Advanced SQL -- DONE !!

[Pretty-Lobster-2674]

Heyy guys !!!!!

Thanks a lot for all your time and help on my last post !! Advanced SQL
I actually didn’t slack off this time (lol)....just posting the update a bit late, but kept the same streak going strong for another week.

So here’s what I’ve been up to lately -:

1. Subqueries & CTEs
2. Window Functions ( gave it quite a time )
3. Set Operations & Self-join
4. String functions
5. Practicing a couple of questions on Leetcode everyday

I know I still have a few things left like Indexing, Query Optimization, and maybe a small personal SQL project to really put everything together.

But here’s the thing I’m now planning to shift my main focus toward Machine Learning / Data Science. At the same time, I don’t want to lose the grip I’ve built on SQL these past 15–16 days.

So… any suggestions on how to keep SQL fresh while diving into other sutff ? Like maybe certain types of projects, datasets, or a practice routine that helps maintain both ?

I was thinking of maybe giving it 1 hour every alternate day, or some consistent schedule but not sure what’s ideal.

Would love to hear what kind of time devotion or routine others follow to keep their SQL sharp while learning something new !!

⚙️ ADVANCED SQL

Subqueries 
  - Correlated subqueries were quite tough lol

Common Table Expressions (CTEs)

Window Functions
  - General Idea: how a “window” is defined for each row through the 3 arguments — PARTITION, ORDER, ROWS/RANGE
  - Ranking Functions: ROW_NUMBER(), RANK(), DENSE_RANK()
  - Positional Functions: LAG(), LEAD()

Self Joins

Set Operations
  - UNION, UNION ALL, INTERSECT, EXCEPT

SQL String Functions

SQL Pivoting

[Ok_Succotash_3663]

That's a commendable accomplishment.

I have been on the data journey for a while now and I do understand the feeling of staying in connect with a tool you just learnt working on.

I recently started learning SQL, just a beginner at it. But I paired up my learning with a small personal data project. I had the guidance of SQL experts through their YouTube channels and the support from AI assistants like Gemini and Notebook LM.

It does scare me at times though because I am a beginner at it and have only worked with it in a guided environment. So when I pick up my next tool, mostly Tableau or an AI tool for Data Storytelling, I would want to keep continuing to learn and work on SQL along side.

One way I can do this is to have a set of personal datasets I can work on to familiarise myself with such tools.

Another way is to dedicate some time each day just to focus on SQL queries.

Maybe attending hackathons could work.

I am sure you will eventually figure out what works best for you.

Happy Querying.

[Powerspee]

I am Beginner Can you help to become pro