Duração:
2 dias
Próxima Data:
Consulte-nos
Local:
Online
Descrição
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.
*PVP por participante. A realização do curso nas datas apresentadas está sujeita a um quórum mínimo de inscrições.
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.
-
Área: Microsoft
-
Certificação Associada: Database Administrator
Programa:
Module 1: Get Started Querying with Transact-SQL
Learn how to use Transact-SQL to query data in a database.
Lessons:
- 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
Partilha:
Precisas de ajuda a encontrar o teu futuro?
