Stephen Pettit - B5 - What is SQL?

What is SQL?

SQL is a computer programming language that is connected to informational databases. SQL stands for Structured Query Language. A database is a tool that basically stores any kind of information you input.[3] SQL extracts and organizes information that is listed inside a database. SQL is one of the most popular coding softwares that competes with Java, C++,  Python. SQL is able to handle a tremendous amount of information[2] It can control millions of data in rows and columns which is very helpful.[2] Some companies are huge, and have databases with what it seems to be infinite amount of information. SQL is very useful in extracting specific information. There is also database management systems that has SQL built into the software. MySQL is one of the most popular engines that uses SQL. MySQL is "generally used on web servers" which makes it a very popular option.

Why is SQL important?

SQL is one of the most desired coding programs from companies. It is a very strong skill to possess, because of how many companies utilize databases.[1] In general though, you are able to find specific data very quickly rather to spending hours, days, months, even years trying to find data. SQL doesn't limit to extracting data, but also allows the user to modify the data, and the combine data from other sources as well.[4] It is also very easy to find a data based job, if you are proficient with SQL. Apparently it is very easy to learn too, because it does not require nearly as much code as other programs. One unique feature that I found is that it can be used on smart phones in addition to laptops, and PCs.[5]           

Work Cited
[1] https://tableplus.com/blog/2018/08/why-sql-is-the-most-important-skill-to-learn.html
[2] https://codingsight.com/structured-query-language-importance-of-learning-sql/
[3] https://www.businessnewsdaily.com/5804-what-is-sql.html
[4] https://blog.stoneriverelearning.com/6-reasons-why-you-should-learn-sql/
[5] https://www.javatpoint.com/dbms-advantage-of-sql

Comments

https://ae-410-510-ay19-20.blogspot.com/2020/02/a-database-in-simple-terms-is.html

Pritesh,

I am not too familiar with databases, but my understanding is that most types of databases are similar to each other. And that the main difference between other databases is how the data is interpreted. Object database seem to be able to paint a better picture for the user. Also, when the database gets more intense, object databases would probably break down the situation more clearly. It would show how sub categories are connected with each other.

https://ae-410-510-ay19-20.blogspot.com/2020/02/design-offices.html

Jake,

I found your post very interesting because I currently work for a MEP form for the mechanical department, and I design ductwork/piping on Revit. Databases will help me in the future when I get more involved in the engineering aspects. Dynamo is a perfect example on how it can extract information from the BIM server Revit to minimize time spent on digging information. For this assignment, I research SQL which is a coding program that is used on databases. The SQL allows you to organize the data in large databases like you described.

https://ae-410-510-ay19-20.blogspot.com/2020/02/b5-relational-database.html

Douha,

I found your post very interesting, and thought you did a great job explaining in more depth about a relational database. The image made it more clear as well. Another interesting thing you brought up is the registration process at Drexel. Never realized that was considered a database. Also after researching SQL it makes more sense how it can be used to extract data from a relational database. All of the information in the tables can be extracted and modified from SQL, and this cleared it up for me.