586 Courses delivered Live Online

Course Overview The "UK Employment Law Level 5" course offers a comprehensive introduction to the key aspects of employment law within the UK. This course is designed for those seeking to understand the legal framework that governs workplace relations, from recruitment through to dismissal. Covering crucial topics such as employment contracts, discrimination, and health and safety, this course provides valuable knowledge applicable across various industries. By the end of the course, learners will be equipped with the legal understanding required to navigate and implement employment laws effectively, ensuring compliance and fostering fair workplace practices. Course Description This course delves into the fundamental areas of UK employment law, offering learners a thorough grounding in legislation that affects both employers and employees. Learners will explore areas including recruitment procedures, employment contracts, employee handbooks, and the disciplinary process, along with in-depth coverage of national minimum wage laws and workplace discrimination. The course also includes key topics such as parental rights, sick pay, pension schemes, and the health and safety obligations of employers. Learners will gain a comprehensive understanding of employment law, empowering them to contribute to a fair, legal, and well-managed workplace. Course Modules Module 01: Basics of Employment Law Module 02: Legal Recruitment Process Module 03: Employment Contracts Module 04: Employee Handbook Module 05: Disciplinary Procedure Module 06: National Minimum Wage & National Living Wage Module 07: Parental Rights, Sick Pay & Pension Scheme Module 08: Discrimination in the Workplace Module 09: Health & Safety at Work Module 10: Dismissal, Grievances and Employment Tribunals Module 11: Workplace Monitoring & Data Protection (See full curriculum) Who is this course for? Individuals seeking to understand UK employment law. Professionals aiming to advance their careers in HR or management. Beginners with an interest in workplace legislation and employee relations. HR managers and team leaders looking to update their legal knowledge. Career Path HR Manager Employment Lawyer Compliance Officer Payroll Specialist Workplace Policy Advisor Employee Relations Consultant

Course Overview The LEED V4 - Building Design and Construction course offers an in-depth exploration of sustainable building practices in line with the LEED (Leadership in Energy and Environmental Design) standards. Learners will gain a comprehensive understanding of the LEED V4 framework and its application to building design and construction. The course highlights key principles, including energy efficiency, environmental responsibility, and resource management, equipping participants with the knowledge to meet LEED certification requirements. Upon completion, learners will be prepared to integrate sustainable practices into their work, contributing to green building initiatives and reducing environmental impact in the construction industry. Course Description This course delves into the core components of the LEED V4 standards, covering a broad spectrum of topics such as integrative processes, sustainable site development, water efficiency, energy optimisation, and indoor environmental quality. Learners will explore how these elements impact building design and construction, learning how to create energy-efficient, eco-friendly structures. The course provides a thorough examination of each LEED category, equipping participants with the skills needed to navigate the certification process and apply sustainable design principles to real-world projects. By the end, learners will have the knowledge to assess projects for LEED compliance and incorporate green strategies into building practices, driving sustainability forward. Course Modules Module 01: Introduction Module 02: Integrative Process Module 03: Location & Transportation Module 04: Sustainable Sites Module 05: Water Efficiency Module 06: Energy & Atmosphere Module 07: Materials & Resources Module 08: Indoor Environment Quality Module 09: Innovation Module 10: Regional Priority Module 11: Completion (See full curriculum) Who is this course for? Individuals seeking to enhance their knowledge of sustainable building practices Professionals aiming to pursue LEED accreditation or certification Beginners with an interest in green building and environmental design Architects, engineers, and construction managers looking to stay current with industry standards Sustainability advocates looking to make a difference in the built environment Career Path Green Building Consultant LEED Accredited Professional Sustainability Coordinator Environmental Consultant Energy Manager Construction Project Manager Sustainability Analyst

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.

Duration 5 Days 30 CPD hours This course is intended for This class is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL, and want to increase proficiency and learn best practices. Targeted at: DBAs and Architects, and appropriate for Analysts, Support Engineers, and other IT professionals Overview Please refer to overview This is an immersive 5-day class that offers hands-on labs and combines the core topics from Foundations of Postgres Administration and Advanced PostgreSQL Administration into a one-week class, with significant savings over list price. Upon course completion, you will be prepared to manage mission critical PostgreSQL installations, and perform core administration tasks with confidence and skill. Course Outline 1 - POSTGRES SYSTEM ARCHITECTURE 2 - INSTALLATION AND GETTING STARTED 3 - CONFIGURATION, CREATING, MANAGING DATABASES 4 - USER TOOLS ? USING PSQL 5 - GUI TOOLS - USING PGADMIN 4 6 - SECURITY BASICS 7 - SQL PRIME BACKUP AND RECOVERY 8 - ROUTINE MAINTENANCE 9 - POSTGRES DATA DICTIONARY 10 - MOVING DATA 11 - SQL TUNING 12 - PERFORMANCE TUNING 13 - STREAMING REPLICATION 14 - TABLE PARTITIONING 15 - EXTENSION MODULES 16 - MONITORING 17 - UPGRADING BEST PRACTICES

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 The "Handyperson/Handyman (From Basic Tools to Plumbing, Painting and Decorating)" course is designed to provide learners with a comprehensive understanding of a wide range of essential skills. This course covers everything from basic tool usage to more advanced tasks such as plumbing, painting, decorating, and general maintenance. Learners will gain the confidence to undertake various home improvement projects, enhance their professional toolkit, and apply their new skills in everyday situations. By the end of the course, learners will have developed a strong foundation in essential handyperson tasks and be well-equipped to handle minor repairs and maintenance work across different environments. Course Description In this course, learners will explore an extensive range of handyperson skills, beginning with the fundamentals of basic tools and equipment. They will progress to more complex topics such as electrical work, plumbing, and general carpentry. The course covers crucial areas such as appliance repair, wall and floor maintenance, as well as painting and decorating techniques. Learners will gain valuable knowledge of health and safety practices, ensuring they work efficiently and safely. This course is designed to provide learners with a solid skill set that can be applied across a wide range of tasks, from minor repairs to larger construction projects. Throughout the course, learners will be guided on how to establish their own handyperson business, providing them with essential entrepreneurial knowledge to further their career. Course Modules Module 01: Introduction to Handyperson Module 02: Basic Tools and Equipment Module 03: Electrical Work Module 04: Plumbing Skills Module 05: Appliances Module 06: General Carpentry Module 07: Basic Maintenance Skills Module 08: Walls and Floors Module 09: Painting and Decorating Module 10: Drilling, Tiling and Welding Module 11: Construction Projects Module 12: Health and Safety at Work Module 13: Starting Own Business for Handyperson (See full curriculum) Who is this course for? Individuals seeking to develop diverse handyperson skills Professionals aiming to expand their knowledge in home improvement and maintenance Beginners with an interest in the construction or maintenance industry Anyone looking to start their own handyperson business or freelance career Career Path Handyperson Maintenance Technician Property Manager Independent Handyman/Handyperson DIY Consultant Home Improvement Specialist Construction Worker Small Business Owner (Handyperson Services)

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

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 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