Programming & Development

DP-080T00 Querying Data with Microsoft Transact-SQL

Introduction:

This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

Objectives:

Course Outline:

1 – Introduction to Transact-SQL

  • Work with schemas
  • Explore the structure of SQL statements
  • Examine the SELECT statement
  • Work with data types
  • Handle NULLs

2 – Sort and filter results in T-SQL

  • Sort your results
  • Limit the sorted results
  • Page results
  • Remove duplicates
  • Filter data with predicates

3 – Combine multiple tables with JOINs in T-SQL

  • Understand joins concepts and syntax
  • Use inner joins
  • Use outer joins
  • Use cross joins
  • Use self joins

4 – Write Subqueries in T-SQL

  • Understand subqueries
  • Use scalar or multi-valued subqueries
  • Use self-contained or correlated subqueries

5 – Use built-in functions and GROUP BY in Transact-SQL

  • Categorize built-in functions
  • Use scalar functions
  • Use ranking and rowset functions
  • Use aggregate functions
  • Summarize data with GROUP BY
  • Filter groups with HAVING

6 – Modify data with T-SQL

  • Insert data
  • Generate automatic values
  • Update data
  • Delete data
  • Merge data based on multiple tables

Enroll in this course

$1,190.00

Need Help Finding The Right Training Solution?

Our training advisors are here for you.