SQL Server 7.0 Data Warehousing SQL Part I This course is designed to help students gain knowledge of the core components of data warehousing application development tools and SQL management tools. The course introduces basic concepts terminology for understanding SQL Server 7.0 relational databases Structured Query Language and new or improved features. It builds on this foundation to cover client/server web applications programming 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...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks ...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. 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 more...
SQL Server 7 0 System Administration - Part 4 ....
Identify the features of Data Transformation Services (DTS).
Identify data source and data destination types provided in SQL Server.
Match each Data Transformation Services (DTS) tool with its function.
Identify the features of restructuring and mapping data.
Select the functions that can be performed using Data Transformation Services (DTS) steps.
Identify the features of Datamore...
Optimizing an SQL 7.0 Data Warehouse The Optimizing an SQL 7.0 Data Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It helps students to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query more...