Register your product to gain access to bonus material or receive a coupon.
Microsoft SQL Server 2012 Step by Step
- By Patrick LeBlanc
- Published Feb 15, 2013 by Microsoft Press. Part of the Step by Step Developer series.
eBook
- Sorry, this book is no longer in print.
- Includes EPUB and PDF
- 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.
PDF
The popular standard, used most often with the free Acrobat® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Description
- Copyright 2013
- Dimensions: 7-3/8" x 9"
- Pages: 480
- Edition: 1st
- eBook
- ISBN-10: 0-7356-6390-4
- ISBN-13: 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
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
More Information
Other Things You Might Like
- Online Video $199.99