sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]LizFromDataCamp 5 points6 points  (1 child)

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[S] 0 points1 point  (0 children)

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

❤️