Online Related Exam eLearning Training

Win2000 Professional Connect through Networks ...ethods to detect them, and enables you to find solutions. Related Exam: Microsoft Exam #070-210: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Directory Server Installing Configuring Troubleshooting Active Directory As an introduction to Active Directory in Windows 2000, this course will help you learn about installing, configuring, and troubleshooting Active Directory. First, you will learn about the benefits and features of Active Directory, as well as the physical and logical layout. You will learn how to install Active Directory, use Active Directory administration tools, and manage single master  more...

Win2000 Dir Serve Man Optimizing Active Dir Components This course provides an explanation of Active Directory components and how to best manage these components. First, you will learn about the different types of user accounts in Windows 2000, and how to create and manage local and domain user accounts. Next, you will learn how to locate, move and control access to Active Directory objects, as well as how to manage permission inheritance between  more...

Win2000 Active Directory Implementation Implementing Change Configuration Management This course provides an explanation of how to use group policies to manage users and computers in a centralized or decentralized network. First, the course introduces group policies and change and configuration management. You will learn how to store, modify, and process Group Policy Objects (GPOs), as well as how to link GPOs to domains, organizational units, or sites. This course describes GPO  more...

Win2000 Active Directory Implementation Managing User Environments and Software Deployments In this course, you will learn how to use Administrative Template settings and the Software Installation extension of the Group Policy console to manage user accounts and computer settings and deploy software. First, the course introduces user environment management, Administrative Template settings, and group policy loopback. You will learn how to manage user environments using group policy  more...

Win2000 Netwk Sec Design Analyzing an Org Sec Reqts In this course you will learn to analyze an organization's business models, processes, organizational structures, and IT management structure. You will learn the various network roles and responsibilities and will analyze the impact of security design on an organization. After learning about the different types of network security risks, you will learn to plan secure boundaries through firewalls  more...

Microsoft Excel 2000 Basic This highly interactive CBT contains five units that cover basic Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 2000, students learn how to build, edit, and format worksheets, and how to work with charts, formulas, and functions. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet  more...

Microsoft Access 2000 Basic This highly interactive CBT contains five units that cover basic Access skills. Through step-by-step instruction within a realistic simulation of Microsoft Access 2000, students learn how to create and manage data and tables, create forms and reports, and modify a database structure. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics  more...

Visual Basic 6 0 Database Access Part I This course provides an introduction to Visual Basic's capabilities relating to database access and manipulation in an online environment. It explains how databases are organized, how information is retrieved and manipulated in databases, and what technologies are available to ensure cross-platform and uniform access to database information. This course describes the fundamentals of viewing  more...

Visual Basic 6 Introduction Part II This course provides an introduction to the functionality and programming capabilities of Visual Basic 6.0. It builds on the concepts presented in the first course in this series, Visual Basic 6.0 Introduction Part I. In the first unit, you will learn how to create and use variables, procedures, and functions in program code. Data types, constants, and arrays are also covered, as well as how to  more...

Visual Basic 6 0 Intermediate This course builds on the concepts learned in the first course, Introduction to Visual Basic 6.0, and covers more advanced topics leading to certification in Visual Basic. The student will review what was learned in the introductory course, and then begin learning more advanced development techniques and technologies.Related Exam: Microsoft Exam #070-176: Designing and Implementing Desktop  more...

Visual Basic 6 0 Advanced This course covers techniques that Visual Basic programmers can use to enhance the interface, functionality and performance of their applications. Students will learn to create menus and toolbars. The course also introduces the student to ActiveX programming and the Common Dialog control. The course also shows students how to create and load documents using the File Access features of Visual  more...

Visual Basic 6 0 Enterprise Client Server Development Part 1 This course introduces developing programs for an enterprise client/server environment. It introduces multi-tier application architecture, reviews how to instantiate a COM component, and describes how to make and compile COM configurations. It also describes how COM components are registered and identified in the Windows registry. This course also introduces the concept of transactions and  more...

Visual Basic 6 0 Enterprise Client Server Dev Part II Microsoft Transaction Server (MTS) is a tool that enlists objects and their associated resources into transactions, and manages those transactions to ensure that changes to data are made correctly. This course discusses the role of transactions in MTS, and explains how MTS uses a context to manage objects and transactions. Additionally, it covers the steps required to build MTS components that  more...

Visual Basic 6 0 Advanced Enterprise Client Server Dev Part I This course discusses database security implementations to aid a developer in correctly programming components that access data without compromising security. The different security modes available to Microsoft SQL Server 7.0 and previous versions of SQL Server are explained, as well as their respective advantages. It also explains creating Windows NT accounts and user groups. This course  more...

Visual Basic 6 0 Advanced Enterprise Client Server Dev Part II This course investigates advanced concepts and technologies that will help you develop more capable and reliable client/server applications with Visual Basic. It discusses the attributes of interfaces and the concept of an interface as a contract. It examines the basic IUnknown interface, the creation and implementation of abstract classes and multiple interfaces, and the fundamentals of the  more...

Visual Basic 6 0 Using the Win 32 API Part I This course provides an overview of the Microsoft Win32 application programming interface (API), how it is organized, and some of its features that you can use in your Visual Basic Windows applications. The Win32 API includes services that go beyond the core language and controls provided with Visual Basic such as system management, networking, printing, and security. Using the Win32 API, you can  more...

Visual Basic 6 0 Using the Win32 API Part II This course describes how to use some of the more common Win32 API drawing functions, it explains how to obtain and release a device context and how to draw dots, lines, and rectangles on a form or control. It also describes how to change pen and brush styles by using stock objects and by creating customized pens and brushes. In addition, it explains how to place a text string on a control or form  more...

Visual Basic 6 0 ActiveX COM Part I This course builds and extends the skills beyond basic Visual Basic programming by introducing ActiveX components and the Component Object Model (COM). The Component Object Model (COM) is an open, extensible standard on which ActiveX is based. By understanding COM, you can design applications from components that communicate through a common set of interfaces. Component software development cuts  more...

Win2000 Netwk Security Design Providing Secure Access in a LAN This course provides an overview of security policy concepts and the different ways of implementing security. You will learn to use account policies and local policies and to maintain event logs. Security Templates concepts will be covered as will the configuration of the Security Configuration and Analysis utility. You will learn to use the Encrypting File System (EFS) and to configure SNMP  more...

Win2000 Netwk Security Design Providing Secure Access in Remote Netwks This course covers demand-dial routing as a feature of RRAS security and also explains the LAN and WAN routing protocols supported by RRAS. You will learn about RRAS security strategies and will learn to configure the RRAS callback options used to verify identities of clients and servers. You will learn about the components of a virtual private network and about the features of the VPN tunneling  more...

Win2000 Netwk Security Design Providing Secure Access-Internet This course provides an overview of maintaining security for a private network configured for public access and explains the risks that a network is prone to while using the Internet. You will learn how to protect a network using a firewall and will also learn about the guidelines for placement of Web and FTP servers, application servers, RRAS servers, and DNS servers while configuring a firewall.  more...

Win2000 Netwk Infra Design Wide Area Network Infra This course explains the role of RADIUS on a network and the integration of RADIUS and Windows 2000. It further explains the role of a VPN on a network and discusses the strategies for VPN availability and performance. Next, this course introduces you to the Demand-Dial Routing strategy in Windows 2000 and discusses Demand-Dial Routing installation, as well as the methods of Demand-Dial Security.  more...

Win2000 Professional Installing on Multiple Computers ...000 Professional installation using answer files and RIS. Related Exam: Microsoft Exam #070-210: Implementing and Administering Microsoft The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of this course and  more...

Win2000 Professional Enhanced Support for Hardware Devices ...fferent hardware devices are also covered in this course. Related Exam: Microsoft Exam #070-210: Implementing and Administering Microsoft Windows 2000 The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Professional Administering Users and Groups ...the problems related to user accounts and group policies. Related Exam: Microsoft Exam #070-210: Implementing and Administering Microsoft Windows 2000 The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Professional Administering Resources ...ile-system, file or folder inaccessibility, and printing. Related Exam: Microsoft Exam #070-210: Implementing and Administering Microsoft The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of this course and  more...

Win2000 Professional Custom Desktop Environment ...elines and procedures for troubleshooting those problems. Related Exam: Microsoft Exam #070-210: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Professional Optimizing System Performance ...ve problems related to task scheduling and offline files. Related Exam: Microsoft Exam #070-210: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Professional Recovering Data and Systems ... and configuring the system for responding to Stop errors.Related Exam: Microsoft Exam #070-210: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Professional Implementing and Monitoring Security ...cies and problems related to audit and security policies. Related Exam: Microsoft Exam #070-210: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Server Managing File and Print Resources ...alling, managing, auditing, and troubleshooting printers. Related Exam: Microsoft Exam #070-215: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Server Configuring Storage Use ...disk, and troubleshoot and repair partitions and volumes. Related Exam: Microsoft Exam #070-215: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Server Maintenance and Troubleshooting ...arious tools you need to use to troubleshoot STOP Errors. Related Exam: Microsoft Exam #070-215: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Server Monitoring and Optimizing ...for detecting and resolving disk and network bottlenecks. Related Exam: Microsoft Exam #070-215: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Server Configuring Network Services ...se. You will learn about the lookup zones and zone types. Related Exam: Microsoft Exam #070-215: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Server Managing Terminal Services ...minal sessions and users using Terminal Services Manager. Related Exam: Microsoft Exam #070-215: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Server Setting Up Remote Access Service ...iar with the procedure for installing and configuring IAS.Related Exam: Microsoft Exam #070-215: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Server Implementing Interoperability ...nd Windows 2000 networks are also covered in this course. Related Exam: Microsoft Exam #070-215: Implementing and Administering Mi The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of this course and the  more...

Win2000 Server Automated Methods of Installation ... a computer for creating a disk image using Sysprep tool. Related Exam: Microsoft Exam #070-215: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Win2000 Network Infrastructure Implementation Administering DNS This course introduces you to the concept of Domain Name System (DNS) and explains the benefits of using DNS. You will learn how to install and configure a DNS server and DNS client computers, as well as how to monitor a DNS server and troubleshoot problems related to DNS servers and clients. The course also discusses the concept of zones that are used to store this information. You will learn how  more...

Win2000 Network Infrastructure Administering DHCP This course discusses DHCP services. It describes the procedure for installing, managing and troubleshooting DHCP Server, configuring DHCP client services, and for integrating DHCP Server services with other networking services, such as Active Directory, DNS, and RRAS. Further in this course, you will learn how to create and manage scopes, superscopes, multicast scopes, and new reservations. The  more...

Win2000 Network Infrastructure Administering WINS This course discusses the components, features, and benefits of WINS. It describes the procedure for installing the WINS server service and explains how to add and start a WINS server on a Windows 2000 network, as well as how to troubleshoot name resolution problems. Further, the course covers the strategies followed to select replication partners and describes how to configure a WINS server as a  more...

Win2000 Network Infrastructure Configuring Network Protocols This course introduces you to some commonly used network protocols. You will learn to install and configure TCP/IP, NWLink, and Network Binding. You will also learn about IP addressing, default gateways, and host name and NETBIOS resolutions. The use of the Windows 2000 performance logs and alerts to view TCP/IP related counters and troubleshooting problems encountered while using TCP/IP are also  more...

Win2000 Network Infrastructure Configuring IP Routing Protocols This course introduces you to the role of IP Routing Services in a Windows 2000 network and explains Windows 2000-based IP routing. You will learn how to implement static and dynamic IP routing. Next, this course explains how to configure IP routing protocols. You will learn how to set up a Routing Information Protocol (RIP)-for-IP network, how to configure RIP-for-IP network security, as well as  more...

Win2000 Network Infrastructure Configuring Internet Connection Sharing Network This course discusses the Internet Connection Sharing (ICS) feature of the Windows 2000 operating system, as well as installing ICS, configuring network applications and services for ICS, and troubleshooting problems related to ICS. Next, the course explains the concept of Network Address Translation (NAT), a protocol available as a part of Routing and Remote Access Service (RRAS) of the Windows  more...

Win2000 Network Using Certificate Services This course introduces the concept of certificates and certification authorities. You will learn about digital signatures and installing certificate services on a Windows 2000 server. You will also learn about the types of certification authorities and their role in issuing and authorizing certificates. Then, the course covers managing certificates and examines the importance of EFS keys in  more...

Win2000 Active Directory Design Introducing Windows 2000 Active Directory Services This course provides an introduction to basic Active Directory concepts. First, you will learn about directory services, the introduction of Active Directory in Windows 2000, and the physical structure and information flow in Active Directory. This course explains the features of Active Directory, such as domains, trusts, trees, forests and organizational units. Next, you will learn about sites  more...

Win2000 Active Directory Design Advanced Active Directory Concepts This course gives you the knowledge and skills necessary to design an Active Directory implementation plan, by covering methods of extending the schema, Active Directory data recovery and maintenance, and setup and upgrade strategies. First, you will learn about expanding and modifying the schema, prerequisites, implications of these changes, and methods for altering schema components. The course  more...

Win2000 Netwk Infra Design Prep for W2K Netwk Serv Infra This course discusses planning a business model, as well as centralized and decentralized administration. It covers structural, process, and end-user requirements of an organization. You will also learn about vendor, partner, and customer relationships and the features in Windows 2000 that help in meeting these requirements. Further, the course deals with IT management structure, including desktop  more...

Win2000 Server Installing and Upgrading ...roubleshooting installation and upgrade failure problems. Related Exam: Microsoft Exam #070-210: Implementing and Administering Microsoft Windows 2000. The course addresses the training needs of system administrators, network designers, and IT consultants. This course also addresses the needs of IT professionals who want to become certified under the new Windows 2000 MCSE track. Completion of  more...

Microsoft Access 97 Advanced This highly interactive CBT contains three units that cover advanced Access 97 skills. Through step-by-step instruction within a realistic simulation of Microsoft Access, individuals learn how to add complex objects to a form, manage database objects, create macros and modules and maintain a database. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering  more...

Microsoft Word 2000 Basic This highly interactive CBT contains five units that cover basic Word skills. Through step-by-step instruction within a realistic simulation of Microsoft Word 2000, students learn how to design, create, edit, and enhance documents. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet mastered. A searchable index and online  more...

Microsoft Word 2000 Intermediate This highly interactive CBT contains five units that cover intermediate Word skills. Through step-by-step instruction within a realistic simulation of Microsoft Word 2000, students learn how to work with styles and graphics, merge documents, share Word document information with other programs, and use Word to create a Web site. Performance-based Pre- and Post-Assessments create a custom course  more...

Microsoft PowerPoint 2000 Advanced This highly interactive CBT contains three units that cover advanced PowerPoint skills. Through step-by-step instruction within a realistic simulation of Microsoft PowerPoint 2000, students learn how to enhance charts, work with embedded and linked objects, and use slide show features. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics  more...

Microsoft Word 2000 Advanced This highly interactive CBT contains six units that cover advanced Word skills. Through step-by-step instruction within a realistic simulation of Microsoft Word 2000, students learn how to work with larger documents and collaborate with others working on the same document, arrange text and text objects, create and modify charts and forms, and customize the Word environment. Performance-based Pre-  more...

Microsoft Excel 2000 Intermediate This highly interactive CBT contains six units that cover intermediate Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 2000, students learn how to manage workbooks, automate tasks, use and analyze list data, enhance charts and worksheets, and work with Excel and the Internet. Performance-based Pre- and Post-Assessments create a custom course path for  more...

Microsoft Excel 2000 Advanced This highly interactive CBT contains five units that cover advanced Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 2000, students learn how to perform "what-if" analysis, create PivotTables, exchange Excel data with other programs, control worksheet properties and calculations, and program with Excel. Performance-based Pre- and Post-Assessments  more...

Microsoft Access 2000 Intermediate This highly interactive CBT contains six units that cover intermediate Access skills. Through step-by-step instruction within a realistic simulation of Microsoft Access 2000, students learn how to create complex queries, forms, and reports, share Access information with other programs, and add objects to a form. Related Exam: MOUS Access 2000 Expert. Designed to teach intermediate Access skills.  more...

Oracle8i DBA--SQL*Loader, Oracle Export and Import, and NLS The course is aimed at familiarizing you with the data transfer tools of Oracles. The course will teach you how to use SQL*Loader to load data into an Oracle database. The course will also teach you how to use the Oracle Export and Import Utilities. Next the course will detail explain the NLS feature of Oracle8i. The course initiates the learner into hands-on learning by helping the learner to  more...

Visual Basic 6 Introduction Part I This course introduces the Rapid Application Development environment of Visual Basic 6.0. The student will become familiar with the Visual Basic design environment and will be introduced to the development of Windows applications. Programming fundamentals are covered including a discussion of variables and subroutines procedures and functions number and string manipulation and control-of-flow  more...

MCSD Solutions Architecture I The first course in series of four courses that is designed to provide all of the information a student needs to complete Microsoft's Solutions Architecture exam 70-100. This course explains how to analyze the business requirements for designing new software. This course provides an overview of the Microsoft Solutions Framework (MSF) Microsoft's guidelines for planning building and  more...

MCSD Solutions Architecture II The second course in a series of four courses that is designed to provide all of the information a student needs to complete Microsoft's Solutions Architecture exam 70-100. This course describes the process of designing a technical architecture. This course will describe networking technologies such as clients servers network types network models and network protocols. It also describes the  more...

MCSD Solutions Architecture III The third course in series of four courses that is designed to provide all of the information a student needs to complete Microsoft's Solutions Architecture exam 70-100. This course explains how to design applications and data models for designing new software. It describes the logical design phase and shows how to create class diagrams logical data models and user interface prototypes. This  more...

SQL Server 7.0 Management Part II This course provides the skills to database administrators managers and users so that they may take full advantage of SQL Server 7.0 features. It explains how to use the fundamental elements of Transact-SQL how to use the SELECT statement and how to monitor database performance. It also examines stored procedures and joins. Related Exam: Prepares users for both Microsoft Exams #070-028  more...

SQL Server 7.0 Management Part III This course explains how to design a logical model of a database and identifies the components to use in order to organize and access a SQL Server database. It describes the advanced programmatic features of the SQL language which can be used to extend the functionality of SQL stored procedures.Additionally this course examines the functions of a SQL cursor including how to navigate a result set  more...

SQL Server 7.0 Advanced Features Part I This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition it outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advanced  more...

SQL Server 7.0 Advanced Features Part II This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition It outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advances  more...

Oracle 8i PL/SQL - Intro to RDBMS and SQL *Plus The course aims to familiarize you with the basic concepts of database design. The course also provides a brief overview of relational database model since the Oracle database is based on this model. The course familiarizes you with the use of SQL and SQL *PLUS commands. The course will enable you to construct queries using SELECT statement with clauses such as WHERE ORDER BY and DISTINCT. You  more...

Oracle 8i PL/SQL - Functions, Tables, and Groups This course covers the concepts of single row functions that enable the manipulation of data. The course essentially focuses on three single row functions: character functions number functions and date functions. The course also covers the concept of conversion that enables the conversion of a value from one datatype to another. The concept of retrieving data from more than one table by using  more...

Oracle 8i PL/SQL - Adv SQL, SQL *Plus & Data Dictionary In this course you will learn to create subqueries and queries using SET operators. The course describes the SQL *PLUS file commands and SET commands that are used to customize the SQL *PLUS environment. Furthermore the course discusses the SQL *Plus format commands and script files. The concept of data dictionary tables and views is also covered in the course. Related Exam: Oracle Exam #1Z0-001:  more...

Oracle 8i PL/SQL - DML and DDL Statements This course introduces the DDL and DML statements. It explains the concept of creation of tables and views. It also covers the various commands for manipulating a database. In addition the course explains the transaction processing features. It highlights the concept of altering a table definition in a database dropping a table adding comments to a table and renaming a table. It describes the  more...

Oracle 8i PL/SQL - Database Objects and Security This course is aimed at familiarizing the learner with the inbuilt objects and security options in Oracle. The course includes creating and managing sequences indexes and users. It also includes PL/SQL block PL/SQL records and tables PL/SQL variables and datatypes. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL.  more...

Oracle 8i PL/SQL - Oracle PL/SQL Basic Operations The course is aimed at familiarizing the learner with the basic concepts of PL/SQL. It describes the different datatypes and variables available with PL/SQL. The course provides an overview of PL/SQL records and tables and explains how to access a database from PL/SQL. It also describes the steps to write conditional constructs and controlling structures in PL/SQL along with different types of  more...

Oracle 8i DBA - Introducing Procedure Builder This course aims to introduce you to the various components of Procedure Builder. It explains the features of the Procedure Builder components such as the Object Navigator the PL/SQL Interpreter the Program Unit Editor the Stored Program Unit Editor and the Database Trigger Editor. It describes how you can use the components of Procedure Builder to create debug and execute program units. Related  more...

Oracle 8i DBA - Oracle Server and Database Architecture This course is aimed to familiarize you with the basic concepts of Oracle 8i Architecture and Oracle Enterprise Manager. This course will introduce you to the concepts of Oracle instances and SGA components. You will learn to identify the memory structures and processes involved with an Oracle instance. You will be introduced to the Oracle Universal Installer and be able to explain the Optimal  more...

Oracle 8i DBA - Oracle Instance, the Start-up and Shutdown Procedure The course is aimed at familiarizing the learner with the Oracle instance. It teaches you the learner about the startup and shutdown processes and the different stages of startup and shutdown. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping you the learner type in the commands  more...

Oracle 8i DBA - Data Dictionary and Database Files The course is aimed at familiarizing the student with the Data Dictionary views and database files. The course enables the learner to manage log and control files. The uses and contents of control files will be discussed as well as obtaining information from control files. The planning use and troubleshooting of redo log files will also be explained. The course also provides a list of Data  more...

Oracle 8i DBA - Oracle Storage Architecture This course is designed to give an Oracle DBA the necessary knowledge and skills to manage data storage. It will provide detailed information about logical structures such as tablespaces segments extents and Oracle data blocks. The creation and management of rollback segments will also be covered. The course also provides a list of data dictionary views that help in managing these logical  more...

Oracle 8i DBA - Understanding Storage Allocation This course covers the various aspects of optimizing database objects. It discusses tables clusters and index-organized tables. This course explains the different types of tables supported by Oracle 8i the structure of a row the different data types supported by Oracle 8i and the guidelines to create a table. Further the course covers how to create the cluster the cluster index and the tables in  more...

Oracle8i DBA: Indexes and Constraints In this course you will learn to create indexes and enforce various constraints. The course describes the reorganization of indexes managing indexes and maintaining constraints. You will also learn how to obtain information about indexes and constraints from the data dictionary. Related Exam: Oracle Exam #1Z0-023: Oracle 8i: Architecture and Administration.  more...

Oracle 8i DBA - Managing Oracle Database Security This course is aimed to familiarize the learner with the basic concepts of Oracle 8i administration of security user roles and resources. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping the learner to type-in the commands to perform administrative tasks. Related Exam: Oracle  more...

Java 2: Introduction to Java 2 This course provides an introduction to the Java programming language. Topics covered include the history of Java main features of the language its differences from C++ the Java Virtual Machine and the Java Application Programming Interface. You will also learn the methodology for creating and executing Java programs and applets. An explanation of the tools provided by the SDK is included along  more...

Java 2: Language and Semantics This course details the Java language and Java semantics. It describes the fundamentals of Java programming such as syntax fundamentals lexical issues data types keywords identifiers constants literals and variables. In addition you will learn about the use of operators expressions and control statements in Java. Finally the course explains the use of arrays. Related Exam: Sun Microsystems Exam  more...

Java 2: Classes and Inheritance This course is aimed to discuss the constructs and features that make Java a highly modular and object-oriented programming language. The use and implementation of programming constructs such as classes objects methods packages interfaces and constructors and details of their benefits are described. Additionally the course explains the application of various Java features such as encapsulation  more...

Java 2: Handling Exceptions & Implementing Threads This course explains the mechanism of exception handling and threads in Java. It introduces important keywords such as try catch throws throw and finally. The Java exception hierarchy various built-in exception types and the procedure for creating your own exception subclasses are explained. In addition you will learn about multithreading the life cycle of a thread thread priorities the use of  more...

Java 2: java.lang Package This course is an overview of the java.lang package. It provides an understanding of the interfaces and exceptions thrown by the classes in the java.lang package. You will be able to determine the methods in the Object class and write programs by using the Class class and the ClassLoader class. The course demonstrates how to manipulate strings by using methods of the String class and perform  more...

Java 2: java.util Package This course provides an overview of the Collections framework contained in the java.util package. It explains the interfaces and the classes that form the core components of this package. In addition you will learn to use the utility classes such as ArrayList Vector HashSet and LinkedList in a program. The implementation of the interfaces in the java.util package is explained by using the  more...

Java 2: Building a Graphical User Interface This course provides an overview of the java.awt package and its important classes such as Component Container Panel and Graphics. The course covers the Graphical User Interface (GUI) components such as the label the button the check box and so on. In addition you will examine the layout manager and the different layouts in detail. Finally you will learn to position the components in the client  more...

Java 2: Applets and Imaging In this course you will learn about the procedure for creating an applet its features and its life cycle. The course also explains the paint repaint and the update methods and the differences between the three methods. You will be introduced to the various components of the Delegation Event Model in JDK 1.2 and the class hierarchy in the java.awt.event package. In addition you will learn to  more...

Java 2: File I/O This course covers the concepts of I/O (input/output) in Java. You will be introduced to terms such as streams readers and writers. You will learn how to perform I/O operations in Java using the InputStream and OutputStream classes and their subclasses. The course also explains how I/O operations are performed in files with the help of the File class. You will also learn to create a random access  more...

Java 2: Advanced Java This course is designed to explain the garbage collection mechanism of JVM and the methods and packages used in garbage collection. It explains the security model of JDK 1.2 and describes the security mechanisms the security policies and permissions. The course covers the concepts of internationalization and the functions of the Locale class the Calendar class and the TimeZone class. You will  more...

Java 2: Enterprise Java This course is designed to provide an overview of the new technologies in Java. It includes the Swing and JFC package and gives details of the Swing architecture Swing classes creation of GUIs by using Swing components and the JComponent class. It provides an overview to the Java Servlets describes the Servlets using ServletRequest interface ServletResponse interface cookies and session tracking.  more...