|
Provided by: 123-CBT Computer Based Training SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks |
 |
Training
Provided by 123-CBT Computer Based Training
This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover 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.
o Match SQL Server 2000 tools used to import and export data with their functions.
o Identify the features and functions of the Data Transformation Services (DTS) process.
o Identify the features of distributed data.
o Identify the different methods of distributing data.
o Match the replication types with their characteristics.
o Identify the considerations for using transactions and locks.
o Create a Transact-SQL script to define a transaction.
o Create a Transact-SQL script to rollback a transaction.
CEU credits: 0.70 CEUs
o Identify guidelines for importing and exporting data.
o Match SQL Server 2000 tools used to import and export data with their functions.
o Identify the features and functions of the Data Transformation Services (DTS) process.
o Identify the features and functions of DTS tools.
o Identify the functions of data transformation and mapping.
o Identify tasks that can be defined within a DTS package.
o Identify the features for defining a workflow.
o Identify guidelines for creating a DTS package.
o Import data into SQL Server 2000 by using the Bulk Insert Task.
o Import data from a Transact-SQL query.
o Modify a DTS package by using DTS Designer.
o Transfer SQL Server 2000 objects.
Learn To:
o Identify guidelines for importing and exporting data.o Match SQL Server 2000 tools used to import and export data with their functions.
o Identify the features and functions of the Data Transformation Services (DTS) process.
o Identify the features of distributed data.
o Identify the different methods of distributing data.
o Match the replication types with their characteristics.
o Identify the considerations for using transactions and locks.
o Create a Transact-SQL script to define a transaction.
o Create a Transact-SQL script to rollback a transaction.
Audience
The target audience for this course 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). Learners are expected to have experience with using the Microsoft Windows 2000 operating system. Learners are also expected to have an understanding of basic relational database concepts and have knowledge of basic Transact-SQL syntax. In addition, learners should have taken the first four parts of this series (73480-73483).Deployment Options
Internet / Intranet, Download, LAN, WorkstationAccreditation
NASBA credits: 4 CPE CreditsCEU credits: 0.70 CEUs
Language Options
American EnglishTotal Learning Time
7 hours73484 Objectives
Unit 1: Transferring Data 3 hourso Identify guidelines for importing and exporting data.
o Match SQL Server 2000 tools used to import and export data with their functions.
o Identify the features and functions of the Data Transformation Services (DTS) process.
o Identify the features and functions of DTS tools.
o Identify the functions of data transformation and mapping.
o Identify tasks that can be defined within a DTS package.
o Identify the features for defining a workflow.
o Identify guidelines for creating a DTS package.
o Import data into SQL Server 2000 by using the Bulk Insert Task.
o Import data from a Transact-SQL query.
o Modify a DTS package by using DTS Designer.
o Transfer SQL Server 2000 objects.
|
|
||||||||||
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
