Oracle SQL Tutorial

Module 1: Introduction & Environment Setup

1 Introduction to Oracle Database — Complete Guide 9 min 2 Oracle Database vs Database Instance — Complete Guide 9 min 3 Oracle Architecture — Complete Guide 9 min 4 Oracle Database Files — Complete Guide 9 min 5 Oracle Storage Structures — Complete Guide 9 min 6 Oracle Multitenant Architecture — Complete Guide 9 min 7 Oracle DBA Tasks — Complete Guide 9 min 8 Oracle VirtualBox Installation — Complete Guide 9 min 9 Oracle Linux Installation — Complete Guide 9 min 10 Basic Linux Commands — Complete Guide 9 min 11 Oracle Database Installation — Complete Guide 9 min 12 SQL Developer Installation — Complete Guide 9 min 13 Putty & WinSCP Setup — Complete Guide 9 min

Module 2: Database Startup & Connection

14 Database Startup — Complete Guide 9 min 15 Database Shutdown — Complete Guide 9 min 16 SYS User Connection — Complete Guide 9 min 17 SQL*Plus Connection — Complete Guide 9 min 18 Listener Management — Complete Guide 9 min 19 PDB Switching — Complete Guide 9 min 20 Easy Connect — Complete Guide 9 min 21 tnsnames.ora — Complete Guide 9 min 22 Connection Troubleshooting — Complete Guide 9 min

Module 3: Oracle Architecture & Internals

23 SGA & PGA — Complete Guide 9 min 24 Background Processes — Complete Guide 9 min 25 Redo Logs — Complete Guide 9 min 26 Undo Segments — Complete Guide 9 min 27 Control Files — Complete Guide 9 min 28 Data Dictionary — Complete Guide 9 min 29 Dynamic Performance Views — Complete Guide 9 min 30 Oracle Internals — Complete Guide 9 min

Module 4: Database Administration

31 Initialization Parameters — Complete Guide 9 min 32 PFILE & SPFILE — Complete Guide 9 min 33 ALTER SYSTEM — Complete Guide 9 min 34 ALTER SESSION — Complete Guide 9 min 35 Parameter Tuning — Complete Guide 9 min 36 Oracle Networking — Complete Guide 9 min 37 Database Links — Complete Guide 9 min 38 Oracle Net Manager — Complete Guide 9 min

Module 5: Security & User Management

39 Users — Complete Guide 9 min 40 Roles — Complete Guide 9 min 41 Privileges — Complete Guide 9 min 42 Profiles — Complete Guide 9 min 43 Password Policies — Complete Guide 9 min 44 PDB_DBA — Complete Guide 9 min 45 SYS User — Complete Guide 9 min 46 Oracle Security — Complete Guide 9 min

Module 6: Tablespaces & Storage

47 Tablespaces — Complete Guide 8 min 48 Datafiles — Complete Guide 8 min 49 Segments — Complete Guide 9 min 50 Extents — Complete Guide 8 min 51 Blocks — Complete Guide 9 min 52 Compression — Complete Guide 8 min 53 Row Migration — Complete Guide 9 min 54 Space Management — Complete Guide 9 min

Module 7: SQL & PL/SQL

55 SQL Queries — Complete Guide 9 min 56 Joins — Complete Guide 9 min 57 Window Functions — Complete Guide 9 min 58 Stored Procedures — Complete Guide 9 min 59 Functions — Complete Guide 9 min 60 Packages — Complete Guide 9 min 61 Triggers — Complete Guide 9 min 62 Exception Handling — Complete Guide 9 min

Module 8: Backup, Recovery & Flashback

63 Undo Management — Complete Guide 9 min 64 Redo Management — Complete Guide 9 min 65 Flashback Query — Complete Guide 9 min 66 Flashback Table — Complete Guide 9 min 67 RMAN — Complete Guide 9 min 68 Backup Strategies — Complete Guide 9 min 69 Point-in-Time Recovery — Complete Guide 9 min 70 Disaster Recovery — Complete Guide 9 min

Module 9: Performance & High Availability

71 AWR — Complete Guide 9 min 72 ADDM — Complete Guide 9 min 73 SQL Tuning Advisor — Complete Guide 9 min 74 Explain Plans — Complete Guide 9 min 75 Oracle RAC — Complete Guide 9 min 76 Oracle ASM — Complete Guide 9 min 77 Oracle Data Guard — Complete Guide 9 min 78 HA Architecture — Complete Guide 9 min

Module 10: Oracle Cloud & Modern Features

79 Oracle Cloud Infrastructure — Complete Guide 9 min 80 Autonomous Database — Complete Guide 9 min 81 AI Vector Search — Complete Guide 9 min 82 Blockchain Tables — Complete Guide 9 min 83 JSON Relational Duality — Complete Guide 9 min 84 SQL Firewall — Complete Guide 9 min 85 Automatic Indexing — Complete Guide 9 min 86 AI Database Features — Complete Guide 9 min

Module 11: Real-World Projects

87 Banking Core System — OracleCore Project 9 min 88 Airline Reservation System — OracleCore Project 9 min 89 Telecom Billing Platform — OracleCore Project 9 min 90 ERP Platform — OracleCore Project 9 min 91 Healthcare System — OracleCore Project 9 min 92 Government Data Platform — OracleCore Project 9 min 93 AI Analytics Platform — OracleCore Project 9 min 94 Enterprise Cloud Platform — OracleCore Project 9 min 95 RAC Enterprise Cluster — OracleCore Project 9 min 96 High Availability Banking Platform — OracleCore Project 9 min