Product Management GlobalMart

Learning Objectives

Be able to perform JOINS between tables

Be able to understand how HAVING clause works

Be able to perform GROUP and aggregations on data

Be able to implement Sub-querying and Common Table Expressions

Understanding CTE as great method for sub-querying

Overview

SQL is a powerful tool for data analysis as it allows users to focus on the analysis itself, rather than the mechanics of how to retrieve the data.

In this scenario, we will ponder over how SQL is used for managing and manipulating data stored in relational databases and how it allows users to easily retrieve, sort, filter, and aggregate large amounts of data.

Prerequisites

SQL Data Wrangling-Basic