Microsoft
SQL Server 2000 Development
Course
Description
In the age of e-commerce, Microsoft
SQL Server 2000 database features and capabilities
allow students with the required knowledge and experience
to develop and implement database solutions for world-class
organizations.
This course provides extensive hands-on experience
creating stored procedures and triggers, and developing
SQL queries that utilize the full extent of the SQL
Server
Intended
Audience
This course is valuable for programmers, analysts,
developers and designers, working with SQL Server
2000 and building database applications. Some SQL
experience is assumed.
Objectives
Upon completion of this course, students will be
able to understand:
- SQL statements review and evaluation
- SQL Server overview
- Overview of programming
- Creating and managing SQL Server databases
- Creating data types and tables
- Implementing data integrity
- Planning indexes
- Creating and maintaining indexes
- Implementing views
- Implementing stored procedures
- Implementing user-defined functions
- Implementing triggers
- Programming across multiple servers
- Query performance
- Analyzing queries
- Using graphical SHOWPLAN
- Managing transactions and designing locks
|
