Name: Supporting Windows 10
Price: 3697 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

<p>Ever wondered how a simple scent can transport you to a place of calm, relaxation, and balance? Imagine unlocking the secrets of aromas, harnessing their therapeutic potential, and creating a haven of well-being for yourself and others. Welcome to our Aromatherapy Basics Course, where the magic of fragrances meets the science of well-being!<br /></p><p>Begin with a captivating exploration of the history and principles underlying this ancient practice, gaining insight into the art of harnessing nature's aromatic treasures.Dive into the intricacies of essential oils, unravelling their unique therapeutic qualities and learning how to blend them seamlessly. </p><p>Uncover the diverse techniques and applications that make Aromatherapy a versatile tool for enhancing both emotional and physical well-being. From crafting common blends to creating your personalised aromatic formulations, acquire the skills to tailor scents to individual preferences and needs.</p><p>As you progress, dive into the profound impact of aromas on emotional equilibrium, discovering how these natural elixirs can be harnessed to promote emotional resilience and tranquillity.Safety and ethics take centre stage, ensuring your journey through Aromatherapy is guided by responsible practices. Tailor your expertise to special populations and discover the nuances of introducing aromatics to diverse individuals. Culminate your learning with an exploration into the business and marketing facets of Aromatherapy, equipping you to share your aromatic expertise with the world.</p><p>This course transcends the ordinary, offering a holistic understanding of Aromatherapy that goes beyond the surface. Unleash the potential of nature's fragrant wonders.</p><p><strong>Key Features</strong></p><ul><li>CPD Accredited </li><li>FREE PDF + Hardcopy certificate</li><li>Fully online, interactive course </li><li>Self-paced learning and laptop, tablet and smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>Course Curriculum </strong></p><ul><li>Module 1: Introduction to Aromatherapy</li><li>Module 2: Essential Oils and Their Properties</li><li>Module 3: Aromatherapy Techniques and Applications</li><li>Module 4: Common Aromatherapy Blends and Recipes</li><li>Module 5: Blending Techniques and Custom Formulations</li><li>Module 6: Emotional Well-being and Aromatherapy</li><li>Module 7: Physical Well-being and Aromatherapy</li><li>Module 8: Safety and Ethical Practices in Aromatherapy</li><li>Module 9: Aromatherapy for Special Populations</li><li>Module 10: Business and Marketing in Aromatherapy</li></ul><p><strong>Learning Outcomes:</strong></p><ul><li>Explore essential oil properties for holistic well-being.</li><li>Master diverse aromatherapy techniques for varied applications.</li><li>Develop personalised blends catering to unique needs.</li><li>Apply aromatherapy ethically and with safety in mind.</li><li>Address emotional and physical concerns through aromatherapy.</li><li>Navigate business and marketing strategies within the aromatherapy field.</li></ul><p><strong>Accreditation</strong></p><p>This course is <strong>CPD Quality Standards</strong> (<strong>CPD QS)</strong> accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.</p><p><strong>Certificate</strong></p><p>After completing this course, you will get a FREE Digital Certificate from Training Express.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <ul><li>Wellness enthusiasts seeking holistic approaches.</li><li>Individuals aspiring to enhance their therapeutic skills.</li><li>Health practitioners interested in complementary therapies.</li><li>Entrepreneurs looking to venture into aromatherapy products.</li><li>Care professionals aiming to expand their toolkit.</li><li>Those curious about the intersection of wellness and business.</li><li>Parents exploring natural remedies for family well-being.</li><li>Holistic health advocates keen on ethical practices.</li></ul>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Aromatherapist</li><li>Wellness Consultant</li><li>Essential Oil Retailer</li><li>Spa and Wellness Centre Manager</li><li>Holistic Health Practitioner</li><li>Product Development Specialist</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p>Once you've successfully completed your course, you will immediately be sent a FREE digital certificate.</p></div>
        <h4>Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK).<br />For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only <strong>£10</strong>.<br />Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.</p></div>

                        </div>

Training Express

Introduction to Aromatherapy Course

<h3><b>Windows PowerShell training course description</b></h3>
      <p>This course is intended for IT Professionals who are
already experienced in general Windows Server and
Windows Client administration, and who want to learn
more about using Windows PowerShell for
administration. No prior experience with any version of
Windows PowerShell, or any scripting language, is
assumed. This course is also suitable for IT
Professionals already experienced in server
administration, including Exchange Server, SharePoint
Server, SQL Server, System Center, and others.  </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	 <li>Work with Windows PowerShell pipeline.</li>
                   				 <li>Query system information by using WMI and CIM.</li>
																								<li>Work with variables, arrays, and hash tables.</li>
                        <li>Write advanced scripts in Windows PowerShell.</li>
                   				 <li>Administer remote computers.</li>
																								<li>Use advanced Windows PowerShell techniques.</li>
                  </ul>
                
        <h5><b>Windows PowerShell training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>IT professionals.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Supporting Windows Server
                    </p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Windows PowerShell training course contents</b></h3>
      <ul>
				<li>Getting started with Windows PowerShell </li><p>
Overview and background of Windows PowerShell, Understanding command syntax, Finding commands.
<br /><span>Hands on</span> Configuring Windows PowerShell console &amp; ISE application.
<br /><span>Hands on</span> Finding and running basic commands, Using the About files.

</p><li>Cmdlets for administration </li><p>
Active Directory administration cmdlets, Network configuration cmdlets, Other server administration cmdlets.
<br /><span>Hands on</span> Windows Administration. Creating and managing Active Directory objects, Configuring network settings on Windows Server, Creating a web site.

</p><li>Working with the Windows PowerShell pipeline </li><p>
Understanding the pipeline, Selecting, sorting, and measuring objects, Filtering objects out of the pipeline, enumerating objects in the pipeline, Sending pipeline data as output.
<br /><span>Hands on</span> Using the pipeline. Selecting, sorting, and displaying data.
<br /><span>Hands on</span> Filtering objects. <br /><span>Hands on</span> Enumerating objects. <br /><span>Hands on</span> Sending output to a file. Exporting user information to a file.

</p><li>Understanding how the pipeline works </li><p>
Passing the pipeline data, Advanced considerations for pipeline data.
<br /><span>Hands on</span> Working with pipeline parameter binding. Predicting pipeline behaviour.

</p><li>Using PSProviders and PSDrives </li><p>
Using PSProviders, Using PSDrives.
<br /><span>Hands on</span> Using PSProviders and PSDrives Creating files and folders on a remote computer, Creating a registry key for your future scripts, Create a new Active Directory group.

</p><li>Querying system information by using WMI and CIM </li><p>
Understanding WMI and CIM, Querying data by using WMI and CIM, Making changes with WMI/CIM.
<br /><span>Hands on</span> Working with WMI and CIM. Querying information by using WMI, Querying information by using CIM, Invoking methods.

</p><li>Working with variables, arrays, and hash tables </li><p>
Manipulating variables, arrays and hash tables.
<br /><span>Hands on</span> Working with variables, Using arrays, Using hash tables.

</p><li>Basic scripting </li><p>
Introduction to scripting, Scripting constructs, Importing data from files.
<br /><span>Hands on</span> Basic scripting. Setting a script, Processing an array with a ForEach loop, Processing items by using If statements, Creating a random password, Creating users based on a CSV file.

</p><li>Advanced scripting </li><p>
Accepting user input, Overview of script documentation, Troubleshooting and error handling, Functions and modules.
<br /><span>Hands on</span> Accepting data from users. Querying disk information from remote computers, Updating the script to use alternate credentials, Documenting a script.
<br /><span>Hands on</span> Implementing functions and modules. Creating a logging function, Adding error handling to a script, Converting a function to a module.

</p><li>Administering Remote Computers </li><p>
Using basic Windows PowerShell remoting, Using advanced Windows PowerShell remoting techniques, Using PSSessions.
<br /><span>Hands on</span> Using basic remoting. Enabling remoting on the local computer, Performing one-to-one remoting, Performing one-to-many remoting.
<br /><span>Hands on</span> Using PSSessions. Using implicit remoting, Managing multiple computers.

</p><li>Using background jobs and scheduled jobs </li><p>
Using background jobs, Using scheduled jobs.
<br /><span>Hands on</span> Using background jobs and scheduled jobs. Starting and managing jobs, Creating a scheduled job.

</p><li>Using advanced Windows PowerShell techniques </li><p>
Creating profile scripts, Using advanced techniques.
<br /><span>Hands on</span> Practicing advanced techniques. Creating a profile script, Verifying the validity of an IP address, Reporting disk information, Configuring NTFS permissions, Creating user accounts with passwords from a CSV file.
<br /><span>Hands on</span> Practicing script development (optional)
</p>
      </ul>

Using Windows PowerShell

At the end of this course, candidates will have an understanding of what a risk assessment is and how to complete one. To achieve this the course will define important terms, provide some basic background information to explain how important risk assessments are and discuss some of the legislation that applies. It will then go on to provide practical advice on how to identify hazards and analyse risk before finishing off by explaining the responsibilities of both employers and employees with regards to risk assessment.

TNA Training & Safety Consultants

Introduction to Risk Assessment

This course will start by covering some of the key terms you will need to understand before moving on to identifying critical control points and analysing some of the key hazards. It'll show you how to determine control points and how to avoid cross-contamination in the food chain. It will also cover some of the control measures that can be taken along with how to address a problem if a critical limit is breached.

Introduction to HACCP Level 2

<div id="msbmAccordion">
<div>
<div id="headingOne">
<h2>

</h2>
</div>
<div id="collapseOne">
<div>
The Professional Certificate Course in Introduction to Hotel Marketing covers the importance of hotel marketing in business, market segmentation, product development, strategic pricing, product promotion, distribution channels, and online marketing. The course provides a comprehensive overview of the fundamental concepts and skills required for effective hotel marketing, enabling students to develop and implement successful marketing strategies.<br /><br />
</div>
</div>
</div>
<div>
<div id="headingOne_B">
<h2>

</h2>
</div>
<div id="collapseOne_B">
<div>
<p>The Professional Certificate Course in Introduction to Hotel Marketing provides comprehensive knowledge and skills in hotel marketing. The course covers topics such as market segmentation, product development, strategic pricing, distribution channels, and online marketing.<br /><br />After the successful completion of the course, you will be able to learn about the following,<br /><br /></p>
<ul>
<li>What is Hotel Marketing?</li>
<li>Importance of Marketing in Business.</li>
<li>What is Market Segmentation.</li>
<li>Benefits of Market Segmentation.</li>
<li>Types of Market Segmentation.</li>
<li>Product Development for effective sales.</li>
<li>What should be the strategic Product Pricing.</li>
<li>Locating the Product and its importance.</li>
<li>Product Promotion, its way and role in Hotel Marketing.</li>
<li>Channel of Distribution in the Hotel Industry</li>
<li>Online Marketing.</li>
</ul>
<p> </p>
</div>
</div>
</div>
<div> <div id="headingTwo"> <h2>  </h2> </div> <div id="collapseTwo"> <div> <div> <div> <div> <div> <div id="msbmAccordion"> <div> <div> <div> <div> <div id="headingOne1"> <h2>  </h2> </div> <div id="collapse1966"> <div> <p>The Professional Certificate Course in Introduction to Hotel Marketing covers the importance of hotel marketing in business, market segmentation, product development, strategic pricing, product promotion, distribution channels, and online marketing. The course provides a comprehensive overview of the fundamental concepts and skills required for effective hotel marketing, enabling students to develop and implement successful marketing strategies.</p> <ul> <li> <div> <div> <i></i> </div> <div> <h5>VIDEO - Course Structure and Assessment Guidelines</h5> <p>Watch this video to gain further insight.</p> </div> </div> </li> <li> <div> <div> <i></i> </div> <div> <h5>Navigating the MSBM Study Portal</h5> <p>Watch this video to gain further insight.</p> </div> </div> </li> <li> <div> <div> <i></i> </div> <div> <h5>Interacting with Lectures/Learning Components</h5> <p>Watch this video to gain further insight.</p> </div> </div> </li> <li> <div> <div> <i></i> </div> <div> <h5>Introduction to Hotel Marketing</h5> <p>Self-paced pre-recorded learning content on this topic.</p> </div> </div> </li> <li> <div> <div> <i></i> </div> <div> <h5>Introduction to Hotel Marketing</h5> <p>Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. </p> </div> </div> </li> </ul> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div>
<div>
<div id="headingThree">
<h2>

</h2>
</div>
<div id="collapseThree">
<div>
All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details.
</div>
</div>
</div>
<div>
<div id="headingFive">
<h2>

</h2>
</div>
<div id="collapseFive">
<div>
There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course.<br />
<p>The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience.<br /><br /></p>
<ul>
<li>Hotel Marketing Professionals</li>
<li>Hospitality Industry Professionals</li>
<li>Individuals interested in the Hospitality Industry</li>
</ul>
</div>
</div>
</div>
</div><div>
<div>

<div>
<h5>Average Completion Time</h5>
<p>2 Weeks</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>Accreditation</h5>
<p>3 CPD Hours</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>Level</h5>
<p>Advanced</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>Start Time</h5>
<p>Anytime</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>100% Online</h5>
<p>Study online with ease.</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>Unlimited Access</h5>
<p>24/7 unlimited access with pre-recorded lectures.</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>Low Fees</h5>
<p>Our fees are low and easy to pay online.</p>
</div>
</div>
</div>

Metropolitan School of Business & Management UK

Online Course Marketing

Marketing Management

Hospitality Management

Hotel Management

Hospitality & Tourism

Business & Marketing

Professional Certificate Course in Introduction to Hotel Marketing in London 2024

<p>Fun fact about Actuarial Science: Actuaries are often referred to as "financial doctors" because they specialise in assessing and managing financial risks, much like medical doctors diagnose and treat health risks.Our Introduction to Actuarial Science course is your doorway to a thrilling journey into the heart of financial risk analysis. Dive into the fascinating realm of numbers, probabilities, and financial security as you learn the art of predicting and managing uncertainties. With this course, you'll gain a deep understanding of the financial landscape, enabling you to make informed decisions and secure your financial future. Whether you dream of a career in finance, insurance, or risk management, this course will empower you with the knowledge and skills to excel in your chosen field.</p><p><strong>Key Features</strong></p><ul><li>CPD Accredited</li><li>FREE PDF + Hardcopy certificate</li><li>Fully online, interactive course</li><li>Self-paced learning and laptop, tablet and smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>Course Curriculum </strong></p><ul><li>Module 01 : Introduction to Actuary</li><li>Module 02 : Actuaries and Their Environment</li><li>Module 03 : The Valuation of Cash Flows</li><li>Module 04 : The Basic Deterministic Model</li><li>Module 05 : The Life Table</li><li>Module 06 : Life Annuities</li><li>Module 07 : Life Insurance</li><li>Module 08 : The Stochastic Life Contingencies Model</li><li>Module 09 : The Stochastic Approach to Insurance and Annuities</li><li>Module 10 : Taxation and Inflation</li><li>Module 11 : Probabilistic Models, Uncertain Payment and Profit Testing</li><li>Module 12 : Individual Risk Models</li><li>Module 13 : Principles of Premium Calculation</li><li>Module 14 : Multiple Decrement Theory</li></ul><p><strong>Learning Outcomes:</strong></p><ul><li>Analyse and predict financial risks with confidence.</li><li>Master the valuation of cash flows and basic deterministic models.</li><li>Understand the intricate world of life tables and annuities.</li><li>Explore the complexities of life insurance and stochastic life contingencies.</li><li>Navigate tax and inflation issues in the financial realm.</li><li>Gain proficiency in probabilistic models and principles of premium calculation.</li></ul><p><strong>Accreditation</strong></p><p>This course is <strong>CPD Quality Standards</strong> (<strong>CPD QS)</strong> accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <ul><li>Aspiring actuaries</li><li>Financial analysts</li><li>Risk management enthusiasts</li><li>Insurance professionals</li><li>Finance and economics students</li><li>Anyone interested in mastering financial uncertainties</li></ul>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Actuary</li><li>Financial Analyst</li><li>Risk Manager</li><li>Insurance Underwriter</li><li>Pension Consultant</li><li>Investment Analyst</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p>Once you've successfully completed your course, you will immediately be sent a FREE digital certificate.</p></div>
        <h4>Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK).<br />For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only <strong>£10</strong>.<br />Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.</p></div>

                        </div>

Introduction to Actuarial Science Course

<div>
	<h3><strong>Description:</strong></h3>
<p><span>Business Accounting refers to the systematic recording, analysing, interpreting and presenting financial information. An Introduction to Business Accounting - Complete Video Course course provides you with the basic knowledge of Business Accounting for the betterment of your business.</span></p>
<p><span>In the course, you will learn the accounting equation and different types of financial statements and the ways of analysing transactions using the double-entry system, and by journalizing transactions. The course will also teach you how to post entries, the trial balance, and find errors using horizontal analysis. The Business Accounting course will also teach you the ways of adjusting process, adjusting entries, preparing a worksheet, and creating financial statements. Areas of concentration also include accounting cycles, temporary vs permanent accounting basics, the accounting cycle illustrated steps, the fiscal year, and working capital and current ratio.</span></p>
<p><span>To sum up, the course will help you to know the basic usage of Business Accounting.</span></p>
<h3><b>Assessment:</b></h3>
<ul>
<li><span>At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.</span></li>
<li><span>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</span></li>
</ul>
<h3><b>Certification:</b></h3>
<ul>
<li><span>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.</span></li>
<li><span>Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</span></li>
</ul>
<h3><b>Who is this Course for?</b></h3>
<p><b>An Introduction to Business Accounting - Complete Video Course </b><span>is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.</span></p>
<p><span>As there is no experience and qualification required for this course, it is available for all students from any academic background.</span></p>
<h3><b>Requirements</b></h3>
<p><span>Our</span><b> An Introduction to Business Accounting - Complete Video Course</b><span> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</span></p>
<h3><b>Career Path</b></h3>
<p><span>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</span></p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Professional Bookkeeper Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Professional Bookkeeper</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Introduction to Accounting and Business</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Defining a Business</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Ethics in Accounting</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Generally Accepted Accounting Principles (GAAP)</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4">The Accounting Equation</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Accounting Equation</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transactions</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Financial Statements</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Analyzing Transactions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Accounting Equation and Transactions</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Double-Entry System</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Transactions - Journalizing</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Journal Entries</td>
					<td> </td>
					<td><span><i></i> 00:38:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Entering Information - Posting Entries</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Posting Entries</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Trial Balance</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Finding Errors Using Horizontal Analysis</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Horizontal  Trend : Balance Sheet</td>
					<td> </td>
					<td><span><i></i> 00:21:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Horizontal  Trend: Income Statement</td>
					<td> </td>
					<td><span><i></i> 00:36:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Adjusting Process</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Purpose of the Adjusting Process</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Adjusting Entries</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adjusting Entries - Prepaid Expenses</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adjusting Entries - Accrued Revenues</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adjusting Entries - Depreciation Expense</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Adjustment Summary</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adjustment Summary - Review</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Vertical Analysis</td>
					<td> </td>
					<td><span><i></i> 00:33:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Preparing a Worksheet</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Preparing a Worksheet</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Financial Statements</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Income Statement</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Financial Statements - Definitions</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Completing the Accounting Cycle</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Temporary vs. Permanent Accounts</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td colspan="4">The Accounting Cycle Illustrated</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Accounting Cycle Illustrated - Steps 1-5</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Accounting Cycle Illustrated - Steps 6-10</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Fiscal Year</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Fiscal Year</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Spreadsheet Exercise</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Spreadsheet Exercise - Steps 1-4</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Spreadsheet Exercise - Steps 5-7</td>
					<td> </td>
					<td><span><i></i> 00:37:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam- An Introduction to Business Accounting - Complete Video Course</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- An Introduction to Business Accounting - Complete Video Course</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Order Your Certificates and Transcripts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

John Academy

Accounting

Certification in Business Accounting & Taxation (CBAT)

Business Accounting

Accounting & Bookkeeping

Financial Accounting

Practical Accounting

An Introduction to Business Accounting - Complete Video Course

<h3><b>Complete Python training course description</b></h3>
        <p> Python is an agile, robust, expressive, fully objectoriented,
          extensible, and scalable programming
          language. It combines the power of compiled
          languages with the simplicity and rapid development of
          scripting languages. This course covers Python from
          the very basics of 'hello world!' through to object
          oriented programming and advanced topics such as
          multi threading. Hands on follows all the major sections
          in order to reinforce the theory.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	    <li>Read Python programs.</li>
        <li>Write Python programs.</li>
        <li>Debug Python programs.</li>
        <li>Use Python's objects and memory model as well as
          its OOP features.</li>
        </ul>
        <h5>
        <b>Complete Python programming training course details</b></h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
               <p>Anyone wishing to learn Python. </p>
              
							<li><b>Prerequisites:</b></li>
							
             <p> None. </p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
             
              
						</ul>
					</div>
				</div>
       <h3><b>Complete Python programming training course contents</b></h3>
      <ul>
        <li>Welcome to Python: </li>
        <p> What is Python? Origins, features. Downloading and installing Python, Python manuals, comparing Python, other implementations. </p>
        <li>Getting started: </li>
        <p> Program output, the print statement, "hello world!", Program input, raw_input(), comments, operators, variables and assignment, numbers, strings, lists and tuples, dictionaries, indentation, if statement, while Loop, for loop. range(), list comprehensions. Files, open() and file() built-in functions. Errors and exceptions. Functions, Classes, Modules, useful functions. </p>
        <li>Python basics: </li>
        <p> Statements and syntax, variable assignment, identifiers, basic style guidelines, memory management, First Python programs, Related modules/developer tools. </p>
        <li>Python Objects: </li>
        <p> Other built-in types, Internal Types, Standard type operators, Standard type built-in functions, Categorizing standard types, Unsupported types. </p>
        <li>Numbers: </li>
        <p> Integers, Double precision floating point numbers, Complex numbers, Operators, Built-in and factory functions, Other numeric types. </p>
        <li>Sequences: strings, lists, and tuples: </li>
        <p> Sequences, Strings, Strings and operators, String-only operators, Built-in functions, String built-in methods, Special features of strings, Unicode, Summary of string highlights, Lists, Operators, Built-in functions, List type built-in methods, Special features of lists, Tuples, Tuple operators and built-in functions, Tuples special features, Copying Python objects and shallow and deep copies. </p>
        <li>Mapping and set types: </li>
        <p> Mapping Type: dictionaries and operators, Mapping type built-in and factory functions, Mapping type built-in methods, Dictionary keys, Set types, Set type operators, Built-in functions, Set type built-in methods. </p>
        <li>Conditionals and loops: </li>
        <p> If, else and elif statements, Conditional expressions, while, for, break, continue and pass statements, else statement . . . take two, Iterators and iter(), List comprehensions, Generator expressions. </p>
        <li>Files and input/output: </li>
        <p> File objects, File built-in functions [open() and file()], File built-in methods and attributes, Standard files, Command-line arguments, File system, File execution, Persistent storage modules. </p>
        <li>Errors and exceptions: </li>
        <p> What are exceptions? Detecting and handling exceptions, Context management, Exceptions as strings, Raising exceptions, Assertions, Standard exceptions, Creating Exceptions, Why exceptions, Exceptions and the sys module. </p>
        <li>Functions: </li>
        <p> Calling, creating and passing functions, formal arguments, variable-length arguments, functional programming, Variable scope, recursion, generators. </p>
        <li>Modules: </li>
        <p> Modules and files, Namespaces, Importing modules, Module import features, Module built-in functions, Packages, Other features of modules. </p>
        <li>Object-Oriented Programming (OOP): </li>
        <p> Classes, Class attributes, Instances, Instance attributes, Binding and method invocation, Static methods and class methods, Composition, Sub-classing and derivation, Inheritance, Built-in functions for classes, and other objects, Customizing classes with special methods, Privacy, Delegation, Advanced features of new-style classes (Python 2.2+), Related modules and documentation. </p>
        <li>Execution environment: </li>
        <p> Callable and code Objects, Executable object statements and built-in functions, Executing other programs. 'Restricted' and 'Terminating' execution, operating system interface. </p>
        <li>Regular expressions: </li>
        <p> Special symbols and characters, REs and Python, Regular expressions example. </p>
        <li>Network programming: </li>
        <p> Sockets: communication endpoints, Network programming in Python, SocketServer module, Twisted framework introduction. </p>
        <li>Internet client programming: </li>
        <p> What are internet clients? Transferring files, Network news, E-mail. </p>
        <li>Multithreaded Programming: </li>
        <p> Threads and processes Python, threads, and the global interpreter lock, The thread and threading Modules. </p>
        <li>GUI programming: </li>
        <p> Tkinter and Python programming, Tkinter Examples, Brief tour of other GUIs. </p>
        <li>Web programming: </li>
        <p> Web surfing with Python: creating simple web clients, Advanced Web clients, CGI: helping web servers process client data, Building CGI applications, Using Unicode with CGI, Advanced CGI, Web (HTTP) Servers. </p>
        <li>Database programming: </li>
        <p> Python database application programmer's interface (DB-API), ORMs. </p>
        <li>Miscellaneous </li>
        <p> Extending Python by writing extensions, Web Services, programming MS Office with Win32 COM, Python and Java programming with Jython.</p>
      </ul>

Complete Python programming

<h3><b>Supporting Windows 10 course description</b></h3>
      <p>This course is designed to provide students with the
knowledge and skills required to support and
troubleshoot Windows 10 PCs and devices in a
Windows Server domain environment. These skills
include understanding of Windows 10 features, how
they can be used in an Active Directory environment
and how to troubleshoot them. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	 <li>Troubleshoot startup issues and operating system
services on a Windows 10 PC.</li>
																								<li>Troubleshoot issues related to network connectivity.</li>
                   				 <li>Troubleshoot client configuration failures and GPO
application issues.</li>
																								<li>Troubleshoot issues related to application
installation and operation.</li>	
                        <li>Recover a PC running Windows 10.</li>
                  </ul>
        <h5><b>Supporting Windows 10 course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone supporting users running Windows 10 personal
computers within a medium to large enterprise.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>None.
                    </p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Supporting Windows 10 course contents</b></h3>
      <ul>
				<li>Implementing a Troubleshooting Methodology  </li><p>
Overview of Windows 10, Introduction to the EDST Job Role, Overview of the Troubleshooting Steps &amp; Tools. <br /><span>Hands on</span> Implementing a Troubleshooting Methodology.
<br /><span>Hands on</span> Using Troubleshooting Tools for Windows 10.

</p><li>Troubleshooting Startup Issues </li><p>
Overview of the Windows 10 Startup Recovery Environment, Troubleshooting Startup Settings &amp; Operating System Services Issues, Recovering BitLocker-Protected Drives.
<br /><span>Hands on</span> Troubleshooting Startup Issues. <br /><span>Hands on</span> Recovering BitLocker-Encrypted Drives, Creating a New BitLocker Password.

</p><li>Troubleshooting Hardware and Device Drivers </li><p>
Troubleshooting Device Driver Failures &amp; Physical Failures, Overview of Hardware Troubleshooting, Monitoring Reliability, Configuring the Registry.
<br /><span>Hands on</span> Troubleshooting Device Driver Issues, Resolving Hardware Issues, Adding a Missing Device Driver to a Driver Store, Reverting a Problematic Device Driver.
<br /><span>Hands on</span> Troubleshooting Hardware Issues, Diagnosing Memory, Troubleshooting and Repairing Failed Disk Redundancy Synchronizing Settings, Accessing Data on a Foreign Volume.

</p><li>Troubleshooting Remote Computers </li><p>
Using Remote Desktop and Remote Assistance, Remoting with Windows PowerShell <br /><span>Hands on</span> Troubleshooting Remote Computer by using Remote Desktop and Remote Assistance.
<br /><span>Hands on</span> Troubleshooting Remote Computer by using Windows PowerShell.

</p><li>Resolving Network Connectivity Issues </li><p>
Determining Network Settings, Troubleshooting Network Connectivity Issues, Troubleshooting Name Resolution. <br /><span>Hands on</span> Resolving Network Connectivity Issues.
<br /><span>Hands on</span>Resolving Name Resolution Issues.

</p><li>Troubleshooting Group Policy </li><p>
Overview of Group Policy Application, Resolving Client Configuration Failures and GPO Application Issues. <br /><span>Hands on</span> Troubleshooting Group Policy Application Issues. <br /><span>Hands on</span> Resolving Group Policy Issues.
<br /><span>Hands on</span> Installing and Sharing a Printer.

</p><li>Troubleshooting User Settings </li><p>
Troubleshooting Sign In Issues, Troubleshooting the Application of User Settings.
<br /><span>Hands on</span> Troubleshooting Sign in Problems.
<br /><span>Hands on</span> Troubleshooting the Application of User Settings, Resolving Folder Redirection Problem, Resolving Roaming User Profile Problem.

</p><li>Troubleshooting Remote Connectivity </li><p>
Troubleshooting VPN Connectivity Issues &amp; DirectAccess.
<br /><span>Hands on</span> Troubleshooting VPN Connectivity Lab : Configuring and Troubleshooting DirectAccess Configuring and Verifying, DirectAccess Client-Side Settings, Troubleshooting DirectAccess. Troubleshooting Resource Access Within a Domain &amp; File Permissions Issues, Recovering Files Encrypted by EFS, Troubleshooting Printer Access Issues. Lab : Troubleshooting File Access Issues Lab : Troubleshooting Access to Encrypted Files.
<br /><span>Hands on</span> Troubleshooting Printer Access Issues

</p><li>Troubleshooting Resource Access for Non Domain Member Clients </li><p>
Configuring and Troubleshooting Device Registration, Configuring and Troubleshooting Work Folders, Configuring and Troubleshooting OneDrive Access.
<br /><span>Hands on</span> Troubleshooting Resource Access for Clients that are not Domain Members. Troubleshooting Device Registration, Work Folders and OneDrive for Business.

</p><li>Troubleshooting Applications </li><p>
Troubleshooting Desktop App Installation Issues, Desktop Apps, Managing Windows Store Apps, Troubleshooting Access to Company Web Applications.
<br /><span>Hands on</span> Troubleshooting Desktop Apps, AppLocker Policy Application &amp; Application Compatibility issue.
<br /><span>Hands on</span> Troubleshooting Access to Company Web Applications, Internet Explorer Issue &amp; Microsoft Edge.

</p><li>Maintaining Windows 10 </li><p>
Managing &amp; Troubleshooting Windows Activation, Troubleshooting Performance, Applying Applications.
<br /><span>Hands on</span> Monitoring and Troubleshooting Performance.

</p><li>Recovering Data and Operating System </li><p>
File Recovery in Windows 10, Recovering an OS.
<br /><span>Hands on</span> Recovering Data, Recovering Data from Azure Backup, Recovering Deleted File by Using File History.
<br /><span>Hands on</span> Provisioning Computer to Comply with Company Standards, Provision Computer to Comply with Company Standards.
</p>
      </ul>

Supporting Windows 10

Reading

Nottingham

Dickson Training Ltd

ILM Level 5 Qualifications in Business Coaching and Mentoring

Diploma (Zoom)

Certificate (Zoom)

Diploma

Certificate

Chesterfield

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;">FAA Level 1 Award In Awareness Of First Aid For Mental Health (RQF)</h2><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Classroom (4.5 hour course), Virtual (2 x 2 &frac12; hour sessions)&nbsp;</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Gives learners a good awareness of Mental Health First Aid</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Gives learners the skills to start that difficult conversation</strong></li></ul><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h3 id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Contents:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">What is Mental Health?</li><li fr-original-style="" style="box-sizing: border-box;">Why people develop mental health conditions</li><li fr-original-style="" style="box-sizing: border-box;">What the role of a mental health first aider is</li><li fr-original-style="" style="box-sizing: border-box;">Knowing how to provide advice and practical support</li><li fr-original-style="" style="box-sizing: border-box;">Knowing how to recognise and manage stress</li><li fr-original-style="" style="box-sizing: border-box;">Recognising a range of mental health conditions:</li><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Depression</li><li fr-original-style="" style="box-sizing: border-box;">Anxiety</li><li fr-original-style="" style="box-sizing: border-box;">Psychosis</li><li fr-original-style="" style="box-sizing: border-box;">Eating disorders</li><li fr-original-style="" style="box-sizing: border-box;">Suicide</li><li fr-original-style="" style="box-sizing: border-box;">Self-harm</li></ul></ul><h3 fr-original-style="" style="box-sizing: border-box;">Benefits of this course:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">37% of all work-related ill-health is due to mental health problems</li><li fr-original-style="" style="box-sizing: border-box;">Problems with mental health cover 45% of all working days lost</li><li fr-original-style="" style="box-sizing: border-box;">A whopping 12.8 million working days, or 49, 042 years, were lost due to mental health problems in 2018/19</li><li fr-original-style="" style="box-sizing: border-box;">602,000 workers suffered from work-related stress, depression or anxiety in 2018/19</li><li fr-original-style="" style="box-sizing: border-box;">One in four people will have a mental health problem at some point during their lives</li><li fr-original-style="" style="box-sizing: border-box;">Whether work is causing or aggravating mental health problems, employers have a legal responsibility towards their employees</li><li fr-original-style="" style="box-sizing: border-box;">Work-related mental health issues must to be assessed to measure the levels of risk to staff</li><li fr-original-style="" style="box-sizing: border-box;">Where a risk is identified, steps must be taken to remove it or reduce it as far as reasonably practicable</li><li fr-original-style="" style="box-sizing: border-box;">This half day course gives people a good awareness of mental health in the workplace</li><li fr-original-style="" style="box-sizing: border-box;">For a more complete introduction, see our full day First Aid for Mental Health or two day Supervising First Aid for Mental Health courses</li></ul><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h3 fr-original-style="" style="box-sizing: border-box;">Accredited, Ofqual regulated qualification</h3><div fr-original-style="" style="box-sizing: border-box;"><img src="https://images.cademy.co.uk/pochat-training/6c550a94-5c16-4ff3-b27f-7407b1a35e22/original.jpeg" style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left; cursor: pointer; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable"></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This Awareness of Mental Health First Aid Course is a nationally recognised, Ofqual regulated qualification accredited by&nbsp;</span><a href="http://www.firstaidawards.com/" style="color: rgb(34, 177, 77); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" target="_blank" fr-original-style=" color: rgb(34, 177, 77);">First Aid Awards</a><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br 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);">This means that you can be rest assured that your Mental Health First Aid Certificates fulfil the upcoming <img src="https://images.cademy.co.uk/pochat-training/93996411-85e2-4821-bf00-5875b510df81/original.png" style="width: 232px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left; cursor: pointer; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 232px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable">legal requirements and are a very good way to make sure you and your employees have a supporting workplace to deal with staff&#39;s mental health conditions.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br 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);">The&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Ofqual Register number</strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;for this course is&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">603/3768/0</strong></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;"><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;"><br fr-original-style="" style="box-sizing: border-box;"></p><img src="https://images.cademy.co.uk/pochat-training/7cbdb7f4-2060-482c-aab7-6d4ad4183309/original.png" style="width: 585px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 585px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable">

Pochat Training

Mental Health Awareness

Mental Health First Aid

Health & Wellbeing

Occupational Health & Wellbeing

Emotional Wellbeing

Psychological Wellbeing

Mental Health

Emotional Resilience

Accredited Mental Health First Aid

Mental Resilience

Mental Health At Work

Resilience

Awareness of First Aid for Mental Health

 This price includes an Ofqual regulated certificate

 With Ofqual regulated certificate 

This price includes a CPD certificate instead of an Ofqual regulated certificate (it's exactly the same course)

 With CPD certificate

<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

<h2 id="isPasted" style="color: rgb(57, 54, 79); box-sizing: border-box;" fr-original-style=" color: rgb(57, 54, 79);">About this event</h2><div style="color: rgb(57, 54, 79); box-sizing: border-box;" fr-original-style=" color: rgb(57, 54, 79);"><h3 style="color: rgb(30, 10, 60); box-sizing: border-box;" fr-original-style=" color: rgb(30, 10, 60);">COURSE INTRODUCTION</h3><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This course covers Tuberculosis, latent and active, diagnosis, screening and testing, groups offered vaccine, symptoms and treatment; within the current regulatory and legal framework. We discuss Mantoux, BCG techniques, IGRA testing, Scar identification and current issues. The course is hands-on and practical and each participant receives a certificate after successfully completing the course.</p><h3 style="color: rgb(30, 10, 60); box-sizing: border-box;" fr-original-style=" color: rgb(30, 10, 60);">AIMS AND OBJECTIVES</h3><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Be able to provide accurate and up to date information about BCG and TB vaccines</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Update staff on current issues</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Provide a safe, effective and high standard of care</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">COURSE CONTENTS</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; The aims of TB immunisation: national policy and schedules</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; History of TB</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; How common is TB</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Epidemiology and current statistics</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Screening and testing</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Latent TB infection</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Active TB disease</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Signs and symptoms of TB</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Diagnosis</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; IGRA Testing</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Treatment</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Management</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; TB Vaccination</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Practical workshop</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Technique-intradermal</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; BCG Technique</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Mantoux / Technique</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Scar identification</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; The legal aspects of vaccination</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Prescribing vaccines</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Storage and handling of vaccines - cold chain</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Correct administration of vaccines</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Record-keeping and reporting</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Competence Assessment</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Ref: National Minimum Standards for Immunisation Training, PHE and RCN, Immunisation for Infectious Diseases</p><h3 style="color: rgb(30, 10, 60); box-sizing: border-box;" fr-original-style=" color: rgb(30, 10, 60);">WHO SHOULD ATTEND?</h3><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Nurses - Primary Care, Secondary Care</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Occupational Health Staff</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Doctors - Occupational Health</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Military Staff</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Midwives</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Neonatal Nurses</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; School Nurses</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Includes All course materials and certificate of attendance</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">AB Health Group awards CPD points / certificate of attendance for each course. &nbsp;If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. &nbsp;The charge for the certificate including postage is &pound;30.00.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Annie Barr AB Health Group</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Organiser Description</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Annie Barr is a leading provider of high quality, accredited healthcare training. With a selection of engaging healthcare training that has been developed by experts to equip you and your workforce with the skills, knowledge and competence needed to provide compassionate and high quality care.</p></div>

About this event
COURSE INTRODUCTION
This course covers Tuberculosis, latent and active, diagnosis, screening and testing, groups offered vaccine, symptoms and treatment; within the current regulatory and legal framework. We discuss Mantoux, BCG techniques, IGRA testing, Scar identification and current issues. The course is hands-on and practical and each participant receives a certificate after successfully completing the course.
AIMS AND OBJECTIVES
• Be able to provide accurate and up to date information about BCG and TB vaccines
• Update staff on current issues
• Provide a safe, effective and high standard of care


COURSE CONTENTS
• The aims of TB immunisation: national policy and schedules
• History of TB
• How common is TB
• Epidemiology and current statistics
• Screening and testing
• Latent TB infection
• Active TB disease
• Signs and symptoms of TB
• Diagnosis
• IGRA Testing
• Treatment
• Management
• TB Vaccination
• Practical workshop
• Technique-intradermal
• BCG Technique
• Mantoux / Technique
• Scar identification
• The legal aspects of vaccination
• Prescribing vaccines
• Storage and handling of vaccines - cold chain
• Correct administration of vaccines
• Record-keeping and reporting
• Competence Assessment
Ref: National Minimum Standards for Immunisation Training, PHE and RCN, Immunisation for Infectious Diseases
WHO SHOULD ATTEND?
• Nurses - Primary Care, Secondary Care
• Occupational Health Staff
• Doctors - Occupational Health
• Military Staff
• Midwives
• Neonatal Nurses
• School Nurses
Includes All course materials and certificate of attendance
AB Health Group awards CPD points / certificate of attendance for each course. If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. The charge for the certificate including postage is £30.00.


Annie Barr AB Health Group
Organiser Description
Annie Barr is a leading provider of high quality, accredited healthcare training. With a selection of engaging healthcare training that has been developed by experts to equip you and your workforce with the skills, knowledge and competence needed to provide compassionate and high quality care.

AB Health Group

General Health

Medical Training

Professional Development

Public Health

BCG/Mantoux and TB - Webinar

TB / BCG Training WEBINAR

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p><p>Earning your SHRM Certified Professional (SHRM-CP) or SHRM Senior Certified Professional (SHRM-SCP) credential makes you a recognized expert and leader in the HR field and a valuable asset to your organization, keeping  you and your organization more competitive in today's economy. This professional distinction sets you apart from your colleagues, proving your high level of knowledge and skills. Students will be able to identify areas of strength and build on them. They will also see where they will need further concentrated study in preparation for their exam.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION</h3> <ul> <li>The SHRM Body of Competency and Knowledge? (BoCK)</li> <li>The SHRM-CP and SHRM-SCP Certifications</li> <li>The SHRM Learning SystemÂ© for SHRM-CP/SHRM-SCP</li> </ul> <h3>2 - HR COMPETENCIES</h3> <ul> <li>Behavioral Competencies</li> </ul> <h3>3 - DOMAIN 1: PEOPLE</h3> <ul> <li>Functional Area #1: HR Strategic Planning</li> <li>Functional Area #2: Talent Acquisition </li> <li>Functional Area #3: Employee Engagement and Retention </li> <li>Functional Area #4: Learning and Development</li> <li>Functional Area #5: Total Rewards</li> </ul> <h3>4 - DOMAIN 2: ORGANIZATION</h3> <ul> <li>Functional Area #6: Structure of the HR Function</li> <li>Functional Area #7: Organizational Effectiveness and Development</li> <li>Functional Area #8: Workforce Management</li> <li>Functional Area #9: Employee and Labor Relations</li> <li>Functional Area #10: Technology Management</li> </ul> <h3>5 - DOMAIN 3: WORKPLACE</h3> <ul> <li>Functional Area #11: HR in the Global Context</li> <li>Functional Area #12: Diversity and Inclusion</li> <li>Functional Area #13: Risk Management</li> <li>Functional Area #14: Corporate Social Responsibly</li> <li>Functional Area #15: U.S. Employment Law and Regulations</li> </ul> <h3>6 - FINAL EXAM/REVIEW/DISCUSSION</h3></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans SHRM-CP/SHRM-SCP Certification Preparation 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 SHRM-CP/SHRM-SCP Certification Preparation course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Clifton Practice Hypnotherapy Training (CPHT)

Chartered Institute of Personnel Development (CIPD)

Certified Payroll Professional (CPP)

Professional Skills Course (PSC)

Certified Supply Chain Professional (CSCP)

Scrum Master Professional Certificate (SMPC)

SHRM-CP/SHRM-SCP Certification Preparation

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

Computing Skills

Microsoft SQL

Data Skills

SQL Server

Trainers Course

55366 Querying Data with Transact-SQL

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is 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

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

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>

Automated External Defibrillation (AED)

Defibrillator

How to Use an AED

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

30744 Courses

Querying Microsoft SQL Server

By Systems & Network Training

Introduction to Aromatherapy Course

By Training Express

Using Windows PowerShell

By Systems & Network Training

Introduction to Risk Assessment

By TNA Training & Safety Consultants

Introduction to HACCP Level 2

By TNA Training & Safety Consultants

Professional Certificate Course in Introduction to Hotel Marketing in London 2024

By Metropolitan School of Business & Management UK

Introduction to Actuarial Science Course

By Training Express

An Introduction to Business Accounting - Complete Video Course

By John Academy

Complete Python programming

By Systems & Network Training

Supporting Windows 10

By Systems & Network Training

Search By Location