Querying Microsoft SQL Server 2012/2014

Request more details:

Description:
This 5-day instructor led course (20461D) provides participants with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. 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. Note: This course is designed for participants who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Prerequisites:
This course requires that you meet the following prerequisites:
- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
Introduction to Microsoft SQL Server 2014:
The Basic Architecture of SQL Server
SQL Server Editions and Versions
Getting Started with SQL Server Management Studio
Introduction to T-SQL Querying:
Introducing T-SQL
Understanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements
Writing SELECT Queries:
Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions
Querying Multiple Tables:
Understanding Joins
Querying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins
Sorting and Filtering Data:
Sorting Data
Filtering Data with a WHERE Clause
Filtering with the TOP and OFFSET-FETCH Options
Working with Unknown and Missing Values
Working with SQL Server 2014 Data Types:
Introducing SQL Server 2014 Data Types
Working with Character Data
Working with Date and Time Data
Using DML to Modify Data:
Inserting Data
Modifying and Deleting Data
Using Built-In Functions:
Writing Queries with Built-In Functions
Using Conversion Functions
Using Logical Functions
Using Functions to Work with NULL
Grouping and Aggregating Data:
Using Aggregate Functions
Using the GROUP BY Clause
Filtering Groups with HAVING
Using Subqueries:
Writing Self-Contained Subqueries
Writing Correlated Subqueries
Using the EXISTS Predicate with Subqueries
Using Table Expressions:
Using Derived Tables
Using Common Table Expressions
Using Views
Using Inline Table-Valued Functions
Using Set Operators:
Writing Queries with the UNION Operator
Using EXCEPT and INTERSECT
Using APPLY
Using Window Ranking, Offset, and Aggregate Functions:
Creating Windows with OVER
Exploring Window Functions
Pivoting and Grouping Sets:
Writing Queries with PIVOT and UNPIVOT
Working with Grouping Sets
Executing Stored Procedures:
Querying Data with Stored Procedures
Passing Parameters to Stored Procedures
Creating Simple Stored Procedures
Working with Dynamic SQL
Programming with T-SQL:
T-SQL Programming Elements
Controlling Program Flow
Implementing Error Handling:
Using TRY / CATCH Blocks
Working with Error Information
Implementing Transactions:
Transactions and the Database Engine
Controlling Transactions
Isolation Levels