The Complete Oracle Sql Development Bootcamp 2021

  1. Home
  2. Oracle-sql
  3. The Complete Oracle Sql Development Bootcamp 2021

Tags: Oracle SQL

From Beginner to Oracle SQL Developer: Get Ready for Oracle Certification Exam 1Z0-071 and Become Oracle SQL Certified

Last updated 2022-01-10 | 4.5

- Master the Contents Required to Pass Oracle SQL Exam 1Z0-071
- The Full Track of Oracle Database SQL 18c
- Have the Ability to Solve any Oracle SQL Problem

What you'll learn

Master the Contents Required to Pass Oracle SQL Exam 1Z0-071
The Full Track of Oracle Database SQL 18c
Have the Ability to Solve any Oracle SQL Problem
Downloading and Installing Oracle Database 18c Express Edition
Installing Oracle SQL Developer
Connecting to the Database using Oracle SQL Developer and SQLPlus
Retrieving Data Using SELECT statement
Restricting and Sorting Data Using WHERE and ORDER BY Clause
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Displaying Data From Multiple Tables Using Joins
Using Subqueries Part I
Using Set Operators
Manipulating Data Using DML Statements Part I
Data Definition Language (DDL) / Creating Tables
Data Dictionary Views
Data Definition Language (DDL) / Creating Views
Data Definition Language (DDL) / Creating Sequences/ Creating Synonyms/ Creating Indexes
Managing Schema Objects
Using Subqueries Part II
Manipulating Data By Using Subqueries
Controlling User Access
Manipulating Data Using DML Statements Part II
Managing Data in Different Time Zones

* Requirements

* No programming experience is required to master the contents of this course

Description

  • Master the Contents Required to Pass Oracle SQL Exam 1Z0-071
  • The Full Track of Oracle Database SQL 18c
  • Have the Ability to Solve any Oracle SQL Problem
  • Downloading and Installing Oracle Database 18c Express Edition
  • Installing Oracle SQL Developer
  • Connecting to the Database using Oracle SQL Developer and SQLPlus
  • Retrieving Data Using SELECT statement
  • Restricting and Sorting Data Using WHERE and ORDER BY Clause
  • Using Single-Row Functions to Customize Output
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data From Multiple Tables Using Joins
  • Using Subqueries Part I
  • Using Set Operators
  • Manipulating Data Using DML Statements Part I
  • Data Definition Language (DDL) / Creating Tables
  • Data Dictionary Views
  • Data Definition Language (DDL) / Creating Views
  • Data Definition Language (DDL) / Creating Sequences/ Creating Synonyms/ Creating Indexes
  • Managing Schema Objects
  • Using Subqueries Part II
  • Manipulating Data By Using Subqueries
  • Controlling User Access
  • Manipulating Data Using DML Statements Part II
  • Managing Data in Different Time Zones

Course content

24 sections • 242 lectures

Introduction 11 lectures

Download the Course Syllabus Preview 00:05

Data and Database Overview Preview 03:11

DBMS and SQL Overview Preview 02:08

Downloading Oracle Database Express Preview 02:33

Installing Oracle Database Express Preview 03:20

Downloading Oracle SQL Developer Preview 01:35

Installing Oracle SQL Developer Preview 01:51

Chapter 1 Quiz 1

Connecting to Oracle Database using Oracle SQL Developer Preview 04:47

View Table Structure and Data Practice Preview 04:09

Connecting to Oracle Database using Oracle SQLPlus Practice Preview 03:18

Using SELECT Statement to Retrieve Data 13 lectures

Writing Basic SELECT Statement Preview 02:53

Writing Basic SELECT Statement Practice Preview 03:27

If you cannot prepare Oracle DB express on your PC!!! Preview 00:06

Arithmetic Operations and Null Values Preview 04:49

Arithmetic Operations and Null Values Practice Preview 02:19

Chapter 2 Quiz 1

Using Column Alias Preview 02:26

Using Column Alias Practice Preview 02:13

Concatenation Operator, Literal Character String and DISTINCT keyword Preview 06:12

Describe Command Preview 01:39

Concatenation Operator, Literal Character String, Distinct and Describe Practice Preview 05:47

Chapter 2 Quiz 2

All Chapter Practices Preview 00:03

Filtering Data 8 lectures

Filtering Data Preview 09:08

Filtering Data Practice Preview 04:36

Comparison Operators Preview 11:24

Comparison Operators Practice Preview 07:37

Logical Operators Preview 08:59

Logical Operators Practice Preview 04:36

Chapter 3 Quiz 1

All Chapter Practices Preview 00:03

Sorting Data 12 lectures

Sorting Data Preview 05:41

Sorting Data Practice Preview 03:32

Chapter 4 Quiz 1

Row Limiting Clause Preview 05:05

Row Limiting Clause Practice Preview 03:05

Chapter 4 Quiz 2

Substitution Variables Preview 07:06

Difference between & and && Practice Preview 03:05

Define and Verify Commands Preview 04:13

Substitution Variables and Verify Practice Preview 08:31

Chapter 4 Quiz 3

All Chapter Practices Preview 00:03

Single Row Functions 12 lectures

SQL Functions Preview 01:39

Character Functions – Case Conversion Functions Preview 05:42

Case Conversion Functions Practice Preview 03:52

Character Functions – Manipulation Functions Preview 10:41

Character Manipulation Functions Practice Preview 06:32

Chapter 5 Quiz 1

Numeric Functions Preview 07:52

Numeric Functions Practice Preview 05:30

Chapter 5 Quiz 2

Date Functions Preview 07:35

Date Functions Practice Preview 02:52

All Chapter Practices Preview 00:03

Conversion and General Functions 12 lectures

Data Type Conversion Preview 06:21

Conversion Functions – TO_CHARE Preview 11:51

TO_CHARE Practice Preview 08:37

Conversion Functions - TO_NUMBER and TO_DATE Preview 07:19

TO_NUMBER and TO_DATE Practice Preview 04:53

Chapter 6 Quiz 1

General Functions - NVL, NVL2, NULLIF and COALESCE Preview 12:17

NVL and NVL2 Practice Preview 04:51

Chapter 6 Quiz 2

General Functions - CASE and DECODE Preview 05:18

CASE and DECODE Practice Preview 02:43

All Chapter Practices Preview 00:03

Group Functions 11 lectures

Using Group Functions Preview 04:52

Using Group Functions Practice Preview 03:12

Distinct and Null Values in Group Functions Preview 04:27

Distinct and Null Values in Group Functions Practice Preview 02:39

Using the GROUP BY clause Preview 06:50

Using Group By Clause Pratice Preview 04:41

Chapter 7 Quiz 1

Using the HAVING clause Preview 06:08

Using the HAVING Clause Practice Preview 04:15

Chapter 7 Quiz 2

All Chapter Practices Preview 00:03

Joins 17 lectures

Join – Overview Preview 05:50

Inner Join – Natural Join Preview 04:45

Inner Join - Natural Join Practice Preview 04:28

Inner Join – Using Clause Preview 05:59

Inner Join – Using Clause Practice Preview 03:47

Inner Join – ON Clause Preview 07:53

Inner Join – ON Clause Practice Preview 02:42

Chapter 8 Quiz 1

Inner Join – Self Join Preview 05:50

Inner Join – Self Join Practice Preview 02:07

Non equijoin Preview 02:45

Outer Join Preview 06:57

Outer Join Practice Preview 03:07

Cross (Cartesian) Join Preview 02:25

Cross Join Practice Preview 01:18

Chapter 8 Quiz 2

All Chapter Practices Preview 00:03

Using Subqueries I 9 lectures

Using Subqueries Preview 04:23

Single Row Subquery Preview 04:01

Single Row Subquery Practice Preview 04:22

Multi Row Subquery Preview 05:56

Multi Row Subquery Practice Preview 03:43

Multi Column Subquery Preview 02:51

Multi Column Subquery Practice Preview 02:43

Chapter 9 Quiz 1

All Chapter Practices Preview 00:03

SET Operators 7 lectures

Set Operators - Overview Preview 03:27

Set Operators – UNION/UNION ALL Preview 03:35

Union/Union All Practice Preview 02:24

Set Operators – INTERSECT/MINUS Preview 06:10

Intersect/Minus Practice Preview 04:53

Chapter 10 Quiz 1

All Chapter Practices Preview 00:03

DML - Data Manipulation Language and TCL – Transaction Control Language 7 lectures

DML – INSERT Statement Preview 09:51

DML – UPDATE Statement Preview 05:59

DML – DELETE Statement Preview 05:31

TCL – Transaction Control Language Preview 13:18

DML and TCL Practice Preview 11:15

Chapter 11 Quiz 1

All Chapter Practices Preview 00:03

DDL - Data Definition Language 19 lectures

DDL – CREATE TABLE Statement Preview 06:17

Columns Data Types Preview 05:34

Create Table Practice Preview 04:45

Table Constraints – NOT NULL and CHECK Preview 06:26

Not Null and Check Constraints Practice Preview 06:11

Table Constraints – UNIQUE and PRIMARY Preview 04:58

Unique and Primary Constraints Practice Preview 07:41

Table Constraints – FOREIGN KEY Preview 05:19

Foreign Key Constraints Practice Part I Preview 06:19

Foreign Key Constraints Practice Part II Preview 07:23

Chapter 12 Quiz 1

CREATE TABLE with Subquery Preview 03:26

Create Table with Subquery Practice Preview 04:44

DDL – ALTER TABLE Statement Preview 05:29

Alter Table Practice Preview 04:35

DDL – DROP TABLE Statement Preview 01:32

Drop Table Practice Preview 01:23

Chapter 12 Quiz 2

All Chapter Practices Preview 00:03

Data Dictionary Views 13 lectures

Data Dictionary – Overview Preview 04:30

Data Dictionary Views– Objects Information Preview 03:15

Use USER_OBJECTS and ALL_OBJECTS Practice Preview 06:15

Data Dictionary Views– Tables Information Preview 02:14

Use USER_TABLES and ALL_TABLE Practice Preview 04:30

Data Dictionary Views– Columns Information Preview 02:51

Use USER_TAB_COLUMNS Practice Preview 05:16

Data Dictionary Views– Constraints Information Preview 06:53

Use USER_CONSTRAINTS and USER_CONS_COLUMNS Practice Preview 07:07

Data Dictionary Views– Comments Preview 04:38

Use USER_TAB_COMMENTS and USER_COL_COMMENTS Practice Preview 03:19

Chapter 13 Quiz 1

All Chapter Practices Preview 00:03

Views 11 lectures

Views Overview Preview 03:46

Create View / Query View Preview 03:59

Create View and Query View Practice Preview 05:30

Modify View Preview 02:55

Modify View Practice Preview 02:35

DML Operations on a View Preview 08:53

DML Operations on a View Practice Preview 06:50

Retrieve VIEW Information / Drop VIEW Preview 01:14

Retrieve VIEW Information and Drop VIEW Practice Preview 01:47

Chapter 14 Quiz 1

All Chapter Practices Preview 00:03

Sequences 8 lectures

Create Sequences Preview 04:40

Create Sequences Practice Preview 03:04

Using Sequences / Modify Sequences Preview 05:35

Using Sequences and Modify Sequences Practice Preview 06:23

View Sequence Information / Drop Sequence Preview 02:07

View Sequence Information and Drop Sequence Practice Preview 02:33

Chapter 15 Quiz 1

All Chapter Practices Preview 00:03

Synonyms 5 lectures

Create Synonym Preview 02:49

Create Synonym Practice Preview 02:45

View Synonym Information / Drop Synonym Preview 02:12

View Synonym Information and Drop Synonym Practice Preview 01:54

All Chapter Practices Preview 00:03

Indexes 6 lectures

Create Index Preview 09:05

Create Index Practice Preview 01:36

View Index Information / Drop Index Preview 02:42

VIew Index Information and Drop Index Practice Preview 05:13

Chapter 17 Quiz 1

All Chapter Practices Preview 00:03

Managing Schema Objects 9 lectures

Managing Constraints Preview 11:57

Managing Constraints Practice Preview 10:36

Chapter 18 Quiz 1

Temporary Table Preview 03:14

Temporary Table Practice Preview 06:41

External Table Preview 06:06

External Table Practice Preview 06:15

Chapter 18 Quiz 2

All Chapter Practices Preview 00:03

Using Subqueries II 12 lectures

Multicolumn Subquery Preview 04:58

Multicolumn Subquery Practice Preview 04:15

Correlated Subquery Preview 14:32

Correlated Subquery Practice Preview 02:20

Chapter 19 Quiz 1

EXISTS and NOT EXISTS Operators Preview 12:21

EXISTS and NOT EXISTS Operators Practice Preview 03:09

Chapter 19 Quiz 2

WITH Clause Preview 06:19

WITH Clause Practice Preview 05:35

Chapter 19 Quiz 3

All Chapter Practices Preview 00:03

Manipulating Data Using Subqueries 6 lectures

Correlated Update Preview 07:47

Correlated Update Practice Preview 04:52

Correlated Delete Preview 05:54

Inline View Preview 05:24

Chapter 20 Quiz 1

All Chapter Practices Preview 00:03

Controlling User Access 11 lectures

Privileges Overview Preview 02:03

System Privileges Preview 04:28

System Privileges Practice Preview 10:51

Object Privileges Preview 07:35

Object Privileges Practice Preview 06:11

Chapter 21 Quiz 1

Roles Preview 03:24

Roles Practice Preview 05:26

Revoke Privileges Preview 02:06

Revoke Privileges Practice Preview 06:48

All Chapter Practices Preview 00:03

Manipulating Data – DML II 14 lectures

MERGE Statement Preview 08:06

Merge Statement Practice Preview 06:48

Multitable Insert - Overview Preview 01:09

Multitable Insert - Unconditional INSERT ALL Preview 04:35

Unconditional Insert All Practice Preview 04:28

Multitable Insert - Conditional INSERT ALL Preview 05:16

Multitable Insert - Conditional INSERT FIRST Preview 04:59

Conditional Insert First Practice Preview 04:51

Multitable Insert - Pivoting INSERT Preview 07:18

Chapter 22 Quiz 1

FLASHBACK Table Statement/Drop Preview 06:44

FLASHBACK Query Preview 04:06

Flashback Practice Preview 07:25

All Chapter Practices Preview 00:03

Managing Data in Different Time Zones 8 lectures

Time Zone Overview Preview 06:32

Time Zone Practice Preview 06:23

INTERVAL Data Types Preview 04:48

Interval Data Types Practice Preview 05:18

Other Time Functions Preview 07:39

Other Time Functions Practice Preview 02:38

Chapter 23 Quiz 1

All Chapter Practices Preview 00:03

Practice Test 1 lectures

Practice Test