Learn Data By Data Adventurers

​If you're interested in learning SQL from scratch or sharpening your skills, these sessions are for you. Here’s what I’ll be covering:

1. ​Introduction to SQL

   • ​What is SQL?

   • ​Basics: Syntax, Structure, SQL Commands (DDL, DML, DCL, TCL)

2. ​Database Design

   • ​Understanding Databases, Tables, Data Types

   • ​Primary/Foreign Keys & Normalization (1NF, 2NF, 3NF)

3. ​Basic SQL Queries

   • ​SELECT Statement, WHERE Clause, ORDER BY, LIMIT/TOP

4. ​Advanced SQL Queries

   • ​JOINs, Subqueries, Aggregation Functions (COUNT, SUM, AVG, MIN, MAX)

5. ​Data Manipulation

   • ​INSERT, UPDATE, DELETE Statements

   • ​Transactions, Rollback, NULL Handling

6. ​Indexes and Views

   • ​Creating/Using Indexes, Views & Performance Tips

7. ​Stored Procedures and Functions

   • ​Creating Procedures, Functions, Error Handling

8. ​SQL Performance Tuning

   • ​Query Optimization, Execution Plans

9. ​Advanced Topics

   • ​Triggers, Events, Dynamic SQL, Security Management

10. ​Practical Applications and Projects

    • ​Real-world case studies & building a mini-project with SQL