Name: Oracle database administration
Price: 2797 GBP
Availability: InStock

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong></h2>
<p>There are various kinds of geophysical data available. They are separated into seismic and non-seismic (multi-physics) data. Non-seismic or multi-physics data (which includes gravity, magnetics, electrical, electromagnetics, spectral etc - apart from providing complimentary information to seismic) is the main source of information for very shallow subsurface applications such as engineering, mapping pollution, archaeology, geothermal energy, and related areas. This 5 full-day blended course will focus specifically on seismic data which is the main method used in the Oil &amp; Gas industry.</p>
<p>In this blended course, participants will be equipped to understand that seismic data represents the movement of the surface, resulting from waves generated by a source, dynamite or vibrator which are reflected by changes in the subsurface rocks. The basic principles of acquisition and processing will be explained and insights into advanced methods, allowing a much more accurate interpretation of seismic data than previously considered possible, will also be provided.</p>
<p>This blended course contains an introduction to Machine Learning and its important role in all aspects of seismic acquisition, processing, and interpretation. There is no need to know in detail how the algorithms work internally but it is necessary to know how to use them correctly to achieve optimum results.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>By attending this course, participants will be able to acquire the following:</p>
<ul>
<li>Obtain an understanding of the strengths and limitations of geophysical methods, specifically seismic, and the costs and risks involved, and how to reduce these.</li>
<li>Be able to communicate more effectively with staff in other disciplines.</li>
<li>Understand the potential applications of seismic data and know how to formulate the requirements needed for prospect and field evaluation.</li>
<li>Gain an awareness of modern seismic technology.</li>
<li>Apply the learning in a series of practical, illustrative exercises.</li>
<li>Know what types of questions to ask to assess the necessary quality of a seismic project in its role in a sequence of E&amp;P activities</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>The blended course is intended for <strong>non-geophysicists who have intensive interaction with geophysicists</strong>. But it may be of interest to those who want to know about the recent progress made in geophysics, leading to amazing imaging results, which could not be imagined a decade ago. The blended course will bring to the attention of the geologists, petrophysicists and reservoir/petroleum engineers an awareness of how the data they will work with is acquired and processed by the geophysicist. It will introduce the concepts that are of importance in geophysics and thus relevant for non-geophysicists to know and be able to communicate with geophysicists as well as formulate their requests.</p>
</div>
</div>
</div>
<div>
<div>

Course Level 

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

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader has degree in Geology (University of Leiden), a Master's degree in Theoretical Geophysics (University of Utrecht) and a PhD in Utrecht on 'Full wave theory and the structure of the lower mantle'. This involved forward modelling of P- and S-waves diffracted around the core-mantle boundary and comparison of the frequency-dependent attenuation of the signal with those obtained from major earthquakes observed at long offsets in the 'shadow zone' of the core. These observations were then translated into rock properties of the D' transition zone.</p>
<p>After his PhD, he joined Shell Research in The Netherlands to develop methods to predict lithology and pore-fluid based on seismic, petrophysical and geological data. He subsequently worked for Shell in London to interpret seismic data from the Central North Sea Graben. As part of the Quantitative Interpretation assignment, he was also actively involved in managing, processing and interpreting Offshore Seismic Profiling experiments.</p>
<p>After his return to The Netherlands, he headed a team for the development of 3D interpretation methods using multi-attribute statistical and pattern recognition analysis on workstations. After a period of Quality Assurance of 'Contractor' software for seismic processing, he became responsible for Geophysics in the Shell Learning Centre. During that period, he was also a part-time professor in Applied Geophysics at the University of Utrecht.</p>
<p>From 2001 to 2005, he worked on the development of Potential Field Methods (Gravity, Magnetics) for detecting oil and gas. Finally, he became a champion on the use of EM methods and became involved in designing acquisition, processing and interpretation methods for Marine Controlled Source EM (CSEM) methods.</p>
<p>After his retirement from Shell, he founded his own company, specialising in courses on acquisition, processing and interpretation of geophysical data (seismic, gravity, magnetic and electromagnetic data), providing courses to International and National energy companies.</p>
<p>In the last couple of years, he became keenly interested in the use of Machine Learning in Geophysics. Apart from incorporating 'Artificial Intelligence' in his courses, he also developed a dedicated Machine Learning course for geophysics.</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

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

Accreditions And Affliations

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

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Fundamentals of Seismic for Non-Geophysicists

Team of 10, pp

Normal Fee, pp

As the awareness of ADHD increases, more and more people are being diagnosed, or suspect they have ADHD. 
This workshop, delivered by Esther Barrett, ADHD Coach, who was diagnosed with ADHD four years ago, provides educators with an overview of what ADHD is, the challenges that people with ADHD face and strategies to help with learning and work. 


Panda Education and Training Ltd

Mental Health Awareness

Educational Psychology

ADHD (Attention Deficit Hyperactivity Disorder)

Educator

Assessor Training

As the awareness of ADHD increases, more and more people are being diagnosed, or suspect they have ADHD. 



This workshop provides educators with an overview of what ADHD is, the challenges that people with ADHD face and strategies to help with learning and work.



Introduction to ADHD in Adults for Educators

General Admission

<p dir="ltr" id="isPasted" 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;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About the Course</strong></span></p><p dir="ltr" id="isPasted" 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;" fr-original-style="color:#000000;">Learn &amp; master coaching tools and skills that help teams and systems, address intangible hurdles which lead to a lack of trust, conflict, unskillful communication and tribalism, towards teams/systems which are more collaborative &amp; aligned whilst at work and at home.&nbsp;</span></p><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" 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;" fr-original-style="color:#000000;">The Fundamentals of Organisation and Relationship Systems Coaching is a two-day course&nbsp;</span><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">for coaching teams, as well as partnerships, families, and wider organisations, at the heart of which is&nbsp;</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Relationship Systems Intelligence (RSI&trade;).&nbsp;</span></p><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" 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;" fr-original-style="color:#000000;">During this course, you will gain insights into how to utilise RSI to address some of the common challenges that often afflict professional and personal relationships. You&rsquo;ll learn to:</span></p><br fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Increase your power and influence by tapping into the inherent wisdom of the team or relationship.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Build</span><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">&nbsp;co-responsibility for both process and outcomes.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Establish</span><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">&nbsp;boundaries and limitations, while focusing on common interests.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Reveal</span><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">&nbsp;roles and garner deeper insights.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Craft a narrative that resonates deeply and plots a course for change.</span></p></li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" 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;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Relationship Systems Intelligence</strong></span></p><p dir="ltr" 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;" fr-original-style="color:#000000;">Beyond Emotional Intelligence (which is the relationship with self) and Social Intelligence (which is the interaction with others) lies Relationship Systems Intelligence (RSI&trade;), where the primary focus shifts to encompass the entire group, team, or system.</span></p><p dir="ltr" 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;" fr-original-style="color:#000000;">RSI acknowledges the system or team as a distinct entity, facilitating the emergence of change through collaborative efforts and shared leadership. Each system or team possesses a unique identity, complete with its own personality, intelligence, and information that go beyond the individual components within it.</span></p><p dir="ltr" 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;" fr-original-style="color:#000000;">Relationship Systems Intelligence (RSI) operates across three distinctive tiers: the individual system (where we navigate our inner voices), the dyadic or pair system, and expansive large group systems. Each of these tiers forms a crucial leg of the relationship systems coaching framework. Proficiency in all three is imperative for effectively coaching complex systems.</span></p><p dir="ltr" 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;" fr-original-style="color:#000000;">In the Fundamentals (or ORS@Work) course, we introduce the art of fostering conscious and intentional relationships with self and others.</span></p><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" 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;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outcomes:</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Develop a deeper understanding of team dynamics.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Design intentional and accountable conversations.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Align differences to impact the collective whole.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Feel confident engaging and supporting your clients through&nbsp;change and development initiatives.</span></p></li></ul><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 id="isPasted" 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;">Orientation Call</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Alongside the date for the course, you&#39;ll be sent an additional dates for an Orientation call and a Mentoring call. These are <span style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">additional learning opportunities we provide for free on top of your training dates. These are optional and not compulsory, but we do recommend you attend if you are able.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">The Orientation call provides context and an introduction to the course, we will explain what happens over the training dates, talk you through requirements and a space for you to ask any questions. It&#39;s also a chance for you to connect with your learning system ahead of the course.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">The Mentoring call is a 90-minute session to reconnect with your learning system and your leaders to embed everything you&#39;ve learned in the course. It&#39;s a space to share your experiences of using the tools and skills and to ask the leaders for input on any experiences you&#39;ve had whilst coaching relationships. It&#39;s a fantastic opportunity to deepen your experience of the tools and skills you&#39;ve learnt and fine-tune your practice.&nbsp;</span></p>

About the Course
Learn & master coaching tools and skills that help teams and systems, address intangible hurdles which lead to a lack of trust, conflict, unskillful communication and tribalism, towards teams/systems which are more collaborative & aligned whilst at work and at home. 
The Fundamentals of Organisation and Relationship Systems Coaching is a two-day course for coaching teams, as well as partnerships, families, and wider organisations, at the heart of which is Relationship Systems Intelligence (RSI™). 
During this course, you will gain insights into how to utilise RSI to address some of the common challenges that often afflict professional and personal relationships. You’ll learn to:
Increase your power and influence by tapping into the inherent wisdom of the team or relationship.
Build co-responsibility for both process and outcomes.
Establish boundaries and limitations, while focusing on common interests.
Reveal roles and garner deeper insights.
Craft a narrative that resonates deeply and plots a course for change.
Relationship Systems Intelligence
Beyond Emotional Intelligence (which is the relationship with self) and Social Intelligence (which is the interaction with others) lies Relationship Systems Intelligence (RSI™), where the primary focus shifts to encompass the entire group, team, or system.
RSI acknowledges the system or team as a distinct entity, facilitating the emergence of change through collaborative efforts and shared leadership. Each system or team possesses a unique identity, complete with its own personality, intelligence, and information that go beyond the individual components within it.
Relationship Systems Intelligence (RSI) operates across three distinctive tiers: the individual system (where we navigate our inner voices), the dyadic or pair system, and expansive large group systems. Each of these tiers forms a crucial leg of the relationship systems coaching framework. Proficiency in all three is imperative for effectively coaching complex systems.
In the Fundamentals (or ORS@Work) course, we introduce the art of fostering conscious and intentional relationships with self and others.
Course Outcomes:
Develop a deeper understanding of team dynamics.
Design intentional and accountable conversations.
Align differences to impact the collective whole.
Feel confident engaging and supporting your clients through change and development initiatives.


Orientation Call
Alongside the date for the course, you'll be sent an additional dates for an Orientation call and a Mentoring call. These are additional learning opportunities we provide for free on top of your training dates. These are optional and not compulsory, but we do recommend you attend if you are able. 
The Orientation call provides context and an introduction to the course, we will explain what happens over the training dates, talk you through requirements and a space for you to ask any questions. It's also a chance for you to connect with your learning system ahead of the course.
The Mentoring call is a 90-minute session to reconnect with your learning system and your leaders to embed everything you've learned in the course. It's a space to share your experiences of using the tools and skills and to ask the leaders for input on any experiences you've had whilst coaching relationships. It's a fantastic opportunity to deepen your experience of the tools and skills you've learnt and fine-tune your practice. 

CRR UK

Business Relationship Management (BRM)

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.

May 2025 Fundamentals Organisation & Relationship Systems Coaching Training

Redhill

<h3><b>Intro to SQL training course description</b></h3>
        <p> A hands on course focusing on the use of SQL. In
particular this course does not concentrate on any
particular version of SQL but rather enables delegates
to recognise the differences found in SQL on different
platforms. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                        
                        <li>Explain the difference between standard SQL and different flavours.</li>
<li>Use SQL statements to query databases.</li>
<li>Use SQL statements to define databases.
</li>
                  </ul>
        <h5>
        <b>Intro to SQL training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with databases.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Intro to SQL training course contents</b></h3>
      <ul>
        <li>What is SQL? </li><p>
What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends.

</p><li>Database basics </li><p>
RDBMS, Tables.
<br /><span>Hands on</span> Investigating a database.

</p><li>Basic SQL commands </li><p>
SQL Overview: SQL DML, SQL DDL, SQL
queries. SELECT, WHERE and ORDER BY
clauses. Combining conditions. IN, LIKE and
BETWEEN.
<br /><span>Hands on</span> Querying a database from existing
tables.

</p><li>SQL data retrieval </li><p>
Scalar functions.
<br /><span>Hands on</span> Selecting data from an existing database.
		  
		  </p><li>More SQL data retrieval
 </li><p>
Scalar functions, variations. Aggregate functions,
GROUP BY. HAVING. 
<br /><span>Hands on</span> Selecting data from an existing database.
		  
	</p><li>Table joins </li><p>
Multiple tables, joins, keys, inner joins, left joins,
right joins.
<br /><span>Hands on</span> Selecting data from an existing database.	  
		  

</p><li>SQL basic data manipulation </li><p>
INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK.
<br /><span>Hands on</span> Modifying data in tables.

</p><li>SQL Data Definition </li><p>
USE, CREATE, DROP, TRUNCATE, ALTER.
<br /><span>Hands on</span> Managing new tables and columns.



</p><li>Data control </li><p>
GRANT, REVOKE.
		  <br /><span>Hands on</span> Defining permissions.
</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Introduction to SQL

<h2>Lean Six Sigma Green Belt Certification Program: Virtual In-House Training</h2>
 <p>This learning series is designed to enable participants to fulfill the important role of a Lean Six Sigma Green Belt and to incorporate the Lean Six Sigma mindset into their leadership skills.</p>
 <p>Green Belt is not just a role, it is also a competency required for leadership positions at many top companies. This learning series is designed to enable participants to fulfill the important role of a Lean Six Sigma Green Belt and to incorporate the Lean Six Sigma mindset into their leadership skills. With a real-world project focus, the series will teach the fundamental methodology, tools, and techniques of the Define, Measure, Analyze, Improve and Control Process Improvement Methodology. This course is delivered through sixteen 3-hour online sessions.</p><h3>What you Will Learn</h3>
 <p>At the end of this program, you will be able to:</p>
 <ul>
 <li>Identify strategies for effectively leading high performing process improvement teams</li>
 <li>Analyze whether projects align with business strategy</li>
 <li>Apply process improvement methodologies to DMAIC steps, based on real world scenarios</li>
 <li>Explain ways to appropriately respond to process variation</li>
 <li>Distinguish among best practice problem solving methodologies</li>
 <li>Evaluate and effectively communicate data-driven decisions, based on real world scenarios</li>
 </ul><section>
                    <h3>Introduction</h3> <ul>  <li>Lean Six Sigma &amp; quality</li>  <li>The vision</li>  <li>The methodologies</li>  <li>The metric</li>  </ul>  <h3>Project Selection</h3> <ul>  <li>Why Projects</li>  <li>Random idea generation</li>  <li>Targeted idea generation</li>  <li>CTQs (Critical to Quality) &amp; projects</li>  <li>Project screening criteria</li>  <li>Quick improvements</li>  </ul>  <h3>Introduction to Define</h3> <h3>Project Planning</h3> <ul>  <li>Developing the core charter</li>  <li>Developing a project charter</li>  <li>Facilitation</li>  </ul>  <h3>Process Management</h3> <ul>  <li>Business process management</li>  <li>Top-down process mapping</li>  </ul>  <h3>Voice of the Customer</h3> <ul>  <li>Voice of Customer</li>  <li>Stakeholder analysis</li>  <li>Communication planning</li>  <li>Kicking off the project</li>  </ul>  <h3>Define Summary</h3> <h3>Introduction to Measure</h3> <h3>Data Collection</h3> <ul>  <li>Fact-based decision making</li>  <li>Data sampling</li>  <li>Operations definitions</li>  <li>Data collection plan</li>  <li>Measurement system analysis</li>  </ul>  <h3>Graphical Statistics for Continuous Data</h3> <ul>  <li>Meet Six SigmaXL</li>  <li>Graphical &amp; statistical tools</li>  <li>Data stratification</li>  </ul>  <h3>Graphical Statistics for Discrete Data</h3> <ul>  <li>Pareto analysis</li>  <li>Dot plots</li>  <li>Plotting data over time: Looking for patterns</li>  </ul>  <h3>Variation Concepts</h3> <ul>  <li>Variation is reality</li>  <li>Special Cause and Common Cause variation</li>  <li>Example of standard business reporting</li>  <li>Individuals Control Chart</li>  </ul>  <h3>Process Capability</h3> <ul>  <li>Genesis of process capability</li>  <li>Calculating the metrics of Six Sigma</li>  <li>Yield metrics: Measuring process efficiency</li>  </ul>  <h3>Cost of Poor Quality</h3> <ul>  <li>The Cost of Poor Quality (COPQ)</li>  <li>Cost of Quality categories</li>  <li>Calculating the Cost of Poor Quality</li>  </ul>  <h3>Measure Summary</h3> <h3>Introduction to Analyze</h3> <h3>Process Analysis</h3> <ul>  <li>Introduction to process analysis</li>  <li>Value-added analysis</li>  <li>Cycle time analysis</li>  <li>WIP &amp; pull systems</li>  <li>Analyzing bottlenecks and constraints</li>  </ul>  <h3>Cause &amp; Effect Analysis</h3> <ul>  <li>Fishbone/Ishikawa diagram</li>  <li>5-Whys analysis</li>  <li>Graphical &amp; statistical tools</li>  </ul>  <h3>Advanced Analysis</h3> <ul>  <li>Why use hypothesis rests?</li>  <li>Hypothesis tests</li>  <li>Correlation and regression analysis</li>  </ul>  <h3>Analyze Summary</h3> <h3>Introduction to Improve</h3> <h3>Solutions</h3> <ul>  <li>Creativity techniques</li>  <li>Generating alternative solutions</li>  <li>Solution selection techniques</li>  </ul>  <h3>Introduction to Design of Experiments</h3> <ul>  <li>Introduction to DOE</li>  <li>DOE activity</li>  </ul>  <h3>Error Proofing</h3> <ul>  <li>Failure mode &amp; effect analysis</li>  <li>Poka-Yoke</li>  </ul>  <h3>Project Management Fundamentals</h3> <ul>  <li>Successful teams</li>  <li>Project roles</li>  <li>Conflict management</li>  </ul>  <h3>Standardization</h3> <ul>  <li>Standardization</li>  <li>The Visual Workplace</li>  <li>5S</li>  </ul>  <h3>Piloting &amp; Verifying Results</h3> <ul>  <li>What is a pilot?</li>  <li>Evaluating results</li>  </ul>  <h3>Improve Summary</h3> <h3>Introduction to Control</h3> <h3>Statistical Process Control</h3> <ul>  <li>Review of Special &amp; Common Cause variation</li>  <li>Review of Individual Control Chart</li>  <li>P-Chart for discrete proportion data</li>  </ul>  <h3>Transition Planning</h3> <ul>  <li>Control plan</li>  <li>Project closure</li>  </ul>  <h3>Control Summary</h3> <h3>Summary and Next Steps</h3>


                </section>

IIL Europe Ltd

Lean Six Sigma Green Belt Certification Program: Virtual In-House Training

<h3><b>MySQL for developers training course description</b></h3>
        <p>  This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                      <li>Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database.</li>
<li>Use advanced features of the MySQL Client.</li>
<li>Use advanced data types.</li>
<li>Manage the structure of databases and tables.</li>
<li>Manage and using indexes.</li>
<li>Write complex SQL query statements.</li>
<li>Use advanced SQL expressions.</li>
<li>Use advanced SQL functions.</li>
<li>Perform advanced Insert, Update, Delete, Replace and Truncate Operations.</li>
<li>Use user variable syntax and properties.</li>
<li>Import and export data from within MySQL.</li>
<li>Import and export data from the command line.</li>
<li>Perform complex joins to access multiple tables.</li>
<li>Perform complex subqueries.</li>
<li>Create, manage and us views.</li>
<li>Use prepared statements.</li>
<li>Create and use stored routines.</li>
<li>Create and use triggers.</li>
<li>Obtain database metadata.</li>
<li>Optimize queries.</li>
<li>Work with the main storage engines.</li>
<li>Debug MySQL applications.</li>

                  </ul>
        <h5>
        <b>MySQL for developers training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>MySQL foundation </p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL for developers training course contents</b></h3>
      <ul>
        <li>Introduction </li><p>
Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions.

</p><li>Client/server concepts </li><p>
MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options
<br /><span>Hands on</span> Using client/server

</p><li>The MySQL client program </li><p>
Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities.
<br /><span>Hands on</span> Using the MySQL client program

</p><li>Data types </li><p>
Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options.
<br /><span>Hands on</span> Using data types 

</p><li>Identifiers </li><p>
Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names
<br /><span>Hands on</span> Using identifiers

</p><li>Databases </li><p>
Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command
<br /><span>Hands on</span> Using databases

</p><li>Tables and indexes </li><p>
Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata.
<br /><span>Hands on</span> Creating, altering and dropping tables/indexes

</p><li>Querying for data </li><p>
The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause.
<br /><span>Hands on</span> Querying for data

</p><li>SQL Expressions and functions </li><p>
Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions.
<br /><span>Hands on</span> Using expressions and functions

</p><li>Updating data </li><p>
Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements.
Exercise: Inserting, updating, replacing and deleting data

</p><li>Connectors 	</li><p>
MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached.

</p><li>Obtaining database metadata </li><p>
What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage.
<br /><span>Hands on</span> Obtaining database metadata

</p><li>Debugging 	</li><p>
Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility.
<br /><span>Hands on</span> Debugging

</p><li>Joins </li><p>
Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another.
<br /><span>Hands on</span> Coding joins

</p><li>Subqueries 	</li><p>
Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes.
<br /><span>Hands on</span> Coding subqueries

</p><li>Views </li><p>
Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views.
<br /><span>Hands on</span> Using views

</p><li>Import and Export </li><p>
Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options.
<br /><span>Hands on</span> Importing and exporting

</p><li>User variables and prepared statements </li><p>
Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors.
<br /><span>Hands on</span> Using variables and prepared statements

</p><li>Introduction to stored routines </li><p>
Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security.
<br /><span>Hands on</span> Writing simple stored routines

</p><li>Stored routines - program logic </li><p>
The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops.
<br /><span>Hands on</span> Writing stored routines with program logic

</p><li>Stored routines - exception handlers and cursors </li><p>
Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking.
<br /><span>Hands on</span> Writing stored routines with program logic

</p><li>Procedures with parameters </li><p>
Creating procedures with parameters, Calling Procedures With Parameters.
<br /><span>Hands on</span> Writing stored routines with parameters

</p><li>Functions 	</li><p>
What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses.
<br /><span>Hands on</span> Writing functions

</p><li>Triggers </li><p>
Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges.
<br /><span>Hands on</span> Writing triggers

</p><li>Basic optimizations </li><p>
Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization.
<br /><span>Hands on</span> Making use of basic optimizations

</p><li>More about indexes </li><p>
Indexes and joins
<br /><span>Hands on</span> Investigating indexes and joins
				</p>
      </ul>

MySQL for developers

<h3><b>CWISA training course description</b></h3>
        <p>
    This CWISA course covers wireless technologies with
reference to IoT. It examines from an IoT perspective
how wireless works, and is an excellent introduction to
IoT for the wireless engineer. Topics range from wireless
technologies, RF, to mobile networks, IoT, and security.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
      <li>Describe wireless networking and IoT technologies.</li>
					<li>Explain basic RF communications.</li>
					<li>Plan wireless solutions.</li>
					<li>Describe how to implement wireless solutions.</li>
					<li>Use best practices in implementing wireless
solutions.</li>
                  </ul>
                        
        <h5>
        <b>CWISA training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with IoT technologies.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>RF fundamentals.</p>
              
							<li><b>Duration</b></li>
							
              <p>4 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>CWISA training course contents</b></h3>
							
	<ul>				
<li>Introduction to wireless technologies</li><p>
History of wireless, radio waves and frequencies,
wireless technologies and related components,
common components of wireless solutions, LAN
networking requirements, Network security,
Implementing wireless solutions, staging,
documentation, security updates, Industry
organizations, IEEE, compatibility and certification
groups.
</p><li>Wireless network use cases</li><p>
Wireless BANs, Wireless PANs, Wireless LANs,
Wireless MANs, Wireless WANs, Wireless sensor
networks, New network driver-Internet of Things,
IoT for industry (IIoT), IoT for connected vehicles,
Residential environments, Retail, Education (K12), Higher education, Agriculture, Smart cities /
Public access, Health care, Office buildings,
Hospitality, Industry, Stadiums, arenas, and large
public venues.
</p><li>Planning wireless solutions</li><p>
Identifying use cases and applications, common
wireless requirements and constraints, performing
a wireless system design, selecting and evaluating
design parameters.
</p><li>RF communications</li><p>
RF wave characteristics, RF propagation
behaviours, RF signal metrics, fundamentals of
wireless modulation. other wireless carriers,
common frequency bands.
</p><li>Radio frequency hardware</li><p>
Hardware levels, basic RF hardware components
(circuit board level), RF link types (use category).
RF device types.
</p><li>Mobile communications networks</li><p>
Mobile networks, LTE, 5G, Use cases.
</p><li>Short-range, low-rate, and low-power networks</li><p>
RF and speed, RF and range, RF and power,
802.11, 802.15.4, Bluetooth, LoRa (Long range) /
LoRaWAN, ZigBee, 6LoWPAN, NB-IoT and
LTE-M.
</p><li>Wireless sensor networks</li><p>
What is a Wireless Sensor Network (WSN)? WSN
applications, Sensors and actuators, WSN
architectures, Planning a WSN.
</p><li>Internet of Things (IoT)</li><p>
Internet of Things (IoT) defined, IoT history and its
definition revisited, one more comment on the
definition of IoT, IoT verticals, Oil &amp; Gas, IoT
structure/ architecture basics, IoT connected
objects.
</p><li>Securing wireless networks</li><p>
Confidentiality, integrity and availability, Privacy,
non-repudiation, authenticity &amp; safety, Importance
of authentication in wireless networks, Key
cryptographic technologies &amp; concepts,
Authentication methods, Authorisation, OAuth 2.0
authorisation framework, monitoring.
</p><li>Troubleshooting wireless solutions</li><p>
Proper solutions design, designing and
implementing wireless solutions, basic installation
procedures, general configuration considerations,
troubleshooting and remediation, troubleshoot
common problems in wireless solutions.
</p><li>Programming, scripting and automation</li><p>
What is an API? categories of APIs, common API
communication methods, choosing a language,
why are we integrating systems? Application &amp;
integration architectures. Data structures &amp; types,
XML, YAML, API types.
</p>
				</ul>

CWISA Wireless IoT Solutions Administrator

<h3><b>MySQL server admins training course description</b></h3>
        <p>This MySQL Server administration course is designed
for MySQL Server administrators who have a basic
understanding of a MySQL database and a good
working knowledge of SQL commands.
The course provides an understanding of MySQL
Architecture and practical experience in setting up,
configuring and maintaining a MySQL server, backing
up and recovering data and optimising query
performance. This MySQL Server administration course
also covers MySQL replication and its role in high
availability and scalability.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                        <li>Use MySQL Workbench.</li>
 <li>Install and configure a MySQL Server .</li>
 <li>Administer and tune a MySQL server.</li>
 <li>Configure log files and interpret error messages..</li>
 <li>Secure the Server.</li>
 <li>Administer a replication topology.</li>
                  </ul>
        <h5>
        <b>MySQL server admin training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Database administrators, Database developers and
Technical consultants.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Introduction to MySQL</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL server admin training course contents</b></h3>
      <ul>
        <li>Introduction to Oracle Application Express </li><p>
APEX concepts APEX main components Workspaces, database applications and websheet applications Creating a workspace The Workspace Administrator Upgrading APEX Logging into APEX Running an application

</p><li>SWL Workshop </li><p>
Use APEX to browse, create and modify objects Process ad hoc SQL statements Manage scripts in APEX Create, run and save SQL queries

</p><li>Build a database application </li><p>
Application components Create an application Create an application from a spreadsheet

</p><li>Create reports </li><p>
Create reports using wizards Edit report attributes Add links to reports Create a link to a printer-friendly version of a report Save and print reports in different formats

</p><li>Using files </li><p>
Uploading images Creating cascading stylesheet files Uploading static files Adding an Image as an application logo Adding a reference to a Javascript file

</p><li>Pages and regions </li><p>
Web form behaviour in APEX Create a form based on a table Create a form based on a procedure Create a form with a report Create a tabular form Format a form Locking in APEX forms

</p><li>Creating lists of values </li><p>
Overview of application express shared Components Dynamic and static lists of values Create a dynamic list of values Create a static list of values Use a list of values to control data in a report Create a cascading list of values

</p><li>Items and buttons </li><p>
Understand the different Types of items Create items Understand and edit item attributes Use Javascript with item Manipulate items in tabular forms Add dynamic items to a report Create and edit buttons

</p><li>Page Processing </li><p>
Page rendering and page processing Create computations Validate input data Process Data Understand application branching Create conditional branches

</p><li>Shared components </li><p>
Overview of application express navigation components Manage parent and standard tabs Create navigation bar entries Create and use lists and list items Manage breadcrumbs Create shortcuts Shared component subscription User interface defaults

</p><li>Display dynamic content </li><p>
Filter reports with dynamic queries Create charts with a wizard Format charts Create calendars Add links to calendars Create hierarchical trees

</p><li>State and debugging </li><p>
Understand session state Set a session state value Clear the session state Review the session state Review the messages in debug mode Enabling feedback Managing feedback and team development

</p><li>Themes and templates </li><p>
Switch to a different theme View existing templates Understand and manage templates Create a new template Add references to cascading stylesheet and Javascript files

</p><li>Dynamic actions and plug-in components </li><p>
Identify plug-in components and their types Plug In a component Create dynamic actions Use a plug-in in a dynamic action

</p><li>Building website applications </li><p>
Websheet applications and their components Create a websheet application Enable SQL and PL/SQL in a websheet application Add sections and pages to a websheet application Add links on a websheet page Add a data grid to a websheet application Create SQL reports ion websheet applications Add annotations to a websheet application

</p><li>Implementing security </li><p>
Authentication and authorization Provide an authentication scheme Create an authorization scheme using access control Enable and configure session state protection

</p><li>Deploy an appliction </li><p>
Define supporting objects Package an application Export an application Import an application Install supporting objects

</p><li>Administer Apex workspaces </li><p>
Manage workspaces and users Request a schema or storage Purge session state Monitor developer activity log Monitor workspace activity View activity reports Import a workspace

</p><li>Utility programs </li><p>
Import and export data Generate DDL statements View objects reports</p>
      </ul>

MySQL server administration

<h3><b>Querying Microsoft SQL Server course description</b></h3>
        <p>This course covers the technical skills required to write
basic Transact-SQL queries for Microsoft SQL Server
and provides the foundation for all SQL Server-related
disciplines; namely, database administration, database
development and business intelligence. This course
helps prepare for exam 70-761. <br />
Note: This course is
designed for SQL Server 2014or SQL Server 2016. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                       <li>Write SELECT statements.</li>

<li>Create and implement views and table-valued
functions.</li>

<li>Transform data by implementing pivot, unpivot,
rollup and cube.</li>

<li>Create and implement stored procedures.</li>

<li>Add programming constructs such as variables,
conditions, and loops to T-SQL code.</li>

                  </ul>
        <h5>
        <b>Querying Microsoft SQL Server course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Database administrators, database developers, and
business intelligence professionals. <br />SQL power users,
namely, report writers, business analysts and client
application developers.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Database fundamentals</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Querying Microsoft SQL Server course contents</b></h3>
      <ul>
        <li>Introduction to Microsoft SQL Server </li><p>
Management studio, creating and organizing T-SQL scripts, using books online.
<br /><span>Hands on</span> working with SQL Server tools.

</p><li>T-SQL querying </li><p>
Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY.
<br /><span>Hands on</span> introduction to T-SQL querying.

</p><li>Writing SELECT queries </li><p>
Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions.
<br /><span>Hands on</span> writing basic SELECT statements.

</p><li>Querying multiple tables </li><p>
cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins.
<br /><span>Hands on</span> querying multiple tables.

</p><li>Sorting and filtering data </li><p>
Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause.
<br /><span>Hands on</span> sorting and filtering data.

</p><li>SQL Server data types </li><p>
Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions.
<br /><span>Hands on</span> working with SQL Server data types.

</p><li>DML </li><p>
Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML.
<br /><span>Hands on</span> using DML to modify data.

</p><li>Built-in functions </li><p>
Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability.
<br /><span>Hands on</span> built-in functions

</p><li>Grouping and aggregating data </li><p>
Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause.
<br /><span>Hands on</span> grouping and aggregating data.

</p><li>Subqueries </li><p>
Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries.
<br /><span>Hands on</span> subqueries.

</p><li>Table expressions </li><p>
Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs).
<br /><span>Hands on</span> table expressions.

</p><li>Set operators </li><p>
The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators.
<br /><span>Hands on</span> set operators.

</p><li>Windows ranking, offset, and aggregate functions </li><p>
OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions.

</p><li>Pivoting and grouping sets </li><p>
	PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses.
<br /><span>Hands on</span> pivoting and grouping sets

</p><li>Executing stored procedures </li><p>
Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures.
<br /><span>Hands on</span> executing stored procedures.

</p><li>Programming with T-SQL </li><p>
T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms.
<br /><span>Hands on</span> programming with T-SQL

</p><li>Error handling </li><p>
T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client.
<br /><span>Hands on</span> implementing error handling.

</p><li>Implementing transactions </li><p>
Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block.
<br /><span>Hands on</span> implementing transactions.
</p>
      </ul>

Querying Microsoft SQL Server

<h3><b>Oracle Database 12c Admin training course description</b></h3>
        <p> This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                        <li>Administer an Oracle database instance.</li>
<li>Monitor an Oracle database.</li>
<li>Configure the Oracle network environment.</li>
<li>Create and manage database storage structures.</li>
<li>Manage users, profiles, privileges and roles.</li>
<li>Manage undo data and temporary segments.</li>
<li>Monitor and resolve lock conflicts.</li>
<li>Maintain database security.</li>
<li>Implement database auditing.</li>
<li>Monitor the performance of the Database.</li>
<li>Load and unload data.</li>
<li>Use the job scheduler.</li>
<li>Configure a database for backup and recovery.
</li>
                        
                  </ul>
        <h5>
        <b>Oracle Database 12c Admin training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. </p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended.</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Oracle Database 12c Admin training course contents</b></h3>
      <ul>
        <li>Introduction to Oracle database 12c </li><p>
Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks.

</p><li>Oracle Database 12c Architecture </li><p>
Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance.

</p><li>Administer a database instance </li><p>
Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files.

</p><li>Configure the Oracle network environment </li><p>
Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager.

</p><li>Storage Structures </li><p>
Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles.

</p><li>Manage users </li><p>
Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions.

</p><li>Manage profiles and resources </li><p>
Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles.

</p><li>Manage privileges </li><p>
Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles.

</p><li>Database auditing </li><p>
Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options.

</p><li>Data concurrency and lock conflicts </li><p>
Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts.

</p><li>Undo management </li><p>
Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size.

</p><li>Proactive database management </li><p>
Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/

</p><li>Performance management </li><p>
Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory.

</p><li>SQL tuning </li><p>
SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor.

</p><li>Moving data </li><p>
Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables.

</p><li>Automate tasks with the scheduler </li><p>
Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule.

</p><li>Managing resources with Resource Manager </li><p>
Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans.

</p><li>Manage space </li><p>
Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments.

</p><li>Backup and recovery configuration </li><p>
Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability

</p><li>Oracle support </li><p>
The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch</p>
      </ul>

Oracle database administration

Southend on Sea

Rotherham

Manchester

Slough

Portsmouth

Bingley

Nottingham

Paisley

Birmingham

Luton

Northampton

Bedford

Liverpool 

Swansea

BASIC to ADVANCED COURSE PACKAGE

Complete 3 courses over 2 full days and receive three qualifications:

Introduction to Phlebotomy Certificate (Nationally Recognised Level 3, Ireland Level 5)
Days 1 and 2: 9.30am – 5.00pm

Advanced Phlebotomy Certificate (Nationally Recognised Level 4, Ireland Level 6)
Day 1: 5.30pm - 8.30pm

Geopace Certificate of Competency (Nationally Recognised Accredited, CPD Practical Skills)
Day 2: 5.30pm - 8.30pm

Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.






Key Facts & Summary:


COURSE 1: INTRODUCTION TO PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Three (Ireland Level Five)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (21 CPD Points)

PART 1 (DAY 1) - 9.30am to 5.00pm
PART 2 (DAY 2) - 9.30am to 5.00pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

A TWO DAY venepuncture course at Level 3. Trains up to the point of live blood draws.

On completion awards a Nationally Recognised and Accredited Certificate in Phlebotomy.

DAY ONE (PART 1) - THEORY
Attend the course location of your choice – starts at 9.30am and finishes approx. 5.00pm

DAY TWO (PART 2) - CLASSROOM
Your classroom tutor will recap on the theory element (above) after which you will begin your practical sessions learning and developing the skills required up to the point of Live Blood Draws.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 2: ADVANCED PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Four (Ireland Level 6)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (14 CPD Points)

PART 1 - THEORY
Complete your theory training online in the comfort of your own home or at work.

PART 2 - CLASSROOM
Follow on from your Day One Theory training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.

On completion awards a Nationally Recognised and Accredited Certificate in Advanced Phlebotomy.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 3: ROUTE TO COMPETENCY MASTERCLASS
CPD ACCREDITED - The CPD Certification Service

CLASSROOM
Follow on from your Day Two practical training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

GEOPACE LIVE BLOOD SESSIONS enabling you to draw human blood under 1-to-1 supervision of your tutor. You will follow a Competency Checklist, signed off by your tutor on completion.

On completion awards a Geopace Certificate of Competency - Nationally Recognised and Accredited Route to Competency - Live Blood Draws Certificate

DOWNLOAD A COURSE ITINERARY HERE




How do I attend?

EITHER -
CLASSROOM OPTION - Attend one of our scheduled classroom locations, completing your Introduction to Phlebotomy Course over 2 days. You will also complete your Advanced Training at the end of the first day and your Competency Training at the end of the second day.

Our Introduction to Phlebotomy and Advanced Phlebotomy Training Kits are supplied at no charge when booking our virtual classroom training option.
If you would like to add one or both of these kits to your classroom training option then these are available to add at time of booking. Our comprehensive training kits each mirror the same equipment and supplies used in the classroom and both include detailed video tutorials, allowing you to continue to practice and "hone" your skills after you have completed your practical training.

OR -

VIRTUAL CLASSROOM OPTION- Complete your theory training online at home or work, then join us for a one day Zoom session to complete your Introduction to Phlebotomy virtual classroom training, followed by your Advanced Training in the evening of the same day. You have the option to add a classroom-based competency session, awarding a CPD Accredited Geopace Certificate of Competency, at time of booking.

Our Virtual Classroom option includes two very comprehensive training kits - one for your introductory course and one for your advanced course. Kits are included at no charge (normally £79.95 each) and are yours to keep and to continue to practice with after you have finished your courses. The equipment and supplies included in your kits are the same as those used if you choose the classroom option.

How do I book?

Choose whether you would like to attend in a classroom or if you would like to complete your training by virtual classroom.
Click on the Classroom - Booking Options or Virtual Classroom - Booking Options buttons below to see all upcoming dates and locations.

Please note - Competency Training
Our Route to Competency Masterclass - Live Blood Sessions can only be completed in a classroom environment. This is included when you book a classroom option. When booking the virtual classroom option you can choose to add this at time of booking. You will receive a voucher code to enable you to book onto any upcoming dates or locations. For most of our two day course we run our competency training at the end of the second day and therefore you should be able to complete your full training programme with us over two days.

If you are completing your training by virtual classroom please see our list of competency training locations here.

If you would like to "mix and match" your training dates and/or locations then please call our admin team on 01525 713377 who will be more than happy to put a training package together for you on dates and / or locations that suit you.

All courses are accredited and are Skills for Health & WHO compliant.

Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

THIS COURSE PACKAGE INCLUDES:
1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5)
2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6)
3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom)

Learn how to take blood ... train as a Phlebotomist

FAST-TRACK YOUR PHLEBOTOMY TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% off -  Multi-Course Discount

    Cover all stages from beginner through to Level 4

    Available as Classroom or Virtual Classroom

    Complete your beginner to advanced training in 2 days

    Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications

    Both courses are dually accredited (OCN & CPD)

    Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom

    Covers all steps up to live blood draw

    Learn advanced skills and techniques

    Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep)

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Phlebotomy Training - Beginner to Advanced PACKAGE

ONLINE STUDY + ONE DAY ZOOM SESSION
NO CLASSROOM ATTENDANCE REQUIRED


Awarding Body: Dual Accreditation - Open College Network (OCN Credit4Learning) & The CPD Certification Service (21 CPD Points)
 
Award Level: UK - Level Three (Advanced) + 21 CPD Points
Ireland Level Five (Advanced) + 21 CPD Points
 
Minimum Age: 18 (16 with parental consent)
 
Entry requirements: None. English Level 2 desirable
 
Training Locations: Study online + virtual classroom.
 
Practical Training: Includes FREE Practise@Home Phlebotomy Training Kit worth £79.99
This comprehensive 76 piece practical training kit includes mini-arm trainer, sharps container and all medical grade supplies needed as well as a step-by-step 30 minute training video.



PART 1 (THEORY) - STUDY AT HOME ONLINE :
Complete your theory training online in the comfort of your own home or at work. Stop/start when it suits you and complete the online modules at your own pace. Can be completed on multiple devices such as laptop, smart-phone, desktop computer, kindle, tablet etc.
 
PART 2 (PRACTICAL SESSIONS) - JOIN US FOR A COMPREHENSIVE ONE DAY ZOOM SESSION:
Full instructions will be provided. We will send you a completely free Practise@Home Phlebotomy Training Kit, including a mini-arm trainer, for you to keep. You will follow your tutor's on-screen instructions during your Zoom virtual classroom sessions as you learn and develop your phlebotomy skills. The procedures and practices taught online are exactly the same as you would learn in the classroom. At any time before or after your course you can watch our 30 minute step-by-step video to refresh your knowledge and continue to use your training kit to practice your skills.
 
(THIS COURSE AWARDS THE SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR CLASSROOM AND HYBRID COURSE VERSIONS)


Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


COURSE ITINERARY

 
A dually-accredited hybrid modular venepuncture course awarding an
OCN Accredited Level Three Certificate (3 credits) & 21 CPD Points


Nationally Recognised Qualification


Part 1 - online (eLearning) Part 2 - Virtual Classroom (1 Day Zoom)


PRE-COURSE
Home study pack - download and complete before the virtual classroom sessions

PART 1 - ONLINE
M01: Course Overview
M02: History, Definitions and Roles
M03: Work-flow cycles
M04: Professionalism
M05: Health & Safety
M06: Blood Collection Systems
M07: Anatomy & Physiology
M08: Blood Composition
M09: Using the equipment
M10: Performing the venepuncture - see Classroom Part 2
M11: Lab Tests and Bottle Types
M12: Analytical Errors
M13: Informal Quiz – answers
M14: Award – accredited certificates, value, application and overview. Job Opportunities.


PART 2 - VIRTUAL CLASSROOM (ONE DAY ZOOM SESSION)
M01: Introduction: Welcome, Introductions and Overview.
M10: Performing the venepuncture (theory overview)
P01: Practical Session 1 – Equipment familiarisation - "Tools of the Trade"
P02A: Practical Session 2A – Unpacking your training kit
P02B: Practical Session 2B - A look at the mini-arm trainer and associated equipment
P03: Practical Session 3 – Using the tourniquet and identifying a vein
P04: Practical Session 4 – Handling and assembling the equipment. Familiarisation and procedures including initial skill-set development
P05: Practical Session 5 - Further skill-set development and consolidation. Discussing needle types including winged infusion sets (butterfly needles)
P06A: Practical Session 6A – Performing the venepuncture on the mini-arm trainer. Palpating the vein, performing the venepuncture. Sample handling and labelling.
P06B: Practical Session 6B – Consolidating pre- and post-venepuncture procedures.
 
Additional support material can be downloaded as you progress through the course online.





ZOOM SESSION

VIRTUAL CLASSROOM (ZOOM) SESSIONS 
Our Virtual Classroom training course consists of online study (Part 1 - theory) and Virtual Classroom Zoom sessions (Part 2 - practical skill-set development)
You must complete your Part 1 online study before joining us for your Zoom session(s).
Once you have enrolled on this course you will be sent a free Practise@Home Training Kit, This is yours to keep and can be reused any many time as you wish after you have completed the course.
Your Booking Confirmation will include your Zoom log-in details.



Learn how to take blood ... train as a Phlebotomist

    Nationally Recognised Qualification

    No previous experience or qualifications needed

    OCN Accredited - Level 3 (advanced)

    CPD Accredited (The CPD Certification Service)

    Covers all steps up to live blood draw

    Practise on artificial arm and fake blood!

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Introduction to Phlebotomy Course (GPT003VC) - 1 DAY Virtual Classroom

Brighton

ONLINE STUDY - In your own time (approx. 6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)



Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 4 (Foundation Degree Level) - Ireland Level 6
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 4 (Ireland Level 6)

 
PART 1 - Theory: Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.

PART 2 - Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.


Attend a classroom location to complete your practical training.


Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


Course Itinerary:
PART 1 - THEORY (ONLINE)
M00 - Introduction:
Learning outcomes, Assumptions and Overview.
M01 - Basic Phlebotomy - revision:
Recap of basic phlebotomy theory and practice - precursor to
the advanced course.
M02 - Aspirated and Vacuated Systems:
Open systems (Syringe & Needle), closed systems (Vacutainer & Monovette), Alternative closed systems, Using Monovette - aspiration and evacuated techniques, monovette adapter systems.
M03 - Specialised and Advanced Phlebotomy Equipment:
The centrifuge - overview. Safe operation and use. Managing a centrifuge breakage or spillage.
Equipment and practices in unusual situations.
Patients with special needs and requiring specific attention.
Equipment preparation for blood samples that are collected at
0 degrees, 37 degrees C and other non-standard conditions.
A look at advances in technology and how to use the latest devices.
M04 - Point of Care Testing:
What is POC Testing? Advantages, Disadvantages and Clinical
Outcomes. Comparison of POC with lab testing. 10 common POC tests. Roles for phlebotomists performing POC Tests.
M05 - Neonates and Children:
Sample collection from new-born to pre-adult. A detailed overview of legal principles of law including child consent and child protection for phlebotomists. Neonatal and child blood collection equipment.
A comprehensive look at heel and finger-prick procedures including
microtainers, lancets and capillary tube collection. Detailed heel prick procedure. Paediatric finger prick collection. The life-threatening hazard of over-collecting. Communication techniques in differing age bands.
Consent and the law. Basic principles of lawful consent for neonates and paediatric patients. Child protection.
Detailed analysis of neonatal and paediatric blood collection including Guthrie card collection. Neonatal bottles - colours and tests. Paediatric blood gases collection.
Butterfly needles - when to use. Blood tests during pregnancy. Neonatal blood screening - nine conditions covered. Bilirubin in neonates.
M06 - Geriatric Patients:
The challenges of phlebotomy in older people. Understanding skin changes and venepuncture implications. A profile of common
geriatric blood tests. Age related problems. Procedural precautions.
M07 - Special Procedures:
Drawing blood from back of hand. Drawing blood from lower limb veins. Managing the unwilling or difficult patient. Managing the psychiatric patient. Managing the isolated patient. Non-routine blood tests. Managing the latex allergy patient (type 1 and type 4 reactions). Latex indicators. Sample handling - non-routine procedures. Drug trials and research projects.
M08 - Special Tests and Sample Handling Procedures:
A look at sample collection at specific times of day and night,
samples that are protected from light, collected on ice and
collected at body temperature. Procedures for each group - collection notes, analytic time, optimal collection time and notes for each group.
M09 - Advanced Phlebotomy Tasks:
Additional procedures. Maintaining POC equipment. Stock control and stock rotation. Quality control. Data entry. Product evaluation. Training and competency evaluation.
M10 - Alternative Environments:
A step-by-step look at non-clinical phlebotomy environments including private testing, DEFRA, forensic and police, cord blood collection, DNA analysis, veterinary services, overseas and volunteering.

PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING

PART 2 (CLASSROOM)
MORNING , AFTERNOON OR EVENING SESSION:

1 - Welcome, introductions and overview:
- Classroom - health & safety briefing, schedule overview.
- Virtual Classroom - audio/visual checks and registration. Unpacking and overview of your training kit.
2 - Syringe and Needle (open system): Correct use and applications.
3 - Monovette (open and closed systems):
Using the Monovette system in aspiration mode - correct use and applications.
Using the Monovette system in evacuated mode - correct use and applications.
4 - IR Vein Detector:
Demonstration of the IR vein detector for assisting in detection of difficult veins.
5 - Veins in back of hand:
Detecting suitable veins in the back of the hand.
6 - POC testing:
Point of Care Testing - use of glucose meter to demonstrate a typical POC test procedure. Correct use and overview of other POC test devices.
7 - Using lancets (finger collection)
We look at the correct use of lancets for POC testing and whole blood micro-collection.
8 - Using lancets (heel collection)
We look at the correct use of lancets for neonatal blood spot tests (Guthrie Test).
9 - Capillary collection
Using glass capillary tubes for micro-collection. Correct use and handling.
10 - Microtube collection
Correct use of BD Microtainers (and similar micro-collection bottles) - collection and handling.

This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.
 
(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)



The UK's first and only Level 4 qualification in Phlebotomy (equivalent to Ireland Level 6)

    FDSc (Foundation Degree Level) qualification

    Nationally Recognised certificate

    Dually accredited: Open College Network  and CPD

    Covers both aspirated and evacuated systems

    Covers specialised blood collection systems & methods

    Classroom or Virtual Classroom learning options

    Comprehensive Training Kit is provided when booking our Virtual Classroom option (yours to keep)

    Complete your training from beginner to advanced level

    This course either follows on from our Introduction to Phlebotomy Course  or can be combined with our introductory course as part of a course package (see below)

    Available to candidates who have completed (or are currently enrolled to complete) our Introduction to Phlebotomy Course or have previous phlebotomy practical experience.


Advanced Phlebotomy - Skills & Techniques (GPT005)

Key Facts:


COURSE 1: PERIPHERAL I.V. CANNULATION COURSE (GPT008)



ONLINE STUDY - In your own time (approx. 5-6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)



Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 3 (Advanced Level) - Ireland Level 5
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 3 (Ireland Level 5)

 
PART 1 - Theory: Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.

PART 2 - Skills and Practical Development:
Safely and competently set up and maintain a Peripheral IV Infusion.


Attend a classroom location to complete your practical training.

 
Course Itinerary:
PART 1 - THEORY (ONLINE)
M1 - Peripheral IV Cannulation - Introduction:
Definitions - understanding terminology relating to PIVC.
IV Therapy and NMC guidelines.
M2 - Legal & Professional Responsibilities:
Legal Obligations and Accountability. Criminal, Civil and
Contractual law in Healthcare. Vicarious Liability and your
Duty of Care.
M3 - Anatomy & Physiology:
Sites appropriate to IV cannulation. Hand vs. arm.
Advantages and disadvantages of relevant veins.
An overview of Homeostasis and Fluid Balance.
M4 - Hygiene and Infection Prevention & Control (IPC):
Reducing healthcare-associated infections. Keeping Safe.
Bloodborne Pathogens and Work Practice Controls.
Standard Precautions. Waste Disposal. Needle-stick injuries.
M5 - Indications and Advantages:
When to cannulate, infusion types and benefits over
alternative infusion routes. Continuous and intermittent infusion.
Prophylactic use before procedures and in unstable patients.
Contraindications.
M6 - Equipment:
Cannula types, sizes and colour coding. How to select
appropriate size. Equipment overview for total procedure.
M7 - Vein Choice for Cannulation:
Correct vein selection. Which veins to avoid.
How to manage an unsuccessful cannulation.
M8 - Procedures:
Full procedure for cannulation including correct documentation.
M8: Guide to Cannulation - revision
M8: Video - Recap with full procedure
M9 - Contraindications:
When inappropriate to cannulate including patients with specific health conditions.
M10 - Complications:
A detailed look at potential complications during and after
cannulation, including phlebitis, infections, petechiae and haematomas. Clinical signs and corrective actions.

PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING

PART 2 (CLASSROOM:
1 - Welcome, introductions and overview:
Classroom - registration and introductions.
Virtual Classroom - audio/visual checks and registration.
2 - Legal & Professional Responsibilities:
Overview and discussion.
3 - Anatomy - key points (appropriate to PIVC):
Arteries and veins. Selecting an approprate site. Sites to avoid and “first choice” sites.
4 - Cannulae - selection and types:
A detailed look at different types of cannulas, respective benefits and attributes. Selectinng an appropriate pVAD.
5 - Complications:
Complications of pVAD insertion including examples of
infiltration, haematoma, extravasation and transfixation.
6 - VIP Score:
Understanding and using the Visual Infusion Phlebitis score.
7 - Equipment - overview:
We take a look at all essential equipment required for PIVC.
8 - PRACTICAL SESSIONS:
Multiple practical sessions throughout the session.
9 - Fluids:
The importance of understanding fluids. Includes detailed overview of: maintenance fluids, Hartmann’s solution, Colloids (and risks), blood products.
10 - Infusion Rates:
Calculating infusion rates and drops per minute.

This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.
 
(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)
Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.





Key Facts:


COURSE 2: VACCINATION / INJECTION COURSE (GPT601)



ONLINE STUDY - In your own time (approx. 5-6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)


Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 4 (FDSc Level) - Ireland Level 6
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 4 (Ireland Level 6)



SUITABLE FOR:
- MEDICAL / HEALTHCARE (trainees and professionals)
- AESTHETIC THERAPISTS (all levels)

 
This Vaccination / Injection Course is a nurse or paramedic-led half-day session covering all essential theory and practical skill-sets required to deliver effective Intramuscular, Intradermal and Subcutaneous injections / vaccinations.
 
PART 1 - THEORY (online)
Delegates will fully understand the theory and will be able to demonstrate they can identify the correct patient, gain consent and safely administer a vaccine or injection, conforming to WHO and Skills for Health recommended standards.
 
Itinerary:
M01 Course Overview and brief history
M02 Infection Protection Control
M03 Professionalism and Effective Communication
M04 Understanding injection procedures
M05 Why do we vaccinate?
M06 The immune system and how vaccines work. Vaccine types and composition.
M07 The National Vaccine Policy & Schedule
M08 Vaccine preventable diseases
M08A – Covid-19 Update
M09 Vaccines - understanding the reconstitution process
M10 Storage and Handling – understanding correct procedures and protocols
M11 Equipment – Syringes and Syringe Types, Needles and Needle Types, SDV (Single-Dose Vials), MDV (Multi-Dose Vials), Pre-Filled Syringes, Gloves and PPE.
M12 Vaccination sites, techniques and anatomical site selection
i) Intramuscular (IM) Injection
ii) Subcutaneous (SubCut) Injection
iii) Intradermal (ID) Injection
M13 Legal requirements, Consent and Standard Operating Procedures
M14 Adverse Reactions and Basic Life Support Guidance
M15 Record keeping & Documentation
 
PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING
PART 2 - CLASSROOM (am, pm or evening sessions)
3 - 4 hours skill-set development with practical demonstrations and hands-on experience performing Intramuscular, Intradermal and Subcutaneous Injections.
 


How do I attend?

EITHER -
CLASSROOM OPTION - Complete your theory training online at home or work, then attend one of our scheduled classroom locations, completing your Peripheral IV Cannulation Course and your Injection Course on the same day.
Our Peripheral IV Cannulation Course and Injection Course training kits are supplied at no charge when booking our virtual classroom training option.
If you would like to add one or both of these kits to your classroom training option then these are available for you to add at time of booking. Training kits mirror the same equipment and supplies used in the classroom and both include detailed video instructions, allowing you to continue to practice and "hone" your skills after you have completed your practical training.

OR -

VIRTUAL CLASSROOM OPTION- Complete your theory training online at home or work, then join us for your one full day to complete your cannulation and injection course training.

Our Virtual Classroom option includes two very comprehensive training kits - one for your cannulation course and one for your injection course. Kits are included at no charge (normally £79.95 and £39.95 respectively) and are yours to keep and to continue to practice with after you have finished your courses. The equipment and supplies included in your kits are the same as those used if you choose the classroom option.

How do I book?

Choose whether you would like to attend in a classroom or if you would like to complete your training by virtual classroom.
Click on the Classroom - Booking Options or Virtual Classroom - Booking Options buttons below to see all upcoming dates and locations.

Additional Courses suitable for Aesthetic Therapists:
Our popular Introduction to Phlebotomy Course also trains you to perform venepuncture at Advanced Level. We offer both classroom and virtual classroom options for this course and a comprehensive Practise@Home Training Kit is provided for our virtual classroom option. Both options are accredited at Advanced Level.
If you already have phlebotomy skills (or decide to enroll on our phlebotomy training course) then you will be able to offer your clients Platelet-Rich Plasma (PRP) Treatments, also known as Vampire Facials. Our PRP (Vampire Facials) Course trains you in the harvesting, preparation and treatment of PRP for application to your clients as required. We offer both classroom and virtual classroom options for this course and a comprehensive Practise@Home Training Kit is provided for our virtual classroom option. Both options are accredited at Foundation Degree Level.

If you would like to "mix and match" your training dates and/or locations or would like to build your own package of courses then please call our admin team on 01525 713377 who will be more than happy to put a training package together for you on dates and / or locations that suit you.

All courses are dually accredited and are Skills for Health & WHO compliant.

Medical Aesthetics

Platelet-rich plasma (PRP)

Intravenous Cannulation

Aesthetic Practitioner

Facial Aesthetics

THIS COURSE PACKAGE INCLUDES:
1: PERIPHERAL I.V. CANNULATION - IV THERAPIES COURSE (GPT008)
2: VACCINATION / INJECTION COURSE (GPT601)

Learn how to administer injectables and intravenous therapies ...

FAST-TRACK YOUR AESTHETICS TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% Multi-Course Discount

    Cover all stages from Level 1 through to Level 4 (FDSc)

    Cover your theory training online

    Complete your advanced practical training in 1 day

    Practical training in Classroom or Virtual Classroom

    Comprehensive Practise@Home training kits for VC

    Awards 2 accredited qualifications

    Dual Accreditations for all courses

    Covers all steps required to safely perform injectables

    Covers all steps required to safely perform IV therapies

    Practise IV on artificial arm with fake blood

    Practise injection techniques on realistic injection pads

    Learn beginner to advanced skills and techniques

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Aesthetic Therapy Training - Beginner to Advanced PACKAGE

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Retreat in Daily Life</strong> is a way to find something of what you might experience on a residential retreat, with the difference being that you are at home, and the prayer experience is woven into the rhythm of your ordinary life.&nbsp;</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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The&nbsp;Contemplative at Home Retreat in Daily Life</strong> involves two components:</p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Six days per week : Thirty to Forty-five minutes of <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">daily personal prayer</strong>, with suggested meditations and reflection questions.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">One day per week : A&nbsp;two-hour Zoom call, to share with other pilgrims who are on retreat with you. Lissy hosts these sessions in a <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">group spiritual direction</strong> format.&nbsp;</li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is this for?</strong></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">This retreat is suitable for anyone who has (or has had) some kind of practice of Christian prayer, and is ready to explore a bit more of their faith, their prayer life or their relationship with God.&nbsp;</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">This might be for you if you</div><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Would like to explore the contemplative prayer traditions of the Christian faith</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Are ready for something deeper in your relationship with God</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Hope to find God in new ways</div></li><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">Would like some structure and support to help you reinstate a habit of daily prayer</div></li><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">Would like to go away on retreat, but are unable to at the moment</div></li><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Enjoy&nbsp;</span>Contemplative at Home meditations and want to connect&nbsp;with others who do as well</div></li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prayer Material</strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></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;">Meditations from the Contemplative at Home archives are suggested for five days of the week, with an Examen or review practice on the sixth day of the week. Each week follows a slightly different theme.</span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p id="isPasted" style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week One: Introduction to Contemplative Prayer / Establishing your Routine</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week Two: Lectio Divina / Listening to Scripture</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week Three: Imaginative Contemplation / Encoutering Jesus&nbsp;</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week Four: Praying with the Psalms / My Life in God</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Prompts for reflection are also provided. Most of the meditations are around twenty minutes in length, with a suggested 15 minutes after the audio&nbsp;meditation for journalling or reflecting on your prayer experience.&nbsp;</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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Further Details and Commitment</strong></p><p 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;">The times listed on the sign up link above reflect the time for the group calls. Please be aware of your local time zone. I work in the UK and times may be listed for GMT.&nbsp;&nbsp;</span></p><p 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;">There will be one call before the retreat begins, and one at the end of each week, for a total of 5 calls.&nbsp;</span></p><p 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;">There will be a maximum of six participants in the group.<br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please check that you are able to attend all of the group sessions before you apply.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The daily prayer can be done at any time that suits you but, if you don&#39;t already have a 30-45 minute window of time devoted to prayer each day, do take some time to think about when you might fit it in, for example: will you wake up earlier? Will you do it at lunch time? in the evening? How realistic is this? &nbsp;Is there a place in your house where you could sit to pray? Will&nbsp;those you share space with will be able to respect your commitment to the retreat?</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;">This won&#39;t be for everyone, but for those who are drawn to take part in this prayer experience, I have no doubt that it will be a positive and enriching time. I am really looking forward to sharing this space with you.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</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>

Contemplative at Home

Contemplative at Home Retreat in Daily Life

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

Nexus Human

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 for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.</p>Overview<p>Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment. Analyze data by using queries and reports. Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Intune. Deploy and manage the Configuration Manager client. Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. Identify and configure the most appropriate method to distribute and manage content used for deployments. Distribute, deploy, and monitor applications for managed users and systems. Maintain software updates for PCs that Configuration Manager manages. Implement Endpoint Protection for managed PCs. Configure an operating-system deployment strategy by using Configuration Manager. Manage and maintain a Configuration Manager site.</p><p>This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports.  Although this course and the associated labs are written for Microsoft Endpoint Configuration Manager and Windows 11, the skills taught will also be backwards compatible with previous editions of System Center Configuration Manager and Windows 10.</p>Prerequisites<p></p><li>Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.</li>  <li>Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.</li>  <li>Installation, configuration, and troubleshooting for Windows-based personal computers.</li>  <li>Basic concepts of public key infrastructure (PKI) security.</li>  <li>Basic understanding of scripting and Windows PowerShell syntax.</li>  <li>Basic understanding of Windows Server roles and services.</li>  <li>Basic understanding of the configuration options for iOS and Android Mobile device platforms.</li><p></p></div><div id="course-pills-2"><h3>1 - Managing computers and mobile devices in the enterprise</h3> <ul> <li>Overview of systems management by using enterprise management solutions</li> <li>Overview of the Configuration Manager architecture</li> <li>Overview of the Configuration Manager administrative tools</li> <li>Tools for monitoring and troubleshooting a Configuration Manager site</li> </ul> <h3>2 - Analyzing data using queries, reports, and CMPivot</h3> <ul> <li>Introduction to queries</li> <li>Configuring SQL Server Reporting Services</li> <li>Analyzing the real-time state of a device by using CMPivot</li> </ul> <h3>3 - Preparing the Configuration Manager management infrastructure</h3> <ul> <li>Configuring site boundaries and boundary groups</li> <li>Configuring resource discovery</li> <li>Organizing resources using device and user collections</li> </ul> <h3>4 - Deploying and managing the Configuration Manager client</h3> <ul> <li>Overview of the Configuration Manager client</li> <li>Deploying the Configuration Manager client</li> <li>Configuring and monitoring client status</li> <li>Managing client settings and performing management operations</li> </ul> <h3>5 - Managing inventory for PCs and applications</h3> <ul> <li>Overview of inventory collection</li> <li>Configuring hardware and software inventory</li> <li>Managing inventory collection</li> <li>Configuring software metering</li> <li>Configuring and managing Asset Intelligence</li> </ul> <h3>6 - Distributing and managing content used for deployments</h3> <ul> <li>Preparing the infrastructure for content management</li> <li>Distributing and managing content on distribution points</li> </ul> <h3>7 - Deploying and managing applications</h3> <ul> <li>Overview of application management</li> <li>Creating applications</li> <li>Deploying applications</li> <li>Managing applications</li> <li>Deploying and managing Windows apps</li> </ul> <h3>8 - Maintaining software updates for managed PCs</h3> <ul> <li>The software updates process</li> <li>Preparing a Configuration Manager site for software updates</li> <li>Managing software updates</li> <li>Configuring automatic deployment rules</li> <li>Monitoring and troubleshooting software updates</li> <li>Enabling third-party updates</li> </ul> <h3>9 - Implementing Defender Protection for managed PCs</h3> <ul> <li>Overview of Endpoint Protection in Configuration Manager</li> <li>Configuring, deploying, and monitoring Endpoint Protection policies</li> <li>Configuring and deploying advanced threat policies</li> <h3>10 - Managing compliance and secure data access</h3> <ul> <li>Overview of Compliance Settings</li> <li>Configuring compliance settings</li> <li>Viewing compliance results</li> <li>Managing resource and data access</li> <h3>11 - Managing operating system deployment</h3> <ul> <li>An overview of operating system deployment</li> <li>Preparing a site for operating system deployment</li> <li>Deploying an operating system</li> <li>Managing Windows as a service</li> <h3>12 - Managing and maintaining a Configuration Manager site</h3> <ul> <li>Configuring role-based administration</li> <li>Configuring Remote Tools</li> <li>Overview of Configuration Manager site maintenance and Management Insights</li> <li>Backing up and recovering a Configuration Manager site</li> <li>Updating the Configuration Manager infrastructure</li> <h3>13 - What?s new in Microsoft Endpoint Configuration Manager</h3> <ul> <li>Whats new in Microsoft Endpoint Manager covering each semi annual release</li> </ul></ul></ul></ul></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55348: Administering Microsoft Endpoint Configuration Manager 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 55348: Administering Microsoft Endpoint Configuration Manager 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>

Microsoft Certification

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sixty minute webinar on rally regularity timing for jogularity and regularity in styles where a full average speed time schedule is provided. The competitive component of on the public highway historic road rallying, focusing on jogularity style timing. Ideal for competitors on events such as HERO Challenge, Rally the Globe events or Three Castles.
</p>

Join our exclusive 60-minute webinar on rally regularity timing, designed to give an introduction to regularities in the jogularity or cumulative speed table styles. Learn how to navigate a full average speed time schedule and master the competitive aspects of historic road rallying on public highways. This session focuses on the processes required to understand and use the supplied time schedules, perfect for those competing in events like the HERO Challenge, Rally the Globe, and Three Castles. Whether you're a seasoned competitor or looking to sharpen your skills, this webinar will equip you with the strategies you need to succeed.


Rally Navigation Training Services

Sports & Fitness

Historic Road Rallying training webinar on Regularity focusing on the Jogularity and Cumulative Speed Table styles.

Rally Navigation - Introduction to Regularity Timing

<div data-node="61658ba442cd6" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61658ba442cd7" fr-original-style="" style="box-sizing: border-box;"><div data-node="61658ba442cd8" fr-original-style="" style="box-sizing: border-box;"><div data-node="61658ba442cd9" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79d7" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="6165945ab79d8" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79d9" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79da" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c2" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40c3" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c4" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c5" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Digital Electronics Course</span></h3></div><div data-node="618322664d7fd" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Aim</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Digital Electronics Course</strong>&nbsp;is designed to give practical knowledge of the type of electronic circuitry used in a modern Computer System or in any type of Computer Controlled equipment such as Photocopiers, Cash Registers, Tablets, mobile phones and many other types of IT equipment.&nbsp;</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);">Digital Electronics involves the use of Silicon chips (Integrated Circuits). The internal structure of a computer is to a large extent comprised of Digital Electronic Circuits.</p></div></div><div data-node="618322b7d4864" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Duration and Schedule</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Digital Electronics Course</strong> runs over 10 evenings (every Monday and Wednesday) from 7.00pm to 10.00pm with the next course commencing on&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(255, 0, 0);">Monday 2nd September 2024 at 7.00 pm</span>.</strong></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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(255, 0, 0);"><b style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">A payment of &pound;65 secures your place on your chosen course.</b><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;The balance of the course fees of &pound;600 can be paid shortly before course commencement.</span></span><br fr-original-style="" style="box-sizing: border-box;"></strong></p></div></div></div></div></div><div data-node="61657d76a40c7" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40c8" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c9" fr-original-style="" style="box-sizing: border-box;"><div data-node="6183230b58256" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Online Virtual Classroom &ndash; how it works?</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The course will be delivered through 9 online virtual classroom sessions. The 10th and last session will involve the additional practical work for the course as well as the written examination (multiple choice for City &amp; Guilds and written for Hi-Tech Training) which will take place at our training centre at 43 North Great Georges Street, Dublin 1 (completed online for non ROI learners).</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);">During the virtual classroom sessions, trainees will have a live video feed with their instructor talking to them, doing practical live demonstrations on equipment being involved actively in the learning.</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);">We will send out a practical kit so that trainees can complete assignments and practical work at home. The kit is the property of Hi-Tech Training and will be returned to Hi-Tech Training on the last day of the course.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></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);">(The kits may also be purchased by the learner&hellip;.see the&nbsp;<a href="http://hitechtraining.ie/product-category/electronics-courses/digital-electronics-course/" target="_blank" rel="noopener" style="color: rgb(209, 33, 56); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(209, 33, 56);">Kits Page Link</a>&nbsp;for more details).<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></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);">The kit consists of power supply unit breadboard, multimeter, cables, The kit consists of breadboard, multimeter, oscilloscope, battery and connectors, components including resistors, LEDs and ICs (AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, Latches, Flip-Flops, Timers, etc). Trainees will build various projects as part of the course. The kit forms an integral part of the course, so full course fees need to be paid at least 7 days prior to course commencement to allow time to ship the kit in time for the course.</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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">* If attending the course from outside of Ireland the course practical training kit must be purchased via our online shop in time for delivery before course commencement. The equipment will then remain the property of the trainee.</strong></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);">In preparation for each course, we have a quick informal free 1 hr online meeting approx. 7 days prior to course commencement, to make sure that trainees get connected through Zoom properly, let them know what the virtual classroom will be like and go through any questions they may have. To join the virtual sessions, you will need a PC/Laptop or Tablet with an internet connection. Joining instructions (login IDs, etc.) will be sent before the Informal Induction session.</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);"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div><div data-node="61657d76a40d2" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Learning Objectives</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This course equips participants with practical &ldquo;Hands-on&rdquo; skills relevant to the workplace and the theory required for certification. Participants can expect to have the skills to:&nbsp;</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Build and fault-finding a range of Digital Electronic circuits used in computers and computer-controlled equipment</li><li fr-original-style="" style="box-sizing: border-box;">Use test equipment including Multimeters, Oscilloscopes, logic probes and pulsers to implement systematic fault-finding techniques.</li><li fr-original-style="" style="box-sizing: border-box;">Study and use of popular Digital Electronic gates and more advanced circuits</li></ul></div></div><div data-node="61657d76a40d7" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Course Content</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Introduction to Electronics: &ndash; Electric Current, OHMS Law, Insulation, Conduction and related Formulae. Resistor colour codes.</li><li fr-original-style="" style="box-sizing: border-box;">Practical study of Digital I.C.s including AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, SR Latches and D-Latches and Flip-Flops.</li><li fr-original-style="" style="box-sizing: border-box;">Oscillators, Multivibrators and 555 Timers. Switches and Switch De-bounce circuits and their applications.</li><li fr-original-style="" style="box-sizing: border-box;">Numbering systems, TTL and CMOS technologies</li><li fr-original-style="" style="box-sizing: border-box;">Counters, Counter Decoding Circuitry, Shift Registers</li><li fr-original-style="" style="box-sizing: border-box;">A-D and D-A converters</li><li fr-original-style="" style="box-sizing: border-box;">Digital Displays: &ndash; LED and LCD, numeric and alphanumeric, operating currents, voltages and power requirements. Display decoders and drivers.</li><li fr-original-style="" style="box-sizing: border-box;">Test Equipment: &ndash; Practical use of Analogue and Digital Multimeters, Oscilloscopes, Logic probes, Logic Pulsers, etc.</li><li fr-original-style="" style="box-sizing: border-box;">Fault-finding techniques: &ndash; Diagnosing and rectifying faults on circuits built during course.</li><li fr-original-style="" style="box-sizing: border-box;">Health &amp; Safety, Care of Tools and instruments for assembly and repair</li></ul></div></div></div></div></div><div data-node="61657d76a40d3" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40d4" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40d5" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40d6" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Certification</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds of London Institute Digital Electronics 2 (Examination No. 7267-425). This examination consists of 1 written paper and 4 practical assignments. The qualification can be used as part of the requirement for <a title="City & Guilds Diploma in IT Systems Support" href="http://hitechtraining.ie/city-guilds-certification/" style="color: rgb(209, 33, 56); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(209, 33, 56);">City &amp; Guilds Diploma in IT Systems Support (7267-24).</a></li><li fr-original-style="" style="box-sizing: border-box;">On completion of the Course, having been successful in an examination, the participant will receive a Hi-Tech Training Certificate.</li></ul></div></div><div data-node="61657d76a40d8" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><img width="794" height="602" src="http://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24.png" alt="Hi Tech - City & Guilds Diploma in IT Systems Support (7267-24)" itemprop="image" srcset="https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24.png 794w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-300x227.png 300w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-768x582.png 768w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-600x455.png 600w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-64x49.png 64w" sizes="(max-width: 794px) 100vw, 794px" title="Hi Tech - City & Guilds Diploma in IT Systems Support (7267-24)" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></div></div></div></div></div></div></div></div></div></div></div></div><div data-node="61658ba442ce7" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61658ba442ce8" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></div>

Hi-Tech Training

City & Guilds

Electronics

Digital Design

Electrical Engineering

Analog Electronics

Computer Engineering

Digital Skills

Online Education

This Digital Electronics Course is designed to give practical knowledge of the type of electronic circuitry used in a modern Computer System or in any type of Computer Controlled equipment such as Photocopiers, Cash Registers, Tablets, mobile phones and many other types of IT equipment. 

Digital Electronics involves the use of Silicon chips (Integrated Circuits). The internal structure of a computer is to a large extent comprised of Digital Electronic Circuits.

Digital Electronics Course Online

Deposit Only

Full Price (including Deposit)

Join us for a fun and interactive online workshop with Rebecca to learn the basics of mindful photography! Event lasts one week.






Agenda
18:00 - 18:30
Opener - before we start we will get to know you a little.
18:30 - 19:15
Session starts - we will explore the basics of Mindful Photograpy together
19:15 - 19:20
Short Break
19:20 - 20:30
Practical exercises, feedback and discussion
20:30 - 20:30
Details on the week long project
About this event
Event lasts 2 hours
Welcome to an exciting online event with an optional guided and fully interactive project to last the whole week!

Special bank holiday code available now email rebecca@mindfulphotography.org.uk and ask for the code !

Introduction to Mindful Photography with Rebecca, founder of Mindful Photography UK.

Join us on Mon Sep 23 2024 at 18:30 GMT for a unique experience that combines mindfulness and photography. We deliberately keep our sessions limited to small numbers so that we all have a chance to talk to each other and have interactive discussion.

In this online session, Rebecca will guide you through the art of capturing moments with intention and awareness. Learn how to slow down, observe your surroundings, and create beautiful images that reflect your thoughts and feelings. No prior experience required, just bring your camera or smartphone and an open mind.

Don't miss this opportunity to explore the world through a new lens!

Sign up now to secure your online spot.

Here is some feedback from a recent session we ran this springtime. I think you will agree these are big changes and we are so proud to be part of them!

I felt the session was really inclusive.
I feel more mindful and in the present moment.
The process is transferable and “you can do it anywhere”.
I feel my wellbeing is supported, and I feel more in control.
I understand myself better, I accept myself.
It supports my creativity and self-expression which I hadn’t always fully acknowledged.
I realise I had a fear of making mistakes, but by being in a group I feel so supported.
I feel more physically active.
I feel more self-aware and have increased my self-knowledge.
I feel more empowered to do things and make changes in my life and in my community.






Frequently asked questions
What is your refund policy?
We can accept cancellations up until 48 hours before we begin. We regret, as we are a small CIC, that we cannot take cancellations via email but ask that you log into Eventbrite to cancel your ticket should it be necessary.
Do I need any special equipment?
No, you need something to take a photograph on, a valid email address and a strong internet connection so that we can communicate over zoom. You would benefit from downloading an app called www.padlet.com to your device but this is not essential. The extension project is entirely optional.
What happens after the week long project is finished?
You will be invited into a community project or if you live in North Yorkshire you might like to book a 1:1 session with me. Personalised sessions start at £49:99 per person.
Do I have to be a photographer?
Absolutely not, we assume no prior experience of photography.
Is this like therapy?
We are not therapists but the process has a gentle and calming effect upon your wellbeing. We will be engaging in simple tasks to encourage mindfulness. We do ask that you are well and happy to engage in a small group session online. We embody respect in our work and we ask that you do the same.
Will you be using my images?
We never share your images unless you specifically ask for us to. Your image and copyright remains your own.
Can I share your lesson content?
We are a community interest company called Mindful Photography UK CIC and all images, wording, content, intellectual property are trademarked and copyrighted by Mindful Photography UK 2024. We ask that you respect our livelihood and do not share our lessons and content.

22001 Courses delivered Online

Fundamentals of Seismic for Non-Geophysicists

By EnergyEdge - Training for a Sustainable Energy Future

Introduction to ADHD in Adults for Educators

By Panda Education and Training Ltd

May 2025 Fundamentals Organisation & Relationship Systems Coaching Training

By CRR UK

Introduction to SQL

By Systems & Network Training

Lean Six Sigma Green Belt Certification Program: Virtual In-House Training

By IIL Europe Ltd

MySQL for developers

By Systems & Network Training

CWISA Wireless IoT Solutions Administrator

By Systems & Network Training

MySQL server administration

By Systems & Network Training

Querying Microsoft SQL Server

By Systems & Network Training

Oracle database administration

By Systems & Network Training