Course description

Learn basic Transact-SQL queries for Microsoft SQL Server 2016.

Learn how to write basic Transact-SQL queries for Microsoft SQL Server 2016. This course will provide a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines—namely, database administration, database development and business intelligence.

You will learn about: T-SQL elements, writing SQL queries, querying JOINs, sorting and filtering data, SQL Server 2016 data types, T-SQL DML, built-in functions, grouping and aggregating data, subqueries, and set operators.

This course incorporates material from the Official Microsoft Learning Product 20761: Querying Data with Transact-SQL.

Each individual Microsoft Official Course On-Demand includes 3 months (or 12 months with purchase of Microsoft Total Access Collection) of 24x7 access to the following:

What You’ll Learn

Who Needs to Attend

Database administrators, database developers and business intelligence professionals, as well as SQL power users who aren’t necessarily database-focused, such as report writers, business analysts and client application developers.

Prerequisites

Follow-On Courses:

Related Certifications

MCSA: SQL 2016 Database Development

Course Outline

1. Introduction to Microsoft SQL Server 2016

2. Introduction to T-SQL Querying

3. Writing SELECT Queries

4. Querying Multiple Tables

5. Sorting and Filtering Data

6. Working with SQL Server 2016 Data Types

7. Using DML to Modify Data

8. Using Built-In Functions

9. Grouping and Aggregating Data

10. Using Subqueries

11. Using Set Operators

Labs

Lab 1: Working with SQL Server 2016 Tools

Lab 2: Introduction to Transact-SQL Querying

Lab 3: Writing Basic SELECT Statements

Lab 4: Querying Multiple Tables

Lab 5: Sorting and Filtering Data

Lab 6: Working with SQL Server 2016 Data Types

Lab 7: Using DML to Modify Data

Lab 8: Using Built-In Functions

Lab 9: Grouping and Aggregating Data

Lab 10: Using Subqueries

Lab 11: Using SET Operators