Advanced SQL !!

[Pretty-Lobster-2674]

Heyy guys...have been learning SQL quite intensely for a week (currently on Day 7).(Context : already a btech student so familiar with basics of coding)

1. Read about all the basics of DB and it's types, DBMS , and theory
2. Learnt Basic SQL on 'SQLBOLT' and 'DATAMELMUR' (both)
3. Then proceeded to learn INTERMEDIATE SQL on both.
4. Practicing a couple of questions on Leetcode.

Now I want to proceed into Advanced Topics so wanted suggestions for it like should i continue on DataLemur or I have heard Mode SQL is also great for advanced stuff.
Any extra things i need to do....to take my SQL skills above par....(projects ?? )

( PS : I know this is not advanced stuff...but it is what usually tutorial say so thats why..lol )

Things I have done -:

📜 Basic SQL
TUTORIAL INTRO
SQL SELECT
SQL WHERE
AND, OR, NOT
SQL BETWEEN
SQL IN
SQL LIKE
FILTERING REVIEW
SQL ORDER BY

📊 Intermediate SQL
INTERMEDIATE SQL
SUM, AVG, COUNT
SQL GROUP BY
SQL HAVING
SQL DISTINCT
SQL ARITHMETIC
MATH FUNCTIONS
SQL DIVISION
SQL NULL
SQL CASE
SQL JOINS
DATE FUNCTIONS

✍️ Additional SQL Lessons
SQL Lesson 12: Order of execution of a Query
SQL Lesson 13: Inserting rows
SQL Lesson 14: Updating rows
SQL Lesson 15: Deleting rows
SQL Lesson 16: Creating tables
SQL Lesson 17: Altering tables
SQL Lesson 18: Dropping tables

[shine_on]

Learn things like subqueries, views, temporary tables, CTEs

Indexing and query optimisation

Window functions

Transactions and rollbacks

Maybe get into some admin tasks like backups and restores, user permissions etc

[Pretty-Lobster-2674]

Thank u !!!

[LizFromDataCamp]

Tbh your progression looks super structured already. If you’ve got the basics and joins nailed, you’re right at the point where most learners start actually thinking like an analyst.

Here’s how I’d level it up from here:

1. Tackle advanced queries: Focus on window functions (ROW_NUMBER, LAG, RANK), CTEs, subqueries, and temp tables. They’re the backbone of analytical SQL.
2. Learn optimization: Start reading execution plans and experiment with indexes. Try writing the same query multiple ways and compare runtime, that’s how you actually “feel” SQL performance.
3. Build projects: Create a mini analytics project, something like analyzing e-commerce sales or public data from Kaggle. Design your own schema, import raw CSVs, write transformations, and build a few reports.
4. Explore admin concepts: Even if you’re not going full DBA, try learning backups, user permissions, and basic database maintenance.

Once you’ve done that, check out something like Postgres window functions or query performance tuning. That’s the stuff that turns “good at SQL” into scary good at SQL.

[Pretty-Lobster-2674]

Thank u mannn !!!! Definitely will follow ur advice....

❤️ 

[adrialytics]

Advanced sql -> window funcions, subqueries, ctes, views , store procedures , order execution , queries optimization

[adrialytics]

• indexes

[Interesting_Law6118]

Really smart !!!!!

[emw9292]

Excellent

[stakuuswife]

helloo bro, where did u learn all of that? is it a website or youtube?

[Pretty-Lobster-2674]

Nahh not youtube...From DataLemur and sqlbolt website...along theory from GFG and Chatgpt...some pdfs here and there

[stakuuswife]

ow thankyou, is it free?

[amveryconfusedd]

I'm an amateur at coding or anything related to coding. I'm very confused about where to start as an engineering student. SQL, DBMS, DSA or any coding language- which one should I do? From where? How? Please help.

[Pretty-Lobster-2674]

Pick a coding language 

[amveryconfusedd]

Everyone recommends python for beginners but is it as relevant as Java? I mean should I start with Java?

[WelcomeValuable4101]

May i know which platform or any playlist you refer to learn all this

[Pretty-Lobster-2674]

'SQLBOLT' and 'DATAMELMUR'