Seminarinhalt
Programm
- Introduction
- Work with schemas
- Explore the structure of SQL statements
- Examine the SELECT statement
- Work with data types
- Handle NULLs
- Introduction
- Sort your results
- Limit the sorted results
- Page results
- Remove duplicates
- Filter data with predicates
- Introduction
- Understand joins concepts and syntax
- Use inner joins
- Use outer joins
- Use cross joins
- Use self joins
- Introduction
- Understand subqueries
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
- 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
- Introduction
- Insert data
- Generate automatic values
- Update data
- Delete data
- Merge data based on multiple tables
Zielgruppen
Vorkenntnisse
- der Besuch des Seminars SSQLBAS - smart SQL Server: Introduction to SQL Databases oder vergleichbare Kenntnisse.
Trainings zur Vorbereitung
Wichtige Information
Als Aufbautraining empfehlen wir das Training SQL Server: Data Querying mit Transact-SQL Aufbau (SQLAP-Advanced)
Querying Data with Microsoft Transact-SQL
24.04.2025 — Andreas H.Querying Data with Microsoft Transact-SQL
21.02.2024 — Peter L.Querying Data with Microsoft Transact-SQL
05.02.2024 — Gina B.Querying Data with Microsoft Transact-SQL
19.12.2023 — Roland G.Querying Data with Microsoft Transact-SQL
29.08.2023 — Markus F.