Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Oracle Database Administrator DBA
Getting Started to Oracle DBA
Project Files and Course Documents - Oracle Database Administration DBA
What We Will Learn in this Oracle Database Administrator DBA? (3:33)
Oracle Database Setting Up
Downloading Oracle Software (3:53)
Extracting Files Oracle database administration (0:29)
Installing Oracle 12c Database (3:59)
Startup Instance on Windows Oracle database administration (3:23)
Oracle database administration Shutdown Instance (3:00)
Make SQL Developer Run Faster (1:48)
Oracle Live SQL (3:42)
Quiz
Installation of Oracle Database on Linux
Download Linux (3:39)
Download Virtualbox - Oracle database administration (0:54)
Download Oracle Software (1:21)
Install Virtualbox (1:35)
Create Virtual Machine (1:09)
Install Linux (8:11)
Oracle dba Prerequests (11:02)
Oracle Software Installation (6:31)
Create Database (3:00)
Quiz
After Installations in Oracle DBA
Startup & Shutdown Instance From Client (5:34)
Oracle dba Connect Database From Client (1:20)
Quiz
Database and RDBMS Concepts
Learn Data, Database and RDBMS Concepts (16:08)
Quiz
DDL ( Data Definition Language )
Connect and Start to Create Objects (3:34)
What is DDL? (0:57)
Create Tablespace (1:37)
Create User (1:40)
Create Table (3:31)
Create Synonym (2:22)
Alter Objects (3:30)
Drop Objects (3:13)
Section Practice (3:51)
Quiz
DML ( Data Manipulating Language ) and TCL ( Transaction Control Language )
Insert Data to Table (4:55)
DML and TCL (1:02)
Update Table Data (4:27)
Delete from Table (5:32)
Quiz
Retrieving, Restricting and Reporting Data
"Like" Operator (4:32)
Basic Select Statement (17:23)
Sorting Data (5:11)
Limiting The Resultset (6:15)
Using Ampersand (&) Subtition (4:22)
Single Row Operators (3:49)
Single Row Functions (17:30)
Conversion Functions (13:48)
Using Group Functions (10:41)
Restricting Reported Data (2:15)
Joining Tables (30:10)
Using Subqueries (21:54)
Exists And Not Exists (3:41)
"With" Clause (3:51)
Using The Set Operators (7:32)
What We Have Learned in this Oracle Database Administration dba course? (4:40)
Quiz
Schema Objects And Managing Schema
Schema Objects With SQL Developer (53:02)
Using Dictionary Views To Manage Schema (5:43)
What We Have Learned In This Section? (1:14)
Quiz
Controlling User Access
Section Summary (0:44)
Controlling User Access (13:49)
Quiz
Manipulating Large Data Sets
Manipulating Large Data Sets (15:42)
Section Summary (1:19)
Quiz
Oracle Database Administration Tips & Tricks
Monthly Controls (7:54)
First Controls of Day in Oracle Database (6:35)
Useful Scripts Usage (4:16)
Opatch-AWR-ASH (5:30)
ORA Errors Solutions (7:06)
Oracle Database Administration Tips & Tricks
Homework
Be Ready For The Homework (4:06)
What is Next?
What should be the next step to become DBA? (1:56)
Using The Set Operators
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock