Sql Server Training

SQL SERVER is a database made by Microsoft. SQL Servert is most popular database used Sql Server is becoming preferred choice of database to many programmers. Persons when used with microsoft technologies like .NET . Since .NET technology is widely of all background can learn SQL Server.

Course Content:

Introduction to Basic Database Concepts:

• What is Data, Field, Record and database?
• Limitations of File Management System.
• Basic Concepts of Advantages of DBMS
• Exploring Relational DBMS
• Understanding Client and Server

E-R Modeling and Diagram:

• Analyzing the Requirement
• Identify Entities and their Relationships
• Drawing E-R Diagram
• Conversion of E.R. Diagrams into Tables

Normalization:

• First Normal Form
• Second Normal Form
• Third Normal Form
• Practically Normalizing Tables

Introduction to SQL Server:

• introduction to database
• Introduction to Management Studio
• Types of System Databases in SQL

 Introduction to SQL:

• Basics of SQL Types of SQL Statements
• DDL, DML, DQL, DCL and TCL
• Create Database using Management Studio
• Datatypes in SQL Server

DDL and DML Statements:

• Create, Alter and Drop Table Insert,
• Update and Delete Statement Truncate Statement

Working with Queries (DQL):

• Understanding Select Statement Usage of Top, Distinct, Null etc...keywordsv  Using String and Arithmetic Expressions
• Exploring Where Clause with Operators Using Advanced Operatorsv  Sorting data using Order By clausev  Working with basic of Sub Queries

Aggregate Functions:

• Using functions in Queries
• Count, Sum, Min, Max, Avg Group By and Having Clause
• Using Group By with Rollup and Cube

Joins and Set Operations:

• Introduction to Joins Cross Joins
• Inner Join
• Outer Join
• Self Join
• Co-related Sub Queries
• Set Operations using Unions,
• intersect and Except

Implementation of Data integrity:

• types of constraints.
• Entity integrity
• Domain integrity
• Referential integrity
• Types of constraints
• difference between unique, not null and primary key constraints.

Implementing Views:

• how to create a view,
• advantages of views,
• altering and dropping a view And advanced options while creating a view.
• Introduction & Advantages of Views
• Creating, Altering, Dropping Views

Data Control language (DCL):

• Creating Users& Roles
• Granting& Revoking of Roles & privileges

Working with Indexes:

• how to create a index,
• advantages and disadvantages of index,
• and types of index and dropping index,
• and also about index structure.
• Introduction Clustered and Non Clustered Index
• Creating and Dropping Indexes

Writing Transact-SQL (T-SQL):

• What is T-SQL?
• Scripts and Batches Declaring Variables
• Using Statements
• Working with Temp tables
• Error Handling
• Using System Functions / Global Variables
• Using Dynamic SQL

Working with Stored Procedures and Functions:

• Introduction to stored procedures
• Benefits of Stored Procedures
• Creating, Executing Modifying, Dropping
• Inputâ??Output and Optional Parameters
• System defined SPâ??s and Functions.
• User defined Functions

Implementing Triggers:

• Introduction to triggers
• Constraints vs Triggers
• Creating, Altering, Dropping triggers
• for/after/instead of triggers

Working with Cursors:

• Creating Cursors
• Cursors vs. Select
• Types of cursors
• Locks on cursors
• Advantages of cursors

Transaction Control Language (TCL):

• Introduction Transactions process
• Types of transactions (Implicit, explicit)
• Working with Locks,
• Types of locks

Backup and Restore:

• Generating SQL Script
• Executing SQL Script
• Taking database Backup
• Restoring database using backup
• Attaching and Detaching of database