Online Ms SQL Server eLearning Training

MS SQL Server 2000: Database Administration Part 1: Installing SQL Server 2000 This is the first course in a five part series that presents the students with both theoretical and practical instruction in the subject of installing SQL Server 2000. more...

MS SQL Server 2000: Database Administration Part 2: Managing Databases This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects. more...

MS SQL Server 2000: Database Administration Part 3: Security and Data Recovery This is the third course in a five part series that deals with the backup and restore strategies for SQL Server 2000 and with managing security and permissions with SQL Server 2000. more...

MS SQL Server 2000: Database Administration Part 4: Managing Data This course deals with transferring data, managing replication services, and maintaining high availability. more...

MS SQL Server 2000: Database Administration Part 5: Maintaining SQL Server 2000 This is the last course in a five part series that deals with managing, monitoring, and troubleshooting SQL Server 2000. more...

MS SQL Server 2000: Design and Implementation Part 1: Introduction to SQL Server This is the first course in a five part series that 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. more...

MS SQL Server 2000: Design and Implementation Part 2: Managing Data This is the second course in a five part series that will teach students how to work with SQL Server data. more...

MS SQL Server 2000: Design and Implementation Part 3: Managing Objects This is the third course in a five part series that 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. more...

MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn 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. 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: Database Administration Part 1: Installing SQL Server 2000 This is the first course in a five part series that presents the students with both theoretical and practical instruction in the subject of installing SQL Server 2000.  more...

MS SQL Server 2000: Database Administration Part 2: Managing Databases This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects.  more...

MS SQL Server 2000: Database Administration Part 3: Security and Data Recovery This is the third course in a five part series that deals with the backup and restore strategies for SQL Server 2000 and with managing security and permissions with SQL Server 2000.  more...

MS SQL Server 2000: Database Administration Part 4: Managing Data This course deals with transferring data managing replication services and maintaining high availability.  more...

MS SQL Server 2000: Database Administration Part 5: Maintaining SQL Server 2000 This is the last course in a five part series that deals with managing monitoring and troubleshooting SQL Server 2000.  more...

MS SQL Server 2000: Design and Implementation Part 1: Introduction to SQL Server This is the first course in a five part series that 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.  more...

MS SQL Server 2000: Design and Implementation Part 2: Managing Data This is the second course in a five part series that will teach students how to work with SQL Server data.  more...

MS SQL Server 2000: Design and Implementation Part 3: Managing Objects This is the third course in a five part series that 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.  more...

MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn 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.  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: Installation & Administration In this course, students will be presented with a task-based, real-world scenario covering the implementation, administration and troubleshooting of Microsoft SQL Server 6.5. Implementation of SQL Server includes the installation of the software and the setup of the SQL database. Administration of SQL Server includes managing storage, the setting up of user accounts and assigning permissions. The more...

MS SQL Server 6.5: Design & Management In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: SQL Server implementor roles and responsibilities; data modeling and data definition concepts; database object creation, such as tables; and basic data retrieval, manipulation, and modification. This course, together with MS SQL Server 6.5 DB Design Il, prepares students for 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...

MS SQL Server 6.5: Management & Optimization In this course, students will be presented with a task-based, real-world scenario covering the, administration optimization, troubleshooting of Microsoft SQL Server 6.5. Administration of SQL Server includes managing storage, the setting up user accounts, and assigning permissions. The optimization, configuration, and diagnostics of SQL Server will also be covered. more...

Implementing MS SQL Server 7.0 This course provides the student with an introduction to the core technologies, architecture, and various features of Microsoft SQL Server 7.0. It also provides the student with the preliminary knowledge and skills required for planning and installing SQL Server 7.0. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0. more...

Managing MS SQL Server 7.0 This course provides the student with ways to configure SQL Server and managing data in SQL Server. It also presents ways to manage various administrative tasks. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0. more...

Managing MS SQL Server 7.0 Security This course enables the student to plan a backup and restoration strategy for preventing data loss. It also provides the student with an introduction to SQL security concepts and the security accounts used by SQL Server. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-028). more...

Optimizing & Troubleshooting MS SQL Server 7.0 This course teaches the student how to monitor and optimize the SQL Server performance. The student will learn how to detect and troubleshoot various problems that occur while installing SQL Server 7.0 and when establishing client connections. The student will also learn about different replication and backup problems and how to troubleshoot the same. more...

MS SQL Server 7.0 Basics This course teaches the student the concept of database and tables in SQL Server 7.0. It also covers the tools used to maintain data integrity. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 7-029. more...

Planning an MS SQL Server 7.0 Data Warehouse This course provides the student with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides the student with the preliminary knowledge for planning and implementing data warehouses using SQL Server 7.0 In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019). more...

Implementing an MS SQL Server 7.0 Data Warehouse This course teaches the student how to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of crating files and filegroups and helps students to select an application programming interface for accessing a data source. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL more...

Using MS SQL Server 7.0 OLAP Services This course provides the student with an introduction to the concepts, architecture, and various features of the Online Analytical Processing (OLAP) services. It also provides students with the preliminary knowledge for creating a data warehouse for use with OLAP services. The students will be able to design and optimize an OLAP database. In addition, the course prepares students to take the more...

Optimizing a MS SQL Server 7.0 Data Warehouse This course helps the student to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019). more...