SQL Server Training in Chennai

SQL Server Training in Chennai

#SECTION-1

Overview of SQL Server

  • SQL Server architecture overview
  • Features of SQL Server

#SECTION-2

Authentication Modes

  • SQL Server Authentication Mode
  • SQL Server Authentication Mode
  • SQL Server Authentication Mode
  • Object Explorer Details

#SECTION-3

Introduction To TSQL

  • History and Features of TSQL
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)

#SECTION-4

Data Manipulation Language

  • Identity
  • Creating A Table From Another Table
  • Inserting Rows From One Table To Another r>

#SECTION-5

Data Query Language (DQL)

  • Where clause
  • Column aliases

#SECTION-6

Built In Functions

  • Scalar Functions
  • Numeric Functions Conversion Functions
  • Parameters Limitations
  • Date Functions
  • Convenient Aggregate Functions

#SECTION-7

BTop n Clause

  • Set Operators
  • Sub Queries
  • Set Operators
  • Indexes

#SECTION-8

Stored Sub Programs

  • Stored Procedures
  • User Defined Functions
  • Triggers
  • Exception Handling

#SECTION-9

CLR Integration

  • Working With XML Data Type
  • Backup and Restore Of Database
  • T Attach and Detach of Database
  • Normalization