Oracle DB 12c: Installation & Administration (1Z0-062)
(1Z0-062.AE1)/ISBN:978-1-64459-359-2
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
Hand on lab
61+ LiveLab | 61+ Video tutorials | 01:07+ Hours
Video Lessons
37+ Videos | 14:02+ Hours
Need guidance and support? Click here to check our Instructor Led Course.
Here's what you will learn
Download Course OutlineLessons 1: Introducing Oracle Database 12c Components and Architecture
- Oracle Database Fundamentals
- Oracle Database 12c Architecture
- Oracle Data Integrator Repositories
- Summary
- Exam Essentials
Lessons 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
Lessons 3: Understanding Storage and Space Management
- Understanding the Physical and Logical Storage
- Managing Tablespaces
- Managing Data Files
- Managing Space
- Summary
- Exam Essentials
Lessons 4: Managing Data Concurrency and Undo
- Managing Data Changes Using DML
- Managing Data Concurrency
- Summary
- Exam Essentials
Lessons 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
Lessons 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
Lessons 7: Maintaining the Database and Managing Performance
- Proactive Database Maintenance
- Managing Performance
- Summary
- Exam Essentials
Lessons 8: Using Backup and Recovery
- Understanding and Configuring Recovery Components
- Performing Backups
- Understanding Types of Database Failures
- Performing Recovery Operations
- Summary
- Exam Essentials
Lessons 9: Controlling Resources and Jobs
- Resource Management with the Resource Manager
- Task Automation with Oracle Scheduler
- Summary
- Exam Essentials
Lessons 10: Upgrading to Oracle Database 12c
- Determining the Database Upgrade Method
- Preparing for a Database Upgrade
- Upgrading the Database
- Summary
- Exam Essentials
Lessons 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
Lessons 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
Lessons 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 LAB Activities
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