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-timedata 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
- 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
- Creating Views
- Other Database Objects
- Controlling User Access
- SQL Workshop
- Using SET Operators
- Oracle9i Datetime Functions
- Enhancements to the GROUP BY Clause
- Advanced Subqueries
- Hierarchical Retrieval
- Oracle9i Extensions to DML and DDL Statements