Overview
The course provides a comprehensive introduction to use Oracle's SQL for database access, covering data manipulation and transaction management concepts.
Those interested in working with SQL in Oracle or other relational database products, including application developers, programmers, database administrators and managers. No previous database experience is required.
- Introduction to Database Concepts
- Starting SQL*PLUS
- Querying databases
- Joining Tables & Sub-queries
- DDL commands
- Other database objects
- SQL *reports
- Creating partitioned tables
- Large objects
- PL/SQL
- Cursors and Exception handling
- Subprogram in PL/SQL
- Abstract data types
- Nested tables and Varrays
- Tuning SQL
- Introduction to Oracle DBA
- Oracle 9i
