SQL: Using Information Schema to query table metadata

Relational Database Concepts: Primary Keys and Entity Integrity

Relational Database Concepts: Natural Keys, Candidate Keys, Surrogate Keys, Secondary Keys

Relational Database Concepts: Data Domain: Physical and Logical

Relational Database Concepts: Foreign Keys and Referential Integrity

Learn Databases Walkthrough

SQL: DDL and DML Part 1 of 4: CREATE TABLE, Primary Keys and INSERT

SQL: DDL and DML Part 2 of 4: ALTER TABLE, and CONSTRAINTs: Check, Unique, and Foreign Key

SQL: DDL and DML Part 3 of 4: INSERT, UPDATE, SELECT and DELETE

SQL: DDL and DML Part 4 of 4: INFORMATION SCHEMA

Master the SQL SELECT statement part 01: Column Projections

Master the SQL SELECT statement part 02: WHERE clause

Master the SQL SELECT statement part 03: CASE