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

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

Category: 
Course Hours: 
90
Price: 
$600.00
Course Type: 
Mentor Supported
  • Description
  • Objectives
  • Outline
  • Materials
  • Certification
  • Approvals
  • System Requirements
  • Watch a Demo

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

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

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

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)

Ed4Online has been approved as an Accredited Provider by the International Association for Continuing Education and Training (IACET). In obtaining this accreditation, Ed4Online 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, Ed4Online 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

While our courses are accessible through multiple mobile learning platforms, some courses may include a CD or DVD with the Textbook, so you may need access to a computer with CD-ROM or DVD Drive.

 

PC Software Requirements

  • Operating Systems - Windows 7 or higher
  • Microsoft Office 2007 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)
  • Kindle Reader App is 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)
  • Kindle Reader App is 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
  • Courses that include a CD-ROM or DVD may require an external drive and Parallels software to view.
School Location: