From 0 To 1:SQL And Databases – Heavy Lifting

Course Curriculum

Chapter 1: Introduction To Databases

Lecture 1: Data Is A Big Deal

Lecture 2: Why Do We Need A Database?

Lecture 3: MySQL – Installed and Introduced (Mac OS X)

Lecture 4: Setting up MySQL and the Workbench (Mac OS X)

Lecture 5: MySQL Server and Workbench installed (Windows)

Lecture 6: Entities And Attributes – Things And Stuff Which Describe Them

Lecture 7: Identifying Entities Using Keys

Lecture 8: The Entity Relationship (E-R) Model – Entities And Attributes

Lecture 9: Relationships – What Connects Entities

Lecture 10: Cardinality Of Relationships

Lecture 11: The Entity Relationship (E-R) Model – Relationships

Lecture 12: Mapping E-R Theory to the world of databases

Chapter 2: Going From Relations To Database Tables

Lecture 1: Introducing The SELECT Statement

Lecture 2: Introducing The SELECT Statement

Lecture 3: Quotes and NULLS – Avoid The Gotchas

Lecture 4: Simple Examples

Lecture 5: More Simple Examples

Lecture 6: Using the Like Operator

Lecture 7: Between, In and Not In

Lecture 8: A Multi-Column Select

Lecture 9: Working with Dates (MySQL As Example)

Chapter 3: Creating Tables And Inserting Data Into Them

Lecture 1: Creating Database, Use Database and Create Table

Lecture 2: Column Subtleties: Null, Primary Key and Auto-Increment

Lecture 3: An Example – Sales Data

Lecture 4: Insert Table – Examples

Lecture 5: More Insert Table Examples

Lecture 6: Referential Integrity Introduced

Lecture 7: Creating a Database and Using It

Lecture 8: An Involved Bulk Loading Example

Chapter 4: Back To Retrieving Data – More Advanced Queries Using Group By

Lecture 1: Aggregation Operators Introduced

Lecture 2: The Group By Clause

Lecture 3: More Group By Examples

Lecture 4: Order By

Lecture 5: Having

Lecture 6: Limit

Lecture 7: Count and Count Distinct

Chapter 5: Joins – Don't Let Them Intimidate You! They're All Fuzzy And Nice

Lecture 1: Introduction To SQL Joins

Lecture 2: Cross Joins aka Cartesian Joins

Lecture 3: Inner Joins

Lecture 4: Left Outer Joins

Lecture 5: Right, Full Outer Joins, Natural Joins, Self Joins

Chapter 6: Subqueries: Layering The Cake

Lecture 1: Subqueries Introduced

Lecture 2: Union, Union All, Intersect and Except.

Lecture 3: Query-In-A-Query

Lecture 4: Inserting Via Subqueries

Lecture 5: Use A Subquery To Populate A Table

Lecture 6: Outer Join And Inner Join: A Little Test

Chapter 7: Constraints

Lecture 1: Not NULL constraints

Lecture 2: Primary Keys

Lecture 3: Foreign Key Constraints

Lecture 4: Deletes and Updates With Foreign Key Constraints

Lecture 5: Check Constraints

Chapter 8: Somewhat More Advanced Concepts

Lecture 1: Indices

Lecture 2: Stored Procedures

Lecture 3: Triggers

Lecture 4: Transactions

Lecture 5: Handle with Care: Update and Delete

Lecture 6: Handle with Care: Alter and Drop

Lecture 7: Views, Temporary Tables, and User Priviliges

Chapter 9: Table Design: Theory And Practice

Lecture 1: Practical Tips for Table Designs that you won't regret!

Lecture 2: More Practical Design Tips

Lecture 3: Normal Forms – Friends Once You Know Them

Chapter 10: Putting It Together: Database Programming In Python

Lecture 1: Interfacing with Databases from Python

Lecture 2: SQLite works right out of the box

Lecture 3: Build a database of Stock Movements – I

Lecture 4: Build a database of Stock Movements – II

Lecture 5: Build a database of Stock Movements – III

Chapter 11: Appendix

Lecture 1: [For Linux/Mac OS Shell Newbies] Path and other Environment Variables