The Data God’s Blessing

Prev Next

Peter gets a blessing from the DATA GOD 🦸‍♀️

No FAQ Available.

Contents

1. Course Overview

Who can Enroll in this Course? Any Prerequisites?

What Type of Computer do I Need for this Course?

Course Outline

2. Introduction

How Learning SQL can Help You in Your Career

Who is Peter Pandey?

Peter Pandey’s Early Life and SQL

3. SQL Basics: Data Retrieval - Single Table

Install MySQL: Windows

Install MySQL: Linux, Mac

Import Movies Dataset in MySQL

Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)

Exercise - Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)

Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)

Exercise - Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)

Summary Analytics (MIN, MAX, AVG, GROUP BY)

Exercise - Summary Analytics (MIN, MAX, AVG, GROUP BY)

HAVING Clause

Calculated Columns (IF, CASE, YEAR, CURYEAR)

Exercise - Calculated Columns (IF, CASE, YEAR, CURYEAR)

The Data God’s Blessing

Quiz

4. SQL Basics: Data Retrieval - Multiple Tables

Why do We Need Multiple Tables?

SQL Joins (INNER, LEFT, RIGHT, FULL)

Exercise - SQL Joins (INNER, LEFT, RIGHT, FULL)

Cross Join

Analytics on Tables

Join More Than Two Tables

Exercise - Join More Than Two Tables

Quiz

5. SQL Basics: Complex Queries

Subqueries

ANY, ALL Operators

Co-Related Subquery

Exercise: Subqueries

Common Table Expression (CTE)

CTE Benefits & Other Applications

Exercise: CTE

Peter Pandey Flexes his SQL Skills

Quiz

6. SQL Basics: Database Creation & Updates

Database Normalization and Data Integrity

Entity Relationship Diagram (ERD)

Mentor Talk: Art of Googling

Data Types: Numeric (INT, DECIMAL, FLOAT, DOUBLE)

Data Types: String (VARCHAR, CHAR, ENUM)

Data Types: Date, Time (DATETIME, DATE, TIME, YEAR, TIMESTAMP)

Data Types: JSON, Spatial (JSON, GEOMETRY)

Luck Favors the LinkedIn Post

Primary key

Foreign Key

Create a Database From an Entity Relationship Diagram - ERD

Import Data From a CSV File Into a Database

Insert Statement

Update and Delete

I Need a Favour

Expect the Unexpected: The Intermission Scene

Quiz

7. AtliQ Hardware & Problem Statement

The Rise of Databases at AtliQ

Relational vs No-SQL Database

AtliQ Hardware’s Business Model

Profit & Loss Statement

ETL, Data Warehouse, OLAP vs OLTP, Data Catalog

Fact vs Dimension Table, Star vs Snowflake Schema, Data Import

Simplified: What is Kanban?

Quiz

8. SQL Advanced: Finance Analytics

Backlog Grooming Meeting: Gross Sales Report

User-Defined SQL Functions

Exercise: User-Defined SQL Functions

Gross Sales Report: Monthly Product Transactions

Gross Sales Report: Total Sales Amount

Exercise: Yearly Sales Report

Stored Procedures: Monthly Gross Sales Report

Stored Procedure: Market Badge

Benefits of Stored Procedures