Online Statements eLearning

Principles of External Auditing Principles of External Auditing The thought of an external auditor coming to your company may make you feel uneasy. This course will help you understand how external auditors and companies work together to ensure an accurate audit report. This course will familiarize you with terminology, concepts, strategies, and techniques that are specific to external auditing and its practice. You can  more...

ANSI C Programming Expressions ANSI C Programming: Expressions To describe the syntax rules governing expressions and statements in ANSI C and how to to use expressions and statements  more...

ANSI C Programming Flow Control ANSI C Programming: Flow Control To describe advanced flow-control statements  more...

General Coding Best Practices General Coding Best Practices To outline the best practices for writing high quality methods, expressions, variables, arrays, loops, and if statements, and to describe recommended practices for writing readable code  more...

Oracle Database 11g PL SQL Variables Attributes and Executable Statements Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements Oracle To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.  more...

Oracle Database 11g Using DML DDL Cursors Control Structures and Loops Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops Oracle To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.  more...

Introduction to Oracle and SQL in Oracle Database 10g Introduction to Oracle and SQL in Oracle Database 10g Oracle To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements  more...

Manipulating Data in Oracle Database 10g Manipulating Data in Oracle Database 10g Oracle To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements  more...

Oracle Database 11g Subqueries Set Operators and Data Manipulation Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation Oracle To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.  more...

Code of Conduct Company Template ...eric items with your company's own Code of Conduct policy statements and modify the questions and supporting content accordingly. SkillSoft's Custom Development Solution Team is available to perform the modifications to fit your company's specific requirements. This course was developed with subject matter support provided by the Labor and Employment Practice Group of the law firm of Baker,  more...

Developing and Deploying Strategic Plans ...ry goals and objectives based on their mission and vision statements. Other success factors include understanding market forces, internal strengths and weaknesses, stakeholders, relevant technology, and legal and regulatory factors. With these considerations, an organization's action plan can be developed and deployed, and its effectiveness evaluated. This course explores the concepts of  more...

Java Programming with J2SE 5 Operators and Flow Control in Java Java Programming with J2SE 5: Operators and Flow Control in Java Sun To enable the learner to identify and work with Java operators, expressions, selection statements, and loop constructs  more...

Quality Systems Models and Theories ...ented must be aligned to the corporate mission and vision statements and the strategic plan in order to be effective. As an organization evolves, its quality plan must be monitored and revised in order to reflect these changes. This course explores the quality mission, plan, and methodologies and discusses the importance of effective monitoring, documentation, and implementation. It  more...

The Acct Equation and Financial Statements ...Statements Business owners and managers, regardless of form and size of their organizations, put their best efforts in generating enough assets to pay for business's liabilities and build adequate stockholders' equity. The basic accounting equation offers us a simple way to understand how these three elements assets, liabilities, and stockholders' equity relate to each other. Every  more...

Basic Acct Principles and Framework ... system, monitors it, prepares and presents the financial statements to management, and interprets them as needed. Bookkeeping is a part of the accounting function and involves the mechanical aspect of recording, classifying, and summarizing transactions in account books and posting them to respective financial statements. Apart from the statutory importance, accounting data is very critical to  more...

Java Programming with Java SE 6 0 Operators and Flow Control in Java Java Programming with Java SE 6.0: Operators and Flow Control in Java Sun To enable the learner to identify and work with Java operators, expressions, selection statements, and loop constructs  more...

Financial Statements for Non-fiinancial Professionals ...Statements for Non-fiinancial Professionals Financial statements, including the Income Statement, the Cash Flow Statement, and the Balance Sheet, work as a dashboard of the financial performance of an organization. Knowing how these financial statements are created, and how they reflect the performance of the organization, helps non-financial professionals better understand how their own  more...

Analyzing Financial Statements for Non-financial Professionals ...Statements for Non-financial Professionals Financial statements of an organization often conceal more than they reveal. Being able to analyze them and extract meaningful information is an essential skill that financial as well as non-financial professionals should have. Ratio analysis can be used to determine relationships between two elements of the same financial statement or between  more...

Principles of Acct Finance for Non-financial Professionals Principles of Acct. & Finance for Non-financial Professionals Finance and accounting are at the heart of every business. These functions deal with recording, summarizing, and analyzing financial information across all departments for decision making, directing, and controlling their resources and activities. Every activity or non-activity in an organization has financial implications and  more...

Oracle Database 11g R2 Managing Database Memory Performance Oracle Database 11g R2: Managing Database Memory & Performance Oracle Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which  more...

The Cash Flow Statement ...eriod. This course discusses various aspects of Cash Flow Statements and walks the learner through the steps in preparing one using a business scenario. Learners are introduced to various components in a Cash Flow Statement and also shown how to calculate cash at the end of the accounting period. This course also presents examples of how various transactions affect cash balances in an  more...

The Balance Sheet ...nce Sheet is arguably the most important of all financial statements. It is a financial snapshot of a company's health at a specific point in time as measured in terms of assets, liabilities, and owners' or shareholders' equity. It allows you to see what a company owns as well as what it owes to other parties. People who might be interested in the Balance Sheet include creditors, investors,  more...

The Income Statement ...statements show the financial performance of an organization. They are comprised of the Income Statement, the Cash Flow Statement, and the Balance Sheet, and are used both internally and externally by a variety of users. The Income Statement can also be referred to as profit and loss statement or statement of operations, and is one of the most important financial statements. It shows the  more...

The Accounting Cycle and Accrual Accounting ...verified for correctness, and then presented as financial statements to the organization's internal and external users. As in most other things, timing is of prime importance in accounting, specifically in recording transactions. Most organizations record revenue or expense transactions when they actually take place known as accrual accounting. Others do it when money actually changes hands  more...

Accounting Transactions and Books of Account ...on stands. The correctness and integrity of the financial statements that an organization produces largely depend on the correctness and integrity of its bookkeeping activities. Journalization and posting to ledgers are the two core bookkeeping activities. The journals are where all transactions are first recorded on a daily basis. Information from a journal is then posted to the ledgers to  more...

Trial Balance Adjusting Entries ...alance to check equality of debits and credits. Financial statements are also prepared at this stage in the cycle. Finally, all temporary accounts are closed and a post-closing trial balance is prepared. This course teaches you how to prepare a trial balance, make adjusting entries, and close the temporary account books at the end of an accounting period. It introduces several types of trial  more...

Introduction to Software Program Design Introduction to Software Program Design In order to work their magic, computer programmers need to understand the various methods required by programming languages. This course introduces the learner to the basic methods and processes necessary to construct algorithms, including variables and data types, expressions and statements, and more advanced concepts like arrays and functions.  more...

IFRS Introduction Conceptual Framework IFRS: Introduction & Conceptual Framework Because of increasing globalization and interaction among corporations and national economies, the various users of financial information require a single set of high-quality accounting standards. IFRS (International Financial Reporting Standards) was developed to meet this need. This course gives the learner a well-rounded understanding about IFRS  more...

IFRS Standards for Financial Statements Their Items ...Statements & Their Items This course introduces the objectives of some key standards from the IFRS along with their scope and key business implications. Where they apply, it examines differences with GAAP and the implications of switching from the GAAP to the IFRS system. The course also addresses standards relating to the presentation of financial statements, inventories, statement of  more...

IFRS Key Standards for Financial Accounting Activities ...ing and reporting practices, produce comparable financial statements, and establish a common accounting language across different countries. These standards are now adopted in over 110 countries from every part of the world and several other countries are preparing to adopt them. This course aims to prepare learners for implementing some key standards related to financial and accounting  more...

JavaScript Functions Regular Expressions ... and provide users with an alternative way to encapsulate statements to perform more powerful and useful actions in a reusable piece of code. Regular expressions ease the task of validating data in JavaScript programs. This course will explore how to use Function objects and useful predefined functions that are part of the JavaScript language. It will also detail the regular expression support  more...

JavaScript Language Basics JavaScript Language Basics JavaScript is a client-side interpreted scripting language that enables you to enhance static web applications by working in tandem with HTML and Cascading Style Sheet (CSS). This course will introduce the history of JavaScript and outline how it is commonly used to develop dynamic web sites. Moving into the fundamentals of the language, the course will demonstrate  more...

SQL Server 2008 Database Management ...run regularly. SQL Server 2008 Transact-SQL provides DBCC statements, which in turn provide statements to maintain the database and database files. An administrator can also use maintenance plans to run a series of tasks on specific databases using a schedule or on demand. This course demonstrates how to confirm the integrity of a database, manage database files, and how to create maintenance  more...

SQL Server 2008 Data Management ... another partition. SQL Server 2008 provides Transact-SQL statements to ensure that administrators can perform these tasks to manage the table partitions. SQL Server also provides data compression at the table row and page level. Indexes can be created to allow for the quick retrieval of data from database tables. Administrators need to monitor and manage these indexes to ensure that they are  more...

Running Queries Manipulating Data in SQL Server 2008 ...s to include only the data that you require. Transact-SQL statements also allow you to update, change, and remove data from tables. This course identifies the basic T-SQL statements that can be used to retrieve and modify data within SQL Server databases. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL  more...

Creating Implementing Programming Objects in SQL Server 2008 ...70-433) In SQL Server 2008 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not retrieve the desired results. You can group Transact-SQL statements by creating programming objects within a database. These programming objects include  more...

Oracle Database 11g Manipulating Queries Data Oracle Database 11g: Manipulating Queries & Data Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.  more...

Oracle Database 11g Getting Started with PL SQL Oracle Database 11g: Getting Started with PL/SQL Oracle To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.  more...

Oracle Database 11g Using DML DDL Cursors Loops Control Structures Oracle Database 11g: Using DML, DDL, Cursors, Loops & Control Structures Oracle To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.  more...

Oracle Database 11g Problem SQL Statements Oracle Optimizer ...Statements & Oracle Optimizer Oracle Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command, SQL*Plus AUTOTRACE command  more...

Oracle Database 11g Architecture SQL Tuning Optimization ...nce of and tuning database components, as well as the SQL statements used to access and manipulate the database, helps to ensure the Oracle Database server runs efficiently and as expected. This course explores the major architectural components of the Oracle Database server, memory structures, background processes, and physical and logical storage structures. It also examines SQL tuning,  more...

Oracle Database 11g Optimizer Statistics Hints Cursor Sharing ...ng, and manipulating optimizer statistics. if you use SQL statements where literal values are provided for the WHERE clause conditions, you get results in many versions of almost identical SQL to be stored in the library cache. If, instead of issuing different statements for each literal, you use a bind variable, then in theory that extra parse activity is eliminated. Listing the benefits of  more...

Oracle Database 11g Application Tracing Automatic SQL Tuning Oracle Database 11g: Application Tracing & Automatic SQL Tuning Oracle Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and  more...

Oracle Database 11g R2 Using Change Management Solutions ...solutions and demonstrates how to use them to analyze SQL statements, test upgrades, and capture and analyze workloads. It is one of a series of courses in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP)  more...

Oracle Database 11g R2 Intelligent Infrastructure Enhancements ...ead. This course identifies how to automatically tune SQL statements using Automatic SQL Tuning, use Automatic Workload Repository baselines to gather performance metrics, control maintenance tasks, determine I/O metrics using I/O Calibration tool, and use Resource Manager. This course is one of a series in the SkillSoft learning path that covers objectives for the Oracle exam 1Z0-050 Oracle  more...

Oracle Database 11g R2 Diagnosability Enhancements ...ion, running health checks, and performing repairs on SQL statements. These features enables the DBA to quickly and efficiently diagnose issues and report problems to Oracle Support, as well as reducing damage and interruptions. This course discusses using Automatic Diagnostic Repository, creating and submitting Incident Packages to Oracle Support, running health checks and viewing the reports.  more...

Oracle Database 11g R2 SQL Monitoring Performance Enhancements ... database using Automatic Memory Management, and that SQL statements are running properly by monitoring them in real-time using Enterprise Manager. It also offers a new feature to conceptually extend the buffer cache by using DB Smart Flash. This course demonstrates how to monitor SQL commands in real-time using SQL Monitoring, use Automatic Database Diagnostic Monitoring (ADDM), DB Smart  more...

Oracle Database 11g R2 Managing Concurrency Undo Auditing ...be detected and managed through Enterprise Manager or SQL statements. Managing undo data and implementing Oracle Database security are also important DBA roles. Data is manipulated using DML, and undo data exists as a copy of the original, premodified data and is captured for every transaction that changes data. Security requirements have been a matter of individual concern until recently, but  more...

Software Program Control Flow Fundamentals Software Program Control Flow Fundamentals Computer software works because programmers create algorithms, which when broken down, are nothing more than a collection of logical constructs. This course introduces the learner to the logic behind computer software, including using defining tables to solve a problem, conditional statements like IF THEN, and repetition using FOR and WHILE loops.  more...

Java 2 - Language & Semantics ...ndamentals, operators and expressions as well as, control statements and arrays. In this unit, you will learn about the Java syntax and lexical issues. It covers identifying the range and declaring the constants, literals, and variables of the three main categories of primitive data types. You will learn to identify Java keywords and identifiers. This unit also explains how to write the  more...

Accounting In An Hour ...r of minutes, Accounting In An Hour demystifies financial statements, helping you quickly understand how a company makes and loses money and how assets and liabilities are recorded. If you?ll invest just sixty minutes in this course, you?ll not only think about your role in your organization in an entirely different manner, everyone else will think about you differently, too. You?ll have the  more...

Business Ethics Conduct Policy Statements It is 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...

Project Management Professional- (Self Directed) Project Management Professional is a self-directed course that covers the fundamentals of managing projects with the newcomer in mind. Project management is the discipline of organizing and managing resources in such a way that these resources deliver all the work required to complete a project within defined scope, time, and cost constraints. This course can be completed as quickly as you care  more...

Build Your Own BIZ - Dynamic Workforce Management Effective personnel management is vital to your business. Dynamic Workforce Management will help you make sound personnel management decisions. 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  more...

Build Your Own BIZ - Using Financial Statements ...statements to help you measure how well your company is doing. 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. You will receive as a  more...

ADO NET Connections and Commands To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design  more...

ADO NET Connections and Commands To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design  more...

VBScript - Elements Arrays Procedures and Program Flow To explain the capabilities of the VBScript programming language and the use of arrays, procedures, loops, and conditional statements in a VBScript program  more...

Accounting Fundamentals How does a business achieve and maintain profitability? An understanding and an accurate application of accounting practices are hallmarks of a successful and financially progressive business. Accounting is a distinct discipline, with its own standards and language. Understanding accounting procedures requires a prerequisite knowledge of certain principles, concepts, terms, and common accounting  more...

Accounting for Merchandising Businesses A merchandising business is a business that buys goods and sells them for profit. Merchandising businesses, which include wholesalers and retailers, typically handle inventory, therefore accounting procedures exist to record the cost of goods sold or not sold. This course will provide practical information about maintaining accounts and generating financial statements specifically for  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...

Principles of Financial Statements This course presents an overview of the principles of financial statements, introducing the learner to critical concepts and terminology necessary for understanding the rules impacting the presentation of numbers on financial statements, and the cash cycle of financial management.  more...

Components of Financial Statements This course presents an overview of the relationship between business management decisions and financial statements, introducing the learner to critical concepts and terminology that are necessary for conducting an applied interpretation of financial statements.  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...

Ratio Analysis for Financial Statements This course introduces the learner to ratio analysis and how ratios are used in analyzing financial statements. Ratio analysis is used by businesses, investors, creditors, and stockholders in decision-making. Up-to-date audited reports from past and current financial statements are used to secure the most accurate ratio analysis results.  more...

Credibility and Disclosure in an Annual Report This course will familiarize business managers, financial professionals, and other business professionals with methods to determine the credibility of an annual report, as well as the degree of disclosure that is required. The course begins by examining how the CPA can address credibility issues, primarily through the auditing process. It also examines the important contribution of the notes  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...

Operators and Flow Control in Java To enable the learner to identify and work with Java operators, expressions, selection statements, and loop constructs  more...

Java Programming with J2SE 5 Operators and Flow Control in Java To enable the learner to identify and work with Java operators, expressions, selection statements, and loop constructs  more...

Operators and Flow Control in Java To enable the learner to identify and work with Java operators, expressions, selection statements, and loop constructs  more...

Dreamweaver MX Web Applications ...e Stored Procedures What are Views SQL What is SQL Select Statements Using Where & Order By Retrieving Data Using LIKE Connecting to Databases Web & Application Servers Types of Application Servers Installing Personal Web Server Configuring PWS Configuring IIS Interfacing with Databases Database Drivers Setting up a DSN Connecting to an MS SQL Server Connect to a CFMX Server Creating a  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...

Using T-SQL in SQL Server 2000 To discuss Transact-SQL and its elements and view and define data using Transact-SQL statements  more...

Introduction to Oracle and SQL in Oracle9i To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements  more...

Strategic Management Developing a Successful Process ... Recognize the qualities of effective mission and vision statements. Identify issues to consider when setting goals and objectives. Discuss issues to consider when setting goals and objectives. Differentiate among the strategy types. Identify guidelines to secure acceptance for the strategic plan.  more...

Macromedia Flash MX 2004 Fundamentals of ActionScript ...syntax, and working with data. Working with Functions and Statements provides an overview of the types of functions and statements. Finally, Working with Movie Clips covers working with target paths and controlling movie clips. Learn To: Identify the new features of ActionScript 2.0. Identify the methods for handling events. Identify the tasks for defining a variable and  more...

Oracle Database 10g PL SQL Fundamentals Part 1 ...locks. 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  more...

Oracle Database 10g SQL Fundamentals I Part 1 ...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 natural joins to retrieve data from multiple tables. Identify the use of an equijoin to retrieve data from multiple tables. Identify the use of  more...

Oracle Database Administration Workshop I Part 2 ...entify 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 of SQL*Loader data files. Distinguish between the direct  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...

C Programming - Part 2 ... argument to a function. Identify the output of a set of statements using the string-handling function strcpy with arguments. Identify the output of a set of statements that use the string-handling function strcmp with arguments. Identify the output of a set of statements using the string-handling function strcat with arguments. Identify the output of a set of statements using the  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 4 Course Overview This is the last course in a four-part series on C++ Programming, which is based on ANSI C++. This course is designed to give learners some of the practical skills needed to be able to write and compile user-ready C++ applications. Learners will acquire skills needed to perform runtime exception handling, incorporate standard libraries, and create well-designed class  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...

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

Oracle SQL Tuning Diagnostics and Tuning Schema ...tify the need and areas for tuning the performance of SQL statements. Identify tuning steps. Identify the tools that help you test an diagnose performance problems with a SQL statement. Use efficient data access methods that are available for the optimizer. Create the appropriate database objects before starting to tune SQL statements. C ontent Emphasis  more...

Oracle SQL Tuning Tuning SQL and the Optimizer ...his 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. Identify the factors in SQL code design that affect response time.  more...

Oracle Form Builder Enhancing the User Interface ...scope of a trigger with their description. Identify the statements that are allowed in trigger code. Match the execution hierarchy of a trigger with their description. Create a trigger by using an appropriate method. Match the PL/SQL Editor components with their description. Match the trigger properties with their descriptions. Identify the rules for writing trigger code. Match  more...

Oracle Form Builder Writing and Debugging Code ...tify the rules followed by Form Builder while issuing DML statements during commit processing. Write an On-Logon trigger to override the default logon process. Identify the different ways to run Form Builder against non-Oracle data sources. Match the commit status values returned by different system variables with their implications. Write the code to manipulate the commit status of a  more...

Oracle Cert App Developer Track for Developer 2000 R2 Curriculum ...ists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retreival Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle PL/SQL: Procedures, Functions and Packages (ID#7745) Oracle PL/SQL: Database Programming (ID#7746) Oracle Form Builder: Form Fundamentals (ID#381) Oracle Form Builder: Enhancing the User  more...

Oracle Report Builder Report Fundamentals ...he functions of the Parameter Form objects. Identify the statements that describe the interrelationship among the objects in the Report Editor views. Identify the definition of the report wizard. Create a query by using the Query Builder in the Report Wizard. Select the fields to be displayed from a list of available fields by using the Report Wizard. Create a summary by using the Report  more...

Oracle8 Certified Database Administrator Curriculum ...sists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle8 Database Administration - Manage an Instance (ID#421) Oracle8 Database Administration - Create Databases (ID#426) Oracle8 Database Administration - Manage Data Storage Structures (ID#430)  more...

Oracle8 Database Administration - Manage Storage Structures ...orary Segments Duration: 2 Hour(s) Identify the statements that require the use of temporary segments. Identify the features of temporary segments in PERMANENT tablespaces. Identify the features of temporary segments in temporary tablespaces. Identify the guidelines for using temporary segments. Retrieve temporary segment statistics by using Oracle SQL Worksheet. Retrieve  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ...ing AUTOTRACE. Identify the symptoms of inefficient SQL statements. Identify the characteristics of optimizer modes. Perform the steps to set the optimizer mode at the instance level using the OPTIMIZER_MODE parameter. Perform the steps to register a module using the SET_MODULE procedure. Perform the steps to track a module using the READ_MODULE procedure. Perform the steps to view  more...

Oracle Form Builder R6 Forms Fundamentals ...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). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Oracle Developer: Form  more...

Oracle Form Builder R6 Enhancing the User Interface ...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 part of the Oracle Developer series, Oracle  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...

Oracle Form Builder R6 Project Builder and Menu Modules ...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 three parts of the Oracle Developer series:  more...

Oracle Form Builder R6 Controlling the User Interface Programmatically ...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 four parts of the Oracle Developer series: Oracle  more...

Oracle Form Builder R6 Including Reusable Oracle Components ...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 five parts of the Oracle Developer series: Oracle  more...

Oracle Reports R6 Report Fundamentals ... 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). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Oracle Developer Report  more...

Oracle Reports R6 Enhance 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 part in this series Oracle Reports: Reports  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...

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 Course Overview This is the second course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Implement data integrity. Create and maintain indexes. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database  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 4 ... the ways aggregate functions handle null values. Select statements to use with the GROUP BY clause on columns. Select statements to use with the GROUP BY clause on expressions. Select when to use the HAVING clause. Perform the steps to summarize group values. Perform the steps to summarize combinations of groups. Select the characteristics of the GROUPING function. Select guidelines for  more...

SQL Server 7 0 - Implementing a Database - Part 5 ...rform 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. Unit 2: Implementing Triggers Duration: 2 - 3 Hour(s) Select  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 1 ...s of procedures and programming structures. Identify the statements used to declare a variable and a constant. Identify methods of verifying data entered by the user. Set a reference to a type library. Identify form events in Visual Basic. Create a menu on a form. Create a pop-up menu. Identify the properties and uses of the ListView control. Identify the uses of the TreeView control in  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 4 ...g mechanisms that are supported by Visual C++. Match the statements in the C++ exception handling syntax with their purposes. Identify the steps in the exception handling process. Identify the advantages of using exception handling over using return codes. Match the functions of the CException class with their purposes. Identify the derived classes to be used for handling the errors  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...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 ...ata 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 expressions with their  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 ...ition, 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 tables by using an equijoin, a non-equijoin, an outer join, and a self join. Write SQL statements that contain common group functions. Restrict  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...

Oracle8i Database Admin Create Databases ...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), Oracle8i Database Administration: Manage an Instance (63311). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023.  more...

Oracle8i Database Admin Manage Storage Structures ...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), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will help candidates prepare for the  more...

Oracle8i Database Admin Manage Data Storage ...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), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312) and Oracle8i Database Administration: Manage Storage  more...

Oracle8i Database Admin Manage Security ...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), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will help candidates prepare for the  more...

OCDBA8i Curriculum ...cludes the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics(ID#322) Oracle 8i Backup and Recovery: Strategies & Backups(ID#7486) Oracle 8i Backup and Recovery: Troubleshooting & Recovery(ID#7487) Oracle 8i Database Admin.: Manage an Instance(ID#7476) Oracle 8i  more...

Oracle Designer 6i Curriculum The Complete Oracle Designer 6i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements Oracle SQL: Data Retrieval Techniques Oracle SQL: DML & DDL Oracle SQL: PL/SQL: Basics Oracle Designer 6i First Class: Analysis Oracle Designer 6i First Class: Design & Generation To review individual course descriptions, please return to the previous page and select the  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...

Windows 2000 Installation Config Admin --Part 4 Enterprise Admin ...en Keyboard by using the menu bar. Identify the solution statements that can be used to troubleshoot accessibility service problems. Procedural Steps: Most of the accessibility service problem Configure desktop settings by using Control Panel. Identify the diagnostic steps that can be used to determine the cause of a display problem. Identify the uses of Windows Installer. Identify the  more...

Windows 2000 Installation Config Admin --Part 4 Enterprise Admin ...en Keyboard by using the menu bar. Identify the solution statements that can be used to troubleshoot accessibility service problems. Procedural Steps: Most of the accessibility service problem Configure desktop settings by using Control Panel. Identify the diagnostic steps that can be used to determine the cause of a display problem. Identify the uses of Windows Installer. Identify the  more...

Oracle Database 10g New Features for Administrators Part 2 ...isor. Identify Database Control options for tuning SQL statements. Identify features of the DBMS_SQLTUNE package. Identify features of the SQL Access Advisor. Identify different options for performance monitoring. Identify enhancements made for the MERGE clause in Oracle Database 10g. Identify features of a partitioned outer join operation. Identify features of the SQL  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...

Oracle PL SQL Database Programming ... courses entitled: Oracle SQL and SQL *Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL *Plus: DML and DDL (course 61112), Oracle PL/SQL: Basics (course 61113) and Oracle PL/SQL: Procedures, Functions and Packages (course 61114). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Developing Program Units Duration: 1 - 2 Hour(s) Select the processes  more...

Oracle Database 10g Administration Workshop I Part 1 ...s of SQL*Plus and iSQL* Plus. Identify the uses of SQL statements. Identify features of a PL/SQL block. Identify features of APIs. Identify features of Database Control. x Identify features of Database Control. Identify database management tasks that can be performed by using the Database home page. Identify features of tablespaces. Sequence the steps to create a  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.  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.  more...

Java Exceptions Assertations ...xceptions. Under assertions, the course focuses on assert statements, compilation of classes that use assertions, enabling and disabling assertions at run time, and uses of assertions. Learn To: Identify key concepts related to exceptions. Distinguish between exceptions and errors. Identify the code that uses the try, catch, and finally clauses to handle exceptions.  more...

Java Exceptions Assertations ...xceptions. Under assertions, the course focuses on assert statements, compilation of classes that use assertions, enabling and disabling assertions at run time, and uses of assertions. Learn To: Identify key concepts related to exceptions. Distinguish between exceptions and errors. Identify the code that uses the try, catch, and finally clauses to handle exceptions.  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 ...e. 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 by using equijoins and nonequijoins and join a table to itself by using a self join. Group data by using group functions.  more...

SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server ...ns of SQL Server 2000 services. Match the basic types of statements used in Transact-SQL with their functions. Match Data Control Language (DCL) statements with their functions. Identify the functions of Data Definition Language (DDL) statements. Identify the types of SQL Server 2000 databases. Identify the features of the SQL Server 2000 object-naming standard. Identify the methods for  more...

SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data ...Transact-SQL. Learn To Identify the basic types of statements used in Transact-Structured Query Language (SQL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements. Identify the guidelines for selecting columns within a table. Identify the guidelines for using the WHERE clause to retrieve rows in a  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...

Oracle9i SQL Curriculum The Introduction to Oracle9i: SQL Curriculum includes the following courses: Oracle9i SQL: Basic SELECT Statements Oracle9i SQL: Data Retrieval Techniques Oracle9i SQL: DML and DDL To review individual course descriptions, please return to the previous page and select the desired title(s).  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...

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

Self Development Positively Influencing Others ...es to the Satir modes. Use 'I' statements to influence others. Match the sensory system of another person. Respond appropriately to verbal attacks. Given five steps, work to empower another person. Audience Professionals who are want to learn how to use techniques to positively  more...

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

Oracle9i Database Admin Manage Storage Structures ... Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4  more...

Oracle9i Database Admin Manage Data Storage ... Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4  more...

Oracle9i Database Admin Manage Security ... Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4  more...

Oracle9i Peformance Tuning Managing Memory and Disk I O ...tic tools available for evaluating the performance of SQL statements and PL/SQL modules. o Identify the sections of the STATSPACK SQL report. o Designate the execution plan Oracle follows for executing a SQL statement by creating an EXPLAIN PLAN. o Sequence the steps to diagnose SQL statement performance with SQL TRACE and TKPROF. o Identify the advantages of using SQL*PLUS AUTOTRACE  more...

Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention ...ify the locking mechanism characteristics. o Select the statements that characterize DML and DDL locks. o Identify the DML lock characteristics. o Sequence the process steps of the Oracle shared server configuration. o Identify the characteristics of the Oracle shared server. o Query a dispatcher process to determine the process status using the V$DISPATCHER view. Audience The  more...

CIW JavaScript Fundamentals Part 1 Programming Principals ...s. This course will teach students how to use conditional statements to control program flow. Learn To Identify the key characteristics of JavaScript. Match object programming characteristics with their descriptions. Identify the features of JavaScript that distinguish it from Java. Identify features of the JavaScript object hierarchy model. Identify syntax associated with the window  more...

Oracle SQL PL SQL Using Procedure Builder Curriculum ...ll Builder courses: Course 61110 Oracle SQL: Basic SELECT Statements Course 61111 Oracle SQL: Data Retrieval Techniques Course 61112 Oracle SQL: DML and DDL Course 61113 Oracle PL/SQL: Basics Certification: This curriculum will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle8i Certified  more...

Database Technologies Introduction to SQL ...st course, this course teaches students the essential SQL statements, and associated variations, needed to perform fundamental data access and manipulation on a relational database. After taking this course, students will have a solid foundation in two basic aspects of SQL: Data Definition Language (DDL - creating databases and tables) and Data Manipulation Language (DML - adding, altering, and  more...

Visual Basic NET-Web Based Development Curriculum ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  more...

Visual Basic NET-Web Based Development Curriculum ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  more...

Visual Basic NET-Web Based Development Part 1 ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  more...

Visual Basic NET-Web Based Development Part 1 ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  more...

Visual Basic NET-Web Based Development Part 2 ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  more...

Visual Basic NET-Web Based Development Part 2 ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  more...

Visual Basic NET-Web Based Development Part 3 ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  more...

Visual Basic NET-Web Based Development Part 3 ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  more...

Visual Basic NET-Web Based Development Part 4 ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  more...

Visual Basic NET-Web Based Development Part 4 ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  more...

Visual Basic NET-Web Based Development Part 5 ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  more...

Visual Basic NET-Web Based Development Part 5 ... constructs of programming, such as loops and conditional statements. Participants in this course possibly work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. This course is suitable for Web developers who have knowledge of Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a  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.  more...

Financial Management Financial Planning Forecasting This course will provide a basic introduction to financial planning and forecasting and how this process is important in the firm meeting its financial goals. We will describe the planning process (also known as budgeting) and how the plan, once established, is implemented. Learn To: Identify key aspects of strategic and business plans. Identify guidelines for creating a financial  more...

Financial Management Analyzing Financial Statements ...statements are used by management to improve the organization's performance, and by investors when they set values on an organization's stocks and bonds. You will learn about ratio analysis, the tools used to analyze financial statements. Learn To: Identify the importance of financial analysis. Identify types of financial analysis tools. Identify types of liquidity ratios.  more...

Financial Management Inventory Costing Depreciation ... Objectives: Unit 1: Balance Sheet and Income Statements (1 hour) Identify key aspects of asset types. Identify uses of balance sheets for different user types. Identify benefits of analyzing income statements. Identify key aspects governing the presentation of assets on a balance sheet. Identify elements of an income statement. Unit 2: Inventory Costing and  more...

Business Accounting Accounting for Liabilities ...m liabilities and how they are accounted for on financial statements, as well as how to calculate the present value, future value, interest rate, and maturity date on various types of cash flows. Learn To • Identify types of current liabilities. • Recognize ways long-term liabilities are reported on financial statements.  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 Reading Analyzing an Annual Report ...Statements: Reading and Analyzing an Annual Report teaches the student how to read and analyze an annual report and its notes of disclosure. The program details the characteristics, users, and components of annual reports and notes of disclosure that will help the student understand why it is important to create, analyze, and comprehend annual reports. 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...

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

Goal Setting Organizational Goal Setting ...rganization through the use of organizational objectives, statements of values, and vision and mission statements. In addition, you will learn how to implement strategic goals in your workplace. Learn To Help a team develop and implement an action plan. Sequence the process for managing team goal failure.  more...

Organizational Crisis Mgmt Resolving Crises in Organizations ...ch, handling of apologies, guidelines for Initial Holding Statements, and how to best deal with press releases, press conferences, and media interviews. Learn To To identify guidelines for controlling communication in a crisis situation. To identify the elements of the five 'Cs' rule. To communicate in  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential  more...

Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3 ...ues to variables. Identify the result of Flow-of-control statements in SQL. Identify the query command that retrieves data from joined tables. Add a Data Environment to a Visual Basic Project using the Add Data Environment command. Establish a connection to a SQL Server database using the Data Link Properties dialog box. Display the structure of a SQL Server database. Create a SQL Stored  more...

Oracle 11i10 Order to Cash Invoicing Overview This course covers key concepts related to the AutoInvoicing and Receivables processes. Further, the course covers concepts related to the Bill Presentment Architecture (BPA). This course also discusses concepts related to implementing customer invoicing. Learn To: Identify key concepts related to the AutoInvoice process. Identify options for managing the AutoInvoice system  more...

Oracle 11i10 Order to Cash Porcessing Invoices ... adjustment. Identify key concepts related to reports, statements, and profile options. Unit 2: Managing Invoices Identify methods for correcting invoices. Create a credit memo. Identify features of transaction types. Identify key concepts related to printing transactions. Print a transaction. Create a Proxima Payment term and assign it to a customer for  more...

Oracle8 Database Administration - Manage Security ... with their descriptions. Specify the commands to audit statements by using an Oracle SQL Worksheet. Specify the command to audit a privilege by using an Oracle SQL Worksheet. Specify the command to audit a schema object by using Oracle SQL Worksheet. Specify the command to disable an audit option by using Oracle SQL Worksheet. Match the audit option views with the information they  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...

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 Internet App Dev Track for Forms Developer R6 6i Curriculum ...cludes the following courses: Oracle SQL: Basic SELECT Statements(ID#378) Oracle SQL: Data Retrieval Techniques(ID#379 Oracle SQL: DML and DDL(ID#380) Oracle PL/SQL: Basics(ID#322) Oracle PL/SQL: Procedures, Functions and Packages(ID#7745) Oracle PL/SQL: Database Programming(ID#7746) Oracle Developer: Forms Fundamentals(ID#470) Oracle Developer: Enhancing the User Interface(ID#471)  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...

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

CIW Dynamic Server Pages Part 1 ...ed result. • Select the piece of code that uses PHP statements to perform a specified task. • Identify the piece of code that uses PHP variable functions to perform a specified task. • Identify the output of a specified piece of code that uses PHP arrays. • Select the line of code that uses PHP array functions to perform a specified task. • Identify the piece of  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...

CIW Database Specialist Part 4 Advanced JDBC ...e and updateable result sets, batch updates, and prepared statements. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and Application Development in JDBC are also covered. Learn To: o Identify functions of DatabaseMetaData methods. o Identify methods for determining database schema. o Match the ResultSetMetaData methods with their descriptions.  more...

Security Part 4 Cryptography Operational Security ...features of certificate polices and Certificate Practices Statements (CPSs). Identify reasons for certificate revocation. Match trust models with their features. Identify standards for Public Key Infrastructure (PKI). Sort features of centralized and decentralized key management.  more...

Financial Management Accounting Fundamentals ... the simulations. Finally, you will learn about financial statements and what they tell you about the firm. Learn To: Identify functions of accounting. Sequence the steps in the accounting process. Identify key aspects of the accounting equation. Identify features of T-accounts. Identify features of accounts in a general ledger. Identify the types of financial  more...

WebSphere Studio 5 0 SOAP JavaBeans WSDL ... To identify the functions of code statements used for implementing an AXIS client. To identify requirements for document exchange messaging in AXIS. To identify features of the JavaBean component model. To identify features of JavaBean specification. To identify  more...

WebSphere Studio 5 0 SOAP JavaBeans WSDL ... To identify the functions of code statements used for implementing an AXIS client. To identify requirements for document exchange messaging in AXIS. To identify features of the JavaBean component model. To identify features of JavaBean specification. To identify  more...

Financial Management Series The Financial Management Series includes the following courses: Financial Management: Accounting Fundamentals Financial Management: Understanding Financial Statements Financial Management: Financial Planning & Forecasting Financial Management: Cash Analysis & Management Financial Management: Analyzing Financial Statements Financial Management: Inventory Costing & Depreciation  more...

Advanced Financial Statements Series The Advanced Financial Statements Series includes the following courses: Financial Statements: Financial Statements Analysis Financial Statements: Reading and Analyzing an Annual Report Financial Statements: Analyzing Cash Flows To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle Database 10g PL SQL Fundamentals Part 3 ...earn To: Match the stages in the execution of SQL statements with their descriptions. Identify features of dynamic SQL. Identify the features of the DBMS_SQL package. Identify guidelines for standardizing constants and exceptions. Identify benefits of using local subprograms. Sort the characteristics of the rights models according to their category. Identify features  more...

Six Sigma and Critical Customer Requirements Mark Twain once said, "Everybody talks about the weather but nobody does anything about it." Unlike the weather, serving customer needs is something companies actually can do something about. Quality Function Deployment (QFD) is a systematic process for motivating a business to focus on its customers. In a Six Sigma?? environment, such a focus is central to success. In this course, you'll learn  more...

Accounting Basics In this course, we investigate the basics of accounting. We introduce the skills and knowledge required to prepare and understand the financial plans and budgets that are crucial to the ongoing operation of an organisation. This course provides in depth coverage of Business and Information Management, Basic Accounting and Accounting Transactions.  more...

SAP FIGL101 - General Ledger Accounting ...ports such as Balance Sheets, Profit & Loss and Cash Flow Statements Release: ECC 6. 0 (newest SAP release) Audience: - End users - Accountants Prerequisite: - Basic SAP skills (SAP101) - A general understanding of financial accounting terms Exam & Certificate: - approx. 35 questions - Certificate of Completion CPE credits: 6. 0 Includes: - 12 lessons,  more...

HR401 - SAP Employee Self-Service ESS ...gency contacts - Review your pay slips and compensation statements - Record your own working time, request leaves and review your time statements Release: Enterprise Portal (ESS/ MSS) Audience: - End users Prerequisite: None Exam & Certificate: - Approx. 90 questions - Certificate of Completion CPE credits: 6. 5 Includes: - 13 lessons, approx. 6. 5 hours course  more...