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 Oracle multitenant container databases
- Oracle database instances and database sharding
Accessing Oracle Database
- Establishing connections to Oracle database instances
- Utilizing Oracle database tools
- SQL*Plus
- Using Oracle SQL Developer
- Working with the Database Configuration Assistant (DBCA)
- Key features of Enterprise Manager Cloud Control 13c
- Overview of Oracle Enterprise Manager components
- Unified management view for the enterprise
- Administration of the Oracle Enterprise Manager database
Creating an Oracle Database
- Creating an Oracle database via DBCA
- Creating an Oracle database using SQL commands
Working with Database Instances
- Starting Oracle database instances
- Shutting down Oracle database instances
- Differences between shutdown modes
- Opening and closing PDBs
- Configuring PDBs
Managing Database Instances
- Application of initialization parameters
- Working with the automatic diagnostic repository
- Reviewing the alert log
- Utilizing trace files
- Administration of the DDL log file
- Working with dynamic performance views
- Using the data dictionary
Overview of Oracle Net Services
- Identification of Oracle Net Services components
- Configuration and management of Oracle Net Services
- Overview of the Oracle Net Listener
- Differences between dedicated and shared server architectures
Naming Methods
- Establishing Oracle network connections
- Understanding naming methodologies
- Easy connect
- Local and directory naming conventions
- Workload management via database services
- Creation of database services
Working with the Listener
- Use of the default listener
- Configuration of dynamic service registration
- Configuration of static service registration
Configuring a Shared Server Architecture
- Enabling shared server functionality
- Controlling shared server operations
- Use of SGA and PGA
- Considerations for shared server configuration
Configuring Oracle Connect Manager
- Understanding 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
- Use of the Oracle Connection Manager control utility
Creating PDBs
- Provisioning new pluggable databases
- Creating a new PDB 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
- Modifying PDB modes
- Adjusting PDB settings
- Changing initialization parameters
- Use of the Alter System Command within a PDB
- Per-PDB hostname and port number configuration
- Deletion of PDBs
Understanding Database Storage
- Database storage architecture
- Database structures
- Use of segments, extents, and blocks
- Use of tablespaces and data files
- Types of segments
- Storage of table data
- Database block contents
- Management of deferred segment creation
- Monitoring tablespace space usage
Managing Tablespaces
- Creation of tablespaces
- Definition of default permanent tablespaces
- Management of temporary tablespaces
- Modification and deletion of tablespaces
- Implementation of Oracle Managed Files (OMF)
- Moving or renaming online data files
Improving Usage Space
- Space management features
- Management of block space
- Specification of table compression
Managing Undo Data
- Management of transactions and undo data
- Storage of undo information
- Configuration of undo retention
- Enabling temporary undo
Creating and Managing User Accounts
- Oracle-provided administrator accounts
- User authentication
- Assignment of quotas
Configuring Privilege and Role Authorization
- Understanding system privileges
- Configuration of system privileges
- Privilege management
Configuring User Resource Limits
- Management of profiles and users
- Profile parameters
Oracle Database Auditing
- Database security fundamentals
- Implementation of auditing
- FGA policy
Loading and Transporting Data
- Data migration
- Data loading methods
- Data export and import processes
- Database transport
Database Monitoring
- Performance management activities
- Database maintenance
- Performance tuning methodologies
Database Processes
- Process architecture and structure
- Utilization of various writer and monitor processes
Managing Memory
- Memory component management
- Automatic memory management
Analyzing SQL
- Use of the Oracle optimizer
- Optimization of access paths
- SQL plan directives
Requirements
- Foundational knowledge of SQL
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
