|
|
 |
Microsoft SQL Server 2000
Programming a MS SQL Server 2000 Database (2073)
|
|
|
Who Should Attend
| Network and database administrators responsible for the development, implementation and management of SQL Server 2000 databases, consultants, support engineers, MCP, MCSE and MCDBA candidates. |
Prerequisites
| Same as pre-requisites for course (2072) Administering a MS SQL Server 2000 Database. Plus course (2151) Windows 2000 Network & Operating System Essentials or have equivalent experience |
Course Objectives
| This course teaches you the knowledge and necessary skills required to effectively design and develop a database solution using Microsoft SQL Server 2000. Participants will learn all the primary skills require, including architectural concepts, Transact-SQL statements, rules and defaults in order to enforce data integrity. You will also learn indexing, how to create and use stored procedures, optimise query performance, analyse queries and finally set-up a distributed database environment |
Course Content
| 1. Orientation of SQL Server 2000
|
| 2. Orientation of Transact-SQL programming language and tools
|
| 3. Creating, modifying and working with SQL databases
|
| 4. Creating Data Types and Tables
|
| 5. Implementing data integrity using constraints, defaults and rules
|
| 6. Designing, creating and maintaining indexes
|
| 7. Defining and working with views
|
| 8. Creating, executing and modifying stored procedures
|
| 9. Implementing User-defined Functions
|
| 10.Creating, dropping and altering triggers
|
| 11.Programming Across Multiple Servers
|
| 12.Querying, modifying and managing distributed data
|
| 13.Querying multiple tables
|
| 14.Advanced query methods and performance
|
| 15.Organising and summarising data
|
| 16.Managing SQL Server 2000 transactions and locks |
|
|
|
|
Top