Name: Gas Turbines, Co-Generation and Combined Cycle Power Plants
Price: 3009 GBP
Availability: InStock

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong><em> </em></h2>
<p>This 3 full-day course covers the design of systems for natural gas handling and treatment from the wellhead to the gas processing plant to achieve marketable products that meet desired product specifications.</p>
<p>This course will emphasize on field handling equipment and separation systems, dehydration, fluid measurement, sampling and analysis as well as introduction into reciprocating and centrifugal compressors. It will comprise interactive presentations including exercises/quizzes.</p>
<p>This course can also be offered through Virtual Instructor Led Training (VILT) format.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>At the end of the course, the participants will be able to describe and explain the following:</p>
<ul>
<li>Gas processing principles of dehydration (water removal) by absorption, adsorption, refrigeration and low temperature separation (JT effect) and basic associated equipment</li>
<li>Gas processing in-depth by absorption using glycol and glycol proper (Pre- Cooling requirements, Dew Point control and related processes). Glycol regeneration including principles of stripping, DRIZO and Coldfinger.</li>
<li>Process equipment involved for water removal by absorption. (Knock out drums; Contactor - absorber and internals, heat exchangers, re-boilers, pumps, filters and glycol storage).</li>
<li>Principles of gas metering and types of meter (Measurement Units (MJ, BTU, nM3, scf and conversions).</li>
<li>Typical gas contracts &amp; sales specifications.</li>
<li>Gas pipeline operations.</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>Production and processing personnel involved with natural gas and associated liquids to acquaint or reacquaint themselves with gas conditioning and processing unit operations. This course is for <strong>production operations engineers, operations field supervisors, facility engineers, process engineers, design engineers, operations personnel and others who select, design, install, evaluate or operate gas processing plants and related facilities</strong>.</p>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Intermediate</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader has more than 25 years of accumulated experience in the Oil &amp; Gas Industry, particularly in LNG / Offshore LNG Industry as Project Manager (8 years) and Process Technology Design (12 years). From 2010 to 2012, he worked for TOTAL E&amp;P as Manager of R&amp;D activities related to LNG, FLNG, Gas Treatment and Safety Engineering. From 1992 to 2010, he worked for Technip, spending 12 years (1992 to 2004) in the Process and Technology Division, where he was the Principal Engineer on gas treatment and LNG projects such as Yemen LNG and Nigeria LNG. From 2004 to 2010, he was actively involved in the development of Technip Offshore LNG technologies as Project Manager - several patents filed, author or co-author of different publications on LNG transfer technologies.</p>
<p>He has also been a member of:</p>
<ul>
<li>the Foreign Advisory Committee on the 2nd Trondheim Technology Gas Conference, Norway, 2-3 November 2011</li>
<li>the Steering Committee on the SPE Forum 'Economic and Sustainability Challenges in the Future Development of Sour Gas', Bali, Indonesia, 8-13 May 2011</li>
<li>The Technip 'Experts Network' as 'Main Expert - LNG' for several years</li>
</ul>
<p>He holds a 'summa cum laude' master's degree in Chemical Engineering from Rome University 'La apienza' (1992) and has been a member of the Italian Register of Engineers.</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>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.<br />
Request for further information about post training coaching support and fees applicable for this.</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Gas Conditioning and Processing

Team of 10, pp

Normal Fee, pp

<div>
</div>
<section>
<div>
<h2>About this Training</h2>
<p>Front End Loading (FEL) is a methodology that takes a deliberate approach to capital project planning. Where traditional project plans seek to help an operator reach production targets and budgets, FEL methodology aligns an operator's technical and business goals to create a more comprehensive development plan. The FEL approach increases project definition and lowers risk to positively impact total investment costs and return on investment.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>Upon completion of this course, participants will be able to:</p>
<ul>
<li>Learn the methods applied for Pre-FEL and FEL process</li>
<li>Understand the importance of FEL, FEL stages; visualisation, conceptualisation, definition</li>
<li>Uncover how to apply project management during FEL</li>
<li>Determine risk management in the FEL process</li>
<li>Understand benchmarking &amp; value improving practices</li>
</ul>
<p> </p>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>The course is recommended for anyone who wish to gain in-depth knowledge and understanding of the importance of Front-End Loading and how to apply Front End Loading best practices, including:</p>
<ul>
<li>Team Leaders</li>
<li>Senior Managers (Line and Function)</li>
<li>Project Managers</li>
<li>Development Engineers</li>
<li>Graduate Engineers</li>
<li>Quality Assurance Engineers</li>
<li>Key Contractor's Management</li>
<li>FEED engineers</li>
<li>Design engineers</li>
<li>Mechanical engineers</li>
<li>Process engineers</li>
</ul>
<p> </p>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader is a subsea pipeline consultant with extensive experience in the design, construction, and installation of subsea pipelines for the oil and gas industry. As a consultant, he provides technical expertise and support to clients on all aspects of subsea pipeline projects, from the initial planning and design phase through to construction and commissioning. He is knowledgeable about industry standards, regulations, and best practices for subsea pipelines, and works closely with clients to ensure that projects are delivered safely, on time, and within budget. He has over thirty years' experience in early concept and front-end studies for the initiation of numerous high value upstream oil and gas projects worldwide. He has worked for both Operating Companies and Consultants managing the FEL process for complex, multi-discipline and technically challenging concepts, combining both his technical and project management skills. He has been working with companies like ExxonMobil, Quantum Power, North Caspian Operating Company, OMV Petrom, Port Meridian, BG Group, and etc.</p>
<p> </p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>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.<br />
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

Front End Loading in Oil and Gas Projects

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong></h2>
<p>This 3 full-day course will provide a comprehensive understanding of the various types of transformer maintenance including breakdown maintenance, preventive maintenance, total productive maintenance, condition-based maintenance, proactive maintenance, and reliability-centered maintenance. All the expected problems in dry and oil-filled transformers will be discussed in detail. All the diagnostics, troubleshooting and maintenance required to ensure adequate operation of transformers will be covered thoroughly. This course will focus on maximizing the efficiency, reliability, and longevity of all types of transformers by providing an understanding of all commissioning requirements, repair and refurbishment methods of transformers.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<ul>
<li><strong>Equipment Diagnostics and Inspection:</strong> Learn in detail all the diagnostic techniques and inspections required of critical components of transformers</li>
<li><strong>Equipment Testing:</strong> Understand thoroughly all the routine tests, type tests, and special tests required for the various types of transformers</li>
<li><strong>Equipment Maintenance and Troubleshooting:</strong> Determine all the maintenance and troubleshooting activities required to minimize transformer downtime and operating cost</li>
<li><strong>Equipment Repair and Refurbishment:</strong> Gain a detailed understanding of the various methods used to repair and refurbish transformers</li>
<li><strong>Efficiency, Reliability, and Longevity:</strong> Learn the various methods used to maximize the efficiency, reliability, and longevity of transformers</li>
<li><strong>Equipment Sizing:</strong> Gain a detailed understanding of all the calculations and sizing techniques used for transformers</li>
<li><strong>Design Features:</strong> Understand all the design features that improve the efficiency and reliability of transformers</li>
<li><strong>Equipment Selection:</strong> Learn how to select all types of transformers by using the performance characteristics and selection criteria that you will learn in this course</li>
<li><strong>Equipment Commissioning:</strong> Understand all the commissioning requirements for transformers</li>
<li><strong>Equipment Codes and Standards:</strong> Learn all the codes and standards applicable for transformers</li>
<li><strong>Equipment Causes and Modes of Failure:</strong> Understand the causes and modes of failure in transformers</li>
<li><strong>System Design:</strong> Learn all the requirements for designing different types of transformer systems</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<ul>
<li>Engineers of all disciplines</li>
<li>Managers</li>
<li>Technicians</li>
<li>Maintenance personnel</li>
<li>Other technical individuals (this course is suitable for individuals who do not have an electrical background)</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Training Methods 

</div>
<div id="collapseThree">
<div>
<p>Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all 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.</p>
<p><span>Each delegate will receive a copy of the following materials written by the instructor:</span></p>
<ul>
<li><span>Excerpt of the relevant chapters from the 'ELECTRICAL EQUIPMENT HANDBOOK' published by McGraw-Hill in 2003 (600 pages)</span></li>
<li><span>Transformer Testing, Maintenance and Commissioning Manual (covering all the tests, maintenance activities, protective systems and all commissioning procedures for all types of transformers - 350 pages)</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>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.</p>
<p>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.</p>
<p>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.</p>
<p>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;</p>
<ul>
<li>Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011.</li>
<li>Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003.</li>
<li>Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012.</li>
<li>Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999).</li>
<li>Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999).</li>
</ul>
<p>Furthermore, he has received the following awards:</p>
<ul>
<li>The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016</li>
<li>The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996).</li>
<li>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).</li>
<li>Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983).</li>
</ul>
<p>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.</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>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.<br />
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

Transformer Maintenance

London

<h2>Portfolio, Programme, and Project Offices (P3O®) Practitioner: In-House Training</h2>
<p>P3O® is the AXELOS standard for the design of decision-making processes regarding changes in organizations. P3O provides a guideline for the design of portfolio, programme, and project offices in organizations.</p>
<p>The P3O Practitioner Course is an interactive learning experience. The P3O Practitioner-level content provides you with sufficient knowledge and understanding of the P3O guidance to design, implement, manage or work within any component office of a P3O model. It enables participants to successfully complete the associated P30 Practitioner exam and achieve the qualification.</p>
<p>In this course, you will be prepared to successfully attempt the P3O Practitioner exam and learn how to implement or re-energize a P3O model in their own organization.</p><h3>What you will Learn</h3>
 <p>At the end of the P3O Practitioner course, you will be able to:</p>
 <ul>
 <li>Define a business case to get senior management approval for P3O</li>
 <li>Build a right P3O model to adapt to the organization's needs, taking account of the organization's size and portfolio, programme and project management maturity</li>
 <li>Identify the elements, roles, and functions deployed in a generalized P3O model</li>
 <li>Use tools and techniques in running the P3O and advising those who shape the portfolio of programmes and projects</li>
 </ul><section>
                    <h3>Introduction to P3O</h3><ol><br /><li>What is the purpose of P3O?</li><li>Definitions</li><li>What are P3Os?</li><li>Portfolio, programme, and project lifecycles</li><li>Governance and the P3O</li></ol><br /><h3>Designing a P3O Model</h3><ol><br /><li>Factors that affect the design</li><li>Design considerations</li><li>What functions and services should the P3O offer?</li><li>Roles and responsibilities</li><li>Sizing and tailoring of the P3O model</li></ol><br /><h3>Why have a P3O?</h3><ol><br /><li>How a P3O adds value</li><li>Maximizing that value</li><li>Getting investment for the P3O</li><li>Overcoming common barriers</li><li>Timescales</li></ol><br /><h3>Why have a P3O (Extension)?</h3><ol><br /><li>The P3O Business Case</li><li>The P3O Model Blueprint</li><li>Vision Statement</li><li>Demonstrating the Value</li><li>KPIs</li><li>The Benefits of Claimed Capabilities</li><li>Benefit Realisation and Strategic Objectives</li><li>Benefit Profile</li></ol><br /><h3>How to Implement or Re-Energize a P3O</h3><ol><br /><li>Implementation lifecycle for a permanent P3O</li><li>Identify</li><li>Define</li><li>Deliver</li><li>Close</li></ol><br /><h3>Implementation lifecycle for a temporary programme or project office</h3><ol><br /><li>Organizational context</li><li>Definition and implementation</li><li>Running</li><li>Closing</li><li>Recycling</li></ol><br /><h3>How to operate a P3O</h3><ol><br /><li>Overview of tools and techniques</li><li>Benefits of using standard tools and techniques</li><li>Critical success factors</li><li>P3O tools</li><li>P3O techniques</li></ol>


                </section>

IIL Europe Ltd

Portfolio, Programs, & Project Offices Practitioner: In-House

General Admission

Redhill

<h3><b>Total QoS training course description</b></h3>
        <p>An advanced technical hands on course focusing on
Quality of Service issues in IP networks.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
       <li>Explain the difference between Integrated services and differentiated services.</li>
										<li>Explain how DiffServ works.</li> 
										<li>Explain how RSVP works. </li>
										<li>Design networks supporting QoS.</li>
      </ul>
        <h5>
        <b>Total QoS training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Network administrators.<br />
                Network operators. </p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>TCP/IP Foundation for engineers</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Total QoS training course contents</b></h3>
			<ul>	<li>What is QoS</li><p>
QoS and CoS, throwing bandwidth at the problem,
Best effort services, Differentiated services,
Integrated services, guarantees, the need for QoS,
IETF working groups.
				</p><li>Application issues</li><p>
Video, Voice, other applications, Jitter, delay,
packet loss. Flows, per flow and per aggregate
QoS, Stateful vs. stateless QoS, applications vs.
network QoS.
</p><li>'Traditional' IP QoS</li><p>
The TOS field and precedence, the obsolete
OSPF use of the TOS field, TCP congestion
avoidance.
</p><li>Queuing</li><p>
Where to use queuing, FIFO, Priority queuing,
Custom queuing, Weighted Fair Queuing,
CBWFQ, PQWFQ, LLQ, RED and WRED.
</p><li>DiffServ</li><p>
Architecture, DSCP, CU, packet classification and
marking, meters and conditioners, Bandwidth
brokers and COPS, Per Hop Behaviours, best
effort PHB, Assured Forwarding PHB, Expedited
forwarding PHB, Network Based Application
Recognition (NBAR).
</p><li>Layer 2 issues</li><p>
Fragmentation and interleaving, compression
(codecs, MPEG formats, header compressionâ¦),
802.1p, Subnet bandwidth management,
Bandwidth allocators and requestor modules, the
use of MPLS, traffic engineering, traffic shaping.
</p><li>RSVP</li><p>
What is RSVP? architectures, paths, path
messages, reservations, traffic specifications, tear
downs, guaranteed and controlled load, token
buckets, Call Admission Control in voice
networks, gatekeepers.
	</p><li>Other issues</li><p>
Policy based routing, the Resource Allocation
Protocol, QoS management tools, baselining
networks, design issues, QoS in IPv6, QoS and
	multicasts.</p>
				</ul>

Systems & Network Training

Network & Security

Network Engineer

Total QoS for engineers

<h3><b>Complete Visual BASIC training course description</b></h3>
      <p>    A hands-on introduction to programming in Visual BASIC V6.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	   <li>Build Visual BASIC applications.</li>
					<li>Build simple components. </li>
                    <li>Debug Visual BASIC programs.</li>
                    <li>Examine existing code and determine its function.</li>
                  </ul>
        <h5>
        <b>Complete Visual BASIC training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone wishing to program in Visual BASIC.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None although experience in another high level language would be useful.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Complete Visual BASIC training course contents</b></h3>
      <ul>
				<li>Application development using VB </li><p>

VB features. VB editions, VB terminology. Working in the Development Environment. Event-Driven Programming. Creating a program in VB. Project and executable files. VB reference materials.
</p><li>Visual Basic fundamentals </li><p>
Objects. Controlling objects. Introduction to forms. Introduction to controls. Basic controls.

</p><li>Working with code and forms </li><p>
Modules. Working with code. Interacting with the user. Working with code statements. Managing forms.

</p><li>Variables and procedures </li><p>
Introduction to variables and constants. Working with Procedures and Functions.

</p><li>Controlling program execution </li><p>
Common VB functions. Comparison and relational operators. Conditional structures. Looping structures.

</p><li>Debugging </li><p>
Error types. Debugging logic errors in VB.

</p><li>Working with controls </li><p>
Control types. Standard controls. Advanced standard controls. ActiveX controls. Insertable controls.

</p><li>Data access using the ADO data control </li><p>
Overview of ActiveX Data Objects. VB data access features. Relational database concepts. Using the ADO data Control to access data. SQL. Manipulating data. Using the data form wizard.

</p><li>Input validation </li><p>
Field-Level validation. The masked edit control. Form-Level validation. Form events used when validating data.

</p><li>Error trapping </li><p>
Trapping run time errors. Error handling overview. Enabling an error trap. Errors and the calling chain. In line error handling.

</p><li>Enhancing the User Interface </li><p>
Menus. Status bars. Toolbars.

</p><li>Drag and Drop </li><p>
Overview of Drag and Drop. Mouse events Drag and Drop basics.

</p><li>More about controls </li><p>
Using control arrays. Using the controls collection. Working with object variables. Collections.

</p><li>Finishing touches </li><p>
User Interface design principles. Distributing an application. Creating a default project.</p>
			
      </ul>

Complete Visual BASIC

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong><em> </em></h2>
<p>This five-day course provides an intermediate level of understanding of the geomechanical factors that affect wellbore instability, sand production and hydraulic fracture design.  The course is structured such that upon completion, participants will have understood the value that geomechanics can bring to drilling, completion and production operations and will be able to leverage this value wherever it applies.  The course emphasis will be on integrating the topics presented through a combination of lectures, case-studies and hands-on exercises. A special focus will be on how geomechanics knowledge is extracted from routinely acquired well data and how it is applied in the prediction and prevention of formation instability.</p>
<p><strong>Course Highlights</strong></p>
<p>The course is essentially non-mathematical and makes wide use of diagrams, pictures and exercises to illustrate the essential concepts of geomechanics</p>
<ul>
<li>Essential Rock Mechanics Principles</li>
<li>Wellbore Stability Analysis</li>
<li>Anisotropic Rock Properties for unconventional projects</li>
<li>Lost Circulation and Wellbore Strengthening applications</li>
<li>Sand Production Management</li>
<li>Input to Hydraulic Fracture design</li>
<li>Salt instability</li>
</ul>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p><strong>By attending this training, you will be able to acquire the following:</strong></p>
<ul>
<li>Apply the basic concepts of geomechanics to identify, predict and mitigate against formation instability during drilling, completion and production</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This course is intended for Drilling Engineers, Well Engineers, Production Technologists, Completion Engineers, Well Superintendents, Directional Drillers, Wellsite Supervisors and others, who wish to further their understanding of rock mechanics and its application to drilling and completion.</p>
<p>There is no specific formal pre-requisite for this course.  However, attendees are requested to have been exposed to drilling, completions and production operations in their positions and to have a recommended minimum of 3 years of field experience.</p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your Expert Course Instructor is an operational geomechanics advisor with over 46 years of experience in exploration, development and production in the upstream oil and gas industry.  After obtaining a BSc (Hons) Physics degree from Aberdeen University, he worked for a variety of oil service companies in wireline operations, management and formation evaluation, before joining Schlumberger in 1995.  Since 2000 he has worked principally in real-time geomechanics operations and developing acousto-geomechical applications, taking on the role of geomechanics advisor and technical manager within the Europe-Africa area of operations.  Before forming his own company in 2014, Your Expert Course Instructor was one of Schlumberger's principal instructors, delivering cross-discipline internal and external geomechanics training to petrophysicists, geologists, reservoir, petroleum, well construction and drilling engineers at operating company locations, training centers and operational centers worldwide.  Through extensive operational and wellsite experience gained in the North Sea, Europe, Africa, South America and the Far East, he has gained a broad based knowledge of drilling, production, log data acquisition, analysis and interpretation that has allowed him to develop and deliver pragmatic solutions to the geomechanical challenges of drilling, sand production, fracturing and unconventional reservoirs, faced by operators.</p>
<p>His principal interests include the development and application of acousto-geomechanical techniques for the evaluation of anisotropic formations and fracture systems and the identification and prevention of wellbore instability</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>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.<br />
Request for further information about post training coaching support and fees applicable for this.</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

Geomechanics

<h3><b>Essential GEPON training course description</b></h3>
      <p>Designed to benefit those requiring an in depth
knowledge of the principles and applications of the
IEEE Ten Gigabit Ethernet and Gigabit Ethernet
Passive Optical Networking and Fibre to the X in NG
network applications and their associated equipment,
its flexibility and function within a modern transmission
network.<br />
Using an effective mix of instruction and correlation to
theory based learning the delegate will gain a complete
understanding of the equipment and the tasks to be
undertaken in a real life situation.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
        <li>Compare FTTx networks.</li>
																				<li>Compare PON variants.</li>
                    <li>Recognise the GEPON architecture.</li>
                    <li>Explain how GEPON works.</li>
                    <li>Recognise GEPON issues.</li>
                  </ul>
       
        <h5>
        <b>Essential GEPON training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone requiring GEPON knowledge.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Introduction to data communications and networking.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Essential GEPON training course contents</b></h3>
      <ul>
				<li>FTTN, FTTC, FTTH </li><p>
Single Mode Fibre (SMF) and various types, Multimode Fibre (MMF), Fibre Safety and properties (Dispersion/attenuation), Fibre Reel cables and types, Fibre installation and air blown fibre, Transmitters and receivers - power budget/laser classes, Fibre to the home (FTTH), FTTC (Fibre to the Cabinet), FTTN (Fibre to the node), FTTD (Fibre to the Desk), FFTH Topologies and wavelengths, Active or Passive Optical Network (PON).

</p><li>WDM equipment and GPON OSP design </li><p>
Wavelength considerations, WDM/DWDM/CWDM EDFA optical amplification, AWG (Arrayed Waveguide Grating) splitters, Couplers (splitters) and losses, Optical splitters 1x2, 1x4, 1x8, 1x16, 1x32, 1x64, 2x64.

</p><li>IEEE PON variants </li><p>
Gigabit Ethernet Passive Optical Network (GEPON), Time Division PON (TDM-PON), Wave Division Multiplexing PON (WDM-PON), 1Gbps, 10Gbps, 40Ggps, 100Gbps, Strategies for TDM-PON to WDM-PON migration, Architecture of NG-PON (hybrid WDM/TDM PON), Additional services than triple play.

</p><li>GEPON design </li><p>
GEPON OSP centralized design, GEPON OSP distributed design, GEPON PON splitters x4 x8 x32, Fibre splice trays / fibre cassette trays / fibre enclosures, GEPON field testing /GEPON field installation verification, GEPON physical layer testing, Optical Time Domain Reflectometer (OTDR), Optical power source /Optical power meter, Optical Return Loss (ORL), APON/BPON/GPON/EPON/GEPON/10-GEPON comparison.

</p><li>IEEE 802.3ah GEPON: Ethernet in the first mile </li><p>
IEEE 802.3 options, Optical Ethernet options, Ethernet in the first mile, 1000BASE-LX, 1000BASE-SX, IEEE 802.1Q VLANs, Q-in-Q and MAC-in-MAC. QofS Ethernet TOS and priority methods PCP and DiffServe, Reference model / terminology / architecture, Example of ONT functional blocks, Example of OLT functional blocks, FTTx scenarios, The four switching arrangements for external access network backup.

</p><li>IEEE 802.3av 10-GEPON </li><p>
Physical layer, 10GBASE-SR, 10GBASE-LX4, 10GBASE-ER, 10GBASE-LR, 10GBASESW, 10GBASE-LW, 10GBASE-EW, Enhancement band, Bit rate and wavelengths, Compatibility, Forward error correction.

</p><li>IEEE 802.3ca 25G, 50G and 100G NG-EPON </li><p>
MAC frame structure, Downstream multiplexing / Upstream multiplexing, Media access control and ONU registration, Alarm messages.

</p><li>IEEE 802.3bk extended EPON </li><p>
Laser Types PRX40 and PR40, Reference model.

</p><li>GEPON issues and standards </li><p>
GEPON components OLT / GEPON ONT and examples GEPON management, RG (Residential Gateway), HPNA (Home Phone Network Alliance), Power Line Carrier (PLC), GPON DLNI, G.hn or G.9960 MOCA, FTTH Council certification, Standard for network certification, Qualify for use of the fibre-connected home badge, GEPON frame synchronization to network timing, Direct clock synchronization interface (BITS), Multiservice Access Platform (MSAP), Software planning tool. Superconnected cities / voucher scheme.

</p><li>Ethernet OAM </li><p>
Link monitoring, remote failure indication, Remote loopback.
</p>
      </ul>

Essential GEPON

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong></h2>
<p>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 &amp; Gas wells worldwide.</p>
<p>This 5 full-day course will look at the following areas:</p>
<ol>
<li>Equipment for surface and pressure control</li>
<li>Assembly components for bottom-hole</li>
<li>Details of the different types of interventions performed with Coiled Tubing, and</li>
<li>How to deal with fatigue and corrosion.</li>
</ol>
<p>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.</p>
<p>This course can also be offered through Virtual Instructor Led Training (VILT) format.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>By the end of the course, the participants will be able to:</p>
<ul>
<li>Plan, design, manage and execute interventions for Coiled Tubing</li>
<li>Enhance operational performance during interventions for Coiled Tubing</li>
<li>Explain the recommended equipment for various Coiled Tubing field conditions and applications</li>
<li>Discuss the proper pressure control equipment for any particular well condition</li>
<li>Learn about the most commonly used downhole tools and explain their function</li>
<li>Understand how to calculate and define string limits for Coiled Tubing</li>
<li>Learn how to work safely with liquid nitrogen</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This course is aimed at</p>
<ul>
<li>Drilling and completion engineers</li>
<li>Production engineers</li>
<li>Surface/subsurface engineers</li>
<li>Operations engineers</li>
<li>Service company managers</li>
<li>Field engineers</li>
</ul>
<p>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.</p>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Training Methods 

</div>
<div id="collapseThree">
<div>
<p>Other than the daily quizzes to reinforce the materials presented in the session, the participants will work through exercises such as:</p>
<ol>
<li>Selecting suitable BHAs for various operations</li>
<li>Rigging up equipment in the correct order and preparing an outline testing programme</li>
<li>Carrying out suitable calculations to perform an N2 lift</li>
<li>Preparing an outline programme for a balanced cement plug</li>
<li>Identifying issues in various videos &amp; photos and suggesting mitigations</li>
<li>Basic N2 safety quiz</li>
<li>Final exercise will be preparing an outline programme for a Proppant Clean out, including a detailed Risk Register and Mitigation options</li>
</ol>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course instructor has over 40 years of experience in the Oil &amp; 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 &amp; 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.</p>
<p>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.</p>
<p>While working on rotation, he regularly taught Completion Practices, Well Intervention, Well Integrity and Reporting &amp; 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.</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>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.<br />
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

Coiled Tubing Operations - Equipment, Applications, Well Control, Safety & Emerging Technologies

<div>
</div>
<section>
<div>
<h2>About this training course</h2>
<p>This 5 full-day course will cover all aspects of gas turbines, co-generation and combined cycle power plants. It will cover in detail all the components of these types of power plants such as: compressors, gas and steam turbines, heat recovery steam generators, deaerators, condensers, lubricating systems, instrumentation, control systems, and economics.</p>
<p>The design, selection considerations, operation, maintenance, pay-back period, economics of co-generation plants and combined cycles, as well as, emission limits, reliability, monitoring and governing systems are also covered in detail. This course will also provide up-dated information in respect to all the significant improvements that have been made to co-generation and combined cycles power plants, during the last two decades.</p>
<p>The course will illustrate through sophisticated computer simulation how gas turbines, co-generation and combined cycle plants perform under steady-state and transient conditions. In addition, the participants will learn how to use the computer simulation program which provides the following benefits:</p>
<ol>
<li>Allow the operator to extend the gas turbine operating period by avoiding unnecessary outages and maintenance activities.</li>
<li>Determination of essential gas turbine maintenance activities to reduce the duration of outages.</li>
<li>Profit optimization of co-generation and combined cycle plants.</li>
<li>Minimization of the environmental emissions of co-generation and combined cycle plants.</li>
</ol>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<ul>
<li><strong><span>Power Plant Computer simulation:</span></strong><span> Gain a thorough understanding of computer simulation of gas turbines, co-generation, and combined cycle plants.</span></li>
<li><strong><span>Power Plant Components and Systems: </span></strong><span>Learn about all components and subsystems of the various types of power plants such as gas turbines, co-generation and combined cycle plants</span></li>
<li><strong><span>Power Plants Economics: </span></strong><span>Examine the advantages, applications, performance and economics of power plants such as: gas turbines, co-generation, and combined cycle plants</span></li>
<li><strong><span>Power Plant Equipment: </span></strong><span>Learn about various power plant equipment including: compressors, turbines, governing systems, combustors, deaerators, feed water heaters, etc.</span></li>
<li><strong><span>Power Plant Maintenance:</span></strong><span> Learn all the maintenance activities required for power plants such as: gas turbines, co-generation plants and combined cycles to minimize their operating cost and maximize their efficiency, reliability, and longevity</span></li>
<li><strong><span>Power Plant Environmental Emissions:</span></strong><span> Learn about the monitoring and control of environmental emissions.</span></li>
<li><strong><span>Power Plant Instrumentation and Control Systems:</span></strong><span> Learn about the latest instrumentation and control systems of gas turbines, co-generation and combined cycles power plants</span></li>
<li><strong><span>Power Plant Reliability and Testing:</span></strong><span> Increase your knowledge of power plant predictive and preventive maintenance, reliability and testing.</span></li>
<li><strong><span>Power Plant Selection and Applications:</span></strong><span> Gain a detailed understanding of the selection considerations and applications of power plants such as: gas turbines, co-generation and combined-cycle power plants</span></li>
<li><strong><span>Power Plant Profitability:</span></strong><span> Learn about the reliability, life cycle cost, profitability, refurbishment, and life extension methods for gas turbines, co-generation and combined cycle power plants.</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<ul>
<li><span>Engineers of all disciplines</span></li>
<li><span>Managers</span></li>
<li><span>Technicians</span></li>
<li><span>Maintenance personnel</span></li>
<li><span>Other technical individuals</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><span>Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all 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.</span></p>
<p><span>Each delegate will receive a copy of the following materials written by the instructor:</span></p>
<ul>
<li><span>'POWER GENERATION HANDBOOK' second edition, published by McGraw-Hill in 2012 (800 pages)</span></li>
<li><span>Practical manual (500 pages)</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>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;</p>
<ul>
<li>Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011.</li>
<li>Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003.</li>
<li>Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012.</li>
<li>Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999).</li>
<li>Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999).</li>
</ul>
<p>Furthermore, he has received the following awards:</p>
<ul>
<li>The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016</li>
<li>The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996).</li>
<li>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).</li>
<li>Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983).</li>
</ul>
<p>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.</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>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.<br />
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

Gas Turbines, Co-Generation and Combined Cycle Power Plants

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>The Power BI in a Day course is designed for beginners and intermediate users of Power BI.</p>Overview<p>#NAME?</p><p>Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions.</p></div><div id="course-pills-2"><h3>1 - Accessing &amp; Preparing data</h3> <ul> <li>Data Set</li> <li>Power BI Desktop</li> <li>Power BI Desktop ? Accessing Data</li> <li>Power BI Desktop ? Data Preparation</li> </ul> <h3>2 - Data Modeling and Exploration</h3> <ul> <li>Power BI Desktop ? Data Modeling and Exploration</li> <li>Power BI Desktop ? Data Exploration Continued</li> <li>References</li> </ul> <h3>3 - Data Visualization</h3> <ul> <li>Power BI Desktop</li> <li>Power BI Desktop ? Data Visualization</li> <li>References</li> </ul> <h3>4 - Publishing &amp; Accessing Reports</h3> <ul> <li>Power BI Desktop ? Creating Mobile View</li> <li>Power BI Service</li> <li>Power BI Service ? Publishing Report</li> <li>Power BI Mobile ? Accessing Report on Mobile Device</li> <li>Power BI Service ? Collaboration and Distribution</li> <li>References</li> </ul> <h3>5 - Dashboard and Collaboration</h3> <ul> <li>Power BI Service</li> <li>Building Dashboard</li> <li>References</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Power BI: Dashboard in a Day training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Power BI: Dashboard in a Day course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Powerbi

Tableau Desktop Specialist

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Power BI: Dashboard in a Day

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Life is hectic. Finding time out feels almost impossible. We want to pray, we want to reflect, but when we do find a snatched moment to ourselves, we remain distracted.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">I&#39;ve designed this space to help you reconnect with your breath, to gently stretch your body, and to listen... to the voice of your inner wisdom, and to the voice of your Beloved.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will meditate with scripture, we will journal, we will use creative means to listen to the Spirit.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will sit with Love.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">I hope you will come away feeling centred, refreshed and assured of your belovedness.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;Two hours, on Zoom.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">"Come away with me to a quiet place"</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Past Participants are Saying:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">"<span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">A really well led session allowing time for reflection and prayer." - Ellie</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Mini-Retreats are hosted by Lissy Clarke, Spiritual Director, Yoga Teacher and the voice behind the meditations at Contemplative at Home.&nbsp;</em></p>

Life is hectic. Finding time out feels almost impossible. We want to pray, we want to reflect, but when we do find a snatched moment to ourselves, we remain distracted.
I've designed this space to help you reconnect with your breath, to gently stretch your body, and to listen... to the voice of your inner wisdom, and to the voice of your Beloved. 
We will meditate with scripture, we will journal, we will use creative means to listen to the Spirit.
We will sit with Love.
I hope you will come away feeling centred, refreshed and assured of your belovedness.
 Two hours, on Zoom.
"Come away with me to a quiet place"

The sessions will be shaped around the following themes this year:
October: Teresa of Avila
November: Letting Go
December: Advent / Expectant Hope
January: The Gifts of Winter Darkness
February: Love
March: Lent
April: No Session
May: Resurrection / Spring
June: TBC

July: The Gifts of Summer

August: No Session


You are invited to participate from the comfort of your own home. Ideally you'll be able to find a little space where you won't be interrupted. You might wish to ask those you share space with to help you protect this time by respecting your privacy.
All who sign up will be sent a link to the recording of the retreat which will remain live until the following session. If you would like to participate via recording, simply register for the event. It would be great if you could let me know that you won't be with us in real time.

Past Participants are Saying:


"A really well led session allowing time for reflection and prayer." - Ellie


Virtual Mini-Retreats are hosted by Lissy Clarke, Spiritual Director, Yoga Teacher and the voice behind the meditations at Contemplative at Home. 

NB: Virtual Mini-Retreats are FREE for members who support the show at £15/ month and above (thank you!! ✨) - but you must still register to secure a place on a particular date, as places are limited. Memberships can be started or stopped at any time. More information here.

Contemplative at Home

Virtual Mini-Retreats

Suggested Donation

Elevate your auditing expertise and lead the way in quality management with our ISO 9001:2015 Lead Auditor course, certified by CQI and IRCA. This comprehensive program is designed for professionals seeking to conduct first, second, and third-party audits of Quality Management Systems (QMS) against the ISO 9001:2015 standard.
Our course provides in-depth training on the principles and practices of auditing, equipping you with the knowledge and skills to effectively lead audit teams and assess the conformance and effectiveness of QMS in organizations. You will learn how to plan, conduct, report, and follow up on audits in compliance with ISO 19011 guidelines and ISO/IEC 17021 standards.
Key Features of the Course:
Certified Expertise: Achieve a globally recognized certification from CQI and IRCA, enhancing your professional credibility and career prospects.
Experienced Instructors: Learn from industry experts with extensive experience in quality management and auditing, who provide real-world insights and practical guidance.
Interactive Learning: Engage in hands-on exercises, case studies, and role-play scenarios that simulate real auditing situations, ensuring that you can apply what you learn directly to your work.
Comprehensive Curriculum: Cover all aspects of the ISO 9001:2015 standard, audit principles, and techniques, as well as risk-based thinking and the process approach.
Career Advancement: This course is ideal for those aspiring to become lead auditors, quality managers, or consultants, offering a pathway to new opportunities and enhanced professional status.
Upon successful completion of the course and examination, you will be awarded the prestigious CQI and IRCA certification, recognized globally as a mark of excellence in auditing. This certification will enable you to conduct audits for certification bodies and help organizations achieve compliance and continual improvement.
Enroll in our ISO 9001:2015 Lead Auditor course today and take the next step in your journey to becoming a leader in quality management.

QUALITY ACADEMY

Quality Management System

ISO 9001

Quality Management

Quality Assurance

Quality Auditor

Become a certified ISO 9001:2015 Lead Auditor with our CQI and IRCA accredited course. Gain the skills to lead quality management audits and enhance your career. Enroll now!

ISO 9001:2015 Lead Auditor (CQI and IRCA Certified)

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Aims:&nbsp;</strong>To develop the exercise professional&rsquo;s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Outcome:</strong>&nbsp;You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Qualification Structure:</strong></span></p><ol start="1" type="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learners will cover:</span><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Key mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The relationships between mental health, society and lifestyle</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Legislation and government policy relating to mental health</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The role of national organisations relating to mental health</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Roles and boundaries of the people involved in programming physical activity for individuals with mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to motivate and support individuals with mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to evaluate the usefulness of a range of resources of information on mental health and its relationship to physical activity</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to evaluate the effectiveness of a range of mental health interventions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to program physical activity for individuals with mental health conditions How to deliver physical activity programmes to individuals with mental health conditions</li></ul></ol><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Entry Requirements:</strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">We recommend you hold an Exercise Referral Qualification</span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></div><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Assessments:</strong></span></div><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Theory paper</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Research worksheet</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Analysis task</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Knowledge questions</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Programme design</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Programme delivery</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Professional discussion (programme delivery)</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Evaluation of programme delivery</p></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div>

Aims: To develop the exercise professional’s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.
Outcome: You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.
Qualification Structure:
Learners will cover:
Key mental health conditions
The relationships between mental health, society and lifestyle
Legislation and government policy relating to mental health
The role of national organisations relating to mental health
Roles and boundaries of the people involved in programming physical activity for individuals with mental health conditions
How to motivate and support individuals with mental health conditions
How to evaluate the usefulness of a range of resources of information on mental health and its relationship to physical activity
How to evaluate the effectiveness of a range of mental health interventions
How to program physical activity for individuals with mental health conditions How to deliver physical activity programmes to individuals with mental health conditions
Entry Requirements:We recommend you hold an Exercise Referral QualificationAssessments:
Theory paper
Research worksheet
Analysis task
Knowledge questions
Programme design
Programme delivery
Professional discussion (programme delivery)
Evaluation of programme delivery

Platinum Training Institute

Physical Activity

Health

Mental Health

Aims: To develop the exercise professional’s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.

Outcome: You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.

YMCA Level 4 Certificate in Delivering Physical Activity for Individuals with Mental Health Conditions

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The primary audience for this course is any IT, facilities or data centre professional, who are involved in the design/build, renovation or relocation of a mission-critical data centre.</p>Overview<p>This 5-day course is designed to prepare participants to analyse a given business case and perform technical evaluation for a project plan and a set of designs for the implementation of a mission critical data centre.<br />The course also engages participants in product evaluations and demonstrates how to select equipment and develop equipment test scripts (IET) and integrated performance and validation testing (IPVT). CDCEÂ© builds upon knowledge gained in CDCP and CDCS courses. Participants who pass the exam will join the industry's elite data centre project design experts.<br />CDCEÂ© is the highest level training in the EPI Design and Build training track under the EPI Data Centre Training Framework. Participants must hold a valid CDCS certificate in order to be able to register for the CDCE class.</p><p>CDCEÂ© is the premier certification for data centre professionals in the data centre design/build and related fields.</p></div><div id="course-pills-2"><h4>Data Centre Life Cycle</h4><ul><li>Data centre lifecycle stages and phases<br />Exercise: Stage/Phase/Milestone/Document mapping</li></ul><h4>Design Preparation</h4><ul><li>Creation of a SON ? Statement Of Need<br />Technology review<br />Conceptual sizing<br />How to calculate for computer room space<br />How to calculate facility space<br />How to calculate incoming power<br />Exercise: Conceptual sizing building and power<br />Analysing capacity of existing facility<br />Analysing investment options<br />Site selection<br />Permits and approvals<br />Exercise: Site selection<br />Conceptual design<br />Budget and project timeline<br />Business case preparation<br />Project delivery structure<br />Project management options<br />Project manager and team</li></ul><h4>Design Planning</h4><ul><li>OSRA?Operational Systems Requirement Analysis<br />TFRA?Technical Facilities Requirement Analysis<br />Operations and maintenance review<br />RFP?Request For Proposal process<br />Vendor selection</li></ul><h4>Design Development</h4><ul><li>Project planning<br />Design development<br />PDR ? Preliminary Design Review<br />Equipment selection<br />FDR/V ? Final Design Review/Validation<br />Exercise: Full design validation of power, cooling, floor plans, fire suppression<br />Design freeze and LLTI<br />Creation of construction documents<br />BOM/BOQ ? Bill Of Material/Bill Of Quantity<br />Exercise: Equipment selection</li></ul><h4>Acquire</h4><ul><li>Requirements of purchase orders<br />Shipping terms<br />FWT/FAT ? Factory Witness Test/Factory Acceptance Test<br />Sequencing<br />Incoming goods inspection and handling<br />Asset management</li></ul><h4>Construct</h4><ul><li>Temporary essential services<br />Erection of the building<br />Permanent essential services<br />Building inspection<br />Snag list<br />COF?Certificate Of Fitness</li></ul><h4>Fit-Out</h4><ul><li>Fit-Out<br />Builders cleaning<br />As-Built Drawings</li></ul><h4>Test &amp; Commissioning</h4><ul><li>IET?Individual Equipment Test<br />IPVT/IST?Integrated Performance Verification Test/Integrated Systems Test<br />Common mistakes with IET/IPVT<br />Deep cleaning<br />Exercise: IET/IPVT scripting</li></ul><h4>Hand-Over</h4><ul><li>Facility hand-over requirements and documents<br />PCC?Practical Completion Certificate<br />DLP?Defect Liability Period<br />Defect Management<br />ICT Systems Installation<br />ICT Systems Testing<br />Hand-Over/DLP Expiry<br />FCC?Final Completion Certificate</li></ul><h4>Retirement</h4><ul><li>Reasons and definitions of retirement<br />Building the business case and project plan<br />Sequencing<br />Transfer of site<br />Demolishing of site<br />Legal matters<br />FCC?Final Completion Certificate</li></ul><h4>Exam: Certified Data Centre Expert (CDCEÂ©)</h4><ul><li>The CDCEÂ© exam is in two parts: Part A is a 90-minute closed book exam, with 60 multiple-choice questions. For Part A, the candidate requires a minimum of 45 correct answers to pass the exam. Part B is a 90-minute closed book exam, with 25 open questions. For Part B the candidate needs to obtain a minimum of 75% to pass.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Certified Data Centre Expert (CDCE) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Certified Data Centre Expert (CDCE) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Certified in Cybersecurity (CC)

IT Certifications

Construction Design & Management (CDM)

Cisco Certified Internetwork Expert (CCIE)

Certified in Data Protection (CDP)

Certified Cyber Professional (CCP)

Certified Data Centre Expert (CDCE)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is targeted toward an IT Professional that has the technical knowledge and skills required to conceptualize, design, and engineer secure solutions across complex enterprise environments. Students should have a minimum of 10 years experience including at least 5 years of hands-on technical security experience.</p>Overview<p>Upon successful completion of this course, students will be able to:  Identify enterprise security fundamentals.  Apply enterprise security technology solutions.  Implement security design and solutions.  Manage risk, policies and procedures within an enterprise.  Integrate security solutions within an enterprise.  Conduct security research and analysis.</p><p>In this course, students will examine advanced security concepts, principles, and implementations that pertain to enterprise level security.</p>Prerequisites<p></p><ul><li>CompTIA Cybersecurity Analyst (CySA+) Certification</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Enterprise Security Architecture</h3> <ul> <li>The Basics of Enterprise Security</li> <li>The Enterprise Structure</li> <li>Enterprise Security Requirements</li> </ul> <h3>2 - Enterprise Security Technology</h3> <ul> <li>Common Network Security Components and Technologies</li> <li>Communications and Collaboration Security</li> <li>Cryptographic Tools and Techniques</li> <li>Advanced Authentication</li> </ul> <h3>3 - Enterprise Resource Technology</h3> <ul> <li>Enterprise Storage Security Issues</li> <li>Distributed, Shared, and Virtualized Computing</li> <li>Cloud Computing and Security</li> </ul> <h3>4 - Security Design and Solutions</h3> <ul> <li>Network Security Design</li> <li>Conduct a Security Assessment</li> <li>Host Security</li> </ul> <h3>5 - Application Security Design</h3> <ul> <li>Application Security Basics</li> <li>Web Application Security</li> </ul> <h3>6 - Managing Risk, Security Policies, and Security Procedures</h3> <ul> <li>Analyze Security Risk</li> <li>Implement Risk Mitigation Strategies and Controls</li> <li>Implement Enterprise-Level Security Policies and Procedures</li> <li>Prepare for Incident Response and Recovery</li> </ul> <h3>7 - Enterprise Security Integration</h3> <ul> <li>The Technology Life Cycle</li> <li>Inter-Organizational Change</li> <li>Integrate Enterprise Disciplines to Achieve Secure Solutions</li> </ul> <h3>8 - Security Research and Analysis</h3> <ul> <li>Perform an Industry Trends and Impact Analysis</li> <li>Perform an Enterprise Security Analysis</li> </ul></div>

Certificate in Information Security Management Principles (CISMP)

Certified Cloud Security Professional (CCSP)

ASIS Certified Protection Professional (CPP)

Cissp

CompTIA Security+

CompTIA Advanced Security Practitioner (CASP+)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.</p>Overview<p>Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries</p><p>This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.</p>Prerequisites<p></p><ul> <li>Basic understanding of relational databases.</li> <li>Basic Windows knowledge.</li> </ul><p></p></div><div id="course-pills-2"><h3>Module 1: Introduction to Transact-SQL</h3><ul> <li>What is Transact-SQL</li> <li>The SELECT statement</li> <li>The WHERE clause</li> <li>Sorting results</li> <li>Calculations</li> <li>CASE expressions</li> </ul>   <h3>Module 2: Joining tables with Transact-SQL</h3><ul> <li>The JOIN clause</li> <li>Inner joins</li> <li>Outer joins</li> <li>Self joins and cross joins</li> </ul>  <h3>Module 3: Filtering and sorting results</h3><ul> <li>Implement the ORDER BY clause</li> <li>Filter data with the WHERE clause</li> <li>Limit the number of rows returned by a query</li> <li>Implement NULL logic</li> </ul>  <h3>Module 4: SQL Server data types</h3><ul> <li>Understand data types</li> <li>Implement string data types</li> <li>Implement temporal data types</li> </ul>  <h3>Module 5: Inserting, updating and deleting data</h3><ul> <li>Insert new records</li> <li>Update existing records</li> <li>Delete data</li> </ul>   <h3>Module 6: Using SQL Server functions with Transact-SQL</h3><ul> <li>Understand function types in SQL Server</li> <li>Convert data using functions</li> <li>Implement logical functions</li> <li>Work with NULL data using functions</li> </ul>  <h3>Module 7: Aggregating data with Transact-SQL</h3><ul> <li>Implement aggregation in SQL Server</li> <li>Group records in SQL Server</li> <li>Filter aggregated data</li> </ul>   <h3>Module 8: Implement subqueries with Transact-SQL</h3><ul> <li>Implement scalar and multi-valued sub-queries</li> <li>Implement correlated subqueries</li> <li>Implement existence checks with subqueries</li> </ul>   <h3>Module 9: Create queries that use table expressions</h3><ul> <li>Create views</li> <li>Create table-valued functions</li> <li>Implement derived tables</li> <li>Implement common table expressions</li> </ul>  <h3>Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data</h3><ul> <li>Write queries with the UNION operator</li> <li>Write queries with the INTERSECT and EXCEPT operators</li> <li>Write queries with the APPLY operator</li> </ul>    <h3>Module 11: Implement window functions in queries</h3><ul> <li>Understand window functions</li> <li>Impement window functions</li> </ul>    <h3>Module 12: Use PIVOT and grouping sets in queries</h3><ul> <li>Implement PIVOT in queries</li> <li>Implement grouping sets in queries</li> </ul>   <h3>Module 13: Use stored procedures in queries</h3><ul> <li>Query data with stored procedures</li> <li>Interact with stored procedures using input and output parameters</li> <li>Write simple stored procedures</li> <li>Pass dynamic SQL to SQL Server</li> </ul>    <h3>Module 14: Implement programming features in Transact-SQL</h3><ul> <li>Understand T-SQL programming elements</li> <li>Implement loops and conditions in T-SQL queries</li> </ul>   <h3>Module 15: Add error handling to queries</h3><ul> <li>Understand SQL Server error handling</li> <li>Implemet structured exception handling</li> </ul>   <h3>Module 16: Use transactions in queries</h3><ul> <li>Understand database transactions</li> <li>Implement transactions in T-SQL</li> </ul></div>

Computing Skills

Microsoft SQL

Data Skills

SQL Server

Trainers Course

55366 Querying Data with Transact-SQL

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for IT professionals who wish to develop cloud computing skills to enable them to move IT workloads to the cloud and integrate products and services from different providers and industries. Their focus is to ensure that cloud deployments are secure, that automation and orchestration are used effectively to bring business value from the cloud, and that costs are controlled through effective management of cloud vendors.   This course is also designed for students who are preparing to take the CompTIA Cloud+ certification exam CV0-003, or who plan to use Cloud+ as the foundation for more advanced cloud certifications or career roles.</p>Overview<p>In this course, you will deploy, test, secure, manage, optimize, and troubleshoot a cloud solution.   You will:  - Prepare to deploy cloud solutions  - Deploy a pilot project  - Test a pilot project deployment  - Design a secure network for cloud deployment  - Determine CPU and memory sizing for cloud deployments  - Determine storage requirements for cloud deployments  - Plan Identity and Access Management for cloud deployments  - Analyze workload characteristics to ensure successful migration to the cloud  - Secure systems to meet access requirements  - Maintain cloud systems  - Implement backup, restore, and business continuity measures  - Analyze cloud systems for required performance  - Analyze cloud systems for anomalies and growth forecasting  - Troubleshoot deployment, capacity, automation, and orchestration issues  - Troubleshoot connectivity issues  - Troubleshoot security issues</p><p>In this course, you will learn how to implement, maintain, and deliver cloud technologies including network, storage, and virtualization technologies to create cloud solutions.</p></div><div id="course-pills-2"><h3>1 - PREPARING TO DEPLOY CLOUD SOLUTIONS</h3> <ul> <li>Describe Interaction of Cloud Components and Services</li> <li>Describe Interaction of Non-cloud Components and Services</li> <li>Evaluate Existing Components and Services for Cloud Deployment</li> <li>Evaluate Automation and Orchestration Options</li> <li>Prepare for Cloud Deployment</li> </ul> <h3>2 - DEPLOYING A PILOT PROJECT</h3> <ul> <li>Manage Change in a Pilot Project</li> <li>Execute Cloud Deployment Workflow</li> <li>Complete Post-Deployment Configuration</li> </ul> <h3>3 - TESTING PILOT PROJECT DEPLOYMENTS</h3> <ul> <li>Identify Cloud Service Components for Testing</li> <li>Test for High Availability and Accessibility</li> <li>Perform Deployment Load Testing</li> <li>Analyze Test Results</li> </ul> <h3>4 - DESIGNING A SECURE AND COMPLIANT CLOUD INFRASTRUCTURE</h3> <ul> <li>Design Cloud Infrastructure for Security</li> <li>Determine Organizational Compliance Needs</li> </ul> <h3>5 - DESIGNING AND IMPLEMENTING A SECURE CLOUD ENVIRONMENT</h3> <ul> <li>Design Virtual Network for Cloud Deployment</li> <li>Determine Network Access Requirements</li> <li>Secure Networks for Cloud Interaction</li> <li>Manage Cloud Component Security</li> <li>Implement Security Technologies</li> </ul> <h3>6 - PLANNING IDENTITY AND ACCESS MANAGEMENT FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Identity Management and Authentication Technologies</li> <li>Plan Account Management Policies for the Network and Systems</li> <li>Control Access to Cloud Objects</li> <li>Provision Accounts</li> </ul> <h3>7 - DETERMINING CPU AND MEMORY SIZING FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine CPU Size for Cloud Deployment</li> <li>Determine Memory Size for Cloud Deployment</li> </ul> <h3>8 - DETERMINING STORAGE REQUIREMENTS FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Storage Technology Requirements</li> <li>Select Storage Options for Deployment</li> <li>Determine Storage Access and Provisioning Requirements</li> <li>Determine Storage Security Options</li> </ul> <h3>9 - ANALYZING WORKLOAD CHARACTERISTICS TO ENSURE SUCCESSFUL MIGRATION</h3> <ul> <li>Determine the Type of Cloud Deployment to Perform</li> <li>Manage Virtual Machine and Container Migration</li> <li>Manage Network, Storage, and Data Migration</li> </ul> <h3>10 - MAINTAINING CLOUD SYSTEMS</h3> <ul> <li>Patch Cloud Systems</li> <li>Design and Implement Automation and Orchestration for Maintenance</li> </ul> <h3>11 - IMPLEMENTING BACKUP, RESTORE, DISASTER RECOVERY, AND BUSINESS CONTINUITY MEASURES</h3> <ul> <li>Back Up and Restore Cloud Data</li> <li>Implement Disaster Recovery Plans</li> <li>Implement Business Continuity Plans</li> </ul> <h3>12 - ANALYZING CLOUD SYSTEMS FOR PERFORMANCE</h3> <ul> <li>Monitor Cloud Systems to Measure Performance</li> <li>Optimize Cloud Systems to Meet Performance Criteria</li> </ul> <h3>13 - ANALYZING CLOUD SYSTEMS FOR ANOMALIES AND GROWTH FORECASTING</h3> <ul> <li>Monitor for Anomalies and Resource Needs</li> <li>Plan for Capacity</li> <li>Create Reports on Cloud System Metrics</li> </ul> <h3>14 - TROUBLESHOOTING DEPLOYMENT, CAPACITY, AUTOMATION, AND ORCHESTRATION ISSUES</h3> <ul> <li>Troubleshoot Deployment Issues</li> <li>Troubleshoot Capacity Issues</li> <li>Troubleshoot Automation and Orchestration Issues</li> </ul> <h3>15 - TROUBLESHOOTING CONNECTIVITY ISSUES</h3> <ul> <li>Identify Connectivity Issues</li> <li>Troubleshoot Connectivity Issues</li> </ul> <h3>16 - TROUBLESHOOTING SECURITY ISSUES</h3> <ul> <li>Troubleshoot Identity and Access Issues</li> <li>Troubleshoot Attacks</li> <li>Troubleshoot Other Security Issues</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Cloud Plus Certification (Exam CV0-003) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the CompTIA Cloud Plus Certification (Exam CV0-003) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

CompTIA Network+

Cloud Architecture

AWS Certified Cloud Practitioner

CompTIA A+

CompTIA Cloud+

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>The Microsoft 365 Endpoint Administrator is responsible for deploying, configuring, securing, managing, and monitoring devices and client applications in a corporate setting. Their duties include managing identity, access, policies, updates, and apps. They work alongside the M365 Enterprise Administrator to develop and execute a device strategy that aligns with the requirements of a modern organization. Microsoft 365 Endpoint Administrators should be well-versed in M365 workloads and possess extensive skills and experience in deploying, configuring, and maintaining Windows 11 and later, as well as non-Windows devices. Their role emphasizes cloud services over on-premises management technologies.</p><p></p><p></p><p>In this course, students will learn to plan and execute an endpoint deployment strategy using contemporary deployment techniques and implementing update strategies. The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Microsoft Entra ID, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data.</p><p></p>Prerequisites<p>The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 11 and later, and non-Windows devices.</p></div><div id="course-pills-2"><h3>1 - Explore the Enterprise Desktop</h3> <ul> <li>Examine benefits of modern management</li> <li>Examine the enterprise desktop life-cycle model</li> <li>Examine planning and purchasing</li> <li>Examine desktop deployment</li> <li>Plan an application deployment</li> <li>Plan for upgrades and retirement</li> </ul> <h3>2 - Explore Windows Editions</h3> <ul> <li>Examine Windows client editions and capabilities</li> <li>Select client edition</li> <li>Examine hardware requirements</li> </ul> <h3>3 - Understand Microsoft Entra ID</h3> <ul> <li>Examine Microsoft Entra ID</li> <li>Compare Microsoft Entra ID and Active Directory Domain Services</li> <li>Examine Microsoft Entra ID as a directory service for cloud apps</li> <li>Compare Microsoft Entra ID P1 and P2 plans</li> <li>Examine Microsoft Entra Domain Services</li> </ul> <h3>4 - Manage Microsoft Entra identities</h3> <ul> <li>Examine RBAC and user roles in Microsoft Entra ID</li> <li>Create and manage users in Microsoft Entra ID</li> <li>Create and manage groups in Microsoft Entra ID</li> <li>Manage Microsoft Entra objects with PowerShell</li> <li>Synchronize objects from AD DS to Microsoft Entra ID</li> </ul> <h3>5 - Manage device authentication</h3> <ul> <li>Describe Microsoft Entra join </li> <li>Examine Microsoft Entra join prerequisites limitations and benefits</li> <li>Join devices to Microsoft Entra ID</li> <li>Manage devices joined to Microsoft Entra ID</li> </ul> <h3>6 - Enroll devices using Microsoft Configuration Manager</h3> <ul> <li>Deploy the Microsoft Configuration Manager client</li> <li>Monitor the Microsoft Configuration Manager client</li> <li>Manage the Microsoft Configuration Manager client</li> </ul> <h3>7 - Enroll devices using Microsoft Intune</h3> <ul> <li>Manage mobile devices with Intune</li> <li>Enable mobile device management</li> <li>Explain considerations for device enrollment</li> <li>Manage corporate enrollment policy</li> <li>Enroll Windows devices in Intune</li> <li>Enroll Android devices in Intune</li> <li>Enroll iOS devices in Intune</li> <li>Explore device enrollment manager</li> <li>Monitor device enrollment</li> <li>Manage devices remotely</li> </ul> <h3>8 - Execute device profiles</h3> <ul> <li>Explore Intune device profiles</li> <li>Create device profiles</li> <li>Create a custom device profile</li> </ul> <h3>9 - Oversee device profiles</h3> <ul> <li>Monitor device profiles in Intune</li> <li>Manage device sync in Intune</li> <li>Manage devices in Intune using scripts</li> </ul> <h3>10 - Maintain user profiles</h3> <ul> <li>Examine user profile</li> <li>Explore user profile types</li> <li>Examine options for minimizing user profile size</li> <li>Deploy and configure folder redirection</li> <li>Sync user state with Enterprise State Roaming</li> <li>Configure Enterprise State Roaming in Azure</li> </ul> <h3>11 - Execute mobile application management</h3> <ul> <li>Examine mobile application management</li> <li>Examine considerations for mobile application management</li> <li>Prepare line-of-business apps for app protection policies</li> <li>Implement mobile application management policies in Intune</li> <li>Manage mobile application management policies in Intune</li> </ul> <h3>12 - Deploy and update applications</h3> <ul> <li>Deploy applications with Intune</li> <li>Add apps to Intune</li> <li>Manage Win32 apps with Intune</li> <li>Deploy applications with Configuration Manager</li> <li>Deploying applications with Group Policy</li> <li>Assign and publish software</li> <li>Explore Microsoft Store for Business</li> <li>Implement Microsoft Store Apps</li> <li>Update Microsoft Store Apps with Intune</li> <li>Assign apps to company employees</li> </ul> <h3>13 - Administer endpoint applications</h3> <ul> <li>Manage apps with Intune</li> <li>Manage Apps on non-enrolled devices</li> <li>Deploy Microsoft 365 Apps with Intune</li> <li>Additional Microsoft 365 Apps Deployment Tools</li> <li>Configure Microsoft Edge Internet Explorer mode</li> <li>App Inventory Review</li> </ul> <h3>14 - Protect identities in Microsoft Entra ID</h3> <ul> <li>Explore Windows Hello for Business</li> <li>Deploy Windows Hello</li> <li>Manage Windows Hello for Business</li> <li>Explore Microsoft Entra ID Protection</li> <li>Manage self-service password reset in Microsoft Entra ID</li> <li>Implement multi-factor authentication</li> </ul> <h3>15 - Enable organizational access</h3> <ul> <li>Enable access to organization resources</li> <li>Explore VPN types and configuration</li> <li>Explore Always On VPN</li> <li>Deploy Always On VPN</li> </ul> <h3>16 - Implement device compliance</h3> <ul> <li>Protect access to resources using Intune</li> <li>Explore device compliance policy</li> <li>Deploy a device compliance policy</li> <li>Explore conditional access</li> <li>Create conditional access policies</li> </ul> <h3>17 - Generate inventory and compliance reports</h3> <ul> <li>Report enrolled devices inventory in Intune</li> <li>Monitor and report device compliance</li> <li>Build custom Intune inventory reports</li> <li>Access Intune using Microsoft Graph API</li> </ul> <h3>18 - Deploy device data protection</h3> <ul> <li>Explore Windows Information Protection</li> <li>Plan Windows Information Protection</li> <li>Implement and use Windows Information Protection</li> <li>Explore Encrypting File System in Windows client</li> <li>Explore BitLocker</li> </ul> <h3>19 - Manage Microsoft Defender for Endpoint</h3> <ul> <li>Explore Microsoft Defender for Endpoint</li> <li>Examine key capabilities of Microsoft Defender for Endpoint</li> <li>Explore Windows Defender Application Control and Device Guard</li> <li>Explore Microsoft Defender Application Guard</li> <li>Examine Windows Defender Exploit Guard</li> <li>Explore Windows Defender System Guard</li> </ul> <h3>20 - Manage Microsoft Defender in Windows client</h3> <ul> <li>Explore Windows Security Center</li> <li>Explore Windows Defender Credential Guard</li> <li>Manage Microsoft Defender Antivirus</li> <li>Manage Windows Defender Firewall</li> <li>Explore Windows Defender Firewall with Advanced Security</li> </ul> <h3>21 - Manage Microsoft Defender for Cloud Apps</h3> <ul> <li>Explore Microsoft Defender for Cloud Apps</li> <li>Planning Microsoft Defender for Cloud Apps</li> <li>Implement Microsoft Defender for Cloud Apps</li> </ul> <h3>22 - Assess deployment readiness</h3> <ul> <li>Examine deployment guidelines</li> <li>Explore readiness tools</li> <li>Assess application compatibility</li> <li>Explore tools for application compatibility mitigation</li> <li>Prepare network and directory for deployment</li> <li>Plan a pilot</li> </ul> <h3>23 - Deploy using the Microsoft Deployment Toolkit</h3> <ul> <li>Evaluate traditional deployment methods</li> <li>Set up the Microsoft Deployment Toolkit for client deployment</li> <li>Manage and deploy images using the Microsoft Deployment Toolkit</li> </ul> <h3>24 - Deploy using Microsoft Configuration Manager</h3> <ul> <li>Explore client deployment using Configuration Manager</li> <li>Examine deployment components of Configuration Manager</li> <li>Manage client deployment using Configuration Manager</li> <li>Plan in-place upgrades using Configuration Manager</li> </ul> <h3>25 - Deploy Devices using Windows Autopilot</h3> <ul> <li>Use Autopilot for modern deployment</li> <li>Examine requirements for Windows Autopilot</li> <li>Prepare device IDs for Autopilot</li> <li>Implement device registration and out-of-the-box customization</li> <li>Examine Autopilot scenarios</li> <li>Troubleshoot Windows Autopilot</li> </ul> <h3>26 - Implement dynamic deployment methods</h3> <ul> <li>Examine subscription activation</li> <li>Deploy using provisioning packages</li> <li>Use Windows Configuration Designer</li> <li>Use Microsoft Entra join with automatic MDM enrollment</li> </ul> <h3>27 - Plan a transition to modern endpoint management</h3> <ul> <li>Explore using co-management to transition to modern endpoint management</li> <li>Examine prerequisites for co-management</li> <li>Evaluate modern management considerations</li> <li>Evaluate upgrades and migrations in modern transitioning</li> <li>Migrate data when modern transitioning</li> <li>Migrate workloads when modern transitioning</li> </ul> <h3>28 - Manage Windows 365</h3> <ul> <li>Explore Windows 365</li> <li>Configure Windows 365</li> <li>Administer Windows 365</li> </ul> <h3>29 - Manage Azure Virtual Desktop</h3> <ul> <li>Examine Azure Virtual Desktop</li> <li>Explore Azure Virtual Desktop</li> <li>Configure Azure Virtual Desktop</li> <li>Administer Azure Virtual Desktop</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans MD-102T00 : Microsoft 365 Endpoint Administrator training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the MD-102T00 : Microsoft 365 Endpoint Administrator course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

831 Design courses in Leicester

Gas Conditioning and Processing

By EnergyEdge - Training for a Sustainable Energy Future

Front End Loading in Oil and Gas Projects

By EnergyEdge - Training for a Sustainable Energy Future

Transformer Maintenance

By EnergyEdge - Training for a Sustainable Energy Future

Portfolio, Programs, & Project Offices Practitioner: In-House

By IIL Europe Ltd

Total QoS for engineers

By Systems & Network Training

Complete Visual BASIC

By Systems & Network Training

Geomechanics

By EnergyEdge - Training for a Sustainable Energy Future

Essential GEPON

By Systems & Network Training

Coiled Tubing Operations - Equipment, Applications, Well Control, Safety & Emerging Technologies

By EnergyEdge - Training for a Sustainable Energy Future

Gas Turbines, Co-Generation and Combined Cycle Power Plants

By EnergyEdge - Training for a Sustainable Energy Future

Search By Location