The Most Advanced Oracle SQL Certification Course

Introduction

1
What is Oracle and Oracle Database ?
2
What is Oracle and Oracle Database ?
3
Introduction to Oracle SQL & Classification
4
Join the secret Facebook group
5
Join the Secret Whatsapp Group

Installation

1
How to Install Oracle Database 19c In Windows
2
How to Install Oracle Database 19c In Windows
3
Enable Pluggable Database with TNSNAMES.ORA file
4
How To Create [TNS Service] Using Oracle Net Configuration Assistant
5
How To Create [TNS Service] Using Oracle Net Configuration Assistant
6
Introduction to SQL Developer with Installation
7
UNLOCK HR AND SCOTT USER
8
Introduction to SQL Plus
9
Introduction to SQL Developer with Installation

Query : Common SQL*PLUS commands

1
Common SQL*PLUS commands

Query : Sorting Data

1
Order By Clause
2
Sorting by Column Aliase
3
Sorting by Multiple Columns

Query : Writing Basic SQL Statements

1
Selecting Columns
2
Using the Concatenation Operators
3
Using Arithmetic Operators
4
Defining Null Values
5
Using Column Aliases
6
Using the Concatenation Operators
7
Eliminitating Duplicate Rows

Query : Single Row Functions

1
Case-manipulation functions
2
Character-manipulation functions
3
Number Functions
4
Date Functions
5
Using the TO_CHAR functions with Dates
6
Using the TO_CHAR functions with Numbers
7
RRRR Format
8
Nesting Functions
9
Using the NVL Functions
10
Using the DECODE Functions

Query : Restricting Data

1
Using the Where Clause
2
Using the Null Conditions
3
Comparison Conditions
4
Logical Conditions – Using the AND, OR, NOT Operators
5
Using the Between Conditions
6
Using the IN Comparison Conditions
7
Using the Like Conditions
8
Using the Null Conditions
9
Logical Conditions – Using the AND, OR, NOT Operators

Query : Displaying Data from Multiple Tables

1
Cartesian-Products
2
Non-Equi-Joins
3
Equi-Joins
4
Self Joins
5
Non-Equi-Joins
6
Outer Joins
7
Self Joins

Query : Sorting Data

1
Order By Clause
2
Sorting by Column Aliase
3
Sorting by Multiple Columns

Query : Aggregating Data Using Group Functions

1
Types of Group Functions
2
Using the Group By Clause
3
Illegal Queries using group functions
4
Using the HAVING clause
5
Nesting Groups

Query : Single Row Functions

1
Case-manipulation functions
2
Character-manipulation functions
3
Number Functions
4
Date Functions
5
Using the TO_CHAR functions with Dates
6
Using the TO_CHAR functions with Numbers
7
RRRR Format
8
Nesting Functions
9
Using the NVL Functions
10
Using the DECODE Functions

Query : Subqueries

1
Using the SUBQUERIES
2
Using the SUBQUERIES
3
Executing Single Row Subqueries
4
Executing Single Row Subqueries
5
Using Group Function in a Subqueries
6
Using Group Function in a Subqueries
7
The Having Clause with Subqueries
8
The Having Clause with Subqueries
9
Using the ANY operator in multiple row subqueries
10
Using the ANY operator in multiple row subqueries
11
Using the ALL operator in multiple row subqueries
12
Null Values in a Subquery

Query : Aggregating Data Using Group Functions

1
Types of Group Functions
2
Using the Group By Clause
3
Illegal Queries using group functions
4
Using the HAVING clause
5
Nesting Groups

DDL : Creating and Managing Views

1
Creating and Managing Views

DDL : Creating and Managing Tables

1
Creating and Managing Tables
2
Creating and Managing Tables
3
Quering the Data Dictionary Table
4
Quering the Data Dictionary Table
5
Creating a Table by Using a Subquery
6
Adding, Modifying and dropping a column
7
Adding, Modifying and dropping a column
8
The Set Unused Option
9
The Set Unused Option
10
Changing the name of an Object
11
Dropping a Table
12
Truncating A Table
13
Changing the name of an Object
14
Truncating A Table

Data Manipulation Language (DML)

1
Manipulating Data – Insert
2
Manipulating Data – Update
3
Manipulating Data – Delete
4
Manipulating Data – Merge

Data Definition Language (DDL) : Including Constraints

1
Including Constraints – Not Null
2
Including Constraints – Not Null
3
Including Constraints – Primary Key
4
Including Constraints – Primary Key
5
Including Constraints – Foreign Key
6
Including Constraints – Foreign Key
7
Including Constraints – Unique Key
8
Including Constraints – Unique Key
9
Including Constraints – Check
10
Including Constraints – Check

Data Control Language (DCL)

1
Controlling User Access
2
Controlling User Access

DDL : Creating and Managing Views

1
Creating and Managing Views

Transaction Control

1
Data Control with Rollback and Commit
2
Data Update on Different Sessions

Data Manipulation Language (DML)

1
Manipulating Data – Insert
2
Manipulating Data – Update
3
Manipulating Data – Delete
4
Manipulating Data – Merge

Quiz and Free E-books

1
Oracle SQL Quiz
25 questions
2
Oracle SQL Quiz
25 questions
3
E-books
4
E-books

Other Database Objects

1
Other Database Objects – Sequence
2
Other Database Objects – Sequence
3
Other Database Objects – Index
4
Other Database Objects – Synonym
5
Other Database Objects – Synonym

What is Next ?

1
Learn PLSQL to move forward.

Transaction Control

1
Data Control with Rollback and Commit
2
Data Update on Different Sessions

Bonus Lecture

1
The UNION [ALL], INTERSECT, MINUS Operators
2
The UNION [ALL], INTERSECT, MINUS Operators
3
Top-N-Analysys
4
Top-N-Analysys
5
If Condition in SQL : Case
6
If Condition in SQL : Case

What is Next ?

1
Learn PLSQL to move forward.
Get course
Enrolled: 5016 students
Lectures: 141
Level: Beginner

Archive

The Most Advanced Oracle SQL Certification Course
Price:
bdt.2,000
Live Courses