Microsoft SQL Server 2012 Step by Step

Your hands-on, step-by-step guide to building applications with Microsoft SQL Server 2012

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

• 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

If you find an error, you can report it to us through our Submit errata page.