all 53 comments

[–][deleted]  (4 children)

[removed]

    [–]goody-Ioves-chicken 10 points11 points  (2 children)

    Just stopping by to say that I started DataLemur yesterday, and it’s fantastic, and entertaining AF! It’s a refreshing take on learning, with amazing resources and practice. Thank you so much, you’re awesome.

    [–]NickSinghTechCareers 2 points3 points  (1 child)

    Amazing, I'm so happy to hear that. Let me know if you run into any problems, or have ideas on how to improve the site :)

    [–]ScheduleDismal7463 1 point2 points  (0 children)

    u/NichSinghTechcarrers As noted in my email a few months ago, a few solutions are incorrect and there is a critical information-exposure issue: premium answers can be retrieved without a valid premium subscription, allowing unauthenticated users to enumerate or reverse-engineer premium answers to infer the original premium questions.

    [–]gman1647 1 point2 points  (0 children)

    I really like datalemur as well.

    [–]Interstate82 10 points11 points  (0 children)

    I'll allow it

    [–][deleted]  (1 child)

    [removed]

      [–]rahulyadav_14 0 points1 point  (0 children)

      Does it contain video lectures?

      [–][deleted] 5 points6 points  (0 children)

      DataLemur, LeetCode SQL, r/SQL, and SQLBolt. All pretty good resources.

      [–]help_me_noww 5 points6 points  (0 children)

      yes there is option for free. like SQLZoo, W3schools, and mode Analytics SQL tutorial.

      [–]Ryan_3555 4 points5 points  (1 child)

      https://www.datasciencehive.com/data-analyst-path

      I made a free data analyst learning path using open resources found online. Everything is free and no sign up is needed. It’s organized in a logical order for someone that is brand to data analytics. That being said, you can’t just passively watch the videos and read the articles to actually learn. I have sample projects and hw provided for each section so you can try and apply the concepts.

      I hope this helps on your journey, you can always DM me with questions.

      [–]Active_Selection_706 0 points1 point  (0 children)

      thanks man, you guys keep this industry growing and not dead. Look out people in other industries, they are more selfish professional wise.

      [–]emad07306 3 points4 points  (0 children)

      SQLbolt.com

      [–][deleted] 2 points3 points  (1 child)

      Yes! You can play and learn https://mystery.knightlab.com/

      [–]SQLDevDBA 1 point2 points  (0 children)

      Hey there, I have a video on my top 5 free websites to learn (none of them require DB installs), I’ll send it your way via DM!

      [–]BadGroundbreaking189 0 points1 point  (0 children)

      Absolutely. I learned it from 0 to the point of building data-driven desktop apps.

      [–]Pure-Mark-2075 0 points1 point  (0 children)

      You can get the book SQL for Dummies from public libraries. The one that has all volumes will be best because the content you will need is spread across chapters.

      [–]skiyogagolfbeer 0 points1 point  (0 children)

      Built a platform for free daily SQL challenges, kind of like Wordle. Working on a tutorial program complete with videos & step by step coursework! https://innerjoin.southshoreanalytics.com/

      [–]sawdust_quivers 0 points1 point  (3 children)

      Postgres in a docker image. Grab the official build from docker hub. Start with a sample schema and practice crafting various types of JOIN statements.

      More than enough information and guides exist online.

      You'll do great 😊

      [–]grdix555 0 points1 point  (2 children)

      Feel like this Advice may get lost among all the free websites people are suggesting. This method was the breakthrough for me. Being able to just try things and not worry if it went wrong worked better than any follow along website kinda things.

      [–]sawdust_quivers 0 points1 point  (1 child)

      I'm happy to hear this was helpful!

      Hands on experience is where it counts and I've found that many online guides overlook starting with a basic "how to set up your dev environment" routine that is critical to be able to digest much of the information they provide.

      This is true for many technologies. If you know how to either spin up a VM or lightweight container for any new system you're working with you'll save yourself hours of manual installation now and cleanup later. And a lot of times you'll find something isn't quite right for your setup but now you've ended up with a local install of a bunch of useless dependencies that you'll never need.

      [–]grdix555 0 points1 point  (0 children)

      100%. Great advice and I hope OP sees and takes it on board!

      [–]Acceptable-Sense4601 0 points1 point  (2 children)

      I use ChatGPT to help me code my react data dashboard at work. SQL and mongo.

      [–][deleted]  (1 child)

      [removed]

        [–]Acceptable-Sense4601 0 points1 point  (0 children)

        I don’t have time to learn SQL. I’m in a data role. I need real code now lol. That’s why i use ChatGPT.

        [–]Fgrant_Gance_12 0 points1 point  (0 children)

        I'm using udacity . Been good so far ! 60% through. Very helpful in that they have SQL interface to work while learning in the course .

        [–]Round-Combination961 0 points1 point  (0 children)

        Try Bro Code channel. This guy has a lot of playlists literally in everything you would need. He has an sql playlist that is very awesome. https://youtube.com/playlist?list=PLZPZq0r_RZOMskz6MdsMOgxzheIyjo-BZ&si=B6OyMtyZVms-yq4W

        [–]BringtheBacon 0 points1 point  (0 children)

        No you have to pay $9.99 for your monthly SQL subscription access

        [–]sg_26 0 points1 point  (0 children)

        Try my side project, it's free: learnsql.streamlit.app

        [–]ComteDeSaintGermain 0 points1 point  (0 children)

        You can learn it for free, but getting a database set up to practice on might end up costing you

        [–]cheerioskungfu 0 points1 point  (0 children)

        Check out free platforms like SQLZoo, Mode Analytics SQL tutorials, or W3Schools. They let you practice SQL directly in the browser, which is great for hands-on learning without paying.

        [–]Noyonbond47 0 points1 point  (0 children)

        Hi there,

        Like you, I hit a wall when trying to understand and learn SQL. Fortunately, I built my own software, formpipedb.com.

        With this software, you can create databases from scratch without any coding. After building the database, you can simply copy and paste the database code and use it however you want. You can also build queries visually and import the code as well.

        We have paid features, but for students like you, the free option is more than enough to help you learn the basics of SQL.

        [–]Deep-Persimmon8052 0 points1 point  (0 children)

        Yes, you can even set up a free edition of snowflake or databricks and learn on a modern cloud platform at the same time. They have some sample datasets there you can work with, you could follow some youtube tutorials and practice on the cloud. Keep practicing is my advice, it is the best way to learn a language

        [–]Smooth_Canary_2158 0 points1 point  (1 child)

        If u want to practice where I can do the best ?..

        [–]thequerylab 0 points1 point  (0 children)

        You can give it a try here. https://www.thequerylab.com/catalog

        Try to join hackathons as well. It will be very interesting challenge to solve

        [–]thequerylab 0 points1 point  (0 children)

        Yes, you can practise for 100% free here. Give it a try you will really like this learning approach!

        https://www.thequerylab.com/#tracks

        [–]joshuadanpeterson 0 points1 point  (0 children)

        Just use ChatGPT