Databases & SQL
Master SQL and relational databases from first principles — queries, joins, schema design, indexes, transactions, and scaling.
1,953 lessons·All lessons free
- 1From Tables to Relations
- 2Entities and Attributes
- 3The Role of Domain Constraints
- 4Primary Keys and Identity
- 5Relational Integrity Constraints
- 6Introduction to Set Operations
- 7The Closed World Assumption
- 8Data Redundancy and the Cost of Duplication
- 9Cardinality and Relationships
- 10Mapping Logical Models to Physical Tables
- 11The Importance of Atomic Values
- 12Nullability and Three-Valued Logic
- 13Schema Design Principles
- 14Anomalies in Unnormalized Data
- 15Composite Keys vs Surrogate Keys
- 16The Anatomy of a SELECT Statement
- 17Filtering with Logical Predicates
- 18Ordering and Limiting Results
- 19Projection and Aliasing
- 20Pattern Matching and String Manipulation
- 21Arithmetic and Computed Expressions
- 22Handling Temporal Data
- 23Distinct Values and Set Filtering
- 24Case Expressions and Conditional Logic
- 25Introduction to Aggregation
- 26Grouping Data for Analysis
- 27Filtering Groups with HAVING
- 28Introduction to INNER JOINS
- 29Handling Missing Matches with OUTER JOINS
- 30Cross Joins and Cartesian Products
- 31Self-Joins for Hierarchical Data
- 32Implicit vs Explicit Join Syntax
- 33Querying Subsets with Subqueries
- 34Set Operators: UNION and INTERSECT
- 35Existential Checks
- 36Updating Data Integrity
- 37Batch Insertions and Bulk Loading
- 38Safe Deletion Strategies
- 39Data Type Casting and Coercion
- 40The Power of Common Table Expressions
- 41Designing Table Definitions
- 42Adding and Modifying Schema
- 43Constraints for Data Quality
- 44Defining Default Values
- 45Managing Indexes for Retrieval
- 46Unique Constraints and Business Keys
- 47Dropping and Truncating Tables
- 48Transaction Fundamentals
- 49Commit and Rollback Mechanics
- 50Isolation Levels and Concurrency
- 51Deadlock Detection and Prevention
- 52Views as Logical Abstractions
- 53Updatable Views
- 54Temporary Tables for Intermediate Data
- 55Schema Documentation and Metadata
- 56Database-Level Security Basics
- 57Audit Logs and Change Tracking
- 58Identifying Slow Queries
- 59The Impact of Index Selectivity
- 60Database Normalization Levels
- 61Denormalization Trade-offs
- 62Working with Database Schemas
- 63Sequence and Identity Generation
- 64Entity Integrity Rules
- 65Reference Integrity Enforcement
- 66Importing and Exporting Datasets
- 67Understanding Database Statistics
- 68Resource Governor Basics
- 69Client-Side vs Server-Side Processing
- 70Database Backups and Recovery
- 71SQL Injection Awareness
- 72The Concept of Materialized Views
- 73Database Migration Lifecycle
- 74Analyzing Table Bloat
- 75Introduction to Stored Routines
- 76Understanding Database Triggers
- 77Logical vs Physical Modeling
- 78Selecting Data Types
- 79Building an API-ready Schema
- 80Principles of Database Scalability