Querying Data with Microsoft Transact-SQL

DP-080 2 days 480*

This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL.

The course is replacing 20761.

Overview

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.

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.

What you’ll learn

At the end of the course you will be able to:

  • Use SQL Server query tools
  • Write SELECT statements to retrieve columns from one or more tables
  • Sort and filter selected data
  • Use built-in functions to returned data values
  • Create groups of data and aggregate the results
  • Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

COURSE MODULES

Module 1: Getting Started with Transact-SQL

  • Introduction to Transact-SQL
  • Using the SELECT statement

Module 2: Sorting and Filtering Query Results

  • Sorting query results
  • Filtering the data

Module 3: Using Joins and Subqueries

  • Using JOIN operations
  • Using subqueries

Module 4: Using Built-in Functions

  • Getting started with scalar functions
  • Grouping aggregated results

Module 5: Modifying Data

  • Inserting data into tables
  • Modifying and deleting data

Accreditation

ITCE is a Certified Microsoft Learning Partner.


Calendar

Frequently Asked Questions

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.

Are there any prerequisites for this course?

There are no prerequisites for this course.


Register






    Once you submit your registration, we will get in touch with you to confirm your interest and attendance.

    By continuing to use the site, you agree to the use of cookies. more information

    The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

    Close