SQL Data Wrangling

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

SQL Data Wrangling-2 posterMASTERCLASS Intermediate Mentorskool

Prerequisites

Filtering Data using SQL
Sorting and Ordering Data using SQL
Fundamentals of Text-processing using SQL
Fundamentals of Date-processing using SQL
Fundamentals of Math-processing using SQL