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
- Insight into Oracle multitenant container databases
- Details on Oracle database instances and database sharding
Connecting to Oracle Database
- Establishing connections to Oracle database instances
- Utilizing Oracle database toolsets
- Working with SQL*Plus
- Leveraging Oracle SQL Developer
- Employing the Database Configuration Assistant (DBCA)
- Exploring features of Enterprise Manager cloud control 13c
- Overview of Oracle Enterprise Manager components
- Achieving a unified view for enterprise management
- Administering the Oracle Enterprise Manager database
Setting Up an Oracle Database
- Creating an Oracle database via DBCA
- Creating an Oracle database using SQL commands
Handling Database Instances
- Initiating the Oracle database instance
- Terminating an Oracle database instance
- Differentiating between shutdown modes
- Opening and closing PDBs
- Adjusting PDB configurations
Administering Database Instances
- Applying initialization parameters
- Working with the automatic diagnostic repository
- Inspecting the alert log
- Utilizing trace files
- Managing the DDL log file
- Working with dynamic performance views
- Leveraging the data dictionary
Fundamentals of Oracle Net Services
- Identifying Oracle net services components
- Setting up and managing Oracle net services
- Overview of the Oracle net listener
- Distinguishing between dedicated and shared server architectures
Naming Conventions
- Establishing Oracle network connections
- Comprehending various naming methods
- Implementing easy connect
- Configuring local and directory naming
- Managing workloads through database services
- Establishing new database services
Working with the Listener
- Utilizing the default listener
- Setting up dynamic service registration
- Setting up static service registration
Setting Up Shared Server Architecture
- Activating shared server mode
- Regulating shared server operations
- Utilizing 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 client-side settings
- 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
- Using OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative methods for creating PDBs
Managing PDBs
- Switching PDB modes
- Modifying PDB settings
- Adjusting initialization parameters
- Using the Alter System Command within a PDB
- Configuring hostname and port number for each PDB
- Dropping PDBs
Understanding Database Storage
- Database storage architecture
- Database structures
- Utilizing segments, extents, and blocks
- Working with tablespaces and data files
- Understanding segment types
- Storing table data
- Database block content
- Managing deferred segment creation
- Monitoring tablespace utilization
Managing Tablespaces
- Creating new tablespaces
- Defining default permanent tablespaces
- Working with temporary tablespaces
- Modifying and dropping tablespaces
- Implementing Oracle Managed Files (OMF)
- Moving or renaming online data files
Optimizing Space Usage
- Understanding space management capabilities
- Managing block space
- Specifying table compression
Handling Undo Data
- Managing transactions and undo data
- Storing undo information
- Configuring undo retention
- Enabling temporary undo
Creating and Managing User Accounts
- Oracle-provided administrator accounts
- Authenticating users
- Assigning resource quotas
Configuring Privileges and Roles
- Understanding system privileges
- Configuring system privileges
- Managing privilege assignments
Setting User Resource Limits
- Managing profiles and users
- Understanding profile parameters
Oracle Database Auditing
- Understanding database security principles
- Implementing auditing
- FGA policies
Loading and Transporting Data
- Migrating data
- Methods for data loading
- Exporting and importing data
- Transporting databases
Database Monitoring
- Performance management tasks
- Maintaining databases
- Understanding performance tuning approaches
Database Processes
- Process architecture and structure
- Using various writer and monitor processes
Managing Memory
- Managing memory components
- Automatic memory management
Analyzing SQL
- Using 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.
