fbpx




SQL Training

SQL Training

Due to the COVID-19 our training courses will be taught via an online classroom.

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.

 

Get in touch for more information

Fill in the form and we will contact you about the SQL training:

Academy: SQL
I agree to be contacted *

About the training & classes

The SQL training is split in 4 days. Click below to see a detailed description of each class: 

 
 
Relational Databases: I

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:

  • Relational databases in general
  • Relational Data Modeling & Normalization
  • SQL
  • Data Definition language (postgres as an example)
  • Data Manipulation language (postgres as an example)
  • Data Control language (postgres as an example)
  • Transactions
Relational Databases: II

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:

  • SQL SELECT statements with filters, sorting, etc.
  • SQL joins, left, right, inner, outer (why do all of these exist?)
  • SQL aggregations
  • Indexes used to speed up query execution
  • SQL Views
  • Database connectivity (JDBC and ODBC)
ETL & Datawarehouses

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:

  • Understand what ETL is and what purpose it serves
  • Describe the various stages in the ETL process
  • Understand what data quality dimensions exist
  • Understand what metadata is and how it relates to the ETL process
  • Have some basic understanding of what a Data warehouse is
  • Describe what data modelling techniques are used in a typical Data warehouse
PowerBI

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:

  • BI Tools
  • Data visualizations essentials
  • Power BI installation
  • Power BI demo example in detail, including:
  • General overview of PowerBI
  • Data connections
  • Pie Charts
  • Bar diagrams
  • Bubble plots
  • Time series plots
  • Data on maps
  • Drilling vs Next level
  • New column vs measure
  • Custom Visuals
  • Running R code in PowerBI
  • Running Python code in PowerBI