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.
Course Outline
Introduction
- Overview of Oracle database server architecture
- Overview of Oracle multitenant container database
- Oracle database instance and database sharding
Accessing Oracle Database
- Connecting to an Oracle database instance
- Utilising Oracle database tools
- SQL*Plus
- Utilising Oracle SQL Developer
- Utilising Database Configuration Assistant (DBCA)
- Understanding the Enterprise Manager Cloud Control 13c features
- Overview of Oracle Enterprise Manager components
- Single pane of glass for enterprise management
- Managing Oracle Enterprise Manager databases
Creating an Oracle Database
- Creating an Oracle database using DBCA
- Creating an Oracle database via an SQL command
Working with Database Instances
- Starting the Oracle database instance
- Shutting down an Oracle database instance
- Comparing shutdown modes
- Opening and closing pluggable databases (PDBs)
- Configuring PDBs
Managing Database Instances
- Utilising initialisation parameters
- Working with the Automatic Diagnostic Repository
- Viewing the alert log
- Utilising trace files
- Administering the DDL log file
- Working with dynamic performance views
- Utilising the data dictionary
Overview of Oracle Net Services
- Defining components of Oracle Net services
- Configuring and managing Oracle Net services
- Overview of Oracle Net listener
- Comparing dedicated and shared server architectures
Naming Methods
- Establishing Oracle network connections
- Understanding naming methods
- Easy Connect
- Local and directory naming
- Managing workloads via database services
- Creating database services
Working with the Listener
- Utilising the default listener
- Configuring dynamic service registration
- Configuring static service registration
Configuring a Shared Server Architecture
- Enabling a shared server
- Controlling shared server operations
- Utilising SGA and PGA
- Shared server configuration considerations
Configuring Oracle Connection Manager
- Understanding Oracle Connection Manager
- Utilising filtering rules
- Implementing intranet and internet access control
- Utilising session multiplexing
- Configuring Oracle Connection Manager
- Configuring the cman.ora file
- Configuring clients
- Configuring the database server
- Utilising the Oracle Connection Manager control utility
Creating PDBs
- Provisioning new pluggable databases
- Creating a new PDB from PDB$SEED
- Utilising the FILE_NAME_CONVERT clause
- Utilising OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative techniques for creating PDBs
Managing PDBs
- Changing the PDB mode
- Modifying PDB settings
- Changing initialisation parameters
- Utilising the Alter System command within a PDB
- Configuring hostname and port number per PDB
- Dropping PDBs
Understanding Database Storage
- Database storage architecture
- Database structures
- Utilising segments, extents, and blocks
- Utilising tablespaces and data files
- Understanding types of segments
- 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 File (OMF)
- Moving or renaming online data files
Improving Space Utilisation
- 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 Authorisation
- 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
- Auditing implementation
- 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 performance tuning methods
Database Processes
- Process architecture and structure
- Utilising different writer and monitor processes
Managing Memory
- Managing memory components
- Automatic memory management
Analyzing SQL
- Utilising the Oracle optimizer
- Optimising access paths
- SQL plan directives
Summary and Next Steps
Requirements
- Foundational knowledge of SQL
Target Audience
- System administrators
- Technical consultants
- Database administrators
35 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
