Duration
4 days
Overview
This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
Audience
- Data Warehouse Administrator
- Database Administrator
- Database Designer
- Support Engineer
- Technical Administrator
Introduction
- Oracle Database Innovation
- Oracle 19c Database New Features
- Relation Database Models HR Sample Schema
Installation and configuration
- 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
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
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
- 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
Backup and Recovery
- Categories of Failure
- Files to backup
- Types of backup
- Backup RMAN
- Types of Recovery
- Flashback technology.
- Incremental backup
Stored Procedure
- Triggers
Overview
- Index types
- Index fragmentation and rebuild
Overview
- Create and Configure a Pluggable Database (PDB)
Programme scope, delivery arrangements and suitability are confirmed during enquiry.