Oracle 18c DBA Fundamentals in Warwick

Oracle 18c DBA Fundamentals​ Course Outline

Module 1: Getting Started with Database Administration

• Types of Oracle Database Users
• Tasks of a Database Administrator
• SQL Statements
• Identifying Your Oracle Database Software Release
• About Database Administrator Security and Privileges
• Database Administrator Authentication
• Creating and Maintaining a Database Password File
• Data Utilities

Module 2: Creating and Configuring an Oracle Database

• About Creating an Oracle Database
• Considerations Before Creating the Database
• Creating a Database with DBCA
• Creating a Database with the CREATE DATABASE Statement
• Specifying CREATE DATABASE Statement Clauses
• Specifying Initialisation Parameters
• Managing Initialisation Parameters Using a Server Parameter File
• Managing Application Workloads with Database Services
• Considerations After Creating a Database
• Cloning a Database
• Dropping a Database
• Database Data Dictionary Views
• Database Configuration Assistant Command Reference for Silent Mode

Module 3: Starting Up and Shutting Down

• Starting Up a Database
• Altering Database Availability
• Shutting Down a Database
• Quiescing a Database
• Suspending and Resuming a Database
• Delaying Instance Abort

Module 4: Managing Processes and Memory

• About
  • Dedicated and Shared Server Processes
  • Database and Proxy Resident Connection Pooling
• Configuring
  • Oracle Database for Shared Server
  • Database Resident Connection Pooling
• Managing
  • Prespawned Processes
  • Processes for Parallel SQL Execution
  • Processes for External Procedures
  • Terminating Sessions
• Process and Session Data Dictionary Views
• What is Memory Management and its Architecture?
• Using Automatic Memory Management
• Configuring
  • Memory Manually
  • Database Smart Flash Cache
• Improving Query Performance
  • Memoptimised Rowstore
  • Oracle Database In-Memory

Module 5: Managing Users and Securing the Database

• Importance of Establishing a Security Policy for Your Database
• Managing Users and Resources
• User Privileges and Roles
• Auditing Database Activity
• Predefined User Accounts

Module 6: Monitoring the Database and Managing Diagnostic Data

• Monitoring
  • Errors and Alerts
  • Performance
  • Quarantined Objects
• Oracle Database Fault Diagnosability Infrastructure
• Investigating, Reporting, and Resolving a Problem
• Viewing Problems with the Support Workbench
• Adding Problems Manually to the Automatic Diagnostic Repository
• Viewing the Alert Log
• Finding Trace Files
• Running Health Checks with Health Monitor
• Repairing SQL Failures with the SQL Repair Advisor
• Repairing Data Corruptions with the Data Recovery Advisor
• Creating, Editing, and Uploading Custom Incident Packages

Module 7: Managing Control Files

• What Is a Control File?
• Guidelines for Control Files
• Creating Control Files
• Troubleshooting After Creating Control Files
• Backing Up Control Files
• Recovering a Control File Using a Current Copy
• Dropping Control Files
• Control Files Data Dictionary Views

Module 8: Managing the Redo Log

• What Is the Redo Log?
• Planning the Redo Log
• Creating Redo Log Groups and Members
• Relocating and Renaming Redo Log Members
• Dropping Redo Log Groups and Members
• Forcing Log Switches
• Verifying Blocks in Redo Log Files
• Clearing a Redo Log File
• Precedence of FORCE LOGGING Settings
• Redo Log Data Dictionary Views

Module 9: Managing Archived Redo Log Files

• What Is the Archived Redo Log?
• Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
• Controlling Archiving
• Specifying Archive Destinations
• About Log Transmission Modes
• Managing Archive Destination Failure
• Controlling Trace Output Generated by the Archivelog Process
• Viewing Information About the Archived Redo Log

Module 10: Managing Tablespaces

• Guidelines for Managing Tablespaces
• Creating Tablespaces
• Consider Storing Tablespaces in the In-Memory Column Store
• Specifying Nonstandard Block Sizes for Tablespaces
• Controlling the Writing of Redo Records
• Altering Tablespace Availability
• Using Read-Only Tablespaces
• Altering and Maintaining Tablespaces
• Renaming Tablespaces
• Dropping Tablespaces
• Managing Lost Write Protection with Shadow Tablespaces
• Managing the SYSAUX Tablespace
• Correcting Problems with Locally Managed Tablespaces
• Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
• Viewing Information About Tablespaces

Module 11: Managing Data Files and Temp Files

• Guidelines for Managing Data Files
• Creating Data Files and Adding Data Files to a Tablespace
• Changing Data File Size
• Altering Data File Availability
• Renaming and Relocating Data Files
• Dropping Data Files
• Verifying Data Blocks in Data Files
• Copying Files Using the Database Server
• Mapping Files to Physical Devices
• Data Files Data Dictionary Views

Module 12: Transporting Data and Managing Undo

• About Transporting Data
• Transporting Databases
• Transporting Tablespaces Between Databases
• Transporting Tables, Partitions, or Subpartitions Between Databases
• Converting Data Between Platforms
• Guidelines for Transferring Data Files
• What Is Undo?
• Introduction to Automatic Undo Management
• Managing Undo Tablespaces
• Migrating to Automatic Undo Management
• Managing Temporary Undo
• Undo Space Data Dictionary Views

Module 13: Using Oracle Managed Files

• About Oracle Managed Files
• Enabling the Creation and Use of Oracle Managed Files
• Creating Oracle Managed Files
• Operation of Oracle Managed Files
• Scenarios for Using Oracle Managed Files

Module 14: Managing Views, Sequences, and Synonyms

• Managing Views
• Managing Sequences
• Managing Synonyms
• Views, Synonyms, and Sequences Data Dictionary Views

Module 15: Managing Automated Database Maintenance Tasks

• About Automated Maintenance Tasks and Maintenance Windows
• Configuring
  • Automated Maintenance Tasks
  • Maintenance Windows
  • Resource Allocations for Automated Maintenance Tasks
• Automated Maintenance Tasks Reference

Module 16: Managing a Distributed Database

• Managing Global Names in a Distributed System
• Creating Database Links
• Using Shared Database Links
• Managing Database Links
• Viewing Information About Database Links
• Creating Location Transparency
• Managing Statement Transparency