Sunday, February 9, 2020

B5 - What is SQL and Why is it Important

Structured Query Language (SQL) is a database language that is used to communicate with databases. To start, a database is simply a library of information that is stored online. Data is extremely important in the world today and some databases may become enormous and hard to go through. This is where SQL comes into play. To put simply, SQL pulls specified data from these databases for the user to either analyze or manipulate. Furthermore, it is easy and is highly recommended to learn. This is important because in this advancing world, databases will only be increasing in size and to be able to quickly go through all of the data, SQL allows the ability to do that while filtering, modifying, and analyzing it. Because it is a universal language, it can integrate into other scripting languages. Another benefit of learning this is that it is high in demand in the job industry. A con regarding SQL is that it is a language that mainly only speaks to relational databases. A relational database is basically a tabular database. 



Comments


I think object oriented databases would definitely play a role in our industry. Due to an object based database, the information that is being shared throughout the teams would be easily filtered or manipulated to portray/show what they want.


This definitely helped me understand my research on SQL a lot more since SQL is used to pull data from relational databases. Databases are everywhere in our life and we use it for many different things and you came up with great examples.


Showing data through objects and classes seems extremely beneficial for our industry. It is easily managed and the information can be shared through many different teams. Learning this and understanding the many different types of databases allowed me to understand more of why there are so many different types. Some databases are more beneficial to certain applications than others.

6 comments:

Michael Manley said...

I think your analysis of SQL gave a really good overview of what the language is and what it accomplishes. I agree with you that SQL fulfills a very important task in proving a uniform way pull data. Although SQL is primarily designed for relational databases, there are many SQL-like languages that operate very similarly to SQL and work on non-relational databases. Good work!

Manon Flamini said...

Brian,

You did a good job describing what SQL is and why it is important. Databases are being used more and more everyday, and it is important to have a language that allows us to use them efficiently. I am currently learning SQL and I can see how its application is beneficial in managing databases and the advantages there are to being proficient in it.

Madeleine Walker-Elders said...

Hi Brian,

SQL databases can be extremely important to holding information, and running queries in order to analyze that information into useable data with meaning. I agree that it has a major weakness by only being able to operate with relational databases, but there are many languages that can bridge the two. SQL is a necessary baseline information language to build off more database-related knowledge moving forward!

Varsha Ajith said...

Brian,

You have very concisely explained what SQL means and how it is used. Although databases are often seen as a valuable resource, it can definitely become difficult to navigate some really huge ones that have a lot of information on them. So, I see why it is important to streamline the process of referring to them and using SQL to essentially speak to the database to extract only the information that is needed.

cory said...

Brian,

I think your description of SQL as a program is excellent. SQL is an excellent tool for creating, indexing, and modifying databases. I also agree that its status as a universal language makes it all the more valuable because of how easily it can be integrated into other languages. furthermore, i agree with your sentiment that since it is so useful, it is a very marketable skill and that will only increase as time moves on, especially in the design industry.

Larisa Parshakova said...

Your post is very informative. I haven’t dealt with database languages before and to be frank did not know that such a thing existed. It is very fascinating that with the development of a bigger data structure there are ways to ease communications within them and make extraction of the information less complicated. However it is good to know that SQL deals with only relational databases, that’s quite a limitation.