Querying Data with Microsoft Transact-SQL - SQL Server

Who Should Attend?

• Data analysts/engineers/scientists,
• Database administrators/developers
• Data solution architects, 
• Technology managers,
• Students,
• SQL or Transact-SQL Starters

Course Outline

• Using query tool to write and execute queries in Transact-SQL
• Understand the basic concepts of relational database and the T-SQL language
• Write SELECT statements to retrieve data from a relational database table
• Understand basic datatypes and how they are used
• Understand the basics of NULL values
• Use ORDER BY to sort results from a T-SQL SELECT statement
• Add a TOP clause to limit the ordered rows returned
• Page the sorted data with OFFSET-FET
• Write WHERE clauses to filter the rows returned
• Use DISTINCT to eliminate duplicate rows in the results
• Insert data into an existing table
• Specify that a column should be automatically populating with an IDENTITY or a SEQUENCE value
• Modify data using the UPDATE statement
• Delete data using the DELETE statement
• Write queries accessing data from multiple tables using JOIN operations
• Understand the differences between type of JOIN operations: INNER JOIN, OUTER JOIN, CROSS JOIN
• Understand how to join a table to itself with a self-join
• Write subqueries within a SELECT statement
• Understand the difference between scalar and multi-valued subqueries
• Understand the difference between correlated and self-contained subqueries
• Write queries using scalar functions
• Write queries using aggregate functions
• Use GROUP BY to combine data into groups based on a common column value
• Understand how HAVING is used to filter groups of rows
• Modify data using MERGE to synchronize two tables