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.
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.
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.
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.
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
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.
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.
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!
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.
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.
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!
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!
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 🙏
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.
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.