Querying Data with Transact-SQL
- Beginn:
- 9. Aug 2021
- Ende:
- 13. Aug 2021
- Kurs-Nr.:
- NW20761
- Preis:
- 2145,00 EUR pro Platz (zzgl. MwSt.)
Beschreibung
This course ist designed to introduce students to Transact SQL. The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
Inhalte
- Introduction to Microsoft SQL Server 2016
- Introduction to T-SQL Querying
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server 2016 Data Types
- Using DML to Modify Data
- Using Built-In Functions
- Grouping and Aggregating Data
- Using Subqueries
- Using Table Expressions
- Using Set Operators
- Using Windows Ranking, Offset, and Aggregate Functions
- Pivoting and Grouping Sets
- Executing Stored Procedures
- Programming with T-SQL
- Implementing Error Handling
Voraussetzungen
-
Basic knowledge of the Microsoft Windows operating system and its core functionality.
-
Working knowledge of relational databases.
Seminarzeiten
Dieses Seminar findet täglich von 9:00 – ca. 17:00 Uhr statt.
Seminarsprache und -unterlagen
Die Seminarsprache ist Deutsch, die Seminarunterlagen werden in englischer Sprache zur Verfügung gestellt.
Enthaltene Leistungen
Im Seminarpreis sind die Seminarunterlagen, die Pausenverpflegung (Kaffee, Tee, kalte Getränke, Kekse, Süßigkeiten) sowie die Mittagsverpflegung enthalten.