Oracle Database 12c: DBA

Oracle Database 12c: DBA course is offered by TCIL-IT. TCIL-IT Chandigarh is a fastest-emerging company in the IT and telecommunications industry. Being a well accredited company, we have specialized in the field of various industrial training programs.

Modules:

• Module1: Introduction
• Course Objectives
• Course Schedule
• Overview of Oracle Database 12c
• Overview of Oracle Cloud
• Overview of the HR Schema
• Oracle Database 12c Introduction
• Module2:Exploring the Oracle Database Architecture
• 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
• Module 3: Oracle Software Installation Basics
• 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
• Module 4: Installing Oracle Database Software
• System Requirements for Oracle Database
• Creating Operating System Groups and Users
• Types of Installations
• Module 5: Creating an Oracle Database by Using DBCA
• 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)
• Module 6: Oracle Database Management Tools
• 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
• Module 7: Managing the Database Instance
• 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
• Module 8: Configuring the Oracle Network Environment
• 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
• Module 9: Administering User Security
• Database User Accounts (overview)
• Predefined Administrative Accounts
• Creating a User
• Authentication
• Unlocking a User Account and Resetting the Password
• Privileges
• Roles
• Profiles
• Module 10: Managing Database Storage Structures
• 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
• Module 11: Managing Space
• 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
• Module 12: Managing Undo Data
• 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
• Module 13: Managing Data Concurrency
• Overview of Locks
• Locking Mechanism
• Data Concurrency
• DML Locks
• Enqueue Mechanism
• Module 14: Implementing Oracle Database Auditing
• Separation of Responsibilities Database Security
• Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles)
• Configuring the Audit Trail
• Specifying Audit Options
• Module 15: Backup and Recovery Concepts
• 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
• Module 16: Backup and Recovery Configuration
• 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
• Module 17: Performing Database Backups
• 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
• Module 18: Performing Database Recovery
• And more.