SQL Server 2008

SQL Server 2008

Microsoft SQL Server is a relational database management system developed by Microsoft Corporation. Its primary function is to store and retrieve data as requested by other software applications, on the same computer or other computers across the network. There are several editions of MS SQL Server for different kind of uses.


Analytic Square has achieved the noteworthy position as India's best training institute for SAS certification. In the last few years, there has been an extensive increase in collecting data by structure enterprise .

Module-1

  • Chapter 1. Overview of Microsoft® SQL Server™
  • Chapter 2. General database concepts
  • Chapter 3. Evolution of Database (DBMS, RDBMS, OODBMS)
  • Chapter 4. Database Objects (Table, View, Stored Procedure, User defined Functions)

Module-2

  • Chapter 1. GUI of SQL Server
  • Chapter 2. System Databases
  • Chapter 3. Inside the SQL Server database (.LDF and .MDF files)
  • Chapter 4. How to create database

Module-3

  • Chapter 1. Data types in SQL Server (General overview)
  • Chapter 2. Create Table- Basic
  • Chapter 3. Adding data into Table (INSERT INTO command)
  • Chapter 4. DML, DDL, DCL, DQL command
  • Chapter 5. Create Table- Advance (Referential Integrity, Constraints-Check, Default, Unique, Primary Key, Foreign Key)
  • Chapter 6. Cascade data

Module-4

  • Chapter 1. Select data
  • Chapter 2. Joining data
  • Chapter 3. Union Data
  • Chapter 4. Select with Crete
  • Chapter 5. Questions

Module -5

  • Chapter 1. Indexes- Structure and types of
  • Chapter 2. Creating Indexes
  • Chapter 3. Index working
  • Chapter 4. Optimization –Basic

Module-6

  • Chapter 1. Views in SQL Server
  • Chapter 2. Stored Procedures
  • Chapter 3. User Defined Functions
  • Chapter 4.Triggers

Module-7

  • Chapter 1. SQL Server Agent
  • Chapter 2. SQL Profiler

NOTE: FEE IS NON - REFUNDABLE