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

83 Courses in Sheffield

Sale & Purchase of Oil & Gas Properties

By EnergyEdge - Training for a Sustainable Energy Future

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

Sale & Purchase of Oil & Gas Properties
Delivered in Internationally or OnlineFlexible Dates
£3,009 to £3,499

Suicide First Aid

5.0(2)

By Changing Minds Training

This one-day Suicide First Aid training course gives learners the knowledge and tools to understand that suicide is one of the most preventable deaths and some basic skills can help someone with thoughts of suicide stay safe from their thoughts and stay alive.

Suicide First Aid
Delivered in London or UK Wide or OnlineFlexible Dates
£2,495

Disciplined Agile Scrum Master (DASM): In-House Training

By IIL Europe Ltd

Disciplined Agile Scrum Master (DASM): In-House Training Is your team treading water using waterfall? Do you feel trapped in an agile framework? Would you like to find solutions to the problems you've been wrestling with? Are you looking for ways to enhance your team's agility? Break free from your old ways by choosing a way of working that fits your team's context. Find strategies to improve your processes and strengthen your team with the Disciplined Agile® tool kit. Disciplined Agile Scrum Master is a nine-lesson, instructor-led course that shows you how to use Disciplined Agile (DA™) to improve your team's way of working. In just two days, you will become familiar with foundational agile and lean practices that DA supports, practice using the tool kit to solve problems, and learn how to build high-performance teams. Filled with activities, animations, supplemental reading, and more, this course will prepare you to take the Disciplined Agile Scrum Master (DASM) exam and, equally important, start using Disciplined Agile immediately. #BBD0E0 » What You Will Learn After the completion of this course, you will be able to: Apply foundational agile and lean practices in your own team setting Describe what business agility is and how it is core to value proposition of Disciplined Agile® Describe the significance of the Disciplined Agile mindset Define the DA™ principles, promises, and guidelines and how they set Disciplined Agile apart from other frameworks Explain how people are organized into DA teams Define the primary DA roles and how they each are key to the success of a self-organizing agile team Explain how to help your team work well together using the Lean principle of 'respect people' Analyze your team's context to make better process-related decisions Select the best-fit DA life cycles for your teams Apply the five DA steps of choosing your team's way of working (WoW) Apply the relevant agile and lean techniques to successfully initiate your team Apply the relevant agile and lean techniques to support your team producing business value Apply the relevant agile and lean techniques to support your team releasing their work into production Apply the relevant agile and lean techniques to support your team on an ongoing basis Recognize when to be resilient List and define the principles of Lean Significance of the Disciplined Agile® Mindset Business agility and how it is core to value proposition of Disciplined Agile Eight DA principles and how they are core to what sets Disciplined Agile apart from other agile frameworks Which situations each of the DA™ life cycles is best applied DA Practice of choosing a team's way of working (WoW) Foundations of Agile How people are organized into DA teams Primary DA roles and how they each are key to the success of a self-organizing agile team Help your team work well together (Lean principle 'Respect people') Inception phase and why it is important DA tool kit to tailor your way of working within a select phase according to context Agile techniques and ceremonies relevant to Inception Construction phase and why it is important Agile techniques and ceremonies that take place during Construction Eliminate Waste and Build Quality (Lean principles) Deliver Value Quickly (Lean principle) Transition phase and why it is important Ongoing phase and why it is important Learn Pragmatically (Lean principle) Elements of the process blade (onion) diagram Principles of Lean When to be resilient Benefits of explicit workflow Kaizen loops and PDSA techniques for continuous improvement Options for cross-team learning: "community of practice" and "center of excellence"

Disciplined Agile Scrum Master (DASM): In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,450

Emergency First Aid at Work 6 hours (VTQ) Level 3 - EFAW

5.0(27)

By PETM

Embark on a journey to become a workplace hero with our comprehensive one-day First Aid course. This dynamic and engaging training program is designed to equip you with the essential skills and knowledge needed to handle emergency situations confidently and effectively.

Emergency First Aid at Work 6 hours (VTQ) Level 3 - EFAW
Delivered In-Person in ELY + 1 more or UK WideFlexible Dates
£65

Suicide First Aid Lite

5.0(2)

By Changing Minds Training

This half-day Suicide First Aid Lite training course gives learners the knowledge and tools to understand that suicide is one of the most preventable deaths and some basic skills can help someone with thoughts of suicide stay safe from their thoughts and stay alive.

Suicide First Aid Lite
Delivered in London or UK Wide or OnlineFlexible Dates
£1,995

Basic Life Support and Management of Anaphylaxis (RQF)

By BAB Business Group

Anaphylaxis is a severe and life-threatening allergic reaction, which requires immediate medical attention. With the number of sufferers increasing each year, it is extremely important to know what to do when faced with this acute emergency condition.  The QA Level 2 Award in Basic Life Support and Management of Anaphylaxis (RQF) qualification has been designed for those who have a specific responsibility at work, at home or in voluntary and community activities, to provide basic life support and manage anaphylaxis when dealing with an emergency. Successful candidates will be able to recognise the signs and symptoms of anaphylaxis, and will be equipped with the vital skills needed to administer safe, prompt and effective treatment.

Basic Life Support and Management of Anaphylaxis (RQF)
Delivered In-Person in Heywood or UK WideFlexible Dates
£65

Combined EFAW & EPFA course

5.0(15)

By 2 Save A Life First Aid Courses NI

EPFA and EFAW combined course

Combined EFAW & EPFA course
Delivered In-Person in Newtownards or UK WideFlexible Dates
£102

M.D.D DATING PROFILE SPECIALIST (SINGLES)

4.9(27)

By Miss Date Doctor Dating Coach London, Couples Therapy

Introducing the Dating Profile Specialist Package: Elevate Your Online Dating Experience with Expert Guidance Are you seeking professional assistance to create an exceptional online dating profile that stands out and captures the attention of potential matches? Miss Date Doctor’s Dating Profile Specialist Package offers you personalized guidance and support from experienced specialists who are dedicated to helping you present your best self in the online dating world. Crafting a standout dating profile requires expertise and insight into what makes a profile truly captivating. Our specialized dating profile experts are committed to helping you showcase your unique qualities and increase your chances of making meaningful connections. Here’s how the Dating Profile Specialist Package can support you: Personalized Assessment: Our dating profile specialists will conduct a thorough assessment to understand your personality, interests, and dating goals. Tailored Profile Creation: We’ll work with you to create a personalized and compelling dating profile that reflects your authentic self. Photo Selection: Our experts will provide guidance on selecting and arranging photos that highlight your best features and personality. Attention-Grabbing Bio: We’ll help you craft a captivating bio that effectively communicates your values, hobbies, and what you’re looking for in a partner. Showcasing Unique Qualities: Our specialists will assist in highlighting your unique qualities and qualities that set you apart from the crowd. Online Etiquette Guidance: We’ll provide insights into how to initiate conversations, maintain engaging communication, and build connections. Boosting Confidence: The Dating Profile Specialist Package can boost your confidence by providing expert support in creating an impressive and authentic profile. Attracting Compatible Matches: We’ll work towards attracting matches who resonate with your personality and are genuinely interested in connecting with you. The Dating Profile Specialist Package at Miss Date Doctor is designed to empower you with a standout online dating profile that captures your true essence. Our specialized dating profile experts provide tailored guidance and practical advice to help you make a lasting impression in the online dating community. Invest in your online dating success and take the first step towards a captivating dating profile with the Dating Profile Specialist Package. Embrace the opportunity to showcase your best self and attract matches that align with your values and aspirations. Let our experts guide you towards an enhanced online dating experience filled with meaningful connections. 4 sessions x 1 hour 20 new photos using Artificial intelligence approved https://relationshipsmdd.com/product/dating-profile-specialist/

M.D.D DATING PROFILE SPECIALIST (SINGLES)
Delivered in London or UK Wide or OnlineFlexible Dates
£800

MySQL for developers

5.0(3)

By Systems & Network Training

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

MySQL for developers
Delivered in Internationally or OnlineFlexible Dates
£2,797

Parent and Carer Course

5.0(15)

By 2 Save A Life First Aid Courses NI

This 2 - 2-5 hour course is designed is designed to provide parents and carers with the opportunity to: Develop the basic skills and knowledge needed to deal with a wide range of emergency paediatric First Aid situations, which could arise when looking after babies and children. The course can take place in in a community group or in the comfort of your home, with family and friends who maybe caring for your child or they may have children of their own. The course can be booked during the week, week nights or weekends, with or without children present. The idea is to bring the skills and knowledge to you, in your normal routine.

Parent and Carer Course
Delivered In-Person in Newtownards or UK WideFlexible Dates
£30