As part of this section, we will primarily focus on writing basic queries.
Overview of Data Model
Define Problem Statement – Daily Product Revenue
Selecting or Projecting Data
Joining Tables – Inner
Joining Tables – Outer
Solution – Daily Product Revenue
Here are the key objectives for this section
What are different standard transformations and how they are implemented using Basic SQL?
Understand the data model using which basic SQL features are explored?
Setup the database, tables and load the data quickly
How we typically select or project the data, filter the data, join data from multiple tables, compute metrics using aggregate functions, sort the data etc?
While exploring basic SQL queries, we will define a problem statement and come up with a solution at the end.
Self evaluate whether one understood all the key aspects of writing basic SQL queries using exercises at the end.
Username or Email Address
Registration confirmation will be emailed to you.