Descriptions
The Oracle Database 12c: Administration course provides participants with the knowledge and practical skills required to manage and maintain an Oracle Database environment. This training introduces the architecture of Oracle Database 12c and teaches how to install, configure, administer, and monitor databases effectively. Participants will learn how to manage database storage, users, security, and performance while ensuring data availability through backup and recovery techniques. The course also demonstrates how to automate administrative tasks using enterprise management tools and best practices for maintaining a reliable database system.
Course Objectives
- Understand the architecture and components of Oracle Database 12c.
- Install and configure Oracle Database software.
- Create and manage Oracle databases.
- Start up, shut down, and manage database instances.
- Manage database storage structures such as tablespaces and datafiles.
- Create and manage database users, roles, and privileges.
- Monitor database performance and troubleshoot issues.
- Implement backup and recovery strategies to ensure data availability.
- Use administrative tools such as enterprise management interfaces to automate database administration tasks.
Target Audience
- PL/SQL Developer
- System Analysts
- Technical Consultant
- Forms Developer
- Portal Developer
Pre requisites
- Pre requisites: Data processing
- Familiarity with data processing concepts and techniques
Course Outline
- Introduction to Oracle Database 12c Architecture
- Installing Oracle Database Software
- Creating and Managing Databases
- Managing Users and Security
- Managing Storage Structures
- Backup and Recovery
- Database Monitoring and Performance
- Automation and Management Tools
| 2026 CLASSES | |||||
|---|---|---|---|---|---|
| Jan | Feb | Mar | Apr | May | Jun |
| 5 – 8 | – | 16 – 18 | – | 11 – 14 | – |
| Jul | Aug | Sep | Oct | Nov | Dec |
| 20 – 23 | – | 21 – 25 | – | 23 – 26 | – |
