Oracle Database: Become Oracle Database Administrator DBA
4.3 (59 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
451 students enrolled

Oracle Database: Become Oracle Database Administrator DBA

Learn Oracle Database Administration become Oracle Database Administrator Oracle DBA and get six figures jobs as DBA
4.3 (59 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
451 students enrolled
Created by Oak Academy
Last updated 6/2020
English
English [Auto]
Current price: $113.99 Original price: $189.99 Discount: 40% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 1 article
  • 38 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You would be able to install the necessary Oracle Software/Database
  • Creating and Starting Oracle Database
  • Creating A New Database User
  • Database Concepts And Fundamentals
  • Creating Tables
  • Inserting, Updating and Deleting Data In The Table
  • Retrieving Data From Table
  • Filtering Result Set
  • Sorting Data
  • Limiting Result Set
  • Using Ampersand Subtition To Make More Dynamic Queries
  • Single Row Functions
  • Reporting Aggregated Data
  • Table Joins
  • Using Subqueries
  • Exists And Not Exists
  • Using Set Operators
  • Managing Schema Objects
  • Dictionary Views To Manage Schema Objects
  • Controlling User Access In Oracle
  • Manipulating Large Datasets
  • Let's start and I will take you step by step into the DBA world
Course content
Expand all 64 lectures 06:52:44
+ Installation of Oracle Database on Linux
9 lectures 37:20
Download Virtualbox
00:54
Download Linux
03:39
Download Oracle Software
01:20
Install Virtualbox
01:35
Create Virtual Machine
01:09
Install Linux
08:11
Prerequests
11:02
Oracle Software Installation
06:31
Create Database
02:59
+ After Installations
2 lectures 06:54
Startup & Shutdown Instance From Client
05:34
Connect Database From Client
01:20
+ Database and RDBMS Concepts
1 lecture 16:08
Learn Data, Database and RDBMS Concepts
16:08
+ DDL ( Data Definition Language )
9 lectures 24:20
What is DDL?
00:58
Connect and Start to Create Objects
03:36
Create Tablespace
01:37
Create User
01:42
Create Table
03:31
Create Synonym
02:22
Alter Objects
03:30
Drop Objects
03:13
Section Practice
03:51
+ DML ( Data Manipulating Language ) and TCL ( Transaction Control Language )
4 lectures 16:01
DML and TCL
01:02
Insert Data to Table
04:55
Update Table Data
04:32
Delete from Table
05:32
+ Retrieving, Restricting and Reporting Data
16 lectures 02:37:31
Basic Select Statement
17:23
"Like" Operator
04:32
Sorting Data
05:11
Limiting The Resultset
06:15
Using Ampersand (&) Subtition
04:22
Single Row Operators
03:49
Single Row Functions
17:30
Conversion Functions
13:48
Using Group Functions
10:40
Restricting Reported Data
02:15
Joining Tables
30:10
Using Subqueries
21:54
Exists And Not Exists
03:41
"With" Clause
03:50
Using The Set Operators
07:32
What We Have Learned?
04:39
+ Schema Objects And Managing Schema
3 lectures 59:59
Schema Objects With SQL Developer
53:02
Using Dictionary Views To Manage Schema
05:43
What We Have Learned In This Section?
01:14
+ Controlling User Access
2 lectures 14:33
Controlling User Access
13:49
Section Summary
00:44
Requirements
  • No prior knowledge is required!
  • Basic Computer Knowledge
  • Desire to learn Oracle Database Administration
  • We prefered Windows OS , but this is not mandatory. You can prefer to use other Operating Systems
  • Nothing else! It’s just you, your computer and your ambition to get started today
  • LIFETIME ACCESS, course updates, new content, anytime, anywhere, on any device
  • This is one of the most amazing Udemy courses in Oracle SQL
Description

Hello there,

Welcome to Oracle Database: Become Oracle Database Administrator DBA course.

This Oracle DBA course is one of the most awesome Udemy courses which teach step by step and follow methodology in introducing concepts and demos ( Learn by doing ) to the students so that they can learn with ease Oracle Database Administration.

In this course you will learn;

  • Downloading Oracle Software,

  • Database and RDBMS Concepts,

  • DML ( Data Manipulating Language ) and TCL ( Transaction Control Language ),

  • Retrieving Data,

  • Restricting And Sorting Data,

  • Using Single Row Functions and Customize Output,

  • Using Conversion Functions and Conditional Expressions,

  • Reporting Aggregated Data Using The Group Functions,

  • Defining Table Joins and Displaying Data from multiple Tables,

  • Using Subqueries,

  • Using The Set Operators,

  • Schema Objects And Managing Schema,

  • Controlling User Access,

  • Manipulating Large Data Sets and more!

Why would you want to take this course?

Our answer is simple: The quality of teaching.

When you enroll, you will feel the OAK Academy`s seasoned developers expertise.

No Previous Knowledge is needed!

This course will take you from a beginner to a more experienced level.

If you are new to Oracle Database, or have no idea about what a DBA does no problem, you will learn anything you need to start Oracle Database.

If you are a DBA or familiar to the Oracle Database / Oracle SQL  and you just need a refresher, you are also in the right place. You will learn step by step with hands-on examples.

Fresh Content

You will find DBA's in almost every organization/business, to maintain the organization's database. Becoming a DBA is totaly depends on the knowledge you have in the overall architecture of Oracle Database. It’s no secret how technology is advancing at a rapid rate. New tools are released every day, Oracle updates its system, and it’s crucial to stay on top of the latest knowledge. With this course you will always have a chance to follow latest trends.

Video and Audio Production Quality

All our contents are created/produced as high quality video/audio to provide you the best learning experience.

You will be,

· Seeing clearly

· Hearing clearly

· Moving through the course without distractions

You'll also get:

✔ Lifetime Access to The Course

✔ Fast & Friendly Support in the Q&A section

✔ Udemy Certificate of Completion Ready for Download

Dive in now!

We offer full support, answering any questions.

See you in the course!

Who this course is for:
  • Anyone who wants to become an Oracle DBA
  • Anyone who plans a career in Oracle Data Administration
  • Software developers whom want to increase SQL knwoledge
  • Anyone who are studying Oracle 1Z0-071 Exams
  • Anyone who are junior Oracle DBA's
  • Anyone who are manage RDBMS and want to immigrate Oracle