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".

 Different Datasets - Different Scenarios - Multiple exercises.

Course Content:

SQL Queries Hands on

• What is Database Testing and how it differs from Manual/Automation Testing
• 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