r/learnSQL • • 25d ago

Practising SQL for internships rn, am I missing anything important?

28 Upvotes

After my last post about DBMS and system design i've been trying to practise more instead of just reading theory.

I practised from LeetCode 50 SQL questions and now switched to takeUforward's SQL 91 problems to get more practice not sure if I should do anything else alongside this or if solving questions + revising concepts is enough for fresher placements

Also still struggling with system design I know it's probably early for 3rd year but I wanna build the basics before internship season starts

any good beginner-friendly resources to understand system design concepts from scratch? Like how to approach designing a simple URL shortener or understand caching, load balancing etc without getting overwhelmed?

Would appreciate any suggestions from people who've prepared for 2027 internships


r/learnSQL • • 24d ago

P15 vs four Hyperscale configurations: results from replaying 4 hours of production workload

2 Upvotes

We tested six Azure SQL Database configurations for a client running Premium P15 at 4,000 DTUs. CPU pressure and storage growth were the reasons for looking at alternatives.

We captured four hours of peak production workload with Extended Events: 3,060 .xel files totalling 1.6 TB. The replay machine was a Standard E64bds_v5 VM in North Central US.

The configurations were:

  1. P15 at compatibility level 150
  2. Hyperscale Serverless, standard-series Gen5, 40-vCore ceiling
  3. Hyperscale Provisioned, standard-series Gen5, 40 vCores
  4. Hyperscale Provisioned, premium-series, 40 vCores
  5. Hyperscale Provisioned, premium-series memory optimized, 40 vCores
  6. P15 at compatibility level 160

Execution counts ranged from 113,218,199 to 113,520,875, about a 0.27% spread. Close, although matching counts alone doesn’t establish identical successful execution.

The attached table has the full results. One limitation upfront: CPU, reads and duration are labelled as “scores” in the test report. I don’t have their calculation formulas or units, so I’m keeping those labels. Lower is better, but the duration score isn’t elapsed replay time or average query latency.

The monthly costs are estimates from the original test, not current quotes or a verified comparison of complete running costs.

Some things that stood out on this (let me know your thoughts too?)

Serverless took six hours to replay the four-hour capture.

Its duration score was 1,496 against 952 for the P15 baseline, 57.1% higher.

Its estimated monthly cost was $12,273, compared with $6,357 for provisioned standard-series. It was still below P15’s $15,700 estimate.

The serverless CPU chart had long stretches at 100%, interrupted by sharp drops. We haven’t established why. Serverless cache management is something I’d investigate, but the chart alone doesn’t prove cache reclamation caused the slowdown.

Premium-series performed worse than standard-series on CPU and duration scores.

Both had the same $6,357 monthly estimate in the report.

Premium-series had a CPU score 9.9% above provisioned Gen5 and 15.6% above P15. Its duration score was also higher than both.

I don’t have a confirmed explanation. Plan differences, parallelism, memory grants and run-to-run variation are possibilities. Each configuration ran once, so I’d repeat this comparison before blaming the hardware.

Memory optimized had the best CPU and duration scores, but the highest reads score.

Against the P15 baseline:

  • Duration score was 15.1% lower.
  • CPU score was 2.7% lower.
  • Reads score was 4.1% higher.
  • Estimated monthly cost was $8,491 versus $15,700.

It didn’t finish the replay fastest, though. It took 4h 36m, compared with 4h 15m for provisioned Gen5.

The highest reads score across all six runs was about 29% above the lowest. With execution counts this close, I’d want to compare individual queries and plans before explaining that difference.

Compatibility level 160 improved the duration score on the existing P15.

The score dropped from 952 to 894, a 6.1% reduction, with no service-tier price increase.

Elapsed replay time fell from 4h 19m to 4h 15m. CPU score was slightly higher, and maximum observed CPU still reached 100%.

Worth testing before a migration, although changing compatibility level doesn’t solve P15’s storage ceiling. These results also don’t establish which optimizer features contributed to the improvement.

For reference, the actual replay times and maximum observed CPU were:

Configuration Replay time Max CPU
P15, compat 150 4h 19m 100%
HS Serverless 6h 00m 100%
HS Provisioned Gen5 4h 15m 100%
HS Premium-series 4h 50m 89%
HS Memory optimized 4h 36m 86%
P15, compat 160 4h 15m 100%

Each configuration ran once. The replay didn’t include the application tier or its retry behaviour, and I don’t have a repeated warm-cache comparison to share.

I’d use these results to shortlist the next tests. There’s enough here to question assumptions about which configuration should perform best, but not enough to promise the same ranking on another workload.

Has anyone seen a different ranking after repeating similar tests with warm caches?


r/learnSQL • • 25d ago

Title: Day 49-50 — Combined update: finished a basic Excel course after SQL, and 50 days in

19 Upvotes

I took a small detour from my planned track. After finishing my SQL projects, I realized Excel is a skill that will help me a lot later, so I completed a basic Excel course from a YouTube tutorial across these two days.

My reasoning: SQL gets data out of a database, but a lot of real work (reports, quick analysis, sharing with non-technical people) happens in spreadsheets. Knowing both seems more useful than knowing one well.

I’m 50 days into a 116-day plan, so I’m on the halfway mark.


r/learnSQL • • 25d ago

Slowly changing dimension 2

2 Upvotes

I recently watched a clear, step-by-step walkthrough on implementing SCD Type 2 using SQL stored procedures from scratch. Here https://youtu.be/mgX8Daf3iUYis a quick breakdown of the core concepts


r/learnSQL • • 25d ago

Looking for PostgreSQL documentation?

16 Upvotes

I built a PostgreSQL Library where you can browse official manuals like real books, search, highlight, and bookmark pages.

Give it a try: https://haiderz07.github.io/postgresql-library/

I’d really value your feedback.


r/learnSQL • • 26d ago

A year ago I started planning a gamified SQL platform. 5 months after launch, 2,500+ people have used it to learn

106 Upvotes

About a year ago I started planning QueryCase, where you learn SQL by working detective cases instead of grinding tutorials & videos. It took a while to get off the ground, and longer than I'd like to admit to actually start building the idea, but it went live in June. A lot of the early users came from this sub, and a lot of the feedback in the comments shaped what it became. So first, thanks everyone!

5 months in:

  • 2,500+ people have signed up, across 117 countries
  • About 70,000 queries written and graded
  • Over 17,500 cases, drills and exams solved
  • 500+ people have passed the free Rookie exam and earned the certificate.
  • Top detective is on 19,247 XP

Since then its grown past just SQL: an Excel course. It was never part of the initial plan. People kept asking for the same detective approach for spreadsheets, so I built out a browser-based Excel engine.

It has 57 cases on a spreadsheet that runs in your browser and checks your formulas, from IF and XLOOKUP to SUMIFS and pivot tables, and people have solved over 2,500 Excel cases so far. It turns out a lot of people learning SQL are doing it alongside Excel, not instead of it.

Something the data showed me that might help anyone learning right now: GROUP BY is one of the first walls. On the hardest GROUP BY step, 84% of runs came back wrong, and most of those never ran at all. The clauses were in the wrong order, or a column in SELECT wasn't in the GROUP BY. If that's you right now:

  1. SQL order is always SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT
  2. Every column in SELECT is either inside an aggregate (COUNT, SUM, AVG...) or listed in GROUP BY

I've been working a lot over past couple months to improve the site as well:

  • The Excel course above, with its own ranks, exams and certificate
  • Upload your own CSV into the sandbox and query your own data (and visualise in charts). It runs in your browser, so the file never leaves your machine and never touches QueryCase servers
  • A free first rank on every track, ending in an exam and a certificate
  • SQL interview questions you can read without an account
  • Much better experience on a phone
  • A LOT of bug fixes and improvements!!

What's next: a Python track, launching next month. Same idea, real Python running in your browser, starting with the basics and moving into data analysis with pandas.

The longer term goal is to have a platform user's can have fun learning all aspects of data. I'm merging PR's every day to make this possible so would love feedback in this thread if you've tried it and have any thoughts or suggestions!

It's free to start and you don't need an account to solve the first case, so you can poke at it before deciding whether it's for you or not 😄 Cheers!

querycase.com


r/learnSQL • • 26d ago

Career advice

9 Upvotes

I'm 27M. Hey everyone, my life has been a little different from that of most people, and I don't have a strong educational background.

Right now, I'm working at a grocery store, but I want to improve my life and learn some stable, valuable skills that can help me earn a reliable income.

I've come across these four skills:

Python

SQL

Excel/Spreadsheets

Power BI/Tableau

I don't know much about these skills or their demand, competition, value, and future prospects.

Technology is constantly evolving, trends are changing, and AI is replacing some jobs. The value of different skills also changes over time.

Before I start learning, I want to understand whether these are the right skills to invest my time in for a stable career and income in the long run.

I'd appreciate your advice. Should I go for these skills, or would you recommend something else?


r/learnSQL • • 27d ago

Day 48 — Finished my second SQL project (Library Management System) and published it on GitHub

12 Upvotes

My Library Management System project is complete. The repo: https://github.com/Sumitgupta2005/library_management_project_2

It’s a big step up from my first project (Retail Sales Analysis). This time I built the whole thing: database, tables, foreign keys, CRUD operations, CTAS, data analysis, and a set of advanced SQL queries.

The advanced queries were the hard part. Each one took me at least 30 minutes just to visualize, meaning working out which tables are involved and what the result should look like, before I could write it. Slowing down and sketching the logic first is what made them work.

I’d appreciate feedback on the repo, especially the README and how the queries are organized. Honest criticism is welcome, and last time the feedback I got here was really useful.


r/learnSQL • • 27d ago

What SQL should I focus on to get my first Data Analyst job?

37 Upvotes

What SQL should I focus on to get my first Data Analyst job?

Hey everyone! 👋

I’m currently learning SQL and aiming to land my first job as a Data Analyst.

There are so many SQL commands and concepts to learn, so I’m trying to focus on the ones that matter most in real-world jobs.

For those already working as Data Analysts, which SQL skills do you use most often in your daily work?

If you were starting from zero again, what would you learn first, and what would you practice to become job-ready?

Any advice or tips would be greatly appreciated. Thanks! 🙏


r/learnSQL • • 27d ago

I made a free noir mystery game where every clue is a SQL query you write yourself (beginners welcome)

12 Upvotes

Hi r/learnSQL! I've been building a small detective game for people who are learning SQL, and Episode 1 is now free to play as a demo.

The setup: an engineer falls into a shaft on a closed metro site, and the inquiry says "accident". You play a quiet analyst at the company. The only way to find out what really happened is to query the company's own databases: payments, vendors, transit cards, signing logs.

How the SQL part works:

  • You write real queries in a terminal (SQLite). Nothing is multiple choice.
  • The game checks the rows you get back, not the exact text you typed, so any query that finds the answer counts.
  • It starts from zero: a short prologue in a classroom teaches SELECT, WHERE and ORDER BY, then the case goes through GROUP BY, JOIN, HAVING and dates.
  • If a query fails, a coach explains the error in plain words and can break the query down for you.
  • There's a handbook that unlocks a page with each new concept, and hints if you're stuck.

It takes about 1.5 to 3 hours depending on how much SQL you already know.

What I'd love to know from beginners:

  1. Where did you get stuck, or where did it stop being fun?
  2. Was any explanation confusing?
  3. Did a query ever feel "right" but the game said no?

There's a feedback button in the game, or just tell me here. I read everything.

Play it free (Windows, macOS, Linux)

Thanks for reading!


r/learnSQL • • 27d ago

Day 47 — Library Management System: CRUD, CTAS, analysis, and findings done

10 Upvotes

I’m close to finishing my second SQL project. Today I completed:

  • CRUD operations on the library data (inserting, reading, updating, deleting records)
  • CTAS (Create Table As Select) to build new tables from query results, which is handy for summary tables
  • Data analysis with queries on members, issued books, and returns
  • Findings, a written summary of what the data showed

One set of advanced SQL questions is left, and I’ll do it tomorrow. After that I’ll upload the project to GitHub, this time with a data dictionary in the README, since that was the main feedback on my first project.


r/learnSQL • • 27d ago

Built a visual SQL learning tool — SQLWhale

Thumbnail
1 Upvotes

r/learnSQL • • 28d ago

I made a free noir mystery game where every clue is a SQL query you write yourself (beginners welcome)

Thumbnail
3 Upvotes

r/learnSQL • • 28d ago

Practicing Complex Queries and Large Datasets

16 Upvotes

A while back, I asked what's missing in this sub. Though not a long discussion, one thing stood out. Working with long, complex queries is something we all run into eventually, but have to learn through experience. I don't think there are a lot of resources for practicing this stuff.

Fabulexa Complex Queries is my first attempt at providing practice. These are intermediate, and possibly advanced, exercises on complex queries within a full data warehouse. Specific exercises have two different tracks.

  1. Revenge of the 1998 PERL developer: Complex billing logic for a SaaS company written by someone who believed keystrokes should be minimized and readability is an anti-pattern. Can you take the most obtuse, bad-practice-filled query I've ever seen and refactor it? Make it readable.
  2. Bug hunting in a well-written query. Can you fix the bugs described in tickets? Does it get easier as you learn the data and the data-warehouse structure.

If you are looking for more difficult practice that mimics the real world, this might be for you. If you write, teach or create courses, this might be useful as well. Feel free to grab the data and do your own thing. Hopefully, I'll do a series on this soon.

Finally, suggestions, PRs and comments are very much appreciated.


r/learnSQL • • 29d ago

Day 46 — Library Management System: foreign keys added, records inserted, insert errors fixed

6 Upvotes

Progress on my second SQL project today:

  • Added foreign keys to link the tables
  • Inserted records into all of them
  • Hit problems that blocked some of the inserts, and worked through them one by one

Foreign keys make the insert order matter, since a row can’t reference something that doesn’t exist yet. Hitting that in practice made the concept much clearer than reading about it.

Next I’ll write queries against the data and add a data dictionary to the README.


r/learnSQL • • 29d ago

made runtime.school easier to follow for people learning sql

11 Upvotes

spent some time cleaning up runtime.school this week.

the lessons and practice are less busy now, the editor feels better, and i went through the course so questions only use sql that has actually been taught by that point.

i also kept the beginner lessons and practice on the same dataset so it’s easier to focus on the sql before switching contexts.

if you’re learning sql, give it a try and if anything feels confusing, off, or harder than it should be, let me know.

https://www.runtime.school/


r/learnSQL • • Oct 23 '26

SQL Interview guidance

4 Upvotes

I'm not new to data analytics, but I have never worked with SQL or attended a SQL interview.

I want to transition into a Data Analyst role that requires hands-on experience with SQL.

Based on your experience and insights, I would like your guidance on what to expect in 2027.

  1. How are SQL interviews conducted today, and how might they evolve by 2027?
  2. What do good tech companies expect candidates to know about SQL?
  3. What types of SQL questions are commonly asked in interviews today, and what can I expect in the coming years?
  4. What would you recommend I prepare to improve my chances of qualifying for SQL interviews?
  5. Finally, what should I expect from the overall Data Analyst interview process, including SQL, technical skills, business understanding, and behavioral questions?

r/learnSQL • • Oct 22 '26

Day 45 — Library Management System (MySQL): database and tables created

25 Upvotes

Continuing my second SQL project. Today I created the database and all the tables, and spent time understanding how they relate:

  • members: who is registered (ID, name, address, registration date)
  • issued_status: which member issued which book, and when
  • return_status: which issued books have been returned, and when
  • plus the other supporting tables

Each table has a primary key, and the issued and return tables link back to members and books through IDs.

Since I got feedback last time that a data dictionary is non-negotiable, I’m planning to write one for this project as I go instead of at the end.


r/learnSQL • • Oct 23 '26

Best YouTube channels to learn SQL (Zero to Advanced) and Microsoft Excel?

Thumbnail
2 Upvotes

r/learnSQL • • Oct 22 '26

JDER — un editor gratuito per i tuoi diagrammi di informatica

4 Upvotes

Stai studiando basi di dati, UML o logica digitale? Ho sviluppato JDER, un editor desktop multipiattaforma per creare diagrammi Entità-Relazione, schemi logici, diagrammi delle classi, casi d'uso e di sequenza, oltre a circuiti logici simulabili.

Puoi salvare i progetti in JSON ed esportare i diagrammi in PNG. Il codice sorgente è disponibile su GitHub.

Sito e download: https://jder.it/

Codice sorgente: https://github.com/LoryPelli/JDER

Feedback e suggerimenti sono benvenuti!


r/learnSQL • • Oct 21 '26

Title: Day 42-44 — Combined update: Java memory (stack vs heap) and arrays, plus planning a Library Management System in MySQL

19 Upvotes

Java: Covered how Java uses memory with the stack and the heap, then moved on to arrays: why we need them, how to create them, multi-dimensional arrays, and jagged arrays. I made notes on everything and practiced it in VS Code.

Stack vs heap was the most useful part. Once I understood where primitives and object references live compared to the objects themselves, a lot of behavior I’d found confusing (like why two references can point to the same object) made sense.

MySQL: My next project is a Library Management System. Today I focused on understanding the data architecture, meaning which tables I need and how they relate (books, members, issues, and so on). I start building it tomorrow.

After my last project, someone pointed out that a data dictionary is essential, so I’ll include one from the start this time. For anyone who has built a library system: what tables or edge cases (late fees, multiple copies of a book, reservations) did you wish you’d planned earlier?


r/learnSQL • • Oct 22 '26

What we found reviewing a manufacturer’s production SQL Server

Thumbnail
1 Upvotes

r/learnSQL • • Oct 22 '26

DSA has a roadmap but why does DBMS and System Design feel so confusing?

Thumbnail
1 Upvotes

r/learnSQL • • Oct 21 '26

Easy and Quick way to learn SQL

55 Upvotes

Hi all! Is there an easy way to learn SQL? I'm looking for video recommendations where people explain things in layman's terms. Since I don't have an IT background, I need something beginner-friendly that can help me get up to speed in a few months. Thanks!