• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

67 Courses in London

Water Chemistry for Thermal Power Station Plant Chemist & Boiler Engineers

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course This is an advanced chemistry training course for power plant chemists and boiler engineers wishing to expand their knowledge and skills, and to become more effective in their day-to-day roles dealing with thermal power plant chemistry. This 5 full-day course will provide ample opportunity for robust technical discussion and expand on advanced concepts in thermal power plant cycle chemistry. It focuses only on the steam/water aspects of the thermal power cycle. This course is a MUST for all power plant chemists and boiler engineers. It is also beneficial for anyone involved in power plant operation and maintenance because it provides guidelines and rules for improving power plant performance and reliability. Training Objectives Gain a significant increase in understanding of cycle chemistry in steam power plants and the inter-relationships between plant operation, cycle chemistry and potential failure modes due to corrosion and/or deposition throughout the cycle Gain a thorough understanding of all causes of corrosion in a steam power plant and all the methods used to reduce the corrosion rate in a steam power plant Become better equipped to effectively manage the corrosion and deposition risks in a thermal power plant Learn how to reduce failure rate in boilers and steam power plants and improve plant performance Understand condensate polishing and treatment of condensate return to industrial boilers Discover the causes of boiler water contamination and treatment programs Learn about layup and offline corrosion protection Understand water chemistry limits to prevent steam contamination by carryover Learn about boiler water chemistry guidelines and control of steam chemistry Understand high-purity make-up treatment methods Perform demineralizer calculations Perform system design calculations Gain a thorough understanding of mixed bed polishing and reverse osmosis Target Audience Power Plant Chemists Boiler Engineers Engineers involved in the operation and maintenance of power plants Managers Technicians Maintenance personnel Other technical individuals (this seminar is suitable for individuals who do not have a background in chemical engineering) Course Level Advanced Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: 'POWER GENERATION HANDBOOK' second edition, published by McGraw-Hill in 2012 in New York (800 pages) Water Chemistry for Thermal Power Plant Chemists and Boiler Engineers Manual (650 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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

Water Chemistry for Thermal Power Station Plant Chemist & Boiler Engineers
Delivered in Internationally or OnlineFlexible Dates
£3,009 to £3,499

Industrial Instrumentation and Modern Control Systems

By EnergyEdge - Training for a Sustainable Energy Future

About this training course This 5 full-day course provide a comprehensive understanding of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, HART protocol, control valves, actuators, and smart technology. This course will focus on maximizing the efficiency, reliability, and longevity of these systems and equipment by providing an understanding of the characteristics, selection criteria, common problems and repair techniques, preventive and predictive maintenance. This course is a MUST for anyone who is involved in the selection, applications, or maintenance of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology because it covers how these systems and equipment operate, the latest maintenance techniques, and provides guidelines and rules that ensure their successful operation. In addition, this course will cover in detail the basic design, operating characteristics, specification, selection criteria, advanced fault detection techniques, critical components and all preventive and predictive maintenance methods in order to increase the reliability of these systems andequipment and reduce their operation and maintenance cost This course will provide the following information for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology: Basic Design Specification Selection Criteria Sizing Calculations Enclosures and Sealing Arrangements Codes and Standards Common Operational Problems All Diagnostics, Troubleshooting, Testing, and Maintenance Practical applications of smart instrumentation, SCADA, and Distributed Control Systems, control valves, actuators, etc in the following industries will be discussed in detail: Chemical and petrochemical Power generation Pulp and paper Aerospace Water and sewage treatment Electrical power grids Environmental monitoring and control systems Pharmaceutical plants Training Objectives Equipment Operation: Gain a thorough understanding of the operating characteristics of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Diagnostics and Inspection: Learn in detail all the diagnostic techniques and inspections required of critical components of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Testing: Understand thoroughly all the tests required for the various types of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Maintenance and Troubleshooting: Determine all the maintenance and troubleshooting activities required to minimize the downtime and operating cost of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Repair and Refurbishment: Gain a detailed understanding of the various methods used to repair and refurbish modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Efficiency, Reliability, and Longevity: Learn the various methods used to maximize the efficiency, reliability, and longevity of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Sizing: Gain a detailed understanding of all the calculations and sizing techniques used for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Design Features: Understand all the design features that improve the efficiency and reliability of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Selection: Learn how to select modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology by using the performance characteristics and selection criteria that you will learn in this course Equipment Enclosures and Sealing Methods Learn about the various types of enclosures and sealing arrangements used for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Commissioning: Understand all the commissioning requirements for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Codes and Standards: Learn all the codes and standards applicable for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Causes and Modes of Failure: Understand the causes and modes of failure of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology System Design: Learn all the requirements for designing different types of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: Industrial Instrumentation and Modern Control Systems Practical Manual (400 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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

Industrial Instrumentation and Modern Control Systems
Delivered in Internationally or OnlineFlexible Dates
£3,009 to £3,499

Hypnotherapy Practitioner Diploma Course : Feb - March 2025

By Hypnotic Solutions Training

Hypnotherapy Training Course

Hypnotherapy Practitioner Diploma Course : Feb - March 2025
Delivered Online & In-Person
£1,895 to £1,995

3ds Max Essential Training Course

By ATL Autocad Training London

Course Title: 3ds Max Essential Training Course Perfect for novice 3ds Max users, our Essentials Training Course, hosted by an Autodesk Certified Trainer, equips you with core skills for creating 3D models and animations. Click here for more info: Website Duration: 16 hours Method: 1-on-1, Personalized Attention, Tailored Content, Flexible Pace, Individual Support Schedule: Tailor your own schedule by pre-booking a convenient hours, available from Mon to Sat between 9 am and 7 pm. Course Highlights: Comprehensive Learning: Covering 3ds Max from the basics, including interface navigation and customization, to essential skills for professional 3D modeling and animations. Expert Guidance: Certified tutors and industry experts provide personalized attention, ensuring a deep understanding of 3D concepts. Flexible Scheduling: Tailor the learning experience to your pace and preferences, with one-on-one sessions available from Monday to Sunday. Interactive Learning: Engage in hands-on exercises and practical projects, enhancing your skills in a real-world context. Job Opportunities: Upon completion, students can pursue careers as: 3D Modelers: Creating detailed 3D models for games, movies, or architectural visualization. Animation Artists: Designing engaging animations for various media platforms. Visual Effects (VFX) Artists: Working on special effects for films, TV shows, and commercials. Architectural Visualizers: Producing realistic architectural renders for construction and design projects. Game Designers: Developing immersive game environments and characters. Recommended Reading: "3ds Max 2022 for Beginners" by CADFolks: A beginner-friendly guide covering fundamental concepts and techniques in 3ds Max. "Mastering Autodesk 3ds Max 2022" by Nicholas Boughen: A comprehensive resource for mastering advanced features and workflows in 3ds Max. "The Animator's Survival Kit" by Richard Williams: A classic animation guide providing valuable insights for aspiring animators. These books offer valuable knowledge and techniques, complementing the skills learned in the course and aiding in future career endeavors. Upon completing the 3ds Max Basic to Fundamentals Training Course, participants will: Master 3ds Max Tools: Gain a deep understanding of the software interface, tools, and navigation, enabling efficient 3D modeling and animation. Create Complex Models: Develop proficiency in creating intricate 3D models, including objects, characters, and architectural elements, using various modeling techniques. Apply Realistic Textures: Learn to apply textures, maps, and materials to enhance the realism of 3D models, understanding diffuse, bump, and reflective materials. Perfect Lighting and Rendering: Acquire skills in setting up various lights, environment lighting, and global illumination for realistic renderings, optimizing rendering settings for quality output. Animate with Precision: Master keyframe animation, path animation, and constraints, bringing 3D scenes to life with smooth and accurate motion. Understand Dynamics and Simulations: Explore basic dynamics and simulations, including particle systems, creating dynamic and interactive 3D environments. Problem-Solve Creatively: Develop problem-solving skills for common challenges in 3D design, using innovative techniques and tools. Professional Project Execution: Apply learned skills to real-world projects, ensuring a professional approach to 3D modeling, animation, and visualization. By the end of the course, participants will be equipped with the knowledge and skills to confidently create visually stunning 3D models, animations, and visualizations, making them proficient 3ds Max users ready for diverse industry applications. Course Highlights: Comprehensive Learning: Covering 3ds Max from the basics, including interface navigation and customization, to essential skills for professional 3D modeling and animations. Expert Guidance: Certified tutors and industry experts provide personalized attention, ensuring a deep understanding of 3D concepts. Flexible Scheduling: Tailor the learning experience to your pace and preferences, with one-on-one sessions available from Monday to Sunday. Interactive Learning: Engage in hands-on exercises and practical projects, enhancing your skills in a real-world context. Job Opportunities: Upon completion, students can pursue careers as: 3D Modelers: Creating detailed 3D models for games, movies, or architectural visualization. Animation Artists: Designing engaging animations for various media platforms. Visual Effects (VFX) Artists: Working on special effects for films, TV shows, and commercials. Architectural Visualizers: Producing realistic architectural renders for construction and design projects. Game Designers: Developing immersive game environments and characters. Recommended Reading: "3ds Max 2022 for Beginners" by CADFolks: A beginner-friendly guide covering fundamental concepts and techniques in 3ds Max. "Mastering Autodesk 3ds Max 2022" by Nicholas Boughen: A comprehensive resource for mastering advanced features and workflows in 3ds Max. "The Animator's Survival Kit" by Richard Williams: A classic animation guide providing valuable insights for aspiring animators. These books offer valuable knowledge and techniques, complementing the skills learned in the course and aiding in future career endeavors. Receive ongoing email support for a lifetime. Access comprehensive handouts and valuable documents. Explore flexible financial support choices, including installment plans and funding through job center plus and DWP (Contact us for specifics). Rest assured with our money-back guarantee: If you're dissatisfied after your initial session, we address your concerns and provide a refund if necessary (Terms and conditions may apply). Get help with computer optimization to enhance software performance in Autocad, 3ds Max, and Photoshop on both PC platforms. Benefit from our industry connections, facilitating portfolio promotion and job opportunities.

3ds Max Essential Training Course
Delivered in London or OnlineFlexible Dates
£558

Compressors & Pumps: Selection, Applications, Operation, Troubleshooting and Maintenance

By EnergyEdge - Training for a Sustainable Energy Future

Enhance your expertise in compressor and pump selection, operation, troubleshooting, and maintenance with EnergyEdge's comprehensive classroom training. Elevate your skills today!

Compressors & Pumps: Selection, Applications, Operation, Troubleshooting and Maintenance
Delivered in Internationally or OnlineFlexible Dates
£2,699 to £2,899

Jewellery Design Course - Create Personalised Jewellery (Blender)

By FluidDesigner

Learn to use 3D printing software to design and create your own pendants, earrings, rings and bracelets. The course is on a one-to-one basis. If you want to be in the jewellery trade as a designer and seller of modern jewellery or you simply want to create designs for yourself and your family then you should be learning how to create your own designs using apps such as Fluid Designer for 3D Printing.

Jewellery Design Course - Create Personalised Jewellery (Blender)
Delivered In-Person in London or UK WideFlexible Dates
£245

Querying Microsoft SQL Server

5.0(3)

By Systems & Network Training

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Querying Microsoft SQL Server
Delivered in Internationally or OnlineFlexible Dates
£2,797

About this Training Course Managed Pressure Drilling (MPD) offers opportunities to improve safety and efficiency in drilling, and it is increasingly recognised by operators and regulators. MPD aims to cost effectively resolve chronic drilling problems that contribute to non-productive time. This 3 full-day course provides participants with an understanding of the MPD techniques and equipment. The course starts with the design requirements for an MPD operation. It covers all MPD methods, including constant bottom hole pressure and mud cap drilling operations. It also includes all of the rig types - both onshore and offshore - and MPD. MPD equipment is presented in detail and the design aspects of the well are also examined. Training Objectives This course aims to provide participants with a good understanding of the various aspects of managed pressure drilling. It also enables participants to gain knowledge of planning MPD operations, type of equipment and the equipment requirements for both onshore and offshore and MPD operations. At the end of the course, participants will be able to: Understand the variations in MPD Design MPD operations for various techniques Understand the engineering requirements of MPD Define MPD equipment requirements Understand operational and well control aspects of MPD Target Audience This course is designed for engineers, managers and service providers who are about to use MPD techniques and are trying to better understand the associated complexities and challenges surrounding MPD. Trainer Your expert course leader was born and raised in Nijmegen, Netherlands. He holds an MSc in Drilling Engineering from The Robert Gordon University in Aberdeen and has over 39 years of oilfield experience. He started in the industry back in 1977 as a Mud logger before becoming a wellsite drilling engineer in 1980 working mainly in the Middle East and West Africa. In 1988, he joined Shell in in the Southern North Sea. In 1995, he joined Smedvig in Norway and worked on a number of deepwater wells as well as on underbalanced drilling operations. In 1999, he started Leading Edge Advantage in Aberdeen and worked in coiled tubing, underbalanced and managed pressure drilling. In 2004, he joined Weatherford as Regional Engineering Manager in Singapore and developed the first ultra deepwater MPD systems. In 2010, he joined SPT Group specializing in well control and hydraulics modelling. SPT Group was later acquired by Schlumberger in 2012. At Schlumberger, he was Drilling Adviser, with a focus on well control, relief well planning and MPD. During that time, he was also an instructor for NExT teaching numerous well engineering courses. In 2015, he joined Wild Well as Engineering Manager in Asia and in February 2017, he became an independent consultant concentrating on provision of drilling engineering training. He has written and presented numerous papers and authored several chapters in the SPE Advanced Technology books. He is an active committee member and speaker on numerous SPE Workshops around the world. 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

Managed Pressure Drilling (MPD)
Delivered in Internationally or OnlineFlexible Dates
£2,063 to £2,399

LNG Markets, Pricing, Trading & Risk Management

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course The LNG market is developing from a fully based market on long-term contracts, to a more flexible market based on a portfolio of contracts of different durations. The increase of LNG demand, fuelled by South Korea, Japan and several other emerging economies, are creating a base for a more flexible market, where the LNG spot market will be playing a key role. Changes in the LNG market can be identified in the following areas: development of terminals and plant sizes, increased integration throughout the supply chain, diversification of supply sources, increased contractual flexibility and increased geographical distance. This is creating the foundation for the development of the LNG spot market right here in Asia today. This 3 full-day intensive intermediate level course will give you cutting-edge knowledge needed in today's complex LNG market. Increase your knowledge and understanding of the LNG market and spot trading aspects by attending this course. Training Objectives By the end of this course, participants will be able to: Leverage on the current and global drivers of the world Natural gas and LNG markets Understand regional LNG pricing effects and who the key buyers and new sellers are Appreciate the trading structures of LNG and how to structure its risk management Understand the workings and future outlook of the Asian LNG Spot market Discover and exploit the arbitrage trading opportunities between the different markets Learn what LNG derivatives are and how it will become available for hedging and proprietary trading purposes Target Audience This course will benefit: LNG market development executives are drawn from both technical and non-technical (commercial, finance and legal) backgrounds. Participants in an LNG market development team, perhaps with expertise in one area of gas development, will benefit from the course by obtaining a good grounding of all other areas. The course is pitched at an intermediate level, although those with a basic knowledge will be able to grasp most of the concepts covered. Course Level Intermediate Trainer Your course leader is a skilled and accomplished professional with over 25 years of extensive C-level experience in the energy markets worldwide. He has strong expertise in all the aspects of (energy) commodity markets, international sales, marketing of services, derivatives trading, staff training and risk management within dynamic and high-pressure environments. He received a Master's degree in Law from the University of Utrecht in 1987. He started his career at the NLKKAS, the Clearing House of the Commodity Futures Exchange in Amsterdam. After working for the NLKKAS for five years, he was appointed as Member of the Management Board of the Agricultural Futures Exchange (ATA) in Amsterdam at the age of 31. While working for the Clearing House and exchange, he became an expert in all the aspects of trading and risk management of commodities. In 1997, he founded his own specialist-consulting firm that provides strategic advice about (energy) commodity markets, trading and risk management. He has advised government agencies such as the European Commission, investment banks, major utilities, and commodity trading companies and various energy exchanges and market places in Europe, CEE countries, North America and Asia. Some of the issues he has advised on are the development and implementation of a Risk Management Framework, investment strategies, trading and hedging strategies, initiation of Power Exchanges (APX) and other trading platforms, the set-up of (OTC) Clearing facilities, and feasibility and market studies like for the Oil, LNG and the Carbon Market. The latest additions are (Corporate) PPAs and Artificial Intelligence for energy firms. He has given numerous seminars, workshops and (in-house) training sessions about both the physical and financial trading and risk management of commodity and carbon products. The courses have been given to companies all over the world, in countries like Japan, Singapore, Thailand, United Kingdom, Germany, Poland, Slovenia, Czech Republic, Malaysia, China, India, Belgium and the Netherlands. He has published several articles in specialist magazines such as Commodities Now and Energy Risk and he is the co-author of a book called A Guide to Emissions Trading: Risk Management and Business Implications published by Risk Books in 2004. 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

LNG Markets, Pricing, Trading & Risk Management
Delivered in Internationally or OnlineFlexible Dates
£2,665 to £3,099

Best Practices Procurement for Carbon Offsets in the Energy Industry

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course More energy companies today are setting ambitious net-zero targets and are expected to pour billions into the voluntary carbon offset market by the end of this decade. To get to net zero emissions, companies will need to balance emissions with nature and technology-based offsets. Markets are the best tool for connecting carbon sources and sinks. Many countries will not have enough supply inside their borders and will need to co-operate with those who have extra greenhouse gas removal potential. The energy industry is in search of effective climate tools as pressure mounts from investors and consumers for more progress on fighting rising emissions. Corporations fighting to cut their carbon footprint have for years focused on internal reduction measures. Many are now adding to that effort by turning to carbon credits, a process made easier as verification and registration tools mature. One particular category of carbon offsets leads the way: high-quality, nature-based carbon credits. These represent the largest category of carbon credit projects in the voluntary carbon market, comprising nearly half of credits issued. Public concern about this practice focused on the additionality, leakage, and integrity of carbon offsets that are created through reforestation, land preservation, carbon capture and other projects. Lack of standardization and government regulation has also increased uncertainty for all participants in carbon markets, creating risks for developers of credit-generating projects and offset purchasers. Demand for higher-quality offsets will value projects that were subjected to due diligence and rely upon reputable third-party verification. Companies purchasing offsets generated by permanent and quantifiable projects will therefore be in the best position moving forward. In this highly interactive training course, your course instructor will guide you through the latest developments and best procurement practices to successfully operate in the voluntary carbon market. Training Objectives At the end of this course, the participants will be able to: Discover the current state of the carbon economy Gain insights into the voluntary carbon market Learn about the different type carbon credits available Examine how companies can reach net zero target by using carbon offsets Uncover best practices in carbon credit procurement strategy Learn the pricing dynamics carbon credits Examine how to identify and ensure high quality credits Obtain key learning from flawed carbon offset projects Target Audience This course is intended for: Energy transition team leaders Carbon credit procurement professionals ESG strategy team leaders Finance and accounting professionals Low carbon business analysts or economists Corporate business sustainability professionals Legal, compliance and regulatory professionals Carbon trading professionals Course Level Intermediate Trainer Your expert course leader is a skilled and accomplished professional with over 25 years of extensive C-level experience in the energy markets worldwide. He has a strong expertise in all the aspects of (energy) commodity markets, international sales, marketing of services, derivatives trading, staff training and risk management within dynamic and high-pressure environments. He received a Master's degree in Law from the University of Utrecht in 1987. He started his career at the NLKKAS, the Clearing House of the Commodity Futures Exchange in Amsterdam. After working for the NLKKAS for five years, he was appointed as Member of the Management Board of the Agricultural Futures Exchange (ATA) in Amsterdam at the age of 31. While working for the Clearing House and exchange, he became an expert in all the aspects of trading and risk management of commodities. In 1997, he founded his own specialist-consulting firm that provides strategic advice about (energy) commodity markets, trading and risk management. He has advised government agencies such as the European Commission, investment banks, major utilities and commodity trading companies and various energy exchanges and market places in Europe, CEE countries, North America and Asia. Some of the issues he has advised on are the development and implementation of a Risk Management Framework, investment strategies, trading and hedging strategies, initiation of Power Exchanges (APX) and other trading platforms, the set-up of (OTC) Clearing facilities, and feasibility and market studies like for the Oil, LNG and the Carbon Market. The latest additions are (Corporate) PPAs and Artificial Intelligence for energy firms. He has given numerous seminars, workshops and (in-house) training sessions about both the physical and financial trading and risk management of commodity and carbon products. The courses have been given to companies all over the world, in countries like Japan, Singapore, Thailand, United Kingdom, Germany, Poland, Slovenia, Czech Republic, Malaysia, China, India, Belgium and the Netherlands. He has published several articles in specialist magazines such as Commodities Now and Energy Risk and he is the co-author of a book called A Guide to Emissions Trading: Risk Management and Business Implications published by Risk Books in 2004. 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

Best Practices Procurement for Carbon Offsets in the Energy Industry
Delivered in Internationally or OnlineFlexible Dates
£2,751 to £3,199