MCAD Certification Training SQL
Our training course for Microsoft Certification SQL Database Implementation for Exam 70-229 is co-developed with Microsoft and is guaranteed to contain everything required to pass the certification exam. The CBT
contains the complete course material, interactive lab exercises and practice exam simulators. The Approve Microsoft Course Book is also included with your training course.
Overview
 The Microsoft SQL Server 2000 Designing and Implementing Databases Curriculum
presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. It
will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and
triggers, and SQL Server indexes, how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries. This
curriculum teaches SQL Server 2000 transactions and locks, and how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked
servers, create transactions, manage locks, and how to troubleshoot transactions and locking.
MCAD MCSD SQL 2000 Training Tutorial Course on CD
This curriculum consists of five Skill Builder courses: Course 73480 Microsoft SQL Server 2000 Designing and Implementing Databases -
- Part 1: Introduction to SQL Server Course 73481 Microsoft SQL Server 2000 Designing and Implementing Databases -
• 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.
- Part 2: Managing Data Course 73482 Microsoft SQL Server 2000 Designing and Implementing Databases -
• 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.
- Part 3: Managing Objects Course 73483 Microsoft SQL Server 2000 Designing and Implementing Databases -
• 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.
- Part 4: Managing Indexes Course 73484 Microsoft SQL Server 2000 Designing and Implementing Databases -
• 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.
- Part 5: Distributed Data and Locks
Audience
The audience for this curriculum includes database designers, 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.
Learning Time
30 to 40 hours
|
