181 Operator courses in Manchester

About this Training Course  This five-day course provides an intermediate level of understanding of the geomechanical factors that affect wellbore instability, sand production and hydraulic fracture design. The course is structured such that upon completion, participants will have understood the value that geomechanics can bring to drilling, completion and production operations and will be able to leverage this value wherever it applies. The course emphasis will be on integrating the topics presented through a combination of lectures, case-studies and hands-on exercises. A special focus will be on how geomechanics knowledge is extracted from routinely acquired well data and how it is applied in the prediction and prevention of formation instability. Course Highlights The course is essentially non-mathematical and makes wide use of diagrams, pictures and exercises to illustrate the essential concepts of geomechanics Essential Rock Mechanics Principles Wellbore Stability Analysis Anisotropic Rock Properties for unconventional projects Lost Circulation and Wellbore Strengthening applications Sand Production Management Input to Hydraulic Fracture design Salt instability Training Objectives By attending this training, you will be able to acquire the following: Apply the basic concepts of geomechanics to identify, predict and mitigate against formation instability during drilling, completion and production Target Audience This course is intended for Drilling Engineers, Well Engineers, Production Technologists, Completion Engineers, Well Superintendents, Directional Drillers, Wellsite Supervisors and others, who wish to further their understanding of rock mechanics and its application to drilling and completion. There is no specific formal pre-requisite for this course. However, attendees are requested to have been exposed to drilling, completions and production operations in their positions and to have a recommended minimum of 3 years of field experience. Trainer Your Expert Course Instructor is an operational geomechanics advisor with over 46 years of experience in exploration, development and production in the upstream oil and gas industry. After obtaining a BSc (Hons) Physics degree from Aberdeen University, he worked for a variety of oil service companies in wireline operations, management and formation evaluation, before joining Schlumberger in 1995. Since 2000 he has worked principally in real-time geomechanics operations and developing acousto-geomechical applications, taking on the role of geomechanics advisor and technical manager within the Europe-Africa area of operations. Before forming his own company in 2014, Your Expert Course Instructor was one of Schlumberger's principal instructors, delivering cross-discipline internal and external geomechanics training to petrophysicists, geologists, reservoir, petroleum, well construction and drilling engineers at operating company locations, training centers and operational centers worldwide. Through extensive operational and wellsite experience gained in the North Sea, Europe, Africa, South America and the Far East, he has gained a broad based knowledge of drilling, production, log data acquisition, analysis and interpretation that has allowed him to develop and deliver pragmatic solutions to the geomechanical challenges of drilling, sand production, fracturing and unconventional reservoirs, faced by operators. His principal interests include the development and application of acousto-geomechanical techniques for the evaluation of anisotropic formations and fracture systems and the identification and prevention of wellbore instability 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

About this training course Artificial lift systems are an important part of production operations for the entire lifecycle of an asset. Often, oil and gas wells require artificial lift for most of the life cycle. This 5-day training course offers a thorough treatment of artificial lift techniques including design and operation for production optimization. With the increasing need to optimize dynamic production in highly constrained cost environments, opportunities and issues related to real-time measurements and optimization techniques needs to be discussed and understood. Artificial lift selection and life cycle analysis are covered. These concepts are discussed and reinforced using case studies, quizzing tools, and exercises with software. Participants solve examples and class problems throughout the course. Animations and videos reinforce the concepts under discussion. Understanding of these important production concepts is a must have to exploit the existing assets profitably. Unique Features: Hands-on usage of SNAP Software to solve gas-lift exercises Discussion on digital oil field Machine learning applications in gas-lift optimization Training Objectives After the completion of this training course, participants will be able to: Understand the basics and advanced concepts of each form of artificial lift systems including application envelope, relative strengths, and weaknesses Easily recognize the different components from downhole to the surface and their basic structural and operational features Design and analyze different components using appropriate software tools Understand challenges facing artificial lift applications and the mitigation of these challenges during selection, design, and operation Learn about the role of digital oilfield tools and techniques and their applications in artificial lift and production optimization Learn about use cases of Machine learning and artificial intelligence in the artificial lift Target Audience This training course is suitable and will greatly benefit the following specific groups: Production, reservoir, completion, drilling and facilities engineers, analysts, and operators Anyone interested in learning about selection, design, analysis and optimum operation of artificial lift and related production systems will benefit from this course. Course Level Intermediate Advanced Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the 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 in their own organization. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 20. This course is also available through our Virtual Instructor Led Training (VILT) format. Prerequisites: Understanding of petroleum production concepts. Each participant needs a laptop/PC for solving class examples using software to be provided during class. Laptop/PC needs to have a current Windows operating system and at least 500 MB free disk space. Participants should have administrator rights to install software. Trainer Your expert course leader has over 35 years' work-experience in multiphase flow, artificial lift, real-time production optimization and software development/management. His current work is focused on a variety of use cases like failure prediction, virtual flow rate determination, wellhead integrity surveillance, corrosion, equipment maintenance, DTS/DAS interpretation. He has worked for national oil companies, majors, independents, and service providers globally. He has multiple patents and has delivered a multitude of industry presentations. Twice selected as an SPE distinguished lecturer, he also volunteers on SPE committees. He holds a Bachelor's and Master's in chemical engineering from the Gujarat University and IIT-Kanpur, India; and a Ph.D. in Petroleum Engineering from the University of Tulsa, USA. Highlighted Work Experience: At Weatherford, consulted with clients as well as directed teams on digital oilfield solutions including LOWIS - a solution that was underneath the production operations of Chevron and Occidental Petroleum across the globe. Worked with and consulted on equipment's like field controllers, VSDs, downhole permanent gauges, multiphase flow meters, fibre optics-based measurements. Shepherded an enterprise-class solution that is being deployed at a major oil and gas producer for production management including artificial lift optimization using real time data and deep-learning data analytics. Developed a workshop on digital oilfield approaches for production engineers. Patents: Principal inventor: 'Smarter Slug Flow Conditioning and Control' Co-inventor: 'Technique for Production Enhancement with Downhole Monitoring of Artificially Lifted Wells' Co-inventor: 'Wellbore real-time monitoring and analysis of fracture contribution' Worldwide Experience in Training / Seminar / Workshop Deliveries: Besides delivering several SPE webinars, ALRDC and SPE trainings globally, he has taught artificial lift at Texas Tech, Missouri S&T, Louisiana State, U of Southern California, and U of Houston. He has conducted seminars, bespoke trainings / workshops globally for practicing professionals: Companies: Basra Oil Company, ConocoPhillips, Chevron, EcoPetrol, Equinor, KOC, ONGC, LukOil, PDO, PDVSA, PEMEX, Petronas, Repsol, , Saudi Aramco, Shell, Sonatrech, QP, Tatneft, YPF, and others. Countries: USA, Algeria, Argentina, Bahrain, Brazil, Canada, China, Croatia, Congo, Ghana, India, Indonesia, Iraq, Kazakhstan, Kenya, Kuwait, Libya, Malaysia, Oman, Mexico, Norway, Qatar, Romania, Russia, Serbia, Saudi Arabia, S Korea, Tanzania, Thailand, Tunisia, Turkmenistan, UAE, Ukraine, Uzbekistan, Venezuela. Virtual training provided for PetroEdge, ALRDC, School of Mines, Repsol, UEP-Pakistan, and others since pandemic. 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 Training Course Well interventions have a large opportunity to enhance well production if correctly designed and implemented. Conversely, they can have a large negative impact on production if they're not. The Well Intervention & Productivity School (WIPS) is designed to help well intervention specialists, well service supervisors, and petroleum engineers become more aware of the problems that can arise in the planning and execution of well interventions. This 5 full-day course is designed to make those that attend aware of how their job can directly impact the productivity. Early identification of problems in wells and effective interventions to fix problems can have a significant impact by minimising lost oil through formation damage and non productive time. As well as discussing best practice, time will be made available for discussion relating to specific problems that may be affecting fields operated by members of the class. The course is a mixture of informal teaching and lectures. In addition, group exercises are used to reinforce the subjects covered during the lectures. This encourages cross discipline awareness, communication and motivates team building. The course has recently been updated in the areas of Subsea and HPHT interventions. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Upon completion of this course, the participants will be able to: Identify the main reasons for performing well interventions. Identify the main formation damage mechanisms and understand how to prevent them. Improve your knowledge and understanding of well barriers. Improve your knowledge of pumping and stimulation operations. Improve your knowledge of wireline, coiled tubing and hydraulic workover operations. Target Audience The course is aimed at all engineers and contractors involved in the planning and execution of well interventions. This is a school where engineers and supervisors can hone their skills, especially at a time when increased production is a high priority. In the past, course attendees have been a mix of Petroleum engineers, Well Intervention engineers, Reservoir and Drilling engineers, Production Operators, Wellsite supervisors, as well as Geologists. In recent years, delegates have come from a wide range of disciplines and backgrounds. Experience before coming on the course has varied from no field experience and no experience of planning and programming well interventions through to many years working in well interventions. In order to be able to best adapt the course to the delegates expectations, you will be required to submit a pre-course questionnaire upon submission of your registration. Course Level Intermediate Trainer Your expert course leader has over 40 years in the oil industry. During that time, he has worked exclusively in well intervention and completions. After a number of years working for intervention service companies (mostly slickline), he joined BP as an offshore well service supervisor. He was responsible for the day-to-day supervision of well intervention work on many of BP's North Sea platforms and subsea wells. This included coil tubing, e-line, slickline, stimulation and well test operations. An office-based role as a well operations engineer followed. He was responsible for planning, programming and organising of all the well intervention work on the Bruce and later the Magnus fields. In 1995, he moved into completion design. Since then, he has designed many platform and sub-sea completions, often travelling to the rig site to oversee the installation. In addition to his day-to-day work as a completion engineer, he regularly teaches completion and well intervention courses all over the world. He is also the author of the book, Well Control for Completions and Interventions, Gulf Publishing - April 2018. He has also appeared as an expert witness ant the International Court of Arbitration.   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 training course Gas-lift is one of the predominant forms of artificial lift used for lifting liquids from conventional, unconventional, onshore and offshore assets. Gas-lift and its various forms (intermittent lift, gas-assisted plunger lift) allows life of well lift-possibilities when selected and applied properly. This 5-day training course is designed to give participants a thorough understanding of gas-lift technology and related application concepts. This training course covers main components such as application envelope, relative strengths and weaknesses of gas-lift and its different forms like intermittent lift, gas-assisted plunger lift. Participants solve examples and class problems throughout the course. Animations and videos reinforce the concepts under discussion. Unique Features: Hands-on usage of SNAP Software to solve gas-lift exercises Discussion on digital oil field Machine learning applications in gas-lift optimization Training Objectives After the completion of this training course, participants will be able to: Understand the fundamental theories and procedures related to Gas-Lift operations Easily recognize the different components of the gas-lift system and their basic structural and operational features Be able to design a gas-lift installation Comprehend how digital oilfield tools help address ESP challenges Examine recent advances in real-time approaches to the production monitoring and lift management Target Audience This training course is suitable and will greatly benefit the following specific groups: Production, reservoir, completion, drilling and facilities engineers, analysts, and operators Anyone interested in learning about implications of gas-lift systems for their fields and reservoirs Course Level Intermediate Advanced Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the 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 in their own organization. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 20. This course is also available through our Virtual Instructor Led Training (VILT) format. Prerequisites: Understanding of petroleum production concepts. Each participant needs a laptop/PC for solving class examples using software to be provided during class. Laptop/PC needs to have a current Windows operating system and at least 500 MB free disk space. Participants should have administrator rights to install software. Trainer Your expert course leader has over 35 years' work-experience in multiphase flow, artificial lift, real-time production optimization and software development/management. His current work is focused on a variety of use cases like failure prediction, virtual flow rate determination, wellhead integrity surveillance, corrosion, equipment maintenance, DTS/DAS interpretation. He has worked for national oil companies, majors, independents, and service providers globally. He has multiple patents and has delivered a multitude of industry presentations. Twice selected as an SPE distinguished lecturer, he also volunteers on SPE committees. He holds a Bachelor's and Master's in chemical engineering from the Gujarat University and IIT-Kanpur, India; and a Ph.D. in Petroleum Engineering from the University of Tulsa, USA. Highlighted Work Experience: At Weatherford, consulted with clients as well as directed teams on digital oilfield solutions including LOWIS - a solution that was underneath the production operations of Chevron and Occidental Petroleum across the globe. Worked with and consulted on equipment's like field controllers, VSDs, downhole permanent gauges, multiphase flow meters, fibre optics-based measurements. Shepherded an enterprise-class solution that is being deployed at a major oil and gas producer for production management including artificial lift optimization using real time data and deep-learning data analytics. Developed a workshop on digital oilfield approaches for production engineers. Patents: Principal inventor: 'Smarter Slug Flow Conditioning and Control' Co-inventor: 'Technique for Production Enhancement with Downhole Monitoring of Artificially Lifted Wells' Co-inventor: 'Wellbore real-time monitoring and analysis of fracture contribution' Worldwide Experience in Training / Seminar / Workshop Deliveries: Besides delivering several SPE webinars, ALRDC and SPE trainings globally, he has taught artificial lift at Texas Tech, Missouri S&T, Louisiana State, U of Southern California, and U of Houston. He has conducted seminars, bespoke trainings / workshops globally for practicing professionals: Companies: Basra Oil Company, ConocoPhillips, Chevron, EcoPetrol, Equinor, KOC, ONGC, LukOil, PDO, PDVSA, PEMEX, Petronas, Repsol, , Saudi Aramco, Shell, Sonatrech, QP, Tatneft, YPF, and others. Countries: USA, Algeria, Argentina, Bahrain, Brazil, Canada, China, Croatia, Congo, Ghana, India, Indonesia, Iraq, Kazakhstan, Kenya, Kuwait, Libya, Malaysia, Oman, Mexico, Norway, Qatar, Romania, Russia, Serbia, Saudi Arabia, S Korea, Tanzania, Thailand, Tunisia, Turkmenistan, UAE, Ukraine, Uzbekistan, Venezuela. Virtual training provided for PetroEdge, ALRDC, School of Mines, Repsol, UEP-Pakistan, and others since pandemic. 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

NPORS Scissor Lift Training The aim of the NPORS Scissor lift training is to provide the candidate with the basic knowledge and practical skills involved in operating Mobile Elevated Working Platforms. NPORS Scissor lift training delegates will be enabled to: Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Your skills, our commitment—always at the best price. Boom Lift Training We at Vally Plant Training also offer the Boom Lift Training Course. The two can run at the same time so you are able to gain both qualifications to operate these MEWPS in the workplace Mobile Elevating Work Platform (MEWPS) Course Summary An Introduction to the Construction Industry. Provision and Use of Work Equipment Regulations. Lifting Operations and Lifting Equipment Regulations. Health and Safety at Work Order. Other current relevant regulations. Introduction to the machine. Pre – shift inspections. Controls and instruments. Operators Code of Safe Practice. Components and types of Mobile Elevating Work Platforms. Limitation of use. Moving and locating machine. Emergency controls. Servicing and Inspection Testing. Scissor Lift Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of the Scissor Lift and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built MEWP practical training area to simulate an actual working environment. Our Scissor lift training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS scissor lift Tester to your site nationwide, to reduce the amount of time away from work Frequently Asked Questions 1. Who should take the Scissor Lift Training? This training is ideal for individuals who need to operate Mobile Elevated Work Platforms (MEWPs), particularly scissor lifts, in various industries. 2. What does the Scissor Lift Training cover? The training includes site safety awareness, machine control familiarization, pre-start checks, safe operating techniques, recognizing hazards, and emergency procedures. 3. How long is the Scissor Lift Training? The course typically lasts 1 day and can accommodate up to 6 candidates. 4. What certification do I receive upon completion? Participants receive an NPORS card, either the traditional card valid for 5 years or the NPORS card with CSCS logo, initially valid for 2 years. 5. Are there any prerequisites for the Scissor Lift Training? Candidates must have a good understanding of English. For the NPORS card with CSCS logo, a CSCS Health & Safety test must have been completed within the last two years. Our more courses: Refine your expertise with our specialized Lift Supervision Training, Slinger Signaller Training, Ride-On Road Roller, Telehandler Training, Cat & Genny Training Slinger Signaller, Abrasive Wheels Training, Lorry Loader Training and Telehandler Training. Elevate your skills for safer and more efficient operations in construction and logistics. Enroll today to advance your career prospects. For those looking for a “NPORS Scissor Lift Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK

About this Training Course This course will provide detailed learning to the various aspects of the design, analysis and operation of subsea control systems for a variety of field development options to allow effective management of subsea facilities either from offshore structures or from shore bases. This will include power and telemetry focussing on electrical, hydraulic and electro-hydraulic systems, shut down systems, and application of intelligent monitoring and 'smart' fields. Training Objectives By attending this course, participants will be able to: To provide detailed knowledge and understanding of the requirements for, and design of, subsea electrical, electro-hydraulic, hydraulic and programmable control systems. Knowledge of the components and uses of a wide variety of subsea control systems the requirements for and design implications, of umbilicals and control lines (power and telemetry) Knowledge of, and ability to model, power requirements subsea and detailed understanding of the requirements and objectives of pre-commissioning, both at the factory and in situ. Knowledge of the standards involved in design of equipment, control and application of manual and automatic shut-down valves, and emergency response systems Introduction to design of redundancy and the role of spare capacity and to be able to put this knowledge to effect to contribute to detailed field design. An understanding of obsolescence management in subsea control systems Target Audience This course is intended for Offshore and Onshore Subsea Production Control Systems; Engineers, Technicians, Supervisors, Operators; Graduates; Apprentices; transfers from other industries, and existing staff with a limited exposure to Production Control and a need to understand the more technical aspects of the system. Companies not directly involved in the day-to-day support of the industry, but occasionally involved in supplying and supporting operators; manufacturers and suppliers of Oil and Gas equipment and services may also find this a useful course to understand how their equipment and technical expertise is integrated into the Offshore system. Trainer For most of his working life, your expert course leader has been in a role that has enabled him to pass on skills and knowledge to others. A full-time role in Training and Development came about in 1996 with the offer to take up a full-time teaching post at Aberdeen College. In 1998, he was recruited by Kvaerner Oilfield Products, an Oil & Gas industry company, specialising in Subsea Control Systems, to develop and implement a Training & Competence program acceptable for its staff of over 600 and their client companies - a challenge he could not resist. In 2003, he broadened his horizons and became an independent Training & Development consultant. Building a reputation for delivering training and development to the Oil & Gas industry to the highest standards, he later joined Jee Ltd, a leading subsea engineering and training company based in Aberdeen. He was tasked with a wide portfolio of training, coaching & mentoring to achieve high levels of competence for the client's staff and customers. He is also a Science and Engineering Ambassador (Scotland), promoting the need for engineers and technicians for Scotland's industries, a frequent consultant to the European Economic & Social Committee for standardising Vocational Skills training and competence throughout the EU. He holds memberships in the Society of Operations Engineers, Chartered Institute of Personnel & Development and Society of Underwater Technologies. 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

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

About this Training Course This 5 full-day course covers all the main elements of IChemE's Process Safety Competency framework: culture, knowledge and competence, engineering and design, human factors, systems and procedures, and assurance. Participants will achieve at least the second level of competence 'Basic Application', which is defined as 'Performs fundamental and routine tasks. Requires occasional supervision. Increased functional expertise and ability. Works with others.' This course examines the interrelation of the various techniques of process safety for analysing and managing process hazards in the hydrocarbon and chemical processing industries. There is a particular emphasis on engineering design aspects with extensive participation in individual and group exercises, tutored exercises and video case studies throughout the course to underpin key learning points. The learning is consolidated in a comprehensive case study and requires collaboration between members of each syndicate. This course has been reviewed and approved by the Institution of Chemical Engineers. IChemE is the global professional membership organisation for chemical, biochemical and process engineers and other professionals involved in the chemical, process and bioprocess industries. Their knowledge of professional standards, close involvement with industry, education and regulators, and their expertise as a leading global training provider, means they are uniquely positioned to independently assess and approve training courses and professional development programmes across the world. Training Objectives By the end of this course, participants will be able to: Acquire the underpinning knowledge required to achieve process safety competency Gain a comprehensive understanding of process safety management Understand the concept of the safety life cycle of a process plant from conceptual design onwards including operation, maintenance and modification Understand the hazard scenarios associated with a process plant Understand how risks can be controlled by hardware and procedural measures Identify and analyse hazard causes and consequences Recognise when specialist analytical expertise is required Generate effective and appropriate measures to reduce risks Justify and communicate practical solutions to non-technical personnel Explain the rationale for process safety measures to decision makers Target Audience This course is suitable for process industry professionals who need to acquire a comprehensive understanding of process safety management, those moving into process safety positions or those who wish to broaden their process safety knowledge within their existing discipline. It is particularly suited for anyone involved in the design, operation, modification or maintenance of a major hazard installation. This includes: Supervisors, operators and maintainers in Oil & Gas, Petrochemical and Chemical industries, process, mechanical and chemical engineers and technicians Design engineers, project engineers and HSE managers Control, automation and instrumentation engineers It will also demonstrate a substantial understanding of process safety for those engaged in Continuous Professional Development or aiming for the Chartered Engineer status. Course Level Basic or Foundation Trainer Your expert course leader has 50 years' experience in chemical and process safety engineering. His early career included 20 years in design and project engineering with various fine chemical and pharmaceutical companies where he designed chemical processes, specified plant equipment and selected materials for highly corrosive and toxic processes, often where textbook data was not available. This was followed by 10 years in offshore oil and gas design projects where he was responsible for setting up a Technical Safety group to change design safety practices in the aftermath of the 1988 Piper Alpha disaster. In recent years, he has been called upon to conduct various offshore and onshore incident investigations. His career has given him experience in project engineering, project management, process design and operations, safety engineering and risk management. He is a Fellow of the UK Institution of Chemical Engineers. He served on the Scottish Branch committee, and was elected chairman for a two-year term in 1991. He has also been chairman of the Safety and Reliability Society - North of Scotland Branch. He has delivered training courses in Process Hazard Analysis (HAZOP and HAZID), Process Safety Management, Hazard Awareness, Risk Assessment, Root Cause Analysis, Failure Modes & Effect Analysis and has lectured on Reliability Analysis to the M.Sc. course in Process Safety and Loss Prevention at Sheffield University. In addition to delivering training courses, he currently facilitates HAZOP / HAZID / LOPA studies and undertakes expert witness roles advising lawyers engaged in contractual disputes, usually involving the design or construction of chemical plants or Oil & Gas production facilities, or criminal prosecutions. 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 Training A variety of factors such as prices for crude oil and natural gas, liability exposure, and relations with host countries, present an opportunity for investors looking to acquire assets without taking on elements of exploration and market risk. Conversely, operators want to ensure that they are in the best position to monetise the disposal of interests in their portfolios. The material in this course covers the range of considerations that occur in the sale and purchase of upstream oil and gas properties. They include structuring (asset sale, share transfer, merger, interest swaps, and farm-outs), process (tender, direct negotiation, due diligence, preliminary and final agreements, closing and post-closing adjustments) and how funding is structured (credit agreements and reserve base lending). Training Objectives Upon completion of this course, participants will be able to: Plan and prepare for the sale or purchase of upstream oil and gas properties Select and structure the type of transaction best suit to the position of the Buyer and Seller Conduct and evaluate the commercial, operational, and legal aspects of due diligence Negotiate and document the terms and conditions contained in sale and purchase agreements for oil and gas properties Conduct post-closing adjustments in the sale and purchase of operating properties Assist in the negotiation of credit arrangements to fund the purchase of oil and gas properties Target Audience This course has been specifically designed for commercial, operating, legal and financial professionals involved in the sale and purchase of upstream oil and gas properties whose roles include: Conducting tenders for the sale of exploration and operating interests Performing due diligence reviews Negotiating preliminary and definitive agreements Arranging credit agreements and other types of funding Course Level Basic or Foundation Trainer Your expert course leader is an international legal expert in petroleum law who is based in Scotland. He received the degrees of Juris Doctor from the University of Wyoming and LLM-Energy Law from the University of Utah. He has been listed in the Guide to the World's Leading Energy and Natural Resources Lawyers. In over 30 years of practice, he has been chief legal officer in petroleum companies, consultant to development banks and aid programmes, and law professor. His private sector experience included positions as General Counsel of the Petroleum Corporation of New Zealand and Chief Legal Officer for Sinclair Oil Corporation in the United States. He has been a consultant to the Asian Development Bank, The World Bank and the European Investment Bank on petroleum sector policy, gas sales agreements, and production sharing contracts. This has included assignments in Cambodia, Bangladesh, India, Indonesia, Laos, Pakistan, Papua New Guinea, Philippines, and Vietnam. Your expert course leader has been an adviser and trainer on negotiations for various petroleum companies including BP, BG Group, Gazprom, KazMunayGas, Perushaan Gas Negera, Pertamina, PETRONAS, Philippine National Oil Corporation, Total, Shell and Statoil. He was appointed by Economic Community of West African States (ECOWAS) as the lead negotiator on behalf of four West African governments for the West African Gas Pipeline Project. His academic credentials include an appointment as Distinguished Visiting Professor for Oil & Gas Law at the University of Wyoming. He is currently Honourary Professor for International Petroleum Law at the University of Dundee Centre for Energy, Petroleum & Mineral Law and Policy. At CEPMLP, he has been the Course Director and principal instructor for seminars on Petroleum Industry Negotiations, Petroleum Service Contracts, Gas Industry Contracts, and Downstream Petroleum Law. He is the course author of International Comparative Petroleum Law. His publications include A Framework for Negotiating and Documenting International Petroleum Transactions and A Framework for Negotiating and Managing Production Sharing Contracts and Related Agreements. His academic work has been published in the Land and Water Law Review, Tulsa Law Journal and Journal of Comparative and International Law. 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

About this Training Course This 4 full-day Maintenance and Reliability Masterclass course will provide Maintenance and Reliability personnel with a full explanation of the Award-winning Model of Excellence for maintenance. This is top tier training that has also been designed to equip participants with practical skills to take back to work. The course enables participants to develop a strategy to achieve outstanding maintenance and reliability performance for their own workplace. This course is aligned with SMRP* best practices and the CMRP exam. It provides an opportunity for participants to sit for an examination+ on the final day of the course. Your facilitator for this course is a fully qualified CMRP professional, an approved SMRP Proctor, authorised to conduct CMRP exams and a globally respected maintenance consultant and best practice trainer. +Exam fees are not inclusive in the course fees. *SMRP refers to Society of Maintenance and Reliability Professionals. PetroEdge is not affiliated with SMRP. Training Objectives By the end of this course, participants will be able to: Appreciate the content and underlying principles of our maintenance Model of Excellence o How to develop a strategy for outstanding maintenance and reliability performance o Developing reliability methodologies and programmes to drive performance o Options and tools to improve reliability at equipment level o Leadership skills and improving organisation and human performance o Work with management with an overview of the latest practice in planning scheduling and control Describe how maintenance can become a more strategic and influential function Use the Carcharodon model of excellence and class leading methodologies for improving maintenance and reliability Target Audience This course will benefit: Maintenance managers Reliability professionals Experienced supervisors Planners Project engineers Operations managers Functional specialists Course Level Basic or Foundation Training Methods Course methodology of this training course: Other than world-class visuals and slides, this course will include a high level of interaction between the facilitator and participants and group discussion among the participants themselves. There will be a number of case studies to demonstrate key points and also a minimum of one workshop exercise each day to give participants the chance to apply learning and appreciate key aspects of best practice. Participants will also have the chance to share examples from their own experience, discuss real problems they are facing and develop actions for improvement when they return to work. Examples of the exercises that are used in this course are as follows: Exercise: Understanding the challenges and seeing the opportunities Exercise: Developing a strategy Group Exercise: Selecting maintenance plans Group exercise: Case study failure Group exercise: Planning work Trainer Your expert course leader is an award-winning consultant and trainer with 30 years' experience in maintenance and reliability improvement. He has worked across five continents, in a wide variety of environments from the world's largest oil refinery to a small drinks production line. He has 10 years of maintenance management experience in the process industry, so he brings a very practical approach to training. He moved into consulting with ABB Eutech as their global maintenance specialist where he led maintenance and reliability best practice panels, delivered a wide range of maintenance improvement projects and trained other consultants. He is a fully qualified CMRP professional, an approved SMRP* Proctor, authorised to conduct CMRP exams and a globally respected maintenance consultant and best practice trainer. He founded his consultancy and training business in 2002 to focus on maintenance and reliability improvement. As part of this, he developed a range of maintenance 'models of excellence' with inputs from authors, international lecturers and some of the world's leading consultants and operators. His work has been recognised as being at the leading edge of industry best practice, winning independent awards such as the UK Chemical Industries Association 'Excellence in Engineering' award. He remains close to the industry as a respected specialist helping operating companies to achieve changes in performance. This ongoing field work enables him to continue to refine and extend best practice and the learning from this is continually fed into his training. His unique experience of facilitating two major turnarounds when the Coronavirus escalated into lockdown have given him a unique insight into how events of this type can disrupt maintenance. Moreover, his involvement in developing management processes and leading a Coronavirus response on a major industrial asset means he can talk with direct experience about how to cope and innovate in this global pandemic. He is also the expert course leader for the following courses offered by PetroEdge: Preventive and Predictive Maintenance Effective Plant Turnaround Management 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