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
₹15,000
₹20,000
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
Questions
My Question
{{ comment.replies_count }}
Send
Load More
Back to Q&A List
Add Comment
{{ message }}
Send
9) Conversion Functions and Conditional Expressions
TO_CHAR with dates
Lesson is locked. Please Buy course to proceed.
9) Conversion Functions and Conditional Expressions
Implicit Data Conversion VS Explicit
Complete
9) Conversion Functions and Conditional Expressions
TO_CHAR with numbers
w
Login
Sign Up
Remember me
Forgot Password?
Sign In
Sign Up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
Email Reset Link
Cart
Your cart is empty!
Return to shop
Shopping Cart
Cart is empty!
Total
₹0.00
Apply Coupon
APPLY
0
Questions
My Question