Oracle Database Administration from Zero to Hero

Oracle Database Administration course /Multitenancy/ Oracle Database Backup&Recovery/Data Guard/Patching & Upgrade

Created by: Oleksiy Gusarov
Database expert at Oracle

What Will I Learn?

• Oracle Database Administration
• Oracle Database Architecture, Physical files of the DB, Memory Structures, Memory Management, Background Processes
• How to install Oracle Database Software on the server without GUI
• How to access Oracle Database via sqlplus, sqlcl and SQL Developer
• Managing Database Instance: Starting and Shutting down DB, working with initialization parameters, Diagnosing problems, working with Data Dictionary
• Oracle Net Services
• Administering User Access, Privileges & Roles, Resource Limitation
• Multitenancy: Creating PDBs from SEED, Clonning PDBs, creating Refreshable Clones, Unplug/Plug PDBs
• Transparent Data Encryption (TDE)
• Creating and Managing Tablespaces
• Managing UNDO Data
• Practicing different Backup and Recovery scenarious via RMAN
• Moving Data: Data Pump, SQL Loader
• Data Guard configuration
• Applying the latest Database Patch
• Database Upgrade from 19c to 21c

Requirements

• Basic Linux Knowledge
• understand what is a process in linux
• Basic SQL Knowledge

Target audience

• Students looking for a job in IT industry
• IT specialists willing to improve their database knowledge
• Retraining for DBA who worked with other Database Management Systems
• Oracle Database Beginners willing to advance