Duration
5 days
Course Outline
1 Introduction
- Oracle Database Innovation
- Oracle 19c Database New Features
- Relation Database Models HR Sample Schema
2 Installation and configuration
3 Exploring Oracle Database Architecture
- Oracle Database Server Architecture: Overview
- Oracle Database Instance Configurations
- Connecting to the Database Instance
- Oracle Database Memory Structures
- Shared Pool
- Database Buffer Cache
- Redo Log Buffer
- Large Pool
- Java Pool
- Streams Pool
- Program Global Area
- Process Architecture
- Database Writer Process (DBWn)
- Log Writer Process (LGWR)
- Checkpoint Process (CKPT)
- System Monitor Process (SMON)
- Process Monitor Process (PMON)
- Recoverer Process (RECO)
- Listener Registration Process (LREG)
- Archiver Processes (ARCn)
- Database Storage Architecture
- Logical and Physical Database Structures
- SYSTEM and SYSAUX Tablespaces
- Oracle Container Database: Introduction
- Multitenant Architecture
- Interacting with an Oracle Database: Memory, Processes, and Storage
- Practice
4 Oracle Database Management Tools
- Oracle Database Management Tools: Introduction
- Using SQL*Plus
- Oracle SQL Developer: Connections
- Logging In to Oracle Enterprise Manager Database Express
- Practice
5 Administering User Security
- Database User Accounts
- Predefined Administrative Accounts
- Administrative Privileges
- Protecting Privileged Accounts
- Authenticating Users
- Administrator Authentication
- OS Authentication and OS Groups
- Managing Users
- Creating a User
- Unlocking a User Account and Resetting the Password
- Privileges
- System Privileges
- Revoking System Privileges with ADMIN OPTION
- Granting Object Privileges
- Object Privileges
- Revoking Object Privileges with GRANT OPTION
- Using Roles to Manage Privileges
- Assigning Privileges to Roles and Assigning Roles to Users
- Predefined Roles
- Creating a Role
- Secure Roles
- Assigning Roles to Users
- Privilege Analysis
- Privilege Analysis Flow
- Profiles and Users
- Implementing Password Security Features
- Creating a Password Profile
- Supplied Password Verification Functions
- Modifications to the Default Profile
- Assigning Quotas to Users
- Applying the Principle of Least Privilege
- Practice
6 Managing the Database Instance
- Initialization Parameter Files
- Types of Values in Initialization Parameters
- Initialization Parameters: Examples
- Using SQL*Plus to View Parameters
- Changing Initialization Parameter Values
- Starting Up an Oracle Database Instance
- Shutdown Modes
- Viewing the Alert Log
7 Backup and Recovery
- Categories of Failure
- Files to backup
- Types of backup
- Backup RMAN
- Types of Recovery
- Flashback technology.
- Incremental backup
8 Stored Procedure
9 Triggers
10 Index
Overview
- Index types
- Index fragmentation and rebuild
11 Multitenant Databases
Overview
- Create and Configure a Pluggable Database (PDB)
Programme scope, delivery arrangements and suitability are confirmed during enquiry.