Name: Microsoft Access
Price: 1697 GBP
Availability: InStock

London

<h2>Business Intelligence: In-House Training</h2>
 <p>Business Intelligence (BI) refers to a set of technology-based techniques, applications, and practices used to aggregate, analyze, and present business data. BI practices provide historical and current views of vast amounts of data and generate predictions for business operations. The purpose of Business Intelligence is the support of better business decision making. This course provides an overview of the technology and application of BI and how it can be used to improve corporate performance.</p><h3>What you will Learn</h3>
 <p>You will learn how to:</p>
 <ul>
 <li>Specify a data warehouse schema</li>
 <li>Identify the data and visualization to be used for data mining and Business Intelligence</li>
 <li>Design a Business Intelligence user interface</li>
 </ul><section>
                    <h3>Getting Started</h3> <ul> <li>Introductions</li> <li>Agenda</li> <li>Expectations</li> </ul> <h3>Foundation Concepts</h3> <ul> <li>The challenge of decision making</li> <li>What is Business Intelligence?</li> <li>The Business Intelligence value proposition</li> <li>Business Intelligence taxonomy</li> <li>Business Intelligence management issues</li> </ul> <h3>Sources of Business Intelligence</h3> <ul> <li>Data warehousing</li> <li>Data and information</li> <li>Information architecture</li> <li>Defining the data warehouse and its relationships</li> <li>Facts and dimensions</li> <li>Modeling, meta-modeling, and schemas</li> <li>Alternate architectures</li> <li>Building the data warehouse</li> <li>Extracting</li> <li>Transforming</li> <li>Loading</li> <li>Setting up the data and relationships</li> <li>Dimensions and the Fact Table</li> <li>Implementing many-to-many relationships in data warehouse</li> <li>Data marts</li> </ul> <h3>Online Analytical Processing (OLAP)</h3> <ul> <li>What is OLAP?</li> <li>OLAP and OLTP</li> <li>OLAP functionality</li> <li>Multi-dimensions</li> <li>Thinking in more than two dimensions</li> <li>What are the possibilities?</li> <li>OLAP architecture</li> <li>Cubism</li> <li>Tools</li> <li>OLAP variations - MOLAP, ROLAP, HOLAP</li> <li>BI using SOA</li> <li>Applications of Business Intelligence</li> <li>Applying BI through OLAP</li> <li>Enterprise Resource Planning and CRM</li> <li>Business Intelligence and financial information</li> </ul> <h3>Business Intelligence User Interfaces and Presentations</h3> <ul> <li>Data access</li> <li>Push-pull data access</li> <li>Types of decision support systems</li> <li>Designing the front end</li> <li>Presentation formats</li> <li>Dashboards</li> <li>Types of dashboards</li> <li>Common dashboard features</li> <li>Briefing books and scorecards</li> <li>Querying and Reporting</li> <li>Reporting emphasis</li> <li>Retrofitting</li> <li>Talking back</li> <li>Key Performance Indicators</li> <li>Report Definition and Visualization</li> <li>Typical reporting environment</li> <li>Forms of visualization</li> <li>Unconstrained views</li> <li>Data mining</li> <li>What is in the mine?</li> <li>Applications for data mining</li> <li>Data mining architecture</li> <li>Cross Industry Standard Process for Data Mining (CISP-DM)</li> <li>Data mining techniques</li> <li>Validation</li> </ul> <h3>The Business Intelligence User Experience</h3> <ul> <li>The business analyst role</li> <li>Business analysis and data analysis</li> <li>Five-step approach</li> <li>Cultural impact</li> <li>Identifying questions</li> <li>Gathering information</li> <li>Understand the goals</li> <li>The strategic Business Intelligence cycle</li> <li>Focus of Business Intelligence</li> <li>Design for the user</li> <li>Iterate the access</li> <li>Iterative solution development process</li> <li>Review and validation questions</li> <li>Basic approaches</li> <li>Building ad-hoc queries</li> <li>Building on-demand self-service reports</li> <li>Closed loop Business Intelligence</li> <li>Coming attractions - future of Business Intelligence</li> <li>Best practices in Business Intelligence</li> </ul>


                </section>

IIL Europe Ltd

Business Intelligence: In-House Training

General Admission

Redhill

<h3><b>Network virtualization training course description</b></h3>
      <p>This course covers network virtualization. It has been
designed to enable network engineers to recognise and
handle the requirements of networking Virtual
Machines. Both internal and external network
virtualization is covered along with the technologies
used to map overlay networks on to the physical
infrastructure. Hands on sessions are used to reinforce
the theory rather than teach specific manufacturer
implementations.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
   <li>Evaluate network virtualization implementations and technologies.</li>
																				<li>Connect Virtual Machines with virtual switches.</li>
    															 <li>Explain how overlay networks operate.</li>
    															 <li>Describe the technologies in overlay networks.</li>
                  </ul>
        <h5>
        <b>Network virtualization training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Engineers networking virtual machines.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Introduction to virtualization.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Network virtualization training course contents</b></h3>
      <ul>
				<li>Virtualization review </li><p>
Hypervisors, VMs, containers, migration issues, Data Centre network design. TOR and spine switches. VM IP addressing and MAC addresses.
<br /><span>Hands on</span> VM network configuration

</p><li>Network virtualization </li><p>
What is network virtualization, internal virtual networks, external virtual networks. Wireless network virtualization: spectrum, infrastructure, air interface. Implementations: Open vSwitch, NSX, Cisco, others.
<br /><span>Hands on</span> VM communication over the network.

</p><li>Single host network virtualization </li><p>
NICs, vNICs, resource allocation, vSwitches, tables, packet walks. vRouters.
<br /><span>Hands on</span> vSwitch configuration, MAC and ARP tables.

</p><li>Container networks </li><p>
Single host, network modes: Bridge, host, container, none.
<br /><span>Hands on</span> Docker networking.

</p><li>Multi host network virtualization </li><p>
Access control, path isolation, controllers, overlay networks. L2 extensions. NSX manager. OpenStack neutron. Packet walks. Distributed logical firewalls. Load balancing.
<br /><span>Hands on</span> Creating, configuring and using a distributed vSwitch.

</p><li>Mapping virtual to physical networks </li><p>
VXLAN, VTEP, VXLAN encapsulation, controllers, multicasts and VXLAN. VRF lite, GRE, MPLS VPN, 802.1x.
<br /><span>Hands on</span> VXLAN configuration.

</p><li>Orchestration </li><p>
vCenter, vagrant, OpenStack, Kubernetes, scheduling, service discovery, load balancing, plugins, CNI, Kubernetes architecture.
<br /><span>Hands on</span> Kubernetes networking.

</p><li>Summary </li><p>
Performance, NFV, automation. Monitoring in virtual networks.</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Definitive network virtualization

<div>
</div>
<section>
<div>
<h2><strong>About this Virtual Instructor Led Training (VILT)</strong><em> </em></h2>
<p>This 5 half-day course provides a detailed description of all performance testing methods for all thermal power plant equipment including boilers, turbines, condensers, pumps, fans, deaerators, and feedwater heaters. The methodology, and code requirements for the performance tests for all thermal power plant equipment will be explained in detail. The preparatory work and instrumentation required for each test will also be covered during the course.</p>
<p>The efficiency calculations for all equipment used in circulating fluidized bed (CFB) boiler and pulverized coal boiler power plants will be explained, including all processes, operational and maintenance activities, capital projects, technical options, potential initiatives and incentives to implement upgrades / repairs for increasing the power plant equipment efficiency.</p>
<p>The course will also provide a thorough explanation of CFB and pulverized coal boiler technology including hydrodynamics, combustion, emissions, design considerations, gas-solid separators, design of CFB and pulverized coal boiler components, management of solid residues, materials, stoichiometric calculations, and model for sulfur capture. The operation, maintenance, testing, and refurbishment options of all the equipment and systems used in CFB and pulverized coal power plants will be presented, including boilers, superheaters, reheaters, turbines, condensers, feedwater heaters, deaerators, pumps, compressors, fans, electric generators, instrumentation and control systems, and governing systems, etc.</p>
<p>The participants will get equipped on all factors which affect the CFB and pulverized coal boiler power plant efficiency and emissions, all methods used to calculate the heat rate of CFB and pulverized coal power plants as well as all areas in CFB and pulverized coal boiler power plants where efficiency loss can occur.</p>
<p>Updated information on the methods used to improve CFB boiler and pulverized coal boiler power plant heat rate will also be provided. It includes:</p>
<ol>
<li>Optimizing the combustion process and sootblowing</li>
<li>Controlling the steam temperature</li>
<li>Recovering moisture from boiler flue gas</li>
<li>Performing steam turbine maintenance</li>
<li>Lowering condenser back pressure</li>
<li>Pre-drying high moisture coal and reducing stack temperature</li>
</ol>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<ul>
<li><strong>Thermal Plant Performance Testing:</strong> Gain a thorough understanding of all the performance testing methods for all thermal power plant equipment including boilers, turbines, condensers, pumps, fans, daerators, and feedwater heaters</li>
<li><strong>Performance Test Methodology and Code Requirements:</strong> Understand the methodology, and code requirements for performance tests of all thermal power plant equipment</li>
<li><strong>Performance Test Preparatory Work and Instrumentation:</strong> Learn about the preparatory work and instrumentation required for each equipment performance test in a thermal power plant</li>
<li><strong>Equipment Efficiency Calculations:</strong> Gain a thorough understanding of the efficiency calculations for all the equipment used in circulating fluidized bed (CFB) boilers and pulverized coal boilers power plants</li>
<li><strong>Calculating the Heat Rate of CFB and Pulverized Coal Boiler Power Plants:</strong> Learn all the methods used to calculate the heat rate of CFB and pulverized coal boiler coal power plants</li>
<li><strong>Benefits of Lowering the Heat Rate of CFB and Pulverized Coal Boiler Power Plants:</strong> Understand all the benefits of lowering the heat rate of CFB coal power plants</li>
<li><strong>Methods Used to Improve CFB and Pulverized Coal Boiler Power Plants Heat Rate:</strong> Gain a thorough understanding of all the methods used to improve the heat rate of CFB and pulverized boiler coal power plants</li>
<li><strong>Processes, Operational and Maintenance Activities in CFB and Pulverized Coal Boiler Power Plants: </strong>Discover all the processes, operational and maintenance activities used to improve the heat rate of CFB and pulverized coal power plants</li>
<li><strong>Capital Projects Used to Improve the Heat Rate of CFB and Pulverized Coal Boiler Power Plants:</strong> Learn about all the capital projects used to improve the heat rate of CFB and pulverized coal power plants</li>
<li><strong>Technical Options for Improving the Heat Rate of CFB and Pulverized Coal Boiler Power Plants:</strong> Understand all the technical options used to improve the heat rate of CFB and pulverized coal boiler power plants</li>
<li><strong>Potential Initiatives and Incentives to Implement Upgrades / Repairs for Improving the Heat Rate of CFB </strong><strong>and Pulverized Coal Bed Boiler Power Plants:</strong> Discover all the potential initiatives and incentives to implement upgrades / repairs for improving the heat rate of CFB and pulverized coal power plants</li>
<li><strong>Factors Affecting CFB and Pulverized Coal Boiler Power Plants Efficiency and Emissions:</strong> Learn about all the factors which affect CFB and pulverized coal boiler power plants efficiency and emissions</li>
<li><strong>Areas in CFB and Pulverized Coal Power Plants where Efficiency Loss Can Occur:</strong> Discover all the areas in CFB and pulverized coal power plants where efficiency loss can occur</li>
<li><strong>Optimize the Operation of CFB and Pulverized Coal Power Plant Equipment and Systems to Improve the Plant Heat Rate:</strong> Understand all the techniques and methods used to optimize the operation of CFB and pulverized coal power plant equipment and systems to improve the plant heat rate</li>
<li><strong>CFB and Pulverized Coal Power Plant Equipment and Systems:</strong> Learn about the various types of CFB and pulverized coal power plant equipment and systems including boilers, superheater, reheaters, steam turbines, governing systems, deaerators, feedwater heaters, coal-handling equipment, transformers, generators and auxiliaries</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

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

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><strong>The VILT will be delivered online in 5 sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day</strong>, including time for lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. The instructor relies on a highly interactive training method to enhance the learning process. This method ensures  that all the delegates gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization.</p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<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>E</span><span>ach delegate will receive a soft copy of the following materials written by the instructor:</span></p>
<ul>
<li><span>'POWER GENERATION HANDBOOK' second edition published by McGraw-Hill in 2012 (800 pages)</span></li>
<li><span>Excerpt of the relevant chapters from the 'POWER PLANT EQUIPMENT OPERATION AND MAINTENANCE GUIDE' published by</span> <span>McGraw-Hill in 2012 (800 pages)</span></li>
<li><span>THERMAL POWER PLANT PERFORMANCE TESTING MANUAL (includes practical information about all the performance testing methods for all thermal power plant equipment - 400 pages)</span></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 about post training coaching support and fees applicable for this.</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

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

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Thermal Power Plant Performance Testing

Team of 10, pp

Normal Fee, pp

<h2>Managing Successful Programmes (MSP®) 5th Edition Practitioner: In-House Training</h2>
<p>Managing Successful Programmes (MSP®) is a globally-recognized framework for best practice programme management. MSP certification provides guidance for programme managers, business change managers, and the next step for project managers to develop their knowledge and skills to be able to positively respond to the challenges of managing programmes and larger, more strategic, or multiple projects. MSP 5th Edition emphasizes flexibility, adaptability, and responsiveness by adopting an incremental approach to the programme lifecycle and thus enabling organizational agility.</p>
<p>AXELOS offers two levels of MSP Examination: MSP Foundation and MSP Practitioner. The MSP 5th Edition Foundation Examination is intended to assess whether the candidate can demonstrate sufficient recall and understanding of the MSP programme management framework. MSP 5th Edition Practitioner is for project, programme, and business change managers that want to build on their knowledge of MSP in order to practically apply the MSP framework to real-life scenarios, providing the skills to lead and manage a programme. It is a must-have certification for both project and programme management professionals to deliver organizational value to their employers and boost their careers.</p><h3>What you will Learn</h3>
<p>At the end of this course, participants will be able to:</p>
<ul>
<li>Understand how to apply the MSP principles in context</li>
<li>Understand how to apply and tailor relevant aspects of the MSP themes in context</li>
<li>Understand how to apply and tailor relevant aspects of the MSP processes in context</li>
</ul><section>
                    <ul><li>Course Introduction</li><li>Application of MSP Principles</li><li>Program Strategy and Themes</li><li>Application of Organization Theme</li><li>Application of Design Theme</li><li>Application of Justification Theme</li><li>Application of Structure Theme</li><li>Application of Knowledge Theme</li><li>Application of Assurance Theme</li><li>Application of Decisions Theme</li><li>Application of MSP Processes</li></ul>


                </section>

Managing Successful Programmes 5th Edition Practitioner: In-House

<div>
</div>
<section>
<div>
<h2><strong>About this Virtual Instructor Led Training (VILT)</strong></h2>
<p>A large amount of geological data is acquired at a substantial cost when carrying out a drilling operation. Ensuring optimal quality of this information and effective reporting plays a key role during well design and drilling operations. In addition, there is much to benefit from the later usage of the data in field studies. A critical component that ensures favourable and positive results is the close co-operation between geological, drilling and well engineering departments.</p>
<p>Comprising 5 half-day sessions, this Virtual Instructor Led Training (VILT) course aims to provide the required knowledge in order for the collaboration to be most effective and successful. This VILT course will comprise lectures interspersed with practical and interactive exercises and quizzes to promote better understanding.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>At the end of this VILT course, participants will be able to:</p>
<ul>
<li>Understand the techniques used by wellsite geologists in formation evaluation via:
<ul>
<li>Quick-look analysis to assess reservoir and hydrocarbons</li>
<li>Mudlog data (lithology/cutting description, gas readings)</li>
</ul>
</li>
<li>Grasp the application of wellsite data in exploration and development</li>
<li>Be able to read, assess and use drilling reports</li>
<li>Acquire an understanding of drilling problems caused by subsurface conditions</li>
<li>Understand the role and contributions of the geologist to the well maturation process</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This VILT course is intended for <strong>geologists and other subsurface staff involved in drilling operations who would like to work and communicate more effectively with wellsite staff. </strong></p>
<p><strong> </strong><strong><em>Please note that this VILT course is not a preparation course for a wellsite assignment.</em></strong><em> To be able to work independently on the wellsite, a more hands-on or on-site training would be required.</em></p>
</div>
</div>
</div>
<div>
<div>

Training Methods 

</div>
<div id="collapseThree">
<div>
<p>This VILT course will be delivered online in <strong>5 half-day sessions comprising 4 hours per day</strong>, with 2 breaks of 10 minutes per day.</p>
<p>Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total).</p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader has close to 20 years of experience as a geologist in the Oil &amp; Gas industry. Her main interest and passion is in well planning and operations. She had previously worked as a production geologist and technical authority in NAM (Netherlands), and as a discipline advisor tasked to coach young staff in Bangalore. She has been active in internal training sessions on drilling hazards, mudwindow assessment and project management. She obtained an MSc in hard rock structural geology from the University in Utrecht, a PhD at Brown University (RI, USA) and a post-doctoral at the RWTH Aachen.</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br />
Request for further information about post training coaching support and fees applicable for this.</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

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

Wellsite Geology & Operations

Kuala Lumpur

<section style="color: rgb(33, 37, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 37, 41);"><h2 style="color: rgb(62, 57, 52); box-sizing: border-box;" fr-original-style=" color: rgb(62, 57, 52);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Classroom Training</strong></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In the upcoming digital era, Python stands out as the language of the future for effective AI and data analytics implementation, particularly in the Oil and Gas sector. Its widespread adoption is attributed to extensive libraries, versatility, and a thriving community of developers consistently pushing the boundaries of the field. This training course will tailor a transformative learning experience for professionals in oil and gas.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Commencing with overview in the computer programming, participants delve into programming fundamentals and set up their Python coding environment. Participants will be able to explore flow control tools and functions, unlocking the full potential of Python. Furthermore, participants will gain expertise in various programming paradigms, with a particular focus on Object-Oriented Programming (OOP), a crucial foundation for building sophisticated applications.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Participants will navigate through file handling, internal modules, and external libraries like NumPy, Pandas, and Matplotlib, providing proficiency in data manipulation and visualization tailored for the challenges of real-life projects. Through a hands-on Data Analytics Project, participants will apply their skills to a real-world dataset, derive insights, and present findings.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This comprehensive workshop equips professionals with the tools for effective automation and data analytics in the Oil and Gas sector. Participants will experience a robust understanding of Python&rsquo;s applications, ready to drive impactful and data-driven initiatives in their professional journey.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will be delivered face-to-face over 5-day sessions, comprising of 8 hours per day, 1 hour lunch and 2 breaks of 15 minutes per day. Course Duration: 8 hours in total, 40 CPD points. Maximum number of participants: 30</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download your brochure</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Please Send me the Brochure for Assessment Based Training – Python Programming & Analytics for the Oil & Gas Sector – Maximising Value from Data Assets" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Email me the brochure</a></p></section><section style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseOne" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TRAINING OBJECTIVES</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Acquire a comprehensive understanding of Python syntax, including variables, data types, and fundamental programming constructs.</li><li fr-original-style="" style="box-sizing: border-box;">Apply Python programming skills to analyze industry-specific datasets, extracting meaningful insights that can inform decision-making and operational efficiency.</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate the ability to automate routine tasks and streamline workflows within the Oil and Gas sector using Python.</li><li fr-original-style="" style="box-sizing: border-box;">Develop practical solutions and strategies using Python programming for challenges commonly faced in the industry, fostering hands-on experience and problem-solving capabilities.</li><li fr-original-style="" style="box-sizing: border-box;">Gain insights into emerging trends in digital technology within the industry and how Python can be leveraged for continuous adaptation and innovation.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseTwo" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TARGET AUDIENCE</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">All Engineers and Technologists from diverse fields who are interested in utilizing Python programming and data analytics techniques to explore and address challenges within their respective domains.</li><li fr-original-style="" style="box-sizing: border-box;">Data Analysts and Scientists who working with data generated by sensors, monitoring equipment, and other sources within the industry.</li><li fr-original-style="" style="box-sizing: border-box;">IT and Automation Specialists who responsible for designing and implementing IT solutions and automation systems as well as who involve in developing and maintaining software application in the Oil and Gas sector.</li><li fr-original-style="" style="box-sizing: border-box;">Executives and Managers seeking a strategic understanding of how Python and data analytics can impact decision-making and operational efficiency in the industry.</li><li fr-original-style="" style="box-sizing: border-box;">Professionals who interest in applying Python programming and data analytics techniques to study and solve challenges in the Oil and Gas field.</li><li fr-original-style="" style="box-sizing: border-box;">Individuals from related industries or backgrounds who are transitioning into roles within the Oil and Gas sector and wish to acquire relevant Python skills.</li><li fr-original-style="" style="box-sizing: border-box;">Professionals from diverse backgrounds who recognize the growing importance of data analytics in the Oil and Gas sector and wish to enhance their skill set.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapsecl" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE LEVEL</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Basic</li><li fr-original-style="" style="box-sizing: border-box;">Intermediate</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseThree" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TRAINING METHODS</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The trainer will employ the &lsquo;learning by doing&rsquo; method by emphasizing practical application. Participants will be introduced to the concepts and theories using techniques that they can easily relate to. The learning experience is then reinforced by implementing the subject through real-life examples. The trainer will provide quizzes and tests for self-assessment and ensuring participants can measure their understanding and apply the knowledge effectively. This hands-on approach not only enhances comprehension but also empowers participants to confidently apply the learned skills in their professional endeavors.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Preparation ahead of the Class:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Participants are required to download the&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python 3.x</strong>&nbsp;version software onto their laptops.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The instructions are provided below:</p><ol fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Download&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Anaconda</strong>&nbsp;by visiting the Anaconda website (https://www.anaconda.com/products/distribution).</li><li fr-original-style="" style="box-sizing: border-box;">Click on the &ldquo;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Download</strong>&rdquo; button for the version that suits your operating system (Windows, macOS, Linux).</li><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Select the&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python 3.x</strong>&nbsp;version (e.g., Python 3.8) during the installation process.</li><li fr-original-style="" style="box-sizing: border-box;">Install Anaconda follow the instructions to run the installer. Install Just Me (Recommended).</li></ol></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseFive" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TRAINER</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Your expert trainer is a seasoned multidisciplinary engineer with a 15-year professional journey, driven by an unwavering commitment to innovation and excellence. Armed with a Ph.D. in offshore engineering, he draws extensive insights from diverse industry sectors, notably oil and gas, where he served as a subsea pipeline engineer. His hands-on experience encompasses the entire spectrum, from design and manufacturing to installation and operations of offshore oil and gas facilities.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Previously at Rosen Group, your expert trainer developed digital tools for offshore structural assessments and risk-based inspection. He led research at the ARC Offshore Floating Facilities Hub on enhancing riser design and monitoring using Python and data analytics. He performed design verification for INPEX, Chevron, and Apache on subsea pipelines, risers, umbilicals, and LNG facilities, and was a deputy project manager on verifying the Ichthys gas pipeline. He conducted risk-based inspection and auditing of the Ichthys LNG plant for DNV GL. He also worked as a structural engineer at Advanced Building Engineers designing steel structures, buildings, and other components. Meanwhile, at the University of Western Australia (UWA), your expert trainer developed AI and data solutions for the oil &amp; gas industry focused on condition monitoring and probabilistic assessments and led research on offshore facilities by creating tools for analysis and machine learning.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">His academic pursuit culminated in a thesis that underscores his proficiency in employing data science and machine learning, primarily through Python. His research focused on optimising asset integrity management for offshore oil and gas assets, showcasing a seamless integration of engineering and cutting-edge technology. In 2023, he fully unleash AI-driven solutions across diverse sectors. Currently, he actively contributes to mineral resource exploration and assists oil and gas operators in the effective implementation of new AI and digital technologies.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">His dedication to knowledge dissemination is evident through his role as a global educator. Over the past five years, he has conducted Python programming lectures at universities and industries, reaching over 1000 novices. His unwavering commitment to lifelong learning, coupled with a growth mindset have positions him as a transformative trainer in the realms of applied AI, data science, and engineering in oil and gas sector</p><section style="color: rgb(33, 37, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 37, 41);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download your brochure</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Please Send me the Brochure for Assessment Based Training – Python Programming & Analytics for the Oil & Gas Sector – Maximising Value from Data Assets" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Email me the brochure</a></p></section></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseCS" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">POST TRAINING COACHING SUPPORT (OPTIONAL)</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &ldquo;One to One&rdquo; 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 fr-original-style="" style="box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Request%20for%20further%20information%20regarding%20post%20training%20coaching%20support" target="_blank" style="color: rgb(0, 123, 255); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(0, 123, 255);">Request for further information post training support</a>&nbsp;and fees applicable.</p></div></section>

Machine Learning (ML)

Maximize the value of data assets in the oil and gas sector with EnergyEdge's assessment-based training course on Python programming and analytics.

Assessment Based Training - Python Programming & Analytics for the Oil & Gas Sector - Maximising Value from Data Assets

<div>
</div>
<section>
<div>
<h2><strong>About this Virtual Instructor Led Training (VILT)</strong><em> </em></h2>
<p>Accredited by the <strong>United Kingdom Lubricants Association (UKLA)</strong>, this 4 half-day Virtual Instructor Led Training (VILT) course will provide an in-depth understanding of the principles, economics and flexibility of lubricant blending plants and how to operate a lubricants blending plant efficiently and economically.</p>
<p>The latest developments and trends in lubricant blending and the advantages and disadvantages of lubricant blending equipment, facilities and operations will be discussed. The importance of testing components and products for each blend, lubricant blend quality control and product quality management will also be explained.</p>
<p>The VILT course will also clarify the importance of lubricant product filling, packaging and warehouse storage, strategies for optimising existing lubricant blending plant facilities and how to avoid or minimise problems with lubricant blending and product quality.</p>
<p>The VILT course is recognised under the <strong>UKLA Continuing Professional Development (CPD) scheme</strong> for Registered Lubricant Professional.</p>
<p>*<strong>There will be an examination for this VILT.</strong></p>
<p> </p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p><strong>This VILT course will enable you to:</strong></p>
<ul>
<li>Learn about Mineral Oil Base Oils; API Groups I, II and III: Properties and Characteristics</li>
<li>Acquire the knowledge about Synthetic Base Oils; API Groups IV and V: Properties and Characteristics</li>
<li>Learn about Lubricant Additives: Properties and Characteristics</li>
<li>Know the Lubricant Formulation and Ease of Blending</li>
<li>Explore the Blending Plant Design: Grassroots Plants and Upgrading Existing Plants</li>
<li>Learn about Blending Plant Equipment and Facilities and Their Operation</li>
<li>Understand the Lubricant Blending Issues: Avoiding Problems</li>
<li>Test and Analyse Base Oils and Additives</li>
<li>Test and Analyse Blended Lubricants</li>
<li>Explore the importance of Product Quality Control</li>
<li>Understand the process of Lubricant Packaging and Filling</li>
<li>Understand the process of Lubricant Storage</li>
<li>Learn about Product Quality Management</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This VILT course will be useful and applicable for:</p>
<ul>
<li><strong>Middle and Senior managers</strong> to understand how and why to design and operate an efficient and profitable lubricant blending plant.</li>
<li><strong>Blending plant operators and specialists</strong> to improve and optimise current blending plant operations.</li>
<li><strong>Manufacturers of lubricants</strong> will understand how and why high quality components and effective testing during the entire blending process are important to final lubricant product quality and performance.</li>
<li><strong>Lubricant formulators</strong> will understand the importance of close communication and co-operation with blending plant managers and operators to minimise blending costs and to thereby maximise product profitability.</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Course Level 

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

Training Methods 

</div>
<div id="collapseThree">
<div>
<p>The VILT course will be delivered online in <strong>4 half-day sessions comprising 4 hours per day</strong>, with 2 breaks of 10 minutes per day.</p>
<p>Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total).</p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader (CChem, MRC) has worked as Sales, Technical Marketing Manager and Company Director with over 50 years of broad experience in the lubricants, fuels, petroleum additives, with four leading companies Chevron, Ethyl Petroleum Additives Ltd, Texaco Limited and Kuwait Petroleum (GB) Ltd. His major recent responsibilities have been concerned with leading the Oil Industry Association United Kingdom Lubricants Association, and acting in an advisory capacity as Technical Director to the Association.</p>
<p>He has acquired a wide experience in technical, marketing and sales within the oil industry. The related experience gained with the oil additives industry has provided him with special additional insights. He has also led the Certificate of Lubricant Competence course for the United Kingdom Lubricants Association (UKLA) for 11 years. He is a Chartered Chemist and a Member of the Royal Society of Chemistry.</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br />
Request for further information about post training coaching support and fees applicable for this.</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

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

Lubricants Blending and Quality Assurance (Accredited by the United Kingdom Lubricants Association (UKLA))

<h3><b>Signalling training course description</b></h3>
      <p>An intensive course that defines and explores the signalling methods that are to be found in today's telecommunications services.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
     <li>Describe the Functionality and Features of Signalling.</li>
					<li>Describe the Functionality of Analogue &amp; Digital Subscriber Signalling.</li>
                    
                    <li>Describe the various types of signalling used on different network types.</li>
                    <li>Describe the Functionality of Private Network Signalling.</li>
                    <li>Describe the Functionality of Public Network Signalling.</li>
                  </ul>
        <h5>
        <b>Signalling training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Personnel involved with systems design, implementation and support.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Telecommunications Introduction</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Signalling training course contents</b></h3>
      <ul>
				<li>Introduction 	</li><p>
What is Signalling?, Standards, ITU-T Recommendations, Signalling Categories - Supervisory Addressing, E.164, Call Information, Network Management, Network Components, Inband/Outband Switch Signalling, Analogue Vs Digital Signalling.

</p><li>Analogue Subscriber Signalling </li><p>
Analogue Local Loops/Switches/Trunks, Digital Switches/Local Loops, Telephone Handset, Accessing the Local Exchange, Pulse/Tone Dialling.

</p><li>Digital Subscriber Signalling </li><p>
Integrated Digital Access, DASS2 &amp; DPNSS, DASS2 - Call, IMUX, Euro ISDN, Q.931 Call Control, Message Identification, Message Types, Call Establishment Messages, Call Clearing.

</p><li>Network Types </li><p>
Service Types, Circuit Switched, Packet Switched, Signalling Terminology, In-Channel Signalling, G.704, Performance and Quality, Digital Signalling, CAS, CAS Applications, Foreign Exchange, CCS, Break-In/Out

</p><li>Private Network Signalling Types </li><p>
Networking PABXs, Inter PABX Analogue Signalling Methods, E &amp; M, Tone-On-Idle, Inter PABX Digital Signalling Methods, DPNSS, DPNSS Deployment, PABX Support for DPNSS, DPNSS Call, Q.Sig, Q.Sig support/functionality/protocol, Message Overview, Call Establishment.

</p><li>Public Network Signalling </li><p>
SS7, SS7 Operations, SS7 Topology, SSP, STP, SCP, Database Types - CMSDB NP LIDB HLR VLR, Signalling Modes, Link Types, Further Redundancy, Linksets, SS7 addressing, Point Codes, Sub-System, Global Title Addressing and Translation, ANSI PCs, ITU-T PCs, SS7 Protocol Stack, MTP Level 1, MTP Level 2, Flow Control, FISU, LSSU, MSU, MSU SIF, MTP Level 3, SCCP, TCAP, TUP, Facility Format, Main Facilities, Flow Control Negotiation, Closed User Groups, Reverse Charging, Fast Select Facility, Throughput Class Negotiation, Call Barring, On-Line Facility Registration. BTUP, ISDN ISUP, Supplementary Services, ISUP Call - IAM, Progress/Answer/Suspend/ Resume/Release Messages,

</p><li>Intelligent Network (IN) </li><p>
Introduction, IN Evolution, IN Conceptual Model, IN Target Services &amp; Service Features, Service Independent Building Blocks
</p>
      </ul>

Signalling systems for engineers

<h2>SAFe® DevOps: In-House Training</h2>
<p>This course provides a comprehensive overview for understanding the DevOps skills needed to accelerate time-to-market by improving the flow of value through the Continuous Delivery Pipeline. You will map the current value stream through the delivery pipeline from idea to cash and identify practices that will eliminate bottlenecks to flow. The course will build an understanding of the complete flow of value from Continuous Exploration to Continuous Integration, Continuous Deployment, and Release on Demand.</p><h3>What you will Learn</h3>
<p>After attending the class, attendees should be able to:</p>
<ul>
<li>Explain how DevOps enables strategic business objectives</li>
<li>Apply a CALMR approach to DevOps to avoid automating broken processes</li>
<li>Understand how successful DevOps requires continuous exploration, continuous integration, continuous deployment, and the ability to release to end users on demand</li>
<li>Incorporate continuous testing and continuous security into the delivery pipeline</li>
<li>Use value-stream mapping to measure flow and identify bottlenecks in the end-to-end delivery process</li>
<li>Select DevOps skills and tools strategically for the fastest, most compelling results</li>
<li>Prioritize DevOps solutions and investments for the greatest economic benefit</li>
<li>Design and implement a multi-phased DevOps transformation plan tailored to their organization</li>
<li>Work with all roles and levels in the organization to continually optimize the value stream</li>
</ul><section>
                    <ul><li>Introducing DevOps</li><li>Mapping your Continuous Delivery Pipeline</li><li>Gaining alignment with Continuous Exploration</li><li>Building quality with Continuous Integration</li><li>Reducing time-to-market with Continuous Deployment</li><li>Delivering Business Value with Release on Demand</li><li>Taking action</li></ul>


                </section>

SAFe DevOps: In-House Training

<h3><b>Microsoft Access training course description</b></h3>
        <p>   A hands on course providing a solid grounding
in Microsoft Access. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                        <li>Use and customise the Microsoft Access
environment.</li>
<li>Select, use and customise queries.</li>
<li>Define tables.</li>
<li>Design forms and reports.</li>
<li>Recognise the use of macros.</li>

                  </ul>
        <h5>
        <b>Microsoft Access training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone wishing to work with Microsoft Access.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Database fundamentals</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Microsoft Access training course contents</b></h3>
      <ul>
        <li>Introducing databases </li><p>
Flat file databases, Relational databases, the objects defined in an Access database, planning a simple relational database.

</p><li>Open Access and create a database </li><p>
The database wizards, tables, creating and amending tables, using field properties to improve the quality of data entry and system performance, the primary key.

</p><li>Working in datasheet view </li><p>
View, add, modify and delete records, find records. Advantages and disadvantages of entering data directly into a table.

</p><li>Queries </li><p>
Sort and select records form a single table, advantages and disadvantages of entering data via a query, define simple calculated expressions, use 'Totals' queries.

</p><li>Forms </li><p>
Use the form wizards, basic editing of objects created using the form wizards, Data-entry in form view.

</p><li>Reports </li><p>
Use the report wizard, basic editing of objects created using the report wizard, print reports.

</p><li>The multi table environment </li><p>
Plan and create a related table, define a one-to-many relationship, write multi-table queries and use the 'AutoLookup' feature, use the form wizard to create a subform and carry out data-entry in a main/subform, print and amend reports, use the report wizard to create reports based on multi-table.

</p><li>Relationships </li><p>
Working with one-to-one and one-to-many relationships, recognising and handling many-to-many relationships, referential integrity.

</p><li>Select queries </li><p>
Select queries based on related tables, parameter queries, Crosstab, find unmatched queries and Find Duplicate, the implications of the Join properties in a relational query, conditional expressions, and working with the expression builder.

</p><li>Action queries </li><p>
Make table queries, append queries, update queries, delete queries. Customising forms. Using the Toolbox, calculated controls, Combo and List boxes, query by form, working with form and control properties, domain aggregate functions.

</p><li>Reports </li><p>
Report and control properties, customising sorting and grouping, calculated controls on reports, Sub-reports, editing and altering a report's source.

</p><li>Macros </li><p>
Introduction to macros.</p>
      </ul>

Microsoft Access

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

884 Design courses in Manchester

Business Intelligence: In-House Training

By IIL Europe Ltd

Definitive network virtualization

By Systems & Network Training

Thermal Power Plant Performance Testing

By EnergyEdge - Training for a Sustainable Energy Future

Managing Successful Programmes 5th Edition Practitioner: In-House

By IIL Europe Ltd

Wellsite Geology & Operations

By EnergyEdge - Training for a Sustainable Energy Future

Assessment Based Training - Python Programming & Analytics for the Oil & Gas Sector - Maximising Value from Data Assets

By EnergyEdge - Training for a Sustainable Energy Future

Lubricants Blending and Quality Assurance (Accredited by the United Kingdom Lubricants Association (UKLA))

By EnergyEdge - Training for a Sustainable Energy Future

Signalling systems for engineers

By Systems & Network Training

SAFe DevOps: In-House Training

By IIL Europe Ltd

Microsoft Access

By Systems & Network Training

Search By Location