Oracle SQL

SQL stands for Structured Query Language and is the standard relational language that is supported by just about every database product. All database professionals should know how to write, troubleshoot, and optimize SQL.

Different database vendors have their own flavor of SQL. In  this course we will cover Oracle SQL.

Key Oracle SQL Features

• Standards compliance: ANSI SQL compliance

• Multi-version read consistency

• Procedural extensions: PL/SQL and Java

• Unleash the full power of queries: Analytic SQL

• Spatial and text

• Performance: indexes, in-memory, partitioning, optimization

Our Course will start with the basics of Oracle SQL, such as how to retrieve and manipulate data. Then we will move to the more advanced topics such as how to create tables and views.

With this course, you should be on your way to becoming proficient in writing, executing, and optimizing SQL.

History of SQL

Dr. E. F. Codd published the paper, "A Relational Model of Data for Large Shared Data Banks", in June 1970 in the Association of Computer Machinery (ACM) journal, Communications of the ACM. Codd's model is now accepted as the definitive model for relational database management systems (RDBMS). The language, Structured English Query Language (SEQUEL) was developed by IBM Corporation, Inc., to use Codd's model. SEQUEL later became SQL (still pronounced "sequel"). In 1979, Relational Software, Inc. (now Oracle) introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard RDBMS language.

SQL Standards

Oracle strives to comply with industry-accepted standards and participates actively in SQL standards committees. Industry-accepted committees are the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO), which is affiliated with the International Electrotechnical Commission (IEC). Both ANSI and the ISO/IEC have accepted SQL as the standard language for relational databases. When a new SQL standard is simultaneously published by these organizations, the names of the standards conform to conventions used by the organization, but the standards are technically identical.

The latest SQL standard was adopted in July 2003 and is often called SQL:2003. The formal names of this standard are:

• ANSI/ISO/IEC 9075:2003, "Database Language SQL", Parts 1 ("SQL/Framework"), 2 ("SQL/Foundation"), 3 ("SQL/CLI"), 4 ("SQL/PSM"), 9 ("SQL/MED"), 10 ("SQL/OLB"), 11 ("SQL/Schemata"), 13 ("SQL/JRT") and 14 ("SQL/XML")

• ISO/IEC 9075:2003, "Database Language SQL", Parts 1 ("SQL/Framework"), 2 ("SQL/Foundation"), 3 ("SQL/CLI"), 4 ("SQL/PSM"), 9 ("SQL/MED"), 10 ("SQL/OLB"), 11 ("SQL/Schemata"), 13 ("SQL/JRT") and 14 ("SQL/XML")