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
- Introduction to the Oracle multitenant container database
- Concepts of Oracle database instances and database sharding
Connecting to 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 Oracle Enterprise Manager Cloud Control 13c capabilities
- Overview of Oracle Enterprise Manager components
- Achieving a single pane of glass for enterprise management
- Managing the Oracle Enterprise Manager database
Provisioning an Oracle Database
- Creating an Oracle database via DBCA
- Initializing an Oracle database using SQL commands
Interacting with Database Instances
- Starting the Oracle database instance
- Shutting down an Oracle database instance
- Evaluating different shutdown modes
- Opening and closing PDBs
- Configuring PDBs
Overseeing Database Instances
- Utilizing initialization parameters
- Interacting with the automatic diagnostic repository
- Inspecting the alert log
- Utilizing trace files
- Administering the DDL log file
- Working with dynamic performance views
- Leveraging 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
- Contrasting dedicated and shared server architectures
Naming Strategies
- Establishing Oracle network connections
- Understanding various naming methods
- Implementing Easy Connect
- Using local and directory naming
- Managing workloads through database services
- Creating database services
Managing the Listener
- Utilizing the default listener
- Configuring dynamic service registration
- Setting up static service registration
Setting Up a Shared Server Architecture
- Enabling shared server mode
- Controlling shared server operations
- Leveraging SGA and PGA
- Considerations for shared server configuration
Configuring Oracle Connection Manager
- Understanding Oracle Connection Manager
- Applying filtering rules
- Implementing access control for intranet and internet
- Utilizing session multiplexing
- Configuring Oracle Connection Manager settings
- Managing the cman.ora file
- Configuring client settings
- Configuring the database server
- Using the Oracle Connection Manager control utility
Provisioning 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
Overseeing PDBs
- Modifying PDB modes
- Adjusting PDB settings
- Updating initialization parameters
- Using the ALTER SYSTEM command within a PDB
- Setting hostname and port number for each PDB
- Dropping PDBs
Comprehending Database Storage
- Database storage architecture
- Database structures
- Utilizing segments, extents, and blocks
- Using tablespaces and data files
- Understanding different segment types
- Storing table data
- Database block content
- Managing deferred segment creation
- Monitoring tablespace utilization
Administering 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
Optimizing Space Usage
- 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 resource quotas
Configuring Privileges and Roles
- Understanding system privileges
- Configuring system privileges
- Managing privilege assignments
Setting User Resource Limits
- Managing profiles and user settings
- Understanding profile parameters
Oracle Database Auditing
- Understanding database security
- Implementing auditing
- Configuring FGA policies
Loading and Transporting Data
- Moving data
- Methods for loading data
- Exporting and importing data
- Transporting a database
Monitoring the Database
- Performance management activities
- Maintaining databases
- Understanding performance tuning methods
Database Processes
- Process architecture and structure
- Utilizing various writer and monitor processes
Managing Memory
- Managing memory components
- Automatic memory management
Analyzing SQL
- Utilizing 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.
