|
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
|
Course |
Hours |
Days |
Times |
Dates |
Price |
| SQL - Level II |
12 |
M |
6 pm - 9 pm |
In session! |
$384.00 |
| SQL - Level III |
12 |
M |
6 pm - 9 pm |
9/25, 10/2, 10/9, 10/23 |
$384.00 |
| 
