Oracle Database 12c: DBA

by TCIL-IT Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

TCIL-IT Logo

img Duration

Please Enquire

Course Details

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.
  • Chandigarh Branch

    TCIL-IT (ICS) S.C.O. 3017-18, Second Floor Opp. Kisan Bhavan (Bijwara Market), Chandigarh

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy