DataCamp
DataCamp Logo

Data-Driven Decision Making in SQL 

  • Offered byDataCamp

Data-Driven Decision Making in SQL
 at 
DataCamp 
Overview

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

Duration

4 hours

Mode of learning

Online

Difficulty level

Intermediate

Official Website

Go to Website External Link Icon

Credential

Certificate

Data-Driven Decision Making in SQL
 at 
DataCamp 
Highlights

  • Earn a certificate after completion of the course
  • Learn from the industry best faculty
Details Icon

Data-Driven Decision Making in SQL
 at 
DataCamp 
Course details

Who should do this course?

Business Analysts

Data Analysts and Data Scientists

Managers and Executives

Developers

What are the course deliverables?

Introduction to SQL and Data-Driven Decision Making

Basic SQL Queries

Advanced SQL Techniques

Data Transformation and Cleaning

Building Analytical Models in SQL

Visualization and Reporting

More about this course

In this course, you will learn how to use SQL to support decision making. It is based on a case study about an online movie rental company with a database about customer information, movie ratings, background information on actors and more

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

Data-Driven Decision Making in SQL
 at 
DataCamp 
Curriculum

Introduction to business intelligence for a online movie rental database
Introduction to data driven decision making
Exploring the database
Exploring the table renting
Filtering and ordering
Working with dates
Decision Making with simple SQL queries
Grouping movies
First account for each country.
Average movie ratings
Average rating per customer
Joining movie ratings with customer data
Data Driven Decision Making with advanced SQL queries
Data Driven Decision Making with OLAP SQL queries
OLAP: CUBE operator
Groups of customers
Categories of movies
Analyzing average ratings

Other courses offered by DataCamp

– / –
26 hours
– / –
– / –
39 hours
– / –
– / –
4 hours
Beginner
– / –
4 hours
Intermediate
View Other 46 CoursesRight Arrow Icon
qna

Data-Driven Decision Making in SQL
 at 
DataCamp 

Student Forum

chatAnything you would want to ask experts?
Write here...