Autoplay
Autocomplete
Previous Lesson
Complete and Continue
From 0 to 1: Heavy Lifting with SQL & Databases
Introduction To Databases
Data Is A Big Deal (18:22)
Why Do We Need A Database? (19:59)
MySQL - Installed and Introduced (Mac OS X) (7:05)
Setting up MySQL and the Workbench (Mac OS X) (17:32)
MySQL Server and Workbench installed (Windows) (6:31)
Entities And Attributes - Things And Stuff Which Describe Them (15:16)
Identifying Entities Using Keys (13:43)
The Entity Relationship (E-R) Model - Entities And Attributes (5:45)
Relationships - What Connects Entities (5:53)
Cardinality Of Relationships (9:10)
The Entity Relationship (E-R) Model - Relationships (9:52)
Mapping E-R Theory to the world of databases (13:28)
[For Linux/Mac OS Shell Newbies] Path and other Environment Variables (8:25)
Going From Relations To Database Tables
Introducing The SELECT Statement (19:54)
Columns Have Data Types (11:15)
Quotes and NULLS - Avoid The Gotchas (13:54)
Simple Examples (14:51)
More Simple Examples (13:23)
Using the Like Operator (8:11)
Between, In and Not In (18:14)
A Multi-Column Select (10:29)
Working with Dates (MySQL As Example) (11:23)
Creating Tables And Inserting Data Into Them
Creating Database, Use Database and Create Table (14:08)
Column Subtleties: Null, Primary Key and Auto-Increment (14:44)
An Example - Sales Data (12:38)
Insert Table - Examples (19:26)
More Insert Table Examples (9:15)
Referential Integrity Introduced (19:56)
Creating a Database and Using It (17:27)
An Involved Bulk Loading Example (14:16)
Back To Retrieving Data - More Advanced Queries Using Group By
Aggregation Operators Introduced (18:17)
The Group By Clause (17:21)
More Group By Examples (19:48)
Order By (16:17)
Limit (7:14)
Count and Count Distinct (8:22)
Joins - Don't Let Them Intimidate You! They're All Fuzzy And Nice
Introduction To SQL Joins (9:56)
Cross Joins aka Cartesian Joins (17:04)
Inner Joins (19:54)
Left Outer Joins (15:33)
Right, Full Outer Joins, Natural Joins, Self Joins (16:10)
Having (19:54)
Subqueries: Layering The Cake
Subqueries Introduced (7:08)
Union, Union All, Intersect and Except. (19:34)
Query-In-A-Query (13:53)
Inserting Via Subqueries (9:44)
Use A Subquery To Populate A Table (6:51)
Outer Join And Inner Join: A Little Test (9:01)
Constraints
Not NULL constraints (10:09)
Primary Keys (9:43)
Foreign Key Constraints (13:29)
Deletes and Updates With Foreign Key Constraints (12:07)
Check Constraints (1:39)
Somewhat More Advanced Concepts
Indices (16:49)
Stored Procedures (10:28)
Triggers (11:40)
Transactions (13:09)
Handle with Care: Update and Delete (13:28)
Handle with Care: Alter and Drop (12:39)
Views, Temporary Tables, and User Priviliges (5:36)
Table Design: Theory And Practice
Practical Tips for Table Designs that you won't regret! (12:00)
More Practical Design Tips (10:46)
Normal Forms - Friends Once You Know Them (10:30)
Putting It Together: Database Programming In Python
Interfacing with Databases from Python (6:48)
SQLite works right out of the box (6:29)
Build a database of Stock Movements - I (15:03)
Build a database of Stock Movements - II (13:50)
Build a database of Stock Movements - III (13:24)
Right, Full Outer Joins, Natural Joins, Self Joins
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock