SQL Certification Course - Overivew

Background - Database is Backbone of Every Organization & SQL is Primary Language to Work With Database Operations
Hence SQL is Asked in Every Technical Interview.
To Make Sure You Crack Technical Interviews we have created Power Packed SQL course that covers right from Basics to Advanced Job Oriented Topics.
No Prerequisite required, can be learnt by both IT & Non IT Students.
Course Covers - Oracle 11g/12c Suite
Join Us - Learn in Depth - Start Cracking Technical Interviews !

SQL Syllabus

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
- Co related Sub Query
Views
Inline Views
Complex Queries
- Joins with Groups
- Inline views, Joins, Sub Query Integration

SET Operators

DDL - Create, Alter and Drop
- Tables
- Indexes
- Sequence
- Synonyms
DML - Data Manipulation Language
- Insert
- Update
- Delete
- Truncate
Advanced DML Operations
Transaction Mgt (T SQL)
- Commit
- Rollback
- Read Consistency
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