Training Courses - the complete list
 m High quality, flexible training.- m Your venue or ours on dates to suit.
- m Fixed price for up to 8 attendees.
- m Laptops for your venue included.
- m All courses can be tailored.m Email your requirements.
- m From £995.00 + vat per day for up to 8 attendees
List of Full List Courses
| LSQ-61 |
Introduction to SQL details |
(2 day) |
This introduction to SQL training course is for database developers or database end users who need to to be competent extracting data from, and updating data in, relational database servers like Microsoft SQL Server, Oracle, IBM DB2, PostgreSQL and MySQL using ANSI standard Structured Query Language (SQL). In order to master the syntax of the language, the course is highly practical in nature and the focus throughout is on coding SQL by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| LSQ-62 |
A Foundation in SQL details |
(3 day) |
This is a course for database developers or database end users who need to manipulate data by interacting with relational database servers like Microsoft SQL Server, Oracle, IBM DB2, MySQL and PostgreSQL using Structured Query Language (SQL) and who need to progress their SQL skills beyond the basics. It teaches core SQL from the ANSI/ISO standards and is aimed at those who need to extract data from, and insert data into, existing databases to an in-depth level and who also need to create and modify databases and tables. The course is highly practical in nature and the focus throughout is on coding SQL by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| TSQ-63 |
Querying SQL Server with Transact SQL (T-SQL) details |
(2 day) |
This highly rated course is for Microsoft SQL Server database developers or end users who need to extract data using Transact SQL (T-SQL). While attendees gain much experience designing complex T-SQL queries using standard functions, joins and subqueries, T-SQL action statements which facilitate data or database modification do not form part of this course. So as to master the syntax of the language, the course is highly practical in nature and the focus throughout is on coding T-SQL by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| TSQ-64 |
Introduction to Transact SQL (T-SQL) details |
(2 day) |
This course is for Microsoft SQL Server database developers or end users who need to extract and update data using Transact SQL (T-SQL) up to the level of working with joins (inner and outer), grouping and summarizing results, working with subqueries, creating and using views, and performing action queries with INSERT, UPDATE and DELETE. In order to master the syntax of the language, the course is highly practical in nature and the focus throughout is on coding Transact SQL (T-SQL) by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| TSQ-65 |
A Foundation in Transact SQL (T-SQL) details |
(3 day) |
This course is aimed at Microsoft SQL Server database developers or end users who need to extract and insert data to an in-depth level and who also need to create and modify database objects. The course is highly practical in nature and the focus throughout is on coding T-SQL by hand. On completion, each attendee is given a USB pen drive to take away. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| TSQ-66 |
T-SQL Programming with SQL Server details |
(2 day) |
This highly practical course is aimed at database developers or power users with existing SQL or T-SQL experience. It teaches how to utilize T-SQL's procedural extensions (variables, conditionals, looping and cursors) to develop solutions with Microsoft SQL Server's programming objects (stored procedures, triggers, views and user defined functions). Processing transactions, basic error handling and working with XML also feature. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| MSQ-67 |
SQL Querying for MySQL details |
(2 day) |
This SQL training course is for those who need to extract data specifically from MySQL relational databases. While attendees gain much experience designing complex SQL queries using standard MySQL functions, joins and subqueries, SQL action statements which facilitate data or database modification are not covered. The course is highly practical in nature and the focus throughout is on coding SQL (with MySQL variances) by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| MSQ-68 |
MySQL Foundation details |
(2 day) |
This MySQL training course is for those charged with maintaining and using MySQL. It focuses on developing the skills required to create and maintain MySQL relational databases. A highly practical course based on a mix of lectures and well designed projects, it can be delivered on either the Windows or Linux platforms. If delivered at your venue, we can supply all equipment already setup for the course. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| MSQ-69 |
Introduction to SQL for MySQL details |
(2 day) |
This introduction to SQL training course is specifically for MySQL database developers or users who need to to be competent extracting data from, and updating data in, MySQL relational databases. The course is highly practical in nature and the focus throughout is on coding SQL (with MySQL variances) by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| MSQ-70 |
A Foundation in SQL for MySQL details |
(3 day) |
This is a course for MySQL database developers or users who need to manipulate data by interacting with MySQL relational databases using Structured Query Language (SQL) and who need to progress their SQL skills beyond the basics. It is aimed at those who need to extract data from, and insert data into, existing MySQL databases to an in-depth level and who also need to create and modify MySQL databases and tables. The course is highly practical in nature and the focus throughout is on coding MySQL-based SQL by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| OSQ-71 |
Database Querying with Oracle SQL details |
(2 day) |
This SQL training course is for anyone who needs to extract data from Oracle relational databases. While attendees gain much experience designing complex SQL queries using standard Oracle functions, joins and subqueries, SQL action statements which facilitate data or database modification are not covered. The course is highly practical in nature and the focus throughout is on coding SQL (with Oracle variances) by hand and can be delivered with or without the SQL*Plus query tool enhancements (please specify). On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| OSQ-72 |
Introduction to SQL for Oracle details |
(2 day) |
This introduction to SQL training course is specifically for Oracle database developers or users who need to to be competent extracting data from, and updating data in, Oracle relational databases. The course is highly practical in nature and the focus throughout is on coding SQL (with Oracle variances) by hand and can be delivered with or without the SQL*Plus query tool enhancements (please specify). On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| OSQ-73 |
A Foundation in SQL for Oracle details |
(3 day) |
This is a course for Oracle database developers or users who need to manipulate data by interacting with Oracle relational databases using Structured Query Language (SQL) and who need to progress their SQL skills beyond the basics. It is aimed at those who need to extract data from, and insert data into, existing Oracle databases to an in-depth level and who also need to create and modify Oracle databases and tables. The course is highly practical in nature and the focus throughout is on coding Oracle-based SQL by hand and can be delivered with or without the SQL*Plus query tool enhancements (please specify). On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| ISQ-75 |
SQL Querying with IBM DB2 details |
(2 day) |
This SQL training course is for those who need to extract data specifically from IBM DB2 relational databases. While attendees gain much experience designing complex SQL queries using standard IBM DB2 functions, joins and subqueries, SQL action statements which facilitate data or database modification are not covered. The course is highly practical in nature and the focus throughout is on coding SQL (with IBM DB2 variances) by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| ISQ-76 |
Introduction to SQL for IBM DB2 details |
(2 day) |
This introduction to SQL training course is specifically for IBM DB2 database developers or users who need to to be competent extracting data from, and updating data in, IBM DB2 relational databases. The course is highly practical in nature and the focus throughout is on coding SQL (with IBM DB2 variances) by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| ISQ-77 |
A Foundation in SQL for IBM DB2 details |
(3 day) |
This is a course for IBM DB2 database developers or users who need to manipulate data by interacting with IBM DB2 relational databases using Structured Query Language (SQL) and who need to progress their SQL skills beyond the basics. It is aimed at those who need to extract data from, and insert data into, existing IBM DB2 databases to an in-depth level and who also need to create and modify IBM DB2 databases and tables. The course is highly practical in nature and the focus throughout is on coding IBM DB2-based SQL by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| PSQ-80 |
SQL Querying for PostgreSQL details |
(2 day) |
This SQL training course is for those who need to extract data specifically from PostgreSQL relational databases. While attendees gain much experience designing complex SQL queries using standard PostgreSQL functions, joins and subqueries, SQL action statements which facilitate data or database modification are not covered. The course is highly practical in nature and the focus throughout is on coding SQL (with PostgreSQL variances) by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| PSQ-81 |
Introduction to SQL for PostgreSQL details |
(2 day) |
This introduction to SQL training course is specifically for PostgreSQL database developers or users who need to to be competent extracting data from, and updating data in, PostgreSQL relational databases. The course is highly practical in nature and the focus throughout is on coding SQL (with PostgreSQL variances) by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| PSQ-82 |
A Foundation in SQL for PostgreSQL details |
(3 day) |
This is a course for PostgreSQL database developers or users who need to manipulate data by interacting with PostgreSQL relational databases using Structured Query Language (SQL) and who need to progress their SQL skills beyond the basics. It is aimed at those who need to extract data from, and insert data into, existing PostgreSQL databases to an in-depth level and who also need to create and modify PostgreSQL databases and tables. The course is highly practical in nature and the focus throughout is on coding PostgreSQL-based SQL by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| LXM-02 |
Introduction to XML details |
(2 day) |
A broad, partly practical, partly presentation based training course for developers or managers who will be involved in all aspects of XML development. The course provides some practical experience in working with XML data, understanding the role of namespaces and the use of XML processors. This is followed with a presentation based overview of XML transformations with XPath and XSLT, data modelling with XSD Schema, XML within browser/server development and XML with regard to relational databases (eg SQL Server and Oracle). On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| LXM-03 |
XML Foundation details |
(3 day) |
A highly practical starter training course for developers who will be both transforming XML data with XSLT, and creating XML data models with XML Schema. It creates a sound understanding of the XML data format, working with namespaces, using XPath to extract data from XML trees and gives an essential kick start to working with both XSLT and Schema documents.
view pricing | view full outline (This course can be tailored)
|
| LXS-11 |
XSLT Foundation details |
(2 day) |
This is a highly practical, introductory-level training course for those who need to be competent with the fundamentals of transforming source data in XML format. It is relevant to application developers whose ultimate goal may be to produce RSS, PDF, SOAP, HTML, XHTML, XML, XSL-FO, SVG or Text output (among others). While the course aims to provide solid foundations in XSLT. It is aimed at developers who will most likely be working with XSLT in a secondary capacity. Those using XSLT in a primary capacity, or who need to work with XSLT in more depth, are urged to consider the three-day version: XSLT Development. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| LXS-12 |
XSLT Development details |
(3 day) |
Consistently achieving outstanding reviews from attendees, this is a highly practical, in-depth training course aimed at experienced developers who will be using XSLT in a primary capacity. It is relevant to application developers whose ultimate goal may be to produce RSS, PDF, SOAP, HTML, XHTML, XML, XSL-FO, SVG or Text output (among others) from either document-centric or data-centric XML source documents. Those requiring a more gentle introduction to only the fundamentals of XSLT would be encouraged to consider our two-day XSLT introductory-level course: XSLT Foundation. The course duration can be lengthened if required. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| LSC-31 |
XML Schema Foundation details |
(2 day) |
A practical training course providing a solid introduction to creating and working with XML Schema documents. It is for those with little or no experience of the XML development world. The first part of the course concentrates on creating a practical understanding of the core and required XML skills (XML data format, namespaces). The second part gives practical experience in creating and editing XML Schema documents with particular emphasis on data modelling. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| LVB-54 |
Introduction to VBScript details |
(2 day) |
This is a practical, introductory VBScript course for those with little or no previous programming experience. Programming concepts (variables, loops, conditionals etc) are skilfully explained alongside browser and server related VBScript language elements. No previous programming experience is necessary although some (X)HTML experience is preferred.
view pricing | view full outline (This course can be tailored)
|
on site training courses available in:
- London
- , Birmingham
- , Edinburgh
- , Manchester
- , Scotland
- , Glasgow
- , Nottingham
- , Midlands
- , Bristol
- , Wales
- , Cardiff
- , Dublin
- , Belfast
- , Leeds
- , Liverpool
- , Sheffield
- , Reading
- , Oxford
- , Cambridge
- , Southampton
- , Newcastle
- , Durham
- , Warrington.
and across the UK and Ireland
|
|
SQL
your venue or ours 
