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

[@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

[@nguyen8461]

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.

[@nyashachiroro2531]

These course are always super detailed. I like that

[@hawarhekmat1174]

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

[@bahaaismail9003]

the best crash course ever watched

[@akinpelumi717]

Thank you for such a detailed crash course.

[@mrashad_com]

Thank you, it is a very good start for DB

[@sadev0]

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

[@DanielKeshavarznezhad]

Thanks for great course

[@besmartforhim1245]

Awesome! Very informative!!

[@infohub3709]

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

[@kaleemshabir3154]

Legend always appears with a crash course that is great enouph

[@codewithmarc3569]

It's very interesting!

[@BoolFalse]

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

[@Thilina4321]

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

[@academind]

Sorry, we released a lot of courses in the last months - no concrete plans as of now :)

[@leheisenberge]

nice! a Sri lankan

[@soumyasrm]

Can you please share timestamp of this course

[@academind]

Just added, thanks for the hint.

[@jimshtepa5423]

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)?

[@ContemporaryW]

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

[@ridl27]

code pls! and ty!

[@vikrantthanki3379]

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

[@sondoshashem1563]

Lol I’m here because of chatgpt too

[@suryateja2524]

What about ionic framework in 2022??

[@josephwong2832]

nice

[@NarutoUzumaki-ye1ks]

.

[@ЗулфияТатанбекова-ц6п]

южю