How Does SQL Work?

by Hongde H
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: http://www.ehow.com/how-does_4687261_sql-work.html

 

 

2 thoughts on “How Does SQL Work?

  • November 5, 2012 at 1:43 am
    Permalink

    Very cool article. Personally, I think its important to understand the meaning behind the work we’re going to be doing because it helps create much more of a comprehensive outlook and understanding of our work. I remember when I was first starting to learn HTML around the age of 10 (yeah I was a geeky kid 🙂 I asked my dad how HTML works when I saw him coding one night. He told me that if I type – anything – I – wanted – in the text file my webpage will show up the way I want. So one day, being as naiive as I was, I open up a txt pad, type up random snippets of HTML from my, “Idiots Guide to HTML” book, and voila, I had a page show up completely different than what I wanted or expected. Once I learned my lesson in how HTML worked, and once that pillar was firmly planted, the learning curve became incredibly easier.

  • November 5, 2012 at 10:16 am
    Permalink

    I liked seeing the 3 components. I’ve always liked taking things apart to see how they work and then putting them back together. Seeing these different parts and languages helps me understand what talks to what and what controls what. Very helpful.

Comments are closed.