My SQL

JUST COMPLETELY REDONE! Master SQL, Work With Complex Databases, Build Reports, and More!

Bestseller

Created by

The Scholar

Last updated August 13, 2025 90 lessons 100% positive reviews

About the course

What you’ll learn

Create your own database or interact with existing databases
Write complex SQL join queries across multiple tables
Master MySQL 8 Window Functions (LEAD, LAG, RANK, etc.)
Model real-world data and generate reports using SQL
Answer company performance or sales questions using data
Learns the ins and out of MySQL 8.x syntax

Explore related topics

Course content

Curriculum

24 Sections
90 Lessons
20 Weeks

Expand all sectionsCollapse all sections

Data Warehouse Basics
4
- 1.1
  What is a Data Warehouse?
  20 Minutes
- 1.2
  OLTP vs OLAP
  20 Minutes
- 1.3
  ETL vs ELT Concepts
  20 Minutes
- 1.4
  Data Lake vs Data Warehouse
  20 Minutes
Data Modeling
3
- 2.1
  Dimensional Modeling
  20 Minutes
- 2.2
  ER Modeling vs Star Schema vs Snowflake Schema
  20 Minutes
- 2.3
  Fact Table & Dimension Table
  20 Minutes
Schemas
3
- 3.1
  Star Schema
- 3.2
  Snowflake Schema
- 3.3
  Advantages and Disadvantages
Normalization & Denormalization
3
- 4.1
  1NF
- 4.2
  2NF
- 4.3
  3NF
Slowly Changing Dimensions (SCD)
0
Fact Table Types
6
- 6.1
  Additive Facts
- 6.2
  Semi Additive Facts
- 6.3
  Factless Facts
- 6.4
  Additive Facts
- 6.5
  Semi Additive Facts
- 6.6
  Factless Facts
Dimension Types
4
- 7.1
  Conformed Dimension
- 7.2
  Junk Dimension
- 7.3
  Degenerate Dimension
- 7.4
  Role Playing Dimension
ETL Concepts
3
- 8.1
  ETL Overview
- 8.2
  Extraction, Transformation, Loading Steps
- 8.3
  ETL Pipeline Design Principles
Introduction to MySQL
5
- 9.1
  MySQL Architecture
- 9.2
  Client
- 9.3
  Server Model
- 9.4
  Storage Engines (InnoDB vs MyISAM)
- 9.5
  Installation & Setup
Database Basics
3
- 10.1
  Database & Table Creation
- 10.2
  Datatypes
- 10.3
  Constraints (Primary Key, Foreign Key, Unique, Not Null, Default, Check)
Basic SQL Queries
5
- 11.1
  SELECT Statement
- 11.2
  Filtering with WHERE
- 11.3
  ORDER BY
- 11.4
  DISTINCT
- 11.5
  LIMIT / OFFSET
Functions and Operators
5
- 12.1
  Aggregate Functions (SUM, AVG, COUNT, MIN, MAX)
- 12.2
  String Functions
- 12.3
  Date & Time Functions
- 12.4
  Mathematical Functions
- 12.5
  CASE WHEN Logic
Joins and Set Operations
8
- 13.1
  INNER JOIN
- 13.2
  LEFT JOIN
- 13.3
  RIGHT JOIN
- 13.4
  FULL OUTER JOIN
- 13.5
  CROSS JOIN
- 13.6
  UNION
- 13.7
  UNION ALL
- 13.8
  INTERSECT / EXCEPT
Subqueries & Nested Queries
3
- 14.1
  Scalar Subqueries
- 14.2
  Correlated Subqueries
- 14.3
  EXISTS vs IN vs JOIN
Advanced SQL Queries
6
- 15.1
  Common Table Expressions (CTE)
- 15.2
  Window Functions (ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG, NTILE)
- 15.3
  Recursive CTE
- 15.4
  Derived Tables
- 15.5
  Framing
- 15.6
  Partition By
Data Manipulation (DML)
4
- 16.1
  INSERT
- 16.2
  INSERT INTO SELECT
- 16.3
  UPDATE
- 16.4
  DELETE
Data Definition (DDL)
4
- 17.1
  CREATE
- 17.2
  ALTER
- 17.3
  DROP
- 17.4
  TRUNCATE
Transaction Management
2
- 18.1
  COMMIT
- 18.2
  ROLLBACK
Views
2
- 19.1
  CREATE VIEW
- 19.2
  CREATE OR REPLACE VIEW
Indexes
5
- 20.1
  Clustered Index (Primary Key)
- 20.2
  Non-Clustered Index (Secondary Index)
- 20.3
  Composite Indexes
- 20.4
  BTree
- 20.5
  Hash Index
Stored Procedures (PL/SQL equivalent)
4
- 21.1
  CREATE PROCEDURE
- 21.2
  IN, OUT, INOUT Parameters
- 21.3
  Control Flow (IF, CASE, WHILE, LOOP, REPEAT)
- 21.4
  Error Handling
Functions
3
- 22.1
  CREATE FUNCTION
- 22.2
  RETURN Statement
- 22.3
  Deterministic vs Non-Deterministic Functions
Triggers
3
- 23.1
  BEFORE INSERT/UPDATE/DELETE
- 23.2
  AFTER INSERT/UPDATE/DELETE
- 23.3
  Use Cases and Best Practices
Cursors
2
- 24.1
  DECLARE Cursor
- 24.2
  OPEN, FETCH, CLOSE

Instructor

The Scholar

1 Student11 Courses

Follow

₹7,000.00

The Scholar 10 Months 20 weeks 100% positive reviews Unlimited 90 lessons Language: English Skill level All levels

Courses you might be interested in

Deep Learning & AI

The Scholar

Learn to build Deep Learning models in Python with guidance from experienced Machine Learning and Data Science experts, complete with ready-to-use code templates.

42 Lessons

₹7,000.00

Start Learning

Advance Excel

The Scholar

All-in-One Excel Training: Enhance your skills with hands-on projects and real-world applications, covering Excel versions from 2007 to 2024.

80 Lessons

₹7,000.00

Start Learning

ChatGPT

The Scholar

ChatGPT Artificial Intelligence (AI) is transforming the way we work. Harness the power of ChatGPT AI to assist you in countless ways with the latest ChatGPT 4o.

29 Lessons

₹7,000.00

Start Learning

Machine Learning

The Scholar

Master the theory, practice, and mathematics behind Data Science, Machine Learning, Deep Learning, and NLP through comprehensive end-to-end projects.

41 Lessons

₹7,000.00

Start Learning

About US

Leadership Team

Career

Gallery

Certification & Awards

Contact us

Artificial Intelligence & ML

Generative AI & GPT

Big Data & Cloud

What We Serve

Who We Serve

PG Certifications

More

Our Recruitment Service

My SQL

Bestseller