Microsoft SQL Server 2012 Step by Step

Microsoft SQL Server 2012 Step by Step

Paperback Step by Step

By (author) Patrick LeBlanc

USD$35.60
List price $47.70
You save $12.10 25% off

Free delivery worldwide
Available
Dispatched in 2 business days
When will my order arrive?

  • Publisher: Microsoft Press,U.S.
  • Format: Paperback | 432 pages
  • Dimensions: 186mm x 228mm x 30mm | 780g
  • Publication date: 4 March 2013
  • Publication City/Country: Redmond
  • ISBN 10: 0735663866
  • ISBN 13: 9780735663862
  • Sales rank: 290,072

Product 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

Other people who viewed this bought:

Showing items 1 to 10 of 10

Other books in this category

Showing items 1 to 11 of 11
Categories:

Author information

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 www.sqllunch.com, a website devoted to teaching SQL Server technologies.

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