SQL 101 Crash Course: Learn SQL Fundamentals (8 HOURS!)

Full SQL 101 Crash Course for Beginners. In this 8-hour course, you'll learn the fundamentals of databases & SQL and even get to practice your new SQL skills with 18+ exercises.

This SQL Crash Course is the first 8 hours of Mo Binni & Andrei Neagoie's 26-hour SQL + Databases Bootcamp Course, which is one of the most in-depth and highly-rated SQL courses online (and perfect for beginners).

So once you finish, come take the rest of Mo & Andrei's SQL + Databases Bootcamp where you'll go even deeper and have the skills to get hired 👇

🤑 Use code: YTSQL10 to get 10% OFF (for life!)

🚀 Career Paths (step-by-step roadmap from beginner to hired):

=========

=========

⏰ Timestamps:

00:00 Introduction
01:49 The Big Data Breach At Keiko Corp
04:22 What Is a Database?
10:28 I Didn't Learn Anything, Try Again...
17:13 Database Management System (DBMS)
25:06 Exercise: Building Amazon
30:50 Exercise: Building Amazon 2
36:27 5 Types Of Databases
42:14 Exercise: What Is A Database?
43:34 Section Review
45:13 SQL Playground
47:16 What Is SQL?
49:43 What Is A Query?
56:36 Exercise: Setting Up Your First Database
56:57 Imperative vs Declarative
1:00:31 History of SQL
1:03:02 Exercise: The Select Statement
1:03:09 SQL Standards
1:07:43 What Is A Database? Revisited
1:13:29 Database Oriented Approach
1:20:30 Exercise: SQL Starter Quiz
1:20:37 Database Models
1:22:07 Hierarchical And Networking Model
1:30:19 Relational Model
1:37:46 DBMS Revisited
1:51:52 Relational Model Revisited
1:53:08 Tables
1:57:02 Columns
2:01:19 Rows
2:03:56 Primary And Foreign Keys
2:09:09 OLTP vs OLAP
2:12:35 Exercise: OLTP vs OLAP
2:16:05 Exercise: Relational Model Quiz
2:16:12 Why PostgreSQL
2:18:14 Environment Tooling
2:21:34 Command Line 101
2:27:05 WINDOWS Setup
2:32:06 Optional: Setting Up Windows For Command Line
2:36:43 MAC Setup
2:43:22 LINUX Setup
2:49:08 Importing The Databases
2:55:21 Starting With Query
3:00:44 Exercise: Simple Queries
3:11:04 Changing Column Names in a SELECT Query
3:14:32 Concat Function
3:19:33 What Is A Function In SQL?
3:26:28 Aggregate Functions
3:31:57 Exercise: Aggregate Functions
3:32:04 Commenting Your Queries
3:41:45 Common SELECT Mistakes
3:50:22 Filtering Data
3:56:15 AND and OR
4:10:39 Exercise: Filtering Data
4:18:45 The NOT Keyword
4:26:13 Exercise: The Where Clause
4:26:20 Comparison Operators
4:32:31 Exercise: Comparison Operators
4:32:38 Logical Operators
4:40:19 Operator Precedence
4:50:07 Operator Precedence 2
5:01:47 Exercise: Operator Precedence
5:01:54 Checking For NULL Values
5:14:05 IS Keyword
5:27:56 NULL Coalescing
5:35:18 Exercise: Null Value Coalescing
5:35:25 3 Valued Logic
5:47:58 Exercise: 3 Valued Logic
5:48:05 BETWEEN + AND
5:50:21 Exercise: BETWEEN + AND
5:50:28 IN Keyword
5:54:01 Exercise: IN Keyword
5:54:08 LIKE
6:07:36 Exercise: Like Keyword
6:07:43 Dates And Timezones
6:20:45 Setting Up Timezones
6:24:31 How Do We Format Date And Time?
6:30:56 Timestamps
6:41:33 Date Functions
6:46:34 Date Difference And Casting
6:48:31 Age Calculation
6:50:49 Extracting Information
6:53:49 Intervals
6:57:12 Exercise: Date and Timestamp
6:57:19 DISTINCT
7:01:39 Exercise: Distinct Keyword
7:01:46 Sorting Data
7:08:13 Exercise: Sorting Data
7:08:20 Multi Table SELECT
7:19:16 Inner Join
7:39:08 Self Join
7:44:11 Outer Join
7:55:51 Less Common Joins
8:02:36 Exercise: Inner Join
8:02:43 USING Keyword
8:07:21 Final Words

=========

💥 Who should take the rest of this SQL + Databases Bootcamp?

◾ Both beginner and advanced professionals looking to learn modern SQL and Database principles
◾ Professionals who are working with or will be working with databases and want to learn to work smart and efficiently using best practices
◾ Anyone interested in learning one of the most in-demand tech skills that will be around for many years to come: SQL
◾ Developers, Data Scientists, Machine Learning Engineers, Business Analysts, Product Managers, Sales/Marketers, and anyone who uses data to make business decisions

=========

Graduates of Zero To Mastery are now working at Google, Tesla, Amazon, Apple, IBM, JP Morgan, Facebook, Shopify + other top tech companies. Many are also working as top-rated Freelancers getting paid $1,000s while working remotely around the world.

This could be you 👆

=========

#zerotomastery #sql

[ZeroToMastery]

We’re constantly updating our courses, so to get the most up-to-date version, check out the full course linked below. 👇


As a thank you for watching on YouTube, use code YTSQL10 for 10% off!

Keep learning and keep building! 🚀

[benbrahimilias]

ERROR: at 4:34:43, the diagram is not correct, it has to be for OR operator and not for AND.
think of it like parallel and series diagrams in the electricity.

[ZeroToMastery]

The Exercise and Data Files are linked down below. (2 separate downloads) 😊

[BOGDES]

Multumesc, Andrei si intregii echipe ! Felicitari pentru munca depusa! 🙏

[leojohn]

Lovely.

Do you have a course for data structures?
Or a practical course for caching frontend and backend?

[yokeshebinesan]

Hey andrie, The source file in the description only has the exercises in doc format. Please put databases.employees, france, world, store.

Thanks in advance

[Ash-foqs]

is this a good resource for fresher SDE interviews ?

[NrBrT]

Could you please replace the link which should point to the database .sql files in the youtube video description? Right now you have a .zip file with .docx files in it. We have no access to the .sql files you refer in the course, so we cannot follow you to practice. Thanks in advance!

[johnsonbubu]

help! I can't find the resource file for the DBs.

[realmfalme]

Did anyone get the DATA SQL files with all the data? Please NOT the exercises. I will appreciate

[onlygod-do]

please put complete javascript course thanks