Oracle Database

Full Oracle Database course — 68 topics from the basics to advanced use.

Lessons

• JSON, XML and Large Objects
• Spatial, Graph, Text and Vector Search
• Flashback Technologies
• External Tables, SQL*Loader and Database Links
• Database Creation, Startup and Shutdown
• Storage Structures
• Redo, Undo, Control Files and Archiving
• Oracle Net Services
• Multitenant Architecture (CDB/PDB)
• Users, Privileges, Roles and Profiles
• Advanced Security
• Backup and Recovery with RMAN
• Data Pump: Export and Import
• Scheduler, Jobs and Automation
• Automatic Storage Management (ASM)
• Patching, Upgrading and Migration
• Introduction to Databases and Oracle
• Installation, Tools and Environment Setup
• Oracle Architecture Overview
• Data Types
• DDL: Tables and Constraints
• DML: Inserting, Updating and Deleting Data
• Basic Querying with SELECT
• Single-Row Functions
• Indexing in Depth
• The Optimizer and Execution Plans
• Optimizer Statistics
• SQL Tuning
• Instance Tuning: AWR, ASH, ADDM and Wait Events
• Memory Management
• Partitioning
• Compression and Database In-Memory
• Parallel Execution
• Resource Manager
• Real Application Clusters (RAC)
• Data Guard
• GoldenGate and Replication
• Maximum Availability Architecture and Online Operations
• Exadata and Engineered Systems
• Oracle Cloud: OCI, Autonomous Database and Multicloud
• What's New in Oracle 19c, 21c, 23ai and 26ai
• APEX, ORDS and Application Development
• Monitoring with Enterprise Manager and Diagnostics
• DevOps, Testing and Best Practices
• Appendices: Projects, Interview Questions, Cheat Sheet & Certification
• Aggregation and Grouping
• Joins
• Set Operators
• Subqueries
• WITH Clause and Recursive Queries
• Hierarchical Queries (CONNECT BY)
• Analytic (Window) Functions
• PIVOT, UNPIVOT, MODEL and MATCH_RECOGNIZE
• Views, Materialized Views, Sequences and Synonyms
• Transactions and Read Consistency
• Database Design and Normalization
• PL/SQL Fundamentals
• Cursors
• Exception Handling
• Procedures and Functions
• Packages
• Triggers
• Records and Collections
• Bulk Processing: BULK COLLECT and FORALL
• Dynamic SQL
• Advanced PL/SQL
• Built-in Packages
• Course Overview