SQL Server Training

Overview

About SQL Server Training

This SQL Server training teaches developers all the Transact-SQL skills they need to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server. Gives idea about writing Queries & Sub-queries, working with Joins, etc. As well as database management skills like backup, restore, etc.

SQL Server Training Course Prerequisite

No Prior Experience is Presumed.

SQL Server Training Course Objective

Learn Database models
Overview of SQL Server Management Studio and Transact-SQL language
Master writing simple and complex queries that retrieve data from the database
Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
Insert, update, and delete data
Retrieve data from tables
Joins
Sub-queries
Working with Data Types
Procedure and Functions
Understand the different Views
Working with Triggers
Design a database
Maintain databases, tables, and sequences with SQL statements
Create and manage views
Ensure the integrity of multiple, related database updates by using transactions
Retrieve data using cursors
Manage binary data using BLOBs

SQL Server Training Course Duration

30 Working days, daily one and half hours

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

Hierarchical Data Model (HDBMS)
Network Data Model (NDBMS)
Relational Data Model (RDBMS)
Object Data Model (ODBMS)
Object Relational Data Model (ORDBMS)

Conceptual 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
Data Types In TSQL
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

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

Overview

CCNA is the associate level Certification in Networking offered by Cisco. CCNA in Routing and switching covers basics of Cisco Networking and Routing switching technologies along with IP addressing schemes, routing basics, switching and Wan Technologies. After completion of CCNA course, a candidate can easily install, configure and troubleshoot Cisco Routers and switches for small Networks. After completion of CCNA certification, student can go for CCNP course. Network Bulls provides CCNA course Training on real Routers and switches. Network Bulls provides 24x7 Lab facilities for students to perform practical on real Cisco devices.

We are Best Institute for Cisco CCNA course Training in India. Network Bulls provides CCNA course in Gurgaon Center on Real Cisco devices (Routers and Switches), with 24x7 Lab Facility. CCNA course is delivered as per Cisco CCNA Certification exam blueprints. Training Center is situated in Gurgaon with Biggest Cisco CCNA Training labs in India. CCNA Coaching is also delivered Online. Network Bulls is considered as one of the best CCNA Training Institute in Delhi, Gurgaon. We also provide Industrial and Summer Trainings in Gurgaon and Delhi.

CCNA Training is conducted using real Cisco devices. We do not use simulator softwares in our classes or labs. In order to prepare for CCNA certification online exam conducted by Cisco, candidates need to work on real devices instead of relying on simulators. To crack CCNA certification exam in first attempt candidate need to practice at-least for 3-4 hours a day during classes.

CCNA certification Exam details:

Candidates need to clear either ICND1 and ICND2 online exams or composite exam of CCNA in order to get the certification. Latest exam code of CCNA composite exam also known as CCNAx is 200-120. Fee for CCNA certification composite exam is 295 USD and passing marks required are 825 out of 1000. CCNA exam is conducted online in Pearson Vue testing centers.

Course Content

Training Plan

CCNA Training Fee and Duration:
Track	Regular Track	Weekend (Sat & Sun)
Duration	40 Days	8 Weekends
Hours	2 hours a day	3 hours a day
Training fee	8000/-	8000/-

Month	First Batch	Second Batch	Third Batch	Fourth Batch
Training Schedule for CCNA course:
August	4th Aug 2015	11th Aug 2015	18th Aug 2015	25th Aug 2015
September	1st Sept 2015	8th Sept 2015	15th Sept 2015	22nd Sept 2015
October	6th Oct 2015	13th Oct 2015	20th Oct 2015	27th Oct 2015
November	3rd Nov 2015	10th Nov 2015	17th Nov 2015	24th Nov 2015