About Aptech Computer Education
Courses Offered
Placement Services
Partnership Benefits
News and Events
About Aptech
e-Aptechite Newsletter



 
Aptech short-term courses: SQL Server 2000
SQL Server 2000 is a RDBMS package from Microsoft. It is an environment used to create databases on a Microsoft Windows operating system. It offers a very high degree of performance and scalability for applications running in client/ server and N-tier architectures. It is largely used in medium-sized establishments
Who will the course benefit?  
Individuals who design, implement and maintain online query applications to create and employ database query programmes using SQL Server 2000  
What skills will the student gain?
 
Prerequisites
Basic knowledge of RDBMS concepts  
Duration  
40 hours
Certification  
Certificate of participation
 
   
After the completion of this course, the student will be able to:
Understand SQL Server features and architecture
Work with SQL Server 2000 Tools and Transact SQL
Work with Tables, Data Types and Joins
Create sub-queries, aggregate functions, and summarise data
Work with Data Integrity Tools and Indexes
Implement triggers and stored procedures  
Manage Transactions Locks and Cursors  
     
 
 
 
 
 
Copyright © Aptech Ltd.