Writing Basic SQL Queries

Lesson
Materials

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.