Online Statement eLearning - Training Resources

Systems Requirements Analysis and Design Writing Learn how to effectively write business requirements for systems analysis and design. This course is for both technical and non-technical professionals who will need to gather and write business and technical requirements for the purposes of systems analysis and eventual systems design and implementation. Modules covered include: ?Introduction to Requirements Writing and Writing Tips  more...

QuickBooks Pro 2005 ...x issues, task management, classifying transactions, bank statement reconciliation and more. Learn one-on-one with one of the industry's foremost experts on Intuit products, Matt Harward. Matt has been training and consulting on computer software and hardware for over 10 years. He has been an official corporate presenter for Novell, HP, IBM, Compaq, and Lucent Technologies. He is formally  more...

QuickBooks Pro 2006 ...x issues, task management, classifying transactions, bank statement reconciliation and more. Learn one-on-one with one of the industry`s foremost experts on Intuit products. Course Instructor: Matt Harward. Matt has been training and consulting on computer software and hardware for over 10 years. He has been an official corporate presenter for Novell, HP, IBM, Compaq, and Lucent Technologies.  more...

Preventing Sexual Harassment for Leaders ...thers. It also includes an example of an effective policy statement. IMPORTANT NOTE: INTERNET EXPLORER (IE) BROWSER REQUIRED - can`t use Netscape or other browsers for this training. Leaders have a particular responsibility in preventing sexual harassment, and this course spells out just exactly what their role is. They will be given critical information to tell them what the law expects and  more...

Business Ethics Conduct Policy Statements ...s widely agreed that every company needs to have a policy statement on legal and ethical conduct. The Organizational Sentencing Guidelines require that a company "must have taken steps to communicate effectively its standards and procedures to all employees and other agents, e.g., by requiring participation in training Courses or by disseminating publications that explain in a practical manner  more...

Build Your Own BIZ(tm) - Better Budgeting This course will help you gain an overall understanding of the budgeting process. You will receive as a bonus 1 year unlimited access to this course from the day of enrollment. If attempting to accelerate your learning (1-2 weeks or less), please pay special attention to key points so you may successfully apply the information gained from this course to your particular business situation. Create  more...

Basic Internet Specialist Certificate Designed to help people learn more about the Web including terminology, finding information, and creating effective websites that sell. Designed to help people learn more about the Web including terminology, finding information, and creating effective websites that sell. Students will learn how to deal with customers concerns, and the best way to provide support. Students will also learn how to  more...

Accounting In An Hour ...d profitability? What is the difference between an Income Statement and a Balance Sheet? If you?re unsure about even one of those questions, that confirms you?re not able to contribute as well as others at meetings where finance is discussed. You?ll never be counted on to give a meaningful financial opinion?and that relegates you to second-tier status in the minds of your colleagues and  more...

Preparing for Inbound Sales Calls Do you think selling means waiting for the phone to ring? A successful inside sales agent begins planning long before the customer calls. Successful inside selling is all about being prepared, and that means thinking ahead on customer inquiries and responses you will give. This course identifies the common perceptions that customers have of salespeople. In the course, you will learn the three  more...

Leading a Customer-focused Team ... parameters for what has to be accomplished by creating a Statement of Purpose and effective team goals. Once these have been established, your role as leader becomes that of enabler and the rest of the course is devoted to demonstrating how you can manage and support the team's performance.In the second lesson you'll learn how to measure the elements of performance that impact on customer  more...

The Dynamics of Interacting ...olutely fundamental qualities of success." To make such a statement, John J. McGuirk was probably inspired by a direct experience that he had in dealing with other people. Based on your own experience, would you agree that interacting with others is connected to success? Think of a time when you got the results that you wanted. Can you also recall the quality of your interaction in that  more...

Negotiating Inclusively ...s? What if your ability to interpret a certain gesture or statement is inaccurate? Can you suppose how this situation might go sour during the negotiating process? Inclusive Negotiating is about becoming familiar with both the similarities and the differences among different types of people. In this course, you will explore the cultural characteristics of negotiators from around the globe. You  more...

Making Decisions Dynamically ...our decisions determine your life. Nowhere is this simple statement so unabashedly evident as in today's business world. Made consciously or unconsciously, your decisions represent the fundamental tool you use in facing the opportunities, challenges, and uncertainties of life. It's not a case, however, of "make a decision, any decision." The increased complexity and competition of the 21st  more...

Initiating a Project and Preparing the Project Plan ...evelop Project Charter, Develop Preliminary Project Scope Statement, and Develop Project Management Plan. Through interactive learning strategies and real-life scenarios, the learner will explore these concepts and gain a better understanding of the project integrative processes in action. This course is aligned with "A Guide to the Project Management Body of Knowledge" (PMBOK?? Guide) - Third  more...

Planning Project Scope Project scope management is concerned with ensuring that projects include and account for all the work needed for the successful completion of a project. Successful project managers use project scope management throughout the project life cycle to identify and control all aspects involved in a project. This course will highlight the importance of project scope management to project performance.  more...

Using Control Structures To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct  more...

Six Sigma DMAIC Defining the Problem "What's your problem?" It could be said that this is one way to get to the heart of a matter. Of course, there's a better way. In this course, Six Sigma DMAIC: Defining the Problem, Six Sigma Green Belts and team members are given a systematic, objective, and measurable process for quantifying the challenges facing your organization. In lesson one, "The Project Charter," you'll learn guidelines  more...

Analyzing an Annual Report This course will familiarize business managers, financial professionals, and other business professionals with methods to extend their analysis of financial statements beyond the three basic reports: the Balance Sheet, Income Statement, and Cash Flow Statement. The course begins by analyzing two accounting features often identified in the notes to the financial statements: the cost of goods sold  more...

Analyzing the Income Statement and Balance Sheet This course examines the Income Statement and the Balance Sheet, their respective structures and relationships as they correlate to business activities, and introduces common methods of analysis when using these financial statements to measure a business's financial performance.  more...

The Income Statement and Balance Sheet Connection This course examines in detail the relationship between the Income Statement and the Balance Sheet, how the line items on each statement relate to the other and correlate to business activities and decision-making. The course introduces common methods of analysis when using these financial statements to measure a business's financial performance.  more...

Analyzing Cash Flow Would a family survive if it didn't know where its available cash was coming from, how much cash it had to spend, or how to get more cash for its needs? If you answered no, you are right. Just like a family that has to understand cash issues for survival, a business also has to understand information about its usable cash in order to sustain its life. This course will teach you how to read, and  more...

Analyzing Cash Flow Statements ... business decision; by analyzing your company's financial statements. They contain information that can help you improve your company's efficiency and overall effectiveness. Cash flow statement analysis focuses on determining your company's ability in the following four areas: (1) ability to meet short-term obligations and to efficiently generate revenue, (2) ability to generate future revenues  more...

Financial Statements ...statements to report their performance and their financial condition to investors and lenders. Managers--including non-financial managers--can use these statements to understand how the organization is doing: Are any changes needed? Can the organization improve? How quickly is the organization growing in comparison with its competitors? Are there any financial danger signs? This course provides  more...

Oracle9i Peformance Tuning Managing Memory and Disk I O ...rning Time 6 to 8 hours 64332 Objectives Unit 1: SQL Statement Tuning 1 - 2 hours o Match the optimizer modes with their descriptions. o Match the OPTIMIZER_MODE parameter values with their description. o Identify the methods of creating stored outlines. o Set the value of the USE_STORED_OUTLINES parameter. o Match the values of the USE_PRIVATE_OUTLINES parameter with their  more...

Oracle9i SQL DML and DDL ...vering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table. The course also explains the use of external tables and how to  more...

Oracle9i SQL Data Retrieval Techniques ... Identify the features of a group function. o Write SQL statements that contain common group functions. o Manage null values when using group functions in a SQL statement. o Identify the requirements for using subqueries. o Identify the characteristics of each subquery type. o Write a single-row subquery to return one row in the WHERE clause of a SELECT statement. o Identify the  more...

Oracle9i SQL Basic SELECT Statements ...atabase principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. Learn To: o Identify the components of the relational model. o Match the structural  more...

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

Java Operations Flow Control ...tors. In the Flow Control unit, the course covers various statements used to implement conditional as well as iterative flow control. Learn To: Identify code that performs different types of data type conversions for primitive data types. Identify code that performs data type casting on primitive data types. Identify associativity and precedence rules for operators. Identify the  more...

Java Operations Flow Control ...tors. In the Flow Control unit, the course covers various statements used to implement conditional as well as iterative flow control. Learn To: Identify code that performs different types of data type conversions for primitive data types. Identify code that performs data type casting on primitive data types. Identify associativity and precedence rules for operators. Identify the  more...

IBM DB2 Universal Database V6 1--App Development ...mas for table design and index design. Code combined SQL statements using compound SQL. Create a local temporary table that can be referenced in an SQL statement using a common table expression. Retrieve data with logical conditions using a CASE expression in a given scenario. Unit 2: Application Development Objects Duration: 1 - 2 Hour(s) Identify valid DB2 object names. Control  more...

IBM DB2 Universal Database V6 1--App Development ...mas for table design and index design. Code combined SQL statements using compound SQL. Create a local temporary table that can be referenced in an SQL statement using a common table expression. Retrieve data with logical conditions using a CASE expression in a given scenario. Unit 2: Application Development Objects Duration: 1 - 2 Hour(s) Identify valid DB2 object names. Control  more...

IBM DB2 Universal Database V6 1--Administration ...ons. Construct a table space using the CREATE TABLESPACE statement. Choose the required number of containers given a scenario. Construct a buffer pool of a specified page size using the CREATE BUFFERPOOL statement. Select the effects of a CREATE DATABASE statement. Select data placement attributes given the system catalogs. Construct the appropriate type of index using the CREATE INDEX  more...

IBM DB2 Universal Database V6 1--Administration ...ons. Construct a table space using the CREATE TABLESPACE statement. Choose the required number of containers given a scenario. Construct a buffer pool of a specified page size using the CREATE BUFFERPOOL statement. Select the effects of a CREATE DATABASE statement. Select data placement attributes given the system catalogs. Construct the appropriate type of index using the CREATE INDEX  more...

IBM DB2 Universal Database V6 1--Fundamentals ...e effects of table check constraints given a CREATE table statement. Identify characteristics of a trigger. Analyze data modification instructions to determine whether DB2 applies referential constraints given referential constraint definitions. Unit 3: Basic Structured Query Language Usage Duration: 2 Hour(s) Display data using a SELECT statement. Specify rows to be retrieved  more...

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

Oracle PL SQL Procedures Functions Packages ...) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Subprograms: Procedures Duration: 2 - 3 Hour(s) Match the various sections of a subprogram with their contents. Identify the components of developing environments. Identify the steps to  more...

Oracle8i Backup and Recovery Troubleshooting Recovery ...uration: 1 - 2 Hour(s) Identify the ways of resolving statement failure. Identify the causes of statement failure. Identify the ways of resolving user process failures. Identify the causes of user process failures. Identify the ways of resolving user error failures. Identify the causes of user error failures. Identify the recovery process in an instance failure. Identify the causes  more...

Oracle8i Performance Tuning Managing Memory Disk I O ... Explain the plan for a query by using the EXPLAIN PLAN statement. Inspect the performance of a plan by setting up trace at the session level. Match the TKPROF options with their respective descriptions. Generate an execution plan at the system level for a SQL statement by using AUTOTRACE. Identify the characteristics of optimizer modes. Set the optimizer mode at the session level by  more...

Oracle8i Database Admin Manage an Instance ...s should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023. T otal Learning Time 6 - 8 Hour(s) Course Contents  more...

Oracle Reports R6 Control Reports ... following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). In addition, participants should have taken the first two parts in this series: Oracle Reports:  more...

Oracle Form Builder R6 Writing and Debugging Code ...valent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first two parts of the Oracle Developer series: Oracle  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ... 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 to generate an execution plan at the system level for a SQL  more...

Oracle8 Backup and Recovery - Troubleshooting and Recovery ...uration: 1 - 2 Hour(s) Identify the ways of resolving statement failure. Identify the causes of statement failure. Identify the ways of resolving user process failures. Identify the causes of user process failures. Identify the ways of resolving user error failures. Identify the causes of user errors failures. Identify the recovery process in an instance failure. Identify the causes  more...

Oracle8 Database Administration - Manage an Instance .... Identify the steps in the execute phase of a given DML statement. Identify the uses of a rollback segment. Identify the characteristics of a redo log buffer. Identify the events that cause the Database Writer (DBWR) to write to datafiles. Identify the events that cause the Log Writer (LGWR) to write to the redo log file. Identify the uses of System Change Numbers. Sequence the steps  more...

Oracle Report Builder Controlling Reports ...ction, format attribute setting, report creation, and SQL statement execution. Identify the different development and runtime environments Identify the factors to be considered for developing reports for execution in different GUIs, environments, and languages. C ontent Emphasis Skills-Based A udience Application developers, database administrators, designer/developers, and  more...

Oracle Report Builder Enhancing Reports ...ify the advantages of modifying the properties of a query statement. Change the structure of a group in the Object Navigator. Update the layout of a report using the Report Wizard. Identify the methods of ordering data in a group. Create a group filter by using the Property Palette dialog box. Add new data to a report by creating a query in the Data Model. Create an external query by  more...

Oracle Form Builder Writing and Debugging Code ...e sources for the different clauses of the default SELECT statement. Write the code for a Pre-Query trigger at the data block level. Write the code for a Post-Query trigger at the data block level. Implement query array processing in a Form Builder application. Write a code for a trigger to fire in the Enter Query mode by using the SYSTEM.MODE variable. Match the transactional triggers  more...

C Programming - Part 3 ...offset position of a file pointer in bytes after a set of statements are executed. Complete the code to move a file. Identify the code to perform I/O operations from standard devices by using disk file I/O functions. Enter the command line statement to execute the C program. Identify the code used to display the value of environment variables. Identify the advantages of using system calls  more...

C Programming - Part 2 ...lements for a displayed one-dimensional array declaration statement. Identify the correct one-dimensional array initialization statement for a specified situation. Specify the statement to access an element from a one-dimensional array. Type a piece of code to pass an array as an argument to a function. Identify the output of a set of statements using the string-handling function strcpy  more...

C Programming - Part 1 ...ators in C. Identify the different types of conditional statements. Identify the different types of iterative flow control statements. Identify user-defined functions in C. C ontent Emphasis Skills-Based A udience Application developers, software engineers, and programmer/analysts are some of the types of people who will benefit from taking this course. Personnel expecting  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 ...tion: 1 - 2 Hour(s) Retrieve data by using the SELECT statement with a WHERE clause. Aggregate data by using the aggregation functions. Group the aggregated data by using the GROUP BY keyword. Retrieve specific groups of the aggregated data by using the HAVING keyword. Calculate totals and subtotals of the groups in the aggregated data by using the ROLLUP keyword. Calculate totals and  more...

Visual C 6 0 Designing Implementing Distributed Applications - Part 3 ...ase, maintain data integrity and import data. Write SQL statements to access data from tables and manipulate the data. Implement data access in applications through stored procedure model and cursors. Create transactions and implement locking strategies. C ontent Emphasis Skills-Based A udience This course is designed for programmers looking to develop applications using  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 5 ... Write outgoing data to the connected socket. Write the statement to open a COM port for overlapped I/O. Write the statement to close a COM port. Write the statement to write data to a COM port for overlapped I/O. Write the statement to read data from a COM port for overlapped I/O. Unit 3: Database Access: ODBC and DAO Duration: 2 Hour(s) Configure an Open Database Connectivity  more...

Oracle Database 10g SQL Fundamentals I Part 2 ... Learn To: Identify the code for using the INSERT statement. Identify the code for using the UPDATE statement. Identify the code for using the DELETE statement. Identify tasks to be performed for granting system privileges. Identify tasks to be performed for granting object privileges. Identify syntax for performing various tasks for maintaining columns. Identify the code  more...

Oracle Database 10g PL SQL Fundamentals Part 1 ... blocks. Identify uses of PL/SQL operators. Match SQL statements with their functions. Identify guidelines for retrieving data in PL/SQL. Identify codes for manipulating data using DML statements. Identify the syntax for testing the outcome of SQL statements using cursors. Identify the syntax of the IF statement. Identify the syntax of the CASE construct. Identify considerations  more...

Oracle Database 10g SQL Fundamentals I Part 1 ...al Database Management System (RDBMS). Identify the SQL statement to retrieve data from tables. Identify arithmetic expressions used to perform operations on data. Identify operators used to format results in SQL statements. Identify features of single-row functions. Match the character functions with their uses. Match the number functions with their purpose. Identify the use of  more...

C Foundation for Non-C Programmers - Part 1 ...n addition, they will learn how to create expressions and statements, apply flow control, and create and call functions. L earn To: Identify the basic program structure in C++. Identify the different compilers. Identify the process of creating an executable program. Identify basic and complex data types used in C++. Identify the operators and the expressions in which they are  more...

C Foundation for Non-C Programmers - Part 2 ... the code that overloads a specified operator. Match the statement to invoke an implicit member function with the task performed by the implicit member function. Identify the header of a member function definition for a specified scenario. Unit 2: Classes: Advanced Concepts Duration: 2 - 3 Hour(s) Match the depictions of different types of inheritance with their names. Identify  more...

Oracle SQL Specifics Retrieving and Formatting Data ...rs will learn how SQL functions can be used in SQL SELECT statements to extract data from the database and how SET operators can be used to combine multiple queries into a single query. Users will also learn how subqueries and correlated subqueries can help to solve data retrieval problems. Finally, participants will learn how to retrieve data based on a hierarchical relationship between rows.  more...

Oracle SQL Specifics Creating and Managing Database Objects ...ld integrity constraints, and use the COMMIT and ROLLBACK statements to 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  more...

Oracle SQL and SQL Plus Advanced SELECT Statements ...This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition, this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries. L earn To: Write single-row subqueries. Write multiple-row and multiple-column subqueries. Write correlated subqueries. Write  more...

Oracle SQL and SQL Plus SQL Plus and Reporting ...en, course 60121 Oracle SQL and SQL*Plus: Advanced Select Statements. T otal Learning Time 7 - 8 Hour(s) Course Contents Unit 1: SQL*Plus Duration: 3 Hour(s) Differentiate between SQL and SQL*Plus. Match the SQL*Plus command categories with sample tasks. Write the code to display the column definitions of a given table. Complete the SELECT statement that prompts the user  more...

Oracle SQL Tuning Diagnostics and Tuning Schema ...ew This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash clusters.  more...

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

SQL Server 7 0 - Implementing a Database - Part 1 ...erver programming tool that is used to enter Transact-SQL statements, system procedures and script files using ODBC. Select uses of Data Control Language statements. Select uses of Data Definition Language statements. Select SQL Server naming conventions for object identifiers. Select uses of Data Manipulation Language statements. Select when to use local variables. Select global variable  more...

SQL Server 7 0 - Implementing a Database - Part 2 ...ct the guidelines which apply when using the CREATE INDEX statement. Perform the steps to create a unique index. Perform the steps to create a composite index. Identify the methods used to view existing indexes. Perform the steps to drop indexes. Perform the steps to allocate a percentage of free space on leaf level index pages. Perform the steps to specify a percentage to fill non-leaf  more...

SQL Server 7 0 System Administration - Part 3 ...orm the steps necessary to add multiple files to a backup statement. Match six of the advanced options available in the Transact-SQL BACKUP statement with their functions. Associate the six tape backup options with their functions. Unit 2: Performing Backups Duration: 2 - 3 Hour(s) Match the proper full backup frequency with its scenario. Perform the steps necessary to create a  more...

SQL Server 7 0 - Implementing a Database - Part 3 ... earn To: Query multiple tables using Transact-SQL statements. Retrieve and modify data using advanced query techniques. 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  more...

SQL Server 7 0 - Implementing a Database - Part 5 ...ypes with its use. Select the functions of the RAISERROR statement. Perform the action to customize error messages. Select the statements used in transactional error-handling. Select the counters that can be monitored by SQL Server Performance Monitor. Perform the steps to view the event generated by the stored procedure. Select the recommended practices for effective stored procedures.  more...

SQL and PL SQL PL SQL Basics ...) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112) and Oracle 8i. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: PL/SQL: An Introduction Duration: 0.5 - 2 Hour(s) Identify the features of PL/SQL. Identify the benefits of PL/SQL. Select the actions by which a PL/SQL engine processes a  more...

SQL and PL SQL Basic SELECT ...atabase principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. L earn To: Identify relational database concepts and properties. Describe database design processes by explaining the system development life cycle and entity relationship modeling. Describe the concept of object relational database management  more...

SQL and PL SQL Data Retrieval Techniques ... 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 format specified by the user will be covered. L earn To: Retrieve rows from multiple  more...

SQL and PL SQL DML and DDL ...irst two courses in this series, Oracle SQL: Basic SELECT Statements (course 61110) and Oracle SQL: Data Retrieval Techniques (61111). This course will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle  more...

Java for Procedural Programmers Java Concepts ...n Developer is introduced. You will learn the concepts of statements such as non-functional statements, conditional statements, and iterative statements. In the Using Existing Classes section, features of Java objects, classes, and containers are discussed. The Creating Your Own Class section covers creating a class, class members, and object hierarchy in Java. Learn To  more...

IBM DB2 Universal Database V6 1--Fundamentals ...e effects of table check constraints given a CREATE table statement. Identify characteristics of a trigger. Analyze data modification instructions to determine whether DB2 applies referential constraints given referential constraint definitions. Unit 3: Basic Structured Query Language Usage Duration: 2 Hour(s) Display data using a SELECT statement. Specify rows to be retrieved  more...

IBM DB2 Universal Database V6 1--Fundamentals ...e effects of table check constraints given a CREATE table statement. Identify characteristics of a trigger. Analyze data modification instructions to determine whether DB2 applies referential constraints given referential constraint definitions. Unit 3: Basic Structured Query Language Usage Duration: 2 Hour(s) Display data using a SELECT statement. Specify rows to be retrieved  more...

Oracle SQL for End Users--Part 1 ...d for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties, introduces the Oracle server, and indicates how SQL and SQL*Plus are used in the Oracle product set. In this course, the learner creates basic SQL SELECT statements and customizes these queries to restrict and sort the results. In  more...

Oracle SQL for End Users--Part 2 ...his 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 executes a formatted report by using SQL*Plus commands. L earn To: Access data from more than one table  more...

Java for Procedural Programmers Java Concepts ...n Developer is introduced. You will learn the concepts of statements such as non-functional statements, conditional statements, and iterative statements. In the Using Existing Classes section, features of Java objects, classes, and containers are discussed. The Creating Your Own Class section covers creating a class, class members, and object hierarchy in Java. Learn To  more...

Advanced Project Leadership Organization Strategy Business Needs ...ify the need for Project Charter. Identify the need for Statement of Work. Identify the key questions to ask when preparing a strategic Project Charter. Identify the method for analyzing and matching business needs to strategy. Identify the process for linking high level deliverables to strategy. Identify how the type of organization could cause risk. Audience: Project managers  more...

QuickBooks 2003 Up Running Learn To Identify options in the Create Invoices window. Print a batch of invoices. Identify options in the Receive Payments window. Deployment Options e-Learning Language Options US English Total Learning Time 2 hours Objectives Unit 1: QuickBooks 2003 Bookkeeping (2 hours)  more...

Lotus Domino Designer 6 for Release 5 Developers Part 2 ...ace rule. o To identify features of a nested assignment statement. Audience The targeted audience for this curriculum includes Domino developers who currently use Domino R5 and are moving to Domino 6. This course teaches developers how to enhance their presentations as well as teaching the new features of cascading style sheets, using third party tools, layers, agents, and reusable  more...

Financial Management Understanding Financial Statement ...ding a basic understanding of an organization's financial statements. Learn To: Identify the importance aspects of major financial statements. Identify methods to prepare an income statement. Identify adjustments made in preparing a balance sheet. Identify the key ratios for analyzing the balance sheet. Identify key information derived from a cash flow statement. Audience:  more...

Financial Management Cash Analysis Management ...dentify categories of cash flow activities in a cash flow statement. Identify positive and negative cash flows by interpreting a cash flow statement. Audience: Non-financial professionals including managers, department heads, and others in the firm who wish to develop a better understanding of financial and accounting concepts and terminology. Deployment: Self-Study  more...

Financial Management Inventory Costing Depreciation ...sets on a balance sheet. Identify elements of an income statement. Match inventory costing methods with their impact on the balance sheet and income statement. Identify key aspects of inventory control systems. Match depreciation methods with their impact on the balance sheet and income statement. Audience: Non-financial professionals including managers, department heads, and  more...

Business Accounting Accounting for Stockholders Equity ...t an overview of the information contained in a company's statement of stockholders' equity and in the stockholders' equity portion of the balance sheet. The program details components of stockholders' equity, stock transactions, and financial analysis ratios used to evaluate a company's long-term solvency. Learn To • Identify the components used to  more...

Financial Statements Financial Statements Analysis ...Statements: Financial Statements Analysis offers the student an overview of financial statements, budgets, and ratio analysis. The program details how to create a balance sheet and income statement, the purpose of these financial statements, the role of budgeting in accounting, how to combat budgeting variances, and the different methods of analyzing financial statements. Learn To  more...

Financial Statements Analyzing Cash Flows ...Statements: Analyzing Cash Flows offers the student an overview of accounting methods, the statement of cash flows, stock, and financial ratios. The program details how accounting methods affect financial statements, who looks at your financial statements and for what reasons, and how financing instruments affect financial statements. It also covers the methods used for and activities reported  more...

Budgeting Creating Analyzing a Budget ...ccessful budget. Identify the components of a cash flow statement. Identify reasons to consult with others when developing a budget. Simulation Overview: In this simulation, you will meet with Elizabeth Thomas, a Budget Analyst in Icon's Financial Services Department, to discuss how different parts of a budget are compiled. Since the main goal for your meeting with Elizabeth will be  more...

Emotional Intelligence Developing Emotional Intelligence Skills ...igence (0.5 - 1 hour) Given four statements, identify the correctly paraphrased statement. State facts and use paraphrasing when communicating with others. Identify two dangers of nonverbal communication. List the ways to assert yourself without being antagonistic. Apply  more...

Excellence in Service Creating an Exceptional Service Environment ...will learn steps for writing your customer service vision statement, as well as suggestions for ensuring that the appropriate processes and systems are in place to support exceptional customer service. You will also learn ways to be a role model of exceptional customer service for your employees. Learn To: Define a customer service vision for your organization or department.  more...

Leadership Development Leading the Way ...d Production Departments to discuss the company's mission statement and vision. Unit 3: Communicating with Followers (0.5 - 1 hour) Understand why the follower is a critical part of the leadership process. Communicate effectively with followers. Use effective listening skills. Empower and motivate  more...

Managerial Leadership Creating a Vision ...'s vision, basic steps to complete when drafting a vision statement, and guidelines for communicating the vision. In addition, this program provides steps for setting goals that are aligned with an organization's vision. Learn To Choose questions to answer when defining your organization's vision. Identify steps for writing a vision  more...

Succession Planning Setting Up a Succession Planning Program ...to action. It begins with guidelines on writing a mission statement, policy and procedures, identifying target groups and other issues such as legal considerations. It then provides comprehensive guidelines on all aspects of rolling out your plan, how to communicate and provide training in it. The second part of the course focuses on identifying key roles within your organization, developing a  more...

Project Management Project Integration Management ...nt, as well as how to develop a preliminary project scope statement and a project management plan. You will also learn the inputs, tools, techniques, and outputs of managing, monitoring, and controlling project execution. Finally, you will learn about integrated change control and how configuration management is involved in that process. Learn To: Identify the elements of Integration  more...

Project Management Project Scope Management ...y scope definition inputs. Identify contents of a scope statement. Identify basic scope analysis techniques. Unit 3: Work Breakdown Structure Identify benefits of a WBS. Define the decomposition approach to creating a WBS. Sequence the steps for creating a WBS. Identify key outputs resulting from the WBS creation process. Unit 4: Scope Verification and Control  more...

Organizational Learning Developing a Knowledge Mgmt System ...ation is to follow the process for drafting a KM strategy statement that is suitably aligned with the company's vision. Unit 2: Assessing Knowledge (0.5 - 1 hour) Identify who should be included in a knowledge assessment team. Identify steps for performing a knowledge assessment. Follow the process for performing a  more...

Lotus Domino R5 Development Part 4 Making Your Application Run ...e lexical elements in the Formula language. Identify the statements that follow the syntax rules for writing formulas in the Formula language. Identify the rules to be followed for using variables in the Formula language. Identify the rules to be followed for using constants in the Formula language. Identify the order of evaluation for the formula statements in the Formula language. Write  more...

CIW Database Specialist Part 3 Database Interaction JDBC ... DDL commands, inserting, updating, and querying with DML statements, granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts, to include joins, transactions and database security, and using JDBC drivers and executing SQL statements. Learn To: o Identify features of Structured Query Language (SQL). o Match the SQL data types with  more...