Microsoft SQL
Microsoft SQL Server 2000 Development Level I
(12 HRS)

• Exploring components, features and services of SQL Server
• Identifying administrative utilities
• Using SQL Server Enterprise Manager and Query Analyzer
• Working with and programming in Transact-SQL
• Database structure
• Inserting and selecting data
• Designing, creating and managing tables

 Microsoft SQL Server 2000 Development Level II
(12 HRS)

• Maintaining and normalizing table designs
• Using Enterprise Manager to generate a script
• Implementing constraints
• Joining and querying multiple tables
• Implementing advanced table joins
• Generating a workload file in SQL Profiler

 Microsoft SQL Server 2000 Development Level III
(12 HRS)

• Designing, creating, managing and dropping views
• Displaying view information
• Creating indexed and partitioned views
* Creating, designing, executing and managing stored procedures
• Using functions
• Creating, designing and implementing triggers
• Understanding transactions and locks
• Implementing distributed queries