⇒ Course Objectives
⇒ Course Schedule
⇒ Overview of Oracle Database 12c
⇒ Overview of Oracle Cloud
⇒ Overview of the HR Schema
⇒ Oracle Database 12c Introduction
⇒ Oracle Database Architecture: Overview
⇒ Oracle Database Instance Configurations
⇒ Connecting to the Oracle Database Instance
⇒ Oracle Database memory Structures (overview)
⇒ Process Architecture
⇒ Process Structures
⇒ Process Startup Sequence
⇒ Database Storage Architecture
⇒ Planning Your Installation
⇒ Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM Operating System Groups and Users
⇒ Environment Variables
⇒ Configuring the Oracle Software Owner Environment Using Oracle Universal Installer (OUI)
⇒ Installation Option: Silent Mode
⇒ System Requirements for Oracle Database
⇒ Creating Operating System Groups and Users
⇒ Types of Installations
⇒ Planning the Database Storage Structure
⇒ Types of Databases (based on workload)
⇒ Choosing the Appropriate Character Set
⇒ Setting the NLS_LANG Initialization Parameter
⇒ Using the Database Configuration Assistant (DBCA)
⇒ Introducing Oracle Database Management Tools
⇒ Using SQL*Plus
⇒ Using SQL Developer
⇒ Logging in to Oracle Enterprise Manager Database Express
⇒ Using the Enterprise Manager Database Express Home Page
⇒ Understanding the Enterprise Manager Cloud Control
⇒ Framework Using Enterprise Manager Cloud Control
⇒ Initialization Parameter Files
⇒ Starting an Oracle Database Instance
⇒ Shutting Down an Oracle Database Instance
⇒ Viewing Log Files
⇒ Using Trace Files
⇒ Using the Dynamic Performance Views
⇒ Data Dictionary
⇒ Oracle Net Services Overview
⇒ Oracle Net Listener Overview
⇒ Connecting to a Server
⇒ Tools for Configuring and Managing the Oracle Network Using the Listener Control Utility
⇒ Using Oracle Net Configuration Assistant Using Oracle Net Manager
⇒ Database User Accounts (overview)
⇒ Predefined Administrative Accounts
⇒ Creating a User
⇒ Authentication
⇒ Unlocking a User Account and Resetting the Password
⇒ Privileges
⇒ Roles
⇒ Profiles
⇒ Understanding Storage of Data Database Block contents Exploring the Storage Structure Creating a New Tablespace
⇒ Overview of Tablespaces Created by Default Managing Tablespaces
⇒ Viewing Tablespace Information Using Oracle Managed Files
⇒ Space Management Overview
⇒ Block Space Management
⇒ Row Chaining and Migration
⇒ Free Space Management Within Segments
⇒ Types of Segments
⇒ Allocating Extents
⇒ Allocating Space
⇒ Creating Tables Without Segments
⇒ Undo Data Overview Transactions and Undo Data Storing Undo Information
⇒ Comparing Undo Data and Redo Data Managing Undo
⇒ Configuring Undo Retention
⇒ Guaranteeing Undo Retention
⇒ Changing an Undo tablespace to a Fixed Size
⇒ Overview of Locks
⇒ Locking Mechanism
⇒ Data Concurrency
⇒ DML Locks
⇒ Enqueue Mechanism
⇒ Separation of Responsibilities Database Security
⇒ Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles)
⇒ Configuring the Audit Trail
⇒ Specifying Audit Options
⇒ Categories of Failures
⇒ Flashback Technology
⇒ Understanding Instance Recovery
⇒ Phases of Instance Recovery
⇒ Tuning Instance Recovery
⇒ Using the MTTR Advisor
⇒ Comparing Complete and Incomplete Recovery
⇒ Oracle Data Protection Solutions
⇒ Configuring for Recoverability
⇒ Configuring the Fast Recovery Area
⇒ Multiplexing the Control File
⇒ Online Redo Log File
⇒ Multiplexing the Online Redo Log File
⇒ Archived Redo Log Files
⇒ Archived Redo Log File Naming and Destinations
⇒ Backup Solutions Overview
⇒ Oracle Secure Backup (overview)
⇒ User Managed Backup (overview)
⇒ Backup Terminology and Types of Backups
⇒ Using Recovery Manager (RMAN)
⇒ Configuring Backup Settings
⇒ Oracle-Suggested Backup
⇒ Backing Up the Control File to a Trace File
⇒ Data Recovery Advisor
⇒ Loss of a Control File
⇒ Loss of a Redo Log File
⇒ Loss of a Datafile in NOARCHIVELOG Mode
⇒ Loss of a Noncritical Datafile in ARCHIVELOG Mode
⇒ Loss of a System-Critical Datafile in ARCHIVELOG Mode
⇒ Moving Data: General Architecture
⇒ Oracle Data Pump
⇒ SQL*Loader
⇒ External Tables
⇒ Database Maintenance (overview)
⇒ Viewing the Alert History
⇒ Terminology
⇒ Automatic Workload Repository (AWR)
⇒ Statistic Levels
⇒ Automatic Database Diagnostic Monitor (ADDM)
⇒ Advisory Framework
⇒ Enterprise Manager and Advisors
⇒ Performance Monitoring
⇒ Tuning Activities
⇒ Performance Planning
⇒ Instance Tuning
⇒ Performance Tuning Methodology
⇒ Performance Tuning Data
⇒ Monitoring Performance
⇒ Managing Memory
⇒ Database as a Service Architecture, Features and Tooling
⇒ Software Editions: Included Database Options and Management Packs Automated Database Provisioning
⇒ Managing the Compute Node Associated With a Database Deployment Managing Network Access to Database as a Service
⇒ Enabling Access to a Compute Node Port
⇒ Scaling a Database Deployment & Patching Database as a Service Using the Oracle Database Cloud Service
Duration
2-3 MonthsAvailable Seats
15Online Training Schedule
8.00 pm to 10.00 pmIndustrial Training Schedule in Chandigarh
8.00 am to 7.00 pm