- Copyright 2013
- Dimensions: 7-3/8" x 9"
- Pages: 480
- Edition: 1st
-
eBook
- ISBN-10: 0-7356-6390-4
- ISBN-13: 978-0-7356-6390-9
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
- 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