Microsoft SQL Server 2012 Step by Step
21%
off

Microsoft SQL Server 2012 Step by Step

By (author)

US$39.04US$49.99

You save US$10.95

Free delivery worldwide

Available
Dispatched from the UK in 2 business days

When will my order arrive?

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

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
  • 421,177

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 www.sqllunch.com, 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