r/learnSQL • • 1h ago

Free Excel and SQL level tests for beginners: 10 questions each, no sign-up. Tell me where they're too easy or too hard

4 Upvotes

I see a lot of "am I ready to apply?" posts here, so I built two short tests to answer that with something other than a certificate.

\- Excel: 10 questions in a real spreadsheet, from SUM and IF up to VLOOKUP and INDEX/MATCH. [https://getsheetdrill.com/test

\- SQL: 10 questions on a real database, from SELECT up to JOINs and subqueries. [https://getsheetdrill.com/sql/test

You type the formula or the query, it runs in your browser and gets checked right away. Typing the result by hand doesn't pass. At the end you get your level and which topic to study next.

Both are free and need no account. The site has paid lessons further on, but the tests and the first lessons are free.

I made it, so I'm biased. What I'd like to know: which question felt unfair, and what topic is missing for an entry-level analyst role?


r/learnSQL • • 15h ago

Title: Day 75-76 — Combined update: Hospital Management System, adding Billable, Inpatient/Outpatient, and service classes

3 Upvotes

Progress on my Hospital Management System over the last two days. I added:

  • Billable
  • Inpatient and Outpatient classes
  • PatientService and DoctorService

In DoctorService I wrote methods to search doctors by specialization (case-insensitive), update a doctor's availability (throwing a custom DoctorNotFoundException if the ID doesn't exist), list the departments, and view all doctors.

I followed the advice from earlier comments here: keep the model classes simple, put the logic in separate service classes, and use custom exceptions for errors.

For people who've structured something similar: do you keep the doctor collection inside the service class, or in a separate repository class? I'm not sure whether the service is taking on too much.


r/learnSQL • • 21h ago

Does SQL pair well with a marketing degree?

3 Upvotes

I actually graduated 4 years ago and eventually got a marketing job this year, but it’s boring, I work in SEO and there’s nothing fulfilling about it, also the pay is terrible.

I was looking into skills that could make me more valuable o to go alongside my marketing experience and SQL came up, is it worth it?


r/learnSQL • • 22h ago

Is SQL certificate for free worth it ?

2 Upvotes

Hello, I want to learn SQL in hopes to become a data analyst. We don’t have SQL course in our university so I stumbled upon a website that teaches you SQL and you get a certificate after. However the certificate is for free so it’s not taken seriously. I am just wondering if it’s worth even completing or should I pay for one ? I am wondering what would look good on my CV


r/learnSQL • • 1d ago

MySQL Query Optimization in 2026?

10 Upvotes

How to actually learn because I think they are very important for a SQL engineer in 2026...More so than ever.

I want to learn the details of cost-based and heuristic-based query optimization. The problem is I am from Nepal and we do not have libraries or digital courses service from libraries.

To the USA people: Please consider tell government to help us read and learn in a mass way.

I would really appreciate if you guys could help me out.

I found lots of free resources in google pdfs, but they are lecture slides meant to be accompanied with the lecture. But the problem is that lecture video is not freely accessible.

I am willing to pay huge money to learn this thing.


r/learnSQL • • 1d ago

W3 Schools SQL course

2 Upvotes

Hi Reddit,

I just started the SQL course on W3 Schools online because it is free.

If you complete this course, will it be enough to get a entry level job using SQL?

Or is W3 Schools something that prepares you for certification for SQL?

Thank you!


r/learnSQL • • 1d ago

FREE Ebook - Your First 30 Days as a DBA

12 Upvotes

(Portuguese, English, and Spanish versions)

Most of us didn't plan to become DBAs. One day the databases were ours, and we learned the rest in production.

Get the free ebook: https://www.dbatopro.com/products


r/learnSQL • • 2d ago

Day 74 — Hospital Management System: started coding with packages, three classes, and custom exceptions

4 Upvotes

I moved from planning to coding today:

Several people here suggested planning modules first, handling exceptions carefully, and not putting all the logic in one class, so I tried to follow that from the start.

Next I’ll build one module at a time and test it before moving on.

For people who’ve used custom exceptions in a project like this: how many did you end up needing, and did you group them under a common parent exception?


r/learnSQL • • 3d ago

Free sources to learn SQL

46 Upvotes

Hi everyone, I'm a 3rd-year B. Tech Data Science student and I want to learn SQL from scratch. I don't have money to take a course and I don't want to fall into tutorial hell, so please suggest some free and good resources to learn SQL.


r/learnSQL • • 3d ago

We made a free SQL playground that runs in your browser, plus a 21-day beginner challenge

8 Upvotes

If you've ever wanted to practise SQL but got stuck installing a database, this is for you.

DBA Genesis Playground opens with a sample EMPLOYEE table already loaded. Click Run and you see real results in seconds. Nothing to install.

We're also running #21DaysOfSQL: one small challenge a day until Dec 10.

Day 1: Show every row in the table.

Day 2: Show only the employees in Accounting.

Try it here: dbagenesis.com/playground


r/learnSQL • • 3d ago

Day 73 — Started my Hospital Management System in Java: understanding the topics is not the same as implementing them

3 Upvotes

I started my Hospital Management System project today. I spent a good part of the day just understanding what I was building, using Claude as a guide to help me visualize the code structure, and then built the first three classes: Person, Patient, and Doctor.

The biggest thing I learned: understanding a concept and applying it in a real-life project are very different. I know inheritance, encapsulation, and abstraction individually, but deciding which classes to create, what belongs in each, and how they connect was much harder than any tutorial exercise.

I’ll build and test one piece at a time, as people here suggested on my earlier projects.

For people who’ve built similar projects: how did you decide what goes in a parent class like Person and what stays in Patient or Doctor? I want to avoid redoing the structure later.


r/learnSQL • • 3d ago

I made a free set of 54 short SQL exercises that tell you *why* your query is wrong, not just that it is

4 Upvotes

Hi r/learnSQL, I'm a data engineer and I built SQL Dojo https://sqldojo.dev to practise SQL the way I wish I had learned it: lots of short steps, each one checked, with an explanation when you get it wrong.

What it looks like:

  • Each step asks a question about a realistic dataset (an online shop, a SaaS, product events…) and checks your result.
  • When it's wrong, it tells you how: too many rows, missing rows (and which ones), values that differ, and the likely cause, like a join that duplicates rows or a NULL hiding in a NOT IN.
  • A "step by step" view runs your query one clause at a time, in the order the database actually runs it (FROM, then WHERE, then GROUP BY…). This is the thing that made SQL click for a lot of people I've taught.
  • Spaced reviews bring back the steps you struggled with.

It runs in your browser: no install, no database to set up, no account needed to start.

The white belt (54 steps, about 3 hours, from your first SELECT to joins and GROUP BY) and the reference library are free. The later belts (window functions, CTEs, data modeling, interview runs) are a one-time payment, no subscription, and you don't need them to get value from the free part. There a also a practice section with real datasets.

I'd really like feedback from people learning right now: where did you get stuck, was an explanation unclear, is the pace right?


r/learnSQL • • 3d ago

i need to learn as much sql in one week as possible from zero

75 Upvotes

Hi guys i have somthing that is database reateld in about one and half weeks and i need to learn as much SQL and database desing is possible in the next 1.5 weeks. i have about 3 hours of studytime a day. i corrcrtnly dont know much. can someone tell me where to start. i heard about SQLbolt but that it.


r/learnSQL • • 4d ago

count(*) vs count(col), i keep mixing them up

10 Upvotes

ok so my teacher said count(*) counts rows and count(col) skips nulls, but then he did an example with a left join and the numbers looked off to me and i didnt catch why. is the rule basically use count(right_table.id) after a left join if you want 0 for the ones with no match? or does count(*) still give 1 there


r/learnSQL • • 4d ago

Title: Day 70-72 — Combined update: HashMap/HashSet, full core Java revision, and planning a Hospital Management System

9 Upvotes

Over the last three days I:

  • Covered HashMap and HashSet
  • Revised all of core Java again, this time implementing everything in code instead of only reading my notes
  • Picked my next project: a Hospital Management System that uses all the core Java topics I’ve learned so far

For the planning, I used Claude as a guide, more like a mentor than a code generator. It helped me think through the structure and finalize a plan without giving me the code, so the implementation will still be mine. I start building tomorrow.

Based on the feedback I got here on my earlier projects, I’ll test each part as I build it and not leave all the errors for the end.

For people who’ve built a hospital or similar management system as a beginner: what would you plan before writing code, and what did you wish you’d designed differently?


r/learnSQL • • 4d ago

Answer different but same result?

7 Upvotes

Very daft beginner question but I'm working through the absolute basic AdentureWorks Practice questions (from here)

Q.19 - Select the IDs of employees who have the job titles ‘Sales Representative’ or ‘Tool Designer’ and who have worked (or are working) in the Sales or Marketing departments.

My answer:

Select E.BusinessEntityID, E.JobTitle, D.Name
From HumanResources.Employee as E
    Join HumanResources.EmployeeDepartmentHistory as edh
    ON E.BusinessEntityID = edh.BusinessEntityID
    Join HumanResources.Department as D
    On D.DepartmentID = edh.DepartmentID
where E.JobTitle in ('Sales Representative','Tool Designer')
AND D.Name In ('Sales','Marketing');

Their/The answer:

SELECT e.BusinessEntityID
FROM HumanResources.Employee AS e
WHERE e.JobTitle IN ('Sales Representative', 'Tool Designer') 

INTERSECT 

SELECT edh.BusinessEntityID
FROM HumanResources.EmployeeDepartmentHistory AS edh
JOIN HumanResources.Department AS d
ON edh.DepartmentID = d.DepartmentID
WHERE d.Name IN ('Sales', 'Marketing');

I got the same results? I checked against the actual data tables without the WHERE clauses to make sure neither statement was missing anything.

(Yes I know I'm carrying in the JobTitle and Name fields into my version, I'm doing that basically to visually sense check the answer I get rather than just trust that a list of ID values is correct)

Other than 'this is a section where we're teaching you about UNION functions', I couldn't see why they used more lines than necessary for the same answer. Am I just being a bit too ASD about it, or is there a reason it's better practice to use INTERSECT rather that JOIN here?


r/learnSQL • • 4d ago

Why is my Left Join acting like an Inner Join (with no Where clause)

2 Upvotes

I've seen all the posts about people asking about joins when there's a where clause involved, but I have no idea what's causing this behavior since as far as I know it SHOULD be returning everything. This is being done in MSAccess. Please don't respond with "don't use Access" I don't have that option.

Select TableA.*, TableB.*
From TableA Left Join TableB
On (TableA.ID = TableB.ID)
And (TableA.Date = TableB.Date)

TableA and TableB have the same values for ID, but there's only one row where they both have the same date. I would expect this to give every row for TableA, and nulls in every cell for the TableB columns except for the one where there's a date match. What I'm getting instead is only the single row where there's a full match between the two tables. Am I missing something stupid here?

Edit: Since the date values keep getting brought up, both sets of dates are converted to the same type and format in previous cleaning queries. And, importantly, they are matching properly if the values exist in both tables A and B.


r/learnSQL • • 5d ago

How do you handle NULL values when writing SQL queries?

17 Upvotes

I'm still learning SQL and sometimes get confused about how to handle NULL values in different situations. I know they can affect query results, especially when using filters, joins, or calculations.

How do you usually deal with NULL values, and are there any common mistakes beginners should watch out for? TIA


r/learnSQL • • 5d ago

Looking to become an SQL teacher, anyone interested?

39 Upvotes

Hi everyone! I've learned the basics of SQL within my company, and it gave me a huge advantage compared to my peers, and helped to get promoted. I enjoyed teaching it to colleagues, and would love to teach to anyone for free to improve my teaching skills! let me know if anyone is interested


r/learnSQL • • 5d ago

Best way to learn SQL and PL/SQL as a university student?

37 Upvotes

Hi everyone!

I'm a university student currently studying Advanced Databases (Database Avancé) as part of my degree.

I'm learning SQL and PL/SQL because they're required for one of my university modules. However, I don't want to just memorize commands or learn enough to pass the exams. I'd really like to understand how they work and become comfortable writing queries and solving database-related problems.

The problem is that I'm not quite sure where to start or how to organize my learning.

For those of you who have learned SQL and PL/SQL, I'd really appreciate your advice:

- What learning resources, courses, or YouTube channels would you recommend?

- Should I focus on SQL first before moving on to PL/SQL?

- Are there any websites where I can practice exercises and real-world problems?

- What's the best way to combine theory with practical exercises?

I'm looking for a beginner-friendly learning path that I can follow alongside my university studies.

Thanks in advance for your help!


r/learnSQL • • 5d ago

SQL Server DBA Interview Questions

2 Upvotes

💡Looking for easy-to-understand SQL Server interview questions & the latest best practices?

Subscribe to our YouTube channel:-

@MadeSimpleMSSQL

Visit at https://madesimplemssql.com

#TSQL #TransactSQL #SQLQueries #DBA #SQL #diy #madesimplemssql #sql #data #ukreels #usa #usareels #usagirl #USAToday #USAMovies #usatiktok #USATodayBestSellingAuthor #Indiana #uknews #ukjobsearch #UKJobs #france #germany


r/learnSQL • • 6d ago

MySQL

6 Upvotes

I want to understand how to use MySQL on VS code and run the code SQL in MySQL,and connect the file SQL in SQL tools?


r/learnSQL • • 6d ago

Looking for unique, real-world database project ideas (MS SQL Server + C#)

Thumbnail reddit.com
2 Upvotes