Oracle Database (Version 19c) Administration Essentials

Oracle Database (Version 19c) Administration Course

  • Start Date : 24/09/2022
  • Duration : 40 Hours
  • No. of Classes/ Sessions : 20
  • Registration Deadline : 23/09/2022
  • Batch No : 1
  • Class Schedule :
  • Fri (06:00 PM-08:00 PM)
  • Sat (06:00 PM-08:00 PM)
Oracle Database (Version 19c) Administration Essentials

Introduction

Oracle Database is the most popular Relational Database Management System (RDBMS) developed by Oracle Corporation, holding the Number one ranking among the RDBMS based on the revenue share. It supports OLTP, OLAP, and mixed database workloads and is available for on-premise, on-cloud, or hybrid cloud installation. Oracle provides industry-leading high availability solutions, replication solutions, and backup managers. The performance of a well-tuned Oracle database is the finest, even with large databases.

As Oracle leads the international RDBMS market, there are immense local and global employment opportunities. This course will equip you with the exact skills required to work as an Oracle Database administrator (DBA). After completing this course, you will create and administer Oracle Database, including backup, restore, recovery, flashback, performance tuning, and many more techniques. This course will ensure that the candidates have all the technical skills needed to represent a company’s vision and move it forward.

  1. This Course includes hands-on DBA skills like Database Performance Tuning, SQL Tuning, Database Patching and Upgradation, Database Health-checkup and House-Keeping, Database Security Management. Available DBA training in Bangladesh doesn’t cover these topics. These are advanced DBA skills to have which will boost a trainees’ career in the industry.
  2. All topics are a combination of theory, hands-on, and real-life industry experience.
  3. Trainees will be ready for OCA (1Z0-082) an OCP (1Z0-083) Certification
  4. This training is based on Oracle Database Version 19c, which is the latest stable oracle release. Training for the same version (19c) is not available in Bangladesh. Training centres offer training up to version 12c
  5. Hand-on practical on Multitenant Architecture
Prerequisites :

Basic understanding of Linux is preferable but not mandatory.

Training Modules :
  1. Introduction to SQL
  2. Querying Data
  3. Sorting Data
  4. Filtering Data
  5. Conditional Expressions
  6. SET Operators
  1. Joining Multiple Tables
  2. Subquery
  3. Grouping Data
  4. Aggregate Functions
  5. Working with table structures
  6. Constraints
  7. Modifying data
  1. Database Memory Architecture
  2. Overview of System Global Area (SGA)
  3. Detail of Database Buffer Cache and REDO Log Buffer
  4. Detail of Shared Pool, Large Pool, Java Pool, and Streams pool
  5. Overview of Program Global Area (PGA)
  6. Database Process Architecture
  7. Detail of Database Writer, Log writer, and Archiver Process
  8. Detail of System Monitor, Process Monitor, and Recovered Process
  1. Overview of Network Architecture
  2. Configuring Listener
  3. Configuring TNS
  4. Creating Database Links
  5. Overview of Multitenant Architecture
  6. Overview of Container Database (CDB)
  7. Overview of Pluggable Database (PDB)
  8. Comparison of Legacy and Multitenant Architecture
  9. Advantages of Multitenant Architecture
  1. Creating and Configuring Non-CDB Database
  2. Creating and Configuring Multitenant Container Database 
  3. Configuring Initialization Parameter Files
  4. Steps in Startup and Shutdown
  5. Data Dictionary Views
  1. Using SQL*Plus and RMAN
  2. Install and Configure Oracle SQL Developer, PL/SQL Developer and Toad
  3. Using SSH, MobaXterm
  4. Configuring Enterprise Manager Cloud Control 13c
  5. Using Enterprise Manager Cloud Control
  1. Physical and Logical Data Structure
  2. Managing Control Files
  3. Creating Redo Log Groups and Members
  4. Relocating and Renaming Redo Log Members
  5. Dropping Redo Log Groups and Members
  6. Forcing Log Switches
  7. Clearing a Redo Log File
  8. Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
  9. Specifying Archive Destinations
  10. Overview of Related Dictionary Views
  1. Tablespace Creation
  2. Adding and Dropping Datafiles to a Tablespace
  3. Renaming Tablespaces
  4. Dropping Tablespaces
  5. Managing the SYSTEM and SYSAUX Tablespace
  6. Managing UNDO Tablespace
  7. Creating a User
  8. Unlocking a User Account and Resetting the Password
  9. Managing Users in Multitenant Environment
  1. Configuring Authentication
  2. OS Authentication and OS Groups
  3. System and Object Privileges
  4. Revoking and Granting Privileges
  5. Using Roles
  6. Using Profiles
  7. Creating a Password Profile
  8. Assigning Quotas to Users
  9. Privilege Analysis
  10. Applying the Principle of Least Privilege
  1. Types of Activities to be Audited
  2. Mandatorily Audited Activities
  3. Understanding Auditing Implementation
  4. Administering the Roles Required for Auditing
  5. Enabling and configuring Standard Auditing
  6. Enabling and configuring Value-Based Auditing
  7. Enabling and configuring Fine-Grained Auditing
  8. Enabling and configuring Unified Auditing
  9. Archiving and Purging the Audit Trail
  1. Types of RMAN Backup
  2. Performing Database Backup with RMAN
  3. Performing Archive Log Backup with RMAN
  4. Configuring Auto backup
  5. Managing RMAN Backups
  1. Basic Concepts of RMAN Performance Tuning
  2. Using V$ Views to Diagnose RMAN Performance Problems
  3. Tuning RMAN Backup Performance
  4. Interpreting RMAN Message Output
  5. Using V$ Views for RMAN Troubleshooting
  6. Terminating an RMAN Command
  1. Recovering After the Loss of Control Files
  2. Recovering After the Loss of Online Redo Log Files
  3. Recovering After the Loss of Data Files in NOARCHIVELOG Mode 15-11
  4. Recovering After the Loss of Non-Critical Data Files in ARCHIVELOG Mode
  5. Recovering After the Loss of System-Critical Data Files in ARCHIVELOG Mode
  1. Flashback Database, Restore Points, and Guaranteed Restore Points
  2. Prerequisites for Flashback Database and Restore Points
  3. Using Normal and Guaranteed Restore Points
  4. Rewinding a Table with Flashback Table
  5. Rewinding a DROP TABLE Operation with Flashback Drop
  6. Rewinding a Database with Flashback Database
  1. Generating Automatic Workload Repository (AWR) Report and Analysis
  2. Generating Automatic Database Diagnostic Monitor (ADDM) Report and Analysis
  3. Performance Tuning Methodologies
  4. Performance Monitoring: Top Sessions
  5. Performance Monitoring: Top Services
  6. Performance Monitoring: Wait for Events
  7. Tuning Memory
  8. Tuning Instance
  1. Database Health Checkup
  2. Database Housekeeping
  3. Using My Oracle Support
  4. Alert Log File Analysis
  5. Gathering Statistics
  6. Configuring Automated Maintenance Tasks
  1. Optimizer Statistics Collection
  2. Overview and usage of SQL Plan
  3. Using the SQL Tuning Advisor
  4. Using the SQL Access Advisor
  5. Tuning RMAN performance
  1. Configuring Opatch
  2. Getting Patches from MOS
  3. Conventional Patching
  4. Online Patching
  5. Applying for a Patch Release
  1. Database Up-gradation Path
  2. Performing Database Up-gradation

Review

No Reviews yet
PRICE : TK. 25000
Contact info

+88 01714 121719

+88 02 41010090

[email protected]