[ Home ] [ IT Training ] [ Careers ] [ About Us ] [ How To reach ] 

• Overview of SQL Server 2000 database organization
  Components of SQL Server

• Installing SQL Server
  SQL Server services
  Starting SQL Server services
  Stopping and pausing SQL Server services

• Database architecture
  Transaction log architecture
  Using system and database catalogs

• Creating a user database
  Setting database options
  Managing user database size
  Organizing database files

• Managing access to SQL Server
  Creating and managing logins
  Understanding the authentication process

• Performing administrative tasks
  Performing configuration tasks
  Performing maintenance tasks
  Defining operators
  Defining jobs
  Configuring alerts

• Database backups
  Backing up databases, files, file groups and transaction logs
  Restoring user databases
  Restoring and rebuilding system databases

• The Bulk Copy Program (bcp)
  The BULK INSERT statement in Transact-SQL

• Monitoring database performance and activity
  Using the monitoring tools

• SQL Server replication
  Planning for replication
  Implementing replication
  Monitoring and administering replication
  

Corporate Office:
207, Lok Center, Marol-Maroshi Road, Marol, Andheri (East), Mumbai 400 059. India.
Tel: +91- 22- 2920 1583, 2920 6976, 2925 7840, 2920 9720, 2920 4122, 2925 7632, 2920 4130, 2920 8902, 2925 3052, 2925 7689, 2920 7387, 2920 6329 Fax. No: +91-22- 2920 7388      |e-mail: info@pragatisoftware.com

© Pragati Software Pvt. Ltd. All rights reserved.