Back To Microsoft Training Courses

Microsoft SQL Server 2000 Designing and Implementing Databases Training CBT Suite

Price: $645.00

CBT Course Overview:

The Self Study Store Computer Based Training Microsoft SQL Server 2000 Designing and Implementing Databases presents learners with instruction of how to install, manage, monitor, and troubleshoot SQL Server 2000.

Total Training Duration:

40 hours

CBT Course Modules:

• Microsoft SQL Server 2000 Database Administration Part 1: Installing SQL Server 2000 Training
• Microsoft SQL Server 2000 Database Administration Part 2: Managing Databases Training
• Microsoft SQL Server 2000 Database Administration Part 3: Security and Data Recovery Training
• Microsoft SQL Server 2000 Database Administration Part 4: Managing Data Training
• Microsoft SQL Server 2000 Database Administration Part 5: Maintaining SQL Server 2000 Training

Training Course Topics:

• Identify the features and functions of SQL Server 2000.
• Match the components of the client-server communication process with their features.
• Identify the features and functions of SQL Server 2000 services.
• Match the basic types of statements used in Transact-SQL with their functions.
• Identify the SQL Server 2000 system-supplied data types.
• Add a user defined data type.
• Match the parts of a data row with their features.
• Identify characteristics of entity modeling.
• Identify features of attributes.
• Identify requirements for logical modeling.
• Identify the login authentication modes and methods used by SQL Server 2000.
• Identify the features of views.
• Identify the considerations for creating views.
• Create a view by using Transact-SQL.
• Match the different user-defined functions with their characteristics.
• Create a user-defined function by using Transact-SQL.
• Identify characteristics of schema binding.
• Identify the features of stored procedures.
• Identify the features of clustered indexes.
• Identify the features of nonclustered indexes.
• Retrieve information from the sysindexes table.
• Identify guidelines for creating indexes.
• Identify the considerations for creating unique indexes.
• Identify the considerations for creating composite indexes.
• Identify the features of distributed data.
• Identify the different methods of distributing data.
• Match the replication types with their characteristics.
• Identify the considerations for using transactions and locks.
• Create a Transact-SQL script to define a transaction.
• Create a Transact-SQL script to rollback a transaction.
• Much more.