Querying Data with Microsoft Transact-SQL

Introduction to Transact-SQL - Introduction - Work with schemas - Explore the structure of SQL statements - Examine the SELECT statement - Work with data types - Handle NULLs Sort and filter results in T-SQL - Introduction - Sort your results - Limit the sorted results - Page results - Remove duplicates - Filter data with predicates Combine multiple tables with JOINs in T-SQL - Introduction - Understand joins concepts and syntax - Use inner joins - Use outer joins - Use cross joins - Use self joins Write Subqueries in T-SQL - Introduction - Understand subqueries - Use scalar or multi-valued subqueries - Use self-contained or correlated subqueries Use built-in functions and GROUP BY in Transact-SQL - Introduction - Categorize built-in functions - Use scalar functions - Use ranking and rowset functions - Use aggregate functions - Summarize data with GROUP BY - Filter groups with HAVING Modify data with T-SQL - Introduction - Insert data - Generate automatic values - Update data - Delete data - Merge data based on multiple tables

In diesem Training werden die Grundlagen von Transact-SQL vermittelt, dem Microsoft-Dialekt der SQL-Standardsprache. Die Themen umfassen das Abfragen und Ändern von Daten in relationalen Datenbanken, die in Microsoft SQL Server-basierten Datenbanksystemen gehostet werden. Dazu zählen Microsoft SQL Server, Azure SQL-Datenbank und Azure Synapse Analytics.

- der Besuch des Seminars SSQLBAS - smart SQL Server: Introduction to SQL Databases oder vergleichbare Kenntnisse.