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
- Architectural overview of the Oracle database server
- Introduction to Oracle multitenant container databases
- Oracle database instances and database sharding concepts
Accessing Oracle Database
- Establishing connections to Oracle database instances
- Utilizing Oracle database tools
- Working with SQL*Plus
- Leveraging Oracle SQL Developer
- Utilizing the Database Configuration Assistant (DBCA)
- Exploring the features of Enterprise Manager Cloud Control 13c
- Overview of Oracle Enterprise Manager components
- Achieving a unified view for enterprise management
- Administering the Oracle Enterprise Manager database
Creating an Oracle Database
- Provisioning an Oracle database via DBCA
- Initializing an Oracle database using SQL commands
Managing Database Instances
- Initiating the Oracle database instance
- Terminating an Oracle database instance
- Evaluating different shutdown modes
- Opening and closing Pluggable Databases (PDBs)
- Configuring PDB settings
Administrating Database Instances
- Utilizing initialization parameters
- Working with the Automatic Diagnostic Repository
- Reviewing the alert log
- Analyzing trace files
- Managing the DDL log file
- Interacting with dynamic performance views
- Navigating the data dictionary
Overview of Oracle Net Services
- Identifying components of Oracle Net services
- Configuring and managing Oracle Net services
- Understanding the Oracle Net listener
- Contrasting dedicated and shared server architectures
Naming Methods
- Establishing Oracle network connections
- Understanding various naming methods
- Utilizing Easy Connect
- Configuring local and directory naming
- Managing workloads through database services
- Creating new database services
Working with the Listener
- Utilizing the default listener
- Configuring dynamic service registration
- Configuring static service registration
Configuring a Shared Server Architecture
- Enabling shared server mode
- Controlling shared server operations
- Managing System Global Area (SGA) and Program Global Area (PGA)
- Considering shared server configuration best practices
Configuring Oracle Connection Manager
- Understanding Oracle Connection Manager
- Applying filtering rules
- Implementing intranet and internet access controls
- Utilizing session multiplexing
- Configuring Oracle Connection Manager settings
- Modifying the cman.ora file
- Configuring client-side settings
- Configuring the database server-side settings
- Using the Oracle Connection Manager control utility
Creating PDBs
- Provisioning new Pluggable Databases
- Creating a new PDB from PDB$SEED
- Applying the FILE_NAME_CONVERT clause
- Utilizing OMF or the PDB_FILE_NAME_CONVERT parameter
- Employing alternative techniques for PDB creation
Managing PDBs
- Switching PDB operating modes
- Adjusting PDB configurations
- Modifying initialization parameters
- Using the Alter System command within a PDB
- Assigning specific hostnames and port numbers to PDBs
- Dropping Pluggable Databases
Understanding Database Storage
- Database storage architecture
- Internal database structures
- Utilizing segments, extents, and blocks
- Managing tablespaces and data files
- Understanding different segment types
- Storing table data efficiently
- Reviewing database block content
- Managing deferred segment creation
- Monitoring tablespace utilization
Managing Tablespaces
- Creating new tablespaces
- Defining default permanent tablespaces
- Managing temporary tablespaces
- Altering or dropping existing tablespaces
- Implementing Oracle Managed Files (OMF)
- Moving or renaming online data files
Optimizing Space Usage
- Understanding space management capabilities
- Managing block-level space
- Implementing table compression
Managing Undo Data
- Handling transactions and undo data
- Storing undo information
- Configuring undo retention settings
- Enabling temporary undo
Creating and Managing User Accounts
- Utilizing Oracle-provided administrator accounts
- Implementing user authentication
- Assigning resource quotas
Configuring Privilege and Role Authorization
- Understanding system-level privileges
- Configuring system privileges
- Managing privilege assignments
Configuring User Resource Limits
- Managing user profiles
- Understanding profile parameter settings
Oracle Database Auditing
- Comprehending database security models
- Implementing auditing mechanisms
- Configuring Fine-Grained Auditing (FGA) policies
Loading and Transporting Data
- Migrating data
- Exploring data loading methods
- Exporting and importing data sets
- Transporting database files
Database Monitoring
- Conducting performance management activities
- Maintaining database health
- Understanding performance tuning methodologies
Database Processes
- Process architecture and organizational structure
- Utilizing various writer and monitor processes
Memory Management
- Managing different memory components
- Implementing automatic memory management
Analyzing SQL
- Utilizing the Oracle optimizer
- Optimizing data access paths
- Implementing 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.
