Course Overview This comprehensive course in Supply Chain Management, Purchasing & Procurement provides learners with the strategic knowledge and operational understanding needed to navigate today’s dynamic supply environments. It explores the core components of supply chain systems, procurement cycles, and purchasing strategies, offering insight into effective logistics planning, supplier relations, and risk mitigation. Learners will gain the tools to streamline processes, optimise procurement decisions, and align purchasing objectives with broader business goals. Designed to support both career development and organisational efficiency, the course equips participants with a strong foundation in modern supply chain functions—contributing to smarter decision-making and improved supply performance. Course Description This course delves into the critical areas of supply chain operations, from foundational concepts to advanced procurement practices. Participants will study logistic management frameworks, category and inventory management, transport coordination, and supplier relationship strategies. Special focus is given to procurement tools, bid management, and cost reduction techniques that can enhance purchasing functions. Through each module, learners are introduced to effective methods for improving supply accuracy, managing quality, and applying risk assessment across sourcing channels. The course supports learners in understanding the interconnected nature of global supply networks, helping them contribute more effectively to procurement, planning, and supplier engagement in diverse business settings. Course Modules Module 01: Supply Chain Basics Module 02: Supply Chain Drivers Module 03: Introduction to Logistic Management Module 04: Planning Framework for Logistics Module 05: Transport Management Module 06: Role of Procurement in an Organisation Module 07: The Purchasing Cycle Module 08: Purchasing Toolkits Module 09: Managing Competitive Bids Module 10: Quality Management Module 11: Supplier Relationship Management Module 12: Analysing and Reducing Risk in the Supply Chain Module 13: Improving Efficiency and Accuracy Module 14: Category Management Module 15: Inventory Management Module 16: E-Procurement (See full curriculum) Who is this course for? Individuals seeking to build a career in procurement or logistics. Professionals aiming to upskill in supply chain operations. Beginners with an interest in purchasing and supply management. Business owners or team leaders looking to optimise procurement processes. Career Path Supply Chain Analyst Procurement Officer Purchasing Manager Inventory Control Specialist Logistics Coordinator Category Manager Supplier Relationship Manager Operations Executive in manufacturing, retail, or distribution sectors
Course Overview The "Criminology & Profiling" course provides an in-depth exploration of criminology, criminal behaviour, and profiling techniques. Learners will gain a comprehensive understanding of crime classification, the psychology of offenders, and the methods used in criminal investigations. This course combines theory with practical insights, preparing individuals to analyse criminal patterns and contribute to crime prevention strategies. Learners will leave with the skills to evaluate crime scenes, profile offenders, and understand the workings of the criminal justice system. The course offers an essential foundation for anyone seeking to work in criminology or forensic psychology, equipping them with the expertise to support law enforcement agencies and legal professionals. Course Description This course delves into various facets of criminology, with modules covering the classification of crime, violent crimes, criminal psychology, and the forensic science used in profiling offenders. It explores offender profiling, the phases of profiling, and investigative strategies that draw from behavioural science. Learners will examine crime scenes, develop an understanding of victimology, and explore the roles within the criminal justice system. Through this structured curriculum, learners will develop skills to identify criminal behaviour, understand criminal motivation, and apply profiling techniques to real-world cases. The course is designed to equip learners with a strong theoretical foundation, complemented by an understanding of practical approaches in criminology and profiling. Course Modules Module 01: Introduction to Criminology and Profiling Module 02: Classification of Crime Module 03: Violent Crimes Module 04: The Crime Scene Module 05: Dealing with Crime Module 06: Understanding Criminal Psychology Module 07: Forensic Science Module 08: Phases of Profiling Module 09: Criminal Profiling: Science, Logic and Metacognition Module 10: Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice Module 11: Victimology Module 12: The Criminal Justice System in England and Wales (See full curriculum) Who is this course for? Individuals seeking to understand criminal behaviour and profiling techniques. Professionals aiming to advance their career in criminology or forensic psychology. Beginners with an interest in criminology, criminal justice, or psychology. Those interested in law enforcement and criminal investigation. Career Path Criminologist Criminal Profiler Forensic Psychologist Police Detective Criminal Justice Researcher Victim Support Specialist Legal Consultant Crime Analyst
Course Overview This comprehensive Data Analytics course provides an in-depth exploration of data analysis, covering the essential principles and techniques used to extract valuable insights from data. Learners will engage with core concepts, such as data mining, statistical analysis, and visualisation, enabling them to make informed decisions and drive business outcomes. By the end of the course, participants will have the skills to analyse and interpret data, apply analytical tools effectively, and present their findings clearly. This course equips learners with the necessary tools to understand and leverage data in various professional settings, adding significant value to their career prospects. Course Description The Data Analytics course covers a wide range of topics, including the fundamentals of data analysis, statistical methods, and various data visualisation techniques. Learners will explore essential tools such as Excel and specialised software, while gaining a deep understanding of how to collect, store, and process data effectively. Emphasis is placed on developing the analytical mindset required to interpret data accurately and draw actionable insights. This course is designed to ensure learners can confidently navigate the world of data analytics and apply their knowledge in diverse industries, enhancing their problem-solving and decision-making abilities. Course Modules Module 01: Introduction to the World of Data Module 02: Basics of Data Analytics Module 03: Statistics for Data Analytics Module 04: Actions Taken in the Data Analysis Process Module 05: Gathering the Right Information Module 06: Storing Data Module 07: Data Mining Module 08: Excel for Data Analytics Module 09: Tools for Data Analytics Module 10: Data-Analytic Thinking Module 11: Data Visualisation That Clearly Describes Insights Module 12: Data Visualisation Tools (See full curriculum) Who is this course for? Individuals seeking to enhance their analytical skills for data-driven decision-making. Professionals aiming to transition into data analytics or enhance their data-related roles. Beginners with an interest in understanding data and its applications across industries. Business professionals seeking to leverage data for strategic growth. Career Path Data Analyst Business Intelligence Analyst Data Scientist Market Research Analyst Operations Analyst Financial Analyst Business Analyst Data Visualisation Specialist
Course Overview The "Microsoft Excel Complete Course" is designed to equip learners with the essential skills to master Microsoft Excel, one of the most widely used tools in data analysis and business operations. This course covers a comprehensive range of topics, including Excel's new features, formula creation, data visualisation, and workbook management. It offers practical knowledge that will help learners work more efficiently, whether they are managing large datasets, analysing trends, or presenting information. By the end of this course, learners will be confident in using Excel for various business tasks, gaining a strong foundation for further professional development. Course Description This course covers all key aspects of Microsoft Excel, from the basics to advanced techniques. Learners will explore Excel’s new features in the 2019 version, as well as how to perform calculations, modify worksheets, and apply formatting. The course delves into functions, lists, and data analysis tools, including PivotTables and charts. Learners will also learn how to work with multiple worksheets and workbooks, use lookup functions, and automate workbook functionality. With a focus on essential Excel tools and techniques, learners will gain the ability to efficiently manage and analyse data for business or personal use. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Office 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: Working with Functions Module 09: Working with Lists Module 10: Analyzing Data Module 11: Visualizing Data with Charts Module 12: Using PivotTables and PivotCharts Module 13: Working with Multiple Worksheets and Workbooks Module 14: Using Lookup Functions and Formula Auditing Module 15: Sharing and Protecting Workbooks Module 16: Automating Workbook Functionality Module 17: Creating Sparklines and Mapping Data Module 18: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to improve their data management and analysis skills. Professionals aiming to enhance their productivity in Excel for business applications. Beginners with an interest in data analysis or office administration. Anyone looking to build a strong foundation in Excel for career advancement. Career Path Data Analyst Financial Analyst Office Administrator Project Manager Business Analyst Operations Manager Administrative Assistant HR Specialist
Course Overview: This comprehensive Property Law course provides an in-depth understanding of property rights, ownership, and key legal principles. Learners will explore essential concepts such as land law, co-ownership, leases, mortgages, and property rights. The course covers both theoretical and practical aspects of property law, enabling learners to gain a clear understanding of property transactions and disputes. By the end of the course, participants will be equipped with the knowledge to navigate property law in both residential and commercial settings, offering them a strong foundation for a career in property law, real estate, or related sectors. Course Description: This Property Law course covers a range of crucial topics, from the fundamental principles of land law to complex property rights and ownership issues. Learners will examine the different forms of land tenure, including registered and unregistered land, and gain insights into the legalities of co-ownership and leases. Key areas such as mortgages, licenses, and proprietary estoppel will also be explored. Throughout the course, learners will develop an understanding of the rights and responsibilities of property owners, landlords, and tenants, and how these impact property transactions. By the end of the course, learners will have gained valuable legal knowledge applicable to property law disputes, legal agreements, and property transactions in the UK. Course Modules: Module 1: Introduction to Property Law Module 2: Land Law Principles- Rights and Interests Module 3: Registered and Unregistered Land Module 4: Ownership and Possession of the Property Module 5: Co-Ownership in Property Module 6: Leases and Bailment Module 7: Property Law: License Module 8: The Mortgage Law Module 9: Insurance for Property Maintenance Module 10: Proprietary Estoppel (Property Rights) Module 11: Security Interests in Property (See full curriculum) Who is this course for? Individuals seeking to gain a solid understanding of property law Professionals aiming to advance their careers in the property or real estate sectors Beginners with an interest in legal aspects of property ownership Aspiring property investors or those looking to specialise in property law Career Path: Property Lawyer Real Estate Consultant Mortgage Advisor Property Manager Legal Advisor for Property Transactions Estate Agent Landlord/Property Investor
Course Overview: The "CAD Designer Training" course provides a comprehensive introduction to the world of Computer-Aided Design (CAD). Learners will explore the core principles, tools, and techniques used in CAD software to create both 2D and 3D designs. The course covers fundamental topics such as shape creation, geometry, modelling, and assemblies, along with software introductions to AutoCAD, T-Flex, SolidWorks, and FreeCAD. By the end of this course, participants will have a solid understanding of CAD design and the technical skills necessary to pursue a career in design, engineering, or architecture. Course Description: This in-depth course is designed to equip learners with the essential skills for becoming proficient in CAD design. It covers a variety of important areas, including the basics of CAD design, 2D and 3D shape creation, geometry and modelling, and assembly techniques. Learners will gain an introduction to industry-standard software such as AutoCAD, T-Flex, SolidWorks, and FreeCAD, allowing them to explore multiple platforms used in the CAD design field. With modules covering extrusion, rotations, grids, polygons, and civil drawings, this course ensures learners develop a comprehensive understanding of the tools and techniques used by CAD professionals. It is an excellent foundation for anyone wishing to pursue a career in the design and engineering sectors. Course Modules: Module 01: Introduction to CAD Design Module 02: CAD Designer Career in the United Kingdom Module 03: Basics for CAD Design – Part 1 Module 04: Basics for CAD Design – Part 2 Module 05: 2D Shape in CAD Module 06: 3D Shape in CAD Module 07: Geometry and Modelling Module 08: Assemblies in CAD Design Module 09: Extrusion and Rotations Module 10: Blending Operations in CAD Module 11: Grids and Regular Polygons Module 12: Parameters in Civil Drawings Module 13: Introduction to AutoCAD Module 14: Introduction to T-Flex CAD Module 15: Introduction to SolidWorks Module 16: Introduction to FreeCAD (See full curriculum) Who is this course for? Individuals seeking to build a career in design and engineering. Professionals aiming to develop their CAD design skills. Beginners with an interest in CAD software and design. Those pursuing opportunities in the construction, architecture, or manufacturing industries. Career Path: CAD Designer 3D Modeler Architectural Drafter Mechanical Designer Civil Drafter Product Designer Engineering Assistant Design Consultant
Course Overview "JavaScript for Everyone" offers a comprehensive introduction to one of the most essential programming languages used in web development. This course covers the fundamental concepts of JavaScript, allowing learners to build dynamic, interactive websites. Students will gain a solid understanding of core JavaScript principles such as variables, loops, functions, and objects, as well as more advanced topics like cookies, page redirection, and error handling. By the end of the course, learners will be equipped with the skills to implement JavaScript in real-world projects, enhancing the interactivity and functionality of websites. Course Description This course provides an in-depth exploration of JavaScript, focusing on both basic and advanced topics. It begins with an introduction to key programming concepts before diving into areas such as conditional statements, functions, and events. Learners will discover how to work with JavaScript objects, arrays, and built-in objects like Number, Boolean, and String. Additionally, the course covers important aspects like page redirection, pop-up boxes, and validation techniques. By the end, students will be proficient in JavaScript debugging, error handling, and using regular expressions, with a clear understanding of how to apply JavaScript in web development projects. Course Modules Module 01: Introduction Module 02: Basic Concepts on JavaScript Module 03: Conditional and Switch Statements Module 04: JS Functions Module 05: JS Events Module 06: JS Cookies Module 07: JS Page Redirection Module 08: JS Popup Boxes Module 09: JS Void Module 10: JS Print Module 11: JS Objects Module 12: JS Number Object Module 13: JS Boolean Object Module 14: JS String Object Module 15: JS Arrays Module 16: JS Dates Module 17: JS Math and Reg Exp Module 18: JS Browsers and Summary Module 19: JS Debugging Module 20: JS Errors Module 21: JS Validations (See full curriculum) Who is this course for? Individuals seeking to develop web development skills. Professionals aiming to enhance their programming knowledge. Beginners with an interest in web development or JavaScript. Anyone looking to gain a foundational understanding of programming languages. Career Path Web Developer Front-End Developer JavaScript Developer Software Engineer Full-Stack Developer Web Application Developer
Course Overview This Personal Assistant (PA) course is designed to provide learners with essential skills and knowledge to excel in a variety of administrative roles. Covering everything from business communication to organisational skills, this course ensures learners are equipped to manage office duties efficiently, support executives, and contribute to the smooth running of an organisation. By completing this course, learners will gain a solid understanding of the core functions of a PA, enabling them to confidently take on responsibilities in any professional setting. Course Description The course delves into key areas including business telephone etiquette, managing travel arrangements, organising meetings, and developing effective communication skills. Learners will explore the nuances of record-keeping, minute-taking, and scheduling, essential for ensuring a well-structured office environment. With a strong emphasis on time management, organisational skills, and business writing, this course prepares learners to confidently manage multiple tasks and responsibilities in fast-paced work environments. By the end, learners will have developed the ability to enhance productivity and support executive operations effectively. Course Modules Module 01: Introduction to Personal Assistant Module 02: Business Telephone Skills Module 03: Representing Your Boss and Company Module 04: Mail Services and Shipping Module 05: Travel Arrangements Module 06: Organising Meetings and Conferences Module 07: Time Management Module 08: Record Keeping and Filing Systems Module 09: Business Writing Skills Module 10: Organisational Skills Module 11: Communication Skills Module 12: Customer Service Module 13: Effective Planning and Scheduling Module 14: Invoicing/Petty Cash Module 15: Introduction to Minute Writing Module 16: Preparation for Minute Taking Module 17: The Meeting Structure Module 18: Minute Meeting, Decision and Action Module 19: Roles and Responsibility of Minute Taker Module 20: Tips for Minute Taking Module 21: Technology in Minute Taking Module 22: Building Confidence (See full curriculum) Who is this course for? Individuals seeking to enhance their administrative skills. Professionals aiming to advance their career as a Personal Assistant. Beginners with an interest in office management and administrative roles. Anyone interested in developing organisational and communication skills. Career Path Personal Assistant Executive Assistant Administrative Assistant Office Manager Office Administrator Executive Support Specialist
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.
Course Overview The Care Certificate (15 Standards) course offers a foundational introduction to essential standards for individuals working in health and social care roles across the UK. Covering all 15 standards required by the Care Quality Commission (CQC), this course is designed to ensure learners understand their responsibilities, safeguarding protocols, and person-centred care approaches. It supports individuals in developing the knowledge needed to meet industry expectations in line with the Skills for Care guidelines. Upon completion, learners will be able to demonstrate a firm grasp of care values, communication techniques, infection control, and equality and diversity awareness, helping them integrate confidently into care settings. The Care Certificate provides an excellent starting point for those new to care roles or seeking to align their current practices with professional benchmarks. Course Description This course comprehensively covers the 15 core standards of the Care Certificate, including duty of care, communication, privacy and dignity, safeguarding adults and children, and health and safety. It provides detailed theoretical understanding to help learners develop a values-based approach aligned with UK care sector expectations. The course is structured to improve understanding of policies, legal frameworks, and workplace responsibilities in social care environments. Learners will explore topics such as person-centred support, infection prevention, mental health awareness, and handling information in care settings. The course supports learners in enhancing their understanding of the principles and frameworks that underpin professional conduct in care roles, helping them demonstrate competency across a wide range of subject areas relevant to both domiciliary and residential care roles. Course Modules: Module 01: Understand Your Role Module 02: Your Personal Development Module 03: Duty of Care Module 04: Equality and Diversity Module 05: Work in a Person-Centred Way Module 06: Communication Module 07: Privacy and Dignity Module 08: Fluids and Nutrition Module 09: Awareness of Mental Health, Dementia and Learning Disabilities Module 10: Safeguarding Adults Module 11: Safeguarding Children Module 12: Basic Life Support Module 13: Health and Safety Module 14: Handling Information Module 15: Infection Prevention and Control (See full curriculum) Who is this course for? Individuals seeking to start a career in health and social care. Professionals aiming to meet mandatory training requirements for care roles. Beginners with an interest in understanding care standards and regulations. Volunteers or support workers looking to formalise their knowledge in care settings. Career Path Care Assistant Support Worker Domiciliary Carer Healthcare Assistant Residential Care Worker Adult Social Care Professional