This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761. View Full Course

This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database. View Full Course

SQL is an industry-standard language for accessing mainframe, midrange and LAN-based, multi-user relational databases. This course will teach the delegate how to read and write good SQL for querying, updating and maintaining SQL databases. The course progresses through the elements of the language to build a thorough appreciation and understanding of SQL's capabilities and power. It covers ANSI-s... View Full Course

This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures. View Full Course

This 2 day course is intended for delegates who are new to querying data stored in a Microsoft SQL Server 2016 database, and need a measured and relatively gentle introduction to the subject. It could also prove beneficial to delegates wanting to refresh their existing querying skills.

You will find that this is a comprehensive course for this level, with plenty of illustrated examples a... View Full Course

This 2 day course provides a foundation for designing, building and working with relational databases, enabling delegates to effectively develop and use relational databases in a business environment.

The training will focus on the fundamentals of database design in order to facilitate a better understanding of how data is stored, queried, and manipulated. That said, sufficient material ... View Full Course

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. View Full Course

View Full Course

View Full Course

View Full Course

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. View Full Course

The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. View Full Course

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. View Full Course

This 3 day course is intended for delegates who need to learn the essential skills necessary to maintain a Microsoft SQL Server system infrastructure. Being concise and hands-on, it is aimed at quickly getting delegates familiar with the Microsoft SQL Server administration concepts, tools and utilities. This course is an abridged version of the full 5 day “Microsoft SQL Server System Administrati... View Full Course

The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. View Full Course

The one-day SQL course is designed for users with a good knowledge of MapInfo, but who have difficulty getting to grips with query building and the management and use of queries.

It’s for those using any version of MapInfo Pro and is run as a hands-on session. Training notes are provided for back-up and revision purposes.

The course’s aim is to give the user the ability to use S... View Full Course

This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands.

The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, backing up and recovering data and optimising query performanc... View Full Course

The Oracle PL/SQL course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language. View Full Course

The Oracle PL/SQL Stored Program Units course provides practical experience in developing and writing triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages.
View Full Course

The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. View Full Course

The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. View Full Course

The Oracle SQL Fundamentals course is designed to give delegates practical experience in writing Oracle SQL statements and scripts. A wide range of SQL functions and data manipulation statements are introduced. View Full Course

The PHP Programming & MySQL for Web Development course is designed to give delegates the knowledge to develop/maintain PHP scripts utilizing the MYSQL database system and HTML. View Full Course

This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how t... View Full Course

A Certified Ethical Hacker (CEH) is a skilled professional who understands and knows how to look for weaknesses and vulnerabilities in target systems and uses the same knowledge and tools as a malicious hacker, but in a lawful and legitimate manner to assess the security posture of a target system(s). The CEH credential certifies individuals in the specific network security discipline of Ethical ... View Full Course

Delegates will learn how to create advanced formulas in Crystal Reports, format Crystal reports based on calculation results (conditional formatting), use multiple sections, insert sub reports and access data from sources other than PC databases. View Full Course

Digital forensic practices stem from forensic science, the science of collecting and examining evidence or materials. Digital or computer forensics focuses on the digital domain including computer forensics, network forensics, and mobile forensics. As the cyber security profession evolves, organizations are learning the importance of employing digital forensic practices into their everyday activi... View Full Course

The course is aimed at those who have gained some experience in the use of MapInfo data and the software and are ready to further their knowledge. The aim is to give the MapInfo trainees confidence to use their own data within the MapInfo environment, learn how to map external data sources, perform basic analysis and produce themed maps from their data. View Full Course

This course introduces the delegate to the main architectural concepts of Data Guard. Delegates will learn how to use Oracle Data Guard to protect Oracle Databases against planned and unplanned downtime. They will learn how to create and manage physical, logical and snapshot standby databases. They will also learn how to use standby databases in a standby role for reporting, querying and testing ... View Full Course