Development
Advanced SQL course
DURATION 2 Days
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.