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.
- Overview of Oracle multitenant container database.
- Oracle database instance and database sharding concepts.
Accessing Oracle Database
- Establishing connections to an Oracle database instance.
- Utilizing Oracle database tools effectively.
- Introduction to SQL*Plus.
- Working with Oracle SQL Developer.
- Using the Database Configuration Assistant (DBCA).
- Familiarization with Oracle Enterprise Manager Cloud Control 13c features.
- Overview of Oracle Enterprise Manager components.
- Implementing a single pane of glass approach for enterprise management.
- Administrating the Oracle Enterprise Manager database.
Creating an Oracle Database
- Creating an Oracle database using DBCA.
- Creating an Oracle database via SQL commands.
Working with Database Instances
- Initiating the Oracle database instance.
- Shutting down an Oracle database instance.
- Comparing different shutdown modes.
- Opening and closing Pluggable Databases (PDBs).
- Configuring PDBs.
Managing Database Instances
- Utilizing initialization parameters.
- Working with the automatic diagnostic repository.
- Reviewing the alert log.
- Utilizing trace files for diagnostics.
- Administering the DDL log file.
- Working with dynamic performance views.
- Using the data dictionary.
Overview of Oracle Net Services
- Defining 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.
- Implementing Easy Connect.
- Local and directory naming conventions.
- Managing workloads using database services.
- Creating database services.
Working with the Listener
- Using the default listener.
- Configuring dynamic service registration.
- Configuring static service registration.
Configuring a Shared Server Architecture
- Enabling the shared server.
- Controlling shared server operations.
- Using SGA and PGA.
- Considerations for shared server configuration.
Configuring Oracle Connect Manager
- Understanding Oracle Connection Manager.
- Using filtering rules.
- Implementing intranet and internet access control.
- Using session multiplexing.
- Configuring Oracle Connection Manager settings.
- Configuring 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.
- Alternative techniques for creating PDBs.
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 per PDB.
- Dropping PDBs.
Understanding Database Storage
- Database storage architecture.
- Database structures.
- Using segments, extents, and blocks.
- Using tablespaces and data files.
- Understanding the different types of segments.
- Storing table data.
- Database block content analysis.
- 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 processes.
Managing Memory
- Managing memory components.
- Automatic memory management.
Analyzing SQL
- Using the Oracle optimizer.
- Optimizing access paths.
- SQL plan directives.
Requirements
- Foundational knowledge of SQL.
Target Audience
- System Administrators
- Technical Consultants
- Database Administrators
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 6500 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
good explanation on each points and provide assignment for practices.
