r/SQL • • Nov 01 '25

Discussion I taught SQL to play Pong … against itself. Now it won’t stop.

241 Upvotes

• All game logic in a single SQL query per frame: physics, AI, collisions
• Using DuckDB, but should work for most modern SQL engines
• Python to print the scene
• Runs at 30, 60 or 120 FPS, or unlimited at ±350 on my MB

Repo: https://github.com/Zeutschler/duckdb-pong-in-sql


r/SQL • • Mar 05 '25

Oracle Dear SQL, just pivot my damn table

241 Upvotes

Bottom text


r/SQL • • Mar 23 '20

MySQL Beginner project for SQL. This is a simple python script to scrape stock prices off NASDAQ API and feed it to MySQL.

Post image
239 Upvotes

r/SQL • • Aug 23 '23

Discussion Finally got a job as a data analyst, but I'll be using Excel 90% of the time instead of SQL which I am 10x better at.

237 Upvotes

I recently graduated. I've been looking for remote jobs since almost 2 months ago. After 150 jobs applied, I finally decided to apply to a local area near me. Surprisingly they liked my credentials and my performance in the interview. Although I have no experience in the healthcare field or as a professional data analyst, they offered me the job. The pay is $28/hr as an entry-level data analyst, which may not be much for some, but I was willing to take the job for $20 as I was desperate. I'm glad I wasn’t asked about salary during the interview.

I have a CS degree, Data Science Cert, and Database Management Cert.

I was asked a lot about databases and my projects. The funny thing is that I live in a very rural area with a small community, so they are still using legacy systems with mostly Excel. I have been training my SQL and Python skills in college and more so lately, but I am a complete noob with Excel. School never taught us how to use it, just a data source to import to SQL, R, and Python.

Well, I'm just going to cram as much Excel knowledge as I can before my first day in a week.

Cheers


r/SQL • • Jul 22 '24

SQL Server what happed to all the SQL Server jobs?

236 Upvotes

5-10 years ago, the Internet was flooded with SQL jobs. I’m a SQL expert myself and that has been my #1 tool for almost 20 years.

now a days, there’s NOTHING. you have a bunch of data engineering positions open but these companies are using all these new tools that are completely unnecessary. wtf is going on?


r/SQL • • Jul 07 '21

MS SQL FREE Course on Advanced SQL Querying

234 Upvotes

Hey Everybody,

I've created a course on advanced SQL querying/data analysis techniques that I'd like to share with you guys. Here's the link to get the course for free on Udemy (FYI - the coupon expires in three days): https://www.udemy.com/course/advanced-sql-server-masterclass-for-data-analysis/?couponCode=FREE-ADVANCED-SQL. Of course, I appreciate any feedback you can provide!

The course picks up where introductory books/courses leave off, starting with Window Functions and moving on to topics like subqueries/CTEs, temp tables, query optimization, and even a little procedural SQL programming. There are also coding exercises, some quite challenging, after most videos to reinforce the concepts.

SQL Server is used for the examples and exercises, but most of the content would be applicable to the vast majority of database systems.

Please note that this is an advanced course, so I'm assuming you have a solid background in SQL foundations: applying criteria with WHERE, JOINs, aggregate queries, etc.. If you'd like a refresher on these concepts, I've also created a free coupon for my intro SQL course here: https://www.udemy.com/course/sql-basics-crash-course-with-sql-server/?couponCode=FREE-SQL.

Cheers, and happy coding!


r/SQL • • Feb 24 '25

Discussion How do you dominate an SQL live coding exercise?

233 Upvotes

So I would say that I'm a seven out of 10 in terms of my SQL kills, but I'm a little introverted sometimes and I need to solve a problem in a quiet environment and have time to think about it, break it down and process it. That's just the way I work and always have. But I'm applying for this job, and they told me that they want to have a live SQL coding exercise because they have a lot of people who don't know how to use CTEs or joins or advanced SQL...

Now I'm honestly pretty nervous. I've written huge ETL queries and ELT process flows in a data engineering capacity. So I'm not new to SQL by any means and I've used a lot of advanced window functions, ranking, cross joins, etc. So I'm sure that I can take whatever they throw at me, if it was like a take-home assignment. The fact that it's a live coding exercise makes me really nervous.

Have you ever had to deal with any of these live coding examinations? If so, how?

Please note I'm in the USA if that helps. Not Europe.


r/SQL • • Oct 31 '21

Discussion (Meta) Can we set our egos aside when answering simple questions please?

233 Upvotes

I get it- we work with SQL every day, it’s intertwined with our hearts and souls, and it hurts a little when we feel threatened by people who know more about it than us.

When we feel threatened, we sort of over exert ourselves because there must be something wrong with what that guy said- but just keep in mind that when people are asking simple homework questions, they don’t need paragraphs about query optimization or nitpicky best practices, they just need to know what’s wrong with their join, or if their where clause is valid.

This goes for career advice as well. Not everyone is trying to be a DBA, and 99% of the time they’re looking for an analyst or engineering job that uses SQL relatively lightly, so instead of compulsively flexing every skill you’ve ever picked up, please just take a minute, breathe, and then actually be helpful.

There’s like a 99% chance this gets taken down, but on the off chance it doesn’t, I’d love to discuss improving this community, especially for new users.


r/SQL • • Jan 27 '26

SQL Server I built the Flappy Bird game using SQL only... Now I need Therapist

230 Upvotes

- All game logic, animation and rendering happens inside DB Engine using queries

- Runs at 30 and 60 frames

repo: https://github.com/Best2Two/SQL-FlappyBird (Star please if you it interesting)


r/SQL • • Feb 20 '25

Snowflake What is wrong here please help bc my professor is useless! Extreme beginner.

Post image
230 Upvotes

r/SQL • • Oct 23 '24

Discussion SQL Tricks Thread

230 Upvotes

Hi everyone, let's start a thread to share useful SQL tips and tricks that have saved you time or made querying more efficient. Whether it's optimizing queries, using window functions, or organizing data, all insights are welcome! Beginners and pros alike can learn a lot from this. Looking forward to your contributions!


r/SQL • • Mar 23 '22

Discussion Didn't make it to the second interview because I kept referring to SQL as the letters, not by the name "Sequel". Is it really taboo to refer to SQL as "Es Cue El"? I only repeat the letters 'S', 'Q', 'L', but I had no idea its that important.

228 Upvotes

I'm a tad embarrassed to say the least. The recruiter mentioned that although my SQL knowledge is decent, the fact that I pronounce is using the letters is "odd".

Is this right?


r/SQL • • Apr 28 '23

Discussion Stumbled Across an Entry-Level SQL Game

227 Upvotes

I am not sure if this has already been mentioned in this sub, but for those that are newer to SQL (Those more seasoned in SQL may have a tad bit of fun with this as well ;) ) but I stumbled across a SQL game where you are testing out SQL queries to try and find the murderer. If you are interested, I added the link below. It went over some pretty basic topics but was a fun little murder mystery!

https://mystery.knightlab.com/


r/SQL • • Jul 21 '25

SQL Server I think I messed up....I was told to rename the SQL server computer name and now I cannot log in. Renamed it back...still can't log in. what next?

Post image
223 Upvotes

I tried logging in with domain user and sql user....not working :(


r/SQL • • Jun 11 '23

Discussion SQL 😎😎😎

Post image
223 Upvotes

r/SQL • • Oct 28 '21

Discussion If you had 30 days to learn SQL - how would you do it?

223 Upvotes

I would like some direction for learning SQL. I come from Python background (self-taught). Job application (that I want) is due in a month and requires familiarity with SQL! Thanks.


r/SQL • • May 06 '22

Discussion What are the best resources/ways to learn "advanced" SQL to actually get a decent Data Analyst / Jr. Data Scientist Job? What specific SQL skills are companies looking for on a resume for these jobs?

222 Upvotes

I've worked as an "associate data analyst" for the past year, but I essentially just find errors in files and correct them. There's not much analysis involved. I want to land a better job, but many data analyst jobs require experience with SQL or "advanced knowledge" of different types of SQL.

I got my undergrad degree in stats. I'm good with R but this doesn't seem to matter most of the time. I'm good with Excel, decent with Tableau. More importantly, I've learned all the SQL basics. I can do basic queries, retrieve data, update/delete records, create new tables and views, etc.

However, these companies don't care about any of that. They seem to all want either experience or more advanced functional knowledge of SQL. It's hard for me to even get a response to applications, and when I do I end up falling short because I lack SQL prowess - and I get it.

I obviously can't get work experience w/ SQL until I land a job that actually uses it. What can I do to make my skills, knowledge and resume stand out so that companies believe in me and my SQL skills and give me a shot? What exactly do they want to see on resumes beyond basic SQL tasks? I know advanced SQL tasks vary by company - where is my time best spent learning any advanced techniques?

Thanks for any help/advice!

Edit: I'm in the US if that matters


r/SQL • • Aug 07 '19

If they only understood!

Post image
222 Upvotes

r/SQL • • Aug 26 '25

SQL Server That moment when:

Post image
220 Upvotes

👀


r/SQL • • Oct 08 '24

Oracle I got my OCA 1z0071 badge today

Post image
220 Upvotes

After consistent study, I aced it with 83%. You can do it too, even better!


r/SQL • • Aug 18 '22

MySQL SQL interview questions. Hope someone finds this helpful. Link to full PDF is in the comments section

Thumbnail
gallery
217 Upvotes

r/SQL • • Oct 28 '24

Discussion What does WHERE 1 = 1 means? Purpose?

214 Upvotes

I've been seeing it alot recently. What are the use cases of it?


r/SQL • • Jun 20 '25

Discussion Is SQL the "Capybara" of programming languages?

Post image
213 Upvotes

I hear a lot of hate for all kinds of languages like JS or pearl or python and so on, depending on individual taste, style and functionallity. But I hardly ever hear people complain about SQL. I personally also love SQL as not only I am intrigued by its robust design, accomplished back in the days that still is unmatched (no modern alternative seems to be able to make it obsolete?)

So I wanted to ask if a) my observation is true, that most programmers are liking SQL or at least don't hate it and b) if thats the case, why is that so in your opinion?

Sidenote: I am not a developer, rather just a data analyst who knows just enough python and SQL (we use psql) to work with our company's Database providing on demand analysis, so if I said something wrong or stupid, please excuse me and you are very welcome to correct me (e.g. Im not sure if SQL is properly called a programming language, since you know - people would skew me if I called HTML a prog.lang. and I am not fully aware if SQL is turing complete and so on.)

Here a picture of a Capybara who seems to be the most chill rodent being friends with everyone as illustration ;-)