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 the Oracle database instance and database sharding
Accessing Oracle Database
- Establishing connections to an Oracle database instance
- Leveraging Oracle database utilities
- SQL*Plus interface
- Utilizing Oracle SQL developer
- Working with the Database Configuration Assistant (DBCA)
- Exploring the features of Enterprise Manager cloud control 13c
- Component overview of Oracle Enterprise Manager
- The concept of a single pane of glass for enterprise management
- Administrating the Oracle Enterprise Manager database
Creating an Oracle Database
- Building an Oracle database via DBCA
- Initializing an Oracle database using SQL commands
Working with Database Instances
- Initiating the Oracle database instance
- Terminating an Oracle database instance
- Evaluating different shutdown modes
- Opening and closing PDBs
- Setting up PDB configurations
Managing Database Instances
- Applying initialization parameters
- Utilizing the automatic diagnostic repository
- Reviewing the alert log
- Leveraging trace files
- Administering the DDL log file
- Interacting with dynamic performance views
- Referencing the data dictionary
Overview of Oracle Net Services
- Identifying the core components of Oracle net services
- Setting up and overseeing Oracle net services
- Introduction to the Oracle net listener
- Contrasting dedicated and shared server architectures
Naming Methods
- Setting up Oracle network connections
- Grasping the various naming methodologies
- Easy connect protocol
- Local and directory-based naming conventions
- Regulating workloads through database services
- Building database services
Working with the Listener
- Employing the default listener
- Setting up dynamic service registration
- Configuring static service registration
Configuring a Shared Server Architecture
- Activating a shared server
- Regulating shared server activities
- Managing SGA and PGA
- Key considerations for shared server configuration
Configuring Oracle Connect Manager
- Comprehending Oracle Connection Manager
- Applying filtering rules
- Implementing access controls for intranet and internet
- Leveraging session multiplexing
- Setting up Oracle Connection Manager
- Modifying the cman.ora file
- Configuring client settings
- Configuring the database server
- Utilizing the Oracle Connection Manager control utility
Creating PDBs
- Provisioning new pluggable databases
- Creating a new PDB from PDB$SEED
- Applying the FILE_NAME_CONVERT clause
- Utilizing OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative methods for creating PDBs
Managing PDBs
- Switching the PDB mode
- Adjusting PDB settings
- Modifying initialization parameters
- Using the Alter System Command within a PDB
- Setting hostname and port number for each PDB
- Removing PDBs
Understanding Database Storage
- Storage architecture of the database
- Internal database structures
- Working with segments, extents, and blocks
- Managing tablespaces and data files
- Recognizing different segment types
- Storage of table data
- Content structure of a database block
- Overseeing deferred segment creation
- Monitoring tablespace utilization
Managing Tablespaces
- Creating new tablespaces
- Defining default permanent tablespaces
- Managing temporary tablespaces
- Modifying and dropping tablespaces
- Implementing Oracle Managed File (OMF)
- Moving or renaming online data files
Improving Usage Space
- Recognizing space management capabilities
- Managing block-level space
- Defining table compression settings
Managing Undo Data
- Overseeing transactions and undo data
- Storage of undo information
- Setting undo retention levels
- Activating temporary undo
Creating and Managing User Accounts
- Oracle-provided administrator accounts
- User authentication processes
- Allocating resource quotas
Configuring Privilege and Role Authorization
- Understanding system-level privileges
- Setting up system privileges
- Overseeing privilege assignments
Configuring User Resource Limits
- Managing user profiles
- Understanding profile parameter settings
Oracle Database Auditing
- Comprehending database security protocols
- Implementing auditing procedures
- FGA (Fine-Grained Auditing) policy
Loading and Transporting Data
- Data migration strategies
- Methods for data loading
- Data export and import processes
- Database transport procedures
Database Monitoring
- Performance management tasks
- Database maintenance routines
- Understanding performance tuning techniques
Database Processes
- Process architecture and organization
- Utilizing various writer and monitor processes
Managing Memory
- Overseeing memory components
- Automated memory management
Analyzing SQL
- Leveraging the Oracle optimizer
- Optimizing 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.
