Querying Data with Microsoft Transact-SQL

Sviluppo
SQL Server
Microsoft
2 Giorni
it
Nessuna certificazione
Descrizione del corso

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.

Programma

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


Ad hoc

Cerchi un
corso su misura?
Richiedilo ora

Contatti

Hai bisogno
di aiuto?
Contattaci