Receive in-depth knowledge from industry professionals, test your skills with hands-on assignments & demos, and get access to valuable resources and tools.
This course is a deep dive into relational databases. The lessons that are presented here focus on basic concepts behind relational databases, advanced SQL joins and aggregations, ETL (extract, transform, load) processes and BI tools such PowerBI. After this course, you will be able to handle relational databases with confidence as well as possess the theoretical and practical knowledge to work with them. This course is ideal for data engineers/scientists who want to take the next step in their relational database knowledge and BI tools. As requirements, experience with other programming languages such as python or java is needed.
Are you interested? Contact us and we will get in touch with you.
The SQL training is split in 4 days. Click below to see a detailed description of each class:
In this training we will discuss basic concepts behind relational databases and learn how to structure data in a relational manner. We will take an in-depth look into the techniques of creating a well-defined relational data model. We will then learn how to create these data structures in a relational database. Data Manipulation, transactions and access management is also discussed in this training.
The training includes theory, demos, and hands-on exercises. After this training you have gained knowledge about:
This training will teach you how to retrieve data using SQL. Among other things, it will cover SQL joins and aggregations, which participants must use to answer questions about a sample database containing DVD rental data during the practice session.
The training includes theory, demos, and practical exercises. After this training you will have gained knowledge about:
This training introduces participants to data warehousing and ETL (extract, transform, load) processes. Typical data warehouse schemas such as the star and snowflake model are discussed. ETL goals and data quality concerns are covered and illustrated via hands-on exercises.
The training includes theory and hands-on exercises. After completing this course, you will be able to do the following:
PowerBI is a Microsoft business analytics service that delivers insights to enable fast and informed decisions. In this lesson, we will present the main BI tools and some data visualization essentials. Furthermore, we will work on several hands-on exercises using the PowerBI Software.
After this training you will have gained knowledge about:
info.nl@eraneos.com
KvK nr. 02070702
BTWnr. NL813364103B01
Terms and Conditions
Privacy Statement (English)
Privacy Verklaring (Dutch)