Querying SQL Server Database using Transact-SQL Workshop

The Query SQL Server Database using T-SQL Workshop course provides step-by-step instructions on how to perform a variety of  database development tasks for activities based on real-life work scenarios. This course provides students with the technical skills required to write Transact-SQL queries for Microsoft SQL Server.  

Note: This course is designed for students interested in learning SQL Server 2016, 2017, 2019 or 2022. It covers the new features in SQL Server 2022, but also the important capabilities across the SQL Server data platform.

On successful Completion of this course you will be able to:

• Describe the basic architecture and concepts of SQL Server 2019/2022
• Understand the similarities and differences between Transact-SQL and other computer languages
• Write SELECT queries
• Query multiple tables
• Sort and filter data
• Describe the use of data types in SQL Server
• Modify data using Transact-SQL
• Use built-in functions
• Group and aggregate data
• Use subqueries
• Use table expressions
• Use set operators
• Use window ranking, offset and aggregate functions
• Implement pivoting and grouping sets
• Execute stored procedures
• Program with T-SQL
• Implement error handling
• Implement transactions