1. Introducing SQL Server 2014
  2. Basics of Database Design
  3. T-SQL Basics
  4. SELECT queries
  5. Action Queries
  6. Locking and Execution Plans
  7. Views, Stored Procedures, and Functions
  8. Advanced Transact-SQL
  9. XML and SQL Server
  10. Triggers
  11. .NET inside of SQL Server
  12. SMO and RMO Programming
  13. Data Protection/Tracking
  14. SQL Server 2014 Analysis Services
  15. SQL Server 2014 Integration Services
  16. SQL Server 2014 Reporting Services
  17. Service Broker
  18. Security and SQL Server
  19. Conclusion