Instructor Led Sql Stored Procedures Training - Training Resources
Sql Stored Procedures Training Provider? - Tell us about your Training!
Please select the location nearest to you:
United Kingdom
India
Canada
United States
United Arab Emirates
 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
SQL Programming and Stored Procedures
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...
SQL Programming and Stored Procedures
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...
Upsizing Access to SQL
Have you got an Access database which is getting unwieldy? Symptoms to watch out for include a database which runs slowly, or one which crashes a lot. If this sounds familiar, maybe it is time to upsize to SQL Server. In theory you could just the Access upsizing wizard, but bitter experience tells us that this will leave a host of issues unsolved. This one-day course tells you what to look out
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...
SSRS
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...
From Ahana Systems and Solutions (P) Ltd
MS SQL Database Administration Online Training 28th,Nov
MS SQL Database Administration
SQL Server 2005
* Install and configure Microsoft SQL Server 2005.
* Understand basic database design principles and how to implement them in SQL Server.
* Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
* Understand the differences between view, stored procedures, triggers, and user-defined functions.
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 the
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...
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...
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...
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, CLR
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, CLR
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 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...
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 Knowledge Cube
Oracle 10g Developer
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.
more...
From Aspect Training
SQL Advanced for SQL Server
Aspect Traininga ™s two-day course provides students with product knowledge and skills needed to implement advanced T-SQL strategies on Microsoft SQL Server 2005/ 2008. The course focuses on teaching individuals how to use additional Transact SQL Server features and tools related to developing and querying a database.
After completing this course, students will be able to:
a Write and
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 Wintrac Inc.
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 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 Boston University Corporate Education Center
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...
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...
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
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 |
