Oracle Certified Associate Certification

Oracle Certified Associate Certification Exam :
  • Step 1 - Pass One Exam Oracle Database 12c: SQL Fundamentals I Exam Number : (1Z0-061) OR Oracle Database SQL Expert Exam Number : 1Z0-071
  • Step 2 - Pass Exam Oracle Database 12c: Administration I Exam Number : (1Z0-062)Complete the above 2 exams to become “Oracle Database 12c Administrator Certified Associate Certification-OCA”

Syllabus for Oracle Certified Associate Certification Exam

Oracle Database 12c: SQL Fundamentals I Exam Number : (1Z0-061)
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Sub queries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
Oracle Database 12c: Administration I Exam Number : (1Z0-062)
  • Exploring the Oracle Database Architecture
  • Preparing the Database Environment
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Database Maintenance
  • Performance Management
  • Intelligent Infrastructure Enhancements
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data

Drop us a query

Course Features

Real-Life Case Studies
Assignments
Lifetime Access
Expert Support
Global Certification
Job Portal Access