6238 Courses

Duration 2 Days 12 CPD hours This course is intended for This basic course is for everyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of Overview Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses Code inner joins and non-correlated subqueries Use SQL arithmetic operations Use scalar and column functions Use UNION and UNION ALL INSERT, UPDATE and DELETE rows Code simple CREATE TABLE and CREATE VIEW statements This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment. Outline Introduction Simple SQL Queries Retrieving Data from Multiple Tables Scalar Functions and Arithmetic Column Functions and Grouping UNION and UNION ALL Using Subqueries Maintaining data

This is a one day welding course for two people wishing to learn to arc weld, and make a basic 3 dimensional welded steel sculpture ,Cost £300 We are limited to what we can do in one day (6 hour course ) . Your teacher for the day will be award wing sculpture artist Roger Russell . In one day you will learn to weld with confidence and accuracy, a range of welds sizes . You will make a steel dragon fly to take home ,like the one in the picture. You will also be taught how to cut and bend metal using Metalcraft XL5 and mini bending machines, to make the parts of your dragon fly . Anyone completing a welding course with me can can have access to my supervised workshop and equipment on a £100 per day rate, and or for a 2 hour evening session , booked in advance is £20.

Our Cosmeti-Craft Workshops are a great way of learning a new skill and having some fun making your own cosmetics. Children from age 5 upwards can have fun learning about colours and smells while older children experience a more detailed tutorial on the uses and effects of cosmetic ingredients.

Parents workshop for teen mental health, suitable for parents of teens and preteens - covering depression, anxiety, general mental health, how to cope with exam stress, bullying and an overview of eating disorders and some other conditions

Join us for a 2-day Youth Mental Health First Aid (MHFAider®) course at The Ashcombe School in Dorking! Learn how to provide crucial support during a mental health crisis while gaining the skills to spot early signs of mental health issues. This in-person course creates a safe, supportive environment, with self-care prioritised throughout. Subsidised price: £20. Let's make mental health a normal part of everyday life!

Join us for a 2-day Mental Health First Aid (MHFAider®) course at The Ashcombe School in Dorking! Learn how to provide crucial support during a mental health crisis while gaining the skills to spot early signs of mental health issues. This in-person course creates a safe, supportive environment, with self-care prioritised throughout. Subsidised price: £10. Let's make mental health a normal part of everyday life!

Blindvision Equality, Diversity and Inclusion Training Module 2

Craft, create, and make. Have fun at this adult workshop, Lincolnshire

For a lovely set of hand and foot prints why not book in for an hour of squishing hands and toes in clay and making coloured hand prints in what ever shape you like. More than one child? then keep them entertained making a few things while they wait there turn. £35 per hour £10 any additional child.

If your looking to really get to grips with throwing, from handles to lids, tea pots to platters. Then why not book in for a two day session or a couple of hours a week £35 per person per hour £20 any additional person per hour.