Online 2000 Databases eLearning

Administering Microsoft ® SQL Server 2000 (SQL) This course will provide student with the knowledge and skills required to install, manage and administer Microsoft SQL Server 2000 (SQL) databases. This course is design to help students master the concept of administering Microsoft? SQL Server 2000 (SQL) databases effectively. When a student completes this course he/she will be able to plan and complete a successful installation or upgrade,  more...

SQL Server 2000 Complete Course This course is a complete set of SQL Server 2000 Administration, SQL Server 2000 Desing and Implementation, Datawarehousing and XML Enabled Applications using SQL 2000. This course teaches you to administer and troubleshoot information systems that incorporate the SQL Server 2000 Enterprise Edition. Learn how to install and configure a SQL 2000 Server, plan, design, and create SQL 2000 databases,  more...

SQL Server 2000 Databases To describe how to create and modify SQL Server 2000 databases  more...

Managing SQL Server 2000 Databases To guide students in configuring, performing, and automating routine administrative tasks  more...

Backing Up SQL Server 2000 Databases To explain how to back up SQL Server databases  more...

Restoring SQL Server 2000 Databases To describe the process involved in restoring SQL Server databases  more...

SQL Server 2000 Databases To describe how to create and modify SQL Server 2000 databases  more...

SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server ...guage (DDL) statements. Identify the types of SQL Server 2000 databases. Identify the features of the SQL Server 2000 object-naming standard. Identify the methods for retrieving metadata information. Audience The audience for this course includes database designers, database managers, and technical managers. Candidates for Exam 70-229 operate in medium to large computing environments  more...

SQL Server 2000 Design Implement Databases Part 3 Managing Objects Course Overview 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. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different  more...

SQL Server 2000 Design Implement Databases Part 4 Managing Indexes Course Overview 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. Learn To Identify the features of clustered indexes. Identify the features of nonclustered  more...