Syllabus

1 month
On Oracle 18c

Number Functions
- number formatting
- Round
- Trunc
- Mode etc.
- currency formatting
- convert from string to number and vice versa etc.
Date Functions
- Date Formatting
- Date difference
- last day etc
- Conversion from String to Date and vice versa etc.
Nested Functions
Handle Null Values :NVL, NVL2, NULLIF, COALESCE
Conditional Expressions - Case and Decode

Groups

Joins

Sub Query & Co-related Sub Query
- Single Row Sub Query
- Multi Row Sub Query
- Multi Column Sub Query
- Co related Sub Query
Advanced Joins
- Integrating Joins & Groups
- Writes Join queries linking upto 5 tables
- Integrating Joins, Groups & Sub Query
- Integrating Joins, Groups, Sub Query & Corelated Sub query
Creating Complex Queries
Views
Advance Views
Inline Views
Advanced Inline Views with Joins, Groups & Sub Queries

SET Operators

DML - Data Manipulation Language
- Insert
- Update
- Delete
- Truncate
Advanced DML Operations
- Insert, Update & Delete using Queries & Sub Query
Transaction Mgt (T SQL)
- Commit
- Rollback
- Read Consistency
DDL - Create, Alter and Drop
- Tables
- Indexes
- Sequence
- Synonyms
Constraints
- Primary Key
- Unique
- Foreign Key
- Not Null
- Check
Foreign Key Effect
- Effect of Foreign Keys on DML & DDL Operations
Creating Tables Using Queries
Rolups & Cubes
DCL - Data Control Language
- Managing Security
- Creating Users & Roles
- Manage User & Role Privileges
Interview Prepare Session
Project