fbpx

DP-080: Querying Data with Microsoft Transact-SQL

Presencial
PROMOÇÃO

Curso com 10% de desconto
Aproveite já!

Chat

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.

Objetivos

  • Introduce relational databases, the SQL language and Transact-SQL
  • Sort and filter query results
  • Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations
  • Use subqueries to combine multiple SELECT statements and compose nested queries
  • Use functions in Transact-SQL, and how to group aggregated results
  • Use Transact-SQL to insert, update, and delete data in a database

Destinatários

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.

Condições

Ao concluir com aproveitamento esta formação, cumprindo a percentagem mínima de 70% de assiduidade e após avaliação ao curso, o formando poderá receber o seu Certificado Microsoft de conclusão e o badge digital para partilhar com a sua rede profissional online.

Programa

  • Introduction to Transact-SQL
  • Sort and filter results in T-SQL
  • Combine multiple tables with JOINs in T-SQL
  • Write Subqueries in T-SQL
  • Use built-in functions and GROUP BY in Transact-SQL
  • Modify data with T-SQL

Introduction to Transact-SQL

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

Sort and filter results in T-SQL

  • Sort your results
  • Limit the sorted results
  • Page results
  • Remove duplicates
  • Filter data with predicates
  • Exercise – Sort and filter query results
  • Knowledge check

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
  • Exercise – Query multiple tables with joins
  • Knowledge check

Write Subqueries in T-SQL

  • Understand subqueries
  • Use scalar or multi-valued subqueries
  • Use self-contained or correlated subqueries
  • Exercise – Use subqueries
  • Knowledge check

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
  • Exercise – Use built-in functions
  • Knowledge check

Modify data with T-SQL

  • Insert data
  • Generate automatic values
  • Update data
  • Delete data
  • Merge data based on multiple tables
  • Exercise – Modify data
  • Knowledge check

Outras datas e horários

Chat

Quero saber mais informações sobre este curso

DP-080: Querying Data with Microsoft Transact-SQL

Data & AI | 14h - Laboral: 09h00 - 17h00


Notas

Pretende mais informação sobre este curso?

Preencha o formulário com os seus dados e as suas questões e entraremos em contacto consigo para lhe darmos todas as informações pretendidas.

Obrigado!

Quero inscrever-me neste curso

DP-080: Querying Data with Microsoft Transact-SQL

Data & AI | 14h - Laboral: 09h00 - 17h00


Dados Pessoais
Dados para faturação