Become Oracle Dbalearn Database Administration From Scratch

Learn Oracle Database Administration become Oracle Database Administrator, Oracle DBA and get six figures jobs as DBA

Last updated 2022-01-10 | 4.4

- You would be able to install the necessary Oracle Software/Database
- Creating and Starting Oracle Database
- Creating A New Database User

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

* 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

  • 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

15 sections • 68 lectures

What We Will Learn? Preview 03:33

Project Files and Course Documents Preview 00:06

Downloading Oracle Software Preview 03:53

Extracting Files Preview 00:29

Installing Oracle 12c Database Preview 03:59

Startup Instance on Windows Preview 03:23

Shutdown Instance Preview 03:00

Make SQL Developer Run Faster Preview 01:48

Oracle Live SQL Preview 03:42

Download Virtualbox Preview 00:54

Download Linux Preview 03:39

Download Oracle Software Preview 01:20

Install Virtualbox Preview 01:35

Create Virtual Machine Preview 01:09

Install Linux Preview 08:11

Prerequests Preview 11:02

Oracle Software Installation Preview 06:31

Create Database Preview 02:59

Startup & Shutdown Instance From Client Preview 05:34

Connect Database From Client Preview 01:20

Learn Data, Database and RDBMS Concepts Preview 16:08

Quiz

What is DDL? Preview 00:58

Connect and Start to Create Objects Preview 03:36

Create Tablespace Preview 01:37

Create User Preview 01:42

Create Table Preview 03:31

Create Synonym Preview 02:22

Alter Objects Preview 03:30

Drop Objects Preview 03:13

Section Practice Preview 03:51

Basic Select Statement Preview 17:23

"Like" Operator Preview 04:32

Sorting Data Preview 05:11

Limiting The Resultset Preview 06:15

Using Ampersand (&) Subtition Preview 04:22

Single Row Operators Preview 03:49

Single Row Functions Preview 17:30

Conversion Functions Preview 13:48

Using Group Functions Preview 10:40

Restricting Reported Data Preview 02:15

Joining Tables Preview 30:10

Using Subqueries Preview 21:54

Exists And Not Exists Preview 03:41

"With" Clause Preview 03:50

Using The Set Operators Preview 07:32

What We Have Learned? Preview 04:39

Quiz

Schema Objects With SQL Developer Preview 53:02

Using Dictionary Views To Manage Schema Preview 05:43

What We Have Learned In This Section? Preview 01:14

First Controls of Day Preview 06:35

Monthly Controls Preview 07:54

Useful Scripts Usage Preview 04:16

Opatch-AWR-ASH Preview 05:30

ORA Errors Solutions Preview 07:06

Be Ready For The Homework Preview 04:06

What should be the next step to become DBA? Preview 01:56