This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL & SQLite - Your Pirate Adventure with Shady Deals & Rum!
Welcome To This Adventure
Hello & Welcome to the SQL Pirate Adventure! (2:01)
Introduction to A New Isle (1:51)
Sailing to SQIsLand (1:57)
Your Motivation Behind
Why Learn SQL? (4:17)
Database (15:52)
Get to Know The Tools You Are Working With
SQLite (2:19)
Install SQLite Studio & Overview (9:38)
Destination: OL'Tables - The Harbour City of SQisLand
Arriving at OL'Tables (12:11)
OL'Tables QuizTime 4 (0:19)
OL'Tables Expressions with SELECT Command (3:18)
OL'Tables Expressions 2 with SELECT Command (2:41)
OL'Tables Expressions 3 with SELECT Command (2:56)
OL'Tables Concatenation with SELECT Command (3:56)
Leaving OL'Tables - Summary (1:41)
Destination: Fort Encargo - The Jail Of SQisLand
Arriving at Fort Encargo - Data Types (5:12)
Fort Encargo Command WHERE - Intro & Using with Numbers (4:46)
Fort Encargo Command WHERE - Using with Numbers Part 2 (4:41)
Fort Encargo Combine Queries with AND (3:45)
Fort Encargo Query Conditions with OR (3:44)
Fort Encargo Defining Lists for Matching with IN (3:31)
Fort Encargo Command WHERE - Using on Text (3:48)
Fort Encargo Command WHERE - Using on Text Part 2 (3:11)
Fort Encargo Fuzzy Filter (2:53)
Fort Encargo Fuzzy Filter Part 2 (4:21)
Fort Encargo Quiz Time (0:10)
Fort Encargo Command WHERE - Using on Boolean (2:55)
Fort Encargo Handling The Data Type of NULL (2:09)
Fort Encargo Grouping Conditions (5:45)
Fort Encargo Grouping Conditions Part 2 (2:19)
Leaving Fort Encargo - Summary (1:20)
Destination: Cloister Consilio - The Rum Hideout
Arriving At Cloister Consilio (2:12)
Cloister Consilio Aggregate Results with GROUP BY (6:50)
Cloister Consilio Aggregate Results with GROUP BY Part 2 (2:10)
Cloister Consilio Sort Results with ORDER BY (3:46)
Cloister Consilio Sort Results with ORDER BY Part 2 & Assignment (0:29)
Cloister Consilio Filter Results of WHERE with HAVING & Assignment (5:14)
Cloister Consilio Display Only Unique Entries with DISTINCT (1:41)
Cloister Consilio Display Only Unique Entries with DISTINCT Part 2 & Quiz (0:15)
Cloister Consilio Intermediate Summary (0:44)
Cloister Consilio Textual Representations with CASE (5:49)
Cloister Consilio Textual Representations with CASE Part 2 (1:30)
Cloister Consilio Textual Representations with CASE Part 3 (1:32)
Cloister Consilio Crew Mood Assignment (0:15)
Cloister Consilio Combine Tables with JOIN (11:42)
Cloister Consilio Combine Tables with JOIN Part 2 (4:58)
Cloister Consilio Combine Tables with JOIN Part 3 (2:15)
Cloister Consilio Merge Tables And Results with UNION (7:59)
Cloister Consilio Assignment - The XXX Files (0:18)
Leaving Cloister Consilio - Summary (1:17)
Destination: Fuente El Vamos - The Oasis of Inspiration and Entrepreneurship
Arriving At Fuente El Vamos Intro & Assignment Rum Business - Sugar Plantation (8:41)
Fuente El Vamos Summary & Create Tables with CREATE (6:08)
Fuente El Vamos Create Tables with CREATE Part 2 (3:22)
Fuente El Vamos Add Data with INSERT (3:32)
Fuente El Vamos Add Entries with INSERT Part 2 (6:50)
Fuente El Vamos Remove Entries with DELETE (2:23)
Fuente El Vamos Update Entries with UPDATE (3:03)
Fuente El Vamos Quiz Time (0:10)
Fuente El Vamos Create Query Shortcuts with SQL Views (7:17)
Leaving Fuente El Vamos & Quiz Time (0:54)
Destination: Puerte De Graduacion - The Lift Off Harbor
Arriving At Puerto de Graduacion & Assignment (1:43)
How to Go On & Thank You For Having Me as Your Instructor (1:46)
Fort Encargo Command WHERE - Intro & Using with Numbers
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock