Microsoft SQL Server™ 2000 Designing and Implementing Databases

The Implementing a Databases on Microsoft SQL Server 2000 Curriculum is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 2000. This curriculum will help students prepare for Microsoft certification exam 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000. Skills taught in this series include construct and manage databases; implement data integrity; create and maintain indexes; query multiple tables using Transact-SQL statements; define transactions and set transaction isolation levels; access data by using the Stored Procedure model; access data using triggers; and set up a distributed environment to access, modify and manage remote data.

Audience

The audience for this course includes Databasesers, database managers, and technical managers. Candidates for Exam 70-229 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Students are expected to have experience with using the Microsoft Windows 2000 operating system. Students are also expected to understand database concepts and Transact-SQL syntax. Students should be familiar with the role of the database administrator.

This course presents students with both theoretical and practical instruction in SQL Server, the Transact-SQL language, and SQL Server Databases.

Introduction to SQL Server

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.
Match Data Control Language (DCL) statements with their functions.
Identify the functions of Data Definition Language (DDL) statements.
Identify the types of SQL Server 2000 databases.
Identify the features of the SQL Server 2000 object-naming standard.
Identify the methods for retrieving metadata information.

Managing Data

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 functions of database user accounts and roles in SQL Server 2000.
Match the types of roles in SQL Server 2000 with their characteristics.

Managing Objects

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 considerations for creating stored procedures.
Identify the features of encrypting stored procedures.
Identify the characteristics of triggers.
Identify the advantages of using triggers.
Identify guidelines for creating triggers.

Managing Indexes

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 functions of the query optimizer.
Identify the features of cost-based optimization.
Sequence the steps for processing queries by using query optimizer.

Distributed Data and Locks

Identify guidelines for importing and exporting data.
Match SQL Server 2000 tools used to import and export data with their functions.
Identify the features and functions of the Data Transformation Services (DTS) process.
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.

Delivery

Computer Based Training (CD-ROM) and manual

Content

Interactive, skills-based with full testing for exam preparation

Duration

Approx 40 hours

Qualifications

Microsoft Certified Professional (MCP) Exam 70-229

Pre-requisites

Microsoft Access or Database Fundamentals or relevant experience.

Click here to get a free information pack

Call us on 01492 623887 with any enquiries

Top

Distance learning/Self Study

All courses are designed to offer you the student the convenience of studying from the comfort of your own home or workplace, working at your own pace in the way that is most suited to your lifestyle and career commitments. Working at your own pace means that you are more likely to learn the subject in-depth as you are not under pressure to compete with other students who may be better or worse than, so you will never lag behind or be waiting for somebody to catch up.

Keimos Database Courses

Our courses use simulations extensively to provide opportunities for students to learn & practice skills-based content. This “learning by doing'” model is far more effective than the traditional true/false, multiple choice approach. Live application software is not needed.

Interactive content is used often in the courses to engage the learner's attention, to reinforce and exercise skills being taught, and to provide feedback on the learner's grasp of a skill or concept.