Techehost
ORACLE DATABASE
Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Get course

Course sections

Section 1
1) Oracle Introduction
Section 2
2) Installation Process
Section 3
3) Introduction Database
Section 4
4) DDL & DML Statements
1
Introduction to DDL & DML
Section 5
5) Retrieving data using Select statement
1
Capabilities of SQL SELECT Statements
2
Arithmetic expressions and NULL values
3
Column Alias, Concatenation , Distinct and DESCRIBE
Section 6
6) Restricting and sorting data
1
The WHERE Clause & Comparison Operators
2
Using Between and / IN / Like Operators
3
Using IS NULL / NOT / Not equal Operators
4
Logical Operators (AND/ OR/ NOT)
5
Order by Clause
6
The FETCH Clause
Section 7
7) Variables
1
Substitution Variables
2
DEFINE / UNDEFINE
3
ACCEPT / PROMPT
4
Double-Ampersand / SET VERIFY / SET DEFINE
Section 8
8) Single-row Functions
1
Single Row Function Introduction
2
Character functions (Upper, Lower, Initcap )
3
Character functions (concat, substr, length )
4
Character functions ( instr )
5
Number functions ( Round, Trunc, MOD )
6
Date Functions ( Sysdate)
7
Date Functions ( months_between, add_months, next_day, last_day)
8
Date Functions ( round , trunc )
9
Nesting Functions
Section 9
9) Conversion Functions and Conditional Expressions
1
Implicit Data Conversion VS Explicit
2
TO_CHAR with dates
3
TO_CHAR with numbers
4
TO_NUMBER , TO_DATE Functions
5
The CASE Function
6
NUllif & Coalesce Function
7
The DECODE Function
Section 10
10) Group Functions
1
Group functions (sum, count, max, min, avg)
2
Group by Clause, Having Clause
Section 11
11) Joins Concept
1
Natural Join
2
Left/Right/full Outer Join
3
Cross Join
4
Self Join
Section 12
12) Subqueries
1
Single row & Multiple rows Subqueries
2
NULL values
3
Exists and not Exists
4
Scalar Subquery / Correlated Subquery
Section 13
13) Set Operators
1
Union
2
Union all
3
Intersect
Section 14
14) Introduction to View
1
Creating Simple Views
2
Creating Complex Views
3
READ ONLY / With check option
Section 15
15) Sequences
Section 16
Synonyms and Indexes
1
Creating Sequences
2
Creating Synonyms
3
Creating Indexes
Section 17
16) Controlling User Access
1
Database Security / System Privileges & Roles
2
Database Security / Object Privileges
3
Creating ROLE Practice
4
With Grant Option
5
Drop user Statement
Section 18

12) Subqueries

Scalar Subquery / Correlated Subquery

Lesson is locked. Please Buy course to proceed.

12) Subqueries Exists and not Exists
Complete
13) Set Operators Union
w
Cart
Checkout - ₹0.00
  • 0
  • 1

Shopping Cart

Cart is empty!

Total
₹0.00
Apply Coupon
APPLY
Checkout View All Courses
0