Calculated Columns (IF, CASE, YEAR, CURYEAR)

Prev Next

Ask Questions (on Discord)
Write Course Review

Calculated Columns (IF, CASE, YEAR, CURYEAR)

In this lecture, we will cover,

1. What are computed or derived columns?
2. IF and CASE statement
3. SQL inbuilt functions such as YEAR, CURDATE, etc.

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