MySQL Tutorial: Build your own database! Learn Web Development beginners course 2023

We start with absolutely nothing and start by looking at the different tools you can use to work with your databases. Then we go into how you can create, edit and delete whole databases and database tables – and how you can alter them after you made them. We also cover advanced topics such as foreign keys and indexes.
Then we work with data, and after learning to read, write, change and remove data, we work with the most common types of joins: inner join, left join, right join and full outer joins.

Links to videos mentioned in the course:
Install MySQL on Mac: https://www.youtube.com/watch?v=Iw_e0loFezU
Install MySQL on Windows: https://www.youtube.com/watch?v=Iw_e0loFezU
GitHub Tutorial: https://www.youtube.com/watch?v=vSmGLRp-0JQ
RegEx Tutorial: https://www.youtube.com/watch?v=sBtG8uvvb20
Base64 to put files in databases: https://www.youtube.com/watch?v=NDrKaUCrJVo

Links to other complete courses on the channel:
HTML Tutorial: https://www.youtube.com/watch?v=OnFizDPrrVI
CSS Tutorial: https://www.youtube.com/watch?v=epVdyPPlQKo

Tags:
#database #web #sql #mysql #programming #course #tutorial #learn #university #mysql #db #dbdesign #databasedesign #webdevelopment #webdevelopmentfullcourse #webdevelopmenttraining #webdevelopmenttutorial

Chapters:
00:00 Introduction
00:50 Database Management Systems
2:46 Installation
2:58 Database Users & System Users
3:52 Commandline SQL Tool
4:13 HeidiDB & DBeaver Tools
4:50 PHPMyAdmin Tool
5:00 Custom PHP Database Script as Tool
5:40 Create a database for a webshop
7:20 Create a table for users
9:01 Data types
11:51 Constraints
13:53 Indexes
16:05 Primary Keys & Foreign Keys
19:36 Serial
20:22 Building Database Tables
22:30 Relational Tables
23:06 One-To-Many & Many-To-Many
23:42 Editing Tables
24:37 Create Read Update Delete: CRUD
25:11 Insert Data
26:48 Read data
30:38 Create Read Update Delete (CRUD) Data
31:02 Search Database
33:16 Regular Expressions Regex in MySQL
34:06 Fulltext Search
34:56 Complex Search Queries
35:56 Time Search
37:04 Ordering an Limiting Search Results
38:15 Count, Average and Sum of results
39:33 Joins and the Join Syntax
41:06 Inner Join
41:37 Left Join
42:11 Right Join
42:29 Full Outer Join
43:22 Cross Join
43:46 Joining Multiple Tables (Many-to-many)
44:44 Columns with the same name – Use Aliases
47:15 Views
49:00 Data Models – Entity Relationship Diagrams – ER Diagrams
49:42 Migrations
51:55 Outro

source