Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Oracle Database 19c: Administration Workshop

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. This course provides basic information on backup and recovery techniques.

Description

Overview

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

Course Objectives

After completing this course, students will be able to:

  • Generate database creation scripts using the Database Configuration Assistant (DBCA) and create a container database (CDB)
  • View and modify initialization parameters in SQL*Plus
  • Work with the Automatic Diagnostic Repository (ADR)
  • Implement Oracle Managed Files (OMF)
  • Use techniques to save space
  • Understand DBA responsibilities for security and auditing
  • Transport tablespaces and databases
  • Use performance views and tools to monitor database instance performance

Course Outline

Lesson 1: Introduction to Oracle Database

  • Database Server Architecture

Lesson 2: Accessing an Oracle Database

  • Accessing an Oracle Database
  • Usage of general DBCA Tools to Interact with Database

Lesson 3: Creating an Oracle Database by Using DBCA

  • Creating a Database Using DBCA

Labs

  • Creating a New CDB

Lesson 4: Creating an Oracle Database by Using a SQL Command

  • Creating Database using SQL Command

Labs

  • Creating a New CDB

Lesson 5: Starting Up and Shutting Down a Database Instance

  • Starting Up and Shutting Down a Database Instance
  • Opening and Closing PDBs

Labs

  • Shutting Down and Starting Up the Oracle Database

Lesson 6: Managing Database Instances

  • Managing the Database

Labs

  • Investigating Initialization Parameter Files
  • Viewing Initialization Parameters by Using SQL*Plus
  • Modifying Initialization Parameters by Using SQL*Plus
  • Viewing Diagnostic Information

Lesson 7: Oracle Net Service: Overview

  • Configuring and Administering Oracle Net Service

Lesson 8: Configuring Naming Methods

  • Oracle Net Components
  • Naming Method

Labs

  • Configuring the Oracle Network to Access a Database
  • Creating a Net Service Name for a PDB

Lesson 9: Configuring and Administering the Listener

  • Configuring and Administering the Listener

Labs

  • Exploring the Default Listener
  • Creating a Second Listener
  • Connecting to a Database Service Using the New Listener

Lesson 10: Configuring a Shared Server Architecture

  • Configuring a Shared Server Architecture

Labs

  • Configuring Shared Server Mode
  • Configuring Clients to Use a Shared Server

Lesson 11: Configuring Oracle Connection Manager for Multiplexing and Access Control

  • Configuring Oracle Connection Manager for Multiplexing and Access Control Connection Manager

Labs

  • Installing Oracle Instant Client
  • Configuring the cman.ora File
  • Configuring the Database for Oracle Connection Manager
  • Configuring Clients for Oracle Connection Manager
  • Configuring the Oracle Database Server for Session Multiplexing

Lesson 12: Creating PDBs from Seed

  • Creating PDBs from Seed
  • Provisioning New Pluggable Databases

Labs

  • Creating a New PDB from the PDB Seed

Lesson 13: Using Other Techniques to Create PDBs

  • Using Other Techniques to Create PDBs
  • Method of Creating and Migrating PDBs

Labs

  • Cloning Remote PDBs in Hot Mode
  • Relocating PDBs

Lesson 14: Managing PDBs

  • Managing PDBs

Labs

  • Renaming a PDB
  • Setting Parameter Values for PDBs

Lesson 15: Database Storage Overview

  • Database Storage Overview
  • Purpose of the Default Tablespaces
  • Storage of Data in Blocks
  • Advantage of Deferred Segment Creation

Lesson 16: Creating and Managing Tablespaces

  • Creating and Managing Tablespaces
  • Viewing Tablespace Information

Labs

  • Viewing Tablespace Information
  • Creating a Tablespace
  • Managing Temporary and Permanent Tablespaces

Lesson 17: Improving Space Usage

  • Space Management Features
  • Creating Global Temporary Tables

Labs

  • Managing Space in Tablespaces
  • Using Compression
  • Enabling the Resumable Space Allocation Feature

Lesson 18: Managing Undo Data

  • Managing the Undo
  • Enabling Temporary Undo

Labs

  • Managing Undo Tablespaces in a PDB

Lesson 19: Creating and Managing User Accounts

  • Creating and Managing User Accounts
  • Creating Common Users in the CDB and PDBs
  • Assigning Quotas

Labs

  • Creating Common and Local Users
  • Creating a Local User for an Application
  • Exploring OS and Password File Authentication

Lesson 20: Configuring Privilege and Roles Authorization

  • Configuring Privilege and Roles Authorization

Labs

  • Granting a Local Role (DBA) to PDBADMIN
  • Using SQL*Developer to Create Local Roles

Lesson 21: Configuring User Resource Limits

  • Configuring User Resource Limits

Labs

  • Using SQL*Developer to Create a Local Profile
  • Using SQL*Developer to Create Local Users
  • Configuring a Default Role for a User

Lesson 22: Implementing Oracle Database Auditing

  • Implementing Oracle Database Auditing
  • Configuring Auditing
  • Viewing Audit Policy Information

Labs

  • Enabling Unified Auditing
  • Creating Audit Users
  • Creating an Audit Policy

Lesson 23: Introduction Loading and Transporting Data

  • Introduction Loading and Transporting Data

Lesson 24: Loading Data

  • Loading Data

Labs

  • Loading Data into a PDB from an External File

Lesson 25: Transporting Data

  • Transporting Data
  • Using the RMAN Convert Command

Labs

  • Moving Data from One PDB to Another PDB
  • Transporting a Tablespace

Lesson 26: Using External Tables to Load and Transport Data

  • Using External Tables to load Transport Data
  • External Table Demo

Labs

  • Querying External Tables
  • Unloading External Tables

Lesson 27: Automated Maintenance Tasks: Overview

  • Automated Maintenance Tasks: Overview
  • Automated Maintenance Tasks: Components

Lesson 28: Automated Maintenance Tasks: Managing Tasks and Windows

  • Configuring Automated Maintenance Tasks

Labs

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

Lesson 29: Database Monitoring and Performance Tuning Overview

  • Database Monitoring and Tuning Performance Overview

Lesson 30: Monitoring Database Performance

  • Understanding What Database Performance is Monitored

Lesson 31: Analyzing SQL and Optimizing Access Paths

  • Analyzing SQL and Optimizing Access Paths
  • Adaptive Execution Plans

Similar courses

Introduction to DAX for Power BI

Using Data Analysis Expressions to solve common business problems in Power BI

More Information
PL-400T00: Microsoft Power Platform Developer

The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes.

More Information
Cisco® Solutions: Implementation and Administration (CCNA 200-301)

In this course, you will implement and administer networks by using Cisco solutions.

More Information
CompTIA A+ Part 1 Certification (Exam 220-1101)

Install and configure mobile devices; Compare and contrast networking hardware; Configure internet connections and wireless networking,; Troubleshoot hardware and networks; Install motherboards, RAM, storage devices, CPUs and add-on cards; Deploy and configure connected devices; Summarize cloud-computing concepts and virtualization

More Information
Oracle PL/SQL

This course is designed to create PL/SQL blocks both anonymous and named. This course will cover PL/SQL objects and data types. It will also cover packages and how to debug and improve performance within PL/SQL. It will address deploying PL/SQL objects and using Oracle pre-define packages, procedures, and functions.

More Information
CompTIA Network+ Certification (Exam N10-008)

CompTIA Network+ validates the technical skills needed to securely establish, maintain and troubleshoot the essential networks that businesses rely on. CompTIA Network+ is the only certification that covers the specific skills that network professionals need.

More Information
Agile Fundamentals Workshop

In this course, you will understand and use Agile core terms, explain key Agile concepts and their importance in achieving agility, identify, engage, and leverage key stakeholders in an Agile environment, apply common Agile tools and techniques, embrace and advocate for an Agile mindset to benefit from an Agile approach, select the best practices for a project and apply them appropriately to benefit the project and organization.

More Information
CompTIA Cybersecurity Analyst (CySA+) Certification (Exam CS0-002 & CS0-003)

This course introduces tools and tactics to manage cybersecurity risks, identify various types of common threats, evaluate the organization's security, collect and analyze cybersecurity intelligence, and handle incidents as they occur.

More Information
Advanced Java 9

Students who attend this course will leave armed with new skills to leverage modules, scale applications into multi-core environments, and improve the performance of Java 9 applications. This course will teach students everything they need to successfully master and implement the latest features and benefits of Java 9 and become a more effective Java 9 developer.

More Information
55339: Programming in C#

In this course, students will review the basics of C# program structure, language syntax, and implementation details, and then consolidate their knowledge throughout the week as they build an application that incorporates several features of .NET. The course aims to follow the spirit of the Microsoft Official Curriculum course 20483, while bringing it completely up-to-date with the latest features of C#, .NET 6.0 and Visual Studio 2022.

More Information
55337: Introduction to Programming

In this course you will, explain core programming fundamentals such as computer storage and processing, create and use variables and constants in programs, discuss how to create and use functions in a program, use decisions structures in a computer program, create and use repetition (loops) in a computer program, explain pseudocode and its role in programming, implement object-oriented programming concepts, and identify application errors and explain how to debug an application and handle errors.

More Information
AngularJS Training: AngularJS Programming

In this course, you will create single page web applications using the MVC pattern of AngularJS, understand the programming model provided by the AngularJS framework, define Angular controllers and directives, and control Angular data bindings.

More Information
Comprehensive Angular 12 Programming

In this course, you will develop single page Angular applications using Typescript, set up a complete Angular development environment, create components, directives, services, pipes, forms and custom validators, handle advanced network data retrieval tasks using observables, consume data from REST web services using the Angular HTTP Client, handle push-data connections using the WebSockets protocol, work with Angular Pipes to format data, and use advanced Angular Component Router features.

More Information
Introduction to Programming with Python®

This course is designed for people who want to learn the Python programming language in preparation for using Python to develop software for a wide range of applications, such as data science, machine learning, artificial intelligence, and web development.

More Information
Data Wrangling with Python

This course teaches concepts by deep-dive on-hand exercises. Throughout the course, you will learn data wrangling with hands-on exercises and activities. You’ll find checklists, best practices, and critical points mentioned throughout the lessons, making things more interesting.

More Information
Developing Advanced Automation with Red Hat Ansible Automation Platform (DO374)

In this course, you will apply recommended practices for effective and efficient automation with Ansible, perform automation operations as rolling updates, use advanced features of Red Hat Ansible Automation Platform to work with data, including filters and plugins, create automation execution environments to contain and scale Red Hat Ansible Automation, and leverage capabilities of the automation content navigator to develop Ansible Playbooks.

More Information
Building Data Analytics Solutions using Amazon Redshift

In this course, you will build a data analytics solution using Amazon Redshift, a cloud data warehouse service.

More Information
Data Warehousing on AWS

In this course, you will learn new concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS.

More Information
Building Data Lakes on AWS

In this course, you will apply data lake methodologies in planning and designing a data lake, articulate the components and services required for building an AWS data lake, secure a data lake with appropriate permission, ingest, store, and transform data in a data lake and query, analyze, and visualize data within a data lake.

More Information
Building Batch Data Analytics Solutions on AWS

In this course, you will learn to build batch data analytics solutions using Amazon EMR, an enterprise-grade Apache Spark and Apache Hadoop managed service.

More Information
Developing on AWS

In this course, you will learn how to use the AWS SDK to develop secure and scalable cloud applications using multiple AWS services such as Amazon DynamoDB, Amazon Simple Storage Service, and AWS Lambda. You explore how to interact with AWS using code and learn about key concepts, best practices, and troubleshooting tips.

More Information
Cloud Operations on AWS

In this course, you will learn how to manage and operate automatable and repeatable deployments of networks and systems on AWS.

More Information
DevOps Engineering on AWS

In this course, you will learn how to use the combination of tools, practices, and cultural philosophy of DevOps to improve an organization’s ability to develop, deliver, and maintain applications and services at high velocity on AWS.

More Information
55315: Introduction to SQL Databases

In this course you will describe key database concepts in the context of SQL Server, characterize database languages used in SQL Server, describe data modeling techniques, discuss normalization and denormalization techniques, distinguish relationship types and effects in database design, describe the effects of database design on performance, and define commonly used database objects.

More Information
55366: Querying Data with Transact-SQL

In this course, you will create single table SELECT queries, create multiple table SELECT queries, insert, update, and delete data, query data using built-in functions, create queries that aggregate data, create subqueries, create queries that use table expressions, use UNION, INTERSECT, and EXCEPT on multiple sets of data, implement window functions in queries, use PIVOT and GROUPING SETS in queries, use stored procedures in queries, add error handling to queries, and use transactions in queries.

More Information
55321: SQL Server Integration Services

In this course you will, create sophisticated SSIS packages for extracting, transforming, and loading data, use containers to efficiently control repetitive tasks and transactions, configure packages to dynamically adapt to environment changes, use Data Quality Services to cleanse data, successfully troubleshoot packages, create and manage the SSIS Catalog, deploy, configure, and schedule packages, secure the SSIS Catalog.

More Information
Advanced Programming Techniques with Python (v1.11)

In this course, you will expand your Python proficiencies, select an object-oriented programming approach for Python applications, create object-oriented Python applications, create a desktop application, create data-driven applications, create and secure web service-connected applications, program Python for data science, implement unit testing and exception handling, and package an application for distribution.

More Information
55316: Administering a SQL Database

In this course you will authenticate and authorize users, assign server and database roles, authorize users to access resources, use encryption and auditing features to protect data, describe recovery models and backup strategies, backup and restore SQL Server databases, automate database management, configure security for the SQL Server agent, manage alerts and notifications, managing SQL Server using PowerShell, trace access to SQL Server, monitor a SQL Server infrastructure, and import and export data.

More Information
Web Development with HTML5, CSS, and JavaScript

In this course, you will develop web content in HTML, enhance its formatting and layout using CSS, and add interactivity using JavaScript.

More Information
Building Modern Data Analytics Solutions on AWS

In this course, you will learn how to leverage AWS data Services to store, process, analyze, stream, and query data to make decisions with speed and agility at scale, how to modernize data solutions end to end, and obtain skills to put your data to work to make better, more informed decisions, respond faster to the unexpected, and uncover new opportunities.

More Information
Developing Serverless Solutions on AWS

In this course, you will practice and deploy serverless solutions on AWS.

More Information
Amazon SageMaker Studio for Data Scientists

In this course, you will learn to accelerate the process to prepare, build, train, deploy, and monitor ML solutions using Amazon SageMaker Studio.

More Information
CompTIA A+ Part 2 Certification (Exam 220-1102)

In this course, you will install, configure, optimize, troubleshoot, repair, upgrade, and perform preventive maintenance on personal computers, digital devices, and operating systems.

More Information
AZ-305T00: Designing Microsoft Azure Infrastructure Solutions

This course teaches Azure Solution Architects how to design infrastructure solutions.

More Information
CompTIA Cloud+ Certification (Exam CV0-003)

CompTIA Cloud+ shows you have the expertise needed to deploy and automate secure cloud environments and protect mission-critical applications and data.

More Information
55348: Administering Microsoft Endpoint Configuration Manager

In this 5-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports. Although this course and the associated labs are written for Windows Server 2022, the skills taught will also be backwards compatible for Server 2016 and 2019.

More Information
CompTIA Security+ Certification (Exam SY0-701)

This course maps to the CompTIA Security+ certification exam (SY0-701) and establishes the core knowledge required of any cybersecurity role, as well as providing a springboard to intermediate-level cybersecurity jobs.

More Information
AZ-040T00: Automating Administration with PowerShell

Gain fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers.

More Information
55215: SharePoint Online Power User

Learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues.

More Information
Hands-on Practical Python for Data Wrangling & Transformation

This introductory and beyond level course is for technical users newer to Python who want to learn advanced data handling and transformation skills, using the latest tools and techniques. The course is approximately 50% hands-on to 50% lecture ratio, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Student machines are required.

More Information
CompTIA Data+ Certification (Exam DA0-001)

CompTIA Data+ is an early-career data analytics certification for professionals tasked with developing and promoting data-driven business decision-making that gives learners the confidence to bring data analysis to life.

More Information
SQL Querying: Fundamentals

In this course, you will compose SQL queries to retrieve desired information from a database.

More Information
SQL Querying: Advanced

In this course, you will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel the data entry process.

More Information
Introduction to SQL Databases 10985WV (55356)

This 2-day entry-level course examines the services and features of Microsoft SQL 2022. (This is NOT a SQL querying course, SQL Querying syntax will not be discussed). The content focuses on database tables, adding and changing data, creating and using stored procedures, entity relationships, and indexes.

More Information
Data Analysis Fundamentals

Doing data analysis work is about more than learning a software program (Excel, Power BI, Tableau, etc.) - you need to understand the concepts and theory too. This one day course gets you up to speed (and can be useful either before or after your software classes).

More Information
Using Data Science Tools in Python

In this course, you will use various Python tools to load, analyze, manipulate, and visualize business data.

More Information
Microsoft Power Apps: Building Low-Code Business Apps

In this course, you will use Microsoft Power Apps to build and deploy low-code business apps.

More Information
ITIL 4 Foundation Certification with Exam

ITIL 4 is the next evolution of ITIL, providing a practical and flexible transition that allows organizations to adopt the new ways of working required by the modern digital world. It provides an end-to-end IT/digital operating model for the delivery and operation of tech-enabled products and services and enables IT teams to continue to play a crucial role in wider business strategy.

More Information
55371: Windows Server Administration

This five-day instructor-led course teaches IT professionals the fundamental administration skills required to deploy and support Windows Server in most organizations. It is designed primarily for IT professionals who have some experience with Windows Server and will be responsible for managing identity, networking, storage and compute by using Windows Server, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server.

More Information
AZ-800T00: Administering Windows Server Hybrid Core Infrastructure

This four-day course is intended for Windows Server Hybrid Administrators who have experience working with Windows Server and want to extend the capabilities of their on-premises environments by combining on-premises and hybrid technologies. Windows Server Hybrid Administrators implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.

More Information

Press enter to see more results