Description
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
information
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.