Course Introducion :
The Oracle Database Administration Workshop 1 (DB1) is the foundation course for individuals aspiring to become Oracle Database Administrators (DBAs).
This course introduces participants to the core concepts, architecture, and administrative tasks required to manage an Oracle database efficiently.
The course focuses on Oracle Database 19c, Oracle’s Long-Term Support Release, and emphasizes the Multitenant Architecture (CDB/PDB), along with database installation, configuration, storage management, user and security administration, and basic backup and recovery operations.
The course combines theoretical sessions with hands-on lab exercises that simulate real-world DBA tasks, providing practical experience in database administration and operations.
Course outline
Day One : Introduction to Oracle Database
- Overview of Oracle Database architecture
- Database instance, memory structures (SGA, PGA)
- Background processes
- Physical and logical storage structures
- Multitenant architecture: CDB and PDB concepts
Day Two: Accessing the Database
- Using SQL*Plus, SQL Developer, and Oracle Enterprise Manager
- Connecting as different users
- Viewing database information and environment variable
Day Three : Installing Oracle Software
- Oracle installation methods (GUI, silent mode)
- Configuring Oracle Home and environment variables
- Applying patches and updates
Day Four : Creating Databases with DBCA
- Using Database Configuration Assistant (DBCA)
- Creating a container database (CDB) and pluggable databases (PDBs)
- Understanding templates and parameter options
Day Five : Creating Databases Manually
- Using CREATE DATABASE SQL command
- Enabling pluggable database options
- Configuring file locations and naming conventions