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
- Oracle Database Instances and Database Sharding
Accessing Oracle Database
- Establishing connections to Oracle database instances
- Leveraging Oracle database tools
- Utilizing SQL*Plus
- Working with Oracle SQL Developer
- Using 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 view for enterprise management
- Managing 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
- Comparing various 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
- Using trace files
- Administering the DDL log file
- Utilizing dynamic performance views
- Working with 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 naming methods
- Easy Connect
- Local and directory naming
- 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
- Utilizing SGA and PGA
- Considerations for shared server configuration
Configuring Oracle Connect Manager
- Understanding Oracle Connection Manager
- Implementing filtering rules
- Setting up intranet and internet access control
- Utilizing session multiplexing
- Configuring Oracle Connection Manager
- 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
- Using the FILE_NAME_CONVERT clause
- Utilizing OMF or the PDB_FILE_NAME_CONVERT parameter
- Alternative techniques for creating PDBs
Managing PDBs
- Modifying the PDB mode
- Adjusting 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
- Database structures
- Using segments, extents, and blocks
- Utilizing tablespaces and data files
- Understanding segment types
- 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 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
- 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
- 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
- Familiarity with basic SQL concepts
Target Audience
- System Administrators
- Technical Consultants
- Database Administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
