This course introduces new architectural concepts and DBA best practices in Oracle Database 12c administration. You will learn how to install and configure an Oracle Database 12c instance and how to use the tools and interfaces that are needed by a database administrator. The course emphasizes understanding methodologies in database administration, performance sustainability, backup and recovery. The instructor teaches with real-world examples, especially for DBA situations relating to resource management, job scheduling, performance tuning and DB infrastructure reporting.
The course provides access to material from Oracle and cloud accounts provided by hosting services to install and configure Oracle Database 12c instances. All the course work is taught on the Linux platform, which is the most common operating system for Oracle in enterprises. You will gain hands-on experience installing, working with, and administering databases in the cloud. In addition to helping students with the study of the Oracle material, the instructor will share real-world approaches, provide detailed instructions and help you practice your skills. The course prepares you for the Oracle Certified Associate exam.
- Overview, architecture, terms and concepts
- How to install Oracle12c
- How to create, configure and connect to a database
- Tools: Enterprise Manager Cloud Control, SQL*Plus and SQLDeveloper
- Initialization; stages of instance; UNDO management
- Process, memory architecture and storage structures
- Oracle Net Services architecture
- Security administration
- Resource management workflow
- Scheduler workflow and job components
- Data concurrency and lock conflicts
- Performance and tuning methodologies
- Advisor framework and reports
- Backup and recovery using RMAN; FLASHBACK technology
- Oracle data pump, SQL*Loader and external tables.