Microsoft SQL Server 2012 Step by Step

Microsoft SQL Server 2012 Step by Step

3.83 (24 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 3 business days
When will my order arrive?


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
show more

Product details

  • Paperback | 432 pages
  • 186 x 228 x 30mm | 779.99g
  • Microsoft Press,U.S.
  • Redmond, United States
  • English
  • 1st ed.
  • 0735663866
  • 9780735663862
  • 446,188

About Patrick LeBlanc

Patrick LeBlanc is a Data Platform Technical Solution Professional at Microsoft, working directly with customers on the business value of SQL Server. He co-authored SharePoint 2010 Business Intelligence 24-Hour Trainer and Knight's Microsoft Business Intelligence 24-Hour Trainer, and founded, a website devoted to teaching SQL Server technologies.
show more

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
show more

Rating details

24 ratings
3.83 out of 5 stars
5 25% (6)
4 38% (9)
3 33% (8)
2 4% (1)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X