Summer Reading B2G1 Free

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Original Essays | July 14, 2015

    Joshua Mohr: IMG Your Imagination, Your Fingerprint

    When I was in grad school, a teacher told our workshop that if a published novel is 300 pages, the writer had to generate 1,200 along the way. I... Continue »
    1. $17.50 Sale Hardcover add to wish list

      All This Life

      Joshua Mohr 9781593766030

Qualifying orders ship free.
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
3 Remote Warehouse General- General
14 Remote Warehouse Computers Reference- General

Microsoft SQL Server 2012 Step by Step


Microsoft SQL Server 2012 Step by Step Cover


Synopses & Reviews

Publisher Comments:

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

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

Table of Contents

IntroductionGetting started with Microsoft SQL Server 2012Chapter 1: Overview of Microsoft SQL Server 2012Chapter 2: Installing, Configuring, and Upgrading Microsoft SQL Server 2012Chapter 3: Using SQL Server 2012 administration and development toolsDesigning databasesChapter 4: Designing SQL Server databasesChapter 5: Creating your first tableChapter 6: Building and maintaining indexesAdvanced database design topicsChapter 7: Table compressionChapter 8: Table partitioningChapter 9: Database snapshotsChapter 10: The SELECT statementUsing Transact-SQL (T-SQL)Chapter 11: Advanced data retrieval topicsChapter 12: Modifying dataChapter 13: Built-in scalar functionsCreating other database objectsChapter 14: Advanced T-SQL topicsChapter 15: ViewsChapter 16: User-defined functionsChapter 17: Stored proceduresChapter 18: Data manipulation triggersSQL Server replicationChapter 19: ReplicationDatabase maintenanceChapter 20: BackupsChapter 21: Managing and maintaining indexes and statisticsChapter 22: Maintenance plansDatabase managementChapter 23: SQL Server ProfilerChapter 24: Extended EventsChapter 25: SQL Server securityChapter 26: Resource GovernorChapter 27: SQL Server AgentChapter 28: Database MailChapter 29: Data definition triggersChapter 30: Dynamic management objectsHigh-availability solutionsChapter 31: AlwaysOnChapter 32: Log shippingAbout the Author

Product Details

Leblanc, Patrick
Microsoft Press
LeBlanc, Patrick
LeBlanc, David
SQL Server;database administrator;databases
Database Management - General
Edition Description:
Trade Paper
Step by Step Developer
Publication Date:
9 x 7.38 in

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Computers Reference » General
Computers and Internet » Computers Reference » System Administration
Computers and Internet » Database » Applications
Computers and Internet » Database » SQL
Computers and Internet » Personal Computers » Desktop Applications » General

Microsoft SQL Server 2012 Step by Step New Trade Paper
0 stars - 0 reviews
$49.99 In Stock
Product details 432 pages Microsoft Press - English 9780735663862 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at