.Net Framework | ASP | C# | .Net Online Training | .Net Online Training India | Microsoft Technologies

Yahoo Profile Of Gods Grace Technologies  Gods Grace Technologies On Facebook  Gods Grace Technologies On Flickr  Gods Grace Technologies On Digg  Gods Grace Technologies On Twitter  Gods Grace Technologies On Delicious

MS SQL SERVER
MS SQL SERVER Online Training India

1.Introduction to SQL SERVER

  • History of SQL SERVER
  • Software And Hardware Requirements
  • IP Configuration, Domain Creation
  • Client-Server Architecture
  • IIS Configuration
  • Installation Process
  • Services, Checks after installation
  • Architecture of SQL SERVER 2005
  • Server startup process
  • Tools in SQL SERVER 2005
  • Management Studio(SSMS)
  • BI Tools(BIDS)
  • Configuration Tools
  • Performance Tools(Profiler)

2.Enabling Remote Connections

  • TCP/IP
  • Named Pipes

3.Authentications

  • Windows Authentications
  • SQL Server Authentications

4.Securities

  • Logins
  • Users
  • Roles
  • Password Management
  • Database Assignment
  • Privileges
  • Schema

5.Databases

  • System Databases
  • User Databases

6.Database Designing

  • Creating Database
  • Altering Database

7.Files And File Groups

  • Data Files
  • Log Files
  • Primary File Group

8.Memory Architecture

  • Data Pages
  • Header and Description
  • Extents

9.Transactions in SQL SERVER

  • Commit
  • Rollback
  • Buffer
  • Checkpoint

10.Recovery Models

  • Full
  • Bulk Logged
  • Simple
  • Non Logged Operations

11.Compatibility

  • 2005
  • 2000
  • 7.0

12.Backups and Planning

  • Full
  • Differential
  • Transaction Log
  • Files and File Groups
  • Temporary
  • Jobs and Schedules
  • Back up Device
  • Append and Over write

OLTP and OLAP

Import and Export

13.SSIS

  • Migrations
  • SSIS Vs DTS Packages
  • Transformations

Up gradation

14.Replication

  • Publisher
  • Publication
  • Subscriber
  • Subscription
  • Distributor
  • Agents
  • Snap Shot Publication
  • Transactional Publication
  • Merge Publication
  • Replication monitor

15.Log Shipping

  • Primary Servers
  • Secondary Servers
  • Monitoring Servers
  • Jobs and Schedules
  • Blocking of Jobs
  • High Availability

16.Mirroring

  • Principle Server
  • Mirror Server
  • Witness Server
  • Mirror_Error
  • Stand by Server

17.SQL SERVER AGENT

  • Jobs
  • Schedules
  • Alerts
  • Operators
  • Error Logs

Database Mail

1.Maintenance Plan

  • Through SSMS
  • Through SSIS

Second tab content...

Third tab content...