MICROSOFT OFFICIAL COURSE Pre-Release and Final Release Versions Microsoft SQL Server (only on the A-MIA-SQL1). Course Files. Querying Microsoft SQL Server training course by Nicomp is offered at any of our 50 locations around the United States and Canada. Microsoft Official Curriculum – Microsoft Course Page 1 of 12 write basic Transact-SQL queries for Microsoft SQL Server This course.

Author: Faujinn Kelrajas
Country: Cameroon
Language: English (Spanish)
Genre: Technology
Published (Last): 4 December 2004
Pages: 27
PDF File Size: 2.99 Mb
ePub File Size: 6.1 Mb
ISBN: 628-1-16026-379-7
Downloads: 23745
Price: Free* [*Free Regsitration Required]
Uploader: Vugis

Describe components of well-performing queries. As such, course 10774a querying microsoft sql server 2012 primary target audience for this course is: Training Kit Exam Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text. Ssl window functions to rows defined in an OVER clause, including partitions and frames. Using Window Ranking, Offset and Aggregate Functions This module introduces window functions including ranking, aggregate and offset functions.

Use functions that work with NULL. Using Set Operators This module introduces operations involving multiple sets of data. Implement structured exception handling in T-SQL. Create simple views and write queries against them. For information on exam policies and scoring, see the Microsoft Certification exam policies and FAQs.

10774 Querying Microsoft SQL Server 2012

Using Table Expressions This module introduces T-SQL expressions which return a valid relational table, typically for further use in the query. Write queries which summarize course 10774a querying microsoft sql server 2012 using built-in aggregate functions. If the virtual machines in your classroom are able to connect to the internet and you have a Windows Azure account you may be able to connect to your Azure server and database.

Return information about errors from system objects. Querying SQL Server Metadata SQL Server provides access to structured metadata by using a variety of mechanisms, such as system catalog views, system functions, dynamic management objects, and system stored procedures.


Note that Microsoft will not respond directly to your feedback.

Grouping and Aggregating Data After completing this module, you will be able to: Microsoft exams might include adaptive testing technology and simulation items. It discusses batches, variables, control of flow elements such as loops and conditionals, how to create and execute dynamic SQL statements, and how to use synonyms. This exam measures your ability to accomplish the technical tasks listed below.

Improving Query Performance This module introduces the concepts of system resource usage and the performance impact of querying SQL Server After completing this course, students will be able to: Write queries which pivot and unpivot result mivrosoft Write queries which course 10774a querying microsoft sql server 2012 multiple groupings with grouping sets Module Execute system stored procedures to return system information.

Describe the effects course 10774a querying microsoft sql server 2012 isolation levels on transactions. Create simple views mlcrosoft write queries against them. To help you prepare for this exam, Microsoft recommends that you have hands-on experience with the product and that you use the specified training resources.

Pricing does not include applicable taxes. Failing to show up for your exam appointment or not rescheduling or qurying your appointment at least 24 hours prior to your scheduled appointment forfeits your entire exam fee. Write self-contained subqueries which return scalar or multi-valued results. Display and interpret basic query performance data Module Using Built-In Functions Write queries which use conversion functions Write queries which use logical functions Write queries which test for nullability After completing this module, students will be able to: Describe the language elements of T-SQL used for simple programming tasks.

The percentages indicate the relative weight of each major topic area on the exam.


Describe the uses of queries which are nested within other queries. Using Built-In Functions This module introduces the use of functions that are built in to SQL Server Denali, and will discuss some common usages including data type conversion, testing for logical results and nullability.

Create simple inline table-valued functions and write queries against them. Insert new data into your tables. Note This wql guide is subject to 20122 at any time without prior notice and at the sole discretion of Microsoft. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of course 10774a querying microsoft sql server 2012 certification process.

Write queries which use derived tables. Use column and course 10774a querying microsoft sql server 2012 aliases. Much of this functionality is new to SQL Server Write queries that use inner joins.

Implementing Transactions After completing this module, you will be able to: Many of the labs in the rest of this course are enabled for you to perform the lab while connected to your own Azure database in the cloud.

It was determined that no updates to exam objectives were required. Study Group Updated on – Last reply by.

Course D: Querying Microsoft SQL ServerĀ® | Microsoft

Who should take this exam? The module discusses views, derived tables, common table expressions and inline table-valued functions.

Write queries which specify multiple groupings with grouping sets.