The Structured Query Language is a special-purpose programming language designed for managing data held in a (RDBMS)relational database management system
Originally based upon relational algebra and tuple relational calculus, SQL consists of
- (DDL) data definition language and
- (DML) data manipulation language.
The scope of SQL includes (CRUD) create, read, update, and delete data .
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.
Despite these standards, the SQL code is not completely portable among different database systems.
SQL databases tend to be mysterious when it comes to the information that is stored within them.
The SQL Database Engine is the core service for storing, processing, and extracting data.
The SQL Database Engine provides access and rapid transaction processing to meet the requirements of applications.
The SQL Database Engine can be used to create relational databases
- online transaction processing or
- online analytical processing data.
It is likely that you have a number of applications that put information into your various SQL database engines
From this information set, you need to be able to retrieve meaningful information and that is where this course comes in.
This hands-on class focuses on retrieving information from your systems in a way that is more insightful in terms of getting
what you need from the system,
working with multiple tables, and
doing it easily.
In this course, we will cover:
Advanced uses of the
String, arithmetic, and date functions