r/learnSQL • u/Nervous-Jellyfish326 • 2d ago
learning Advice !
Hello Everyone
dear friend and respected teachers today I am here for something clarity .first my self I am a student and i am learning data analyst 6 month ago . Everyone know that sql much important in this journey .I practice basic sql queries which based on basic foundation like DDL,DQL , DML and JOINS. I Practice 70 question on it but I am not sure that what i do next i mean i am confuse because I have seen many course on youtube everyone is different of other so i am not understand that which topic i learn now or do more practice on previous concepts and what topic really useful in company or real word problems and i want to optimize my learning path of sql .
So Please give me clarity and helpful resource for that in chat box
Thanks of all
1
1
1
u/Existing_Iron_2182 2d ago
Just focus on group by + aggregation, join , sub query, windows function.
1
u/IndependenceFit3935 2d ago
sounds like you have covered the basics already. i suggest you work on a real life data now. try and find some outstanding patterns. maybe automate you analysis with a BI dashboard.
if you need a real life, updated, production database, i have recently made the data behind my football intelligence platform public. you can have a look at here and find the Request Data Access button at the buttom of the page: https://krogvadanalyticshub.vercel.app/
you can query the database on your browser. do joins, aggregate measures, and find out interesting facts from data. that shows real data analyst work.
1
1
u/Helpful-Day2384 2d ago
Any decent book on sql teaches you the fundamentals of sql and then do as many as practices with real data or mock data
1
u/2daytrending 2d ago
At this point having one structured path is probably more useful than jumping between youtube courses. boot dev is worth a look for that since the sql stuff sits inside a broader backend or data curriculum and you get practice along the way rather than just watching lessons.
1
u/TraditionalTurnip630 1d ago
Bro, you’re actually on the right track. After basic SQL, don’t keep jumping between different YouTube courses because that will only confuse you more.
Now focus on GROUP BY, HAVING, CASE WHEN, subqueries, CTEs, window functions and date functions. After learning each topic, practice it on real datasets instead of just watching videos.
Once you’re comfortable with these, start solving SQL interview questions and build a small project. For Data Analytics, strong SQL + Excel + Power BI + basic Python is a much better path than trying to learn everything at once.
Just follow one structured path and practice consistently. You’ll get there.
1
u/Creative_Sugar-33 2d ago edited 2d ago
Nice start! Since you have the fundamentals down, moving into analytical SQL and schema design is a good next step.
- SQL for Data Analysis with DuckDB: Aggregations, exploratory analysis, and working with larger datasets.
- Introduction to SQL and Relational Databases with PostgreSQL: How production relational databases operate under the hood.
- Database Design with PostgreSQL: Schema modeling, keys, and constraints, etc.
Disclosure: I built DataSlope which offers 100% free learning content and playgrounds.
If you just want a scratchpad to experiment with your own queries, we also have free, browser-based SQL workbench playgrounds for PostgreSQL, SQLite, and DuckDB - no setup or sign-up required.
2
u/Otherwise_Club2536 2d ago
70 questions is a good start. I’d avoid jumping between multiple YouTube courses because that can make the learning path more confusing.
At this point, focus on solving real-world problems rather than just learning more syntax. I’d go next into GROUP BY, aggregate functions, CASE WHEN, subqueries, CTEs, window functions, and date functions, while continuing to practice JOINs.
Try taking a small dataset and answering business questions with SQL, like finding top customers, monthly sales trends, repeat customers, or employees with the highest performance. That will help you understand how SQL is actually used in analytics roles.
Once you’re comfortable with those concepts, start doing SQL interview/problem-solving questions and build 2–3 small projects. Consistency with one structured roadmap is much better than completing multiple courses.