DP-080: Querying Data with Microsoft Transact-SQL

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator, or a database developer. 

The SQL language can be used to easily perform queries that return insightful information and thus improve the understanding of the contents of a database. This course provides an excellent opportunity to study and practice with the SQL language in a training environment. 

There are no specific prerequisites.

Knowledge of databases or programming in a language facilitates is helpful but not required.

Module 1: Getting Started with Transact-SQL

• Introduction to Transact-SQL
• Using the SELECT statement

Module 2: Sorting and Filtering Query Results

• Sorting query results
• Filtering the data

Module 3: Using Joins and Subqueries

• Using JOIN operations
• Using subqueries

Module 4: Using Built-in Functions

• Getting started with scalar functions
• Grouping aggregated results

Module 5: Modifying Data

• Inserting data into tables
• Modifying and deleting data