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 Oracle database server architecture
- Overview of Oracle multitenant container database
- Oracle database instance and database sharding
Accessing Oracle Database
- Establishing connections to an Oracle database instance
- Utilizing Oracle database tools
- SQL*Plus
- Utilizing Oracle SQL developer
- Employing Database Configuration Assistant (DBCA)
- Exploring the Enterprise Manager cloud control 13c features
- Overview of Oracle Enterprise Manager components
- Unified enterprise management interface
- Administering the Oracle Enterprise Manager database
Creating an Oracle Database
- Setting up an Oracle database via DBCA
- Setting up an Oracle database using SQL commands
Working with Database Instances
- Initiating the Oracle database instance
- Terminating an Oracle database instance
- Comparing different shutdown modes
- Opening and closing PDBs
- Configuring PDBs
Managing Database Instances
- Utilizing initialization parameters
- Working with the automatic diagnostic repository
- Reviewing the alert log
- Utilizing trace files
- Administering the DDL log file
- Interacting with dynamic performance views
- Leveraging the data dictionary
Overview of Oracle Net Services
- Defining Oracle Net Services components
- Configuring and managing Oracle Net Services
- Introduction to the Oracle Net listener
- Comparing dedicated and shared server architectures
Naming Methods
- Establishing Oracle network connections
- Understanding various naming methods
- Easy connect
- Local and directory-based naming
- Workload management through database services
- Creating database services
Working with the Listener
- Using the default listener
- Configuring dynamic service registration
- Configuring static service registration
Configuring a Shared Server Architecture
- Enabling shared server mode
- Controlling shared server operations
- Managing SGA and PGA memory
- Considerations for shared server configuration
Configuring Oracle Connect Manager
- Understanding Oracle Connection Manager
- Applying filtering rules
- Implementing intranet and internet access controls
- Utilizing session multiplexing
- Configuring 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
- Using the FILE_NAME_CONVERT clause
- Utilizing OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative techniques for creating PDBs
Managing PDBs
- Switching PDB modes
- Modifying PDB configurations
- Updating initialization parameters
- Using the Alter System Command within a PDB
- Setting hostname and port number per PDB
- Dropping PDBs
Understanding Database Storage
- Database storage architecture
- Database structures
- Utilizing segments, extents, and blocks
- Managing tablespaces and data files
- Understanding segment types
- Storing table data
- Database block content analysis
- Managing deferred segment creation
- Monitoring tablespace space usage
Managing Tablespaces
- Creating new tablespaces
- Defining default permanent tablespaces
- Working with temporary tablespaces
- Altering and dropping tablespaces
- Implementing Oracle Managed Files (OMF)
- Moving or renaming online data files
Improving Usage Space
- Understanding space management capabilities
- Managing block space efficiency
- Specifying table compression
Managing Undo Data
- Managing transactions and undo data
- Storing undo information
- Configuring undo retention settings
- Enabling temporary undo
Creating and Managing User Accounts
- Oracle-provided administrator accounts
- User authentication processes
- Assigning resource quotas
Configuring Privilege and Role Authorization
- Understanding system privileges
- Configuring system privileges
- Administering privileges
Configuring User Resource Limits
- Managing profiles and user accounts
- Understanding profile parameters
Oracle Database Auditing
- Understanding database security frameworks
- Auditing implementation strategies
- FGA policy configuration
Loading and Transporting Data
- Data migration techniques
- Methods for loading data
- Exporting and importing data
- Transporting a database
Database Monitoring
- Performance management activities
- Database maintenance tasks
- Understanding performance tuning methods
Database Processes
- Process architecture and structure
- Utilizing various writer and monitor processes
Managing Memory
- Managing memory components
- Automatic memory management
Analyzing SQL
- Leveraging the Oracle optimizer
- Optimizing access paths
- SQL plan directives
Requirements
- Fundamental knowledge of SQL
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
