Book description
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
- Dedication
- Introduction
-
I. Getting started with Microsoft SQL Server 2012
- 1. Overview of Microsoft SQL Server 2012
- 2. Installing, Configuring, and Upgrading Microsoft SQL Server 2012
- 3. Using SQL Server 2012 administration and development tools
-
II. Designing databases
- 4. Designing SQL Server databases
- 5. Creating your first table
- 6. Building and maintaining indexes
-
III. Advanced database design topics
- 7. Table compression
- 8. Table partitioning
- 9. Database snapshots
- 10. The SELECT statement
- IV. Using Transact-SQL (T-SQL)
- V. Creating other database objects
- VI. SQL Server replication
- VII. Database maintenance
-
VIII. Database management
- 23. SQL Server Profiler
- 24. Extended Events
- 25. SQL Server security
- 26. Resource Governor
- 27. SQL Server Agent
- 28. Database Mail
- 29. Data definition triggers
- 30. Dynamic management objects
- IX. High-availability solutions
- Index
- About the Author
- Copyright
Product information
- Title: Microsoft® SQL Server® 2012 Step by Step
- Author(s):
- Release date: February 2013
- Publisher(s): Microsoft Press
- ISBN: 9780735670013
You might also like
book
Microsoft® SQL Server® 2008 Step by Step
Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to …
book
Microsoft® SQL Server® 2012 Integration Services
Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services …
book
Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
Ace your preparation for Microsoft Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press. …
book
Professional Microsoft® SQL Server® 2008 Administration
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, …