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
- Overview of Oracle database server architecture.
- Introduction to Oracle multitenant container databases.
- Concepts of Oracle database instances and database sharding.
Accessing Oracle Database
- Establishing connections to Oracle database instances.
- 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.
- Using a single pane of glass for enterprise management.
- Managing the Oracle Enterprise Manager database.
Creating an Oracle Database
- Creating an Oracle database via DBCA.
- Creating an Oracle database using SQL commands.
Working with Database Instances
- Starting an Oracle database instance.
- Shutting down an Oracle database instance.
- Comparing different shutdown modes.
- Opening and closing Pluggable Databases (PDBs).
- Configuring PDBs.
Managing Database Instances
- Working with initialization parameters.
- Managing the automatic diagnostic repository.
- Reviewing the alert log.
- Utilizing trace files.
- Administering the DDL log file.
- Working with dynamic performance views.
- Using the data dictionary.
Overview of Oracle Net Services
- Identifying the components of Oracle Net Services.
- Configuring and managing Oracle Net Services.
- Overview of the Oracle Net listener.
- Comparing dedicated and shared server architectures.
Naming Methods
- Establishing Oracle network connections.
- Understanding various naming methods.
- Using Easy Connect.
- Implementing local and directory 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.
Configuring a Shared Server Architecture
- Enabling the shared server feature.
- Controlling shared server operations.
- Managing SGA and PGA usage.
- Considerations for shared server configuration.
Configuring Oracle Connect Manager
- Understanding Oracle Connection Manager.
- Applying filtering rules.
- Implementing access control for intranet and internet.
- Utilizing session multiplexing.
- Configuring Oracle Connection Manager settings.
- 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.
- Using OMF or the PDB_FILE_NAME_CONVERT parameter.
- Other techniques for PDB creation.
Managing PDBs
- Changing the PDB mode.
- 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 structural components.
- Working with segments, extents, and blocks.
- Using tablespaces and data files.
- Understanding different segment types.
- Storing table data.
- Database block content structure.
- Managing deferred segment creation.
- Monitoring tablespace space usage.
Managing Tablespaces
- Creating new 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 settings.
- Enabling temporary undo.
Creating and Managing User Accounts
- Oracle-supplied administrator accounts.
- Authenticating users.
- Assigning resource quotas.
Configuring Privilege and Role Authorization
- Understanding system privileges.
- Configuring system privileges.
- Managing privilege assignments.
Configuring User Resource Limits
- Managing user profiles.
- Understanding profile parameters.
Oracle Database Auditing
- Understanding database security frameworks.
- Implementing auditing strategies.
- Working with FGA policies.
Loading and Transporting Data
- Methods for moving data.
- Various data loading techniques.
- Exporting and importing data.
- Transporting entire databases.
Database Monitoring
- Performance management activities.
- Database maintenance procedures.
- Understanding performance tuning methods.
Database Processes
- Process architecture and structure.
- Utilizing different writer and monitor processes.
Managing Memory
- Managing memory components.
- Automatic memory management.
Analyzing SQL
- Using the Oracle optimizer.
- Optimizing access paths.
- Applying SQL plan directives.
Requirements
- Familiarity with fundamental SQL concepts.
Intended Audience
- System Administrators.
- Technical Consultants.
- Database Administrators.
Testimonials (1)
good explanation on each points and provide assignment for practices.
