Oracle DataBase Lesson 16 – ORDER BY FETCH FIRST | Dataplexa

Oracle Database

I. Foundations
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
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 & PL/SQL
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 & Admin
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
← Previous Course Index Next →