25 Books to Read Before You Die

Recently Viewed clear list

The Powell's Playlist | August 6, 2014

Graham Joyce: IMG The Powell’s Playlist: Graham Joyce

The Ghost in the Electric Blue Suit is set on the English coast in the hot summer of 1976, so the music in this playlist is pretty much all from the... Continue »
  1. $17.47 Sale Hardcover add to wish list

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
16 Remote Warehouse Computers Reference- General
3 Remote Warehouse General- 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 www.sqllunch.com, 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, David
LeBlanc, Patrick
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
Follow us on...

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