1) Oracle Architecture & Components
- Difference between instance and database
- Memory structures (SGA, PGA)
- Background processes
- Physical files: datafiles, control files, redo logs
Lab
- Query V$ and dictionary views to identify components
- Inspect the file structure of a running database
2) Storage & Logical Structures
- Logical structures: tablespaces, segments, extents, blocks
- Types of tablespaces (SYSTEM, UNDO, TEMP, user)
- Datafile operations: add, resize, rename
Lab
- Create and manage tablespaces
- Add and resize datafiles
- Map logical to physical structures
3) Instance Operations & Logging
- Startup modes, shutdown modes
- Redo logs, archived redo logs
- Rollforward, recovery basics
- Alert log and trace files
Lab
- Start and stop instance in various modes
- Simulate a log switch, archive logs
- Explore the alert log and trace directories
4) User Security & Privileges
- Users, roles, system and object privileges
- Authentication methods
- Password policies, default roles
Lab
- Create users and roles
- Grant and revoke privileges
- Configure authentication mode
5) Backup & Recovery Fundamentals
- Recovery concepts: complete, incomplete recovery
- Recovery tools overview (RMAN, user-managed)
- Data protection modes
Lab
- Simulate basic backup and restore (user-managed)
- Recover a database to a point in time
6) Tools & Administration Interfaces
- SQL*Plus, SQL Developer basics
- Enterprise Manager basics
- Data dictionary and catalog views
Lab
- Use SQL*Plus to query, create objects, run scripts
- Use EM to view database status
- Explore data dictionary views
