Course description

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-... ???? 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 Data Analyst: https://zerotomastery.io/career-paths... ========= ???? Crash Course Files: https://links.zerotomastery.io/sql-cr... ???? SQL Cheat Sheet: https://zerotomastery.io/cheatsheets/... ???? 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

What will i learn?