Introduction to Oracle Database Backup and Security
4.7 (12 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,097 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to Oracle Database Backup and Security to your Wishlist.

Add to Wishlist

Introduction to Oracle Database Backup and Security

A Practical hands-on guide to backing up and restoring Oracle Databases and Implementing security
4.7 (12 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,097 students enrolled
Last updated 4/2017
English
Current price: $10 Original price: $135 Discount: 93% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • y
  • You should have an understanding of database concepts like Table|Row|Columns
  • Basic SQL knowledge
Description

SQL Server 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.

if you are new to using  SQL Server, this  introductory course is where you want to begin. In
this course , we'll cover the basics of how backup and recover databases. We will also cover how to implement security
measures that will protect the database from unauthorized access.

One of the things that separate mediocre DBAs from exceptional ones is that exceptional DBAs know how to use the tools available to them effectively.

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.


Who is the target audience?
  • Beginner Database administrators
  • Data Analyst
  • Data Scientist
  • Engineers
  • Students
  • Recent Graduates who want explore IT carreer
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
02:25:55
+
Setting up Your Test Environment
11 Lectures 48:06

Hardware Requirements
00:18

Software Requirements
00:17



Unlock Sample HR Schema Account
03:30

Download and install Java JDK
05:24

Download Oracle SQL Developer
04:55

Install Oracle SQL Developer
06:07

Starting Oracle SQL Developer
03:40

SQLplus
09:34
+
Backing Up and Restoring Oracle Database
6 Lectures 48:24
Introducction
08:13

Enabling ARCHIVELOG Mode
09:23

Backing up the database
07:28

Restoring and Recovering Database
06:12

Viewing and Restoring Historical Data using Flashback
10:21

Recovering Dropped Tables
06:47
+
Managing Users and Database Security
6 Lectures 49:27
Establishing Security Policy on a Database
06:41

Database Privileges and Roles
10:26

Managing Oracle database users
07:50

Creating new database user
06:39

Auditing database activities
07:19

Predefined Oracle user accounts
10:32
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
1,548 Reviews
35,067 Students
85 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.