Online Administering Microsoft Sql Server eLearning Training

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. more...

Security in a Microsoft SQL Server 2000 Environment To explain how to plan and implement security on a SQL 2000 database Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...

Transferring and Transforming Data in SQL Server 2000 To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...

Transferring and Transforming Data in SQL Server 2000 To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...

Installing Configuring and Upgrading SQL Server 2000 To describe how to install, configure, and upgrade SQL Server Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...

Overview of SQL Server 2000 To provide a high-level overview of SQL Server Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...

Managing SQL Server 2000 Databases To guide students in configuring, performing, and automating routine administrative tasks Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...

SQL Server 2000 Databases To describe how to create and modify SQL Server 2000 databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...

Backing Up SQL Server 2000 Databases To explain how to back up SQL Server databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...

Restoring SQL Server 2000 Databases To describe the process involved in restoring SQL Server databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...

SQL Server 2000 Replication To describe how to implement the SQL 2000 replication models Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...

Monitoring SQL Server 2000 Performance To explain how to monitor SQL Server for optimal performance Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...

SQL Server 7.0 Database Admin. Part I This course builds upon previous courses by covering database management and provides a foundation for advanced courses on data warehousing client/server application development and SQL to IIS active server pages. Related Exams: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.  more...

SQL Server 7.0 Database Admin. Part II Microsoft exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.  more...

SQL Server 7.0 Installing and Upgrading This course presents a comprehensive view of upgrading and installation process and its installation types and requirements. Students will learn the procedures for installing and upgrading to SQL Server 7.0. The course describes setup options that must be determined before installing SQL Server 7.0 and covers logon accounts the Windows NT User Account network protocols management tools and sort more...

SQL Server 7.0 Management Part I This course is designed to teach the skills necessary to take full advantage of SQL Server 7.0 features and enhancements used to manage data. SQL Server 7.0 contains two powerful tools for managing data: Transact-SQL at the command-line level and SQL Server Wizard features. This course presents a comprehensive view of the database development process by outlining the processes of creating the more...

SQL Server 7.0 Management Part II This course provides the skills to database administrators managers and users so that they may take full advantage of SQL Server 7.0 features. It explains how to use the fundamental elements of Transact-SQL how to use the SELECT statement and how to monitor database performance. It also examines stored procedures and joins. Related Exam: Prepares users for both Microsoft Exams #070-028 more...

SQL Server 7.0 Management Part III This course explains how to design a logical model of a database and identifies the components to use in order to organize and access a SQL Server database. It describes the advanced programmatic features of the SQL language which can be used to extend the functionality of SQL stored procedures.Additionally this course examines the functions of a SQL cursor including how to navigate a result set more...

SQL Server 7.0 Developing SQL Client/Server Part I This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server more...

SQL Server 7.0 Developing SQL Client/Server Part II This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server more...

SQL Server 7.0 Advanced Features Part I This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition it outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advanced more...

SQL Server 7.0 Advanced Features Part II This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition It outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advances more...

SQL Server 7.0 Web Integration This course introduces several new or enhanced technologies procedures and tools for increased dependence on the Web for business applications. The course presents a comprehensive view of Web applications with SQL Server 7.0. The course outlines Microsoft's overall Web strategy including reasons for linking the databases to Web clients possible tasks that can be accomplished through Web more...

Planning an SQL 7.0 Data Warehouse The Planning an SQL 7.0 Data Warehouse course is the first course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides students with the preliminary knowledge for planning and implementing data warehouses using SQL Server more...

Implementing an SQL 7.0 Data Warehouse The Implementing an SQL 7.0 Data Warehouse course is the second course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of creating files and filegroups and helps students to select an application programming interface for more...

Using SQL 7.0 OLAP Services The Using SQL 7.0 OLAP Services course is the third course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students 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 more...

Optimizing a 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. It helps students 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 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...

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...