Tutorialspoint

Mid-Year Savings Flat 10% OFF, Use Code: MID10

Oracle DB Online Training Course

person icon Tutorialspoint

4.6

Oracle DB Online Training Course

Master Oracle DB from basics to advanced with a comprehensive online course

updated on icon Updated on Jul, 2024

language icon Language - English

person icon Tutorialspoint

English [CC]

category icon Databases,Oracle

Lectures -42

Duration -8.5 hours

4.6

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Oracle Database is a relational database management system (RDBMS) that is used by businesses of all sizes. It is a powerful and scalable database that can handle large amounts of data.

Oracle DB Online Training Overview

Oracle DB Online Training course will teach you everything you need to know to master Oracle Database. You will get started with the basics of Oracle Database and learn the Oracle SQL language. The course will also introduce you to Oracle PL/SQL along with Oracle administration and security.

The course walks you through the Oracle Database-based applications such as ERP systems, and CRM systems. By the end of the course, you will learn how to build your own Oracle Database applications and contribute to open-source projects.

This course is perfect for:

  • Anyone who wants to learn Oracle Database

  • Database administrators

  • Developers

  • Business analysts

  • Anyone who wants to work with Oracle Database

Goals

  • Understand the fundamentals of Oracle Database

  • Learn the basic functionality of Oracle Database Server and Oracle Database Client

  • Learn how to create an Oracle Database

  • Maintain and manipulate the Oracle Database

  • Understand Data Dictionary and its applications

Prerequisites

  • Basic programming skills

  • Familiarity with SQL language

Oracle DB Online Training Course

Curriculum

Check out the detailed breakdown of what’s inside the course

Oracle DB Online Training
41 Lectures
  • play icon Oracle DB - Overview 08:44 08:44
  • play icon Oracle DB - Installation 36:19 36:19
  • play icon Oracle DB - Physical Architecture 05:43 05:43
  • play icon Oracle DB - Memory Architecture 06:48 06:48
  • play icon Oracle DB - SGA Components 25:31 25:31
  • play icon Oracle DB - Process 15:00 15:00
  • play icon Oracle DB - Logical Architecture 03:24 03:24
  • play icon Oracle DB - SPFILE & PFILE 23:43 23:43
  • play icon Oracle DB - Startup & Shutdown 11:54 11:54
  • play icon Oracle DB - Alert Log, Trace Files & ADR 02:19 02:19
  • play icon Oracle DB - Dynamic Performance View & Data Dictionary 04:07 04:07
  • play icon Oracle DB - Net Services 01:35 01:35
  • play icon Oracle DB - Configuring & Managing the Oracle Network 18:14 18:14
  • play icon Oracle DB - Dedicated & Shared Server Process 04:36 04:36
  • play icon Oracle DB - Storage Structure 05:29 05:29
  • play icon Oracle DB - Table Space Data Files 37:38 37:38
  • play icon Oracle DB - Manage Files (OMF) 05:18 05:18
  • play icon Oracle DB - User Management 07:13 07:13
  • play icon Oracle DB - Profile 10:23 10:23
  • play icon Oracle DB - Privilege 11:49 11:49
  • play icon Oracle DB - Roles 05:38 05:38
  • play icon Oracle DB - SQL Commands 16:24 16:24
  • play icon Oracle DB - Constraint 10:02 10:02
  • play icon Oracle DB - Views 08:31 08:31
  • play icon Oracle DB - Sequence 10:43 10:43
  • play icon Oracle DB - Synonyms 02:53 02:53
  • play icon Oracle DB - Introduction to Oracle PLSQL 08:57 08:57
  • play icon Oracle DB - Stored Procedure & Function 13:34 13:34
  • play icon Oracle DB - Deadlock 02:09 02:09
  • play icon Oracle DB - Undo Data 08:15 08:15
  • play icon Oracle DB - Retention Guarantee in Undo 04:55 04:55
  • play icon Oracle DB - What is ORA-01555 02:13 02:13
  • play icon Oracle DB - Multiplexing Redo Log Files 05:18 05:18
  • play icon Oracle DB - No Archive log & Archive log Mode 07:43 07:43
  • play icon Oracle DB - Multiplexing Control Files 07:58 07:58
  • play icon Oracle DB - SQL Loader 31:14 31:14
  • play icon Oracle DB - Data Pump 16:34 16:34
  • play icon Oracle DB - Categories of Failure 07:15 07:15
  • play icon Oracle DB - Backup Concept 52:31 52:31
  • play icon Oracle DB - Recovery Catalog 10:38 10:38
  • play icon Oracle DB - Restore & Recovery 38:18 38:18

Instructor Details

Tutorialspoint

Tutorialspoint

Simple and Easy Learning


Tutorials Point originated from the idea that there exists a class of readers who respond better to online content and prefer to learn new skills at their own pace from the comforts of their drawing rooms.

The journey commenced with a single tutorial on HTML in 2006 and elated by the response it generated, we worked our way to adding fresh tutorials to our repository which now proudly flaunts a wealth of tutorials and allied articles on topics ranging from programming languages to web designing to academics and much more.

40 million readers read 100 million pages every month

Our Text Library Content and resources are freely available and we prefer to keep it that way to encourage our readers acquire as many skills as they would like to. We don't force our readers to sign up with us or submit their details either to use our Free Text Tutorials Library. No preconditions and no impediments, Just Simply Easy Learning!

We have established a Digital Content Marketplace to sell Video Courses and eBooks at a very nominal cost. You will have to register with us to avail these premium services.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515