Database Administration

DBA Roles and Responsibilities; Database Architecture; ORACLE logical and physical database structure; Memory and Process Structure, SQLPLUS Overview, creating a database;

Working with Tablespaces and Data Files, Creating and adding tablespace and datafiles, Managing Control Files, Online Redo Logs and Archive logs; Multiplexing;

Working with Tables and Constraints; Working with Indexes, Views, Synonyms, and Sequences; Partitioning and Materialized Views, Introduction of PLSQL, Stored Procedure, Functions, Trigger, package.

Backup and Recovery Overview, Database backup, restoration and recovery, defining a backup and recovery strategy, Backup and Recovery options; Data Dump; User-Managed Backup and Recovery; Configuring RMAN; RMAN Backups, Restore and Recovery; High Availability Features; Oracle Data Guard; Flashback operations.

Database Security and Auditing; Database Authentication Methods; Database Authorization Methods; Data Encryption Techniques, Virtual Private Database; Managing Users and Security: Profiles, managing users, managing privileges, managing roles,\n111

Understanding the Multitenant Architecture, Pluggable Architecture; Creating CDB; Administrating Root Container; Creating Pluggable Databases (PDBs) within a CDB; Administrating Pluggable Databases; Backup and Recovery in multitenant Environment; Databases in the Cloud

Tuning Application Design; Tuning Memory Usage; Tuning Data Access; Tuning Data Manipulation; Reducing Network Traffic; Using Automatic Workload Repository(AWR); Automatic Database Diagnostic Monitor(ADDM), Tuning SQL; SQL Tuning Advisor, Performance Tuning in a Multitenant Environment; Distributed Databases and Networking Tool