7 reviews

New

Oracle Database Administration : Oracle Express Edition 18c

Step by step instructions for Installation, Configuration & Administration of Oracle Express Edition 18c Database

Instructor

Wysheid Learning Portal

Category

IT & Software

Other IT & Software

819 Students enrolled

Description
Curriculum
FAQ
Reviews

Oracle Express Edition ( Oracle XE) is the free version of Oracle RDBMS Software. In this course, We, Wysheid, will teach you how to administrate Oracle XE Database. We designed the course for the beginners, and no prior knowledge on Oracle is necessary.

After the completion of the course, you will learn the following.

1) Configure the Linux OS for Oracle RDBMS Software installation

2) Installation of Oracle Database pre-install rpm

3) Installation of Oracle Express Edition 18c Installation

4) Creating Oracle Express Edition 18c ( Oracle XE) Database

5) Setting up the operating system variables for database connection

6) Connecting to the database using Oracle Networking

7) Start and stop of the XE database.

8) Taking the backup of Oracle XE Database.

This course is for :

Anyone who wants to build the career as Oracle Database Administrator

Configure Linux For Oracle EX 18c Installation

1

Introduction to Oracle Experss Edition 18c

Video lesson

Introduction Oracle Express Edition 18c. Discuss in detail about the topics covered in the course

Installation of 18c Express Edition

2

Installing Oracle Database 18c Pre-install rpm

Video lesson

This lesson explains how to configure the Linux Operating system for Oracle Installation. We will use Oracle-provided pre-install rpm for this activity. Pre-install rpms are available for database versions 11g, 12c & 18c.

Creating Express Edition database

3

Installation of Oracle XE 18c on OEL

Video lesson

This lesson explains the steps of installing Oracle Express Edition 18c on Oracle Enterprise Linux

Setting Up Enviornmental Variables For Database Connection

4

Creating Express Edition Database

Video lesson

This lesson explains the steps of creating the Oracle Express Edition 18c database

Connecting to XE 18c Database

5

Setting Up Enviornmental Variables for Database Connection

Video lesson

Steps to configure the operating system variables for database connection

Startup & Shutdown of XE Database

6

Connecting to Oracle XE 18c database

Video lesson

In this lesson , we will learn how to connect to Oracle Express Edition database

Creating User On Oracle XE Database

7

Startup & Shutdown of Oracle XE 18c Database

Video lesson

In this lesson , i will show the steps startup & shutdown oracle XE Database

Taking backup of XE 18c Database

8

Creating Users On Oracle XE Database

Video lesson

Learn to create users in Oracle XE 18c Database . Oracle XE 18c supports multitenant database . In this lesson , you will learn to create users in root container as well as pluggable database.

Recovering Oracle XE 18c Database

9

Steps for taking the backup of XE database using RMAN

Video lesson

This lesson discuss the steps to take the backup of XE 18c database using RMAN

De-install Oracle XE 18c

10

Recovering Oracle XE 18c Database Using RMAN

Video lesson

Learn to recover Oracle XE database from RMAN backup . We will be covering the backup and recovery of root container as well as pluggable database

Patching & Upgrading in Oracle XE 18c Database

11

Steps to de-install Oracle XE 18c

Video lesson

Learn to de-install or uninstall Oracle XE 18c database. You will learn to delete the database as well to uninstall the software binaries.

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!

4.29

7 reviews

Please, login to leave a review

Stars 5

Stars 4

Stars 3

Stars 2

Stars 1

Login/Sign Up

Search

Menu

Oracle Database Administration : Oracle Express Edition 18c