Oracle SQL for Data Analysis: Beginner to Advance

Oracle SQL for Data Analysis: Beginner to Advance
Course Fee:	7,000.00	Course Duration:	1 Month

Introduction:

Gain the knowledge and skills needed to land an entry-level job in Data Analytics. Learn how to use ORACLE SQL for Data Analysis. No prior programming knowledge is required in any language. It is learn-by-doing hands-on course, so except Diploma or UG level education in any branch there is no other requirement

Course Details

1. Introduction:

· Introduction

· RDBMS Concept

· Oracle Platform Setup

· What is SQL

· Basic SELECT Statements

2. SQL Logical Operator:

· AND Operator

· OR Operator

· Using AND & OR together

3. SQL Operator IN and BETWEEN

· SQL IN operator

· SQL BETWEEN operator

4. 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
Use of Basic Operators

5. Subquery/ Nested Query

Basic Sub-Query Technique
Multi-valued Subqueries
Subquery Returning NULL
Set Comparison Subqueries
Correlated Subqueries
Subquery Operator EXISTS
ANY/ALL Operators

6. SQL Join Operator

SQL Inner Join Operation
SQL Non-Equi Join Operation
SELF JOIN operation
OUTER JOIN operation

· OUTER JOIN clause

7. SQL standardized build-in Group Function

SQL Group Function Concepts
SQL Group Function Queries
SQL Group Function Tricky Queries
ROLLUP & CUBE – SQL Group Function Analytical Extension

· Oracle SQL General built in Functions

8. Transaction And DML

SQL Transactions Concepts
SQL DML Statements
SQL Transaction and Isolation
Concept of Consistency and Consistent Read in Database Transaction
SQL Transaction Control Language
SQL DELETE vs TRUNCATE vs DROP

9. DDL Creating and Altering the tables

SQL Create table Statement
Borrow Structure and Data from Existing Table
SQL Alter Table operation

· Data Integrity Constraints

Data Integrity Concepts
SQL Create and Alter Constraints
Foreign Key Constraint and Referential Integrity

10.Analytical Functions

· DECODE vs CASE

· RANK() vs DENSE_RANK()

11. Interview Preparation

Some most important queries
What is a VIEW?
SQL vs NOSQL
SUM over multiple table

Work on live examples

Course Coordinator:

Md. Shakhawat Hossain

Cell: 01717539855