Week 11: Muddy - SQL

This weeks lectured covered Database's and their many functions. Something that was not fully covered and a bit confusing to me was SQL. SQL stands for Structured Query Language and the textbook defines it as " a query language that allows users to manage, update, and retrieve data." SQL can be very beneficial as many relational database products for servers, personal computer databases and mainframes use it. Object-oriented databases have several advantages compared with relational databases that include additional types of data, faster access times and you can re-use objects. Here are a few examples of applications that can be used for object-oriented databases.

A. Multimedia Database - These are databases that store different types of multimedia like audio and video or even image files. Some also may store more then one like TV files which store audio and video.

B. Groupware Database - This type of databases stores documents such as schedules, calendars, memo's and reports. One can search through these documents to make their tasks easier and more efficient.

C. Computer Aided Design Databases - Databases that store different engineering and architectural designs. These designs come from software like AutoCAD.

After digging around the internet, I stumbled across a great SQL reference website found at: http://www.sql.org/. This website has great material regarding SQL and how to properly use it and implement it with databases through tutorials and other instructional material.

Using SQL can be very important in a business environment, especially those who frequently use Databases. As one becomes more familiar with SQL it can make their daily tasks easier and more efficient which will create a better bottom line for the company.