| 1 |
Introduction & Setup |
- Relational Database Concepts
- Environment Setup
- Familiarize with SQL Developer
|
- Set up the environment and understand basic concepts.
|
| 2 |
Oracle Architecture |
- Instance and Database
- Logical Structure
- Users and Schemas
|
- Understand the core components of Oracle.
|
| 3 |
Basic SQL |
- ORDER BY
- Simple Functions
|
- Write basic queries to retrieve and sort data.
|
| 4 |
Data Manipulation (DML) |
|
- Manipulate and modify data in tables.
|
| 5 |
Advanced Querying |
- JOINs
- Aggregate Functions & GROUP BY
- Subqueries
- Analytic Functions
|
- Write complex queries and analyze data.
|
| 6 |
Data Definition (DDL) |
- CREATE, ALTER, DROP
- Constraints
|
- Manage the structure of database objects.
|
| 7 |
PL/SQL Programming |
- Anonymous PL/SQL Blocks
- Variables and Control Flow
- Cursors
|
- Write programming code blocks in Oracle.
|
| 8 |
Schema Objects |
- Procedures & Functions
- Packages
- Triggers
|
- Create reusable code units.
|
| 9 |
Transaction Management |
- ACID Properties
- COMMIT, ROLLBACK, SAVEPOINT
|
|
| 10 |
Optimization & Performance |
- Indexes
- Execution Plan
- Hints
|
- Improve the performance of queries.
|
| 11 |
Basic Administration |
- User and Privilege Management
- Backup and Restore
|
- Perform basic administrative tasks.
|