DP-080T00 Querying Data with Microsoft Transact-SQL (UT-Microsoft-DP-080T00)


Course Description

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.

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

 

There are no prerequisites for this course.

Course Information

Length: 2 day

Format: Lecture and Lab

Delivery Method: Virtual

Max. Capacity: 16



Schedule

Contact Us

UPCOMING COURSES
Date
Geography & Location
Days
Cost
CLC
GTR
Apr 17, 2024 - 2 day(s)
Apr 17, 2024
AMER
Remote-EST
AMER, Remote-EST
2
$1190 USD
$1190 USD

Do you have more questions? We're delighted to assist you!

1-877-797-2799
info@firefly.cloud

Who Should Attend

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.