Part I: Getting started with Microsoft SQL Server 2012
Chapter 1. Overview of Microsoft SQL Server 2012
Chapter 2. Installing, Configuring, and Upgrading Microsoft SQL Server 2012
Chapter 3. Using SQL Server 2012 administration and development tools

Part II: Designing databases
Chapter 4. Designing SQL Server databases
Chapter 5. Creating your first table
Chapter 6. Building and maintaining indexes

Part III: Advanced database design topics
Chapter 7. Table compression
Chapter 8. Table partitioning
Chapter 9. Database snapshots
Chapter 10. The SELECT statement

Part IV: Using Transact-SQL (T-SQL)
Chapter 11. Advanced data retrieval topics
Chapter 12. Modifying data
Chapter 13. Built-in scalar functions

Part V: Creating other database objects
Chapter 14. Advanced T-SQL topics
Chapter 15. Views
Chapter 16. User-defined functions
Chapter 17. Stored procedures
Chapter 18. Data manipulation triggers

Part VI: SQL Server replication
Chapter 19. Replication

Part VII: Database maintenance
Chapter 20. Backups
Chapter 21. Managing and maintaining indexes and statistics
Chapter 22. Maintenance plans

Part VIII: Database management
Chapter 23. SQL Server Profiler
Chapter 24. Extended Events
Chapter 25. SQL Server security
Chapter 26. Resource Governor
Chapter 27. SQL Server Agent
Chapter 28. Database Mail
Chapter 29. Data definition triggers
Chapter 30. Dynamic management objects

Part IX: High-availability solutions
Chapter 31. AlwaysOn
Chapter 32. Log shipping