Custom Search

Online Microsoft SQL eLearning Training

Microsoft SQL Training Seminars and Classes
From Online Training Directory
Administering Microsoft SQL Server 2000 SQL on-line e-learning cbt (computer based)study at homecoursewareSelf Directed This course will provide student with the knowledge and skills required to install, manage and administer Microsoft SQL Server 2000 (SQL) databases.  more...
Administering Microsoft SQL Server 2000 (SQL) on-line e-learning cbt (computer based)study at homecourseware This course will provide student with the knowledge and skills required to install, manage and administer Microsoft SQL Server 2000 (SQL) databases.  more...
From Serebra Learning Corporation
Microsoft SQL Server 7.0: System Administration - Part 1 on-line e-learning cbt (computer based) This is the first course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.  more...
Microsoft SQL Server 7.0: System Administration - Part 2 on-line e-learning cbt (computer based) This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.  more...
Microsoft SQL Server 7.0: System Administration - Part 3 on-line e-learning cbt (computer based) This is the third course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.  more...
Microsoft SQL Server 7.0: System Administration - Part 4 on-line e-learning cbt (computer based) This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.  more...
Microsoft SQL Server 7.0: System Administration - Part 5 on-line e-learning cbt (computer based) This is the final course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.  more...
Microsoft SQL Server 7.0: Implementing a Database - Part 1 on-line e-learning cbt (computer based) This is the first course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.  more...
Microsoft SQL Server 7.0: Implementing a Database - Part 2 on-line e-learning cbt (computer based) This is the second course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.  more...
Microsoft SQL Server 7.0: Implementing a Database - Part 3 on-line e-learning cbt (computer based) 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.  more...
Microsoft SQL Server 7.0: Implementing a Database - Part 4 on-line e-learning cbt (computer based) 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.  more...
Microsoft SQL Server 7.0: Implementing a Database - Part 5 on-line e-learning cbt (computer based) 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.  more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1 on-line e-learning cbt (computer based) This is the first course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing; identify the  more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2 on-line e-learning cbt (computer based) This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data  more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3 on-line e-learning cbt (computer based) This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to create a data warehouse database; perform the steps necessary to build and manage replication by using the Enterprise Manager; build a  more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4 on-line e-learning cbt (computer based) ...m 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from multidimensional data structures; identify the features and functionality of Pivot Table Service, Local Cubes and Client/Server  more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 5 on-line e-learning cbt (computer based) This is the final course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft SQL Server 7.0 data  more...
Security in a Microsoft SQL Server 2000 Environment on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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...
Visual Basic 6 0 Advanced Enterprise Client Server Dev Part I on-line e-learning cbt (computer based) ...ising security. The different security modes available to Microsoft SQL Server 7.0 and previous versions of SQL Server are explained, as well as their respective advantages. It also explains creating Windows NT accounts and user groups. This course discusses the merits of using SQL stored procedures for business services and data integrity checks. It describes how to create, write, and debug  more...
Small Business Server 2000 on-line e-learning cbt (computer based) To provide an overview of Microsoft Small Business Server (SBS) 2000 and its main features, such as its management consoles and monitoring tools, and to show how Microsoft Exchange 2000, ISA Server 2000, and Microsoft SQL Server 2000 integrate with SBS 2000 Network administrators for companies of up to 50 users; IT solutions companies that wish to deploy SBS 2000  more...
Installing Configuring and Upgrading SQL Server 2000 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 Introduction on-line e-learning cbt (computer based) This course presents an overview of the features and benefits of SQL Server 7.0 a major update to Microsoft's SQL Server database product. It describes the major differences between versions 6.5 and 7.0 and examines core components data warehousing application development tools and SQL management tools. This course provides an excellent foundation for advanced courses on upgrade and  more...
SQL Server 7.0 Installing and Upgrading on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 Data Warehousing SQL Part I on-line e-learning cbt (computer based) ...tical Processing (OLAP) is then used to process the data. Microsoft SQL Server 7.0 provides several powerful tools for building data warehouses and data marts and OLAP systems. Using the Data Transformation Services (DTS) Package Designer the user can define steps workflow and transformations necessary to build a data warehouse. Microsoft Decisions Support Services providing a robust OLAP  more...
SQL Server 7.0 Developing SQL Client/Server Part I on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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...
Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data on-line e-learning cbt (computer based) This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL.  more...
Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries on-line e-learning cbt (computer based) This course will teach students how to work with queries. The course will also introduce views stored procedures triggers and user-defined functions.  more...
MS SQL Server 2000: Database Administration Part 1: Installing SQL Server 2000 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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...
Planning an SQL 7.0 Data Warehouse on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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...
MS SQL Server 6.5: Installation & Administration on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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: Advanced Retrieval Structures on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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
BizTalk Server 2000 Part 5 Secruity Optimization on-line e-learning cbt (computer based)cd rom ... Learn To • Identify Microsoft Windows 2000 and Microsoft SQL Server 2000 security features that are used by Microsoft BizTalk Server 2000. • Identify the tasks that can be performed by the BizTalk Server Administrators group and by the Windows 2000 Administrators group. • Identify features of logon properties and service accounts in the Microsoft BizTalk Server 2000  more...
BizTalk Server 2000 Part 4 Components Solutions Troubleshooting on-line e-learning cbt (computer based)cd rom ...f Microsoft Internet Information Services (IIS), ASP, and Microsoft SQL Server 2000 Enterprise Edition. Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74313 Objectives Unit 1: BizTalk Components 2 -  more...
BizTalk Server 2000 Part 3 Monitoring Orchestration on-line e-learning cbt (computer based)cd rom ...f Microsoft Internet Information Services (IIS), ASP, and Microsoft SQL Server Enterprise Edition. Content Emphasis Conceptual Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74312 Objectives Unit 1: BizTalk Orchestration Designer  more...
BizTalk Server 2000 Part 2 Documents Mapping Managing Submitting on-line e-learning cbt (computer based)cd rom ...f Microsoft Internet Information Services (IIS), ASP, and Microsoft SQL Server 2000 Enterprise Edition. Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74311 Objectives Unit 1: BizTalk Mapper 2 - 3  more...
BizTalk Server 2000 Part 1 Intro to BizTalk Server 2000 on-line e-learning cbt (computer based)cd rom ...f Microsoft Internet Information Services (IIS), ASP, and Microsoft SQL Server 2000 Enterprise Edition. Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74310 Objectives Unit 1: BizTalk Server 2000  more...
BizTalk Server 2000 Curriculum on-line e-learning cbt (computer based)cd rom Course Overview This curriculum introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. This curriculum covers creating maps using BizTalk Mapper, creating objects in and managing BizTalk Messaging Manager, and the submission of documents to BizTalk Server. Additionally, it covers the tracking of interchanges and business  more...
MCDBA Curriculum Version II on-line e-learning cbt (computer based)cd rom The Complete MCDBA Curriculum includes the following curriculums: Microsoft Windows 2000 Administration Curriculum (ID#7578) Microsoft Windows 2000 Installation, Configuration & Admin. Curriculum (ID#7586) Microsoft SQL Server 2000: Database Administration Curriculum (ID#7895) Microsoft SQL Server 2000: Designing & Implementing Databases Curriculum (ID#7901) MS Win 2000 Network  more...
CIW E-Commerce Designer Part 4 Site Implementation on-line e-learning cbt (computer based)cd rom ...f the Oracle8 package. Identify the main capabilities of Microsoft SQL Server. Audience Candidates for this exam design and implement commerce-driven Web sites, identify customer needs, monitor customer usage patterns, determine order processes and service after sales, and consider how e-business solutions can increase sales. Candidates include system administrators, application  more...
SQL Server 2000 Database Admin Part 4 Managing Data on-line e-learning cbt (computer based)cd rom Course Overview This course deals with transferring data, managing replication services, and maintaining high availability. Learn To Identify guidelines for importing and exporting data. Match SQL Server 2000 tools used to import and export data with their functions. Identify the features and functions of the Data Transformation Services (DTS) process. Identify the features of  more...
SQL Server 2000 Database Admin Part 1 Install SQL Server 2000 on-line e-learning cbt (computer based)cd rom ...0. Identify the typical hardware optimization issues for Microsoft SQL Server 2000. Select an appropriate edition of SQL Server 2000. Identify the different types of SQL Server 2000 installations. Install a default instance of SQL Server 2000. Sequence the stages of an unattended installation. Identify the types of SQL Server databases. Identify the database objects related to SQL  more...
SQL Server 7 0 Database Design Curriculum on-line e-learning cbt (computer based)cd rom The SQL Server 7.0 Database Design Curriculum consists of the following courses: SQL Server 7.0 Implementing a Database - Part 1 SQL Server 7.0 Implementing a Database - Part 2 SQL Server 7.0 Implementing a Database - Part 3 SQL Server 7.0 Implementing a Database - Part 4 SQL Server 7.0 Implementing a Database - Part 5 To review individual course descriptions, please return to the  more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5 on-line e-learning cbt (computer based)cd rom ...m 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft SQL Server 7.0 data warehouse; and perform the tasks related to database maintenance in Microsoft SQL Server 7.0. L earn To:  more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 on-line e-learning cbt (computer based)cd rom ...m 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from multidimensional data structures; identify the features and functionality of Pivot Table Service, Local Cubes, Client/Server  more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3 on-line e-learning cbt (computer based)cd rom ...m 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to create a data warehouse database; perform the steps necessary to build and manage replication by using the Enterprise Manager; build a dimension and assign its member properties; build an aggregation and identify the guidelines for optimizing aggregation  more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2 on-line e-learning cbt (computer based)cd rom ...m 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data Transformation Services (DTS) components and the components of the DTS object model; identify the methods of distributing data;  more...
SQL Server 7 0 Designing Implementing Data Warehouses Curriculum on-line e-learning cbt (computer based)cd rom ...Microsoft SQL Server 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  more...
SQL Server 7 0 Designing Implementing Data Warehouses - Part 1 on-line e-learning cbt (computer based)cd rom ...m 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing; identify the different techniques for gathering data; identify the basic requirements of the data warehouse; and identify the guidelines  more...
Visual C 6 0 Designing Implementing Desktop Applications - Part 1 on-line e-learning cbt (computer based)cd rom ...nterprise Manager. Configure SQL Server 6.5 by using the Microsoft SQL Enterprise Manager. Configure a SQL Server database by using the SQL Enterprise Manager. Set permissions for a specific user by using the By User tab. Install Microsoft Message Queue Server (MSMQ). Create a queue by using the Microsoft Message Queue Explorer. Configure an enterprise by using the Microsoft Message Queue  more...
Visual InterDev 6 0 Accessing Remote Data on-line e-learning cbt (computer based)cd rom ...etrieve data from a database by using Microsoft ISQL_w of Microsoft SQL Server 6.5. Add a record to a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5. Update a record from a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5. Delete a record from a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5. Create a stored procedure to  more...
Visual InterDev 6 0 Accessing Remote Data on-line e-learning cbt (computer based)cd rom Course Overview This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of Remote  more...
SQL Server 7 0 System Administration - Part 5 on-line e-learning cbt (computer based)cd rom ...wledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the methods and attributes of SQL Server 7.0 replication. Identify and apply techniques for planning and setting up SQL Server 7.0 replication. Identify the procedures for replication maintenance. C ontent Emphasis Skills-Based A udience This course is designed  more...
SQL Server 7 0 - Implementing a Database - Part 1 on-line e-learning cbt (computer based)cd rom ...th 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 Skills-Based A udience This course is designed for IT professionals responsible for  more...
SQL Server 7 0 - Implementing a Database - Part 2 on-line e-learning cbt (computer based)cd rom ...th 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 solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL  more...
SQL Server 7 0 System Administration - Part 1 on-line e-learning cbt (computer based)cd rom ...wledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the main components of the SQL Server. Understand the properties of SQL Server Architecture, including the underlying technical details. Understand the components of SQL Server installation, including hardware and software requirements, types of installations, and installation  more...
SQL Server 7 0 System Administration - Part 2 on-line e-learning cbt (computer based)cd rom ...wledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Work with Microsoft SQL Server is and Work with Microsoft SQL Server 7.0, its architecture, security, and database structure. Understand the basics of SQL Server databases and how to create databases and other objects. Modify databases; manage data on multiple disks; assess database  more...
SQL Server 7 0 System Administration - Part 3 on-line e-learning cbt (computer based)cd rom ...wledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the concepts, interfaces and fixed roles involved in performing backups. Gain a working knowledge of database, transaction log and filegroup backups and perform these backups as a system administrator. Restore damaged or incomplete databases. C ontent Emphasis  more...
SQL Server 7 0 System Administration - Part 4 on-line e-learning cbt (computer based)cd rom ...wledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Automate SQL Server 7.0 administrative tasks. Identify and use the SQL Server 7.0 tools for transferring and transforming data. Identify and use the tools for monitoring and maintaining SQL Server 7.0. C ontent Emphasis Skills-Based A udience This course is designed for  more...
SQL Server 7 0 - Implementing a Database - Part 3 on-line e-learning cbt (computer based)cd rom ... 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 professionals responsible for implementing a database solution with