SQL 101 Crash Course: Master SQL Fundamentals in Just 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 👇

🔥 Full SQL + Databases Bootcamp: https://zerotomastery.io/courses/sql-bootcamp/
🤑 Use code: YTSQL10 to get 10% OFF (for life!)

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

Become a Backend Developer: https://zerotomastery.io/career-paths/become-a-backend-developer/

Become a Data Analyst: https://zerotomastery.io/career-paths/become-a-data-analyst/

=========

📈 Course Data Files: https://drive.google.com/drive/folders/188cgYPnTslNE62N6wePlP1uj50r6icuL?usp=sharing
🗂 Course Exercise Files: https://links.zerotomastery.io/sql-crash-course-files
👍 Subscribe for more free tutorials and exclusive content: https://links.zerotomastery.io/youtube

=========

⏰ 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.

🎓 Here are just a few of them: https://zerotomastery.io/testimonials

This could be you 👆

=========

Become a SQL & Database Pro 👉 https://zerotomastery.io/courses/sql-bootcamp/

#zerotomastery #sql