Oracle Database 18c: Administration Workshop

loading..
(Course eligible for SATVs)

loading..

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. 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. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

 

  • Oracle Database Editions, Options, and Management Packs
  • Oracle Cloud Overview
  • Sample HR Schema
  • Oracle Database Server Architecture
  • Oracle Database Instance Configurations
  • Connecting to the Database Instance
  • Oracle Database Memory and Process Structures
  • Logical and Physical Database Structures
  • Multitenant Architecture
  • Automatic Storage Management (ASM) Overview
  • Oracle Database Cloud Service Architecture
  • Features and Tooling
  • Automated Database Provisioning
  • Input to the Creation Wizard
  • SSH Key Pairs
  • Database File Storage
  • SQL*Plus
  • SQL Developer
  • Database Configuration Assistant (DBCA)
  • Oracle enterprise Manager Database Express
  • Oracle Enterprise Manager Cloud Control
  • Oracle Database Cloud Service Tools
  • Managing the Compute Node
  • Managing Network Access to DBCS
  • Scaling a Database Deployment
  • Patching a Database Deployment
  • Initialization Parameter Files
  • Starting Up Oracle Database Instances
  • Shutting Down Oracle Database Instances
  • Automatic Diagnostic Repository (ADR)
  • Alert Log and Trace Files
  • Dynamic Performance Views
  • Data Dictionary Views
  • Oracle Net Listener Overview
  • Connecting to an Oracle Database Instance
  • Naming Methods
  • Oracle Net Services Administration Tools
  • Configuring Communication Between Database Instances
  • Comparing Dedicated and Shared Server Configurations
  • Managing Oracle Cloud Users, Privileges, and Roles
  • Managing Oracle Database Users, Privileges, and Roles
  • User Authentication
  • Creating and Assigning Profiles
  • Assigning Quotas to Users
  • Applying the Principal of Least Privilege
  • Methods and Tools to Create PDBs
  • Creating PDBs from Seed
  • Cloning PDBs
  • Unplugging and Plugging in PDBs
  • Dropping PDBs
  • Encryption in Oracle Database Cloud Service
  • Overview of Transparent Data Encryption (TDE)
  • CDB and PDB Master Encryption Keys
  • Creating and Activating an Encryption Key
  • Table Data Storage
  • Creating, Altering and Dropping Tablespaces
  • Viewing Tablespace Information
  • Implementing Oracle Managed Files
  • Moving and Renaming Online Data Files
  • Tablespace Encryption by Default in DBCS
  • Oracle Database Space Management Features
  • Block Space Management
  • Types of Segments
  • Deferred Segment Creation
  • Space-Saving Features
  • Table and Row Compression
  • Shrinkable Segments
  • Resumable Space Allocation
  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data
  • Comparing Local Undo Mode and Shared Undo Mode
  • Configuring Undo Rentention
  • Temporary Undo
  • Oracle Data Pump
  • SQL*Loader
  • External Tables
  • Migrating to Oracle Database Cloud Service
  • Categories of Failure
  • Instance Recovery
  • Complete Recovery
  • Point-in-time Recovery
  • Flashback Technology
  • Configuring and Monitoring the Fast Recovery Area
  • Multiplexing Control Files
  • Multiplexing Redo Log Files
  • Archive Redo Log Files
  • Configuring ARCHIVELOG Mode
  • Backup Terminology
  • Using Recovery Manager (RMAN)
  • RMAN Backup Types
  • Automatic Backups on Database Cloud Service (DBCS)
  • On-Demand Backups on DBCS
  • Database Recovery Advisor
  • Recovering Data Files in NOARCHELOG Mode
  • Recovering Data Files in ARCHIVELOG Mode
  • Recovery Options in Database Cloud Service (DBCS)
  • Performance Planning Considerations
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework
  • Managing Metric Thresholds and Alerts
  • Monitoring Wait Events, Sessions, and Services
  • Performance Tuning Methodology
  • Managing Memory Components
  • SQL Tuning Process
  • Oracle Optimizer
  • Optimizer Statistics
  • SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Performance Analyzer
  • Data Warehouse Administrator
  • Database Administrators
  • Database Designers
  • Support Engineer
  • Technical Administrator
  • A working knowledge of SQL and PL/SQL packages is very helpful in the course.
  • Basic knowledge of Linux operating system

Key Participants Benefit

You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. 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. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

  • Describe Oracle Database architecture
  • Explain 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

Register

Traditional Classroom   

    Show all

    Traditional Classroom   

      Show all

      Traditional Classroom   

        Show all

        Traditional Classroom   

          Show all

          OnlineLive   

            Show all

            Connected Classroom   

              Show all

              Connected Classroom   

                Show all

                Connected Classroom   

                  Show all

                  Connected Classroom   

                    Show all

                    Flexible Mentored Learning   

                      Show all

                      Flexible Mentored Learning   

                        Show all

                        Flexible Mentored Learning   

                          Show all

                          Flexible Mentored Learning   

                            Show all

                            Not currently scheduled

                            Fast track the availability of this course.
                            Add to watch list or call 1300 794 006.

                            Need your team upskilled?
                            Request a Quote

                            blah is false
                            top