Online Database Using Pl eLearning

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

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

Monitoring and Diagnosing Database Problems in SQL Server 2005 Monitoring and Diagnosing Database Problems in SQL Server 2005 Microsoft To monitor and resolve database blocks, and connect to the server using a dedicated administrator connection (DAC)  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...

Oracle Database 11g Using DML DDL Cursors Control Structures and Loops Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops Oracle To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.  more...

Oracle Database 11g Using Data Types INDEX BY Tables and Cursors in PL SQL Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL Oracle To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.  more...

Oracle Database 11g Managing Data in Different Time Zones Oracle Database 11g: Managing Data in Different Time Zones Oracle To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.  more...

Oracle Database 10g Using Flashback Oracle Database 10g: Using Flashback Oracle To recognize Oracle 10g's Flashback technology and use Flashback features  more...

Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g Oracle To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases  more...

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

Using Control Structures Using Control Structures Oracle To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct  more...

Using Composite Data Types Using Composite Data Types Oracle To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records  more...

Explicit Cursors and Exception Errors Explicit Cursors and Exception Errors Oracle To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled  more...

Oracle Database 11g Using Dynamic SQL and Implementing Performance Improvements Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements Oracle To recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL, language enhancements, and a variety of performance enhancements  more...

Oracle Database 11g Using Trigger Data Warehousing and Pivoting Enhancements Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements Oracle To recognize the steps for improving performance, managing scalabilty, enhancing control and processing speed, and reducing network load using enhanced features such as compound triggers, SecureFile LOBs, and PIVOT operations  more...

Oracle Database 11g Using the PL SQL Debugger Collections and Data Warehousin Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousin Oracle To recognize ways to utilize the PL/SQL Debugger to analyze your code, identify the uses and benefits of collections, and identify the steps for employing data warehousing enhancements to improve query execution times.  more...

Oracle Database 11g Using SQL to Query Your Database Oracle Database 11g: Using SQL to Query Your Database Oracle To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.  more...

Oracle Database 11g Subqueries Set Operators and Data Manipulation Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation Oracle To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.  more...

Oracle Database 11g Using DDL Views Sequences Indexes and Synonyms Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms Oracle To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.  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...

Using XML Using XML Microsoft recognize how to use, implement, retrieve and manipulate XML data in SQL Server 2005 using XQuery language  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...

Oracle Database 11g R2 Database Architecture Recovery Operations Oracle Database 11g R2: Database Architecture & Recovery Operations Oracle An important aspect of Oracle Database administration is to understand how a database and its major components function. Also as an Oracle Database administrator, you need to be able to recover when problems occur in the database. This is accomplished using backups, which are used to protect against problems such as  more...

Oracle Database 11g R2 Managing Database Space Duplication Oracle Database 11g R2: Managing Database Space & Duplication Oracle To effectively manage space, you can configure automatic management by the Oracle database server. This allows you to generate alerts about potential problems and recommend possible solutions. This course explores how to use the Oracle database server for automatic space management, proactively monitor and manage tablespace  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...

Oracle Database 11g R2 Managing Database Memory Performance Oracle Database 11g R2: Managing Database Memory & Performance Oracle Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which  more...

Oracle Database 11g R2 Database Diagnostics Flashsback Technologies Oracle Database 11g R2: Database Diagnostics & Flashsback Technologies Oracle Administering an Oracle database requires monitoring and diagnosing data failures and recovering from them. Oracle Database 11g Release 2 provides the Data Recovery Advisor which eases this task by automatically detecting errors when they occur and providing repair advice. The use of the Automatic Diagnostic  more...

Oracle Database 11g R2 Using Monitoring Tuning RMAN Oracle Database 11g R2: Using, Monitoring & Tuning RMAN Oracle Reconstructing the contents of all or part of a database from a backup typically involves two phases. The first phase is the retrieval of a copy of the data file from the backups. The second involves reapplying changes to the file that occurred since the backup, using archived and online redo logs. To effectively administer an  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...

Data Management Localization Encryption in Linux Data Management, Localization, & Encryption in Linux CompTIA CompTIA Linux Powered by LPI LX0-102 CompTIA Linux The Linux environment is capable of supporting many simultaneous users and processes. This course will discuss the use of basic database SQL commands, the internationalization, and localization of the Linux environment, and Linux data security using GnuPG and OpenSSH. This course  more...

Cisco Route 1 0 Implementing an OSPF-Based Solution Cisco Route 1.0: Implementing an OSPF-Based Solution Cisco Cisco Certified Design Professional (CCDP ) 642-902 Implementing Cisco IP Routing (ROUTE) v1.0 Configuring Open Shortest Path First (OSPF) in today's networks is an important skill to have as a network administrator. You will need to understand the primary configuration commands for single-area and multiarea OSPF designs, and the  more...

Data Management Localization Encryption in Linux Data Management, Localization & Encryption in Linux Linux Professional Institute LPI: Junior Level Linux Professional Exam 102: Junior Level Linux Professional (LPIC-1) The Linux environment is capable of supporting many simultaneous users and processes. This course will discuss the use of basic database SQL commands, the internationalization, and localization of the Linux environment, and  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...

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

Data Integration With VB 2008 Data Integration With VB 2008 Microsoft Visual Studio 2008 and the .NET Framework 3.5 allow developers to data-bind Windows Forms elements and create a database-connected Windows Forms applications. This course explores how to integrate data capabilities into Windows Forms. Topics in this course cover database connections, using LINQ in Windows Forms, using data-bound controls, connection  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 Management SQL Server 2008: Database Management Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) Database maintenance is an ongoing task for SQL Server 2008 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks  more...

SQL Server 2008 Data Management SQL Server 2008: Data Management Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) SQL Server 2008 provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may need to  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...

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

Querying Managing XML Data inSQL Server 2008 Querying & Managing XML Data inSQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) XML has been integrated into SQL Server 2008 so that XML data can be stored within databases using the XML data type. You can query this data using the XQuery language within the XML data type methods. SQL Server 2008 also provides support for  more...

Using SQL Server 2008 Messaging Full-Text Search Scripts Track Changes Using SQL Server 2008 Messaging, Full-Text Search, Scripts & Track Changes Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) SQL Server 2008 provides many components to ensure that database developers can perform many tasks within the database without having to create custom applications. SQL Server's Service Broker component allows  more...

Gathering Performance Data in SQL Server 2008 Gathering Performance Data in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) In order to keep SQL Server 2008 running as efficiently as possible, SQL Server 2008 provides a variety of performance tuning and optimization utilities. Among these utilities are the SQL Server Profiler and the Database Engine Tuning Advisor.  more...

Deploying SQL Server 2008 Integration Services Package Deploying SQL Server 2008 Integration Services Package Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) This course discusses the deployment and execution of SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server. This course gives an  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...

Managing SSIS Packages in SQL Server 2008 Managing SSIS Packages in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) This course discusses managing SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server and then managed by administrator and users. This course  more...

Oracle Database 11g Packages Dynamic SQL Coding Considerations in PL SQL Oracle Database 11g: Packages, Dynamic SQL & Coding Considerations in PL/SQL Oracle To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.  more...

Oracle Database 11g Using Triggers the PL SQL Compiler Managing Code Oracle Database 11g: Using Triggers, the PL/SQL Compiler & Managing Code Oracle To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.  more...

Oracle Database 11g Querying a Database with SQL Oracle Database 11g: Querying a Database with SQL Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.  more...

Oracle Database 11g Manipulating Queries Data Oracle Database 11g: Manipulating Queries & Data Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.  more...

Oracle Database 11g Using DDL Views Schema Objects Oracle Database 11g: Using DDL, Views & Schema Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.  more...

Oracle Database 11g Managing Time Zones Datetime Functions Oracle Database 11g: Managing Time Zones & Datetime Functions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.  more...

Oracle Database 11g Suqueries Regular Expressions Oracle Database 11g: Suqueries & Regular Expressions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.  more...

Oracle Database 11g Using DML DDL Cursors Loops Control Structures Oracle Database 11g: Using DML, DDL, Cursors, Loops & Control Structures Oracle To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.  more...

Oracle Database 11g Using Data Types INDEX BY Tables Cursors Oracle Database 11g: Using Data Types, INDEX BY Tables & Cursors Oracle To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.  more...

Oracle Database 11g Using Exceptions Subprograms JDeveloper REF Cursors Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper & REF Cursors Oracle To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.  more...

Oracle Database 11g Packages Dynamic SQL Coding Considerations Oracle Database 11g: Packages, Dynamic SQL & Coding Considerations Oracle To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.  more...

Oracle Database 11g Using Triggers the PL SQL Compiler Oracle Database 11g: Using Triggers & the PL/SQL Compiler Oracle To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.  more...

Oracle Database 11g Performance Tuning Methodology Tools Oracle Database 11g: Performance Tuning Methodology & Tools Oracle Oracle Database 11g provides a variety of tools that can be used for performance tuning in an Oracle database environment. These tools can be used to diagnose and tune common SQL-related and instance-related problems as well as proactively tune an Oracle database. One such tool, Enterprise Manager, can be used to monitor an  more...

Oracle Database 11g Using AWR Defining Problems Oracle Database 11g: Using AWR & Defining Problems Oracle Automatic Workload Repository (AWR) is the infrastructure that provides services to Oracle Database 11g components that collect, maintain, and utilize statistics for problem detection and self-tuning purposes. This course explains how to create and manage AWR snapshots, and demonstrates how to use the snapshots to generate individual  more...

Oracle Database 11g Metrics Alerts Baselines AWR Tools Services Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools & Services Oracle Metrics, alerts, baselines, and thresholds are monitoring objects that can be used to monitor and manage the performance tuning of an Oracle Database 11g environment. Automatic Workload Repository (AWR) based tools can be used to tune automatic maintenance tasks and generate and read ADDM and ASH reports. This  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 SQL Performance Database Replay Oracle Database 11g: SQL Performance & Database Replay Oracle Database Replay allows you to test the impact of a system change by replaying a real-world workload on a test system before it is exposed to a production system. This course demonstrates how to use Database Replay to capture and replay workloads to test the impact of a system change. It also explains how to use SQL Performance  more...

Oracle Database11g Shared Pool Buffer Cache Tuning Oracle Database11g: Shared Pool & Buffer Cache Tuning Oracle The buffer cache is an extremely important component for the performance, scalability, and reliability of the database. This course demonstrates how to identify the symptoms that indicate a buffer cache problem and how to use the various methods available to resolve common performance issues related to the buffer cache. It also  more...

Oracle Database 11g Tuning PGA Temporary Space AMM Oracle Database 11g: Tuning PGA, Temporary Space & AMM Oracle Oracle Database 11g provides various methods for tuning, monitoring and managing memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data  more...

Oracle Database 11g Segment Space I O and Performance Tuning Oracle Database 11g: Segment Space, I/O and Performance Tuning Oracle Oracle Database 11g provides various methods for tuning segment space usage and input/output (I/O). This course explains how to use Automatic Segment Space Management (ASSM) to tune segment space usage, how to shrink segments using SQL or the Enterprise Manager, and how to use table compression. Automatic Storage  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 Execution Plans and Star Transformations Oracle Database 11g: Execution Plans and Star Transformations Oracle An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting  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 Configuring OSB Security Oracle Database 11g: Configuring OSB & Security Oracle Oracle Secure Backup or OSB is centralized tape-management software that allows you to backup and restore data using a variety of machine architectures. This course covers how OSB complements the Oracle backup and recovery options, as well as terminology, interface options, and backup management features. Additionally, it explores how to  more...

Oracle Database 11g RMAN and Oracle Secure Backup Oracle Database 11g: RMAN and Oracle Secure Backup Oracle RMAN manages the disk space in the Flash Recovery Area, and by putting RMAN in control of your backup and restore operations, you simplify your availability-related processes. This course describes integrated disk and tape backup, how to register the administrative server in Enterprise Manager, checking RMAN backup and recovery  more...

Oracle Database 11g Managing Backups Infrastructure Oracle Database 11g: Managing Backups & Infrastructure Oracle Restoring files is easily accomplished using the Oracle Secure Backup catalog. This course demonstrates how to browse the catalog for file-system backup data, create catalog-based restore requests, and perform file-system restoration. In addition, this course explores the Oracle Secure Backup processes, configuring defaults and  more...

Oracle Dabase 11g Tape Vaulting Duplication Tuning Oracle Dabase 11g: Tape Vaulting, Duplication & Tuning Oracle Oracle Secure Backup uses a volume rotation policy to track a backup volume as it moves from its originating location to a storage location and is eventually recycled. This process is known as vaulting. This course covers configuring and using tape vaulting and a tape vaulting environment, viewing tape rotation reports, and  more...

Oracle Database 11g RAC Performance Tuning Oracle Database 11g: RAC Performance Tuning Oracle Performance Tuning uses diagnostic tools to gather statistics, statistic rates, and sampled statistics in order to tune the database system to provide the best performance as efficiently as possible. Although there are specific tuning areas for Oracle Database 11g: RAC, such as instance recovery and interconnect traffic, you will get the  more...

Oracle Database 11g Configure Manage Use Services in RAC Oracle Database 11g: Configure, Manage & Use Services in RAC Oracle A service is a grouping of related tasks within a database with common functionality, quality expectations, and priority relative to other services. It provides a single-system image for managing competing applications running within a single instance and across multiple instances and databases. Using standard interfaces,  more...

Oracle Database 11g Diagnosing Oracle Clusterware Node Management Oracle Database 11g: Diagnosing Oracle Clusterware & Node Management Oracle Problems that occur with Oracle RAC instances can be difficult to diagnose because they span across two or more nodes in a cluster. Oracle Database 11g provides various methods for diagnosing and debugging Oracle Clusterware and RAC components. This course discusses the basics of debugging and the use of diagnostics  more...

Oracle Database 11g High Availability Oracle Database 11g: High Availability Oracle In Oracle Database 11g, RAC and Data Guard together provide the benefits of system-level, site-level, and data-level protection, resulting in high levels of availability and disaster recovery without loss of data. This course explains how to configure connections for high availability using various types of workload distribution and load  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 Privileges Roles Application Contexts Oracle Database 11g: Privileges, Roles & Application Contexts Oracle Authorization is the process that determines the privileges that the user is allowed to exercise. In the Oracle database, authorization is determined by the grant of system and object privileges. This course covers implementing roles, enterprise roles, and the securing of objects through procedures. It also describes how  more...

Oracle Database 11g Encryption Concepts Oracle Database 11g: Encryption Concepts Oracle All encryption has two parts: an algorithm, which is a procedure or a method of manipulating data, and a key or a secret that allows data to be decrypted. This course discusses the issues and challenges of encryption and describes key management solutions. It also describes the encryption options available with Oracle Database 11g. Using  more...

Oracle Database 11g Transparent Data Encryption Oracle Database 11g: Transparent Data Encryption Oracle Transparent Data Encryption (TDE) is available with Oracle Advanced Security (ASO) and provides easy-to-use protection for your data without requiring changes to your applications. This course demonstrates how to set up the database master encryption key and implement TDE. It also explores how to encrypt column and tablespace data.  more...

Oracle Database 11g R2 Installation Oracle Restart Oracle Database 11g R2: Installation & Oracle Restart Oracle Oracle Database 11g Release 2 offers a unique scale-out technology with a single database instance, lower server and storage costs, and increased availability and scalability. It also provides customers with improved user service levels, reduced down-time, and more efficient use of IT resources as well as an increased level of  more...

Oracle Database 11g R2 Using Change Management Solutions Oracle Database 11g R2: Using Change Management Solutions Oracle Oracle Database 11g Release 2 is designed for data center environments that are rapidly evolving and changing to keep up with business demands, enabling DBAs to manage change effectively and efficiently. Oracle Database 11g Release 2 offers significant advances in the areas of automatic diagnostics, supportability, and change  more...

Oracle Database 11g R2 Intelligent Infrastructure Enhancements Oracle Database 11g R2: Intelligent Infrastructure Enhancements Oracle Oracle Database 11g Release 2 offers new intelligent infrastructure features to aid DBAs by automatically gathering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded  more...

Oracle Database 11g R2 Diagnosability Enhancements Oracle Database 11g R2: Diagnosability Enhancements Oracle Oracle Database 11g Release 2 offers new diagnosability enhancements to help DBAs in diagnosing, resolving, and preventing problems. These new features include enhancements to problem and incident identification, running health checks, and performing repairs on SQL statements. These features enables the DBA to quickly and efficiently  more...

Oracle Database 11g R2 SQL Monitoring Performance Enhancements Oracle Database 11g R2: SQL Monitoring & Performance Enhancements Oracle Oracle Database 11g Release 2 offers improvements and new features to provide DBAs a better way to monitor SQL commands in real-time and to allow the database to automatically manage its own memory and gather optimizer statistics. These features enable the DBA to ensure the optimal memory sizes are being used for the  more...

Oracle Database 11g R2 Application Performance Enhancements Oracle Database 11g R2: Application Performance Enhancements Oracle Oracle Database 11g Release 2 offers improved and new features to provide better application performance. It offers online table redefinition, which allows tables to be modified without affecting the availability of the table to users and does not affect any of its dependencies. This allows for easier application changes and  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 Database Architecture Installation Oracle Database 11g R2: Database Architecture & Installation Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 To understand how an Oracle Database functions, it is important to gain a basic understanding of its major components. This course identifies the major architectural components of the Oracle Database 11g  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...

Oracle Database 11g R2 Managing Concurrency Undo Auditing Oracle Database 11g R2: Managing Concurrency, Undo & Auditing Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 Oracle Database 11g Release 2 is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented  more...

Oracle Database 11g R2 Backup Recovery Oracle Database 11g R2: Backup & Recovery Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 Preparing for and performing data recovery and completing database backups are expected job duties of an Oracle Database 11g Database Administrator (DBA) to ensure that the database is available for users when they require it.  more...

Oracle Database 11g R2 Moving Data Oracle Support Oracle Database 11g R2: Moving Data & Oracle Support Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 From time to time Oracle DBAs are required to move data. Oracle Database 11g Release 2 offers various ways to complete this task, including Oracle Data Pump, SQL*Loader, and the use of external tables. DBAs are also  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...

Beginning Active Server Pages Learn to program using Microsofta ™s latest technology, ASP.  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 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...

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

Windows 2000 Level 1 This course introduces students to the basic features in Microsoft Windows 2000 by walking them through the end-user necessary skills like using the mouse, working on the Desktop, using windows, and operating the Start menu and Taskbar. This course introduces students to the basic features in Microsoft Windows 2000. Students will learn end-user necessary skills like using the mouse, working on  more...

Windows 98 Level 1 This introductory course will teach students how to use the basic features of Microsoft Windows 98. The course includes lessons on customizing the Desktop using Web content, screen savers, and Desktop themes. Students will also gain un understanding of the file system, including how to use Windows Explorer.  more...

Windows 98 New Features This course will introduce students to the new features found in Windows 98, including Internet-related features. Creating a Web page using FrontPage Express and using the Online Help option are just two of the specific topics that will be covered.  more...

Advanced Active Server Pages Learn to program using Microsofta ™s latest technology, ASP. PREREQUISITE: Beginning Active Server Pages  more...

SQL Server 2000 Implementing and Designing Databases This course teaches you to design, implement, administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000. This course prepares you to design and implement database solutions by using Microsoft SQL Server 2000. This course covers subjects such as: Developing a Logical Data Model, Implementing the Physical Database, Retrieving and Modifying Data, Programming  more...

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

Crystal Reports 8 This self-paced interactive course will give the student in-depth knowledge of Crystal Reports 8 and all of its functionality. One of the greatest challenges in working with data and databases is creating useful, effective, and efficient reports that people will use to enhance the business capabilities of their companies. Upon completion of this course, the student will be able to quickly create  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...

Web Development Fundamentals To outline web-page develpment using HTML and to introduce scripting and database management and connection techniques  more...

Web Development Fundamentals To outline web-page develpment using HTML and to introduce scripting and database management and connection techniques  more...

Web Development Fundamentals To outline web-page develpment using HTML and to introduce scripting and database management and connection techniques  more...

Web Development Fundamentals To outline web-page develpment using HTML and to introduce scripting and database management and connection techniques  more...

Web Development Fundamentals To outline web-page develpment using HTML and to introduce scripting and database management and connection techniques  more...

Web Development Fundamentals To outline web-page develpment using HTML and to introduce scripting and database management and connection techniques  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...

Manipulating Data with DB2 UDB To execute queries using SQL  more...

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

Using Flashback Technology in Oracle 10g To outline the considerations and procedures for using Flashback features  more...

Performing and Managing Backups in Oracle 10g To outline the processes and considerations for using RMAN to perform and monitor backups  more...

Using Globalization Support in Oracle 10g To outline the considerations and procedures for globalizing a database  more...

Optimizing Database Performance in Oracle 10g To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors  more...

Managing Storage and System Resources in Oracle 10g To outline the processes and considerations for using the Automatic Storage Management and Database Resource Manager features  more...

Using the Scheduler to Automate Tasks in Oracle 10g To outline the processes and considerations for using the Scheduler tool  more...

Using Advanced Features in Oracle 10g To outline the processes and considerations for using the advanced features of Oracle Database 10g  more...

Oracle Database 11g Storage Enhancements recognize ways in which storage has been enhanced in Oracle Database 11g using Automatic Storage Management's (ASM's) commands and extensions.  more...

Oracle Database 11g Intelligent Infrastructure Enhancements Identify how to to monitor performance, automate maintenance, calibrate and manage resources, and streamline job scheduling using Oracle Database 11g's intelligent infrastructure enhancements.  more...

Oracle Database 11g Using RMAN Enhancements Flashback and LogMiner identify ways of using Oracle Database 11g's enhanced RMAN, Flashback and LogMiner tools to clone databases, create backups and catalogs, archive historical data, and roll back transactions.  more...

Oracle Database 11g Diagnostic Enhancements and Using the Data Recovery Advisor recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic Repository, Support Workbench, SQL Repair Advisor, and the Data Recovery Advisor.  more...

Oracle Database 11g Database Architecture and ASM To recognize the structural elements in Oracle Database 11g's architecture, including and Automatic Storage Management (ASM), and recognize the steps for managing storage using disk groups.  more...

Oracle Database 11g Configuring for Recovery To recognize the steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g, using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog.  more...

Oracle Database 11g Configuring for Backups To identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them using reports and dynamic performance views, and also for performing user-managed backups and recoveries.  more...

Oracle Database 11g Using RMAN for Recovery To identify ways to use RMAN to ensure that data is not lost in Oracle Database 11g, by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time.  more...

Oracle Database 11g Supporting RMAN and Using Flashback Technology To recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks, and also for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g's flashback features.  more...

Oracle Database 11g Diagnosing the Database and Managing Memory To identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and also for enabling and configuring automatic memory management and automatic shared memory management.  more...

Oracle Database 11g Managing Resources and Task Automation To identify ways to ensure that resources are being put to best use and database jobs are performed when they should be, using the Database Resource Manager and the Scheduler.  more...

Microsoft Visio 2003 Expert User This course focuses on the advanced features in Microsoft Visio 2003. This will help the learners create specialized diagrams by using different shapes and wizards provided by Visio 2003. Learn To: Identify drawing operations that you can perform to create new shapes from existing shapes in a Microsoft Visio 2003 drawing. Assign a shape to a new layer in Microsoft Visio 2003.  more...

Visual InterDev 6 0 Planning a Web Application C ourse Overview This is the first 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 plan a Web site; analyze the planning guidelines and the performance and maintenance factors that need to be  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 3 C ourse Overview This is the third 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 help participants learn Novell Network Backup and Restoration procedures, and how to use Domain Name System (DNS)/Dynamic Host Configuration  more...

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

Crystal Reports v10 Introduction to Report Design Part 3 This course is the last in a three-part series that focuses on the basics of reporting using Crystal Reports v10. This course covers various ways of manipulating report data. In Crystal Reports, various features such as formulas, parameter fields, charts, and report alerts can be used to make reports easy-to-understand, interactive, and visually appealing. This course also introduces the learner  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 Messaging and Working Remotely 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 send messages and attachments; receive and reply to messages; organize and customize messages; and create local replicas, replicate mail and set up a machine for replication. L earn To: Send  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 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...

Oracle Database 10g SQL Fundamentals I Part 1 In this course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features. Learn To: Match the different phases of system development life cycle (SDLC) with their features. Identify features of an Entity Relationship  more...

Oracle Database 10g Administration Workshop II Part 2 This course will teach learners to use RMAN and explain the various RMAN commands. Diagnostic sources, non-critical recovery, and incomplete recovery concepts are also covered in this course. Learners will also learn how to perform incomplete recovery. Learn To: Match various RMAN commands with their features. Distinguish between the methods for issuing RMAN commands. Identify  more...

Oracle Database Administration Workshop I Part 2 Oracle Database 10g is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage enterprise information. This course covers salient aspects of Oracle Database 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and schemas has been discussed  more...

Introduction to PCs and Software This course provides the learner with comprehensive foundational knowledge of PCs, working with Microsoft Windows, Microsoft application software, and using the Internet and E-mail. The course covers an introduction to the PC, benefits, components, hardware and software, input and output devices, storage, and general maintenance. Working with Microsoft Windows XP, opening and closing applications,  more...

SAP R 3 System Management Advanced Administration CCMS 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. Subjects such as software logistics and the CCMS are discussed. L earn To: The Basis System for Advanced Users. Software Logistics. TMS.  more...

Introduction to E-Commerce This course provides the learner with an overview of the state of e-commerce today. It defines electronic commerce and discusses electronic commerce elements. An overview of business-to-consumer and business-to-business electronic commerce is given. This course also addresses issues and technologies available for companies wishing to engage in e-commerce. Learn To: Introduction to  more...

Lotus Notes R5 Messaging and Working Remotely 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 send messages and attachments; receive and reply to messages; organize and customize messages; and create local replicas, replicate mail and set up a machine for replication. L earn To: Send  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...

Data Modeling - Create Basic Models Course Overview This is the first course in a two-part series which covers Data Modeling. You will begin by learning a top-down, systematic approach to database development using entity-relationship models and normalization. Then you will use this approach to identify and define business information requirements both in the course and within your work environment. This course can be used as  more...

Data Modeling - Develop Depth to Your Models Course Overview This is the second course in a two-part series which covers Data Modeling. You will begin by learning a top-down, systematic approach to database development using entity-relationship models and normalization. Then you will use this approach to identify and define business information requirements both in the course and within your work environment. This course can be used as  more...

Process and Function Modeling Course Overview Participants learn how to systematically describe the work performed by an organization using the Process Model. The process modeling technique is used to model the functional requirements of business, and should be used in conjunction with information modeling. This course can be used as part of an integrated Oracle curriculum and to supplement many of Oracle's Designer/2000  more...

Object Analysis Design Requirements Analysis Course Overview This is the first title in a series of two, and covers the same material as the first half of the Instructor Led course Object Oriented Analysis and Design Using UML. This course teaches students the principles and terminology of object oriented development, and how to apply object oriented techniques to define systems using the notation of the Unified Modeling Language (UML).  more...

Object Analysis Design Design Implementation Course Overview This is the second title in a series of two, and covers the same material as the second half of the Instructor Led course Object Oriented Analysis and Design Using UML. This course teaches students the principles and terminology of object oriented development. It follows on from the first title in the series Object Analysis and Design: Requirements and Analysis and teaches the  more...

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

Oracle SQL 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 and SQL Plus Advanced SELECT Statements Course Overview This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition, this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries. L earn To: Write  more...

Oracle SQL and SQL Plus SQL Plus and Reporting Course Overview This is the second course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output. L earn To: Identify the fundamental concepts of SQL*Plus and write queries  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 Forms Fundamentals Course Overview This course is the first in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features, components, and capabilities of Developer/2000. In addition, this course will help participants learn how to run, create, and customize a form module. L earn To: Identify the key features,  more...

Oracle Form Builder Enhancing the User Interface Course Overview This course is the second in a six-part Oracle Form Builder series based on Oracle Developer/2000 Release 2. This course helps participants learn how to create input and non-input items, and support text items with Lists of Values (LOVs) and editors. Additionally, users will learn to create triggers and add functionality to them. L earn To: Create input and  more...

Oracle Form Builder Writing and Debugging Code Course Overview This course is the third in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course will help participants learn to create and control alerts, debug PL/SQL code, and process queries. In addition, transaction processing, Form Builder application customization, and writing flexible code will be covered. L earn To: Identify  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 Handling Multiple Object Relationships Course Overview This course is the fifth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants to learn about Key triggers, write applications that respond to mouse events, manage windows and canvases, and use Object Navigator. In addition, users will work with multiple form applications, record groups, and list items. L  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...

Oracle Report Builder Report Fundamentals Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features of Report Builder, building a standard tabular report, and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate report  more...

Oracle Report Builder Enhancing Reports Course Overview This course is the second in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the ways to enhance a report using the Data and Layout Model. In addition, this course will help participants learn how to modify layout objects and enhance matrix reports. L earn To: Enhance a report using the  more...

Oracle Report Builder Controlling Reports Course Overview This course is the third in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course helps participants learn how to develop report templates, code PL/SQL triggers in a report, and use Report Builder's built-in package. Finally, building reports for different environments will be covered. L earn To: Identify the regions of  more...

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

Oracle8 Database Administration - Create Databases Course Overview This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn To:  more...

Oracle8 Database Administration - Manage Storage Structures Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To:  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 Forms Fundamentals Course Overview This course is the first in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course introduces the learner to the key features, components, and capabilities of Oracle Developer. In addition, this course helps learners to run, create, and customize a form module. L earn To: Identify the key features, components and capabilities of  more...

Oracle Form Builder R6 Enhancing the User Interface Course Overview This course is the second in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes how to create input and non-input items, how to create lists of values (LOVs) and editors to support text items, and how to create forms using multiple windows and a variety of canvas styles. Additionally, this course covers ways to add functionality to  more...

Oracle Form Builder R6 Writing and Debugging Code Course Overview This course is the third in a six-part Oracle Developer series that is based on Oracle Developer Release 6. In this course learners will create and control alerts, debug PL/SQL code, and process queries in form modules. In addition, the course will cover transaction processing, Form Builder application customization, and writing flexible code. L earn To: Identify the  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...

Oracle Form Builder R6 Controlling the User Interface Programmatically Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. L earn To:  more...

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

Oracle Reports R6 Report Fundamentals Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Reports Release 6. This course introduces the learner to, the key features of Report Builder, steps involved in building a standard tabular report and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate  more...

Oracle Reports R6 Enhance Reports Course Overview This course is the second in a three-part Oracle Reports series that is based on Oracle Reports Release 6. The goal of this course is to enable developers to construct complex reports and charts using Oracle Reports. This course introduces the learner to the key features of the Data Model editor, Layout Model objects and their properties. The course also enables the learner to  more...

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

Programming XML Using XML This course firstly provides a general overview of how to generate XML documents from Java objects. It introduces Java programming with XSL Transforamtions (XSLT). It covers architectural implications of incorporating XML into business applications. Lastly, this course shows how to use the DB2 XML Extender to import and export XML from a DB2 database. Learn To 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...

TCP IP Internetworking on Microsoft Windows NT 4 0 - Part 3 Course Overview This is the third course in a four part series for IT professionals who intend to set up, configure, use and support TCP/IP on Microsoft Windows NT 4.0. The series aims to enable the professionals to pass Microsoft exam 70-59, Internetworking Microsoft TCP/IP on Microsoft Windows NT 4.0. L earn To: Administer a WINS environment by configuring database replication  more...

Excel 2000 Expert User Course Overview This course provides participants the knowledge to use the advanced features of Microsoft Excel 2000. At the completion of this course, students will learn how to create and use templates; retrieve, sort and manipulate data from a list; create and modify shared workbooks; and analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools. L earn To:  more...

SQL Server 7 0 System Administration - Part 5 Course Overview This is the final course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the methods and attributes of SQL Server 7.0 replication. Identify and apply techniques for planning and setting up SQL Server 7.0 replication. Identify the procedures  more...

SQL Server 7 0 - Implementing a Database - Part 1 Course Overview This is the first 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: Identify the components of SQL Server 7.0. Identify the characteristics of Transact-SQL and its processing. Perform the skills to construct and manage databases. C ontent Emphasis  more...

SQL Server 7 0 - Implementing a Database - Part 2 Course Overview This is the second course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Implement data integrity. Create and maintain indexes. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database  more...

SQL Server 7 0 System Administration - Part 1 Course Overview This is the first course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the main components of the SQL Server. Understand the properties of SQL Server Architecture, including the underlying technical details. Understand the components of  more...

SQL Server 7 0 System Administration - Part 2 Course Overview This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Work with Microsoft SQL Server is and Work with Microsoft SQL Server 7.0, its architecture, security, and database structure. Understand the basics of SQL Server databases and how  more...

SQL Server 7 0 System Administration - Part 4 Course Overview This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Automate SQL Server 7.0 administrative tasks. Identify and use the SQL Server 7.0 tools for transferring and transforming data. Identify and use the tools for monitoring and  more...

SQL Server 7 0 - Implementing a Database - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Query multiple tables using Transact-SQL statements. Retrieve and modify data using advanced query techniques. C ontent Emphasis Skills-Based A udience This course is designed for IT  more...

SQL Server 7 0 - Implementing a Database - Part 4 Course Overview This is the fourth course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Generate summary value and summary data as well as generate control break reports using aggregate functions. Define transactions and set transaction isolation levels. Identify the purpose and  more...

SQL Server 7 0 - Implementing a Database - Part 5 Course Overview This is the final course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Access data by using the Stored Procedure model. Access data using triggers. Set up a distributed environment to access, modify and manage remote data. C ontent Emphasis Skills-Based A  more...

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

Site Server 3 0 Implementation - Part 3 This is the final 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 identify the tasks and procedures associated with the Knowledge Manager; and identify the tools and procedures for analyzing Web site  more...

Visual InterDev 6 0 Planning a Web Application Course Overview This is the first 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 plan a Web site; analyze the planning guidelines and the performance and maintenance factors that need to be  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 2 Course Overview This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models;  more...

IIS 4 0 Creating Configuring a Web Server - Part 3 Course Overview This is the third course in a four part series that will provide students with the knowledge to support the various features of Microsoft Internet Information Server 4.0. Participants will gain an understanding of the product's architecture and perform the procedures to install, configure, and implement Internet Information Server. L earn To: Create and interpret  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...

Exchange Server 5 5 Concepts and Administration - Part 3 Course Overview This is the final course in a three part series that will provide IT professionals the knowledge to install, configure, administer and troubleshoot Microsoft Exchange Server 5.5 in single-site and multiple-site environments. L earn To: Identify public folder contents, create a public folder strategy, view and assign public folder permissions and set public folder  more...

Lotus Notes 6 Moving to IBM Lotus Notes 6 The first course introduces the Lotus Notes 6 environment and capabilities, and the basics of Notes navigation using bookmarks and other navigation tools. The learner is given instruction in the establishment of their mail environment, including such procedures as setting up a filing system for incoming messages, customizing outgoing messages, and managing the Address book. They are also given  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...

Windows 2000 Planning Implementing Active Directories - Part 1 Course Overview This is the first course in a four part series that will provide IT professionals with the knowledge and skills necessary to plan and implement Microsoft Windows 2000 Active Directory in an enterprise environment. At the completion of this course, students will learn to identify the key features and components of Active Directory; identify the physical structure and security  more...

Crystal Reports v10 Introduction to Report Design Part 1 This course is the first in a three-part series that focuses on the basics of reporting using Crystal Reports v10. This course introduces the user to Crystal Reports and its environment. It also covers the fundamentals of databases and the key concepts associated with relational databases. In this course, you will learn to plan, create, preview, save, and distribute reports. Learn To:  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 5 Advanced Notes Mail Routing Course Overview This is the fifth 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 contents of the different mail routing documents in a Domino directory; configure mailing options, such as forwarding address, messaging size, priorities and shared mail; and  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...

Lotus Notes R5 System Admin Part 10 Monitoring a Notes Domino Env Course Overview This is the final 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 monitor the statistics and events of Domino servers by using monitors, probes and event messages to ensure the integrity of the Domino system; monitor mail and database replication; and  more...

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

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

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