Instructor Led Sql Stored Procedures Training
Sql Stored Procedures Training Provider? - Tell us about your Training!
Please select the location nearest to you:
United Kingdom
United States
India
Canada
South Africa
Pakistan
 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 Wise Owl Business Solutions Ltd
Advanced SQL
If you are comfortable creating queries in SQL, maybe it is time to move on to learn more advanced programming topics? This three day course assumes that you know how to use the main SQL keywords SELECT, FROM, WHERE, GROUP BY and ORDER BY, and shows you how to really progam in SQL Server. Learn how to write stored procedures, create 3 different types of function, use subqueries effectively - and
more...
Advanced SQL
If you are comfortable creating queries in SQL, maybe it is time to move on to learn more advanced programming topics? This three day course assumes that you know how to use the main SQL keywords SELECT, FROM, WHERE, GROUP BY and ORDER BY, and shows you how to really progam in SQL Server. Learn how to write stored procedures, create 3 different types of function, use subqueries effectively - and
more...
SSRS 2005
In the current business environment organisations need to be able to transform data into clear, concise, user-friendly formats. This two-day SQL Server Reporting Services (SSRS) course shows you how to create, execute and manage reports. Using SQL Server 2005 Business Intelligence Studio you will create interactive reports and learn how to deploy and export them in various formats. You will
more...
In the current business environment organisations need to be able to transform data into clear, concise, user-friendly formats. This two-day SQL Server Reporting Services (SSRS) course shows you how to create, execute and manage reports. Using SQL Server 2005 Business Intelligence Studio you will create interactive reports and learn how to deploy and export them in various formats. You will
more...
Writing SQL
You may have a fantastic database, but unless you can extract useful information from it, it may as well not exist! This two-day course shows you how to mine your database, from getting a mailing list of people meeting certain criteria through to compiling summary information for the board. Note that the SQL language varies slightly between different database providers; this course teaches the
more...
You may have a fantastic database, but unless you can extract useful information from it, it may as well not exist! This two-day course shows you how to mine your database, from getting a mailing list of people meeting certain criteria through to compiling summary information for the board. Note that the SQL language varies slightly between different database providers; this course teaches the
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...
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...
From Wintrac Inc.
Develop Oracle 9i PL-SQL Program Units
An essential component of client/ server application development is the creation of database server-side program units. This course discusses the subjects of database triggers and stored procedures. Advanced topics such as using system-supplied packages, programming for superior performance, object oriented encapsulation of logic into packages and many others are discussed in detail.
You can get
more...
Oracle8i PL-SQL Programming
This class is for those entering the world of Oracle application development either having previous Oracle or other relational database experience. You will learn the critical aspects of Oracle development including cursors, stored procedures and functions, triggers, error handling and tuning basics. Hands-on workshops constitute approximately 50% of the class.
You can get a complete list of
more...
Introduction to Oracle8i for Sybase Developers
This class is the starting point for all developers with Sybase experience entering the world of Oracle application development. You will leverage your existing Sybase skills to rapidly learn the critical aspects of Oracle development including working with SQL*Plus, writing PL/ SQL programs, creating stored procedures, calling Oracle Supplied Packages, creating Java procedures and creating
more...
Introduction to Oracle8i for Developers
This class is the starting point for all developers entering the world of Oracle application development. You will learn the critical aspects of Oracle development including SQL, SQL*PLUS, stored procedures, and triggers. Hands-on workshops constitute approximately 50% of the class. Overviews of relational concepts and Oracle architecture are also provided.
You can get a complete list of
more...
Introduction to Oracle9i for Sybase Developers
This class is the starting point for all developers with Sybase experience entering the world of Oracle application development. You will leverage your existing Sybase skills to rapidly learn the critical aspects of Oracle development including working with SQL*Plus, writing PL/ SQL programs, creating stored procedures, calling Oracle Supplied Packages, creating Java procedures and creating
more...
Oracle9i PL-SQL Programming
This class is for those entering the world of Oracle application development either having previous Oracle or other relational database experience. You will learn the critical aspects of Oracle development including cursors, stored procedures and functions, triggers, error handling and tuning basics.
You can get a complete list of other Oracle classes at
more...
Introduction to Oracle9i for Developers
class is the starting point for all developers entering the world of Oracle application development. You will learn the critical aspects of Oracle development including SQL, SQL*PLUS, stored procedures, and triggers. Hands-on workshops constitute approximately 50% of the class. Overviews of relational concepts and Oracle architecture are also provided.
You can get a complete list of other Oracle
more...
T-SQL 2005 WITH ADVANCED TOPICS
In this course, you'll start by learning about the basic features that are available in SQL Server, including how to design and create a database and how to build queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You'll learn about the new enhancements to the
more...
WRITING T-SQL QUERIES IN SQL SERVER 2005
In this course, youa ™ll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and
more...
PROGRAMMING DATABASES WITH MICROSOFT SQL SERVER 2000 - LEVEL 2
This course shows you how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL (T-SQL), the programming language of SQL Server. You'll also learn how to take advantage of SQL Server's tools for maintaining, securing, and tuning your databases.
You can get a complete list of other Sql server classes at
more...
T-SQL 2008
In this course, you will learn about the features that are available in SQL Server like how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for
more...
Microsoft SQL Server 2008 for Developers
In this course, you'll see an overview tour of SQL Server 2008 including its editions, components, and tools. Then you will learn about the steps to install, and/ or upgrade to SQL Server 2008 and configuring the server. You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management
more...
DB2 UDB for zOS Version Nine - Technical Introduction
Describe the new features and enhancements of DB2 UDB for z/ OS Version Nine. Evaluate the usefulness of the new features and enhancements of DB2 UDB for z/ OS Version Nine.
This course cover a Technical Introduction to the following NEW SQL Features of DB2 UDB for z/ OS Version Nine, including the following - pureXML, New Data Types (bigger BINARY, VARBINARY, BIGINT, DECFLOAT), INSTEAD OF
more...
From L'Obel IT-Palaestra
L'Obel Certified Erwin Training
L'Obel Certified Erwin Training
L'Obela ™s Erwin course will help you acquire advanced skills for becoming a skilled Data Warehouse Specialist.
Internship Options
L'Obel ITP is unique in its training and delivery methodology as it is the first in India to provide the participant Hi-End technology training followed by rigorous INTERNSHIP in its SOFTWARE DEVELOPMENT CENTER. This gives
more...
From Software Training Academy, Inc
SQL Server 2005 Transact SQL T-SQL with Additional Topics
In this course, you'll start by learning about the basic features that are available in SQL Server, including how to design and create a database and how to build queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You'll learn about the new enhancements to the
more...
In this course, you'll start by learning about the basic features that are available in SQL Server, including how to design and create a database and how to build queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You'll learn about the new enhancements to the
more...
SQL Server 2008 Transact SQL (T-SQL)
In this course, you will learn about the features that are available in SQL Server like how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for
more...
In this course, you will learn about the features that are available in SQL Server like how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for
more...
SQL Server 2008 for developers
In this course, you'll see an overview tour of SQL Server 2008 including its editions, components, and tools. Then you will learn about the steps to install, and/ or upgrade to SQL Server 2008 and configuring the server. You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management
more...
In this course, you'll see an overview tour of SQL Server 2008 including its editions, components, and tools. Then you will learn about the steps to install, and/ or upgrade to SQL Server 2008 and configuring the server. You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management
more...
SQL Server 2008 Reporting Services
In this course, you will learn how to use SQL Server 2008 Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS 2008. Youa ™ll then explore tabular and list reports that employ datasets and data regions. As you progress youa ™ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL
more...
In this course, you will learn how to use SQL Server 2008 Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS 2008. Youa ™ll then explore tabular and list reports that employ datasets and data regions. As you progress youa ™ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL
more...
Oracle 10g 11g PL SQL Programming
...ng, array processing and error handling
Create PL/ SQL stored procedures that accept and return values or sets of values
Manage stored procedure dependencies and privileges
Create PL/ SQL functions, including powerful table functions and pipelined table functions
Create database triggers for auditing, complex business rule support, simple replication and more
more...
...ng, array processing and error handling
Create PL/ SQL stored procedures that accept and return values or sets of values
Manage stored procedure dependencies and privileges
Create PL/ SQL functions, including powerful table functions and pipelined table functions
Create database triggers for auditing, complex business rule support, simple replication and more
more...
From Kogent
BOR210 - BusinessObjects Desktop Intelligence XI R2 - Report Design
BOR210: BusinessObjects Desktop Intelligence XI R2 - Report Design
Desktop Intelligence is an integrated query, reporting and analysis solution that allows business users to access the data in their corporate databases directly from their desktop and present and analyze this information in a Desktop Intelligence document.
This course is designed to give learners comprehensive skills and
more...
From Hands On Technology Transfer, Inc.
SQL Programming
This SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand
more...
This SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand
more...
Microsoft Transact-SQL Programming
This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course covers T-SQL programming constructs, predefined data types including XML, deployment of stored procedures and triggers, use
more...
This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course covers T-SQL programming constructs, predefined data types including XML, deployment of stored procedures and triggers, use
more...
From Open Source Training
SQL Programming
This SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand
more...
From NobleProg - IT training courses
Oracle Database 11g Performance Tuning
Module 1. Basic Tuning Tools
* Monitoring tools overview
* Enterprise Manager
* V$ Views, Statistics and Metrics
* Wait Events
Module 2. Using Automatic Workload Repository
* Managing the Automatic Workload Repository
* Real Time SQL Monitoring
Module 3. Defining Problems
* Defining the Problem
* Limit the Scope and Setting the Priority
*
more...
Module 1. Basic Tuning Tools
* Monitoring tools overview
* Enterprise Manager
* V$ Views, Statistics and Metrics
* Wait Events
Module 2. Using Automatic Workload Repository
* Managing the Automatic Workload Repository
* Real Time SQL Monitoring
Module 3. Defining Problems
* Defining the Problem
* Limit the Scope and Setting the Priority
*
more...
ORACLE PLSQL Fundamentals
This 3 day course gives an introduction to ORACLE PL/ SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/ SQL commands.
The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core
more...
This 3 day course gives an introduction to ORACLE PL/ SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/ SQL commands.
The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core
more...
Advanced SQL Stored Procedures Triggers for Microsoft SQL Server Training Course
The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL.
Requirements
Delegates should be familiar with the Microsoft SQL Server SQL Language
more...
The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL.
Requirements
Delegates should be familiar with the Microsoft SQL Server SQL Language
more...
From Last Minute Training
Writing Queries Using Microsoft SQL Server 2005 T-SQL - CTE
In this course, you ll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL.
more...
Writing Queries Using Microsoft SQL Server
In this course, you ll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL.
more...
Implementing a Microsoft SQL Server 2005 Database - nexient
Who should attend?
This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.
Performance Objectives
After completing this course, students will be able to:
Create databases and database files.
Create data types and tables.
Use XML-related features in Microsoft SQL Server 2005.
Plan,
more...
From Saryx
SQL Server
Overview of the course content:
Installing SQL Server 2005
a Meeting the Prerequisites
a Preparing to Install
a Upgrading from a Previous Version
a Installing SQL Server 2005
a Installing a Second Instance
a Troubleshooting the Installation
Module 2: Implementing Security in
SQL Server 2005
a Understanding Security Modes
a Understanding SQL Server Logins
a
more...
Overview of the course content:
Installing SQL Server 2005
a Meeting the Prerequisites
a Preparing to Install
a Upgrading from a Previous Version
a Installing SQL Server 2005
a Installing a Second Instance
a Troubleshooting the Installation
Module 2: Implementing Security in
SQL Server 2005
a Understanding Security Modes
a Understanding SQL Server Logins
a
more...
From eVentureSolutions (EVS)
Certified SQL Server Specialist
SQL Server offers a robust architecture for enterprise data management, developer productivity and business intelligence. This course provides the knowledge and practical skills needed to maximize the benefits of SQL Server. Participants gain a solid ground on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL
more...
From Modulus
T-SQL 2008
In this course, you will learn about the features that are available in SQL Server such as how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for
more...
In this course, you will learn about the features that are available in SQL Server such as how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for
more...
SQL Server 2008 for Developers
In this course, you'll see an overview tour of SQL Server 2008 including its editions, components, and tools. Then you will learn about the steps to install, and/ or upgrade to SQL Server 2008 and configuring the server. You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management
more...
In this course, you'll see an overview tour of SQL Server 2008 including its editions, components, and tools. Then you will learn about the steps to install, and/ or upgrade to SQL Server 2008 and configuring the server. You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management
more...
Introduction to Oracle 10g PLSQL Programming Training
PL/ SQL is Oracle's embedded procedural database language, allowing developers and administrators to write scripts, stored procedures, functions, packages, and database triggers which run in the optimized environment of the Oracle Database server. The Oracle10g release has greatly enhanced the features and functionality of PL/ SQL. This advanced course helps PL/ SQL programmers take advantage of
more...
PL/ SQL is Oracle's embedded procedural database language, allowing developers and administrators to write scripts, stored procedures, functions, packages, and database triggers which run in the optimized environment of the Oracle Database server. The Oracle10g release has greatly enhanced the features and functionality of PL/ SQL. This advanced course helps PL/ SQL programmers take advantage of
more...
Introduction to Oracle 11g Programming Training
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools. The Oracle 11g release has greatly enhanced the features and functionality of PL/ SQL. Students will learn the fundamentals of the PL/ SQL programming language. Students will write stored
more...
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools. The Oracle 11g release has greatly enhanced the features and functionality of PL/ SQL. Students will learn the fundamentals of the PL/ SQL programming language. Students will write stored
more...
Introduction to Oracle 11g PLSQL Programming Training
A Relational Database Management System (RDBMS) is a software system that allows you to create and manage a relational database. Minimum requirements for such a system are defined by both ANSI and ISO. PL/ SQL is Oraclea ™s Procedural Language for SQL. It is Oraclea ™s database programming language for creating stored procedures, functions, database triggers, and object methods. PL/ SQL
more...
A Relational Database Management System (RDBMS) is a software system that allows you to create and manage a relational database. Minimum requirements for such a system are defined by both ANSI and ISO. PL/ SQL is Oraclea ™s Procedural Language for SQL. It is Oraclea ™s database programming language for creating stored procedures, functions, database triggers, and object methods. PL/ SQL
more...
From NACE EDUCATION
My SQL
Why learn MySQL?
MySQL is a multithreaded, multi-user SQL database management system (DBMS) which has more than 11 million installations. The basic program runs as a server providing multi-user access to a number of databases. MySQL is popular for web applications and acts as the database component of the LAMP, MAMP, and WAMP platforms (Linux/ Mac/ Windows-Apache-MySQL-PHP/ Perl/ Python), and for
more...
Why learn MySQL?
MySQL is a multithreaded, multi-user SQL database management system (DBMS) which has more than 11 million installations. The basic program runs as a server providing multi-user access to a number of databases. MySQL is popular for web applications and acts as the database component of the LAMP, MAMP, and WAMP platforms (Linux/ Mac/ Windows-Apache-MySQL-PHP/ Perl/ Python), and for
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 LearnQuest
Teradata SQL Training
Course Number: CFLQ-105
Duration: 3 days
Format: Group On-Site Training, Group Virtual Training, Public Virtual Training
Course Description
This course is designed to comprehensively cover SQL from basic syntax to stored procedures to SQL programming considerations. It is also fully customizable, and can range from 2-5 days, depending upon your needs.
Course Objective
Upon completion
more...
Course Number: CFLQ-105
Duration: 3 days
Format: Group On-Site Training, Group Virtual Training, Public Virtual Training
Course Description
This course is designed to comprehensively cover SQL from basic syntax to stored procedures to SQL programming considerations. It is also fully customizable, and can range from 2-5 days, depending upon your needs.
Course Objective
Upon completion
more...
From Aspect Training
ADO dot NET for C sharp Developers
Overview:
Aspect Traininga ™s ADO. NET for C# Developers provides a thorough, detailed and structured walkthrough of ADO. NET concepts
Aspect Traininga ™s ADO. NET for C# Developers is useful for .NET developers or architects developing database applications.
Prerequisites:
Experience with developing C#.NET applications
Course Topics:
Introducing ADO. NET
What Is ADO.
more...
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...
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
Learn to create tables and manipulate data,
tables and other database objects
using ANSI-standard SQL and Sybases Transact-SQL extensions,
and gain hands-on experience using Adaptive Server databases.
You will also learn the special features and functions of the Adaptive Server,
such as automatic recovery of transactions, stored procedures, triggers, and cursors.
In addition, you will learn to use
more...
Learn to create tables and manipulate data,
tables and other database objects
using ANSI-standard SQL and Sybases Transact-SQL extensions,
and gain hands-on experience using Adaptive Server databases.
You will also learn the special features and functions of the Adaptive Server,
such as automatic recovery of transactions, stored procedures, triggers, and cursors.
In addition, you will learn to use
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
You need to know how to tune queries and 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
more...
You need to know how to tune queries and 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
more...
ADO NET Using Visual Basic 2005
Learn about the features provided by ADO.NET 2.0 including
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
more...
Learn about the features provided by ADO.NET 2.0 including
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
more...
ADO NET Using Visual C 2005
Learn about the features provided by ADO.NET 2.0 including
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
more...
Learn about the features provided by ADO.NET 2.0 including
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
more...
SQL Server 2005 Administration
Learn about the features of SQL Server; how to design and create a
database; and how to build basic queries 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
more...
Learn about the features of SQL Server; how to design and create a
database; and how to build basic queries 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
more...
SQL Server 2005 T-SQL
Learn how to build basic queries using Transact-SQL, the language 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
more...
Learn how to build basic queries using Transact-SQL, the language 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
more...
From Intertech
Implementing a Microsoft SQL Server 2005 Database Training
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Learning Objectives
Create databases and database files
Create data types and tables
Use XML-related features in Microsoft
more...
Implementing a Microsoft SQL Server 2008 Database Training
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.
Learning Objectives
Create databases and database files
Create data types and tables
Use XML-related features in Microsoft
more...
Querying and Processing SQL Server Data with SQL Statements Training
This two-day, hands-on course covers everything database administrators and developers need to know to query SQL Server databases using SELECT statements ranging from simple to complex, and use INSERT, UPDATE and DELETE statements to modify and maintain data. Creating and using of VIEWS is also covered, along with accessing data through stored procedures and user-defined functions.
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 Mercury Solutions Limited
MCITP Database Developer SQL Server 2008
MCITP Database Developer 2008 is a highly recognized Microsoft certification. It is geared towards those IT professionals who possess basic Microsoft knowledge and want to upgrade to MCTIP certification on SQL Server 2008.
Upon the completion of this course, the candidate can successfully design, implement and maintain tables and views. He also knows how to program servers by using triggers,
more...
From Corporate Education Group
Oracle Database 10g Program with PL SQL
This class is applicable to Oracle8i, Oracle9i and Oracle Database 10g users.
This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.
Students learn to create anonymous PL/SQL
more...
This class is applicable to Oracle8i, Oracle9i and Oracle Database 10g users.
This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.
Students learn to create anonymous PL/SQL
more...
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
Introduction
Elements of this syllabus are subject to change.
The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes establishing monitoring standards and
more...
Introduction
Elements of this syllabus are subject to change.
The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes establishing monitoring standards and
more...
From Object Arena
ORACLE 10g11gDBA TrainingObjectArena Chennai
ORACLE 10g, 11g, DBA Training@ObjectArena Chennai
Object Arena Software Solutions (P) Ltd., Chennai provides in-depth
training in Oracle 11g DBA on real-time scenarios
Following are the major topics covered in VB. Net / C#
- The oracle enterprise architecture
- Creating AN oracle database & database instance
- Manage Database Storage Structures: Tablespaces
- DML, DDL, DCL
more...
From Victoria International College of Business and Technology
SQL Server 2005 DBA Certificate and Hands-on Training in Toronto
SQL Server 2005 DBA Certificate and Hands-on Training
New Session: Jan 2 Fri, 6: 30pm-10: 30pm
(Later on each Friday 6: 30pm-10: 30pm, total 60 hours, 15 weeks)
We invite you to attend first free trial class, seats are limited!!!
Please call David Li to 647-290-5809, 416-665-1888 or email to davidli@viccollege. com for further inquiry and reservation.
Microsoft Certified IT
more...
From Corporate Education Group
Implementing a Microsoft SQL Server 2005 Database
Introduction This three-day instructor-led course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Audience This course is intended for IT Professionals wanting to become skilled on SQL Server 2005
more...
Introduction This three-day instructor-led course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Audience This course is intended for IT Professionals wanting to become skilled on SQL Server 2005
more...
Advanced Java Programming
This course provides advanced training in developing software using the Java 2 Platform, Standard Edition, or J2SE. It is intended for students with solid experience in structured and object-oriented Java programming, including use of the Collections API and exception handling.
The first part of the course covers several general-purpose topics: using Java-5.0 generics, writing multi-threaded
more...
This course provides advanced training in developing software using the Java 2 Platform, Standard Edition, or J2SE. It is intended for students with solid experience in structured and object-oriented Java programming, including use of the Collections API and exception handling.
The first part of the course covers several general-purpose topics: using Java-5.0 generics, writing multi-threaded
more...
Updating Your Database Development Skills to Microsoft SQL Server 2005
This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers.
Audience This course is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop
more...
This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers.
Audience This course is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop
more...
Administering a Microsoft SQL Server 2000 Database
This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000. Course 2072 is a revision of Course 832, System Administration for Microsoft SQL Server 7.0. The course content is being revised to reflect changes in the product.
At Course Completion At the end of
more...
This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000. Course 2072 is a revision of Course 832, System Administration for Microsoft SQL Server 7.0. The course content is being revised to reflect changes in the product.
At Course Completion At the end of
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 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 |
