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
- High-level view of Oracle database server architecture
- Insight into Oracle multitenant container databases
- Oracle database instances and database sharding concepts
Accessing Oracle Database
- Establishing connections to Oracle database instances
- Leveraging Oracle database utilities
- Working with SQL*Plus
- Utilizing Oracle SQL developer
- Deploying the Database Configuration Assistant (DBCA)
- Exploring Enterprise Manager cloud control 13c capabilities
- Overview of Oracle Enterprise Manager components
- Single-pane-of-glass enterprise management approach
- Administration of the Oracle Enterprise Manager database
Creating an Oracle Database
- Provisioning an Oracle database via DBCA
- Generating an Oracle database using SQL commands
Working with Database Instances
- Initiating Oracle database instances
- Terminating Oracle database instances
- Evaluating different shutdown modes
- Managing the opening and closing of PDBs
- Configuration strategies for PDBs
Managing Database Instances
- Application of initialization parameters
- Utilizing the automatic diagnostic repository
- Reviewing alert logs
- Working with trace files
- Administration of DDL log files
- Interaction with dynamic performance views
- Navigating the data dictionary
Overview of Oracle Net Services
- Identifying Oracle net services components
- Configuration and management of Oracle net services
- Introduction to the Oracle net listener
- Distinguishing between dedicated and shared server architectures
Naming Methods
- Setting up Oracle network connections
- Interpreting various naming methods
- Utilizing Easy Connect
- Local and directory-based naming strategies
- Workload management through database services
- Creation of database services
Working with the Listener
- Deployment of the default listener
- Setup for dynamic service registration
- Setup for static service registration
Configuring a Shared Server Architecture
- Activation of shared servers
- Regulation of shared server operations
- Utilization of SGA and PGA
- Key considerations for shared server configuration
Configuring Oracle Connect Manager
- Comprehending Oracle Connection Manager
- Application of filtering rules
- Implementation of intranet and internet access controls
- Use of session multiplexing
- Configuration of Oracle Connection Manager
- Configuration of the cman.ora file
- Client configuration
- Database server configuration
- Operation of the Oracle Connection Manager control utility
Creating PDBs
- Provisioning new pluggable databases
- Creating new PDBs from PDB$SEED
- Application of the FILE_NAME_CONVERT clause
- Use of OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative techniques for PDB creation
Managing PDBs
- Modification of PDB modes
- Adjustment of PDB settings
- Updating initialization parameters
- Application of the Alter System Command within a PDB
- Configuration of hostname and port number for individual PDBs
- Removal of PDBs
Understanding Database Storage
- Database storage architecture design
- Core database structures
- Use of segments, extents, and blocks
- Management of tablespaces and data files
- Categorization of segment types
- Storage strategies for table data
- Content organization within database blocks
- Administration of deferred segment creation
- Monitoring tablespace utilization
Managing Tablespaces
- Provisioning of tablespaces
- Definition of default permanent tablespaces
- Handling temporary tablespaces
- Alteration and deletion of tablespaces
- Deployment of Oracle Managed File (OMF)
- Relocation or renaming of online data files
Improving Usage Space
- Insight into space management capabilities
- Regulation of block space
- Specification of table compression
Managing Undo Data
- Oversight of transactions and undo data
- Storage of undo information
- Configuration of undo retention
- Activation of temporary undo
Creating and Managing User Accounts
- Review of Oracle-supplied administrator accounts
- User authentication processes
- Allocation of resource quotas
Configuring Privilege and Role Authorization
- Understanding system-level privileges
- Configuration of system privileges
- Privilege management strategies
Configuring User Resource Limits
- Management of user profiles and accounts
- Interpretation of profile parameters
Oracle Database Auditing
- Foundations of database security
- Implementation of auditing mechanisms
- FGA policy configuration
Loading and Transporting Data
- Strategies for moving data
- Available data loading methods
- Export and import data procedures
- Transportation of entire databases
Database Monitoring
- Performance management workflows
- Database maintenance routines
- Performance tuning methodologies
Database Processes
- Architecture and structure of processes
- Function of distinct writer and monitor processes
Managing Memory
- Oversight of memory components
- Automatic memory management features
Analyzing SQL
- Leveraging the Oracle optimizer
- Optimization of access paths
- Implementation of SQL plan directives
Requirements
- Familiarity with fundamental SQL concepts
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
