iNEWPM

Course Details

MS SQL Server- Development

                                                                                                                         

Prerequisites

·         There are no pre-requisites for this course.

·         Familiar with any database concept is advantageous.

Course Contents


1.      Database Overview

·         Overview of Database

·         Components of Database System

·         Advantages of Database

·         RDBMS Concepts

·         Table, Record, Field, Column

·         Overview of DDL,DML,DCL

2.      Working with SQL Server Management Studio

·         Management Studio Work Area

·         Creating Tables

·         View Data

·         SQL Select Statement

·         SQL Data Types

3.      Restricting and Sorting Data

·         Where Clause

·         Logical Operators

·         AND, OR Operators

·         Arithmetic Operator

·         Comparison Operator

·         Logical Operators

·         IN & Between Operator

4.      SQL Functions

·         AVG

·         MAX,MIN

·         SUM etc

5.      Aggregating Data Using Group Functions

·         Group Functions

·         Group By Clause

·         HAVING Clause

6.      Subqueries

·         Single Row Subqueries

·         Multiple Row Subqueries

·         Correlated Subqueries

7.      Manipulating Data

·         INSERT Statement

·         UPDATE Statement

·         DELETE Statement

·         MERGE Statement

8.      SQL Joins

·         Inner Join

·         Left Join

·         Right Join

·         Full Outer Join

 

9.      Transact-SQL Programming 

·         Introduction to T-SQL

·         Programming Elements

·         Control Statement in TSQL

·         Looping Structure

10.  Cursors

·         Basics of Cursor

·         LifeCycle of Cursor

·         Types Of Cursors

·         Forward_Only and Scroll Cursors

·         Static, Dynamic and Keyset Cursors

·         Local and Global Cursors

11.  Transaction and Error Handling

·         Transactions and the Database Engine

·         Controlling Transactions

·         Isolation Levels

·         TRY / CATCH Blocks

·         Working with Error Information

12.  Stored Procedures  

·         Querying Data with Stored Procedures

·         Passing Parameters to Stored Procedures

·         Creating Simple Stored Procedures

·         Working with Dynamic SQL

13.  User Defined Functions

·         Creating and Altering Functions

·         Types Of User Defined Functions

·         Scalar Functions

·         Inline Table-Valued

·         Multi-statement Table-Valued

·         Permissions On User Defined Functions

14.  Triggers

·         Create Trigger

·         Types of Trigger

·         After Triggers

·         Instead Of Triggers

 

 

 

Are you providing Training Classes
IT Courses / Govt Exam Preparation
Higher Studies / Studies Abroad
NEWFreeCompanies HiringUpdates//nuPM