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

1197 Design courses in Potters Bar

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

Business Relationship Management Professional (BRMP)

By IIL Europe Ltd

Business Relationship Management Professional (BRMP)® Business Relationship Management (BRM) embodies a set of competencies (knowledge, skills, and behaviors) to foster an effective business value-producing relationship between a service provider and its business partners. The BRM Discipline rests on solid research-based foundations verified and enhanced over a decade of successful implementations in leading organizations across the world. Proven to be equally effective for shared services including Human Resources, Finance, Legal, external service providers and others, BRM practices have enjoyed widespread adaptation in IT. The Business Relationship Management Professional (BRMP) training and certification program provides a foundational understanding of business relationship management (BRM) for individuals at every experience level, with the training and certification designed to provide a solid baseline level of knowledge. In other words, this course provides the 'why' and the 'what' - 'why' business relationship management is important to your organization and 'what' a BRM capability does to add value to your organization. This interactive course, with discussions, partnering activities, and periodic knowledge checks, will provide you with the opportunity to apply learning to your unique organizational situations, creating solutions that you can use immediately upon returning to your workplace. This practical knowledge will allow you to demonstrate immediate value in your role, as well as prepare you for the BRMP Certification exam. What You Will Learn This course provides a foundational understanding of Business Relationship Management. Upon completion of the BRMP® course, participant will be able to demonstrate their understanding: Explain what business relationship management is and the value it provides to an organization Articulate the need for an organization to move beyond traditional goals of profit and products to encompass those that are appropriate for a relationship-centered organization Describe the importance of integrating business relationship management into every element of their organization Define the importance of educating their organization that a mature BRM capability will evolve culture, build partnerships, drive value, and satisfy purpose Apply business relationship management to their organization's triple bottom line of people, purpose, and planet Explain the basic knowledge, skills, and mindsets of the business relationship management role Clarify the core business relationship management approaches, tools, and templates used to achieve results Illustrate the value and impact the BRM capability has on an organization by completing a draft of the BRM Capability Workbook BRM Introduction - The Bigger Picture Why BRM = why now? Relationship-centered organization Theory of 'relationshipism' Triple bottom line BRM defined Activity domains BRM challenges BRM Capability BRM capability framework Organizational purpose and strategy Now-to-new Evolve culture Build partnerships Drive value Satisfy purpose Limitless growth and improvement BRM Capability - Evolve culture Evolve culture framework Purposeful narrative Desired behaviors Influential relationships Personal growth BRM Capability - Build partnerships Build partnerships framework BRM role competency model Relationship maturity and quality Partnering mindsets Relationship discovery Relationship nurturing BRM Capability - Drive value What is value? Types of value Sources of value Drive value framework BRM role competency model Value discovery Value realization Value results BRM Capability - Satisfy purpose Satisfy purpose framework BRM role competency model Through the BRM capability Through the triple bottom line Social value BRM Capability - Wrap-up Evolve culture capability framework Build partnerships capability framework Drive value capability framework Satisfy purpose capability framework BRM Role Our purpose and what we believe Role clarity Single point of focus BRM Code of Ethics BRM Role Competency Model BRM mindset Scope of BRM role BRM role with organizational factors BRM Team Our purpose and what we believe BRM team definition BRM team purpose, mission, and vision Assessing the value of a BRM team Organizing a BRM team Leading a BRM team Transition management Coaching BRMs Closing - BRM Key Learnings Key learnings from each module Closing - BRMP Course Wrap-Up What to do in the next 30/60/90/365 days Digital badge After passing the exam Recap learning objectives Review learning objectives Review expectations Course feedback

Business Relationship Management Professional (BRMP)
Delivered In-Person in LondonFlexible Dates
£2,795

BloomsFair signature flower table arrangement

By BloomsFair

We invite you to join us for a floral experience, creating a beautiful arrangement you can take home and learning a new skill. Our team of professionals will take you through basic mechanics, colour coordination, types of blooms.  To add to your experience we will have treats and a glass of sparkling wine or non-alcoholic cocktail. Spend your Friday night learning something new in our beautiful studio located in Angel.  You will leave with a gorgeous two-piece arrangement, two dinner candles and a sense of fulfilment. 

BloomsFair signature flower table arrangement
Delivered In-PersonFlexible Dates
£90

Group workshop (5-12 people)

By 3rd Rail Print Space

Our workshop packages are perfect for groups looking for an alternative activity to take part in as part of a corporate event, team building exercise, stag or hen do, birthday party, Christmas party or any other occasion you’d like to embellish with a unique creative spin.  Below is a list of ‘off the shelf’ workshops and packages we currently offer however each of these can be customised to suit your needs. So if you like the look of tie due but also want to give t-shirt printing a go drop us an email and we’ll do our best to make it happen. Similarly if you’d like any of these experiences to come to you please get in touch as a selection of our equipment is portable. Booking a workshop as a group would give you a discount price as well. If you are more than 5 people, you can get it from 50£ per person (regular price 75£) for our usual 6h workshop. We also offer short courses (2/3 hours) for 25£ per person. - TSHIRT PRINTING WORKSHOP - PAPER PRINTING WORKSHOP - FABRIC PRINTING WORKSHOP Email hello@3rdrailprintspace.co.uk for a quote.

Group workshop (5-12 people)
Delivered In-Person in London or UK WideFlexible Dates
Price on Enquiry

ISO 42001 Artificial Intelligence Lead Implementer Course

5.0(1)

By Cognicert Limited

The “ISO 42001:2023 Lead Implementer Course” is designed to provide participants with the knowledge and skills necessary to lead the implementation of an Artificial Intelligence Management System based on ISO 42001:2023. This comprehensive course covers the key principles, requirements, and best practices for establishing and maintaining an effective Artificial Intelligence management system. Participants will learn how to develop, implement, and manage processes that comply with the ISO 42001 standard.

ISO 42001 Artificial Intelligence Lead Implementer Course
Delivered Online & In-PersonFlexible Dates
£1,200

Foundations of Immunisation and Vaccines for Non-Registered Practitioners

By Guardian Angels Training

The "Foundations of Immunisation and Vaccines for Non-Registered Practitioners" course is fully compliant with the National Minimum Standards and Core Curriculum for Immunisation Training and is designed to equip non-registered healthcare professionals with a solid understanding of immunisation concepts, vaccine administration, and the importance of vaccination in public health.

Foundations of Immunisation and Vaccines for Non-Registered Practitioners
Delivered In-Person in InternationallyFlexible Dates
£1,875

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

Beauty NVQ Level 3
Delivered In-PersonFlexible Dates
£2,499

Auditing in the Exploration & Production (E&P) Industry Level 2

By EnergyEdge - Training for a Sustainable Energy Future

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

Auditing in the Exploration & Production (E&P) Industry Level 2
Delivered in Internationally or OnlineFlexible Dates
£3,173 to £3,690

Exploration & Production (E&P) Accounting Level 3

By EnergyEdge - Training for a Sustainable Energy Future

About this training course This highly interactive 5-day training is aimed at those who wish to take their E&P accounting skills to a more advanced level than our introductory course, E&P Accounting - Level 1, and our intermediate course, E&P Accounting - Level 2. It will help equip you for more demanding analytical roles within your organisation. Training Objectives After the completion of this training course, participants will be able to: Carry out and manage the day-to-day financial accounting activities associated with participation in E&P joint ventures Prepare, analyse and present information for effective financial reporting Understand the impact of a comprehensive range of activities on the financial statements of an upstream oil and gas company Practically apply IFRS in accounting for a wide range of typical oil and gas industry activities Target Audience This is an advanced level course designed for: those who have already attended E&P Accounting - Level 1 and E&P Accounting - Level 2, or those who can demonstrate, by a combination of relevant experience and previous study, sufficient prior knowledge to contribute and benefit from attending this workshop Course Level Advanced Training Methods Training Method - Scenario Based Learning Learning centers around highly realistic E&P company scenarios. A computer-based simulation is used to plan, record and report the progress of your company through several years of international E&P activities. Teams of 2 - 3 people participate in the financial management of these activities, including Operator and Non-operator accounting, recording of transactions, updating of financial statements and analysis of results. The highly interactive laptop-based scenario approach will enable you to follow the impact of each activity from initiation through to final results and analysis of company performance. You will need to bring with you to the course your own laptop PC with MS Excel™ pre-installed. Prior knowledge of spreadsheet techniques is assumed. Trainer will provide various Excel files which participants may retain at the end of the course. 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

Exploration & Production (E&P) Accounting Level 3
Delivered in Internationally or OnlineFlexible Dates
£3,173 to £3,690

Level 3 NVQ Diploma in Wood Occupations

By BAB Business Group

The aim of the Level 3 NVQ Diploma in Wood Occupations (Construction) qualification is to recognise the knowledge, skills and competence of individuals who specialise in a wood based occupation in the construction industry eligible for the Gold CSCS Card. Upon completion of the qualification, you will be awarded the NVQ Level 3 Diploma in Wood Occupations. The qualification modules will be discussed and agreed upon with each individual candidate to ensure that the qualification will be suited to your job role. Each candidate will be allocated a designated and qualified assessor to provide support throughout the qualification and provide information, advice and guidance to candidates in order that they can achieve the qualification. If you require further information or are looking to undertake this qualification, please contact us. CSCS Cards Candidates can undertake the CSCS test and obtain the red (Provisional) CSCS card on signing up for various qualifications. The red card can usually be obtained within 7 to 14 days and can be used to access the construction sites for a period of 12 months. On completion of the qualification, candidates can upgrade or renew their CSCS Card card to the full 5 year card.

Level 3 NVQ Diploma in Wood Occupations
Delivered In-Person in Heywood or UK WideFlexible Dates
£2,050