2981 Code courses

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. We also learn Data Definition Language and Data Manipulation Language statements. as well as course automation of queries using T-SQL. Hands-on, Practical SQL Advanced Course. PCWorkshops SQL Advanced Course Certificate. Max 4 people per course; we keep it personalised.

From propaganda to advertising, posters are a ubiquitous, powerful vehicle to take a message to the masses. Over four weeks, learn how to approach poster design in a creative and practical way. Although some computer work will be introduced, it will only be used as another production tool, participants will be encouraged to experiment with analogue techniques such as collage and hand-generated type. You will learn about the history of poster design; learn to use aspects of Adobe InDesign, Illustrator and Photoshop; develop approaches to letterform and layout. The emphasis of this course is on the development of a set of posters from research and design through to output. Week 1: History History of Poster Design: Looking at significant and famous posters from around the globe and their impact on society. Practical activity: After a quick introduction to InDesign we will recreate one of these posters, studying the component parts and their relationships to one another. Homework: Think of a concept for your design. What is it for? Who is your target audience? Where and how will it be displayed? Select a favourite poster to bring in or discuss with the group in week 2. Week 2: Image We will begin by discussing participant posters they have brought in to share and look at positives and potential negatives within the designs. Image selection can be a key factor to the success of your poster campaign. We will think about the choices between photography and illustration looking at examples of how this is done successfully. Think about the different ways we can generate and use images. Practical activity: Consider what medium the image might be and how it can be created. Learn about flatbed/film scanner for potential use in image creation. Week 3: Fonts We will look at how typography impacts designs and the messages that it can convey by itself. Consider various approaches to how we can generate type. How typographic selections work alongside selected images. Practical activity: Work through a few typographic workshops thinking about how typographic choices will alter the message you are trying to convey. We will consider various ways and techniques of creating type for our poster. Homework: Developing your typographic solution further, if required. Work through variations of layout. Week 4: Output Continue working on our posters making final tweaks and selecting the poster that is our most successful design for output. We will look at the various formats for output and how we prepare our posters for print. Look at usage of different poster sizes – why use one over the other?? Practical activity: Size your final poster and get it ready for output (if working analogue, scan final poster and upscale).   Courses are subject to minimum enrolment. Please register early, within five days of the start date, to reduce the likelihood of course cancellation. Please read our cancellation policy before booking. Students, anyone over the age of 65, and those in receipt of any form of benefits can claim the concessionary price, offering a 10% discount on the full course price. Valid proof of eligibility must be produced on the first day of the course. Please use the code CONCESSION when prompted at checkout.

This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

Duration 1 Days 6 CPD hours This course is intended for Looking for a way to extend your business operations? Look no further than the App in a Day workshop! In this one day course you will learn to build a custom, secure business application that you can share across your organise and will run across multiple platforms including tablets and mobile devices. Power Platform is a secure and scalable platform for building your own applications. In this course, you will learn how to build an application from the ground up by building the required UX, Backend, and frontend. All this without writing any code. Overview Some of the applications of the Power Platform you will learn to build will allow you to potentially: A) Share information with trusted colleagues and associates B) Monitor and manage your business operations C) Monitor and manage your customers D) Share business news on social media E) Share business photos and footage This course will teach you how to build your own application that is completely secure and private. Power Apps Canvas App Connect to data sources and filter results based on specified criteria Work with screens and navigation Use controls, properties, formulas, and actions to customize the user experience Display the logged in user?s name Configure app settings Save and share an app Run an app on a mobile device Microsoft Dataverse Create and customize a custom table Use the Form control Save data into the Microsoft Dataverse using the Form control Microsoft Dataverse Create a standalone Model-driven app. Customize forms for the Model-driven app Use a Business Process Flow to guide users through a process Microsoft Dataverse Create a flow that is triggered when a new Microsoft Dataverse row is created Automate sending approval requests Customize the approval based on the Microsoft Dataverse row Use the Approval centre

This module aims to develop knowledge and understanding of the importance of customs documentation in the world of international trade to ensure both parties clearly understand the documentation that will be required in the import or export of goods or services.

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems.

Description A spirited yoga practise to boost your energy, uplift your soul, and leave you feeling lit up from the inside out! Move better, breath better, and feel better for LIFE! This is an invigorating and energising mixed-ability yoga class designed to challenge you physically, make you sweat, and leave you with that blissed out post-yoga feeling! Options given to suit all levels of yoga experience - both beginner's and advanced students will find something to work on, from down-dog to handstands! Get strong, retrain habits, and get moving! Every class contains structured flowing movements interwoven with guided breath work. Challenge your strength, mobility, and fitness. Classes always end with svanasana - mindfulness-based guided relaxation, meditation, and massage to leave you feeling calm, grounded, and blissful. Carry that feeling over into your life, as you enjoy more energy, feeling more centred, and finding more strength and balance both on and off the mat. - Fantastic stress relief! - Improve your posture - Great mobility, strength, and balance training - Learn to move with confidence and prowess - Boost your energy! - Increase body-awareness, coordination, and mental focus - Feel more awake, more powerful, and more alive! Taught at the Hub on the Green - a beautiful calm and clean setting in the heart of Bournville. What style of yoga is it? Not all yoga is created equal! Roo teaches a modern style of yoga that has been developed by a physiotherapist and neurologist, providing movement education for both your body and your brain. This innovative method provides a smarter, safer, and more effective approach to yoga and movement. Working from the ground up with intelligent sequencing and emotional awareness, this movement practise is designed to retrain your habits, correct postural imbalances, and teach you how to hold yourself and move through space - so that you can stand tall, move with confidence, and feel empowered for LIFE! Come and feel the difference! First time? Use code TRYFOR5 to get your first drop-in class for only £5 🙂 Discounts for yoga teachers - get in touch to find out more! Option to drop-in (£11 per class) or book a 6 week block (£54). These are 6 consecutive classes, starting from the week you book them on. When there is a break (for example, over the summer), your 6 week block will be "paused" for the duration of the break, and start again when classes resume. There will be no refunds given for any classes missed within your block. Mats and yoga blocks are provided. Spaces are limited - pre-booking is strongly advised! Any remaining spaces will be allocated to walk-ins on the day on a first-come-first-served basis. If the room is full, I'm really sorry but you will be unable to join the class. So make sure you book! :D See you on the mat! Roo x

Description A spirited yoga practise to boost your energy, uplift your soul, and leave you feeling lit up from the inside out! Move better, breath better, and feel better for LIFE! This is an invigorating and energising mixed-ability yoga class designed to challenge you physically, make you sweat, and leave you with that blissed out post-yoga feeling! Options given to suit all levels of yoga experience - both beginner's and advanced students will find something to work on, from down-dog to handstands! Get strong, retrain habits, and get moving! Every class contains structured flowing movements interwoven with guided breath work. Challenge your strength, mobility, and fitness. Classes always end with svanasana - mindfulness-based guided relaxation, meditation, and massage to leave you feeling calm, grounded, and blissful. Carry that feeling over into your life, as you enjoy more energy, feeling more centred, and finding more strength and balance both on and off the mat. - Fantastic stress relief! - Improve your posture - Great mobility, strength, and balance training - Learn to move with confidence and prowess - Boost your energy! - Increase body-awareness, coordination, and mental focus - Feel more awake, more powerful, and more alive! Taught at the Hub on the Green - a beautiful calm and clean setting in the heart of Bournville. What style of yoga is it? Not all yoga is created equal! Roo teaches a modern style of yoga that has been developed by a physiotherapist and neurologist, providing movement education for both your body and your brain. This innovative method provides a smarter, safer, and more effective approach to yoga and movement. Working from the ground up with intelligent sequencing and emotional awareness, this movement practise is designed to retrain your habits, correct postural imbalances, and teach you how to hold yourself and move through space - so that you can stand tall, move with confidence, and feel empowered for LIFE! Come and feel the difference! First time? Use code TRYFOR5 to get your first drop-in class for only £5 🙂 Discounts for yoga teachers - get in touch to find out more! Option to drop-in (£11 per class) or book a 6 week block (£54). These are 6 consecutive classes, starting from the week you book them on. When there is a break (for example, over the summer), your 6 week block will be "paused" for the duration of the break, and start again when classes resume. There will be no refunds given for any classes missed within your block. Mats and yoga blocks are provided. Spaces are limited - pre-booking is strongly advised! Any remaining spaces will be allocated to walk-ins on the day on a first-come-first-served basis. If the room is full, I'm really sorry but you will be unable to join the class. So make sure you book! :D See you on the mat! Roo x

THIS COURSE PACKAGE INCLUDES: 1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5) 2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6) 3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom) Learn how to take blood ... train as a Phlebotomist FAST-TRACK YOUR PHLEBOTOMY TRAINING WITH OUR COMPLETE TRAINING PACKAGE 20% off - Multi-Course Discount Cover all stages from beginner through to Level 4 Available as Classroom or Virtual Classroom Complete your beginner to advanced training in 2 days Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications Both courses are dually accredited (OCN & CPD) Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom Covers all steps up to live blood draw Learn advanced skills and techniques Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep) Basic understanding of English language required OPEN TO ALL APPLICANTS