Hands On Training

Data-Driven Decision Making in SQL

DataCamp

(3)

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

This course is designed to teach you how to utilize SQL to make informed decisions. The course is centered around a case study involving an online movie rental company that maintains a database with various customer information, movie ratings, and actor background information. SQL queries can be used to analyze customer preferences, sales development, and more. Additionally, the course covers SQL extensions for online analysis processing (OLAP), which allow for the exploration of multidimensional aggregated data. By taking this course, you will gain valuable insights into data-driven decision-making and learn how to use SQL for data analysis effectively.

Course Overview

Virtual Labs

International Faculty

Case Based Learning

Post Course Interactions

Case Studies,Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Intermediate SQL

What You Will Learn

Learn how to analyze a SQL table and report insights to management

You will learn to apply SQL queries to study for example customer preferences, customer engagement, and sales development

This course also covers SQL extensions for online analytical processing (OLAP), which makes it easier to obtain key insights from multidimensional aggregated data

Course Content

Expand all sections

Module 1: Introduction to business intelligence for a online movie rental database

Module 2: Decision Making with simple SQL queries

Module 3: Data Driven Decision Making with advanced SQL queries

Module 4: Data Driven Decision Making with OLAP SQL queries

Course Instructors

Bart Baesens

Professor in Analytics and Data Science at KU Leuven

Bart Baesens is professor in Analytics and Data Science at the Faculty of Economics and Business of KU Leuven, and a lecturer at the University of Southampton (UK). He has done extensive research...

Tim Verdonck

Professor at KU Leuven

Tim Verdonck is a professor in Statistics and Data Science at the Department of Mathematics of KU Leuven (Belgium). He is also a visiting professor at the School of Economics, Management and Statisti...

Irene Ortner

Consultant @ Applied Statistics

Irene did her PhD in Statistics at Vienna University of Technology. During a postdoc at KU Leuven she focused in her research on fraud and anomaly detection with statistical and machine learning tool...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%