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
- Architecture of the Oracle database server
- Concepts of Oracle multitenant container databases
- Oracle database instances and database sharding
Accessing Oracle Database
- Establishing connections to an Oracle database instance
- Utilizing Oracle database tools
- Working with SQL*Plus
- Using Oracle SQL Developer
- Leveraging the Database Configuration Assistant (DBCA)
- Exploring the features of Enterprise Manager cloud control 13c
- Components of Oracle Enterprise Manager
- Achieving a single pane of glass for enterprise management
- Administering 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
- Starting an Oracle database instance
- Shutting down an Oracle database instance
- Differences between shutdown modes
- Opening and closing PDBs
- Configuration of PDBs
Managing Database Instances
- Utilization of initialization parameters
- Working with the automatic diagnostic repository
- Reviewing the alert log
- Using trace files
- Administering the DDL log file
- Working with dynamic performance views
- Using the data dictionary
Overview of Oracle Net Services
- Components of Oracle Net Services
- Configuration and management of Oracle Net Services
- Overview of the Oracle Net listener
- Differences between dedicated and shared server architectures
Naming Methods
- Establishing Oracle network connections
- Understanding various naming methods
- Easy Connect
- Local and directory naming methods
- Managing workloads through database services
- Creation of 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
- Utilizing SGA and PGA
- Considerations for shared server configuration
Configuring Oracle Connect Manager
- Understanding Oracle Connection Manager
- Implementing filtering rules
- Controlling intranet and internet access
- Utilizing session multiplexing
- Configuring Oracle Connection Manager
- Configuring the cman.ora file
- Client configuration
- Database server configuration
- 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
- Changing 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
- Internal database structures
- Working with segments, extents, and blocks
- Using tablespaces and data files
- Types of segments
- Storage of table data
- Content of database blocks
- Managing deferred segment creation
- Monitoring tablespace space usage
Managing Tablespaces
- Creation of 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
- Space management features
- Managing block space
- Specifying table compression
Managing Undo Data
- Transactions and undo data management
- Storage of undo information
- Configuring undo retention
- Enabling temporary undo
Creating and Managing User Accounts
- Oracle-supplied administrator accounts
- User authentication
- Assigning quotas
Configuring Privilege and Role Authorization
- System privileges
- Configuring system privileges
- Managing privileges
Configuring User Resource Limits
- Managing profiles and users
- Profile parameters
Oracle Database Auditing
- Database security concepts
- Implementation of auditing
- FGA policy
Loading and Transporting Data
- Methods of moving data
- Data loading techniques
- Exporting and importing data
- Transporting a database
Database Monitoring
- Performance management activities
- Database maintenance
- Performance tuning methodologies
Database Processes
- Process architecture and structure
- Writer and monitor processes
Managing Memory
- Memory component management
- Automatic memory management
Analyzing SQL
- Using the Oracle optimizer
- Optimizing access paths
- SQL plan directives
Requirements
- Fundamental understanding of SQL
Target Audience
- System Administrators
- Technical Consultants
- Database Administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
