Oracle SQL For Data Analysis : Truly From Basics to Advanced

5.0 /5

(1 Rating)

Offered byUDEMY

Oracle SQL For Data Analysis : Truly From Basics to Advanced
at
UDEMY
Overview

This Course helps know more about Oracle SQL For Data Analysis : Truly From Basics to Advanced

Duration	15 hours
Total fee	₹449
Mode of learning	Online
Official Website	Go to Website
Credential	Certificate

Oracle SQL For Data Analysis : Truly From Basics to Advanced
at
UDEMY
Highlights

Certification will be issued after completion of course

Oracle SQL For Data Analysis : Truly From Basics to Advanced
at
UDEMY
Course details

Skills you will learn

RDBMS Installation ERP Data analysis

More about this course

This Course is for everybody who likes to make career in Data Analytics, database programming, front end programming, ERP, or in general succeed as an IT professional, management people and undergraduate students of any stream. This course is covered on Oracle's LiveSQL platform available on web hence does not require any local installation of Oracle,

Oracle SQL For Data Analysis : Truly From Basics to Advanced
at
UDEMY
Curriculum

Introducction

RDBMS Concepts

Oracle LiveSQL platform set up

Basic SELECT Statement

SQL Logical Operators

AND Operator

OR Operator

Using AND & OR Together

SQL operators IN and BETWEEN

SQL operator IN

SQL operator BETWEEN

SQL Clauses Distinct & ORDER BY &SET Operators

SQL clause DISTINCT

SQL clause ORDER BY

SQL UNION - MINUS - INTERSECT operators

Handling Of NULL Values

SQL clause IS NULL and IS NOT NULL

SQL built in function NVL

SQL built in function NVL2

SQL built in function COALESCE

Subquery/Nested Query Techniques

Multi-valued Subqueries

Subquery Returning NULL

Set Comparison Subqueries

Correlated Subqueries

SQL Join Operation

SQL Inner Join Operation

SQL Non-Equi Join Operation

SELF JOIN operation

OUTER JOIN operation

SQL Standardized built-in Group Functions

SQL Group Function Queries

SQL Group Function Tricky Queries

ROLLUP & CUBE - SQL Group Function Analytical Extensions

Oracle SQL General Built-in Functions

SQL Functions Part - 2

SQL Functions Part - 3

SQL Functions Part - 4

SQL Functions Part - 5

TransSQL Transaction and Isolation

Concept of Consistency and Consistent Read in Database Transaction

SQL Transaction Control Languageaction And DML

Oracle SQL For Data Analysis : Truly From Basics to Advanced
at
UDEMY
Faculty details

Prashant Munshi

more than 23 years of extensive experience in Oracle Database Administration (DBA) including onsite experience in US and UK of about 6 years. I have been a distinguished corporate trainer and adjunct faculty in the subjects of database engineering and software technologies; attached with various prestigious engineering & tech colleges in Central India since last 15 years.