SQL Server Online Training

In short, Structural Query Language is called as SQL. It is the base to enter into Analytics, Datawarehouse and various jobs. Since past few years, data is increasing rapidly from multiple sources due to various reasons. Whenever data increases, SQL requirement also increases. It is a common Database language to interact with any Databases like MySQL, Postgres, SQL Server, Oracle, DB2, etc. SQL is required in most of the project related to Banking, Healthcare, Telecom, Finance, etc. This Course is designed from basic to advanced level topics based on IT industry requirement. From this course, you will learn all the topics required for real-time project work. This course will help you to build your career as the role of Development, Database/ETL Testing, Support, DBA, etc.

Course Objectives

What are the Course Objectives?

Understanding high-level Architecture of Database.
Work independently in Development, Support and Testing Project.
In-depth knowledge of various advanced concepts.prepare the Complex queries.
Upgrade database related technologies like DBA, Datawarehouse, Bigdata, ETL, etc.

Who should go for this Course?

Any IT experienced Professional.
Any B.E/ B.Tech/ BSC/ M.C.A/ M.Sc Computers/ M.Tech/ BCA/ BCom College Students in any stream.
Fresh Graduates

Pre-requisites:

The course can learn by any IT professional having basic knowledge of :

Computer System
DBMS Concepts

Course Curriculum

SQL Server Online Training Modules

BASIC CONCEPTS

Database Concepts
RDBMS Concepts
Data Models
Constraints
Normalization- 1NF,2NF,3NF,BCNF etc
ER Diagrams

SQL SERVER CONCEPTS

Introduction to Sql Server 2008 R2
Sql Server 2008 Features
Server Types
Editions
Components
Management Studio
T-SQL Features
New Operators
DML Statements

T-SQL

DDL
Data Types
System Defined Data Types
User defined Data
Create/modify/delete tables
Operators
DML
DCL
Using Select Statement

MAINTAINING DATABASE INTEGRITY

Constraints
Rules
Entity Integrity
Domain Integrity
Referential Integrity

SUBQUERIES

Built-in function
Nested Sub Queries
Correlated Sub Queries
Derived tables
Recursive queries
Common Table Expression

JOINS

Cross Join, Inner Join, Self Join, Outer Join

INDEXES

Types of Indexes
• Creating indexes
Modifying indexes
Dropping indexes

VIEWS

About View
Creating Views
Altering Views
Materialized Views
Distributed View

STORED PROCEDURES

Advantages
System Stored Procedures
Extended Stored Procedures
Parameter Handling

USER DEFINED FUNCTIONS

Returning Scalar Value
Returning Table of Data
Deterministic Functions
Non Deterministic Functions

TRIGGERS

Constraints Vs Triggers
After Triggers
Instead of Trigger
DDL Triggers
Altering and Dropping Triggers

CURSORS

Select Vs Cursors
Types of Cursors
Creating Cursors
Open/Fetch/Close Cursors
Using Cursors in Stored Procedures and Triggers

MICROSOFT .NET FRAME WORK INTEGRATION

CLR Integration
UDA
UDF
Stored Procedures
Triggers

TRANSACTIONS AND LOCKS

ACID Properties
Implicit Transactions
Explicit Transactions
Transaction Process
Concurrency Problems
Lock Types
Distributed Transactions
Dead Locks

DATA TRANSFORMATION SERVICES

ADMINISTRATIVE TASKS

Creating Database
Copy, Maintaining Database
Security Concepts
Schemas, Permissions
Backup and Restore Database
Sql Server Agent
Sql Server Profiler
Database Engine Tuning Adviser

SQL SERVER MANAGEMENT OBJECTS

Programming with SMO
Connecting to Sql Server
Scripting

XML IN SQL SERVER

XML in Sql Server

WORKING WITH IMAGES

Working with Images

INTRODUCTION TO MS- BI

SSRS
Standard, Ad- hoc Embedded Reports
SSIS
SSAS

SQL SERVER 2012 FEATURES

Sequence
OFFSET and FETCH
WITH RESULT SETS in stored procedure THROW in triggers