Online Cursor eLearning
Cursor Training Provider? - Tell us about your Training!
 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 |
From 123-CBT Computer Based Training
Word 2002 Basic
...nd Key The Home Key Using Ctrl Key Combinations Moving Cursor To End Of Document Moving Insertion Point To Start Of Document The Page Up And Page Down Keys Moving Insertion Point To Next Page Moving Insertion Point To Previous Page Other Shortcuts The Go To Command Inserting Text Replacing Text The Overtype Feature Click And Type The Click And Type Pointer Changing The Zoom Level
more...
Word 2002 Basic
...nd Key The Home Key Using Ctrl Key Combinations Moving Cursor To End Of Document Moving Insertion Point To Start Of Document The Page Up And Page Down Keys Moving Insertion Point To Next Page Moving Insertion Point To Previous Page Other Shortcuts The Go To Command Inserting Text Replacing Text The Overtype Feature Click And Type The Click And Type Pointer Changing The Zoom Level
more...
Designing a SQL Server 2005 Cursor Strategy
Designing a SQL Server 2005 Cursor Strategy Microsoft
recognize how to design and implement an appropriate cursor strategy in SQL Server 2005
more...
Designing a SQL Server 2005 Cursor Strategy Microsoft
recognize how to design and implement an appropriate cursor strategy in SQL Server 2005
more...
Oracle Database 11g Using Exceptions Subprograms JDeveloper REF Cursors
Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper & REF Cursors Oracle
To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.
more...
Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper & REF Cursors Oracle
To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.
more...
Oracle Database 11g Optimizer Statistics Hints Cursor Sharing
...Cursor Sharing Oracle
Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course covers gathering optimizer and system statistics, setting statistic preferences, using dynamic sampling, and manipulating optimizer statistics. if you use SQL statements
more...
...Cursor Sharing Oracle
Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course covers gathering optimizer and system statistics, setting statistic preferences, using dynamic sampling, and manipulating optimizer statistics. if you use SQL statements
more...
Oracle Database 11g R2 Application Performance Enhancements
...ase 11g Release 2 is also improved by the use of adaptive cursor sharing, which allows for intelligent cursor sharing and the use of invisible indexes. It provides two different caches. The first cache includes SQL Query Result Cache used to cache query results or query blocks for future use, which reduces memory use and provides scalability. The second cache is the PL/SQL cross-section
more...
...ase 11g Release 2 is also improved by the use of adaptive cursor sharing, which allows for intelligent cursor sharing and the use of invisible indexes. It provides two different caches. The first cache includes SQL Query Result Cache used to cache query results or query blocks for future use, which reduces memory use and provides scalability. The second cache is the PL/SQL cross-section
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.
more...
...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.
more...
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
more...
...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
more...
Oracle SQL Tuning Tuning SQL and the Optimizer
...tify whether a given code uses an explicit or an implicit 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
more...
...tify whether a given code uses an explicit or an implicit 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
more...
Oracle Form Builder Including Reusable Oracle Components
...ase a data block on a stored procedure that returns a Ref cursor.
Write the code to base a data block on a stored procedure that returns a table of records.
Identify the properties of a data block based on a stored procedure.
Identify the performance implications specific to database calls using a particular data access mechanism.
Identify the guidelines to base a data block on a stored
more...
...ase a data block on a stored procedure that returns a Ref cursor.
Write the code to base a data block on a stored procedure that returns a table of records.
Identify the properties of a data block based on a stored procedure.
Identify the performance implications specific to database calls using a particular data access mechanism.
Identify the guidelines to base a data block on a stored
more...
Oracle8 Performance Tuning Managing Memory and Disk I O
...ps to determine the percentage of parse calls that find a cursor to share using GETHITRATIO column of the V$LIBRARYCACHE view
Perform the steps to determine the reloads-to-pins ratio from the V$LIBRARYCACHE view.
Identify the steps used to size the Library Cache.
Perform the steps to compute the amount of sharable memory that has been used using SELECT SUM query.
Perform the steps to
more...
...ps to determine the percentage of parse calls that find a cursor to share using GETHITRATIO column of the V$LIBRARYCACHE view
Perform the steps to determine the reloads-to-pins ratio from the V$LIBRARYCACHE view.
Identify the steps used to size the Library Cache.
Perform the steps to compute the amount of sharable memory that has been used using SELECT SUM query.
Perform the steps to
more...
Oracle Form Builder R6 Including Reusable Oracle Components
...data block based on a stored procedure that returns a REF cursor by using the Data Block Wizard. Create a data block based on the stored procedure that returns a table of records by using the Data Block Wizard. Identify the properties of a data block based on a stored procedure. Identify the performance implications of using stored procedures. Identify the guidelines to base a data block on
more...
...data block based on a stored procedure that returns a REF cursor by using the Data Block Wizard. Create a data block based on the stored procedure that returns a table of records by using the Data Block Wizard. Identify the properties of a data block based on a stored procedure. Identify the performance implications of using stored procedures. Identify the guidelines to base a data block on
more...
Oracle Reports R6 Enhance Reports
...he Object Navigator. Create ref queries by using the ref cursor query tool. Modify the properties of a query using Property Palette option in the Data Model. Create a data link between objects by using the link tool in the Data Model. Modify the database column to display the contents of a file by using the property palette. Identify the properties of a summary column. Create a formula
more...
...he Object Navigator. Create ref queries by using the ref cursor query tool. Modify the properties of a query using Property Palette option in the Data Model. Create a data link between objects by using the link tool in the Data Model. Modify the database column to display the contents of a file by using the property palette. Identify the properties of a summary column. Create a formula
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...
...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...
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...
...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...
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...
...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...
Oracle8i Performance Tuning Managing Memory Disk I O
...iew. Determine the percentage of parse calls that find a cursor to share by using the GETHITRATIO column of the V$LIBRARYCACHE view. Determine the reloads-to-pins ratio by using the V$LIBRARYCACHE view. Compute the amount of sharable memory that has been used by using the V$SQLAREA view. Keep a large object in memory by using the KEEP procedure of the DBMS_SHARED_POOL package. View the
more...
...iew. Determine the percentage of parse calls that find a cursor to share by using the GETHITRATIO column of the V$LIBRARYCACHE view. Determine the reloads-to-pins ratio by using the V$LIBRARYCACHE view. Compute the amount of sharable memory that has been used by using the V$SQLAREA view. Keep a large object in memory by using the KEEP procedure of the DBMS_SHARED_POOL package. View the
more...
Oracle PL SQL Procedures Functions Packages
... Identify the effect of the persistent state of a package cursor on dependent processor. Create the statement to remove a package. Perform the steps to start a debug session for a subprogram by using the PL/SQL Interpreter. Perform the steps to set a breakpoint by using the PL/SQL Interpreter in the Procedure Builder. Step through the code to determine the cause of an error by using the
more...
... Identify the effect of the persistent state of a package cursor on dependent processor. Create the statement to remove a package. Perform the steps to start a debug session for a subprogram by using the PL/SQL Interpreter. Perform the steps to set a breakpoint by using the PL/SQL Interpreter in the Procedure Builder. Step through the code to determine the cause of an error by using the
more...
Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3
...rver security implementations. Implement an appropriate cursor for a recordset object. C ontent Emphasis Skills-Based A udience This course is designed for programmers who need to create basic applications with Microsoft Visual Basic 6.0. Participants should have completed the first two courses in this series. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit
more...
...rver security implementations. Implement an appropriate cursor for a recordset object. C ontent Emphasis Skills-Based A udience This course is designed for programmers who need to create basic applications with Microsoft Visual Basic 6.0. Participants should have completed the first two courses in this series. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit
more...
Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3
...et from a Connection object. Identify the combination of cursor type and cursor location best suited in a specific situation. Identify the properties and methods that you will use for navigating a recordset in a given scenario. Identify the lock type best suited for a specific situation. Modify data in a SQL Server database by using the Connection object to directly execute SQL statements.
more...
...et from a Connection object. Identify the combination of cursor type and cursor location best suited in a specific situation. Identify the properties and methods that you will use for navigating a recordset in a given scenario. Identify the lock type best suited for a specific situation. Modify data in a SQL Server database by using the Connection object to directly execute SQL statements.
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...
...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
...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...
...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...
CIW Database Specialist Part 4 Advanced JDBC
This is the final course in a four part series that teaches metadata, improving JDBC programs, and building applications using JDBC. Topics covered include introduction to metadata and to ResultSetMetaData, SQL exceptions, scrollable and updateable result sets, batch updates, and prepared statements. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and
more...
This is the final course in a four part series that teaches metadata, improving JDBC programs, and building applications using JDBC. Topics covered include introduction to metadata and to ResultSetMetaData, SQL exceptions, scrollable and updateable result sets, batch updates, and prepared statements. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and
more...
From Serebra Learning Corporation
UNIX Editing Printing and Text Formatting
...ks; opening a file, navigating through a file, moving the cursor, deleting text, adding text and moving text. The course shows the student how to launch and quit the vi editor and explains how to work on multiple file and recover from a system crash. It introduces the student to command affect the entire file and describes hoe to use perviously specified patterns for improving editing
more...
...ks; opening a file, navigating through a file, moving the cursor, deleting text, adding text and moving text. The course shows the student how to launch and quit the vi editor and explains how to work on multiple file and recover from a system crash. It introduces the student to command affect the entire file and describes hoe to use perviously specified patterns for improving editing
more...
Scalability and Performance in Oracle9i
To describe the scalability and performance enhancements available in an Oracle9i database Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database
more...
To describe the scalability and performance enhancements available in an Oracle9i database Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database
more...
Using PL SQL with an Oracle Server
To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block Database administrators, application developers, and database operators
more...
To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block Database administrators, application developers, and database operators
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...
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...
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...
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...
Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 - Part 3
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 integrity.
more...
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 integrity.
more...
Microsoft Visual C++ 6.0: Designing and Implementing Applications - Part 8
This is the final course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment.
more...
This is the final course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment.
more...
SQL Server 7.0 Management Part III
....Additionally this course examines the functions of a SQL cursor including how to navigate a result set using a cursor. It describes different types of cursors and the meaning of the global and local scope of a cursor. It also explains how to design and manage explicit implicit and automatic transactions and it describes different locks. Related Exam: Microsoft exams #070-028 Administering
more...
....Additionally this course examines the functions of a SQL cursor including how to navigate a result set using a cursor. It describes different types of cursors and the meaning of the global and local scope of a cursor. It also explains how to design and manage explicit implicit and automatic transactions and it describes different locks. Related Exam: Microsoft exams #070-028 Administering
more...
Advanced Oracle PL/SQL: Design Considerations and Object Types
This course introduces students to subtypes subprograms cursor variables and the NOCOPY parameter used in advanced function definitions and packages. Students also learn about object types data dictionary views and collections.
more...
This course introduces students to subtypes subprograms cursor variables and the NOCOPY parameter used in advanced function definitions and packages. Students also learn about object types data dictionary views and collections.
more...
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 |
