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
- Overview of the Oracle multitenant container database
- Oracle database instances and database sharding
Accessing the Oracle Database
- Establishing connections to an Oracle database instance
- Utilizing Oracle database tools
- Working with SQL*Plus
- Using Oracle SQL Developer
- Employing the Database Configuration Assistant (DBCA)
- Exploring the features of Enterprise Manager Cloud Control 13c
- Overview of Oracle Enterprise Manager components
- Achieving 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
Handling Database Instances
- Starting an Oracle database instance
- Shutting down an Oracle database instance
- Reviewing various shutdown modes
- Opening and closing PDBs
- Configuring PDBs
Managing Database Instances
- Applying initialization parameters
- Interacting with the automatic diagnostic repository
- Reviewing the alert log
- Utilizing trace files
- Administering the DDL log file
- Working with dynamic performance views
- Utilizing the data dictionary
Overview of Oracle Net Services
- Identifying the components of Oracle Net Services
- Setting up and managing Oracle Net Services
- Overview of the Oracle Net listener
- Contrasting dedicated and shared server architectures
Naming Mechanisms
- Setting up Oracle network connections
- Comprehending naming mechanisms
- Easy connect
- Local and directory-based naming
- Managing workloads through database services
- Creating database services
Working with the Listener
- Utilizing the default listener
- Configuring dynamic service registration
- Configuring static service registration
Setting Up a Shared Server Architecture
- Activating the shared server
- Regulating shared server operations
- Leveraging SGA and PGA
- Considerations for shared server configuration
Configuring Oracle Connect Manager
- Understanding the Oracle Connection Manager
- Applying filtering rules
- Implementing intranet and internet access controls
- Utilizing session multiplexing
- Configuring the Oracle Connection Manager
- Setting up the cman.ora file
- Configuring clients
- Configuring the database server
- Using the Oracle Connection Manager control utility
Creating PDBs
- Provisioning new pluggable databases
- Creating a new PDB from PDB$SEED
- Utilizing the FILE_NAME_CONVERT clause
- Employing OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative methods for creating PDBs
Managing PDBs
- Modifying the PDB mode
- Adjusting PDB settings
- Modifying initialization parameters
- Using the Alter System command within a PDB
- Configuring hostname and port number for each PDB
- Removing PDBs
Understanding Database Storage
- Database storage architecture
- Database structures
- Utilizing segments, extents, and blocks
- Working with tablespaces and data files
- Understanding the various types of segments
- Storing table data
- Database block contents
- Managing deferred segment creation
- Monitoring tablespace utilization
Managing Tablespaces
- Creating tablespaces
- Defining default permanent tablespaces
- Working with temporary tablespaces
- Altering and removing tablespaces
- Implementing Oracle Managed File (OMF)
- Moving or renaming online data files
Optimizing Space Usage
- Understanding space management capabilities
- Managing block space
- Specifying table compression
Managing Undo Data
- Managing transactions and undo data
- Storing undo information
- Configuring undo retention
- Enabling temporary undo
Creating and Managing User Accounts
- Oracle-supplied administrator accounts
- Authenticating users
- Assigning quotas
Configuring Privilege and Role Authorization
- Understanding system privileges
- Setting up system privileges
- Managing privileges
Setting User Resource Limits
- Managing profiles and users
- Understanding profile parameters
Oracle Database Auditing
- Understanding database security
- Implementing auditing
- FGA policy
Loading and Transporting Data
- Migrating data
- Methods for data loading
- Exporting and importing data
- Transporting a database
Database Monitoring
- Performance management activities
- Maintaining databases
- Understanding performance tuning methods
Database Processes
- Process architecture and structure
- Using distinct writer and monitor processes
Memory Management
- Managing memory components
- Automatic memory management
Analyzing SQL
- Using the Oracle optimizer
- Optimizing access paths
- SQL plan directives
Requirements
- Fundamental understanding of SQL
Intended Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
