Phase 7: SQL & Database Mastery
Days 91–108 | 18 Lessons
Master SQL from DDL/DML fundamentals to advanced features like stored procedures, triggers, CTEs, and performance tuning for production systems.
Lessons in This Phase
| Day | Title | Description |
|---|---|---|
| 91 | 📘 Day 91: Relational Databases | Welcome to Day 91! Today, we'll dive deep into the foundational concepts of **Relational |
| 92 | 📘 Day 92: Data Definition Language (DDL) | Welcome to Day 92! Today, we'll learn about Data Definition Language (DDL), a subset of SQL used |
| 93 | 📘 Day 93: Data Manipulation Language (DML) | Welcome to Day 93! Today, we'll learn about Data Manipulation Language (DML), a subset of SQL |
| 94 | 📘 Day 94: Data Query Language (DQL) | Welcome to Day 94! Today, we'll focus on the Data Query Language (DQL), which is used to |
| 95 | 📘 Day 95: Joins | Welcome to Day 95! Today, we'll learn about Joins, a fundamental concept in SQL for combining |
| 96 | 📘 Day 96: Subqueries | Welcome to Day 96! Today, we'll explore Subqueries, also known as nested queries or inner |
| 97 | 📘 Day 97: Views | Welcome to Day 97! Today, we'll learn about Views, which are virtual tables based on the |
| 98 | 📘 Day 98: Indexes | Welcome to Day 98! Today, we'll learn about Indexes, a crucial performance-tuning feature in |
| 99 | 📘 Day 99: Transactions | Welcome to Day 99! Today, we'll learn about Transactions, a sequence of operations performed as |
| 100 | 📘 Day 100: Stored Procedures | Welcome to Day 100! Today, we'll learn about Stored Procedures, which are prepared SQL code that |
| 101 | 📘 Day 101: Triggers | Welcome to Day 101! Today, we'll learn about Triggers, which are special stored procedures that |
| 102 | 📘 Day 102: Common Table Expressions (CTEs) | Welcome to Day 102! Today, we'll learn about Common Table Expressions (CTEs), a temporary result |
| 103 | 📘 Day 103: Pivoting Data | Welcome to Day 103! Today, we'll learn about Pivoting Data, a technique used to transform data |
| 104 | 📘 Day 104: Database Design and Normalization | Welcome to Day 104! Today, we'll cover the important topics of Database Design and |
| 105 | 📘 Day 105: JSON in SQL | Welcome to Day 105! Today, we'll explore how to work with JSON (JavaScript Object Notation) data |
| 106 | 📘 Day 106: XML in SQL | Welcome to Day 106! Today, we'll explore how to work with XML (eXtensible Markup Language) data |
| 107 | 📘 Day 107: SQL Security | Welcome to Day 107! Today, we'll discuss SQL Security, a critical topic for protecting your |
| 108 | 📘 Day 108: SQL Performance Tuning | Welcome to Day 108! Today, we'll discuss SQL Performance Tuning, the process of optimizing your |