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 |