Training Kit (Exam 70-461): Querying Microsoft(R) SQL
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.

1123938671
Training Kit (Exam 70-461): Querying Microsoft(R) SQL
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.

69.99 Out Of Stock
Training Kit (Exam 70-461): Querying Microsoft(R) SQL

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

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

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

Overview

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.

Product Details

ISBN-13: 9780735666054
Publisher: Pearson Education
Publication date: 12/15/2012
Series: Microsoft Press Training Kit Series
Pages: 752
Product dimensions: 7.40(w) x 8.90(h) x 1.70(d)

About the Author

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.

Table of Contents

Introduction Chapter 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

From the B&N Reads Blog
Page 1 of

Related Subjects

Computers
Database Management
Computer Certification & Training
Computer Programming
Microsoft Certification
Programming Languages
Applications & Languages - Databases
Database Administration & Management
Microsoft Certification - Topics
SQL (Programming Language)
SQL
SQL Server
Microsoft SQL Server->Certification
SQL (Computer program language)
SQL Server 2012
Computers
Database Management
Computer Certification & Training
Computer Programming
Microsoft Certification
Programming Languages
Applications & Languages - Databases
Database Administration & Management
Microsoft Certification - Topics
SQL (Programming Language)
SQL
SQL Server

Customer Reviews