pt. 1. Laying the foundations
pt. 2. Building databases and working with data
pt. 3. Advanced T-SQL data types and querying techniques
pt. 4. Programming with T-SQL
pt. 5. Enterprise data management
pt. 6. Securing your SQL server
pt. 7. Monitoring and auditing
pt. 8. Performance tuning and optimization
pt. 9. Business intelligence.