863 Courses in Cardiff delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for This course is for employees of Sun Life who want to learn how to use HUE when working with SQL databases. Overview Upon successful completion of this course, students will be able to operate HUE when interacting with SQL databases. In this course, students will learn how to operate HUE when interacting with SQL databases. Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify and Execute a Saved Query Performing a Conditional Search Search Using One or More Conditions Search for a Range of Values and NULL Values Search Data Based on Patterns Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators Retrieving Data from Multiple Tables Combine the Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Exporting Query Results Generate a Text File Generate an XML File Additional course details: Nexus Humans SQL Querying Fundamentals with HUE - Part 1 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 SQL Querying Fundamentals with HUE - Part 1 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 45.625 Days 273.75 CPD hours Overview Live, instructor-led virtual classes: Benefit from an interactive classroom with added flexibility and convenience. Access to Red Hat certified instructors: Virtual classes are taught by the same experienced subject matter experts who lead classroom trainings. Flexible scheduling options: Various class topics and time options facilitate incorporating learning and preferences into busy schedules. Focused training sessions: Participants can narrow their learning to more specific topic areas. Choice of learning modality: A combination of self-paced materials and expert-taught classes maximizes learning. Train without traveling: Learn when, where, and how it is best for you Red Hat© Learning Subscription Premium provides a customizable learning experience with self-paced and live training options. Users can tailor their learning with recorded video classes, e-books, online content, and live virtual classes. A subscription provides access to content across the entire Red Hat product portfolio, content that is continuously updated by Red Hat experts. Live, instructor-led classes create an engaging, immersive learning experience. These interactive sessions compliment the on-demand, self-paced learning materials available with a Red Hat Learning Subscription for highly effective, flexible training for everyone from beginners to experienced professionals.This subscription provides an array of additional features to complement the learning experience. Cloud-based labs give the opportunity for hands-on practice in actual Red Hat environments. Expert extras are short, on-demand videos where Red Hat practitioners demonstrate innovative technologies in practical scenarios. Skills paths and pre-assessments are available for course selection guidance. Red Hat Learning Subscription Premium also includes certification exams. Red Hat?s exams are industry-recognized and performance-based. These exams validate that holders have the skills needed to undertake even the most ambitious technology projects. Reporting capabilities to track progress toward training and certification goals. 24x7 self-paced access to Red Hat online training and video classroom courses Content is created by Red Hat experts who build and use Red Hat technology and is directly related to Red Hat certification exams. Early access Be the first to explore in-development technology before it is officially released by accessing courses and labs in development. Cloud-based labs Get hands-on practice in authentic Red Hat environments, delivered 24x7 on six continents. Skills paths Map your learning and certification goals to one of the skills paths inside the platform to develop a strong foundation for a specific skill set. Certification exams and retakes Validate your skills through performance-based exams remotely or at a testing station. Exams can be taken when and where it's most convenient. Expert extras Red Hat field practitioners present short demo videos to supplement courses by showing innovative technologies and practices based on actual use cases. Expert chat Get direct answers and guidance from curriculum experts via a 30-minute chat session per day. Machine translations provide chat dialogue in local languages. E-book Downloads Download course e-books to continue learning offline. Reporting An individual?s dashboard provides a summary of training progress, courses and labs taken, and exam status. Management reports provide insights so a team?s engagement and progress can be measured. Globally available,translated content Access Red Hat?s most popular courses in as many as 11 languages: English, International Spanish, Brazilian Portuguese, French, Italian, German, Simplified Chinese, Korean, Japanese, Hindi, and Czech. Additional course details: Nexus Humans Red Hat Learning Subscription Premium 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 Red Hat Learning Subscription Premium 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.

MojiTax is hosting an invaluable event for ADIT students aimed at unlocking the secrets to exam success. This engaging session is designed to provide insights into MojiTax's effective learning methodologies that have contributed to its impressive success rates. Attendees will benefit from expert discussions on Knowledge-Based Learning, and Exam Writing Techniques. Additionally, we will share motivational ADIT journies, highlighting the impactful benefits of MojiTax. This event represents a unique opportunity for ADIT candidates to enhance their exam preparation strategies, connect with a supportive community, and learn from those who have excelled. Video time: X hours Exams: X Author: MojiTax Level: Not Applicable Study time: 1 hour 01 Live session Open Event Link (2pm - 3pm London Time)

Overview The Risk Analysis course is a highly demanded certification for roles in project risk management. It recognizes skills, competency, and competency in assessing and identifying project risks, mitigating threats and capitalising on opportunities, while still possessing core knowledge and practical application in all areas of project management. The risk management specialist role on project teams is becoming more important to an organization's success. This course has been designed to benefit professionals who have the responsibility of regularly making important business decisions and wish to enhance their Risk Management abilities and apply them to their businesses. Upcoming Events Online (USD 2250) Online Streaming Live (Flexible Dates) For more dates and Venue, Please email sales@gbacorporate.co.uk

Overview In this competitive era no matter how much hard work and solid efforts are contributed still, too many projects end up creating unneeded and unsellable products. There is a significant risk that the outcome of the project may not be relevant to the client/user requirements or become outdated when needs change. Here is where Design Thinking and Agile Management play their role. The combination of Agile and Design Thinking should be used in order to achieve impactful outcomes. Agile and design thinking together works well and gives an effective approach to product development, one that results in efficient resolutions to significant problems. In this course, you'll learn how to define and determine what's important to a user primary in the process, to frontload value, by directing your team on testable narratives about the user and generating an effectively shared perspective. For more dates and Venue, Please email sales@gbacorporate.co.uk

Our Fast Track Level 3 training course is tailor-made for immigration advisors and legal professionals seeking a targeted, time-efficient course focusing on essential OISC Level 3 syllabus fundamentals. This course is 1 day. Our fast track OISC Level 3 one day course is specifically designed for those interested in progressing to the next OISC level. This course focuses on 3 main areas which are introduced at Level 3: Preparation and conduct of appeals, Bail applications to the First-tier Tribunal and Pre Action-Protocol Letters. Throughout this training, you will acquire a comprehensive understanding of the intricate structures and frameworks governing UK immigration law at an advanced level. Our expert instructors will provide in-depth insights, practical knowledge, and invaluable tips to equip you with the necessary skills and confidence to handle complex immigration cases.   Course joining links, materials and instructions are sent out 24hours before the course starts. Why Study with Immigration Advice Service? Immigration Advice Service has been providing professional immigration services for over 10 years in the public, private and corporate sectors. Our OISC Level 3 (Fast Track) preparation course is thoughtfully crafted to equip participants with a comprehensive understanding of the essential knowledge needed at OISC level 3. Our fully qualified and OISC regulated trainer will guide you through the process and ensure you are competent with elements covered within the course. Course Content: This fast track course is specifically designed to covers the following key areas. Introduction: The OISC Level 3 assessment The preparation and conduct of appeals Bail applications to the First-tier Tribunal Pre Action Protocol Letters Prior to judicial review Looking for a more in-depth training session? Why not check out our standard Level 3 training course which recaps and builds on from knowledge learnt at OISC Level 2 and delivered over a 2-day period.

Overview OBJECTIVES Develop practical skills enabling effective communication at the time of an incident Familiarize students with both techniques & technologies involved in crisis communication Provide a health check for your personal & organizational readiness Provide the confidence to know that your response strategies are appropriate and effective Build relevant knowledge through exploring relevant case studies and practical exercises Develop flexible creative and well-motivated teams Upcoming Events Online (USD 1950) Online Streaming Live (Flexible Dates) At Venue (USD 4500) Dubai 20 Feb - 24 Feb Istanbul 27 Feb - 3 March London 20 March - 24 March For more dates and Venue, Please email sales@gbacorporate.co.uk

Course Duration: Half-day or full-day program (with virtual delivery options) Target Audience: HR professionals, leaders, managers, and wellbeing champions who are responsible for creating and maintaining mental health support systems and promoting work-life balance within their organisations. Course Objectives By the end of this course, participants will be able to: Understand the importance of mental health and wellbeing in the workplace. Learn strategies for creating a workplace culture that supports mental health and resilience. Develop practical tools to prevent burnout and promote work-life balance. Identify systems and resources to help employees maintain mental health and manage stress. Design and implement a workplace wellbeing plan that fosters employee engagement and productivity. Course Outline Module 1: The Importance of Workplace Wellbeing What is workplace wellbeing? Understanding mental health, emotional wellbeing, and work-life balance The link between employee wellbeing and organisational performance Statistics and trends: The rising importance of mental health in the workplace The business case for prioritising mental health: reducing absenteeism, turnover, and improving productivity Legal and ethical considerations in workplace mental health Module 2: Mental Health in the Workplace Recognising the signs of mental health challenges (e.g., anxiety, depression, stress) The impact of workplace culture on employee mental health Stress and burnout: Causes, symptoms, and prevention strategies The role of leadership in promoting mental health and supporting employees Confidentiality and stigma: Overcoming barriers to mental health support Module 3: Creating a Culture of Wellbeing Building a supportive and inclusive workplace culture that prioritises mental health Encouraging open dialogue: How to talk about mental health and reduce stigma The role of leadership in modelling and promoting wellbeing practices Policies and practices to promote work-life balance (e.g., flexible working, remote work options) The importance of employee engagement in fostering a culture of wellbeing Module 4: Systems and Resources for Mental Health Support Developing an Employee Assistance Program (EAP) and other mental health resources Peer support networks and mental health champions within the workplace Mental health first aid training: How to support colleagues in need Creating accessible resources for employees to manage their mental health (e.g., online tools, workshops, apps) Integrating wellbeing initiatives into existing HR systems: policies, performance management, and professional development Module 5: Strategies for Managing Stress and Preventing Burnout Stress management techniques for individuals and teams Time management, task prioritisation, and setting boundaries to reduce stress Mindfulness and relaxation exercises to combat workplace stress Encouraging regular breaks, physical activity, and healthy work habits Building resilience: Developing coping strategies for challenging situations Preventing burnout: Identifying early warning signs and taking proactive measures Module 6: Promoting Work-Life Balance Defining work-life balance in today’s connected world Strategies for setting boundaries between work and personal life Managing expectations: How to avoid overworking and reduce the pressure to be "always on" The importance of taking breaks, vacations, and "disconnecting" from work Flexible working arrangements and how they contribute to balance Supporting parents, carers, and individuals with other life commitments Module 7: Implementing a Workplace Wellbeing Plan Conducting a wellbeing audit: Understanding current practices and identifying gaps Designing a comprehensive wellbeing program: Key components and best practices Measuring the success of wellbeing initiatives: Metrics, feedback, and employee engagement Aligning wellbeing efforts with organisational goals and values Action planning: Creating a roadmap for rolling out workplace wellbeing initiatives Communicating wellbeing resources and encouraging employee participation Module 8: Sustaining Wellbeing in the Workplace Embedding mental health and wellbeing into the organisation’s long-term strategy Continuous improvement: Monitoring and refining wellbeing programs Engaging employees in ongoing wellbeing activities (e.g., wellness challenges, workshops, wellness days) Training leaders and managers to foster ongoing mental health support Celebrating successes and recognising the importance of mental health in organisational culture Delivery Style Interactive, with a blend of group discussions, case studies, and role-playing activities Practical exercises for creating wellbeing strategies and action plans Relaxation techniques and mindfulness exercises incorporated into the sessions Tools and templates for creating mental health initiatives in the workplace Employee engagement surveys and feedback collection techniques to measure program effectiveness Course Materials Provided Workplace Wellbeing Framework and Best Practice Guidelines Wellbeing Plan Template and Action Plan for Implementation Stress Management and Resilience Toolkit Resources for Managers: Creating Mental Health-Supportive Teams Mental Health First Aid Checklist and Employee Assistance Program Resources Resource list: Apps, books, and online resources for mental health in the workplace Optional Add-ons Follow-up sessions for managers and leaders on maintaining a mental health-friendly work environment E-learning modules on specific aspects of wellbeing (e.g., stress management, mental health first aid) One-on-one wellbeing consultations or coaching for employees Employee wellbeing workshops (e.g., mindfulness, physical wellness, nutrition)

Overview Internal auditing is an independent and objective activity to evaluate an organisation's internal operations. You'll learn how to initiate an audit, prepare and conduct audit activities, compile and distribute audit reports and complete follow-up activities. It is very important for the organisation to have a smooth flow of accounting as it plays a very important role in the development of the organisation. Financial Managers or any person who deals with Accounts need to see that the company accounts are very updated and are free from any risks that can become a problem during the time of Auditing.  Objectives   By the end of the course, participants will be able to: Efficiently dealing with senior leaders with confidence Effective Contribution and Strategically Analysing and Auditing towards business success Analysing and Evaluating as an effective internal audit leader How to manage key relationships with the audit committee Practical methods for managing the audit committee and senior management Describing the significance to help maximize the contribution to their organization

Effective communication in the workplace is part and parcel of our daily lives, but not everyone is a natural.  Do you find it tough standing up in front of people? Does the thought of engaging with audiences in any setting fill you with anxiety? Is doing a remote video message to colleagues on Zoom or Teams a tough call? Do you do it regularly but need some professional guidance on whether it’s working? At CoComms we can improve every aspect of your performance and offer a range of tips and techniques to help manage these environments and keep your audience engaged and interested. Public Speaking and Presentation Training In a professional setting it’s vital to come across as dynamic, trustworthy, credible and real. You want people to trust you and in turn get behind your vision or plan or proposal. If you can achieve this you can improve your confidence, your engagement and your prospects. Our training is designed to hone your presentation skills so whether you are pitching for work, taking colleagues through change or speaking to a new audience, you can do it with a clarity and confidence that makes your messages clear and insightful. The training includes: Perfecting your slides Working to produce a clean, easy to navigate slide deck that give logic and flow to your presentation. Developing your storytelling We use our journalistic techniques to show you how to build a story to keep your audience engaged with a well-structured and entertaining presentation. Calls to Action Make sure it is clear what you want to achieve and what you want from your audience. Rehearse and Review We film and then playback a range of practical presentation exercises so we can review your performance and work to make any improvements. Conference and Panel Training The audience at a conference may be a captive one, but that doesn’t mean they are always listening and engaging with what you have to say. We can make sure your keynote speech or panel contribution is memorable, appreciated by your audience and beneficial to your business. Our training looks at preparing for and delivering a speech from start to finish and includes: Defining your big ideas What is it you want to say and what do you want your audience to remember? Develop your narrative and script How can you get across your message using storytelling. Choosing the right language How vibrant and energised language can make the difference in your speech. The tips and tricks to make sure your speech is memorable How vocabulary and delivery techniques ensure your words are heard. Controlling the message How to deal with unhelpful questions and return to the main aspects of your story. Stakeholder Communication Training Engaging effectively with stakeholders with clarity and confidence can make all the difference to your relationships. A successful “town hall” meeting can win over your sceptics, convince those who are unsure and build a common goal between your business and stakeholders. Our stakeholder communication training prepares you for these vital meetings and includes: Focusing the meeting We look at how to control the meeting so the important business is covered and how to prepare for any questions or comments you may receive. Keep control of the conversation We teach you conversational techniques to focus on the main points without being too assertive or dismissive. Rehearse and Review We use video and practical role-play exercises to assess your performance and look for ways to improve. Breaking down the information We look at how to present facts and figures without overwhelming (or boring!) your audience. Our techniques will help you narrate the message in a clear and comprehensive way. Making an impact Using our journalistic experience we will work with you to develop your presentation skills to make the biggest impact and demonstrate credibility and authority. Video Calls for Business The world has changed. Now is the time to ensure your business is changing too. Many in-person meetings, conferences, networking events and clients hosting are, for now, a thing of the past. These face-to-face interactions have been replaced by video calls, webinars and online events. So, how do you develop contacts, maintain relationships and manage your team in this new virtual world? How do you look and sound confident, be heard, and build trust and credibility through a computer screen? At CoComms, we are online communications experts and our years of experience in broadcasting mean we understand how to engage a virtual audience. Interactive and practical training We work with you through a variety of scenarios to analyse your performance on video calls. Feedback on your performance We offer supportive, positive feedback and share our tried and tested techniques so you can improve. Make Video Calls work for you Through our training you will become more confident, more productive and more dynamic on video calls. Contact us If you have a query regarding any of our services or would like to book a consultation for free initial advice and guidance please get in touch