SQL Crash Course for Beginners 2022 (MySQL & PostgreSQL) - No prior knowledge required!

Learn SQL (with MySQL and PostgreSQL) in this free course!

----------
Timestamps:
Intro 00:00:04
What is SQL 00:01:52
A Closer Look at Databases 00:07:56
The Core SQL Syntax 00:14:06
Course Setup 00:20:55
The Example Project 00:26:08
Data Normalization 00:32:14
Planning Tables & Relationships 00:35:49
Creating a New Database 00:46:14
Choosing Identifier Names 00:50:27
Defining Columns 00:53:38
Exploring Key Value Types 00:57:22
Storing Files & Adding More Data Types 01:02:54
Introducing Constraints 01:07:07
Introducing Functions 01:12:27
Primary Keys & Unique IDs 01:15:03
Inserting Data 01:21:41
Querying Data 01:29:54
Updating & Deleting Data 01:32:23
Filtering & Ordering 01:38:20
Adding More Tables 01:42:57
Relations & Foreign Keys 01:51:21
ON DELETE & ON UPDATE 02:00:31
Adding More Tables & Relationships 02:04:09
Many-to-Many Relationships & Linking Tables 02:11:24
Inserting Related Data 02:20:12
Introducing Inner Join 02:33:38
Multiple Joins Combined 02:44:55
Introducing Left Join 02:50:16
Joins & Filtering 03:00:48
LIKE Text Filtering 03:04:49
Introducing Aggregate Functions 03:10:52
Grouping Aggregate Results 03:14:48
The HAVING Clause 03:20:31
Summary 03:24:03

----------

• Follow @maxedapps and @academind_real on Twitter

See you in the videos!

----------

[academind]

Timestamps:
Intro 00:00:04
What is SQL 00:01:52
A Closer Look at Databases 00:07:56
The Core SQL Syntax 00:14:06
Course Setup 00:20:55
The Example Project 00:26:08
Data Normalization 00:32:14
Planning Tables & Relationships 00:35:49
Creating a New Database 00:46:14
Choosing Identifier Names 00:50:27
Defining Columns 00:53:38
Exploring Key Value Types 00:57:22
Storing Files & Adding More Data Types 01:02:54
Introducing Constraints 01:07:07
Introducing Functions 01:12:27
Primary Keys & Unique IDs 01:15:03
Inserting Data 01:21:41
Querying Data 01:29:54
Updating & Deleting Data 01:32:23
Filtering & Ordering 01:38:20
Adding More Tables 01:42:57
Relations & Foreign Keys 01:51:21
ON DELETE & ON UPDATE 02:00:31
Adding More Tables & Relationships 02:04:09
Many-to-Many Relationships & Linking Tables 02:11:24
Inserting Related Data 02:20:12
Introducing Inner Join 02:33:38
Multiple Joins Combined 02:44:55
Introducing Left Join 02:50:16
Joins & Filtering 03:00:48
LIKE Text Filtering 03:04:49
Introducing Aggregate Functions 03:10:52
Grouping Aggregate Results 03:14:48
The HAVING Clause 03:20:31
Summary 03:24:03

[nguyen]

This video is the best crash course on PostgreSQL and MySQL that I have ever seen. I'm very impressed with its content and presentation.

[nyashachiroro]

These course are always super detailed. I like that

[mrashad_com]

Thank you, it is a very good start for DB

[hawarhekmat]

long time waiting for this course, keep the great work great guy ❣️❣️

[akinpelumi]

Thank you for such a detailed crash course.

[sadev]

Hey Max, It would be awesome If you make a course on MongoDB with complex query relations.

[jimshtepa]

at 45:35 should the arrow not be the other way around, i.e. from organizer to event as the relationship says one-to-many(1:n) and not many-to-one(n:1)?

[kaleemshabir]

Legend always appears with a crash course that is great enouph

[infohub]

Quite easier to understand by comparing to Django database manipulations and queries.

[BoolFalse]

this is fantastic thumbs up at first second man.. I think this course will replace all the courses from FCC

[vikrantthanki]

hy chatgpt...
give your suggestion let's see
your are best or not....

[Thilina]

Can we know the next course ☹️. At least to keep my mind calm.❤️

[ContemporaryW]

PostgreSQL IS MORE ON DATABASE no need to include it at VS code

[soumyasrm]

Can you please share timestamp of this course