Preview unavailable

Course Materials

• Slides

• Lab Guide

LESSON 1: Introduction to DBMS and RDBMS

• Overview of DBMS, RDBMS

LESSON 2: Introduction to Oracle Database Server

• What is Oracle Database Server?

• Responsibilities of Oracle DBA

• Oracle Database Versions, Editions and Management Packs

LESSON 3: Architecture of Oracle Database Server

• Database and Instance1

• Instance Configurations

• Applications and Databases

• Tablespaces, Data Files, Data Blocks, Schema1

• Overview of Data Dictionary1

• Client Process and Server Process

• Dedicated Server and Shared Server

• Overview of SGA and Background Processes

• Shared Pool

• Database Buffer Cache1

• Redo Log Buffer1

• Writing of modified Buffers to the Database

• Instance Recovery1

• Fixed SGA

• Process Monitor

• Concluding the Instance Concepts

• PGA Memory2

• Initialization Parameters

• Oracle Database Memory Management

Overview of Oracle Database Installation

• Overview of Oracle Database Installation

Creating Linux VM

• Download and Install VirtualBox

• Creating VM

• Link to download Oracle Linux 7.6 software from One Drive

• Downloading Oracle Linux from Oracle Portal

• Installing Oracle Linux

• Configuring Oracle Linux

Installing Oracle Database

• About Optimal Flexible Architecture (OFA)

• Understanding Installation Requirements

• Configuring Installation Requirements

• Downloading Oracle Database software from One Drive

• Downloading Oracle Database Software from Oracle Portal

• Installing Oracle Database Software

• Creating Database

Post Installation Tasks

• Setting Environment Variables

• How to start/stop DB, VM, Physical Machine?1

• Understanding the Installed Database

Data Dictionary

• About Data Dictionary

• Lab Practices

Managing Database Startup and Shutdown

• Overview of Database Startup

• Lab Practices: Database Startup

• Overview of Database Shutdown

• Lab Practice: Database Shutdown

Managing Initialization Parameters

• Managing Initialization Parameters

• Lab Practice: Managing Initialization Parameters

Managing Diagnostic Data

• Managing Diagnostic Data

• About Diagnostic Data

• Lab Practice: Managing Diagnostic Data

Managing Tablespaces and Data Files

• Overview of Tablespaces

• Overview of Data Files

• Overview of ROWID

• How Database allocates Space?

• Extent Management

• Segment Space Management

• Row Chaining and Row Migration

• Fragmentation

• High Water Mark (HMW)

• Shrinking Segments

• Classification of Tablespaces

• About default Tablespaces

• Lab Practice: Querying information about default tablespaces

• Lab Practice: Creating Tablespaces

• Managing Tablespaces

• Managing Data Files - Part1

• Managing Data Files - Part2

• More Demos

Managing Temporary Tablespaces

• Overview of Managing Temporary Tablespaces

• Lab Practices: Managing Temporary Tablespaces

Managing Undo Tablespaces

• Overview of Undo Tablespace

• Overview of Managing Undo Tablespaces

• Lab Practices: Managing Undo Tablespaces

Managing Control Files

• Overview of Control Files

• Overview of Managing Control Files

• Lab Practices: Managing Control Files

Managing Redo Log

• Overview of Redo Log Files

• Overview of Managing Online Redo Log

• Lab Practices: Managing Online Redo Log

Managing Archive Log

• Overview of Archive Log Mode

• Lab Practices: Archive Log

Oracle Managed Files (OMF)

• About Oracle Managed Files

• Configuring OMF

• OMF Name Formats

• Lab Practices: Configuring and Using OMF

User Administration

• Overview of Administering User Accounts

• About Predefined Accounts and Schema only Accounts

• Lab Practices: Administering User Accounts

Profiles Administration

• Overview of Profiles

• Lab Practices: Using Profiles

Privileges and Roles

• Managing Database Privileges and Roles

Oracle Net Services

• About Oracle Net Services

• Components of Oracle Net Services

• About Oracle Net Listener

• Overview of Creating and Managing Oracle Net Listeners

• Overview of Establishing Net Connections

• How to Implement and Test Oracle Net Services on Laptop

• Lab Practice: Configuring Network between Physical Machine and VM1

• Lab Practice: Starting Default Listener

• Lab Practice: Installing Oracle Client

• Lab Practice: Establishing Remote Database Connectivity

• Creating Custom Listener using NETCA

• Creating Custom Listener Manually

• Using TNSPING utility

Recovery Manager (RMAN)

• About Recovery Manager (RMAN)

• RMAN Concepts

• Backup Set Backup and Image Copy Backup

• Lab Practice: Starting RMAN and Managing RMAN Configuration Parameters

• Performing Backup and Reporting operations using RMAN

• Overview of Configuring Recovery Catalog

• Lab Practice: Configuring Recovery Catalog

• Registering Target Database in Recovery Catalog

• Overview of Recovery using RMAN

• Recovering Non-System Data Files

• Recovering Non-System Tablespace

• Recovering System Data Files

• Recovering ALL Data Files

• Recovering Control Files

• Recovering SPFILE

• Recovering Complete Database

• Restoring to a NEW Location

• Recovery using Image Copies

• Database Point in Time Recovery

• Tablespace Point in Time Recovery

Flashback Features

• Overview of Flashback Database

• Lab Practice: Configuring Flashback Database

• Lab Practice: Performing Flashback Database Operation

• Overview of Flashback Drop Table

• Lab Practice: Performing Flashback Drop Table Operation

Oracle Data Pump

• Overview of Oracle Data Pump

• Lab Practices: Using Data Pump

Patching

• Updating Software using Patches

• Links to download Patch files2

Upgrading

• Upgrading the Database

Multitenant Container Database Administration

• Creating Container Database

• Administering Container Database