Microsoft DP-080T00 - Querying Data with Microsoft Transact-SQL

Enrol in the Introduction to Transact-SQL course to gain essential skills in querying and modifying data within Microsoft SQL Server-based systems. This comprehensive two-day course covers fundamental topics such as writing SELECT statements, sorting and filtering data, using built-in functions, creating data groups, and modifying data with Transact-SQL commands. Ideal for data analysts, engineers, scientists, and database professionals, this course will enhance your ability to work with data effectively.

What will you learn? 

• Use SQL Server query tools effectively
• Write SELECT statements to retrieve columns from one or more tables
• Sort and filter selected data
• Use built-in functions to return data values
• Create groups of data and aggregate the results
• Modify data with Transact-SQL using INSERT, UPDATE, DELETE, and MERGE commands

Who is this course for?

• Data analysts, data engineers, data scientists, database administrators, and database developers
• Solution architects, students, and technology managers involved with data
• Anyone needing to write basic SQL or Transact-SQL queries
• Individuals seeking to improve their data management skills