Name: Oracle 19c Database Administration I (DBA I) (TTOR20519)
Availability: InStock
Rating: 4.6 (5878 reviews)

Duration:

40.00 hours

32.5 CPD hours

Overview:

Oracle 19C Database Administration I (Oracle DBA I) is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models. You will also learn how to create users and administer databases as well as harden the databases to meet your business requirements. This is the foundational course for learning about Oracle Database and it does not assume prior knowledge or Oracle technologies, however you should have incoming experience working with SQL, and be comfortable with Linux and working from the command line. This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas.

Description:

Oracle 19C Database Administration I (Oracle DBA I) is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models. You will also learn how to create users and administer databases as well as harden the databases to meet your business requirements. This is the foundational course for learning about Oracle Database and it does not assume prior knowledge or Oracle technologies, however you should have incoming experience working with SQL, and be comfortable with Linux and working from the command line. This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas.

Course 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

Creating a New PDB from the PDB Seed
Cloning Remote PDBs in Hot Mode
Relocating PDBs

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

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

Using External Tables to Load and Transport Data

Querying External Tables
Unloading External Tables

Automated Maintenance Tasks Overview

Automated Maintenance Tasks
Maintenance Windows
Predefined Maintenance Windows

Bonus: Managing Tasks and Windows

Enabling and Disabling Automated Maintenance Tasks
Modifying the Duration of a Maintenance Window

Bonus: Database Monitoring and Performance Tuning Overview

Performance Planning Considerations
Automatic Workload Repository (AWR)
Advisory Framework

Bonus: Monitoring Database Performance & Processes

Server-Generated Alerts
Setting Metric Thresholds
Performance Monitoring
Examining the Database Background Processes

Bonus: Tuning Database Memory

Viewing Memory Configurations

Bonus: Analyzing SQL and Optimizing Access Paths

Using the Optimizer Statistics Advisor

, 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

Available Delivery Options for Oracle 19c Database Administration I (DBA I) (TTOR20519)

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

How many CPD hours does Oracle 19c Database Administration I (DBA I) (TTOR20519) provide?

The 5 day Oracle 19c Database Administration I (DBA I) (TTOR20519) course gives you up to 32.5 CPD hours/structured learning hours.

Who is the correct audience for Oracle 19c Database Administration I (DBA I) (TTOR20519)?

This hands-on course is geared for experienced DBAs new to Oracle 19c, who can work in Linux and have basic experience with SQL scripting.

Do you provide training for Oracle 19c Database Administration I (DBA I) (TTOR20519)?

Yes, we provide corporate training, dedicated training and closed classes for Oracle 19c Database Administration I (DBA I) (TTOR20519). This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of Oracle 19c Database Administration I (DBA I) (TTOR20519)?

The Oracle 19c Database Administration I (DBA I) (TTOR20519) training takes place over 5 day(s), with each day lasting approximately 40.00 hours including breaks.

What other terms do people search for?

Popular related searches include: Oracle DBA; Database

Why are Nexus Human the best provider for Oracle 19c Database Administration I (DBA I) (TTOR20519)?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for Oracle 19c Database Administration I (DBA I) (TTOR20519)?

Yes, the discount code PENPAL5 is currently available for Oracle 19c Database Administration I (DBA I) (TTOR20519) training. Only one discount code can be used per booking.

Oracle 19c Database Administration I (DBA I) (TTOR20519)