Course Description
Preston IT’s Oracle Database Administration training program will help you master vital skills as an Oracle DBA, and understanding the role of an Oracle DBA in real life industry. As part of our training, you will master the Oracle database architecture, the database processes, memory structures, database objects, security measures, data backup and recovery methods through engaging lectures and hands-on projects.
Oracle Course Outline
- • Introduction to SQL Fundamentals
- • Constraints
- • Data Definition Language (DDL) and Data Manipulation Language (DML)
- • Other Schema Objects
- • Linux
- • Database Creation
- • Oracle Architecture
- • Networking
- • Datafiles and Tablespace Management
- • Oracle Enterprise Manager (OEM)
- • Migration
- • Backup and Recovery
- • Security
- • Performance Management and Tuning
- • PROJECTS (Upgrade, Patching, RMAN Duplicate, Managing Controlfiles)
