Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 35 hours
Course Outline
Introduction
- Overview of the Oracle database server architecture
- Introduction to Oracle multitenant container database
- Oracle database instance and database sharding concepts
Accessing Oracle Database
- Establishing connections to an Oracle database instance
- Utilizing Oracle database tools
- Working with SQL*Plus
- Using Oracle SQL developer
- Leveraging the Database Configuration Assistant (DBCA)
- Reviewing Enterprise Manager cloud control 13c features
- Overview of Oracle Enterprise Manager components
- Implementing a single pane of glass for enterprise management
- Administering the Oracle Enterprise Manager database
Creating an Oracle Database
- Setting up an Oracle database with DBCA
- Creating an Oracle database via SQL commands
Managing Database Instances
- Initiating the Oracle database instance
- Shutting down an Oracle database instance
- Distinguishing between different shutdown modes
- Opening and closing PDBs
- Configuring PDBs
Administering Database Instances
- Utilizing initialization parameters
- Working with the automatic diagnostic repository
- Reviewing the alert log
- Using trace files
- Administering the DDL log file
- Interacting with dynamic performance views
- Utilizing the data dictionary
Oracle Net Services Overview
- Identifying components of Oracle net services
- Configuring and managing Oracle net services
- Introduction to the Oracle net listener
- Comparing dedicated and shared server architectures
Naming Methods
- Establishing Oracle network connections
- Comprehending naming methods
- Easy connect
- Local and directory naming strategies
- Managing workloads via database services
- Creating database services
Working with the Listener
- Utilizing the default listener
- Configuring dynamic service registration
- Configuring static service registration
Setting Up a Shared Server Architecture
- Enabling the shared server
- Controlling shared server operations
- Utilizing SGA and PGA
- Considerations for shared server configuration
Configuring Oracle Connect Manager
- Understanding Oracle Connection Manager
- Applying filtering rules
- Implementing access control for intranet and internet
- Leveraging session multiplexing
- Configuring the Oracle Connection Manager
- Configuring the cman.ora file
- Configuring client settings
- Configuring the database server
- Using the Oracle Connection Manager control utility
Creating PDBs
- Provisioning new pluggable databases
- Creating a new PDB from PDB$SEED
- Utilizing the FILE_NAME_CONVERT clause
- Using OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative techniques for PDB creation
Managing PDBs
- Changing the PDB mode
- Modifying PDB settings
- Adjusting initialization parameters
- Executing the Alter System Command within a PDB
- Configuring hostname and port number for each PDB
- Dropping PDBs
Understanding Database Storage
- Database storage architecture
- Database structures
- Utilizing segments, extents, and blocks
- Working with tablespaces and data files
- Differentiating segment types
- Storing table data
- Database block content
- Managing deferred segment creation
- Monitoring tablespace usage
Tablespace Management
- Creating tablespaces
- Defining default permanent tablespaces
- Working with temporary tablespaces
- Altering and dropping tablespaces
- Implementing Oracle Managed File (OMF)
- Moving or renaming online data files
Optimizing Space Usage
- Understanding space management features
- Managing block space
- Specifying table compression
Undo Data Management
- Managing transactions and undo data
- Storing undo information
- Configuring undo retention
- Enabling temporary undo
User Account Creation and Management
- Oracle-provided administrator accounts
- User authentication processes
- Assigning resource quotas
Privilege and Role Authorization
- Understanding system privileges
- Configuring system privileges
- Privilege management
User Resource Limit Configuration
- Managing profiles and users
- Understanding profile parameters
Oracle Database Auditing
- Understanding database security
- Implementing auditing
- FGA policy
Data Loading and Transportation
- Data movement strategies
- Data loading methods
- Exporting and importing data
- Transporting a database
Database Monitoring
- Performance management activities
- Database maintenance
- Understanding performance tuning methods
Database Processes
- Process architecture and structure
- Utilizing various writer and monitor processes
Memory Management
- Managing memory components
- Automatic memory management
SQL Analysis
- Using the Oracle optimizer
- Optimizing access paths
- SQL plan directives
Requirements
- Fundamental knowledge of SQL
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (4)
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
Everything in the world of ORACLE
Geiner Gomez Gomez - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
The cheat sheets
Aaron Fernandez Rodriguez - OSFEM
Course - Oracle Database 19c: Administration
Machine Translated
Generating reports with the graphical interface.
Harold Romero Romero - OSFEM
Course - Oracle Database 19c: Administration
Machine Translated
