How Does SQL Work?{2}

The article is choose to read this week is ” How Does SQL Work?” by Josienita Borlongan. The article is very straight forward and the author started the article right away by explaining it into four parts such as definition, uses, Features and components and scalability.

According to author, The Structured Query Language (SQL) is the language of databases, a computer language that one can use to interact with a relational database. It is a comprehensive language for controlling and interacting with database management systems. By learning SQL, we will be able to use SQL to search existing  database, modify databases and create new databases and database elements.

SQL is a tool that database analysts, administrators and developers use to access and manipulate database.  For example, a series of commands of SQL allow you search and select records in a database. The SQL language is based on the Relational Database Management System (RDBMS) protocol, which stores database information in data tables made up of rows and columns. Certain SQL commands such as the “WHERE” function are used to search these tables of data for desired information.  Moreover,  there are also certain commands allow you manipulate information that is stored in a Microsoft SQL database. You can use these commands to update the data that is stored in tables, delete data from fields or entire database entries, and reorder data. You can also use SQL to edit forms for viewing a database and to set permissions for database  access.

There are 3 components of SQL which are The Data Definition Language (DDL), The Data Manipulation Language (DML) and The Data Control Language (DCL). DDL is used to create and modify tables and other objects in the database. DML is used to manipulate data within a table. DCL is used to create privileges to allow users access to, and manipulation of, the database.

For scalability, SQL grows as the business becomes bigger. SQL Server is quick for large and small businesses, so as the business grows, the SQL Server can handle the new volume of database requests up to millions of records and transactions.

The reason I choose this article is because we are going to learn SQL and handle our SQL project. Knowing all the four parts in the article will help us understand how does SQL works and granting us basics information about SQL. Therefore, I choose this article and hope it would give everyone a common understanding of what SQL is and how it works before we get into a deeper level of the SQL world.

Source: Josienita Borlongan  (November 2nd, 2012) ” How does SQL work?”

Retrieved from: