 |  |  |  |  |  |
| Course | Microsoft SQL Server 2000 for Windows | |
| Duration | 5 Days | |
| Content | SQL Server Overview | What
is SQL Server SQL Server Integration SQL Server Databases SQL Server Security Working with SQL Server |
| Overview of Programming SQL Server | Designing
Enterprise Application Architecture SQL Server Programming Tools The Transact-SQL Programming Language Elements of Transact-SQL Additional Language Elements Ways to Execute Transact-SQL Statement |
|
| Creating and Managing Databases | Creating
Databases Creating Filegroups Managing Databases Introduction to Data Structures |
|
| Creating Data Types and Tables | Creating
Data Types Creating Tables Generating Column Values Generating Scripts |
|
| Implementing Data Integrity | Types
of Data Integrity Enforcing Data Integrity Defining Constraints Types of Constraints Disabling Constraints Using Defaults and Rules Deciding Which Enforcement Method to Use |
|
| Planning Indexes | Introduction
to Indexes Index Architecture How SQL Server Retrieves Stored Data How SQL Server Maintains Index and Heap Structures Deciding Which Columns to Index |
|
| Creating and Maintaining Indexes | Creating
Indexes Creating Index Options Maintaining Indexes Introduction to Statistics Querying the sysindexes Table Setting Up Indexes Using the Index Tuning Wizard Performance Considerations |
|
| Implementing Views | Introduction
to Views Advantages of Views Defining Views Modifying Data Through Views Optimising Performance by Using Views Performance Considerations |
|
| Implementing Stored Procedures | Introduction
to Stored Procedures Creating, Executing, Modifying and Dropping Stored Procedures Using Parameters in Stored Procedures Executing Extended Stored Procedures Handling Error Messages Performance Considerations |
|
| Implementing User-defined Functions | What
is a User-defined Function? Defining User-defined Functions Examples of User-defined Functions |
|
| Implementing Triggers | Introduction
to Triggers Defining Triggers How Triggers Work Examples of Triggers Performance Considerations |
|
| Optimising Query Performance | Introduction
to the Query Optimiser Obtaining Execution Plan Information Using an Index to Cover a Query Indexing Strategies Overriding the Query Optimiser |
|
| Analysing Queries | Queries
That Use the AND Operator Queries That Use the OR Operator Queries That Use Join Operations |
|
| Managing Transactions and Locks | Introduction
to Transactions and Locks Managing Transactions SQL Server Locking Managing Locks |
|