Curriculum
Course:
Oracle SQL Masterclass : Advanced Skills...
Login
Curriculum
Oracle SQL Masterclass : Advanced Skills for Software Developers
Introduction
0/4
What is Oracle and Oracle Database ?
Text lesson
Introduction to Oracle SQL & Classification
Text lesson
Join the secret Facebook group
Text lesson
Join the Secret Whatsapp Group
Text lesson
Installation
0/6
How to Install Oracle Database 19c In Windows
Text lesson
Enable Pluggable Database with TNSNAMES.ORA file
Text lesson
How To Create [TNS Service] Using Oracle Net Configuration Assistant
Text lesson
UNLOCK HR AND SCOTT USER
Text lesson
Introduction to SQL Plus
Text lesson
Introduction to SQL Developer with Installation
Text lesson
Query : Common SQL*PLUS commands
0/1
Common SQL*PLUS commands
Text lesson
Query : Sorting Data
0/3
Order By Clause
Text lesson
Sorting by Column Aliase
Text lesson
Sorting by Multiple Columns
Text lesson
Query : Writing Basic SQL Statements
0/7
Selecting Columns
Text lesson
Using the Concatenation Operators
Text lesson
Using Arithmetic Operators
Text lesson
Defining Null Values
Text lesson
Using Column Aliases
Text lesson
Using the Concatenation Operators
Text lesson
Eliminitating Duplicate Rows
Text lesson
Query : Single Row Functions
0/10
Case-manipulation functions
Text lesson
Character-manipulation functions
Text lesson
Number Functions
Text lesson
Date Functions
Text lesson
Using the TO_CHAR functions with Dates
Text lesson
Using the TO_CHAR functions with Numbers
Text lesson
RRRR Format
Text lesson
Nesting Functions
Text lesson
Using the NVL Functions
Text lesson
Using the DECODE Functions
Text lesson
Query : Restricting Data
0/9
Using the Where Clause
Text lesson
Using the Null Conditions
Text lesson
Comparison Conditions
Text lesson
Logical Conditions – Using the AND, OR, NOT Operators
Text lesson
Using the Between Conditions
Text lesson
Using the IN Comparison Conditions
Text lesson
Using the Like Conditions
Text lesson
Using the Null Conditions
Text lesson
Logical Conditions – Using the AND, OR, NOT Operators
Text lesson
Query : Displaying Data from Multiple Tables
0/7
Cartesian-Products
Text lesson
Non-Equi-Joins
Text lesson
Equi-Joins
Text lesson
Self Joins
Text lesson
Non-Equi-Joins
Text lesson
Outer Joins
Text lesson
Self Joins
Text lesson
Query : Sorting Data
0/3
Order By Clause
Text lesson
Sorting by Column Aliase
Text lesson
Sorting by Multiple Columns
Text lesson
Query : Aggregating Data Using Group Functions
0/5
Types of Group Functions
Text lesson
Using the Group By Clause
Text lesson
Illegal Queries using group functions
Text lesson
Using the HAVING clause
Text lesson
Nesting Groups
Text lesson
Query : Single Row Functions
0/10
Case-manipulation functions
Text lesson
Character-manipulation functions
Text lesson
Number Functions
Text lesson
Date Functions
Text lesson
Using the TO_CHAR functions with Dates
Text lesson
Using the TO_CHAR functions with Numbers
Text lesson
RRRR Format
Text lesson
Nesting Functions
Text lesson
Using the NVL Functions
Text lesson
Using the DECODE Functions
Text lesson
Query : Subqueries
0/7
Using the SUBQUERIES
Text lesson
Executing Single Row Subqueries
Text lesson
Using Group Function in a Subqueries
Text lesson
The Having Clause with Subqueries
Text lesson
Using the ANY operator in multiple row subqueries
Text lesson
Using the ALL operator in multiple row subqueries
Text lesson
Null Values in a Subquery
Text lesson
Query : Aggregating Data Using Group Functions
0/5
Types of Group Functions
Text lesson
Using the Group By Clause
Text lesson
Illegal Queries using group functions
Text lesson
Using the HAVING clause
Text lesson
Nesting Groups
Text lesson
DDL : Creating and Managing Views
0/1
Creating and Managing Views
Text lesson
DDL : Creating and Managing Tables
0/8
Creating and Managing Tables
Text lesson
Quering the Data Dictionary Table
Text lesson
Creating a Table by Using a Subquery
Text lesson
Adding, Modifying and dropping a column
Text lesson
The Set Unused Option
Text lesson
Changing the name of an Object
Text lesson
Dropping a Table
Text lesson
Truncating A Table
Text lesson
Data Manipulation Language (DML)
0/4
Manipulating Data – Insert
Text lesson
Manipulating Data – Update
Text lesson
Manipulating Data – Delete
Text lesson
Manipulating Data – Merge
Text lesson
Data Definition Language (DDL) : Including Constraints
0/5
Including Constraints – Not Null
Text lesson
Including Constraints – Primary Key
Text lesson
Including Constraints – Foreign Key
Text lesson
Including Constraints – Unique Key
Text lesson
Including Constraints – Check
Text lesson
Data Control Language (DCL)
0/1
Controlling User Access
Text lesson
Transaction Control
0/2
Data Control with Rollback and Commit
Text lesson
Data Update on Different Sessions
Text lesson
DDL : Creating and Managing Views
0/1
Creating and Managing Views
Text lesson
Data Manipulation Language (DML)
0/4
Manipulating Data – Insert
Text lesson
Manipulating Data – Update
Text lesson
Manipulating Data – Delete
Text lesson
Manipulating Data – Merge
Text lesson
Other Database Objects
0/3
Other Database Objects – Sequence
Text lesson
Other Database Objects – Index
Text lesson
Other Database Objects – Synonym
Text lesson
Quiz and Free E-books
0/2
Oracle SQL Quiz
25 questions
E-books
Text lesson
Bonus Lecture
0/3
Bonus - The UNION [ALL], INTERSECT, MINUS Operators
Video lesson
Top-N-Analysys
Text lesson
If Condition in SQL : Case
Text lesson
What is Next ?
0/1
Learn PLSQL to move forward.
Text lesson
Text lesson
Including Constraints – Foreign Key
Live Courses