Online Views eLearning - Training Resources

Microsoft Excel XP Certification Our Excel XP gives you the comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. Welcome to Microsoft Excel XP Certification Our Excel XP gives you the comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. You'll be able to easily analyze data with charts, Microsoft PivotTable views and  more...

Microsoft Excel 2003 (Levels 1-2-3) Our Excel 2003 gives you the comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. Microsoft Excel 2003 (Levels 1-2-3) Our Excel 2003 gives you the comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. You`ll be able to easily analyze data with charts, Microsoft PivotTable views and  more...

Excel 97 This course introduces students to the introductory, intermediate, and advanced aspects of Excel 97. It starts out teaching basic spreadsheet features and moves up to the most powerful aspects of Excel, such as adjusting default settings, creating views and custom toolbars, protecting worksheets, and applying passwords.  more...

Excel 97 Level 3 This advanced level course introduces the accomplished Excel user to the most powerful aspects of Excel. Some topics that will be covered include adjusting default settings; creating views and custom toolbars; protecting worksheets and applying passwords; and importing data from other applications.  more...

Access 97 Level 2 Students in this course will learn to master the more powerful aspects of Microsoft Access 97, including a variety of views, data types and field properties, and summary reports and mailing labels.  more...

Views on Organizational Change The way that you respond to your new job role, new responsibilities, or fresh procedures is unique to you. The way that you react to change is intensely personal. But, to a large extent, organizations change in predictable ways and for predictable reasons. Similarly, the ways in which people respond to change tend to follow predictable patterns. Being able to think of yourself as part of this  more...

Problem Performance Identification ...ightforward as it may at first sound. There are different views about the methods of identifying problem performance and a manager needs to be able to appreciate the differing points of view. Specifically the distinction between conduct and performance is crucial, because the responses to them need to be different. Another facet of the effective management of problem performance lies in  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 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...

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

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

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

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

Rational Application Developer Workbench To recognize the features of Rational Application Developer, set workbench preferences, and work with perspectives, views, and projects  more...

Project Server 2003 Enterprise Features and Views To implement Project Server 2003 Enterprise features and views  more...

Changing Corporate Culture ...ompany is a difficult task. It requires changing existing views and practices that until now have defined the workplace. You can overcome ingrained attitudes by learning how a diversity initiative differs from federal mandate, why some workers will object to the concept of diversity, and how to handle their opposition. This course describes the challenges of providing a climate of acceptance,  more...

Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention ...nce, 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: o Match the component of database storage with its definition. o Avoid dynamic  more...

Oracle9i Peformance Tuning Managing Memory and Disk I O This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the  more...

Oracle9i Performance Tuning Architecture Strategy ...rocess trace files. o Identify the functions of the DBA views used to provide data storage statistics. o Match the dynamic performance views with the statistics they provide. o Match the V$ views used to collect system-wide statistics with their functions. o Identify the factors taken into consideration in selecting the physical structure for data. o Match the index types with their  more...

Oracle9i Database Admin Manage an Instance ...This course also explains the various dynamic performance views and initialization parameters and the globalization support that is provided. Learn To • Identify the memory structures of the SGA and the information stored in the database and nondatabase files. • Identify the connection procedures and the processes generated during database connection. • Identify the  more...

Oracle9i SQL DML and DDL ...CREATE SEQUENCE statement. o Identify the properties of views. o Match the clauses of the CREATE VIEW statement with their functions. o Create a public synonym by using the CREATE PUBLIC SYNONYM statement. o Remove a synonym by using the DROP PUBLIC SYNONYM statement. o Identify the features of Oracle database security. o Create users in an Oracle database. o Match the types of  more...

SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries ... how to work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions. Learn To Identify advantages of using aliases for table names. Identify the guidelines for using joins. Identify the considerations for using inner joins. Identify considerations for using subqueries. Create a derived table by using a subquery. Create a  more...

SQL Server 2000 Design Implement Databases Part 3 Managing Objects ...s, and triggers. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different user-defined functions with their characteristics. Create a user-defined function by using Transact-SQL. Identify characteristics of schema binding. Identify the features of stored procedures. Identify the considerations  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum ...ting and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn how to apply this knowledge to developing DB2-based applications, including using application objects such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and dynamic SQL within an application. This  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum ...ting and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn how to apply this knowledge to developing DB2-based applications, including using application objects such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and dynamic SQL within an application. This  more...

IBM DB2 Universal Database V6 1--Fundamentals ...objects, ensure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). Manage database operations. C ontent Emphasis Skills-Based A udience This course is intended for database administrators and application developers. Students should have a fundamental understanding of relational database technology, including concepts of  more...

IBM DB2 Universal Database V6 1--Fundamentals ...objects, ensure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). Manage database operations. C ontent Emphasis Skills-Based A udience This course is intended for database administrators and application developers. Students should have a fundamental understanding of relational database technology, including concepts of  more...

IBM DB2 Universal Database V6 1 Admin Curriculum ...ting and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn how to plan, implement and maintain new and existing DB2 databases. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13432 IBM DB2 Universal Database V6.1 Administration  more...

IBM DB2 Universal Database V6 1 Admin Curriculum ...ting and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn how to plan, implement and maintain new and existing DB2 databases. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13432 IBM DB2 Universal Database V6.1 Administration  more...

GroupWise 5 5 Admin Part 1--System Fundamentals ...roupWise client. Identify the default GroupWise calendar views. Post an appointment. Schedule a group appointment. Create a Multi-User list. Create a task. Create a reminder note for another person. Create a folder using the GroupWise client. Link a message to a folder using the GroupWise client. Share a folder using GroupWise. Track the status of a message using GroupWise. Identify  more...

Oracle8i Backup and Recovery Strategies Backups ...eters in the init.ora file. Identify the data dictionary views used to obtain the archive log information. Unit 3: Oracle Recovery Manager Duration: 2 Hour(s) Select the features of Recovery Manager (RMAN). Start Recovery Manager by using the RMAN command. Identify the events that occur during the connection process after the RMAN command is executed. Select the situations in  more...

Oracle8i Performance Tuning Managing Memory Disk I O Course Overview This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...

Oracle8i Performance Tuning Architecture Strategy ...tistics using the dynamic troubleshooting and performance views. Diagnose statistics using the UTBSTAT/UTLESTAT output report. Identify appropriate OEM tuning tools. Use the available data access methods to tune the logical design of the database. List the primary steps for operating system tuning. Identify similarities between operating system and database tuning. C ontent  more...

Oracle8i Database Admin Create Databases ...ify and create a database. Identify the data dictionary views. Identify the data dictionary views to retrieve information. Identify the scripts to set up the PL/SQL environment. Identify control files Identify redo log files Identify tablespaces and data files. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network  more...

Lotus Domino R5 System Admin Part 1 Planning a Notes Domino Infrastructure ...rotocols, remote access connections and standard database views in Domino. L earn To: Identify the concepts related to the planning of a Notes/Domino infrastructure. Identify the concepts related to protocols, remote access connections and standard database views in Domino. C ontent Emphasis Skills-Based A udience This course series is for system administrators who  more...

Oracle Database 10g Administration Workshop II Part 4 ...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) architecture. Identify key concepts related to creating and accessing an Automatic Storage Management (ASM) instance. Identify features of Resource Manager. Identify key concepts related to  more...

Access 2000 Fundamentals ...of each Access 2000 database object. Identify the object views available in Access 2000. Print database objects. Create a new database in Access 2000. Access help on a specified subject by using the office Assistant. Unit 2: Access 2000 Tables Duration: 2 - 3 Hour(s) Create a table by using the Table Wizard. Create a table by using the Design view. Create a table by entering  more...

Oracle Reports R6 Enhance Reports ...ies of the Layout Model sections. Match the Layout Model views with their properties. Create a default layout for a report by using the Report Wizard. Sequence the steps to create a default layout for a section of the report by using the Report Wizard. Display the layout view for a report section by using the section option. Apply conditional formatting to a layout object by using the  more...

Oracle Reports R6 Report Fundamentals ...names, the Report Builder module types, the Report editor views, the different categories of objects available in a Report Module with their descriptions. Create a report using Report Wizard. Invoke the Reentrant wizard. Create Form Like, Break, Mailing Label, and Matrix types of reports using the reentrant Report Wizard. Modify reports in Live Previewer. Match report file types and  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention ...egment efficiency. Query the V$TRANSACTION and V$SESSION views to help estimate the volume of rollback data. Estimate the volume of rollback data. Identify actions that reduce the amount of rollback. Select the appropriate actions that increase the probability of successful completion when executing a large transaction. Adjust the configuration of your rollback segments to resolve the  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ...e function of the User Global Area. Match the diagnostic views of the Library Cache with their respective definitions. Perform the steps to determine the percentage of parse calls that find a cursor to share using GETHITRATIO column of the V$LIBRARYCACHE view Perform the steps to determine the reloads-to-pins ratio from the V$LIBRARYCACHE view. Identify the steps used to size the Library  more...

Oracle8 Performance Tuning Strategies and Techniques ...tistics using the dynamic troubleshooting and performance views. Diagnose statistics using the UTBSTAT/UTLESTAT output report. Identify appropriate Oracle Enterprise Manager (OEM) tuning tools. Use the available data access methods to tune the logical design of the database. List the primary steps for operating system tuning. Identify similarities between operating system and  more...

Oracle8 Network Administration Net8 Configuration and Troubleshooting ...rameters with their functions. Match the data dictionary views used to verify MTS setup with their contents. Sequence the steps involved in the Connection Pooling process. Identify the syntax of the init.ora parameter MTS_DISPATCHERS that needs to be configured to enable Connection Pooling. Unit 3: Connection Manager Duration: 2 Hour(s) Identify the benefits of the connection  more...

Oracle8 Backup and Recovery - Troubleshooting and Recovery ...a files needing recovery by using the dynamic performance views. Recover from an open database failure. Recover tablespace syntax. Identify the use of the v$datafile view. Recover a database from loss of data file that does not have a backup. Recover a failed database that had a file in hot backup mode. Identify the use of the v$backup view Recover from the loss of an online redo log  more...

Oracle8 Backup and Recovery - Strategies and Backups ... Manage the database archive processing. Identify the v$ views used for obtaining archive log information. Unit 3: Oracle Recovery Manager Duration: 2 Hour(s) Identify the features of Recovery Manager (RMAN). Identify the Recovery Manager components. Identify the features of Backup Manager. Identify the contents of a recovery catalog. Identify the situations when a recovery  more...

Oracle8 Database Administration - Manage Security Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and  more...

Oracle8 Database Administration - Manage Data ... for implementing clusters. Identify the data dictionary views to be used for retrieving specified information about clusters. Identify the data storage and retrieval features of an index-organized table. Identify the features of an index-organized table that distinguish it from a regular table. Create an index-organized table with an overflow area in a specified tablespace. Identify the  more...

Oracle8 Database Administration - Create Databases ...database after its creation. Unit 2 - Data Dictionary Views and Standard Packages Duration: 1 - 2 Hour(s) Identify the types of information stored in the data dictionary. Identify the features of the data dictionary components. Create a data dictionary view for a specific database by executing the appropriate script. Identify the contents of the data dictionary view categories.  more...

Oracle8 Database Administration - Manage an Instance ...e shutdown. Identify the features of dynamic performance views. Specify the associated dynamic performance view parameter for a given description. Display the current parameter values by using the V$PARAMETER dynamic performance view. Modify a dynamic initialization parameter by using the Oracle Instance Manager. Set up a restricted session to a database by using the Oracle Instance  more...

Oracle Report Builder Report Fundamentals ...names, the Report Builder module types, the Report editor views and the Data Model objects with their descriptions. Create a report using Report Wizard. Identify the features of Live Previewer. Modify reports in Live Previewer. Identify report file types. Match report file types with their portability limitations. Convert a .rdf file to a .rep file. Document a report using Report  more...

Lotus Notes R5 Managing and Sharing Information ...e, students will learn how to design and manage forms and views; search domains, address books and the Internet for information; automate routine tasks by using agents; browse the Web by using the Personal Web Navigator; manage Web pages in Lotus Notes; and subscribe to various databases to obtain information based on selection criteria. L earn To: Design and manage forms and views.  more...

Lotus Notes R5 Managing and Sharing Information ...e, students will learn how to design and manage forms and views; search domains, address books and the Internet for information; automate routine tasks by using agents; browse the Web by using the Personal Web Navigator; manage Web pages in Lotus Notes; and subscribe to various databases to obtain information based on selection criteria. L earn To: Design and manage forms and views.  more...

Lotus Notes R5 Messaging and Working Remotely ...e Databases bookmark folder. Match mail folders and mail views with their contents. Send a mail message. Attach a file to a mail message. Send a bookmark in a mail message. Preview a mail message in the preview pane. Reply to a mail message. Forward a mail message. Set up the Out of Office mail agent. Print a mail message. Open a mail attachment by using the options in the Attachment  more...

Lotus Notes R5 Messaging and Working Remotely ...e Databases bookmark folder. Match mail folders and mail views with their contents. Send a mail message. Attach a file to a mail message. Send a bookmark in a mail message. Preview a mail message in the preview pane. Reply to a mail message. Forward a mail message. Set up the Out of Office mail agent. Print a mail message. Open a mail attachment by using the options in the Attachment  more...

Lotus Notes R5 Collecting and Organizing Information ...ormatting options; and organize the workspace by managing views, folders and bookmarks. L earn To: Identify the different application types in Lotus Notes, the features provided for Lotus Notes mails and the features of Notes replication. Use Notes workspace to perform common tasks. Create and enhance documents using different formatting options. Organize the workspace by  more...

Lotus Notes R5 Collecting and Organizing Information ...ormatting options; and organize the workspace by managing views, folders and bookmarks. L earn To: Identify the different application types in Lotus Notes, the features provided for Lotus Notes mails and the features of Notes replication. Use Notes workspace to perform common tasks. Create and enhance documents using different formatting options. Organize the workspace by  more...

SAP R 3 Supply Chain Management ...Management'. The course is intended to show the different views regarding the supply chain in companies and its possibilities of use within different business areas. L earn To: What does Supply Chain Management mean? Supply Chain Management vision. Elements of the Supply Chain Management. Goals and possibilities. Solution starting points with SAP and examples for use.  more...

Oracle 11i10 Order to Cash Invoicing Overview ...a sources. Identify key concepts related to data source views. Identify key concepts related to Template Management. Identify key concepts related to template assignment rules. Identify key concepts related to print management. Unit 3: Customer Invoicing: Implementing Identify key concepts related to customer setup. Identify key concepts related to transaction setup.  more...

SAP R 3 v3 0 Information Systems within FI ...Accounts Receivable, Accounts Payable: define evaluation views. define evaluation types. Evaluate Accounts Receivable, Accounts Payable: specify the data volume. choose evaluations. create evaluations. display evaluations. Customize G/L Accounts: create forms. create reports. define valuation constants. Evaluate G/L accounts: balance sheet analysis: Fiscal Year comparison. use Key  more...

Outlook 2000 Proficient User ...dd an existing vCard to a message. Identify the built-in views in Contacts. Identify the customization options available for Contacts. Unit 2: Recording Tasks, Journals and Notes Duration: 2 - 3 Hour(s) Identify the elements of the Tasks interface. Create a single task. Create a recurring task. Edit a recurring task. Identify built-in views in Tasks. Identify the customization  more...

Outlook 2000 Fundamentals ...eadings. Set AutoArchive options. Identify the built-in views to filter the list of messages using the View menu. Apply a filter to a list of messages using the Filter dialog box. Change the default viewing options using the Other Settings dialog box. Identify the customization options available for Messages in the Options dialog box. Unit 3: Scheduling with Outlook 2000 Calendar  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 ...by using Joins. Access data by using Subqueries. Create views using by using SQL statements. Sequence the steps to access data from a remote server. Unit 2: Data Access: Multidimensional Structures Duration: 1 - 2 Hour(s) Match the components of a multidimensional schema with their descriptions. Identify the benefits of MDX SELECT statement as compared to SQL. Match the MDX  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 2 ... Microsoft Transaction Server (MTS), and the elements and views of the MTS Explorer interface. Manage and deploy packages in MTS. Implement security in MTS and SQL Server. C ontent Emphasis Skills-Based A udience This course is designed for programmers using Visual Basic 6.0 and are currently building desktop applications and accessing corporate databases. Participants should  more...

Visual InterDev 6 0 Implementing Server Technologies ...the features of MTS components; Identify the elements and views of Microsoft Transaction Server (MTS) Explorer; identify the guidelines for creating transaction objects; create a package, add a component to a package and set the component properties; implement declarative security for MTS; set package identity and security in MTS; and add mail and search services to a Web site. L earn To:  more...

Visual InterDev 6 0 Implementing Server Technologies ...the features of MTS components; Identify the elements and views of Microsoft Transaction Server (MTS) Explorer; identify the guidelines for creating transaction objects; create a package, add a component to a package and set the component properties; implement declarative security for MTS; set package identity and security in MTS; and add mail and search services to a Web site. L earn To:  more...

Visual InterDev 6 0 Building Web Sites and Pages ...h their descriptions. Identify the uses of the different views in the HTML Editor Window. Install FrontPage server extensions. Sequence the stages to deploy a Web project. Create a Web Project. Create a site diagram containing HTML and ASP pages. Create a hierarchical relationship among pages in a site diagram. Add site navigation to a Web page by using the PageNavbar Design-Time  more...

Quality Management The Quality Management Process Quality Management: The Quality Management Process offers the student an overview of the fundamentals of quality management, the costs of quality, and how to achieve quality through customer orientation. The program also outlines how to achieve daily quality management, identify variation in processes, and control costs. Learn To Identify the role of management in  more...

Microsoft FrontPage 2003 Proficient User ...ironment with their functions. Identify the Web editing views. Identify functions of the basic toolbar buttons. Identify methods for formatting text. Identify the different text alignments. Match the options in the Spelling dialog box with their functions. Create a hypertext link to a Web page. Create a bookmark on a Web page. Create an image hyperlink. Insert a layer in a Web  more...

Microsoft Project 2003 Fundamentals ...Calendar, and Outlining management, manipulation of data, views and reports, and project updating, tracking, and conflict resolution. Learn To: Match Microsoft Project 2003 products with their features. Identify component parts of the Microsoft Project 2003 interface. Identify options in the New Project task pane. Identify predefined filters. Create a custom filter. Identify  more...

Oracle Workflow 11i10 Communications Function Activities ...ult. Identify options provided by the directory service views. Identify features of various local directory service tables. Load roles in Oracle Workflow Builder. Audience: The target audience is functional and technical consultants and end-users who have knowledge of Oracle 9i, SQL, and programs within PL/SQL. Deployment: Self-Study Accreditation CEU credits: 0.40  more...

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

Oracle Database 10g SQL Fundamentals I Part 2 ...for altering and dropping a table. Identify features of views. Identify syntax for performing various tasks for managing views. Identify the syntax for creating a sequence. Identify the syntax for modifying a sequence. Identify the syntax for creating and dropping synonyms. Identify features of indexes. Identify the syntax for creating and dropping indexes. Identify features of  more...

Oracle Database 10g Administration Workshop II Part 2 ... by Enterprise Manager (EM). Match various RMAN dynamic views with their functions. Sequence the steps that are performed to monitor an RMAN backup. Unit 2: Diagnostic Sources and Recovery Identify features of the alert.log file. Identify features of alerts. Identify options that enable you to configure alerts. Identify key concepts related to trace files. Identify the  more...

Oracle Database Administration Workshop I Part 2 ... a table using Enterprise Manager. Identify features of views. Identify features of sequences. Identify features of SQL statements used in data manipulation. Identify tasks for exporting data using the Data Pump utility. Identify features of data import using the Data Pump utility. Identify features of SQL*loader. Identify features of SQL* Loader control files. Identify features  more...

SAP R 3 v4 0 MM Warehouse Management ...ent master data. Creating storage bins. Material master views. Stock placement/removal. Transfer requirements. Unit 2: Stock Movements Duration: 1 - 2 Hour(s) External goods receipt. Goods movements for production. Confirming transfer orders. Goods issues for sales orders. Picking for a delivery. Manual WM procedures. Creating transfer requirements. Transferring stock.  more...

Oracle SQL Specifics Creating and Managing Database Objects ...o control transactions. Learners will create and maintain views, sequences, indexes and synonyms. Additionally, users will learn how to control database access, add new users, and provide alternative names for objects using synonyms. Finally, participants will learn how to format query output, control the SQL*Plus environment, and specify variables at runtime. L earn To: Create and  more...

Oracle SQL Tuning Diagnostics and Tuning Schema ...rience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash clusters. Participants will then be able to test the results of their tuning efforts using performance analysis tools. L earn To: Identify the need and areas for tuning the performance of SQL statements. Identify tuning steps. Identify the tools that help  more...

PowerPoint 2000 Proficient User ...ey enable you to perform. Navigate between the different views by using the view buttons. Access help on a topic by using the Office Assistant. Customize the Office Assistant. Create a customized toolbar. Set custom options. Unit 2: Creating a Presentation Duration: 1.5 - 2 Hour(s) Create a presentation by using the AutoContent Wizard. Create a presentation from a design  more...

SQL Server 7 0 System Administration - Part 2 ... of planning security for linked databases. Identify how views and stored procedures can be used to simplify security. Distinguish between application roles and other roles. Perform the steps for creating an application role for users/logins within SQL Server Enterprise Manager. Perform the steps for activating an application role for users/logins using Transact-SQL. Identify the  more...

SQL Server 7 0 - Implementing a Database - Part 4 ...tion levels. Identify the purpose and benefits of using views. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474) and the first three courses in this  more...

Visual InterDev 6 0 Building Web Sites and Pages ...h their descriptions. Identify the uses of the different views in the HTML Editor Window. Install FrontPage server extensions. Sequence the stages to deploy a Web project. Create a Web Project. Create a site diagram containing HTML and ASP pages. Create a hierarchical relationship among pages in a site diagram. Add site navigation to a Web page by using the PageNavbar Design-Time  more...

Microsoft Works Suite 2005 Creating Databases ...mentals such as the Works Database interface and database views. Learn To: Identify components of the Works Database interface. Create a database from an existing template. Identify the steps to create a blank database. Audience: A home computer user with basic to intermediate skills and wants to use a personal computer competently and as a productivity tool. Deployment:  more...

Lotus Domino R5 System Admin Part 9 Managing a Notes Domino Env ...abbed pane that perform specific functions. Identify the views in the Task pane of the Replication tabbed pane that perform specific functions. Identify the options in the Task pane of the Configuration tabbed pane that perform specific functions. Identify the option in the Tools pane of the People & Groups tabbed pane that will be used in a specified scenario. Identify the option in the  more...

Lotus Notes R5 System Admin Part 10 Monitoring a Notes Domino Env ...erformance Monitor window. Match various Server log file views with the situations in which the information contained in them is used. Search the Domino Server log file for specific information by using Domino Administrator. Unit 2: Statistics and Events Duration: 1 - 2 Hour(s) Configure the Server Statistic Collection document by using Domino Administrator. Create a Domino system  more...

SQL and PL SQL DML and DDL ...lter tables and constraints. Create sequences. Create views. Create indexes. Manage system privileges. C ontent Emphasis Skills-Based A udience Application Developers, Database Administrators, Designer/Developers, System Analysts, and Technical Support Professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and  more...

Programming XM XML Parsing ... the editing capabilities in XML Editor Source and Design views. Unit 2: XML Parsers (1.5 - 2 hours) Identify functions of XML parsers. Differentiate between Document Object Model (DOM) and Simple API for XML (SAX) parsers. Identify considerations for using Java when creating an XML application.  more...

Project 2000 Proficient User ...g a template to create a new project. Customize tables, views, groups, outlines, filters, timescales, bar styles, custom forms, and the accessibility and user options. Track projects and customize Project Central. C ontent Emphasis Skills-Based A udience This course is intended for end users that use the fundamental capabilities of Microsoft Project 2000. Participants should  more...

Oracle Database 10g Administration Workshop II Part 1 ...s of linguistic sorts that can be customized. Match the views used to obtain parameter information with their descriptions. Distinguish between different types of character set scanner utilities. Identify key concepts related to data conversion between client and server character sets. Identify key concepts related to data conversion done using Oracle utilities. Identify key concepts  more...

Oracle Database 10g New Features for Administrators Part 1 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers the new features of Oracle Database 10g that are applicable to database administration. The features include Manageability concepts, Grid computing, enhanced installation features, configuration and performance  more...

IBM DB2 Universal Database V6 1--Fundamentals ...objects, ensure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). Manage database operations. C ontent Emphasis Skills-Based A udience This course is intended for database administrators and application developers. Students should have a fundamental understanding of relational database technology, including concepts of  more...

IBM DB2 Universal Database V6 1--Fundamentals ...objects, ensure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). Manage database operations. C ontent Emphasis Skills-Based A udience This course is intended for database administrators and application developers. Students should have a fundamental understanding of relational database technology, including concepts of  more...

Frontpage XP Proficient User ...features of FrontPage 2002. • Match FrontPage 2002 views with their purposes. • Create a one-page Web site. • Create a Web page by using a template. • Save a Web page for the first time. • Identify features of a Web site wizard. • Create a Web site by using a template. • Preview a Web site. • Move files to organize a Web site in Folders  more...

Frontpage XP Proficient User ...features of FrontPage 2002. • Match FrontPage 2002 views with their purposes. • Create a one-page Web site. • Create a Web page by using a template. • Save a Web page for the first time. • Identify features of a Web site wizard. • Create a Web site by using a template. • Preview a Web site. • Move files to organize a Web site in Folders  more...

PowerPoint XP Proficient User Course Overview This course presents the learner with the skills to become proficient at Microsoft PowerPoint 2002. This course guides the learner through the basics of PowerPoint presentations with the emphasis on learning by doing. Learners will be presented with topics such as creating and modifying presentations. The course will also cover adding graphics to presentations and preparing a  more...

Windows XP Prof User Fundamentals ...lder tasks in Windows XP. o Identify features of folder views in Windows XP. o Match new features of Internet Explorer with their functions. o Identify new features of Outlook Express. o Identify features of the Add Network Place Wizard. Audience The intended audience for this course is anyone who is familiar with and has a basic mastery of any other Windows operating system.  more...

Database Technologies Introduction to SQL ...OMMIT and ROLLBACK). o Identify the general overview of views and indexes, including how to create these database elements. Audience Associate database administrators, technical support consultants, and associate programmer/analysts are some of the types of people who would benefit from this course. This course is intended for people who are relatively new to the world of corporate IT and  more...

Project 2002 Fundamentals ...eals with filtering, grouping, sorting, working with task views, project baselines, and how to track and update projects. Learn To: o To match Microsoft Project 2002 products with their features. o To identify new features in Microsoft Project 2002. o To identify component parts of the Microsoft Project 2002 interface. o To identify types of task relationships in Microsoft Project  more...

Works 2003 Creating Databases ... a blank database. Match Database views with their functions. Save data. Sort data. Identify options in the Filter dialog box. Insert a field in an existing database. Enter data in a form. Identify options in the Format dialog  more...

Lotus Domino Designer 6 Preparing Domino R4 Developers ...rms in Designer 6, including tables, fields, actions, and views. Learn To: o To match Domino 6 clients with their functions. o To match components of the Notes client interface with their functions. o To match Domino Designer 6 Client interface elements with their functions. o To match table types with their characteristics. o To create a nested table. o To create a tabbed table.  more...

Access 2003 Fundamentals ... To identify functions of database object views. To identify options in the Table Wizard. To identify table field properties. To create an input mask for a table field. To identify options in the Lookup Wizard. To identify options in the Simple  more...

Word 2003 Proficient User ... Learn To To match document views with their features. To identify options for arranging windows. To identify options for inserting a table in Word. To identify research options in Word. To identify options in the Insert Hyperlink dialog box.  more...

PowerPoint 2003 Fundamentals ... To match types of PowerPoint views with their functions. To identify methods for adding text to slides. To identify options for adding an AutoShape to a slide. To identify methods for modifying an AutoShape. To add WordArt to a slide.  more...

Microsoft Project 2003 Proficient User ...iciency-level skills, i.e. advanced management of Tables, Views, and Reports, the customization, automation, and exchange of data, Project consolidation and collaboration, and Project Server and Project Web Access. Learn To: Identify features of earned value tables. Create a custom table. Identify options for manipulating custom fields. Create a consolidated project. Identify  more...

Lotus Notes Domino R5 Development Part 1 Basic Concepts ...Hour(s) Identify the contents of the mail folders and views in Notes R5. Send a Notes R5 message with a return receipt. Enable the out of office agent in Notes R5. Create a calendar entry by using the Welcome page. Create a group calendar entry by using the Calendar pane. Unit 3: Working with Domino Databases Duration: 2 Hour(s) Match the components of a Domino database with  more...

Programming XML XML Parsing ... the editing capabilities in XML Editor Source and Design views. Unit 2: XML Parsers (1.5 - 2 hours) Identify functions of XML parsers. Differentiate between Document Object Model (DOM) and Simple API for XML (SAX) parsers. Identify considerations for using Java when creating an XML application.  more...

Oracle Database 10g PL SQL Fundamentals Part 2 This course introduces learners to PL/SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers. Learn To: Identify features of PL/SQL blocks within a subprogram. Match types of PL/SQL named blocks  more...