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

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)

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 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