A Guide to becoming an Oracle Database Administrator (DBA)
3.6 (46 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,905 students enrolled
Wishlisted Wishlist

Please confirm that you want to add A Guide to becoming an Oracle Database Administrator (DBA) to your Wishlist.

Add to Wishlist

A Guide to becoming an Oracle Database Administrator (DBA)

Learn the essential tools you will need to function effectively as an Oracle DBA
3.6 (46 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,905 students enrolled
Last updated 2/2017
English
Curiosity Sale
Current price: $10 Original price: $165 Discount: 94% off
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Start and Shut down a database
  • Backup and Recover Data
  • Create database objects like database,schema and tables
  • Monitor the database
  • Export and Import Metadata and Data
  • View database version and globalization
  • Identify database software release number
  • Manage database users
  • Manage security of the database
View Curriculum
Requirements
  • You should be able to use a PC at a beginner level
  • You should have Oracle database installed -The course will guide you how to do that
  • You should have tools to connect to Oracle database -The course will guide you how to do that
  • You should have ba basic understandingof database concepts-For example what is a table
  • You should have a basic understanding of SQL
Description

Oracle Database Administrator's are in constant demand in the IT industry.
The  rapid growth of data has fuelled the demand for database administrator's in general.  We are more than before reliant on data in our everyday life either through the use of social media with applications like Facebook,Instagram Whatsapp ,Twitter and may more data rich applications.

This course is designed for beginners who are considering a career as a database administrator. It will guide you
through some of the tasks that an Oracle database administrator has to perform.

Oracle DBA Responsibilities includes:

Installing new versions of the Oracle database and its tools
Installing tools  required to access the Oracle database.
Shutting down and Starting the database
Backing up and Recovering Data
Exporting and Importing Data
Managing Users
Managing security of the database
Monitoring the database
Creating database objects like databases, tables and views
Create new database users as required.
Upgrading the database
Plans and implements backup and recovery of the Oracle database.
Assists with impact analysis of any changes made to the database objects.
Provides technical support to application development teams
Enforces and maintains database constraints to ensure integrity of the database.
Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
Troubleshooting  problems regarding the databases, applications and development tools.


This course is a  practical hands-on workshop that will guide you through performing some of the task an oracle database
administrator performs. By the end of this course you will gain some useful skills that will give you enough confidence
to progress your journey towards becoming a database administrator.

Looking forward to welcoming you to the course.

Who is the target audience?
  • College students
  • IT Professionals who want to become a DBA
  • Aspiring database administrators(DBA)
  • Data Analyst
  • Data warehouse professionals
  • Fresh graduates who are looking for a job in the IT industry.
  • Anyone who wants to explore a career in Database Administration
Students Who Viewed This Course Also Viewed
Curriculum For This Course
72 Lectures
07:15:19
+
Installing your Oracle Software and Tools Used to Administer an Oracle Database
16 Lectures 01:11:03



Oracle Database Hardware Preinstallation Requirements
00:19

Oracle Database Software Preinstallation Requirements
00:18




Download and Install java JDK
05:24

Download Oracle SQL Developer
04:55

Install Oracle SQL Developer
06:07

Launching Oracle SQL Developer
03:40

Download TOAD
05:29

Install TOAD
03:33

Connect TOAD to Oracle Database
08:11

Using SQLPLUS
09:34
+
Monitoring a Database
4 Lectures 14:51
Introduction
00:53

Monitoring and viewing a Database Session
05:11

Monitoring Top SQL Statements
05:51

Monitoring Long Operations
02:56
+
Exporting and Importing Metadata and Data
4 Lectures 26:33
Exporting and Importing Meta Data and Data with Oracle SQL Developer
07:40

Importing Metadata and Data Using a Script File
06:57

Exporting Data to Microsoft Excel File
05:26

Importing Data from Microsoft Excel File
06:30
+
Managing Oracle Database Accounts
4 Lectures 20:00
Types of Oracle Database Users
04:27

How to create new user with DBA Priviledges
07:37

Predefined Administrative Accounts
03:10

Operating System Accounts: SYSDBA Vs SYSOPER
04:46
+
Analytic Functions
17 Lectures 02:04:36
Analytic Function Introduction
06:43

Syntax
04:07

Partition By Clause
08:04

Order By Clause
05:48

Dense Rank
05:57

First and Last Function
08:56

LAG Function
03:37

LEAD Function
06:43

LISTAGG Function
06:14

RANK Function
06:04

ROW Number Function
09:26

What is a Windowing clause
08:06

Default Windowing Clause
10:52

Using Rows with Windowing Clause
11:25

Using Range with Windowing Clause
07:36

Using Between with Windowing Clause
09:35

Multiple Window into Your Data
05:23
+
Backing Up and Recovering Data
6 Lectures 48:23
Introduction
08:13

Enabling ARCHIVELOG Mode
09:23

Backing Up the Database
07:27

Restoring and Recovering the Database
06:12

Viewing and Restoring Historical Data with Flashback Query
10:21

Recovering Dropped Tables
06:47
+
Managing the Oracle Database Instance
8 Lectures 47:53
How to ShutDown a Database
06:46

How to start up a Database
05:18

How to check Database version with Oracle SQL Developer
04:08

How to identify Oracle Database Release Number
05:25

What is a Schema
05:12

What is a Tablespace
05:58

How to create a Tablespace - Part 1
08:35

How to create a Tablespace - Part 2
06:31
+
Managing Users and Securing the Database
6 Lectures 49:27
Establishing Security Policy on a Database
06:41

Privileges and Roles
10:26

Managing oracle database users
07:50

How to create a new database user
06:39

Auditing Database activities
07:19

Predefined oracle database accounts
10:32
+
Managing UNDO Data
7 Lectures 32:37
What is UNDO Data
03:02

UNDO Tablespace
04:30

UNDO Retention
04:31

Configuring UNDO Retention
07:03

What is a Transaction
07:10

REDO log files
04:45

UNDO Vs REDO Data
01:36
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,577 Reviews
35,165 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.