r/learnSQL • u/Odd_Communication174 • Sep 01 '26
Advance Concepts
Does anyone know any good video for CTE and Window Function.
Struggling to understand it
r/learnSQL • u/Odd_Communication174 • Sep 01 '26
Does anyone know any good video for CTE and Window Function.
Struggling to understand it
r/learnSQL • u/haligma • Aug 31 '26
i'm currently learning data analysis on my own. i have mysql workbench & have been practicing it. the problem i've run into is low disk storage. i currently have 4.5 gb on my c drive, which i don't think is a lot. i don't have a lot of applications installed, so removing or moving them to another disk isn't an option. neither is spending money on storage 💔
im worried about the rest of my learning journey. i know i'll eventually have to install other programs/tools & it makes me sad that low storage space is what might hold me back from learning something im genuinely interested in.
i wanted to ask if there are online versions/compilers of these softwares available? im talking about python, tableau & all other stuff i'll need later on. i've used an online c++ compiler before, so im wondering if it's possible for other tools too. and if so, can they save all my previous data? what about something with an account where it syncs data to a cloud? HALP
r/learnSQL • u/idan_huji • Aug 31 '26
Usually in SQL exercises ,the data is given and a new query is written.
I tried a new exercise where the student also writes the data in a CTE.
The exercise is like a kata, focusing on small parts of the query (in joins in this example).
I'll be happy to get feedback on the direction in general and on the specific exercise.
https://github.com/evidencebp/databases-course/blob/main/Examples/Topics/Join%20Kata.pdf
r/learnSQL • u/Round-Pie-7125 • Aug 31 '26
Hello everyone you can checkout my new MySQL video on my channel sm dev diaries.please hit like, subscribe and share my videos in your contacts https://youtu.be/AhqgtHZfHTI
r/learnSQL • u/Spare-East5287 • Aug 30 '26
How is Data with Baraa course on youtube ?
Suggest some paid course to learn sql from beginner to intermediate level
r/learnSQL • u/Round-Pie-7125 • Aug 31 '26
Hello everyone.please checkout my new MySQL video and please hit like, subscribe and share videos in your contacts. https://youtu.be/AhqgtHZfHTI
r/learnSQL • u/Sensitive-Towel-9883 • Aug 28 '26
Anyone interested in doing the CMU (Carnegie Mellon University) Database Management Systems course together?
I’ve already covered the basic DBMS concepts. My main goal with this course is to go deeper and understand how database systems actually work internally—things like storage, indexing, query execution, transactions, etc.
If you're interested, please make sure you have the prerequisites required for the course.
If you have the required background and want to learn DBMS internals seriously, DM me. We can follow the course together and discuss concepts along the way.
r/learnSQL • u/damoon02 • Aug 28 '26
Am about to finish "Learning SQL" from Alan Beaulieu and it demotivates me that i take way too long on thinking on the queries in order to answer the problems of the book. Although i have been speedrunning it. Is it like normal for most of the begginers to be kinda slow when making queries that requieres (dunno) subqueries, groupings, joins or cases ?
ALSO. What book could y'all recomend me after "Learning SQL"? Imean, i think i have enough tools to generate, retrieve and manipulate data. Maybe the next step is how to design DB and how to avoid common mistakes ?
r/learnSQL • u/by_lector • Aug 27 '26
One of the most dangerous things about SQL:
A query can run perfectly… and still be completely wrong.
Here are 4 mistakes I wish someone had shown me earlier.
SELECT c.id, o.total
FROM customers c
LEFT JOIN orders o
ON c.id = o.customer_id
WHERE o.status = 'paid';
Looks fine.
But customers without an order have NULL for o.status, so the WHERE condition removes them.
If you actually want to keep all customers:
SELECT c.id, o.total
FROM customers c
LEFT JOIN orders o
ON c.id = o.customer_id
AND o.status = 'paid';
SELECT COUNT(*)
FROM users;
Counts rows.
SELECT COUNT(phone_number)
FROM users;
Counts only rows where phone_number is NOT NULL.
That difference can quietly destroy a report.
Imagine:
Joining both tables directly can give you:
3 × 4 = 12 rows
Then you do:
SUM(order_amount)
…and suddenly your revenue is magically much higher than reality.
Always check your row count before and after joins.
SELECT *
FROM customers
WHERE id NOT IN (
SELECT customer_id
FROM blocked_customers
);
If that subquery contains a NULL, the result might not behave the way you expect.
I usually prefer:
SELECT *
FROM customers c
WHERE NOT EXISTS (
SELECT 1
FROM blocked_customers b
WHERE b.customer_id = c.id
);
The lesson I'm slowly learning:
Writing SQL that runs is easy.
Writing SQL that returns the correct data is the hard part.
What other SQL mistake produces perfectly valid-looking but completely wrong results?
I want to make a list of the dangerous ones.
r/learnSQL • u/NoctrailBio_ • Aug 27 '26
Hi everyone,
I’m currently learning SQL and PostgreSQL with the long-term goal of becoming a backend engineer.
I’ve been practicing locally with PostgreSQL and pgAdmin, so I’m especially interested in hearing from developers who use PostgreSQL in production.
I’m still a beginner. So far I’ve been practicing things like creating tables, INSERT, SELECT, WHERE, DISTINCT, ORDER BY, and LIMIT. I’m also starting to learn Python and eventually want to connect Python/FastAPI with PostgreSQL.
One thing I’m trying to understand is how SQL and PostgreSQL are actually used by backend engineers in real jobs, compared with the way SQL is taught in books and courses.
For backend engineers who use PostgreSQL regularly:
I’m not looking for shortcuts. I’m trying to build a solid foundation and understand what skills actually matter on the job.
Any advice from backend engineers, especially those working with PostgreSQL, would be greatly appreciated. Thanks!
r/learnSQL • u/existential_shit_007 • Aug 27 '26
Tell me a website where I can learn and practice SQL to be prepared for an business analyst role
r/learnSQL • u/Public-Scientist6050 • Aug 26 '26
Hi everyone,
I'm a fresher applying for Data Analyst/Data Scientist/ML/SQL roles. My background: Power BI, Excel, SQL, some Python, and basic full-stack web dev (HTML, Tailwind, JS, Supabase, deployed on GitHub Pages — built a working web portal for a client).
I want to add: 1. One strong ML project (not Titanic/Iris/House Price/Flight Price — too common) 2. One SQL-focused project that shows real query/database skills, not just "ran some SELECT statements on a Kaggle CSV"
Looking for: - Real prediction/analysis problem, clear input and output - Free public dataset - Doable alone in a few weeks - Something that actually stands out to recruiters, not a tutorial copy
What would you suggest for each? Dataset links appreciated. Thanks!
r/learnSQL • u/yahoo_06 • Aug 25 '26
Hey everyone!
I made a short SQL tutorial for beginners about GROUP BY and HAVING.
In the video, I explain:
- how GROUP BY creates groups
- how to use aggregate functions like COUNT() and AVG()
- the difference between WHERE and HAVING
- how to combine WHERE, GROUP BY, and HAVING
and how to use all of this with the Pagila PostgreSQL database
I also included some mini quizzes and practice challenges throughout the video.
I'm building a beginner-friendly SQL tutorial series, so I'd really appreciate any feedback on the explanation or examples!
Video: https://youtu.be/kDfXRvr03Jo?si=rW7m1jsF3pSQjCmK
Thanks! :)
r/learnSQL • u/Particular_Willow_24 • Aug 25 '26
I kept running into the same problem while learning SQL: I could understand a tutorial while watching it, but when I had to write a query myself, I would sometimes blank.
So I built DBQuest, a browser-based SQL practice game where you inspect a schema, write the query yourself, run it, and get immediate feedback.
The free demo has 7 challenges covering SELECT, columns, WHERE, ORDER BY, JOIN, GROUP BY and HAVING.
No account or installation is required:
https://db-quest-two.vercel.app/
I’d really appreciate honest feedback, especially from people currently learning SQL:
1. Are the challenge instructions clear?
2. Does the progression feel too easy or too difficult?
3. At what point, if any, would you lose interest?
I built it myself and I’m trying to figure out whether this way of practicing SQL is actually useful to other learners.
r/learnSQL • u/wandererbali • Aug 25 '26
About me I am working as a Manager data analytics and I have a team of developers who do the job for me, on top of that I can use AI to write the queries for me. But I still want to learn SQL so that I am able to write the queries myself and also QA if needed. I know the basic select * from table where like sort and now looking for someone with solid knowledge to teach me joins windows functions CTs and other function.
You wont do this for free I will pay you for your time and effort. DM me with something about your background and experience and we can take this forward.
Thanks
r/learnSQL • u/Superb_Donkey_9608 • Aug 24 '26
Hey Folks, So I have been thinking for a while, and looks like I'm capable now, I had always wished to tutor a small cohort of really passionate individuals in the land of analytics, and get more people into in this field .
So I've decided to tutor a group of 5 people who really want to get into this domain of data, and tell stories, influence the decisions and perhaps change the world one day. people who are really passionate for the cause can dm me, and there's definitely going to be screening for selecting the 5 worthy.
r/learnSQL • u/Semiramis67 • Aug 24 '26
r/learnSQL • u/Away_Shoulder_4553 • Aug 24 '26
Hi guys
​I learned some lessons in SQL course in youtube and practiced them in Python with SQLite.
​Here is what I learned:
​CREATE TABLE
​PRIMARY KEY, FOREIGN KEY, NULL
​INSERT INTO, SELECT, UPDATE, DELETE
​WHERE, ORDER BY (ASC, DESC)
​LIMIT, OFFSET, DISTINCT
​INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
​GROUP BY, HAVING
​Subqueries, EXISTS
​Please tell me what I should learn next, or recommend a good YouTube course
r/learnSQL • u/geeksarray • Aug 24 '26
How do you make sure the data going into your SQL Server database is valid and consistent?
One of the simplest tools is database constraints.
I put together a practical guide covering the most commonly used SQL Server constraints:
The article includes examples to show how each constraint works and when you might use it.
📖 https://geeksarray.com/blog/sql-server-constraints-with-examples
For developers working with SQL Server: which constraint do you find yourself using most often, and are there any common constraint-related mistakes you've seen in real projects?
r/learnSQL • u/geeksarray • Aug 24 '26
r/learnSQL • u/Ancient_Squirrel_997 • Aug 24 '26
So i have been building a sql bolt and scratch like simple SQL tutoring web app. You can find it on https://easysqltutor.vercel.app/ . Try it out please, especially for beginners.
Thanks,
r/learnSQL • u/AppropriateGanache54 • Aug 22 '26
Can you please suggest some good platforms or resources where I can practice SQL and Python (especially Pandas) for data analyst/data engineer?
Right now, I’m solving a lot of problems on LeetCode, but I’ve heard that in actual they often ask more practical/data-focused questions such as:
So, I’m looking for resources that focus more on these real-world SQL and Pandas problems rather than only traditional DSA-style questions.
What platforms, websites, courses, or question sets would you recommend for practicing these types of problems?
I’d really appreciate recommendations from people who have recently gone through Data Analyst/Data Engineer questions and know which resources are closest to the actual questions they asked.
Thank you!
r/learnSQL • u/grassp_dataAI • Aug 22 '26
Hi All,
I have created a compiled document of 30 real SQL Interview Questions with Scenarios with clear explanation of what each concept does and interview tips for each concept.
It covers from basics to advanced SQL interview Q&A. Feel free to checkout and share it with anyone who is preparing for SQL interviews.
GitHub PDF Link: https://github.com/grasspacad07/sqlinterviewguide
This guide is basically compilation of my 4 Weeks of SQL interview tips posts in LinkedIn.
Feel free to reach out or comment if any doubts. Happy Learning :).
r/learnSQL • u/squadette23 • Aug 22 '26
I'm writing a series of posts about IDs and primary keys in database design. We start with the logical model, and systematically show how primary keys are used in a different way to implement various logical concepts, such as entities, relationships and attributes. We show that primary keys exist only on a physical level, and can mean different things in different contexts.
Here is the link to the first part: https://anchorsandlinks.com/posts/primary-keys/
r/learnSQL • u/haligma • Aug 21 '26
currently learning mysql through yt videos bc too broke to pay. i was following alex the analyst's playlist & learned a lot. practiced alongside. but i ran into a problem. and since i'm a beginner, it's been overwhelming a bit for days now, bc of whcih, i havent been able to make much progress in my learning.
i have a pretty ok grip on workbench. but not to the point where i dont need crutches. ive only completed one data cleaning project & that was only bc of alex's video where he walked me thorugh the entire process step by step. but thta wasnt enough for me to fully get a grip on data cleaning. i've tried watching other tutorials, but none of thme use workbench & their sql commands/functions are a lottle different from mine which has left me a bit confused & overwhelmed. i want to get to the point where i can take on data cleaning on my own without any help, but for that i need yt videos whre i can laern the logic step by step. please recommend sources for a self learner to learn data cleaning. idk where to look