Course Curriculum
Oracle Database 23ai, 19c, 12c, 11g Administration Workshop
This course introduces the core principles of Oracle Database administration, focusing on essential tasks and skills. Guided by experienced Oracle University instructors, you’ll engage in hands-on exercises designed to reinforce your understanding and prepare you for the Oracle Certified Associate (OCA) & Oracle Certified Professional (OCP) exam.
What You’ll Learn:
– Install Oracle Grid Infrastructure
– Create and manage database users
– Install and configure an Oracle Database
– Manage storage structures effectively
– Administer the Oracle Database
– Understand Oracle Database architecture and its component interactions
– Perform essential backup and recovery procedures
Benefits to You:
Gain the knowledge to ensure your database runs with optimal performance—fast, reliable, secure, and easy to manage. Learn how to streamline workloads, reduce IT costs, and enhance service quality by enabling seamless database consolidation within your datacenter.
Build an Operational Database:
This course also covers how to create an operational database and manage its components efficiently. You’ll explore performance monitoring, database security, user management, and backup/recovery strategies to maintain a smooth-running system.
Certification and Training Path:
The Oracle Database 23ai,19c: Administration Workshop course satisfies the training requirement for the Oracle Certification Path. Eligible training formats include instructor-led online (LVC, LWC), in-class (ILT), or Training On Demand courses.
Please note that Self-Study and Knowledge Center courses do not meet certification training requirements.
Who can learn this course:
– Any Graduates (B.A, B.Com, B.Sc)
– Engineering Students (B.Tech, B.E, M.Tech)
– BCA/MCA Graduates
– Diploma Holders
– Working Professionals
– Data Warehouse Administrators
– Database Administrators
– Software Testers
– Project Managers
– MIS Support Professionals
Course Curriculum :
Oracle Database Architecture
– Exploring Oracle Database Architecture
– Overview of Oracle Database and ASM Architecture
– Process and Memory Structures
– Logical and Physical Storage Structures
– ASM Storage Components
Installing Oracle Software
– Installation Tasks for Oracle Database Administrators
– Tools for Database Administration
– System Requirements for Installation
– Oracle Universal Installer (OUI) Overview
– Installing Oracle Grid Infrastructure and Database Software
– Silent Install Option
– Creating and Deleting an Oracle Database Using DBCA
– Database Planning and Password Management
– Creating Database Design Templates
Managing the Oracle Database Instance
– Starting and Stopping Oracle Database and Components
– Using Oracle Enterprise Manager and SQLPlus
– Modifying Database Parameters
– Stages of Database Startup and Shutdown Options
– Viewing Alert Logs and Dynamic Performance Views
Managing ASM (Automatic Storage Management)
– Setting Up Initialization Parameters for ASM Instances
– Starting and Shutting Down ASM Instances
– Administering ASM Disk Groups
Configuring Oracle Network Environment
– Creating and Configuring Listeners Using Enterprise Manager
– Enabling Oracle Restart for Listener Monitoring
– Testing Oracle Net Connectivity with tnsping
– Choosing Between Shared and Dedicated Servers
Managing Database Storage Structures
– Understanding Storage Structures and How Table Data is Stored
– Anatomy of a Database Block and Space Management in Tablespaces
– Managing Tablespaces in Preconfigured Databases
– Oracle Managed Files (OMF) Overview
Administering User Security
– Managing Database User Accounts and Predefined Administrative Accounts
– Using Roles and Predefined Roles
– Implementing Profiles for User Management
Managing Data Concurrency
– Understanding Data Concurrency and the Enqueue Mechanism
– Resolving Lock Conflicts and Handling Deadlocks
Managing Undo Data
– Undo Data vs Redo Data
– Configuring Undo Retention and Managing Transactions
Implementing Oracle Database Auditing
– Responsibilities of a DBA for Security
– Enabling Database Auditing and Reviewing Audit Information
Database Maintenance
– Managing Optimizer Statistics
– Using Automatic Workload Repository (AWR) and ADDM
– Setting Alert Thresholds and Using Server-Generated Alerts
– Managing Automated Tasks
Performance Management
– Monitoring Performance and Managing Memory Components
– Enabling Automatic Memory Management (AMM)
– Using Memory Advisors and Troubleshooting Views
– Handling Invalid and Unusable Objects
Backup and Recovery Concepts
– Understanding Job Roles in Backup and Recovery
– Handling Instance Recovery and Media Failures
– Using the MTTR Advisor and Archive Log Files
– Backup Solutions: Oracle Secure Backup, RMAN, User-Managed Backups
– Configuring Backup Settings and Monitoring Flash Recovery Area
Performing Database Recovery
– Opening a Database and Using Data Recovery Advisor
– Recovering from Control File and Redo Log File Loss
– Listing and Resolving Data Failures
Moving Data
– Methods for Moving Data: SQL*Loader, External Tables
– Oracle Data Pump Architecture
– Using Data Pump Export and Import
Working with Support
– Using Enterprise Manager Support Workbench
– Logging Service Requests (SR) with Oracle Support
– Managing Patches