ORACLE Database

1. Tag

• Oracle Database 12c Overview
• Introduction & Architecture
• Instance Configurations, Memory Structures, Process Structures
• Database Storage Architecture
• Logical and Physical Database Structures
• Container and Pluggable Database Overview
• Installing Oracle Grid Infrastructure for a Standalone Server
• Grid Infrastructure for a Standalone Server
• Configuring Storage for Automatic Storage Management (ASM)
• Installing Grid Infrastructure for a Standalone Server
• Installing Oracle Database Software
• Planning Your Installation, System Requirements
• Using 4 KB Sector Disks
• Setting Environment Variables
• Creating an Oracle Database by Using DBCA
• Planning the Database Storage Structure
• non-CDB or CDB, Types of Databases (based on workload)
• Choosing the Appropriate Character Set
• Using the Database Configuration Assistant (DBCA)
• Using Oracle Restart
• Overview & Process startup
• Controlling Oracle Restart
• Oracle Restart Configuration
• Using the SRVCTL Utility

2. Tag

• Introduction to Upgrading to Oracle Database 12c
• Upgrade Methods, Data Migration Methods
• Overview of Upgrade Process
• Performing a Rolling Upgrade, Upgrading a CBD
• Preparing to Upgrade to Oracle Database 12c
• Developing a Test Plan, Performance Testing
• Using the Pre-Upgrade Information Tool
• Backing Up the Database
• Installing the Oracle Database 12c Software
• Preparing the New Oracle Home
• Upgrading to Oracle Database 12c
• Upgrading by Using the Database Upgrade Assistant (DBUA)
• Migrating Data by Using Oracle Data Pump
• Data Pump Overview
• Migrating by Using Data Pump
• Importing by Using a Network Link

3. Tag

• Exploring the Oracle Database Architecture
• Architecture Overview
• Instance Configurations, Memory Structures
• Process Architecture, Process Structures
• Database Storage Architecture
• Managing the Database Instance
• Understanding the Enterprise Manager Management Framework
• Logging in to Oracle Enterprise Manager Database Express
• Using the Enterprise Manager Database Express Home Page
• Using Enterprise Manager Cloud Control
• Using SQL*Plus and SQL Developer
• Initialization Parameter Files
• Configuring the Oracle Network Environment
• Oracle Net Services and Net Listener
• Listener Control Utility, Assistant and Manager
• Enterprise Manager Cloud Control
• Managing Database Storage Structures
• Database Block Contents
• Exploring the Storage Structure
• Creating and Managing Tablespaces

4. Tag

• Administering User Security
• Database User Accounts, Administrative Accounts
• Authentication, Privileges, Roles, Profiles
• Managing Data Concurrency
• Locking Mechanism, Data Concurrency
• DML Locks, Enqueue Mechanism, Lock Conflicts
• Managing Undo Data
• Transactions and Undo Data
• Storing Undo Information
• Comparing Undo Data and Redo Data
• Configuring Undo Retention
• Implementing Oracle Database Auditing
• Separation of Responsibilities, Database Security
• Monitoring for Compliance, Standard Database Auditing
• Unified Audit Data Trail
• Performing Database Maintenance
• Database Maintenance
• Viewing the Alert History
• Automatic Workload Repository (AWR)
• Automatic Database Diagnostic Monitor (ADDM)
• Advisory Framework, Enterprise Manager and Advisors

5. Tag

• Managing Performance
• Performance Monitoring
• Tuning Activities, Performance Planning
• Instance Tuning, Monitoring Performance, Managing Memory
• Performance Tuning Methodology & Data
• Managing Performance: SQL Tuning
• SQL Tuning, Oracle Optimizer
• SQL Plan Directives, Adaptive Execution Plans
• SQL Tuning Advisor
• Managing Resources by Using Database Resource Manager
• Database Resource Manager Concepts
• Using the Resource Manager
• Default Maintenance Resource Manager Plan
• Resource Manager Workflow
• Specifying Resource Plan Directives
• Resource Allocation Methods for Resource Plans