Writing Basic SQL Queries¶
As part of this section we will primarily focus on writing basic queries.
Standard Transformations
Overview of Data Model
Define Problem Statement – Daily Product Revenue
Preparing Tables
Selecting or Projecting Data
Filtering Data
Joining Tables – Inner
Joining Tables – Outer
Performing Aggregations
Sorting Data
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.