Programming Courses

  • JavaScript 1 3 days  About the course  The JavaScript 1 course comprises sessions dealing with embedding a script in a web page, variables and expressions, conditions and loops, functions, objects, arrays, errors and debugging, the DOM, event handling, the BOM, and AJAX. The delegate will learn how to add dynamic and interactive behaviour to their web pages.Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered. The delegate will learn and acquire skills as follows:• Embedding or linking to JavaScript code in a web page• Declaring and initialising variables• Constructing expressions• Constructing conditional and…

  • HTML5 & CSS3 with JavaScript 2 days About the Course The HTML5 & CSS3 with JavaScript course comprises sessions dealing with HTML5 elements and attributes, CSS3 styles, responsive web design, geolocation, drag and drop, offline storage, web sockets, server sent events, and cross domain messaging.The delegate will learn how to integrate HTML5 and CSS3 features into their web site.Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.The delegate will learn and acquire skills as follows:• Constructing a HTML5 form• Embedding audio and video• Constructing graphics• Constructing transitions and animations• Building a responsive web page• Establishing…

  • HTML & CSS 2 days About the course The HTML & CSS course comprises sessions dealing with HTML document structure, tags, elements, and attributes, how to mark up and style headings, paragraphs, links, images, lists, tables, and forms. It also provides an introduction to HMTL5 and responsive web design – a must, given that modern web sites should look good on all devices.The delegate will learn how to construct and style a simple web site.Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.The delegate will learn and acquire skills as follows:• Building simple web pages•…

  • Introduction to SQL   1 Day About the course The Introduction to SQL course is designed to give delegates practical experience in using ANSI standard SQL. As it is a generic course, some of the differences between different vendors' implementations will be noted.The delegate will learn and acquire skills as follows:• Creating SQL statements to query a database table• Using standard aggregate functions and related SELECT statement clauses• Joining Tables• Using basic subqueries and the set operatorsWho will the Course Benefit?Anyone who needs to understand and use SQL to manipulate a database.There are no formal pre-requisites for this Introduction to SQL course, although…

  • Java Programming 1 5 Days   About the course The Java Programming 1 course is closely aligned with the Oracle Java SE 8 Programmer I exam.The course comprises sessions dealing with Java apps, variables and operators, decision and loop constructs, arrays, methods, objects, classes, static members, enums, object-oriented principles, exception handling, packages and imports, selected APIs and lambda expressions.Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered. The delegate will learn and acquire skills as follows: • Writing, compiling, and executing simple Java applications• Declaring and initialising variables• Constructing expressions using relational, arithmetic and logical operators• Constructing decision…

  • Java Programming 2 5 Days  About the course  The Java Programming 2 course is closely aligned with the Oracle Java SE 8 Programmer II exam.This course focuses on the core language features and Application Programming Interfaces (APIs) you will use to design effective object-oriented and functional programming applications with the Java Standard Edition 8 Platform. The delegate will learn how to design and develop robust Java code that is easy to test and maintain and can be integrated into multiple applications. The most important new topics introduced in Java SE 8 are covered, such as Functional Programming and Stream API, that…

  • Developing Applications with Java EE 5 Days About the course The Developing Applications with Java EE course introduces delegates to the Java Enterprise Edition API, up to version 7. It explains the core JEE technologies and how they can be used to build large scale web based applications. It also includes an overview of Enterprise Java Beans, the Java Persistence API and JEE security.Delegates will learn how to develop Java systems that create front end web pages using tools such as Servlets, Java Server Pages and WebSocket, and develop back-end components using EJB, CDI and Bean Validation. In addition, we will show how…

  • JavaScript 2  3 Days    About the course The JavaScript 2 course comprises sessions dealing with values and references, strict mode, arrays, scope, objects, asynchronous JavaScript, unit testing and ECMAScript version 6. The delegate will learn about the inner workings of the JavaScript language to better enable them to write complex code and to troubleshoot. Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered. The delegate will learn and acquire skills as follows:• Working with primitive and reference variables• Testing for equality• Coding in strict mode• Working with associative arrays• Determining and affecting the scope of a…

  • Java Web Services 3 Days   About the course  The Java Web Services course is designed to provide a good level of understanding of Web Services and their place in the application stack, using modern Java technologies. With close attention to the practical issue of building SOAP and RESTful services into applications, delegates will practice creating, deploying, monitoring and using Java Web Services and gain a broad understanding of the Java Web Services landscape. The delegate will learn and acquire skills as follows:• Creating, deploying and monitoring SOAP and RESTful web services• Modifying and deploying a web service's WSDL• Developing code-first web services Creating…

  • Introduction to MariaDB 3 Days  About the course  The Introduction to MariaDB course covers the basics of the SQL language as implemented by MariaDB. 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. The delegate will learn and acquire skills as follows:• Using client programs to access a MariaDB database• Creating, altering and dropping a MariaDB database• Writing SQL statements to select data from a MariaDB database• Writing joins…

  • MySQL for Developers 5 Days    About the course This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling.  The delegate will learn and acquire skills as follows:• Using advanced features of the MySQL Client• Using advanced data types• Managing the structure of databases and tables• Managing and using indexes• Writing complex SQL query statements• Using advanced SQL expressions• Using advanced SQL functions• Performing advanced Insert, Update,…

  • MySQL Database Administration 5 Days   About the 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 performance. This MySQL Database Administration course also covers MySQL replication and its role in high availability and scalability. The delegate will learn and acquire skills as follows:• Using Client Programs for MySQL DBA work• Using MySQL Workbench• Obtaining metadata• Configuring…

  • FastTrack to MySQL Database Administration 3 Days    About the course This FastTrack to MySQL Database Administration course is designed for Database Administrators who already have substantial experience in the administration of another relational database management system such as Oracle or Microsoft SQL Server.  The course provides practical experience in setting up and maintaining a MySQL database server, including backing up, recovery, configuration and tuning. The delegate will learn and acquire skills as follows:• Using Client Programs for MySQL DBA work• Using MySQL Workbench• Obtaining metadata• Configuring the MySQL Server• Install and configure the MySQL Server and client programs• Administering and tuning a server•…

  • Introduction to MySQL 3 Days    About the 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. The delegate will learn and acquire skills as follows: • Using client programs to access a MySQL database• Creating, altering and dropping a MySQL database• Writing SQL statements to select data from a MySQL database• Writing joins and subqueries•…

  • Perl Programming 3 Days    About the course The Perl Programming course is designed to give delegates the knowledge to develop/maintain Perl scripts. The delegate will learn and acquire skills as follows:• Declare variables and initialise them• Understand scalar and list context• Construct expressions with arithmetic, logical and relational operators• Use iterative type statements• Use conditional statements• Read/write text and binary files• Manipulate text using regular expression• Use and code subroutines• Use built-in library functions• Use arrays and hashes• Declare and use packages Who will the Course Benefit? Programmers who need to write or maintain scripts in Perl. Course Objectives Knowledge of Perl to write, maintain and understand…

  • PHP Programming 3 Days About the course The PHP Programming course is designed to give delegates the knowledge to develop/maintain PHP scripts.The delegate will learn and acquire skills as follows:• Declare variables and initialise them• Construct expressions with arithmetic, logical and relational operators• Use iterative type statements• Use conditional statements• Read/write text and binary files• Manipulate text using regular expression• Use and code functions• Use built-in library functions• Use arrays and hashes• Create and use external PHP CodeWho will the Course Benefit?Programmers who need to write or maintain scripts in PHP.Course ObjectivesKnowledge of PHP to write, maintain and understand PHP scripts.RequirementsFamiliarisation with programming…

  • PHP & MariaDB for Web Development 2 days  About the course The PHP & MariaDB for Web Development course is designed to give delegates the knowledge to develop/maintain HTML/PHP code that utilises the MariaDB Database system.The delegate will learn and acquire skills as follows:• PHP Configuration• Basic SQL Syntax• Connect to a MariaDB Database with Error Checking• Use PHP to Interact with a MariaDB Database• Utilise PHP with the HTML Environment• Work with Email and Cookies• Consider Security Implications when using PHP and MariaDBWho will the Course Benefit?UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising…

  • PHP & MySQL for Web Development 2 Days About the course The PHP & MySQL for Web Development course is designed to give delegates the knowledge to develop/maintain HTML/PHP code that utilises the MySQL Database system.The delegate will learn and acquire skills as follows:• PHP Configuration• Basic SQL Syntax• Connect to a MySQL Database with Error Checking• Use PHP to Interact with a MySQL Database• Utilise PHP with the HTML Environment• Work with Email and Cookies• Consider Security Implications when using PHP and MySQLWho will the Course Benefit?UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP…

  • PHP Programming & MariaDB for Web Development 5 days  About the course The PHP Programming & MariaDB for Web Development course is designed to give delegates the knowledge to develop/maintain PHP scripts utilizing the MariaDB database system and HTML.The delegate will learn and acquire skills as follows:• Declare variables and initialise them• Construct expressions with arithmetic, logical and relational operators• Use iterative type statements• Use conditional statements• Read/write text and binary files• Manipulate text using regular expression• Use and code functions• Use built-in library functions• Use arrays and hashes• Create and use external PHP Code• PHP Configuration• Basic SQL Syntax• Connect to…

  • PHP Programming & MySQL for Web Development 5 Days About the 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.The delegate will learn and acquire skills as follows:• Declare variables and initialise them• Construct expressions with arithmetic, logical and relational operators• Use iterative type statements• Use conditional statements• Read/write text and binary files• Manipulate text using regular expression• Use and code functions• Use built-in library functions• Use arrays and hashes• Create and use external PHP Code• PHP Configuration• Basic SQL Syntax• Connect to a…

  • Python Programming 1 3 Days  About the course Python is an object oriented rapid development language deployed in many scenarios in the modern world.This Python Programming 1 course is designed to give delegates the knowledge to develop and maintain Python scripts using the current version (V3) of Python.There are many similarities between Python V2 and Python V3. The skills gained on this course will allow the delegate to develop their own skills further using Python V2 or V3 to support the development and maintenance of scripts.Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.The…

  • Python Programming 1 & 2 5 Days About the course Python is an object oriented rapid development language deployed in many scenarios in the modern world.This Python Programming 1 & 2 course comprises sessions dealing with the basics, variables, operators, conditional and control statements, functions, modules, pattern matching, OO, email, databases, advanced OO, iterators and generators, comprehensions, decorators, multithreading, functional programming, web services, and unit testing.Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.The delegate will learn and acquire skills as follows:• Reading/writing text and binary files• Declaring and initialising variables • Constructing expressions with…

  • Python Programming 2 2 Days   About the course The Python Programming 2 course comprises sessions dealing with advanced object orientation, iterators and generators, comprehensions, decorators, multithreading, functional programming, web services, and unit testing. The delegate will learn how to exploit advanced features of the Python language to build complex and efficient applications. Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered. The delegate will learn and acquire skills as follows:• Encapsulating classes• Exploiting polymorphism using inheritance and mixins• Associating objects via composition and aggregation• Working with static members• Using iterators as an alternative to for• Constructing custom iterators•…

  • Ruby Programming 3 days About the course Ruby is a high level Interpreted, Object Oriented, rapid development language deployed in many scenarios in the modern world.This Ruby Programming course is designed to give delegates the knowledge to develop / maintain Ruby scripts.Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.The delegate will learn and acquire skills as follows:• Declare variables and initialise them• Construct expressions with arithmetic, logical and relational operators• Use iterative type statements• Use conditional statements• Read/write files• Manipulate text using regular expression• Use and create Ruby Objects• Use built-in library functionsWho will…

  • Ruby Programming & Ruby on Rails 5 days About the course Ruby is a high level Interpreted, Object Oriented, rapid development language deployed in many scenarios in the modern world.This Ruby on Rails course is designed to give delegates the knowledge to develop / maintain Ruby scripts and Rails based projects.Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.The delegate will learn and acquire skills as follows:Declare variables and initialise themConstruct expressions with arithmetic, logical and relational operatorsUse iterative type statementsUse conditional statementsRead/write filesManipulate text using regular expressionUse and create Ruby ObjectsUse built-in library functionsWork…

  • Ruby on Rails 2 days About the course Ruby is a high level Interpreted, Object Oriented, rapid development language deployed in many scenarios in the modern world.This Ruby on Rails course is designed to give delegates the knowledge to develop / maintain Ruby scripts and Rails based projects.Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.The delegate will learn and acquire skills as follows:Work with REST and describe the purpose of REST and the Rails MVC architectureUse RAILS and describe the purpose of Rails RoutesCreate a project using Ruby and RailsCreate and customise a Rails…

  • Microsoft SQL Server with Transact-SQL 5 days About the course The Microsoft SQL Server with Transact-SQL course covers the basics of the SQL language and more as implemented by Microsoft SQL Server. The course is designed to give delegates practical experience in writing Transact-SQL statements by hand using the SQL Server Management Studio (SSMS) development environment. The basic Transact-SQL statements, including the use of many built-in Transact-SQL functions will be covered along with more advanced coding techniques required by Database Administrators, Database Developers and BI professionals. This course covers Microsoft SQL Server up to version 2016.The delegate will learn and acquire skills as…

  • Advanced Querying Microsoft SQL Server with Transact-SQL 2 days About the course The Advanced Querying Microsoft SQL Server with Transact-SQL course is designed to give delegates practical experience in using more complex Transact-SQL techniques. This course covers Microsoft SQL Server up to version 2016.The delegate will learn and acquire skills as follows:Creating and using ViewsUsing table expressionsEnhanced Grouping and Pivoting DataUsing Windowing ranking, offset and ranking functionsCreating and using Stored ProceduresControlling Program FlowUsing Dynamic SQLImplementing Error HandlingImproving Query PerformanceWho will the Course Benefit?IT Professionals and non-technical 'power users' who are required to implement more complex Transact-SQL queries.Course ObjectivesTo provide more advanced coding skills…

  • Querying Microsoft SQL Server with Transact-SQL 3 Days About the course The Querying Microsoft SQL Server with Transact-SQL course covers the basics of the SQL language as implemented by Microsoft SQL Server. The course is designed to give delegates practical experience in writing Transact-SQL statements using the SQL Server Management Studio (SSMS) development environment. The basic Transact-SQL statements, including the use of many built-in Transact-SQL functions are covered on this course. This course covers Microsoft SQL Server up to version 2016.The delegate will learn and acquire skills as follows:Writing SELECT queriesSorting and filtering dataUsing SQL aggregate functionsUsing SET operatorsWriting joins to query multiple…

  • Programming Microsoft SQL Server with Transact-SQL 2 Days About the courseThe Programming Microsoft SQL Server with Transact-SQL SQL training course introduces the delegate to the programming features of the Transact-SQL programming language, using Microsoft SQL Server. This course looks at the procedural programming language capabilities of T-SQL. The delegate will learn how to use local variables, write program flow control constructs, create stored procedures and triggers, handle errors and use built-in functions.The delegate will learn and acquire skills as follows:Declaring and using variablesUsing conditional programming logicImplementing conditional execution and loop constructsUsing cursors to process recordsTrapping and handling errors and exceptions in codeCreating…

  • Web Development 1 with HTML, CSS and JavaScript 5 Days About the course  The Web Development 1 with HTML, CSS and JavaScript course comprises sessions dealing with HTML, CSS and JavaScript - the three core languages of web development. HTML tags give a web page its structure, Cascading Style Sheets provide the style, and JavaScript code is used to make the page dynamic and interactive. All three are essential for a modern, responsive web site.The delegate will learn how to construct and style a simple web site, and add dynamic and interactive behaviour to their web pages.Exercises and examples are used throughout…

  • Web Development 2 with HTML5, CSS3 and JavaScript 5 Days About the course The Web Development 2 with HTML5, CSS3 and JavaScript course comprises sessions dealing with HTML5, CSS3 and JavaScript. It builds on the skills and knowledge gained by attendance on the Web Development 1 course by covering that which is new in HTML version 5 and CSS version 3, and advanced JavaScript topics.The delegate will learn how to integrate HTML5 and CSS3 features into their web site. They will become familiar with the inner workings of the JavaScript language, enabling them to write complex code and to troubleshoot.Exercises and examples are…