WGU-1Z0-062 ISBN: 978-1-61691-817-0

Oracle Database 12c: Installation and Administration

Gain hands-on expertise in Oracle 1Z0-062 exam with Oracle Database 12c: Installation and Administration course and live lab. This course and live lab provides complete coverage for 1Z0-062 exam and includes topics such as Oracle database 12c components and architecture; creating and operating Oracle Database 12c, understanding storage and space management, understanding Oracle network, architecture, implementing security and auditing, maintaining the database and managing performance, using backup and recovery, and much more. Oracle Database 12c: Installation and Administration live lab is a real computer equipment, networked together and conveniently accessible over the Internet using virtualization. It is automatic, objective-oriented and has equipment such as a computer, server, switch or router in it that a user is free to configure.

Certification is proof of your knowledge and shows that you have the skills required to support Oracle core products. The Oracle certification program can help a company identify proven performers who have demonstrated their skills and who can support the company's investment in Oracle technology. It demonstrates that you have a solid understanding of your job role and the Oracle products used in that role. Oracle Database 12c: Installation and Administration exam is designed to certify the competency of Database professionals to manage, develop, or implement enterprise-wide databases, middleware, or applications.

Intermediate Self-paced · 1 year access 4.1/5 (317 Reviews)

61 Hands-On LiveLabs

Practice real IT tasks in guided environments.

Real environments
Auto-graded
No installation

01 / About

About This Course

Try Free → No credit card required

Target Career Roles

SQL Developer
*Oracle Programmer
Server Administrator
Database Administrator

02 / Lessons & labs

See exactly what you will learn and practice

Download outline (PDF)

Lessons

13 Interactive Lessons · 81 topics

01 Introducing Oracle Database 12c Components and Architecture 5 topics · 9 LiveLab

Oracle Database Fundamentals
Oracle Database 12c Architecture
Oracle Data Integrator Repositories
Summary
Exam Essentials

9 LiveLab in this lesson — see the labs panel →

02 Creating and Operating Oracle Database 12c 8 topics · 8 LiveLab

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

8 LiveLab in this lesson — see the labs panel →

03 Understanding Storage and Space Management 6 topics · 3 LiveLab

Understanding the Physical and Logical Storage
Managing Tablespaces
Managing Data Files
Managing Space
Summary
Exam Essentials

3 LiveLab in this lesson — see the labs panel →

04 Managing Data Concurrency and Undo 4 topics · 3 LiveLab

Managing Data Changes Using DML
Managing Data Concurrency
Summary
Exam Essentials

3 LiveLab in this lesson — see the labs panel →

05 Understanding Oracle Network Architecture 9 topics · 6 LiveLab

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

6 LiveLab in this lesson — see the labs panel →

06 Implementing Security and Auditing 6 topics · 18 LiveLab

Creating and Managing User Accounts
Granting and Revoking Privileges
Controlling Resource Usage by Users
Auditing Database Activity
Summary
Exam Essentials

18 LiveLab in this lesson — see the labs panel →

07 Maintaining the Database and Managing Performance 4 topics · 3 LiveLab

Proactive Database Maintenance
Managing Performance
Summary
Exam Essentials

3 LiveLab in this lesson — see the labs panel →

08 Using Backup and Recovery 6 topics · 4 LiveLab

Understanding and Configuring Recovery Components
Performing Backups
Understanding Types of Database Failures
Performing Recovery Operations
Summary
Exam Essentials

4 LiveLab in this lesson — see the labs panel →

09 Controlling Resources and Jobs 4 topics · 3 LiveLab

Resource Management with the Resource Manager
Task Automation with Oracle Scheduler
Summary
Exam Essentials

3 LiveLab in this lesson — see the labs panel →

10 Upgrading to Oracle Database 12c 5 topics

Determining the Database Upgrade Method
Preparing for a Database Upgrade
Upgrading the Database
Summary
Exam Essentials

11 Using Grid Infrastructure and Data Movement Tools 7 topics · 4 LiveLab

Tools for Moving Data
Migrating Data Using Data Pump
Loading Data with SQL*Loader
Populating External Tables
Introducing Grid Infrastructure
Summary
Exam Essentials

4 LiveLab in this lesson — see the labs panel →

12 Video Tutorials 17 topics

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

13 Introduction to DBAAS

Hands-On Labs Our edge

61 LiveLabs

Displaying the Connection Name
Displaying Information About the Active Services in the Database
Unlocking the Pluggable Database
Altering the Session of the Database Container and the Pluggable Database
Unlocking and Connecting to the User Account
Understanding SGA

Labs run in your browser — nothing to install.

03 / Exam details