1460 Development courses in London

PfMP® Exam Prep This is an intensive PfMP® Exam preparation course. This learning experience guides you through the multi-faceted discipline of portfolio management by focusing on the related technical, leadership, and business skills required to navigate it in the real world. First and foremost, this is an intensive PfMP® exam preparation course. Over the course, we go beyond exam prep to provide selected practice in applying key portfolio management skills, tools, and techniques. This learning experience guides you through the multi-faceted discipline of portfolio management by focusing on the related technical, leadership, and business skills required to navigate it in the real world. The journey zooms in and out between governance context and specific operational activities. The ultimate goal is practical application, with the bonus of certification along the way. What You Will Learn By the end of this program, you will be able to: Align and manage the portfolio, strategically, to satisfy organizational objectives and priorities, through benefit realization Articulate and emulate the role of a portfolio manager Apply the principles and skills of a portfolio manager to your real-world environment Study and prepare for the PfMP® Examination Apply for the certification, per the PMI PfMP Handbook and pass the initial panel review on your application Getting Started Course Overview Details of the PfMP® Certification process Foundation Concepts Projects, program, and portfolios A portfolio management process Strategy and value The role of the portfolio manager The role of key stakeholders Life cycle management The Portfolio Life Cycle Overview of Life Cycle Portfolio Management Information System (PMIS) Governance within the Portfolio Life Cycle Strategic Management Strategy concepts Supporting documentation and the strategic plan Planning and optimization Organizational risk appetite Managing strategic change Governance Management Overview and Guiding Principles The Concept of Governance Effective Design Factors Governance Roles Capacity and Capability Management Overview and Guiding Principles Capacity Management and Planning Supply and Demand (Management and Optimization) Organization Capabilities (Assessment and Development) Performance Management (Reporting, Analytics, and Balance) Stakeholder Engagement The Importance of Stakeholders Overview and Guiding Principles Definition and Identification Analysis and Planning Communications Approaches and Management Value Management Overview (Guiding Principles, Definition, and Components) Negotiating Expected Value Maximizing Value Assuring Value Realizing Value Measuring and Reporting Value A Look at Tools Risk Management Overview and Guiding Principles Portfolio Risk Planning Portfolio Risk Identification Portfolio Risk Assessment Portfolio Risk Response Examination Content Outline (ECO) Overview Structure Strategic Tasks Mapping Governance Tasks Mapping Performance Tasks Mapping Risk Tasks Mapping Communication Tasks Mapping List of Knowledge and Skills Exam Prep and Practice Overview Documenting experience Submitting the application Preparing to sit for the exam

About this Training Course The two elements which consistently remain in the forefront of every executive, tasked to manage a project, are 'Cost' and 'Time'. There is probably no disagreement or a need to prove that a strong correlation exists between Cost and Schedule. The mechanics of capturing cost during the execution is not that difficult a task, as it is when undertaking Design, Engineering, Estimating, Planning, Scheduling, and seeking financing for the project. The corporate management is expected to provide realistic, reliable and risks adjusted projections of a project's overall financial performance. This 3 full-day course and workshop is developed to make the delegates walk through the engineering formulas and equations to become a professional in managing estimates, projections, risks, uncertainties and secure financing for high value, high risk projects, from both On-shore and Offshore Oil & Gas industry segments. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Objectives of this Training Course: This course and the workshops are developed for the participants to gain comprehensive understanding of the field of Cost Engineering and its impact on the project execution, financing and risk management. The underlying objectives are: Enhance familiarization with mechanics of cost engineering in developing budgets and Project Cost Models. Gain understanding of diversity in financing of EPC Projects in context of Offshore and Onshore Oil & Gas projects in international arena. Identify risks associated with cost estimates and costing elements, with an objective of developing project strategies and minimizing the exposure to escalation of prices and market factors. Appreciate the correlation between cost and schedule, resulting in the delivery of contractual obligations. Develop competency to manage risks of costs and time overrun, by implementing appropriate cost control mechanism. Target Audience If you are responsible for undertaking one or more of the following functions in the Oil & Gas and Offshore & Marine Industry, you can't afford to miss this course: Management Accountants, Finance Managers, Cost Controllers, Project Directors, Contracts & Projects Managers, Estimators, Planners and Risk Managers. Course Level Intermediate Training Methods Unique Features of this Enhanced Course Curriculum: This course and the workshops are developed for the participants to gain comprehensive understanding of the field of Cost Engineering and its impact on the project execution, financing and risk management. The underlying objectives are: Enhance familiarization with mechanics of cost engineering in developing budgets and Project Cost Models. Gain understanding of diversity in financing of EPC Projects in context of Offshore and Onshore Oil & Gas projects in international arena. Identify risks associated with cost estimates and costing elements, with an objective of developing project strategies and minimizing the exposure to escalation of prices and market factors. Appreciate the correlation between cost and schedule, resulting in the delivery of contractual obligations. Develop competency to manage risks of costs and time overrun, by implementing appropriate cost control mechanism. Trainer Principal Management Consultant Chartered Valuer and Appraiser (CVA) FACICA | FAMTAC | FAIADR | M.S.I.D | Member, AIEN LL.M. (IP Law), M. Sc. (Maritime Studies), M. Tech (Knowledge Engineering), MBA, First Class CoC (MCA, UK), B. E. (Elect) Your expert course leader, during the last 47 year period, has worked and consulted in the industry verticals encompassing: Technology, Oil & Gas Exploration & Production, Petrochemical Process Plants and Power Plant Construction Projects, Logistics & Warehousing, Marine, Offshore, Oil & Gas Pipelines, Infrastructure Development Projects (Ports, Offshore Supply Bases, Oil & Gas Terminals and Airports etc), EPCIC Contracts, and Shipyards, in South East Asia, Africa, Middle East, Americas and Europe. He serves as the Principal Management Consultant with a management consultancy in Hong Kong and Singapore, specialising in the fields of corporate management consultancy, international contracts reviews and alternative dispute resolutions services. He undertakes special assignments for conducting audits and valuation of intangible properties involving proprietary processes for licensed production, and licensing of intellectual property rights (IP Rights) in patents, trademarks, and industrial designs. He is frequently engaged for assignments like due diligence, acquisitions, mergers, resolving various operational issues, technology transfer and agency services contracts reviews, cost controls, and enhancement of Supply Chain Management. He has been conferred the credentials of Chartered Valuer & Appraiser (CVA) by SAC and IVAS, in accordance with the international valuation standards setting body IVSC. His consulting experience includes Charterparty Management, Business Process Re-engineering, Diversifications, Corporate Development, Marketing, Complex Project Management, Feasibility Studies, Dispute Resolutions and Market Research. He has successfully assisted Marine and offshore E & P clients in managing contractual disputes arising from various international contracts for upgrading & conversion projects. He continues to be actively engaged in claims reviews, mediation, arbitration, litigation, and expert witness related assignments, arising from international contracts and Charterparty Agreements. He graduated with a Bachelor's degree in Electrical Engineering, MBA in General Management, Master of Technology in Knowledge Engineering, Master of Science in Maritime Studies, and LL.M. (IP Law). He also holds professional qualifications in Business Valuations and Appraisers for CVA, arbitration, law, and marine engineering, including the Chief Engineer's First-Class Certificate of Competency (MCA, UK). He is further qualified and accredited as Certified International Arbitrator, Chartered Arbitrator, Sports arbitrator under CAS Rules, WIPO Neutral, Australian Communications and Media Authority (ACMA) Bargaining Code Arbitrator, Accredited Adjudicator and Accredited Mediator (Malaysia). He is admitted to the international panels of arbitrators and neutrals with WIPO, Geneva; ACICA, AMTAC and ACMA, Australia; BVIAC (British Virgin Islands); JIAC (Jamaica); HKIAC Hong Kong; AIAC, Malaysia; AIADR, Malaysia; KCAB, Seoul, South Korea; ICA, Delhi, India; ICC (Singapore); SISV, Singapore; SCMA, Singapore; SCCA, Saudi Arabia; VIAC Vienna, Austria; Thailand Arbitration Centre (THAC), and Mediator with AIAC Malaysia, CMC, and SIMI Singapore. 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

AgilePM® Practitioner This course offers preparation for the Practitioner-level examination to gain the APMG-International™ / Agile Project Management Practitioner Certification. Agile Project Management (AgilePM) is the result of collaboration between APMG-International and The DSDM Consortium. DSDM (Dynamic Systems Development Method) is the longest-established Agile method, launched in 1995, and is the only Agile method to focus on the management of Agile projects. The method has evolved over the years and the DSDM Agile Project Framework is the latest version of which AgilePM is a subset. DSDM has always operated predominantly in the corporate environment and has consistently demonstrated its ability to successfully work with and complement existing corporate processes. APMG-International is a global Examination Institute accredited by The APM Group Ltd. It is one of the Examination Institutes accredited by AXELOS. APMG-International has regional offices located in Australia, China, Denmark, Germany, the Netherlands, Malaysia, the United States, and the United Kingdom. Their portfolio of qualifications includes the Best Practice qualifications of ITIL®, PRINCE2®, MSP®, M_o_R®, and P3O®. AgilePM is one of their specialist management qualifications, which also include Change Management and Service Catalogue. The course covers all the Practitioner elements of the AgilePM Handbook v2 with: Clear explanations of the method and practical examples provided by your course tutor Sample exam paper for the Practitioner-level exams to enrich your knowledge and understanding A case study to allow you to practice the application of the method to an agile project The Traditional Classroom option includes the Practitioner exam to provide you with the right opportunity to verify your new skill set by way of a professional qualification The Virtual Classroom option includes a Practitioner exam voucher to allow you to choose the date and time of your online exam to verify your new skill set by way of a professional qualification What You Will Learn You will learn how to: Identify and apply the concepts, tools, and techniques described in Section 2 (Digging Deeper) of the APMG-International's Agile Project Management Handbook (v2.0) to agile projects Tailor and customize AgilePM to suit the needs of different projects Use AgilePM in conjunction with other project management methods such as PRINCE2® Prepare yourself for the Practitioner exam in AgilePM Roles and Responsibilities - The PM View The roles Key project manager relationships Agile Project Management - Through the Lifecycle The DSDM process and the project lifecycle Project management focus phase by phase The Effective Use of Products The products Deliver on Time - Combining MoSCoW & Timeboxing Ensuring effective prioritisation Bringing MoSCoW and timeboxing together People, Teams, and Interactions Effective communication Collaboration Requirements and User Stories What is a requirement? User stories Estimating - How and When Coping with uncertainty Estimating through the lifecycle Project Planning through the Lifecycle Planning in a DSDM project Planning activities phase by phase Quality - Never Compromise Quality What do we mean by quality? Solution and process quality Risk Management Project risk How DSDM helps mitigate project risk Tailoring the Approach The project approach questionnaire Summary and Next Steps

Build confidence & capability and engage in meaningful dialogue about race.

About this Training Course Managing process hazards in the hydrocarbon and chemical processing industries is a critical function that requires relevant knowledge and skills due to the risks involved. The Advanced Process Safety Engineering course will discuss the interrelation of the various techniques of process safety for analysing, with a particular emphasis on engineering design aspects, as well as how to manage process hazards in a safe and effective way and how they can potentially be avoided. In this 3 full-day advanced level course, the expert course leader will provide participants with insights and examples from his career and experience to show how their learning should be applied in real-life situations. Feedback and questioning is highly encouraged. Reference material and reports can be provided to give more information on any particular topic of interest. Individual and group exercises, tutored exercises and video case studies will be provided throughout the course to underpin the key learning points. Training Objectives Upon completion of this course, participants will acquire in-depth knowledge of: Risk management and 'As Low as Reasonably Practicable' (ALARP) principles. Different aspects of process design that influence process safety. Approach to 'inherently safer' design. Defence in depth using 'layers of protection'. Process for ensuring the technical integrity of safety-critical equipment. Hazards associated with process materials. Range of hazard identification and consequence modelling techniques. Causes and mitigation of human error. Reliability and availability of safety-critical protection equipment. Role of engineered safety-critical equipment and systems. Target Audience This course is suitable for industry professionals who need to acquire a comprehensive understanding of process safety. This includes those who are required to make managerial decisions where process safety is a key consideration, those who are moving into process safety positions or those who wish to broaden their process safety knowledge within their existing discipline. It is particularly suited for anyone involved in the design, operation, modification or maintenance of a major hazard installation, and will demonstrate a substantial understanding of process safety for those engaged in Continuous Professional Development or aiming for Chartered Engineer status. This course will benefit professionals such as: Operations and maintenance supervisors Process, mechanical and chemical engineers and technicians Design engineers, project engineers and HSE managers Control, automation and instrumentation engineers Course Level Advanced Trainer Your expert course leader has 50 years' experience in chemical and process safety engineering. His early career included 20 years in design and project engineering with various fine chemical and pharmaceutical companies where he designed chemical processes, specified plant equipment and selected materials for highly corrosive and toxic processes, often where textbook data was not available. This was followed by 10 years in offshore oil and gas design projects where he was responsible for setting up a Technical Safety group to change design safety practices in the aftermath of the 1988 Piper Alpha disaster. In recent years, he has been called upon to conduct various offshore and onshore incident investigations. His career has given him experience in project engineering, project management, process design and operations, safety engineering and risk management. He is a Fellow of the UK Institution of Chemical Engineers. He served on the Scottish Branch committee, and was elected chairman for a two-year term in 1991. He has also been chairman of the Safety and Reliability Society - North of Scotland Branch. He has delivered training courses in Process Hazard Analysis (HAZOP and HAZID), Process Safety Management, Hazard Awareness, Risk Assessment, Root Cause Analysis, Failure Modes & Effect Analysis and has lectured on Reliability Analysis to the M.Sc. course in Process Safety and Loss Prevention at Sheffield University. In addition to delivering training courses, he currently facilitates HAZOP / HAZID / LOPA studies and undertakes expert witness roles advising lawyers engaged in contractual disputes, usually involving the design or construction of chemical plants or Oil & Gas production facilities, or criminal prosecutions. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

About this Virtual Instructor Led Training (VILT) A large amount of geological data is acquired at a substantial cost when carrying out a drilling operation. Ensuring optimal quality of this information and effective reporting plays a key role during well design and drilling operations. In addition, there is much to benefit from the later usage of the data in field studies. A critical component that ensures favourable and positive results is the close co-operation between geological, drilling and well engineering departments. Comprising 5 half-day sessions, this Virtual Instructor Led Training (VILT) course aims to provide the required knowledge in order for the collaboration to be most effective and successful. This VILT course will comprise lectures interspersed with practical and interactive exercises and quizzes to promote better understanding. Training Objectives At the end of this VILT course, participants will be able to: Understand the techniques used by wellsite geologists in formation evaluation via: Quick-look analysis to assess reservoir and hydrocarbons Mudlog data (lithology/cutting description, gas readings) Grasp the application of wellsite data in exploration and development Be able to read, assess and use drilling reports Acquire an understanding of drilling problems caused by subsurface conditions Understand the role and contributions of the geologist to the well maturation process Target Audience This VILT course is intended for geologists and other subsurface staff involved in drilling operations who would like to work and communicate more effectively with wellsite staff.  Please note that this VILT course is not a preparation course for a wellsite assignment. To be able to work independently on the wellsite, a more hands-on or on-site training would be required. Training Methods This VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Your expert course leader has close to 20 years of experience as a geologist in the Oil & Gas industry. Her main interest and passion is in well planning and operations. She had previously worked as a production geologist and technical authority in NAM (Netherlands), and as a discipline advisor tasked to coach young staff in Bangalore. She has been active in internal training sessions on drilling hazards, mudwindow assessment and project management. She obtained an MSc in hard rock structural geology from the University in Utrecht, a PhD at Brown University (RI, USA) and a post-doctoral at the RWTH Aachen. 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

AgilePM® Practitioner: In-House Training This course offers preparation for the Practitioner-level examination to gain the APMG-International™ / Agile Project Management Practitioner Certification. Agile Project Management (AgilePM) is the result of collaboration between APMG-International and The DSDM Consortium. DSDM (Dynamic Systems Development Method) is the longest-established Agile method, launched in 1995, and is the only Agile method to focus on the management of Agile projects. The method has evolved over the years and the DSDM Agile Project Framework is the latest version of which AgilePM is a subset. DSDM has always operated predominantly in the corporate environment and has consistently demonstrated its ability to successfully work with and complement existing corporate processes. APMG-International is a global Examination Institute accredited by The APM Group Ltd. It is one of the Examination Institutes accredited by AXELOS. APMG-International has regional offices located in Australia, China, Denmark, Germany, the Netherlands, Malaysia, the United States, and the United Kingdom. Their portfolio of qualifications includes the Best Practice qualifications of ITIL®, PRINCE2®, MSP®, M_o_R®, and P3O®. AgilePM is one of their specialist management qualifications, which also include Change Management and Service Catalogue. The course covers all the Practitioner elements of the AgilePM Handbook v2 with: Clear explanations of the method and practical examples provided by your course tutor Sample exam paper for the Practitioner-level exams to enrich your knowledge and understanding A case study to allow you to practice the application of the method to an agile project The Traditional Classroom option includes the Practitioner exam to provide you with the right opportunity to verify your new skill set by way of a professional qualification The Virtual Classroom option includes a Practitioner exam voucher to allow you to choose the date and time of your online exam to verify your new skill set by way of a professional qualification What You Will Learn You will learn how to: Identify and apply the concepts, tools, and techniques described in Section 2 (Digging Deeper) of the APMG-International's Agile Project Management Handbook (v2.0) to agile projects Tailor and customize AgilePM to suit the needs of different projects Use AgilePM in conjunction with other project management methods such as PRINCE2® Prepare yourself for the Practitioner exam in AgilePM Roles and Responsibilities - The PM View The roles Key project manager relationships Agile Project Management - Through the Lifecycle The DSDM process and the project lifecycle Project management focus phase by phase The Effective Use of Products The products Deliver on Time - Combining MoSCoW & Timeboxing Ensuring effective prioritisation Bringing MoSCoW and timeboxing together People, Teams, and Interactions Effective communication Collaboration Requirements and User Stories What is a requirement? User stories Estimating - How and When Coping with uncertainty Estimating through the lifecycle Project Planning through the Lifecycle Planning in a DSDM project Planning activities phase by phase Quality - Never Compromise Quality What do we mean by quality? Solution and process quality Risk Management Project risk How DSDM helps mitigate project risk Tailoring the Approach The project approach questionnaire Summary and Next Steps

About this Virtual Instructor Led Training (VILT) This course will provide a comprehensive, foundational content for a wide range of topics in power system operation and control. With the growing importance of grid integration of renewables and the interest in smart grid technologies, it is more important than ever to understand the fundamentals that underpin electrical power systems. This course provides a thorough understanding of all basic terminology and concepts of electrical systems, structure of a power system, transmission line parameters, insulators, high-voltage direct current transmission, substation and neutral grounding, distribution system, circuit breakers, relaying and protection, power system stability, economic operation of power systems, load frequency control, voltage and reactive power control, renewable energy sources, restructuring of electrical power systems, and smart grids. This course is a MUST for practitioners, consultants, engineers of all disciplines, managers, technicians and all technical personnel who need to learn about electrical power systems. Training Objectives Basic Terminology and Concepts of Electrical Systems: Gain an understanding of the basic terminology and concepts of electrical systems and the structure of a power system Transmission Line Parameters: Learn in detail all the transmission line parameters including line resistance, line inductance, transposition of transmission lines, and capacitance of transmission lines Insulators: Understand thoroughly all the various types of insulators, pin type insulators, suspension type or disc insulators, strain insulators, and testing of insulators High-Voltage Direct Current Transmission: Determine the advantages and disadvantages of high voltage direct current transmission, and gain an understanding of all the features of high-voltage direct current transmission Substations and Neutral Grounding: Gain a detailed understanding of all substation equipment, factors governing the layout of substations, station transformers, elements to be earthed in a substation, power system earthing, earthing transformers, bus bar arrangements and gas-insulated substations Distribution System: Learn about the effects of voltage on the conductor volume, distributor fed from one end, distributors fed from both ends at the same voltage, distributors fed from both ends at different voltages, and alternating current distribution Circuit Breakers: Learn about the classification of circuit breakers, plain-break oil circuit breakers, air break circuit breaker, air blast circuit breakers, vacuum circuit breakers, SF6 circuit breakers, rating and testing of circuit breakers Relaying and Protection: Learn all the requirements of relaying, zones of protection, primary and backup protection, classification of relays, electromagnetic relays, induction relays, feeder protection, phase fault protection, reactance relay, static overcurrent relay, differential protection, transformer protection, Buchholz relays, alternator protection restricted earth fault protection, rotor earth fault protection, and negative-sequence protection Economic Operation of Power Systems: Gain an understanding of steam power plants, heat rate characteristics and characteristics of hydro plants Load Frequency Control: Learn about speed governing mechanism, speed governor, steady state speed regulations and adjustment of governor characteristics Voltage and Reactive Power Control: Gain an understanding of impedance and reactive power, system voltage and reactive power, voltage regulation and power transfer Renewable Energy Sources: Learn about solar power, wind power, geothermal energy, biomass and tidal power Restructuring of Electrical Power Systems: Gain an understanding of smart grids, smart grid components, smart grid benefits, and open smart grid protocol Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Training Methods The VILT will be delivered online in 5 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. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. The instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all the delegates 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 to their own organization. Each delegate will receive a copy of the following materials written by the instructor: 'ELECTRICAL EQUIPMENT HANDBOOK' published by McGraw-Hill in 2003 (600 pages) Introduction to Power Systems Manual (500 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Organisations are essentially about people working together and yet so often they fail to capitalise upon the full potential of this.