Online 72470-72474 eLearning

SQL Server 7 0 - Implementing a Database - Part 1 Course Overview This is the first course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Identify the components of SQL Server 7.0. Identify the characteristics of Transact-SQL and its processing. Perform the skills to construct and manage databases. C ontent Emphasis  more...

SQL Server 7 0 - Implementing a Database - Part 2 Course Overview This is the second course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Implement data integrity. Create and maintain indexes. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database  more...

SQL Server 7 0 - Implementing a Database - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Query multiple tables using Transact-SQL statements. Retrieve and modify data using advanced query techniques. C ontent Emphasis Skills-Based A udience This course is designed for IT  more...

SQL Server 7 0 - Implementing a Database - Part 4 Course Overview This is the fourth course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Generate summary value and summary data as well as generate control break reports using aggregate functions. Define transactions and set transaction isolation levels. Identify the purpose and  more...

SQL Server 7 0 - Implementing a Database - Part 5 Course Overview This is the final course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Access data by using the Stored Procedure model. Access data using triggers. Set up a distributed environment to access, modify and manage remote data. C ontent Emphasis Skills-Based A  more...

SQL Server 7 0 Designing Implementing Data Warehouses - Part 1 ... is recommended that participants take NETg course series 72470-72474, Microsoft SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Data Warehousing: Basic Concepts Duration: 2 - 3 Hour(s) Sequence the phases in the  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2 ... is recommended that participants take NETg course series 72470-72474, Microsoft SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge and have completed the first course in this series. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: OLAP Systems Duration: 1 - 2 Hour(s)  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3 ... is recommended that participants take NETg course series 72470-72474, Microsoft SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge and have completed the first two courses in this series. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Data Warehouse Implementation  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 ... is recommended that participants take NETg course series 72470-72474, Microsoft SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge and have completed the first three courses in this series. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Data Access: Relational Data  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5 ... is recommended that participants take NETg course series 72470-72474, Microsoft SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge and have completed the first four courses in this series. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Microsoft Repository Duration: 2 -  more...