🔹 Week 01 – SQL Fundamentals: DPP 01 – 02
- Built a strong foundation in SQL syntax and relational database concepts
- Practiced data retrieval using SELECT statements
- Applied filtering using WHERE, AND, OR, NOT conditions
- Used sorting and limiting with ORDER BY and LIMIT
- Improved understanding of table-based data querying
- Focused on writing clean, readable, and efficient SQL queries
🔹 Week 02 – Aggregations & Grouping: DPP 01 – 02
- Worked extensively with aggregate functions (COUNT, SUM, AVG, MIN, MAX)
- Implemented GROUP BY to summarize data
- Used HAVING for filtering aggregated results
- Solved business-style problems involving metrics and KPIs
- Strengthened analytical thinking through grouped data analysis
🔹 Week 03 – Joins & Subqueries: DPP 01 – 02
- Implemented INNER JOIN, LEFT JOIN, and RIGHT JOIN
- Combined data from multiple relational tables
- Wrote subqueries to solve nested SQL problems
- Analyzed relationships between entities in normalized databases
- Improved ability to handle real-world relational datasets
🔹 Week 04 – Advanced SQL Concepts: DPP 01
- Introduced advanced SQL problem-solving techniques
- Worked with analytical and ranking-based queries
- Developed performance-aware SQL query mindset
- Solved interview-oriented SQL questions
- Strengthened readiness for Data Analyst and SQL-based roles
🚀 Key Skills Highlighted:
- SQL
- Data Analysis
- Relational Databases
- Joins and Subqueries
- Aggregations
- Business Queries