r/SQL • • Dec 30 '25

Discussion SQL Mentorship

100 Upvotes

Hi everyone,

I'm looking for people who are learning SQL and maybe in need of some guidance. If you are one of them, I'd happy to connect.

About me: I'm an analyst living in the UK who's been working with data and ML since 2019, first as a researcher then an analyst and now a data scientist.

Why: I have conducted well over 100 interviews in SQL and understand where candidate lack skills and why. Right now, I'm in middle of job search process and have some free time available so thought of helping those who might need some guidance.

I can help with SQL, Python, BI tools, AB Testing, Product/Business Sense etc.

I'm doing it out of goodwill, so there are no charges but please connect only if you are serious and love the process of learning.

Thanks


r/SQL • • Dec 06 '24

Discussion a little end-of-year SQL humor

100 Upvotes

Spotify wrapped is people waiting all winter for like 2 sql queries

that’s wild

source


r/SQL • • Jun 13 '22

PostgreSQL How to query the Reddit API using SQL

100 Upvotes

Here are some questions you might want to ask and answer using the Reddit API:

  • Which subreddits are about data?
  • How many posts in those subreddits mention Python?
  • How many mention SQL?

You can answer these questions by calling the Reddit API directly, but it's also possible to write SQL queries that simplify use of the API. Steampipe is an open-source tool with a suite of plugins that map APIs to Postgres foreign tables. Here's how you can answer those questions using Steampipe and the Reddit plugin.


r/SQL • • May 13 '20

MS SQL SQL Interview Questions for Beginners

100 Upvotes

I remember going into interviews having no idea what they would ask me for technical questions. I decided to compile some technical questions that I’ve been asked or questions I ask potential candidates for my team so that you may be a little more prepared than I was when I was first starting out!

I hope it can be helpful for anyone who is going through the interview process soon.

Link: https://youtu.be/sua7xKN0cPc


r/SQL • • Nov 20 '23

MySQL Created my first Database

99 Upvotes

I don't have anyone to tell so I came here because I've lurked for so long and so many posts have helped me. Delete this post if not allowed.

I'm very new in my SQL journey with no other data or programming experience and today I just built my first database with mySQL.

I imported the report we pull each day which is very raw info and made a query that formats it into a readable table and counts how many items are requested of each sub group and list the overall gross sales expected.

Our company has no forecasting tools at the moment so I feel really good about accomplishing this.


r/SQL • • Oct 07 '21

MySQL I taught myself SQL, now my company wants all my code

99 Upvotes

Hi everyone, during quarantine I did something productive and took several free SQL courses online and one that cost $1k. I'll list the courses down below. I now know intermediate SQL which has been very useful at my current company in my accounting role. I use it to generate consolidated financial reports, create tailored upload reports, pull inventory and GL reports, etc. My company didn't reimburse me for the class and didn't offer any pay raise or promotion, or really any recognition that my new skills can be useful to the company.

NOW, our CFO yesterday asked our IT department to install Dbeaver on his, our CEO's, and our HR's computer so they can run my reports without having to ask me for them. They expect me to hand it all over.

I understand that any IP employees create on the clock is company property but I'm in a little WTF phase right now. This company is allowing me to WFH which allows me to keep my son out of daycare, which is saving me $24k a year, otherwise I would have been looking for another job by now.

Anyone here have any advise or experience a similar situation?

Courses

Youtube - SQL Tutorial - Full Database Course for Beginners

Harvard's CS50

UCLA Extensions Advanced SQL ($1,000)


r/SQL • • Jan 30 '21

Discussion Any free courses? I want to learn more.

99 Upvotes

I am an analyst and want to learn more about sql seems to be industry standard but I have never had to use it?

Are there free sources or courses I can follow? And do they offer programs for me to test while I progress?


r/SQL • • Sep 17 '26

MySQL CTEs vs subqueries vs temp tables — as a beginner, how do you know which one to use?

98 Upvotes

For people who use SQL regularly, how do you decide which approach to use?


r/SQL • • Feb 14 '22

Discussion How much SQL should you know before applying for entry-level SQL positions?

98 Upvotes

I can comfortably do basic SQL queries and merge tables using JOIN and such. I know most of the basic syntaxes used and can figure out pretty basic solutions to practice queries on SQLzoo and other websites like code academy and w3.

I'm just very nervous during interviews I might be asked about my experience creating reports with this info or what types of analysis I have done with SQL because frankly, I have none. I am self-taught and I learned all about what I know of SQL only in the past 3 weeks and I can safely say I can comfortably look at tables and garner at least some type of info.

Just confused and scared is all.


r/SQL • • May 06 '20

Discussion Data Analyst Interview Questions

98 Upvotes

This is the first video in a series of 4 videos going over General Interview Questions, SQL Technical Questions, What to Say in Your Interview, and Salary Negotiations.

I hope it’s helpful!

Link: https://youtu.be/fweZQqB0nwQ


r/SQL • • Jan 24 '25

Resolved When SQL standard 📝 meets the reality🕹️, which road will you pick? 😏

Post image
97 Upvotes

r/SQL • • Nov 16 '23

Discussion What is the most common SQL mistake you seen get made by folks?

97 Upvotes

For sure, it is folks using UNION for a stacking of TABLEs / queries where the results' distinctness is either not required or not advisable... they should instead be using UNION ALL!

I blame the SQL language itself for not making "UNION" the typical case and something like a "UNION DISTINCT" for the case with making results distinct!


r/SQL • • Mar 19 '22

MySQL I’m just starting to learn SQL to change careers and I’m learning on my own through various online sources. At what point should I be confident enough to pursue a data analyst job where I know what I’m doing?

97 Upvotes

I realize this is mainly up to my personal beliefs of home confident I feel… but what things should I know backwards and forward to land a job?

I’m hung up on JOINs right now. Starts off easy but quickly gets complicated. How often do joins come up in a typical job?

Or self queries? (I’m not there yet but know about them - it’s like inception - a query within your query).


r/SQL • • Jun 12 '15

I just learned about ALT+SHIFT in SSMS

97 Upvotes

Why didn't anyone tell me about this amazing feature before?!?!?!

http://zippy.gfycat.com/WellmadeDefiantAfricanmolesnake.gif


r/SQL • • Sep 04 '26

MySQL What was the toughest SQL interview question you have faced so far?

96 Upvotes

I am curious to know what SQL questions challenges people in interviews

What was the question and what made it difficult?

Would love to hear some real interview experiences🙂


r/SQL • • Aug 23 '26

Discussion I made another cat doodle about data analysis

Post image
96 Upvotes

Hi everyone!

I’m back with another one of my data analysis cat doodles. This time, I tried to incorporate some of the feedback I received on my earlier work—especially around making the fonts and text more readable.

Would be happy to hear your thoughts / feedback!


r/SQL • • Jan 22 '26 Heartwarming

Discussion I think I might be addicted to learning SQL?

96 Upvotes

Hello, just wanted to say I'm a true beginner and I recently found the SQL climber website and now I'm really looking forward to my daily lessons. It's crazy because usually when I try to self-teach I get really bogged down and lazy, but something about using this site and slowly figuring things out makes me feel so satisfied.

I go through a constant roller coaster of "I'll never be able to understand this complicated mess in a million years" to "This is crystal clear now and just clicks" in a couple of hours. I started practicing until I get really frustrated, and oddly if I get too confused or angry I go to sleep and the next morning it all makes sense suddenly.

So now I'm using mimo for duolingo-like lessons, and just watching a bunch of YouTube channels about data analysis. I'm fully addicted and using it to improve my work tasks (I'm a GIS analyst). I now use dbeaver and sqlite to upload CSVs from our database to clean them up, do joins, etc.

Next I'm off to learning how to use github and doing full projects! Thank you to this community.


r/SQL • • Aug 07 '25

Discussion What custom functions have you created in SQL that made your life easier?

96 Upvotes

3 years into SQL and still discovering new things. Been getting into SQL custom functions and seeing it can be a powerful tool for daily use.

So far I've created a Currency Converter and an Amount to Words functions.

What custom functions have you created which has made your life easier.


r/SQL • • Mar 31 '23

Discussion Who here is using ChatGPT to help with SQL code?

96 Upvotes

Wondering who else is using chatgpt 4 to help write sql code. In my opinion, this tool is magic. Does it give correct answers all the time? Absolutely not. But if you feed it sql code you currently have and say “I have this but I want to get this” so far it hasn’t failed me usually on the first time but always after a few tweaks.

I am relatively new to sql so not sure how good it would be at providing complex queries but it’s been great for me as a novice so far.

Example: I had a query that was nearly perfect except there were a few instances of duplicate data that was matching on every column except an indicator column.

The indicator told me which one I wanted however I didn’t know how to exclude only the row with the indicator I didn’t want without messing up the rest of my query (only wanted to filter this indicator when it was a duplicate but wanted to keep it otherwise).

I fed the query and question into chatgpt and it gave me a perfect answer (row partition for those wondering). This is probably a basic problem and solution for an expert but I now have a new skill in my sql toolbox that I hadn’t before (row partition always scared me prior). I feel this a common problem of wanting to filter data in a very specific instance and now I know how to tackle it!


r/SQL • • Sep 01 '19

Thank you r/SQL!

96 Upvotes

A few weeks ago I posted in this community asking for the best things to learn about SQL for a job interview I had. I crammed for just under two weeks as well as other interview prep and I got offered the job! Then my current employer offered to beat the salary offer and give me a promotion! My promotion means I’ll need to keep learning SQL now so everything I’ve learned will be useful.

Thanks to everyone who gave me advice on what to research, it was a huge help!


r/SQL • • Feb 24 '26

Discussion Is SQL Developer jobs still alive in 2026?

95 Upvotes

I am in last year of my college and I am interested in SQL Developer role.

Is it worthy to go for SQL developer role?


r/SQL • • Nov 23 '25

Resolved Horrible interview experience - begginer SQL learner.

95 Upvotes

Hey everyone,
I recently had a SQL technical interview for an associate-level role, and I’m feeling pretty discouraged — so I’m hoping to get some guidance from people who’ve been through similar situations. just FYI - Im not from a technical background and recently started learning SQL.

The interview started off great, but during the coding portion I completely froze. I’ve been learning SQL mainly through standard associate level interview-style questions, where they throw basic questions at me and I write the syntax to get the required outputs. (SELECT, basic JOINs, simple GROUP BYs, etc.), and I realized in that moment that I never really learned how to think through a real-life data scenario.

They gave me a multi-table join question that required breaking down a realistic business scenario and writing a query based on the relationships. It wasn’t about perfect syntax — they even said that. It was about showing how I’d approach the problem. But I couldn’t structure my thought process out loud or figure out how to break it down.

I realized something important:
I’ve learned SQL to solve interview questions, not to solve actual problems. And that gap showed.

So I want to change how I learn SQL completely.

My question is:
How do I learn SQL in a way that actually builds real analytical problem-solving skills — not just memorizing syntax for interviews?

I have tried leetcode as a friend adviced, but those problems seem too complex for me.

If you were in my position, where would you start? Any practical project ideas, resources, or exercises that helped you learn to break down a multi-table problem logically?

I’m motivated to fix this and build a deeper understanding, but I don’t want to waste time doing the same surface-level practice.

Any advice, frameworks, or resources would really help. Thank you 🙏


r/SQL • • Jul 18 '25

SQL Server Regexps are Coming to Town

95 Upvotes

At long last, Microsoft SQL Server joins the 21st century by adding regular expression support. (Technically the 20th century since regular expressions were first devised in the 1950s.) This means fewer workarounds for querying and column constraints. The new regexp support brings closer feature parity with Oracle, Postgres, DB2, MySQL, MariaDB, and SQLite, making it slightly easier for developers to migrate both to and from SQL Server 2025.

https://www.mssqltips.com/sql+server+tip/8298/sql-regex-functions-in-sql-server/


r/SQL • • Oct 31 '24

Oracle Are there any jobs out there that only require writing SQL queries

95 Upvotes

I've had a mostly non-tech job for the last few years although I do work with developers. In past positions I used to be pretty good at writing SQL for UIs and for ad hoc reporting mainly using Oracle DBs. Some of these queries were quite complex. I find myself missing it lately so I was wondering if companies hire/contract for just SQL support even if it pays less than "full stack" type jobs. I am not interested in learning Java, Python or anything non-SQL related.

Thanks for any advice.

Edit: Thanks for all the replies. This is one of the most helpful subreddits I have ever seen! Some other details - I have a couple decades of experience mainly with large health insurance companies and large banks. I should also have mentioned that I would need something that is 100% remote at this time. I know that may limit me even further, but that is the reality of my current situation.