SQL Practitioner
 

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

With this training you will receive in-depth knowledge from industry professionals, test your skills with hands-on assignments & demos, and get access to valuable resources and tools.

Even after 45+ years SQL still remains a crucial tool. During this training you will get an understanding of SQL, ETL and BI, so you can integrate your work with the rest of your organization.

The SQL classes are perfect for companies of all sizes that want to close the data gap and train their employees. You can follow the schedule below in our offices or contact us for a tailor-made program that meets your needs.

Are you interested? Contact us and we will get in touch with you.

Close the Gap with this SQL Training

Fill in the form and we will contact you:

* These fields are required.

What you will learn

Participants in this training typically have roles like or comparable to Junior/trainee software engineer or data engineerIn order to get most value out of the training, participants should have a basic knowledge of Python and PySpark

During this training you will learn:

  • How to structure data and the techniques;
  • About data warehouses and the ETL processes;
  • Work with PowerBI and visualisation.

After the training you receive a Certificate of Completion. 

Training Dates

This training consists of 4 Classes and the content of the classes is connected. Join the SQL Training on one of these dates in our office or contact us for a tailored training:

Class

  • RDBMS (SQL) 1
  • RDBMS (SQL) 2
  • ETL & Data Warehouses
  • PowerBI
 

Available Dates

March 06, 2020  |  June 26, 2020
April 03, 2020  |  July 24, 2020
May 01, 2020  |  August 14, 2020
July 17, 2020  |  October 23, 2020

Description of the Classes

Relational Databases (RDBMS) 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 (RDBMS) 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 & Data Warehouses

This training introduces participants to data warehousing and ETL (extract, transform, load) processes. Typical data warehouse schema’s 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

For more information or to book your training

Are you interested in the SQL Practitioner training or do you have questions? Fill out the form and we will contact you personally.