Enqurious LogoTM

Use coupon code 'ENQSPARKS25' to get 100 credits for FREE

0
0
Days
0
0
Hours
0
0
Minutes
0
0
Seconds
Go back

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

5 Inputs
1 Hour
Beginner
scenario poster
Industry
e-commerce
Skills
data-wrangling
Tools
sql

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