10774 Querying Microsoft SQL Server 2012 (Beta)

Students will learn 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; Database Administration, Database Development and Business Intelligence.

Lesson 1: Introduction to Microsoft SQL Server 2012

• SQL Server Denali Architecture
• Working with SQL Server Denali Tools
• Working with SQL Server Databases
• Lab : Working with SQL Server Denali Tools (Azure enabled)

Lesson 2: Introduction to Transact-SQL Querying

• Introducing Transact-SQL
• Understanding Sets
• Understanding Predicate Logic
• Understanding the Logical Order of Operations in SELECT Statements
• Lab : Introduction to Transact-SQL Querying

Lesson 3: Writing SELECT Queries

• Writing Simple SELECT Statements
• Eliminating Duplicates with DISTINCT
• Using Column and Table Aliases
• Writing Simple CASE Expressions
• Lab : Writing Basic SELECT statements

Lesson 4: Querying Multiple Tables

• Understanding Joins
• Querying With Inner Joins
• Querying With Outer Joins
• Querying Using Self and Cross Joins
• Lab : Querying Multiple Tables

Lesson 5: Sorting and Filtering Data

• Sorting Data
• Filtering Data
• Filtering with the TOP and OFFSET-FETCH Options
• Working with Unknown Values
• Lab : Filtering and Sorting Data

Lesson 6: Working with SQL Server Denali Data Types

• Introducing SQL Server Denali Data Types
• Working with Character Data
• Working with Date and Time Data
• Lab : Working with SQL Server 2012 Data Types

Lesson 7: Using Built-In Functions

• Writing Queries with Built-In Functions
• Using Conversion Functions
• Using Logical Functions
• Using Functions to Test for Nullability
• Lab : Using Built-In Functions

Lesson 8: Grouping and Aggregating Data

• Using Aggregate Functions
• Using the GROUP BY Clause
• Filtering Groups with the HAVING Clause
• Lab : Grouping and Aggregating Data

Lesson 9: Using Subqueries

• Writing Self-Contained Subqueries
• Writing Correlated Subqueries
• Using the EXISTS Predicate with Subqueries
• Lab : Using Subqueries

Lesson 10: Using Table Expressions

• Views
• Table Expressions
• Lab : Using Table Expressions

Lesson 11: Use Set Operators

• Lab : Use Set Operators

Lesson 12: Using Window Ranking, Offset and Aggregate Functions

• Lab : Using Window Ranking, Offset and Aggregate Functions

Lesson 13: Pivoting and Grouping Sets

• Lab : Pivoting and Grouping Sets

Lesson 14: Querying SQL Server Metadata

• Lab : Querying SQL Server Metadata

Lesson 15: Executing Stored Procedures

• Lab : Executing Stored Procedures

Lesson 16: Programming with T-SQL

• Lab : Programming with T-SQL

Lesson 17: Implementing Error Handling

• Lab : Implementing Error Handling

Lesson 18: Implementing Transactions

• Lab : Implementing Transactions

Lesson 19: Improving Query Performance

• Lab : Improving Query Performance

• Scottsdale, AZ - May 14, 2012
• Anaheim, CA - May 14, 2012
• Orlando, FL - July 9, 2012
• Urbandale, IA - July 16, 2012
• Bethlehem, PA - July 23, 2012
• Mechanicsburg, PA - September 17, 2012
• Pittston, PA - September 17, 2012
• Urbandale, IA - September 17, 2012
• Orlando, FL - September 24, 2012
• Mechanicsburg, PA - October 15, 2012
• Mechanicsburg, PA - November 12, 2012
• Urbandale, IA - November 12, 2012
• Orlando, FL - December 3, 2012
• Urbandale, IA - December 17, 2012