Sql Server

InteliGenes Delhi provides real-time and placement focused microsoft sql training in delhi . Our microsoft sql dba course includes basic to advanced level and our microsoft sql course is designed to get the placement in good MNC companies in delhi as quickly as once you complete the ms sql dba certification training course. Our microsoft sql trainers are microsoft sql dba certified experts and 7 years experienced working professionals with hands on real time multiple MS SQL projects knowledge. We have designed our microsoft sql course content and syllabus based on students requirement to achieve everyone’s career goal.
InteliGenes Delhi offers microsoft sql training with choice of multiple training locations across delhi. Our microsoft sql dba training centers are equipped with lab facilities and excellent infrastructure. We also provide microsoft sql dba certification training path for our students in delhi. Through our associated microsoft sql training centers, we have trained more than 90 microsoft sql students and provided 92 percent placement. Our microsoft sql dba course fee is value for money and tailor-made course fee based on the each student’s training requirements. microsoft sql training in delhi conducted on day time classes, weekend training classes, evening batch classes and fast track training classes.

Course Content are as follows:

• Introduction to Relational Databases & SQL
• Installation of SQL Server
• MS SQL Configuration Manager
• Creating database objects in SQL Server
• TSQL commands like SEQUENCE and CONCAT in MS SQL
• Overview of Database Relationships
• What is SQL Management Studio (SSMS)?
• Introduction to Transact SQL (TSQL)
• Using Inner and Outer Joins in a Database
• Implementing Security in SQL Server
• Automating SQL Server
• New Features like Contained Database, FileTable
• Using SQL Server Management Studio
• Retrieving Data from a Single Table
• Retrieving Data from Two or More Tables
• Coding Summary Queries
• Coding Subqueries
• Insert, Update and Delete Data
• Working With Data Types
• How to Use Functions
• How to Design a Database
• Create and Maintain Databases, Tables and Sequences with SQL Statements
• Using the Management Studio for Database Design
• How to Work with Views
• How to Code Scripts
• Code Stored Procedures, Functions, and Triggers
• How to Work with Cursors
• How to Manage Transactions and Locking
• How to Manage Database Security
• How to work with XML
• How to work with BLOBs
• An Introduction to CLR integration
• Code CLR stored procedures, functions, and triggers
• Code Aggregate Functions and User-Defined Types

Detailed Syllabus

SQL Server Training Course Overview

Introduction To DBMS

• File Management System And Its Drawbacks
• Database Management System (DBMS) and Data Models
• Physical Data Models
• Logical Data Models
• Entity – Relationship (E-R) Model

Introduction To SQL Server

• Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
• Connecting To Server
• Server Type
• Server Name
• Authentication Modes
• Sql Server Authentication Mode
• Windows Authentication Mode
• Login and Password
• Sql Server Management Studio and Tools In Management Studio
• Object Explorer
• Object Explorer Details
• Query Editor

TSQL (Transact Structured Query Language)

• Introduction To TSQL
• History and Features of TSQL
• Types Of TSQL Commands
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Query Language (DQL)
• Data Control Language (DCL)
• Transaction Control Language (TCL)

Database

• Creating Database
• Altering Database
• Deleting Database

Constrains

• Procedural Integrity Constraints
• Declarative Integrity Constraints
• Not Null, Unique, Default and Check constraints
• Primary Key and Referential Integrity or foreign key constraints

Table

• Creating Table
• Altering Table
• Deleting Table

Data Manipulation Language

• Insert
• Identity
• Creating A Table From Another Table
• Inserting Rows From One Table To Another
• Update
• Computed Columns
• Delete
• Truncate
• Differences Between Delete and Truncate

Data Query Language (DQL)

• Select
• Where clause
• Order By Clause
• Distinct Keyword
• Isnull() function
• Column aliases
• Predicates
• Between … And
• In
• Like
• Is Null
• Built In Functions

• Scalar Functions
• Numeric Functions
• Character Functions
• Conversion Functions
• Date Functions
• Aggregate Functions
• Convenient Aggregate Functions
• Statistical Aggregate Functions
• Group By and Having Clauses
• Super Aggregates
• Over(partition by …) Clause
• Ranking Functions
• Common Table Expressions (CTE)
• Top n Clause
• Set Operators

• Union
• Intersect
• Except
• Joins

• Inner Join
• Equi Join
• Natural Join
• Non-Equi Join
• Self Join
• Outer Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Cross Join
• Sub Queries

• Single Row Sub Queries
• Multi Row Sub Queries
• Any or Some
• ALL
• Nested Sub Queries
• Co-Related Sub Queries
• Exists and Not Exists
• Indexes

• Clustered Index
• NonClustered Index
• Create , Alter and Drop Indexes
• Using Indexes
• Security

• Login Creation
• SQL Server Authenticated Login
• Windows Authenticated Login
• User Creation
• Granting Permissions
• Revoking Permissions
• Roles
• Views

• Purpose Of Views
• Creating , Altering and Dropping Indexes
• Simple and Complex Views
• Encryption and Schema Binding Options in creating views
• Transaction Management

• Introduction
• Begin Transaction
• Commit Transaction
• Rollback Transaction
• Save Transaction
• Role Of Log File In Transaction Management
• Implicit Transactions
• TSQL Programming

• Drawbacks Of TSQL that leads to TSQL Programming
• Introduction To TSQL Programming
• Control statements In TSQL Programming
• Conditional Control Statements
• If
• Case
• Looping Control Statements
• While
• Cursors

• Working With Cursors
• Types Of Cursors
• Forward_Only and Scroll Cursors
• Static, Dynamic and Keyset Cursors
• Local and Global Cursors
• Stored Sub Programs

Advantages Of Stored Sub Programs compared to Independent SQL Statements

• Stored Procedures
• Creating , Altering and Dropping
• Optional Parameters
• Input and Output Parameters
• Permissions on Stored Procedures

• User Defined Functions
• Creating, Altering and Dropping
• Types Of User Defined Functions
• Scalar Functions
• Table Valued Functions
• Inline Table Valued Functions
• Multi Statement Table Valued Functions
• Permissions On User Defined Functions

• Triggers
• Purpose of Triggers
• Differences Between Stored Procedures and User Defined Functions and Triggers
• Creating, Altering and Dropping Triggers
• Magic Tables
• Instead Of Triggers

Exception Handling

• Implementing Exception Handling
• Adding and removing User Defined Error Messages To And From SQL Server Error Messages List
• Raising Exceptions Manual

CLR Integration

• What is CLR Integration and The Steps For Implementing It
• A Simple Example With CLR Integration
• Working With XML Data Type
• Backup and Restore Of Database
• Attach and Detach of Database
• Normalization

MS SQL trainer Profile & Placement

Our MS SQL Trainers

More than 7 Years of experience in MS SQL Technologies
Has worked on 7 realtime MS SQL projects
Working in a MNC company in Delhi
Trained 90+ Students so far.
Strong Theoretical & Practical Knowledge
MS SQL certified Professionals

MS SQL (microsoft sql dba) Placement Training in Delhi

More than 90+ students Trained
92 percent Placement Record
78 Interviews Organized
Placement Supported by InterviewDesk.com