Data-Driven Decision Making in SQL
- Offered byDataCamp
Data-Driven Decision Making in SQL at DataCamp Overview
Duration | 4 hours |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website |
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
Data-Driven Decision Making in SQL at DataCamp Course details
Business Analysts
Data Analysts and Data Scientists
Managers and Executives
Developers
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
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
Exploring the table renting
Filtering and ordering
Working with dates
Average movie ratings
Average rating per customer
Frequent customers
Movies with rating above average
Correlated nested queries