Introduction to Oracle Database Backup and Security

Introduction to Oracle Database Backup and Security, available at $59.99, has an average rating of 4.16, with 24 lectures, based on 270 reviews, and has 2337 subscribers.

You will learn about Download and Install Oracle Database Backup a database Restore a database Secure a database Manage database user priviledges and roles View deleted historical data with flashback Recover dropped tables This course is ideal for individuals who are Beginner Database administrators or Data Analyst or Data Scientist or Engineers or Students or Recent Graduates who want explore IT carreer It is particularly useful for Beginner Database administrators or Data Analyst or Data Scientist or Engineers or Students or Recent Graduates who want explore IT carreer.

Enroll now: Introduction to Oracle Database Backup and Security

Summary

Title: Introduction to Oracle Database Backup and Security

Price: $59.99

Average Rating: 4.16

Number of Lectures: 24

Number of Published Lectures: 24

Number of Curriculum Items: 24

Number of Published Curriculum Objects: 24

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will Learn

Download and Install Oracle Database
Backup a database
Restore a database
Secure a database
Manage database user priviledges and roles
View deleted historical data with flashback
Recover dropped tables

Who Should Attend

Beginner Database administrators
Data Analyst
Data Scientist
Engineers
Students
Recent Graduates who want explore IT carreer

Target Audiences

Beginner Database administrators
Data Analyst
Data Scientist
Engineers
Students
Recent Graduates who want explore IT carreer

Oracle Database is a relational database management system -RDBMS that is widely used by a lot of organisations to store and manage their data.

Database backup and recovery as well as securing the database from unauthorized access are key tasks performed by Database administrators or anyone that closely works with or looks after databases.

As a backup administrator, your principal duty is to devise, implement, and manage a backup and recovery strategy. In general, the purpose of a backup and recovery strategy is to protect the database against data loss and reconstruct the database after data loss.

The Oracle database provides security in the form of authentication,authorization, and auditing. Authentication ensures that only legitimate users gain access to the system. Authorization ensures that those users only have access to resources they are permitted to access.

This course is a practical hands-on that will teach you how to:
    • Perform a full database backup
    • Perform a database restore and recovery
    • View and retrieve historical data using Flashback technology
    • Recover and retrieve dropped tables
    • Establish security measures to protect the database
    • Manage user roles and privileges to the database
    • Enabling Archive log mode
    • Auditing Oracle Database users
    • Predefined Oracle user accounts

After the end of this course , you will know how to :

• Backup and restore a database
• Manage database user access and security
• Recover dropped tables
• Use Oracle flashback technology.

Course Curriculum

Chapter 1: Setting up Your Test Environment

Lecture 1: Introduction

Lecture 2: Hardware Requirements

Lecture 3: Software Requirements

Lecture 4: Download Oracle Database

Lecture 5: Install Oracle Database

Lecture 6: Unlock Sample HR Schema Account

Lecture 7: Download and install Java JDK

Lecture 8: Download Oracle SQL Developer

Lecture 9: Install Oracle SQL Developer

Lecture 10: Starting Oracle SQL Developer

Lecture 11: SQLplus

Chapter 2: Backing Up and Restoring Oracle Database

Lecture 1: Introducction

Lecture 2: Enabling ARCHIVELOG Mode

Lecture 3: Backing up the database

Lecture 4: Restoring and Recovering Database

Lecture 5: Viewing and Restoring Historical Data using Flashback

Lecture 6: Recovering Dropped Tables

Chapter 3: Managing Users and Database Security

Lecture 1: Establishing Security Policy on a Database

Lecture 2: Database Privileges and Roles

Lecture 3: Managing Oracle database users

Lecture 4: Creating new database user

Lecture 5: Auditing database activities

Lecture 6: Predefined Oracle user accounts

Lecture 7: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 5 votes
2 stars: 6 votes
3 stars: 60 votes
4 stars: 104 votes
5 stars: 95 votes

Frequently Asked Questions

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!

Menu