Escalate your career by learning how to extract and change data in relational databases with SQL (Structured Query Language) that traverses multiple tables with Select, Insert, Update and Delete statements, functions and scripts. SQL is a current hot skill, valued by employers. Microsoft SQL Server is used for hands on exercises during this course. However, the content of the course is kept as close as possible to standard SQL. (Please note, there will be no instruction on how relat... [More]

Learn how to use a combination of Excel and VBA to improve your productivity, adding power and flexibility to spreadsheets by creating user-defined functions. Basic knowledge of Excel is assumed but no programming knowledge is required. Course Content Recorded Macros: Understanding excel macros; Setting macro security; Saving a document as macro enabled; Recording a simple macro; Running a recorded macro; Relative cell references; Running a macro with relative references; Viewing a ... [More]

Learn how to create dynamic database-driven websites using PHP and MySQL – the fastest-growing scripting language in the world. The course includes demonstrations and hands-on exercises in class along with programming notes. Course Content Background and History of PHP Why PHP is so popular Incorporating PHP into HTML Using PHP to create HTML Escaping characters Comments Processing Form Data Displaying PHP variables as HTML Receiving variables from a form and displaying them in the ... [More]

You probably already know a little of Facebook, Twitter and social bookmarking. In this one-day course you’ll get a real taste of the marketing power of the new Social Media campaigns: creating managing and distributing social content through online communities. We’ll look at case studies of customers engaging with companies on social media sites and evaluate the benefits and drawbacks of various social media tools. An interesting day spent exploring a dynamic and challenging area. ... [More]

Do you want to extend your knowledge in using the Joomla! Platform? This is beyond the introduction of using Sections, Categories, Articles and Menus. We look deeper into some of the business extensions that could be integrated with Joomla! to extend its usability from both ends (as a website administrator and as a site user). Content Content Joomla! Templates – Based on a pre-designed design Template installation Template editing Simple edits – index.php Simple edits – CSS Adding a... [More]

This Adobe dreamweaver course is for anyone interested in developing web pages and web sites with Adobe Dreamweaver. Adobe Dreamweaver is an industry leading web design tool and this course provides you with the basics to get started using this powerful software. Learn the basic concepts of web design, build a website and learn how to manage it in this course. This introduction will provide the groundwork to develop your web design skills in more advanced courses. Course Content Web... [More]

If you need to create product training materials; or would like to set up an online training for your professional service; or you are involved in teaching at any level then this workshop is ideal for you. This introduction course looks at ways of creating successful online training material as learning objects such as videos, podcasts, presentations then linking them to a platform such as an LMS, Blog or a CMS. The course will include hands on exercises using a pre-installed LMS ap... [More]

The skills and knowledge acquired in Microsoft PowerPoint Level 2 are sufficient to be able to build and enhance powerful, real-world presentations for sales, budgets, clubs and more. In this course you will learn how to enhance text in a presentation, add media features, setup a slide show and more. Course Content Text techniques Text pointers Adding text directly to a slide Formatting text Formatting paragraphs Changing bullet and numbering styles Editing text Applying simple word... [More]

The aim of this course is to build on the introductory skills of Level 1. You will learn how to ensure that data is entered correctly, how to create more sophisticated and complex queries and will be introduced to some basic automation techniques involving macros. Course Content Data validation: Assigning default values; Validation rules and text; Validating numbers; Setting required fields; Working with validations Querying techniques: Modifying a saved query; Creating and queries;... [More]

Microsoft Word Level 2 extends the learner’s basic skills and knowledge of Microsoft Word and helps them create more intricate and varied documents. Existing skills and knowledge are enhanced by covering more advanced aspects of key topics such as formatting, tables, and lists, and new features such as merging, envelopes, sections, clip art and graphics are introduced. This course is ideal for people who work in an environment where there is a requirement to produce more intricate d... [More]