Microsoft SQL Classes in Mumbai

14 Lesson

24 Hours

Add to Wishlist

Join Microsoft SQL Classes in Mumbai and sharpen skills employers value most today. Learn practical tools and techniques used widely across today's fast-growing industries and workplaces.

Enroll Now

SQL Course in Mumbai Overview

Prerequisites

Basic understanding of databases and data organization concepts

Skills You Will Gain

Optimize queries for better performance on large datasets
Apply joins, functions, and procedures to solve data problems
Ensure data integrity through proper database design

Key Features

Instructor Led Training : 16 Hrs
Experienced & Professional Trainers
Small Batches Upto 10 Participants
24 X 7 Lifetime Support & Access
1 On 1 Training Option Available
Flexible Schedule

SQL Training in Mumbai Modules

Lesson 1 - Introduction

1. Introduction to DBMS

2. Introduction to RDBMS

3. Introduction to OLTP & OLAP

4. Introduction to Database

5. Introduction to Datawarehouse

6. Architecture of Datawarehouse

7. Entity & Tables

8. Facts and Dimensions

9. Star and Snowflake Schema

Lesson 2 - Introducing SQL Server

1. What is SQL Server

2. Architecture of SQL Server

3. SQL Server Editions

4. Installing SQL Server

5. Sql Server Instances

6. Internals of Sql Server Database

7. MDF & LDF Files

Lesson 3 - Basics of Database Design

1. Normalization

2. Denormalization

3. Introducing SQL Server Management Studio

4. Creating a Database

5. Data Types

6. DDL Commands

7. Designing Table Model

8. Creating Tables

9. Alteration of Table Design

10. Add New Column, Drop Column

11. Drop Table

Lesson 4 - Writing Queries

1. INSERT queries

2. UPDATE queries

3. DELETE queries

4. TRUNCATE

5. The SELECT Clause

6. The FROM Clause

7. The WHERE Clause

8. Mathematical Operator

9. Conditional Operators

10. AND , OR Operators

11. Like Operators

12. The ORDER BY Clause

13. Using TOP N and TOP N PERCENT

14. Aggregate Functions

15. String Functions

16. Date Functions

17. Using GROUP BY and HAVING

Lesson 5 - Constraint in SQL SERVER

1. What is Constraint

2. Adding constraints to columns in Tables

3. Primary Key Constraints

4. Unique Constraints

5. Check Constraints

6. Default

7. Alter Constraints

8. Drop Constraints

Lesson 6 - Relational Database

1. Why Relational Model

2. Advantages of Relational Model

3. Master Table & Child Tables

4. Introduction to Foreign Key

5. Creating Relations between tables

Lesson 7 - Joins In SQL SERVER

1. Introduction to Joins

2. Types of Joins

3. Inner Join

4. Left Outer Join

5. Right Outer Join

6. Full Outer Join

7. Self-Join

8. Writing Joins queries

9. APPLYING CLAUSES USING JOINS

Lesson 8 - Advanced SQL QUERIES

1. OFFSET & FETCH

2. SELECT INTO queries

3. SUB-QUERIES

4. UNION

5. INTERSECT

6. EXCEPT

7. ROW_NUMBER

8. RANK

9. CUBE & ROLLUP

10. What is T-SQL

Lesson 9 - T-SQL

1. Syntax Conventions

2. Executing SQL Statements

3. Identifiers

4. Operators

5. Variables

6. Using T-SQL to Build and Alter Objects

7. If – else statements

8. Case statements

9. Looping statements

10. Identity statements

11. Types of functions

Lesson 10 - Stored Procedures, Functions

1. Introduction to Stored Procedures

2. Writing Stored Procedures

3. Alteration of Processing

4. Using/Calling Procedures

5. Using Input & Output Parameters

6. Advantage of Stored Procedures

7. Introduction to Functions

8. Writing Functions

9. Scalar Functions

10. Table Value Functions

11. Comparison between Stored Procedures & Functions

Lesson 11 - Types of Tables in SQL SERVER

1. Temp Tables

2. Local Temp Table

3. Global Temp Table

4. CTE

5. Examples of CTE

6. Table Variables

7. Comparison between Temp Tables, CTE & Table Variables

Lesson 12 - Views

1. Introduction to Views

2. Creating Views

3. Alteration of Views

4. Types of Views

5. Simple View & Complex View

Lesson 13 - Indexes

1. Introduction to Indexes

2. Types of Indexes

3. Clustered Index & Non Clustered Index

4. Creating Indexes

5. Best Practices of Indexes Creation

Lesson 14 - Advanced SQL-SERVER

1. Error Handling

2. Transactions

3. Authentication Modes in SQL SERVER

4. Creating Users

5. Backup & Restore

Talk To Us

We are happy to help you

1-800-7430-173 (US Toll Free)

+91 7240740740 (India)

Drop Us a Query

Fields marked * are mandatory

Name

Phone Number

Comments

Request For Live Demo Class

SQL Training Fees in Mumbai

SELF PACED LEARNING

US $ 199.00 US $ 99.00

Refund Policy

Duration : 24 hrs
Lifetime Free Upgrade
Reference Documents
24x7 Support & Access

WATCH 1st CLASS FREE

Online Class Room Program

US $ 599.00

100% Money Back Guarantee

Duration : 24 Hrs
Plus Self Paced

Classes Starting From

Fast Track Batch 08 Sep 2026
Weekday Batch 14 Sep 2026
Weekend Batch 12 Sep 2026

Corporate Training

Customized Training Delivery Model
Flexible Training Schedule Options
Industry Experienced Trainers
24x7 Support

Trusted By Top Companies Worldwide

Want to know Today's Offer

Microsoft SQL Server Certification Exam

After completing the Microsoft SQL Server Training Course and hands-on exercises, learners receive a Course Completion Certificate from igmGuru.

Reviews

Login

Email ID*

Password*

Forgot Password?