|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
| Training Seminars
| Training Providers
| Regions
|
| Advertise Training Seminars
| Login
|
||||||||||||||||||||||||
Custom Search
Stored Procedures Training Seminars and Classes
From Serebra Learning Corporation
JDBC Application Development Part 3: Advanced Features, OOAD and SQLJ
 This third course in the series teaches learners skills needed to help them create more advanced databases. It teaches advanced features for creating JDBC programs, including prepared statements, stored procedures, transactions, concurrency control, and metadata. It also teaches how to map an object-oriented design to a relational database and how to use SQLJ standards with Java. more...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...Visual Basic 6 0 Advanced Enterprise Client Server Dev Part I
...ser groups. This course discusses the merits of using SQL stored procedures for business services and data integrity checks. It describes how to create, write, and debug stored procedures, as well as how to call them from Visual Basic code. Finally, this course discusses how to create SQL stored procedures for passing arguments and accepting return values. It also explains how to write SQL 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 C# programmers and candidates for the Microsoft MCSD and MCAD certification paths 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 Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths more...Building ADO NET DataSets
To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths more...Actuate Developer Workbench Fundamentals
Actuate Developer Workbench Fundamentals WBT is meant for users who want to create reports based on data contained in databases. The course describes the features of Actuate Developer Workbench, and familiarizes users with creating simple and complex reports. Users who want to create simple and complex reports using Actuate Developer Workbench. more...PL SQL Triggers
To create and manage triggers Database administrators, application developers, and database operators more...Creating Stored Procedures and Functions
To create and execute a stored function and call, and remove and view stored functions in PL/SQL 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...SQL Server 7.0 Management Part II
This course provides the skills to database administrators managers and users so that they may take full advantage of SQL Server 7.0 features. It explains how to use the fundamental elements of Transact-SQL how to use the SELECT statement and how to monitor database performance. It also examines stored procedures and joins. Related Exam: Prepares users for both Microsoft Exams #070-028 more...SQL Server 7.0 Management Part III
...uage 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 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 more...Oracle 8i DBA - Data Dictionary and Database Files
The course is aimed at familiarizing the student with the Data Dictionary views and database files. The course enables the learner to manage log and control files. The uses and contents of control files will be discussed as well as obtaining information from control files. The planning use and troubleshooting of redo log files will also be explained. The course also provides a list of Data more...MS SQL Server 2000: Design and Implementation Part 3: Managing Objects
  This is the third course in a five part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers. more...Microsoft Access 2000 Designing and Implementing Database Applications Part 4 - Debugging Applicatio
This is the fourth course in a five-part series that will provide IT professionals with the knowledge and skills necessary to design and implement database solutions using Microsoft Access 2000. At the completion of this course students will learn to manage data in tables by using ActiveX Data Objects (ADO) recordsets and SQL; identify code to create and manage stored procedures and triggers; and more...Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries
This course will teach students how to work with queries. The course will also introduce views stored procedures triggers and user-defined functions. more...MS SQL Server 2000: Design and Implementation Part 3: Managing Objects
This is the third course in a five part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view stored procedures user-defined functions and triggers. more...Oracle PL/SQL: Database Programming
This is the second course in a two part series that discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored subprograms and more...Oracle9i PL/SQL: Database Programming
...ackages. Participants will learn how to create and invoke stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. Participants will learn how to manage stored subprograms and packages. This course also introduces participants to database triggers: how to create them and 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...Advanced SQL Programming
This course teaches the student how to create stored procedures, manage distributed data and transactions. The student will also learn the importance of locks and how to troubleshoot a deadlock. Finally the student will learn how to optimize the query execution plan developed by SQL Server. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029. more...
From 123-CBT Computer Based Training
Oracle9i Database Admin Create a Database
 ...e scripts categories. • Identify the properties of stored procedures and packages, the benefits of using stored program units, and the functions of Oracle-supplied packages. • Retrieve information about stored objects, identify the common situations when dependent objects may have an INVALID status, and the functions of the control file with the types of information stored. more...SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries
... work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions. Learn To Identify advantages of using aliases for table names. Identify the guidelines for using joins. Identify the considerations for using inner joins. Identify considerations for using subqueries. Create a derived table by using a subquery. Create a single-value more...SQL Server 2000 Design Implement Databases Part 3 Managing Objects
...jects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different user-defined functions with their characteristics. Create a user-defined function by using Transact-SQL. Identify more...IBM DB2 Universal Database V6 1--App Development
...s schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application developers. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, more...IBM DB2 Universal Database V6 1--App Development
...s schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application developers. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, more...IBM DB2 Universal Database V6 1 App Devel Curriculum
...ts such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and dynamic SQL within an application. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13433 IBM DB2 Universal Database V6.1 Application Development Certification: This curriculum will help candidates prepare for the ILT more...IBM DB2 Universal Database V6 1 App Devel Curriculum
...ts such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and dynamic SQL within an application. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13433 IBM DB2 Universal Database V6.1 Application Development Certification: This curriculum will help candidates prepare for the ILT more...Oracle PL SQL Database Programming
... packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored subprograms and packages. It also introduces learners to database triggers: how to create them and their application to more...Oracle8i Database Admin Create Databases
...ckage components they create. Identify the properties of stored procedures. Identify the properties of packages. Identify the benefits of stored program units. Match the Oracle-supplied packages with their functions. Retrieve information about invalid objects in a specified database by querying the required data dictionary view. Retrieve information about a stored program unit more...Oracle Form Builder R6 Including Reusable Oracle Components
...rocedure. Identify the performance implications of using stored procedures. Identify the guidelines to base a data block on a stored procedure. Identify the restrictions on performing database operations on data source objects. Unit 2: Oracle8 Objects in Form Builder Duration: 1 - 2 Hour(s) Identify the Oracle8 objects features. Identify how Oracle Developer treats Objects in the more...Oracle8 Database Administration - Create Databases
...rmation.
Identify the properties and benefits of using stored procedures and packages.
Plan for the creation of redo log files.
Plan for the maintenance of redo log groups.
Redo log members.
Control files.
Identify the process of log switches and checkpoints.
Manage tablespaces and data files.
C ontent Emphasis
Skills-Based
A udience
Database Administrators, more...Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3
...mand, navigating recordsets, modifying data and executing stored procedures. C ontent Emphasis Skills-Based A udience This course is designed for programmers using Visual Basic 6.0 and are currently building desktop applications and accessing corporate databases. Participants should have completed the first two courses in this series. T otal Learning Time 6 - 8 Hour(s) 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 InterDev 6 0 Accessing Remote Data
...ordset size.
Manipulate database records 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 more...Visual InterDev 6 0 Accessing Remote Data
...ordset size.
Manipulate database records 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 more...Visual InterDev 6 0 Active Server Pages and Data Access
C ourse Overview
This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to identify the features of Active Server Pages (ASP); create a server script and debug the server-side script; more...Oracle Database 10g PL SQL Fundamentals Part 1
...e and use PL/SQL program units, such as stored functions, stored procedures, and packages along with some standard Oracle supplied packages and exception handling techniques in PL/SQL.
Learn To:
Identify features of PL/SQL.
Identify benefits of PL/SQL.
Identify features of PL/SQL blocks.
Audience:
The target course audience is Data Administrators, PL/SQL Developers, and more...SQL Server 7 0 System Administration - Part 5
...the replication system components with appropriate system stored procedures.
Use the replication monitor to view agent histories.
Use the SQL Server Query Analyzer to test connectivity.
Identify the ODBC driver requirements for SQL Server replication.
Use replication wizards to publish data to heterogeneous subscribers.
Identify features of the SQL-DMO object structure.
Perform the steps more...SQL Server 7 0 System Administration - Part 2
...ng security for linked databases.
Identify how views and stored procedures can be used to simplify security.
Distinguish between application roles and other roles.
Perform the steps for creating an application role for users/logins within SQL Server Enterprise Manager.
Perform the steps for activating an application role for users/logins using Transact-SQL.
Identify the recommended more...SQL Server 7 0 - Implementing a Database - Part 5
... 6 - 8 Hour(s) Course Contents Unit 1: Implementing Stored Procedures Duration: 2 - 3 Hour(s) Match the type of stored procedure with its definition. Sequence the steps of the initial processing of stored procedures. Select the characteristics of subsequent stored procedure processing. Select the advantages of stored procedures. Perform the steps for creating stored procedures. more...Visual Basic NET-Web Based Development Part 3
Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security more...Oracle Database 10g PL SQL Fundamentals Part 2
...arn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers.
Learn To:
Identify features of PL/SQL blocks within a subprogram.
Match types of PL/SQL named blocks with their descriptions.
Match types of PL/SQL environments with their descriptions.
Identify features of PL/SQL packages.
Sequence steps for developing more...
From Teach Me IT
SQL Advanced Skills
...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, and stored more...Retrieving Data in SQL Server 2000
...text search. Additionally, 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 more...Advanced SQL Programming
...L Programming. This course teaches students how to create stored procedures, manage distributed data, and transactions. The students also learn the importance of locks and how to troubleshoot a deadlock. Finally the students learn how to optimize the query execution plan developed by SQL Server.
1. Advanced Programming Features
A. Stored procedures
B. Distributed Data
C. more...Actuate Developer Workbench Fundamentals
Actuate Developer Workbench Fundamentals WBT is meant for users who want to create reports based on data contained in databases. The course describes the features of Actuate Developer Workbench, and familiarizes users with creating simple and complex reports. After completing this course, the users will be able to:
List the benefits of using Actuate Developer Workbench
List the components of more...
From Skillspride Online Training
Informix Stored Procedures and Triggers
This course aims to take users through the Informix language. Users will gain an appreciation of privileges, trigger creation, system tables, error handling, ESQL/C and other advanced Informix functions. more...Microsoft SQL Server 2000; Introduction to Databases and Programming
This course introduces readers to the major topics of databases and programming using Microsoft SQL Server 2000. The reader will learn about system databases, tables, data definition, creating tables, retrieving data, modifying data, indices, data integrity, views, triggers, stored procedures, programmability, distributed data and distributed transactions. Throughout the course there are practical more...Microsoft SQL Server 2000 Programming Part 1
This course along with our " SQL Server 2000 Programming Part 2 course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML. more...Microsoft SQL Server 2000 Programming Part 2
This course along with our " SQL Server 2000 Programming Part 1 course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML. more...
| ||||||||||||||||||||||||
|
| ||||||||||||||||||||||||
| Training Directory | New Training Seminars | New Training Providers | | Site Map | Promote Training | Login | Links | ||
|
| ||
| Training-Classes.com by Skillbox® 07/26/08 Copyright 1998-2008 skillbox, inc. All rights reserved |
 |
|
| Are you a Stored Procedures training provider? |
| You could be on this page today - for FREE! |
