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.

Referenzen

SQL Server

SQLServer

MySql