Oracle Certified Associate 12c (OCA 12c)

- Only 7 Days

Your accelerated OCA bootcamp course will teach you the knowledge needed to administer an Oracle Database 12c.

Using Firebrand's unique Lecture | Lab | Review technique, you'll combine theory with practical labs allowing you to get hands-on with the technology. You'll learn faster and leave with the practical skills to carry out day to day administration tasks in a real-world work environment, covering topics including:

  • SQL Fundamentals
  • Oracle Database Architecture
  • Data migration
  • Database backups and recovery

Re-engineered for the cloud

On Firebrand's OCA bootcamp, you'll master the Oracle Database 12c re-engineered for the cloud. Learning to utilise its multitenant architecture, new software efficiencies, manageability benefits and efficient cloud provisioning.

Read more...

You'll also sit exams 1Z0-071: Oracle Database 12c SQL and 1Z0-062: Oracle Database 12c Administration on-site during the course. This is covered by your Certification Guarantee.

97% of Global Fortune 500 companies use Oracle software. Become an Oracle Certified Associate and you’ll prove you can manage this critical technology.

See Benefits...

See prices now to find out how much you could save when you train at twice the speed.

Seven reasons why you should sit your course with Firebrand Training

  1. You'll be OCA 12c certified in just 7 days. With us, you’ll be OCA 12c trained in record time
  2. Our OCA 12c course is all-inclusive. A one-off fee covers all course materials, exams, accommodation and meals. No hidden extras
  3. Pass OCA 12c first time or train again for free. This is our guarantee. We’re confident you’ll pass your course first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
  4. You’ll learn more. A day with a traditional training provider generally runs from 9am – 5pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day quality learning time, with your instructor
  5. You’ll learn OCA 12c faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
  6. You’ll be studying OCA 12c with the best. We’ve been named in Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified 75044 professionals, and we’re partners with all of the big names in the business
  7. You'll do more than study Firebrand's courseware. We use practical exercises to make sure you can apply your new knowledge to the work environment. Our instructors use demonstrations and real-world experience to keep the day interesting and engaging

Think you are ready for the course? Take a FREE practice test to assess your knowledge!

Benefits of Training with Firebrand

  • Distraction-free residential training - you’ll live just steps away from your classroom
  • A purpose-built training centre – get access to dedicated Pearson VUE Select facilities
  • Your Certification Guarantee – pass first time or train again free (just pay for accommodation, exams and incidental costs)
  • Everything you need to certify – you’ll even sit your exam on the course and return home certified
  • No hidden extras – one cost covers everything you need to certify

See Curriculum...

Oracle Database 12c SQL

Oracle and Structured Query Language (SQL)

  • Identify the connection between an ERD and a Relational Database
  • Explain the relationship between a database and SQL
  • Describe the purpose of DDL
  • Describe the purpose of DML
  • Build a SELECT statement to retrieve data from an Oracle Database table

Restricting and Sorting Data

  • Use the ORDER BY clause to sort SQL query results
  • Limit the rows that are retrieved by a query
  • Use ampersand substitution to restrict and sort output at runtime
  • Use SQL row limiting clause

Using Single-Row Functions to Customise Output

  • Use various types of functions available in SQL
  • Use character, number, and date and analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) functions in SELECT statements

Using Conversion Functions and Conditional Expressions

  • Describe various types of conversion functions that are available in SQL
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Apply general functions and conditional expressions in a SELECT statement

Reporting Aggregated Data Using the Group Functions

  • Describe the use of group functions
  • Group data by using the GROUP BY clause
  • Include or exclude grouped rows by using the HAVING clause

Displaying Data from Multiple Tables

  • Describe the different types of joins and their features
  • Use SELECT statements to access data from more than one table using equijoins and nonequijoins
  • Join a table to itself by using a self-join
  • View data that generally does not meet a join condition by using outer joins

Using Subqueries to Solve Queries

  • Define subqueries
  • Describe the types of problems subqueries can solve
  • Describe the types of subqueries
  • Query data using correlated subqueries
  • Update and delete rows using correlated subqueries
  • Use the EXISTS and NOT EXISTS operators
  • Use the WITH clause
  • Use single-row and multiple-row subqueries

Using the Set Operators

  • Describe set operators
  • Use a set operator to combine multiple queries into a single query
  • Control the order of rows returned

Manipulating Data

  • Truncate data
  • Insert rows into a table
  • Update rows in a table
  • Delete rows from a table
  • Control transactions

Using DDL Statements to Create and Manage Tables

  • Describe data types that are available for columns
  • Create a simple table
  • Create constraints for tables
  • Drop columns and set column UNUSED
  • Create and use external tables

Managing Objects with Data Dictionary Views

  • Query various data dictionary views

Controlling User Access

  • Differentiate system privileges from object privileges
  • Grant privileges on tables and on a user
  • Distinguish between privileges and roles

Managing Schema Objects

  • Describe how schema objects work
  • Create simple and complex views with visible/invisible columns
  • Create, maintain and use sequences
  • Create and maintain indexes including invisible indexes and multiple indexes on the same columns
  • Perform flashback operations

Manipulating Large Data Sets

  • Describe the features of multitable INSERTs
  • Merge rows in a table

Oracle Database 12c Administration

Exploring the Oracle Database Architecture

  • List the architectural components of Oracle Database
  • Explain the memory structures
  • Describe the background processes

Oracle Database Management Tools

  • Use database management tools

Oracle Database Instance

  • Understand initialisation parameter files
  • Start up and shut down an Oracle database instance
  • View the alert log and access dynamic performance views

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

Administering User Security

  • Create and manage database user accounts
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles

Managing Database Storage Structures

  • Describe the storage of table row data in blocks
  • Create and manage tablespaces

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 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

Managing Data Concurrency

  • Describe the locking mechanism and how Oracle manages data concurrency
  • Monitor and resolve locking conflicts

Implementing Oracle Database Auditing

  • Enable standard database auditing and unified auditing

Backup and Recovery Concepts

  • Identify the importance of checkpoints, redo log files, and archive log files

Backup and Recovery Configuration

  • Configure the fast recovery area
  • Configure ARCHIVELOG mode

Performing Database Backups

  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups
  • Automate database backups
  • Manage backups

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

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

Performing Database Maintenance

  • Use server-generated alerts

Managing Performance: SQL Tuning

  • Use the SQL Tuning advisor

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 prioritise jobs

Creating an Oracle Database Using DBCA

  • Generate database creation scripts by using DBCA
  • Manage database design templates by using DBCA

Upgrading Oracle Database Software  

  • Describe data migration methods
  • Describe the upgrade process

Introduction to DBAAS

  • Recognise 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

See Exam Track...

You'll sit the following exams at the Firebrand Training Centre, covered by your Certification Guarantee:

1Z0-071: Oracle Database 12c SQL

  • Duration: 100 minutes
  • Questions: 73
  • Passing Score: 63%
  • Format: Multiple Choice

1Z0-072: Oracle Database 12c Administration

  • Duration: 90 minutes
  • Questions: 70
  • Passing Score: 60%
  • Format: Multiple Choice

See What's Included...

Included on the course:

  • Firebrand course materials

Your accelerated course includes:

  • Accommodation
  • Meals, unlimited snacks, beverages, tea and coffee
  • Onsite exams
  • Examination vouchers*
  • Practice tests**
  • Certification Guarantee***
  • Courseware
  • Up-to 12 hours of instructor-led training each day
  • 24-hour lab access
  • Hands-on training through Lecture | Lab | ReviewTM
  • Digital courseware (if available)
  • * Exam vouchers may not be included for Apprentices and will require a separate purchase by an employer due to ESFA guidelines
  • ** Not on all courses
  • *** Pass first time or train again free (just pay for accommodation, exams and incidental costs)

See Prerequisites...

It is recommended that you should have at least 9 months of practical experience of working in a database administration role. This includes a good working knowledge of Oracle SQL and be familiar with Oracle PL/SQL supplied packages.

Additionally, you should have a basic understanding - and preferably some practical experience - of using the following technologies:

  • Oracle Database architecture and OFA
  • SQL statements that query the Oracle Data Dictionary views
  • Oracle Net configuration
  • Database security
  • Diagnostics and troubleshooting
  • Database performance tuning
  • Database space management
  • Datapump and sqlldr
  • Oracle Resource Manager
  • Oracle Scheduler
  • Database maintenance
  • Database backup and in particular RMAN

Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.

See Dates...

Oracle OCA 12c Course Dates

Oracle - Certified Associate 12c (OCA 12c)

Start

Finish

Status

Book now

16/3/2020 (Monday)

22/3/2020 (Sunday)

Limited availability

Book now

Here's the Firebrand Training review section. Since 2001 we've trained exactly 75044 students and asked them all to review our Accelerated Learning. Currently, 96.79% have said Firebrand exceeded their expectations.

Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.


""
Anonymous (18/11/2019 to 20/11/2019)

"Really enjoyed the experience and learned a lot of new skills. So thank you Firebrand."
M.A.. (18/11/2019 to 20/11/2019)

"Good food, good training, could improve by using less disposable cups and offer mugs instead."
Liam Coleman, IBM. (4/11/2019 to 6/11/2019)

"I found the course interesting and the content was delivered well."
R.B.. (4/11/2019 to 6/11/2019)

"Enjoyed my time at Firebrand. The training facilities are good. Plenty of free refreshments and close to your room for relation. Nice surroundings. Clean hotel."
Anonymous. (8/7/2019 to 10/7/2019)

Latest Reviews from our students