1610 Courses in London

Explore the key concepts of Environmental, Social, and Governance (ESG) with our expert-led course designed for professionals. Learn how to seamlessly incorporate sustainable practices into your business strategy and enhance your corporate responsibility. Gain the tools and insights necessary to effectively implement ESG initiatives within your organisation. Join now and lead the change towards a more sustainable future!

Database Design and Data Normalization Course Summary Relational Databases & Data Normalisation Overview Training Courses London. Learn how to decide which tables and columns are required for a database, plan relationships, how to decide on data types and how to relate tables. Database Design and Data Normalization Course Description Session 1: Introduction to Relational Databases The Database Approach Database Management Systems The function of a Database Management System The Processing Architecture The Schema Architecture The Storage Architecture An overview of Database System Development An overview of general database principles Session 2: Conceptual Data Models Overview of Entity Models Entities and how to identify them Attributes and how to identify them Relationships and their qualities Building an Entity Relationship Diagram Resolving many-to-many relationships Sub-type and Super-type Relationships Arc Relationships Recursive Relationships Constraints and Assumptions Normalization to the First Normal Form (1NF) Normalization to the Second Normal Form (2NF) Normalization to the Third Normal Form (3NF) Exercises: Analyzing a specification Creating an Entity Relationship Diagram from it Session 3: The Relational Model Relational Structure Relational Terminology Domains A Relational schema Candidate keys and Primary Keys Foreign Keys Key Constraints Attribute Constraints Implementing Sub-type/Super-type Relationships Views Denormalization using Pre-joined Tables Denormalization using Derived Data An Introduction to Structured Query Language (SQL) Simple Queries Simple Updates of the Data Included in the Database Design and Data Normalization Courses: Database Design and Data Normalization Course Certificate on completion Database Design and Data Normalization Course Manual Practical Database Design and Data Normalization Course exercises, Database Course Homework / Database Course Revision work After the course, 1 free session for questions online Database Course via Gotomeeting.com. Max group size, online and in classroom, on this Database Course is 4.

This course aims to give the learner an understanding of the term "Drag Lift" and the implications of the technique, for the client and the carer. and Health & Social Care organisations

Overview Interest Rate Options are an essential part of the derivatives marketplace. This 3-Day programme will equip you to use, price, manage and evaluate interest rate options and related instruments. The course starts with a detailed review of option theory, from a practitioner’s viewpoint. Then we cover the key products in the rates world (caps/floors, swaptions, Bermudans) and their applications, plus the related products (such as CMS) that contain significant ’hidden’ optionality. We finish with a detailed look at the volatility surface in rates, and how we model vol dynamics (including a detailed examination of SABR). The programme includes extensive practical exercises using Excel spreadsheets for valuation and risk-management, which participants can take away for immediate implementation Who the course is for This course is designed for anyone who wishes to be able to price, use, market, manage or evaluate interest rate derivatives. Interest-rate sales / traders / structurers / quants IT Bank Treasury ALM Central Bank and Government Treasury Funding managers Insurance Investment managers Fixed Income portfolio managers Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Explore the key features of Falls Awareness including common causes of falls in care & work environment including risk assessing for slips, trips and falls and being aware issues arising from medications and illnesses that can increase risk of falls.

This one-day programme explores the role of intellectual property (IP) in relation to innovation and creativity. It examines the different forms as well as the key processes, together with some of the oddities and idiosyncrasies of the legal regime that protects IP. It delves into the various IP models you should be aware of as well as key IP facts and figures and current IP trends across the global economy. This session is designed to give you a deeper understanding of: The main forms of intellectual property The importance of IP - both to your organisation and to the wider economy The key processes in the creation, commercial exploitation, and legal protection of IP The different models for the use of IP Some more advanced concepts for reviewing, valuing and managing IP 1 Main forms of intellectual property (IP) Patents Trademarks Copyright Design Trade secrets 2 Global IP business context Global IP facts and figures Figures for key jurisdictions Analysis of a company using IP data IP trends Overview of the key entities in the IP sector 3 Key IP processes IP creation IP portfolio management IP enforcement IP exploitation IP risk management 4 IP models IP models explained IP licensing IP litigation 5 IP concepts The IP maturity ladder Relative IP value and risk Axis of control 6 IP as an asset class Costs Valuation Financial perspective

Join us for a day of discussions and insights on EDI and the Six Stages Framework at our in-person event on June 28, 2024!     THE EDI ROUNDTABLE & SIX STAGES FRAMEWORK CONFERENCE 2024 Navigating & Challenging Everyday Racism and Discriminations. Embedding EDI into your Workplace & Schools Frameworks for Measuring Impact & Progress   Don't miss out on our Annual trailblazing event! Our pioneering event is back by popular demand. Empower your own self development and improve diversity and inclusion in your organisation or workplace. Check out testimonials from last year.   Tickets are now on sale. Only £30 including lunch!   Book now     https://www.eventbrite.co.uk/e/edi-round-table-event-and-the-six-stages-framework-conference-2024-tickets-884939155837?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurl   Join Us In Creating a More Inclusive World.   Are you ready to dive deep into the complexities of equality, diversity, and inclusion? Have you ever wondered how different sectors can collaborate to enhance racial justice and belonging in our ever-evolving society?   Online agenda and details of speakers and panelists https://www.sixstagesframework.com/edi-agenda/   Check out our Speaker/Panelists and Hosts. https://www.sixstagesframework.com/edi-round-table-2024/   https://youtu.be/DDfQtNJsNKE https://www.eventbrite.co.uk/e/edi-round-table-event-and-the-six-stages-framework-conference-2024-tickets-884939155837?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurl    Information for Schools https://www.sixstagesframework.com/schools/   What's Involved? This one-day event is not to be missed. We understand the challenges many face in embedding EDI (Equality, Diversity, and Inclusion) into the fabrics of their organisation.    The Six Stages Inclusive Framework helps organisation (and schools) go beyond performative measures: cultural celebrations, conversations about unconscious bias and white privilege to real action and implementation.    It supports evidence-based practice and data gathering, obtaining base line measures through the Six Stages Framework Diversity Assessments which enable you to chart your progress.   Who’s the Conference For? Corporate Organisations Schools & Local Authorities Health Services Higher Education Police and Criminal Justice Anyone passionate about EDI   An amazing venue!   The Conference will take place at St Martin-in-the Fields, Trafalgar Square, WC2N 4JJ on June 28th, 2024, set in the heart of London. Take a 3D tour of our venue here: https://my.matterport.com/show/?m=74N3JkZtuq4   Engage with Visionaries   Check out our Speaker/Panelists and Hosts. https://www.sixstagesframework.com/edi-round-table-2024/   Start your day with groundbreaking insights from leading experts. Our opening address and keynotes will set the stage for a series of powerful discussions, including:   Diverse Cross-Functional Roundtable: Engage with top professionals in a dynamic panel discussion, followed by an audience Q&A. Exclusive stimulating and thought-provoking conversation between the dynamic sister duo, Afua Hirsch: Award-winning writer, journalist, former barrister and filmmaker; and  Dr. Ama Collison: Millennial Psychology Limited. Networking Lunch: Connect with like-minded individuals and grow your professional network over lunch.  Afternoon Sessions: Dr. Shungu H. M'gadzah: will present a compelling keynote on "The Six Stages Framework: Understanding and Dealing with Everyday Racism.”  Exploring practical applications in various sectors and drawing from the SSF transformational toolkit.   Workshops: To consolidate and explore the days learning and make recommendations to be published in our annual report.   Who's Speaking? Dr. Shungu H. M'gadzah: Six Stages Framework & Inclusion Psychologists Ltd Dr. Ama Collison: Millennial Psychology Afua Hirsch: Award-winning writer, journalist, former barrister and filmmaker   Visit the wide range of market stalls and bookstore on display.  Explore the books from This is Book Love an award-winning collective and bookstore curating and showcasing and bringing together the best multicultural content the world of arts has to offer Schools, Nurseries, Public and corporate spaces www.thisisbooklove.com   Get Your Tickets Tickets are now on sale. Join us for our Annual trailblazing event! Only £30 including lunch!     Book now       https://www.eventbrite.co.uk/e/edi-frameworks-for-inclusive-organisations-measuring-impact-tickets-909290140287?aff=oddtdtcreator     https://www.eventbrite.co.uk/e/edi-round-table-event-and-the-six-stages-framework-conference-2024-tickets-884939155837?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurl   Link for more Information & Testimonials about last year’s event: https://www.inclusionpsychologists.com/post/exploring-equality-diversity-and-inclusion-through-different-professional-lenses-the-six-stages-fr-2   For sponsorship opportunities or Market stalls contact Dr. Shungu at: drshungu@inclusionpsychologists.comor Dr Ama Dr. Ama Collison    Market stalls: We also have space for market stalls at a cost of £100 so if you know organisations who may be interested. Sponsorship: In terms of sponsorship, we are looking for any contribution to costs. We currently have one sponsor- Inclusivitti. https://www.inclusivitii.com/ Support with the event and donations Any help in publicising the event would be appreciated as well as any donations or sponsors. Organisers: https://www.inclusionpsychologists.com/ Dr Shungu H. M'gadzah, Six Stages Framework https://www.millennialpsychology.co.uk/ Dr Ama Collison: Millennial Psychology https://www.diversifyworld.com/ Mr Romain Muhammad: Diversify World Sponsors: Inclusivitti https://www.inclusivitii.com/ Venue: St Martin- in- the- Fields Here is the link to our online 3D tour. Take a 3D tour of our venue here: https://my.matterport.com/show/?m=74N3JkZtuq4 Best wishes,   Shungu   Dr Shungu Hilda M'gadzah Director & Lead Consultant Psychologist Inclusion Psychologists Ltd Tel: 07956 965 266   AUTHOR: Understanding & Dealing with Everyday Racism- The Six Stages Framework The Six Stages Framework Book   https://www.sixstagesframework.com   www.inclusionpsychologists.com  https://www.inclusionpsychologists.com/book-online   Psychology today directory https://www.psychologytoday.com/profile/774567   Follow me on twitter. https://twitter.com/DrShunguM   LinkedIn profile https://www.linkedin.com/in/shunguhildamgadzah/

Did you know that: Lambeth, Southwark and Lewisham have some of the highest HIV and STI prevalence rates in the UK 66% of people would prefer to use their GP for sexual health services1 but GPs and practice nurses report numerous barriers to offering HIV and STI tests Missed opportunities to diagnose HIV and other STIs have major health implications, including significantly increased mortality rates for HIV2 Why is SHIP training relevant to YOU? Do you want to learn quick simple strategies to assess your patients’ sexual health risk? Find out why the use of speculae is plummeting! Are you all too aware of the reasons NOT to offer an HIV test? Do you worry about how to bring up the topic out of the blue? We will help you become confident in sexual health risk assessment and make meaningful changes to your clinical practice! Session 1a: STI update for Practice Nurses & Nursing Associates Describe the clinical significance of STIs in general practice Outline strategies for STI testing in primary care, including which swabs to use and when Outline management of STIs in the GP setting, including partner notification guidance Describe patterns of STI risk, and prevention methods Session 1b: Talking with patients about sex Formulate and use strategies to bring up sexual health in GP consultations, including when people are not expecting it Demonstrate how to take a rapid sexual health risk assessment tailored for the primary care consultation Formulate clinical management plans drawing on rapid sexual health risk assessment Session 2: Blood borne virus update List the advantages of diagnosing HOV and viral hepatitis in general practice, and the dangers of late diagnoses Recognise the parallels between HIV and viral hepatitis Recognise HIV indicator conditions Overcome barriers to, and normalise, HIV and viral hepatitis testing in your clinical practice Each session provides you with up-to-date resources to take back to your practice to support your consultations.

The importance of building services to the success of an organisation has never been greater and continues to grow. Developers and occupiers are becoming more aware of the contribution that building services make to the well being of occupants and hence their perception of the quality of the working environment. Those involved with the design, construction, maintenance and operation will increasingly be required to deliver building services that demonstrable contribution to the occupier's business. Energy efficiency, carbon management and occupant satisfaction depend substantially on the way building services are designed, managed and operated. To optimise these aspects, an informed strategic approach is essential. Tried and tested techniques and processes are available that, when applied holistically, will deliver substantial benefits. This course reviews best practice in the area and inspires participants to ensure that building services perform at their optimal level. To provide a better understanding of how building services can be designed, managed and operated to: Maximise occupant comfort, satisfaction and wellbeing Add value and contribute to the success of the business of the occupier Improve health safety Reduce operating cost, energy use, carbon emissions and environmental impact Optimise cost and value Provide strategies for continuous improvement and sustainable operation 1 Building services fundamentals The function of services in commercial buildings and their importance to the core business 2 Techniques and processes for optimising cost and value Programmed operation evaluation Continuous commissioning Lifetime product management Performance-based service Energy efficiency and the scope for environmental improvement 3 Making the business case and preparing the strategy Motivating decision-makers Empowering those who have to deliver the results Managing business risk 4 Strategy implementation and monitoring results Ensuring that rich and robust feedback is available to support continuous improvement and strategy enhancementWhen to get feedbackWhyHowWhat to do with it 5 Case histories and 'air time' Sharing experience and addressing specific issues of interest to participants Course review Close

What do engineers and project managers need to know of finance? 'Nothing - leave it to the accountants!' No, no, no! Engineers must be conversant with the terminology and statements that accountants use. Technical expertise in projects, service delivery, production or other areas can only really be harnessed if the managers understand the accounting and reporting that drives businesses. This course gives the necessary understanding to project, production and technical managers. It develops their skills in understanding financial and management accounting. Accountants may not always like it but a major part of their work is to be the 'servants of business' and to gather, compile and present your figures. So you must understand the figures - they belong to you, your processes or projects. There are many reasons for maintaining accurate accounts. This course focuses on the strategic issues (those over-used words) - what figures reveal about the drivers of business and what they reveal about the day-to-day issues that accountants bother you with. The course will enhance your understanding of finance and of the accounting issues which affect your projects, production and technical areas of business. This course will help you: Understand the business world in figures - make sense of what the accountants are telling you Appreciate what drives business - and how this affects your role in your part of the business Relate your activities to the success of the business - through figures Gain the skills to advance in management - financial awareness is a 'must have' if you are to progress in your career 1 What do accountants do? The finance function, types of accountant, financial v management accounting and the treasury function Understanding the role of the finance function and how the information you provide may be used 2 The basic financial statements Balance sheets and income statements (P&L accounts) What they are, what they contain and above all what they can reveal - how to read them The accounting process - from transactions to financial statements What underpins the statements - accounting systems and internal controls 3 Why be in business - from a financial perspective The driving forces behind financial information Performance measures - profitability, asset utilisation, sales and throughput, managing capital expenditure 4 Accounting rules - accounting standards Accounting concepts and the accounting rules: accruals, 'going concern' - substance over form and other 'desirable qualities' Accruals - why the timing of a transaction is so important to the finance function Depreciation and amortisation - the concepts and practice Accounting standards - the role of International Financial Reporting Standards 5 Cash The importance of cash flow - working capital management Cash flow statements - monitoring overall cash flows Raising cash - levels of borrowing, gearing Spending cash - an outline of capital expenditure appraisal 6 Budgeting Why budget? - good and bad practice Determining why budgets play a key role and should not be simply an annual ritual Justifying your budgets - the link between the strategic plan and day-to-day budgeting - alignment of company culture Budgets as motivators - the importance of the right culture Techniques to improve budgeting - whether day-to-day or capital budgeting 7 Costing The type and detail of costing very much depends on your business - eg, manufacturing piston rings is quite different from the construction of a power plant Issues with overhead allocation Accounting for R&D 8 Reading financial statements Annual financial statements - why they are produced, what's in them and what you should look for Learning what a set of accounts reveals about a company's current situation, profitability and future prospects 9 Performance measurement - analytical reviews and ratio analysis ROI/ROCE Profitability, margins and cost control Sales - asset turnover Efficiency (asset / stock turnover, debtor / creditor days) 'City' measures Investment (interest / dividend cover, earnings per share, dividend yield)