No upcoming dates scheduled
Duration:
5 Days
Course Overview:
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.
Course Objectives:
- 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 Table spaces
- 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
Prerequisites:
Before attending this course, students must have relational database basic concepts.
Related posts:
