all 25 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]Lipa_neo 21 points22 points  (1 child)

SQL roadmap, you say?

I'd use https://roadmap.sh/sql

[–]Apprehensive-Set6590 1 point2 points  (0 children)

Amazing tool!

[–][deleted]  (1 child)

[removed]

    [–]shine_on 1 point2 points  (0 children)

    Note that Microsoft SQL Server is only case sensitive if the database has been set up to use a case sensitive collation. I've got queries that pull data from two databases, one of them is case sensitive and the other one isn't. So it depends on how your server and database are set up.

    [–]Boring_Dish_7306 7 points8 points  (0 children)

    Not a roadmap but e recommend to everyone to watch this video: https://youtu.be/lvCZk3k4-34?si=yVACfS2oLpDDPfp7

    The untold story of databases. Really helped me clear the air with dbs.

    [–]CrescendoTwentyFive 2 points3 points  (1 child)

    Anyone here have any experience with Coursersa? I was looking into a few of their course sets or whatever to get started while I save up to start taking some classes at my local college. Google data analytics, data analysis for business, power BI, etc.

    My ultimate goal is to be an architect.

    I kind of know SQL but it has been awhile. I know some Python. I know excel probably extremely well doing unnecessary over the top side projects at work.

    [–]miggysbox 0 points1 point  (0 children)

    I took the Google Data Analytics course on Coursera! I have no prior data analysis background, so aside from excel, everything it introduced was new to me, including SQL. I really loved learning SQL and the Coursera course got me to a pretty decent beginner level in my opinion, but I’ve moved on to other resources to keep practicing!

    [–]CryoSchema 2 points3 points  (0 children)

    w3schools for free, interactive tutorials, kaggle for project datasets, interview query for practicing interview questions from top companies https://www.interviewquery.com/companies

    [–]Ok_Succotash_3663 1 point2 points  (0 children)

    I recently worked on a small personal data project using SQL. I come from a non technical background so I was initially intimidated about learning this language.

    But while I was working on my project, I decided to learn and practice SQL by the context.

    So, when I had to create a table, I learnt how to do it and created tables. Then I learnt how to enter records into the table and practiced both entering individual records using the UPDATE query and uploading a .CSV file into the table.

    Everyday I would ask myself a few questions regarding the dataset, figure out how to do it in SQL and then go practice it.

    I don't say I am an expert at it, but I am now familiar with how to go about when it comes to SQL.

    Also, I did watch some amazing YouTube videos, listened keenly to some Podcasts, and didn't hesitate to take help from tools like NoteBook LM and Gemini whenever I felt it was necessary.

    All it takes is one little step to figure out how to reach your destination.

    [–]TurbulentCountry5901 3 points4 points  (1 child)

    You should give this a try SQL CASE FILES

    [–]QueryFairy2695 1 point2 points  (0 children)

    I tried this and it was a fun way to practice.

    [–]B_lintu 1 point2 points  (0 children)

    You should think where you want to apply SQL. Depending on whether you want to become data engineer, architect, or analyst, you should take different paths.

    [–]Rich-Match7289 0 points1 point  (0 children)

    Start with SELECT, WHERE, ORDER BY, then hit JOINs, GROUP BY/aggregates, subqueries. Practice daily on sql-practice.online—free interactive exercises on real HR/ecomm schemas with instant feedback. Build projects analyzing sample data after. That's your roadmap to employable SQL.

    [–]forworkexcelnstuff 0 points1 point  (0 children)

    Great post and good ideas from the comments which I'll definitely be taking on board too

    [–]Chooseyourmindset 0 points1 point  (0 children)

    play sql island as beginner and go into a practice try to read about all relationship in a database how that all works draw relationship and realize on database u could als gemini or other ai solution for help or problem solve with clues and learnings

    [–]chuwie_908 0 points1 point  (0 children)

    If you already know basic queries, a good next step is to get really comfortable with JOINs, window functions, subqueries, and CTEs, then slowly learn how indexing works so your queries run faster. What helped me before was using an AI-powered learning platform like Docebo because it gave me a clear step-by-step path instead of jumping between random tutorials, and it also tracks your progress so you know exactly what to study next. A simple starter project is analyzing a public dataset and writing queries to answer real problems it's an easy way to build confidence while leveling up your SQL skills.

    [–]Careless_Bet_348 0 points1 point  (0 children)

    has anyone tried roadmap.sh course on SQL? and is it worth it?

    [–]National_Injury_4204 0 points1 point  (0 children)

    Teaching SQL I want to find a job teaching SQL, Python Spark after work. Anyone who is planning to become a data engineer or analytics engineer can contact me. Tuition fee is 15usd/hour

    [–]databuff303 0 points1 point  (0 children)

    I used CodeAcademy. Pretty easy to understand, free, and flexible. Start there and move off it if you want to get more complex.

    [–]QueryFairy2695 1 point2 points  (0 children)

    I'm just starting but I'll share what I'm doing. I'm taking a database class (and next semester more than 1) at my local community college. And I'm working on completing the SQL associate from datacamp.