SQL Functions in Oracle 9i To describe how to use SQL functions for data retrieval Junior database administrators, application developers, and database operators more...
Development Platform in Oracle9i To explain the Oracle9i database enhancements that support the Oracle9i database development platform Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database more...
e-Mail and Browsing During the last century, the telecommunications industry underwent many technological changes that improved the way in which we interact with each other. However, if we measure the impact of all these technologies, the Internet has certainly had the maximum effect on our communication methods. The Internet enables a number of people to access and use certain resources at the same time. It provides more...
Adobe Illustrator CS2 Designing This course teaches fundamental concepts and skills for working with Adobe Illustrator CS2 to enhance artwork. The topics in this course cover commands and tools available in Illustrator to create enhanced illustrations by using paths, masks, text, and typography in the artwork. The course is intended for the basic end user who wishes to use Adobe Illustrator CS2 to construct vector illustrations 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...
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...
Oracle9i SQL: Data Retrieval Techniques This course covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries. more...
MS Access 97 This course is easy to use whether you are a new or experienced user. Effectiveness is our number-one priority in developing our tutorials. Instructions are presented in easy to understand graphical formats instead of just on screen text; applications simulations offer realistic practice opportunities; and interactive exercises keep people engaged throughout the lesson. more...
MS SQL Server 6.5: Advanced Retrieval Structures In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of SQL Server. This course, together with MS SQL Server more...
Oracle9i SQL Data Retrieval Techniques ...joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries. Learn To: o Identify the four Oracle join types used to display data from more than one table. o Identify a more...
IBM DB2 Universal Database V6 1--App Development ... Hour(s) Combine data from two or more tables using a join. Combine two queries into a single result table using set operations. Retrieve data in a restricted condition using a subquery. Retrieve data with referenced values using a correlated subquery. Retrieve data using scalar functions. Retrieve summarized data for groups using grouping functions. Create different levels of more...
IBM DB2 Universal Database V6 1--App Development ... Hour(s) Combine data from two or more tables using a join. Combine two queries into a single result table using set operations. Retrieve data in a restricted condition using a subquery. Retrieve data with referenced values using a correlated subquery. Retrieve data using scalar functions. Retrieve summarized data for groups using grouping functions. Create different levels of more...
Windows NT 4 0 Cluster Server Wolfpack - Part 1 Course Overview
This course is the first part of a two part series that will provide participants the knowledge to install, configure, integrate, optimize and troubleshoot clustering technologies for Microsoft Windows NT 4.0.
L earn To:
Understand the definitions of clustering terms and the benefits of clustering.
Identify the functions of the Cluster Service Manager and the more...
Windows NT 4 0 Cluster Server Wolfpack - Part 1 Course Overview
This course is the first part of a two part series that will provide participants the knowledge to install, configure, integrate, optimize and troubleshoot clustering technologies for Microsoft Windows NT 4.0.
L earn To:
Understand the definitions of clustering terms and the benefits of clustering.
Identify the functions of the Cluster Service Manager and the more...
Access 2000 Expert User ... a query. Filter records in a query. Change the type of join between two tables in a query. Remove the join between two tables in a query. Optimize a query by indexing the table on a field. Unit 2: Access Forms Duration: 1 - 2 Hour(s) Create a form by using the Design view. Customize the form sections by using the Design view. Set the properties of a section in a form by using more...
Oracle8 Performance Tuning Managing Memory and Disk I O ...cteristics of a star query.
Sequence the steps of a hash join process when a hash join is built.
Use the EXPLAIN PLAN statement to explain the plan for a query.
Perform the procedure to set trace up at the session level to look at the performance of a plan.
Perform the steps to use TKPROF to report the trace statistics in readable form and interpret the output file.
Perform the procedure more...
Professional Selling Over the Phone Preparation Strategies ...l clients, you need to write a telesales script. You will join your team in a meeting and follow the steps for writing an effective telesales script. Unit 2: Communication Essentials for Telesales (0.5 - 1 hour) Select qualities of an effective teleselling voice. Identify listening techniques that can improve your teleselling performance. more...
Oracle SQL Specifics Retrieving and Formatting Data ...r.
Use the ORDER BY clause to sort query results.
Use a join to query data from multiple tables.
Use an outer join to return records without a direct match.
Identify the features of the SQL*Plus environment.
Log in to SQL*Plus.
Use the DESCRIBE command to display the structure of a table.
Match SQL*Plus editing commands to their descriptions.
Match SQL*Plus file commands to their more...
Oracle SQL Tuning Tuning SQL and the Optimizer ...data for a specific column in a table.
Match the various join methods with the situation in which they are used.
Match the data retrieval methods available to the optimizer with their features.
Match the access path hints with the optimizer functions they enable.
Specify a hint for the FULL access path in a given query.
Sequence the steps in preparing for a star query.
Identify the hint more...
SQL Server 7 0 - Implementing a Database - Part 3 ... properties of a SELECT statement. Select the uses for a join. Perform the steps to combine tables. Perform the steps to combine table data. Select the statement that combines table data. Perform the steps to combine data from more than two tables. Select the statement that joins a table to itself. Identify the characteristics of the UNION operator. Perform the steps to create a single more...
SQL and PL SQL Data Retrieval Techniques ...scribes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition, how to use SQL*Plus commands to build on basic SQL statements and create customized queries that retrieve the information and display it in a more...
Oracle Database 10g New Features for Administrators Part 2 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 new features of Oracle Database 10g such as automatic management, manageability infrastructure, and application tuning and monitoring.
Learn To:
Identify features of Automatic Database Diagnostic Monitor more...
Oracle SQL for End Users--Part 2 ...e learner displays data from multiple tables by using equijoins, non-equijoins, and self joins. In addition, this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers how to embed subqueries in SQL statements. Finally, the learner creates interactive reports by using substitution variables, and more...
Access XP Expert User ...riterion query by using a form control. Change a join type in a query. Unit 2: Forms Enhancements 1 - 2 hours Create a form in Design view. Modify section properties in a form. Create a subform with the Form Wizard. Add a subform to an existing form. Create a switchboard form by using the Add-In tool. Identify database more...
MS Win XP Install Admin Part 2 Networks Desktops ...Connection Firewall (ICF) in Windows XP Professional. o Join a computer running Windows XP Professional to a domain. o Join a computer running Windows XP Professional to a domain. o Identify features of joining a domain when running Windows XP Professional. o Identify features of joining a domain when running Windows XP Professional. Unit 3: Configuring the Desktop Environment 2 more...
Call Center Mgt Managing an Inbound Call Center ...elmed with the high number of calls from women wishing to join the organization. As a business consultant for Icon, it is your task to identify the needs of the WCAA and explain the benefits of a call center. Unit 2: Establishing the Call Center's Structure (0.5 - 1 hour) Select building considerations. Identify types of call center layouts. more...
ISO 9001 2000 The Auditing Process In ISO 9001:2000: The Auditing Process you learn about the fundamentals of the auditing process for ISO 9000: 2000. It explains the basic audit procedures and requirements as well as the importance of starting and closing the audit in the correct fashion. Learn To Identify features of a quality audit. Identify features of an audit more...
HIPAA Privacy Health Care Employees ...onsibility to update the staff on HIPAA and has agreed to join this meeting. You have attended a number of informative HIPAA seminars, but you will require several more training sessions before you are certified by HIPAA. Unit 2: HIPAA Privacy Rule (0.5 - 1 hour) Identify the purposes of the Privacy Rule. Identify what the Privacy Rule requires more...
Team Conflict Resolving Team Conflict ...stant Project manager for the VCS, you have been asked to join the meeting to help identify why the team isn't making much progress. You will want to identify and address any conflict that is present within the team. Unit 2: Clarifying Team Conflict (0.5 - 1 hour) Identify different types of team conflict. Identify the effects of destructive and more...
Product Coach Course The Virtual Bar Coach is an industry endorsed training program delivered on CD-Rom so that you and your staff can learn at work when it suits. The programme equips staff with comprehensive knowledge about the drinks they serve. Join Sam as he travels the globe to the countries where each of the popular spirits categories was born. Experience the culture, characters and products with Sam on his more...
FileMaker Pro 8 Expert ...ses a calendar example to demonstrate FileMaker Pro theta join relationships, complex calculations and sophisticated scripting techniques. Moreover, relationships, calculations, scripts and other features are combined to show the true power of a FileMaker solution. Even if you don't want to create a calendar, this tutorial will teach you techniques you can use in any solution. Examples of the more...
Blogging Blogging! Although in 1999 there were fewer than 100 weblogs known to be in existence, nowadays one is hard-pressed to miss a blog anywhere on the Internet. In this VTC tutorial, master instructor, Tim Warner, presents a comprehensive introduction to the world of blogging. From the history of blogging, to an overview of relevant terminology, to an in-depth consideration of three major more...
Corel Painter 8 Corel Painter 8 is a natural media emulation tool. It allows users to create digital images and artwork that appear to be created with traditional sketch and painting tools. Painter 8 has over 400 brushes and 30 mediums to work with. The user can also create their own brushes. Experiment with life-like media such as Digital Water Color or create sketches from photographs. It's no wonder Painter is more...
Digital Performer 2 7 Digital Perf ormer is an integrated audio and MIDI sequencing production system. Join Phil Slade as he guides you through Performer 2.7. He begins by helping you set up, taking you through the windows, and teaching the basic commands. He then moves on to the good stuff- recording and editing audio. Start learning today! To get started, simply click one of the topics below. more...
Maxon Cinema 4D XL6 Cinema 4D XL 6 for the Mac and PC enables users to work seamlessly between the two platforms. This extremely fast 3D modeling, animation, and ray-tracing program allows the opportunity to work within an object-oriented and multi-threaded architecture. Join 3D expert Matt Neutra in this powerful program from Maxon Computer as he teaches you the configuration, menus, and workflow. Become more more...
auto des sys form Z 3 9 AutoDesSys FormZ is a 3D modeling application that incorporates drafting and rendering. It's the perfect tool for architects, landscape architects, engineers, product and interior designers, illustrators, and animators, whether they are mature users or novices. FormZ combines solids and surface modeling so users can create any form, real or imaginary. The highly interactive interface allows the more...
3D Studio Max 4 3D Studio Max for Windows is the world's best-selling, professional 3D modeling, animation and rendering software for creating visual effects, character animation and next generation game development. Join Adam Beare as he takes you from the basics, such as introducing the interface, viewports, the main tool bar, pop menus and controls, to more complicated material such as modeling using geometry, more...
Netware 5 Admin Novell Unmatched performance, security, and reliability, Novell NetWare 5 has the tools needed for today's e-business and web-based network solutions. Open architecture standards allow fast, secure integration. Join Professor Louis DiPaola as he shows you the "nuts and bolts" of this system software. He will give useful knowledge such as how to manage users, file system security, login scripts, and the more...
Forex Trading course StraightForex provides a high quality forex trading course.
Amongst the most important characteristics of our course are:
- Online accesible course
- 15 lessons covering the most important aspects of trading
- Access the course at the convenient time for you
- A complete lesson on our consistent system
- One hour is required to go through each lesson
Take this important step and join us today more...
E-mail and Browsing The E-mail and Browsing WBT is meant for end users. It aims to teach the basic concepts of a browser, and the usage of Internet Explorer 5. 0, which is one of the most commonly used browsers. The course also provides an overview of the commonly used e-mail software, Outlook Express.
Describe different Internet Services
List the requirements for connecting to the Internet
Identify the features more...
A+ Module 2 - Windows 98 At the end of this course you will be able to: install Windows 98, understand and troubleshoot the Windows 98 boot process, navigate files and folders and change view settings, view and configure system and Desktop settings, understand and configure different file system settings, run and troubleshoot DOS, 16-bit and 32-bit applications, understand the functions of the Registry, make changes to more...
A+ Syllabus 10 - Module 2 - Windows 98 At the end of this course you will be able to: install Windows 98, understand and troubleshoot the Windows 98 boot process, navigate files and folders and change view settings, view and configure system and Desktop settings, understand and configure different file system settings, run and troubleshoot DOS, 16-bit and 32-bit applications, understand the functions of the Registry, make changes to more...
digital video editing I Ready to make digital videos? Editing film and video is about movement, choreography, the play of light, color, and graphics. And beyond all that, it's all about psychology.
In this 6-lesson course, you'll learn the art and craft of editing videos from two award-winning filmmakers. The course explores techniques that can be applied in a range of non-linear editing programs, including Avid, Finalmore...