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
Getting Started
- Introduction to Oracle database server architecture
- Concepts of Oracle multitenant container databases
- Overview of database instances and database sharding
Connecting to Oracle Database
- Establishing connections to Oracle database instances
- Leveraging Oracle database utilities
- Working with SQL*Plus
- Utilizing Oracle SQL Developer
- Employing the Database Configuration Assistant (DBCA)
- Key features of Enterprise Manager cloud control 13c
- Components of Oracle Enterprise Manager
- Enterprise management through a single pane of glass
- Administration of the Oracle Enterprise Manager database
Database Creation
- Provisioning an Oracle database via DBCA
- Creating an Oracle database using SQL commands
Instance Operations
- Initializing Oracle database instances
- Terminating Oracle database instances
- Differences between various shutdown modes
- Opening and closing PDBs
- PDB configuration
Instance Administration
- Application of initialization parameters
- Interaction with the automatic diagnostic repository
- Reviewing the alert log
- Analysis using trace files
- Maintenance of the DDL log file
- Utilization of dynamic performance views
- Navigation of the data dictionary
Oracle Net Services Overview
- Identification of Oracle Net Services components
- Setup and administration of Oracle Net Services
- Introduction to the Oracle Net listener
- Distinctions between dedicated and shared server architectures
Naming Strategies
- Establishing Oracle network connections
- Exploration of naming methods
- Implementation of Easy Connect
- Local and directory-based naming
- Workload management via database services
- Establishment of database services
Listener Administration
- Utilization of the default listener
- Setup of dynamic service registration
- Setup of static service registration
Shared Server Architecture Setup
- Activation of shared servers
- Regulation of shared server activities
- Utilization of SGA and PGA
- Configuration considerations for shared servers
Oracle Connect Manager Setup
- Comprehension of Oracle Connection Manager
- Application of filtering rules
- Enforcement of intranet and internet access controls
- Implementation of session multiplexing
- Setup of Oracle Connection Manager
- Configuration of the cman.ora file
- Client configuration
- Database server configuration
- Use of the Oracle Connection Manager control utility
PDB Provisioning
- Deployment of new pluggable databases
- Creation of new PDBs from PDB$SEED
- Application of the FILE_NAME_CONVERT clause
- Utilization of OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative methods for PDB creation
PDB Administration
- Adjustment of PDB modes
- Modification of PDB settings
- Adjustment of initialization parameters
- Use of the Alter System Command within a PDB
- Hostname and port number configuration for individual PDBs
- Removal of PDBs
Database Storage Concepts
- Storage architecture of the database
- Database structural elements
- Utilization of segments, extents, and blocks
- Use of tablespaces and data files
- Categorization of segment types
- Storage of table data
- Contents of database blocks
- Administration of deferred segment creation
- Monitoring of tablespace utilization
Tablespace Management
- Creation of tablespaces
- Definition of default permanent tablespaces
- Management of temporary tablespaces
- Modification and removal of tablespaces
- Implementation of Oracle Managed File (OMF)
- Relocation or renaming of online data files
Space Utilization Optimization
- Features of space management
- Administration of block space
- Specification of table compression
Undo Data Administration
- Management of transactions and undo data
- Storage of undo information
- Configuration of undo retention
- Enabling of temporary undo
User Account Management
- Oracle-provided administrator accounts
- User authentication
- Assignment of quotas
Privilege and Role Setup
- System privileges explained
- Configuration of system privileges
- Management of privileges
User Resource Limit Configuration
- Administration of profiles and users
- Explanation of profile parameters
Oracle Database Auditing
- Database security concepts
- Auditing procedures
- FGA policies
Data Loading and Transfer
- Data movement strategies
- Methods for data loading
- Data export and import
- Database transportation
Database Monitoring
- Performance management tasks
- Database maintenance
- Approaches to performance tuning
Database Processes
- Process architecture and design
- Utilization of writer and monitor processes
Memory Management
- Administration of memory components
- Automatic memory management
SQL Analysis
- Utilization of the Oracle optimizer
- Optimization of access paths
- SQL plan directives
Requirements
- Fundamental proficiency in SQL
Target Audience
- System Administrators
- Technical Consultants
- Database Administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
