Oracle Database 12c: Installation and Administration

(1Z0-062) / ISBN: 9781616913472
This course includes
Lessons
TestPrep
LiveLab (Add-on)
Share
$139.99
5 Rating 1 Review
Are you an instructor?
Request free evalution copy

Oracle Database 12c: Installation and Administration

Start your prep for the Oracle Database 12c 1Z0-062 certification exam with Oracle Database 12c: Installation and Administration course. The study guide covers the objectives of 1Z0-062 exam and provides skills on the topics such as DBAAS; Oracle Database 12c components and architecture; creation and operation of Oracle Database 12c; storage and space management; network architecture; backup and recovery; and many more. The cert guide is designed for database administrators, support engineers, technical administrators, and data warehouse administrators who have working knowledge of SQL and PL/SQL packages, and basic knowledge of Linux operating system.
Here's what you will get

The Oracle Certified Associate (OCA) credential is the first step towards achieving the Oracle Certified Professional (OCP) certification. OCA certification proves that you have the fundamental knowledge and skills to support an Oracle Database 12c. The OCA Database 1Z0-062 exam focuses on the topics like Database management and performance measurement; controlling resources and jobs; grid infrastructure and data movement; and many more. This exam has been validated against Oracle Database 12.1.0.1.0.

Lessons
  • 12+ Lessons
  • 200+ Exercises
  • 99+ Quizzes
  • 52+ Flashcards
  • 52+ Glossary of terms
Test Preps
  • 7+ Pre Assessment Questions
  • 35+ Post Assessment Questions
LiveLab (Add-on)
  • 52+ livelab
  • 60+ Video tutorials
  • 01:05+ Hours
Video Lessons
  • 37+ Videos
  • 14:02+ Hours
Here's what you will learn
Download Course Outline
  • Oracle Database Fundamentals
  • Oracle Database 12c Architecture
  • Oracle Data Integrator Repositories
  • Summary
  • Exam Essentials
  • Oracle Database 12c Software Installation
  • Using DBCA to Create an Oracle 12c Database
  • Working with Oracle Database Metadata
  • Managing Initialization-Parameter Files
  • Starting Up and Shutting Down an Oracle Instance
  • Monitoring the Database Alert Log
  • Summary
  • Exam Essentials
  • Understanding the Physical and Logical Storage
  • Managing Tablespaces
  • Managing Data Files
  • Managing Space
  • Summary
  • Exam Essentials
  • Managing Data Changes Using DML
  • Managing Data Concurrency
  • Summary
  • Exam Essentials
  • Introducing Network Configurations
  • An Overview of Oracle Net Features
  • Configuring Oracle Net on the Server
  • Configuring Oracle Net for the Client
  • An Overview of Oracle Shared Server
  • Understanding Database Resident Connection Pooling
  • Communicating Between Databases
  • Summary
  • Exam Essentials
  • Creating and Managing User Accounts
  • Granting and Revoking Privileges
  • Controlling Resource Usage by Users
  • Auditing Database Activity
  • Summary
  • Exam Essentials
  • Proactive Database Maintenance
  • Managing Performance
  • Summary
  • Exam Essentials
  • Understanding and Configuring Recovery Components
  • Performing Backups
  • Understanding Types of Database Failures
  • Performing Recovery Operations
  • Summary
  • Exam Essentials
  • Resource Management with the Resource Manager
  • Task Automation with Oracle Scheduler
  • Summary
  • Exam Essentials
  • Determining the Database Upgrade Method
  • Preparing for a Database Upgrade
  • Upgrading the Database
  • Summary
  • Exam Essentials
  • Tools for Moving Data
  • Migrating Data Using Data Pump
  • Loading Data with SQL*Loader
  • Populating External Tables
  • Introducing Grid Infrastructure
  • Summary
  • Exam Essentials
  • Introduction
  • Database Concepts And Tools
  • DML Atomicity
  • DML Statements
  • Data Concurrency
  • Backup
  • Installation
  • Memory Structure
  • Tables
  • Indexes
  • Constraints And Triggers
  • Implementing Security
  • Storage Structures
  • Internal Memory Structures
  • Background Processes
  • Starting And Stopping Database
  • Critical Storage Files

Exam FAQs
How many questions are asked in the exam? The exam contains 67 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 64%
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • DBA
  • SQL Developer
  • Oracle Programmer
  • Server Administrator
  • Database Administrator
Customer Testimonials
Emmanuel Adesotu
The uCertify Oracle DBA course is very much interactive and contains a very detailed lecture on Oracle architecture, absolutely for a beginner, The lecturer did justice to the course and I recommend for everyone that wishes to learn the internal operation of Oracle database.
×