Introduction 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 Designing databases Chapter 4: Designing SQL Server databases Chapter 5: Creating your first table Chapter 6: Building and maintaining indexes Advanced database design topics Chapter 7: Table compression Chapter 8: Table partitioning Chapter 9: Database snapshots Chapter 10: The SELECT statement Using Transact-SQL (T-SQL) Chapter 11: Advanced data retrieval topics Chapter 12: Modifying data Chapter 13: Built-in scalar functions 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 SQL Server replication Chapter 19: Replication Database maintenance Chapter 20: Backups Chapter 21: Managing and maintaining indexes and statistics Chapter 22: Maintenance plans 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 High-availability solutions Chapter 31: AlwaysOn Chapter 32: Log shipping About the Author.