1 - Getting Started with Transact-SQL
Introduction to Transact-SQLUsing the SELECT statement
2 - Sorting and Filtering Query Results
Sorting query resultsFiltering the data
3 - Using Joins and Subqueries
Using JOIN operationsUsing subqueries
4 - Using Built-in Functions
Getting started with scalar functionsGrouping aggregated results
5 - Modifying Data
Inserting data into tablesModifying and deleting data
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.