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.
Course Outline
Introduction
- Overview of Oracle database server architecture for government systems
- Overview of Oracle multitenant container database environments
- Oracle database instance configuration and database sharding for data partitioning
Accessing Oracle Database
- Connecting to an Oracle database instance securely
- Utilizing Oracle database management tools
- SQL*Plus command-line interface usage
- Using Oracle SQL Developer for data analysis
- Using Database Configuration Assistant (DBCA) for deployment
- Understanding the Enterprise Manager cloud control 13c features for oversight
- Overview of Oracle Enterprise Manager component structure
- Single pane of glass for enterprise management and governance
- Managing Oracle Enterprise Manager database instances
Creating an Oracle Database
- Creating an Oracle database using DBCA for standardized deployment
- Creating an Oracle database using an SQL command for automation
Working with Database Instances
- Starting the Oracle database instance securely
- Shutting down an Oracle database instance safely
- Comparing Shutdown modes for operational integrity
- Opening and closing Pluggable Databases (PDBs)
- Configuring PDBs for specific workload requirements
Managing Database Instances
- Using initialization parameters for system configuration
- Working with the automatic diagnostic repository for incident management
- Viewing the alert log for error tracking
- Using trace files for performance diagnostics
- Administering the DDL log file for change auditing
- Working with dynamic performance views for real-time monitoring
- Using a data dictionary for metadata management
Overview of Oracle Net Services
- Defining components of Oracle net services for network connectivity
- Configuring and managing Oracle net services for reliability
- Overview of Oracle net listener for connection handling
- Comparing dedicated and shared server architecture for resource optimization
Naming Methods
- Establishing Oracle network connections securely
- Understanding the naming methods for service discovery
- Easy connect protocol implementation
- Local and directory naming configurations
- Managing workloads using database services for load balancing
- Creating database services for application routing
Working with the Listener
- Using the default listener for basic connectivity
- Configuring dynamic service registration for automated management
- Configuring static service registration for high availability
Configuring a Shared Server Architecture
- Enabling a shared server to optimize resource usage
- Controlling shared server operations for performance management
- Using SGA and PGA for memory allocation
- Shared server configuration considerations for scalability
Configuring Oracle Connect Manager
- Understanding Oracle Connection Manager for traffic management
- Using filtering rules for security enforcement
- Implementing intranet and internet access control policies
- Using session multiplexing for efficient connection handling
- Configuring Oracle Connection Manager for network security
- Configuring the cman.ora file for parameter settings
- Configuring clients for proper connectivity
- Configuring the database server for listener integration
- Using the Oracle Connection Manager control utility for administration
Creating PDBs
- Provisioning new pluggable databases for tenant isolation
- Creating a new PDB from PDB$SEED as a template
- Using the FILE_NAME_CONVERT clause for file path mapping
- Using OMF or the PDB_FILE_NAME_CONVERT parameter for automatic management
- Other techniques for creating PDBs for flexibility
Managing PDBs
- Changing the PDB mode for operational states
- Modifying PDB settings for customization
- Changing initialization parameters for behavior adjustment
- Using the Alter System Command in a PDB for runtime changes
- Configuring hostname and port number per PDB for network routing
- Dropping PDBs for resource reclaiming
Understanding Database Storage
- Database storage architecture for data integrity
- Database structures for logical organization
- Using segments, extents, and blocks for space allocation
- Using tablespaces and data files for physical storage management
- Understanding the types of segments for object classification
- Storing table data for efficient retrieval
- Database block content for data representation
- Managing deferred segment creation for performance optimization
- Monitoring tablespace space usage for capacity planning
Managing Tablespaces
- Creating tablespaces for storage segregation
- Defining default permanent tablespaces for user objects
- Working with temporary tablespaces for sort operations
- Altering and dropping tablespaces for lifecycle management
- Implementing Oracle Managed File (OMF) for automated file management
- Moving or renaming online data file for maintenance without downtime
Improving Usage Space
- Understanding space management features for efficiency
- Managing block space to reduce fragmentation
- Specifying table compression to optimize storage capacity
Managing Undo Data
- Managing transactions and undo data for consistency
- Storing undo information for recovery operations
- Configuring undo retention for query stability
- Enabling temporary undo for reduced storage overhead
Creating and Managing User Accounts
- Oracle-supplied administrator accounts for privileged access
- Authenticating users for identity verification
- Assigning quotas to enforce storage limits
Configuring Privilege and Role Authorization
- Understanding system privileges for broad access control
- Configuring system privileges for least-privilege compliance
- Managing privileges through role-based access control
Configuring User Resource Limits
- Managing profiles and users for policy enforcement
- Understanding profile parameters for resource constraints
Oracle Database Auditing
- Understanding database security frameworks for compliance
- Auditing implementation for accountability tracking
- FGA policy for fine-grained access monitoring
Loading and Transporting Data
- Moving data between systems securely
- Data loading methods for bulk operations
- Exporting and importing data for portability
- Transporting a database for migration and backup strategies
Database Monitoring
- Performance management activities for service level adherence
- Maintaining databases for operational health
- Understanding methods of performance tuning for optimization
Database Processes
- Process architecture and structure for concurrency control
- Using the different writer and monitor process for system coordination
Managing Memory
- Managing memory components for efficient resource use
- Automatic memory management for dynamic adjustment
Analyzing SQL
- Using Oracle optimizer for query execution planning
- Optimising access paths for improved response times
- SQL plan directives for adaptive performance management
Summary and Next Steps
Requirements
- Foundational proficiency in SQL
Intended Audience
- System administrator
- Technical consultant
- Database administrator
35 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
