Online Ms SQL eLearning Training
From Serebra Learning Corporation
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...
From 123-CBT Computer Based Training
SQL Server 2000 Querying with Transact SQL Curriculum

The MS SQL Server 2000 Querying with Transact SQL Curriculum includes the following courses: MS SQL Server 2000: Querying with Transact SQL Part 1(Manipulating Data) MS SQL Server 2000: Querying with Transact SQL Part 2(Working with Queries) To review individual course descriptions, please return to the previous page and select the desired title(s).
more...
SQL Server 2000 Designing Implementing Databases Curriculum

...MS SQL Server 2000 Designing & Implementing Database Curriculum includes the following courses: MS SQL Server 2000: Design & Implement Databases Part 1(Intro. to SQL Server) MS SQL Server 2000: Design & Implement Databases Part 2 (Managing Data) MS SQL Server 2000: Design & Implement Databases Part 3(Managing Objects) MS SQL Server 2000: Design & Implement Databases Part 4(Managing
more...
SQL Server 2000 Database Administration Curriculum

...MS SQL Server 2000 Database Administration Curriculum includes the following courses: MS SQL Server 2000: Database Admin. Part 1(Install. SQL Server 2000) MS SQL Server 2000: Database Admin. Part 2(Managing Databases) MS SQL Server 2000: Database Admin. Part 3(Security & Data Recovery) MS SQL Server 2000: Database Admin. Part 4(Managing Data) MS SQL Server 2000: Database Admin. Part
more...
SQL Server 7 0 Designing Implementing Data Warehouses Curriculum

...ver 7.0 Curriculum consists of the following courses: MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1 MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2 MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3 MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4 MS SQL Server 7.0: Designing and Implementing Data
more...
MCSE Windows 2000 Electives Curriculum

The MCSE Windows 2000 Electives Curriculum includes the following: MS Windows 2000: Migrating from MS Windows NT 4.0 Curriculum (ID#7556) Installing, Configuring & Administering Microsoft Exchange 2000 Server Curriculum (ID#7732) Microsoft ISA Server 2000 Curriculum (ID#8041) MS SQL Server 2000 Database Administration Curriculum (ID#7895) To review individual descriptions, please select
more...
From Skillspride Online Training
Microsoft SQL Server 7.0 Administration
SQL Server is a scaleable RDBMS designed for client/server applications. This course will prepare Database Administrators to set up and maintain MS SQL systems in a networked environment. It provides both the theory and practical experience of installing, backing up, replicating and monitoring and tuning an SQL Server 7.0 system.
more...
Microsoft SQL Server 7.0 Programming Part 1
This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software. To encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions. To help developers plan their applications systematically, efficiently and economically and to promote good design and development
more...
Microsoft SQL Server 7.0 Programming Part 2
This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software. To encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions. To help developers plan their applications systematically, efficiently and economically and to promote good design and development
more...
Microsoft SQL Server 6.5 Programming
This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software; to encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions to help developers plan their applications systematically, efficiently and economically; to promote good design and development
more...
