The Complete Oracle SQL Bootcamp 2021

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

Created by : Rated :4.1 92384 views

Last Updated: 2022-05-03 11:05:57 English Course Type: Self Learning

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

Welcome to the Complete Oracle SQL Bootcamp 2021.

If you want to get ready and become a professional Oracle SQL Developer and Prepare for an Oracle SQL Certification Exam 1Z0-071: Oracle Certified Associate (OCA), then this course is the best for you.

Do you want to get a better job?

Are you bored with watching a lot of stuff, but could not learn anything?

Are you looking for a really professional course?

Then this is best Oracle SQL course you are looking for.

You have come to the right place!

If you are new to Oracle SQL, no problem! You can easily learn with all the details of SQL. If you already know SQL and want to improve you skills, this course explains all the details including all of the subjects.

Get this course, and go get a better job!

In this course, all the subjects are explained in a professional way.

All practices and solutions are in the lessons. you can pause the video and complete the practice before resuming to watch the solution. Make sure you solve the practice on your own before moving on to the solution!

Topics covered in this course:

Downloading and installing Oracle database express 18c in details
Downloading and installing Oracle SQL Developer
Connecting to Oracle Database using SQL Developer and SQLPlus
Retrieving data using the select statement
Restricting / Filtering Data
Sorting Data
Using Substitution Variables
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Displaying Data from multiple tables using joins
Using Subqueries to Solve Queries Part I
Using the Set Operators
Manipulating tables using DML Statements ( Insert, Update, Delete )
Using Data Definition Language / Creating tables
Managing objects with data dictionary views
Creating Views in details
Creating sequences, synonyms, and indexes
Managing Schema Objects
Retrieving Data By Using Subqueries Part II
Manipulating Data By Using Subqueries
Controlling User Access in details
Manipulating Data using DML Part II
Managing Data in Different Time Zones

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

Students willing to get into Oracle SQL or software development career
Students willing to Master Oracle SQL and get a job as a well paid Oracle SQL Developer
Students willing to work hard in mastering the SQL language
Students who wants to be expert in oracle database SQL 18c and interested in passing Oracle SQL 1Z0-071 exam!

Section 1 : Introduction 11 Lectures 00:13:39
Lecture 1 :
Download the Course Syllabus Preview
Lecture 2 :
Data and Database Overview
Lecture 3 :
DBMS and SQL Overview
Lecture 4 :
Downloading Oracle Database Express
Lecture 5 :
Installing Oracle Database Express
Lecture 6 :
Downloading Oracle SQL Developer
Lecture 7 :
Installing Oracle SQL Developer
Lecture 8 :
Chapter 1 Quiz 1
Chapter 1 Quiz 1
Lecture 9 :
Connecting to Oracle Database using Oracle SQL Developer
Lecture 10 :
View Table Structure and Data Practice
Lecture 11 :
Connecting to Oracle Database using Oracle SQLPlus Practice
Section 2 : Using SELECT Statement to Retrieve Data 13 Lectures 00:14:34
Lecture 1 :
Writing Basic SELECT Statement
Lecture 2 :
Writing Basic SELECT Statement Practice
Lecture 3 :
If you cannot prepare Oracle DB express on your PC!!!
Lecture 4 :
Arithmetic Operations and Null Values
Lecture 5 :
Arithmetic Operations and Null Values Practice
Lecture 6 :
Chapter 2 Quiz 1
Chapter 2 Quiz 1
Lecture 7 :
Using Column Alias
Lecture 8 :
Using Column Alias Practice
Lecture 9 :
Concatenation Operator, Literal Character String and DISTINCT keyword
Lecture 10 :
Describe Command
Lecture 11 :
Concatenation Operator, Literal Character String, Distinct and Describe Practice
Lecture 12 :
Chapter 2 Quiz 2
Chapter 2 Quiz 2
Lecture 13 :
All Chapter Practices
Section 3 : Filtering Data 8 Lectures 00:30:20
Lecture 1 :
Filtering Data
Lecture 2 :
Filtering Data Practice
Lecture 3 :
Comparison Operators
Lecture 4 :
Comparison Operators Practice
Lecture 5 :
Logical Operators
Lecture 6 :
Logical Operators Practice
Lecture 7 :
Chapter 3 Quiz 1
Chapter 3 Quiz 1
Lecture 8 :
All Chapter Practices
Section 4 : Sorting Data 12 Lectures 00:26:42
Lecture 1 :
Sorting Data
Lecture 2 :
Sorting Data Practice
Lecture 3 :
Chapter 4 Quiz 1
Chapter 4 Quiz 1
Lecture 4 :
Row Limiting Clause
Lecture 5 :
Row Limiting Clause Practice
Lecture 6 :
Chapter 4 Quiz 2
Chapter 4 Quiz 2
Lecture 7 :
Substitution Variables
Lecture 8 :
Difference between & and && Practice
Lecture 9 :
Define and Verify Commands
Lecture 10 :
Substitution Variables and Verify Practice
Lecture 11 :
Chapter 4 Quiz 3
Chapter 4 Quiz 3
Lecture 12 :
All Chapter Practices
Section 5 : Single Row Functions 11 Lectures 00:37:21
Lecture 1 :
SQL Functions
Lecture 2 :
Character Functions – Case Conversion Functions
Lecture 3 :
Case Conversion Functions Practice
Lecture 4 :
Character Functions – Manipulation Functions
Lecture 5 :
Character Manipulation Functions Practice
Lecture 6 :
Numeric Functions
Lecture 7 :
Numeric Functions Practice
Lecture 8 :
Date Functions
Lecture 9 :
Date Functions Practice
Lecture 10 :
All Chapter Practices
Lecture 11 :
Chapter 5 Quiz 1
Chapter 5 Quiz 1
Section 6 : Conversion and General Functions 12 Lectures 00:40:40
Lecture 1 :
Data Type Conversion
Lecture 2 :
Conversion Functions – TO_CHARE
Lecture 3 :
TO_CHARE Practice
Lecture 4 :
Conversion Functions - TO_NUMBER and TO_DATE
Lecture 5 :
TO_NUMBER and TO_DATE Practice
Lecture 6 :
Chapter 6 Quiz 1
Chapter 6 Quiz 1
Lecture 7 :
General Functions - NVL, NVL2, NULLIF and COALESCE
Lecture 8 :
NVL and NVL2 Practice
Lecture 9 :
Chapter 6 Quiz 2
Chapter 6 Quiz 2
Lecture 10 :
General Functions - CASE and DECODE
Lecture 11 :
CASE and DECODE Practice
Lecture 12 :
All Chapter Practices
Section 7 : Group Functions 10 Lectures 00:21:06
Lecture 1 :
Using Group Functions
Lecture 2 :
Using Group Functions Practice
Lecture 3 :
Distinct and Null Values in Group Functions
Lecture 4 :
Distinct and Null Values in Group Functions Practice
Lecture 5 :
Using the GROUP BY clause
Lecture 6 :
Using Group By Clause Pratice
Lecture 7 :
Using the HAVING clause
Lecture 8 :
Using the HAVING Clause Practice
Lecture 9 :
Chapter 7 Quiz 1
Chapter 7 Quiz 1
Lecture 10 :
All Chapter Practices
Section 8 : Joins 17 Lectures 00:08:15
Lecture 1 :
Join – Overview
Lecture 2 :
Inner Join – Natural Join
Lecture 3 :
Inner Join - Natural Join Practice
Lecture 4 :
Inner Join – Using Clause
Lecture 5 :
Inner Join – Using Clause Practice
Lecture 6 :
Inner Join – ON Clause
Lecture 7 :
Inner Join – ON Clause Practice
Lecture 8 :
Chapter 8 Quiz 1
Chapter 8 Quiz 1
Lecture 9 :
Inner Join – Self Join
Lecture 10 :
Inner Join – Self Join Practice
Lecture 11 :
Non equijoin
Lecture 12 :
Outer Join
Lecture 13 :
Outer Join Practice
Lecture 14 :
Cross (Cartesian) Join
Lecture 15 :
Cross Join Practice
Lecture 16 :
Chapter 8 Quiz 2
Chapter 8 Quiz 2
Lecture 17 :
All Chapter Practices
Section 9 : Using Subqueries I 9 Lectures 00:09:56
Lecture 1 :
Using Subqueries
Lecture 2 :
Single Row Subquery
Lecture 3 :
Single Row Subquery Practice
Lecture 4 :
Multi Row Subquery
Lecture 5 :
Multi Row Subquery Practice
Lecture 6 :
Multi Column Subquery
Lecture 7 :
Multi Column Subquery Practice
Lecture 8 :
Chapter 9 Quiz 1
Chapter 9 Quiz 1
Lecture 9 :
All Chapter Practices
Section 10 : SET Operators 7 Lectures 00:17:02
Lecture 1 :
Set Operators - Overview
Lecture 2 :
Set Operators – UNION/UNION ALL
Lecture 3 :
Union/Union All Practice
Lecture 4 :
Set Operators – INTERSECT/MINUS
Lecture 5 :
Intersect/Minus Practice
Lecture 6 :
Chapter 10 Quiz 1
Chapter 10 Quiz 1
Lecture 7 :
All Chapter Practices
Section 11 : DML - Data Manipulation Language and TCL – Transaction Control Language 7 Lectures 00:30:04
Lecture 1 :
DML – INSERT Statement
Lecture 2 :
DML – UPDATE Statement
Lecture 3 :
DML – DELETE Statement
Lecture 4 :
TCL – Transaction Control Language
Lecture 5 :
DML and TCL Practice
Lecture 6 :
Chapter 11 Quiz 1
Chapter 11 Quiz 1
Lecture 7 :
All Chapter Practices
Section 12 : DDL - Data Definition Language 19 Lectures 00:34:57
Lecture 1 :
DDL – CREATE TABLE Statement
Lecture 2 :
Columns Data Types
Lecture 3 :
Create Table Practice
Lecture 4 :
Table Constraints – NOT NULL and CHECK
Lecture 5 :
Not Null and Check Constraints Practice
Lecture 6 :
Table Constraints – UNIQUE and PRIMARY
Lecture 7 :
Unique and Primary Constraints Practice
Lecture 8 :
Table Constraints – FOREIGN KEY
Lecture 9 :
Foreign Key Constraints Practice Part I
Lecture 10 :
Foreign Key Constraints Practice Part II
Lecture 11 :
Chapter 12 Quiz 1
Chapter 12 Quiz 1
Lecture 12 :
CREATE TABLE with Subquery
Lecture 13 :
Create Table with Subquery Practice
Lecture 14 :
DDL – ALTER TABLE Statement
Lecture 15 :
Alter Table Practice
Lecture 16 :
DDL – DROP TABLE Statement
Lecture 17 :
Drop Table Practice
Lecture 18 :
Chapter 12 Quiz 2
Chapter 12 Quiz 2
Lecture 19 :
All Chapter Practices
Section 13 : Data Dictionary Views 13 Lectures 00:11:20
Lecture 1 :
Data Dictionary – Overview
Lecture 2 :
Data Dictionary Views– Objects Information
Lecture 3 :
Use USER_OBJECTS and ALL_OBJECTS Practice
Lecture 4 :
Data Dictionary Views– Tables Information
Lecture 5 :
Use USER_TABLES and ALL_TABLE Practice
Lecture 6 :
Data Dictionary Views– Columns Information
Lecture 7 :
Use USER_TAB_COLUMNS Practice
Lecture 8 :
Data Dictionary Views– Constraints Information
Lecture 9 :
Use USER_CONSTRAINTS and USER_CONS_COLUMNS Practice
Lecture 10 :
Data Dictionary Views– Comments
Lecture 11 :
Use USER_TAB_COMMENTS and USER_COL_COMMENTS Practice
Lecture 12 :
Chapter 13 Quiz 1
Chapter 13 Quiz 1
Lecture 13 :
All Chapter Practices
Section 14 : Views 11 Lectures 00:08:31
Lecture 1 :
Create View / Query View
Lecture 2 :
Create View and Query View Practice
Lecture 3 :
Views Overview
Lecture 4 :
Modify View
Lecture 5 :
Modify View Practice
Lecture 6 :
DML Operations on a View
Lecture 7 :
DML Operations on a View Practice
Lecture 8 :
Retrieve VIEW Information / Drop VIEW
Lecture 9 :
Retrieve VIEW Information and Drop VIEW Practice
Lecture 10 :
Chapter 14 Quiz 1
Chapter 14 Quiz 1
Lecture 11 :
All Chapter Practices
Section 15 : Sequences 8 Lectures 00:08:56
Lecture 1 :
Create Sequences
Lecture 2 :
Create Sequences Practice
Lecture 3 :
Using Sequences / Modify Sequences
Lecture 4 :
Using Sequences and Modify Sequences Practice
Lecture 5 :
View Sequence Information / Drop Sequence
Lecture 6 :
View Sequence Information and Drop Sequence Practice
Lecture 7 :
Chapter 15 Quiz 1
Chapter 15 Quiz 1
Lecture 8 :
All Chapter Practices
Section 16 : Synonyms 5 Lectures 00:02:12
Lecture 1 :
Create Synonym
Lecture 2 :
Create Synonym Practice
Lecture 3 :
View Synonym Information / Drop Synonym
Lecture 4 :
View Synonym Information and Drop Synonym Practice
Lecture 5 :
All Chapter Practices
Section 17 : Indexes 6 Lectures 00:17:00
Lecture 1 :
Create Index
Lecture 2 :
Create Index Practice
Lecture 3 :
View Index Information / Drop Index
Lecture 4 :
VIew Index Information and Drop Index Practice
Lecture 5 :
Chapter 17 Quiz 1
Chapter 17 Quiz 1
Lecture 6 :
All Chapter Practices
Section 18 : Managing Schema Objects 9 Lectures 00:23:32
Lecture 1 :
Managing Constraints
Lecture 2 :
Managing Constraints Practice
Lecture 3 :
Chapter 18 Quiz 1
Chapter 18 Quiz 1
Lecture 4 :
Temporary Table
Lecture 5 :
Temporary Table Practice
Lecture 6 :
External Table
Lecture 7 :
External Table Practice
Lecture 8 :
Chapter 18 Quiz 2
Chapter 18 Quiz 2
Lecture 9 :
All Chapter Practices
Section 19 : Using Subqueries II 12 Lectures 00:25:05
Lecture 1 :
Multicolumn Subquery
Lecture 2 :
Multicolumn Subquery Practice
Lecture 3 :
Correlated Subquery
Lecture 4 :
Correlated Subquery Practice
Lecture 5 :
Chapter 19 Quiz 1
Chapter 19 Quiz 1
Lecture 6 :
EXISTS and NOT EXISTS Operators
Lecture 7 :
EXISTS and NOT EXISTS Operators Practice
Lecture 8 :
Chapter 19 Quiz 2
Chapter 19 Quiz 2
Lecture 9 :
WITH Clause
Lecture 10 :
WITH Clause Practice
Lecture 11 :
Chapter 19 Quiz 3
Chapter 19 Quiz 3
Lecture 12 :
All Chapter Practices
Section 20 : Manipulating Data Using Subqueries 6 Lectures 00:12:39
Lecture 1 :
Correlated Update
Lecture 2 :
Correlated Update Practice
Lecture 3 :
Correlated Delete
Lecture 4 :
Inline View
Lecture 5 :
Chapter 20 Quiz 1
Chapter 20 Quiz 1
Lecture 6 :
All Chapter Practices
Section 21 : Controlling User Access 11 Lectures 00:11:41
Lecture 1 :
Privileges Overview
Lecture 2 :
System Privileges
Lecture 3 :
System Privileges Practice
Lecture 4 :
Object Privileges
Lecture 5 :
Object Privileges Practice
Lecture 6 :
Chapter 21 Quiz 1
Chapter 21 Quiz 1
Lecture 7 :
Roles
Lecture 8 :
Roles Practice
Lecture 9 :
Revoke Privileges
Lecture 10 :
Revoke Privileges Practice
Lecture 11 :
All Chapter Practices
Section 22 : Manipulating Data – DML II 14 Lectures 00:39:49
Lecture 1 :
MERGE Statement
Lecture 2 :
Merge Statement Practice
Lecture 3 :
Multitable Insert - Overview
Lecture 4 :
Multitable Insert - Unconditional INSERT ALL
Lecture 5 :
Unconditional Insert All Practice
Lecture 6 :
Multitable Insert - Conditional INSERT ALL
Lecture 7 :
Multitable Insert - Conditional INSERT FIRST
Lecture 8 :
Conditional Insert First Practice
Lecture 9 :
Multitable Insert - Pivoting INSERT
Lecture 10 :
Chapter 22 Quiz 1
Chapter 22 Quiz 1
Lecture 11 :
FLASHBACK Table Statement/Drop
Lecture 12 :
FLASHBACK Query
Lecture 13 :
Flashback Practice
Lecture 14 :
All Chapter Practices
Section 23 : Managing Data in Different Time Zones 8 Lectures 00:15:05
Lecture 1 :
Time Zone Overview
Lecture 2 :
Time Zone Practice
Lecture 3 :
INTERVAL Data Types
Lecture 4 :
Interval Data Types Practice
Lecture 5 :
Other Time Functions
Lecture 6 :
Other Time Functions Practice
Lecture 7 :
Chapter 23 Quiz 1
Chapter 23 Quiz 1
Lecture 8 :
All Chapter Practices

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?