Introduction
  • What is a Database?
  • Role of a DBA!!!
  • OLTP vs OLAP Databases
  • What is Oracle 11g?
  • What is Oracle 12c?
  • Database abc's
  • Undo vs Redo Data
  • Oracle Instance vs Database
  • Quiz Time!!!
Oracle Process Architecture
  • Process Architecture
  • Database Writer Process
  • Log writer Process
  • Checkpoint Process
  • SMON Process
  • PMON Process
  • RECO Process
  • Archiver Process
  • Quiz Time!!!
Oracle Memory Architecture
  • Memory Architecture
  • Database Buffer Cache
  • Shared Pool
  • REDO log buffer
  • Large Pool
  • Java Pool and Streams Pool
  • Keep Buffer Pool
  • Recycle Buffer Pool
  • nK Buffer Cache
  • Program Global Area (PGA)
  • Dedicated vs Shared Databases
  • PGA in a Shared Envrionment
  • Quiz Time!!!
Architecture Recap
  • Architecture Full Picture!!!!
  • Architecture Quiz!!!
Software Installation
  • Software Download...
  • Virtual Machine Installation
  • Linux Installation
  • Oracle Software Installation
  • Oracle Parameter Files
  • Database creation - Manual Method Demo
  • Verify Database creation
  • Database creation using DBCA (Preferred option)
  • Oracle Startup Steps...
  • Oracle Shutdown methods
  • Oracle 12c Upgrade
Tablespace Management
  • How data is stored in a Database?
  • Tablespace Concepts
  • Online and Offline Tablespaces
  • Let's create a Tablespace...
  • Let's add more space to the Database...
  • Tablespace Demo 1
  • Tablespace Demo 2
  • Tablespaces with different block sizes
  • Temporary Tablespace Management
  • Temporary Tablespace Groups
  • Extent Management (Local vs Dictionary managed)
UNDO Management
  • UNDO Concepts
  • Read Consistency
  • ORA-01555 snapshot too old error
  • Automatic Undo Management
  • UNDO Management
  • Configuring Undo Retention Period
  • Retention Guarantee!!
REDO Management
  • REDO Concepts
  • REDO Logfile Management Demo1
  • REDO Logfile Management Demo2
  • Archival Concepts
  • Archival Log Mode Demo
User Management
  • User Management Concepts
  • User Management Demo 1
  • User Management Demo 2
  • User Creation Exercise
  • Privileges
  • System Privileges Demo
  • Object Privileges Demo
  • Revoking User Privileges
  • Revoking System Privileges
  • Revoking Object Privileges
  • Let's practice what we learnt so far...
  • Role Management Concepts
  • Role Management Demo
  • User Profiles
  • User Profile Demo
  • Managing Passwords using Profiles
Oracle Networking
  • Networking Concepts
  • Listener Configuration Demo
  • TNSNAMES Configuration Demo
  • Database Link Concepts
  • Public Database Link
  • Private Database Link
Data Dictionary