36749 PE courses delivered Online

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.

Learn Tai Chi at your own pace with expert guidance. Sessions conducted via Zoom and In-Person, subject to mutual agreement.

About this Training Course Within the energy industry, it is a requirement, both contractual and in some areas legislative, to ensure effective internal systems are in place which support employee development and provide evidence of their competence. A Competence Management and Assurance process - if correctly developed and applied - provides employees and organisations with the tools to demonstrate competence and contributes to career development of the individual. The 3 full-day course focuses on Competence Management Systems (CMS) which are typically in use within the Energy Industry, their structure and process development requirements. In addition, the course details the assessment process, the role of the competency assessors within the organisation and the relationship between competence management and training provision. For impactful learning, the course instructor uses a variety of instructional methodologies such as lectures, discussions, individual reflection, games, mystery puzzles, video, case studies, team syndication, group presentations, sharing and feedback. Training Objectives This course will provide attendees with an understanding of: The role of competencies in the Energy industry The benefits of Competency Management System to the organisation The components of a Competency of Competency Management System The know how to implement the Competency Management System The roles and responsibilities within a Competency Management System The know how to develop Competency Models The relationship between Competency Management and Capability Development The know how to conduct Organisational Analysis The know how to conduct Job Analysis and Task Analysis The know how to develop Competency Standards and Development Guides using the 70:20:10 principle The competency assessment process, tools and methodologies The know how to package and communicate the Competency Assessment Reports to Management Competency Management Case Studies in the Energy Industry Target Audience This course will benefit professionals from Human Resource and Capability Development as well as Line Managers. Course Level Basic or Foundation Trainer Your expert course leader is an independent consultant trainer with more than 30 years of experience in People & Organizational Development. She has retired from her full-time job and is currently serving as an Associate Consultant / Trainer with several Learning & Development organizations operating in Malaysia and Singapore. A chemist by training, her interest in People & Organizational Development was so intense that she decided to switch profession during her earlier years of employment, and she has never looked back since. She has gathered extensive hands-on experience, leading key projects and delivering learning programs in her field of expertise with numerous leading organizations in South East Asia, the Middle East and Europe. A project that she is particularly proud in completing was the transformation of PETRONAS Management Training Institute into a regional Leadership Centre. While leading this project, she was given the opportunity to be seconded to General Electric (GE), a Fortune 500 multinational known for its cutting-edge leadership development innovation. She was instrumental in the development of the existing leadership model for PETRONAS. In addition, she was also extensively involved in the development and implementation of Technical Competency Development process that is currently being used by more than 20 disciplines in the organization. Another massive project that she was heavily involved in was the creation of the quality culture for PETRONAS. The project saw the establishment of PETRONAS' own quality principles where she played a key role in propagating the desired mindset towards the creation of a high performing culture. Her involvement in this project took her to many PETRONAS Operating Companies which spanned into several countries across the globe including Malaysia, Indonesia, Vietnam, Sudan, South Africa and Switzerland, creating awareness through learning programs and consultancy services. The PETRONAS Quality Principles have since evolved into shared values that are now known as the PETRONAS Culture Beliefs. In keeping her expertise current after retiring from full-time employment since 2017, she has continued to deliver learning programs, providing coaching and consultancy services to selected Oil & Gas companies in Malaysia, Indonesia, Singapore, India, Oman and Thailand. Among her most recent work are virtual learning deliveries and consultancies during the COVID-19 pandemic to some government linked companies / agencies in Malaysia and PTT Exploration & Production Company of Thailand. Outside her professional circle, she is an avid cyclist, a jungle tracker and a mount climber. She is also an accredited trainer from the Human Resource Development Corporation (HRD CORP). POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

About this Virtual Instructor Led Training (VILT)  This 4 half-day Virtual Instructor Led Training (VILT) course will address a variety of contract and loan structuring issues associated with geothermal energy projects as well as comparison with solar, wind and battery storage. The course is designed to investigate how various project finance techniques and contract structures can be used to achieve a competitive power prices while maintaining a satisfactory equity return. Distinctive project finance features of power facilities that depend on geothermal, wind, hydro or solar resources will be evaluated with financial models. The course will cover economic analysis of exploration and development of geothermal facilities and how to incorporate probability of failure and success into an IRR framework. Subsequent sessions will address the theory underlying liquidated damages for delay, and performance as well as design of other incentives that is inherent in different contract structures. Nuanced project finance issues associated with structuring debt for renewable projects will be discussed including under what conditions the DSCR drives debt capacity and when the debt to capital ratio is instrumental. The course will be taught with a combination of theoretical discussions, term sheet review and focused financial models. Training Objectives Evaluation of the economic risks that arise from uncertainty associated with drilling exploration wells and development wells for geothermal projects. Analyse the theoretical issues with computing LCOE for geothermal projects compared to other renewable and non-renewable resources and the importance of cost of capital for renewable projects; Understand differences in contract structures for renewable projects and dispatchable projects and how a single price structure can distort incentives for efficient construction and operation; Understand components of financing that influence the bid price required to meet a required rate of return on equity and can result in relatively low prices with reasonable returns. Understand the importance of debt sizing constraints and what strategies are relevant when the debt to capital constraint applies relative to when the debt service coverage ratio drives the debt size; Understand how to compute P50, P90 and P99 for different projects driven by resource risk; Understand the difference between mean reverting resource variation and estimation mistakes that do not correct as the basis for 1-year P90 and 10-year P90. Understand under what conditions debt sculpting can affect returns and how synthetic sculpting can be used to increase returns when the DSCR constraint applies. Understand the theory of credit spreads, variable rate debt and interest rates in different currencies and compute the implied probability of default that in inherent in credit spreads. Understand how to evaluate the costs to equity investors and the benefits to lenders for various credit enhancements including DSRA accounts, cash flow sweeps and covenants. Course Level Basic or Foundation Training Methods The VILT will be delivered online in 4 sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day, including time for lectures, discussion, quizzes and short classroom exercises. Trainer Your expert course leader provides financial and economic consulting services to a variety of clients, he teaches professional development courses in an assortment of modelling topics (project finance, M&A, and energy). He is passionate about teaching in Africa, South America, Asia and Europe. Many of the unique analytical concepts and modelling techniques he has developed have arisen from discussion with participants in his courses. He has taught customized courses for MIT's Sloan Business School, Bank Paribas, Shell Oil, Society General, General Electric, HSBC, GDF Suez, Citibank, CIMB, Lind Lakers, Saudi Aramco and many other energy and industrial clients. His consulting activities include developing complex project finance, corporate and simulation models, providing expert testimony on financial and economic issues before energy regulatory agencies, and advisory services to support merger and acquisition projects. Our key course expert has written a textbook titled Corporate and Project Finance Modelling, Theory and Practice published by Wiley Finance. The book introduces unique modelling techniques that address many complex issues that are not typically used by even the most experienced financial analysts. For example, it describes how to build user-defined functions to solve circular logic without cumbersome copy and paste macros; how to write function that derives the ratio of EV/EBITDA accounting for asset life, historical growth, taxes, return on investment, and cost of capital; and how to efficiently solve many project finance issues related to debt structuring. He is in the process of writing a second book that describes a series of valuation and analytical mistakes made in finance. This book uses many case studies from Harvard Business School that were thought to represent effective business strategies and later turned into valuation nightmares. Over the course of his career our key course expert has been involved in formulating significant government policy related to electricity deregulation; he has prepared models and analyses for many clients around the world; he has evaluated energy purchasing decisions for many corporations; and, he has provided advice on corporate strategy. His projects include development of a biomass plant, analysis and advisory work for purchase of electricity generation, distribution and transmission assets by the City of Chicago, formulation of rate policy for major metro systems and street lighting networks, advocacy testimony on behalf of low income consumers, risk analysis for toll roads, and evaluation of solar and wind projects. He has constructed many advisory analyses for project finance and merger and acquisition transactions. Lastly, our key course expert was formerly Vice President at the First National Bank of Chicago where he directed analysis of energy loans and also created financial modelling techniques used in advisory projects. He received an MBA specializing in econometrics (with honours) from the University of Chicago and a BSc in Finance from the University of Illinois (with highest university honours). POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

LOOKING FOR: MG, ADULT FICTION Jo Williamson has been in publishing for over 25 years. Having worked in Children’s books PR for Dorling Kindersley, HarperCollins and Orion, she started as an agent with Antony Harwood in 2008. She feels very privileged being with authors at the very start of their publishing journey and enjoys close working relationships with all her clients. From editorial help, general advice on the publishing world, guiding careers long-term and general cheerleading, she feels she has the perfect job. Although nothing is off limits and she loves being surprised by submissions, In middle grade children's fiction, Jo is particularly looking for books with heart, epic adventures with voice-led characters, and younger funny fiction with series potential.  In adult fiction, page-turning Commercial Women’s and Book Club fiction are right up Jo's street, including psychological suspense, thriller, cosy crime and books that don’t quite fit the mould. Above all, she wants stories that linger long after the final page has been read. Jo is not the right fit for police procedurals. Jo would like you to submit a covering letter, 1 page synopsis and the first 5,000 words of your manuscript in a single word document. (In addition to the paid sessions, Jo is kindly offering one free session for low income/underrepresented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Wednesday 5th February 2025

Identify some of the unique challenges women face in their personal and professional lives, and understand how to support and empower females in the workplace.

Understanding Workplace Bullying and Harassment The definitive guide to workplace bullying & harassment delivered by UK's leading expert.

Understand why it is difficult for us to accept changes when they occur - both in our personal and professional lives. Outline the emotional stages of the change curve which maps out distinct stages all individuals go through after a change, and learn to utilise a range of strategies to cope with changes.

In times of crisis, people are in reaction mode. They work more from “fight vs. flight” than by using reason. When we serve these customers, we need to respond appropriately and help them to achieve emotional control so that we can work to solve problems. In this interactive online class, you will learn the tools needed to get yourself in emotional control. You will also learn why people react on emotion and tools to help them get back in control, too. Attendees will be able to: Focus on others to project a UB4ME, customer-centered attitude; Empower people with respect (acknowledging) and control (offering choices); and Understand customers better and develop emotionally-intelligent methods for managing their fears and reactions. Register for this class and you will be sent ONLINE login instructions prior to the class date.

Landscape training face to face training customised and bespoke.