Online SQL Server Database eLearning - Training Resources

SQL Server 2000 - XML-Enabled Applications Using SQL 2000 This course is designed to teach students the basics of SQL and XML in building and combining applications where database functions are required This course will give students a good understanding of how to use SQL 2000 in building and integrating applications that use or require a database and are enabled with XML. Course includes a primer for SQL and XML calls for SQL. Course also covers using  more...

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

Microsoft Access Gain a solid understanding of this powerful database management system Course is designed to provide the end user, with little or no prior experience using Microsoft Access, a solid understanding of the basic commands and features of this powerful database management system. As an introductory level class, topics to be covered include how to design, create, organize, display and query a database  more...

Database Deployment and Data Distribution recognize how to design, deploy and utilize database deployment and database distribution solutions  more...

Designing Access to SQL Server Data recognize how to design and utilize data access technologies to manage SQL Server and access SQL Server Data  more...

Designing Efficient Application Access recognize how to efficiently utilize client libraries for database access using automation management objects, server Network Interface and MARS for queries and row management  more...

Designing Queries in SQL 2005 recognize how to design and execute queries in SQL Server 2005, utilizing XQuery and the XML Data Modification Language  more...

Designing a SQL Server 2005 Cursor Strategy recognize how to design and implement an appropriate cursor strategy in SQL Server 2005  more...

Designing a SQL Server 2005 Transaction Strategy recognize the different levels of isolation and granularity to manage concurrency and execute a transaction strategy in SQL Server 2005  more...

SQL Server 2005 Error Handling Techniques recognize how to design code for validating input, for error handling and for user-defined messages in SQL Server 2005  more...

Optimizing Query Performance and Index Strategies recognize how to optimize query performance and indexing strategies in SQL Server 2005  more...

Optimizing Storage in SQL Server 2005 recognize how to optimize database storage and SQL Server performance  more...

Scaling Applications and Resolving Performance Issues recognize how to scale out applications to enterprise level and troubleshoot and identify performance issues that result  more...

Designing Security for a Database Server Infrastructure for SQL Server 2005 To identify business security requirements, select the appropriate authentication method, and specify a security design for different levels of the SQL Server environment  more...

Designing the Physical Database for SQL Server 2005 To identify physical database requirements, select the appropriate strategy for designing database objects, and determine suitable database naming standards and change control procedures  more...

Designing a Database Server High Availability Solution for SQL Server 2005 To select the appropriate database storage design for a high availability scenario and identify a suitable replication solution  more...

Designing a Database Failover Solution for SQL Server 2005 To identify the appropriate cluster configuration solution, database mirroring solution, and log shipping solution for a database  more...

Designing a Database Server Data Recovery Solution for SQL Server 2005 To select the appropriate data backup and recovery solution for a SQL Server 2005 database  more...

Optimizing SQL Server 2005 Performance To identify ways of optimizing the performance of SQL Server 2005  more...

Optimizing a Database Data Recovery Plan for SQL Server 2005 To identify potential causes of database failure, and select the appropriate fault tolerance and restore strategies for a scenario  more...

Monitoring and Maintaining a Database in SQL Server 2005 To monitor a database, automate database maintenance tasks, and configure reporting services for SQL Server 2005  more...

Managing Database Data in a SQL Server 2005 Environment To recognize how to create and deploy SSIS packages, and enforce data quality and data integrity in a SQL Server 2005 database  more...

Managing Data Between Servers and Databases To recognize how to manage change, configure and work with linked servers, and manage and tune replication in SQL Server 2005  more...

Managing and Maintaining Database Security in SQL Server 2005 To identify strategies for auditing database security at the server and user levels, and determine the appropriate way to protect against and respond to different types of attack on SQL Server  more...

Designing an Application Solution for SQL Server 2005 recognize how to design and build a database model and a physical database, and how to secure it  more...

Designing Database Objects recognize how to design database objects according to your requirements  more...

Programming with SQL Server 2005 recognize how to implement SQL Server 2005 programming features to work with database data  more...

Using XML recognize how to use, implement, retrieve and manipulate XML data in SQL Server 2005 using XQuery language  more...

CLR Integration recognize how to use CLR integration in SQL Server 2005 to create, implement and work with data, and how to execute .NET assemblies to achieve this  more...

Database Testing and Code Management recognize how to implement version control, unit testing and performance benchmarking and improvements in SQL Server 2005  more...

Developing Applications that Use SQL Server Support Services recognize how to develop and deploy SQL Service Support solutions with Notification Services and Service Broker  more...

Developing Applications that Use SQL Server Business Intelligence Services recognize how to implement Reporting Services to generate reports and Integration Services to manipulate data according to your requirements  more...

Using PL SQL with an Oracle Server To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block  more...

SQL Server 2000 High Availability To describe the high availability of SQL Server 2000  more...

SQL Server 2000 XML and the Web To outline the relationship between SQL Server 2000, XML, and the Web  more...

Overview of SQL Server 2000 To provide a high-level overview of SQL Server  more...

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

Transferring and Transforming Data in SQL Server 2000 To enable students to extract and transform data in SQL Server 2000  more...

SQL Server 2000 XML and the Web To outline the relationship between SQL Server 2000, XML, and the Web  more...

Designing and Implementing Security in SQL Server 2000 To use programming logic to implement security and describe the different levels of security  more...

The SQL Server 2000 Logical Data Model To describe SQL Server data entities and their normalization  more...

Using T-SQL in SQL Server 2000 To discuss Transact-SQL and its elements and view and define data using Transact-SQL statements  more...

SQL Server 2000 Indexes To describe and show how to create and manage indexes  more...

SQL Server 2000 Programming Business Logic To demonstrate how to implement views, stored procedures, triggers and user-defined functions as means for programming business logic  more...

SQL Server 2000 Transactions and Distributed Data To demonstrate how to utilize transactions and distributed data  more...

Analyzing and Optimizing SQL Server 2000 Queries To show how to analyze and optimize queries  more...

Installing SQL Server 2005 To install SQL Server 2005 and upgrade to SQL Server 2005 from previous versions  more...

Configuring SQL Server 2005 To configure a SQL Server instance and create a database, configure logins, users, and schemas for a database, and set up a linked server configuration  more...

Creating and Implementing Database Objects in SQL Server 2005 To create and implement key database objects in SQL Server 2005  more...

Retrieving Data and Running Queries in SQL Server 2005 To perform relational data and XML data management tasks, and work with assemblies and transactions in SQL Server 2005  more...

SQL Server 2005 Messaging and Querying Tools To implement Service Broker components and use full-text search in SQL Server 2005  more...

Managing and Maintaining SQL Server 2005 Databases To manage and maintain SQL Server 2005 databases  more...

SQL Server 2005 Database Performance and Optimization To monitor and optimize database performance using SQL Server utilities  more...

Monitoring and Diagnosing Database Problems in SQL Server 2005 To monitor and resolve database blocks, and connect to the server using a dedicated administrator connection (DAC)  more...

SQL Server 2005 High Availability and Disaster Recovery To implement database mirroring, log shipping, database snapshots, and data replication in SQL Server 2005  more...

SQL Server 2005 Backup and Restores To back up and restore a database in SQL Server 2005  more...

Overview of SQL Server 2000 To provide a high-level overview of SQL Server  more...

Installing Configuring and Upgrading SQL Server 2000 To describe how to install, configure, and upgrade SQL Server  more...

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

Transferring and Transforming Data in SQL Server 2000 To enable students to extract and transform data in SQL Server 2000  more...

Security in a Microsoft SQL Server 2000 Environment To explain how to plan and implement security on a SQL 2000 database  more...

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

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

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

SQL Server 2000 Replication To describe how to implement the SQL 2000 replication models  more...

Monitoring SQL Server 2000 Performance To explain how to monitor SQL Server for optimal performance  more...

Oracle9i Database Admin Set Up Oracle Net Services Course Overview This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server. Learn To •  more...

Oracle9i Database Admin Perform Database Backups Course Overview This course introduces students to backup methods for Oracle9i database administration. The backup concepts covered by this course include backup strategies and requirements, Oracle Architecture, archiving data, backup methods, and working with a standby database. Students perform backup procedures using operating system utilities, Oracle9i utilities such as RMAN, standard  more...

Oracle9i SQL DML and DDL The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.  more...

Oracle9i SQL Basic SELECT Statements This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. Learn To: o Identify the components of the relational  more...

BizTalk Server 2000 Part 5 Secruity Optimization Course Overview This is the last course in a five part series that deals with the securing of the BizTalk Server 2000 environment and the configuring of servers and groups of servers and optimization of server group performance. This course covers the use of tools and utilities to monitor the status of the BizTalk Server 2000 environment. Learn To • Identify Microsoft Windows 2000 and  more...

BizTalk Server 2000 Part 4 Components Solutions Troubleshooting Course Overview This is the fourth course in a five part series that presents the knowledge and skills necessary to create application integration components (AICs) for use with BizTalk Messaging Services. It also covers the deployment and management of an automated business process between trading partners using BizTalk Server 2000. In this respect, it presents a type of practical application  more...

BizTalk Server 2000 Part 3 Monitoring Orchestration Course Overview This is the third course in a five part series that deals with the tracking of interchanges and business documents using BizTalk Document Tracking. It also covers the orchestration of the business process using BizTalk Orchestration Designer. The learner will review the core procedures necessary for using both these tools and has an opportunity to practice their use in the three  more...

BizTalk Server 2000 Part 2 Documents Mapping Managing Submitting Course Overview This is the second course in a five part series that deals with the mapping and managing of document flow. This course covers creating maps using BizTalk Mapper, creating objects in and managing BizTalk Messaging Manager, and the submission of documents to BizTalk Server. The course continues to build upon the scenario companies that form the scenario core of the curriculum,  more...

BizTalk Server 2000 Part 1 Intro to BizTalk Server 2000 Course Overview This is the first course in a five part series that introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. BizTalk is contextualized in terms of a solution to these various challenges. This course covers the BizTalk administration model and its tools and services. It also covers the installation requirements  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...

SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries Course Overview This course will teach students how to work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions. Learn To Identify advantages of using aliases for table names. Identify the guidelines for using joins. Identify the considerations for using inner joins. Identify considerations for using subqueries. Create a derived  more...

SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data Course Overview This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL. Learn To Identify the basic types of statements used in Transact-Structured Query Language (SQL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements.  more...

SQL Server 2000 Design Implement Databases Part 5 Dist Data 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. Learn To: o Identify  more...

SQL Server 2000 Design Implement Databases Part 4 Managing Indexes Course Overview This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries. Learn To Identify the features of clustered indexes. Identify the features of nonclustered  more...

SQL Server 2000 Design Implement Databases Part 3 Managing Objects Course Overview This is the third course in a five part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different  more...

SQL Server 2000 Design Implement Databases Part 2 Managing Data Course Overview This is the second course in a five part series that will teach students how to work with SQL Server data. Learn To Identify the SQL Server 2000 system-supplied data types. Add a user defined data type. Match the parts of a data row with their features. Identify characteristics of entity modeling. Identify features of attributes. Identify requirements for logical  more...

SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server ...an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify the features and functions of SQL Server 2000 services. Match the basic types of statements used in Transact-SQL with their functions. Match Data  more...

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

SQL Server 2000 Database Admin Part 5 Maint SQL Server 2000 Course Overview This is the last course in a five part series that deals with managing, monitoring, and troubleshooting SQL Server 2000. Learn To Identify guidelines for configuring SQL Server Agent. Identify guidelines for using SQLAgentMail and SQL Mail. Configure a Microsoft Outlook Exchange profile for your administrative account. Identify the goals of SQL Server 2000 monitoring.  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 3 Security Data Recovery Course Overview 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. Learn To Identify how login accounts are processed. Identify the characteristics of the two authentication modes. Sequence the steps to implement an authentication mode. Identify the  more...

SQL Server 2000 Database Admin Part 2 Manag Databases Course Overview 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. Learn To Identify the database option categories. Identify features of the tools used to view database properties. View database  more...

SQL Server 2000 Database Admin Part 1 Install SQL Server 2000 ...ges of an unattended installation. Identify the types of SQL Server databases. Identify the database objects related to SQL Server. Identify the features of the SQL Server 2000 object-naming standard. Audience Candidates for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory,  more...

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

IBM DB2 Universal Database V6 1--Fundamentals Course Overview This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language  more...

IBM DB2 Universal Database V6 1--Fundamentals Course Overview This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language  more...

Oracle PL SQL Database Programming Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored  more...

Oracle PL SQL Procedures Functions Packages 61114 Course Overview This course is the second in a series of three titles. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally, this course introduces the basics of creating and using packages. L earn To: Identify the types and components of a subprogram. Create a subprogram. Create  more...

Oracle8i Performance Tuning Managing Memory Disk I O Course Overview This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...

Oracle8i Performance Tuning Architecture Strategy Course Overview This course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally,  more...

Oracle8i Database Admin Manage Storage Structures Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To: Identify  more...

Oracle8i Database Admin Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  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...

Oracle Reports R6 Control Reports Course Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and  more...

Oracle Form Builder R6 Including Reusable Oracle Components Course Overview This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention Course Overview This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student  more...

Oracle8 Performance Tuning Managing Memory and Disk I O Course Overview This course is the second in a three-part Oracle8 Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...

Oracle8 Backup and Recovery - Troubleshooting and Recovery Course Overview This course is the second course in a two-part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle recovery methods and how to  more...

Oracle8 Backup and Recovery - Strategies and Backups Course Overview This is the first course in a two-part series that will introduce participants to the critical task of planning and implementing database backup strategies. In this course, users will be introduced to backup concepts and the Oracle architecture. They will learn how to change the archive mode of a database and configure a database for archive processing. Additionally, users will  more...

Oracle8 Database Administration - Manage Security Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and  more...

Oracle8 Database Administration - Manage Data Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L  more...

Oracle8 Database Administration - Manage Storage Structures Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To: Identify  more...

Oracle8 Database Administration - Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

Oracle Form Builder Including Reusable Oracle Components Course Overview This course is the sixth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants learn how to implement methods to use data sources, and to integrate charts, reports and timers in Forms. In addition, reusing components, objects and code will be taught. Finally, Form Builder's new features will be covered. L  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5 Course Overview 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  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 Course Overview This is the fourth 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 methods of aggregating and accessing data from relational data structures; identify the methods of data  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3 Course Overview 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  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2 Course Overview 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;  more...

SQL Server 7 0 Designing Implementing Data Warehouses - Part 1 Course Overview 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;  more...

Visual C 6 0 Designing Implementing Distributed Applications - Part 3 Course Overview This is the final course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment. L earn To: Create a database, maintain data integrity and import data. Write SQL statements to access data from tables and manipulate the  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 1 ... 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 Explorer. Configure a site by using the  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3 ...dd Data Environment command. Establish a connection to a SQL Server database using the Data Link Properties dialog box. Display the structure of a SQL Server database. Create a SQL Stored Procedure. Display the T-SQL Debugger for debugging a SQL Stored Procedure. Identify the use of delimiter commands in SQL Transactions. Unit 2: Accessing Data from the Middle Tier Duration: 3 - 4  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 2 Course Overview This is the second course in a five part series that will provide programmers with the basic skills to build three-tier client/server solutions. L earn To: Identify the features, installation requirements, constituents, supporting services and command line utilities of Microsoft Transaction Server (MTS), and the elements and views of the MTS Explorer interface.  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential  more...

Visual InterDev 6 0 Accessing Remote Data C ourse 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  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...

Visual InterDev 6 0 Active Server Pages and Data Access ...d in the login authentication process for connecting to a SQL Server database. Add the connection information for connecting to a SQL Server database. Add a data connection to a project. Identify the features of a data command. Match the Query Designer panes with their functions. Add a data command to the data environment. Identify the data display and data manipulation controls.  more...

Oracle Workflow 11i10 Components Planning Workflow Processes This course covers the benefits of using Oracle Workflow in an e-business environment. It provides an overview of the architecture and components of Oracle Workflow. It also covers the components of a workflow process. Further, it covers the steps to plan a workflow process. It also covers various standard activities. Learn To: Identify benefits of Oracle Workflow. Identify features of  more...

Introduction to Data Warehousing Course Overview This course presents an introduction to Data Warehousing. Beginning with the basic concepts of data warehousing, this course helps you understand the processes involved in and the architecture of data warehousing. The tools involved in analyzing the warehouse data will also be covered. Finally, you'll learn about the Oracle data warehouse. L earn To: Identify the basic  more...

Oracle SQL Specifics Retrieving and Formatting Data Course Overview This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will  more...

Oracle SQL Tuning Tuning SQL and the Optimizer Course Overview This course is the second in a two-part series on SQL Statement Tuning. This course will help application developers to design SQL statements that can reuse parsing and influence the optimizer to improve performance. L earn To: Identify the factors that affect network traffic. Identify the factors that affect parsing. Identify the guidelines for the reuse of  more...

SQL Server 7 0 System Administration - Part 5 Course Overview 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. 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  more...

SQL Server 7 0 - Implementing a Database - Part 1 ...s. Sequence the steps for validating permissions. Match SQL Server databases with their descriptions. Match the database components with their descriptions. Select the characteristics of SQL Server objects. Match commonly used system tables with their functions. Identify methods for retrieving metadata from system tables. Sequence the steps for implementing a SQL Server database.  more...

SQL Server 7 0 - Implementing a Database - Part 2 Course Overview This is the second 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. 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  more...

SQL Server 7 0 System Administration - Part 1 ...ware applications. Sequence the steps for implementing a SQL Server database. Sequence the steps to administer a SQL Server database. Match each application deployment option with its description. Unit 2: Installing and Configuring SQL Server Duration: 2 - 3 Hour(s) Identify the hardware and software installation requirements for installing SQL Server 7.0. Perform a typical SQL  more...

SQL Server 7 0 System Administration - Part 2 ...rity, 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 size requirements and to plan for growth. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for installing, configuring, administering and  more...

SQL Server 7 0 System Administration - Part 3 Course Overview 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. 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  more...

SQL Server 7 0 System Administration - Part 4 Course Overview 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. 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  more...

SQL Server 7 0 - Implementing a Database - Part 3 Course Overview 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. 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  more...

SQL Server 7 0 - Implementing a Database - Part 4 Course Overview 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. 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  more...

SQL Server 7 0 - Implementing a Database - Part 5 Course Overview 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. 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  more...

SQL and PL SQL PL SQL Basics Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.  more...

SQL and PL SQL Basic SELECT Course Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic  more...

Oracle 11i 2 6 Implement Workflow Fundamentals Part 1 The course deals with fundamentals of Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify and automate business processes. Learn To: Identify features of Workflow-driven business processes. Identify features of business processes integration using Oracle Workflow. Match Oracle Workflow database  more...

Oracle Database 10g Administration Workshop II Part 1 This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Students will also practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Learn To: Match goals of Oracle Database 10g manageability features with the methods of achieving them. Identify features of the Oracle Database  more...

Oracle Database 10g New Features for Administrators Part 2 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as automatic management, manageability infrastructure, and application tuning and monitoring. Learn To: Identify features of Automatic Database Diagnostic Monitor  more...

Oracle Database 10g New Features for Administrators Part 4 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as flash backup and recovery. Learn To: Identify features of the flash backup and recovery strategy. Identify tasks that you perform when using the flash recovery  more...

Oracle Database 10g New Features for Administrators Part 5 Oracle Database 10g is designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. Oracle Database 10g supports the Oracle vision of creating a self-aware, self-learning, and completely self-managing database. This course covers new features of Oracle Database 10g such as automatic storage management, upgrade methods, RMAN backup, flash  more...

IBM DB2 Universal Database V6 1--Fundamentals Course Overview This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language  more...

IBM DB2 Universal Database V6 1--Fundamentals Course Overview This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language  more...

Oracle SQL for End Users--Part 1 Course Overview Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties, introduces the Oracle server, and indicates how SQL and SQL*Plus are used in the  more...

WebSphere MQ Integration Message Broker The purpose of this course is to provide learners with a general overview of the WebSphere Business Integration Message Broker product. The course introduces the business and technical reasons for a message broker, and the main features of WebSphere Business Integration Message Broker are then outlined. Students are given a basic understanding of how the product works and what tasks can be done  more...

Oracle 9i New Features Database Administration This course introduces learners to the Oracle9i enhancements in server-side manageability, Oracle Enterprise Manager, and globalization. Learn To Identify memory and space management improvements. Describe segment and index management improvements. Identify improvements in database operations and performance.  more...

Systems Analysis Using Client Server Model Part 1 Client Server Env This is the first course in a three part series that presents the students with instruction in the subject of fundamental client server concepts. This course will cover client server computing fundamentals, client server environment, development in the client server environment, and migrating to client server environment. Learn To: o Identify factors responsible for changes in the business  more...

Visual Basic NET-Web Based Development Part 3 Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security  more...

Visual Basic NET-Web Based Development Part 3 Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security  more...

MCSE Windows 2000 Electives Curriculum The MCSE Windows 2000 Electives Curriculum includes the following: MS Windows 2000: Migrating from MS Windows NT 4.0 Curriculum (ID#7556) Installing, Configuring & Administering Microsoft Exchange 2000 Server Curriculum (ID#7732) Microsoft ISA Server 2000 Curriculum (ID#8041) MS SQL Server 2000 Database Administration Curriculum (ID#7895) To review individual descriptions, please select  more...

CIW Dynamic Server Pages Part 3 Course Overview This is the final course in a three part series that students will learn about ActiveX Data Objects, error handling and dubugging ASP applications, project management in application development, and data integrity and security issues. Learn To • Identify the situations in which ADO would be used. • Identify ASP application development, error handling, and  more...

WebSphere MQ Integration Message Broker The purpose of this course is to provide learners with a general overview of the WebSphere Business Integration Message Broker product. The course introduces the business and technical reasons for a message broker, and the main features of WebSphere Business Integration Message Broker are then outlined. Students are given a basic understanding of how the product works and what tasks can be done  more...

MS Project Server 2003 Introduction Part 1 This course is the first part of a two-part series. This course will focus on introduction to Project Server 2003. It will also explain the software components of Project Server 2003, its architecture, and the configuration planning process. Learn To: Identify features of Microsoft Office Project Server 2003. Match the software components of Microsoft Office Project Server 2003 with  more...

MS Project Server 2003 Introduction Part 2 This course introduces you to the capabilities of Microsoft Office Project Server 2003. It includes how to plan, install, and configure the platform, as well as plan for client access across the organization. Learn To: Configure SQL Server authentication for Microsoft Office Project Server 2003. Identify features of SQL Server 2000 Analysis Services. Sequence the steps to manually  more...

Oracle Application Server 10g Administration Part 3 Oracle Application Server 10g is an integrated, standards-based software platform that allows organizations of all sizes to be more responsive to changing business requirements. This course covers managing, configuring OC4J applications, maintaining OC4J Application pages, OracleAS Portal, managing portal users and groups, exporting and importing portal objects, and Oracle portal advanced  more...

Oracle Application Server 10g Administration II Part 3 This course introduces the various Business Intelligence components such as Discoverer, Reports, Forms, and XML applications. The users learn about configuring and managing OracleAS Discoverer, OracleAS Reports Services, OracleAS Forms, and XML applications. They also learn how to deploy and manage OracleAS Web Services. Learn To: Match the components of Oracle Application Server  more...