Database
This chapter answers:
- What is a database?
- What are typical examples of using a database?
- What is a relational database?
- What are separated tables?
- How do I choose a suitable database solution?
- What is the difference between SQLite and SQL?
Welcome To This Adventure
Your Motivation Behind
Get to Know The Tools You Are Working With
Destination: OL'Tables - The Harbour City of SQisLand
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