Introduction to Adobe After Effects

This Adobe certified course introduces delegates to the basic concepts of working with Adobe After Effects. It aims to give delegates the confidence to begin using the application in a professional environment to produce smooth animation and sophisticated special effects.

Intermediate Adobe After Effects

This intermediate course covers some of the more challenging aspects of working in After Effects. It aims to familiarise delegates with aspects of the software that may not be obvious, and to give delegates the confidence to apply the techniques taught in daily creative work. During training, delegates will be encouraged to explore new techniques that will greatly enhance their working knowledge of the software.

Advanced Adobe After Effects

This in-depth course fully addresses the complexities and sophistication available within After Effects. It teaches, in great detail, real life tips and tricks that will greatly enhance your working knowledge of the software. The course predominantly focuses on working with Effects, 3D and Expressions, although other topics will be covered, with an emphasis on using the features in creative and interesting ways.

Creative Masterclass in Adobe After Effects

This five day course covers all aspects of After Effects, drawing on our Intro, Intermediate and Advanced courses but incorporating extra tutorials, a customised training session, fast work flow techniques and commercial case studies. You’ll be trained by an industry professional who will pass on numerous real-world advice and tips and tricks of the trade. By the end of the course you’ll be fully equipped to create stunning animated motion graphics in all your projects.

Adobe Dreamweaver: Website Development

Adobe Dreamweaver Website Development is a three day course that provides web designers with the knowledge and hands-on practice they need to build and manage professional web sites using Dreamweaver.

Creating HTML Emails with Adobe Dreamweaver

This is a two day hands-on course intended for people who want to create well-designed and reliable HTML emails. During the course, delegates will learn the most effective techniques to create attractive HTML emails which work in all major email clients. Dreamweaver is used to create the pages, but the skills you learn can be used in any other web design tool.

Introduction to Adobe Acrobat

This course provides document authors, technical support staff and others with the skills needed of the many and varied uses of PDF files and Acrobat. Please note that the course topics below are for Acrobat Professional and will be reduced for the Standard or Elements versions.

Introduction to Adobe Illustrator

This Adobe certified course is designed for anyone who needs to understand the fundamental features and uses of Adobe Illustrator and the best way to use these to create drawings, illustrations and other artwork.

Intermediate Adobe Illustrator

This intensive, hands-on training course is designed to teach delegates how to create complex illustrations, manage colour across a range of devices, work with graphs and variables, control how illustrations appear on print and the web, and preview them on mobile device.

Advanced Adobe Illustrator

This course is recommended as a follow up to the two-day Fundamentals of Illustrator course or the two-day Intermediate course, depending on existing levels of knowledge. It is also suitable for those with equivalent experience through self-learning. The course includes topics such as special effects, filters, advanced techniques with the Illustrator drawing tools, layers work and advice concerning suitable settings for high-end output.

Adobe Illustrator Basics

This Adobe certified course is designed for anyone who needs to understand just the basics of using Adobe Illustrator. It is a great starter course to give students an overview of the software.

Introduction to Adobe Animate

This is an introductory course for designers and budding developers new to Adobe Animate. In this course, students will learn to create interactive content using text, graphics, animations, video, and sound. The course focuses on the essentials, and emphasises best practice throughout the course.

Introduction to Adobe Photoshop

This Adobe certified course is designed for anyone who needs to understand the fundamental features and uses of Photoshop and the best way to incorporate these into their work as a designer, photographer or retouching artist.

Intermediate Adobe Photoshop

This course is recommended as a follow up to our two day Fundamentals of Photoshop course, or it can be taken in its own right by those with equivalent experience. The topics taught include many useful techniques in the further creative and efficient use of Photoshop.

Advanced Adobe Photoshop

This course is recommended as a follow up to the two day Fundamentals of Photoshop course or the two-day Intermediate Photoshop course, or for any self-taught professional with equivalent experience. Course topics include in-depth work with layers, alpha channels, montaging, high-end image manipulation and batch processing techniques.

Introduction to Adobe InDesign

This Adobe certified course is designed for anyone who needs to understand the fundamental features and uses of Adobe InDesign and the best way to use these to create brochures, newsletters, flyers and other page designs.

Intermediate Adobe InDesign

This Adobe certified course is designed for confident existing users of Adobe InDesign and builds on the basic operations of InDesign, while introducing more advanced features and techniques.

Advanced Adobe InDesign

This Adobe certified course is designed for experienced InDesign users who wish to work as quickly and efficiently in InDesign. It examines the time saving features and shortcuts which can help designers avoid repetitive formatting and layout tasks and free up time to be creative. This Adobe certified course will allow time for delegates to raise issues relating to their particular workflows.

Introduction to Adobe Premiere Pro

To give students an overview of the key concepts involved in creating digital video for multimedia or video productions using Adobe Premiere.

Advanced Adobe Premiere Pro

This Adobe certified course is designed for those who have a good working knowledge of Premiere and who want to explore more advanced concepts and features of the application. It takes delegates through a typical series of steps for creating, editing and fine-tuning a series of video pieces. We also recommend this course for those planning to obtain the Adobe Certified Expert status.

Introduction to Adobe FrameMaker

This Adobe certified class provides delegates with the concepts and skills needed to use FrameMaker effectively. There are plenty of hands-on practicals, particularly using techniques in the Unstructured View of FrameMaker. Attendees will also learn the skills needed to take advantage of long-document support, including book management features, sophisticated tables and the rich formatting options offered by FrameMaker.

Introduction to Adobe Audition

This Adobe certified training course is aimed at all those excited by the possibilities of creating their own soundtracks using digital technologies and being able to restore poor quality sound. Delivered by our senior consultant with several years experience in audio techniques, the course demonstrates industry-standard techniques and provides examples of best practice.

Introduction to Adobe Captivate

This Adobe certified course introduces users to Adobe Captivate. The course is designed to take participants through the development process of building software demonstrations and interactive simulations. The course is task-based, with participants learning be recording and updating projects. Along with covering the key features of Captivate, the course focuses on best practices to record Captivate projects.

Advanced Adobe Captivate

Captivate offers the possibility of creating complex interactive courseware to levels that are only introduced at a basic level in the Introduction to Captivate course. This course extends your understanding of Captivate so you are able to generate much more flexible and responsive learning materials. There is also an emphasis in the course on providing tips for an efficient and effective workflow, whatever your personal circumstances. The course is taught using practical examples and a hands-on experiential approach.

Introduction to Adobe Lightroom

This course is designed to allow professional photographers to manage, adjust and present large photographs. To ensure you harness the potential of Lightroom to dramatically improve the way you manage digital images, from raw capture to creative output.

Introduction to Adobe Muse

Adobe Muse enables designers to create websites without writing code. Our course shows delegates how to plan, design and publish HTML pages with the skills you already have as a print designer.

Advanced Adobe Edge Animate

Adobe Edge Animate is a Flash alternative that allows creative professionals to animate artwork using HTML5, JavaScript, and CSS3. Edge uses a familiar Adobe interface, borrowing the workspace and user interface conventions of After Effects and Flash Professional. Our Advanced Edge course takes delegates beyond the point and click approach, with built in triggers, to enhance animations and build more complex interactions.

CC Creative Masterclass Introduction

This Adobe certified course is aimed at designers who want an overview of the key applications in the Adobe Creative Cloud toolset. The course provides hands on experience of the most useful features that designers use on a day-to-day basis, with an overview of Photoshop CC, InDesign CC and Illustrator CC. Attend this course, get inspiration for new projects and increase your productivity!

Introduction to Adobe Premiere Elements

To give students an overview of the key concepts involved in creating digital video for multimedia or video productions using Adobe Premiere Elements.

Introduction to Adobe Speedgrade

This course teaches the use of Speedgrade, the powerful colour correction application from Adobe, to grade, balance and professionally finish your film and video productions. The practical tips and techniques covered will give you the confidence to use Speedgrade properly, whether as part of a Premier Pro workflow or with another professional editing system, giving you a fast and effective finish to your productions.

macOS Support Essentials 10.12 (Sierra 101)

macOS Support Essentials 10.12 is a three-day course that gives you a tour of macOS Sierra and describes the best ways to support macOS Sierra users. The course includes lectures and hands-on exercises that provide real-world experience. The course takes you deep inside macOS Sierra, offering in-depth, step-by-step guidance on everything from installing and configuring Sierra to managing networks and system administration. Through practical, hands-on lessons, you'll learn how to set up users, configure system preferences, manage security and permissions, use diagnostic and repair tools, troubleshoot peripheral devices, and more: all you need to professionally support macOS Sierra and systematically prepare for Apple Certified Support Professional (ACSP) 10.12 certification or recertification. For Students Enrolled in a Virtual Class: Each student will need to setup two (2) computers in order to take the class virtually. The first can be a PC, tablet or Mac. The second computer must be a Mac and you will need the software (and version) being taught in the course already installed on your computer. This setup will allow virtual students to view the presentation on one computer and do support exercises on the other one.

OS X Support Essentials 10.11 El Capitan 101

El Capitan 101 OS X Support Essentials 10.11 is a three-day course that gives you a tour of OS X El Capitan and covers the best ways to support OS X El Capitan users. The course includes lectures and hands-on exercises that provide real-world experience.

OS X Server Essentials 10.11 El Capitan

OS X Server Essentials is a three-day course designed to give technical co-ordinators and entry-level system administrators the skills, tools, and knowledge to implement and maintain a network that uses OS X Server for El Capitan. Students learn how to install and configure OS X Server to provide network-based services, such as file sharing, web, and wikis. Tools for efficiently deploying and managing OS X are also covered. The course is a combination of lectures and hands-on exercises that provide real-world experience. Upon completion of the OS X Server Essentials 10.11 (El Capitan 201) course, students will be able to: Utilise the features of Server 5 for OS X Configure essential services on Server for OS X Use Server for OS X tools to monitor and troubleshoot services Use of Server for OS X to manage a small network of Macintosh computers and users Manage access to files and services

Introduction to Mac OS X 10.11 El Capitan

Introduction to Mac OS X is a one-day preliminary course for those new to Mac OS X who need to prepare for El Capitan 101, the Mac OS X Support Essentials course, or other technical Mac OS X training courses. This course focuses on getting to know the foundations of Mac OS X 10.11 El Capitan, with topics ranging from efficient window and application management to system customisation. Delegates also learn how to configure user accounts and manage files.

OS X Server and Support Essentials 10.11 Combined (El Capitan 101 and 201)

Course Description: The El Capitan 10.11 Bootcamp is a combined delivery of the Apple authorized El Capitan 101 and El Capitan 201 courses. The OS X Support Essentials 10.11 Exam is included with the class. (Exam is not included on On-site or online delivery.) This hands-on course provides an in-depth exploration of functionality and troubleshooting on OS X and the best methods for effectively supporting users of OS X systems. This course also gives technical coordinators and entry-level system administrators the skills, tools, and knowledge to implement and maintain a network that uses OS X Server. Students learn how to install and configure OS X Server to provide network-based services, such as file sharing and authentication. Tools for efficiently managing and deploying OS X and software updates are also covered. For Students Enrolled in a Virtual Class: Each student will need to setup two (2) computers in order to take the class virtually. The first can be a PC, tablet or Mac. The second computer must be a Mac and you will need the software (and version) being taught in the course already installed on your computer. This setup will allow virtual students to view the presentation on one computer and do support exercises on the other one.

Final Cut Pro Introduction: Professional Post Production in Final Cut Pro X (FCP X)

Final Cut Pro X is a revolutionary video editing application that helps beginners and seasoned professionals achieve stunning results. In this three-day, hands-on course, students become familiar with the user interface while they learn how to perform editing functions. Students work with real-world media to learn practical approaches to video editing?from basic techniques to the powerful advanced features of Final Cut Pro. The course replaces the now-deprecated Apple Authorised courses known as FCP101 and FCP300. It may also be taken as a private, closed session over four or five days, for those who prefer more time and a less intensive pace. <strong>For Students Enrolled in a Virtual Class: </strong> Each student will need to setup two (2) computers in order to take the class virtually. The first can be a PC, tablet or Mac. The second computer must be a Mac and you will need the software (and version) being taught in the course already installed on your computer. This setup will allow virtual students to view the presentation on one computer and do support exercises on the other one.

Advanced Final Cut Pro X 10.2

This course is aimed at FCP users with existing experience, who would like to take their skills to the next level.

Introduction to Motion

This three-day, hands-on course starts with motion graphics fundamentals and moves into compositing, animation, and the world of 3D. Explore new intelligent templates to quickly and flexibly create high-quality effects, titles, transitions, and generators as well as create rigs to adjust related parameters with a single control.

Introduction to Logic Pro X Professional Music Production

Logic Pro X is the complete professional recording studio for the Mac that gives musicians everything they need to go from first note to final master. This three-day hands-on course introduces students to Logic Pro’s primary features and basic user interface. Students learn how to generate a customised audio and MIDI configuration that will seamlessly integrate with their own personal production studio. Students also create their own song using Logic Pro’s comprehensive array of software instruments, Apple Loops, and DSP effects. In-depth lessons cover MIDI and audio recording, streamlined editing and arrangement techniques, user-defined key commands, automation, using external MIDI controllers, mixing, and creating final output. <strong>For Students Enrolled in a Virtual Class: </strong> Each student will need to setup two (2) computers in order to take the class virtually. The first can be a PC, tablet or Mac. The second computer must be a Mac and you will need the software (and version) being taught in the course already installed on your computer. This setup will allow virtual students to view the presentation on one computer and do support exercises on the other one.

Advanced Techniques in Logic Pro

This three-day course takes you through Logic's powerful advanced features, covering everything from production, editing, and mixing, to notation and scoring to picture. Throughout the class professional secrets are revealed regarding how to streamline production workflow, accelerate editing tasks, effectively manage takes, and construct a mix that will meet the most exacting standards. You'll discover powerful techniques for multi-track recording and explore the limitless potential of Logic's audio instruments, including the revolutionary Sculpture.

Introduction to Apple Keynote 6.5

This one day course is designed to teach those with little or no experience in Keynote to create dynamic and compelling slide shows and presentations containing text, graphics, tables, charts, video and sound.

Introduction to Swift 2.0 Development with Objective-C

With Swift 2.0 featuring significant new enhancements, now is the perfect time to learn Apple’s exciting new programming language. Our course emphasises the best of the new features in version 2.0 and we’ve been careful to make it accessible for those new to programming, teaching topics in small steps so that beginners can learn code in “bite-size” chunks. For experienced programmers, our course is a great way to understand the Swift language and see how well it provides a clean, modern and efficient approach to programming, using the functional features of Swift. Please note that we have delivered this course to staff from Apple UK.

Using the iPad for Business

This course gives you the in-depth skills needed to use the iPad in a business environment. The course focusses on real-world usage of an iPad in typical day-to-day scenarios. Useful tips and tricks, essential apps and additional hardware to enhance your iPad experience will all be covered, allowing you to get the most out of your iPad.

iOS Deployment Essentials

iOS Deployment Essentials is a two-day course that provides students an opportunity to learn about the skills, tools, and knowledge needed to deploy iOS devices. Interactive discussions and hands-on exercises guide students through the configuration, management, and supervision of iOS devices. Students' knowledge and skills are tested and reinforced by working through real-world scenarios.

Apple Certified iOS Technician (ACiT) Training

The Apple Certified iOS Technician (ACiT) Training is a 3 day trainer-led class designed to demonstrate and discuss the repair and troubleshooting process of iOS devices. Taught by an Apple Certified Trainer, you will learn directly from the experts on how to efficiently service iOS devices. With plenty of hands-on and take-apart labs, the key focus is to provide guidance on tools and techniques for a successful iOS service and repair.

Introduction to Apple iMovie

This one day course will teach participants iMovie's basic approach to video editing, as well as providing additional insights into a wider range of its special features and functionality. During the course candidates will be able to log and capture footage, edit in the iMovie environment, create a short movie using cuts and transitions, apply audio and visual effects filters and export to various platforms.

Introduction to iBooks Author

Delegates on this course will learn how to use iBooks Author to create beautiful Multi-Touch textbooks, and many other kinds of book, for rerading on iPads. Featuring galleries, video, interactive diagrams, 3D objects and more, the course shows you how to create electronic books that bring content to life in a myriad of different and compelling ways.

Apple Certification Exam

Sit any Apple Certification Exam

Accelerated A+ Hardware and OS Objectives

In this course, you will install, upgrade, repair, configure, optimise, troubleshoot and perform preventative maintenance on basic personal computer hardware and operating systems. The course will help prepare students to achieve a CompTIA A+ Certification.

SQL Server Database Querying Course

This course is aimed at those who need to extract information from a relational database system. Although it provides an overview of relational database design principals it does not cover the teaching of formal database design processes and database/table creation. The course assumes no previous knowledge of SQL and SELECT statements, and takes delegates from simple queries, through to complex queries involving multiple tables, introducing the vast collection of built-in functions along the way. Covers SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL Server 2014

Advanced SQL Server Database Querying

This course is aimed at SQL Server database developers, administrators and analysts who need to take the basics of SQL Server SQL Data Manipulation Language (DML) statements to the next level. The aim of the course is to show the more advanced use of SELECT, UPDATE and DELETE statements providing delegates with the necessary knowledge and hands on experience to construct complex queries to satisfy complex information extraction requirements. The course focuses on real world business needs and shows how to make the extensive SQL Server library of functions work together to manipulate and extract data values. It also explores the many different ways of retrieving information from multiple tables from simple multi-table SELECT statements through to complex correlated sub-queries as well as introducing the many ways of analysing and processing data through methods such as grouping of data and implementing computed columns. The course will do more than just teach each topic as an isolated subject; it will show delegates how to integrate all these query methods and more to help satisfy their business information extraction needs. This course, along with the Creating Databases in SQL Server and SQL Server Database Querying Courses, helps to prepare delegates for the Microsoft 70-461 exam: Querying Microsoft SQL Server 2012/2014/2016, exam 70-761 Querying Data with Transact-SQL (M20761), and exam 70-762: Developing SQL Databases (M20762), which credit towards MCSA and MCSE certifications. It should be noted, however, that all course attendances should be complemented by reference to the skills measured by the exam, a period of self-study and test exams before sitting the actual exam. Covers SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, and SQL Server 2016.

SQL Server Essential Administration

This course is at aimed anyone charged with administering a SQL Server database system. It focuses on only the core administration responsibilities enabling new SQL Server database administrators to build the skills necessary to install, configure and support a simple SQL Server deployment. The objective is to provide the essential skills for managing a single instance system, enabling administrators to get up and running to a basic level fairly quickly, but also to provide an awareness of some of the more advanced services available. This course can be followed by a number of additional courses focussing on different specialisations and services available for SQL Server deployments. This course, along with the SQL Server Advanced Administration Course, helps to prepare delegates for the Microsoft 70-462 exam: Administering Microsoft SQL Server 2012/2014 Databases. This exam credits towards MCSA and MCSE certifications. It should be noted, however, that all course attendances should be complemented by reference to the skills measured by the exam, a period of self-study and test exams before sitting the actual exam. This course is suitable for delegates working with all versions of SQL Server from SQL Server 2008 through to SQL Server 2016.

SQL Server Advanced Administration (2008/2014)

This course is at aimed at SQL Server 2008 database administrators who wish to build on their basic administration skills and learn how to manage multiple SQL Server deployments and implement some of the more advanced administration and management services. This course, along with the SQL Server 2008 Essential Administration Course, helps to prepare delegates for the 70-432 Microsoft MCTS exam.

Transact SQL Programming (TSQL)

This course is aimed at SQL Server database developers, administrators and analysts who need a little bit more than SQL can do alone. SQL Server provides a powerful scripting language called Transact SQL, which enables developers to extend the capabilities of the SQL language. Using Transact SQL (TSQL) powerful scripts, stored procedures, functions and triggers can be produced to enable extracted information to be processed further, or to enable complex transformations of data prior to, during or after an insert, update or delete, or to implement automated updates and audit trails. Covers SQL Server 2005 through to SQL Server 2016.

SQL Server Reporting Services

Delegates attending the SQL Server Reporting Services course will learn how to use (SSRS) to design, create, deploy, secure and manage reports. The course provides a fundamental understanding of the components of a Reporting Services deployment exploring its basic architecture and terminology. You will learn how to create tabular, matrix, chart and list reports that employ datasets based on ad-hoc queries and stored procedures. As you progress you'll learn to add custom expressions, custom functions and format your reports, implement shared data sources, interactive sorting, drill-down capabilities, and create parameter based reports using the Report Designer. Reports including gauges, indicators, spark lines and maps will also be introduced. The course will introduce both the Visual Studio (SQL Server 2008 Business Intelligence Development Studio (BIDS) for SSRS 2008R2 and SQL Server Data Tools (SSDT) for SSRS 2012 through to 2016) project environment and ReportBuilder 3.0 application for creating, saving and deploying reports. The latter part of the course covers the deployment, management and customisation of Reporting Services projects components and saving of reports, data sets and data sources to the SSRS repository. In this section you will learn how to manage security and access to reports through user roles and accounts. You will also learn how to schedule the execution and caching of reports, and automate the delivery of reports in selected render formats. An introduction to the concepts of accessing reports using URL access and the Reporting Services Web Service API, and the application integration options provided by SSRS will be provided to serve as a taster of how your reports might be integrated into your own applications. This course is suitable for delegates working with all versions of SQL Server from SQL Server 2008 through to SQL Server 2016.

SQL Server Performance and Tuning

The objective of this course is to provide senior database analysts, developers or database administrators with a good understanding of SQL Server Architecture and Query Performance so that applications and their supporting environment can be tuned for optimal performance. The course will provide delegates with the knowledge required to size, plan, monitor, tune and troubleshoot a SQL Server application for either a OLTP live environment or a OLAP data warehousing environment. Everything from Operating System and SQL Server service tuning through to query and index tuning will be covered. It is a hands on course with performance and analysis tools being put to use throughout. Delegates will learn how to capture and analyse performance data to enable troubleshooting of performance problems using tools such as Performance Monitor, SQL Profiler, Extended Events and Dynamic Management Views. They will learn how to interpret query execution plans to determine where the cause of bottlenecks lies and how to tune the queries for best performance. Covers SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL Server 2014.

(SSAS) SQL Server Analysis Services Tabular Model

In this course, you will learn how to use Microsoft SQL Server Analysis Services (SSAS) to design and implement Tabular PowerPivot Models to support Business Intelligence (BI) solutions. You will learn about the Microsoft SQL Server Visual Studio development environment (SQL Server 2012/2014 Data Tools) for design, creation and deployment of SQL Server BISM (Business Intelligence Semantic Model) Tabular Mode projects, and SQL Server Management Studio for the management of Tabular Models. Delegates will be introduced to the concepts of Transactional Relational Databases, Data Warehouse Relational Databases, other sources of data, and Tabular (PowerPivot) Models fundamentals, becoming familiar with terminology such as Tables, Data Sources, Relationships, Hierarchies, Calculations and Measures. The course will take delegates through building a Tabular Model in its simplest form through to extending the features within the model by implementing DAX calculations and measures, and Key Performance Indicators (KPIs). The main emphasis of the course is on the design and creation of Tabular Models, but basic administration and security of models are also covered. An introduction to the DAX language will provide an insight into extending data models by adding simple aggregate type measures and calculations to the model through to complex Time-Intelligence based measures, such as parallel period calculations, year to date, month to date, etc. This course also covers the interrogation of Tabular Models from Microsoft Excel 2010/2013 through Pivot Tables and Charts, and the use of Tabular Models as data sources for SQL Server Reporting Services (SSRS). This course is suitable for delegates working with SQL Server 2012 and SQL Server 2014.

(SSAS) SQL Server Analysis Services Multidimension Mode

In this course, you will learn how to use Microsoft SQL Server Analysis Services (SSAS) to design and implement Multidimensional OLAP cubes to support Business Intelligence (BI) solutions. You will learn about the Microsoft SQL Server Visual Studio development environment (SQL Server 2008 Business Intelligence Development Studio (BIDS), SQL Server 2012/2016 Data Tools) for design, creation and deployment of SQL Server BISM (Business Intelligence Semantic Model) Multidimensional Mode projects, and SQL Server Management Studio for the management of Multidimensional databases. The course will take delegates through building a multidimensional cube in its simplest form through to extending the features within the cube by implementing MDX calculations, Key Performance Indicators (KPIs), Actions and Dimension/Cube Intelligence. The main emphasis of the course is on the design and creation of cubes, but basic administration and security of cubes are also covered. This course is suitable for delegates working with all versions of SQL Server from SQL Server 2008 through to SQL Server 2016.

(SSIS) SQL Server Integration Services

Delegates attending this course will have requirements to implement SQL Server Integration Services (SSIS) to export and import data between mixed data sources, catering for simple exchanges and more complex requirements involving transformation of data before it reaches its destination (such as in the cases of loading a Data Warehouse). Delegates will learn how to carry out data cleansing tasks such as de-duplicating and fuzzy lookups, converge heterogeneous data sources through transformations such as merge and union, split single data sources into many with transformations such as conditional split, handle multiple import files with containers such as for and foreach loops, and much more. In this course you will learn about the Microsoft SQL Server Visual Studio development environment for design, creation and management of SSIS packages, and work with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques. This course, along with the (SSAS) SQL Server Analysis Services Course, helps to prepare delegates for the Microsoft 70-463 exam: Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam credits towards MCSA and MCSE certifications. It should be noted, however, that all course attendances should be complemented by reference to the skills measured by the exam, a period of self-study and test exams before sitting the actual exam. This course is suitable for delegates working with all versions of SQL Server from SQL Server 2008 through to SQL Server 2016.

Introduction to SQL Server MDX

This course provides the fundamental skills required to query cubes using the MDX SELECT statement and customise cubes with the MDX scripting language and functions. At the end of the course delegates will be able to confidently query existing cubes as well as create their own measures and named sets derive information from stored cube data and aggregations. The course covers the most commonly used set of MDX functions and scripting statements and provides the first step in a career of writing MDX statements and scripts. The course covers versions of SQL Server Analysis Services up to an including SQL Server 2012.

Introduction to Microsoft Word

The course provides a thorough introduction to Word, teaching users to create and edit documents, format documents in the most efficient manner, to improve presentation and layout and to perform file management procedures.

Microsoft Sharepoint Administrator 2013 Site Administration for End Users

This course provides you with the knowledge required for a Site Administration role. You will create, customise and manage SharePoint 2013 sites within a site colletion in response to the differing needs of your site members and visitors, and according to the infrastructure of the business. You will identify the roles and expectations of a site owner and a site collection administrator. You will see how to manage sites and users by defining permissions, structure, content and policy. You will see how to gather information about the site’s usage as a means to maintain the site and identify where improvements can be made. The course is aimed at end users, knowledge workers and managers who have the responsibility to manage teams and information within the SharePoint Sites. This course is not aimed at a technical audience, but at end users who will appreciate some technical background information.

Microsoft Sharepoint 2013 Core Skills - Level 1

This course provides you with the basic skills required by an end-user of Microsoft SharePoint Server 2013. The course provides a hands-on experience, with a series of self-guided exercises integrated into the training. It is recommended that delegates also attend the Level 2 course in order to get the most out of this product. You will discover how to access SharePoint from a browser or from Office, how to use SharePoint to collaborate within a team, organise and manage documents, events, tasks and other items. You will also be shown how to create your own site with both public, and private areas, and how to search for information in a portal site.

Introduction to FileMaker Pro

FileMaker Pro is the database “for the rest of us” - a rapid development tool that non-coders can use to manage all aspects of their business. Our introductory course teaches the key techniques in FileMaker needed to build databases, including table structure, layout design, comprehensive search techniques and ways to control the consistency and appearance of data. The course also introduces the fundamentals of relational database design, so that information can be shared across layouts, and the basics of simple automation using buttons.

Intermediate FileMaker Pro: Relational Database Design and Scripting

This FileMaker Authorised course teaches good practice in the design of efficient relational database systems. The course includes full explanations of how and when to link tables together using primary and secondary keys in FileMaker Pro and introduces FileMaker scripting, to provide automation and efficiency of procedures within a database solution. It also looks at techniques to improve the user experience, such as helpful navigation and the use of multiple windows and introduces the power of FileMaker calculations.

Advanced FileMaker Pro

This two day course is aimed at those wanting to learn powerful techniques and best practice in FileMaker database design. It covers some of the less obvious features of FileMaker and emphases the creative use of relationships to build user-friendly interfaces and the efficient capture, display and output of data. The course draws on many tried and tested procedures used by FileMaker developers to create database systems that are both easy to use and that possess rich functionality when required.

Introduction to JavaScript

A two-day course for HTML authors and Web designers who want to add dynamic and interactive content to their pages using client-side scripting with JavaScript. The course includes routines to create pop-up dialog boxes, validate forms and provide customised content. The course is available to users of both Macintosh and PC platforms and delegates will leave with complete programs that can be used on their own sites.

Introduction to ECMAScript 6

JavaScript is evolving and the latest version brings many differences in how to write and structure your code. This course explores why the changes are happening and what is currently or soon to be supported. We explore Traceur as a means to use un-supported features now, even on browsers and devices which don’t yet understand ECMAScript 6.

Introduction to Web publishing and HTML / XHTML

A two-day hands-on course intended for people looking to maintain websites for commercial use on the Internet. This course is suitable for both Mac and PC users who want to acquire HTML knowledge as a solid foundation to their Web design projects. It does not feature a WYSIWYG Web authoring tool but concentrates on the background HTML, input using a simple text editor, such as TextEdit in Mac OS or Notepad in Windows.

Introduction to HTML5 and CSS3 for Web Professionals

This course is aimed at existing web developers with knowledge of earlier versions of HTML and CSS. The course gives an introduction to some of the important new features and tags available within HTML5, as well as some of the latest CSS and JavaScript techniques. It includes the use of new structural HTML element tags such as HEADER, FOOTER, ASIDE, ARTICLE and NAV, as well as the use of the VIDEO and AUDIO tags.

Advanced HTML skills

A one-day course for HTML authors, covering the advanced techniques required to build engaging websites such as Cascading Style Sheets (CSS), JavaScript, plugins and forms. As in the two-day Introduction to Web publishing course, students work on a series of examples which illustrate all the techniques used. The course is available to users of both Macintosh and PC platforms.

Web Accessibility and Usability

This course will enable those attending to gain a thorough understanding of Web Accessibility and Usability issues. Techniques for achieving accessibility standards will be covered, along with informal recommendations for delegates’ own websites.

Designing Websites with Cascading Style Sheets (CSS)

This course is aimed at those developing web sites and corporate intranets. It explores how using style sheets can dramatically improve the creation and management of a site. The focus is on creating and implementing stylesheets in a text editor, but also covers implementation of stylesheets using Dreamweaver

Building Mobile Websites

More web pages are now viewed using Mobile devices than desktop browsers. This course provides best practice in building mobile content, including taking account of the different platforms used by mobile devices. The course includes the relevant new mobile-oriented features of HTML5 and CSS that are essential for building Mobile device friendly web sites. It will also touch on JavaScript and make reference to PHP as a server side technology.

Introduction to Responsive Design

This hands-on course covers the skills necessary to design and build responsive web sites for mobile devices such as phones and tablets. Students will learn the use of techniques such as CSS3 media queries and flexible layouts to build mobile-compatible web sites. The course also provides an extensive introduction to JavaScript and the jQuery Mobile Framework for building mobile-specific web sites.

Introduction to User Experience (UX) Design

This course covers the foundation principles for creating successful user experiences. Through hands-on exercises we experiment and explore space, form, and function to apply successful UX design on modern platforms and devices. Participants gain experience in planning and prototyping through typical UX design workflows.

Introduction to Search Engine Optimisation (SEO)

Our course teaches the accepted techniques and technologies that will give your website the highest rankings in Search Engines. After attending, delegates will be able to optimise their websites for Search Engines such as Google using the most valid and proven techniques.

Basic Video Production - Shooting and Editing

Aimed at anyone with a requirement to shoot and edit professional quality video content, this three day course starts by looking at the basic video camera technology and how to capture general footage and record interviews. Day two covers hands-on shooting and on Day 3, we stay in the studio, editing footage using a professional editing software, adding sound, titles and voiceovers, and finally learning how to deliver the result in the required format, whether for web or broadcast delivery. On scheduled courses, the editing software used is Adobe Premiere Pro. For private training, delegates can choose to work with Apple Final Cut Pro or iMovie if preferred.

Writing for the Web

Delegates will learn how to produce clear, readable on-line information and a greater understanding of how to write for the web.

Writing Press Releases

This course will enable those attending to sharpen their press release writing techniques and raise the profile of their organisations in the media. It includes a thorough exploration of what journalists are looking for in a press release and practical guidance on choosing the right angle and structure to ensure that press releases are read – and used.

Social Media Skills for Business

This course is a one day hands-on workshop for businesses from all industries, ideal for Directors, Business Owners, Entrepreneurs, Business Development, Sales, Marketing and Customer Service professionals who need to understand the benefits of using social media as an online marketing, customer engagement and resource tool for their business.

Advanced Social Media Skills

This is a one day hands-on workshop aimed at Directors, Business Owners, Entrepreneurs, Business Development, Sales, Marketing and Customer Service professionals who want to take their social media skills further, gaining increased benefits from social media as an online marketing, customer engagement and resource tool for their business. The course introduces other social media platforms such as Blogs, Youtube videos, Google +, Foursquare, Pinterest and selected Social Media monitoring tools and shows how to track the benefits gained from these extra tools.

Professional Copywriting

The words you use to promote your business, product or service can have a real impact on prospective customers. This one-day course teaches the techniques used by professional writers in the marketing and advertising fields to persuade and convince their audience, on the web or in traditional media. Bring examples of your own work along to the session and have them critiqued by your tutor, a former advertising creative director, and improve them on the spot!

Proofreading

Promotional information containing errors and ambiguities leaves potential customers feeling doubtful. This one-day course answers basic questions about grammar and some of the common mistakes and omissions that often slip through to printed material. The course allows plenty of practice throughout the day, and help you to develop a system for checking copy so that nothing is missed and your copy is crisp, correct and clear.

Introduction to Digital Photography Skills

To provide training in basic photographic techniques, including both creative and theoretical practices, using a combination of practical work and theory. This course is delivered by an ex-professional advertising photographer. Please bring your own camera along. Important info for scheduled course delegates: cameras used for training must be DSLR or interchangeable lens-system cameras which allow for manual settings.

Introduction to Podcasting

This course is designed to give delegates an introduction to how to create their own quality podcasts. Those attending the course will gain a solid understanding of the different styles of podcasts, technical considerations and how to publish a podcast as well as practical experience of recording, editing and mixing a podcast from start to finish in Audacity. Delegates should bring a device that records audio (e.g. a mobile phone), headphones and a lead to enable downloading of audio files via USB to allow for editing.

Programming in C

This course introduces the syntax, features, code structure and coding conventions of C. Emphasis is placed on teaching the central concepts of the C syntax and style to achieve reusability, adaptability and reliability. Students will learn how to apply data abstraction and class design and careful attention is paid to code efficiency, performance and testing. The course does not require awareness or familiarity with object oriented programming techniques, but programming experience of some kind is assumed.

Programming in C++ For Non-C Programmers

This course is designed to give delegates the knowledge to develop/maintain programs using C++ and its object oriented techniques. The course is for Programmers moving to object-oriented programming using C++.

Programming in C++ For Programmers

C++ is one of the most popular programming languages used for software development. It is used in the areas of systems software, application software, device drivers, embedded software, high-performance server and client applications and video games. Compilers are available for all major platforms. The GNU Compiler collection provides a high quality free C++ compiler for many platforms. This hands on course provides a comprehensive introduction to the key features of the language.

Introduction to Colour Grading

This course is aimed at editors, data wranglers or enthusiasts who want to flesh out their knowledge of colour correction work. The course teaches critical colour theory concepts, how to use scopes and also analyses how colour is used in film to create mood or affect viewers perceptions.

Introduction to Dynamic Website Development using PHP

Whichever authoring tool you use, and however much it simplifies the coding process, there is great benefit to be had from understanding PHP structures properly. Our course teaches PHP syntax, server side operations and the SQL commands that will let you get started with creating robust data driven PHP pages.

Introduction to Maxon Cinema 4D R18

This course teaches the use of Cinema 4D to create all kinds of 3D graphics, modeling, rendering and animations. Workflows and techniques covered will prepare you for product design, architectural visualisation, character animation, scientific simulations, game development, special effects and motion graphics.

Introduction to WordPress

This course will teach users how to identify the major components of a blog, website, CRM or CMS. It will explain the key features of WordPress and its capabilities as a blogging or content management tool, how to plan and design a site and then how to use WordPress to build it.

Advanced WordPress and Custom Theme Development

This course builds on our Fundamentals course and shows delegates how to take advantage of further and more advanced features of WordPress. It includes theme development and customisation, taking advantage of plug-ins, integrating social media how to optimise your WordPress site for search engine discovery.

Introduction to Google Analytics

Google Analytics is the most popular and intuitive web analytics tool available today. This training course is aimed at internet marketers, PR departments and content creators and focuses on teaching delegates the GA user interface, how to finding data efficiently and how to interpret the results.

Introduction to SketchUp Pro

This SketchUp training class makes 3D modeling easy for anyone to learn. After attending our SketchUp class you'll be able to use the software to work under real-world time constraints. From broadcasters to architects and engineers, virtually every industry uses SketchUp to model and animate 3D objects and environments.

Introduction to Google Web Designer

This is an introductory course for designers new to Google Web Designer. In this course, students will learn to create interactive content and web ads using text, graphics, video and animations. The course focuses on the essentials, and emphasises best practice throughout the course.

Introduction to Articulate Storyline

This course introduces the features of Articulate Storyline. Through hands-on exercises it covers the typical work-flow and techniques to create great e-learning content. The technologies are discussed to help decide between Flash and HTML5 publishing.

Introduction to Davinci Resolve

This course is aimed at those wanting to become colourists or DITs and wishing to work with industry standard colour grading application, Davinci Resolve. The course teaches critical colour theory concepts, how to use scopes and other important aspects of Resolve 10.0.

Davinci Resolve For Editors

This course is aimed at video editors who are already doing colour correction work in their NLE, possibly using Magic Bullet, Film Convert or other similar plugins, but want to take their skill levels in Resolve up a notch. The course builds on the delegate’s knowledge of scopes and makes comprehensive coverage of the principle tools and techniques in Resolve.

Pro Tools Introduction

This course covers basic Pro Tools principles, giving you the required skills to complete a Pro Tools project from initial set up to final mix-down. The course provides delegates with the skills needed to understand how to record live instruments, manage MIDI sequencing of software synthesisers and audio looping, amongst others.

Oracle Database Querying Fundamentals

This course provides a solid introduction to SQL (Structured Query Language). The course assumes no previous knowledge of SQL and SELECT statements, and takes delegates from simple queries, through to complex queries involving multiple tables, introducing the vast collection of built-in functions along the way. Although it provides an overview of relational database design principals, it does not cover formal database design processes or database and table creation. This course is aimed at developers, report writers, analysts and anyone who needs to extract information from data stored in a relational database. It is appropriate for users of Oracle 9i, Oracle 10g and Oracle 11g.

Introduction To Oracle PL/SQL Programming

This course is aimed at application developers and database administrators. Delegates to the course will learn the fundamentals of the PL/SQL programming language, writing stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will also learn programming, management and some of the security issues associated with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features. The course is applicable to Oracle 9i, Oracle 10g and Oracle 11g users.

Oracle Database Querying Advanced

This course is aimed at Oracle database developers, administrators and analysts who need to take the basics of Oracle SQL Data Manipulation Language (DML) statements to the next level. The aim of the course is to show the more advanced use of SELECT, UPDATE and DELETE statements providing delegates with the necessary knowledge and hands on experience to construct complex queries to satisfy complex information extraction requirements. The course focuses on real world business needs and shows how to make the extensive Oracle library of functions work together to manipulate and extract data values. It also explores the many different ways of retrieving information from multiple tables from simple multi-table SELECT statements through to complex correlated sub-queries as well as introducing the many ways of analysing and processing data through methods such as grouping of data and implementing computed columns. The course will do more than just teach each topic as an isolated subject; it will show delegates how to integrate all these query methods and more to help satisfy their business information extraction needs. The course is appropriate to users of Oracle 9i, Oracle 10g and Oracle 11g.

Introduction to Audacity

This course is aimed at podcasters, teachers, lecturers and Higher Education users who use Audacity to create audio material to a high standard. In addition, Audacity can be used by community groups and individuals to create oral history projects.

Unix and Linux Fundamentals

The objective of this course is to provide a comprehensive introduction to the UNIX operating system. At the end of the course delegates will have the fundamental skills required to login to a Unix system, manage files and directories, use Unix commands and manage processes, use an editor, access the electronic mail facility and create simple shell scripts.

Linux System Administration: LPI 101/102 & CompTIA Linux+ Certification

You will acquire the skills needed to install and support one or more distributions of the Linux operating system and learn information and skills that will be helpful as you prepare for LPI exams (Exam Codes: LX0–101 and LX0–102). This course is intended for entry-level computer support professionals with basic knowledge of computer hardware, software, and operating systems, who wish to increase their knowledge and understanding of Linux concepts and skills to prepare for a career in Linux support or administration, or to prepare for LPI exams (Exam Codes: LX0–101 and LX0–102). A typical student in the LPI Certification course should have at least 6 to 12 months of Linux experience.

Colour Correction & Grading Introduction: Lumetri Colour in Adobe Premiere Pro & After Effects

Take your productions to a new level with the powerful colour grading capabilities of Adobe® Premiere and Adobe After Effects, Lumetri Color Tools, now part of Adobe Premiere Pro CC and Adobe After Effects CC. Craft your looks to create picture-perfect output for virtually any format, from handheld tablets to the big screen. Up your creativity. Focusing on Adobe Premiere's Lumetri Color colour correction tools & scopes, this 1 day hands on training course will teach you the basics of colour correction & grading; from analysing shots, using Scopes, correcting problems and creating grades. It will also teach you the principles and workflow of colour correction. The Lumetri Colour Tools, scopes and work space have given Adobe Premiere Pro a professional and comprehensive set of colour correction and grading features, enabling users to accurately colour correct and grade a sequence with out exporting to dedicated colour grading packages. ?Learn these new tools and the process of colour correction and grading, quickly and effectively, with our 1 day course.

Adobe Photoshop Elements

This course is designed for those who need to understand the fundamental features and uses of the application and the best way to incorporate these into their work.

Introduction to Adobe Captivate

This Adobe certified course introduces users to Adobe Captivate. The course is designed to take participants through the development process of building software demonstrations and interactive simulations. The course is task-based, with participants learning be recording and updating projects. Along with covering the key features of Captivate, the course focuses on best practices to record Captivate projects.

Advanced Adobe Captivate

Captivate offers the possibility of creating complex interactive courseware to levels that are only introduced at a basic level in the Introduction to Captivate course. This course extends your understanding of Captivate so you are able to generate much more flexible and responsive learning materials. There is also an emphasis in the course on providing tips for an efficient and effective workflow, whatever your personal circumstances. The course is taught using practical examples and a hands-on experiential approach.

Introduction to MS Publisher

This one day course is aimed at new and novice users of Publisher who wish to be able to create and edit publications. After completing this course you will be able to create text and image rich publications based on pre-formed templates and from scratch.

Creating Databases in SQL Server

Delegates attending this course will cover start to finish creation of SQL Server relational databases. They will be introduced to all SQL Data Definition Language (DDL) statements, and will create database storage, tables, data integrity constraints, and indexes. The course is aimed at Database Administrators and Database Developers/Database Designers who will need to create a new database from scratch or will be responsible for maintaining database storage, structures, schemas and design for existing databases on a SQL Server platform. This course, along with the SQL Server Database Querying and Advanced SQL Server Database Querying Courses, helps to prepare delegates for the Microsoft 70-461 exam: Querying Microsoft SQL Server 2012/2014/2016 and exam 70-762: Developing SQL Databases (M20762), which credit towards MCSA and MCSE certifications. It should be noted, however, that all course attendances should be complemented by reference to the skills measured by the exam, a period of self-study and test exams before sitting the actual exam. Covers SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014,and SQL Server 2016.

Designing a Data Warehouse (BI)

This course is aimed at data warehouse and business intelligence designers, implementers and managers, but will also serve as a good basis for business and data analysts who will be involved in working with data warehouses and business intelligence deployments. All individuals who will be involved in some element of working with a data warehouse will benefit from gaining an understanding of the dimension modelling concepts that influence the final design of a data warehouse. Delegates will be introduced to the basic terminology and concepts of a Kimball-based Data Warehouse architecture. The course covers Dimension Modelling Techniques introducing the basics of Fact Tables, Dimension Tables, Dimension Hierarchies and more. Case studies are used throughout to demonstrate the concepts taught and to introduce the need for some of the more advanced modelling techniques such as Factless Tables, Enterprise Data Warehouse Bus Architecture, handling Slowly Changing Dimensions and Snapshots, Bridge Tables, Recursive Hierarchies. As well as introducing the concepts and terminology of the data warehouse design, delegates will learn about the design cycle and processes, the ETL requirements and processes and ensuring that the model is fit for both current and future business requirements. This course is generic, but use of SQL Server and its business intelligence service and tools (DBMS, SSIS, SSAS and SSRS) will allow for some hands on elements of data warehouse design to be carried out to re-enforce concepts. This course can be followed by the SQL Server Business Intelligence courses to address the implementation of a data warehouse, multidimensional cube and reporting deployment in a SQL Server environment: (SSAS) SQL Server Analysis Services, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services.

Introduction to FileMaker Pro

FileMaker Pro is the database “for the rest of us” - a rapid development tool that non-coders can use to manage all aspects of their business. Our introductory course teaches the key techniques in FileMaker needed to build databases, including table structure, layout design, comprehensive search techniques and ways to control the consistency and appearance of data. The course also introduces the fundamentals of relational database design, so that information can be shared across layouts, and the basics of simple automation using buttons.

Intermediate FileMaker Pro: Relational Database Design and Scripting

This FileMaker Authorised course teaches good practice in the design of efficient relational database systems. The course includes full explanations of how and when to link tables together using primary and secondary keys in FileMaker Pro and introduces FileMaker scripting, to provide automation and efficiency of procedures within a database solution. It also looks at techniques to improve the user experience, such as helpful navigation and the use of multiple windows and introduces the power of FileMaker calculations.

Advanced FileMaker Pro

This two day course is aimed at those wanting to learn powerful techniques and best practice in FileMaker database design. It covers some of the less obvious features of FileMaker and emphases the creative use of relationships to build user-friendly interfaces and the efficient capture, display and output of data. The course draws on many tried and tested procedures used by FileMaker developers to create database systems that are both easy to use and that possess rich functionality when required.

Preparatory Training for the FileMaker Certified Developer Exam

This five day course is based on the curriculum of the official FileMaker Training Series (see http://www.filemaker.com/uk/learning/training/fts.html). The FileMaker Training Series (FTS) consists of thirteen modules that cover a comprehensive set of topics that provide the building blocks for successful FileMaker solution development. The topics include beginner, intermediate and advanced content to help any level of FileMaker developer improve their development skills, master the essentials of the FileMaker 16 product line and become a FileMaker Certified Developer. For further information, see http://www.filemaker.com/uk/learning/training/fts.html.

Introduction to Mail Designer Pro 3 for Mac

Mail Designer Pro 3 allows you to create professional mobile-optimised newsletters on your Mac, entirely without without having to understand HTML code, using a powerful design interface. This one day course will cover the whole process of designing professional HTML emails which work beautifully on mobile and desktop.

Effective Writing Skills

This course will enable those who want to improve their writing skills to produce more effective emails, memos, letters, e-shots, marketing collateral, reports and Intranet content. Grammar, structure and reader focus will all be covered.

Introduction to Interviewing for Web

This course is designed to give delegates an understanding of how to conduct successful interviews for use in blogs, podcasts, vlogs and other digital media. Those attending will learn about the different styles of interviews and how to adapt them for different platforms as well as planning, structuring and editing an interview. Delegates should bring a device that records audio and/or video – e.g. a smartphone/tablet/camera + headphones, mic and editing software.

Introduction to Google Apps

This half day course covers an overview of Google apps, including Google Docs, Google Sheets, Google Slides and Google Drive. The focus is on essential skills and additional useful techniques for working more efficiently.

Introduction to VectorWorks

Delegates attending this course will learn how to utilise tools, menu commands and drawing organisation in Vectorworks. The course provides the necessary basics needed to make use of 2D and 3D modeling techniques, to understand the use of graphical styles and outputs in presenting your drawings and how to follow best practice workflows in Vectorworks.

Introduction to Sketch

This course is designed for anyone who needs to understand the fundamental features and uses of Sketch and the best way to incorporate these into their work as a designer, photographer or retouching artist.