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

spacer
Qualifying orders ship free.
$69.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside - Bldg. 2 Computer Certification- General
25 Local Warehouse Computers Reference- General
25 Remote Warehouse Computers Reference- General

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012

by

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 Cover

 

Synopses & Reviews

Publisher Comments:

Ace your preparation for Microsoft Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD–featuring multiple, customizable testing options.

Maximize your performance on the exam by learning how to:

  • Create database objects
  • Work with data
  • Modify data
  • Troubleshoot and optimize queries

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

About the Author

Itzik Ben-Gan is a mentor and cofounder of SolidQ. A Microsoft MVP for SQL Server since 1999, Ben-Gan teaches and consults internationally on T-SQL querying, programming, and query tuning. He is the author of Microsoft SQL Server T-SQL Fundamentals and coauthor of Inside Microsoft SQL Server: T-SQL Querying and Inside Microsoft SQL Server:T-SQL Programming. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.

Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.

Ron Talmage is a mentor with SolidQ. He is a SQL Server MVP, PASS Northwest US Regional Mentor, and current Chapter Leader of the Redmond-based Pacific Northwest SQL Server Users Group. He has been involved with SQL Server since version 4.21a, and has contributed to numerous SQL Server white papers and articles. His current focus is on database administration for relational data warehouses using SQL Server.

Table of Contents

IntroductionChapter 1: Foundations of QueryingChapter 2: Getting Started with the SELECT StatementChapter 3: Filtering and Sorting DataChapter 4: Combining SetsChapter 5: Grouping and WindowingChapter 6: Querying Full-Text DataChapter 7: Querying and Managing XML DataChapter 8: Creating Tables and Enforcing Data IntegrityChapter 9: Designing and Creating Views, Inline Functions, and SynonymsChapter 10: Inserting, Updating, and Deleting DataChapter 11: Other Data Modification AspectsChapter 12: Implementing Transactions, Error Handling, and Dynamic SQLChapter 13: Designing and Implementing T-SQL RoutinesChapter 14: Using Tools to Analyze Query PerformanceChapter 15: Implementing Indexes and StatisticsChapter 16: Understanding Cursors, Sets, and Temporary TablesChapter 17: Understanding Further Optimization Aspects

Product Details

ISBN:
9780735666054
Author:
Ben Gan, Itzik
Publisher:
Microsoft Press
Author:
Ben-Gan, Itzik
Author:
Talmage, Ron
Author:
Sark
Author:
Sarka, Dejan
Author:
a, Dejan
Subject:
Internet-Information
Subject:
Computers-Reference - General
Subject:
SQL Server;T-SQL;database administrator;databases;querying
Copyright:
Edition Description:
Trade Paper
Series:
Microsoft Press Training Kit
Publication Date:
20121231
Binding:
TRADE PAPER
Language:
English
Pages:
752
Dimensions:
9 x 7.38 in

Other books you might like

  1. Knight's 24-Hour Trainer: Microsoft... New Trade Paper $44.95

Related Subjects

Computers and Internet » Computer Certification » General
Computers and Internet » Computer Languages » SQL
Computers and Internet » Computers Reference » General
Computers and Internet » Database » SQL
Computers and Internet » Internet » Information
Computers and Internet » Software Engineering » General

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 New Trade Paper
0 stars - 0 reviews
$69.99 In Stock
Product details 752 pages Microsoft Press - English 9780735666054 Reviews:
spacer
spacer
  • 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.