Scroll to top button

Oracle Database 12c: Installation and Administration

ISBN : 9781616913472

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.

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

Glossary of terms
Pre Assessment Questions
Full Length Tests
Post Assessment Questions
LiveLab (Add-on Component)
Video tutorials

Videos and How To

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
  • 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

Hands on Activities (LiveLab)

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.