1748 Courses in Liverpool

Agile Business Consortium Scrum Master® Course: In-House Training This two-day course covers the principles and theory of the Scrum framework and the role of the Scrum Master. IIL is an accredited training organization (ATO) and the course is delivered by accredited trainers. APMG's accreditation processes are respected globally and accredited by UKAS. A Scrum Master is responsible for promoting and supporting Scrum as defined in The Scrum Guide, and also is the leader who serves the Product Owner, the Development Team, and the Organization. Why APMG - Agile Business Consortium Scrum Master® Course and Certification? The course, syllabus, and learning objectives are based on The Scrum Guide - The Definitive Guide to Scrum: The Rules of the Game - created and maintained by Scrum's creators Ken Schwaber and Jeff Sutherland Increased business (non-IT) focus of course and exercises Developed in partnership with Agile Business Consortium - leaders in promoting and enabling business agility Course is highly interactive to encourage collaboration and reinforce learning objectives Candidates can sit the examination at the end of the training course No recertification requirements. APMG Scrum Master certification does not expire. Successful candidates are entitled to free 1-year membership with the Agile Business Consortium Successful candidates can claim a digital badge and share their success online What You Will Learn At the end of this program, you will be able to: Gain a deep understanding of the Scrum Framework - the theory, practices, roles, rules, and values - as defined in The Scrum Guide Understand, in detail, the role of Scrum Master, and how the role interacts with different members of the Scrum Team and other stakeholders Master the Scrum principles to better understand their application when returning to the workplace Understand how to construct an effective development team with an appropriate mix of skills and experience Know how to act as a servant-leader for the Scrum Team, promoting and enabling self-organization to create high-value products. Learn how to facilitate Scrum Events and remove impediments to the Scrum Team's progress Help Scrum Product Owners shape and refine product backlogs to guide early and incremental delivery of valuable products Drive adoption of the Scrum framework for more effective product and solution development, working with stakeholders and other Scrum Masters to improve its effectiveness Day One Scrum Overview Self-Organization Agile Principles Empirical Product Development Scrum Events The Development Team Scrum Roles Day Two The Product Backlog Sprint Planning and Done Sprint Progress Scrum Simulation Growing as a Scrum Master

About this Virtual instructor Led Training (VILT)  The Subsea Production Engineering Virtual instructor Led Training (VILT) course provides an overview of all of the functionalities and key interfaces of subsea equipment. The VILT course will refer to relevant industry engineering standards for subsea equipment, subsea tie-backs and critical operational requirements. The sessions will cover challenges associated with equipment design and installability, as well as a new module on subsea tie-backs. The primary learning objectives for this VILT course are met through a combination of interactive presentations, discussion and exercises. Training Objectives By the end of this VILT course, participants will be able to: Apply the requirements of related industry standards (API 6A/ 17D, API 17A etc.) engineering standards Understand the barrier and qualification requirements Identify the barriers in place given a specific mode of operation Evaluate and select which tree alternatives are valid based on the key design drivers Identify and describe the key design drivers Explain the importance of well kill rate Describe which tree alternatives are valid for certain scenarios based on an evaluation of the key tree design requirements Examine what effects subsurface requirements may have on tree design Understand the challenges associated with designing equipment for manufacturability and installability Recognise the implications of design changes to specific components and the effects on transportation and installation (such as what type of vessels, lifting equipment, and tools to use and the logistical requirements) Recognise the implication of design changes on manufacturability of subsea equipment Target Audience This VILT course provides a comprehensive understanding of the equipment used in subsea production systems. It is designed for petroleum engineers, production engineers, subsea project engineers and is also highly suitable for cost, planning, offshore installation and offshore operations engineers. Anyone directly or indirectly involved with subsea equipment will benefit from attending this VILT course - from engineers installing the equipment to procurement staff looking to understand more. Training Methods The VILT course will be delivered online in 4 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). Trainer 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 about post training coaching support and fees applicable for this. Accreditions And Affliations

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.

Our suite of modules are based around helping the customer to buy and enabling salespeople to maximise their conversations with their customers.

EnergyEdge's course empowers you with in-depth knowledge of deepwater turbidites. Acquire the necessary skills and knowledge to excel in this specialized field of study.

About this Training Course Materials Management is an essential link in the Supply Chain process. It takes an even bigger significance in the Upstream industry when the cost of a rupture in equipment or stock can be tremendous, without even considering the cost of the equipment itself. The downside may result in the accumulation of out-of-commission materials which leads to business inefficiency. What does it take to maintain efficient Materials Management? This 3 full-day course will explain more in detail. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives At the end of this course, participants will be able to: Understand the importance of an efficient Materials Management in the Supply Chain process Examine the control and validation of Stock processes Understand the role of the Duet and work within the Stock Duet in materials management Learn about the key factors in Stock optimisation Target Audience This course will benefit all personnel involved in Supply Chain including Stock Controllers, Cost Controllers, Buyers, Logisticians and those from the technical department such as Technical Administrators and members of the duet. Course Level Basic or Foundation Trainer Your expert course leader has 25 years of experience in management positions in Contracting, Procurement and Logistics, mainly in the Oil & Gas Industry. He was a Lecturer for IFP Training for 5 years. During his Oil & Gas industry experience, he has worked on major Oil and Gas development projects like the Yadana project in Myanmar, Akpo project in Nigeria and YLNG in Yemen. His international experience allows him to adapt very easily and integrate the multicultural specificities of the Oil & Gas industry in his teaching. 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 In the oil & gas industry, it is common knowledge that operators and main contractors, contract or sub-contract a wide range of their activities. The service contract is the tool used to share the risk of a service between the operator and contractor. It is also an approach adopted by the operator to control the efficiency of his contractor. This course allows all parties involved, company, contractors and subcontractors, to better understand the contractual relationship, their rights and obligations. It gives a detailed review of the contract and its main features. This course will particularly focus on the services contracts that are put in place to support a drilling campaign, covering all specificities of the various contracts. Training Objectives At the end of this course, participants will: Get a thorough understanding of the service contract clauses Be able to administer the contract and optimise the relationship with the company or contractor Target Audience This course will be useful and applicable for the following professionals: contract engineers, contracts administrators, any party involved in the relationship between the company and the contractors of a service contract Drillers and logisticians may also have interest in this course as it covers the contractual aspects of their operational activity: They are the 'Owners' of these services contracts Trainer Your expert course leader has 25 years of experience in management positions in Contracting, Procurement and Logistics, mainly in the Oil & Gas Industry. During his Oil & Gas industry experience, he has worked on major Oil and Gas development projects like the Yadana project in Myanmar, Akpo project in Nigeria and YLNG in Yemen. His international experience allows him to adapt very easily and integrate the multicultural specificities of the Oil & Gas industry in his teaching. 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

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

The course is designed to help improve your understanding of the legal requirements, the theoretical and practical principles for both the initial verification and certification of an electrical installation, further your knowledge and practical skills in the testing and inspection of a range of existing electrical installations, and help improve your understanding of the legal requirements, the theoretical and practical principles for the periodic inspect and testing and certification of an electrical installation.

About this Training Front End Loading (FEL) is a methodology that takes a deliberate approach to capital project planning. Where traditional project plans seek to help an operator reach production targets and budgets, FEL methodology aligns an operator's technical and business goals to create a more comprehensive development plan. The FEL approach increases project definition and lowers risk to positively impact total investment costs and return on investment. Training Objectives Upon completion of this course, participants will be able to: Learn the methods applied for Pre-FEL and FEL process Understand the importance of FEL, FEL stages; visualisation, conceptualisation, definition Uncover how to apply project management during FEL Determine risk management in the FEL process Understand benchmarking & value improving practices   Target Audience The course is recommended for anyone who wish to gain in-depth knowledge and understanding of the importance of Front-End Loading and how to apply Front End Loading best practices, including: Team Leaders Senior Managers (Line and Function) Project Managers Development Engineers Graduate Engineers Quality Assurance Engineers Key Contractor's Management FEED engineers Design engineers Mechanical engineers Process engineers   Course Level Basic or Foundation Trainer Your expert course leader is a subsea pipeline consultant with extensive experience in the design, construction, and installation of subsea pipelines for the oil and gas industry. As a consultant, he provides technical expertise and support to clients on all aspects of subsea pipeline projects, from the initial planning and design phase through to construction and commissioning. He is knowledgeable about industry standards, regulations, and best practices for subsea pipelines, and works closely with clients to ensure that projects are delivered safely, on time, and within budget. He has over thirty years' experience in early concept and front-end studies for the initiation of numerous high value upstream oil and gas projects worldwide. He has worked for both Operating Companies and Consultants managing the FEL process for complex, multi-discipline and technically challenging concepts, combining both his technical and project management skills. He has been working with companies like ExxonMobil, Quantum Power, North Caspian Operating Company, OMV Petrom, Port Meridian, BG Group, and etc.   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