Oracle Database Administration Course

Oracle Database Administration Course

• Introduction 0/6

  • Lecture 1.1
    Introduction to Oracle Database
  • Lecture 1.2
    Oracle Client/Server Architecture
  • Lecture 1.3
    Database and Instance
  • Lecture 1.4
    Oracle Database 11g
  • Lecture 1.5
    Oracle Database 12c
  • Lecture 1.6
    Oracle Database 19c

• Installation 0/6

  • Lecture 2.1
    Operating Systems and Downloading installer
  • Lecture 2.2
    System Requirements
  • Lecture 2.3
    Oracle Express Edition 18c
  • Lecture 2.4
    Oracle SQL Developer Client
  • Lecture 2.5
    Creating and Configuration an Oracle Database
  • Lecture 2.6
    Starting Up and Shutting Down

• Managing the Database Instance 0/5

  • Lecture 3.1
    Instance Management
  • Lecture 3.2
    Create Database
  • Lecture 3.3
    Create Tablespace
  • Lecture 3.4
    Viewing and Modifying Initialization Parameters
  • Lecture 3.5
    Managing Memory Parameters

• Memory Structure 0/8

  • Lecture 4.1
    Instance Memory Structure
  • Lecture 4.2
    System Global Area (SGA)
  • Lecture 4.3
    Shared Pool
  • Lecture 4.4
    Database Buffer Cache
  • Lecture 4.5
    Redo Log Buffer
  • Lecture 4.6
    Large Pool
  • Lecture 4.7
    Java Pool and Streams Pool
  • Lecture 4.8
    Program Global Area (PGA)

• Process Structure 0/7

  • Lecture 5.1
    Background Processes
  • Lecture 5.2
    Database Writer (DBWn)
  • Lecture 5.3
    Log Writer (LGWR)
  • Lecture 5.4
    Checkpoint
  • Lecture 5.5
    System Monitor (SMON)
  • Lecture 5.6
    Process Monitor (PMON)
  • Lecture 5.7
    Archiver (ARCn)

• Storage Structure 0/3

  • Lecture 6.1
    Logical and Physical Database Structures
  • Lecture 6.2
    Segments, Extents and Blocks
  • Lecture 6.3
    Data Files