+91 989 971 4317
analyticsquare@gmail.com

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 .

Developing SSIS Packages

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

Book Class Room