The process of becoming Oracle Database certified broadens your knowledge and skills
by exposing you to a wide array of important database features, functions and tasks.
Our training course teaches you how to master the skills associated with becoming
Oracle (OCA) Certified. You’ll become more valuable to your current and/or future
potential employer. Earning this in demand certification will expand your job opportunities,
support job stability, and speed up your career. The Oracle Database 12c Administrator
Certification ensures that as database professionals you have a strong foundation
and expertise in the industry’s most advanced database management system, Oracle 12c.
Our training course prepares you for two Oracle certification exams: IZ0-071 and IZ0-062.
Your training will describe how to use SQL features, how to create and manage tables,
how to manipulate data, running queries, managing schema objects, how to install and
maintain an Oracle database, how to configure the Oracle network environment, managing
data and databases, SQL features, backup/recovery techniques, upgrading, and migrating
data.
Candidates can prepare for the exams by taking this training; no other prerequisites
are required by Oracle.
By the end of this course, you will be able to:
- Identify SQL features and how to manage tables
- Recall how to manipulate data, restrict, and sort data
- Recognize how to report aggregated data and how to display data
- Describe how to run subqueries and how to manage schema objects
- List how to manipulate large data sets and how to control user access
- Identify the fundamentals of installing Oracle Database software
- Recognize the architectural components of the Oracle Database as well as how to manipulate
data
- Recall how to create an Oracle Database and how to manage storage and space
- List how to implement security and auditing functions as well as how to manage database
performance
- Recognize how to use the back-up recovery system, how to perform and upgrade and how
to configure grid infrastructure
Module 1: SQL and DDL Statements
- Identify the Connection Between an ERD and a Relational Database
- Relationship Between a Database and SQL
- Purpose of DDL
- Purpose of DML
- SELECT Statement
- Categorize the Main Database Objects
- Create a Simple Table
- Review the Table Structure
Module 2: Manipulating Data
- Truncate Data
- Insert Rows into a Table
- Update Rows in a Table
- Delete Rows from a Table
- Control Transactions
- Restricting and Sorting Data
- SQL Row Limiting
Module 3: Single-Row Functions and Conversion Functions
- Character and Number Functions
- Date Functions
- DUAL Table
- Conversion Functions
- Analytical Functions
- Nesting Functions
- SELECT Statements
Module 4: Aggregated Data – Group Functions and Multiple Tables
- Describe the Use of Group Functions
- Group Data by Using the GROUP BY Clause
- Displaying Data from Multiple Tables
- Different Types of Joins and Their Features
- Join a Table to Itself by Using a Self-Join
- Inner Joins and National Joins
- USING
Module 5: Subqueries and Schema Objects
- Define Subqueries
- Types of Subqueries
- Update and Delete Rows Using Correlated Subqueries
- EXISTS and NOT EXISTS Operators
- Write Single-Row and Multiple-Row Subqueries
- How Schema Objects Work
- Create Simple and Complex Views with Visible/Invisible Columns
- Create, Maintain, and Use Sequences
- Perform Flashback Operations
Module 6: Set Operators and Data Dictionary Views
- Describe Set Operators
- Control the Order of Rows Returned
- ORDER BY – By Position
- ORDER BY – By Reference
- Query Various Data Dictionary Views
- Dynamic Performance Views
Module 7: Manipulating Large Data Sets and Controlling User Access
- Features of Multitable INSERTS
- Merge Rows into a Table
- System Privileges from Object Privileges
- Grant Privileges on Tables and on a User
- Distinguish Between Privileges and Roles
Module 8: Exploring the Oracle Database Architecture
- Install the Oracle Database Software
- User Accounts
- OUI Inventory
- Generate Database Creation Scripts by Using DBCA
- Configure Database Options by Using DBCA
- Memory Structures
- Background Processes
- Physical Database Structures
- Logical Database Structures
Module 9: Managing and Configuring
- Use Database Management Tools
- Understand Initialization Parameter Files
- Alert Logs and Dynamic Performance Views
- Configure Oracle Net Services
- Configure Client-Side Network
- Configure Communication Between Databases
- Describe Storage of Table Row Data in Blocks
- Create and Manage Tablespaces
Module 10: Managing Space and User Security
- Save Space by Using Compression
- Segment Advisor
- Manage Resumable Space Allocation
- Create and Manage Database User Accounts
- Grant and Revoke Privileges
- Create and Manage Roles and Profiles
- DML and Undo Data Generation
- Monitor and Administer Undo Data
Module 11: Auditing and Maintenance
- Shared and Exclusive Locks
- Automatic and Manual Locking
- Monitor and Resolve Locking Conflicts
- DBA Responsibilities for Security and Auditing
- Enable Standard Database Auditing and Unified Auditing
- Manage the Automatic Workload Repository (AWR)
- Describe and Use the Advisory Framework
- Set Alert Thresholds
- Automated Tasks
Module 12: Performance and Resources
- Use Automatic Memory Management
- Use the Memory Advisor to Size Memory Buffers
- Manage Optimizer Statistics
- Use the SQL Tuning Advisor
- Use the SQL Access Advisor to Tune Workload
- Configuring the Database Resource Manager
- Access and Create Resource Plans
Module 13: Automating Tasks, Backup, and Recovery
- Job Chains to Perform a Series of Tasks
- Use Scheduler Jobs on Remote Systems
- Moving Data
- Create and Use Directory Objects
- SQL*Loader
- Oracle Data Pump
- Back and Recovery: Configuration
- Configure Fast Recovery Area
- Automate Database Backups
- Manage Backups
Module 14: Restart and Upgrades
- Configure Storage for Oracle Automatic Storage Management
- Standalone Server
- Using Oracle Restart to Manage Components
- Upgrade Methods
- Migration Methods
- Upgrade Process
- Upgrade Requirements
- Migrate to Unified Auditing
Outlines are subject to change, as courses and materials are updated.
Download Course Outline (PDF)
Upon successful completion of this course, students will be prepared to sit for both
the Oracle 12c IZ0-071: Oracle Database 12c: Administration (OCA) certification exam
and Oracle 12c IZ0-062: Oracle Database 12c: Administration (OCA) certification exam.
Internet Connection*
- Broadband or High-Speed - DSL, Cable, and Wireless Connections
*Dial-Up internet connections will result in a diminished online experience. Classroom
pages may load slowly and viewing large audio and video files may not be possible.
Hardware Requirements
- Processor - 2GHz Processor or Higher
- Memory - 1 GB RAM Minimum Recommended
- Webcams are strongly recommended.
PC Software Requirements
- Operating Systems - Windows 7 or higher
- Microsoft Office 2013 or higher. Also, you could use a general Word Processing application
to save and open Microsoft Office formats (.doc, .docx, .xls, .xlsx, .ppt, .pptx)
- Internet Browsers - Google Chrome is highly recommended, Cookies MUST be enabled,
Pop-ups MUST be allowed (Pop-up Blocker disabled)
- The Kindle Reader App or VitalSource Bookshelf App are needed for many of our courses
(No special equipment needed. This can be downloaded for FREE onto your computer.)
- PowerPoint Viewer (if you do not have PowerPoint)
- Adobe PDF Reader
- QuickTime, Windows Media Player &/or Real Player
MAC Software Requirements
- Operating Systems - Mac OS x 10 or higher with Windows
- Mac office programs or a Word Processing application to save and open Microsoft Office
formats (.doc, .docx, .xls, .xlsx, .ppt, .pptx)
- Internet Browsers- Google Chrome is highly recommended, Cookies MUST be enabled, Pop-ups
MUST be allowed (Pop-up Blocker disabled)
- The Kindle Reader App or VitalSource Bookshelf App are needed for many of our courses
(No special equipment needed. This can be downloaded for FREE onto your computer.)
- PowerPoint Viewer (if you do not have PowerPoint)
- Adobe PDF Reader
- Apple QuickTime Media Player