Students will gain a conceptual & practical understanding of the Oracle database architecture & how its components work & interact with one another. Students will also learn how to create an operational database & properly manage the various structures in an effective & efficient manner including performance monitoring, database security, user management, & backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

Duration: 5 Days

SQL*Plus / ANSI SQL / PL/SQL
Manage Users, Privileges, Roles, & Resources
Identify Oracle 10g Architecture Components
Proactive Maintenance & Performance Monitoring
Create an Operation Oracle Database
Startup and Shutdown & Oracle Database
Describe how a User Interfaces with the Oracle Database to Process Information
Create and Manage Oracle Objects: Control Files, Data Files, Redo Log Files, Oracle Database & Instance, Locally Managed & Dictionary Managed Tablespaces, Tables, Indexes, Views, Rollback Segments, Undo Tablespace, Oracle Managed Files, Segments, Extents, & Blocks
Oracle Net Overview
Backup and Recovery Non-RMAN
Loading Data - Export/Import-Transportable Trablespaces-Data Pump SQL*Loader

Before attending this course, students must have relational database basic concepts.

This course is designed for Data Analysts & Developers, Database Operators, Database Administrators, Database Support professionals interested in greatly enhancing & greatly advancing their knowledge of Oracle & Oracle DBA skills & broadening their career path