SQL Server

SQL Server Training

Contents

  • 1 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.6 Views
  • 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