HOT
blank

Become an Oracle Database Administrator (DBA)

Development

Rating4.1
Enroll Now

Become an Oracle Database Administrator (DBA), available at $59.99, has an average rating of 4.1, with 73 lectures, based on 162 reviews, and has 2485 subscribers.

You will learn about 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 This course is ideal for individuals who are College students or IT Professionals who want to become a DBA or Aspiring database administrators(DBA) or Data Analyst or Data warehouse professionals or Fresh graduates who are looking for a job in the IT industry. or Anyone who wants to explore a career in Database Administration It is particularly useful for College students or IT Professionals who want to become a DBA or Aspiring database administrators(DBA) or Data Analyst or Data warehouse professionals or Fresh graduates who are looking for a job in the IT industry. or Anyone who wants to explore a career in Database Administration.

Enroll now: Become an Oracle Database Administrator (DBA)

Summary

Title: Become an Oracle Database Administrator (DBA)

Price: $59.99

Average Rating: 4.1

Number of Lectures: 73

Number of Published Lectures: 73

Number of Curriculum Items: 73

Number of Published Curriculum Objects: 73

Original Price: $139.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

  • 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

Target Audiences

  • 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

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.

Course Curriculum

Chapter 1: Installing your Oracle Software and Tools Used to Administer an Oracle Database

Lecture 1: Introduction

Lecture 2: Responsibilities of a DBA

Lecture 3: Responsibilities of Oracle Database Developer

Lecture 4: Oracle Database Hardware Preinstallation Requirements

Lecture 5: Oracle Database Software Preinstallation Requirements

Lecture 6: Download Oracle Database

Lecture 7: Install Oracle Database

Lecture 8: Unlock Hr Schema Account

Lecture 9: Download and Install java JDK

Lecture 10: Download Oracle SQL Developer

Lecture 11: Install Oracle SQL Developer

Lecture 12: Launching Oracle SQL Developer

Lecture 13: Download TOAD

Lecture 14: Install TOAD

Lecture 15: Connect TOAD to Oracle Database

Lecture 16: Using SQLPLUS

Chapter 2: Monitoring a Database

Lecture 1: Introduction

Lecture 2: Monitoring and viewing a Database Session

Lecture 3: Monitoring Top SQL Statements

Lecture 4: Monitoring Long Operations

Chapter 3: Exporting and Importing Metadata and Data

Lecture 1: Exporting and Importing Meta Data and Data with Oracle SQL Developer

Lecture 2: Importing Metadata and Data Using a Script File

Lecture 3: Exporting Data to Microsoft Excel File

Lecture 4: Importing Data from Microsoft Excel File

Chapter 4: Managing Oracle Database Accounts

Lecture 1: Types of Oracle Database Users

Lecture 2: How to create new user with DBA Priviledges

Lecture 3: Predefined Administrative Accounts

Lecture 4: Operating System Accounts: SYSDBA Vs SYSOPER

Chapter 5: Analytic Functions

Lecture 1: Analytic Function Introduction

Lecture 2: Syntax

Lecture 3: Partition By Clause

Lecture 4: Order By Clause

Lecture 5: Dense Rank

Lecture 6: First and Last Function

Lecture 7: LAG Function

Lecture 8: LEAD Function

Lecture 9: LISTAGG Function

Lecture 10: RANK Function

Lecture 11: ROW Number Function

Lecture 12: What is a Windowing clause

Lecture 13: Default Windowing Clause

Lecture 14: Using Rows with Windowing Clause

Lecture 15: Using Range with Windowing Clause

Lecture 16: Using Between with Windowing Clause

Lecture 17: Multiple Window into Your Data

Chapter 6: Backing Up and Recovering Data

Lecture 1: Introduction

Lecture 2: Enabling ARCHIVELOG Mode

Lecture 3: Backing Up the Database

Lecture 4: Restoring and Recovering the Database

Lecture 5: Viewing and Restoring Historical Data with Flashback Query

Lecture 6: Recovering Dropped Tables

Chapter 7: Managing the Oracle Database Instance

Lecture 1: How to ShutDown a Database

Lecture 2: How to start up a Database

Lecture 3: How to check Database version with Oracle SQL Developer

Lecture 4: How to identify Oracle Database Release Number

Lecture 5: What is a Schema

Lecture 6: What is a Tablespace

Lecture 7: How to create a Tablespace – Part 1

Lecture 8: How to create a Tablespace – Part 2

Chapter 8: Managing Users and Securing the Database

Lecture 1: Establishing Security Policy on a Database

Lecture 2: Privileges and Roles

Lecture 3: Managing oracle database users

Lecture 4: How to create a new database user

Lecture 5: Auditing Database activities

Lecture 6: Predefined oracle database accounts

Chapter 9: Managing UNDO Data

Lecture 1: What is UNDO Data

Lecture 2: UNDO Tablespace

Lecture 3: UNDO Retention

Lecture 4: Configuring UNDO Retention

Lecture 5: What is a Transaction

Lecture 6: REDO log files

Lecture 7: UNDO Vs REDO Data

Lecture 8: Thank You

Instructors

Rating Distribution

  • 1 stars: 6 votes
  • 2 stars: 10 votes
  • 3 stars: 32 votes
  • 4 stars: 54 votes
  • 5 stars: 60 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!

You may also like

Top 10 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024