Online Enterprise eLearning - Training Resources

Electronic Commerce: Strategies Professional Level One of the most detailed courses available on the subject. This course covers several strategies related to building the small or full scale e-commerce enabled business enterprise.  more...

Java 2 -- Enterprise Java ... detail the elements of Java necessary to implement these enterprise features and functions as you program in the Java language. The first unit provides an overview of the JFC package and the Swing architecture. It explains the features of the Swing class and the Swing components. You will learn to differentiate between Swing and AWT components, and convert AWT-based programs to Swing  more...

Java 2 -- Advanced Enterprise Java ...ese features and functions as you program in the Advanced Enterprise Java language. The first unit explains the concept of Java Database Connectivity (JDBC). It covers the features and functions of JDBC and the differences between JDBC and ODBC. You will learn about the models supported by JDBC and the different types of JDBC drivers. You will also learn about the different interfaces in  more...

Visual Basic.NET This Visual Basic .NET course teaches you the standards and basics for the Microsoft .NET framework. Visual Basic.NET is a significant upgrade to Visual Basic and incorporates many new features and framework goals of the .Net architecture. Learning to manage these changes will allow VB developers to create enterprise applications for the .NET platform and to create more traditional VB  more...

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

Introduction to Customer Relationship Management-Part 1 ... Management or CRM. CRM has assumed a crucial role in the enterprise. According to a study conducted by the Aberdeen Group entitled "Customer Relationship Management: Year 2000 Edition" the CRM market will experience continuous growth from $8 billion in 1999 to more than $24 billion by 2003. This course will provide you with an overview of CRM, its components and relevance in a fast-paced  more...

Information Technology Infrastructure Library (ITIL) This eLearning course has been designed to offer a high level introduction to the concepts, terms, benefits, and relationships within the core IT Service Management processes and functions, according to the Information Technology Infrastructure Library (ITIL) best practice framework. ITIL is becoming the standard of choice for many organizations in terms of operating IT practice as well as  more...

Build a Powerful Branding Strategy--Instructor-Led ...keting a small neighborhood business or a major corporate enterprise. The manner in which you manage your brand will have a direct impact on your revenues. For consumer market companies, brands that are properly managed typically account for 50 to 80 percent of a business`s revenues. For industrial markets companies, brands that are responsibly managed usually account for 10 to 30 percent of a  more...

Build a Powerful Branding Strategy--Self-Directed ...keting a small neighborhood business or a major corporate enterprise. The manner in which you manage your brand will have a direct impact on your revenues. For consumer market companies, brands that are properly managed typically account for 50 to 80 percent of a business`s revenues. For industrial markets companies, brands that are responsibly managed usually account for 10 to 30 percent of a  more...

Advanced Customer Relationship Management -Part 2 ... Management or CRM. CRM has assumed a crucial role in the enterprise. According to a study conducted by the Aberdeen Group entitled "Customer Relationship Management: Year 2000 Edition" the CRM market will experience continuous growth from $8 billion in 1999 to more than $24 billion by 2003. This course will provide you with an overview of CRM, its components and relevance in a fast-paced  more...

J2EE Architecture To provide an overview of enterprise application design and development using the J2EE platform and its enabling technologies  more...

Developing Servlets To outline the relationship between JavaServer Pages (JSPs) and servlets, to describe how to create servlets, and to explain how they fit into the web tier of the J2EE platform  more...

Developing JSPs To outline the relationship between JavaServer Pages (JSPs) and servlets, to describe how to create JSPs, and to explain how they fit into the web tier of the J2EE platform  more...

Developing EJBs To describe the Enterprise JavaBean (EJB) component model and to explain how to create EJBs  more...

Persistence and Transactional Issues Affecting EJBs To describe how to implement container-managed persistence (CMP) for entity beans and to discuss how to use container-managed transactions (CMT) and the Java Transaction API (JTA) to control Enterprise JavaBean (EJB) transactions  more...

Java Database Connectivity To describe database connectivity issues in the context of the J2EE platform and to outline how to use the core and extension JDBC APIs  more...

RMI and the Java Message Service To introduce distributed technologies and provide an overview of RMI and the Java Message Service (JMS)  more...

CORBA and the Java IDL To introduce CORBA as a language-independent distribution technology specification and to describe how to use the Java IDL to create Java interfaces for CORBA-compliant systems  more...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Industry Overview Federal Government The Federal Government is the largest contractor and buyer of services and products in the U.S., spending over $200 billion annually. Regardless of what business you are in, chances are there is a government agency in need of your product or service. Winning a government contract can be challenging, and millions of dollars in potential contracts are lost to companies who do not understand  more...

Customer Relationship Management - Fundamentals of CRM Customer Relationship Management: Fundamentals of CRM introduces the student to the benefits of creating customer loyalty, developing a market intelligence enterprise, and incorporating customer relationship management into your company. The program also details the three steps a company can take to create customer loyalty, the four marketing tiers, the four types of CRM, and the four steps of the  more...

Setting up a Site and Adding Content in Dreamweaver CS3 Adobe Dreamweaver CS3 is a web site development authoring and editing tool, suitable for personal and enterprise development environments. This course explores the concepts of creating a new site in Dreamweaver CS3, including configuring site properties and application preferences, adding content, and manipulating text. A look at the major interface elements of Dreamweaver CS3, and how to  more...

Oracle Database 11g Recovering Moving and Enhancing the Oracle Database recognize ways to make use of Oracle Database 11g's tools for moving and recovering data, reporting on problems, and installing updates to enhance a database.  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 Database Performance and Space Management To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces.  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...

Oracle Database 11g Globalization To recognize the steps for utilizing Oracle Database 11g's globalization support features to ensure that information and data is displayed in a user's native language, and that territory and language-dependent conventions are adhered to.  more...

Oracle Database 11g Getting Started with SQL and PL SQL New Features To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies  more...

Oracle Database 11g Using Dynamic SQL and Implementing Performance Improvements 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 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 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 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 Conversion Functions Group Functions and Joins To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.  more...

Oracle Database 11g Subqueries Set Operators and Data Manipulation 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 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...

Introducing Oracle9i Database To introduce the components and architecture of Oracle9i, the application of Oracle9i, and migrating and upgrading to Oracle9i  more...

Manageability Enhancements in Oracle9i To describe the manageability enhancements of an Oracle9i database  more...

Availability Features in Oracle9i To explain how the new features of an Oracle9i database support the maximum availability of a database  more...

Scalability and Performance in Oracle9i To describe the scalability and performance enhancements available in an Oracle9i database  more...

Development Platform in Oracle9i To explain the Oracle9i database enhancements that support the Oracle9i database development platform  more...

Security Overview for Oracle9i Administrators To provide an overview of the security features in an Oracle9i database  more...

Introduction to Oracle and SQL in Oracle9i To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements  more...

SQL Functions in Oracle9i To describe how to use SQL functions for data retrieval  more...

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

Defining and Manipulating Data in Oracle9i To describe how to define database objects and manipulate the data stored within them in an Oracle9i database  more...

Performance Tuning Methodology and Tools in Oracle9i To describe the methods and goals of database tuning and the utilities and tools used to analyze and tune an Oracle9i database  more...

Tuning Memory Structures in Oracle9i To describe how to tune Oracle9i memory structures  more...

Tuning Database Structures in Oracle9i To describe how to tune components of an Oracle9i database  more...

Tuning Systems and Applications in Oracle9i To describe how to tune systems and applications in Oracle9i  more...

Oracle 11i E-Business Suite Introduction To identify the main features of 11i E-Business Suite, to perform key navigation tasks, to create a shared entity type, and to recognize the key business flows of 11i E-Business Suite  more...

Oracle 11i E-Business Suite Multi-Org To identify characteristics and key features of Multi-Org and to identify the considerations to make when implementing Multi-Org  more...

Oracle 11i E-Business Suite Flexfields To create value sets and to perform the tasks to define a structure for descriptive flexfields  more...

Oracle 11i E-Business Suite System Administration To identify ? and in some cases perform ? key system-administration tasks in 11i E-Business Suite  more...

Oracle 11i E-Business Suite Workflow Alerts and Daily Business Intelligence To identify the key features of the Oracle Workflow architecture, to create alerts in 11i E-Business Suite, to recognize the benefits and characteristics of Daily Business Intelligence (DBI) and, given a scenario, run a report in a DBI environment  more...

Oracle 11i Function Security and Data Security To create users and responsibilities, assign responsibilities, create data groups, create functions and menus, and perform key data-security tasks  more...

Oracle 11i Roles Delegated Administration Registration and Auditing To create roles, set up Delegated Administration, create registration processes for roles, run audit reports, monitor users, and enable the AuditTrail feature  more...

Oracle 11i Concurrent Elements To submit and manage requests, create request groups and request sets, and identify the concepts and tools associated with concurrency and concurrency administration  more...

Oracle 11i Profile Options DBA Duties and Printer Management To set and view profile options, perform some Application-DBA tasks, define printers, and print with the pasta.cfg file  more...

Oracle 11i Personalization of Forms and OA Framework Pages To personalize forms and Oracle Applications (OA) framework pages  more...

Oracle 11i Oracle Workflow To identify the components of Oracle Workflow and to recognize the mandatory the optional steps for configuring Oracle Workflow  more...

Oracle 11i System Monitoring and Troubleshooting in OAM To monitor and manage some of the system components of Oracle E-Business Suite, run some troubleshooting wizards, and use the Support Cart feature in Oracle Applications Manager (OAM)  more...

Oracle 11i Using the Navigator Forms and Online Help To define responsibilities and recognize Navigator functionality, enter and work with data using forms, and search for information with Oracle Applications online help  more...

Oracle 11i Concurrent Processing Requests Profiles and Forms To execute application tasks simultaneously by running concurrent requests and request sets, customize the presentation of data, and manage personal user profiles, form attachments, and form flexfields  more...

Oracle Database 10g Installing Oracle Database 10g Release 2 To introduce the concepts of RDBMS and Oracle database administration, and explain how to install Oracle Database 10g software  more...

Oracle Database 10g Creating Databases Release 2 To provide an overview of Oracle database and instance architecture and demonstrate how to use the Database Configuration Assistant  more...

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

Oracle Database 10g Database Control and Storage Structures Release 2 To explain the fundamentals of Oracle database control and how to use tablespaces  more...

Oracle Database 10g Users and Security Release 2 To explain how to manage users, implement security, and audit database activity on an Oracle 10g database  more...

Oracle Database 10g Managing Schema Objects and Data Release 2 To demonstrate how to manage schema objects and data in an Oracle 10g database  more...

Oracle Database 10g The SQL Loader and PL SQL Release 2 To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database  more...

Oracle Database 10g Oracle Net Services and Shared Servers Release 2 To provide an overview of Oracle Net Services and Shared Server  more...

Oracle Database 10g Monitoring and Maintenance Release 2 To demonstrate how to control database performance and configure proactive database maintenance  more...

Oracle Database 10g Managing Undo Data and Lock Conflicts Release 2 To discuss how to manage undo data and manage lock conflicts in an Oracle database  more...

Oracle Database 10g Managing Backup and Recovery Release 2 To discuss how to manage backup and recovery in an Oracle 10g database  more...

Oracle Database 11g Installation and Upgrade Enhancements Recognize the enhancements to Oracle Database 11g's installation and upgrade processes, as well as its various post-upgrade steps, and recognize how to create a new database.  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 Change Management Overview and SQL Plan Management outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.  more...

Oracle Database 11g Database Replay and Automatic SQL Tuning Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database  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 Performance Enhancements identify the scope and capabilities of Oracle Database 11g's performance-enhancing tools, such as those for memory management, performance analysis, and statistics gathering.  more...

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

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 New Security Features identify the ways in which Oracle Database has enhanced security, including enhancements to Transparent Data Encryption and password security, and identify the steps for managing all aspects of security.  more...

Oracle Database 11g SecureFiles and Miscellaneous New Features Recognize the steps for enhancing the performance of large objects, caching query results, and performing other miscellaneous tasks in Oracle Database 11g  more...

Oracle Database 11g Database Architecture and Installation Identify the elements of the Oracle Database 11g architecture and recognize the tools and steps required to install the Oracle Database 11g software  more...

Oracle Database 11g Database Creation Instance Management and Connectivity Identify the steps for creating a new Oracle Database 11g database and then configuring it and managing the instance, and also recognize the steps for configuring new Oracle Net Listeners and database connectivity  more...

Oracle Database 11g Storage Structures and User Security identify the steps for maintaining storage structures and automating storage management in Oracle Database 11g, and for managing privileges, roles, and other security features for users.  more...

Oracle Database 11g Managing the Schema Data and Concurrency Identify the steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency  more...

Oracle Database 11g Managing Undo Data Database Security and Maintenance recognize the steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds.  more...

Oracle Database 11g Performance Monitoring Recovery Concepts and Backup identify the steps for ensuring an Oracle Database 11g database is available to users when needed, by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups.  more...

Introduction to Oracle and SQL in Oracle Database 10g To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements  more...

SQL Functions in Oracle Database 10g To describe how to use SQL functions for data retrieval  more...

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

Group and Datetime Functions in Oracle Database 10g To demonstrate how to use group and datetime functions in Oracle 10g  more...

Subqueries and Hierarchical Queries in Oracle Database 10g To demonstrate how to use subqueries and hierarchical queries in Oracle 10g  more...

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

Creating and Managing Tables and Constraints in Oracle Database 10g To demonstrate how to create and manage tables and constraints in Oracle 10g  more...

Database Objects in Oracle Database 10g To demonstrate how to create database views, sequences, indexes, and synonyms  more...

Managing Database Objects in Oracle Database 10g To demonstrate how to create external tables and to use the data dictionary views in Oracle 10g  more...

Manipulating Data in Oracle Database 10g To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements  more...

Introduction to PL SQL To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL  more...

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

Using Control Structures 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 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 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...

Creating Stored Procedures and Functions To create and execute a stored function and call, and remove and view stored functions in PL/SQL  more...

PL SQL Packages To create and work with Oracle 10g packages  more...

Oracle-Supplied Packages and DBMS_SCHEDULER To use Oracle-supplied packages  more...

Managing Dependencies To manage dependencies and recompile PL/SQL units  more...

Manipulating Large Objects in PL SQL To use LOBs and the DBMS_LOB package  more...

PL SQL Triggers To create and manage triggers  more...

Dynamic SQL and Metadata To write dynamic SQL and use the DBMS_METADATA package  more...

Oracle Database 10g New Features in Security and Software Maintenance To use the new security and software upgrade features in Oracle 10g  more...

Oracle Database 10g New Features in VLDB Support To use Oracle 10g's new VLDB support features  more...

Oracle Database 10g Miscellaneous New Features To recognize how various new features are used in Oracle 10g  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...

Advanced Database Recovery and Repair in Oracle 10g To outline the processes for recovering non-critical files, performing incomplete recoveries, and repairing corrupted components of databases  more...

Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle To outline the concepts and processes to secure the Oracle listener and to work with remote and distributed transactions  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 Using Data Types INDEX BY Tables and Cursors in PL SQL 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 Controlling User Access and Managing Schema Objects To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...

Oracle Database 11g Data Dictionary Views and Large Data Sets To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.  more...

Oracle Database 11g Managing Data in Different Time Zones 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 New Installation and Configuration Features To discuss the new installation and configuration features of Oracle 10g  more...

Oracle Database 10g New Data Loading Features To discuss new data loading features in Oracle 10g  more...

Oracle Database 10g New Automatic Management and Management Infrastructure Feat To identify the new automatic management and management infrastructure features of Oracle 10g  more...

Oracle Database 10g New Resource Scheduling and Task-Management Features To identify the new resource, scheduling, and task-management features of Oracle 10g  more...

Oracle Database 10g New Space Management Features To identify the new space management features of Oracle 10g  more...

Oracle Database 10g New Storage Features To identify the new storage features of Oracle Database 10g  more...

Oracle Database 10g New Tuning Performance-monitoring and Analysis Features To use Oracle 10g's new tuning, performance-monitoring, and analysis features  more...

Oracle Database 10g New Backup and Recovery Features To use Oracle 10g's new backup and recovery features  more...

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

Oracle Database 11g PL SQL Variables Attributes and Executable Statements To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.  more...

Oracle Database 11g Using DML DDL Cursors Control Structures and Loops 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...

The Database Design Methodology To describe and apply the techniques of the database design life cycle to build a relational database  more...

An Introduction to Database Systems To explain the main concepts of database systems  more...

Relational Databases To describe the concepts of relational databases  more...

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

Oracle 11i Project Management and Projects Integration To recognize the Oracle Enterprise Project Management Solution products, the integration of Oracle Project with other Oracle e-business applications, and how to define an Oracle Applications set of books  more...

Oracle 11i Organization Period and Calendar Definitions in Oracle Projects To recognize how Oracle Projects' multiple organization architecture, periods, and calendars are used for structuring and scheduling, and to implement them in an enterprise  more...

Oracle 11i Resource and Role Management To recognize the resources and roles in Oracle Projects, how they are used in project management, and to create and assign them  more...

Oracle 11i Oracle Projects Security Model and Page Layouts To use Oracle Projects to secure function and data access within Projects applications, and use page layouts to manipulate views of project information  more...

Oracle 11i Oracle Projects and Task Definition I To define project setup options and project types to manage project structuring, resources, and workflow  more...

Oracle 11i Oracle Projects and Task Definition II To recognize how projects are organized, and create and administer them  more...

Oracle 11i User-Defined Attributes Implementation Options and Utilization To use Oracle Project's user-defined attributes, group implementation options, and utilization reports to capture information, interface with other Oracle applications, and report actual and scheduled utilization and resources  more...

Oracle 11i Organization Forecasting and Integration To use organization forecasting for project planning and administration, and integrate Oracle Projects with Oracle Sales and Oracle Advanced Product Catalog to manage sales and product lifecycles  more...

SAP R 3 Release 4 6 Fundamentals To describe and demonstrate how SAP R/3 Release 4.6 application modules support business activities  more...

SAP Overview To recognize SAP as a leading ERP solution, identify the mySAP products available, and execute basic tasks in mySAP ERP  more...

mySAP Finance Modules To recognize how to align business processes with key financials modules in the SAP R/3 package  more...

mySAP Logistics Modules To recognize how to align business processes with key logistics modules in the mySAP ERP R/3 package.  more...

mySAP ERP Architecture To recognize the SAP R/3 architecture and how NetWeaver enhances the current SAP R/3 architecture.  more...

SAP R 3 Administration To recognize how to use system monitoring tools, how to perform user management tasks, and how to implement security  more...

Planning and Implementing SAP Projects To implement SAP projects using the ASAP methodology and the SAP implementation guide  more...

SAP NetWeaver To recognize how SAP NetWeaver features as an integration and application platform and how it supports open standards using web and enterprise services.  more...

ABAP Fundamentals To recognize the basic features of ABAP, including the workbench and ABAP tools, and to learn how to create a domain, a data element, and a table.  more...

ABAP Programming I To create a basic and an interactive report program using ABAP and to recognize how to preform basic object-oriented tasks such as creating and instantiating a class  more...

ABAP Programming II To create a dialog program and format and print a SAP form  more...

Navigating SAP R 3 Release 4 6 To enable the student to log on to SAP R/3 Release 4.6, manipulate the user interface, navigate the system, and create and configure a favorites list  more...

Using SAP R 3 Release 4 6 To enable the student to work with tasks and to describe some of the updated screens in Release 4.6  more...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

An Overview of Database Design To describe the process of relational database design to model real-world concepts  more...

Planning and Securing a DB2 UDB Database To plan and secure a DB2 UDB database  more...

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

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

Maintaining DB2 UDB Data Consistency To explain how to choose appropriate isolation levels and to describe how locks are acquired in a DB2 UDB database  more...

Managing a DB2 UDB Server To explain how to manage a DB2 UDB server  more...

Administering Data Placement in DB2 UDB To describe the administration and placement of data in a DB2 UDB database  more...

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

Monitoring a DB2 UDB database To explain how to monitor a DB2 UDB  more...

Utilizing DB2 UDB Utilities To explain the use of DB2 UDB data movement and data maintenance utilities  more...

Managing Disaster Recovery in a DB2 UDB Database To explain how to use the DB2 UDB disaster recovery utilities  more...

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

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

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

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

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

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

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

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

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

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

Enterprise Analysis and Making a Business Case ...Enterprise analysis is a key knowledge area in the practice of business analysis. During enterprise analysis, the business analyst identifies business opportunities, builds a business architecture framework, and determines the best project investment path for the enterprise. From this, the business analyst puts forward a business case, which provides an overall justification for the project. In  more...

Deploying Windows Vista ...operating system used on desktops throughout the world in enterprise and home environments. It provides enhanced security, performance, reliability, and reduced cost for deployment and management. This course discusses the deployment infrastructure for enterprise environments and the different deployment methods that can be used to deploy Windows Vista, either by upgrading or performing  more...

Monitoring Reporting and ISA Server Enterprise Edition To describe the use of ISA Server in an enterprise and develop a strategy for monitoring ISA Server activity  more...

Installation of ISA Server 2004 To demonstrate how to install ISA Server 2004 and configure web proxy, firewall, and SecureNAT clients  more...

ISA Server 2004 Management and Clientele To demonstrate how to install ISA Server 2004 clients and to secure and maintain ISA Server 2004  more...

Access Configuration in ISA Server 2004 To demonstrate how to enable access to Internet resources and to configure access to internal resources  more...

VPN and Exchange with ISA Server 2004 To show how to configure ISA Server 2004 to enable VPNs and to integrate ISA Server 2004 with Microsoft Exchange Server  more...

Firewall Configuration in ISA Server 2004 To give an overview of firewall configuration in ISA Server 2004  more...