Oracle DBA 19c

Name: Oracle DBA 19c
Rating: 4.0 (44 reviews)

Introduction to Oracle 19c Database

Created bySam Dhanasekaran

Last updated 8/2019

English

What you'll learn

Installing Oracle 19c on a Windows 10 PC
Oracle DBA Concepts
Oracle Schema Objects
Database, DBMS and RDBMS
Tables, Indexes, Procedures, Packages, Triggers, Sequences, Synonyms, SQL etc

Course content

6 sections • 53 lectures • 2h 54m total length

Introduction1:48
What is the purpose of this course? This lecture introduces the course to you Oracle 19c and its concepts.

What is a Database3:16
In this lecture, we will understand the definition of Data as well as Database. Data are stored in structured sets such as Tables which are stored in Database
What is a DBMS3:23
A DBMS or a Database Management System is a system that provides access to the database. IBM defines it as a computerized data-keeping system. A DBMS defines how the data is stored and accessed.
Where does the data get stored?1:23
Where does the data get stored? Data gets stored in a type of an object called TABLE. This is where an user can insert data, modify it as well as delete it. Besides there are other objects which can hold supporting data, which we will take a look at in the subsequent lessons.
What is a Table?8:28
What is a Data Block?6:27
Physical Storage Architecture5:32
Installing Oracle creates the executable files and the data files in the hard disk. This lecture explains about it.
Logical Storage Structure - Users, Roles and Tablespaces7:49
This lecture explains about the logical storage structures of an Oracle Database. User, Roles and Tablespaces are discussed in this video
What is a Schema5:17
A schema is an user account used for storing objects such as tables. It is not tied to any user.
GRANTS and REVOKES3:55
This lecture explains about how to provide the access rights
Client Server Architecture - Intro2:22
This video explains about the client server architecture
Types of Clients4:02
This video explains about the types of clients
Quick overview of Oracle RDBMS Architecture5:18
This video gives you a quick overview of Oracle RDBMS Architecture
Connecting to an Oracle Database2:25

Instance vs Database6:58
This video will explain you the difference between an Oracle Instance and Oracle Database
Installation Concepts2:36
This video explains about the concept of installation
Files1:28
This video explains about how the files are stored.
Starting a Database2:46
This video explains about the concept behind starting a database
Basics of Computing5:32
This video explains about the basics of computing
Client Server Architecture - In Depth8:45
This video explains about the Client Server Architecture in detail
Program Global Area5:22
This video explains about the Program Global Area.
Dedicated Server Mode1:51
This video explains about Dedicated Server mode
Shared Server Mode9:26
This video explains about Shared Server mode

Installing Oracle 19c on a Windows 10 PC7:25
This video explains about how to download and install Oracle 19c on a Windows 10 PC
Connecting to an Oracle Database - After Installation4:18
This video explains about making the first connection to the newly installed database
Connecting as SYSDBA - Shutdown and Startup3:26
This video explains about how to connect as SYSDBA. The it also explains about stopping and starting a database
Installing SQL Developer 19.2 on a Windows PC5:11
This video explains about how to install SQL Developer in a Windows PC

What is a Table?1:59
Explains about TABLE
Data Types2:01
Explains about Data Types
Basics of a SELECT Statement2:38
Explains about the SELECT statement
Describe1:43
Explains about the DESC statement
SELECT COUNT0:46
Explains about SELECT COUNT
DBA Tablespaces1:01
Explains about DBA_TABLESPACES
Selecting Particular Columns1:46
How to select particular columns
Filtering the results - Basic WHERE Clause2:22
Explains about WHERE clause
Oracle Database User Architecture5:58
Explains about Oracle Database User Architecture
Schema vs User0:45
Explains the difference between Schema and User
How Objects are Stored1:03
Explains about the storage behind the objects
Accessing the Objects0:54
Explains about accessing the objects
SQL Commands Classification2:53
Types of SQL Commands
Create a Table1:22
How to create a Table.
Create an User2:30
Basics of DML1:35
Gives you the basics of a DML
DML - SELECT0:36
About the SELECT statement
DML - INSERT1:39
About INSERT statement
DBA INFO - METADATA1:11
About METADATA
DBA Info - Data Dictionary0:34
About Data Dictionary
DBA Info - Default Permanent Tablespace3:12
About Default Permanent Tablespace
DML - Fixing the failed INSERT0:28
Explains about Fixing the failed INSERT
Demo of a Transaction2:06
Gives you a demo of a transaction
Handling a Transaction through REDO3:41
Explains about the REDO process
Handling a Transaction - UNDO3:07
Explains about the UNDO process

Requirements

Basic Computer knowledge

Description

An introductory course about Oracle 19c Database from Oracle. Oracle has been the leading RDBMS vendor in the world. With the industry going towards Data Science and Artificial Intelligent, Database Management is a highly sought after skill. This course will introduce you to RDBMS concepts and also how to install Oracle 19c in a Windows 10 PC. This will also introduce you to Oracle DBA also known as Oracle Database Administration

Who this course is for:

Beginners aspiring to learn Oracle DBA
Beginners aspiring to learn Database Concepts
Students who are interested in learning Oracle 19c
Students who are interested in becoming Oracle DBA or Oracle Developer

Oracle DBA 19c

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

RDBMS Concepts13 lectures • 1hr

General Architecture - Common for Oracle 12c, Oracle 18c and Oracle 19c9 lectures • 45min

LAB - Hands On4 lectures • 20min

Additional Core SQL Concepts - (Common for Oracle 12c, Oracle 18c and Oracle 19c25 lectures • 48min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: