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
- Oracle database instances and database sharding concepts
Accessing Oracle Database
- Establishing connections to an Oracle database instance
- Leveraging Oracle database tools
- Utilizing SQL*Plus
- Working with 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 single pane of glass for enterprise management
- Administering the Oracle Enterprise Manager database
Creating an Oracle Database
- Setting up an Oracle database via DBCA
- Creating an Oracle database through SQL commands
Working with Database Instances
- Initiating the Oracle database instance
- Terminating an Oracle database instance
- Differentiating between Shutdown modes
- Opening and closing PDBs
- Configuring PDBs
Managing Database Instances
- Applying initialization parameters
- Utilizing the automatic diagnostic repository
- Reviewing the alert log
- Working with trace files
- Administering the DDL log file
- Interacting 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
- Understanding the Oracle Net listener
- Distinguishing between dedicated and shared server architectures
Naming Methods
- Setting up Oracle network connections
- Comprehending various naming methods
- Implementing Easy Connect
- Applying local and directory naming conventions
- Managing workloads through database services
- Establishing database services
Working with the Listener
- Utilizing the default listener
- Setting up dynamic service registration
- Configuring static service registration
Configuring a Shared Server Architecture
- Activating a shared server
- Regulating shared server operations
- Utilizing SGA and PGA
- Considerations for shared server configuration
Configuring Oracle Connect Manager
- Understanding Oracle Connection Manager
- Applying filtering rules
- Implementing access controls for intranet and internet
- Utilizing session multiplexing
- Setting up Oracle Connection Manager
- Configuring the cman.ora file
- Setting up 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
- Applying the FILE_NAME_CONVERT clause
- Using OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative techniques for creating PDBs
Managing PDBs
- Modifying the PDB mode
- Adjusting PDB settings
- Updating 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
- Working with segments, extents, and blocks
- Managing tablespaces and data files
- Understanding various segment types
- Storing table data
- Database block content
- Managing deferred segment creation
- Monitoring tablespace space usage
Managing Tablespaces
- Creating tablespaces
- Defining default permanent tablespaces
- Working with temporary tablespaces
- Altering and dropping tablespaces
- Implementing Oracle Managed Files (OMF)
- Moving or renaming online data files
Improving Usage Space
- Understanding space management features
- 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
- Configuring system privileges
- Managing privileges
Configuring User Resource Limits
- Managing profiles and users
- Understanding profile parameters
Oracle Database Auditing
- Understanding database security
- Implementing auditing
- FGA policy
Loading and Transporting Data
- Moving data
- Data loading methods
- Exporting and importing data
- Transporting a database
Database Monitoring
- Performance management activities
- Maintaining databases
- Understanding methods of performance tuning
Database Processes
- Process architecture and structure
- Using the different writer and monitor process
Managing Memory
- Managing memory components
- Automatic memory management
Analyzing SQL
- Using the Oracle optimizer
- Optimising access paths
- SQL plan directives
Requirements
- Foundational proficiency in SQL
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
