Oracle Database 12c : Administration Workshop
Duration : 5 Days (40 Hours)
Oracle Database 12c : Administration Workshop Course Overview:
The Oracle Database 12c: Administration Workshop Certification signifies expertise in handling the advanced Oracle Database 12c technology, enabling efficient management of cloud or database infrastructure. This certification equips administrators with knowledge of database architecture, instance management, security, backup recovery, and failure management, making them invaluable for industries seeking professionals to optimize data retrieval, enhance processes, and ensure top-notch data security.
Intended Audience:
• Database administrators
• IT professionals dealing with database management
• Technology consultants handling database solutions
• Database designers and architects
• Data analysts and data science professionals
• Software engineers and programmers who work with Oracle databases
Learning Objectives of Oracle Database 12c : Administration Workshop:
The primary learning objective of the Oracle Database 12c: Administration Workshop Course is to provide participants with detailed knowledge and skills to effectively manage an Oracle database. They will learn about the multi-tenant architecture of 12c, managing container and pluggable databases, and Oracle’s database cloud service. Participants will develop skills in storage management, monitoring and tuning performance, security management, and database resource management. By the end of the course, participants should have an improved understanding of database maintenance, backup and recovery, and data movement for different scenarios.
Module 1: Getting Started
- Course Objectives
Module 2: Exploring Oracle Database Architecture
- Introducing Oracle Database
- Relation Database Models
- Oracle SQL and PL/SQL
- Oracle Database Server Architecture
- Connecting to Oracle Databases
- Oracle Database Tools
- Oracle-Supplied User Accounts
- Querying the Oracle Data Dictionary
Module 3: Managing Database Instances
- Initialization Parameter Files
- Starting Up Oracle Databases
- Shutting Down Oracle Databases
- Opening and Closing PDBs
- Working with the Automatic Diagnostic Repository (ADR)
- Querying Dynamic Performance Views
Module 4: Creating PDBs
- Methods and Tools to Create PDBs
- Creating PDBs from Seed with SQL*Plus
- Cloning PDBs with SQL*Plus
- Unplugging and Pluggin In PDBs with SQL*Plus
- Dropping PDBs with SQL*Plus
Module 5: Configuring the Oracle Network Environment
- Oracle Net Services
- How Listeners Work
- Configuring Listeners for Dynamic Service Registration
- Configuring Listeners for Static Service Registration
- Configuring Local Naming for Connections
- Testing Oracle Net Connectivity with tnsping
- Configuring Communidation Between Databases
- Dedicated Versus Shared Server Configurations
Module 6: Administering User Security
- Creating Users
- Granting Privileges
- Creating and Granting Roles
- Revoking Privileges and Roles
- Creating and Assigning Profiles
- Authenticating Users
- Assigning Quotas to Users
- Applying the Principal of Least Privilege
Module 7: Creating and Managing Tablespaces
- How Table Data is Stored
- Creating Tablespaces in SQL*Plus
- Altering and Dropping Tablespaces in SQL*Plus
- Viewing Tablespace Information in SQL*Plus
- Implementing Oracle Managed Files
- Moving and Renaming Online Data Files in SQL*Plus
Module 8: Managing Storage Space
- Oracle Database Space Management Features
- Block Space Management
- Row Chaining and Migration
- Free Space Management Within Segments
- Types of Segments
- Allocating Extents
- Understanding Deferred Segment Creation
- Space-Saving Features
Module 9: Managing UNDO Data
- Undo Data: Overview
- Transactions and Undo Data
- Storing Undo Information
- Comparing Undo Data and Redo Data
- Managing Undo
- Local Undo Mode Versus Shared Undo Mode
- Configuring Undo Retension
- Categories of Undo
Module 10: Moving Data
- Moving Data: General Architecture
- Oracle Data Pump: Overview
- Oracle Data Pump: Benefits
- Data Pump Export and Import Clients
- Data Pump Utility: Interfaces and Modes
- Data Pump Import: Transformations
- SQL*Loader Overview
- Loading Methods
Module 11: Backup and Recovery Concepts
- DBA Responsibilities
- Categories of Failure
- Understanding Instance Recovery
- Understanding Types of Backups
- Comparing Complete and Incomplete Recovery
- Oracle Data Protection Solutions
- Flashback Technology
Module 12: Monitoring and Tuning Database Performance
- Managing Performance Activities
- Performance Planning Considerations
- Database Maintenance
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor
- Performance Monitoring
- Performance Tuning Methodology
- Database Server Statistics and Metrics
Module 13: SQL Tuning
- SQL Tuning Process
- Oracle Optimizer
- Optimizer Statistics
- SQL Plan Directives
- Adaptive Execution Plans
- SQL Tuning Advisor
- SQL Access Advisor
- SQL Performance Analyzer
Module 14: Oracle Database Resource Manager
- Oracle Database Resource Manager: Overview
- Resource Manager Elements
- Using Resource Manager to Allocate Resources
- Creating a Simple Resource Plan
- Creating a Complex Resource Plan
- Using the Active Session Pool Feature
- Limiting CPU Utilization at the Database Level
- Limiting CPU Utilization at the Server Level
Module 15: 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
Module 16: Introduction to Oracle Database Cloud Service
- Oracle Cloud: Overview
- Database Cloud Service Offerings
- DBCS Architecture
- Features and Tooling
- Additional Database Configuration Options
Module 17: Creating DBCS Database Deployments
- Automated Database Provisioning
- Creating a Database Deployment
- How SSH Key Pairs are Used
- Creating an SSH Key Pair
- Storage Used for Database Files
Module 18: Managing DBCS Database Deployments
- Cloud Tooling
- Accessing Tools and Features from the DBCS Console
- Managing the Compute Node Associated With a Database Deployment
- Managing Network Access to DBCS
- Enabling Access to a Compute Node Port
- Scaling a Database Deployment
Module 19: Backing Up and Restoring DBCS Database Deployments
- Backing Up and Recovering Databases on DBCS
- Backup Destination Choices
- Backup Configuration
- Creating an On-Demand Backup
- Customizing the Backup Configuration
- Performing Recovery by Using the Console
- Performing Recovery by Using the dbaascli Utility
Module 20: Patching DBCS Database Deployments
- Patching DBCS
- Using the DBCS Console to Manage Patches
- Using the dbaascli Utility to Manage Patches
Module 21: Creating Master Encryption Keys for PDBs
- CDB and PDB Master Encryption Keys
- Determining Whether You Need to Create and Activate and Encryption Key for a PDB
- Creating and Activating an Encryption Key
Module 22: Tablespace Encryption by Default
- Tablespace Encryption by Default in DBCS
- Transparent Data Encryption (TDE) Overview
- Components of TDE
- Using TDE
- Defining the Keystore Location
- Controlling Tablespace Encryption by Default
- Managing the Software Keystore and Master Encryption Key
- Managing the Keystore in CDBs and PDBs
Oracle Database 12c : Administration Workshop Course Prerequisites:
• Basic knowledge of database concepts and SQL language
• Familiarity with Oracle Database technologies
• Understanding of cloud computing concepts
• Knowledge of Linux operating system basics
• Prior experience in Oracle Database setup or administration.
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!