Learn with Osru

Day 9 of the SQL journey! Today's about advanced querying -

📄 Full Document: https://www.notion.so/10-Days-Of-SQL_-Day-9-310c6c9af0b58028a52cf601cd3af4ec?source=copy_link

Covered today:
• Single value subqueries (MAX, MIN, AVG)
• Multiple value subqueries (IN, NOT IN)
• Subqueries in SELECT and FROM

Note: I'm a student documenting my process, not a pro. If you spot any mistakes, let me know kindly! ❤️

One more day to go - Day 10 tomorrow!

Day 8 of my SQL journey! Today's the game-changer - connecting multiple tables to unlock powerful insights.

📄 Full Document: https://www.notion.so/10-Days-Of-SQL-_-Day-8-30fc6c9af0b580a59ed1c8af15235a56?source=copy_link

Covered today:
• INNER JOIN - matching data from both tables
• LEFT JOIN - all data from left table
• RIGHT JOIN - all data from right table

Note: I'm a student documenting my process, not a pro. If you spot any mistakes, let me know kindly! ❤️

See you for Day 9 tomorrow!

Day 7 of the SQL journey! Today we're grouping data and analyzing each group separately .

📄 Full Document:
https://www.notion.so/10-Days-Of-SQL_-Day-7-307c6c9af0b580e3b0fbd7ad5855610e?source=copy_link
Covered today:
• GROUP BY - creating data groups
• Multiple aggregate functions per group
• Grouping by multiple columns
• HAVING - filtering groups (not rows!)
• WHERE vs HAVING - when to use which

Note: I'm a student documenting my process. If you spot any mistakes, let me know kindly! ❤️

See you for Day 8 tomorrow!

Celebrating the power of our roots and the language that defines us.

تَقَبَّلَ اللّٰهُ صِيَامَكَ وَقِيَامَكَ وَجَعَلَكَ مِنَ الْفَائِزِينَ
Taqabbalallahu siyamaka wa qiyamaka wa ja‘alaka minal fa’izin.
May Allah accept your fasting and prayers and grant you success

Day 6 of the SQL journey! Today we will learn about calculating totals, averages, and finding insights.

📄 Full Document: https://www.notion.so/10-Days-Of-SQL_-Day-6-30bc6c9af0b580c3995df5f71cb5b3bd?source=copy_link

Covered today:
• COUNT - counting rows and unique values
• SUM - adding up numbers
• AVG - calculating averages
• MAX - finding maximum values
• MIN - finding minimum values

Note: I'm a student documenting my process, not a pro. If you spot any mistakes, let me know kindly! ❤️

See you for Day 7 tomorrow!

Day 5 of the SQL journey! Today we're making our data look organized and professional.

📄 Full Document: https://www.notion.so/10-Days-of-SQL-_Day-5-308c6c9af0b580ce8b9cfee30f244288?source=copy_link

Covered today:
• ORDER BY - sorting data (ascending/descending)
• LIMIT - getting top N results
• OFFSET - pagination basics
• DISTINCT - removing duplicates

Note: I'm a student documenting my process, not a pro. If you spot any mistakes, let me know kindly! ❤️

See you for Day 6 tomorrow!

Day 4 of the SQL journey! Today's topic is powerful but requires caution - changing and deleting data.

📄 Full Document: https://surl.li/mymttl

Covered today:
• UPDATE - modifying existing data
• DELETE - removing data permanently
• WHERE clause (extremely important!)

Note: I'm a student documenting my process, not a pro. If you spot any mistakes, let me know kindly! ❤️

See you for Day 5 tomorrow!

Day 3 of my SQL journey! Today we're learning how to find exactly what we need from our database.

📄 Full Document: https://www.notion.so/10-Days-of-SQL_Day3-306c6c9af0b580f4be60e81a29d68008
Covered today:
• SELECT - viewing all or specific data
• WHERE - filtering with conditions
• Comparison operators
• AND, OR for multiple conditions

Note: I'm a student documenting my process, not a pro. If you spot any mistakes, let me know kindly! ❤️

See you for Day 4 tomorrow!

Moving forward with my 10 Days of SQL journey. Today is about putting data into our tables and setting the rules to keep it accurate.

📌 Full Document: https://surl.li/plzkix
Covered today:
• NOT NULL, UNIQUE, DEFAULT constraints
• ALTER TABLE to modify existing tables
• INSERT statements (single & multiple)

Note: I’m a student documenting my process, not a pro. If you spot any mistakes, let me know kindly! ❤️

See you for Day 3 tomorrow! 📚

They say the best way to master a skill is to teach it. So, for the next 10 days, I’m documenting my SQL journey and sharing every single breakthrough with you.

Day 1: SQL Basics - Database & Table Creation
Access the full document: https://www.notion.so/303fe93818d7808db2c2c66d55e09bd2

Document Overview:
📌 Database fundamentals with relatable examples
📌 MySQL installation guide
📌 Creating your first database (step-by-step)
📌 Creating tables with different data types
📌 Primary keys and auto_increment explained
This is designed for complete beginners. Every concept is explained with examples.

Important note: I'm not a master at this. I'm learning SQL myself and documenting my journey as I go. I'm sharing what I learn in hopes that it helps fellow learners. If you spot any mistakes, please let me know with kindness

Let's grow together! 🌱