Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements. Hands-on, Practical MySQL Course Intermediate. PCWorkshops MySQL Course Intermediate Certificate. Max 4 people per course, we keep it personalised.
GDPR Practitioner
This highly practical workshop will help you become a more effective negotiator and learn the skills that master negotiators use.
About this Virtual Instructor Led Training (VILT) The objective of this 4-half-day Virtual Instructor Led Training (VILT) course is to equip participants with the required knowledge so that they can define and implement an effective oil analysis programme, monitor the condition of transformers and understand oil analysis reports as part of their maintenance strategy. This VILT course is delivered in partnership with ENGIE Laborelec. Training Objectives Participants will be able to go through the following areas during the VILT course: Condition monitoring of power transformers through oil analyses: Transformer Health Index, Transformer Fleet Condition Assessment, Risk Matrix Best practices Which oil analyses/how frequent DGA: focus on partial discharges, sparking, stray gassing, catalytic effects / interpretation systems. Interpretation of results Why and when to perform electrical measurements? International standards: IEEE, IEC, Duval, ASTM, etc Maintenance guidelines Trending and reporting Sampling techniques Use of online monitoring for DGA/water: implementation and real-case advantages etc: New developments: importance of methanol as ageing marker, temperature correction of ageing markers, stray gassing of oils in service etc REX, case studies and real-case exercises concerning power transformers within generation and high-voltage grids Discussion of reports on power transformers Use of unused insulating transformer oils Market trends in the use of inhibited and uninhibited oils Differences, advantages and drawbacks of uninhibited compared with inhibited oils Importance of additives, oxidation stability tests, stray gassing, etc Target Audience The VILT course is intended for a wide audience, including professionals who are maintenance staff, electrical engineers and asset managers responsible for transformers. Typical industries are powerplants, high voltage grids or large industrial sites. 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 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). This VILT course is delivered in partnership with ENGIE Laborelec. Trainer Your expert course leader is a senior expert in the field of insulating and lubricating oils and of condition monitoring of power transformers and turbines. He has 20 years of experience within power industry and since 2010 Key Expert within the ENGIE group. He has worked on various international projects such as the Al Dur power plant in Bahrain, Shuweihat II power plant in UAE, PP11 and Jubail Marafiq power plants in Saudi Arabia and Sohar II and Barka III power plants in Oman. He has also been involved in consulting work in Malaysia for Hyrax Oil. Other assignments include Shell, Nynas, Total, ABB, Alstom, CG Pauwels in Europe. 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
The ISO 31000 Risk Manager training course helps participants acquire the knowledge necessary and ability to integrate the risk management guidelines of ISO 31000 in an organization. It provides information with regard to the risk management principles and their application, as well as the core elements of the risk management framework and steps for a risk management process. In addition, it provides the basic approaches, methods, and practices for assessing risk in a wide range of situations. Upon completion of the training course, you can sit for the exam and gain the "Certified ISO 31000 Risk Manager' credential. The credential demonstrates your knowledge and ability to apply the risk management process in an organization based on the guidelines of ISO 31000 and best practices. Who Should Attend? Managers or consultants responsible for the effective management of risk in an organization Individuals seeking to gain knowledge about the risk management principles, framework, and process Individuals responsible for the creation and protection of value in their organizations Individuals interested in pursuing a career in risk management About This Course Learning objectives Understand the risk management concepts, approaches, methods, and techniques Learn how to establish a risk management framework in the context of an organization Learn how to apply the ISO 31000 risk management process in an organization Understand the basic approaches, methods, and practices used to integrate risk management in an organization Educational approach The training course is based on theory and best practices used in risk management. Lecture sessions are illustrated with practical examples. The participants are encouraged to communicate and engage in discussions and exercises. The exercises are similar in structure with the certification exam questions. Course agenda Day 1: Introduction to ISO 31000 and risk management and establishing the risk management framework Day 2: Initiation of the risk management process and risk assessment based on ISO 31000 Day 3: Risk treatment, recording and reporting, monitoring and review, and communication and consultation according to ISO 31000; the examination. Prerequisites A foundational understanding of ISO 31000 and knowledge of risk management What's Included? Official Study materials Coffee's/Teas, refreshments and Lunch (Classroom courses only) The Exam fees Our Guarantee We are an approved IECB Training Partner. You can learn wherever and whenever you want with our robust classroom and interactive online training courses. Our courses are taught by qualified practitioners with commercial experience. We strive to give our delegates the hands-on experience. Our courses are all-inclusive with no hidden extras. The one-off cost covers the training, all course materials, and exam voucher. Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. Our Promise: Pass first time or 'train' again for FREE. *FREE training and exam retake offered Accreditation Assessment The examination is delivered in a 10 question essay type format, to be completed within 125 minutes and with a 70% pass mark. Exam results are provided within 24 hours. Provided by This course is Accredited by NACS and Administered by the IECB.
Legal Writing and Drafting Skills Why Attend There is a misconception that legal writing and legal drafting is the same but there is a substantial difference between the two. While legal writing typically deals with persuasive documents such as court briefs and legal letters, legal drafting involves creating documents such as contracts. They are both equally important in legal practice. Legal writing is an important skill needed in every practice area of law. Words are used to advocate, inform, persuade and instruct. Are you giving the right impression? Are your clients receiving the right message? This course focuses on clear legal writing for a global audience. Effective communication with English speaking lawyers is about more than simply words. It entails understanding the unique way these speakers think and approach the legal, political, and business world. Did you know that most international commercial agreements are drafted in English, irrespective of the nationality of the contracting parties. Drafting contract skills is ideal for lawyers working in English as a foreign language who need to draft, explain or interpret contract clauses written in English. During the course, delegates will look at a wide variety of commercial agreements through to practical drafting sessions. This course will help participants to draft confidently and effectively in English regardless of the governing law. This is a practical course with many exercises and examples in order to achieve an interactive and stimulating outcome. The course's activities involve the production of typical work-place legal documents. Course Methodology The course consists of group discussions as well as individual and team tasks. There will be writing practice throughout the exercises. Course Objectives By the end of the course, participants will be able to: Apply plain English style of writing to all legal documents Recognize the need for legal clarity in different types of legal documents: legal letters, emails, memorandum and opinions Apply good legal writing practice Demonstrate the register of legal writing Correct common mistakes in legal writing Dispense and deal with pitfalls and issues relating to the use of legal jargon Proofread effectively Target Audience This course is for lawyers, legal secretaries, commercial managers, contract managers and anyone who must draft, amend or update contracts, legal letters and legal opinion. The course is suitable for non-native English speakers looking for a better understanding of English legal terms. Target Competencies Drafting letters Proofreading Writing in plain English Understanding legal terms Legal writing practice Note The Dubai Government Legal Affairs Department has introduced a Continuing Legal Professional Development (CLPD) programme to legal consultants authorised to practice through a licensed firm in the Emirate of Dubai. We are proud to announce that the Dubai Government Legal Affairs Department has accredited EMG Associates as a CLPD provider. In addition, all our legal programmes have been approved. Legal Drafting Signs of a well drafted contract: The simple rules! The language of drafting: Will v Shall v Must Identifying the legal formalities for a binding contract Structure and formation of a commercial contract: follow the formula and you won't go wrong The importance of Boilerplate clauses: No waiver Notices Assignment v Novation Governing v Jurisdiction Force majeure - are we covered for viruses (covid19)? Dispute resolution clause: Litigation v Arbitration v Mediation The preliminary documents in international transaction - using Heads of Terms effectively Vague words and expressions in commercial contracts- know the pitfalls! Best endeavors v All reasonable endeavors v reasonable endeavors Overview of cross border contracts: Distribution v Joint venture v Agency agreements Share Purchase Agreements Warranties and indemnities Allocating risks and liabilities between the buyer and seller Negotiating warranties from a Share Purchase Agreement Plain English in Legal Correspondence Good legal writing practice Moving from legalese to Plain English Unnecessary archaic and meaningless phrases Collocations Importance of collocations in legal writing Pitfalls and issues relating to the use of legal jargon in legal writing Writing short emails Writing long emails Writing formal emails Writing A Legal Letter Layout of a letter Body of a letter Putting a letter together The register of letter writing Typical sentences in legal letters The letter writing clinic: looking at the ten most common problems Rewriting letters Rewriting informal sentences to modern alternatives Correcting common mistakes in letter writing Legal Writing Troubleshooting The problem of English idioms Rephrasing English idioms Easily confused words Cutting unnecessary words Use of consistent terminology Ambiguity: how to avoid it Vagueness: how to avoid it Misuse of preposition in dates Problem words Constantly litigated words Rewriting sentences to remove gender specific language
Qigong Taiji 37 (Tai Chi) Daoyin exercises Makko-Ho and Do-in exercises Japanese Ki Exercises and Hara training Breathing and sound exercises Meditation Well-being guidance There are also currently 3 online Qigong classes each week: Mondays at 9.45am, or Tuesdays and Fridays at 10.00am, all 75 minutes. When you use the link there is usually no need to sign up to Zoom. You can use the app or attend via your usual browser. No experience necessary.
ISO 22301 Lead Auditor training enables you to develop the necessary expertise to perform a Business Continuity Management System (BCMS) audit by applying widely recognized audit principles, procedures and techniques. About This Course During this training course, you will acquire the knowledge and skills to plan and carry out internal and external audits in compliance with ISO 19011 and ISO/IEC 17021-1 certification process. Based on practical exercises, you will be able to master audit techniques and become competent to manage an audit program, audit team, communication with customers, and conflict resolution. After attending this 4 day course, candidates can sit for the exam with the aim of gaining the "ISO22301 Lead Auditor' credential. You will then be in a position to demonstrate that you have the capabilities and competencies to audit organizations based on best practices. Learning objectives Understand the operations of a Business Continuity Management System based on ISO 22301 Acknowledge the correlation between ISO 22301 and other standards and regulatory frameworks Understand an auditor's role to: plan, lead and follow-up on a management system audit in accordance with ISO 19011 Learn how to lead an audit and audit team Learn how to interpret the requirements of ISO 22301 in the context of a BCMS audit Acquire the competencies of an auditor to: plan an audit, lead an audit, draft reports, and follow-up on an audit in compliance with ISO 19011 Educational approach This training is based on both theory and best practices used in BCMS audits Lecture sessions are illustrated with examples based on case studies Practical exercises are based on a case study which includes role playing and discussions Practice tests are similar to the Certification Exam Prerequisites A foundational understanding of ISO 22301 and knowledge of audit principles. What's Included? Refreshments & Lunch (Classroom courses only) Course Slide Deck Official Study Materials CPD Certificate The Exam fees Who Should Attend? Auditors seeking to perform and lead Business Continuity Management System (BCMS) certification audits Managers or consultants seeking to master a Business Continuity Management System audit process Individuals responsible for maintaining conformance with Business Continuity Management System requirements Technical experts seeking to prepare for a Business Continuity Management System audit Expert advisors in Business Continuity Management Our Guarantee We are an approved IECB Training Partner. You can learn wherever and whenever you want with our robust classroom and interactive online training courses. Our courses are taught by qualified practitioners with commercial experience. We strive to give our delegates the hands-on experience. Our courses are all-inclusive with no hidden extras. The one-off cost covers the training, all course materials, and exam voucher. Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. Our Promise: Pass first time or 'train' again for FREE. *FREE training offered for retakes - come back within a year and only pay for the exam. Assessment The exam is a 12 question essay type exam completed in the afternoon of Day 4. The pass mark for the exam is 70%. Exam results are provided within 24 hours. Provided by This course is Accredited by NACSand administered by the IECB. Accreditation
About this Training Course On a day-to-day basis, one of the most common technologies utilised in well intervention is Coiled Tubing. This is prevalent in the oil industry and the technology is used during drilling, completion and production phases of Oil & Gas wells worldwide. This 5 full-day course will look at the following areas: Equipment for surface and pressure control Assembly components for bottom-hole Details of the different types of interventions performed with Coiled Tubing, and How to deal with fatigue and corrosion. The aim of this course is to enable the participants to gain key knowledge that they will require to actively and efficiently participate in the planning, design, and / or execution of a Coiled Tubing intervention. With this, the participants will learn how to calculate the string operating limits and the volumes and rates during nitrogen interventions. The course will walk the participants through the emergency responses and contingencies to deal with in various scenarios. Time will be allocated for the participants to work on the practical exercises as well as real field cases and problems. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By the end of the course, the participants will be able to: Plan, design, manage and execute interventions for Coiled Tubing Enhance operational performance during interventions for Coiled Tubing Explain the recommended equipment for various Coiled Tubing field conditions and applications Discuss the proper pressure control equipment for any particular well condition Learn about the most commonly used downhole tools and explain their function Understand how to calculate and define string limits for Coiled Tubing Learn how to work safely with liquid nitrogen Target Audience This course is aimed at Drilling and completion engineers Production engineers Surface/subsurface engineers Operations engineers Service company managers Field engineers This course will also benefit professionals who would like to increase their knowledge in the planning, design and/or execution of Coiled Tubing and Liquid Nitrogen interventions. Course Level Basic or Foundation Training Methods Other than the daily quizzes to reinforce the materials presented in the session, the participants will work through exercises such as: Selecting suitable BHAs for various operations Rigging up equipment in the correct order and preparing an outline testing programme Carrying out suitable calculations to perform an N2 lift Preparing an outline programme for a balanced cement plug Identifying issues in various videos & photos and suggesting mitigations Basic N2 safety quiz Final exercise will be preparing an outline programme for a Proppant Clean out, including a detailed Risk Register and Mitigation options Trainer Your expert course instructor 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
ITIL® 4 Strategist: Direct, Plan and Improve: In-House Training The ITIL® 4 Strategist: Direct, Plan, and Improve course is based on the ITIL® 4 Strategist Direct, Plan, and Improve candidate syllabus from AXELOS. This course is based on the ITIL® 4 Strategist: Direct, Plan and Improve IT exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. This course provides the practical skills necessary to create a 'learning and improving' IT organization, with a strong and effective strategic direction. It was designed to provide practitioners with a practical and strategic method for planning and delivering continual improvement with necessary agility. It covers both practical and strategic elements, making it the universal module that is a key component to both ITIL® 4 Managing Professional and ITIL® 4 Strategic Leader streams. What You Will Learn At the end of this course, participants will be able to: Understand the key concepts of direction, planning, improvement Understand the scope of what is to be directed and/or planned and know how to use key principles and methods of direction and planning in that context Understand the role of GRC and know how to integrate the principles and methods into the service value system Understand and know how to use the key principles and methods of continual improvement for all types of improvements Understand and know how to use the key principles and methods of Communication and Organizational Change Management to direction, planning and improvement Understand and know how to use the key principles and methods of measurement and reporting in direction, planning, and improvement Understand and know how to direct, plan, and improve value streams and practices Course Introduction Let's Get to Know Each Other Course Overview ITIL® 4 Certification Scheme Course Learning Objectives Course Components Course Agenda Exercises Case Study: Axle Car Hire Case Study: HandyPerson on Demand Exam Details Core Concepts of DPI Key Terms Covered in the Module Module Learning Objectives Basics of Direction Basics of Planning Basics of Improvement Other Core Elements DPI through Service Value Chain and Guiding Principles Key Terms Covered in the Module Module Learning Objectives DPI of the SVS DPI of Guiding Principles Role of Direction in Strategy Management Key Terms Covered in the Module Introducing Strategy Management Developing Effective Strategies Implementation of Strategies Key Terms Covered in the Module Module Learning Objectives Managing Risks Making Decisions through Portfolio Management Directing via Governance, Risk, and Compliance (GRC) Introduction to Assessment and Planning Key Terms Covered in the Module Module Learning Objectives Core Concepts of Assessment Conducting Effective Assessments Core Concepts of Planning Assessment and Planning through VSM Key Terms Covered in the Module Module Learning Objectives Introducing VSM Developing Value Stream Maps Knowing More About VSM Measurement, Reporting, and Continual Improvement Key Terms Covered in the Module Module Learning Objectives Measurement and Reporting Alignment of Measurements and Metrics Success Factors and Key Performance Indicators Continual Improvement Measurements and Continual Improvement through Dimensions and SVS Key Terms Covered in the Module Module Learning Objectives Measurements for the Four Dimensions Continual Improvement of the Service Value Chain and Practices OCM Principles and Methods Key Terms Covered in the Module Module Learning Objectives Basics of OCM OCM throughout DPI and Service Value Chain Resistance and Reinforcement Communication Principles and Methods Key Terms Covered in the Module Module Learning Objectives Basics of Effective Communication Communication with Stakeholders SVS Development Using Four Dimensions Key Terms Covered in the Module Module Learning Objectives Organizations and People in the SVS Partners and Suppliers in the SVS Value Streams and Processes in the SVS Information and Technology in the SVS