Description
In this course, you will learn :
- Oracle databases can be created on Linux and Windows platforms.
- Execute basic DBA tasks on Oracle databases.
- Take care of Oracle database files.
- Taking care of database storage structures.
- Manage the multitenancy of a database.
- Create backup and recovery plans.
- Patches and database upgrades should be applied.
- Perform the fundamentals of performance tuning.
- Install the Oracle Restart configuration.
- Resolve Oracle database issues.
Syllabus :
- Preparing Course Practice Environment
- Introduction to RDBMS
- Database Architecture
- Installing and Creating Oracle Databases
- Oracle Database Basic Administration
- Fundamentals of Oracle Database Multitenancy
- Managing Oracle Database Components
- Managing Database Segments
- Managing Database Users and Security
- Managing Database Connectivity
- Configuring Shared Server
- Managing Fast Recovery Area and Redo Log
- Taking Backups in Oracle Databases
- Database Recovery
- Using RMAN in Multitenant Databases
- More about using RMAN
- Flashback Database
- Using Oracle Database Utilities
- Using the Scheduler
- Using ADR Command Interpreter
- Applying Patches on Oracle Databases
- Automatic Storage Management (ASM)
- Upgrading Oracle Databases