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

SQL Server 2000 

Duration:    4 days

Course Contents:

• Introduction to SQL Server
  Working with tables
  Creating Tables
  Data types and user defined data types
  Indexes
  Constraints
  Identity properties
  Temporary tables

• Querying data
  The Select statement
  Joins
  Dealing with nulls
  Subqueries
  Views and derived tables
  Other search expressions (like, between, etc.)

• Modifying Data
  Basic modification operations
  Internal and performance considerations

• Programming with Transact -SQL
  Transact-SQL programming constructs

• Batches,
  Transactions
  Stored procedures
  Triggers

• Cursors
  Cursors and ISAM
  Appropriate use of cursors
  Cursor syntax and behavior
  

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.