Indexing strategies Query optimization Execution plans Performance monitoring

Primary key constraints Foreign key constraints CHECK constraints UNIQUE constraints DEFAULT values

Normalization (1NF, 2NF, 3NF) Denormalization considerations Schema design best practices Documentation standards

Advanced function demonstrations Window function workshop Performance optimization tips Project presentations

CASE statements Pivoting data Dynamic SQL basics Common Table Expressions (CTEs)

RANK and ROW_NUMBER PARTITION BY Moving averages Running totals

String functions Date/time functions Mathematical functions Conversion functions

Join operations workshop Subquery optimization techniques Real-world scenarios practice Project review