17674 Courses in Cardiff delivered Online

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for application programmers who need to write embedded SQL COBOL or PL/I programs in either a DB2 9 or DB2 10 for z/OS environment. Overview Incorporate static SQL statements in an application program Prepare the program for execution Validate execution results are correct Produce code to support multiple rows being returned from the database manager using cursors Identify considerations regarding units of work, concurrency, and restart of programs Identify differences between static and dynamic SQL Provide test data for applications Discuss program and DB2 options relative to performance of static SQL This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution. CV720G;CF82G;DB2 Concepts Identify DB2 family products Explain DB2 workstation component functions Identify DB2 objects Identify the key differences between static SQL and other application alternatives for accessing DB2 data Program Structure I Embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs Effectively communicate with DB2 when processing NULL values and determining success of statement execution Demonstrate use of DB2 coding aids Code CONNECT statements within an application program Identify connection types and impacts on a unit of work Program for the Call Attach Facility (CAF) Program Preparation Identify the additional steps necessary to prepare a program that contains embedded SQL for execution Describe the functions of the DB2 PRECOMPILE and BIND processes Describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements Program Structure II Use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs Issue positioned UPDATE and DELETE statements Identify how scrollable cursors can be used Recovery and Locking Concepts Define a unit of recovery Identify the basic locking strategies used by DB2 Dynamic SQL Introduction Describe the difference between static and dynamic SQL List the types of dynamic statements Code dynamic SQL in a program Managing Test Data Identify methods to insert data into a table Use the LOAD or IMPORT utility Identify the purpose of the RUNSTATS utility Identify the purpose of the REORG utility Performance Considerations Use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts Identify the access paths available to DB2 List common causes of deadlocks and avoid such causes when possible Use the EXPLAIN tools as aids to develop applications that emphasize performance Additional course details: Nexus Humans CV722 IBM DB2 11 for z/OS Application Programming Workshop 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 CV722 IBM DB2 11 for z/OS Application Programming Workshop 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.

Carrying out manufacturing activities on multiple products with different specifications consecutively.

Unlock the full potential of Microsoft Excel with our course for everyone. Learn essential skills and advanced techniques to excel in any data-driven role.

With over 11 million NHS dental appointments each year, dental hygiene is a growing industry in the UK. Discover the keys to a bright, healthy smile with this engaging dental hygiene course. This engaging dental hygiene course unlocks the secrets of proper dental care through 10 comprehensive modules. Gain invaluable knowledge covering all aspects of oral health, from anatomy and hygiene to common diseases and paediatric care. Whether you want to start a dentistry career or improve your dental health, this dental hygiene course provides the skills and knowledge needed to educate yourself and others. The UK spends over £3 billion on dental services annually - join this high-demand industry and elevate your career prospects today! This Dental Hygiene Course covers the following topics: Understand the fundamentals of dental anatomy and physiology. Master proper oral hygiene techniques for plaque and disease prevention. Identify and educate patients on common dental and oral diseases. Explore the link between nutrition and dental health. Provide specialised care for children's developing teeth. Navigate the denture care process for improved oral function. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Dental Hygiene course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Dental Hygiene is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Dental Hygiene course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Dental Hygiene Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Module 01: Introduction to Dental Hygiene Introduction to Dental Hygiene 00:18:00 Module 02: Benefits of Personal Dental Care Benefits of Personal Dental Care 00:21:00 Module 03: Dental Anatomy Dental Anatomy 00:15:00 Module 04: Methods of Oral Care Methods of Oral Care 00:34:00 Module 05: Dental and Oral Diseases Dental and Oral Diseases 00:41:00 Module 06: Diet and Dental Health Diet and Dental Health 00:29:00 Module 07: Paediatric Dental Care Paediatric Dental Care 00:20:00 Module 08: Herbal Oral Care Herbal Oral Care 00:40:00 Module 09: Dental Check-Up Dental Check-Up 00:24:00 Module 10: Dentures Dentures 00:16:00 Assignment Assignment - Dental Hygiene Online Course 00:00:00

Good English skills are very important in the UK. The ability to express thoughts clearly and confidently in English can open doors to countless personal and professional opportunities. This Functional Skills English Level 2 course will improve your English language abilities and make you more confident in speaking and writing English. The Functional Skills English Level 2 course covers all the basics of English. You will learn about grammar rules and how to construct proper sentences. The modules of Functional Skills English Level 2 course will teach you about sentence structure, question formation, punctuation, and capitalisation. You will also learn techniques to improve your spelling and avoid common mistakes. After completing this Functional Skills English Level 2 course, you will have a recognised qualification in English. Your English language skills will be enhanced significantly. You will be able to communicate more effectively, both in writing and speaking. This will increase your chances of getting better jobs or pursuing higher education in the UK. This Functional Skills English Level 2 course covers the following topics: Gain a fundamental understanding of English grammar principles. Comprehend and craft diverse sentence structures. Formulate effective, clear, and grammatically correct questions. Apply correct punctuation and capitalisation rules. Enhance spelling accuracy, reducing common mistakes. Develop strategies for continuous improvement in English skills. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Functional Skills English Level 2 course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Functional Skills English Level 2 is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Functional Skills English Level 2 course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Functional Skills English Level 2 Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Functional skills english level 2 Introduction to the Course 00:13:00 Basics of Grammar 00:16:00 The Basics of Sentence 00:11:00 Structure of Sentence 00:19:00 Questions 00:13:00 Punctuation and Capitalisation 00:24:00 Spelling 00:27:00 Common Mistakes and Ways to Improve 00:21:00 Mock Exam Mock Exam - English: Spelling, Punctuation and Grammar 00:20:00 Final Exam Final Exam - English: Spelling, Punctuation and Grammar 00:20:00

Overview of Handyperson/Handyman The need for skilled Handyperson/Handyman services is growing across the UK. Over 60% of households depend on reliable people to help with repairs and improvements in their homes. With many older homes and a focus on fixing and updating properties, both cities and countryside areas need good Handyperson/Handyman workers. This course is a great way to learn the right skills and start working in a field where every day brings something new. In this Handyperson/Handyman course, you will go through 13 helpful modules. These cover important topics like using tools safely, basic plumbing, electrical jobs, painting, and putting furniture together. You will also learn how to start your own small repair service. This course is made for people who like fixing things, enjoy hands-on tasks, and want to turn that interest into regular work. Property maintenance in the UK is worth over £40 billion, and the demand for skilled workers is strong. After finishing this Handyperson/Handyman course, you can work for yourself or with small businesses and property agencies. Many people need help with repairs, and having the right skills can give you regular work and peace of mind. If you enjoy practical jobs and want to build a future that fits your skills, this Handyperson/Handyman course is the right choice for you. Learning Outcomes By the end of this Handyperson/Handyman course, you will be able to: Understand the main tasks and responsibilities of a Handyperson/Handyman. Know the important tools and how to use them safely. Learn the basics of plumbing and electrical work. Understand how to repair and maintain walls, floors, and surfaces. Use painting, tiling, and decorating techniques properly. Know the key steps to start your own Handyperson/Handyman business. Who is this course for? This Handyperson/Handyman course is perfect for: People who want to learn how to fix and maintain things at home. New or aspiring Handyperson/Handyman professionals interested in many trades. Anyone planning to provide local repair or maintenance services. DIY lovers who want proper training to improve their skills. Individuals thinking about starting a small Handyperson/Handyman business. Process of Evaluation After studying the Handyperson/Handyman Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Handyperson/Handyman Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements You don't need any educational qualification or experience to enrol in the Handyperson/Handyman course. Career Path Completing this Handyperson/Handyman course can lead to jobs like: Handyperson/Handyman – £22,000 to £35,000 per year Property Maintenance Worker – £21,000 to £32,000 per year Facilities Maintenance Assistant – £20,000 to £30,000 per year Caretaker/Maintenance Officer – £19,000 to £28,000 per year Self-Employed Handyman – £25,000 to £45,000 per year Course Curriculum Module 1: Introduction to Handyperson Introduction to Handyperson 00:22:00 Module 2: Basic Tools and Equipment Basic Tools and Equipment 00:22:00 Module 3: Electrical Work Electrical Work 00:23:00 Module 4: Plumbing Skills Plumbing Skills 00:19:00 Module 5: Appliances Appliances 00:18:00 Module 6: General Carpentry General Carpentry 00:26:00 Module 7: Basic Maintenance Skills Basic Maintenance Skills 00:14:00 Module 8: Walls and Floors Walls and Floors 00:19:00 Module 9: Painting and Decorating Painting and Decorating 00:17:00 Module 10: Drilling, Tiling and Welding Drilling, Tiling and Welding 00:22:00 Module 11: Construction Projects Construction Projects 00:16:00 Module 12: Health and Safety at Work Health and Safety at Work 00:27:00 Module 13: Starting Own Business for Handyperson Starting Own Business for Handyperson 00:27:00

Master essential calculus concepts with Engineering Calculus - Engineering Calculus Made Simple (Derivatives). From functions to derivatives and trigonometric identities, learn advanced mathematical techniques for engineering success.

Enhance your skills with our Speech & Language Therapy Course. Learn techniques to help children & adults with speech, language, & swallowing disorders. Enroll now & make a lasting impact!

Care Certificate: Care Certificate Online Training Introducing the Care Certificate: Your Pathway to Excellence in the Caring Profession Are you passionate about making a positive impact on the lives of others? Do you aspire to build a rewarding career in the caring profession? Look no further! The Care Certificate, our comprehensive Care Certificate course, is here to equip you with the knowledge and skills you need to excel in the world of care. The Care Certificate is a collection of agreed-upon standards that specify the knowledge, abilities, and attitudes that are required of various work categories in the health and social care sectors. The Care Certificate course is made up of the 15 minimum standards that should be covered if you are 'new to care' and should be part of a comprehensive induction course. The standards of Care Certificate are: Understand your role Your personal development Duty of care Equality and diversity Work in a person centred way Communication Privacy and dignity Fluids and nutrition Awareness of mental health, dementia and learning disabilities Safeguarding adults Safeguarding children Basic life support Health and safety Handling information Infection prevention and control Benefits of taking this Care Certificate course Industry-Recognized Accreditation: The Care Certificate is a nationally recognized qualification that serves as a testament to your commitment to providing high-quality care. Developed by industry experts and this Care Certificate holds immense value and is widely accepted across the care sector. Comprehensive and Engaging Content: Our Care Certificate: Care Certificate course curriculum is thoughtfully designed to cover all essential aspects of care provision. From person-centred care and safeguarding principles to infection control and communication techniques. With his Care Certificate you will gain a holistic understanding of the fundamental principles that underpin excellent care practice. Flexibility and Convenience: We understand the demands of a busy schedule. That's why we offer the Care Certificate: Care Certificate online, allowing you to learn at your own pace and from the comfort of your own home. Whether you are a full-time professional or a student, our flexible course structure ensures that you can fit your learning around your existing commitments. Experienced and Supportive Instructors: Our Care Certificate: Care Certificate course instructors are seasoned professionals with extensive experience in the care industry. They bring real-world insights and knowledge to the table, ensuring that you receive valuable guidance and mentorship throughout your learning journey. Enhanced Career Prospects: The Care Certificate is highly regarded by employers in the care sector. By obtaining this Care Certificate, you will significantly enhance your employability and open doors to a wide range of care settings, including hospitals, residential care homes, domiciliary care agencies, and community care centres. This Care Certificate: Care Certificate course serves as a strong foundation for further professional development and career progression. Ongoing Support and Resources: Our commitment to your success extends beyond the completion of the Care Certificate: Care Certificate course. With this Care Certificate course you will have access to a wealth of additional resources, including updated care guidelines, industry insights, and professional networking opportunities. We believe in empowering you with the tools you need to thrive in your care career. Don't miss out on this exceptional opportunity to elevate your care skills and take your career to new heights. Enrol in the Care Certificate: Care Certificate today and embark on a transformative journey of professional growth and personal fulfilment. Invest in your future. Invest in excellence. Enrol in the Care Certificate: Care Certificate now! Courses you will Get with Care Certificate: Care Certificate Course Course 01: Care Certificate Course 02: Social Worker Course 03: Level 6 Diploma in Health and Social Care Management Course 04: Level 2 Certificate in Preparing to Work in Adult Social Care [ Note: Free PDF certificate as soon as completing the Care Certificate: Care Certificate course] Care Certificate: Care Certificate Online Training Course Curriculum of Care Certificate: Module 01: Understand Your Role Experiences, Attitudes And Beliefs Values, Aims And Objectives Rights And Responsibilities At Work Confidentiality Working conditions Agreed ways of Working Reporting Errors Whistleblowing Working In Partnership Effective Partnership Working Advice And Support Module 02: Developing A Personal Development Plan Supervision and appraisal Agreeing your objectives Developing your knowledge, skills and understanding Learning and development Receiving feedback The Care Certificate Continuing your learning Module 03: Duty of care Supporting Independence Comments And Complaints Incidents, Errors And Near Misses Legislation of Care Certificate Managing Conflict And Difficult Situations Module 04: Equality and diversity Ways of working that reduce the likelihood of discrimination Valuing diversity The Equality Act 2010 and protected characteristics Other legislation of Care Certificate The code of conduct Reflecting to discover discrimination Information, advice and support Module 05: Work in a person-centred way Person-centred values in practice Working in a way that promotes person-centred values Promoting dignity The important of finding out the history, preferences, wishes and needs of the individual The changing needs of the individual Supporting individuals to plan for their future wellbeing and fulfilment, including end-of-life care Minimising environmental factors that may cause discomfort or distress Being aware of actions that may be causing discomfort or distress to individuals Supporting individuals to minimise pain or discomfort Supporting individuals to maintain their identity and self-esteem Supporting the individual using person-centred values Module 06: Communication Types of communication in Care Certificate Communication with other workers and individuals Communication and language needs, wishes and preferences Communicating by touch or physical contact Some specialist methods of communication Barriers to effective communication Reducing barriers to communication Checking to understand Additional information and support Confidentiality Limits to confidentiality Module 07: Privacy and dignity Privacy of Information Privacy and dignity in care and support Making choices Care Certificate Risk assessment Supporting active participation Selfcare Module 08: Fluids and nutrition The Importance of Good Nutrition And Hydration in Maintaining Health And Wellbeing Signs And Symptoms of Poor Nutrition And Hydration Supporting individuals to have access to fluids, food and nutrition in accordance with their care plan Module 09: Awareness of mental health, dementia and learning disability Mental health conditions Depression Anxiety Psychosis Dementia Learning disabilities Mistaking conditions Care and support Promoting positive attitudes The social model of disability, positive attitudes and person-centred practice Adaptations Reporting concerns The importance of early detection and diagnosis Adapting care and support Legal frameworks, policies and guidelines Mental capacity Making an assessment of capacity Module 10: Safeguarding adults Your Responsibilities Types of abuse and neglect - signs and indicators Protecting adults from abuse and neglect Six key principles underpin all adult safeguarding work Safeguarding adults reviews (SARs) Sources of advice and information Promoting dignity and rights The importance of individualised person-centred care Multi-agency Working Managing Risk in Care Certificate Complaints Spotting signs of abuse or neglect Reporting and responding to abuse and neglect Whistleblowing Legislation Information sharing Confidentiality Module 11: Safeguarding children What is Child Abuse? The impact of a parent’s/carer’s physical and mental health or domestic violence on a child's Wellbeing Children’s Rights Actions to Take When Abuse is Suspected or Alleged Internet and Online Social Networking Risks Legislation and Safeguarding Module 12: Basic life support Basic Life Support (BLS) Further training beyond the Care Certificate Cardiopulmonary resuscitation (CPR) Obstructed airway (adult) Obstructed airway (infant and child) Confidentiality Record keeping Refresher training Module 13: Health and safety Health and safety policies and procedures agreed with the employer Who is responsible for health and safety in your workplace? Health and safety tasks that require special training Accidents and sudden illness Medication and healthcare activities and tasks Hazardous substances in your workplace Fire safety Signs and indicators of stress in yourself and others Module 14: Handling information Legislation The Freedom of Information Act 2000 Handling information in health and social care Care plans Reporting concerns Module 15: Infection prevention and control The Chain of infection Breaking the Chain Your Health and Hygiene ‘5 moments’ for Hand Hygiene Hand Washing Personal Protective Equipment (PPE) Safe Handling of Waste Soiled Linen Assessment Method of Care Certificate: Care Certificate After completing Care Certificate: Care Certificate Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Care Certificate: Care Certificate After completing the Care Certificate: Care Certificate course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Care Certificate: Care Certificate Online Training This Care Certificate: Care Certificate course is ideal for anyone looking to secure a role in the social care sector. Requirements Care Certificate: Care Certificate Online Training To enrol in this Care Certificate: Care Certificate Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Care Certificate: Care Certificate Course. Be energetic and self-motivated to complete our Care Certificate: Care Certificate Course. Basic computer Skill is required to complete our Care Certificate: Care Certificate Course. If you want to enrol in our Care Certificate: Care Certificate Course, you must be at least 15 years old. Career path Care Certificate: Care Certificate Online Training This Care Certificate: Care Certificate course will prepare you for a variety of job paths, including the following: Child Support Worker Medical Assistant Care Worker Social Worker

This two-day programme gives the key insights and understanding of contracting principles and the impact they have on business and operations. The course is designed for individuals involved in or supporting contracting who want to improve their commercial management skills; individuals in functions such as project management, business development, finance, operations who need practical training in commercial management; general audiences wanting to gain a basic understanding of commercial management. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Associate (CCMA) qualification. The programme addresses 31 different subject areas, across the five stages of the contracting process. By the end of the course the participants will be able, among other things, to: Develop robust contract plans, including scope of work and award strategies Conduct effective contracting activities, including ITT, RFP, negotiated outcomes Negotiate effectively with key stakeholders, making use of the key skills of persuading and influencing and to work with stakeholders to improve outcomes Set up and maintain contract management systems Take a proactive approach to managing contracts Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Develop and monitor appropriate and robust Key Performance Indicators to manage the contractor and facilitate improved performance Understand the approvals process and how to develop and present robust propositions Make appropriate use of best practice contract management tools, techniques and templates DAY ONE 1 Introductions Aims Objectives Plan for the day 2 Commercial context Explaining the contracting context Define the key objective The importance of contact management Impact upon the business 3 Stakeholders How to undertake stakeholder mapping and analysis Shared vision concept, How to engage with HSE, Finance, Operations 4 Roles and responsibilities Exploring the key roles and responsibilities of contract administrators, HSE, Finance, Divisional managers, etc 5 Initiating the contract cycle Overview of the contracting cycle Requirement to tender Methods Rationale and exceptions 6 Specifications Developing robust scope of works Use of performance specifications Output based SOW 7 Strategy and award criteria Developing a robust contract strategy Award submissions/criteria 8 Managing the tender process Review the pre-qualification process Vendor registration rules and processes Creation of bidder lists Evaluation, short listing, and how to use of the 10Cs© model template and app 9 Types of contract Classify the different types of contracts Call-offs Framework agreement Price agreements Supply agreements 10 The contract I: price Understanding contract terms Methods of compensation Lump sum, unit price, cost plus, time and materials, alternative methods Cost plus a fee, target cost, gain share contracts Advanced payments Price escalation clauses DAY TWO 11 Risk How to manage risks Risk classification Mitigation of contractual risks 12 Contractor relationship management session Effectively managing relationships with contractors, Types of relationships Driving forces? Link between type of contract and style of relationship 13 Disputes Dealing with disputes Conflict resolution Negotiation Mediation Arbitration 14 Contract management Measuring and improving contract performance Using KPIs and SLAs Benchmarking Cost controls 15 The contract II: terms and conditions Contract terms and conditions Legal aspects Drafting special terms 16 Managing claims and variations How to manage contract and works variations orders Identifying the causes of variations Contractor claims process 17 Completion Contract close-out process Acceptance/completion Capture the learning/HSE Final payments, evaluation of performance 18 Close Review Final assessment