MOC 10774 A Querying Microsoft SQL Server 2012

    

Summary:
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. Many of the exercises in this course are SQL Azure enabled.

Duration:
5 Days/Lecture & Lab

Audience:
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren't necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

Topics:

• Introduction to Microsoft SQL Server 2012
• Getting Started with SQL Azure
• Introduction to T-SQL Querying
• Writing SELECT Queries
• Querying Multiple Tables
• Sorting and Filtering Data
• Working with SQL Server 2012 Data Types
• Using Built-In Functions
• Grouping and Aggregating Data
• Using Subqueries
• Using Table Expressions
• Using Set Operators
• Using Window Ranking, Offset and Aggregate Functions
• Pivoting and Grouping Sets
• Querying SQL Server Metadata
• Executing Stored Procedures
• Programming with T-SQL
• Implementing Error Handling
• Implementing Transactions
• Improving Query Performance

Prerequisites:
Before attending this course, students must have:
Working knowledge of relational databases.
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Before attending this course, students should have:
Basic understanding of virtualization technology (Classroom labs utilize virtual machines)

Last Update: May 23, 2013