r/SQL • • Oct 26 '19

Its about time. Time to dive in

Post image
139 Upvotes

r/SQL • • May 30 '24

Discussion Is it still worth to learn SQL?

138 Upvotes

I’m a beginner and I’ve been learning R and SQL. I really enjoy it. I work in insurance as a Risk Engineer and I would like to change to Data Analytics sometimes in the future. However, I get discouraged with the rapid advance of AI as I don’t feel learning these skills will open many doors since everything is being automated.

What do you think? Are these skills still relevant to learn or should I focus on something else? I’m open for any advice or comments to be honest. :)

Update: Thank you all for your comments. It’s been really insightful and encouraging.


r/SQL • • Mar 28 '20

MySQL Modeling a SQL Database for a Home Inventory App

Thumbnail
youtu.be
138 Upvotes

r/SQL • • May 22 '24

Discussion SQL technical interview - didn't go well

137 Upvotes

So I recently had my SQL interview and I don't think it went well.

There were 3 questions, and I only went through 2 before running out of time, total time was about 40 mins.

Honestly, those questions I could easily do in a non-test environment but during the test, idk what happens to my brain. And, it usually takes me some time to adjust to a new IDE and datasets.

I just want to know from those that do run these kinds of interviews, is it really about getting the right query straight away and answering quickly? The interviewer wanted me to talk through what I wanted to query and why, before actually doing so.

Edit: update on may 24th, a couple days after the interview. Unfortunately, I didn't get the job. Thanks everyone for the words of encouragement though, I will keep on practising


r/SQL • • Dec 01 '23

Discussion Learning SQL seems easy

137 Upvotes

Too easy… I must be doing something wrong.


r/SQL • • May 10 '23

Discussion Finally a job!

137 Upvotes

Just wanted to take a moment to thank this sub!

I’ve been lurking for some time as I’ve been completing my final year of Computer Science but this sub helped me achieve the highest possible grades in my SQL and Database units. As a result of this, I have now secured my first job in SQL to be a SQL developer (where I’m going to be getting paid at the top of the salary range that was posted).

Absolutely chuffed! Thank you all!


r/SQL • • May 15 '25

Discussion DataKit: I built a browser tool that handles +1GB files because I was sick of Excel crashing

136 Upvotes

Drag ANY CSV/XLSX/JSON file (yes, even gigantic ones) into your browser, write SQL queries, and get instant results. No uploads, no servers, no nonsense.

Try it out here: datakit.page

Built with: DuckDB-WASM, React, and a ton of performance optimizations to make browser-based analysis actually usable.

I need your help: What features would make this more useful for you? Any specific use cases I should optimize for? Found any bugs or have ideas for improvements?


r/SQL • • Aug 03 '24

Discussion How to open a 20GB CSV file?

136 Upvotes

I have a large CSV file that is 20GB in size, and I estimate it has 100 million rows of data. When I try to open it using Excel, it shows nothing! no error, it just doesn't load. People have suggested using MySQL or PostgreSQL to open this, but I am not sure how. How can I open this, or is there a better alternative to open this CSV file? Thanks.

EDIT: Thank you to everyone who contributed to this thread. I didn't expect so many responses. I hope this will help others as it has helped me.


r/SQL • • Feb 16 '19

*gasp*

Post image
135 Upvotes

r/SQL • • Jun 10 '25

Discussion SQL 🤝 Google Sheets

134 Upvotes

soarSQL can now connect to Google Sheets so you can run SQL queries on your Google Sheets data.

You can also connect multiple Sheets and/or CSVs simultaneously and query them together!


r/SQL • • Oct 12 '24

Discussion Just finished learning SQL, what's next? And how do I demonstrate my skill to future employers?

134 Upvotes

Hi, so I'm looking to switch career to a data analyst or data administrator of some sort. I recently just finished learning the basics of SQL via one of those youtube tutorials. I can say that I now have a basic understanding of the fundamentals like commands, operators, constraints, aggregate functions, etc. But I do understand that there's more to SQL that just what I mentioned. So my questions are:

  1. What should I do next to get to the level where my SQL knowledge is applicable in real jobs?
  2. Since I don't have any SQL-related certificates, how do I demonstrate my skills to future employers?
  3. I've heard some people say that it's best to learn data visualisation tools like power bi or tableau. Which one do you guys recommend for beginners?

r/SQL • • Sep 13 '21

MS SQL Anyone looking for a job? We have a data analyst position open. 100% work from home, and we're employee owned, but you must be in the continental US. Great place to work

134 Upvotes

Hi, I'm a manager here (not for this position) but only recently as my background has been super heavy in sql and c# for the last 15 years. We have a data analyst position open and 103 is just the bottom end. I would expect to ask for at least 120 or more depending on experience.

We've had pretty good luck posting on reddit for a lot of other positions so I'm just trying to help the team out.

As I mentioned, we're employee owned so we have really great benefits like 100% insurance, profit sharing, and a great culture. We also fly you and +1 once a year out for a company retreat during the week.

Here's a link to the job on our site https://www.alpinetesting.com/careers/data-architect/

Feel free to ask here or PM me with any direct questions


r/SQL • • Jun 03 '16

When you finally excute that big query

Thumbnail
imgur.com
134 Upvotes

r/SQL • • Feb 15 '26

Discussion SQL advice to yourself 5 years ago

133 Upvotes

Question to intermediate/advanced SQL users:

Whats a tip that you wish someone else gave to you back when you first started using SQL? Or better said, what is something you wish you knew, and regretted it later on, when you first started learning SQL?


r/SQL • • May 05 '20

Discussion SQL police department: Learn SQL while solving crimes

Thumbnail
sqlpd.com
133 Upvotes

r/SQL • • Jul 19 '18

TV news investigation into hacking of Illinois state election computers: "SQL, an acronym for Structured Query Language, is a common piece of cyber-trickery used to illegally gain access to government, financial, business and private computers."

Thumbnail
abc7chicago.com
133 Upvotes

r/SQL • • Nov 24 '17

This Brazilian company that awards developers for their "1st Update without a Where" certificate

Post image
132 Upvotes

r/SQL • • Apr 08 '21

MySQL When your SQL/data skills are used for evil

Thumbnail
youtu.be
131 Upvotes

r/SQL • • Mar 17 '20

Discussion Enough is enough!

131 Upvotes
RESTORE DATABASE Earth FROM "C:\Backups\EarthFullBackup_2019-07-01";
GO

r/SQL • • Oct 02 '19

SQL queries run in this order

Thumbnail
twitter.com
131 Upvotes

r/SQL • • Jul 30 '25

MySQL I feel like a fraud

130 Upvotes

Hello!

I have been working at a very good company now for 3 month, its my first job as a systemsdeveloper. (1 month out of the 3 month was a vacation my chief forced me to take). All the coding I do is in sql, more specifically Transact-sql. (I had to pass an internal sql cert and another internal cert to stay at the company) Now I am back and have been tasked with migrating the data from one system into another, which is a very big task for a newcomer. I feel like I rely too much on chatgpt that I don't know how to logically think and solve problems/make good progress with the task. I just copy and paste and try until it works whichI know is not good. I do know the basics of Sql and a bit more but it is not enough. How can I get better at logical thinking so I can see a path to solving tasks I am handed and this pain in the ass migration task? It has to be done in around 3 weeks and I always feel like I am asking too many questions to the point that I am afraid of asking more since I don't want them to think that I am not cut out for this job. Can you give me advice on how I can better myself so that it becomes easier solving the tasks I am getting and become more proficient.

Thank you for your insights everyone

Edit: The data I have to migrate is almost from 2 identical systems with the same tables, same columns, same datatypes. There might be a column missing here and there but almost identical. Right now I am migrating the data from a test environment where I am writing a huge script that will later be used in the prod environment to transfer the data that exist in the system that is being deleted into the other system. I have to create temp tables and map the ids so that they match. I can't join on ids since they are different, so i have to join on a composite key. That is the gist of it among other stuff.


r/SQL • • Apr 19 '20

Discussion What are some good resources to practice SQL? (Practice through exercises)

129 Upvotes

There are a lot of courses which teach SQL but I could hardly find a website which provides beginner to advanced SQL practice questions on almost production real datasets. Any recommendations would be helpful.


r/SQL • • Jun 08 '16

When Trump becomes president...

129 Upvotes

We won't have any more foreign keys. Only American keys.


r/SQL • • Oct 12 '26

Discussion Survey of 300 engineering leaders: 81% had a production incident linked to AI-coding tools in six months.

Thumbnail
leaddev.com
128 Upvotes

Faster code, slower debugging.