Microsoft SQL Server 2012 Step by Step

Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.

Discover how to:

• Install and work with core components and tools
• Create tables and index structures
• Manipulate and retrieve data
• Secure, manage, back up, and recover databases
• Apply techniques for building high-performing applications
• Use clustering, database mirroring, and log shipping

Table of Contents

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