Description
This database training will allow you to learn how to effectively configure and administer an Oracle database instance
Who is this training for ?
For whom ?
This training is aimed at database administrators (DBA)
Prerequisites
Have completed the IBD051- “SQL Programming – Fundamentals” course or have equivalent skills
Training objectives
Training program
- Explore Oracle Database Architecture
- Oracle Database overview
- Relational database models
- Oracle SQL and PL/SQL
- Server architecture Oracle Database Tools
- Connecting to Oracle Databases
- Oracle Database Tools
- User Accounts Provided by Oracle
- Querying the Oracle Data Dictionary
- Manage database instances
- Initialization parameter files
- Starting Oracle databases
- Stopping Oracle databases
- Opening and closing databases
- Using the Automatic Diagnostic Repository (ADR)
- Querying Dynamic Performance Views
- Create pluggable databases
- Methods and tools for creating pluggable databases
- Creating pluggable databases from an original database with SQL*Plus
- Cloning pluggable databases with SQL*Plus
- Disconnecting and connecting pluggable databases with SQL*Plus
- Deleting pluggable databases with SQL*Plus
- Configure the Oracle network environment
- Oracle Net Services
- How listeners work
- Configuring listeners for dynamic service registration
- Configuration listeners for static service registration
- Configuring local name resolution for connections
- Testing Oracle Net connection with tnsping
- Configuring inter-database communication
- Dedicated/shared server configurations
- Administer user security
- Creating users
- Granting privileges
- Creating and assigning roles
- Revoking privileges and roles
- Creating and assigning profiles
- User authentication
- Assigning quotas to users
- Applying the principle of least privilege
- Create and manage tablespaces
- Storing table data
- Creating tablespaces in SQL*Plus
- Modifying and deleting tablespaces in SQL*Plus
- Displaying tablespace information in SQL*Plus
- Implementing Oracle Managed Files
- Moving and renaming inline data files in SQL*Plus
- Manage storage space
- Oracle Database Space Management Features
- Block Space Management
- Chaining and Row Migration
- Managing free space in segments
- Segment types
- Extent allocation
- Overview of deferred segment creation
- Space-saving features
- Manage cancellation data
- Presentation of cancellation data
- Transactions and cancellation data
- Storage of cancellation information
- Comparison of cancellation data undo and logging data
- Managing undo information
- Local undo mode and shared undo mode
- Configuring information retention cancellation
- Cancellation information categories
- Move data
- Data Movement: General Architecture
- Oracle Data Pump Overview
- Oracle Data Pump: Benefits
- Export and Data Clients 'import Data Pump
- Data Pump utility: Interfaces and modes
- Import Data Pump: Transformations
- SQL*Loader overview
- Methods loading
- Backup and Recovery Concepts
- DBA Responsibilities
- Failure Categories
- Instance Recovery Overview
- Backup Types Overview
- Comparison between full and incomplete recovery
- Oracle Data Protection Solutions
- Flashback Technology
- Monitor and tune database performance
- Managing Performance Activities
- Performance Planning Considerations
- Database Maintenance
- AWR Repository
- Automatic Database Diagnostic Monitor
- Performance Monitoring
- Performance Tuning Methodology
- Database Server Statistics and Metrics
- SQL Settings
- SQL Tuning Process
- Oracle Optimizer
- Optimizer Statistics
- SQL Plans Guidelines
- Plans adaptive execution tools
- SQL Tuning Advisor
- SQL Access Advisor
- SQL Performance Analyzer
- Oracle Database Resource Manager
- Oracle Database Resource Manager Overview
- Resource Manager Elements
- Using the Resource Manager to Allocate Resources
- Creating 'a simple resource plan
- Creating a complex resource plan
- Using the Active Session Pool feature
- Limiting the use of the 'CPU at the database level
- Limiting CPU usage at the server level
- Enterprise Manager Cloud Control
- Controlling the Enterprise Manager Cloud Control framework
- Starting the Enterprise Manager Cloud Control framework
- Stopping the Enterprise Manager Cloud Control framework
- Oracle Database Cloud Service Overview
- Oracle Cloud Overview
- Database Cloud Service Offerings
- DBCS Architecture
- Features and Tools
- Options additional database configuration
- Creating DBCS database deployments
- Providing automated database setup information
- Creating a database deployment
- Using SSH key pairs
- Creating an SSH key pair
- Storage used for database files
- Managing DBCS database deployments
- Cloud Tools
- Access to DBCS console tools and features
- Management of the compute node associated with a database deployment
- Managing network access to DBCS
- Enabling access to a compute node port
- Scaling a database deployment
- Backing up and restoring DBCS database deployments
- Backup and recovery of DBCS databases
- Choice of backup destination
- Backup configuration
- Creating a backup at the request
- Customizing the backup configuration
- Performing a recovery using the console
- Performing a recovery using the dbaascli utility
- Applying patches to DBCS database deployments
- Applying patches to DBCS
- Using the DBCS console to manage patches
- Using the dbaascli utility to manage patches
- Creating master encryption keys for pluggable databases
- CDB and PDB master encryption keys
- Determining the need to create and activate an encryption key for a pluggable database
- Creation and activation an encryption key
- Default tablespace encryption
- Default tablespace encryption in DBCS
- Transparent data encryption overview
- Components of transparent data encryption
- Using transparent encryption data
- Setting the keystore location
- Controlling the default tablespace encryption
- Managing the software keystore and key master encryption
- Key file management in container databases and pluggable databases
