Oracle SQL Tutorial

Oracle — Introduction & Environment Setup

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

Oracle — Database Startup & Connection

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

Oracle — Architecture & Internals

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

Oracle — Database Administration

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

Oracle — Security & User Management

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

Oracle — Tablespaces & Storage

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

Oracle — SQL & PL/SQL

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

Oracle — Backup, Recovery & Flashback

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

Oracle — Performance & High Availability

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

Oracle — Cloud & Modern Features

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

Oracle — Real-World Projects

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