Microsoft SQL Server 2012 Step by Step


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 ...

See more details below
$35.28 price
(Save 29%)$49.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (18) from $27.23   
  • New (14) from $29.16   
  • Used (4) from $27.23   
Microsoft SQL Server 2012 Step by Step

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99 price
(Save 42%)$39.99 List Price


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
Read More Show Less

Product Details

  • ISBN-13: 9780735663862
  • Publisher: Microsoft Press
  • Publication date: 3/4/2013
  • Series: Step by Step Developer Series
  • Pages: 432
  • Sales rank: 130,999
  • Product dimensions: 7.30 (w) x 8.90 (h) x 1.10 (d)

Meet the Author

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

Read More Show Less

Table of Contents

Who should read this book;
Who should not read this book;
Organization of this book;
Conventions and features in this book;
System requirements;
Code samples;
Errata & book support;
We want to hear from you;
Stay in touch;
Getting started with Microsoft SQL Server 2012;
Chapter 1: Overview of Microsoft SQL Server 2012;
1.1 Business intelligence;
1.2 Database Engine;
1.3 T-SQL programming interface;
1.4 Security subsystem;
1.5 Replication;
1.6 Summary;
Chapter 2: Installing, Configuring, and Upgrading Microsoft SQL Server 2012;
2.1 Editions of SQL Server 2012;
2.2 Choosing hardware for SQL Server;
2.3 Software prerequisites;
2.4 Before installation;
2.5 Installing SQL Server;
2.6 After installation;
2.7 How to upgrade to SQL Server 2012;
2.8 Summary;
Chapter 3: Using SQL Server 2012 administration and development tools;
3.1 Using SQL Server Books Online;
3.2 Using SQL Server Management Studio;
3.3 Using SQL Server Management Studio to create solutions and projects;
3.4 Using SQL Server Data Tools;
3.5 Using SQL Server Configuration Manager;
3.6 Summary;
Designing databases;
Chapter 4: Designing SQL Server databases;
4.1 Understanding SQL Server system databases;
4.2 Understanding the SQL Server database structure;
4.3 Adding files and filegroups;
4.4 Detaching and attaching SQL Server databases;
4.5 Understanding database recovery models;
4.6 Summary;
Chapter 5: Creating your first table;
5.1 Developing a naming standard;
5.2 Understanding schemas;
5.3 Understanding SQL Server data types;
5.4 Understanding column properties;
5.5 Creating tables;
5.6 Altering tables;
5.7 Understanding computed columns;
5.8 Adding constraints to a table;
5.9 Understanding the FileTable;
5.10 Creating database diagrams;
5.11 Summary;
Chapter 6: Building and maintaining indexes;
6.1 Index structure overview;
6.2 Adding index options;
6.3 Adding included columns;
6.4 Adding filters to indexes;
6.5 Placing indexes;
6.6 Disabling and dropping indexes;
6.7 Summary;
Advanced database design topics;
Chapter 7: Table compression;
7.1 Understanding row compression;
7.2 Understanding page compression;
7.3 Estimating effects of compression;
7.4 Compression considerations;
7.5 Summary;
Chapter 8: Table partitioning;
8.1 Creating a partition function;
8.2 Creating a partition scheme;
8.3 Partitioning tables and indexes;
8.4 Summary;
Chapter 9: Database snapshots;
9.1 Understanding database snapshot prerequisites and limitations;
9.2 Creating and viewing database snapshots;
9.3 Dropping database snapshots;
9.4 Reverting to a database snapshot;
9.5 Summary;
Chapter 10: The SELECT statement;
10.1 Writing a SELECT statement;
10.2 Sorting results;
10.3 Filtering data with the WHERE clause;
10.4 Creating aliases;
10.5 Using the JOIN operator to return data from multiple tables;
10.6 Limiting the data returned in your result set;
10.7 Using UNION to combine result sets;
10.8 Summary;
Using Transact-SQL (T-SQL);
Chapter 11: Advanced data retrieval topics;
11.1 Pivoting and unpivoting data;
11.2 Paging data;
11.3 Writing expressions;
11.4 Using variables;
11.5 Summary;
Chapter 12: Modifying data;
12.1 Inserting data into SQL Server tables;
12.2 Using sequence numbers;
12.3 Updating data in tables;
12.4 Deleting data from tables;
12.5 Merging data;
12.6 Returning output data;
12.7 Summary;
Chapter 13: Built-in scalar functions;
13.1 Using date and time functions;
13.2 Using conversion functions;
13.3 Using string functions;
13.4 Using logical functions;
13.5 Summary;
Creating other database objects;
Chapter 14: Advanced T-SQL topics;
14.1 Aggregating, windowing, and grouping;
14.2 Windowing;
14.3 Using SQL Server temporary objects;
14.4 Handling T-SQL errors;
14.5 Controlling flow keywords;
14.6 Summary;
Chapter 15: Views;
15.1 What are views?;
15.2 Creating indexed views;
15.3 Summary;
Chapter 16: User-defined functions;
16.1 Understanding user-defined scalar functions;
16.2 Understanding table-valued functions;
16.3 Limitations of functions;
16.4 Summary;
Chapter 17: Stored procedures;
17.1 Working with stored procedures;
17.2 Using the EXECUTE keyword;
17.3 Parameterizing stored procedures;
17.4 Dropping stored procedures;
17.5 Summary;
Chapter 18: Data manipulation triggers;
18.1 Types of triggers;
18.2 Creating triggers;
18.3 Altering triggers;
18.4 Dropping triggers;
18.5 Enabling and disabling triggers;
18.6 Summary;
SQL Server replication;
Chapter 19: Replication;
19.1 Types of replication;
19.2 Replication agents;
19.3 Configuring replication;
19.4 Monitoring replication;
19.5 Summary;
Database maintenance;
Chapter 20: Backups;
20.1 Understanding backup devices;
20.2 Full database backups;
20.3 Differential database backups;
20.4 Transaction log database backups;
20.5 Restoring databases;
20.6 Summary;
Chapter 21: Managing and maintaining indexes and statistics;
21.1 Checking index fragmentation;
21.2 Defragmenting indexes;
21.3 Creating and updating database statistics;
21.4 Summary;
Chapter 22: Maintenance plans;
22.1 Performing database consistency checks;
22.2 Creating maintenance plans;
22.3 Summary;
Database management;
Chapter 23: SQL Server Profiler;
23.1 Understanding SQL Server Profiler;
23.2 Creating traces;
23.3 Running server-side traces;
23.4 Summary;
Chapter 24: Extended Events;
24.1 Understanding the Extended Events architecture;
24.2 Creating and configuring an Extended Events session;
24.3 Using an Extended Events session to monitor system performance;
24.4 Summary;
Chapter 25: SQL Server security;
25.1 Understanding principals;
25.2 Creating server logins;
25.3 Creating user-defined server roles;
25.4 Creating database users;
25.5 Creating built-in database roles;
25.6 Configuring contained databases;
25.7 Summary;
Chapter 26: Resource Governor;
26.1 Enabling and disabling Resource Governor;
26.2 Creating resource pools;
26.3 Creating a workload group;
26.4 Using classifier functions;
26.5 Testing classifier functions;
26.6 Modifying Resource Governor configurations;
26.7 Summary;
Chapter 27: SQL Server Agent;
27.1 SQL Server Agent components;
27.2 Viewing SQL Server Agent Configuration Manager options;
27.3 Configuring SQL Server Agent properties;
27.4 Creating operators;
27.5 Configuring alerts;
27.6 Configuring jobs;
27.7 Creating proxies;
27.8 Summary;
Chapter 28: Database Mail;
28.1 Database Mail components;
28.2 Configuring Database Mail;
28.3 Sending email using Database Mail;
28.4 Monitoring Database Mail;
28.5 Summary;
Chapter 29: Data definition triggers;
29.1 Types of triggers;
29.2 Creating triggers;
29.3 Altering triggers;
29.4 Enabling and disabling triggers;
29.5 Dropping triggers;
29.6 Summary;
Chapter 30: Dynamic management objects;
30.1 Retrieving SQL Server metadata from DMOs;
30.2 Querying server performance statistics;
30.3 Querying server information;
30.4 Querying performance information;
30.5 Querying indexing statistics;
30.6 Summary;
High-availability solutions;
Chapter 31: AlwaysOn;
31.1 Failover cluster instance improvements;
31.2 Creating AlwaysOn Availability Groups;
31.3 Administering AlwaysOn Availability Groups;
31.4 Reading secondary database copies;
31.5 Summary;
Chapter 32: Log shipping;
32.1 Log shipping components;
32.2 Log shipping prerequisites;
32.3 Configuring log shipping;
32.4 Summary;
About the Author;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)