Acronyms Are Hard SQL
Acronyms can be hard to figure out. If you want proof, look no further than our Acronyms Are Hard Series! If you’re looking to learn more about the basics of SQL, look no further.
Dave and Alex were working on some new videos. When Dave asked Alex was SQL stood for (because it made a good video) this addition to Acronyms Are Hard was born.
SQL which can be pronounced as “ess-que-el” or S Q L. SQL stands for Structured Query Language. Basically it’s the standard language for relational databases.
Where Do We Use It?
A lot of places! When we’re talking about an MES, we typically have the software and the SQL database(s). Generally the SQL databases are going to store all the data.
Think of it as your machines have sensors. Those send information to your MES. The MES will not store that information, it passes through and is stored in your SQL database.
Now for the fun part! Queries.
To run those reports and find information, we ask the SQL questions. Those questions are called queries. Karen, this query is for you!
If you’re experienced with databases, you can query directly to the database. A Corso system is going to have your normal queries set up. Plus we’re going to give you an easy interface to continue the queries. A lot of people opt to pull a database and then use Excel to quickly filter.
Where the rubber hits the road. So now you know what SQL stands for (Structured Query Language) and how to pronounce it.
Now where are you going to use it?
The most common SQL databases we run across are: SQL Server, MY SQL, and MS SQL. Dave’s major difference between them: who you’re paying for the service. Generally speaking, there isn’t going to be a noticeable difference after we get a system up and running.
Want to have some fun? Go down a rabbit hole and see how many different types of SQL Databases you can find. Start with PostgreSQL and go from there.
Want To Learn More?
There are tons of really good places to learn more about SQL as a programming language. We’ve had good luck learning and searching at W3School. If you need to understand more about running queries this is a great place to start.
WARNING: Please be careful. If you start scripting or writing to the database. You can break everything. We all know stories of people who have wiped entire databases. There isn’t an undo button with these. That’s why Dave does his best to never write or query directly to the database.
Want to know more about MES and other databases check out THE Ultimate MES Guide!