| Introduction | Why database, ACID and BASE properties, E.F. Codd’s Rule, Cardinality, CAP Theorem, Difference between RDBMS and NoSQL database |
| Database Design | Normalization Rules, ER diagrams |
| Architecture | Introduction to Oracle, Oracle Architecture |
| Data Types | Oracle Data types |
| SQL | Creation and Manipulation of objects using DML, DDL, DCL, TQL & TCL statements Functions (Single Row, Group, Conversion, Analytic) in Oracle, Oracle Constraints, Oracle Views, Sequences, Synonyms, Indexes, Views |
| SQL Objects | Creation of Types, Nested Table, Insertion & Retrieving data from Nested Table |
| PL/SQL | Creation of Procedures, Functions, Triggers and Packages in PL/SQL |
| DBA Overview | Architecture Overview, Multi-Tenant Architecture, Instance Parameters, Listener Control Overview, Starting up and shutting down database |
| DB Creation | Creation of Database using DBCA, Creating a CDB, Creating a PDB from Seed, Other Techniques to create a PDB, Opening and Closing a PDB, Managing PDB |
| Network | Configuring Oracle Net Service, Administering Listener, Shared Server Architecture |
| DBA Account Management | User Creation, Granting of Roles, Privileges, User Profile, Auditing, Resource Limits |
| DBA – Data Management | Storage Structure, Tablespace, UNDO tablespace management, Improving Space Usage |
| Backup & Recovery | RMAN, Flashback |
| Data Transportation | External Tables, SQL Loader, Data Pump |
| Maintenance | Automated Maintenance Tasks, |
| Performance Tuning | Performance Tuning and SQL Optimization, Statspack, using ADDM for Performance Monitoring, Automatic SQL Tuning, SQL Advisor, Real Time DB monitoring, TKPROF |
| Upgrade | Software upgrade Methods |
