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
- Fundamentals of Oracle database server architecture
- Introduction to the Oracle multitenant container database concept
- Oracle database instances and the principles of database sharding
Connecting to Oracle Database
- Establishing connections to an Oracle database instance
- Utilizing essential Oracle database tools
- Working with SQL*Plus
- Applying Oracle SQL developer functionalities
- Leveraging the Database Configuration Assistant (DBCA)
- Exploring key features of Enterprise Manager cloud control 13c
- Overview of the Oracle Enterprise Manager component
- Achieving a single pane of glass for enterprise management
- Administration of the Oracle Enterprise Manager database
Database Creation
- Creating an Oracle database via DBCA
- Creating an Oracle database using SQL commands
Instance Management
- Starting an Oracle database instance
- Shutting down an Oracle database instance
- Comparing different shutdown modes
- Opening and closing PDBs (Pluggable Databases)
- Configuring PDBs
Instance Administration
- Utilization of initialization parameters
- Interacting with the automatic diagnostic repository
- Reviewing the alert log
- Analysis using trace files
- Administration of the DDL log file
- Working with dynamic performance views
- Utilizing the data dictionary
Oracle Net Services Overview
- Defining the core components of Oracle net services
- Configuration and management of Oracle net services
- Introduction to the Oracle net listener
- Comparison of dedicated and shared server architectures
Naming Strategies
- Establishing Oracle network connections
- Understanding various naming methods
- Implementing Easy Connect
- Local and directory naming conventions
- Workload management through database services
- Creation of database services
Listener Operations
- Utilizing the default listener
- Configuring dynamic service registration
- Configuring static service registration
Shared Server Architecture Setup
- Enabling shared server capabilities
- Controlling shared server operations
- Utilizing SGA and PGA
- Considerations for shared server configuration
Oracle Connect Manager Configuration
- Understanding the Oracle Connection Manager
- Applying filtering rules
- Implementing access control for intranet and internet
- Utilizing session multiplexing
- Configuration of the Oracle Connection Manager
- Setting up the cman.ora file
- Client configuration
- Database server configuration
- Use of the Oracle Connection Manager control utility
PDB Creation
- 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
PDB Management
- Modifying PDB modes
- Adjusting PDB settings
- Updating initialization parameters
- Use of the Alter System Command within a PDB
- Setting hostname and port number for each PDB
- Drop operations for PDBs
Database Storage Concepts
- Storage architecture in the database
- Internal database structures
- Use of segments, extents, and blocks
- Management of tablespaces and data files
- Understanding different segment types
- Storage of table data
- Content within database blocks
- Managing deferred segment creation
- Monitoring tablespace space utilization
Tablespace Administration
- Creation of tablespaces
- Defining default permanent tablespaces
- Working with temporary tablespaces
- Altering and dropping tablespaces
- Implementation of Oracle Managed Files (OMF)
- Moving or renaming online data files
Space Usage Optimization
- Understanding space management features
- Managing block-level space
- Specifying table compression
Undo Data Management
- Handling transactions and undo data
- Storage of undo information
- Configuration of undo retention
- Enabling temporary undo
User Account Management
- Oracle-supplied administrator accounts
- User authentication processes
- Assignment of resource quotas
Privilege and Role Authorization
- Understanding system privileges
- Configuration of system privileges
- Management of privileges
User Resource Limit Configuration
- Managing user profiles
- Understanding profile parameters
Oracle Database Auditing
- Database security principles
- Implementation of auditing
- FGA (Fine-Grained Auditing) policies
Data Loading and Transport
- Data migration processes
- Methods for data loading
- Exporting and importing data
- Transporting entire databases
Database Monitoring
- Performance management tasks
- Database maintenance activities
- Understanding performance tuning methods
Database Processes
- Process architecture and structure
- Use of various writer and monitor processes
Memory Management
- Management of memory components
- Automatic memory management
SQL Analysis
- Utilization of the Oracle optimizer
- Optimization of access paths
- SQL plan directives
Requirements
- Fundamental understanding of SQL
Target Audience
- System Administrators
- Technical Consultants
- Database Administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
