Oracle DB 12c: Installation & Administration (1Z0-062)

(1Z0-062.AE1)
This course includes
Lessons
TestPrep
LiveLab
Mentoring (Add-on)
1Z0-062 1Z0-062
Share
Try This Course
Are you an instructor?
Request a free evaluation copy

Oracle DB 12c: Installation & Administration (1Z0-062)

Here's what you will get

Lessons
  • 13+ Lessons
  • 132+ Quizzes
  • 88+ Flashcards
  • 88+ Glossary of terms
TestPrep
  • 70+ Pre Assessment Questions
  • 2+ Full Length Tests
  • 70+ Post Assessment Questions
  • 140+ Practice Test Questions
LiveLab
  • 61+ LiveLab
  • 61+ Video tutorials
  • 01:07+ 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
  • DBaaS Instance and Database Instance
  • Generating a Secure Shell (SSH) Public/Private Key Pair
  • Navigating with My Services Dashboard
  • User Authentication and Roles
  • Summary
  • 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 (Live Labs)

  • 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
  • Creating a Cluster
  • Creating a Cluster Index
  • Removing a Cluster
  • Creating a New Pluggable Database
  • Viewing the User Details
  • Creating a New User Using SQL Plus
  • Creating a Group Using SQL Plus
  • Dropping a User Using SQL Plus
  • Modifying the Current Database Parameters
  • Managing Initialization-Parameter Files
  • Monitoring the Database Alert Log
  • Creating a Tablespace
  • Resizing Data Files
  • Creating a Table Using Compression
  • Using UNDO TABLESPACE
  • Using UNDO_RETENTION
  • Updating a Table
  • Creating a Local Connection using the SQL Developer
  • Creating a Listener
  • Configuring the Local Naming Method
  • Using the V$SESSION View
  • Configuring DBMS_CONNECTION_POOL
  • Creating Database Links
  • Creating a Database User and Granting Privileges to a User
  • Creating and Granting Roles to a User
  • Revoking Privileges and Dropping a Role
  • Creating a Table using a Primary Key
  • Working with DML Triggers
  • Working with DDL Triggers
  • Working with System Event Triggers
  • Using the Instead-of Triggers
  • Using Constraints in the Table
  • Creating a View
  • Updating a View
  • Dropping a View
  • Creating a Procedure in SQL Plus
  • Dropping a Procedure in SQL Plus
  • Creating and Executing a Function in SQL Plus
  • Dropping a Function in SQL Plus
  • Creating a Profile
  • Enabling Privilege Auditing in SQL Plus
  • Disabling the Automatic Space Advisor
  • Enabling the Automatic Space Advisor
  • Viewing Automatic Memory Management Components
  • Adding New Members in a Database
  • Exporting the Table of a Database
  • Creating Database Repository
  • Importing a Table in Database
  • Granting the System Privilege
  • Revoking the System Privilege
  • Creating a Scheduler Job
  • Exporting a Table Using SQL Plus
  • Setting Up the Dump Location
  • Loading External Tables Using Data Pump
  • Managing Tablespace Storage
×