Premium Features

Previous Buy now to get complete version Next
  • Home
uCertify Logo
  • login
  • Signup
    • Help & Support
    • Accessibility
    • Testimonials
  • Powered by uCertify
  • Hello GuestLogin or Signup
  • Feedback & Support
    • Support
    • Keyboard Shortcuts
    • Send Feedback
Scroll to top button

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

(1Z0-062.AE1) / ISBN: 978-1-64459-359-2
This course includes
Lessons
TestPrep
LiveLab
Mentoring (Add-on)
1Z0-062 1Z0-062
Try this course Pre-Assessment and first two Lessons free No credit card required
Are you an instructor? Teach using uCertify products
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
Lesson 1: Introducing Oracle Database 12c Components and Architecture
  • Oracle Database Fundamentals
  • Oracle Database 12c Architecture
  • Oracle Data Integrator Repositories
  • Summary
  • Exam Essentials
Lesson 2: Creating and Operating Oracle Database 12c
  • 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
Lesson 3: Understanding Storage and Space Management
  • Understanding the Physical and Logical Storage
  • Managing Tablespaces
  • Managing Data Files
  • Managing Space
  • Summary
  • Exam Essentials
Lesson 4: Managing Data Concurrency and Undo
  • Managing Data Changes Using DML
  • Managing Data Concurrency
  • Summary
  • Exam Essentials
Lesson 5: Understanding Oracle Network Architecture
  • 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
Lesson 6: Implementing Security and Auditing
  • Creating and Managing User Accounts
  • Granting and Revoking Privileges
  • Controlling Resource Usage by Users
  • Auditing Database Activity
  • Summary
  • Exam Essentials
Lesson 7: Maintaining the Database and Managing Performance
  • Proactive Database Maintenance
  • Managing Performance
  • Summary
  • Exam Essentials
Lesson 8: Using Backup and Recovery
  • Understanding and Configuring Recovery Components
  • Performing Backups
  • Understanding Types of Database Failures
  • Performing Recovery Operations
  • Summary
  • Exam Essentials
Lesson 9: Controlling Resources and Jobs
  • Resource Management with the Resource Manager
  • Task Automation with Oracle Scheduler
  • Summary
  • Exam Essentials
Lesson 10: Upgrading to Oracle Database 12c
  • Determining the Database Upgrade Method
  • Preparing for a Database Upgrade
  • Upgrading the Database
  • Summary
  • Exam Essentials
Lesson 11: Using Grid Infrastructure and Data Movement Tools
  • Tools for Moving Data
  • Migrating Data Using Data Pump
  • Loading Data with SQL*Loader
  • Populating External Tables
  • Introducing Grid Infrastructure
  • Summary
  • Exam Essentials
Lesson 12: Introduction to DBaaS
  • DBaaS Instance and Database Instance
  • Generating a Secure Shell (SSH) Public/Private Key Pair
  • Navigating with My Services Dashboard
  • User Authentication and Roles
  • Summary
Lesson 13: Video Tutorials
  • 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)

Introducing Oracle Database 12c Components and Architecture

  • 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 and Operating Oracle Database 12c

  • 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

Understanding Storage and Space Management

  • Creating a Tablespace
  • Resizing Data Files
  • Creating a Table Using Compression

Managing Data Concurrency and Undo

  • Using UNDO TABLESPACE
  • Using UNDO_RETENTION
  • Updating a Table

Understanding Oracle Network Architecture

  • 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

Implementing Security and Auditing

  • 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

Maintaining the Database and Managing Performance

  • Disabling the Automatic Space Advisor
  • Enabling the Automatic Space Advisor
  • Viewing Automatic Memory Management Components

Using Backup and Recovery

  • Adding New Members in a Database
  • Exporting the Table of a Database
  • Creating Database Repository
  • Importing a Table in Database

Controlling Resources and Jobs

  • Granting the System Privilege
  • Revoking the System Privilege
  • Creating a Scheduler Job

Using Grid Infrastructure and Data Movement Tools

  • Exporting a Table Using SQL Plus
  • Setting Up the Dump Location
  • Loading External Tables Using Data Pump
  • Managing Tablespace Storage
×
uc logo for app downloadDownload our uCertify App [lms_setting_placeholder: This filed is used to set the LMS settings.

Share with your friends and colleagues

We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept