778 Courses in Cardiff delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Advanced SQL Programming (TTSQL005) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours Overview Understand why Blockchain is needed and where Explore the major components of BlockchainLearn about Hyperledger Fabric and the structure of the Hyperledger ArchitectureLean the features of the Fabric model including chaincode, SDKs, Ledger, Security and Membership ServicesPerform comprehensive labs on writing chaincodeExplore the architecture of Hyperledger FabricUnderstand and perform in depth labs on Bootstrapping the NetworkPerform comprehensive labs to integrate/develop an application with Hyperledger Fabric running a smart contractBuild applications on Hyperledger FabricCourse Outline: This training course has been created to walk you through Chaincode Development, Testing, and Deployment for a Hyperledger Fabric Network catering specifically toward Golang written Chaincode (Fabric?s original Chaincode Language). Additionally as an Application Developer you will learn how to write, and prepare Client Applications using the most mature Standard Development Kit in Hyperledger Fabric, NodeJS. Blockchain Basics (Overview)Hyperledger Fabric Development EnvironmentKnowing the Difference: ComposerChaincode Use CasesChaincode BasicsGolang Shim DevelopmentDatabases for the DeveloperChaincode Dev. Deployment and InteractionsClients & SDK Development: Fabric-NetworkClients & SDK Development: Fabric-Client InteractionsLogging and Monitoring

A masterclass in devising therapeutic metaphors This inspiring online training day gives you powerful, non-intrusive ways to help distressed young people – and others – overcome difficulties in their lives – the skills you will learn can also be used with adults Accredited CPD: 6 hours Length: 1 day (9.15am - 4.00pm GMT) LIVE ONLINE – Join Pamela Woodford live online on Tuesday 18th June 2024 for this enjoyable, experiential CPD accredited training day – you will have plenty of opportunities to ask questions, take part in exercises to practice the steps involved, come up with pertinent metaphors and create your own story. Limited numbers. BONUS RECORDING – you will also get a recording of the tutor sessions for a limited time afterwards to maximise your learning. >> If you can’t make this date please register your interest below and we’ll let you know as soon as a new date is available. Fantastic online training, engaging and thought-provoking throughout. The confidence Pamela has given me will impact positively on my everyday practice, I am truly inspired...PSYCHOTHERAPIST Why take this course Children’s natural affinity with stories gives us an incredibly powerful, non-directive way to help emotionally distressed and abused young people, who can sometimes be hard to reach in any other way. On this practical live training event you will learn how to tap into your own metaphorical brain to create therapeutic stories and metaphors ‘in the moment’ that are appropriate to each individual’s circumstances and experiences. Throughout the day Pamela – a master storyteller and highly experienced psychotherapist – draws on her own case histories, metaphor and story examples as she guides you through the steps involved in ‘thinking on your feet’ and creating a story yourself in the moment. By the end of the day you will have lots of new, innovative ways to engage with and help distressed children deal with the experiences they have had – whilst also offering them hope, understanding, and new ways of thinking and feeling about life and themselves. Indeed, you may well be surprised at how quickly positive psychological changes occur as a result of the stories you will create and tell ‘in the moment’. Stories also play a crucial role in child development – through the ways the different characters think, act and overcome difficulties, children gain important templates for understanding the world and dealing with the challenges and situations they will meet in life – both now and in the future. They are a wonderful way to help build resilience. Storytelling and the careful use of therapeutic metaphor are crucial elements of successful counselling and psychotherapy – they help bypass assumptions and rigid thinking to offer a new, broader way of looking at things, awaken innate resources and offer crucial hope – just what struggling children need… Wonderful, interactive online course. Pamela is a joy to listen to – I learnt so muchCOUNSELLOR What will you learn A clear understanding of how to address emotional issues in children Simple ways to calm and relax children – “it’s the way you tell ‘em” Tips for igniting your own imagination and creativity How to ‘think metaphor’ to find the right one for each situation A step-by-step guide to creating your own stories – the 6 steps for creating short stories with metaphors specifically tailored to quickly bring about positive psychological changes in children and young people Breathing life into inanimate objects and taking inspiration from nature – how to tune into your metaphorical mind Valuable experience in creating your own therapeutic story from scratch How to use your stories and metaphors The importance of paying attention to the words children use when telling you something Case histories which illustrate the effectiveness and flexibility of stories – and show why they are such powerful therapeutic tools, even with difficult cases How to find your own metaphors and connect them emotionally to distressing situations Using embedded suggestions in stories – exercise Different ways to use therapeutic stories, such as those in Pamela’s acclaimed Brighter Little Minds series, to develop emotional literacy The importance of incorporating all of our senses How to adapt stories to use with adolescents and adults Tips for thinking creatively ‘on your feet’ to come up with suitable metaphors and ideas there and then in the moment Flexible skills that can easily be adapted to working with adults Why subtly entwining a child’s interests into a story makes its impact stronger How to introduce a story or therapeutic metaphor naturally into your conversation Feedback on the story you create and time to ask questions of the tutor – a highly experienced and creative psychotherapist who has spent decades working therapeutically with distressed children and young people A greater appreciation of the subtle power of metaphor, imagination and embedded suggestions and how to use them to help the young people you care for Increased confidence in creating and telling therapeutic stories yourself A variety of story examples and ‘scripts’ Lots of new ideas from Pamela Woodford’s ‘treasure chest of healing spells’ to spark your own creativity Tips for improving your own storytelling abilities Such a helpful live online training day – the use of metaphor via story form is a powerful toolHEAD OF BEHAVIOUR SUPPORT SERVICE – EDUCATION Course Programme The ‘How to create healing stories for distressed children’ live online workshop starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am What can go wrong for children? How stories can help 11.00am Comfort break and discussion 11.10am Using metaphor, relaxation, imagination and embedded suggestions 1.00pm Lunch break 1.40pm Setting the scene and creating the story 3.10pm Comfort break and discussion 3.20pm Sharing the stories you have created 4.00pm Day ends Who is this course suitable for? Anyone working with emotionally distressed children or young people, including: Psychotherapists, therapists and counsellors Teachers and educational professionals Childcare and healthcare professionals (and students) Foster carers Adoptive parents – and perspective adoptive parents Social workers Parents and carers Interested friends or family who wish to help a young person they know And anyone who would like to attend for personal reasons This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

A life without anxiety can be yours with our bespoke blend of clinical hypnotherapy and advanced NLP therapy techniques. Start with a free online Q&A session. Start enjoying a life free from anxiety

Interior design tutor one to one open 7 days 9 am to 9 pm

Update and renewal option for Geopace Training Certificate holders Update and renew your existing certificate ... Recommended certificate renewal after 18 months Nationally Recognised Dual Accreditations Open College Network Accredited (Advanced Level) CPD Accredited (The CPD Certification Service) Recaps phlebotomy theory incl. legislation Updates your certification and compliancy Awards cumulative credits and CPD points awarded Basic understanding of English language required Download a certificate on completion of your online course APPLICANTS ARE REQUIRED TO HAVE COMPLETED AN ACCREDITED INTRODUCTION TO PHLEBOTOMY COURSE

This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects.

Teach you how to be a better dater Help you with confidence Teach love languages Self-awareness test Personality type test Dating coaching Past issues healing process Assess love life Improve relationships Help with your dating profile 4 sessions 1 hour Dating advice for singles https://relationshipsmdd.com/product/bridget-jones-rescue-package/

A high-impact programme designed to be fun and to get people fully involved. The first-class, jargon-free content is based on what people need to know in practice, not off-putting legal language. This introductory course covers: Introducing Working Safely: Accidents can happen to anyone. The realities of the human suffering behind the statistics. The importance of personal responsibility. Defining hazard and risk: Focusing on the six broad hazard groups, participants are asked to think about the hazards and risks they come across in their own work. 'Risk assessment' demystified. Identifying common hazards: All the main issues - aggression and violence, asbestos, bullying, chemicals and harmful substances, computer workstations, confined spaces, drugs and alcohol, electricity, fire, getting in and out, height, housekeeping, lighting, manual handling, noise, personal hygiene, plant and machinery, slips and trips, stress, temperature, vehicles and transport, and welfare facilities. Improving safety performance: Bridging the gap between management and workforce, encouraging participants to play their part. Also covered: contract work, inspections, safe systems and permits, protective equipment, signage, emergency procedures, reporting and health checks.

This very practical session is designed to enable participants to improve the impact, clarity and accuracy of their reports. It focuses equally on the two key areas - structure and writing technique. This course will help participants: Scope reports based on objective and intended readership Write a structured report Use the Fog Index to ensure readability Write grammatically correct and well-punctuated text Review and edit their work. 1 Introduction Objectives and overview Introductions and personal aims 2 What makes a good report? Practical activity and feedback 3 Before you start The planning process and scoping a report Organising information Key report headings What goes where? Writing practice and review 4 Writing tips and techniques Clear English and use of language Grammar and sentence structure Refresher in punctuation Writing in the third person The Fog Index - and how to measure readability 5 Pulling it all together Reviewing and proofing 6 Review Summary of key learning points Action planning