Recently at work I’ve been assigned a few different tasks involving databases and using Microsoft SQL server. I quickly realized that it has been sometime since I have written SQL queries and decided it is best for me to review some of the basics. Here's what I relearned!
Basically, SQL is the language of databases. SQL stands for Structured Query Language. Structured Query Language is a standard Database language which is used to create, maintain and retrieve information from a relational database.
In a database, information or data, are stored in tables inside the database. Tables consist of columns and rows and are identified by a unique name. Each row represents an item and a column provides the properties of the items. You can think of a table as kind of like a spreadsheet.
Databases are used to store data for a majority of the applications/websites that we encounter on a day to day basis. Having a good understanding of how databases work and how to create a SQL query can go a long way in the tech industry! I will be diving deeper into SQL and how to create advanced queries, I suggest you do too. Thanks for stopping by, I hope you enjoyed it!