Microsoft Transact-SQL

Enroll for 2-day Querying Data with Microsoft Transact-SQL - DP-080T00 training course from Koenig Solutions accredited by Microsoft. In this course you will learn about the basics of Microsoft's dialect of the standard SQL language: Transact-SQL.

Through a blend of hands-on labs and interactive lectures, you will learn about both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

Target Audience:

• Data Analyst
• Data Engineer
• Data Scientist
• Database administrator
• Database Developer

Learning Objectives:

After completing this course, you 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