Online Ms Access Database eLearning

Access 2002 Advanced Access 2002: Advanced Microsoft Lesson 1: Sharing Data Introduction Lesson Objectives Opening Access Opening The Northwind Sample Database Exporting Data Viewing Exported Data Exporting Data In HTML Format Opening An HTML File Sharing Reports Emailing A Report The Snapshot Viewer Viewing An Attachment Printing A Report Creating Backward Compatible Databases Renaming A Database  more...

Access 2002 Intermediate Access 2002: Intermediate Microsoft Lesson 1: The Access Interface Introduction Lesson Objectives Opening Access Opening The Northwind Database Customizing The Interface Creating A New Folder Other Options Changing The Default Database Folder Specifying Keyboard Behavior Setting Default Field Types & Sizes Creating A New Database Opening A Table Using Find Search Options Using  more...

Access 2002 Basic Access 2002: Basic Microsoft Lesson 1: The Access Interface & Database Objects Introduction Lesson Objectives About Databases Access Database Files Opening Access The Title Bar The Menu Bar The Ask A Question List Box The Database Toolbar The Task Pane Navigating Between Task Panes The Clipboard Task Pane The Basic & Advanced Search Task Panes Closing The Task Pane The Status  more...

Database Data Management Database Data Management To describe database data management and data access  more...

Discover Access 2007 Level 3 Discover Access 2007: Level 3 Microsoft Discover Access 2007 from Technology Skills is a rich, multimedia learning tool for users of Microsoft Access 2007. Access 2007 builds on the database capabilities of previous versions of the software program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. In Discover  more...

Discover Access 2007 Level 2 Discover Access 2007: Level 2 Microsoft Discover Access 2007 from Technology Skills is a rich, multimedia learning tool for users of Microsoft Access 2007. Access 2007 builds on the database capabilities of previous versions of the software program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. In Discover  more...

Discover Access 2007 Level 1 Discover Access 2007: Level 1 Microsoft Discover Access 2007 from Technology Skills is a rich, multimedia learning tool for users of Microsoft Access 2007. Access 2007 builds on the database capabilities of previous versions of the software program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. In Discover  more...

Oracle Database 11g Controlling User Access and Managing Schema Objects Oracle Database 11g: Controlling User Access and Managing Schema Objects Oracle To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...

Regular Expressions and User Access in Oracle Database 10g Regular Expressions and User Access in Oracle Database 10g Oracle To demonstrate how to use regular expression support and control user access in Oracle 10g  more...

Oracle Database 10g Database Interfaces Oracle Database 10g: Database Interfaces Oracle To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces  more...

Access XP Proficient Expert Access XP Proficient & Expert Microsoft DiscoverWare's Discover Access XP is an interactive productivity tool for users of Microsoft Access XP. Access XP builds on the database capabilities of previous versions of the program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. Topics cover basic database concepts  more...

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

Designing Efficient Application Access Designing Efficient Application Access Microsoft 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 Designing Queries in SQL 2005 Microsoft 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 Designing a SQL Server 2005 Cursor Strategy Microsoft recognize how to design and implement an appropriate cursor strategy in SQL Server 2005  more...

Designing a SQL Server 2005 Transaction Strategy Designing a SQL Server 2005 Transaction Strategy Microsoft 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 SQL Server 2005 Error Handling Techniques Microsoft 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 Optimizing Query Performance and Index Strategies Microsoft recognize how to optimize query performance and indexing strategies in SQL Server 2005  more...

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

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

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

Optimizing a Database Data Recovery Plan for SQL Server 2005 Optimizing a Database Data Recovery Plan for SQL Server 2005 Microsoft 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 Monitoring and Maintaining a Database in SQL Server 2005 Microsoft 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 Managing Database Data in a SQL Server 2005 Environment Microsoft 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 Managing Data Between Servers and Databases Microsoft 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 Managing and Maintaining Database Security in SQL Server 2005 Microsoft 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...

MICROSOFT SQL SERVER 2005 DESIGNING OPTIMIZING DATA ACCESS MICROSOFT SQL SERVER 2005: DESIGNING & OPTIMIZING DATA ACCESS Microsoft  more...

MICROSOFT SQL SERVER 2005 DATABASE MAINTENANCE MICROSOFT SQL SERVER 2005: DATABASE MAINTENANCE Microsoft  more...

Oracle Database 11g R2 Managing Databse Resources The Scheduler Oracle Database 11g R2: Managing Databse Resources & The Scheduler Oracle By using the Database Resource Manager, you have more control over the allocation of machine resources than is normally possible through operating system resource management alone. Many tasks in the Oracle environment need job-scheduling capabilities. Using advanced Scheduler features, you can exercise more control  more...

Cisco IINS 1 0 Perimeter Security Cisco IINS 1.0: Perimeter Security Cisco Cisco Certified Network Associate Security (CCNA Security) 640-553 Implementing Cisco IOS Network Security 1.0 Traffic from outside a closed network that has a destination inside a closed network passes through the network perimeter. The routers at the network perimeter are an important initial point of network security. This course explains how to  more...

Getting Started with Access 2003 Getting Started with Access 2003 Microsoft To create and navigate an Access 2003 database  more...

Working with Data and Presentation in Access 2003 Working with Data and Presentation in Access 2003 Microsoft To use PivotTables, PivotCharts, and other applications to present and handle database data  more...

Access 2003 Programmability Access 2003 Programmability Microsoft To use macros and Visual Basic for Applications to add interactivity to database objects  more...

Database Administration in Access 2003 Database Administration in Access 2003 Microsoft To implement methods of securing, sharing, replicating, and optimizing the performance of Access 2003 databases  more...

Exchanging Data with Excel 2007 Exchanging Data with Excel 2007 Microsoft In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in  more...

Getting Started with Access 2007 Getting Started with Access 2007 Microsoft With Access 2007, Microsoft introduces some of the most significant changes to Access in years. Most notable is the intuitive new user interface that replaces the traditional menus and toolbars with features like the Ribbon, the Quick Access Toolbar, and the Microsoft Office button. This course provides an introduction to Access 2007 and  more...

Basic Access 2007 Tables Basic Access 2007 Tables Microsoft Microsoft Office Access 2007 makes it easy for you to create and manipulate database tables. You can choose between a Datasheet view and a Design view to create tables from scratch, or you can base your tables on one of the many pre-defined templates. The introduction of the Ribbon and contextual tabs in Access 2007 makes table creation even more intuitive,  more...

Queries and Reports in Access 2007 Queries and Reports in Access 2007 Microsoft Queries and reports are used in Access 2007 to convert data into useful information and are an essential part of any database application. Access 2007 has a Query Wizard which simplifies the process of formulating a query and provides various methods of creating reports to present summarized information easily and effectively. This course explores  more...

Importing and Exporting Data and Data Presentation in Access 2007 Importing and Exporting Data and Data Presentation in Access 2007 Microsoft Microsoft Office Access 2007 offers several options for importing and exporting data, and also provides a variety of data presentation strategies. With Access 2007 you can link to, or import data and objects from external sources such as other Access databases, Excel spreadsheets, text files, XML files, and  more...

Programmability and Administration in Access 2007 Programmability and Administration in Access 2007 Microsoft Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007. This course explains how SharePoint sites can be used with Access and demonstrates options such as moving  more...

Database Administration in Access 2007 Database Administration in Access 2007 Microsoft Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007. This course explains how SharePoint sites can be used with Access and demonstrates options such as moving data to a  more...

Advanced Database Design in Access 2002 Advanced Database Design in Access 2002 Microsoft To provide an overview of advanced database design in Access 2002  more...

Advanced Database Features in Access 2002 Advanced Database Features in Access 2002 Microsoft To demonstrate a range of advanced database features in Access 2002  more...

SQL Server 2008 Instance Database Configuration SQL Server 2008: Instance & Database Configuration Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) SQL Server 2008's core component is its Database Engine, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. Another feature of SQL Server 2008 is  more...

SQL Server 2008 Security Management SQL Server 2008: Security Management Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) Microsoft SQL Server 2008 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2008 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified  more...

SQL Server 2008 Database Monitoring and Performance SQL Server 2008: Database Monitoring and Performance Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) To keep SQL Server 2008 databases running as efficiently as possible, administrators use a variety of performance tuning and monitoring tools. The SQL Server Profiler enables administrators to use trace files and logs to  more...

Creating Implementing Database Objects in SQL Server 2008 Creating & Implementing Database Objects in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) SQL Server 2008 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2008 database to meet business requirements, administrators and developers must  more...

Creating Modifying Table Index Partitions in SQL Server 2008 Creating & Modifying Table & Index Partitions in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) SQL Server 2008 offers the use of partitions to manage subsets of data for large tables and indexes. Partitions can be used to improve the read/write performance on tables within a database by allowing the data within tables  more...

Running Queries Manipulating Data in SQL Server 2008 Running Queries & Manipulating Data in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) SQL Server 2008 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query  more...

Creating Implementing Programming Objects in SQL Server 2008 Creating & Implementing Programming Objects in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) In SQL Server 2008 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not  more...

Implementing SQL Server 2008 Integration Services Implementing SQL Server 2008 Integration Services Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) Microsoft SQL Server 2008 offers a combination of powerful Business Intelligence services to help clients develop and manage sophisticated business intelligence solutions. With the Database Engine at its core,  more...

Deploying Delivering SQL Server 2008 Reporting Services Reports Deploying & Delivering SQL Server 2008 Reporting Services Reports Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) This course discusses features and tasks performed by administrators when working with SQL Server 2008 Reporting Services (SSRS) reports and content. After reports have been created and  more...

Maintaining SQL Server 2008 Reporting Services Maintaining SQL Server 2008 Reporting Services Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) Administration and maintenance of Microsoft SQL Server 2008 Reporting Services and its components is key in providing customers and clients access to the Business Intelligence information they need. This course  more...

Managing SQL Server 2008 Analysis Services Solutions Managing SQL Server 2008 Analysis Services Solutions Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) SQL Server 2008 Analysis Services provides a powerful solution for analyzing extremely large amounts of data in a relational database. This course looks at Analysis Services from a management perspective. It  more...

Oracle Database 11g Controlling User Access Managing Objects Oracle Database 11g: Controlling User Access & Managing Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...

Oracle Database 11g Problem SQL Statements Oracle Optimizer Oracle Database 11g: Problem SQL Statements & Oracle Optimizer Oracle Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command,  more...

Oracle Database 11g Architecture SQL Tuning Optimization Oracle Database 11g: Architecture, SQL Tuning & Optimization Oracle The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and  more...

Oracle Database 11g Indexes Access Paths and Join Operations Oracle Database 11g: Indexes, Access Paths and Join Operations Oracle Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access paths used for tables, such as full table, rowid, and sample table scan. It also examines the access paths used for indexes, such  more...

Oracle Database 11g Optimizer Statistics Hints Cursor Sharing Oracle Database 11g: Optimizer Statistics, Hints & Cursor Sharing Oracle Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course covers gathering optimizer and system statistics, setting statistic preferences, using dynamic sampling, and manipulating  more...

Oracle Database 11g Application Tracing Automatic SQL Tuning Oracle Database 11g: Application Tracing & Automatic SQL Tuning Oracle Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and  more...

Oracle Database 11g Securing Domain Data In Oracle Secure Backup Oracle Database 11g: Securing Domain & Data In Oracle Secure Backup Oracle Oracle Secure Backup (OSB) maintains its own catalog of OSB and their rights on the administrative server. You can preauthorize users for the use of the obtool command line, RMAN, or both. You can also associate an OSB user with multiple Windows domain accounts or a single account that applies to all Windows domains.  more...

Oracle Database 11g Basic User Strong Authentication Oracle Database 11g: Basic User & Strong Authentication Oracle A basic security requirement is that you must know your users. You must identify them before you can determine their privileges and access rights, so that you can audit their actions on the data. This course covers creating and auditing database authenticated users and operating-system-authenticated users. It explores  more...

Oracle Database 11g Enterprise User Security Proxy Authentication Oracle Database 11g: Enterprise User Security & Proxy Authentication Oracle Enterprise User Security addresses the user, the administrative, and the security challenges by centralizing storage and management of user-related information in a Lightweight Directory Access Protocol-compliant directory service. This course describes the basic components of Enterprise User Security. It shows the  more...

Oracle Database 11g Virtual Private Database Oracle Database 11g: Virtual Private Database Oracle A Virtual Private Database (VPD) uses fine-grained access control (FGAC) to limit row and column access and an application context to provide the information that is used to set the policy predicates. This course describes VPD, how to implement VPD, and group policies. It also explores how FGAC is used with VPD, as well as tools, policies,  more...

Oracle Database 11g Oracle Label Security the Data Masking Pack Oracle Database 11g: Oracle Label Security & the Data Masking Pack Oracle Oracle Label Security is a powerful tool for classifying data and mediating access to data based on its classification. It provides an easy-to-implement row-level security solution and is built on the fine-grained access control technology of the virtual private database (VPD). This course describes Oracle Label  more...

Oracle Database 11g Oracle Net Services Listener Security Oracle Database 11g: Oracle Net Services & Listener Security Oracle When considering Oracle security, you must also consider the security of the listener, which is the gateway to the network and the network itself. This course describes the items on the client, listener, and network security checklists. It demonstrates how to secure administration of the network, restrict access by IP  more...

Oracle Database 11g Firewalls Oracle Connection Manager and SQL Plus Security Oracle Database 11g: Firewalls, Oracle Connection Manager and SQL*Plus Security Oracle There is no single best architecture for accommodating Internet requests requiring access to corporate intranets. Instead, trade-offs must be made between two competing goals: security of the intranet against an Internet attack and ease of access to services by both Internet and intranet clients. This  more...

Oracle Database 11g R2 ASM Storage Partitioning Enhancements Oracle Database 11g R2: ASM, Storage & Partitioning Enhancements Oracle Oracle Database 11g Release 2 provides many improvements from its previous releases. This includes enhancements to ASM and storage to improve performance and to reduce server maintenance down time. This course identifies the enhancements in each of these areas. It also demonstrates how to use ASM fast mirror resync,  more...

Oracle Database 11g R2 Oracle Partioning Security Features Oracle Database 11g R2: Oracle Partioning & Security Features Oracle Oracle Database 11g Release 2 offers more advanced data warehouse, partitioning, security and network feature enhancements to allow the DBA to provide a more efficient way for users to access data in a secure environment. This course covers the enhanced data warehouse and partition enhancements, which includes support for  more...

Oracle Database 11g R2 Backup Recover Archive Repair Data Oracle Database 11g R2: Backup, Recover, Archive & Repair Data Oracle Oracle Database 11g Release 2 offers new and improved features to ensure for continuous data access, even during unplanned failures and scheduled maintenance tasks. New RMAN features make it easier to backup, recover and duplicate databases in a timely manner while minimizing data loss. It also offers Flashback technology,  more...

Oracle Database 11g R2 Storage Structures User Security Oracle Database 11g R2: Storage Structures & User Security Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 An Oracle database is divided into logical storage units called tablespaces. Oracle also provides Oracle-Managed Files (OMF), which eliminate the need for the DBA to directly manage the operating system files  more...

Beginning Webmastering Techniques( with site design/management focus ) Moderately Technical--HTML, DOM, CSS, UI design/layout database issues. Topics Covered : Site design, Performance Tuning, Adding audio, video and simple add-ons and also a broad overview of other Webmastering areas of speciality. Prerequisite: Some programming experience is helpful. Familiarity with networking concepts will also be helpful. Software/Hardware Requirement : A student will need to  more...

J2EE Part I ( JSP/servlet ) Learn the server-side Java in one easy attempt. Complement your web-front-end with this server-side part to create a whole application. Be comfortable with round-trip development. We will mainly cover JSP/servlet/JDBC in this course. Students will develop their own applications using server-side Java. Prerequisite: Strong understanding of the Java Programming Language and basic HTML, familiarity  more...

Client/Server Development and Remote Data Access in Visual Basic ...eating a standalone Visual Basic application that binds a MS Access database. The second section introduces the student to communicating over the Internet with TCP/IP by creating simple server and client Visual Basic applications that utilize the Winsock control. The final project section builds on skills learned in the first two sections to create a server application that accesses a database  more...

Access 2000 This course teaches students the basic database elements, good database design, Microsoft Access tools, and database maintenance and security, among many other skills. This course introduces students to basic elements that compose an Access database and strives to broaden and develop the database design skills that they already possess. Students will start out by learning what a database is and  more...

Access 2000 Expert This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. This advanced course strives to broaden and develop the intermediate database design  more...

Access 2000 Level 1 As students are introduced to the basic elements that compose an Access database, they will learn what a database is and how an effective database should be designed and set up. The students will also learn how to create their own databases and how to enter and manipulate data. This course introduces students to the basic elements that compose an Access database. Students will learn what a  more...

Access 2000 Level 2 In this intermediate course, students will gain a more complete understanding of how to effectively create and use the primary database objects in Access; how to maintain databases by backup, as well as how to compact and repair them; and how to employ techniques designed to make data entry faster, easier, and less error-prone. This intermediate course strives to broaden and develop the basic  more...

Access 2000 Level 3 In this advanced course, students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, and how to use Access as a development tool. Various maintenance and security features are covered in the course, teaching students ways to better manage multi-user databases. This advanced course strives to broaden and develop the intermediate  more...

Access 2000 MOUS This comprehensive course teaches students both the basic and the more advanced elements that compose an Access database. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. This comprehensive course teaches students both the basic and the more advanced  more...

Access 2000 Proficient This comprehensive course teaches students both the basic and more advanced elements that compose an Access database. The course will teach skills such as database creation; creation and use of tables, forms, filters and sorts, queries, and reports; as well as some techniques designed to make data entry in Access databases faster, easier, and less error-prone. This comprehensive course teaches  more...

Access 2002 This course introduces students to the basic elements that compose an Access database. Students will learn what a database is and how an effective database should be designed and set up. As the course becomes more advanced, students will use Microsoft Access as a development tool. The course strives to broaden and develop the basic database skills that students already possess. This course  more...

Access 2002 MOUS This course introduces students to the new features in Microsoft Access 2002 that set it apart from Access 2000. This includes speech recognition and the new Task Pane, as well as basic elements that compose an Access database. As the course becomes more advanced, students will gain a more complete understanding of how to effectively create and use the primary database objects in Access and how to  more...

Access 97 This course introduces the database functions of Microsoft Access 97, such as working with Access menus and dialog boxes, creating and editing tables, formatting columns and rows, and planning table design. Accomplished users will work on advanced forms, use parameter and crosstab queries, and employ complex calculation expressions and selection criteria.  more...

Access 97 Level 1 Students will learn the database fundamentals of Microsoft Access 97, such as working with Access menus and dialog boxes, creating and editing tables, formatting columns and rows, and planning table design. Students will also learn about records, wizards and shortcuts, and AutoForms.  more...

Lotus Notes 5.0 Level 2 This course introduces students to advanced features of Lotus Notes 5.0. They will work with many Lotus Notes features used in customizing e-mail messages and accessing database material. This course enhances a student's basic understanding of Lotus Notes 5.0 by introducing them to the advanced features of Lotus Notes 5.0. Students will work with many Lotus Notes features used in customizing  more...

Microsoft Access 2002 Core This course will introduce students to the new features in Microsoft Access 2002, including speech recognition and the new Task Pane, as well as teaching them database creation and how to create and use tables, forms, filters and sorts, queries, and reports. This course will introduce students to the new features in Microsoft Access 2002 that set it apart from Access 2000, including speech  more...

Microsoft Access 2002 Expert This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Various maintenance and security features are also covered, teaching students ways to better manage multi-user databases. This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Students will gain a more  more...

Microsoft Access 2002 Level 1 Students will learn what a database is and how an effective database should be designed and set up. This course will also cover the new features in Access 2002 that set it apart from Access 2000, including speech recognition and the new Task Pane. This course introduces students to the basic elements that compose an Access database. Students will learn what a database is and how an effective  more...

Microsoft Access 2002 Level 2 Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. Students will also learn a variety of techniques designed to make data entry in Access databases faster, easier, and less error-prone. This intermediate course strives to broaden and develop the basic  more...

Microsoft Access 2002 Level 3 Students will be introduced to advanced features and gain a more complete understanding of how to effectively create and use the primary database objects in Access. Various maintenance features are also covered, teaching students ways to better manage multi-user databases. This advanced course strives to broaden and develop the intermediate database design skills that students already possess.  more...

Office 2000 Advanced In this course, students will learn how to use the advanced features of Microsoft Word, Excel, Access, and PowerPoint 2000, as well as a section on business writing. This advanced level course introduces the accomplished user to the most powerful aspects of these applications. It also strives to help the professional become a more effective writer. In this course, students will learn how to use  more...

Office 2000 Intermediate This course is designed to familiarize students with the intermediate features of Microsoft Word, Excel, Access, PowerPoint, and Outlook 2000. It also includes a section on presentation skills. This course introduces students to the more powerful aspects of these applications and attempts to broaden and develop the basic skills that they already possess. This course is designed to familiarize  more...

Office XP (2002) Introduction This course introduces students to the basic features of Microsoft Office XP. It covers the major new features that apply to all of the applications. This includes Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Microsoft Access, Microsoft FrontPage, and Microsoft Outlook. Students will learn the intoductory features that each of these applications has to offer. This course introduces  more...

Outlook 98 Level 1 This course introduces students to the basic features of Microsoft Outlook 98 by working through a series of exercises and scenarios that will instruct them in the functions of numerous buttons, menus, and folders. Students will also learn how to customize Outlook as their desktop Personal Information Manager (PIM). This course introduces students to the basic features of Microsoft Outlook 98,  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. This course is design to help students master the concept of administering Microsoft? SQL Server 2000 (SQL) databases effectively. When a student completes this course he/she will be able to plan and complete a successful installation or upgrade,  more...

Access 2007 Level 1 This entry-level course introduces students to the basic elements that comprise a Microsoft Office Access database. Students will learn what a database is and how an effective database should be designed and set up. They will learn the importance of establishing relationships, as well as how to establish and edit relationships and enforce referential integrity. Access 2007 Level 1 This  more...

Access 2007 Level 2 Access 2007 Level 2 strives to broaden and develop the basic database design skills that students already possess. Students will gain a more complete understanding of how to create and use the primary database objects in Microsoft Office Access 2007, including tables, queries, forms, and reports. Access 2007 Level 2 Strives to broaden and develop the basic database design skills that students  more...

Crystal Reports XI Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Crystal Reports XI Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Follow Jason Manibog as he teaches you  more...

Database Management This course features coverage of the important aspects of the relational PC-based database model including coverage of SQL. A highly useful methodology for designing databases is presented and illustrated through a variety of examples. This course is designed for anyone interested in gaining familiarity with database management. Someone taking this course should have some experience using a  more...

Expert Certificate Course in Medical Transcription with Work Placement Program With no medical background necessary, you can learn to transcribe doctor`s dictation into documents with our online training.We offer hours and hours of transcription practice prepared by doctors so youare ready for the working world when you graduate. We employ six MT instructors,train you in an online-friendly manner, and encourage students to interact witheach other in online forums. All course  more...

Microsoft Access XP Certification Our Access XP gives you powerful new tools for managing your data. Welcome to Microsoft Access XP Certification Our Access XP gives you powerful new tools for managing your data. Share your database with co-workers over an Intranet, find and retrieve information quickly, and take advantage of automated, pre-packaged solutions to quickly create databases. Our interactive training series will show  more...

Microsoft Access 2003 (Levels 1-2-3) Our Access 2003 gives you powerful new tools for managing your data. Microsoft Access 2003 (Levels 1-2-3) Our Access 2003 gives you powerful new tools for managing your data. Share your database with co-workers over an Intranet, find and retrieve information quickly, and take advantage of automated, pre-packaged solutions to quickly create databases. Our interactive training series will show you  more...

Oracle 10g OCA The demand for Oracle technical professionals is growing fast. Experienced or new to the profession you need to know what skills make you more attractive to employers. You will have 1 year access to this course but can complete it as quickly as you like to. Oracle 10g OCA The demand for Oracle technical professionals is growing fast. Experienced or new to the profession you need to know what  more...

Microsoft Office Access 2003 Level 1 Introduces the basic elements of Microsoft Office Access. Students learn what a database is and how an effective database should be designed and set up. They learn how to manipulate the Access interface and create their own databases, students will receive instruction in how to create and use the basic tools of the Access application. This course is designed to introduce students to the basic  more...

Microsoft Office 2000 - Beginning Access To provide an introduction to the core concepts of Microsoft Access 2000 and the skill areas of planning and creating a database, creating tables and forms, and entering and querying data  more...

Dreamweaver MX Web Applications This is the second course in a series of tutorials from the Virtual Training Company for Dreamweaver MX. It covers all that techniques required to construct a data driven web site. Author Mark Fletcher (a member of Team Macromedia) will teach you how to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet  more...

Access 2000 User Series Access 2000 Beginning (2 Hours 6 Minutes) 1.0 Introduction (26 Minutes) 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database (33 Minutes) 2.1 Viewing and Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting and Deleting Records 2.5 Find  more...

Access 2000 Beginning Access 2000 Beginning (2 Hours 6 Minutes) 1.0 Introduction (26 Minutes) 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database (33 Minutes) 2.1 Viewing and Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting and Deleting Records 2.5 Find  more...

Access 2000 Intermediate Access 2000 Intermediate (2 Hours 4 Minutes) 1.0 Planning and Designing a Database (20 Minutes) 1.1 Evaluating Inputs and Outputs 1.2 Normalization 1.3 Creating a Database Using a Wizard 1.4 Creating a Database from Scratch 2.0 Building and Modifying Tables (49 Minutes) 2.1 Creating Tables Using a Wizard 2.2 Creating Tables from Scratch & Data Types 2.3 Setting Primary Keys 2.4 Field Properties  more...

Access 2000 Advanced Access 2000 Advanced (2 Hours 3 Minutes) 1.0 Building and Modifying Forms (51 Minutes) 1.1 Adding Controls 1.2 Selecting Controls 1.3 Moving, Sizing and Deleting Controls 1.4 Aligning Controls 1.5 Changing Control Properties 1.6 Changing the Tab Order Controls 1.7 Form Properties 1.8 Working with Combo Boxes and List Boxes 2.0 Building and Modifying Reports (26 Minutes) 2.1 Understanding Report  more...

Accessing Data and Manipulating DB2 UDB Database Objects To access data and manipulate database objects  more...

Managing Database Access in DB2 UDB To describe database access management in DB2 UDB  more...

Oracle Database 11g Partitioning and Storage-Related Enhancements identify the benefits of Oracle Database 11g's partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.  more...

Subqueries Reporting and User-Access Control in Oracle9i To describe the use of subqueries, reporting, and user-access control in an Oracle9i database  more...

Access 2000 - Proficient DiscoverWare's Discover Access 2000 is an interactive productivity tool for users of Microsoft Access 2000.Access 2000 builds on the database capabilities of previous versions of the program to provide powerful tools for building and maintaining professional databases.Topics include basic database concepts,planning a database, creating and modifying tables and forms,finding and sorting  more...

Access 2000 Expert 1. Access 2000 (Expert) Basics Work With Toolbars The Menu Bar & Other Toolbars Install Add-In Programs What Is An Add-In? Install & Load Add-Ins Unload Add-Ins Work With Previous Versions Of Access Access 2000 & Previous Versions Of Access Access 2000 & Access 97 Access 2000 & Access 95 Convert A Database Set Startup Options Set Startup Options Help In Access 2000 The Office Assistant Microsoft  more...

Visual InterDev 6 0 Active Server Pages and Data Access C ourse Overview This is the third 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 identify the features of Active Server Pages (ASP); create a server script and debug the server-side script;  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...

Frontpage 2000 Expert User C ourse Overview This course prepares IT Professionals to create, organize and manage a Web using FrontPage 2000. L earn To: Import and modify an existing Web. Customize a FrontPage Web. Client-server interaction. C ontent Emphasis Skills-Based A udience This course is intended for end users using Microsoft FrontPage 2000. Participants should have a basic  more...

NetWare 5 Advanced Administration - Part 5 C ourse Overview This is the last course in a five-part series on Novell NetWare 5 Advanced Administration. This series provides the knowledge and skills necessary to design, configure, and administer a complex NetWare 5 network. This course will cover maintaining Novell Directory Services (NDS), NDS troubleshooting and repair, setting up remote access services, and other Novell services.  more...

Lotus Notes R5 Collecting and Organizing Information Course Overview This course provides participants with the fundamental skills to use Lotus Notes R5 on a daily basis in their workplace. At the completion of this course, students will learn how to identify the different application types in Lotus Notes, the features provided for Lotus Notes mails and the features of Notes replication; use Notes workspace to perform common tasks; create and  more...

Lotus Notes R5 Managing and Sharing Information Course Overview This course provides participants with the skills necessary to use Lotus Notes R5 on a daily basis in their workplace. At the completion of this course, students will learn how to design and manage forms and views; search domains, address books and the Internet for information; automate routine tasks by using agents; browse the Web by using the Personal Web Navigator; manage  more...

Microsoft FrontPage 2003 Expert User This course covers higher-level skills of working with FrontPage, including web components and style sheets, advanced forms and data driven pages, and non-HTML technologies and Share Point Services. Learn To: Create a table of contents for a Web page. Insert a photo gallery into a Web page. Identify features of advanced controls that can be inserted in a Web page. Identify  more...

Oracle Database 10g Administration Workshop II Part 4 This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Learners will learn how to use various database technologies, such as Resource Manager, the Scheduler, and materialized views. Learn To: Identify features of Automatic Storage Management (ASM). Identify features of Automatic Storage Management (ASM)  more...

Oracle Database 10g Administration Workshop II Part 3 This course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption. Learn To: Identify features of  more...

Oracle Database 10g Adminsitration Workshop I Part 3 This course provides an understanding of the Database Security. This course will help the learner to understand the benefits of database auditing and monitoring. It also covers Database Listeners and Services. The concept of shared and dedicated servers is also covered. After going through this course, the learners would be able to tune the system for best performance by configuring automatic  more...

Oracle Database 10g SQL Fundamentals I Part 2 In this course, the learner will learn how to use the advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. . Learn To: Identify  more...

Oracle Database 10g PL SQL Fundamentals Part 1 In this course, the learner will get familiar with the procedural language to access Oracle database. The learner will learn how to write and use anonymous PL/SQL blocks, program constructs, simple and composite PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as  more...

SAP R 3 System Management System Administration Course Overview The course SAP R/3 System Management is intended to give all company employees, working in the area of system administration a thorough overview of all areas within system administration and possibilities of use. L earn To: Introduction to the R/3 Basis System. Architecture/System Landscape. R/3 Services. R/3 Networks. Basic Administration  more...

Lotus Notes R5 Managing and Sharing Information Course Overview This course provides participants with the skills necessary to use Lotus Notes R5 on a daily basis in their workplace. At the completion of this course, students will learn how to design and manage forms and views; search domains, address books and the Internet for information; automate routine tasks by using agents; browse the Web by using the Personal Web Navigator; manage Web  more...

Building Cisco Remote Access Networks Part 1 This is the first in a four-part curriculum that prepares the learner to take the Building Cisco Remote Access Networks (BCRAN) v2.0 exam. The course starts with coverage of the basics of WAN technologies and components. The areas then covered are: security in expanding networks, the configuration of asynchronous connections, and controlling network access through PPP. Learn To:  more...

Oracle SQL Specifics Creating and Managing Database Objects Course Overview This course is the second 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. Users will learn how to create and manage tables, build integrity constraints, and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain  more...

Oracle SQL Tuning Diagnostics and Tuning Schema Course Overview This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash  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  more...

Oracle Form Builder Managing Module Types Course Overview This course is the fourth in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course will introduce participants to Project Builder and teach them how to create and manage a menu module. In addition, users will learn how to customize and implement menu security. L earn To: Identify the benefits and terminology of Project  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.  more...

Oracle8 Performance Tuning Strategies and Techniques Course Overview This course is the first in a three-part Oracle8 Performance Tuning series. This course will introduce participants to tools and techniques used to improve the performance of the Oracle8 server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally, students will  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 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...

Oracle Form Builder R6 Project Builder and Menu Modules Course Overview This course is the fourth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes the features and benefits of Oracle Project Builder, how to create and deliver projects, and how to create new file types. In addition, the course describes how to create and manipulate menu modules, and how to manage menu modules. L earn To:  more...

TCP IP Internetworking on Windows NT 4 0 Curriculum Course Overview This course series will help individuals prepare for certification exam 70-059. This exam is an elective for MCSE certification. To become a Microsoft Certified Systems Engineer you are required to pass four operating systems exams and two elective exams that provide a valid and reliable measure of technical proficiency and expertise. L earn To: Microsoft Class -  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 - 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...

Site Server 3 0 Implementation - Part 1 Course Overview This is the first course in a three part series that will help students prepare for the Microsoft Certified Professional exam 70-056, Implementing and Supporting Web Sites Using Microsoft Site Server 3.0. At the completion of this course, students will learn to install and configure Microsoft Site Server 3.0; identify the procedures involved in publishing content; and understand  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  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 1 Course Overview This is the first 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 be introduced to the Visual Basic environment and its main options and characteristics. Students will also learn the strategy for Universal Data Access and the visual  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 2 Course Overview This is the second 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: Identify the definition, features of MFC key classes and the differences between SDK and MFC, static and dynamic and regular vs.  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 5 Course Overview This is the fifth 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: Store and retrieve data from a file and registry by using MFC. Implement remote communication by using the Socket and Serial  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...

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

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

Frontpage 2000 Expert User Course Overview This course prepares IT Professionals to create, organize and manage a Web using FrontPage 2000. L earn To: Import and modify an existing Web. Customize a FrontPage Web. Client-server interaction. C ontent Emphasis Skills-Based A udience This course is intended for end users using Microsoft FrontPage 2000. Participants should have a basic  more...

NetWare 5 Advanced Administration - Part 5 Course Overview This is the last course in a five-part series on Novell NetWare 5 Advanced Administration. This series provides the knowledge and skills necessary to design, configure, and administer a complex NetWare 5 network. This course will cover maintaining Novell Directory Services (NDS), NDS troubleshooting and repair, setting up remote access services, and other Novell services. L  more...

Access 2000 Fundamentals Course Overview This course is intended for end users who are looking to use the fundamental capabilities of Microsoft Access 2000. Participants will learn to identify the basic features of Access 2000; create and maintain tables; and work with Access 2000 data. L earn To: Identify the concepts related to databases and the features of Access 2000. Create and maintain tables and  more...

Access 2000 Proficient User Course Overview This course is intended for end users that are looking to use the intermediate skills of Microsoft Access 2000. At the completion of this course, students will learn how to use Access 2000 to maintain tables and table data; manage Access 2000 data; create and modify forms; and create and modify report formats. L earn To: Use Access 2000 to maintain tables and table  more...

Access 2000 Expert User Course Overview This course provides participants the knowledge to use the advanced features of Microsoft Access 2000. At the completion of this course, students will learn how to create and refine queries; create, modify and enhance the forms in the Design view; create, modify and enhance reports; and secure and enhance the performance of an Access 2000 database. L earn To: Create  more...

Lotus Domino R5 System Admin Part 4 User Setup Configuration Course Overview This is the fourth course in a ten part series for system administrators who are responsible for Domino server and Notes client. At the completion of this course, students will learn how to identify the factors that need to be considered before registering a user in Notes R5; register a user in Notes R5; and install and configure Notes R5. L earn To: Identify the  more...

Lotus Domino R5 System Admin Part 7 Security Planning Implementation Course Overview This is the seventh course in a ten part series for system administrators who are responsible for Domino server and Notes client. At the completion of this course, students will learn how to plan and implement Domino security at an organization; control the access to user IDs and Domino servers; secure Domino database by using database ACLS, roles, and forms and view access  more...

Lotus Domino R5 System Admin Part 8 Internet Connectivity Security Course Overview This is the eighth course in a ten part series for system administrators who are responsible for Domino server and Notes client. At the completion of this course, students will learn how to configure and customize the Domino Web server; set up LDAP, directory assistance, and NNTP; identify the ways to provide Internet security by using firewalls, and set up certification  more...

SQL and PL SQL Data Retrieval Techniques Course Overview This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries.  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...

Windows 2000 Installation Config Admin --Part 5 Network Imp Course Overview This is the fifth course in an eight-part series that will provide IT professionals with the knowledge and skills necessary to implement, administer, and troubleshoot Microsoft Windows 2000 Professional and Server. At the completion of this course, students will learn to identify the lease generation process followed by DHCP, host name resolution process of DNS and the features  more...

GroupWise 5 5 Admin Part 2--Clients Post Offices Course Overview The GroupWise System Administration curriculum is designed to teach students the fundamentals of administering a GroupWise system. In this course, students will gain skills and knowledge needed to install and configure GroupWise 5.5 clients as well as work with both single and multiple post office systems. L earn To: Teach the installation process for the GroupWise  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  more...

GroupWise 5 5 Admin Part 3--System Maintenance Course Overview The GroupWise System Administration curriculum is designed to teach students the fundamentals of administering a GroupWise system. This final course in the 3-part series will give students the skills and knowledge needed to perform routine GroupWise 5.5 administration tasks as well as client and database maintenance. L earn To: Identify GroupWise system objects and how  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...

UNIX--Part 1 User Fundamentals Course Overview The UNIX Part 1: User Fundamentals course is the first in a series of 10 courses on the UNIX operating system. It describes how to get started with UNIX, introducing the Common Desktop Environment (CDE) and the terminal window. It introduces files, directories, and printing and operations frequently performed on these. It teaches how to manipulate input and output, as well as how  more...

UNIX--Part 2 Advanced Topics for Users Course Overview The second course in the UNIX curriculum teaches end users a little about how UNIX works and handles resources. It shows how UNIX can be best used by advanced users in a UNIX-based enterprise. This course can even act as a starting primer for users interested in becoming administrators. L earn To: Identify the hardware requirements for a UNIX system. Identify the  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...

SCO SVR 5 --Part 2 Network Administration Course Overview This second course in the SCO SVR 5 implementation track covers internetworking connectivity, systems, services, and security. Wherever possible, It focus's on the tools and features specific to SCO SVR5. L earn To: Identify the features of the Printer Setup Manager. Identify the command-line interface (CLI) commands used to configure printing in UnixWare 7.  more...

Solaris--Part 2 Network Administration Course Overview This second course in the Sun Solaris implementation track covers internetworking connectivity, systems, services, and security. Wherever possible, It focus's on the tools and features specific to Solaris. L earn To: Identify the characteristics of the print service. Identify the CLI commands used to add a network printer. Identify the CLI commands used to manage  more...

IBM AIX--Part 1 Basic Administration Course Overview In this course, you will learn about installing and setting up an IBM/AIX system. You will learn about system administration. Finally, you will learn about methods for optimizing the system. L earn To: Identify the features of AIX and RS/6000. Identify the functions of the AIX system administrator. Identify the hardware requirements for the installation of AIX 4.3.  more...

HP-UX--Part 1 Basic Administration Course Overview The first course in the HP/UX implementation track covers basic user and system administration in the HP/UX environment. It focuses on the common skills that an administrator will perform and how they are handled in this flavor of Unix. L earn To: Identify the features of HP-UX versions 10 and 11. Identify the function of the HP-UX system administrator. Identify the  more...

Oracle SQL for End Users--Part 2 Course Overview This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course, the learner displays data from multiple tables by using equijoins, non-equijoins, and self joins. In addition, this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database.  more...

CIW Perl Fundamentals Part 1 Basic Syntax Course Overview This is the first course in a three part series that presents students with both theoretical and practical instruction on the foundations of the Perl language. Students will also become familiar with an Introduction to Perl, Flow Control, Arrays, and Associative Arrays. Learn To Identify characteristics of the Perl programming language. Identify characteristics of the  more...

CIW Perl Fundamentals Part 2 Manipulating Scripts Course Overview This is the second course in a three part series that students will learn both theoretical and practical instruction on external data Perl scripts. This course will also cover regular expressions and pattern matching, subroutines, and file access and manipulation. Learn To Identify the syntax of pattern binding operators. Match metacharacters with their functions.  more...

CIW Perl Fundamentals Part 3 Best Practices Course Overview This is the final course of a three part series that presents students with an overview of best practices for Perl. Students will learn about packages and modules, object orientation, database connectivity, and debugging Perl scripts. Learn To Identify characteristics of a package. Identify characteristics of package symbol tables. Identify characteristics of BEGIN and  more...

Office XP-New Features Curriculum Course Overview This curriculum provides a general overview of new productivity and information handling tools. It concentrates on new features within Microsoft Word, Excel and PowerPoint, and Microsoft Office XP software. Additionally, there is an emphasis on database, e-mail, and Internet software. This curriculum consists of two Skill Builder courses: Course 74010 Microsoft Office XP - New  more...

Office XP New Features Part 2 Access Outlook FrontPage Course Overview This is the second course in a two part series that presents the learner with the second of two sets of new features available in the Microsoft Office XP software. The course emphasis is on database, e-mail, and Internet software. Learn To Identify the undo and redo capabilities of Access 2002. Learn To: Identify the features of error logging in database conversions. Learn  more...

Access XP Fundamentals Course Overview This course presents the learner with the fundamentals of Microsoft Access 2002. This course guides the learner through the basics of Access databases and covers topics such as creating and modifying databases, and establishing relationships between tables. Learn To • Identify advantages of a relational database. • Identify the basics of a relational database.  more...

Access XP Proficient User Course Overview This courses covers more advanced features of Access 2002. Individuals will learn how to make different types of data queries, work with forms and link data to other databases. Learn To • Create a single-table query in Design view. • Create a multiple-table query in Design view. • Create a simple query by using the Simple Query Wizard. • Identify  more...

Access XP Expert User Course Overview This course covers the more complex aspects of working with data using Access 2002. Assuming the learner is already proficient in Access, the course covers advanced features of database queries, and enhancing forms and reports. Learn To • Create an update query. • Create a delete query. • Create an append query. • Create a form in Design view.  more...

FrontPage XP Expert User Course Overview This course delivers instruction on the higher level skills required to work with Web sites in FrontPage 2002. Modification and structuring of Web sites are covered, as well as, design considerations and procedures fundamental to Web site customization that include the creation of dynamic pages, frames and tables. Finally, essential elements in client/server interaction, such as  more...

Outlook XP Expert User Course Overview This course teaches the advanced features of Outlook 2002 and will enable the learner to become an expert user. Message formats and templates, security tools and network configuration newsgroups, instant messaging and working remotely topics are covered in the course. It assumes the learner has taken the Outlook Fundamentals and Proficient User courses. Learn To •  more...

XML Building XML-Based Web Applications Part 2 Course Overview This is the second course in a five part series that presents an introduction to the treatment of validation technologies within XML. DTDs are covered, presenting detail on DTD elements and attributes and entities. XML Schemas are then introduced, emphasizing the advantages of schemas over DTDs and then covering data types and namespaces within XML Schemas. The course then  more...

Oracle9i SQL Data Retrieval Techniques This course covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries. Learn To: o Identify the four Oracle join types used to display data from more than one table. o  more...

WebSphere MQ Programming I This course begins with coverage of the MQ environment and then focuses on the major calls of the MQI. Learn To To identify features of WebSphere MQ messaging. To distinguish between queue and database resource managers. To differentiate between environments supported by WebSphere MQ.  more...

MS Win XP Install Admin Part 3 TCP IP NOS Environments This is the third course in a five part series on the Microsoft Windows XP Installation and Administration curriculum. It introduces the concepts behind TCP/IP, and teaches how to support TCP/IP on computers running Microsoft Windows XP Professional. The course also covers the TCP/IP name resolution process, and provides an introduction to installing and configuring Internet Information Server,  more...

WebSphere MQ Programming I This course begins with coverage of the MQ environment and then focuses on the major calls of the MQI. Learn To To identify features of WebSphere MQ messaging. To distinguish between queue and database resource managers. To differentiate between environments supported by WebSphere MQ.  more...

CIW Enterprise Specialist Part 2 CORBA Servers Adv Features Security This is the second course in a five-part series that covers the building of CORBA servers, and advanced features such as Factory and callback objects, exceptions and DII, and CORBA security. The participant will learn how to use the IDL-to-Java compiler to generate server skeletons and how to implement CORBA objects using these skeletons. Server IDL skeletons, CORBA servers and naming services,  more...

Defining Microsoft NET Solution Architectures Part 3 This is the third of a four-part curriculum that prepares the learner for Exam 70-300. The course is devoted to the coverage of the Physical Design phase of the solution design process. Coverage is given in turn to Physical Design goals and models, Physical data modelling, the Presentation Layer, and Design Goals behind the Physical Design. A case study on the Physical Design phase completes the  more...

Defining Microsoft NET Solution Architectures Part 3 This is the third of a four-part curriculum that prepares the learner for Exam 70-300. The course is devoted to the coverage of the Physical Design phase of the solution design process. Coverage is given in turn to Physical Design goals and models, Physical data modelling, the Presentation Layer, and Design Goals behind the Physical Design. A case study on the Physical Design phase completes the  more...

Database Technologies Relational Database Fundamentals The first of a two-part series, this course will introduce the learner to the fundamentals of relational databases and relational database design, including an in-depth look at data modeling and data design. This course will also cover the evolution of data access and the role that databases and associated enabling technologies play in today's corporate environments. Students should leave this  more...

Database Technologies Introduction to SQL The second in a two-part series, this course will teach students the fundamental skills and knowledge needed to acquire a foundation-level understanding of SQL. Building on the basic relational database skills and knowledge acquired in the first course, this course teaches students the essential SQL statements, and associated variations, needed to perform fundamental data access and manipulation  more...

Visual Basic NET-Web Based Development Curriculum The Microsoft Visual Basic.NET-Web Based Development Curriculum introduces Microsoft Visual Studio.NET and ASP.NET Web application projects. The student will learn about error handling and code debugging, user input validation, ADO.NET database connections and data access. The student is also taught the creation and use of XML Web services and the configuration and deployment of Web applications  more...

Visual Basic NET-Web Based Development Curriculum The Microsoft Visual Basic.NET-Web Based Development Curriculum introduces Microsoft Visual Studio.NET and ASP.NET Web application projects. The student will learn about error handling and code debugging, user input validation, ADO.NET database connections and data access. The student is also taught the creation and use of XML Web services and the configuration and deployment of Web applications  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...

Visual Basic NET-Windows Development Part 5 The Debugging and Deploying Windows Forms Applications sections in this course explains assemblies and the use of strong-named assemblies and the Global Assembly Cache (GAC) in the .NET Framework. It also covers how to configure and deploy your Windows Forms applications. The Securing Windows Forms Applications section explains how to use the security features in the .NET Framework in Windows  more...

Visual Basic NET-Distributed Applications Part 3 The Microsoft Visual Basic .NET-Distributed Applications Pt 3: Data Access course teaches learners how to consume and manipulate data by using ADO.NET. Learn To: a To identify features of ADO.NET. a To identify benefits of ADO.NET. a To sequence the steps to read data from a database in a connected environment. a To identify features of DataSets. a To  more...

LAN WAN Integration This course will cover vendor-independent issues relating to the integration of key networking technologies. LAN/WAN Integration is designed to explain internetworking between LANs, as well as LANs with WANs. Students will learn about networking services, protocols, architectures and technologies, and will provide new insight into the methods of integrating LANs with WANs. Additionally, this  more...

Essentials of Management Negotiating Skills In "Essentials of Management: Negotiation Skills" you will learn about the basic types of negotiations and the skills required to use them. You will also learn how to prepare effectively for negotiation by setting your goals and limits and applying logic. Because negotiation is essentially about communication, you learn about the value of mutual benefit and positional negotiation and other  more...

Access 2003 Fundamentals This course, along with the Proficient User course, maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. It presents the learner with the fundamentals of Microsoft Access 2003. The student learns how to create tables and relationships, how to manipulate tables, and how to create simple and advanced queries. Learn To  more...

Access 2003 Proficient User This course, along with the Fundamentals course, maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. Assuming knowledge of the fundamentals, it teaches how to create forms and reports and how to format controls on both forms and reports. The student is also introduced to importing and exporting data to and from Access. Finally, this course teaches  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 Basic 6 0 Designing Implementing Desktop Applications - Part 4 Course Overview This is the fourth 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 Basic 6 0 Designing Implementing Desktop Applications - Part 5 Course Overview This is the final 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 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 Distributed Applications - Part 3 Course Overview This is the third 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 features of SQL Server and select the data integrity to implement in a given situation. Use the ActiveX Data Object (ADO) types for establishing a connection, executing a command, navigating recordsets,  more...

E-Commerce Implementation Issues This course provides the learner with information and case studies highlighting the issues associated with E-commerce Implementation. Learn To: Identify the components of a basic e-commerce Web site. Identify the functions of online storefront systems. Identify the role of user access control and authentication software in selling products online. Identify key payment  more...

Lotus Notes R5 Collecting and Organizing Information Course Overview This course provides participants with the fundamental skills to use Lotus Notes R5 on a daily basis in their workplace. At the completion of this course, students will learn how to identify the different application types in Lotus Notes, the features provided for Lotus Notes mails and the features of Notes replication; use Notes workspace to perform common tasks; create and  more...

Oracle8 Network Administration Net8 Configuration and Troubleshooting Course Overview This is the second course in a two-part series based on Oracle8 Network Administration. This course introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established  more...

Site Server 3 0 Commerce Solutions - Part 1 Course Overview This is the first course in a two part series that will help students prepare for the Microsoft Certified Professional exam 70-057, Designing and Implementing Commerce Solutions with Microsoft Site Server 3.0, Commerce Edition. At the completion of this course, students will learn to understand the methods and procedures of designing a Commerce site; identify the structure of a  more...

MS Office 2003 Introduction to Office 2003 This course will give new Office users a quick jump-start on the major applications in the suite. It will include a broad overview of the components of Office 2003, followed by a quick introduction to Word, Excel, Access, and PowerPoint. Learn To To match Office core applications with their functions. To identify common interface features  more...

Lotus Domino R5 Configuring Optimizing the Environment Course Overview This is the final course in a two part series that will teach Lotus Domino 4.x system administrators about the new Domino R5 system administration features, the impact of those features on their job, and how to migrate their organizations from Domino R4.x to R5. At the completion of this course, students will learn how to set up the administration process and configure LDAP and  more...

Lotus Notes Domino R5 Development Part 1 Basic Concepts Course Overview This is the first course in a nine part series for webmasters, application developers, and graphic designers that will introduce Notes/Domino features, web-specific tasks, and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course, students will learn how to identify basic  more...

Lotus Domino R5 Development Part 2 Application Devel Fundamentals Course Overview This is the second course in a nine part series for webmasters, application developers, and graphic designers that will introduce Notes/Domino features, web-specific tasks, and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course, students will learn how to create a database in  more...

MS Office 2003 New Features for Office Users This first course will give current users of Office an overview of the key new features and capabilities of Office 2003. In addition to a broad overview of new capabilities, it specifically focuses on the use of XML as a native file format in Word, Excel, and Access, as well as on the greatly enhanced Outlook interface. Learn To To identify features of the Reading  more...

Lotus Domino R5 Development Part 5 Adv Application Development Course Overview This is the fifth course in a nine part series for webmasters, application developers, and graphic designers that will introduce Notes/Domino features, web-specific tasks, and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course, students will learn how to identify the functions  more...

Lotus Domino R5 Development Part 6 Developing Applications for Web Clients Course Overview This is the sixth course in a nine part series for webmasters, application developers, and graphic designers that will introduce Notes/Domino features, web-specific tasks, and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course, students will learn how to identify the features  more...

Lotus Domino R5 Development Part 7 Developing Applications for the Notes R5 Course Overview This is the seventh course in a nine part series for webmasters, application developers, and graphic designers that will introduce Notes/Domino features, web-specific tasks, and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course, students will learn how to identify the uses of  more...

Lotus Domino R5 Development Part 9 Web Site Design Course Overview This is the final course in a nine part series for webmasters, application developers, and graphic designers that will introduce Notes/Domino features, web-specific tasks, and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course, students will learn how to identify the  more...

Lotus Domino R5 System Admin Part 1 Planning a Notes Domino Infrastructure Course Overview This is the first course in a ten part series for system administrators who are responsible for Domino server and Notes client. At the completion of this course, students will learn how to identify the concepts related to the planning of a Notes/Domino infrastructure; and identify the concepts related to protocols, remote access connections and standard database views in Domino.  more...

Windows NT Server 4 0 Implementing Directory Services Course Overview This is the first course in a seven-part series intended for network support professionals working in a Microsoft Windows NT Server 4.0 based enterprise environment. The series aims to enable these professionals to pass Microsoft's certification examination 70-68. This series enables participants to design, implement, and support the Windows NT Server network operating system  more...

Windows NT Server 4 0 Installation Configuration - Part 2 Course Overview This is the final course in a seven-part series intended for network support professionals working in a Microsoft Windows NT Server 4.0 based enterprise environment. The series aims to enable these professionals to pass Microsoft's certification examination 70-68. This series gives participants the opportunity to design, implement, and support the Windows NT Server network  more...

Windows 2000 Network Infrastructure Admin --Part 1 DHCP DNS WINS Course Overview This is the first course in a five-part series that will provide IT professionals with the knowledge and skills necessary to install, manage, monitor, configure, and troubleshoot DNS, DHCP, Remote Access, Network Protocols, IP Routing, and WINS in a Windows 2000 network infrastructure. At the completion of this course, students will learn to identify DHCP concepts; identify  more...

Windows 2000 Network Infrastructure Admin --Part 1 DHCP DNS WINS Course Overview This is the first course in a five-part series that will provide IT professionals with the knowledge and skills necessary to install, manage, monitor, configure, and troubleshoot DNS, DHCP, Remote Access, Network Protocols, IP Routing, and WINS in a Windows 2000 network infrastructure. At the completion of this course, students will learn to identify DHCP concepts; identify  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...

IBM DB2 Universal Database V6 1--Administration Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement  more...

IBM DB2 Universal Database V6 1--Administration Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement  more...

ASP NET Part 2 ADO NET Partitioning Tracing Course Overview The is the second course in a three part series that provides the learner with instruction on using ADO.NET to access data, on separating code from content, and on using the ASP.NET trace feature. The course will cover using ADO.NET to access data from various data sources and allows the learner to practice displaying and customizing data display. The course then describes the  more...

CIW Application Developer CGI Using Perl Fundamentals Curriculum Course Overview This curriculum presents instruction on the foundations of CGI using the Perl language, how to get started with CGI and Perl, Perl fundamentals, and Perl input and output. Additionally, the curriculum will cover how to manage files and databases, and CGI security issues. This curriclum consists of two Skill Builder courses: Course 87051 CIW Fundamentals of CGI Using Perl Part 1:  more...

CIW Fundamentals of CGI Using Perl Part 1 CGI Perl Basics Course Overview This is the first course in a two part series that students will learn both theoretical and practical instruction on the foundations CGI using the Perl language. This course will also cover getting started with CGI and Perl, Perl fundamentals, and Perl input and output. Learn To • Sequence the steps in the application development process. • Identify guidelines  more...

CIW Fundamentals of CGI Using Perl Part 2 Advanced Features Course Overview This is the second course in a two part series that presents students with both theoretical and practical instruction on managing files and databases. This course will cover manipulating files, databases, and CGI security issues. Learn To • Identify the syntax used to save form data by using the param method. • Identify characteristics of the save method.  more...

CIW Database Specialist Part 2 Logical Physical Design This is the second course in a four part series that teaches students about normalization, and logical and physical database design. This course will cover the normalization about the first, second, and third normal forms, and also about Boyce-Codd Normal Form, logical database design resolving relationships, creating a logical data model, and the various integrity constraints, physical database  more...

CIW Server Administrator Part 4 Servers Course Overview This is the fourth course in a five part series that will teach students about various servers. This course will cover Web applications, Perl, gateways, and streaming Web servers. Additionally, students will learn about the installation and configuration of both E-Mail and News. Learn To • Match features of HyperText Transfer Protocol (HTTP) messages with their  more...

HTML 4 Part 1 HTML Fundamentals Course Overview This is the first course in a two part series that presents learners with the basic concepts and skills in HTML 4.01. The course covers World Wide Web basics, formatting web pages and creating links, images and multimedia, tables and frames, and placing information online. Learn To • Identify the concepts of HTML. • Create different types of lists. •  more...

Dir Database Int Using DirXML Part 3 Netscape Dir Server eDirectory The is the third course in a four part series that introduces the learner to Netscape Directory Server. It covers the setting up of and the working of the preconfigured Netscape/LDAP driver. Finally, it covers the concepts and customization of the eDirectory-to-eDirectory driver. Learn To: o Identify the features of a Netscape Directory tree. o Match Netscape Directory Server components with  more...

CCNT Basic Data Communications v6 0 Part 2 This course teaches students about networks and transmission principles. The networks section teaches about local area networks (LANs), wide-area networks (WANs), hierarchical WANs, and LAN components. This section also teaches about system network architecture (SNA), and TCP/IP. The Transmission Principles section teaches about data protocols, DTE to DCE interface standards, and transmission  more...

IMS Essentials Curriculum This curriculum introduces the IMS Database Manager and the IMS Transaction Manager (IMS TM). It also covers data entry databases (DEDBs) and expedited message handling (EMH). This curriculum consists of three Skill Builder courses: IMS Essentials Part 1: IMS Database Manager IMS Essentials Part 2: IMS Transaction Manager IMS Essentials Part 3: DEDBs, Advanced IMS Systems, and DB2 Learn  more...

IMS Essentials Part 1 IMS Database Manager In IMS Essentials Part 1: Database Manager, you are introduced to the IMS Database Manager. IMS hierarchical databases are covered, and the Data Language/I (DL/I) function codes used to query and update the databases within application programs. You are introduced to database change logging and the various database recovery utilities used in IMS. Finally, you learn about IMS hierarchic access  more...

IMS Essentials Part 2 IMS Transaction Manager In IBM IMS Essentials Part 2: Transaction Manager, you learn about IMS Transaction Manager (IMS TM). The architecture and messages in IMS TM are introduced. You learn about the security issues and about protecting system integrity in IMS. In the IMS Transaction Message Processing section, both message and application processing are explained. Finally, Multiple Systems Coupling (MSC) and  more...

IMS Essentials Part 3 DEDBs Advanced IMS Systems DB2 In IBM IMS Essentials Part 3: DEDBs, Advanced IMS Systems, and DB2, you learn about data entry databases (DEDBs) and expedited message handling (EMH). The Advanced IMS Systems section introduces DBCTL and the concept of data sharing in IMS. The Common Service Layer (CSL) architecture is explained. Finally, the relationship between IMS and DB2 is explained, including the IMS to DB2 attachment. This  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  more...

Oracle Database 10g PL SQL Fundamentals Part 3 In this course, the learner will get familiar with the procedural language to access Oracle database. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. The student will also learn about the compilation tools and their options. Learn To: Match the stages in the execution of SQL statements  more...