OCA: Oracle Database 12c Administrator Certified Associate Program

×

Status message

Finding your location...
  • Description
  • Objectives
  • Outline
  • Materials
  • Certification
  • Approvals
  • System Requirements
  • Watch a Demo

If you are looking for the most up-to date Oracle Database certifications, take our two part program and preapre for both exams today! 

OCA: Oracle Database 12c Administrator Certified Associate 1Z0-062

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 Oracle’s certification exam IZ0-062. Your training will describe how to use SQL features, how to create and manage tables, how to manipulate data, running queries, and managing schema objects.

Prerequisite(s): Candidates can prepare for the exams by taking this training; no other prerequisites are required by Oracle.
 

OCA: Oracle Database 12c Administrator Certified Associate 1Z0-071

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 Oracle’s certification exam IZ0-071. Your training will include topics such as 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.

Prerequisite(s): Candidates can prepare for the exams by taking this training; no other prerequisites are required by Oracle.

 

** Course Subject to Change.

After completing this course, you should be able to:

  • Type quickly and correctly
  • Identify the transcription format for civil litigation
  • Identify the transcription format for probates
  • Identify the transcription format for family law
  • Identify the transcription format for legal instruments

OCA: Oracle Database 12c Administrator Certified Associate 1Z0-062

After completing this course, you should 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

OCA: Oracle Database 12c Administrator Certified Associate 1Z0-071

After completing this course, you should be able to:

  • 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 

OCA: Oracle Database 12c Administrator Certified Associate 1Z0-062

OCA: Oracle Database 12c Administrator Certified Associate 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

OCA: Oracle Database 12c Administrator Certified Associate 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

OCA: Oracle Database 12c Administrator Certified Associate Module 3
Single-Row Functions and Conversion Functions

  • Character and Number Functions
  • Date Functions
  • DUAL Table
  • Conversion Functions
  • Analytical Functions
  • Nesting Functions
  • SELECT Statements

OCA: Oracle Database 12c Administrator Certified Associate 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

OCA: Oracle Database 12c Administrator Certified Associate 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

OCA: Oracle Database 12c Administrator Certified Associate 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

OCA: Oracle Database 12c Administrator Certified Associate 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

Ed4Career is committed to being both environmentally conscious and making it easier for you to study! We’re making your education mobile! All of our textbooks are now provided as eTextbooks*. You can access them on your laptop, tablet, or mobile device and can study anytime, anywhere.

The move away from physical books to eTextbooks means you get the latest, most up-to-date version available. This also makes your training more accessible, so you can study anywhere you have your phone or tablet. The best part is that all materials are included in your training cost so there are NO extra fees for books!**

*A few courses still have physical materials.
 

OCA: Oracle Database 12c Administrator Certified Associate 1Z0-062

Upon successful completion of this course, students will be prepared to sit for the Oracle 12c IZ0-062: Oracle Database 12c: Administration (OCA) certification exam.

OCA: Oracle Database 12c Administrator Certified Associate 1Z0-071

Upon successful completion of this course, students will be prepared to sit for the Oracle 12c IZ0-062: Oracle Database 12c: Administration (OCA) certification exam.

** Certification exams are not included in the cost of the course.**

 International Association for Continuing Education and Training (IACET)

Ed4Career has been approved as an Accredited Provider by the International Association for Continuing Education and Training (IACET). In obtaining this accreditation, Ed4Career has demonstrated that it complies with the ANSI/IACET Standard which is recognized internationally as a standard of good practice. As a result of the Accredited Provider status, Ed4Career is authorized to offer IACET CEUs for courses and programs that qualify under the ANSI/IACET Standard.

The Continuing Education Unit (CEU) was created by IACET as a measurement of continuing education. One (1) IACET CEU is equal to ten (10) contact hours of participation in an organized continuing education experience under responsible sponsorship, capable direction, and qualified instruction. Under IACET's care, the IACET CEU has evolved from a quantitative measure to a hallmark of quality training and instruction. For more information on IACET, visit iacet.org.

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

 

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

 


Click on the school name below for purchasing info:

1400 Robinwood Drive
Hagerstown, MD 21742
United States
Phone: 240-500-2553

This course is also available at the following school:

Online School Finder
(Virtual Location)


To perform a search for schools based on a custom location please click here.