Online An Instance eLearning - Training Resources

Java 2 -- Classes & Inheritance Students will learn about Classes & Objects, Inheritance and Polymorphism, Nested Classes and Creating Interfaces in the Java Programming Language This unit introduces the concept of classes and objects, and discusses the procedure for declaring classes and creating objects. You will learn to declare instance variables, methods, and local variables by using permitted modifiers such as public,  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 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 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...

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

Database and Instance Management in Oracle9i To describe how to manage an Oracle9i database instance and how to plan and create a database  more...

Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting. Learn To:  more...

Oracle9i Database Admin Set Up Oracle Net Services ...quisites include Oracle9i Database Administration: Manage an Instance (64311), and Oracle9i Database Administration: Create a Database (64312). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 64326 Objectives Unit 1: Oracle Net Services Overview 1 -  more...

Oracle9i Database Admin Create a Database ... file by editing settings in the init.ora file, and start an instance in the NOMOUNT mode. • Identify the command options of the CREATE DATABASE command, the situations in which it fails, create a database by using the CREATE DATABASE command and identify its content after creation. • Identify the benefits of using Oracle-Managed Files and manage data files, control files, and  more...

Oracle9i Database Admin Manage an Instance ...e Overview The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are  more...

Oracle9i Database Fundamentals I Curriculum The Oracle9i Database: Fundamentals I Curriculum includes the following courses: Oracle9i Database Admin.: Manage an Instance Oracle9i Database Admin.: Create a Database Oracle9i Database Admin.: Manage Storage Structures Oracle9i Database Admin.: Manage Data Storage Oracle9i Database Admin.: Manage Security To review individual course descriptions, please return to the previous page and  more...

C Programming for the Microsoft NET Platform Part 2 Course Overview This is the second course in a five part series that teaches statements and exceptions, methods and parameters, and arrays within the Microsoft C# programming language. The course introduces common statements and exception handling, as well as, how to use methods and parameters and how to create, initialize, and use arrays. Learn To • Identify characteristics of  more...

ASP NET Part 3 Web Services Web Apps ...om a browser. • Identify the syntax used to create an instance of a proxy. • Identify the syntax used to create a Web service with Visual Basic (VB). • Call a Web service by using VisualStudio.NET. • Identify features of the Web Service Description Language (WSDL). • Identify the syntax used to compile a proxy class into a DLL. • Create a Web service by  more...

ASP NET Part 3 Web Services Web Apps ...om a browser. • Identify the syntax used to create an instance of a proxy. • Identify the syntax used to create a Web service with Visual Basic (VB). • Call a Web service by using VisualStudio.NET. • Identify features of the Web Service Description Language (WSDL). • Identify the syntax used to compile a proxy class into a DLL. • Create a Web service by  more...

SQL Server 2000 Database Admin Part 1 Install SQL Server 2000 This is the first course in a five part series that presents the students with both theoretical and practical instruction in the subject of installing SQL Server 2000. Learn To Identify the features and functions of SQL Server. Identify the components involved in the client-server communication process. Identify the steps in the client-server communication process. Identify the minimum  more...

Intro to Object-Oriented Programming with Java This course covers the advantages of Object-Oriented Programming (OOP) and OOP features specific to Java. It explains the concept and use of classes, objects, arrays, class members, and scope of variables. It also describes how to invoke methods. In addition, the course covers advanced OOP concepts like encapsulation, inheritance, polymorphism, and method overloading, overriding, and hiding.  more...

Intro to Object-Oriented Programming with Java This course covers the advantages of Object-Oriented Programming (OOP) and OOP features specific to Java. It explains the concept and use of classes, objects, arrays, class members, and scope of variables. It also describes how to invoke methods. In addition, the course covers advanced OOP concepts like encapsulation, inheritance, polymorphism, and method overloading, overriding, and hiding.  more...

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

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

OCDBA8i Curriculum ...ng & Recovery(ID#7487) Oracle 8i Database Admin.: Manage an Instance(ID#7476) Oracle 8i Database Admin.: Create Databases(ID#7477) Oracle 8i Database Admin.: Manage Storage Structures(ID#7478) Oracle 8i Database Admin.: Manage Data Storage(ID#7479) Oracle 8i Database Admin.: Manage Security(ID#7480) Oracle 8i Network Administration: Net8 Architecture & Strategy(ID#7489) Oracle 8i Network  more...

Oracle8i Backup and Recovery Troubleshooting Recovery ...of user error failures. Identify the recovery process in an instance failure. Identify the causes of instance failure. Identify the ways of resolving a media failure. Identify the causes of media failure. Identify a database failure error condition by diagnosing an alert file. Identify the features of an alert file. Identify a database failure error condition by diagnosing a trace  more...

Oracle8i Database Admin Manage Security ... Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Managing Users Duration: 1 Hour(s) Match the components  more...

Oracle8i Database Admin Manage Data Storage ... Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312) and Oracle8i Database Administration: Manage Storage Structures (63313). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s) Course Contents  more...

Oracle8i Database Admin Manage Storage Structures ... Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Storage Structures Duration: 1 - 2 Hour(s) Identify the  more...

Oracle8i Database Admin Create Databases ... Basics (60113), Oracle8i Database Administration: Manage an Instance (63311). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Creating a Database: Procedure Duration: 1 - 2 Hour(s) Identify the guidelines for creating an OFA structure. Match the  more...

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

Oracle8i Database Administration Curriculum The Oracle 8i Database Administration Curriculum includes the following courses: Oracle 8i Database Admin.: Manage an Instance Oracle 8i Database Admin.: Create Databases Oracle 8i Database Admin.: Manage Storage Structures Oracle 8i Database Admin.: Manage Data Storage Oracle 8i Database Admin.: Manage Security To review individual course descriptions, please return to the previous page  more...

Macromedia Flash MX 2004 Developing Flash Applications This course covers how to build a rich Internet application with Macromedia Flash MX 2004. The course has three units. The unit Object-Oriented ActionScript 2.0 introduces learners to object-oriented programming (OOP) concepts used in ActionScript 2.0. Connecting to External Data provides information for sending and retrieving data to and from a Flash file. The third unit, Components, enables  more...

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

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

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention ...session scope type with its definition. Set the scope of an instance tuning session. Set the scope of an application tuning session. Set the scope of a structure tuning session. View collected data in the Oracle Expert repository. Specify the options to display the database class data. Change the duration and sample frequency of collecting instance statistics. Access schema class data.  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ...s. Perform the steps to define the number of buffers for an instance using the DB_BLOCK_BUFFERS initialization parameter. Select the proper clause to obtain the size of each object. Sequence the steps to determine the number of blocks required for objects in the RECYCLE pool. Perform the steps to determine if there have been waits for buffers using the V$SESSION_WAIT view. Perform the  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 Backup and Recovery - Troubleshooting and Recovery ...f user errors failures. Identify the recovery process in an instance failure. Identify the causes of instance failure. Identify the ways of resolving a media failure. Identify the causes of media failure. Identify a database failure error condition by diagnosing an alert Identify the features of an alert file. Identify a database failure error condition by diagnosing a trace Identify  more...

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

Oracle8 Certified Database Administrator Curriculum ...Basics (ID#322) Oracle8 Database Administration - Manage an Instance (ID#421) Oracle8 Database Administration - Create Databases (ID#426) Oracle8 Database Administration - Manage Data Storage Structures (ID#430) Oracle8 Database Administration - Manage Data Storage (ID#434) Oracle8 Database Administration - Manage Security (ID#438) Oracle8 Backup and Recovery - Strategies and Backups  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 Curriculum The Oracle8 Certified Database Administration Curriculum consists of the following courses: Oracle8 Database Administration - Manage and Instance Oracle8 Database Administration - Create Database Oracle8 Database Administration - Manage Storage Structures Oracle8 Database Administration - Manage Data Oracle8 Database Administration - Manage Security To review individual course  more...

Oracle8 Database Administration - Manage an Instance ...eter file. Identify the tasks performed in each stage of an instance startup. Start up an instance by using the Oracle Instance Manager. Change a database state by using the Oracle Instance Manager. Identify the tasks performed in each stage of instance shutdown. Identify the features of dynamic performance views. Specify the associated dynamic performance view parameter for a given  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 the  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 4 ...t. Identify the features of callback procedures. Create an instance of Internet Explorer. Set properties for an instance of Internet Explorer. Call methods exposed by the Internet Explorer objects. Add an event procedure for the Internet Explorer object. Unit 2: Building Reusable COM Components Duration: 2 - 3 Hour(s) Identify COM component types. Identify the differences  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 2 ...ents will learn to use class modules to define and create an instance of a component. Students will also be provided with the basic instruction on the ActiveX Controls feature of Visual Basic 6.0. L earn To: Create a COM component that exposes properties, methods and events. Create property pages for an ActiveX control. C ontent Emphasis Skills-Based A udience This  more...

Visual InterDev 6 0 Accessing Remote Data ...terDev Project Explorer window. Write the code to create an instance of a COM component in ASP by using the CreateObject method. Write the code to create a remote business object instance by using the CreateObject method of RDS.DataSpace. Deploy a Web application containing COM components by using the Visual InterDev Project Explorer window. Match the version compatibility options in the  more...

Visual InterDev 6 0 Active Server Pages and Data Access ...ction of the Response object. Write the syntax to create an instance of a component. Match the built-in ActiveX components used to create ASP with their functions. Set the properties of Browser Capabilities component in the Browscap.ini file. Write to a text file by using the TextStream object. Create a page object by using the PageObject design-time control. Define a method for a page  more...

Visual InterDev 6 0 Active Server Pages and Data Access Course 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; set  more...

Oracle Database 10g Administration Workshop I Part 4 Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will also be taught about undo management, lock management, and backup and recovery techniques. Learn To: Identify benefits of undo data. Identify features of undo segments. Identify undo management tasks that a DBA should perform to  more...

Data Modeling - Create Basic Models ...an entity. Identify the difference between an entity and an instance of an entity. Identify the definition of a relationship. Identify the implications of an optional relationship. Identify the implications of a mandatory relationship. Combine relationships to create a bi-directional relationship. Distinguish between a 'one or more' and a 'one and only one' relationship. Identify how a  more...

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

Site Server 3 0 Implementation - Part 2 Course Overview This is the second 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 concepts considered when planning a catalog; perform the steps to modify an existing Web page to search  more...

Programming XM XML Parsing This course introduces students to WebSphere Studio Application Developer. It provides a general over overview of XML parsing and it introduces students to the Simple API for XML (SAX) parser and the Document Object Model (DOM) XML parser. Learn To To identify features of the WebSphere Studio family. To identify features of WebSphere  more...

Java for Procedural Programmers Java Concepts ... To identify the syntax to create an instance of a class. To identify considerations for creating a class. To identify considerations for creating an instance method. To identify features of overloading. Audience Learners should be programmers whom are able to program in a procedural  more...

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

Oracle Database 10g Administration Workshop I Part 1 Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will be taught to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Learn To:  more...

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

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

Java for Procedural Programmers Java Concepts ... To identify the syntax to create an instance of a class. To identify considerations for creating a class. To identify considerations for creating an instance method. To identify features of overloading. Audience Learners should be programmers whom are able to program in a procedural  more...

Oracle 9i New Features Backup Recovery Performance Tuning This course introduces students to high availability and fault recovery, data protection and disaster recovery, LogMiner enhancements, online operations, and Recovery Manager enhancements. Students also learn about schema improvements, system improvements, and scalable session state management. Learn To Identify the new features designed to reduce unplanned  more...

CIW Enterprise Specialist Part 2 CORBA Servers Adv Features Security ...plementing a CORBA object. o Identify steps in creating an instance of an object to be published. o Identify features and functions of factory objects. o Identify steps in using factory objects to obtain object references. o Identify functions of callback objects. o Identify features of CORBA exceptions. o Match CORBA system exceptions with their definitions. o Identify  more...

CIW Enterprise Specialist Part 4 EJB Deployment EJB Clients Entity Beans ... entity beans. o Identity the life cycle of an entity bean instance. o Match EntityBean interface methods with their descriptions. Audience The intended audience for this course includes Technical Managers, Database Administrators, Application Developers, Systems Analysts, Software Engineers, Software Designers, and Project Managers. Learners should have knowledge of Object-Oriented  more...

Programming XML XML Parsing This course introduces students to WebSphere Studio Application Developer. It provides a general over overview of XML parsing and it introduces students to the Simple API for XML (SAX) parser and the Document Object Model (DOM) XML parser. Learn To To identify features of the WebSphere Studio family. To identify features of WebSphere  more...

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

Oracle Application Server 10g Administration II Part 2 This course introduces learners to Web Cache clusters and OracleAS Clusters. The participants learn to configure these clusters and manage them in OracleAS 10g. The participants also learn to configure J2EE clustering, OC4J, and manage OracleAS in a CFC environment. Learn To: Identify features of Oracle Application Server (OracleAS) 10g Web Cache clusters. Identify benefits of running  more...

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

Oracle Application Server 10g Administration II Part 4 This course covers how to monitor the OracleAS components and processes. It also covers tuning the various components of the OracleAS, as well as backup and recovery of OracleAS. Finally, it provides guidance on reconfiguring the OracleAS middle-tier components. Learn To: Identify features of Oracle Diagnostic Logging (ODL). Identify options for configuring component logging.  more...