Day 30: Full SQL Revision for Data Analysts | PostgreSQL Recap from Basics to Advanced 💻🔥

Channel:

Tech With Nicks

Subscribers:

10,900

Published on July 7, 2025 6:30:24 AM ● Video Link: https://www.youtube.com/watch?v=lpjH9sX4GJU

Duration: 0:00

52 views

0

🎉 Welcome to Day 30 of my 30-Day Data Analyst Challenge!
Today is a full SQL revision day — covering everything from simple SELECTs to advanced joins, CTEs, window functions, and more using PostgreSQL 💪

🔁 Topics Revised:
✅ SELECT, WHERE, ORDER BY

✅ GROUP BY, HAVING, Aggregate Functions

✅ JOINS – INNER, LEFT, RIGHT, FULL OUTER

✅ CASE Statements

✅ CTEs (Common Table Expressions)

✅ WINDOW Functions – RANK(), ROW_NUMBER()

✅ Real-world business query practice

👨‍💻 Practiced everything in pgAdmin using project datasets like Bookstore, HR Analytics, and CRM dashboards.

📌 Tools Used: PostgreSQL + pgAdmin
📅 #Day30 of #30DayDataChallenge
📺 Channel: Tech With Nicks
🔒 All data is fictional and used only for educational purpose#Day30 #SQLRevision #PostgreSQL #TechWithNicks #30DaySQLChallenge #LearnSQL #DataAnalyst #SQLRecap #SQLInterviewPrep #DataAnalytics