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:
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.
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.
Oracle and Structured Query Language (SQL)
Restricting and Sorting Data
Using Single-Row Functions to Customise Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Subqueries to Solve Queries
Using the Set Operators
Using DDL Statements to Create and Manage Tables
Managing Objects with Data Dictionary Views
Controlling User Access
Managing Schema Objects
Manipulating Large Data Sets
Exploring the Oracle Database Architecture
Oracle Database Management Tools
Oracle Database Instance
Configuring the Oracle Network Environment
Administering User Security
Managing Database Storage Structures
Create and manage tablespaces
Managing Undo Data
Managing Data Concurrency
Implementing Oracle Database Auditing
Backup and Recovery Concepts
Backup and Recovery Configuration
Performing Database Backups
Performing Database Recovery
Performing Database Maintenance
Managing Performance: SQL Tuning
Automating Tasks by Using Oracle Scheduler
Creating an Oracle Database Using DBCA
Upgrading Oracle Database Software
Introduction to DBAAS
You'll sit the following exams at the Firebrand Training Centre, covered by your Certification Guarantee:
Included on the course:
Your accelerated course includes:
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:
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.
Here's the Firebrand Training review section. Since 2001 we've trained exactly 76,549 students and asked them all to review our Accelerated Learning. Currently, 96.73% 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 (Monday) to 20/11/2019 (Wednesday))
"Really enjoyed the experience and learned a lot of new skills. So thank you Firebrand."
M.A.. (18/11/2019 (Monday) to 20/11/2019 (Wednesday))
"Good food, good training, could improve by using less disposable cups and offer mugs instead."
Liam Coleman, IBM. (4/11/2019 (Monday) to 6/11/2019 (Wednesday))
"I found the course interesting and the content was delivered well."
R.B.. (4/11/2019 (Monday) to 6/11/2019 (Wednesday))
"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 (Monday) to 10/7/2019 (Wednesday))