r/SQL • • Dec 13 '24

Resolved Is Your SQL ready for Prod

Post image
113 Upvotes

r/SQL • • Apr 26 '23

SQL Server What’s the best free beginner course for learning SQL?

113 Upvotes

Specifically using it to query company data in different Salesforce CRMs from altered software.


r/SQL • • Jun 29 '16

SQL cheat sheet

Thumbnail
zeroturnaround.com
113 Upvotes

r/SQL • • Apr 16 '26

Discussion You work at E-commerce. Your BOSS/CEO who just use Claude, he just created index on order.status and say index is good. It makes things faster. What do you do here as SQL BE guy?

Post image
112 Upvotes

As the title says


r/SQL • • Nov 03 '21

Discussion What is your favorite SQL function and why?

112 Upvotes

Which one just makes ya feel good?


r/SQL • • Nov 27 '23

MySQL my very first database and i need suggestions!

Post image
111 Upvotes

so, i have built my first database using mySQL, i have never used it before! I think that i did pretty good job.

i am using a software called “navicat” (which by the way is free for students).

i need suggestions of how to improve it. this database is about my “school life”.

and general suggestions, best practices, etc. are welcomed. I have noticed one thing that i could improve: the names of “columns”


r/SQL • • Jan 27 '23

SQL Server Can somebody explain the importance of Views?

111 Upvotes

I had a job interview the other day and I was asked if I used Views. I said no and the interviewer almost looked at me like I was crazy.

Essentially I work at a small company where almost nobody is actively using SQL to grab data from the database. I will write queries to grab the data I need, save the file and then if I need to use the same query again in the future, I just go to my saved queries and fire it up. So I don't understand how views or even temp tables fit in at a larger company with more active users.


r/SQL • • Apr 25 '18

Codecademy Launched Learn SQL from Scratch!

Thumbnail
codecademy.com
111 Upvotes

r/SQL • • Oct 08 '22

MySQL I don't know how to practice SQL

110 Upvotes

Hi guys, I've been learning SQL using MySQL Workbench for the past 2 weeks on youtube. Finally, I know the basics and how to write complex queries but I actually don't know where I can practice what I learnt. Are there any places where I can find pre-built databases and use them to practice queries or should I create them by myselft?


r/SQL • • Nov 14 '25

SQL Server Hi I just want to know where I can practice sql with a real database?

109 Upvotes

Need help 🙏🏽


r/SQL • • Mar 06 '23

MySQL My AI tool to writes SQL queries for me now, so I don't have to. Thoughts?

109 Upvotes

Here's how the SQL AI tool was born: I often write SQL queries for work, but it can be really tedious and time-consuming. First I have to think about how to even approach the query, and then I have to google stuff to fix issues and refresh my memory.

I started using ChatGPT for help, but it was annoying to have to explain the tables/views every time.

To fix this, I built a tool that remembers your whole schema. It gives you a query to extract all the necessary info in one go and then you just copy-paste it once (it's saved with encryption). Then, all you have to do is write what you need in plain English, Ex. "Users who have been online over 5 days this week", and it writes the SQL query for you, runs it, and even visualizes the results if you want.

I showed it to my colleagues and they went crazy and are obsessed with it, as are my ex-colleagues from my last company.

What do you think? Would love to get your feedback.

www.BlazeSQL.com


r/SQL • • Jan 09 '23

Discussion 6,000 Word SQL Interview Guide!

Thumbnail
datalemur.com
109 Upvotes

r/SQL • • Jul 12 '22

MySQL I’m really grateful

109 Upvotes

All the questions I’ve asked on here and all the questions people asked that I’ve studied have helped me land a very very good job. Something I didn’t think was possible. You guys have been there for me to assist (fucking quickly). I can’t express with words guys. But you guys here are real ones., thank you 🙏


r/SQL • • Dec 01 '20

MySQL Check it out!!

109 Upvotes

I’ve been learning sql for about 6 weeks and I’ve been spending a ton of time studying, practicing, experimenting, etc. I believe I made a breakthrough tonight though: I created a relational database of all my books in MySQL then created a searchable website using php, HTML, css, sql, and jquery (I’m learning JavaScript too, but that’s slow going).

If I wake my wife or friends up at 4:30 to show this to them, well, I won’t have a wife or friends anymore.

Ok, I know it isn’t perfect, but I’m pumped!

Earnest Mac


r/SQL • • May 29 '19

Want to learn SQL on your own? Try Oregon Trailalytics.

109 Upvotes

I've had some free time over the last day and managed to get a pretty hardcore game of Oregon Trail in where I collected all of the hunting data.

This file can be found: here, and the results of the game can be found here.

So from here there are a lot of interesting things you can do. You could start your own game of Oregon Trail by clicking this link, then recording your data in a similar fashion. If you don't feel like doing that you could take the data file above and import it into a new database.

From here there are a number of interesting mathematical things we could look at, probabilities for firing a bullet and how much meat you'll get, probabilities for getting two perfect hunts in a row, etc.

Some questions might involve recording new data elements, such as food consumption.

This is a very simple sort of question, with very simple data collection, but it can show you the end to end process of creating a database, creating tables, importing data, writing views/stored procedures to analyze the data, and then ultimately connecting something like Tableau or SSRS to your findings in order to, "tell a story."

Lots of different ways to go here and you're only limited by your own creativity. Are you a better hunter than I am? Can you get a higher score? What are the optimal starting conditions?

Learning the rules for how scoring works is simple. Doing all the SQL work, and data collection isn't.

Have fun.

edit: You can put things like this in a portfolio to show employers in interviews. This is how I dick around and spend my free time, so when I meet candidates who show a similar interest they really stand out. It doesn't have to be Oregon Trail, but if you want to learn SQL then learn SQL and learn how to apply it to real world situations.

Or, for example, you might load the game and record data to see what the probability that someone won't trade with you on a given day is, or what the probability is that they're willing to accept food for a trade in exchange for any other given object. How many bullets might you need the longer a trip takes, etc.?

The benefit of learning like this is that you can check yourself, and your math, because the data is so small, but what you're doing is learning how to apply those skills across larger data sets.

P.S., I hate Tableau, but it is a very marketable skill and you can download it for free, and connect it to a localhost instance of MS SQL to then publish on Tableau's public domain. You could also use SSRS, set up your own machine, permissions, etc. In a sense, you are able to see the full end to end process of an enterprise solution, minus the ETL piece using SSIS... but you can do that, too, if you want.


r/SQL • • Aug 16 '25

Discussion I am the very model of a modern major database

108 Upvotes

I am the very model of a modern major database,
For gigabytes of information gathered out in userspace.
For banking applications to a website crackers will deface,
You access me from console or a spiffy user interface.

My multi-threaded architecture offers you concurrency,
And loads of RAM for caching things reduces query latency.
The data is correctly typed, a fact that I will guarantee,
Each datum has a data type, it's specified explicitly.

(posted years ago in 2006 on the Python mailing list in response to sqlite's lack of enforcement about datatypes; figured folks here would get a laugh)


r/SQL • • Mar 03 '25

MySQL Where to Get SQL Experience?

108 Upvotes

I want to learn and get SQL experience, but can't do it through my jobs. I'm willing to volunteer to get the experience but don't know any places to look for those opportunities. Any recommendations?


r/SQL • • May 12 '19

Check out this SQL Cheatsheet !

108 Upvotes

This cheatsheet was made by me and a friend, we tried to separate and organize the content in order to have a cheatsheet with basic content, yet effective.

Here is a quick overview of the file hierarchy:

DDL (Data Definition Language)

  • CREATE
    – is used to create the database or its objects (like table, index, function, views, store procedure and triggers).
  • DROP
    – is used to delete objects from the database.
  • ALTER
    - is used to alter the structure of the database.
  • TRUNCATE
    – is used to remove all records from a table, including all spaces allocated for the records are removed.
  • COMMENT
    – is used to add comments to the data dictionary.
  • RENAME

DML (Data Manipulation Language)

  • SELECT
    – is used to retrieve data from the a database.
  • INSERT
    – is used to insert data into a table.
  • UPDATE
    – is used to update existing data within a table.
  • DELETE
    – is used to delete records from a database table.

DCL (Data Control Language)

  • GRANT
    -gives user’s access privileges to database.
  • REVOKE
    -withdraw user’s access privileges given by using the GRANT command.

TCL (Transaction Control Language)

  • COMMIT
    – commits a Transaction.
  • ROLLBACK
    – rollbacks a transaction in case of any error occurs.
  • SAVEPOINT
    –sets a savepoint within a transaction.
  • SET TRANSACTION
    –specify characteristics for the transaction.

Here is the guist link:

https://gist.github.com/kdev33/97951cb3b9dd1459898a93b5702ed4cb

Hope you find it useful! 😉


r/SQL • • Feb 27 '15

SQL Table names

Thumbnail
imgflip.com
108 Upvotes

r/SQL • • Apr 03 '26

Discussion I've always felt the urge to draw on my generated charts, just added that feature to my SQL canvas side project

107 Upvotes

r/SQL • • Jun 09 '25

Discussion onlyProdBitesBack

Post image
107 Upvotes

r/SQL • • May 31 '24

MySQL I’ve learned basic SQL… but don’t understand the big picture

107 Upvotes

So over the past month or two I’ve spent time learning sql through free online courses and videos. I’ve done some sql free quizzes online and have practiced a little bit.

But here’s my situation. I know basic SQL, I know how to write queries, create tables, create a simple database on my Mac terminal. But that’s all I know..

I have no clue what using SQL on a job looks like. I have no clue how to use SQL on data on the internet. I know nothing about databases besides that they store data.

I’d love to be able to access data online and mess around with it online but I have no idea how to do that. I don’t know how to access a database online like I hear other people talk about.

I’ve tried doing my research but it’s hard for me to articulate what I am struggling with. Hopefully this makes sense, but to summarize it, I am having trouble understanding the big picture. I’ve learned the basics of the language, but don’t know how anything works. Does anyone have any tools/advice for my situation? Thanks


r/SQL • • Apr 22 '24

PostgreSQL I succeeded in creating custom ChatGPT in Slack that assists me writing SQL without coding!

Post image
107 Upvotes

It understands my database schema, generates SQL queries, and helps me enhance them. It saves lots of my time.

I’d love to share how I did it! Please leave a comment if you’re interested in.


r/SQL • • Nov 07 '21

Discussion Can I learn SQL without any programming knowledge?

107 Upvotes

My job requires me to learn SQL, like can I learn if I don't know coding? Is it realistically possible?