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
- Architectural overview of the Oracle database server
- Introduction to the Oracle multitenant container database
- Concepts of Oracle database instances and database sharding
Accessing Oracle Database
- Establishing connections to Oracle database instances
- Utilizing core Oracle database tools
- Working with SQL*Plus
- Leveraging Oracle SQL Developer
- Employing the Database Configuration Assistant (DBCA)
- Exploring features of Enterprise Manager cloud control 13c
- 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
- Building an Oracle database via DBCA
- Creating an Oracle database using SQL commands
Working with Database Instances
- Initiating the Oracle database instance
- Stopping the Oracle database instance
- Evaluating different shutdown modes
- Opening and closing PDBs
- Configuration of PDBs
Managing Database Instances
- Application of initialization parameters
- Interacting with the automatic diagnostic repository
- Reviewing the alert log
- Utilizing trace files
- Administration of the DDL log file
- Workflows with dynamic performance views
- Use of the data dictionary
Overview of Oracle Net Services
- Identifying components of Oracle Net services
- Configuration and management of Oracle Net services
- Overview of the Oracle Net listener
- Comparison of dedicated versus shared server architectures
Naming Methods
- Establishing Oracle network connections
- Understanding naming methodologies
- Easy Connect
- Local and directory naming strategies
- Workload management via database services
- Creation of database services
Working with the Listener
- Utilizing the default listener
- Setup of dynamic service registration
- Setup of static service registration
Configuring a Shared Server Architecture
- Enabling the shared server mode
- Regulation of shared server operations
- Utilization of SGA and PGA
- 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
- Setup of the cman.ora file
- Client configuration
- Database server configuration
- Employment of the Oracle Connection Manager control utility
Creating PDBs
- Provisioning new pluggable databases
- Generating a new PDB 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
Managing PDBs
- Modification of PDB modes
- Adjustment of PDB settings
- Change of initialization parameters
- Application of the Alter System Command within a PDB
- Configuration of hostname and port numbers per PDB
- Deletion of PDBs
Understanding Database Storage
- Database storage architecture
- Internal database structures
- Management of segments, extents, and blocks
- Utilization of tablespaces and data files
- Identification of segment types
- Storage of table data
- Composition of database blocks
- Oversight of deferred segment creation
- Monitoring of tablespace usage
Managing Tablespaces
- Creation of tablespaces
- Definition of default permanent tablespaces
- Interaction with temporary tablespaces
- Alteration and removal of tablespaces
- Deployment of Oracle Managed Files (OMF)
- Relocation or renaming of online data files
Improving Usage Space
- Insight into space management features
- Oversight of block space
- Specification of table compression
Managing Undo Data
- Oversight of transactions and undo data
- Retention of undo information
- Configuration of undo retention policies
- Activation of temporary undo
Creating and Managing User Accounts
- Oracle-provided administrator accounts
- User authentication processes
- Assignment of quotas
Configuring Privilege and Role Authorization
- Comprehension of system privileges
- Configuration of system privileges
- Oversight of privilege management
Configuring User Resource Limits
- Management of profiles and user accounts
- Understanding of profile parameters
Oracle Database Auditing
- Insight into database security
- Implementation of auditing
- FGA policies
Loading and Transporting Data
- Data migration
- Data loading techniques
- Export and import procedures
- Database transport
Database Monitoring
- Performance management tasks
- Database maintenance
- Methods for performance tuning
Database Processes
- Process architecture and structure
- Utilization of various writer and monitor processes
Managing Memory
- Oversight of memory components
- Automated memory management
Analyzing SQL
- Utilization of the Oracle optimizer
- Optimization of access paths
- SQL plan directives
Requirements
- Foundational proficiency in SQL
Intended Audience
- System Administrators
- Technical Consultants
- Database Administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
