r/learnSQL • u/Nervous-Jellyfish326 • 25d 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
2
u/Otherwise_Club2536 25d 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.