Modular Course (Select your Modules)

QUERYING MICROSOFT SQL SERVER® 2014

   In this course students will provided by 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.

Basic (2 days)

• Introduction to Microsoft SQL Server 2014

• Introduction to T-SQL Querying

• Writing SELECT Queries

• Querying Multiple Tables

• Sorting and Filtering Data

• Grouping and Aggregating Data

• Using Subqueries

Intermediate (2 days)

optional

Advanced (2 days)

optional

• Querying data with Stored Procedures

• Programming with T-SQL

• Implementing Error Handling

• Implementing Transactions

• Improving Query Performance (Optional)

• Querying SQL Server Metadata (Optional)

• Working with SQL Server 2014 Data Types

• Using DML to Modify Data

• Using Built-In Functions

• Using Table Expressions

• Using Set Operators

• Using Window Ranking, Offset, and Aggregate Functions

• Pivoting and Grouping Sets