DP-080T00: Querying Data with Microsoft Transact-SQL Training Course

Basic knowledge of databases

There is no certification exam associated with this training course.

• Introduction to Transact-SQL
• Using the SELECT statement
• Sorting query results
• Filtering the data
• Using JOIN operations
• Using subqueries
• Getting started with scalar functions
• Grouping aggregated results
• Inserting data into tables
• Modifying and deleting data
• Use SQL Server query tools
• Write SELECT statements to retrieve columns from one or more tables
• Sort and filter selected data
• Use built-in functions to return data values

This course is likely to add to the employment-related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.

• Data Analysts
• Data Engineers
• Data Scientists
• Database Administrators
• Database Developers
• Solution Architects
• Students
• Technology Managers
• Professionals interested in Microsoft certifications

• Getting Started with Transact-SQL
• Sorting and Filtering Query Results
• Using Joins and Subqueries
• Using Built-in Functions
• Modifying Data
• Using a query tool to write and execute queries in Transact-SQL
• Understand the basic concepts of relational databases and the T-SQL language
• Understand basic data types and how they are used
• Understand the basics of NULL values
• Use ORDER BY to sort results from a T-SQL SELECT statement
• Understand the differences between the type of JOIN operations: INNER JOIN, OUTER JOIN, CROSS JOIN
• Write subqueries within a SELECT statement
• Understand the difference between scalar and multi-valued subqueries
• Understand the difference between correlated and self-contained subqueries
• Insert data into an existing table
• Modify data using the UPDATE statement
• Delete data using the DELETE statement