Course Description – sql2
Introduction to Oracle9i: SQL consists of two modules, Introduction to Oracle9i: SQL Basics andOracle9i: Advanced SQL. Introduction to Oracle9i: SQL Basics covers creating database structures and storing, retrieving, and manipulating data in a relational database. Oracle9i: Advanced SQL covers advanced SELECT statements, Oracle SQL and iSQL*Plus Reporting.For people who have worked with other relational databases and have knowledge of SQL, another course, called Introduction to Oracle9i for Experienced SQL Users is offered. This course covers the SQL statements that are not part of ANSI SQL but are specific to Oracle.
The Oracle server extends the data modeling capabilities to support an object relational database
model that brings object-oriented programming, complex data types, complex business objects, and
full compatibility with the relational world. It includes several features for improved performance and
functionality of online transactionprocessing (OLTP) applications, such as better sharing of run-time
data structures, larger buffer caches, and deferrable constraints. Data warehouse applications will
benefit from enhancements such as parallel execution of insert, update, and delete operations; partitioning;
and parallel-aware query optimization.
in this course
In Oracle9i, you can include the time zone in your date and time data, and provide support for fractional seconds.
Three new data types are added to DATE:
TIMESTAMP WITH TIME ZONE (TSTZ)
TIMESTAMP WITH LOCAL TIME ZONE (TSLTZ)
Oracle9i provides daylight savings support for datetime data types in the server
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms
WHO SHOULD ATTEND?
Other Database Objects
Controlling User Access
Using SET Operators
Oracle9i Datetime Functions
Enhancements to the GROUP BY Clause
Oracle9i Extensions to DML and DDL Statements