• No products in the cart.

ratings 

Oracle 19C Database Administration is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models.

PRIVATE
Course Access

Unlimited Duration

Last Updated

March 4, 2021

Students Enrolled

Total Reviews

Posted by
Certification

This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.In this course you learn about:

· Describe Oracle Database architecture

· Describe Oracle Database Cloud Service (DBCS) architecture and features

· Create and manage DBCS database deployments

· Configure the database to support your applications

· Manage database security and implement auditing

· Implement basic backup and recovery procedures

· Move data between databases and files

· Employ basic monitoring procedures and manage performance

Course Curriculum

    • Oracle Database Server Architecture 00:00:00
    • Oracle Database Instance Configurations 00:00:00
    • Connecting to the Database Instance 00:00:00
    • Oracle Database Memory Structures 00:00:00
    • Automated Database Provisioning 00:00:00
    • Creating a Database Deployment 00:00:00
    • Connecting to an Oracle Database Instance 00:00:00
    • Oracle Database Tools 00:00:00
    • SQL*Plus 00:00:00
    • Oracle SQL Developer 00:00:00
    • SQL Developer Command Line (SQLcl) 00:00:00
    • Database Configuration Assistant (DBCA) 00:00:00
    • Oracle Enterprise Manager Database Express 00:00:00
    • Enterprise Manager Cloud Control 13c Features 00:00:00
    • Managing the Compute Node 00:00:00
    • Scaling a Database Deployment 00:00:00
    • Patching DBCS 00:00:00
    • Working with Initialization Parameters 00:00:00
    • Starting the Oracle Database Instance 00:00:00
    • Shutting Down an Oracle Database Instance 00:00:00
    • Opening and Closing PDBs 00:00:00
    • Alert Log 00:00:00
    • Trace Files 00:00:00
    • DDL Log File 00:00:00
    • Oracle Net Services 00:00:00
    • Oracle Net Listener 00:00:00
    • The Default Listener 00:00:00
    • Establishing Oracle Network Connections 00:00:00
    • Connecting to an Oracle Database 00:00:00
    • Database User Accounts 00:00:00
    • Oracle-Supplied Administrator Accounts 00:00:00
    • Creating Oracle Database Users in a Multitenant Environment -9 00:00:00
    • Schema-Only Account 00:00:00
    • Authenticating Users 00:00:00
    • System Privileges for Administrators 00:00:00
    • Object Privileges 00:00:00
    • Granting Privileges in a Multitenant Environment 00:00:00
    • Granting and Revoking System Privileges 00:00:00
    • Granting and Revoking Object Privileges 00:00:00
    • Creating a New PDB from PDB$SEED 00:00:00
    • Cloning PDBs 00:00:00
    • Unplugging and Plugging in PDBs 00:00:00
    • Plugging an Unplugged Regular PDB into a CDB 00:00:00
    • Creating Tablespaces 00:00:00
    • Creating Permanent Tablespaces in a CDB 00:00:00
    • Altering and Dropping Tablespaces 00:00:00
    • Viewing Tablespace Information 00:00:00
    • Tablespace Encryption by Default in DBCS 00:00:00
    • Space Management Features 00:00:00
    • Block Space Management 00:00:00
    • Row Chaining and Migration 00:00:00
    • Types of Segments 00:00:00
    • Allocating Extents 00:00:00
    • Undo Data 00:00:00
    • Oracle Data Pump 00:00:00
    • SQL Loader 00:00:00
    • Types of Failures 00:00:00
    • Instance Recovery 00:00:00
    • The Checkpoint (CKPT) Process 00:00:00
    • Redo Log Files and the Log Writer (LGWR) 00:00:00
    • Automatic Instance Recovery or Crash Recovery 00:00:00
    • Using the MTTR Advisor 00:00:00
    • Complete Recovery Process 00:00:00
    • The Point-in-Time Recovery Process 00:00:00
    • Flashback 00:00:00
    • Configuring for Recoverability 00:00:00
    • Redo Log Files 00:00:00
    • Creating Database Backups 00:00:00
    • RMAN Backup 00:00:00
    • Backing Up Databases on DBCS 00:00:00
    • Data Recovery Advisor 00:00:00
    • Loss of a Redo Log File 00:00:00
    • DBCS: Performing Recovery by Using the Console 00:00:00
    • dbaascli Utility 00:00:00
    • Automatic Workload Repository (AWR) 00:00:00
    • Automatic Database Diagnostic Monitor (ADDM) 00:00:00
    • Advisory Framework 00:00:00
    • SQL Tuning Process 00:00:00
    • Oracle Optimizer 00:00:00
    • Optimizer Statistics 00:00:00
    • SQL Plan 00:00:00

Course Reviews

Profile Photo
ashar hafeez
0
61

Students

About Instructor

Pak

Course Events

[wplms_eventon_events]

More Courses by Insturctor

© 2021 Ernesto.  All rights reserved.  
X