ORACLE TRAINING COURSE OVERVIEW
- Introduction to DBMS
- Introduction to RDBMS
- Sub Language Commands
- Introduction to SQL Database Object
- Built in Functions
- Grouping the Result of a Query
- Working with Integrity Constraints
- REF constraint
- Querying Multiple Tables (Joins)
- Working with Sub Queries
- Working with DCL, TCL Commands
- Maintaining Database Objects
- Working with Sequences
- Creating Cluster Tables, Implementing Locks, working with roles
- Pseudo Columns in Oracle
- Data Partitions & Parallel Process
- Locks
- SQL * Loader
- PL-SQL (Procedure Language � SQL)
- Advanced PL/SQL
- EXCEPTIONS in PL/SQL
- Database Triggers in PL/SQL
- File Input/Output
- Implementing Object Technology
- Using LOBS
- Using Collections
- Oracle Database Architecture
- Advanced Features
- DBA CONCEPTS