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 handlingv
Implement transactions
Querying SQL Server Database using Transact-SQL Workshop CBT