SPECIAL OFFER

Save up to 50% on all books & eBooks with code MOREPRESS

Home > Topics > Programming > SQL Server

Microsoft SQL Server 2012 Step by Step

Register your book to access additional benefits.

Microsoft SQL Server 2012 Step by Step

Book

  • List price: $49.99

Add to cart

Free shipping

This eBook includes the following formats, accessible from your Account page after purchase:

EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

PDF The popular standard, which reproduces the look and layout of the printed page.

This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

eBook

  • List price: $39.99

Add to cart

About eBook formats

This eBook includes the following formats, accessible from your Account page after purchase:

EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

PDF The popular standard, which reproduces the look and layout of the printed page.

This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Book + eBook

  • Your price: $53.99
  • List price: $89.98

Add to cart

About eBook formats

This eBook includes the following formats, accessible from your Account page after purchase:

EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

PDF The popular standard, which reproduces the look and layout of the printed page.

This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Free shipping

This eBook includes the following formats, accessible from your Account page after purchase:

EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

PDF The popular standard, which reproduces the look and layout of the printed page.

This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

WISH LIST
  • Published 2/15/2013
  • 1st Edition
  • 432 pages
  • Book 978-0-7356-6386-2
  • eBook 978-0-7356-6390-9

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

Online Sample Chapters

Creating Your First Table in Microsoft SQL Server

Overview of Microsoft SQL Server 2012

Sample Pages

Download the sample content

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

Downloads

Please download the files associated with Microsoft® SQL Server® 2012 Step by Step here.

Errata

We've made every effort to ensure the accuracy of this book and its companion content. Any errors that have been confirmed since this book was published can be downloaded below.

Download the errata

If you find an error, you can report it to us through our Submit errata page.

Other titles you might like