Instructor Led Stored Procedures Training Classes
 online course |
 instructor led class |
 learn at home |
 group study |
 self directed training |
 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 Affinity IT Training, LLC
Structured Query Language SQL Using Sybase
Provides an introduction to all standard SQL statements and constructs.
Treatment of SQL is platform neutral, but will be delivered in the
Sybase environment. Coverage of Sybase ASE provides an introduction
to Transact-SQL, Transaction Managment, Stored Procedures, and Triggers.
Delivery format is a combination of Lectures and Labs.
Audience:Technical developers with a need to implement SQL in a
more...
Provides an introduction to all standard SQL statements and constructs.
Treatment of SQL is platform neutral, but will be delivered in the
Sybase environment. Coverage of Sybase ASE provides an introduction
to Transact-SQL, Transaction Managment, Stored Procedures, and Triggers.
Delivery format is a combination of Lectures and Labs.
Audience:Technical developers with a need to implement SQL in a
more...
Introduction To Sybase
Presents the basics of Sybase Adaptive Server
and its SQL programming language including
the use of stored procedures, cursors, and triggers.
Audience:Application developers wishing to integrate Sybase Adaptive Server into their IT solutions.
more...
Presents the basics of Sybase Adaptive Server
and its SQL programming language including
the use of stored procedures, cursors, and triggers.
Audience:Application developers wishing to integrate Sybase Adaptive Server into their IT solutions.
more...
Introduction to IBM DB2 Universal Database for Sybase Developers
Provides the student that has prior SQL or Sybase ASE experience
with the necessary basic skills
and fundamental knowledge of IBM DB2 UDB.
It includes information on the overall architecture of DB2 UDB,
basic to advanced DB2 UDB SQL syntax,
creating and using SQL Stored Procedures,
and an overview of basic administrative tasks
including creation of databases, tables, views, indexes,
the extraction
more...
Provides the student that has prior SQL or Sybase ASE experience
with the necessary basic skills
and fundamental knowledge of IBM DB2 UDB.
It includes information on the overall architecture of DB2 UDB,
basic to advanced DB2 UDB SQL syntax,
creating and using SQL Stored Procedures,
and an overview of basic administrative tasks
including creation of databases, tables, views, indexes,
the extraction
more...
Understanding ADO NET
In this course, you will learn how to retrieve and manipulate data using Microsoft's new
ADO.NET library. Understand how to work with the new ADO.NET object model,
including the DataReader, DataAdapter, and DataSet. See how to apply constraints
and relationships to disconnected data. Learn how to update data, including how
to handle stored procedures, parameters, and return values. Understand how
more...
In this course, you will learn how to retrieve and manipulate data using Microsoft's new
ADO.NET library. Understand how to work with the new ADO.NET object model,
including the DataReader, DataAdapter, and DataSet. See how to apply constraints
and relationships to disconnected data. Learn how to update data, including how
to handle stored procedures, parameters, and return values. Understand how
more...
Oracle 9i PL SQL Programming
Students will learn
the fundamentals of the PL/SQL programming language. Stored procedures,
functions, packages and triggers implement complex business rules in Oracle.
Students will learn programming, management and security issues of working with
PL/SQL program units.
Numerous exercises and labs will introduce
students to the new PL/SQL features in Oracle9.
Audience:Database administrators,
more...
Students will learn
the fundamentals of the PL/SQL programming language. Stored procedures,
functions, packages and triggers implement complex business rules in Oracle.
Students will learn programming, management and security issues of working with
PL/SQL program units.
Numerous exercises and labs will introduce
students to the new PL/SQL features in Oracle9.
Audience:Database administrators,
more...
DB2 -- Fast Track to Programming
Students will gain hands-on experience with the newest features of IBM
'
s DB2 Version 9.
Students will learn to create tables and manipulate data, tables and other database objects using ANSI-standard SQL and SQL Procedural Language extensions.
Coverage includes the special features and functions of the DB2, such as control of transactions, stored procedures, triggers, and cursors.
Good
more...
Students will gain hands-on experience with the newest features of IBM
'
s DB2 Version 9.
Students will learn to create tables and manipulate data, tables and other database objects using ANSI-standard SQL and SQL Procedural Language extensions.
Coverage includes the special features and functions of the DB2, such as control of transactions, stored procedures, triggers, and cursors.
Good
more...
Introduction To Sybase ASE 12 5 1
...ptive Server,
such as automatic recovery of transactions, stored procedures, triggers, and cursors.
In addition, you will learn to use good programming techniques
and develop strategies for writing efficient applications.
Audience:End-users and SQL developers who own, access or develop database and database applications managed by an Adaptive Server Database administrators. SQL developers who
more...
...ptive Server,
such as automatic recovery of transactions, stored procedures, triggers, and cursors.
In addition, you will learn to use good programming techniques
and develop strategies for writing efficient applications.
Audience:End-users and SQL developers who own, access or develop database and database applications managed by an Adaptive Server Database administrators. SQL developers who
more...
Introduction To MySQL
Learn to create tables and manipulate data, tables and other database objects
using ANSI-standard SQL and SQL extensions, and gain hands-on experience using MYSQL databases.
You will also learn the special features and functions of the MYSQL,
such as automatic recovery of transactions, stored procedures, triggers, and cursors.
In addition, you will learn to use good programming techniques
and
more...
Learn to create tables and manipulate data, tables and other database objects
using ANSI-standard SQL and SQL extensions, and gain hands-on experience using MYSQL databases.
You will also learn the special features and functions of the MYSQL,
such as automatic recovery of transactions, stored procedures, triggers, and cursors.
In addition, you will learn to use good programming techniques
and
more...
SQL Server 2000 Performance and Tuning
...stored procedures
for optimal performance.
This course thoroughly covers SQL Server 2000 Query Optimizer.
You will learn techniques to write high performance queries,
allowing the optimizer to use the most efficient query plan,
and diagnose and correct performance problems with already existing queries.
Additionally, you will learn to interpret optimizer statistics and how to use simulated
more...
...stored procedures
for optimal performance.
This course thoroughly covers SQL Server 2000 Query Optimizer.
You will learn techniques to write high performance queries,
allowing the optimizer to use the most efficient query plan,
and diagnose and correct performance problems with already existing queries.
Additionally, you will learn to interpret optimizer statistics and how to use simulated
more...
ADO NET Using Visual Basic 2005
...
connecting to data sources, the various ADO.NET classes,
stored procedures, parameters, return values, how to
search, sort, and filter data stored in a DataSet or DataTable.
Become familiar with strongly typed DataSets and learn their advantages.
See how to leverage the power of XML through various means. Examine new
ADO.NET features that support SQL Server 2005 technologies, including
more...
...
connecting to data sources, the various ADO.NET classes,
stored procedures, parameters, return values, how to
search, sort, and filter data stored in a DataSet or DataTable.
Become familiar with strongly typed DataSets and learn their advantages.
See how to leverage the power of XML through various means. Examine new
ADO.NET features that support SQL Server 2005 technologies, including
more...
ADO NET Using Visual C 2005
...
connecting to data sources, the various ADO.NET classes,
stored procedures, parameters, return values, how to
search, sort, and filter data stored in a DataSet or DataTable.
Become familiar with strongly typed DataSets and learn their advantages.
See how to leverage the power of XML through various means. Examine new
ADO.NET features that support SQL Server 2005 technologies, including
more...
...
connecting to data sources, the various ADO.NET classes,
stored procedures, parameters, return values, how to
search, sort, and filter data stored in a DataSet or DataTable.
Become familiar with strongly typed DataSets and learn their advantages.
See how to leverage the power of XML through various means. Examine new
ADO.NET features that support SQL Server 2005 technologies, including
more...
SQL Server 2005 Administration
...s using Transact-SQL.
Learn how to build effective views, stored procedures,
triggers, and user-defined functions, using Transact-SQL.
Learn about the new enhancements to the Transact-SQL
programming language including improved support for error handling
and hierarchical queries, and programmers can now use .NET languages
like C# and Visual Basic to build database objects.
Audience:Anyone
more...
...s using Transact-SQL.
Learn how to build effective views, stored procedures,
triggers, and user-defined functions, using Transact-SQL.
Learn about the new enhancements to the Transact-SQL
programming language including improved support for error handling
and hierarchical queries, and programmers can now use .NET languages
like C# and Visual Basic to build database objects.
Audience:Anyone
more...
SQL Server 2005 T-SQL
...nguage of
SQL Server. Learn how to build effective views, stored procedures,
triggers, and user-defined functions using Transact-SQL.
Learn about the new enhancements to the Transact-SQL programming
language including improved support for error handling and
hierarchical queries, and how programmers can now use .NET languages
like C# and Visual Basic to build database objects.
Audience:Database
more...
...nguage of
SQL Server. Learn how to build effective views, stored procedures,
triggers, and user-defined functions using Transact-SQL.
Learn about the new enhancements to the Transact-SQL programming
language including improved support for error handling and
hierarchical queries, and how programmers can now use .NET languages
like C# and Visual Basic to build database objects.
Audience:Database
more...
From Knowledge Cube
Oracle 10g Developer
...tions. Students learn to create anonymous PL/ SQL blocks, stored procedures, and functions. They learn about declaring variables and trapping exceptions. Students will also learn to develop stored procedures, functions, packages and database triggers. Students will learn to manage PL/ SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages.
more...
From Microsys Technologies and Solutions Pvt. Ltd.,
SQL Server Programming
Module 1: SQL Server Overview
Module 2: Overview of Programming SQL Server
Module 3: Creating and Managing Databases
Module 4: Creating Data Types and Tables
Module 5: Implementing Data Integrity
Module 6: Planning Indexes
Module 7: Creating and Maintaining Indexes
Module 8: Implementing Views
Module 9: Implementing Stored Procedures
Module 10: Implementing Triggers
Module 11: Optimizing Query
more...
Module 1: SQL Server Overview
Module 2: Overview of Programming SQL Server
Module 3: Creating and Managing Databases
Module 4: Creating Data Types and Tables
Module 5: Implementing Data Integrity
Module 6: Planning Indexes
Module 7: Creating and Maintaining Indexes
Module 8: Implementing Views
Module 9: Implementing Stored Procedures
Module 10: Implementing Triggers
Module 11: Optimizing Query
more...
SQL Server 2005 (Yukon)
.NET CLR Integration
Creating Stored procedures, user-defined functions, triggers using .NET
The SQL Server programming models
.Net user-defined types (UDT)
User Defined Aggregates (UDA)
Security Improvements
New Database Engine Features
New Transact SQL Features
XML Data Types
XQuery
HTTP Endpoints and Web Services
Service Broker
Client Libraries and enhancements
more...
.NET CLR Integration
Creating Stored procedures, user-defined functions, triggers using .NET
The SQL Server programming models
.Net user-defined types (UDT)
User Defined Aggregates (UDA)
Security Improvements
New Database Engine Features
New Transact SQL Features
XML Data Types
XQuery
HTTP Endpoints and Web Services
Service Broker
Client Libraries and enhancements
more...
From Spectra Mind Solutions
CIW Database Specialist Part 4: Advanced JDBC
...d statements with their functions.
Identify features of stored procedures in JDBC.
Unit 3: Building Applications Using JDBC
Identify features of Swing.
Match basic Swing components with their functions.
Identify commonly used features of layout managers.
Identify features of events.
Sequence the steps in the event handling process.
Identify features of a JTable.
Identify
more...
...d statements with their functions.
Identify features of stored procedures in JDBC.
Unit 3: Building Applications Using JDBC
Identify features of Swing.
Match basic Swing components with their functions.
Identify commonly used features of layout managers.
Identify features of events.
Sequence the steps in the event handling process.
Identify features of a JTable.
Identify
more...
From Hands On Technology Transfer, Inc.
Microsoft SQL Server 2000 Database Development
...ng indexes; building transactions & triggers and creating stored procedures; relational database concepts; SQL vocabulary; a terminology guide; key features of SQL Server; a comprehensive guide to the SQL Server tools, including Enterprise Manager and Query Analyzer; and database implementation basics. The course also shows how to install and configure SQL Server, create and manage databases
more...
From Save On Training
Implementing SQL Server 2005
...n Microsoft SQL Server 2005 by using triggers.
Implement stored procedures.
Implement functions.
Implement managed code in the database.
Manage transactions and locks.
Use Service Broker to build a messaging-based solution.
Use Notification Services to generate and send notifications.
Prerequisites
Before attending this course, students must have:
Basic knowledge of the Microsoft
more...
...n Microsoft SQL Server 2005 by using triggers.
Implement stored procedures.
Implement functions.
Implement managed code in the database.
Manage transactions and locks.
Use Service Broker to build a messaging-based solution.
Use Notification Services to generate and send notifications.
Prerequisites
Before attending this course, students must have:
Basic knowledge of the Microsoft
more...
From Boston University Corporate Education Center
Oracle Database 10g Program with PL SQL
...ions.
Students learn to create anonymous PL/SQL blocks, stored procedures, and functions. They learn about declaring variables and trapping exceptions. Students will also learn to develop stored procedures, functions, packages and database triggers. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages.
more...
...ions.
Students learn to create anonymous PL/SQL blocks, stored procedures, and functions. They learn about declaring variables and trapping exceptions. Students will also learn to develop stored procedures, functions, packages and database triggers. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages.
more...
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
...ssues. The first exercise shows students how to determine stored procedures involved in a deadlocked situation. The second exercise shows students how to determine the source of a blocking issue. The third exercise shows students how to evaluate wait types and latches.
Lessons
The Methodology of Troubleshooting Concurrency Issues What Are SQL Server Latches? Activity: Choosing a
more...
...ssues. The first exercise shows students how to determine stored procedures involved in a deadlocked situation. The second exercise shows students how to determine the source of a blocking issue. The third exercise shows students how to evaluate wait types and latches.
Lessons
The Methodology of Troubleshooting Concurrency Issues What Are SQL Server Latches? Activity: Choosing a
more...
Implementing a Microsoft SQL Server 2005 Database
...gers, and XML schemas. Implement views. Implement stored procedures and functions. Implement managed code in the database. Use Service Broker to build a messaging-based solution.
Prerequisites Before attending this course, students must have:
Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL.
more...
...gers, and XML schemas. Implement views. Implement stored procedures and functions. Implement managed code in the database. Use Service Broker to build a messaging-based solution.
Prerequisites Before attending this course, students must have:
Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL.
more...
From The Career Center
SQL Database Design & Implementation
This course teaches you how to use the Transact-SQL language to query and program Microsoft
SQL Server 2000 in a Windows Server Server environment. This course also assists you in preparing
for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator
Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise
Edition.
Upon successful
more...
This course teaches you how to use the Transact-SQL language to query and program Microsoft
SQL Server 2000 in a Windows Server Server environment. This course also assists you in preparing
for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator
Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise
Edition.
Upon successful
more...
From Boston University Corporate Education Center
Advanced Java Programming
...base Objects DML Retrieving and Managing Data Sequences Stored Procedures Using SQL Terminals
2. JDBC Fundamentals
What is the JDBC API? JDBC Drivers Making a Connection Creating and Executing a Statement Retrieving Values from a ResultSet SQL and Java Datatypes Creating and Updating Tables Handling SQL Exceptions and Proper Cleanup Handling SQLWarning
3. Advanced JDBC
SQL Escape
more...
...base Objects DML Retrieving and Managing Data Sequences Stored Procedures Using SQL Terminals
2. JDBC Fundamentals
What is the JDBC API? JDBC Drivers Making a Connection Creating and Executing a Statement Retrieving Values from a ResultSet SQL and Java Datatypes Creating and Updating Tables Handling SQL Exceptions and Proper Cleanup Handling SQLWarning
3. Advanced JDBC
SQL Escape
more...
Updating Your Database Development Skills to Microsoft SQL Server 2005
... Objects ? Programming Objects ? UDF ? Triggers ? Stored Procedures ? Optimization ? SQL XML ? .NET Development (Visual Basic .NET or C# .NET) ? ADO.NET ? In addition, it is recommended, but not required, that students have completed:
? Course 2073, Programming a Microsoft SQL Server 2000 Database. Microsoft Certified Professional Exams No Microsoft Certified
more...
... Objects ? Programming Objects ? UDF ? Triggers ? Stored Procedures ? Optimization ? SQL XML ? .NET Development (Visual Basic .NET or C# .NET) ? ADO.NET ? In addition, it is recommended, but not required, that students have completed:
? Course 2073, Programming a Microsoft SQL Server 2000 Database. Microsoft Certified Professional Exams No Microsoft Certified
more...
From Webucator
Java Servlets and JDBC Training
This practical, application-oriented Java training course teaches Java Servlets technology and shows how to use it to develop simple to complex Web applications. It is intended for experienced Java (J2SE) programmers who want to build Web applications or J2EE components and systems. The course also provides in-depth coverage of database programming using JDBC and introduces the JDBC architecture
more...
This practical, application-oriented Java training course teaches Java Servlets technology and shows how to use it to develop simple to complex Web applications. It is intended for experienced Java (J2SE) programmers who want to build Web applications or J2EE components and systems. The course also provides in-depth coverage of database programming using JDBC and introduces the JDBC architecture
more...
From Boston University Corporate Education Center
Administering a Microsoft SQL Server 2000 Database
...ity within SQL Server. Manage security with views and stored procedures. Create and use application roles to manage application security. Manage SQL Server security in the enterprise environment.
Module 5: Performing Administrative Tasks
The following topics are covered in this module:
Configuration TasksRoutine SQL Server Administrative TasksAutomating Routine Maintenance
more...
...ity within SQL Server. Manage security with views and stored procedures. Create and use application roles to manage application security. Manage SQL Server security in the enterprise environment.
Module 5: Performing Administrative Tasks
The following topics are covered in this module:
Configuration TasksRoutine SQL Server Administrative TasksAutomating Routine Maintenance
more...
From IT Centers LLC
Microsoft MCITP: Database Developer
Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database designers and developers. This credential demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005.
Database developers design and implement relational database models (logical and physical) and database storage
more...
Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database designers and developers. This credential demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005.
Database developers design and implement relational database models (logical and physical) and database storage
more...
online course |
instructor led class |
learn at home |
group study |
self directed training |
cd based training |
DVD video training |
printed book |
e-book digital book |
workshop seminar |
train the trainer |
computer based learning |
discount pricing |
online tutorial |
