29582 Courses

Overview This course covers distressed debt analysis and investing, focusing primarily on corporates but also including financial institutions and sovereign debt as special topics. The programme begins with the foundations of the distressed debt market, causes of and early warning signals, possible outcomes and how to evaluate the probability of outcomes in different scenarios. Restructuring is reviewed in detail, as well as estimation of sustainable debt levels, business valuation and the importance of capital and group structure. Differences between active control and passive non-control investments are highlighted, including stakeholder tactics and due diligence. Case studies cover a variety of companies across sectors and geographies, challenging delegates to make investment decisions on real distressed debt situations. Who the course is for Distressed debt investors, Loan portfolio managers and Private equity investors Hedge fund managers High yield credit analysts and Equity analysts High yield asset managers and Mergers and acquisitions bankers Debt capital markets/leveraged finance bankers Business turnaround/restructuring accountants/corporate finance professionals Lawyers Strategy consultants 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

Overview This is a 2 day course on understanding credit markets converting credit derivatives, from plain vanilla credit default swaps through to structured credit derivatives involving correlation products such as nth to default baskets, index tranches, synthetic collateralized debt obligations and more. Gain insights into the corporate credit market dynamics, including the role of ratings agencies and the ratings process. Delve into the credit triangle, relating credit spreads to default probability (PD), exposure (EAD), and expected recovery (LGD). Learn about CDS indices (iTRAXX and CDX), their mechanics, sub-indices, tranching, correlation, and the motivation for tranched products. The course also includes counterparty risk in derivatives market where you learn how to managed and price Counterparty Credit Risk using real-world, practical examples Understand key definitions of exposure, including Mark-to-Market (MTM), Expected Exposure (EE), Expected Positive Exposure (EPE), Potential Future Exposure (PFE), Exposure at Default (EAD), and Expected Loss (EL) Explore the role of collateral and netting in managing counterparty risk, including the key features and mechanics of the Credit Support Annex (CSA) Briefly touch upon other XVA adjustments, including Margin Valuation Adjustment (MVA), Capital Valuation Adjustment (KVA), and Collateral Valuation Adjustment (CollVA). Who the course is for Credit traders and salespeople Structurers Asset managers ALM and treasury (Banks and Insurance Companies) Loan portfolio managers Product control, finance and internal audit Risk managers Risk controllers xVA desk IT Regulatory capital and reporting 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

Overview This 2-day programme covers the latest techniques used for fixed income attribution. This hands-on course enables participants to get a practical working experience of fixed income attribution, from planning to implementation and analysis. After completing the course you will have developed the skills to: Understand how attribution works and the value it adds to the investment process Interpret attribution reports from commercial systems Assess the strengths and weaknesses of commercially available attribution software Make informed decisions about the build vs. buy decision Present results in terms accessible to all parts of the business Who the course is for Performance analysts Fund and portfolio managers Investment officers Fixed Income professionals (marketing/sales) Auditors and compliance Quants and IT developers 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

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

leadership management training course belbin team roles

Unlock opportunities in the food industry with our HACCP Legislations & Principles course. Learn essential food safety skills and compliance rules for aspiring chefs and restaurant owners.

Anti-Social Behaviour (ASB) Awareness Course provides a thorough understanding of ASB types, family influences, and prevention strategies. Suitable for HR professionals, managers, social workers, and concerned individuals, it offers CPD certification and accessible learning materials.

The Process Mapping Online Training Course will teach you how to identify significant savings in the way in which the process is organised and performed through process flow mapping.

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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.