DP-080: Querying Data with Microsoft Transact-SQL

This course comprises 5 purposely designed modules that take you on a carefully defined learning journey.

It is an instructor-led course which runs to a fixed schedule, with set start and finish dates. It is driven forward by your instructor and features live sessions that are aired at a set time. You will, however, have time to complete certain activities at your own pace outside of the live sessions.

The materials for each module are accessible from the start of the course and will remain available for the duration of your enrollment. Methods of learning and assessment will include reading material, hands-on labs, and online exam questions.

As part of our mentoring service you will have access to valuable guidance and support throughout the course. We provide a dedicated discussion space where you can ask questions, chat with your peers, and resolve issues.

Once you have successfully completed the course, you will earn your Certificate of Completion.

After completing this course, students will be able to:

• 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 returned data values.
• Create groups of data and aggregate the results.
• Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE.

• Data engineers
• Data analysts
• Database administrators
• Database developers
• Data scientists
• Technology managerss
• Individuals preparing for the DP-080 exam
• Professionals interested in learning Microsoft Transact-SQL concepts

• Some experience with databases and SQL will be beneficial to get the most out of this course.

This course will help you to prepare for the DP-080: Querying Data with Microsoft Transact-SQL.

During the couse you will learn the basics of Microsoft's dialect of the standard SQL language, Transact-SQL. Topics covered include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems. In learning about these aspects you will also explore Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

• You will become familiar with the basics of the Transact-SQL (T-SQL) language, as well as general properties and terminology of relational databases.
• You will build your knowledge around SQL language.
• You will become proficient at modifing data with Transact-SQL .

When you take this course, you will also get information and guidance on the Microsoft certification process, knowledge checks and practice questions, and useful tips on how to pass the exam.