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
- n'as pas encore du programme
- 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
- n'as pas encore du programme
- 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
