Blog 5 - SQL

This assignment required students to read about databases with a particular topic in mind. Each group had a separate topic to explore. I will be reading and discussing about Structured Query Languages (SQL) using information found online.

First, a SQL is a means of communicating with a database and has been adopted by the American National Standards Institute (ANSI) as the standards. Various commands of SQL are present in the different database systems but the simple ones are capable of doing almost everything a user needs ("Sqlcourse - Intro" 2019).

Relational database management systems present data in tabular format. Searching, creating, populating, updating, and deleting are basic functions in SQL that most people will do with a table whether or not it is through using SQL.

Why is using SQL important? Well, most things can be represented as points of data and a large compilation of data into big data can be daunting to use and maintain. However,

SQL is able to perform functions across the entire database meaning that as long as the user has some idea of what they are looking for, they can use a combination of functions to narrow down the data until they find what they want ("Sqlcourse - Intro" 2019). This is why it is important to design a database properly. Proper management of a database using SQL prevents any hiccups in the future and provides better user experience.

After reading Nick Maloney’s post, I interpreted his idea of BIM using “massive amount of data in order to perform their intended functions” as manipulating the elements and their properties in the model and having Revit show the user what the model looks like on the front-end of the software.

It is even more important to companies who provide a service such as insurance or social media. These types of companies can have records of millions of people and they can have actuaries who can determine how much people should pay for insurance or marketers to personalize advertisements on social media.

While SQL may not be a necessary skill to have in the near future, being able to maneuver through data in a table has been a useful skill since the creation of spreadsheets.


Sources:
Maloney, Nick. 2019. "B5 - What Is SQL And Why Is It Important?". Ae-410-510-Ay18-19.Blogspot.Com. https://ae-410-510-ay18-19.blogspot.com/2019/02/b5-what-is-sql-and-why-is-it-important.html.

"Sqlcourse - Intro". 2019. Sqlcourse.Com. http://www.sqlcourse.com/intro.html.


Comments on colleagues’ posts:
Blas Andres Rodriguez Vieira
With the advent of big data being used in most companies, it is becoming more important to be able to manipulate data. When we were freshmen/sophomores, we were taught how to use MatLab and Excel but I feel like it will no longer enough in the coming years. Thankfully, the freshmen now are learning programing languages that I feel like it is incredibly useful when learning SQL.

Nana Lin Rasmussen
I think that the tabular method is very easy for beginners whereas more networks of data can be trickier to learn about. I didn’t feel like I was able to handle the database assignment in this class but I feel more confident now that I know how simple it can be.

Yicheng Li
It looks like you have experience with MySQL. What do you think of the usefulness of SQL in the job market today? I don’t have any experience with big data so if you think this is useful then I might be inclined to pick up some SQL.