best way to learn sql reddit - Brave Search

How do you learn SQL

reddit.com › r › SQL › comments › 1e4ld53 › how_do_you_learn_sql

SQL Zoo first and then Data Lemur second. Then you should be good for most entry level jobs interviews. You learn the rest on the job. Answer from xxxHalny on reddit.com

reddit.com › r/sql › best way to learn sql

r/SQL on Reddit: Best way to learn SQL

March 13, 2023 -

Hi everyone

I would like to start learning SQL and I don't really know where to start. Can someone please describe me your journey on how you became proficient with the tool? I am working as a Product Manager, so some basic skills are definitely needed.

Thanks!

I will provide you some valuable tips to rapidly learn SQL and become a professional within few months Create your own database and practice on it. Solve SQL puzzles and challenges available online. Participate in online SQL communities and forums. Use online SQL tutorials and courses. Attend SQL workshops and webinars. Practice SQL queries on real-world datasets. Analyze and manipulate data from different sources. Create and use SQL stored procedures and functions. Work on SQL projects and collaborate with other SQL professionals. Follow best practices and guidelines for SQL optimization and performance. To get you started, I will highly recommend you look at these articles. They will guide you through : What you need to know to get started: https://link.medium.com/kz9qL7TtCAb 10 tips you should know: https://link.medium.com/NsrPQF1tCAb SQL query Optimization: https://link.medium.com/LwrtUV7tCAb Sql queries for complex business reports: https://link.medium.com/Cbi6fRbuCAb The power of sql case statement: https://link.medium.com/rY2G7UfuCAb Advanced SQL queries for mysql workbench series: PART 1: https://link.medium.com/Ab6QXnmuCAb PART 2: https://link.medium.com/mMo35opuCAb PART 3: https://link.medium.com/DXVhGKruCAb Understanding SQL inner join with practical examples: https://link.medium.com/8MYnwLtuCAb Unleashing the power of SQL aggregate functions: PART 1: https://link.medium.com/ZKZtBMAuCAb PART 2: https://link.medium.com/xpA0E7DuCAb PART 3: https://link.medium.com/7xKteHFuCAb PART 4: https://link.medium.com/zmMc91IuCAb

I would start with doing SQL bolt. Then watch either a YouTube series on SQL or do a Udemy course, I personally like Alex the Analyst's series, I recommend just starting with his basic and intermediate series. Whatever database system your company uses watch a couple tutorials on it, if it's something like MySQL or Microsoft SQL server you can set up an instance on your own computer at home and practice using it. Then start doing SQL problems on hackerrank, do them in the database system that you'll be using. Once you're at the point of being able to do all the basic stuff on hackerrank and some of the intermediate I would say you have a good starting grasp on SQL.

reddit.com › r/sql › how do you learn sql

r/SQL on Reddit: How do you learn SQL

July 16, 2024 -

Do you watch hours of tutorials or prefer to have a project and search for how to do the current task in a 2-5 minutes video or text - website.

Would you prefer to find a website where you see the solution ready to use like on stack overflow?

Do you prefer writing the queries from examples but by typing not copying statements?

I ask this because I'm trying to make a learn SQL video series that is watchable and so far the long video 1h talking has viewer skipping like crazy. No memes or entertaining bits every 5 seconds. Plain old desktop recording doing stuff and sharing tips from working almost 20 years with MSSQL. They're not watching it so was thinking of bite-size sql tips instead of long boring videos.

Any feedback is welcomed.

SQL Zoo first and then Data Lemur second. Then you should be good for most entry level jobs interviews. You learn the rest on the job.

Use w3 schools Sql as a reference and then sign up to places like Leetcode and analyst builder to solve challenges

Videos

r/PostgreSQL on Reddit: Learn SQL while doing typing practice

September 6, 2025

r/Database on Reddit: Explore and learn the basics of SQL via typing ...

September 6, 2025

Learn the basics of SQL while practising touch typing : r/SQL

r/learnSQL on Reddit: Is this a good resource to learn SQL? for ...

r/dataanalysis on Reddit: I made a 1 Hour SQL Course on YouTube

r/SQL on Reddit: Just finished the SQL fundamentals course on ...

reddit.com › r/learnsql › best sql course for beginners?

r/learnSQL on Reddit: Best SQL course for beginners?

October 4, 2025 -

Hi Folks,

Who has the best free step by step course/tutorial for beginners on SQL?

Go to youtube and search for 30 hour long course for beginners or find it directly at the guy's website datawithbaraa.com. It's very good.

Not a course exactly but this is a good roadmap for learning SQL from scratch: https://www.reddit.com/r/mavenanalytics/s/0MlayLqadB

reddit.com › r/sql › if you had 30 days to learn sql - how would you do it?

r/SQL on Reddit: If you had 30 days to learn SQL - how would you do it?

October 28, 2021 -

I would like some direction for learning SQL. I come from Python background (self-taught). Job application (that I want) is due in a month and requires familiarity with SQL! Thanks.

I'd suggest solving exercises on https://pgexercises.com . It has exercises with increasing levels of difficulty and also recommends books you can read to get better at SQL.

https://www.w3schools.com/sql/default.asp https://www.w3schools.com/python/python_mysql_getstarted.asp A really good site. Learn the basics here.

reddit.com › r/dataengineering › how and where did you learn sql from and become good at it?

r/dataengineering on Reddit: How and where did you learn SQL from and become good at it?

November 12, 2021 -

I want to learn and become really good at SQL (and Python too!).

This sub seems to have both DEs and SWEs. Could I get some guidance on how and from where I should learn SQL and Python to become a skilled and competent engineer?

Thank you everyone

Edit: I forgot to mention this. Most tutorials and courses seem to focus on the querying part of SQL. Where and how do I learn to design, structure and create Data and databases?

https://sqlbolt.com

I don't claim to be very good at SQL, but my advice is to take some reports from analysts and see the queries they use. From my experience analysts sometimes have to use some hacks because of bad data modelling. Here is a sample problem: Say you have login info for all users of the first 100 days of an app. How do you calculate 7d/14d/30d retention rate? How do you calculate survival rate? A second one that is easier: How do you calculate DAU by seniority (seniority can be breakdown into a few buckets)? A third one: You have a table that has three columns: userId, dateTime and userLevel. Write a query that calculates the median number of days need to reach a certain level. For Python I can't say much. We use it for pipelines but they are not difficult to write. I think the more important question is how to design a pipeline and what precautions to do.

reddit.com › r/sql › best resources to learn sql and what should i focus on to get a job?

r/SQL on Reddit: Best resources to learn SQL and what should I focus on to get a job?

September 28, 2023 -

I'm currently learning SQL in my spare time, polishing up on my Excel skills and after SQL, I want to learn PowerBI. I have NO EXPERIENCE in SQL.

Which books, mock test, website, youtube channel would you recommend? I want to learn from basic to expert level no matter how much time it takes?

You could start with the SQL section of w3schools.com. It's a big picture overview of SQL and it has some pages focused on how to accomplish things specific to different database programs. Get comfortable with that first. The rarely spoken truth is that SQL isn't very hard to pick up. Your value will largely depend on your ability to translate business logic into SQL. Practice. Pick an industry/type of business. It might be best to start with one you're very familiar with on your first run through. Set up your database environment. Securely store all the information required in your set up. Ex: authentication type, administrator account user/pass, database name, etc Gather information on what the business would need to store in a database. Ex: an animal shelter would need a pet table, a kennel/cage table, immunization/medical information table, license/tag table, a table to store people who surrender or adopt .. you get the picture. Make it as detailed as you can, if it's realistic, talk to someone in that line of work, but don't get caught up in making it perfect. 5-10 tables should be enough for the first time around. Design the tables in the database. Pay attention to data types as you go. You'll want to consider the data as it is today, and accommodate for growth. Ex: your table has a field, char(10) as the data type. The data stored is currently 10 characters long. Business needs change, and this field now needs to store 12 characters. Save yourself the headache and start with making it varchar(20) at creation. Also pay attention to keys and how you intend to join tables. I strongly advise putting primary keys on every table and setting them to auto-increment. This gives you a quick out when it comes to duplicate records. Generate data for your tables. Google "data generator" and find the one you like the best. I've used https://generatedata.com/ in the past, it's not terrible but I recall a lot of tweaking to get exactly what I needed. Research. Chances are there's something easier out there. If dropping money on it is not an issue, Regate has a SQL Data Generator for a yearly subscription price of $264. Probably easier to work with. Load your data into the database. Ideally, the data generator provided you with a SQL script that runs a bunch of inserts, one click and done. But it's possible you got a csv or Excel file. Most dbms's come with an import tool of some kind, this the perfect opportunity to learn how to use it. The rest is the fun part. Conjure up potential business scenarios your business might encounter. In the animal shelter example, a couple things might happen: animal adoption, animal surrender, kennel change, new license/tag, etc. Consider what would be most important if you needed to report on these situations, put some queries together, maybe create some views. When you're pretty comfortable with that, start looking into how you'd update data. An animal surrender wouldn't just be entering into the pet table, you'd also want to store the person who surrendered the animal and assign them a kennel. Also: retaining historical data for record changes is a valid business requirement. If it didn't come up in your original design, figuring out how to implement it is good practice. Sorry so long, but it should get you started and introduce you to some situations you're going to encounter later on. Lots of luck!

W3 schools is a great resource and it is free so you can explore all you want before focusing on ay flavor of SQL.

reddit.com › r/sql › complete beginner - where do i start?

r/SQL on Reddit: Complete beginner - Where do I start?

July 27, 2021 -

Hello, I am completely new to the world of SQL and would like to get my journey started! Where do I start? I don't mind paying for courses, I am just looking for the best possible place to learn SQL. I apologize in advance since I am sure this question has been asked before, but I was hoping to get the most updated response.

in the sidebar on the right side of this page is a section called Learning SQL there are two links... follow them, you should

https://www.reddit.com/r/SQL/comments/g4ct1l/what_are_some_good_resources_to_practice_sql/fnx11mc/

Find elsewhere

Google Bing Mojeek

reddit.com › r/learnsql › what is the best way of learning sql and databases in general?

r/learnSQL on Reddit: What is the best way of learning SQL and databases in general?

July 16, 2025 -

I am a backend software developer with around 2 years of professional experience. I create and maintain CRUD web apps on a daily basis, so SQL and databases are no strangers to me. I would like, though, to go deeper and learn those topics better. I was thinking of reading the whole MySQL documentation. But I am also considering the SQLite official documentation, as it seems to be written better (they provide well prepared graphics for a lot of concepts, despite the text). What do you think of that approach to learning? Would you recommend that or there are better ways to dive deep?

I was thinking of reading the whole MySQL documentation. the fact that you even considered this is a good sign "da manual" is muchly underappreciated

In my case I learned because of work requirements, data migrations, etl, complex reports.

reddit.com › r/sql › how to learn sql 2024 in the smartest way?

r/SQL on Reddit: How to learn SQL 2024 in the smartest way?

November 24, 2024 -

I actually nailed the Dbase exam in university 1989, when we also were told ”relational databases are going out”, did know how to optimize databases with BCNF and what not. Then work life did not take me into the world of databases, I was in software but pretty soon went into project leading and managing. Now however doing what’s funny I have started Sw testing again, what rocked my boat in the earlier 90’s. I’m the guy who knows how everythings work using the API’s and GUI’s but I would like to get behind walls of the black box a little learning to examine the databases, what I now ask my buddys the programmers to do.

Some basic knowledge is there, i’ve installed Postgres and like selected my way around a test database.

But then, how to get into the world of joins, stored procedures and what not? What is the smartest way now? I suppose chatgpt is part of the answer?

I suppose chatgpt is part of the answer? i'm here representing the no-it-isn't team

I like the stuff from Datacamp and the book "sql for data science - and a beginners guide". It was part of a book bundle at some point.

reddit.com › r/sql › i am a total beginner to database and want to learn sql or postgresql

r/SQL on Reddit: I am a total beginner to database and want to learn SQL or PostgreSQL

March 8, 2022 -

I have prior programming experience with python and c++, but what I'm learning now requires learning SQL or PostgreSQL.

I do not know anything about databases, so should I learn that first or can I learn it with programming in parallel?

How tough is it compared to the languages I have learned?

Also which should I learn, SQL or PostgreSQL?

SQL is the language, it stands for Structured Query Language and has been around for decades. You use SQL to interact with a database stored in a relational database management system (RDBMS). PostgreSQL is an example of an RDBMS, others are MySQL, SQL Server, Oracle etc. They all use their own flavours of SQL but the basics will be the same so it doesn't really matter which one you begin with (it's like driving a car, some cars will have buttons and switches in different places but they all do the same thing) I don't know much about PostgreSQL myself but I do know that it's free and it adheres pretty well to the SQL standard so you can't go far wrong with learning that. You'll need a client tool as well so you can connect to your server (kinda like an IDE), there are different ones available. Personally I use SQL Server as the RDBMS and SSMS as the client tool, but that's because I use it for work and that's what my companies use. You can download SQL Server Developer Edition for free. So basically you install a server, install a client, use the client to connect to the server, and then type SQL commands into the client to interact with the data on the server.

If you want to work for a corporation - SQL Server. If you’d rather work for a startup/small company - PostgreSQL. There are significant differences, but not so much that you can’t switch later.

reddit.com › r/sql › where to practice sql?

r/SQL on Reddit: Where to practice SQL?

March 20, 2023 -

I have read tutorials and learned the basics of the language. Are there resources of practice problems/projects?

Hope these help! Practice SQL - SQL Zoo SQL Challenges - HackerRank Explore - DoltHub - This has public databases that you can query. I find it pretty fun to find a database that contains data you might find interesting and start practicing that. (I.e. challenge yourself to find top 10 NBA scorers under 25 years of age or whatever)

In addition to what's already provided: https://datalemur.com/ https://sqlbolt.com/ https://www.stratascratch.com/ But there's more theory than just learning the basics of the language. The next step is learning how to break down complex tasks in smaller compartments.

reddit.com › r/businessintelligence › best practical way to learn sql

r/BusinessIntelligence on Reddit: Best Practical Way To Learn SQL

January 2, 2025 -

I have seen multiple posts and youtube videos that complicate things when it comes to learning SQL. In my personal opinion watching countless courses does not get you anywhere.

Here's what helped me when I was getting started.

Go to google and search Mode SQL Tutorial
It is a free documentation of the SQL concepts that have been summarised in a practical manner
I highly recommend going through them in order if you're a total newbie trying to learn SQL
The best part? - You can practise the concepts right then and there in the free SQL editor and actually implement the concepts that you have just learned.

Rinse and repeat this until your comfortable with how to write SQL queries.

P.S I am not affiliated with Mode in any manner its just a great resource that helped me when I was trying to get my first Data Analyst Job.

What are your favourite resources?

If someone knew little or no SQL, I like https://www.codecademy.com/ . The big difference between them and watching youtube videos is the interactive element. You write and execute in the browser which I think is very helpful. If you are trying to grow your existing sql skills, I like trying to solve problems on https://www.hackerrank.com/ Although if you know what you want you want the sql to do, you just don't remember the exact syntax for subqueries, or partitions, or case statements in whatever sql flavor your are in, AI code assistants will probably get you over the line. Which is to say, it's more important you generally understand how SQL works and what it is capable of than the exact syntax for things

This might be an unpopular opinion in this thread BUT I would double down on business understanding and conceptual problem solving rather than the nitty-gritty of SQL syntax. As someone who started out learning excel and using excel to work as an analyst, then learning SQL and Python my take is that with AI these days 80% of my value on the job market is my ability to understand business context and problems 20% is technical know-how. It is definitely not 100-0 but as AI gets better (and just 6 months ago was a major break through with o1) it will continue to shift. If I were to start over, I would 120% use tools that generate SQL code for you using AI. Most of them explain what they are generating as they go, great way to learn and iteratively learn. Some also support public databases to learn. I can promise you, you won't be a data analyst writing SQL code yourself for very long, specially if you are just getting started.

reddit.com › r/learnsql › best resources to learn sql and what should i focus on to get a job?

r/learnSQL on Reddit: Best resources to learn SQL and what should I focus on to get a job?

September 28, 2023 -

I'm currently learning SQL in my spare time, polishing up on my Excel skills and after SQL, I want to learn PowerBI. I have NO EXPERIENCE in SQL.

Which books, mock test, website, youtube channel would you recommend? I want to learn from basic to expert level no matter how much time it takes?

I will never suggest to invest a single dollar for this. Go to YouTube and search for Alex the Analyst. He's best and has a playlist on data analytics. Learn SQL and then progress accordingly. Alex had created the bootcamp to make u job ready entry level analyst. He had also video of projects in the bootcamp. Learn it and make projects then start applying for job through different job platform like LinkedIn or indeed . For more practice you can take help from Google and chatgpt to give specific project ideas or questions. Never underestimate AI. If you get to know how to use this then you'll never need any YouTube,books, website or anything to learn data analytics. Good luck with this.

Checkout this 100% free SQL tutorial .. it has interactive SQL exercises + real interview questions.

reddit.com › r/sql › what are the best sites to learn sql for free?

What are the best sites to learn SQL for free? : r/SQL

May 3, 2024 - You can practice basic-advanced joins and select on Leetcode and HackerRank. That medium acc explains a lot on solving Leetcode problems with patterns and other tips. ... Leetcode, HackerRank. Try solve the problems first and google the functions or methods used to solve those problems. That's ...

reddit.com › r/learnsql › what’s the best interactive course to learn sql?

r/learnSQL on Reddit: What’s the best interactive course to learn SQL?

March 18, 2023 -

I’m mostly looking for one that’s very interactive and with lots of practice. Not really interested in something that’s just watching videos or reading. What’s out there? I don’t mind if it’s paid as long as it’s high quality.

I took dozens to figure out the best one for my team and https://mode.com/sql-tutorial/ consistently was my favorite at explaining concepts. Consider datacamp as well, but Mode’s SQL tutorial was a great balance of topic, guided exercises & practice.

Good one. Google: SQL Simplified JAFFA Inc. Learning Teachable

reddit.com › r/sql › best online course to learn sql

r/SQL on Reddit: Best Online Course to Learn SQL

June 11, 2022 -

I recently graduated college with a minor in Computer Science but we didn't do anything with SQL. Now I'm looking at jobs and realizing its probably a good thing to add to the resume. I went through the free SQL Queries part of codecademy pretty quickly and liked it but figured I should ask for recommendations before paying any money. Looking at jobs mainly in finance now if that changes anything.

Also, I don't need it to be free, but cheap is certainly a plus.

If you want to get the hang of SQL, check out the course available at https://grzegorzpiechnik.gumroad.com/l/nnccol. There, you'll learn not only the basics but also practical tricks for handling data in databases. Creating databases, SQL queries, and even advanced stuff like joining tables - it's all right there.

https://sqlbolt.com for beginners. But after that I would encourage anyone to immediately start working on medium/hard level SQL interview questions. Unlike other coding questions, the SQL questions are actually relevant tasks and problems that companies actually encounter.

Knowing the type of problems and the thought process first will allow you to learn the syntax faster.

https://youtube.com/playlist?list=PLv6MQO1Zzdmq5w4YkdkWyW8AaWatSQ0kX

reddit.com › r/sql › recommended sql learning path. from beginner to expert.

r/SQL on Reddit: Recommended SQL learning path. From beginner to expert.

January 31, 2022 -

Hello all.

I want to increase my SQL knowledge and master this.

I am looking for a good learning path that I can follow to master SQL.

As it's a broad subject. I'd prefer to get your top suggestions on what to learn first.

I can do this on my own. But would like to avoid spending too much learning something I may never use.

It would also be cool to learn how someone would first approach a query. So any good blogs would be great.

Much appreciated.

Steven.

If you want a straightforward learning path for SQL, start by mastering the basics like SELECT statements, filtering, sorting, and joins. This article goes over UC Davis’ SQL course, which walks you through each topic step by step and includes hands-on exercises to help you really get how queries work. Once you feel good about the fundamentals, you can move on to aggregations, subqueries, and more advanced joins. Practicing with sample databases and building small projects will make it a lot easier to master SQL and use it in real-life situations.

https://sqlzoo.net/wiki/SQL_Tutorial Then https://mode.com/sql-tutorial/ Then All the leetcode database questions! https://leetcode.com/problemset/database/

reddit.com › r/learnsql › best course to learn sql?

r/learnSQL on Reddit: Best course to learn SQL?

June 6, 2024 -

My company is willing to pay for me to take a course or certification to learn SQL (I currently just have advanced excel knowledge). I know there are tons of cheap (or relatively cheap options) like coursera or data camp - but if my company is willing to pay, I’d take advantage of a more structured setting. Does anyone have any classes or certifications they have taken for SQL that they would recommend?

LearnSQL.com. They have a complete SQL learning path that takes you from the basics to advanced topics like window functions and CTE. They have courses in different dialects: standard, SQL Server, MySQL, and others. They have a lot of practice courses. When it comes to SQL, it’s the most complete learning platform.

I have done a lot of courses and found some of the best ones on Microsoft Learning. I have to preface this by saying I already knew SQL to just above basics. I am a hands on learner so I prefer to learn by doing. Most of the courses I did on there you do in a sandbox they provide. You can also take the scripts they provide and add them to your knowledge base or library. I have also done a few on Udemy but I think I got the most value from Microsoft. The courses are quite short and you can do in a few hours. Also they are free and you get a transcript. The downside is that you won’t get a certification. I also started with excel and moved to SQL and the combination has been invaluable so you are definitely going to get a lot of mileage out of it. Good luck.

reddit.com › r › SQL › comments › 1mm1nng › should_i_try_to_learn_sql_knowing_i_have

Should i try to learn SQL knowing I have absolutely no ...

We cannot provide a description for this page right now

reddit.com › r/learnprogramming › a good site to learn sql.

r/learnprogramming on Reddit: A good site to learn SQL.

May 19, 2022 -

I (27m) want to switch my exhausting current job to programming.I heard that learning SQl can provide you a good chance to land a data analyst job. Also are there any other languages that i should cater to as well.

u/PopGroundbreaking966 I highly recommend using https://sqlbolt.com/ Very easy to follow mini tasks that you complete on the site itself to give the basics of understanding tables, columns and rows and the most basic SQL statements. Do yourself a favour and spend 20 minutes on it today. Used it when I got into software engineering.

Freecodecamp has free resources and different focuses you can choose from, that and YouTube can point you towards some lesser known ones too.