MS SQL Server Development


  • Batch Timings :
  • Starting Date :

Course Overview

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 FEATURES

  • Resume & Interviews Preparation Support
  • Hands on Experience on Project.
  • 100 % Placement Assistance
  • Multiple Flexible Batches
  • Missed Sessions Covered
  • Practice Course Material

At the end of MS SQL Server Training Course, Participants will be able to:

  • Build database using Data Definition Language Statements
  • Perform basic CRUD operations using Data Manipulation Language statements like Insert, Update and Delete Write and call Stored Procedures and Functions stored in database.
  • Write and manage database triggers, cursors and Index.

Course Duration

  • Weekdays : (50-52 hours)

Prerequisites :

  • This MS SQL server course can be taken by any beginner who wants to build career in Information Technology.
  • There are no pre-requisites for this course. Familiar with any database concept is advantageous..

Course

1.1 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

1.2 Introduction to SQL Server

  • What is SQL Server Version history and different editions
  • Basics of SQL Types of SQL Statements
  • DDL, DML, DQL, DCL and TCL
  • Create Database using Management Studio
  • Datatypes in SQL Server
  • Exploring DDL Statements on Table using Management Studio

1.3 DDL and DML Statements

  • Why write statements in Frontends?
  • Create, Alter and Drop Table Insert,
  • Update and Delete Statement Truncate Statement

1.4 Working with Queries (DQL)

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

1.5 Aggregate Functions

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

1.6 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

1.7 Implementing Views

  • Introduction & Advantages of Views
  • Creating, Altering, Dropping Views
  • Advance Options while Creating a View
  • SQL Server Catalogue Views

1.8 Transact-SQL (T-SQL)

  • Introduction to T-SQL
  • Programming Elements
  • Control Statement in TSQL
  • Looping Structure

1.9 Stored Procedures

  • Introduction to stored procedures
  • Benefits of Stored Procedures
  • Creating, Executing Modifying, Dropping
  • Input–Output and Optional Parameters
  • Working with Dynamic SQL

1.10 Working with Cursors

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

1.13 Transaction and Error Handling

  • Transactions and the Database Engine
  • Controlling Transactions
  • Isolation Levels
  • TRY / CATCH Blocks
  • Working with Error Information

1.14 Triggers

  • Create Trigger
  • Types of Trigger
  • After Triggers
  • Instead Of Triggers

FAQ

SQL is a standard language which stands for Structured Query Language based on the English language whereas MySQL is a database management system. SQL is the core of relational database which is used for accessing and managing database, MySQL is an RDMS (Relational Database Management System) such as SQL Server, Informix etc.

In SQL, there is a built-in function called GetDate() which helps to return the current timestamp/date.

SELECT * FROM Table_name WHERE EmpName like ‘A%’

Quick Enquiry