Creating Database, Use Database and Create Table

Column Subtleties: Null, Primary Key and Auto-Increment

An Example – Sales Data

Insert Table – Examples

More Insert Table Examples

Referential Integrity Introduced

Creating a Database and Using It

An Involved Bulk Loading Example

Aggregation Operators Introduced

The Group By Clause

More Group By Examples

Order By

Having

Limit

Count and Count Distinct

Introduction To SQL Joins Preview

Cross Joins aka Cartesian Joins

Inner Joins

Left Outer Joins

Right, Full Outer Joins, Natural Joins, Self Joins

Subqueries Introduced

Union, Union All, Intersect and Except

Query-In-A-Query

Inserting Via Subqueries

Use A Subquery To Populate A Table

Outer Join And Inner Join: A Little Test

Not NULL constraints

Primary Keys

Foreign Key Constraints

Deletes and Updates With Foreign Key Constraints

Check Constraints

Indices

Stored Procedures

Triggers

Transactions

Handle with Care: Update and Delete

Handle with Care: Alter and Drop

Views, Temporary Tables, and User Priviliges

Practical Tips for Table Designs that you won’t regret!

More Practical Design Tips

Normal Forms – Friends Once You Know Them

Interfacing with Databases from Python

SQLite works right out of the box

Build a database of Stock Movements – I

Build a database of Stock Movements – II

Build a database of Stock Movements – III

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