Microsoft SQL Server - Innozant MIS & Data Analytics & Data Science

Administrator Expert


Microsoft SQL Server is one the most popular Relational Database Management System
(RDBMS) used in Microsoft universe. It can be used for data storage as well as for data
retrieval for applications which can be either on desktop or Web/Browse.

Course Objectives: Learn about SQL – Structured Query Language

Build database using Data Definition Language Systems Perform basic CRUD
operations using Data Manipulation Language statement like Insert, Update and
Delete Write and call Stored Procedures and Functions stored in database.

Write and manage database triggers, cursors and Index.
Pre-requisite / Target Audience:
This SQL server course can be taken by any beginner who wants to build career in

Download Brochure

Topics for this course

Module 1:- Introduction to Basic Database Concepts?

In this module we learn about Basic concepts and advantages of DBMS and limitations of file management system, and also about 3 data base models

Module 2:- E-R Modeling and Diagram?

In this module we learn about entity, attributes and relationship, identify the entities and attributes How to draw a E-R diagram and translating the E-R diagram in relation schema

Module 3: Normalization?

In this module we learn about what is normalization, types of normalization, data before and after normalization, benefits of normalization.

Module 4: Introduction to SQL Server?

In this module we learn about SQL Server, history of sql server ,types of system databases, communication between frontend and backend and sql server editions

Module 5: Introduction to SQL?

In this module we learn about types of sql statements, databases in sql server, how to create a database, datatypes in sql server, and about DDL Statements.

Module 6: DDL and DML Statements?

In this module we learn about how to create a table, alter and drop a table, and about DML statements, like insert update and delete statements.

Module 7: Working with Queries (DQL)?

In this module we learn about select statement, top, distinct string and arithmetic expressions, Sorting the data and about sub queries and where clause (condition).

Module 8: Aggregate Functions?

In this module we learn about how to use aggregate functions like sum, mean, max, avg what is difference between having and where clause, group by clause rollup and cube operator

Module 9: Joins and Set Operations?

In this module we will know about joins and types of joins how to join the tables and about Sub queries, types of operators like union, intersect and except and how to add the tables and relationship between them.

Module 10: Implementation of Data integrity?

In this module, we will learn correctness of data and types of integrity and types of constraints.

Module 11: Working with Constraints?

In this module, we will learn about how to create a constraint, types of constraints, and difference between unique, not null and primary key constraints.

Module 12: Implementing Views?

In this module, how to create a view, advantages of views, altering and dropping a view and advanced options while creating a view.

Module 13: Data Control language (DCL)?

In this module, we will learn how to grant permission and revoking of roles

Module 14: Working with Indexes?

In this module, how to create an index, advantages and disadvantages of index, and types of index and dropping index, and also about index structure

Module 15: Writing Transact-SQL (T-SQL)?

In this module, what is script and what is batche,variables and if else statements and working with temporary tables, and checking with the existence of database objects.

Module 16: Working with Stored Procedures and Functions?

In this module, we will learn how to create a stored procedure and difference between stored procedure and table ,advantages of procedures and about types of parameters.

Module 17: Implementing Triggers?

In this module, we will learn about what is trigger and how to create a trigger, types of triggers How to use a rollback tran.

Module 18: Working with Cursors?

In this module, how to create a cursor, what is cursor, types of cursor and benefits of cursor

Module 19: Transaction Control Language (TCL)?

In this module, we will learn what is transaction ,transaction management and what are acid properties, what are isolation levels and about implicit and explicit transactions.

Module 20: Backup and Restore?

In this module, how to backup database and how to restore a database and how to generate a sql script,and executing a sql script and how to attach and detach a database.
  • Course level: Expert