Basic SQL  «Prev  Next»
Lesson 1

Introduction to Fundamental Aspects of SQL

Module introduction
This module will cover some of the fundamental aspects of SQL.
This includes what SQL is, why we use it, and how it is different from programming. You will also set up your database and propagate it with the PUBS data so that you can use it for the rest of this course.
SQL commonly expanded as Structured Query Language, is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management.
SQL has been standardized by both ANSI and ISO.

The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major platforms. This module will discuss the inner workings of SQL. By the time you have completed this module, you will have the fundamental knowledge you need to go out there and start working with databases.
Thew Structured Query Language is a special programming language designed for managing data held in a relational database management system (RDBMS).
Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language.
The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control. Although SQL is often described as a declarative language (4GL), it also includes procedural elements.
SQL was one of the first commercial languages for Edgar F. Codd's relational model, as described in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks."
Despite not entirely adhering to the relational model as described by Codd, it became the most widely used database language.
SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987. Since then, the standard has been enhanced several times with added features.