Starting Online New Batches of JAVA from 2/Dec/2020 at 5:00pm Get Detail

SQL Server

SQL Server

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.

Sensible Contact Quick Contact Call a Course Adviser for discussing Curriculum Details Sensible Computers Customer Care +91 93013-51989

SQL Server Course Overview

1.1 SQL Server Training Prerequisite

1.2 SQL Server Training Course Objective

1.3 SQL Server Course Duration

2 SQL Server Training Course Content

2.1 Introduction To DBMS

2.2 Introduction To SQL Server

2.3 TSQL (Transact-Structured Query Language)

2.3.1 Introduction To TSQL

2.3.2 Data Manipulation Language

2.3.3 Data Query Language (DQL)

2.3.4 Built In Functions

2.4 Top n Clause

2.4.1 Set Operators

2.4.2 Joins

2.4.3 Sub Queries

2.4.4 Indexes

2.4.5 Security


2.4.7 Transaction Management

2.4.8 TSQL Programming

2.4.9 Cursors

2.4.10 Stored Sub Programs

2.5 CLR Integration

2.6 Working With XML Data Type

2.7 Backup and Restore Of Database

2.8 Attach and Detach of Database

2.9 Normalization