• This course will introduce students to the key concepts and features of SQL server architecture.
  
  
• They will program using Transact SQL, how to maintain data & referential integrity within the database and to write stored procedure.
  
  
• This course will help students undergo MCSE / MCSD Elective Exam.
  
  
• The following are the topics covered in this course :
  
  
  • OVERVIEW OF SQL SYSTEM DATABASES
    
  • DATA DEFINITION
    
  • TRANSACT SQL STATEMENTS
    
  • JOINS & SUB QUERIES
    
  • INDEXING & DATA RETRIEVAL
    
  • USING VIEWS, DEFAULT & RULES
    
  • PROGRAMMABILITY
    
  • TRIGGERS
    
  • REPLICATION
    
  • APPLICATION DEVELOPMENT & OPEN DATA SERVICES