Microsoft SQL Server 2012 Step by Step

Microsoft SQL Server 2012 Step by Step Front Cover
3 Reviews
2013-03-04
432 pages

Book Description

Your hands-on, step-by-step guide to building applications with ® ® 2012

Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building solutions that solve real-world 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

Table of Contents

Part I: 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

Part II: Designing databases
Chapter 4. Designing SQL Server databases
Chapter 5. Creating your first table
Chapter 6. Building and maintaining indexes

Part III: Advanced database topics
Chapter 7. Table compression
Chapter 8. Table partitioning
Chapter 9. Database snapshots
Chapter 10. The SELECT statement

Part IV: Using Transact-SQL (T-SQL)
Chapter 11. Advanced data retrieval topics
Chapter 12. Modifying data
Chapter 13. Built-in scalar functions

Part V: 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

Part VI: SQL Server replication
Chapter 19. Replication

Part VII: Database maintenance
Chapter 20. Backups
Chapter 21. Managing and maintaining indexes and statistics
Chapter 22. Maintenance plans

Part VIII: 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

Part IX: High-availability solutions
Chapter 31. AlwaysOn
Chapter 32. Log shipping

Book Details

  • Title: Microsoft SQL Server 2012 Step by Step
  • Author:
  • Length: 432 pages
  • Edition: 1
  • Language: English
  • Publisher:
  • Publication Date: 2013-03-04
  • ISBN-10: 0735663866
  • ISBN-13: 9780735663862
Download LinkFormatSize (MB)Upload Date
Download from FilePiTrue PDF, EPUB14.106/06/2015
Download from UpLoadedTrue PDF, EPUB14.101/05/2017
Download from ZippyShareTrue PDF, EPUB14.109/22/2016
How to Download? Report Dead Links & Get a Copy