|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
| Training Seminars
| Training Providers
| Regions
|
| Advertise Training Seminars
| Login
|
||||||||||
Custom Search
Microsoft Sql Server Training Seminars and Classes
From Online Training Directory
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...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...
From Serebra Learning Corporation
Microsoft SQL Server 7.0: System Administration - Part 1
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
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
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
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
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
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
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
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
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
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
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
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
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
...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
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
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...Visual Basic 6 0 Advanced Enterprise Client Server Dev Part I
...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
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
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 Introduction
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
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 Data Warehousing SQL Part I
...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
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...Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data
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
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
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...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...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: 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...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
BizTalk Server 2000 Part 5 Secruity Optimization
 ... 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
...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
...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
...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
...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
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
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
...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
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
...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
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
...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
...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
...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
...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
...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
...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 InterDev 6 0 Accessing Remote Data
...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
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
...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
...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
...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
...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
...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
...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
...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
... 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 Microsoft SQL Server more...SQL Server 7 0 - Implementing a Database - Part 4
...th the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Generate summary value and summary data as well as generate control break reports using aggregate functions. Define transactions and set transaction isolation levels. Identify the purpose and benefits of using views. C ontent Emphasis Skills-Based A udience This course is more...SQL Server 7 0 - Implementing a Database - Part 5
... with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Access data by using the Stored Procedure model. Access data using triggers. Set up a distributed environment to access, modify and manage remote data. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a more...Office XP - Planning Collaborative Solutions Curriculum
The Microsoft Office XP - Planning Collaborative Solutions Curriculum presents the learner with a comprehensive introduction to SharePoint Team Services and the principal technologies within Office XP that facilitate sharing of line-of-business data. The curriculum begins with an introduction to SharePoint Team Services and Team Services site architecture. It covers administrative issues and user more...Office XP Collaborative Solutions Part 1
...SharePoint Portal Server, Microsoft Exchange 2000 Server, Microsoft SQL Server 2000, or Microsoft BizTalk. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits CEU credits: 0.70 CEUs Language Options American English Total Learning Time 6 to 8 hours 74101 Objectives Unit 1: SharePoint Team Services 3 - 4 hours o more...Office XP Collaborative Solutions Part 2
...SharePoint Portal Server, Microsoft Exchange 2000 Server, Microsoft SQL Server 2000, or Microsoft BizTalk. In addition, learners should have taken the first part of this series 74101. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits CEU credits: 0.70 CEUs Language Options American English Total Learning Time 6 to 8 more...Commerce Server 2000 Design Implementation Curriculum
The Commerce Server 2002 provides users with the skills necessary for user profiling, catalog management and advanced online business analytics including installation, administration tools, site packaging, and Commerce Server Manager. This curriculum consists of five Skill Builder courses. Course 74116 MS Commerce Server 2000: Design and Imp. Part 1 - Intro, 74117 MS Commerce Server 2000: Design more...Commerce Server 2000 Design Impl Part 1 Intro
...ts and technologies (Internet Information services (IIS), Microsoft SQL Server (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American more...Commerce Server 2000 Design Impl Part 2 Users Objects Catalogs
...ts and technologies (Internet Information services (IIS), Microsoft SQL Server (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. In addition, learners should have taken the first part of this series 74116. Deployment Options Internet / Intranet, Download, LAN, Workstation more...Commerce Server 2000 Design Impl Part 3 Pipelines
...ts and technologies (Internet Information services (IIS), Microsoft SQL Server (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. In addition, learners should have taken the first two parts of this series 74116 and 74117. Deployment Options Accreditation NASBA credits: 4 CPE more...Commerce Server 2000 Design Impl Part 4 Ad Campaigns Websites
...ts and technologies (Internet Information services (IIS), Microsoft SQL Server (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. In addition, learners should have taken the first three parts of this series 74116 thru 74118. Deployment Options Internet / Intranet, Download, LAN, more...Commerce Server 2000 Design Impl Part 5 Infra Sec Admin
...ts and technologies (Internet Information services (IIS), Microsoft SQL Server (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. In addition, learners should have taken the first four parts of this series 74116 thru 74119. Deployment Options Internet / Intranet, Download, LAN, more...
From The Virtual Training Company
Microsoft SQL Server 2005 Administration
SQL Server 2005 is Microsoft's latest release of their enterprise database solution product. SQL Server 2005 is the result of five years of research, development and collection of suggestions and wish lists from database administrators and developers. Microsoft continues to drive the enterprise database market with the added features and capabilities of this new product. Microsoft Certified more...
From Teach Me IT
Retrieving Data in SQL Server 2000
...tification exam Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition (70-229). This course teaches how to insert data in a SQL Server table and use views to retrieve data. It also introduces users to indexes and teaches them how to implement full-text search. Additionally, the users will learn to create stored procedures and cursors. After completing this more... | ||||||||||