Course Outline
Oracle Database 12c Administration 1Z0-062 course overview
This 4 weekdays or 4 weekends OCA Oracle Certified Associate 12c Database course is designed to provide delegates with the necessary knowledge to pursue Oracle Certified Associate 12c Database (OCA) certification.
This short OCA 12c database course is hands-on, instructor-led and classroom based. This training can be taken as a part-time evening course or even on the weekends. A list of all upcoming public OCA training course is given on Training Dragon website.
Who is Oracle Database 12c Administration 1Z0-062 training for?
This training course is for you if you are interested in becoming OCA 12c Database. This course is also suitable for you if you are in one of the following roles:
- Programmers
- Forms Developer
- Functional Implementer
- Portal Developer
- Technical Consultant
- Reports Developer
- End Users
- Application Developers
- PL/SQL Developer
Prerequisites for Oracle Database 12c Administration 1Z0-062 course
What will I get?
- Training from professional OCA certified trainers:
Training Dragon consultants have been implementing professional Oracle solutions across a range of companies for many years. Those consultants write and teach our OCA training courses, so their experience directly informs course content.
- Practical Projects:
This OCA training is designed to prepare you not only for OCA certification, but also to train you for your next job. To do this, next to certification you will also work on real-world practical OCA related exercises in this OCA course. This will ensure that you can apply the knowledge gained from this course to your work environment.
- Course Material and Practice exams:
OCA electronic notes are included in this course. You will also take practice exams as part of the course.
- Course Completion Certificate:
After completing this training you will receive a OCA course completion certificate.
- Support and Careers Advice:
After the course if you have any problems or questions regarding OCA, do not hesitate to contact us. Training Dragon’s trainers and career consultants are expert in their fields and if you need any help with your career choice, please speak to one of our career consultants.
- Pass Guarantee and Train again for Free:
We are sure that you will pass your OCA 12c certification exam at first attempt. However, if you don’t, you can come back within a year and take the complete course for free.
- Official Course Curriculum:
This OCA certification course is based on the official Oracle recommended course syllabus.
Oracle Database 12c Administration 1Z0-062 Course Contents
Exploring the Oracle Database Architecture
- List the architectural components of Oracle Database
- Explain the memory structures
- Describe the background processes
Oracle Database Instance
- Understand initialization parameter files
- Start up and shut down an Oracle database instance
- View the alert log and access dynamic performance views
Administering User Security
- Create and manage database user accounts
- Grant and revoke privileges
- Create and manage roles
- Create and manage profiles
Create and manage tablespaces
- Explain how Oracle database server automatically manages space
- Save space by using compression
- Use the Segment Advisor
- Reclaim wasted space from tables and indexes by using the segment shrink functionality
Managing Data Concurrency
- Describe the locking mechanism and how Oracle manages data concurrency
- Monitor and resolve locking conflicts
Backup and Recovery Concepts
- Identify the importance of checkpoints, redo log files, and archive log files
Performing Database Backups
- Create consistent database backups
- Back up your database without shutting it down
- Create incremental backups
- Automate database backups
- Manage backups
Moving Data
- Describe ways to move data
- Use SQL*Loader to load data from a non-Oracle database
- Use external tables to move data via platform-independent files
- Explain the general architecture of Oracle Data Pump
- Use Data Pump Export and Import to move data between Oracle databases
Managing Performance: SQL Tuning
- Use the SQL Tuning advisor
Creating an Oracle Database Using DBCA
- Generate database creation scripts by using DBCA
- Manage database design templates by using DBCA
Introduction to DBAAS
- Recognize the difference between a DBaaS Instance and a Database Instance
- Navigate with My Services Dashboard
- User authentication and roles
- Generate a Secure Shell (SSH) Public/Private Key Pair
Oracle Database Management Tools
- Use database management tools
Configuring the Oracle Network Environment
- Configure Oracle Net Services
- Use tools for configuring and managing the Oracle network
- Configure client-side network
- Configure communication between databases
Managing Database Storage Structures
- Describe the storage of table row data in blocks
- Create and manage tablespaces
Managing Undo Data
- Explain DML and undo data generation
- Monitor and administer undo data
- Describe the difference between undo data and redo data
- Configure undo retention
Implementing Oracle Database Auditing
- Enable standard database auditing and unified auditing
Backup and Recovery Configuration
- Configure the fast recovery area
- Configure ARCHIVELOG mode
Performing Database Recovery
- Determine the need for performing recovery
- Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file
Performing Database Maintenance
- Use server-generated alerts
Automating Tasks by Using Oracle Scheduler
- Use Oracle Scheduler to simplify management tasks
- Use job chains to perform a series of related tasks
- Use Scheduler jobs on remote systems
- Use advanced Scheduler features to prioritize jobs
Upgrading Oracle Database Software
- Describe data migration methods
- Describe the upgrade process
View Complete Course outline 
