Oracle Course - Detailed Content
Module 1: Introduction to Oracle
- Oracle database architecture
- Installing Oracle 10g
- Oracle Enterprise Manager
Module 2: SQL Fundamentals
- SELECT statements and filtering
- Joins and subqueries
- DML operations (INSERT, UPDATE, DELETE)
- DDL operations (CREATE, ALTER, DROP)
Module 3: Database Administration
- Tablespace management
- User and privilege management
- Backup and recovery
- Performance monitoring
Module 4: PL/SQL Programming
- PL/SQL blocks and variables
- Cursors and exceptions
- Stored procedures and functions
- Triggers and packages