Scribd
Upload
130 views2 pages

Master SQL in 30 Days

The document outlines a comprehensive 30-day SQL training program focused on data analysis and advanced SQL concepts. It covers essential topics such as SELECT statements, JOINs, aggregate functions, and database normalization, along with best practices for optimization. Each day is dedicated to a specific topic to facilitate structured learning.

Uploaded by

kipchumbaallan440
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
130 views2 pages

Master SQL in 30 Days

The document outlines a comprehensive 30-day SQL training program focused on data analysis and advanced SQL concepts. It covers essential topics such as SELECT statements, JOINs, aggregate functions, and database normalization, along with best practices for optimization. Each day is dedicated to a specific topic to facilitate structured learning.

Uploaded by

kipchumbaallan440
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

allinpython.

com Save This Post


@allinpython For Future

SQL for Data Analysis


Day 1: Introduction to SQL
Day 2: Understanding Databases and Tables
Day 3: SELECT Statement
Day 4: WHERE Clause and Logical Operators
Day 5: Sorting Data with ORDER BY Day 01-07
Day 6: LIMIT & OFFSET
Day 7: Aggregate Functions

SQL for Data Analysis


Day 8: GROUP BY Clause
Day 9: HAVING Clause

Day 08-14 Day 10: JOINS (INNER, LEFT, RIGHT)


Day 11: Subqueries
Day 12: Working with Case Statements
Day 13: Self-Joins
Day 14: UNION & UNION ALL
allinpython.com Save This Post
@allinpython For Future

Advanced SQL
Day 15: Understanding Indexes
Day 16: Working with Views
Day 17: Transaction Management
Day 18: Creating Stored Procedures
Day 19: Implementing Triggers
Day 15-21
Day 20: Database Normalization
Day 21: Exploring ACID Properties

SQL for Data Analysis


Day 22: Date Functions
Day 23: String Functions
Day 24: Math Functions Day 22-28
Day 25: Window Functions
Day 26: Common Table Expressions (CTE)
Day 27: Analytic Functions
Day 28: Pivot & Unpivot

SQL Best Practices and Optimization


Day 29: Index Optimization
Day 29-30
Day 30: Query Performance Tuning

You might also like