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.