Advanced SQL course

Overview

Advanced SQL course teaches how to use advanced SQL techniques to access a database. This seminar is intended for students who have a basic knowledge of SQL or have completed a basic SQL course.

Target audience

• Data Analysts
• Business Analysts
• Data Engineers
• SW Engineers

Prerequisites

• Basic understanding of databases and SQL (e.g. our Basic SQL course)

Content

Day 1:

• Overview of the basics of SQL and OLAP functions
• Creating objects
• Join tables
• CASE, CAST, summary (MQT) and provisional tables

Day 2:

• Subqueries
• Scalar functions
• Tabular expressions and recursive SQL
• UDT, UDF and performance

For all inquiries regarding education, please contact us at learn@croz.net.

Check course dates.