Name: Industrial Instrumentation and Modern Control Systems
Price: 3009 GBP
Availability: InStock

London

<h2>SAFe® Agile Product Management: In-House Training</h2>
<p>Discover and apply the mindset, skills, and tools you need to create successful products and solutions that are desirable, viable, feasible, and sustainable.</p>
<p>The Agile Product Management course harnesses the power of Design Thinking to develop innovative solutions with proven SAFe® capabilities to execute on those visions. Learn the right mindset, skills, and tools to create successful products  from inception to retirement using Agile techniques. Recognize how Continuous Exploration fuels innovation and helps you define a vision, strategy, and roadmap to tap into new markets. Find out how to accelerate the product life cycle to get fast feedback and quickly deliver exceptional products and solutions that delight customers  all while aligning with your organization's strategy, portfolio, evolving architecture, and solution intent.</p><h3>What you will Learn</h3>
<p>After completing the class, you should be able to:</p>
<ul>
<li>Use Design Thinking to achieve desirable, feasible, and sustainable outcomes</li>
<li>Explore market needs, segmentation, sizing, and competitive landscape</li>
<li>Manage value stream economics, including pricing and licensing</li>
<li>Use empathy to drive design</li>
<li>Apply product strategy and vision</li>
<li>Develop and evolve roadmaps</li>
<li>Execute and deliver value using SAFe®</li>
<li>Explore innovation in the value stream</li>
</ul><section>
                    <ul><li>Analyzing your Role as a Product Manager in the Lean Enterprise</li><li>Continuously Exploring Markets and Users</li><li>Driving Strategy with Market Segmentation</li><li>Using Empathy to Drive Design</li><li>Defining Product Strategy and Vision</li><li>Creating Roadmaps to Build Solutions</li><li>Delivering Value</li><li>Managing Value Stream Economics</li><li>Creating Innovation in the Value Stream</li></ul>


                </section>

IIL Europe Ltd

SAFe Agile Product Management: In-House Training

General Admission

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong></h2>
<p>Process Hazard Assessment using the HAZOP Technique is an intensely participative course that will both explain the key facets of the HAZOP technique as well as provide ample opportunities for participants to practice and become familiar with the technique using generic and real-life examples.</p>
<p>HAZOP Team Leader Training is an intensely participative course that will develop participants already familiar with the HAZOP technique, the skills, knowledge and attributes of a HAZOP Team Leader. An in-depth syndicate exercise will provide the opportunity to lead a HAZOP team (consisting of other participants) and to be observed performing the role for constructive feedback.</p>
<p>This 5 full-day course has been reviewed and approved by the Institution of Chemical Engineers (IChemE). IChemE is the global professional membership organisation for chemical, biochemical and process engineers and other professionals involved in the chemical, process and bioprocess industries. Their knowledge of professional standards, close involvement with industry, education and regulators, and their expertise as a leading global training provider, means they are uniquely positioned to independently assess and approve training courses and professional development programmes across the world.</p>
<figure></figure>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p><strong>Process Hazard Assessment using the HAZOP Technique</strong> By the end of this course, participants will be able to:</p>
<ul>
<li>Understand the basic HAZOP Technique</li>
<li>Fulfill roles as competent HAZOP Team Members</li>
<li>Understand the role of HAZOP in risk management</li>
<li>Understand how Hazard Identification can predict accidents and incidents</li>
<li>Understand how HAZOP complements other hazard identification tool</li>
</ul>
<p><strong>HAZOP Team Leader Training</strong> By the end of this course, participants will be able to:</p>
<ul>
<li>Understand the role of the HAZOP Team Leader</li>
<li>Practise the role in a classroom environment</li>
<li>Provide feedback to participants on their performance as HAZOP Team Leaders</li>
<li>Appreciate the leadership skills required as HAZOP Team Leader</li>
<li>Plan, organise, manage and successfully undertake a Hazard and Operability study</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This course will benefit:</p>
<ul>
<li>All key persons in the organisation, who by their discipline and/or position, are likely to be called on to initiate, participate or review a HAZOP study.</li>
<li>All who have responsibility for the management and supervision of process &amp; safety including but not limited to Senior Management, Plant Managers, Process and Maintenance Engineers (all disciplines), Line Supervisors, Team Leaders, Safety Specialists, and Process Training Instructors.</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>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader has 50 years' experience in chemical and process safety engineering. His early career included 20 years in design and project engineering with various fine chemical and pharmaceutical companies where he designed chemical processes, specified plant equipment and selected materials for highly corrosive and toxic processes, often where textbook data was not available. This was followed by 10 years in offshore oil and gas design projects where he was responsible for setting up a Technical Safety group to change design safety practices in the aftermath of the 1988 Piper Alpha disaster. In recent years, he has been called upon to conduct various offshore and onshore incident investigations.</p>
<p>His career has given him experience in project engineering, project management, process design and operations, safety engineering and risk management. He is a Fellow of the UK Institution of Chemical Engineers. He served on the Scottish Branch committee, and was elected chairman for a two-year term in 1991. He has also been chairman of the Safety and Reliability Society - North of Scotland Branch.</p>
<p>He has delivered training courses in Process Hazard Analysis (HAZOP and HAZID), Process Safety Management, Hazard Awareness, Risk Assessment, Root Cause Analysis, Failure Modes &amp; Effect Analysis and has lectured on Reliability Analysis to the M.Sc. course in Process Safety and Loss Prevention at Sheffield University. In addition to delivering training courses, he currently facilitates HAZOP / HAZID / LOPA studies and undertakes expert witness roles advising lawyers engaged in contractual disputes, usually involving the design or construction of chemical plants or Oil &amp; Gas production facilities, or criminal prosecutions.</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>

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Process Hazard Assessment using the HAZOP Technique and HAZOP Team Leader Training

Team of 10, pp

Normal Fee, pp

<h4>Overview</h4>
						<hr />
						<div></div>
							<p>
							</p><p>In this course participants will learn how to design, implement as well as achieve desired results from the Public Relations as well as Strategic Marketing along with promoting the product and services of their organisations. </p>
<p>
							
							</p><div>
						
					</div>

GBA Corporate

PR, Brand Management and Strategic Management

Online

On Site

<h2>SAFe® Agile Software Engineering: In-House Training</h2>
<p>The introduction of Lean-Agile and DevOps principles and practices into software engineering has sparked new skills and approaches that help organizations deliver higher-quality, software-centric solutions faster and more predictably.</p>
<p>This workshop-oriented course explores foundational principles and practices and how continuous flow of value delivery and built-in quality are enabled by XP technical practices, Behavioral-Driven Development (BDD), and Test-Driven Development (TDD). Attendees will learn proven practices to detail, model, design, implement, verify, and validate stories in the SAFe® Continuous Delivery Pipeline, as well as the practices that build quality into code and designs. Attendees will also explore how software engineering fits into the larger solution context and understand their role in collaborating on intentional architecture and DevOps.</p><h3>What you will Learn</h3>
<p>To perform the role of a SAFe® Agile Software Engineer, you should be able to:</p>
<ul>
<li>Define Agile Software Engineering and the underlying values, principles, and practices</li>
<li>Apply the Test-First principle to create alignment between tests and requirements</li>
<li>Create shared understanding with Behavior-Driven Development (BDD)</li>
<li>Communicate with Agile modeling</li>
<li>Design from context for testability</li>
<li>Build applications with code and design quality</li>
<li>Utilize the test infrastructure for automated testing</li>
<li>Collaborate on intentional architecture and emergent design</li>
<li>Apply Lean-Agile principles to optimize the flow of value</li>
<li>Create an Agile Software Engineering plan</li>
</ul><section>
                    <ul><li>Introduction to Agile Software Engineering</li><li>Connecting Principles and Practices to Built-in Quality</li><li>Accelerating Flow</li><li>Applying Intentional Architecture</li><li>Thinking Test-First</li><li>Discovering Story Details</li><li>Creating a Shared Understanding with Behavior-Driven Development (BDD)</li><li>Communicating with Models</li><li>Building Systems with Code Quality</li><li>Building Systems with Design Quality</li><li>Implementing with Quality</li></ul>


                </section>

SAFe Agile Software Engineering: In-House Training

Redhill

<h3><b>GPON and FTTx networks training course description</b></h3>
      <p>  Designed to benefit those requiring an in depth
knowledge of the principles and applications of Ten
Gigabit and Gigabit Passive Optical Networking and
Fibre to the X in NG Networks applications and their
associated equipment, its flexibility and function within
a modern transmission network.<br />
Using an effective mix of 'hands on' equipment
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 PON/FTTx systems.</li>
																				<li>Explain network elements and designs.</li>
                    <li>Support applications and network interfaces.</li>
                    <li>List circuit provisioning and bandwidth requirements.</li>
                    <li>Understand upstream &amp; downstream issues.</li>
                     <li>Describe headend &amp; network elements/OLT-ONT.</li>
                     <li>Perform network testing with OTDR test sets.</li>
				</ul>
        <h5>
        <b>GPON and FTTx networks training course details</b></h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
           <p>Anyone working with GPON and FTTx.</p>
              
							<li><b>Prerequisites:</b></li>
							
                 <p>Introduction to data communications and networking.</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
               
              
						</ul>
					</div>
				</div>
     <h3><b>GPON and FTTx training course contents</b></h3>
      <ul>
				<li>FTTN, FTTC, FTTH </li><p>
SMF, 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.

</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>PON variants </li><p>
Gigabit passive optical network (GPON), Gigabit Ethernet passive optical network (GEPON), Time division PON (TDM-PON), Wave Division Multiplexing PON (WDM-PON), 1Gbps, 10Gbps, 40Ggps, 100Gbps FSAN (Full Service Access Network) NGA (Next Generation Access), 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>
GPON OSP centralized and distributed design, GPON PON splitters x4 x8 x32, Fibre splice trays /cassette trays &amp; enclosures, GPON field testing and installation verification, GPON physical layer testing, Optical time domain reflectometer (OTDR), Optical power source &amp; meter, Optical return loss (ORL), APON/BPON/GPON/EPON comparisons.

</p><li>GPON ITU-T G.984.1 </li><p>
Reference model, terminology &amp; architecture, Access network system management functions. ONT &amp; OLT functional block examples. FTTx scenarios, 4 switching arrangements for external access network backup.

</p><li>GPON ITU-T G.984.2 </li><p>
Physical layer, Enhancement band, Bit rate and wavelengths, FEC and RAMAN.

</p><li>GPON ITU-T G.984.3 </li><p>
Frame structure, GPON encapsulation method (GEM), GTC adaptation and framing sublayer protocol stack, Status reporting &amp; traffic monitoring DBA (SR-DBA &amp; TM-DBA), Transmission container (T-CONT) types, Downstream &amp; upstream multiplexing, GEM port identifier, Media access control and ONU registration, Extended bandwidth assignment model scheduling architecture, PLOAM &amp; alarm messages, Downstream &amp; Upstream FEC, Process order in a GTC transmit flow.

</p><li>GPON ITU-T G.984.4 and G.988 ONT management and control interface (OMCI) </li><p>
Management interface, Reference model, Typical ONT with SCTE 55-1 or SCTE 55-2 compliancy.

</p><li>GPON ITU-T G.984.5 enhancement band </li><p>
Band options, GPON NGA, Wavelength allocation.

</p><li>GPON ITU-T G.984.6 optical reach extension (G.984.re) </li><p>
Reach extension (RE), OA-based and OEO-based reach extenders, Protection, Reach extender with OTDR blocking filters (BF) and bypass (BYP) filters.

</p><li>GPON ITU-T G.984.7 long reach </li><p>
Quiet Window.

</p><li>10-GPON ITU-T G.987.1 (XG-PON) </li><p>
Scenarios, reference access network architecture, XG-PON with G-PON through WDM1r, G-PON and XG-PON wavelength allocation, G-PON and XG-PON co-existence with video overlay option, RE migration scenarios.

</p><li>G.989 40Gbps XG-PON2 </li><p>
Functional reference architecture, NG-PON2 system coexistence with legacy systems, Definitions of legacy compatibility terminology.

</p><li>GPON issues and standards </li><p>
GPON components GPON OLT / GPON ONT, GPON management, Operational support systems (OSS), Network management systems (NMS), OMCI (ONT Management control interface), RG (Residential gateway), Data and prioritised voice channel product, GPON broadband-forum standards, Broadband-forum , TR-069 and TR-156, HPNA (home phone network alliance), Powerline carrier (PLC), GPON DLNI G.hn or G.9960, MOCA, FTTH council certification standard for network certification. Fibre-connected home badge, Ethernet in the first mile (EFM), GPON frame synchronization to network timing, Direct clock synchronization interface (BITS), Multiservice access platform (MSAP), Software planning tool, Superconnected cities / voucher scheme.

</p><li>Hands on practical assignments </li><p>
Single and multimode fibre recognition, Fibre Cleaning methods, Checking cleaning with an optical microscope, Optical light source and optical power meter referencing, PON splitter and fibre drum testing with an optical power meter, 6km classroom passive optical network testing with an OTDR at 1310/1550nm, Using decibels (dB's) and decibel milliwats (dBm's), Designing networks up to 20km long using vendor specifications (power budget), Fault finding with a visible fault locator.
</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

GPON and FTTx networks

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong></h2>
<p>Well engineers who are responsible for technically evaluating and authorizing programs for drilling or working over wells must have the required skills and competencies to safely design wells of varying nature. They also need to be able to confirm that well delivery and intervention programs generate intrinsic well control assurance. Such work programs must establish, verify, monitor and maintain suitable and sufficient barriers for the entire well lifecycle - from spud to abandonment. Well engineers must also be able to select a suitable drilling or workover rig, capable of safely performing the work within its operational envelope.</p>
<p>This 3 full-day course aims to further develop and assess the knowledge required to work on and eventually, authorize a well delivery program as deemed fit for purpose. It also addresses elements of well control that must be embedded into well design, well work programming and equipment selection.</p>
<p>This course is intended for participants who already have a sound understanding of the principles of the design and/or delivery of wells and with more than 3 years of relevant industry experience.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>By the end of this course, participants will be able to:</p>
<ul>
<li>Feel confident to design and plan drilling and workover activities while considering geological risks, formation pressures/strengths, and any integrity or well control concerns.</li>
<li>Monitor wells operations and ensure that they can and will remain within the accepted design envelope.</li>
<li>Assess risks and then apply mitigation or recovery methods in cases where design envelopes are threatened.</li>
</ul>
<p>Participants should be capable of assessing a drilling or workover program and then be able to answer the following key questions:</p>
<ol>
<li>Does the program delivery have a sound design and work plan that allows the well(s) to be drilled or worked over safely?</li>
<li>Have we determined the appropriate kick tolerance for each open hole section and is it realistic for all drilling hazards that may be encountered?</li>
<li>Have all drilling hazards been suitably assessed, and the associated risk mitigated to a level as low as reasonably practicable?</li>
<li>Are there adequate, verifiable barriers in place throughout the operation and does everybody know their role and responsibility?</li>
<li>And, as applicable, is the selected rig capable of implementing the work program?</li>
</ol>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This course is intended for <strong>personnel directly or indirectly involved in the preparation, review or authorization of drilling and workover programs</strong>. This includes:</p>
<ul>
<li>Well engineers and drilling supervisors who are responsible for planning and executing drilling and workover operations.</li>
<li>Contractor well engineers, rig managers and other senior drilling staff.</li>
<li>Senior well engineers and rig superintendents who are responsible for managing the delivery of a project or well.</li>
<li>Technical authority holders who are responsible for licensing drilling and workover operations from a regulatory perspective.</li>
</ul>
<p><strong>Assessment:</strong> A satisfactory command of critical knowledge and skills is assured by a 1+ hour closed book assessment. This assessment has a mix of multiple-choice questions (MCQs), calculations and answers that must be written up. The exam is taken electronically. Participants are provided with a suitable formula sheet. The pass mark for issuing a certificate is 70% and participants who are not successful will be issued with a certificate of attendance instead.</p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader has over 45 years of experience in the Oil &amp; Gas industry. During that time, he has worked exclusively in the well engineering domain. After being employed in 1974 by Shell, one of the major oil &amp; gas producing operators, he worked as an apprentice on drilling rigs in the Netherlands. After a year, he was sent for his first international assignment to the Sultanate of Oman where he climbed up the career ladder from Assistant Driller, to Driller, to wellsite Petroleum Engineer and eventually on-site Drilling Supervisor, actively engaged in the drilling of development and exploration wells in almost every corner of this vast desert area. At that time, drilling techniques were fairly basic and safety was just a buzz word, but such a situation propels learning and the fruits of 'doing-the-basics' are still reaped today when standing in front of a class. After some seven years in the Middle East, a series of other international assignments followed in places like the United Kingdom, Indonesia, Turkey, Denmark, China, Malaysia, and Russia. Apart from on-site drilling supervisory jobs on various types of drilling rigs (such as helicopter rigs) and working environments (such as jungle and artic), he was also assigned to research, to projects and to the company's learning centre. In research, he was responsible for promoting directional drilling and surveying and advised on the first horizontal wells being drilled, in projects, he was responsible for a high pressure drilling campaign in Nigeria while in the learning centre, he looked after the development of new engineers joining the company after graduating from university. He was also involved in international well control certification and served as chairman for a period of three years. In the last years of his active career, he worked again in China as a staff development manager, a position he nurtured because he was able to pass on his knowledge to a vast number of new employees once again. After retiring in 2015, he has delivered well engineering related courses in Australia, Indonesia, Brunei, Malaysia, China, South Korea, Thailand, India, Dubai, Qatar, Kuwait, The Netherlands, and the United States. The training he provides includes well control to obtain certification in drilling and well intervention, extended reach drilling, high pressure-high temperature drilling, stuck pipe prevention and a number of other ad-hoc courses. He thoroughly enjoys training and is keen to continue taking classes as an instructor for some time to come.</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>

Advanced Well Engineering

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong></h2>
<p>This intermediate to advanced level 3 full-day training course has been designed to provide participants with a detailed and up-to-date overview of the fluid mechanic fundamentals and operating practice of pumps, compressors and gas and steam turbines. Upon the successful completion of this course, participants will have acquired the practical knowledge to enable them not only to choose the correct device for a particular application but also be in a position to resolve many commonly occurring operating problems. Troubleshooting is an important part of this course and will cover the important topics of Machinery Root Cause Failure Analysis (RCFA) together with Vibration Analysis.</p>
<p>This course is ideal for those personnel in the oil, gas, petrochemical, chemical, power and other process industries who require a wider and deeper appreciation of pumps, compressors and turbines, including their design, performance and operation. The participants will be taken through an intensive primer of turbo-machinery principles, using the minimum of mathematics, and will learn how to solve the many and varied practical industrial problems that are encountered. The course makes use of an extensive collection of VIDEO material together with case studies and numerical exercises.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>Upon the successful completion of this course, each participant will be able to:</p>
<ul>
<li>Apply a comprehensive knowledge of pumps, compressors &amp; turbines and troubleshoot rotating equipment in a professional manner</li>
<li>Identify the different types of turbomachinery including basic design aspects and highlighted problem areas</li>
<li>Minimise compressor work by understanding the processes involved and identifying their efficiency</li>
<li>Understand the flow through turbomachines and the corresponding velocity triangles including torque and power calculations</li>
<li>Analyse the different types of centrifugal machines including their design, installation, operation, maintenance, re-rate/retrofit, troubleshooting and control</li>
<li>Recognise the various beneficial design aspects of turbomachines and understand the crucial process of cavitation</li>
<li>Carry out proper methods of device installation, operation, maintenance and troubleshooting</li>
<li>Understand and apply the powerful methods of Machinery Root Cause Failure Analysis</li>
<li>Understand the various methods of vibration analysis applied to device diagnostics</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This course provides an overview of all significant aspects and considerations of pumps, compressors and turbines for those who are involved in the design, selection, maintenance or troubleshooting of such equipment. This includes maintenance, reliability, integrity, engineering, production and operations managers, engineers and other technical staff.  </p>
</div>
</div>
</div>
<div>
<div>

Course Level 

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

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader is a Senior Mechanical &amp; Instrumentation Engineer (UK, B. Sc., M.Eng., Ph D) with over 45 years of industrial experience in Process Control &amp; Instrumentation, Pumps, Compressors, Turbines and Control Valve Technology.</p>
<p>He is currently a Senior Independent Consultant to various petrochemical industries in the UK, USA, Oman, Kuwait and KSA where he provides consultancy services on both the application and operational constraints of process equipment in the oil &amp; gas industries.</p>
<p>During his early career, he held key positions in Rolls Royce (UK) where he was involved in the design of turbine blading for jet engines, subject to pre-specified distributions of pressure. During this period and since, he has also been closely involved in various aspects of Turbomachinery, Thermodynamics and Fluid Mechanics where he has become a recognised authority in these areas.</p>
<p>Later, he joined the academic staff of University of Liverpool in the UK as a Professor in Mechanical Engineering Courses. A substantial part of his work has been concerned with detailed aspects of Flowmetering - both of single &amp; multiphase flows. He has supervised doctoral research students in this area in collaboration with various European flowmeter manufacturers.</p>
<p>He joined Haward Technology Middle East in 2002 and was later appointed as European Manager (a post which has since lapsed) and has delivered over 150 training courses in Flowmeasurement (single- and multi-phase), Control, Heat Exchangers, Pumps, Turbines, Compressors, Valve and Valve Selection as well as other topics throughout the UK, USA, Oman and Kuwait. During the last two years, he has delivered courses with other training companies operating in the Far and Middle East. He has published about 150 papers in various Engineering Journals and International Conferences and has contributed to textbooks on the topics listed above.</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>

Pumps, Compressors, Turbines & Troubleshooting

<div>
</div>
<section>
<div>
<h2>About this training course</h2>
<p>Artificial lift systems are an important part of production operations for the entire lifecycle of an asset. Often, oil and gas wells require artificial lift for most of the life cycle. This 5-day training course offers a thorough treatment of artificial lift techniques including design and operation for production optimization. With the increasing need to optimize dynamic production in highly constrained cost environments, opportunities and issues related to real-time measurements and optimization techniques needs to be discussed and understood. Artificial lift selection and life cycle analysis are covered. These concepts are discussed and reinforced using case studies, quizzing tools, and exercises with software. Participants solve examples and class problems throughout the course. Animations and videos reinforce the concepts under discussion.</p>
<p>Understanding of these important production concepts is a must have to exploit the existing assets profitably.</p>
<p><strong>Unique Features:</strong></p>
<ul>
<li>Hands-on usage of <strong>SNAP Software</strong> to solve gas-lift exercises</li>
<li>Discussion on <strong>digital oil field</strong></li>
<li><strong>Machine learning</strong> <strong>applications</strong> in gas-lift optimization</li>
</ul>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>After the completion of this training course, participants will be able to:</p>
<ul>
<li>Understand the basics and advanced concepts of each form of artificial lift systems including application envelope, relative strengths, and weaknesses</li>
<li>Easily recognize the different components from downhole to the surface and their basic structural and operational features</li>
<li>Design and analyze different components using appropriate software tools</li>
<li>Understand challenges facing artificial lift applications and the mitigation of these challenges during selection, design, and operation</li>
<li>Learn about the role of digital oilfield tools and techniques and their applications in artificial lift and production optimization</li>
<li>Learn about use cases of Machine learning and artificial intelligence in the artificial lift</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This training course is suitable and will greatly benefit the following specific groups:</p>
<ul>
<li>Production, reservoir, completion, drilling and facilities engineers, analysts, and operators</li>
<li>Anyone interested in learning about selection, design, analysis and optimum operation of artificial lift and related production systems will benefit from this course.</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Course Level 

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

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><span>The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization.</span></p>
<p><em><span>Course Duration: 5 days in total (35 hours).</span></em></p>
<p><strong><span>Training Schedule</span></strong></p>
<p><span>0830 - Registration </span><span>0900 - Start of training </span><span>1030 - Morning Break </span><span>1045 - Training recommences </span><span>1230 - Lunch Break </span><span>1330 - Training recommences </span><span>1515 - Evening break </span><span>1530 - Training recommences </span><span>1700 - End of Training</span></p>
<p><span>The maximum number of participants allowed for this training course is 20.</span></p>
<p>This course is also available through our Virtual Instructor Led Training (VILT) format.</p>
<p><strong>Prerequisites:</strong></p>
<ul>
<li>Understanding of petroleum production concepts.</li>
<li>Each participant needs a laptop/PC for solving class examples using software to be provided during class. Laptop/PC needs to have a current Windows operating system and at least 500 MB free disk space. Participants should have administrator rights to install software.</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader has over 35 years' work-experience in multiphase flow, artificial lift, real-time production optimization and software development/management. His current work is focused on a variety of use cases like failure prediction, virtual flow rate determination, wellhead integrity surveillance, corrosion, equipment maintenance, DTS/DAS interpretation. He has worked for national oil companies, majors, independents, and service providers globally. He has multiple patents and has delivered a multitude of industry presentations. Twice selected as an SPE distinguished lecturer, he also volunteers on SPE committees. He holds a Bachelor's and Master's in chemical engineering from the Gujarat University and IIT-Kanpur, India; and a Ph.D. in Petroleum Engineering from the University of Tulsa, USA.</p>
<p><strong>Highlighted Work Experience: </strong></p>
<ul>
<li>At Weatherford, consulted with clients as well as directed teams on digital oilfield solutions including LOWIS - a solution that was underneath the production operations of Chevron and Occidental Petroleum across the globe.</li>
<li>Worked with and consulted on equipment's like field controllers, VSDs, downhole permanent gauges, multiphase flow meters, fibre optics-based measurements.</li>
<li>Shepherded an enterprise-class solution that is being deployed at a major oil and gas producer for production management including artificial lift optimization using real time data and deep-learning data analytics.</li>
<li>Developed a workshop on digital oilfield approaches for production engineers.</li>
</ul>
<p><strong>Patents:</strong></p>
<ul>
<li>Principal inventor: 'Smarter Slug Flow Conditioning and Control'</li>
<li>Co-inventor: 'Technique for Production Enhancement with Downhole Monitoring of Artificially Lifted Wells'</li>
<li>Co-inventor: 'Wellbore real-time monitoring and analysis of fracture contribution'</li>
</ul>
<p><strong>Worldwide Experience in Training / Seminar / Workshop Deliveries:</strong></p>
<ul>
<li>Besides delivering several SPE webinars, ALRDC and SPE trainings globally, he has taught artificial lift at Texas Tech, Missouri S&amp;T, Louisiana State, U of Southern California, and U of Houston.</li>
<li>He has conducted seminars, bespoke trainings / workshops globally for practicing professionals:
<ul>
<li><u>Companies:</u> Basra Oil Company, ConocoPhillips, Chevron, EcoPetrol, Equinor, KOC, ONGC, LukOil, PDO, PDVSA, PEMEX, Petronas, Repsol, , Saudi Aramco, Shell, Sonatrech, QP, Tatneft, YPF, and others.</li>
<li><u>Countries:</u> USA, Algeria, Argentina, Bahrain, Brazil, Canada, China, Croatia, Congo, Ghana, India, Indonesia, Iraq, Kazakhstan, Kenya, Kuwait, Libya, Malaysia, Oman, Mexico, Norway, Qatar, Romania, Russia, Serbia, Saudi Arabia, S Korea, Tanzania, Thailand, Tunisia, Turkmenistan, UAE, Ukraine, Uzbekistan, Venezuela.</li>
<li>Virtual training provided for PetroEdge, ALRDC, School of Mines, Repsol, UEP-Pakistan, and others since pandemic.</li>
</ul>
</li>
</ul>
</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>

Artificial Lift and Real-Time Production Optimization in Digital Oilfield

<h3><b>Networking Microsoft Systems course description</b></h3>
      <p>A hands-on course covering the network aspects of Microsoft systems. The course progresses from basic TCP/IP tools and configuration settings through to advanced security considerations finishing with an overview of Exchange and IIS. Hands on sessions are based on a choice of Windows Server 2003 or Windows 2000 server and Windows XP or Windows 2000 professional. Customised versions with other Microsoft platforms are also available. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	<li>Design networks with consideration for Microsoft issues such as logons.</li>
					<li>Design, configure and troubleshoot TCP/IP, DNS, WINS and DHCP.</li>
                    <li>Configure security features such as PKI and IPSec.</li>
                    <li>Describe the Windows TCP/IP implementation details.</li>
                  </ul>
        <h5>
        <b>Networking Microsoft Systems course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with Microsoft systems.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>TCP/IP foundation for engineers<br />
                    Supporting Windows ( XP or 2000 or 2003)</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Networking Microsoft Systems course contents</b></h3>
      <ul>
				<li>Configuring network cards </li><p>
PnP, resources, Ethernet cards, wireless cards, dial up networking, other cards, Ethernet settings, layer 2 QoS.

</p><li>Configuring and supporting IP </li><p>
Basic IP settings, advanced IP settings, advanced TCP settings, DrTCP and registry settings, security  
</p><li>DHCP </li><p>
DHCP server, authorising the DHCP service, DHCP client, DHCP relays, Address pools, options, lease duration's, Integrating with DNS.

</p><li>Microsoft networking overview </li><p>
Workgroups and domains, Domain controllers, the logon process in a network, the role of Active Directory, synchronisation, protocol stacks and bindings.

</p><li>Accessing file and print resources </li><p>
Shared folders, permissions, network printers, browsing, NetBIOS, SMB.

</p><li>WINS </li><p>
Servers, clients, Client registration, renewing and releasing of names. NetBIOS node types.

</p><li>DNS1	 </li><p>
Overview, Primary and secondary servers, DDNS, zones, resource records.

</p><li>The browser service </li><p>
Master, backup and other browser roles, elections, announcements, recovery from failure, Inter subnet browsing.

</p><li>TCP/IP implementation details </li><p>
Dead gateway detection, Multi homing, multicasting, MTU path discovery, registry settings, QOS and RSVP, Windows as a router, performance implications of Microsoft services.

</p><li>Internet Access </li><p>
Options, NAT, Firewall capabilities and Proxy server, Internet Authentication Service.

</p><li>Remote Access </li><p>
Installing, RAS servers. RAS process, protocols

</p><li>Security: PKI </li><p>
PPTP, L2TP, What is IPSec, configuring IPSec.

</p><li>Security: VPNs </li><p>
PPTP, L2TP, What is IPSec, configuring IPSec.

</p><li>Other Microsoft networking services &amp; tools </li><p>
Netmeeting, instant messaging, white boarding, document collaboration, video conferencing Microsoft Exchange, IIS, Directory replication, SNMP, Net Monitor, integration with other platforms.
</p>
      </ul>

Networking Microsoft Systems

<div>
</div>
<section>
<div>
<h2><strong>About this training course</strong></h2>
<p>This 5 full-day course provide a comprehensive understanding of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, HART protocol, control valves, actuators, and smart technology. This course will focus on maximizing the efficiency, reliability, and longevity of these systems and equipment by providing an understanding of the characteristics, selection criteria, common problems and repair techniques, preventive and predictive maintenance.</p>
<p>This course is a MUST for anyone who is involved in the selection, applications, or maintenance of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology because it covers how these systems and equipment operate, the latest maintenance techniques, and provides guidelines and rules that ensure their successful operation. In addition, this course will cover in detail the basic design, operating characteristics, specification, selection criteria, advanced fault detection techniques, critical components and all preventive and predictive maintenance methods in order to increase the reliability of these systems andequipment and reduce their operation and maintenance cost</p>
<p>This course will provide the following information for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology:</p>
<ul>
<li>Basic Design</li>
<li>Specification</li>
<li>Selection Criteria</li>
<li>Sizing Calculations</li>
<li>Enclosures and Sealing Arrangements</li>
<li>Codes and Standards</li>
<li>Common Operational Problems</li>
<li>All Diagnostics, Troubleshooting, Testing, and Maintenance</li>
</ul>
<p>Practical applications of smart instrumentation, SCADA, and Distributed Control Systems, control valves, actuators, etc in the following industries will be discussed in detail:</p>
<ul>
<li>Chemical and petrochemical</li>
<li>Power generation</li>
<li>Pulp and paper</li>
<li>Aerospace</li>
<li>Water and sewage treatment</li>
<li>Electrical power grids</li>
<li>Environmental monitoring and control systems</li>
<li>Pharmaceutical plants</li>
</ul>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<ul>
<li><strong><span>Equipment Operation: </span></strong><span>Gain a thorough understanding of the operating characteristics of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>Equipment Diagnostics and Inspection:</span></strong><span> Learn in detail all the diagnostic techniques and inspections required of critical components of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>Equipment Testing:</span></strong><span> Understand thoroughly all the tests required for the various types of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>Equipment Maintenance and Troubleshooting: </span></strong><span>Determine all the maintenance and troubleshooting activities required to minimize the downtime and operating cost of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>Equipment Repair and Refurbishment:</span></strong><span> Gain a detailed understanding of the various methods used to repair and refurbish modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>Efficiency, Reliability, and Longevity: </span></strong><span>Learn the various methods used to maximize the efficiency, reliability, and longevity of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>Equipment Sizing:</span></strong><span> Gain a detailed understanding of all the calculations and sizing techniques used for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>Design Features:</span></strong><span> Understand all the design features that improve the efficiency and reliability of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>Equipment Selection:</span></strong><span> Learn how to select modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology by using the performance characteristics and selection criteria that you will learn in this course</span></li>
<li><span><strong>Equipment Enclosures and Sealing</strong> Methods </span><span>Learn about the various types of enclosures and sealing arrangements used for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>Equipment Commissioning:</span></strong><span> Understand all the commissioning requirements for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>Equipment Codes and Standards:</span></strong><span> Learn all the codes and standards applicable for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>Equipment Causes and Modes of Failure:</span></strong><span> Understand the causes and modes of failure of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</span></li>
<li><strong><span>System Design: </span></strong><span>Learn all the requirements for designing different types of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology</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>

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>Industrial Instrumentation and Modern Control Systems Practical Manual (400 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>

Industrial Instrumentation and Modern Control Systems

<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>

840 Design courses in Cardiff

SAFe Agile Product Management: In-House Training

By IIL Europe Ltd

Process Hazard Assessment using the HAZOP Technique and HAZOP Team Leader Training

By EnergyEdge - Training for a Sustainable Energy Future

PR, Brand Management and Strategic Management

By GBA Corporate

SAFe Agile Software Engineering: In-House Training

By IIL Europe Ltd

GPON and FTTx networks

By Systems & Network Training

Advanced Well Engineering

By EnergyEdge - Training for a Sustainable Energy Future

Pumps, Compressors, Turbines & Troubleshooting

By EnergyEdge - Training for a Sustainable Energy Future

Artificial Lift and Real-Time Production Optimization in Digital Oilfield

By EnergyEdge - Training for a Sustainable Energy Future

Networking Microsoft Systems

By Systems & Network Training

Industrial Instrumentation and Modern Control Systems

By EnergyEdge - Training for a Sustainable Energy Future

Search By Location