3886 Courses delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for This is an advanced course for DBAs and technical individuals who plan, implement, and maintain Db2 11.1 databases Overview This course is designed to teach you how to: Perform advanced monitoring using the Db2 administrative views and routines in SQL queries. Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer. Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation. Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images. Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements. Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity. Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory. Adjust database or Db2 instance configuration options to improve application performance or processing efficiency. Implement Db2 Self Tuning Memory management for specific database memory areas. This course is designed to teach you how to Perform advanced monitoring using the Db2 administrative views and routines in SQL queries. Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer. Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation. Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images. Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements. Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity. Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory. Adjust database or Db2 instance configuration options to improve application performance or processing efficiency. Implement Db2 Self Tuning Memory management for specific database memory areas. Course Outline Advanced Monitoring Db2 Table Space Management Db2 Database Memory Management Database rebuild supportDb2 database and tablespace relocation Db2 Incremental Backup Additional course details: Nexus Humans CL464G IBM Db2 11.1 Advanced Database Administration 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 CL464G IBM Db2 11.1 Advanced Database Administration 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.

Canine Communication Course Overview This Canine Communication course offers a comprehensive introduction to understanding how dogs communicate, both with their own kind and with humans. Learners will explore canine behaviour, body language, emotions, and socialisation, gaining vital insights into canine psychology and intelligence. The course equips learners with essential knowledge to interpret dog signals accurately, promoting better relationships between dogs and their owners or handlers. Whether you are a dog enthusiast, pet owner, or professional working with animals, this course enhances your ability to recognise and respond to canine communication effectively. By the end of the course, learners will be confident in identifying signs of canine wellbeing and distress, helping to ensure the welfare and happiness of dogs in various environments. Course Description Delving deeper into the fascinating world of canine behaviour, this course covers key topics such as the evolution of dogs, their cognitive abilities, and the critical role of socialisation in shaping behaviour. Students will learn to decode canine body language and emotional cues, developing an understanding of how dogs express themselves non-verbally and interact with humans. The curriculum also examines the psychological aspects of dogs, highlighting the importance of recognising signs of suffering and emotional distress. Furthermore, the course explores the responsibilities of dog owners and essential skills for anyone working with dogs professionally. Delivered in a structured, engaging format, this course develops the theoretical knowledge needed to foster strong, empathetic connections between humans and dogs. Canine Communication Curriculum: Module 01: Introduction to Canine Evolution Module 02: Introduction to Canine Intelligence Module 03: The Importance of Socialisation Module 04: Canine Communication Module 05: Canine Psychology Module 06: Dog Communication and Body Language Module 07: Communication Between Dogs and Humans Module 08: Canine Emotions and Signs of Suffering Module 09: The Role of a Dog Owner Module 10: Essential Skills for Working With Dogs (See full curriculum) Who is this course for? Individuals seeking to better understand dog behaviour and communication. Professionals aiming to enhance their knowledge for careers in animal care or training. Beginners with an interest in canine psychology and dog welfare. Pet owners wanting to improve their relationship with their dogs. Career Path Dog Trainer or Behaviourist Animal Welfare Officer Canine Therapist or Rehabilitation Specialist Veterinary Assistant Pet Care Professional Dog Walking and Boarding Services

Acrylic Nail Extension Course Course Overview: This Acrylic Nail Extension course is designed to equip learners with the essential skills to master acrylic nail extension techniques. From understanding nail anatomy and product chemistry to advanced nail art, this course covers everything you need to know about acrylic nails. Learners will develop proficiency in applying acrylic nail extensions, performing maintenance, and ensuring client care and safety. By the end of the course, students will have the knowledge and expertise to apply various nail techniques, making them confident in offering professional services. Whether you are a beginner or seeking to refine your skills, this course provides all the necessary knowledge to build a successful career in the beauty industry. Course Description: This comprehensive course offers a detailed exploration of acrylic nail extensions, starting with the basics of nail anatomy and product chemistry. Learners will delve into essential techniques such as applying tips, overlays, and creating nail art. With modules focusing on nail diseases, disorders, and proper maintenance, the course ensures learners can safely and professionally care for their clients' nails. The course also includes in-depth modules on client communication and salon safety, making sure that students can provide excellent customer service while following industry best practices. Upon completion, learners will have a complete understanding of acrylic nail extensions, from application to removal, and will be equipped to confidently enter the beauty industry with practical skills and a professional approach. Acrylic Nail Extension Course Curriculum: Module 01: Nail Extension Techniques: An Introduction Module 02: Nail Anatomy Module 03: Nail Diseases and Disorders Module 04: Nail Product Chemistry Simplified Module 05: Nail Extension Techniques Module 06: Acrylic Nail Extension: Part-1 (Applying Tips to the Nails) Module 07: Acrylic Nail Extension: Part-2 (Applying Overlays) Module 08: Art in Acrylic Nails: Basic to Advance Module 09: Hands-on Nail Art Training Module 10: Maintaining Artificial Nails Module 11: Acrylic Nail Removal Module 12: Health and Safety in Beauty Salon Module 13: Client Care and Communication (See full curriculum) Who is this course for? Individuals seeking to master acrylic nail extension techniques. Professionals aiming to expand their beauty industry skills. Beginners with an interest in nail care and beauty treatments. Beauty enthusiasts looking to enter the nail extension field. Career Path Nail Technician Beauty Salon Specialist Freelance Nail Artist Nail Care Educator Beauty Consultant Spa and Salon Owner

End of Life Care Course Overview The "End of Life Care" course offers a comprehensive foundation in providing care to individuals at the end of life. Learners will explore key aspects such as the availability of services, advanced care planning, and the goals of care. This course addresses various medical conditions, including physical and neurological illnesses, while also highlighting the importance of communication, psychosocial, and spiritual care. Upon completion, learners will have a thorough understanding of the necessary skills and knowledge to offer quality care during this sensitive time, ensuring individuals and their families receive respectful, empathetic, and professional support. Course Description This course covers a broad range of topics essential for providing quality end-of-life care. Learners will study the availability of care services, the importance of advance care planning, and the various goals of care tailored to individual needs. The curriculum includes an in-depth examination of physical and neurological illnesses, as well as the holistic assessment of care needs. Additionally, learners will focus on effective communication techniques, spiritual and psychosocial care, and legal aspects surrounding end-of-life decisions. By the end of the course, learners will be equipped with the skills to navigate sensitive end-of-life situations, ensuring compassionate care is delivered across all aspects of patient wellbeing. End of Life Care Curriculum Module 01: Introduction to End of Life Care Module 02: Availability of Services Module 03: Advance Care Planning Module 04: Goals of Care Module 05: Physical Illness Module 06: Neurological Illness Module 07: Quality Care at the End of Life Module 08: Communication During the End of Life Module 09: Palliative Care Holistic Assessment Module 10: Spiritual and Psychosocial Care Module 11: Care after Death Module 12: Further Support, Training and Development Module 13: Legal Aspects (See full curriculum) Who is this course for? Individuals seeking to enhance their understanding of end-of-life care. Professionals aiming to specialise in palliative or hospice care. Beginners with an interest in healthcare, particularly in the field of end-of-life care. Those wanting to contribute to improving quality of life in critical care settings. Career Path Palliative Care Specialist Hospice Care Worker Care Manager in End-of-Life Settings Social Worker for End-of-Life Services Health and Social Care Advisor for Elderly and Terminally Ill Individuals

Better Business Cases™ Practitioner: Virtual In-House Training Better Business Cases™ is based on the Five Case Model - which is the UK government's best practice approach to structuring spending proposals and making effective business decisions. Using this best-practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives. The goal of the practitioner course is to develop a candidate's ability to deliver a comprehensive business case, through encouraging expanded knowledge to guide the practical application of theoretical foundations. Upon the completion of this Practitioner course, a candidate will be able to start applying the model to a real business case development project. What You Will Learn At the end of this program, you will be able to: Develop the lifecycle of a business case and to establish the relationships between the five cases Apply the steps in the business case development framework, in order to support the production of a business case, using the Five Case Model, for a given scenario Overview of Better Business Cases Alignment with the strategic planning process Importance of the Business Case using the Five Case Model Overview of the Five Case Model Purpose of the key stages in the development of a spending proposal Purpose of a Business Justification Case Business Case Development Process Purpose of project / programme assurance and assurance reviews Responsibility for producing the Business Case Determining the Strategic Context and Undertaking the Strategic Assessment Scoping the Scheme and Preparing the Strategic Outline Case Planning the Scheme and Preparing the Outline Business Case Procuring the Solution and Preparing the Full Business Case Implementation and monitoring Evaluation and feedback Making the Case for Change Agree on the strategic context Determine spending objectives, existing arrangements, and business needs Determine potential business scope and key service requirements Determine benefits, risks, constraint, and dependencies Exploring the Preferred Way Forward Agree on critical success factors Determine long list options and SWOT analysis Recommend a preferred way forward Determining Potential Value for Money Revisit the short list Prepare the economic appraisal for short-listed options Undertake benefits appraisal Undertake risk appraisal Select preferred option and undertake sensitivity analysis Preparing for the Potential Deal Determine the procurement strategy Determine service streams and required outputs Outline potential risk apportionment Outline potential payment mechanisms Ascertain contractual issues and accountancy treatment Ascertaining Affordability and Funding Requirement Prepare the financial model Prepare the financial appraisals Planning for Successful Delivery Plan programme / project management Plan change and contract management Plan benefits realization Plan risk management Plan programme / project assurance and post project evaluation Procuring the Value for Money Solution Revisit the case for change Revisit the OBC options Detail procurement process and evaluation of best and final offers (BAFOs) Contracting for the Deal Set out the negotiated deal and contractual arrangements Set out the financial implications of the deal Ensuring Successful Delivery Finalize project management arrangements and plans Finalize change management arrangements and plans Finalize benefits realization arrangements and plans Finalize risk management arrangements and plans Finalize contract management arrangements and plans Finalize post-project evaluation arrangements and plans

IELTS Exam Preparation Course Overview This IELTS Exam Preparation course is designed to equip learners with the essential skills needed to excel in the IELTS exam. Covering all four sections of the test—listening, reading, writing, and speaking—the course provides in-depth insights into the format and structure of the test. Learners will develop strong English language skills, ensuring they are well-prepared for each section of the exam. By the end of the course, learners will gain confidence in their ability to manage time, understand test requirements, and perform under exam conditions. With expert guidance and structured content, this course aims to help learners achieve their desired IELTS band score. Course Description This course delves into each component of the IELTS exam, helping learners understand its format and assess their strengths and weaknesses. The grammar modules focus on essential areas such as sentence structure, punctuation, and capitalisation to ensure learners can effectively communicate their ideas. The listening, reading, writing, and speaking modules are tailored to build specific skills required for each section of the exam, guiding learners through practice exercises and strategies for optimal performance. Through engaging lessons and mock tests, learners will gain a clear understanding of what is expected in the IELTS exam and how to approach each section with confidence. The course also includes practical advice on preparing for the test, managing exam stress, and performing well under timed conditions. IELTS Exam Preparation Curriculum Module 01: Introduction to IELTS Module 02: IELTS Test Format Module 03: Grammar for IELTS: Basics of Grammar Module 04: Grammar for IELTS: The Basics of Sentence Module 05: Grammar for IELTS: Structure of Sentence Module 06: Grammar for IELTS: Punctuation & Capitalisation Module 07: The Listening Section Module 08: The Reading Section [Academic] Module 09: The Writing Section [Academic] Module 10: The Speaking Section Module 11: IELTS [General Training] Module 12: IELTS Life Skills Module 13: What To Do Before The IELTS Test? Module 14: IELTS Full-length Practice Tests (See full curriculum) Who is this course for? Individuals seeking to achieve a high band score in the IELTS exam. Professionals aiming to meet English language proficiency requirements for work or study. Beginners with an interest in pursuing international education or career opportunities. Those preparing for the IELTS exam as part of their visa application process. Career Path International student in higher education. Migration consultant or advisor. Professional in need of an English language proficiency qualification. Candidate for job roles requiring IELTS certification for global organisations.

Microsoft Office Basic to Advance Course Overview The "Microsoft Office Basic to Advanced" course provides comprehensive training on the essential applications in the Microsoft Office Suite. From Excel to Word, PowerPoint, and Access, this course equips learners with the skills needed to navigate and master each program's features. Whether you are looking to improve efficiency in everyday tasks or enhance your career prospects, this course covers everything from basic functions to advanced techniques, ensuring a thorough understanding of each program's capabilities. Upon completion, learners will be proficient in using Microsoft Office applications for personal, academic, and professional purposes, enhancing productivity and employability. Course Description This course dives into all key components of the Microsoft Office suite, offering in-depth coverage of Excel, Word, PowerPoint, and Access. Starting with the fundamentals, learners will gain expertise in managing data, creating documents, designing presentations, and managing databases. The course also covers advanced topics such as complex Excel functions, detailed document formatting in Word, effective presentation techniques in PowerPoint, and data management in Access. Through a blend of engaging activities and expert guidance, learners will acquire valuable skills to increase their productivity and confidently use these programs in any professional setting. Microsoft Office Basic to Advance Curriculum Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Microsoft Word 2019 Module 09: Microsoft Word 2019 New Features Module 10: Getting Started with Word Module 11: Formatting Text and Paragraphs Module 12: Working More Efficiently Module 13: Managing Lists Module 14: Adding Tables Module 15: Inserting Graphic Objects Module 16: Controlling Page Appearance Module 17: Preparing to Publish a Document Module 18: Workbooks - Microsoft Word 2016 (Beginner) Module 19: Microsoft PowerPoint 2019 Module 20: Microsoft PowerPoint 2019 New Features Module 21: PowerPoint Interface Module 22: Presentation Basics Module 23: Formatting Module 24: Inserting Options Module 25: Working with Objects Module 26: Table Module 27: Charts Module 28: Review and Presentation Module 29: Microsoft Access 2019 Module 30: Microsoft Access 2019 New Features Module 31: Introduction to Access Module 32: Modify Data Module 33: Working with Queries Module 34: Access Forms Module 35: Working with Reports (See full curriculum) Who is this course for? Individuals seeking to improve their Microsoft Office skills. Professionals aiming to enhance their software proficiency for career advancement. Beginners with an interest in office administration or data management. Those wishing to upgrade their knowledge of Microsoft Office for better job opportunities. Career Path Office Administrator Data Analyst Administrative Assistant Project Manager Executive Assistant IT Support Specialist

Company Accounting - tax return, Annual accounts and Annual return Training Course If you want to work in a Finance or Tax department of a business or as an accountant in well-known accountancy firms it is vital that you know how to prepare accounts for the company and submit them to the right places. This UK Tax accounting course will upgrade your skills to higher level. Completing this course will enable you learn more about the procedures involved in submitting Corporate Tax Return. Once you are skilled on this, you can offer this as a service to potential business clients and earn £££. If you are running a business you can process your own Business Tax return and Accounts, instead of paying someone else to do it. It will save a lot of money (£££) every year. You will stay ahead of the competition if you are looking for a job in the Accounting or Tax Industry once you are skilled Business Accounting and Tax procedures. Identifying requirements to set up a UK Company Identifying Statutory Requirements for Companies Introduction to Confirmation Statement processing Identifying Types of Companies based on size Identifying Types and requirements of various Submissions available Identifying minimum requirements in a Balance Sheet and Profit & Loss Account Identifying Tax Return periods and deadlines Identifying Penalties for Late filing Identifying Closing Down Procedures for Companies Introduction to the Filing Company accounts procedure Company house forms and correspondences Understanding of IXBRL requirements Understanding submission procedures using HMRC Online CT600 (Webfiling) Using one Business(SME/Micro Entity) case to understand the procedures on Annual Submission for Company Tax Return and Accounts submission

Come to an online event. Grow your business with expert training and support from other business professionals, entrepreneurs, freelancers, small start-ups and SME's.

This specialist training is required for anyone in charge of a Junior Section or Company Camp/Holiday. This course is being held online over two evenings, attendance at both parts is required. Open to any BBUK Leaders who have fully completed the registration process. Safeguarding and Managing Risk e-learning modules must be completed prior to attending the training course. By the end of the course you will be able to: Identify the key elements in the preparation phase of a residential. Set realistic aims for the event in consultation with children and young people. Plan and deliver a high-quality programme at a residential. Carry out effective risk assessments for residentials. Understand the importance of maintaining professional boundaries during settings such as residentials, events, and activities outside of BB weekly sessions. Recognise the importance of maintaining safe and appropriate boundaries with children and young people during residentials. Understand and meet the needs of children and young people away from home. Contribute to positive working relationships with adult colleagues. Renewal of certification is required every five years, which can be done by attending the course or submitting logfiles of residentials attended to UKHQ.