SQL Data Wrangling-Intermediate-Sub-Querying Data Hands-On

Learning Objectives

Be able to perform JOINS between tables

Be able to perform GROUP and aggregations on data

Be able to understand how HAVING clause works

Understanding CTE as great method for sub-querying

Be able to implement Sub-querying and Common Table Expressions

Overview

Amazon has been successful in adopting SQL as a go to tool for data processing. The features of SQL which makes it an undeniable choice are :

Write the way you think - Logical and English like statements
Much faster to code to process data whether text or date processing

As SQL gets popular in Amazon, the demand for more and more complex reporting is growing. The requirements are varying and the time to deliver is shortening.

In this self-paced and hands-on module, you'll move to the Intermediate level of SQL where you'll discover how to work across multiple tables, how to summarize data and how to chain more than one outcomes in sequence to produce more and more complex results

Prerequisites

Understanding of different types of JOINs
Understand How to aggregate Data
Knowledge of when to use CTEs v/s sub-queries
Understanding of filtering the Data using WHERE and HAVING clause