Online Distributed Data eLearning Training
From Serebra Learning Corporation
LAN Implementation
In this WestNet e-Learning module, we review the operation and implementation of three established local area network (LAN) technologies: Ethernet, Token Ring, and Fiber Distributed Data Interface (FDDI).
more...
Data Warehousing
This course will provide an overview of Data Warehousing, an emerging technique for storage and retrieval of data from distributed heterogeneous sources. Students will be given an overview of Data Warehousing, study the various components of Data Warehousing Systems, and learn how to build, use and maintain a Data Warehousing System. Information systems managers, database administrators and other
more...
How Local Area Networks Work
In this WestNet e-Learning module, we will use the Open Systems Interconnection (OSI) model to explain the specific technologies and protocols used in most local area networks (LANs). More specifically, you will learn about the popular LAN protocols of Ethernet and Token Ring, and the increasingly important technology of wireless networking. We will start low in the OSI protocol stack, and then
more...
Systems Analysis Using the Client Server Model Part 3: Client Server Design
This is the final course in a three part series that deals with the design of the client server system. Students will learn server design distributed data processing client design and testing and performance monitoring.
more...
IBM DB2 UDB Essentials Part 2 - System and Database Administration
Following on from the first course in this curriculum this course focuses on the roles and principal tasks of the System Administrator and Database Administrators in IBM DB2. Administrative utilities and security are covered. The course also provides comprehensive introduction to the areas of database modelling database design and distributed data processing all core concepts within IBM DB2 UDB.
more...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks


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.
more...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks
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.
more...
MS SQL Server 6.5: Advanced Retrieval Structures


In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of SQL Server. This course, together with MS SQL Server
more...
Advanced SQL Programming
This course teaches the student how to create stored procedures, manage distributed data and transactions. The student will also learn the importance of locks and how to troubleshoot a deadlock. Finally the student will learn how to optimize the query execution plan developed by SQL Server. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.
more...
From 123-CBT Computer Based Training
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks

...tion 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
more...
SQL Server 2000 Database Admin Part 4 Managing Data

...rmation Services (DTS) process. Identify the features of distributed data. Identify the different methods of distributing data. Identify the features of the publisher-subscriber metaphor. Identify the features of the Database Maintenance Plan Wizard. Troubleshoot a database by using the Database Consistency Checker (DBCC). Identify the guidelines for performing a Database Consistency
more...
Oracle Database 10g Administration Workshop II Part 4

...gure an Oracle database for multilingual applications and distributed database access. Learners will learn how to use various database technologies, such as Resource Manager, the Scheduler, and materialized views.
Learn To:
Identify features of Automatic Storage Management (ASM).
Identify features of Automatic Storage Management (ASM) architecture.
Identify key concepts related to
more...
SQL Server 7 0 System Administration - Part 5

...s
Duration: 2 - 3 Hour(s)
Identify the benefits of distributed data.
Identify important considerations in data distribution.
Match the distributed data method with its attribute.
Identify the dynamic of the Publisher-Subscriber relationship.
Choose the appropriate attributes of Articles and Publications.
Match the data filtering method with its appropriate attributes.
Identify the
more...
SQL Server 7 0 - Implementing a Database - Part 5

...recommended effective practices for triggers. Unit 3: Distributed Data Duration: 2 Hour(s) Select the purposes for establishing linked servers. Perform the steps to connect to a remote SQL server. Match common OLE DB provider names with their data sources. Identify facts to consider when establishing linked server security. Match system stored procedures with the information they
more...
NetWare Service and Support Upgrade - Part 2

...rnet connection.
Identify the characteristics of a Fiber Distributed Data Interface (FDDI) network.
Identify the steps involved in the working of an FDDI network.
Identify the steps involved in troubleshooting an FDDI network.
Identify the characteristics of an Asynchronous Transfer Mode (ATM) network.
Identify the steps to connect an Ethernet network to the other networks.
Identify the
more...
Systems Analysis Using Client Server Model Part 3 Client Server Design

... client server system. Students will learn server design, distributed data processing, client design, and testing and performance monitoring. Learn To: o Match types of database management systems (DBMSs) with their features. o Match relational database management system (RDBMS) components with their functions. o Identify characteristics of indexes. o Identify advantages of
more...
CCNT Local Area Networks v6 0 Part 1

...Ring standard.
Identify the specifications of the Fiber Distributed Data Interface (FDDI) standard.
Identify the specifications supported by the IEEE 802.11b wireless standard.
Identify features of Transmission Control Protocol/Internet Protocol (TCP/IP) suite.
Identify features of media access control (MAC) addressing.
Identify features of Transmission Control Protocol (TCP) and User
more...
CCNT Broadband Technologies v 6 0 Part 1

...fy features of Ethernet.
Identify features of the Fiber Distributed Data Interface (FDDI).
Identify features of interconnecting networks.
Identify features of Transmission Control Protocol/Internet Protocol (TCP/IP).
Unit 2: SONET and SDH (3 - 4 hours)
Identify functions of Synchronous Optical Network (SONET).
Identify features of Synchronous Optical Network (SONET) signaling.
more...
From Teach Me IT
Advanced SQL Programming

... teaches students how to create stored procedures, manage distributed data, and transactions. The students also learn the importance of locks and how to troubleshoot a deadlock. Finally the students learn how to optimize the query execution plan developed by SQL Server.
1. Advanced Programming Features
A. Stored procedures
B. Distributed Data
C. Triggers
D.
more...
From Skillspride Online Training
Microsoft SQL Server 2000; Introduction to Databases and Programming
This course introduces readers to the major topics of databases and programming using Microsoft SQL Server 2000. The reader will learn about system databases, tables, data definition, creating tables, retrieving data, modifying data, indices, data integrity, views, triggers, stored procedures, programmability, distributed data and distributed transactions. Throughout the course there are practical
more...
