Querying Data with Microsoft Transact-SQL

DP-080 | 2 days | €495Всички цени са без ДДС.

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 сеп. 2024

    Вид
    Course
    Език
    Bulgarian
    Метод
    Virtual
    Формат
    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.

Вашата сертификационна пътека ви очаква!

Разбере как може да се сертифицирате чрез изпитни ваучери с онлайн проктор. Подобрете вашето кариерно развитие сега!


Регистрация







    След като попълните формата, ние ще се свържем с Вас, за да потвърдим интереса Ви и присъствието Ви в обучението.

    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