Name: Network +
Price: 2797 GBP
Availability: InStock

Redhill

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

Systems & Network Training

Network & Security

Network Engineer

Querying Microsoft SQL Server

General Admission

<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

<div>
</div>
<section>
<div>
<h2>About this training course</h2>
<p>This 5-day intensive training course is designed to improve the skills of those involved in the financial and contractual auditing of upstream Oil &amp; Gas Exploration and Production activities. The objective of this course is to enhance your understanding of the various audit principles and practices being applied in this industry today and to equip you with the knowledge and tools to deal with complex audit cases. The course concentrates on aspects of auditing unique to the E&amp;P business.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>After the completion of this training course, participants will be able to:</p>
<ul>
<li>Apply a structured methodology for conducting oil industry internal, production sharing and joint venture audits</li>
<li>Implement the benefits of a multi-discipline team audit approach</li>
<li>Adopt a model of best practice for conducting audits</li>
<li>Analyse, interpret and decide complex cases using the contracts and documents, the principles and auditor's judgement</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This training course is suitable and will greatly benefit the following specific groups:</p>
<ul>
<li>Personnel with an Internal audit background who are totally new to the discipline of Joint Venture (JV) or Production Sharing Contract (PSC) audit</li>
<li>Experienced audit practitioners who wish to update their auditing techniques</li>
<li>Personnel from Finance or any discipline who intend to take part in <strong><em>internal or joint venture audits</em></strong></li>
<li>Personnel with a background in statutory audit in the accountancy profession who require an insight into the internal and joint venture audit areas</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Course Level 

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

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><span>The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization.</span></p>
<p><em><span>Course Duration: 5 days in total (35 hours).</span></em></p>
<p><strong><span>Training Schedule</span></strong></p>
<p><span>0830 - Registration </span><span>0900 - Start of training </span><span>1030 - Morning Break </span><span>1045 - Training recommences </span><span>1230 - Lunch Break </span><span>1330 - Training recommences </span><span>1515 - Evening break </span><span>1530 - Training recommences </span><span>1700 - End of Training</span></p>
<p><span>The maximum number of participants allowed for this training course is 25.</span></p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader has more than 30 years of experience in the international oil and gas industry, covering all areas of Finance and Audit, including involvement in Commercial roles. During her 19 years with ENI she worked in Italy, Netherlands, Egypt and UK and was CFO for 2 major ENI subsidiaries. She has delivered training courses in Accounting, Audit, Economics and Commercial topics in many Countries.</p>
<p>She has a Degree in Economics &amp; Accounting and is a Certified Chartered Accountant. She is also a Chartered Auditor and an International Petroleum Negotiator. Outside of work, she is inspired by the beauty of nature and art, helping disadvantaged people, sports (football, golf) and her cat<em>.</em></p>
<p><strong>Courses Delivered Internationally:</strong></p>
<ul>
<li>E&amp;P Accounting, Auditing in the Oil &amp; Gas Industry</li>
<li>Cost Control &amp; Budgeting</li>
<li>Introduction to the Oil &amp; Gas Industry</li>
<li>Petroleum Project Economics</li>
<li>Contracts Strategy</li>
<li>International O&amp;G Exploitation Contracts</li>
</ul>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

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

Accreditions And Affliations

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

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Auditing in the Exploration & Production (E&P) Industry Level 2

Team of 10, pp

Normal Fee, pp

<div>
</div>
<section>
<div>
<h2>About this training course</h2>
<p>The aim of this exclusive 5-days training course is to raise an intermediate level to your knowledge and understanding of international E&amp;P finance and accounting. This is achieved by in-depth examination of international practices and current developments across a broad range of relevant topics. You are encouraged to challenge existing methods as a basis for reviewing procedures and introducing improvements in your own work place.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>After the completion of this training course, participants will be able to:</p>
<ul>
<li>Enhance your comprehension of accounting and reporting issues unique to the E&amp;P industry with emphasis on the application of International Financial Reporting Standards (IFRS)</li>
<li>Improve your understanding of the accounting and reporting of Sales Revenue, Farm In/Farm Out, and Carried Interest</li>
<li>Enhance your knowledge of Production Sharing Contracts and Joint Venture Accounting issues including Unitisation &amp; Redetermination</li>
<li>Advance your knowledge of the Corporate Budget and Planning process including a review of Key Performance Indicators and Company Strategy</li>
<li>Raise your awareness of the E&amp;P business activity for which we are accounting and reporting</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>We recommend that, to derive maximum benefit from this course, you should first attend our predecessor Level 1 course. Otherwise, this course is suitable for <strong><em>personnel with a good foundation knowledge in exploration and production accounting.</em></strong></p>
</div>
</div>
</div>
<div>
<div>

Course Level 

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

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><span>The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization.</span></p>
<p><em><span>Course Duration: 5 days in total (35 hours).</span></em></p>
<p><strong><span>Training Schedule</span></strong></p>
<p><span>0830 - Registration </span><span>0900 - Start of training </span><span>1030 - Morning Break </span><span>1045 - Training recommences </span><span>1230 - Lunch Break </span><span>1330 - Training recommences </span><span>1515 - Evening break </span><span>1530 - Training recommences </span><span>1700 - End of Training</span></p>
<p><span>The maximum number of participants allowed for this training course is 25.</span></p>
<p><span>This course is also available through our Virtual Instructor Led Training (VILT) format.</span></p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader has more than 30 years of experience in the international oil and gas industry, covering all areas of Finance and Audit, including involvement in Commercial roles. During her 19 years with ENI she worked in Italy, Netherlands, Egypt and UK and was CFO for 2 major ENI subsidiaries. She has delivered training courses in Accounting, Audit, Economics and Commercial topics in many Countries.</p>
<p>She has a Degree in Economics &amp; Accounting and is a Certified Chartered Accountant. She is also a Chartered Auditor and an International Petroleum Negotiator. Outside of work, she is inspired by the beauty of nature and art, helping disadvantaged people, sports (football, golf) and her cat<em>.</em></p>
<p><strong>Courses Delivered Internationally:</strong></p>
<ul>
<li>E&amp;P Accounting, Auditing in the Oil &amp; Gas Industry</li>
<li>Cost Control &amp; Budgeting</li>
<li>Introduction to the Oil &amp; Gas Industry</li>
<li>Petroleum Project Economics</li>
<li>Contracts Strategy</li>
<li>International O&amp;G Exploitation Contracts</li>
</ul>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

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

Accreditions And Affliations

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

Exploration & Production (E&P) Accounting Level 2

<div>
</div>
<section>
<div>
<h2>About this training course</h2>
<p>This highly interactive 5-day training is aimed at those who wish to take their E&amp;P accounting skills to a more advanced level than our introductory course, <strong>E&amp;P Accounting - Level 1, </strong>and our intermediate course, <strong>E&amp;P Accounting - Level 2.  </strong>It will help equip you for more demanding analytical roles within your organisation.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>After the completion of this training course, participants will be able to:</p>
<ul>
<li>Carry out and manage the day-to-day financial accounting activities associated with participation in E&amp;P joint ventures</li>
<li>Prepare, analyse and present information for effective financial reporting</li>
<li>Understand the impact of a comprehensive range of activities on the financial statements of an upstream oil and gas company</li>
<li>Practically apply IFRS in accounting for a wide range of typical oil and gas industry activities</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This is an advanced level course designed for:</p>
<ul>
<li>those who have already attended <strong><em>E&amp;P Accounting - Level 1 and E&amp;P Accounting - Level 2</em></strong>, or</li>
<li>those who can demonstrate, by a combination of relevant experience and previous study, sufficient prior knowledge to contribute and benefit from attending this workshop</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Course Level 

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

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><strong>Training Method - Scenario Based Learning</strong></p>
<ul>
<li>Learning centers around highly realistic E&amp;P company scenarios.</li>
<li>A computer-based simulation is used to plan, record and report the progress of your company through several years of international E&amp;P activities.</li>
<li>Teams of 2 - 3 people participate in the financial management of these activities, including Operator and Non-operator accounting, recording of transactions, updating of financial statements and analysis of results.</li>
</ul>
<p><span>The highly interactive <strong><em>laptop-based scenario approach</em></strong> will enable you to follow the impact of each activity from initiation through to final results and analysis of company performance. You will need to bring with you to the course <strong><em>your own laptop PC with MS Excelâ¢ pre-installed.</em></strong>  Prior knowledge of spreadsheet techniques is assumed.  Trainer will provide various Excel files which participants may retain at the end of the course.</span></p>
<p><em><span>Course Duration: 5 days in total (35 hours).</span></em></p>
<p><strong><span>Training Schedule</span></strong></p>
<p><span>0830 - Registration </span><span>0900 - Start of training </span><span>1030 - Morning Break </span><span>1045 - Training recommences </span><span>1230 - Lunch Break </span><span>1330 - Training recommences </span><span>1515 - Evening break </span><span>1530 - Training recommences </span><span>1700 - End of Training</span></p>
<p><span>The maximum number of participants allowed for this training course is 25.</span></p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader has more than 30 years of experience in the international oil and gas industry, covering all areas of Finance and Audit, including involvement in Commercial roles. During her 19 years with ENI she worked in Italy, Netherlands, Egypt and UK and was CFO for 2 major ENI subsidiaries. She has delivered training courses in Accounting, Audit, Economics and Commercial topics in many Countries.</p>
<p>She has a Degree in Economics &amp; Accounting and is a Certified Chartered Accountant. She is also a Chartered Auditor and an International Petroleum Negotiator. Outside of work, she is inspired by the beauty of nature and art, helping disadvantaged people, sports (football, golf) and her cat<em>.</em></p>
<p><strong>Courses Delivered Internationally:</strong></p>
<ul>
<li>E&amp;P Accounting, Auditing in the Oil &amp; Gas Industry</li>
<li>Cost Control &amp; Budgeting</li>
<li>Introduction to the Oil &amp; Gas Industry</li>
<li>Petroleum Project Economics</li>
<li>Contracts Strategy</li>
<li>International O&amp;G Exploitation Contracts</li>
</ul>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

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

Accreditions And Affliations

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

Exploration & Production (E&P) Accounting Level 3

<h3><b>Cloud deployment training course description</b></h3>
      <p>This course covers the important topics every cloud
professional needs, including, configuration and
deployment, security, maintenance, management, and
troubleshooting. It covers all aspects of cloud
computing infrastructure and administration, with a
practical focus on real-world skills. It will help you to
master the fundamental concepts, terminology, and
characteristics of cloud computing. Deploy and
implement cloud solutions, manage the infrastructure,
and monitor performance. You will also be able to
install, configure, and manage virtual machines. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
  <li>Cloud services, models, and characteristics.</li>
<li>Virtualization components, installation, and
configuration.</li>
<li>Infrastructure configurations and optimization.</li>
<li>Resource management and specific allocations.</li>
<li>IT security concepts, tools, and best practices.</li>
<li>Recovery, availability and continuity in the cloud.</li>
                  </ul>
        <h5>
        <b>Cloud deployment training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>IT professionals looking to deploy and implement cloud
solutions, manage the infrastructure, and monitor
performance, Install, configure, and manage virtual
machines.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Introduction to virtualization.</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Cloud deployment training course contents</b></h3>
      
				Preparing to Deploy Cloud Solutions<br />
Deploying a Pilot Project<br />
Testing Pilot Project Deployments<br />
Designing a Secure and Compliant Cloud Infrastructure<br />
Designing and Implementing a Secure
Cloud Environment<br />
Planning Identity and Access Management for Cloud
Deployments<br />
Determining CPU and Memory Sizing for Cloud
Deployments<br />
Determining Storage Requirements for Cloud
Deployments<br />
Analysing Workload Characteristics to Ensure
Successful Migration<br />
Maintaining Cloud Systems<br />
Implementing Backup, Restore, Disaster Recovery, and
Business Continuity Measures<br />
Analysing Cloud Systems for Performance<br />
Analysing Cloud Systems for Anomalies and Growth
Forecasting<br />
Troubleshooting Deployment, Capacity, Automation, and
Orchestration Issues<br />
Troubleshooting Connectivity Issues<br />
Troubleshooting Security Issues<br />

Cloud deployment

Yorkshire Hypnotherapy Training

Hypnotherapy

Accredited Hypnotherapy

accredited hypnotherapy training in person and online, expert tuition, free online taster course, contact us now for further details

IN-PERSON HYPNOTHERAPY TRAINING

current as at 2023, please check website for up to date prices

Practitioner training in person

Practitioner training online

<h3><b>Linux training course description</b></h3>
      <p>   A Linux foundation appropriate for all flavours of Linux,
focussed on getting network engineers up and running
with Linux. The command line is used throughout. The
course progresses from the basics of Linux commands
onto useful tools such as grep, then shell features such
as piping and then onto shell scripting. Administration
aspects covered are the tasks network engineers are
most likely to encounter such as software installation.
Hands on exercises concentrate on network related
tasks such as installing net-snmp and using shell
scripts to provide network automation.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
   <li>Use Linux commands to perform a variety of tasks
from manipulating files to handling processes.</li>
																				<li>Create and edit files with vi.</li>
																				<li>Work with permissions.</li>
																				<li>Write simple shell scripts.</li>
																				<li>Install software packages.</li>
                    <li>Configure base networking.</li>
                  </ul>
        <h5>
        <b>Linux training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Network engineers.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>TCP/IP Foundation</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Linux training course contents</b></h3>
      <ul>
				<li>What is Linux? </li><p>
Linux distributions, open source software.
</p><li>Getting started </li><p>
Logging in, changing passwords, logging out.
<br /><span>Hands on</span> Basics and root access.

</p><li>Linux basics </li><p>
Command structure. The Linux manuals, basic commands (who, date, tty, uname, echo, banner...).
<br /><span>Hands on</span> Using the CLI.

</p><li>Connecting to a network </li><p>
IP configuration, DHCP, static addressing, routing, ifconfig, ping, netstat, traceroute, dig.
<br /><span>Hands on</span> Network configuration and testing.

</p><li>Managing Software </li><p>
Package Concepts, Comparison of package formats, RPM, rpm Commands, Yum, Debian Packages, dpkg, apt-cache, apt-get, dselect, aptitude, Converting Between Package Formats, Dependencies and Conflicts, Startup Script Problems, Shared Libraries, Library Management
<br /><span>Hands on</span> Installing network packages such as nmap and net-snmp.

</p><li>Processes and log files </li><p>
ps, kill, background processes, at, exec, priorities. Managing Linux log files. Syslogd. Setting the time. Cron and cronjobs. Managing Processes, the Kernel: The First Process.
<br /><span>Hands on</span> Controlling daemons and services. Setting up a TFTP server.

</p><li>Filesystem commands </li><p>
Home directories, manipulating files and directories, Filesystem layout, Pathnames, hard and symbolic links. Viewing files.
<br /><span>Hands on</span> Exploring the filesystem, working with network device configuration files.

</p><li>The Linux editors </li><p>
ed, vi, shell escapes, .exrc.
<br /><span>Hands on</span> Editing network device configuration files.

</p><li>Extracting data from files </li><p>
grep, find, cut, sort and pasteâ¦
<br /><span>Hands on</span> Working with syslog files.

</p><li>Permissions </li><p>
Theory, chmod, chown, newgrp.
<br /><span>Hands on</span> Handling permission problems.

</p><li>The shell </li><p>
Metacharacters, piping and redirection.
<br /><span>Hands on</span> Running SNMP commands and working with their output.

</p><li>Basic shell scripting </li><p>
What are shell scripts? Simple scripts, control structures. Variable. Setting variables, using variables, set, scope, export, sourcing, environmental variables, read. Positional parameters: $0 to $9, $#, $* and others. shift parameter substitution. Control statements: The test command, if , while loops, for loops, the case statement.
<br /><span>Hands on</span> Automating network tasks.

</p><li>Customising your environment </li><p>
Environmental variables, stty, .profile and other startup files.
<br /><span>Hands on</span> Customising Linux.

</p><li>Introduction to administration </li><p>
The root user, su. Managing users and groups.
<br /><span>Hands on</span> The power of root.

</p><li>Archiving files </li><p>
Backups, tar, cpio, dd, gzip.
<br /><span>Hands on</span> Working with tar files.

</p><li>Booting Linux and Editing Files  </li><p>
Installing Boot Loaders, GRUB Legacy, GRUB 2, Alternative Boot Loaders, the Boot Process, Boot Messages, Runlevels and the Initialization Process, Runlevel Functions, Runlevel Services, Alternative Boot Systems , Upstart, system.
<br /><span>Hands on</span> Installing network services on Linux.</p>
      </ul>

Linux for network engineers

<h3><b>CCNA training course description</b></h3>
        <p>The Implementing and Administering Cisco
Solutions (CCNA) course gives you a broad range of
fundamental knowledge for all IT careers. Through a
combination of lecture, hands-on labs, and self-study,
you will learn how to install, operate, configure, and
verify basic IPv4 and IPv6 networks. The course covers
configuring network components such as switches,
routers, and wireless LAN controllers; managing
network devices; and identifying basic security threats.
It also gives a foundation in network programmability,
and software-defined networking</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
     <li>Install, configure, and operate a small to medium
sized network</li>
<li> Gain a foundation in the essentials of networking,
security, and automation</li>
<li> Prepare for the 200-301 CCNA exam, which
earns CCNA certification</li>
 
                  </ul>
        <h5>
        <b>CCNA training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>
    Network support help desk technicians involved in the
basic installation, operation, and verification of Cisco
networks. Anyone seeking CCNA certification.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Introduction to Data communications &amp; networking</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
			
				 <h3><b>CCNA training course content</b></h3>
				
      <ul>
				<li>After taking this course, you should be able to:</li><p>
Identify the components of a computer network and
describe their basic characteristics.<br />
Understand the model of host-to-host communication.<br />
Describe the Cisco IOS software.<br />
Describe LANs and the role of switches within LANs.<br />
Describe Ethernet and describe the operation of switches.<br />
Install a switch and perform the initial configuration.<br />
Describe the TCP/IP Internet layer, IPv4, its addressing
scheme, and subnetting.<br />
Describe the TCP/IP Transport and Application layers
Explore functions of routing.<br />
Implement basic configuration on a Cisco router.<br />
Explain host-to-host comms across switches and routers.<br />
Identify and resolve common switched network issues
and common problems associated with IPv4 addressing.<br />
Describe IPv6 main features and addresses, and
configure and verify basic IPv6 connectivity.<br />
Describe static routing.<br />
Describe, implement, and verify VLANs and trunks.<br />
Describe inter VLAN routing.<br />
Explain the basics of dynamic routing protocols and
describe components and terms of OSPF.<br />
Explain how STP and RSTP work.<br />
Configure link aggregation using EtherChannel.<br />
Describe the purpose of Layer 3 redundancy protocols.<br />
Describe basic WAN and VPN concepts.<br />
Describe the operation of access control lists (ACLs) and
their applications in the network.<br />
Configure Internet access using DHCP clients and
explain and configure NAT on Cisco routers.<br />
		  Describe
basic QoS concepts.<br />
Describe the concepts of wireless networks, which types
of wireless networks can be built, and how to use
Wireless LAN Controllers (WLCs).<br />
Describe network and device architectures, introduce
virtualization, network programmability and SDN and
describe smart network management solutions such as
Cisco DNA Centerâ¢, SD-Access, and SD-WAN.<br />
Configure basic IOS system monitoring tools.<br />
Describe the management of Cisco devices.<br />
Describe the current security threat landscape.<br />
Describe threat defence technologies.<br />
		  Implement a basic
security configuration of the device management plane.<br />
Implement basic steps to harden network devices. 

</p><li>Detailed course outline</li><p>
Exploring the Functions of Networking.<br />
The Host-to-Host Communications Model.<br />
Operating Cisco IOS Software.<br />
Introducing LANs.<br />
Exploring the TCP/IP Link Layer.<br />
Starting a Switch.<br />
The TCP/IP IP layer, IPv4 Addressing, and Subnets.<br />
The TCP/IP Transport Layer and Application Layer.<br />
Exploring the Functions of Routing.<br />
Configuring a Cisco Router.<br />
Exploring the Packet Delivery Process.<br />
Troubleshooting a Simple Network.<br />
Introducing Basic IPv6.<br />
Configuring Static Routing.<br />
Implementing VLANs and Trunks.<br />
Routing Between VLANs.<br />
Introducing OSPF.<br />
Redundant Switched Topologies with EtherChannel.<br />
Explaining Basics of ACL.<br />
Enabling Internet Connectivity.<br />
Explaining the Evolution of Intelligent Networks.<br />
Introducing System Monitoring.<br />
Managing Cisco Devices.<br />
Securing Administrative Access.<br />
Implementing Device Hardening.


</p><li>Self-Study: </li><p>
Building Redundant Switched Topologies.<br />
Exploring Layer 3 Redundancy.<br />
Introducing WAN Technologies.<br />
Introducing QoS.<br />
Explaining Wireless Fundamentals.<br />
Introducing Architectures and Virtualization.<br />
Examining the Security Threat Landscape.<br />
Threat Defense Technologies. 
</p>
      </ul>

CCNA

<h3><b>Network+ training course description</b></h3>
        <p>This network+ course covers the TCP/IP side of the
exam. For delegates to pass the exam it is important
that they meet the prerequisites, self study is also
required. An intensive hands on IP foundation. The
course focuses on all parts of TCP/IP including layers 4
to 7 on end stations as well as layer 3 on routers. The
TCP/IP protocols are also studied to enable delegates
to be able to troubleshoot TCP/IP using Wireshark.
Hands on sessions are used to reinforce the theory
rather than teach specific manufacturer equipment.
 </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
        <li>Use ping, traceroute and other tools to diagnose
          faults on a network.</li>
        <li>Configure IP on PCs and routers.</li>
        <li>Plan IP addresses and subnets.</li>
        <li>Analyse IP and TCP packets using an analyser.</li>
        <li>Troubleshoot TCP/IP.</li>
        </ul>
        <h5>
        <b>Network+ training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Those wishing to pass the Network+ exam.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Introduction to data communications &amp; networking</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Network+ training course contents</b></h3>
      <ul>
        <li>What is TCP/IP?</li>
        <p> TCP and IP are protocols, 7 layer model, network
          layers, hardware/software layers, internetworking,
          protocols, What is IP? What is TCP? The internet,
          The IAB, RFCs.</p>
        <li> Ping and Wireshark</li>
        <p> Host configuration, IP addresses, subnet masks,
          default gateways, ping. <br />
          <span>Hands on </span>Base configuration. Testing
          with ping. Analysing packets with Wireshark. </p>
        <li>Switches and Wireshark</li>
        <p> Switches versus hubs, layer 2 forwarding table,
          flooding, broadcasts.<br />
          <span>Hands on</span> Building a
          switched based network. </p>
        <li>Configuring network devices</li>
        <p> Configuration options, console port, putty, telnet. <br />
          <span>Hands on</span> Configuring switches, telnet. </p>
        <li>IP</li>
        <p> IP packet format, protocol field, TTL, DiffServ,
          fragments, ICMP. <br />
          <span>Hands on</span> IP packet analysis. </p>
        <li>IP addressing</li>
        <p> 32 bits, dotted decimal, rules, networks, role of
          subnet masks, simple subnetting, prefix notation.
          Broadcasts, special use addresses. <br />
          <span>Hands on</span> Planning and implementing addressing. </p>
        <li>IP and the lower layers</li>
        <p> ARP, media not supporting ARP. <br />
          <span>Hands on</span> ARP. </p>
        <li>Routing</li>
        <p> What are routers? What routers do, default
          gateways, routing and addressing, routing tables,
          ways to update routing tables. <br />
          <span>Hands on</span> Building
          a routed network, traceroute. </p>
        <li>Routing protocols</li>
        <p> IGPs and EGPs, RIP, RIPv2, Why not to use RIP,
          OSPF, OSPF metrics, convergence, distance
          vector protocols, link state protocols. <br />
          <span>Hands on</span> OSPF, analysing routing tables, loopbacks. </p>
        <li>Network simulators</li>
        <p> Network simulators, EVE-NG, GNS3, CML. <br />
          <span>Hands on</span> Using EVE-NG. </p>
        <li>Subnetting</li>
        <p> Subnetting to the bit level, ranges, how prefixes
          are used. <br />
          <span>Hands on</span> Subnetting. </p>
        <li>VLANS and IP addressing</li>
        <p> What are VLANs, tagging, 802.1Q, Inter VLAN
          routing. <br />
          <span>Hands on</span> Inter VLAN routing. </p>
        <li>TCP and UDP</li>
        <p> Layer 4, port numbers, client ports, broadcasts
          multicasts and layer 4, UDP header, TCP header,
          connections, ACK, sliding windows, options,
          connection states. Sockets. <br />
          <span>Hands on</span> Analysing
          TCP packets. </p>
        <li>IPv4 address configuration</li>
        <p> Private addresses, NAT, NAPT, dynamic
          addressing, DHCP, link local addresses. <br />
          <span>Hands on</span> DHCP, NAT. </p>
        <li>IPv6</li>
        <p> What is IPv6, 128 bit addresses, address formats,
          IPv6 address allocation, header format, migration,
          dual stack, tunnelling, NAT64, DNS64. <br />
          <span>Hands on</span> IPv6 setup troubleshooting. </p>
        <li>IPv6 address configuration</li>
        <p> Static addressing, EUI-64 addresses, IPv6
          address order, SLAAC, DHCPv6. <br />
          <span>Hands on</span> SLAAC. </p>
        <li>Applications</li>
        <p> Clients, servers, HTTP, Email, resource sharing,
          VoIP, video, terminal emulation, remote desktop.
          Network management and SNMP.<br />
          <span>Hands on</span> Servers, TFTP, VoIP packet analysis. </p>
        <li>DNS</li>
        <p> Names and addresses, hosts file, how DNS
          works. FQDNs, DNS client configuration. <br />
          <span>Hands on</span> Troubleshooting DNS. </p>
        <li>Security</li>
        <p> Firewalls, firewall architectures, DMZ, how
          firewalls work, proxy servers, filtering, ACLs, IDS,
          VPNs, authentication, encryption, tunnels, secure
          protocols. <br />
          <span>Hands on</span> Firewalls, SSH </p>
        <li>Troubleshooting</li>
        <p> Methods, tools. Using the 7 layer model.
          Troubleshooting toolkits. <br />
          <span>Hands on</span> Fixing the
          network. </p>
      </ul>

Network +

Brighton

Southend on Sea

Rotherham

Manchester

Slough

Portsmouth

Bingley

Nottingham

Paisley

Birmingham

Luton

Northampton

Bedford

Liverpool 

Swansea

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)



Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

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.

Mindful Photography UK

Online Course Marketing

Mindfulness

Photography

Mindfulness Teacher

Teaching Online

One week - Online introduction to Mindful Photography with Rebecca

<h2 fr-original-style="" style="box-sizing: border-box;">How to safely use an AED</h2><h2 fr-original-style="" style="box-sizing: border-box;"><strong id="isPasted" style="color: rgb(34, 177, 77); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(34, 177, 77);">CPD Accredited, Interactive&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Short Course (via Zoom)</strong></strong></h2><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17ad38f5675" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-17ad38f55f3" fr-original-style="" style="box-sizing: border-box;"><span data-css="tve-u-17ad38f55e5" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34) !important;">1&frac12; hr course</span></li></ul></div><div data-css="tve-u-17ad38f5676" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-17ad38f55f3" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17ad38f55ef" fr-original-style="" style="box-sizing: border-box;"><span data-css="tve-u-17ad38f55e5" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34) !important;">Learn how to use an AED safely</span></div></li><li data-css="tve-u-17ad38f55f3" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17ad38f55ef" fr-original-style="" style="box-sizing: border-box;"><span data-css="tve-u-17ad38f55e5" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34) !important;">AED: Automated External Defibrillator</span></div></li></ul></div><div data-css="tve-u-17ad38f5677" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-17ad38f55f3" fr-original-style="" style="box-sizing: border-box;"><span data-css="tve-u-17ad38f55e5" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34) !important;">Learn from the comfort of your own home, great for CPD</span></li></ul></div></li></ul><h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Contents</h2><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">The Chain of Survival</span></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-17ad3a1fcf4" fr-original-style="" style="box-sizing: border-box;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">How to give CPR</span></div></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-17ad3a1fcf4" fr-original-style="" style="box-sizing: border-box;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">DR ABC</span></div></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-17ad3a1fcf4" fr-original-style="" style="box-sizing: border-box;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">Introduction to an AED</span></span></div></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-17ad3a1fcf4" fr-original-style="" style="box-sizing: border-box;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">Aspects of an AED</span></span></span></div></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-17ad38f5679" fr-original-style="" style="box-sizing: border-box;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">Safety aspects of using an AED</span></div></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-17ad38f5679" fr-original-style="" style="box-sizing: border-box;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">How to use an AED on an adult, child and infant/baby</span></div></li></ul><div data-css="tve-u-17ad38f5679" fr-original-style="" style="box-sizing: border-box;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;"></span></span><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">Please note: this course is aimed as a reminder of how to provide first aid, not a first time training session. Giving CPD especially needs to be taught in person, with lots of chances to practice</span><br fr-original-style="" style="box-sizing: border-box;"></span></div><h2 fr-original-style="" style="box-sizing: border-box;">Benefits of this Short Course</h2><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">There are over 30,000 out-of-hospital cardiac arrests a year</span></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-17ad38f5658" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">But just 1 out of 10 survive</span></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-17ad38f5658" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">Improved help by the public, and access to defibrillators (AEDs) gives a higher chance of survival<br fr-original-style="" style="box-sizing: border-box;"></span></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-17ad39cb6c6" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">Learn how to use an AED and (potentially) save someone&#39;s life when it matters most<br fr-original-style="" style="box-sizing: border-box;"></span></li><li data-css="tve-u-171a6872fd5" style="color: var(--tve-color,rgb(34,34,34)) !important; box-sizing: border-box;" fr-original-style=" color: var(--tve-color,rgb(34,34,34)) !important;"><div data-css="tve-u-17ad39d06a7" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17ad38f561f" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">This could be a friend or even a loved one...</span></li></ul><h2 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2>

Pochat Training

Automated External Defibrillation (AED)

Defibrillator

How to Use an AED

<h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(55, 55, 55);">Audience</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Prerequisites</h3><div style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You should have practical experience with Db2 for z/OS</p></div><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Duration</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">2 days.&nbsp;</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Objectives</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Content</h3><ul style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><li fr-original-style="" style="box-sizing: border-box;">Unit 1: Db2 v12 Function Levels: Selected Highlights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 2: Migrating to Db2 13</li><li fr-original-style="" style="box-sizing: border-box;">Unit 3: Availability &amp; Scalability</li><li fr-original-style="" style="box-sizing: border-box;">Unit 4: Performance</li><li fr-original-style="" style="box-sizing: border-box;">Unit 5: Application Management and SQL Changes</li><li fr-original-style="" style="box-sizing: border-box;">Unit 6: SQL Data Insights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 7: Security</li><li fr-original-style="" style="box-sizing: border-box;">Unit 8: IBM Db2 Utilities</li><li fr-original-style="" style="box-sizing: border-box;">Unit 9: Instrumentation and Serviceability</li></ul>

Verhoef Training Ltd.

New Db2 13 Functions and Features - CV321G

Early bird

Book your place early to get an extra discount!

22527 Courses

Querying Microsoft SQL Server

By Systems & Network Training

Oracle database administration

By Systems & Network Training

Auditing in the Exploration & Production (E&P) Industry Level 2

By EnergyEdge - Training for a Sustainable Energy Future

Exploration & Production (E&P) Accounting Level 2

By EnergyEdge - Training for a Sustainable Energy Future

Exploration & Production (E&P) Accounting Level 3

By EnergyEdge - Training for a Sustainable Energy Future

Cloud deployment

By Systems & Network Training

IN-PERSON HYPNOTHERAPY TRAINING

By Yorkshire Hypnotherapy Training

Linux for network engineers

By Systems & Network Training

CCNA

By Systems & Network Training

Network +

By Systems & Network Training

Search By Location