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)
Oracle DB 12c: Installation & Administration (1Z0-062)
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
- 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
×