Have around 13 Years of Experience in working with Database(especially SQL Server) Projects and 9 years of strong experience in SQL training.

Complete Hands on sessions in your Laptop..."Less theory More Practical".

Hands on writing SQL Queries in MS SQL Server & Oracle with different Datasets and Multiple Exercises/Assignments

SQL Queries Hands on

• Database Project Architecture
• Components of the database
• Different types of Database Products(RDBMS)

• Introduction to SQL
• Different versions of SQL Server
• Types of SQL Commands/Statements
• DDL Statements
• DML Statements
• DCL Statements
• TCL Statements

• DDL Statements (Create, Alter, Drop & Truncate)
• DML Statements (Insert, Update, Delete & Select)
• Types of Integrity Constraints
• SQL Operators
• Identity/Sequences
• Sub Queries
• CASE statement
• Group By, Having & Order by clauses
• Types of Joins(INNER, LEFT, RIGHT, FULL & CROSS)
• Union , Intersect & Except
• Built In Functions.
• Views, Indexes & Triggers
• Stored Procedures & Functions

• Real-time Scenario’s using SQL queries
• Real time Interview Questions
• ETL Project Architecture walkthrough
• Introduction to DWH & Data Science

Duration: 4 weeks.