Maxtrain.com - info@maxtrain.com - 513-322-8888 - 866-595-6863
Oracle 19c Database Administration I
Description
Oracle 19c Database Administration I (Oracle 19c DBA I) Introduction
Welcome to the Oracle 19c Database Administration I (Oracle 19c DBA I) course, a comprehensive program tailored for both newcomers and experienced database professionals. Dive deep into Oracle Database architecture and administration, learning to proficiently manage Oracle databases. This course ensures you acquire the practical skills needed for effective database management, covering topics like storage structures, user administration, and security measures to safeguard and enhance your Oracle environment.
Designed to cater to learners of all levels, this course is perfect for those new to Oracle Database, providing hands-on experience in database creation and management. You’ll gain insights into Container Databases (CDBs), tools for database access, and learn how to navigate the intricate logical and physical structures of Oracle Database. The curriculum extends to Oracle Net Services, Oracle Connection Manager, and techniques for integrating non-Oracle data via SQLLoader. Advanced topics include Oracle Data Pump architecture and SQLLoader, along with bonus content on performance monitoring and maintenance windows.
Join us to build a solid foundation in Oracle 19c Database Administration and empower yourself for a thriving career in database management.
Oracle 19c Database Administration I (Oracle 19c DBA I) Course Objectives
- Understand Oracle Database architecture and administration concepts.
- Create and manage Oracle Database storage structures.
- Master user administration and implement security measures.
- Manage Container Databases (CDBs) and access Oracle databases through various tools.
- Learn to utilize Oracle Net Services and Oracle Connection Manager.
- Load non-Oracle databases using SQLLoader and understand Oracle Data Pump architecture.
- Develop skills in basic performance monitoring and maintenance window planning.
Prerequisites
- Take Before: Attendees should have skills equivalent to or should have attended this course as a pre-requisite:
- Introduction to Writing SQL Queries
- Take After:
- Oracle 19c Database Administration I (Oracle 19c DBA II)
Audience
This hands-on course is geared for experienced DBAs new to Oracle 19c. Incoming students should possess:
- Basic understanding of database principles
- Linux skills, including familiarity with command-line options such as ls, cd, cp, and su
- Beginning proficiency with SQL
Oracle 19c Database Administration I (Oracle 19c DBA I) Outline
Introduction to Oracle Database
- Oracle Multitenant Container Database
- Oracle Database Instance Configurations
- Database Sharding
- Oracle Database Server
Accessing an Oracle Database
- Oracle Database Tools
- Database Tool Choices
- SQL Developer
- Enterprise Manager Database Express
Creating an Oracle Database by Using DBCA
- Planning the Database
- Choosing a Database Template
- Configuration Assistant
Creating an Oracle Database by Using a SQL Command
- Creating a Container Database
- Enable Pluggable Database
Starting Up and Shutting Down a Database Instance
- Starting the Oracle Database Instance
- Shutting Down an Oracle Database Instance
- Opening and Closing PDBs
Managing Database Instances
- Investigating Initialization Parameter Files
- Viewing Initialization Parameters by Using SQL*Plus
- Modifying Initialization Parameters by Using SQL*Plus
- Viewing Diagnostic Information
Oracle Net Services Overview
- Oracle Net Services Components
- Oracle Net Listener
Configuring Naming Methods
- Configuring the Oracle Network to Access a Database
- Creating a Net Service Name for a PDB
Configuring and Administering the Listener
- Exploring the Default Listener
- Creating a Second Listener
- Connecting to a Database Service Using the New Listener
Configuring a Shared Server Architecture
- Configuring Shared Server Mode
- Configuring Clients to Use a Shared Server
Configuring Oracle Connection Manager for Multiplexing and Access Control
- Oracle Connection Manager Processes
- Filtering Rules
- Session Multiplexing
Creating PDBs from Seed
- Provisioning New Pluggable Databases
- Tools
- Creating a New PDB from PDB$SEED
- Using OMF or the PDB_FILE_NAME_CONVERT Parameter
Using Other Techniques to Create PDBs
- Cloning Regular PDBs
- Migrating Data from a Non-CDB into a CDB
- Remote PDB
- Cloning Remote PDBs in Hot Mode
- Creating a Proxy PDB
Managing PDBs
- Renaming a PDB
- Setting Parameter Values for PDBs
Database Storage Overview
- Logical and Physical Database Structures
- Tablespaces and Data Files
- Types of Segments
- Monitoring Tablespace Space Usage
Creating and Managing Tablespaces
- Viewing Tablespace Information
- Creating a Tablespace
- Managing Temporary and Permanent Tablespaces
Improving Space Usage
- Managing Space in Tablespaces
- Using Compression
- Enabling the Resumable Space Allocation Feature
Managing Undo Data
- Transactions and Undo Data
- Managing Undo
- Configuring Undo Retention
- Categories of Undo
- Temporary Undo Benefits
Creating and Managing User Accounts
- Creating Common and Local Users
- Creating a Local User for an Application
- Exploring OS and Password File Authentication
Configuring Privilege and Role Authorization
- Granting a Local Role (DBA) to PDBADMIN
- Using SQL*Developer to Create Local Roles
Configuring User Resource Limits
- Using SQL*Developer to Create a Local Profile & Users
- Configuring a Default Role for a User
Implementing Oracle Database Auditing
- Enabling Unified Auditing
- Creating Audit Users
- Creating an Audit Policy
Introduction to Loading and Transporting Data
- General Architecture
- Oracle Data Pump
- SQL Loader
- Loading Data into a PDB from an External File
- Moving Data from One PDB to Another PDB
- Transporting a Tablespace
BONUS CONTENT / TIME PERMITTING
These extra / bonus chapters will be included with your courseware, but only covered in class if time permits
- Loading Data
- Transporting Data
- Using External Tables to Load and Transport Data
- Automated Maintenance Tasks: Overview
- Managing Tasks and Windows
- Database Monitoring and Performance Tuning Overview(Bonus)
- Monitoring Database Performance
- Database Processes
- Managing Memory
- Analyzing SQL and Optimizing Access Paths
$2595.00
|
5 Days Course |