Oracle Database Course Index – Dataplexa

Oracle Database Course Index

Complete Oracle Database learning roadmap — 40 structured lessons covering SQL fundamentals, Oracle architecture, PL/SQL, performance tuning, administration, and enterprise database management.

Open Oracle DB Course Back to Learning Hub

I. Foundations Level (10 Lessons)

1. Introduction to Databases 2. SQL vs NoSQL Databases 3. What is Oracle Database 4. Oracle Editions & Use Cases 5. Installing Oracle & SQL Developer 6. Oracle Database Architecture 7. Tablespaces & Data Files 8. Tables, Rows & Columns 9. Oracle Data Types 10. Creating Tables in Oracle

II. Core SQL & Data Handling (12 Lessons)

11. Constraints & Keys 12. Sequences & Identity Columns 13. INSERT Data 14. SELECT Queries 15. WHERE Clause & Filtering 16. ORDER BY & FETCH FIRST 17. UPDATE Data 18. DELETE Data 19. Aggregate Functions 20. GROUP BY 21. HAVING Clause 22. NULL Handling in Oracle

III. Joins, Subqueries & PL/SQL (10 Lessons)

23. Table Relationships 24. INNER JOIN 25. LEFT, RIGHT & FULL OUTER JOIN 26. Subqueries 27. Views 28. Indexes in Oracle 29. Introduction to PL/SQL 30. PL/SQL Procedures & Functions 31. Triggers 32. Performance Optimization Basics

IV. Enterprise & Administration (8 Lessons)

33. Users, Roles & Privileges 34. Transactions & Concurrency Control 35. Backup & Recovery (RMAN) 36. Oracle Security Best Practices 37. Oracle Performance Tuning 38. Oracle Data Pump (Export & Import) 39. Oracle Database in Cloud (OCI) 40. Mini Project