You are NOT signed in as a student! Your progress will not be saved and you won't see milestones on your ZTM Passport.
Make sure you are logged into
Academy
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Complete SQL + Databases Bootcamp: Zero to Mastery
Introduction
Complete SQL + Databases Bootcamp: Zero to Mastery (3:26)
Course Outline (7:51)
Exercise: Meet Your Classmates and Instructor
The Big Data Breach At Keiko Corp (2:23)
ZTM Plugin + Understanding Your Video Player
Set Your Learning Streak Goal
History And Story Of Data
What Is a Database? (5:57)
I Didn't Learn Anything, Try Again... (6:35)
Database Management System (DBMS) (7:44)
Exercise: Building Amazon (5:34)
Exercise: Building Amazon 2 (5:28)
5 Types Of Databases (5:37)
Exercise: What Is A Database? (1:11)
Section Review (1:29)
Let's Have Some Fun (+ Free Resources)
Databases + SQL Fundamentals
SQL Playground (1:54)
What Is SQL? (2:17)
What Is A Query? (6:27)
Exercise: Setting Up Your First Database
Imperative vs Declarative (3:24)
History of SQL (2:21)
Exercises: The Select Statement
Optional: History of SQL Deep Dive
SQL Standards (4:25)
What Is A Database? Revisited (5:36)
Database Oriented Approach (6:51)
Exercise: SQL Starter Quiz
Database Models (1:21)
Hierarchical And Networking Model (8:03)
Relational Model (7:17)
DBMS Revisited (13:57)
Relational Model Revisited (1:07)
Tables (3:45)
Columns (4:08)
Rows (2:27)
Primary And Foreign Keys (5:03)
OLTP vs OLAP (3:17)
Exercise: OLTP vs OLAP (3:20)
Exercise: Relational Model Quiz
Endorsements On LinkedIn
Unlimited Updates
Environment Setup
Why PostgreSQL (1:52)
Environment Tooling (3:10)
Having Trouble Registering A Serial Key For ValentinaDB?
SQL Tooling Alternatives
Command Line 101 (5:21)
Getting Help With The Setup
WINDOWS Setup (4:53)
Optional: Setting Up Windows For Command Line (4:27)
MAC Setup (6:30)
MAC Commandline Tools
LINUX Setup (5:36)
Importing The Databases (6:03)
Course Check-In
SQL Deep Dive
Query Along
Starting With Query (5:14)
Exercise: Simple Queries (10:10)
Changing Column Names in a SELECT Query (3:19)
Concat Function (4:51)
What Is A Function In SQL? (6:46)
Aggregate Functions (5:19)
Exercise: Aggregate Functions
Commenting Your Queries (9:32)
Common SELECT Mistakes (8:27)
Filtering Data (5:44)
AND and OR (14:15)
Exercise: Filtering Data (7:56)
The NOT Keyword (7:18)
Exercise: The Where Clause
Comparison Operators (6:02)
Exercise: Comparison Operators
Logical Operators (7:31)
Operator Precedence (9:38)
Operator Precedence 2 (11:31)
Operator Precedence Extra
Exercise: Operator Precedence
Checking For NULL Values (12:01)
IS Keyword (13:42)
NULL Coalescing (7:12)
Exercise: Null Value Coalescing
3 Valued Logic (12:24)
Exercise: 3 Valued Logic
BETWEEN + AND (2:06)
Exercise: BETWEEN + AND
IN Keyword (3:24)
Exercise: IN Keyword
LIKE (13:18)
Exercise: Like Keyword
Dates And Timezones (12:53)
Setting Up Timezones (3:37)
How Do We Format Date And Time? (6:15)
Timestamps (10:27)
Date Functions (4:52)
Date Difference And Casting (1:47)
Age Calculation (2:09)
Extracting Information (2:51)
Intervals (3:13)
Exercise: Date and Timestamp
DISTINCT (4:11)
Exercise: Distinct Keyword
Sorting Data (6:17)
Exercise Sorting Data
Multi Table SELECT (10:47)
Inner Join (19:42)
Self Join (4:54)
Outer Join (11:30)
Less Common Joins (6:36)
Exercise: Inner-Join
USING Keyword (4:29)
Implement a New Life System
Advanced SQL
GROUP BY (14:43)
Group By Exercises
HAVING Keyword (7:38)
Having Exercises
Ordering Grouped Data (1:44)
Group By Mental Model (12:10)
Grouping Sets (9:29)
Rollup (7:17)
Window What? (3:30)
Looking Through The Window (8:52)
PARTITION BY (5:50)
Order By Acting Strange (5:34)
Using Framing In Window Function (14:12)
Solving For Current Salary (10:49)
FIRST_VALUE (5:48)
LAST_VALUE (4:03)
SUM (5:32)
ROW_NUMBER (3:03)
Window Function Exercises
Conditional Statements (6:14)
Conditional Statement Exercise
NULLIF (2:25)
NULLIF Exercise
Views...What Are They Good For? (3:41)
View Syntax (5:36)
Using Views (12:24)
Views Exercises
Indexes (11:09)
Index Types (10:28)
Index Algorithms (10:28)
Quick Note: Index Algorithms
What Are Subqueries? (8:18)
Subqueries vs Joins (8:47)
Subquery Guidelines As Types (11:17)
Using Subqueries (11:26)
Quick Note: Titles For Employees
Getting The Latest Salaries (14:19)
Subquery Operators (9:00)
Subquery Exercises
Exercise: Imposter Syndrome (2:55)
Database Management
Before We Get Started
Time To Create Some Stuff! (9:56)
Types Of Databases In A RDBMS (4:18)
Default PostgreSQL Database (7:38)
Template Databases (6:41)
Creating A Database (4:42)
Database Organization (7:08)
Roles In Postgres (3:45)
Role Attributes And Creation (4:52)
Creating Users And Configuring Login (13:44)
Privileges (3:51)
Granting Privileges and Role Management (6:23)
Best Practices For Role Management (4:22)
Data Types & Boolean Type (7:36)
Storing Text (5:19)
Storing Numbers (7:16)
Storing Arrays (4:20)
Data Models And Naming Conventions (10:55)
CREATE TABLE (8:56)
Extra information on CREATE TABLE
Column Constraints (5:49)
Table Constraints (11:42)
Regexes!
UUID Explained (5:47)
Custom Data Types And Domains (6:07)
Creating The Tables For ZTM (11:52)
Extra information on ALTER TABLE
Adding Students And Teachers (8:07)
Creating A Course (12:31)
Adding Feedback To A Course (6:49)
A Tale Of 2 Feedbacks (9:03)
SQL Exercises
SQL Quiz
Backups And Why They Are Important (23:19)
Backing Up In Postgres (7:42)
Restoring A Database (6:15)
Transactions (18:15)
Solving The Mystery
Clue #1 and #2 (1:45)
Getting ready to solve the mystery!
Clue #3 (0:47)
Exercise: Solving The First Clues
Solution: Solving The First Clues (5:25)
Clue #4 (0:27)
Exercise: Clue #4
Solution: Clue #4 (1:02)
Clue #5 and #6 (1:13)
Exercise: Clue #5 and #6
Solution: Clue #5 and #6 (5:46)
Solving The Mystery (2:52)
Database Design
System Design And SDLC (9:49)
SDLC Phases (6:00)
System Design Deep Dive (5:57)
Top-Down vs Bottom-Up (6:28)
DRIVEME Academy (6:41)
Top Down Design (4:41)
ER Model (5:10)
Step 1: Determining Entities (3:34)
Tooling For Diagramming (3:28)
DRIVEME Academy Entities (13:54)
Step 2: Attributes (3:04)
Relational Model Extended (1:09)
Relational Schema And Instance (2:37)
Super Key and Candidate Key (6:22)
Primary Key and Foreign Key (7:33)
Compound Composite And Surrogate Key (4:07)
DRIVEME Attributes (11:56)
Step 3: Relationships (12:05)
DRIVEME Relationships (12:29)
Step 4: Solving Many To Many (9:27)
Step 5: Subject Areas (2:44)
DRIVEME Subject Areas (2:55)
Exercise: Painting Reservations (9:17)
Exercise: Movie Theatre (5:06)
Bottom Up Design (5:17)
Anomalies (10:29)
Normalization (7:14)
Functional Dependencies (6:35)
Functional Dependencies 2 (6:11)
The Normal Forms (4:32)
Going from 0NF to 1NF (8:09)
Going from 1NF to 2NF (5:47)
Going from 2NF to 3NF (8:30)
Boyce-Codd Normal Form (9:01)
Why 4NF And 5NF Are Not Useful (5:57)
Exercise: Database Design Quiz
Database Landscape, Performance and Security
Bruno's Request (1:36)
Scalability (4:19)
Sharding (3:04)
Replication (4:56)
Backups (2:15)
Distributed vs Centralized Databases (3:41)
Database Security (4:02)
Exercise: SQL Injection
Optional: All About Injections Attacks (19:42)
Optional: Storing Passwords (10:54)
Optional: How To Store Passwords
Relational vs NoSQL, PostgreSQL vs MongoDB Databases (10:35)
Future Of Relational Databases (1:47)
Elasticsearch (3:48)
S3 Object Storage (1:48)
Top Databases To Use (4:42)
Where To Go From Here?
Thank You (1:14)
Review This Course!
Become An Alumni
Learning Guideline
ZTM Events Every Month
LinkedIn Endorsements
Bonus: Data Engineering (And the role of Machine Learning)
Watch Data Engineering Section
Bonus: Redis
Watch Redis Section
Extra Bits: Databases In A Web App (with Node.js)
Quick Note: Upcoming Videos
Setting Up Your Database (8:51)
Connecting To The Database (7:06)
Registering A User Part 1 (4:50)
Why 4NF And 5NF Are Not Useful
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures