Querying Data with Transact-SQL

This training course is designed to provide participants with the fundamental concepts related to Transact-SQL. This will cover topics such as introduction to SQL Server, the versions of SQL Server, including cloud versions, how to connect to SQL Server using SQL Server Management Studio, writing SELECT queries, grouping and aggregating data, and programming with T-SQL.

• Gain a comprehensive understanding of the key capabilities and components of SQL Server.
• Learn T-SQL, sets, and predicate logic.
• Write a single table and a multi-table SELECT statement.
• Write SELECT statements with filtering and sorting.
• Understand how SQL Server uses data types.
• Write DML statements, queries that use built-in functions, queries that aggregate data, and subqueries.
• Create and implement views and table-valued functions.
• Use set operators to combine query results.
• Write queries that use window ranking, offset, and aggregate functions.
• Transform data by implementing pivot, unpivot, rollup, and cube.
• Create and implement stored procedures.
• Add programming constructs such as variables, conditions, and loops to T-SQL code.