Oracle SQL Tutorial

Oracle — Introduction & Environment Setup

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

Oracle — Database Startup & Connection

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

Oracle — Architecture & Internals

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

Oracle — Database Administration

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

Oracle — Security & User Management

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

Oracle — Tablespaces & Storage

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

Oracle — SQL & PL/SQL

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

Oracle — Backup, Recovery & Flashback

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

Oracle — Performance & High Availability

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

Oracle — Cloud & Modern Features

79 Oracle Cloud Infrastructure 8 min 80 Autonomous Database 8 min 81 AI Vector Search 8 min 82 Blockchain Tables 8 min 83 JSON Relational Duality 8 min 84 SQL Firewall 8 min 85 Automatic Indexing 8 min 86 AI Database Features 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