1009 Courses in London

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.

Customized and Bespoke 3ds Max Training: Face-to-Face and Online Options

About this Virtual Instructor Led Training (VILT)  Conducted in an interactive manner, Exploration Project Management will include presentations by the course leader, syndicate and plenary exercises, and (optional) assessment of selected participants' projects. Industry case studies will be integrated into all the presentations. The course material will include a course manual (handout) and a course workbook (for exercises). Participants are requested to bring a mini-poster (two PowerPoint slides) as background material for discussion during the course. Training Objectives By the end of this Virtual Instructor Led Training (VILT), participants will be able to: Improve the evaluation, execution and delivery of exploration projects, measured in terms of successful bids for new acreage, increased success rate and volume delivery from exploration drilling, and more rapid progress in appraisal of discoveries. Describe concepts, simple processes, workflows and analysis tools for project execution. Tools include the expert course leader's proprietary project management framework, including project framing and after-action review methodologies, templates for strategy development, decision trees, decision quality frameworks. They also include customised Excel spreadsheets for portfolio modelling, project risk assessment (in new ventures and prospect maturation) and business planning. Understand their role in (a) delivering the company's strategy, (b) contributing data and assessments to key exploration decision makers, and (c) communicating project progress and results to senior management. Target Audience The Virtual Instructor Led Training (VILT) is aimed at exploration professionals with more than 5 to 10 years of experience in the business, who would like to develop their skills for managing exploration projects and presenting the goals and results of their project work to senior management. Exploration and engineering professionals who work in exploration project teams, across the spectrum from new ventures (exploration business development), prospect identification and maturation, and appraisal of discoveries Exploration project leaders Exploration managers The VILT will also benefit professionals from well engineering, petroleum engineering, finance and planning who support exploration activities. Participants are requested to bring a mini-poster (two PowerPoint slides, each printed on A3 paper) as background material for discussion during the course. Course Level Basic or Foundation Trainer Your expert course leader draws on more than 35 years of experience managing, reviewing and directing projects in all aspects of the exploration business: from exploration business development (new ventures), through prospect maturation and drilling, to the appraisal of discoveries. He has more than 30 years' experience with Shell International, followed by 10 years consulting to NOCs in Asia Pacific, Africa and South America and independent oil companies in the United Kingdom, continental Europe and North America. Other than delivering industry training, he has worked on projects for oil & gas companies of all sizes, including independents, national oil companies and (super)-majors, private equity firms, hedge funds and investment banks, and leading management consulting firms. He is an alumnus of Cambridge University. He has M.A and Ph.D. degrees in geology and is a Fellow of the Geological Society of London as well as a respected speaker on management panels at international conferences. Professional Experience Management consultancy & executive education: Advice to investment banks, businesses and major consulting firms. Specialist expertise in upstream oil & gas, with in depth experience in exploration strategy, portfolio valuation and risk assessment. Leadership: Managed and led teams and departments ranging from 3 - 60 in size. Provided technical leadership to a cadre of 800 explorationists in Shell worldwide. Member of the 12-person VP team leading global exploration in Shell, a $3 bln p.a. business and recognised as the most effective and successful among its industry peers. Accountability & decision-making: Accountable for bottom-line results: in a range of successful exploration ventures with budgets ranging from $10's million to $100's million. Made, or contributed to, complex business decisions / investments, taking into account strategic, technical, commercial, organisational and political considerations. Corporate governance: Served as non-executive director on the Boards of the South Rub al Khali Company (oversight of gas exploration studies and drilling in Saudi Arabia) and SEAPOS B.V. (exploration deep-water drilling and facilities management). Technical & operations: Skilled in exploration opportunity evaluation, the technical de risking of prospects, portfolio analysis and managing the interface between exploration and well engineering activities. Unparalleled knowledge of the oil and gas basins of the world, and of different operating regimes and contractual structures, ranging from Alaska, Gulf of Mexico and Brazil, through to the Middle East, former Soviet Union, Far East and Australia. Safety: Following an unsatisfactory audit, became accountable for safety performance in Shell's exploration new ventures. Through personal advocacy and leadership of a small team, delivered pragmatic and effective HSE systems, tools and staff training / engagement and a dramatically improved safety record. R&D: Experience in the 3 key roles in R&D: scientific researcher, research manager, and 'customer' for R&D products. After re-defining Shell's exploration R&D strategy, led the re-structuring of the R&D organization, its interface with 'the business' and approaches to deployment and commercialization. Strategy: Accomplished at formulating competitive strategies in business, R&D and technology deployment, translating them into actionable tactics and results. Defined the exploration strategy of PDO (a Shell subsidiary in Oman) and latterly of Shell's global exploration programme. Professional education, behavioural/motivational coaching: Experienced in organisational re-design, change management, leadership education and talent development. Commercial skills: Personally negotiated drilling compensation claims, educational contracts and E&P contracts, with values of $5 million to $100+ million. 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

This qualification covers complex accounting and finance topics and tasks leading to students becoming confident with a wide range of financial management skills and applications.  Course Overview This qualification covers complex accounting and finance topics and tasks leading to students becoming confident with a wide range of financial management skills and applications. Students will gain competencies in drafting financial statements for limited companies, recommending accounting systems strategies and constructing and presenting complex management accounting reports. Study the Level 4 Diploma in Professional Accounting to master complex accounting tasks and qualify for senior finance roles, as well as AAT full membership. The jobs it can lead to: • Accounts payable and expenses supervisor • Assistant financial accountant • Commercial analyst • Cost accountant • Fixed asset accountant • Indirect tax manager • Payroll manager • Payments and billing manager • Senior bookkeeper • Senior finance officer • Senior fund accountant • Senior insolvency administrator • Tax supervisor • VAT accountant Entry Requirements: Students can start with any qualification depending on existing skills and experience. For the best chance of success, we recommend that students begin their studies with a good standard of English and maths. Course Content: Applied Management Accounting (mandatory): This unit allows students to understand how the budgetary process is undertaken. Students will be able to construct budgets and then identify and report on both areas of success and on areas that should be of concern to key stakeholders. Students will also gain the skills required to critically evaluate organisational performance. Learning outcomes: • Understand and implement the organisational planning process. • Use internal processes to enhance operational control. • Use techniques to aid short-term and long-term decision making. • Analyse and report on business performance. Drafting and Interpreting Financial Statements (mandatory): This unit provides students with the skills and knowledge for drafting the financial statements of single limited companies and consolidated financial statements for groups of companies. It ensures that students will have a proficient level of knowledge and understanding of international accounting standards, which will then be applied when drafting the financial statements. Students will also have a sound appreciation of the regulatory and conceptual frameworks that underpin the preparation of limited company financial statements. Learning outcomes: • Understand the reporting frameworks that underpin financial reporting. • Draft statutory financial statements for limited companies. • Draft consolidated financial statements. • Interpret financial statements using ratio analysis. Internal Accounting Systems and Controls (mandatory): This unit teaches students to consider the role and responsibilities of the accounting function, including the needs of key stakeholders who use financial reports to make decisions. Students will review accounting systems to identify weaknesses and will make recommendations to mitigate identified weaknesses in future operations. Students will apply several analytical methods to evaluate the implications of any changes to operating procedures. Learning outcomes: • Understand the role and responsibilities of the accounting function within an organisation. • Evaluate internal control systems. • Evaluate an organisation’s accounting system and underpinning procedures. • Understand the impact of technology on accounting systems. • Recommend improvements to an organisation’s accounting systems. Business Tax (optional): This unit introduces students to UK taxation relevant to businesses. Students will understand how to compute business taxes for sole traders, partnerships and limited companies. They will also be able to identify tax planning opportunities while understanding the importance of maintaining ethical standards. Learning outcomes: • Prepare tax computations for sole traders and partnerships. • Prepare tax computations for limited companies. • Prepare tax computations for the sale of capital assets by limited companies. • Understand administrative requirements of the UK’s tax regime. • Understand the tax implications of business disposals. • Understand tax relief, tax planning opportunities and agent’s responsibilities in reporting taxation to HM Revenue & Customs. Personal Tax (optional): This unit provides students with the fundamental knowledge of the three most common taxes that affect taxpayers in the UK: Income Tax, Capital Gains Tax and Inheritance Tax. With this knowledge students will be equipped to not only prepare the computational aspects of taxes, where appropriate, but also appreciate how taxpayers can legally minimise their overall taxation liability. Learning outcomes: • Understand principles and rules that underpin taxation systems. • Calculate UK taxpayers’ total income. • Calculate Income Tax and National Insurance contributions (NICs) payable by UK taxpayers. • Calculate Capital Gains Tax payable by UK taxpayers. • Understand the principles of Inheritance Tax. Audit and Assurance (optional): This unit aims to give a wider understanding of the principles and concepts, including legal and professional rules of audit and assurance services. The unit will provide students with an awareness of the audit process from planning and risk assessment to the final completion and production of the audit report. Students will also get a practical perspective on audit and assurance, with an emphasis on the application of audit and assurance techniques to current systems. Learning outcomes: • Demonstrate an understanding of the audit and assurance framework. • Demonstrate the importance of professional ethics. • Evaluate the planning process for audit and assurance. • Review and report findings. Cash and Financial Management (optional): This unit focuses on the important of managing cash within organisations and covers the knowledge and skills to make informed decision on financing and investment in accordance with organisational policies and external regulations. Students will identify current and future cash transactions from a range of sources, learn how to eliminate non-cash items and use various techniques to prepare cash budgets. Learning outcomes: • Prepare forecasts for cash receipts and payments. • Prepare cash budgets and monitor cash flows. • Understand the importance of managing finance and liquidity. • Understand the way of raising finance and investing funds. • Understand regulations and organisational policies that influence decisions in managing cash and finance. Credit and Debt Management (optional): This unit provides an understanding and application of the principles of effective credit control systems, including appropriate debt management systems. Students will be introduced to techniques that can be used to assess credit risks in line with policies, relevant legislation and ethical principles. Learning outcomes: • Understand relevant legislation and contract law that impacts the credit control environment. • Understand how information is used to assess credit risk and grant credit in compliance with organisational policies and procedures. • Understand the organisation’s credit control processes for managing and collecting debts. • Understand different techniques available to collect debts. DURATION 420-440 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

About this training course This 5-days comprehensive training course provides not only an introduction into the issues associated with the development of the pipeline transportation of CO2 from its Capture, it's transportation, storage and usage but also provides an in depth understanding of the issues to be considered in the development, design and operations of these pipelines. The theme throughout this training course is CO2 Flow Assurance and Innovative Technologies. Each training day will consist of lectures in the morning and a hands-on workshop in the afternoon. The workshop allows the participants to appreciate the design process associated with CO2 transport and its operations. Various software will be available during the workshop to predict thermo hydraulics and associated phase flows through CO2 pipelines and the attached infrastructure. Further software to assess surge and environmental safety will also be available. The CO2 pipeline design approach will consider an integrated solution through modelling the CO2 capture system as well as the host storage facility. The participants will have a total appreciation of the methodology required to develop a CO2 transportation system and have an understanding of all of the Flow Assurance, risks, and operating issues and technology requirements. Training Objectives After the completion of this training course, participants will be able to: Understand the process required and identify data to analyse Flow Assurance for CO2 pipeline transport Review and Identify the Flow Assurance issues required to be evaluated for CO2 pipeline transport design and operations methodology. These include; Hydrates, Slugging, Corrosion, Scaling, Fluid Phase Behaviour and transient conditions Establish the studies to be undertaken for each area of CO2 transport including 'Rules of Thumb' and software to be used Comprehend the need for innovative methods and the technologies to mitigate Flow Assurance issues and the need for economics considerations Appreciate the need for an integrated analysis of the CO2 transport system from the CO2 capture to the host storage facility Gain an appreciation of the emerging and enabling technologies for CO2 transport and storage application Dive deeper into the operational strategies requirements to mitigate Flow Assurance issues Target Audience This training course is suitable and will greatly benefit the following specific groups: Reservoir Engineers Flow Assurance Engineers Thermodynamics Engineers Process and Chemical Engineers Pipeline Engineers Facilities Engineers Control and Subsea Engineers working in the Oil and Gas industries Engineers in other disciplines may attend that require an appreciation of CO2 pipeline transport Control and Subsea Engineers working in the Oil and Gas industries Engineers in other disciplines may attend that require an appreciation of CO2 pipeline transport Course Level Intermediate 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 Course delivery: The maximum number of participants allowed for this training course is 20. A basic understanding of thermo-hydraulics would be advantageous. Morning Lectures and afternoon hands-on practical workshop. Special features: PC-based simulation software demonstration Workshop for hands-on training Course References & Additional resources: 'CO2 Transport from Capture to Storage and Usage', 1st Edition Handouts Pre & Post Assessment Trainer Your expert course leader is a renowned specialist in flow assurance management for the oil & gas field developments. His expertise enables him to support the operating and contracting companies as well as financial institutions regarding due diligence on offshore development investment decisions and associated operational system risks. Technical assessment of fields for acquisition and production enhancement opportunity. He possesses specialist expertise in evaluating difficult pipeline fluids transport such as Ethylene, Carbon Dioxide and Hydrogen through feasibility studies and technical reviews for clients. He has an exceptional academic background and natural leadership abilities are supported by practical experience of diverse projects worldwide, along with numerous publications at key conferences and publication of four books. Particular interests in developing novel and innovative technologies for subsea applications to solve difficult flow assurance problem areas and improve field development economics. He has worked on major industry projects including; Concorde aircraft fuelling system, the Channel Tunnel aerodynamics and the first deep water oil field development (Foinaven) in the West of Shetland. He is also currently developing a renewable energy solar farm and carbon neutral energy crop (Miscanthus) for domestic and commercial power generation application. He has developed in-house resources including specialist oil & gas field development evaluation software for subsea and onshore field infrastructure development options including; costing and financial analysis, reservoir viability, flow assurance assessment, subsea processing and boosting technologies, flow induced vibrations, surge analysis, heat transfer and chemical injection systems. Patents: · Subsea Seabed Power Generation for Depleting Gas fields Using Renewable Energy · Gas to Liquids Absorption Technology (GTLA) for subsea and onshore Flow Assurance applications · Subsea Gas Compressor System using pigs and liquid pumps · Pressure Boosting using water injection pumps · B&W Mentor subsea multi-phase meter · Surge suppression using a contained gas method for pipeline systems 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

This is the follow on course for those who want complete knowledge of all Beauty Therapy. Students will need to have completed their NVQ Level 2 in order to progress to this level. This is the perfect course for being able to offer any treatment you require. You can choose from 25 evening or a 'Fast Track' of ONLY 10 Days plus coursework, case studies and homework. This course is accredited by the VTCT and recognised by the HABIA- Hair and Beauty regulated government standards. Although our Tutors have been teaching NVQ levels at many Colleges for over 15 years now, we started the 'Academy' so that the teaching revolved around the student and not around making targets, politics and college protocols! Although we set dates, our students have an opportunity to pick and choose and to the best of our ability, we will structure special dates around them. This is what makes us completely unique and probably why we are the most features teaching school on a multitude of TV Channels!! There are many Colleges and Schools that can teach you but whatever you do, even if you do not choose us to learn with us, please make sure the school has 100% pass rate as some of the biggest private schools only have between 50-75% pass rates!! You will need to BOOK SOON TO AVOID DISAPPOINTMENT!! Here at 'The Angel Academy of Teaching and Training', we have 2 different routes of NVQ Level 3: Here are the two NVQ Level 3 options: NVQ Level 3 Massage Route: Swedish Body Massage This unit will teach a variety of massage moves which can be used effectively on paying clients to help them maintain good health. Performed on massage couches, each student will receive guidance on how to effectively use massage moves on different parts of the body. Instruction will be given in order for a student to effectively perform a 60 minute massage routine. The Course will teach the following: Client Consultation Contra-indications and contra-actions Health and Safety in the workplace Related Anatomy and Physiology Massage moves to include, effleurage, petrissage, percussion and tapotement Correct application of oil and correct pressure application After-care Indian Head Massage Indian Head Massage traditionally was an ancient healing process known to relieve headaches, stress and tension. Hair was strengthened and conditioned too with the use of certain oils. Today, the fashionable hair salons provide the use of Indian Head Massage as a means of relaxation, and it ' s popularity is increasing rapidly. On-Site practitioners now visit offices to provide treatments, bringing Indian Head Massage into our working day. In fact, Indian Head Massage is more than a massage, it is an overall healing therapy which involves chakra, colour and crystal therapy. Essential oils can be added to the scalp by a trained aromatherapist to induce a real state of well-being. Benefits of becoming certified at Indian Head Massage: Take Indian Head Massage to the employees in the large corporations Incorporate it as an extra into existing treatments to give you 'the edge' Many customers prefer to keep their clothes on Very little workspace is needed. Just a chair! Pre-Blended Aromatherapy This unit is designed to give you an insight into aromatherapy oils. Enjoy discovering the therapeutic and relaxing effects of acupressure massage using pre-blended essentials oils The course will teach the following: The benefits of using pre-blended oils Shiatsu massage Pressure points Oils and their benefits Health and Safety Related Anatomy and Physiology Client Consultation and Contra-indications After-Care Hot Stone Treatment Hot Stone Massage is an ancient treatment which involves both the Placement Of Stones and the Application and Massage using them. They are a brilliant aid for the Therapist to work deeply on a client without any trauma to their hands. One stone massage stroke is equivalent to 10 normal massage strokes. The physical and spiritual well-being induced by the stones is amazing. The treatment is a lovely one to give that brings immediate benefits. Aches and Pains Swollen Muscle and Joint Pains Aids Blood Circulation Stimulates the Lymphatic system to eliminate waste It can help relieve pain Improve Bodily Functions Helps to maintain health and well-being Your extra unit is: Facial Electrical Treatments This course is becoming more popular than ever before due to the amazing electrical equipment now available at reasonable prices for salons and therapist. Microdermabrasion Micro-Current Galvanic- Iontopheresis and Desincrustation Faradic- Electrical Muscle Stimulation Micro-Lance Direct and In-direct High Frequency Realated Anatomy Health and Safety Client Consultation and Contra-indications Related Anatomy & Physiology To enable students to identify all bodily systems relating to Anatomy and Physiology, allowing them to apply their knowledge and understanding into their therapeutic working life. The course will teach the following: Cells and Tissues The Skeletal System The Integumentary System The Blood Lymph Systems The Muscular System Neurology The Digestive and Excretory Systems The Respiratory and Olfactory Systems The Endocrine and Reproductive Systems Arthrology Health and Safety Issues Hygiene in the Workplace NVQ Level 3 General Route: Body Electrical Treatments This course is becoming more popular than ever before due to the amazing electrical equipment now available at reasonable prices for salons and therapist. An Electrical body treatment can postpone early signs of ageing, improve the appearance of the skin and erase minor sun damage, scarring, pigmentation, cellulite and 'Orange Peel' creping. The course will teach the following: Microdermabrasion Micro-Current Galvanic- Iontopheresis and Desincrustation Faradic- Electrical Muscle Stimulation Direct and In-direct High Frequency Related Anatomy & Physiology Health and Safety Client Consultation and Contra-indications Facial Electrical Treatments This course is becoming more popular than ever before due to the amazing electrical equipment now available at reasonable prices for salons and therapist. An Electrical facial treatment can postpone early signs of ageing, improve the appearance of the skin and erase minor sun damage, scarring and pigmentation. The course will teach the following: Microdermabrasion Micro-Current Galvanic- Iontopheresis and Desincrustation Faradic- Electrical Muscle Stimulation Micro-Lance Direct and In-direct High Frequency Related Anatomy & Physiology Health and Safety Client Consultation and Contra-indications Swedish Body Massage This unit will teach a variety of massage moves which can be used effectively on paying clients to help them maintain good health. Performed on massage couches, each student will receive guidance on how to effectively use massage moves on different parts of the body. Instruction will be given in order for a student to effectively perform a 60 minute massage routine. The course will teach the following: Client Consultation Contra-indications and contra-actions Health and Safety in the workplace Related Anatomy and Physiology Massage moves to include, effleurage, petrissage, percussion and tapotement Correct application of oil and correct pressure application After-care Electrical Epilation Electrolysis gives you the skills necessary for a treatment to remove unwanted hair, using alternating current and blend techniques. Individual hairs can be treated effectively and safely. The course will teach the following: Be able to safely carry out an electrical epilation treatment on most areas of the body Understand how to correctly work to remove unwanted hair Related Anatomy and Physiology Preparation of the work area Health and Safety Client Consultation and Contra-indications After-Care Your extra unit is: Hot Stone Treatment Hot Stone Massage is an ancient treatment which involves both the Placement Of Stones and the Application and Massage using them. They are a brilliant aid for the Therapist to work deeply on a client without any trauma to their hands. One stone massage stroke is equivalent to 10 normal massage strokes. The physical and spiritual well-being induced by the stones is amazing. The treatment is a lovely one to give that brings immediate benefits. Aches and Pains Swollen Muscle and Joint Pains Aids Blood Circulation Stimulates the Lymphatic system to eliminate waste It can help relieve pain Improve Bodily Functions Helps to maintain health and well-being Related Anatomy & Physiology To enable students to identify all bodily systems relating to Anatomy and Physiology, allowing them to apply their knowledge and understanding into their therapeutic working life. The course will teach the following: Cells and Tissues The Skeletal System The Integumentary System The Blood Lymph Systems The Muscular System Neurology The Digestive and Excretory Systems The Respiratory and Olfactory Systems The Endocrine and Reproductive Systems Arthrology Health and Safety Issues Hygiene in the Workplace IF YOU REQUIRE ANY FURTHER INFORMATION CHECK OUT OUR PROSPECTUS, CALL US, ASK A QUESTION ONLINE AND PAY YOUR DEPOSIT NOW TO AVOID DISAPPOINTMENT! Dates and Costs Please see below our list of upcoming courses. Click on the course for further information, request a call or email regarding the course or book now! We are quite flexible in terms of course dates so if you would like to organise a course around your timetable, please contact us! Course Days Dates Cost NVQ Level 3 ** FAST TRACK OPTION ** 14 OPEN OPEN £2499 NVQ Level 3 ** FAST TRACK OPTION ** 14 2/10/2023 15/10/2023 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 12/11/2023 25/11/2023 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 8/12/2023 21/12/2023 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 1/01/2024 14/01/2024 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 15/02/2024 28/02/2024 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 2/03/2024 16/03/2024 £2499

About this Training Course Time is money in all industries. For the Oil & Gas industry, this is no exception and the ability to maximise return on investment is all related to where the Oil is and how easily and quickly we can get that product to the customer. Whether in a technical, managerial or supporting role, you are a valuable asset in ensuring that project delivery targets are met and profits are realised. As Petroleum Engineering (PE) activities continue to increase, professionals like you must grasp the language and technology of PE operations in order to maximise expenditures throughout the producing life of a well. Petroleum Engineering equipment and procedures have a unique language that must be conquered for maximum benefit. Clear and understandable explanations of rig equipment, completion equipment, operations procedures, and their complex interactions provide an excellent foundation for smooth communication and increased efficiency in inter-department project team efforts. A confident understanding of the technical jargon and a visual appreciation of the various pieces of equipment used provides for an overall 'big picture' of the industry value chain. This serves as an excellent foundation for smooth communication and increased efficiency in inter-department project team efforts. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By the end of this course, the participants will be able to: Define the role of Petroleum Engineering and its interaction between other departments Describe terms used in the Oil & Gas industry such as Surface/Subsurface, Upstream, Midstream and Downstream Describe the Appraisal of Oil & Gas Discoveries, the Cost Estimations, Economics & Reserves Explain what is the Formation, how do we connect to it, and how do we ensure best value Describe how to construct a well, select the equipment & methods, understand the duration that the well is required to perform for Target Audience This course will benefit those in geology, reservoir engineering, equipment and maintenance, and non-petroleum engineering technical professionals as well as forward-looking executives in the following fields who are interested to enhance their knowledge and awareness of the drilling process for increased productivity and contribution to the team that they're supporting: Accounting Administration Business Development Commercial E & P IT Estimation & Proposal Finance & Administration Finance HSE General Management Joint Ventures Legal Logistics Materials Planning Planning & Budgeting Procurement Sourcing Supply Chain Tender Contract Training Drilling Fluids Course Level Basic or Foundation Trainer Your Expert Course Trainer has over 40 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in well intervention and completions. After a number of years working for intervention service companies (completions, slickline & workovers), he joined Shell as a well service supervisor. He was responsible for the day-to-day supervision of all well intervention work on Shell's Persian/Arabian Gulf platforms. This included completion running, coil tubing, e-line, slickline, hydraulic workovers, well testing and stimulation operations. An office-based role as a senior well engineer followed. He was responsible for planning, programming and organising of all the well engineering and intervention work on a number of fields in the Middle East. He had a brief spell as a Site Representative for Santos in Australia before joining Petro-Canada as Completions Superintendent in Syria, then moved to Australia as Completions Operations Superintendent for Santos, before returning to Shell as Field Supervisor Completions and Well Interventions in Iraq where he carried out the first ever formal abandonment of a well in the Majnoon Field. While working on rotation, he regularly taught Completion Practices, Well Intervention, Well Integrity and Reporting & Planning courses all over the world. In 2014, he started to focus 100% on training and became the Technical Director for PetroEDGE. Since commencing delivering training courses in 2008, he has taught over 300 courses in 31 cities in 16 countries to in excess of 3,500 participants. 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

Enhance your drilling skills with our Directional, Horizontal, and Multilateral Drilling Simulator Assisted course. Join EnergyEdge for comprehensive training.

About this Virtual Instructor Led Training (VILT) This 4 half-day Virtual Instructor Led Training (VILT) course presents the principles and best practices of portfolio management in the upstream (E&P) oil and gas industry. The VILT course is equally valuable for small independents, large integrated international companies and national oil companies. The VILT course consists of presentations, case studies, illustrative practical exercises and syndicate discussions. Particular emphasis is given to pragmatic portfolio management approaches and solutions which can be implemented swiftly without recourse to major investments in planning and portfolio management software. The VILT course will draw on examples from your expert course leader's 35+ years' experience in the oil and gas industry as an explorationist, upstream vice-president and management consultant. The VILT course handout will comprise softcopy slides used in the presentation and a softcopy workbook for the exercises. Participants will gain proficiency in portfolio management techniques, understand how and why to undertake this activity and be able to apply key concepts directly in the business of their teams / divisions. The VILT course will be presented over 4 half-days, using Microsoft Teams or Zoom and a proprietary set of VILT tools. Participants will be asked to complete a pre course questionnaire (PCQ) addressing their objectives and experience, and attend a session to familiarise themselves with VILT tools before course commencement.     Training Objectives To present the tools, concepts and principles of portfolio management To define the quantitative metrics which are used to describe projects in a portfolio To understand the benefits of portfolio management at different stages of the upstream business: in strategy development, opportunity screening, business development, drilling prospects, conducting appraisal of discoveries and developing fields To put portfolio management in the organisational context by describing the role of the portfolio management team and examining how value assurance (quality control) is best conducted on portfolio data for projects and assets To demonstrate how portfolio management contributes to improved business performance By the end of the VILT course, participants will understand: Key concepts and principles of portfolio management How to design a simple portfolio database and describe complex projects in a small number of objective metrics How to segment the portfolio into meaningful units How to use portfolio data in making business choices and decisions at the strategic and tactical levels The extent to which it is meaningful and reasonable to make comparisons across different portfolio segments How the portfolio management team can support the wider business in decision-making Target Audience This VILT course is specially designed for exploration and development geoscientists, E&P economists and finance staff, and E&P managers. Both technical and non-technical staff will benefit from the concepts presented. Companies are encouraged to send participants from different functions and seniority levels to gain great benefits especially those which would like to implement the concepts presented in this VILT course. Course Level Basic or Foundation 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. The VILT course will be presented in an interactive workshop format that allows for discussion. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). Trainer Your expert course leader draws on more than 35 years of experience managing, reviewing and directing projects in all aspects of the exploration business: from exploration business development (new ventures), through prospect maturation and drilling, to the appraisal of discoveries. He has more than 30 years' experience with Shell International, followed by 10 years consulting to NOCs in Asia Pacific, Africa and South America and independent oil companies in the United Kingdom, continental Europe and North America. Other than delivering industry training, he has worked on projects for oil & gas companies of all sizes, including independents, national oil companies and (super)-majors, private equity firms, hedge funds and investment banks, and leading management consulting firms. He is an alumnus of Cambridge University. He has M.A and Ph.D. degrees in geology and is a Fellow of the Geological Society of London as well as a respected speaker on management panels at international conferences. Professional Experience Management consultancy & executive education: Advice to investment banks, businesses and major consulting firms. Specialist expertise in upstream oil & gas, with in depth experience in exploration strategy, portfolio valuation and risk assessment. Leadership: Managed and led teams and departments ranging from 3 - 60 in size. Provided technical leadership to a cadre of 800 explorationists in Shell worldwide. Member of the 12-person VP team leading global exploration in Shell, a $3 bln p.a. business and recognised as the most effective and successful among its industry peers. Accountability & decision-making: Accountable for bottom-line results: in a range of successful exploration ventures with budgets ranging from $10's million to $100's million. Made, or contributed to, complex business decisions / investments, taking into account strategic, technical, commercial, organisational and political considerations. Corporate governance: Served as non-executive director on the Boards of the South Rub al Khali Company (oversight of gas exploration studies and drilling in Saudi Arabia) and SEAPOS B.V. (exploration deep-water drilling and facilities management). Technical & operations: Skilled in exploration opportunity evaluation, the technical de risking of prospects, portfolio analysis and managing the interface between exploration and well engineering activities. Unparalleled knowledge of the oil and gas basins of the world, and of different operating regimes and contractual structures, ranging from Alaska, Gulf of Mexico and Brazil, through to the Middle East, former Soviet Union, Far East and Australia. Safety: Following an unsatisfactory audit, became accountable for safety performance in Shell's exploration new ventures. Through personal advocacy and leadership of a small team, delivered pragmatic and effective HSE systems, tools and staff training / engagement and a dramatically improved safety record. R&D: Experience in the 3 key roles in R&D: scientific researcher, research manager, and 'customer' for R&D products. After re-defining Shell's exploration R&D strategy, led the re-structuring of the R&D organization, its interface with 'the business' and approaches to deployment and commercialization. Strategy: Accomplished at formulating competitive strategies in business, R&D and technology deployment, translating them into actionable tactics and results. Defined the exploration strategy of PDO (a Shell subsidiary in Oman) and latterly of Shell's global exploration programme. Professional education, behavioural/motivational coaching: Experienced in organisational re-design, change management, leadership education and talent development. Commercial skills: Personally negotiated drilling compensation claims, educational contracts and E&P contracts, with values of $5 million to $100+ million. 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 5-day intensive training course is designed to improve the skills of those involved in the financial and contractual auditing of upstream Oil & Gas Exploration and Production activities. The objective of this course is to enhance your understanding of the various audit principles and practices being applied in this industry today and to equip you with the knowledge and tools to deal with complex audit cases. The course concentrates on aspects of auditing unique to the E&P business. Training Objectives After the completion of this training course, participants will be able to: Apply a structured methodology for conducting oil industry internal, production sharing and joint venture audits Implement the benefits of a multi-discipline team audit approach Adopt a model of best practice for conducting audits Analyse, interpret and decide complex cases using the contracts and documents, the principles and auditor's judgement Target Audience This training course is suitable and will greatly benefit the following specific groups: Personnel with an Internal audit background who are totally new to the discipline of Joint Venture (JV) or Production Sharing Contract (PSC) audit Experienced audit practitioners who wish to update their auditing techniques Personnel from Finance or any discipline who intend to take part in internal or joint venture audits Personnel with a background in statutory audit in the accountancy profession who require an insight into the internal and joint venture audit areas Course Level Intermediate 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 25. Trainer Your expert course leader has more than 30 years of experience in the international oil and gas industry, covering all areas of Finance and Audit, including involvement in Commercial roles. During her 19 years with ENI she worked in Italy, Netherlands, Egypt and UK and was CFO for 2 major ENI subsidiaries. She has delivered training courses in Accounting, Audit, Economics and Commercial topics in many Countries. She has a Degree in Economics & Accounting and is a Certified Chartered Accountant. She is also a Chartered Auditor and an International Petroleum Negotiator. Outside of work, she is inspired by the beauty of nature and art, helping disadvantaged people, sports (football, golf) and her cat. Courses Delivered Internationally: E&P Accounting, Auditing in the Oil & Gas Industry Cost Control & Budgeting Introduction to the Oil & Gas Industry Petroleum Project Economics Contracts Strategy International O&G Exploitation Contracts 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