44111 Courses

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users. Overview Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables. Before starting this course, make sure you meet at least one of the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Basic working knowledge of Relational Databases. In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL. Course Outline 1.Introduction to Microsoft SQL Server 2.Introduction to T-SQL Querying 3.Writing SELECT Queries 4.Querying Multiple Tables 5.Sorting and Filtering Data 6.Working with SQL Server Data Types 7.Using DML to Modify Data 8.Using Built-In Functions 9.Grouping and Aggregating Data 10.Using Subqueries 11.Using Table Expressions 12.Using Set Operators 13.Using Windows Ranking, Offset, and Aggregate Functions 14.Pivoting and Grouping Sets 15.Executing Stored Procedures 16.Programming with T-SQL

Duration 3 Days 18 CPD hours This course is intended for Risk managersBusiness Process OwnersBusiness Finance ManagersBusiness Risk ManagersRegulatory Compliance ManagersProject ManagementPersons responsible for information security or conformity within an organization Overview To understand the concepts, approaches, methods and techniques allowing an effective risk managementaccording to ISO 31000To understand the relationship between the risk management and the compliance with the requirements ofdifferent stakeholders of an organizationTo acquire the competence to implement, maintain and manage an ongoing risk management program accordingto ISO 31000To acquire the competence to effectively advise organizations on the best practices in risk management In this three-day intensive course participants develop the competence to master a model for implementing risk management processes throughout their organization using the ISO 31000:2009 standard as a reference framework. Day 1 Introduction to the Risk Management framework according to ISO 31000 Concepts and definitions related to Risk Management Risk Management standards, frameworks and methodologies Implementation of a Risk Management framework Understanding an organization and its context Day 2 Risk identification and assessment, risk evaluation, treatment, acceptance, communication and surveillance according to ISO 31000 Risk identification Risk analysis and risk evaluation Risk treatment Risk acceptance and residual risk management Risk communication and consultation Risk monitoring and review Day 3 Risk assessment methodologies according to ISO 31000 and Certification Exam Presentation of risk assessment methodologies Certification Exam

Corporate Finance with Credit Control Diploma Step into the nuanced world of Corporate Finance and Credit Control with this meticulously designed course. In an era where robust financial management is indispensable, understanding Credit Control within Corporate Finance is critical. The course aims to equip you with the analytical tools and financial acumen necessary for effective decision-making and risk mitigation. Learning Outcomes: Gain a comprehensive understanding of the purpose and functionality of Credit Control. Learn to interpret and utilize Cash Flow Statements in Credit Control contexts. Master the art of Financial Reporting specifically for Credit Control. Acquire skills in Credit Analysis for robust financial planning. Dive into the Corporate Finance Masterclass to understand the larger financial ecosystem. Familiarize yourself with the factors contributing to Financial Collapse. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Corporate Finance with Credit Control Diploma: Purpose of Credit Control: Lay the foundation by understanding why Credit Control is pivotal in Corporate Finance. Cash Flow Statements in Credit Control: Learn to read and analyse Cash Flow Statements, enabling you to make informed decisions in Credit Control. Financial Reporting and Credit Control: Integrate the fundamentals of financial reporting into your Credit Control skillset, thereby enhancing your market readiness. Credit Analysis: Get hands-on training in Credit Analysis, which allows you to evaluate creditworthiness and risks effectively. Corporate Finance Masterclass: Broaden your understanding of Corporate Finance, aligning it with the specialised skills you've acquired in Credit Control. Financial Collapse: Study the anatomy of financial meltdowns to identify red flags and preemptively exercise Credit Control measures.

Overview of Payroll Management Course In today's fast-paced business world, efficient payroll management is the lifeblood of any organisation. The UK's payroll industry is a thriving sector, with an estimated market value of £1.46 billion in 2021. As businesses evolve and regulations change, the demand for skilled payroll professionals continues to soar. Our comprehensive Payroll Management Course is designed to equip you with the essential knowledge and skills needed to excel in this dynamic field. From understanding the intricacies of UK payroll systems to mastering year-end procedures, this course covers every aspect of payroll administration. You'll delve into crucial topics such as legislation settings, pension schemes, and e-submissions, ensuring you're well-prepared for the challenges of modern payroll management. Whether you're an aspiring payroll professional or a seasoned finance expert looking to upskill, this course offers a clear path to success. With the UK payroll software market projected to grow at a CAGR of 9.2% from 2021 to 2028, now is the perfect time to invest in your payroll management education. Join us and unlock a world of opportunities in this essential and rewarding field. This Payroll Management Course will help you to learn: Understand the structure and basics of the UK's payroll system. Familiarise with legislation and company-specific payroll settings. Comprehend pension schemes and various pay elements. Master the processes for adding and updating employee records. Manage monthly payroll runs, including anomalies and leavers. Navigate year-end procedures, reports, and historical payroll data. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Payroll Management Course. Enrol today and complete the course to achieve a certificate that can change your career forever. 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 Certificate of Completion - Digital/PDF Certificate After completing the Payroll Management Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  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 Who Is This Course for? Finance professionals seeking to expand their knowledge in payroll management. HR personnel transitioning into payroll-related roles. Small business owners managing their own payroll systems. Accounting students aiming to specialise in payroll administration. Individuals looking to start a career in payroll management. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Payroll Management Course 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 Payroll Administrator: £20K to £26K/year. Payroll Manager: £30K to £45K/year. HR Officer with Payroll Duties: £16K to £25K/year. Payroll Consultant: £25K to £40K/year. Payroll Systems Analyst: £28K to £35K/year. Course Curriculum Module 01: Payroll System in the UK Payroll System in the UK 01:05:00 Module 02: Payroll Basics Payroll Basics 00:10:00 Module 03: Company Settings Company Settings 00:08:00 Module 04: Legislation Settings Legislation Settings 00:07:00 Module 05: Pension Scheme Basics Pension Scheme Basics 00:06:00 Module 06: Pay Elements Pay Elements 00:14:00 Module 07: The Processing Date The Processing Date 00:07:00 Module 08: Adding Existing Employees Adding Existing Employees 00:08:00 Module 09: Adding New Employees Adding New Employees 00:12:00 Module 10: Payroll Processing Basics Payroll Processing Basics 00:11:00 Module 11: Entering Payments Entering Payments 00:12:00 Module 12: Pre-Update Reports Pre-Update Reports 00:09:00 Module 13: Updating Records Updating Records 00:09:00 Module 14: e-Submissions Basics e-Submissions Basics 00:09:00 Module 15: Process Payroll (November) Process Payroll (November) 00:16:00 Module 16: Employee Records and Reports Employee Records and Reports 00:13:00 Module 17: Editing Employee Records Editing Employee Records 00:07:00 Module 18: Process Payroll (December) Process Payroll (December) 00:12:00 Module 19: Resetting Payments Resetting Payments 00:05:00 Module 20: Quick SSP Quick SSP 00:09:00 Module 21: An Employee Leaves An Employee Leaves 00:13:00 Module 22: Final Payroll Run Final Payroll Run 00:07:00 Module 23: Reports and Historical Data Reports and Historical Data 00:08:00 Module 24: Year-End Procedures Year-End Procedures 00:09:00

This Excel Introduction course is a very good introduction to essential fundamental programming concepts using Excel as programming language. These concepts are daily used by professionals and are essential in most jobs. By the end, you'll be comfortable with Excel concepts, ribbons, formulas, and the Functions Wizard. You will gain hands-on practical experience creating a spreadsheet from scratch on your own.

Boost your career with Sales Psychology! Unlock proven strategies like silence, objection handling, and sincerity to skyrocket your closing rates. Enrol now!

Explore the ancient art of Acupuncture Therapy in our comprehensive course. Learn about acupressure points, treatment for pain and mental health, professional standards, and much more. Ideal for aspiring practitioners and those seeking holistic health insights.

Learn to make your favorite American dishes with our comprehensive American Cooking course! From Southern fried chicken to Tex-Mex tacos to New England clam chowder, we'll teach you everything you need to know to cook like a pro.

From basic concepts such as perspective and shading to more advanced subjects like still-life compositions and portraiture, this Art, Drawing and Painting Diploma course covers a wide range of topics essential for aspiring artists. Through step-by-step demonstrations and hands-on exercises, learners will develop their drawing skills and gain confidence in their artistic abilities.

Explore the complexities of mental health with our Mental Health Awareness course. Learn about various disorders, treatments, and social attitudes, ideal for healthcare professionals, educators, and HR managers. Enhance your understanding and support those in need.