RelationalDBDesign   Tweet
RedhatLinuxSysAdmin SeoMining


Lesson 1
Course introduction
What are the characteristics of SQL Database Engines?
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 for 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
  1. what you need from the system,
  2. working with multiple tables, and
  3. doing it easily.

Course goals
In this course, we will cover:
  1. Advanced uses of the SELECT statement
  2. The DISTINCT keyword
  3. Views
  4. String, arithmetic, and date functions
Structured Query Language is a special-purpose 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 (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.