Oracle Database 12c Administration 1Z0-062

Get OCA 12c database certification training in classroom from OCA certified trainers in London

This course will take place in 3-4 Kirby Street, London, EC1N 8TS. Find on map
15 %
Discount

when you buy 3 or more courses

The discount will be automatically
applied at the checkout
Looking for a
2-12 months
training?
Choose Database Administrator
Career Programme

Looking for a 2-12 months training?

Choose

Database Administrator career programme

Upcoming dates

There are no open public schedule dates for Oracle Database 12c Administration 1Z0-062 course. We can offer you a private training or arrange a public course for you. Contact us here and we can make arrangements for your course.

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

Daily schedule

The scheme below shows what a typical day at Training Dragon looks like.

10:00 11:30 11:45 13:00 14:00 15:30 15:45
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Lunch
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Video Placeholder

Looking for a
2-12 months
training?

Choose

Database Administrator career programme

Our Trainers

Emiliano
Emiliano
Leads our teaching team with many years of experience in teaching web development.
Ross
Ross
Brings many years of Python and Java software development experience to classrooms.
Olu
Olu
Microsoft and Oracle certified developer with years teaching experience in Android, .NET and databases.

Latest Reviews

Frequently Asked Questions

Have a question?
We are here to answer them