Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Complete SQL Bootcamp
Course Introduction
Introduction (2:15)
Course Curriculum Overview (1:41)
Overview of Databases (7:37)
Course FAQs
Time to get your Computer Set-Up!
Setup and Installation of PgAdmin and PostgreSQL (14:57)
Installation Notes
PostGreSQL Installation (Mac OS)
Mac OS X - Quick Note
Mac OS Installation (5:56)
Mac Sample Database Download
Mac Database Set-up (10:42)
Review of Set-up
PostGreSQL Installation (Windows)
Windows - Quick Note
Windows Installation (4:07)
Sample Database Download
Windows Command Line Installation Lecture (19:45)
Databases and Tables
Databases and Tables Overview (1:12)
Creating and Restoring a Database (6:21)
Overview of Challenges! (1:36)
Challenge: Restore a Database! (0:42)
Restoring a Table Schema (6:13)
Review of Section
SQL Statement Fundamentals
SQL Cheat Sheet
SQL Statement Fundamentals (0:42)
SELECT Statement (10:48)
Challenge: SELECT task. (2:44)
SELECT DISTINCT (5:46)
Challenge: SELECT DISTINCT (2:05)
SELECT WHERE (14:03)
Challenge: SELECT WHERE (3:45)
COUNT (5:00)
LIMIT (2:59)
ORDER BY (10:05)
Challenge: ORDER BY (3:38)
BETWEEN (8:43)
IN (8:26)
LIKE (10:24)
General Challenge 1 (9:54)
Setup and Installation of PgAdmin and PostgreSQL
Download
Complete and Continue