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.
Unlimited Duration
March 4, 2021
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
- 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
- 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 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
- Undo Data 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
- 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
- SQL Tuning Process 00:00:00
- Oracle Optimizer 00:00:00
- Optimizer Statistics 00:00:00
- SQL Plan 00:00:00
Course Reviews

Students