Querying Data with Microsoft Transact-SQL

DP-080 | 2 days | €495All prices exclude VAT.

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

Module 1: Introduction to Transact-SQL

Module 2: Sort and filter results in T-SQL

Module 3: Combine multiple tables with JOINs in T-SQL

Module 4: Write Subqueries in T-SQL

Module 5: Use built-in functions and GROUP BY in Transact-SQL

Module 6: Modify data with T-SQL


Accreditation

ITCE is a Certified Microsoft Learning Partner.


Calendar

  1. 16 – 17 Sep 2024

    Training Type
    Course
    Language
    Bulgarian
    Learning Method
    Virtual
    Format
    All day

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.

Your Certification Journey Awaits!

Get more information on how you can get certified through online proctored exam vouchers. Boost your career prospects now!


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