Custom Search

> > > >

Online Cursors eLearning - Training Resources

Cursors Training Provider? - Tell us about your Training!

Matching Training Programs

online course

instructor-led class

learn at home

group study

self-directed study

cd-based training

DVD video training

printed book

e-book digital book

workshop seminar

train the trainer

computer-based learning

discount pricing

online tutorial

Cursors Training Seminars and Classes

From 123-CBT Computer Based Training

Explicit Cursors and Exception Errors

To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled more...

Oracle Database 11g Using Data Types INDEX BY Tables and Cursors in PL SQL

To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters. more...

Oracle Database 11g Using DML DDL Cursors Control Structures and Loops

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

IBM DB2 Universal Database V6 1--App Development

...ontains null values. Identify situations in which to use cursors in an application that contains embedded SQL. Code a statement that uses a specific type of cursor to manipulate data using embedded SQL. Code a positioned update using embedded SQL. Match SQLCA elements with the error-handling information they contain. Identify the transaction that produces a specific effect on a database. more...

IBM DB2 Universal Database V6 1--App Development

Oracle Form Builder R6 Writing and Debugging Code

...n in a trigger by using the attributes of PL/SQL implicit cursors. Identify 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 data sources other than Oracle. Match the commit status values returned by different system variables with more...

Oracle Form Builder Writing and Debugging Code

...n in a trigger by using the attributes of PL/SQL implicit cursors. Identify 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 more...

Visual C 6 0 Designing Implementing Distributed Applications - Part 3

...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 MFC library and Microsoft Visual C++. Participants should have completed the first seven courses in this series. T otal Learning Time more...

Visual InterDev 6 0 Accessing Remote Data

...s by using SQL, stored procedures, data access models and cursors. Implement business rules by using triggers. Identify the components of Remote Data Services (RDS). Identify the methods of navigating and manipulating data by using the components of Remote Data Services (RDS). Identify the benefits of using COM components. Create a COM component in Visual Basic 6. Register a more...

Visual InterDev 6 0 Accessing Remote Data

Oracle Database 10g PL SQL Fundamentals Part 1

...he 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 for handling nulls. Identify considerations for building Boolean conditions. Identify the syntax of loop statements. Identify the syntax for controlling explicit cursors. Identify the syntax for using cursor more...

Oracle SQL Tuning Tuning SQL and the Optimizer

...mplicit cursor. Identify the advantage of using explicit cursors. Identify the advantages of using explicit cursors. Identify the language that will process a given task in the minimum possible time. Identify the methods used for maintaining a shared pool. Identify the contents of a shared SQL area. Sequence the steps performed in the Oracle Server for processing a SQL statement. more...

SQL Server 7 0 - Implementing a Database - Part 3

...Perform the steps to update rows. Select the benefits of cursors. Select the methods for requesting a cursor. Select the uses of Transact-SQL cursors. Sequence the steps of the Transact-SQL cursor procedure. Match the types of cursors with their descriptions. Match the cursor characteristic with its description. Match the cursor syntax with its function. Identify the characteristics of more...

SQL and PL SQL PL SQL Basics

...PL/SQL commands Identify features and attributes of SQL cursors, and manage transactions. Use the IF-THEN-ELSE and IF-THEN-ELSIF conditional constructs and the Basic loop, FOR LOOP, and WHILE LOOP looping constructs to control flow in PL/SQL code. Declare and reference PL/SQL records and PL/SQL tables Identify the types and features of LOB datatypes. Understand cursors, how to operate more...

From Serebra Learning Corporation

Visual Basic 6 0 Database Access Part II

This course provides a detailed look at the ActiveX Data Object (ADO)that acts as the bridge between your application and a database. Designed for intermediate to advanced Visual Basic application programmers Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential. more...

Explicit Cursors and Exception Errors

To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled Database administrators, application developers, and database operators more...

Manipulating Data with DB2 UDB

To execute queries using SQL Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification more...

Microsoft SQL Server 7.0: Implementing a Database - Part 3

This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. more...

Advanced Features of Director 8 0

The Working with Advanced Features of Director 8 WBT is meant for end users and describes the various advanced features Director 8, and how to use them to create movies. Additionally, the course describes how to integrate a Flash movie with a Director movie, play movies on the Internet, and package movies for distribution. End users who are familiar with the Windows Graphical User Interface and more...

SQL Server 7.0 Management Part III

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

Oracle 8i PL/SQL - Oracle PL/SQL Basic Operations

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

SQL Advanced Skills

This course is the second course in the SQL Programming curriculum that consists of two courses. The course describes the statements used to manipulate data and to work with tables, indexes, and views. The students will also be able to describe the functioning of cursors, stored procedures, triggers, and transactions. more...

MS SQL Server 6.5: Advanced Retrieval Structures

In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of SQL Server. This course, together with MS SQL Server more...

JDBC and Databases

This course is the sixth in a series of seven on the Advanced Java Topics. This course teaches students how to add database functionality to a Java program using JDBC. The course covers connections cursors statements drivers and architectural issues. Recommended browser is Internet Explorer more...

From Learningdom

SQL and PLSQL Training

SQL Introduction to SQL, Select Queries, Data sorting and restricting, Functions, Data from Multiple Tables, Group By Clause, Create Table, Alter Table, Constraints, More Constraints, Indexes, Views, Set operators, SQL Aggregate Functions PL/ SQL PL/ SQL Basics, Using SQL*Plus for PL/ SQL, Using TOAD for PL/ SQL, All about variable declaration, PL/ SQL Looping, Conditional Logic, : DML more...

From The Virtual Training Company

Macromedia Flash 5 Techniques

As in Virtual Training Company's other "Techniques" tutorials, the Flash 5 Techniques tutorial takes the user through ten projects that concentrate on different skills needed to maximize this application. Author Rick Martin assumes you have a basic understanding of Flash 5 and goes step by step through projects like basic and advanced animated splash screens, scrolling text windows, flashing mask more...

From Teach Me IT

Advanced PL/SQL Programming

... triggers Apply database triggers Manipulate data using cursors Declare a cursor variable Integrate transactions with database Restrict database access by applying locks Control user access Define dynamic SQL Use DBMS_SQL to execute non-query DDL and DML statements Use the DBMS_SQL package to execute queries Identify the different types of exceptions Handle user-defined exceptions more...

SQL Advanced Skills

...s. Users will also be able to describe the functioning of cursors, stored procedures, triggers, and transactions. After completing this course, the user will be able to: Define a relational database Insert new records in an existing table Insert records from another table Update and delete data from a table Create and modify tables Create and manipulate indexes Create views, cursors, more...

Retrieving Data in SQL Server 2000

...lly, the users will learn to create stored procedures and cursors. After completing this course, the user will be able to: Insert and modify data in a database Retrieve data using a simple SELECT statement and with a JOIN clause Retrieve data based on conditions Retrieve data using subqueries Define, create, and modify views Modify data through views List the types of indexes Create more...

SQL Server 7.0 - Basic Programming

SQL Server 7.0 - Basic Programming course is the second course of the three courses in the Implementing SQL Server curriculum. The Implementing SQL Server curriculum prepares the students for the Microsoft Certification exam Implementing and Designing Databases with Microsoft SQL Server7.0 (70-029). This course introduces students to the basics of T-SQL. It also covers the skills required to more...

Working with Advanced Features of Director 8

...-frame animation Create a film loop Create controls and cursors Insert a Flash movie into a Director movie Insert other types of files in a movie List the various types of Lingo scripts Perform common tasks using Lingo Writing Lingo statements Use handlers in movies Use lists Use variables in movies Use operators to manipulate values Control flow in scripts Plan to publish movie on more...