Name: MySQL for developers
Price: 2797 GBP
Availability: InStock

<h4>Overview</h4>
						<hr />
						<div></div>
							<p>
							</p><p>In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user. By attending this course, you will be able to effectively prepare and build financial models.</p>

<p>Objectives</p>

<ul>
	<li>
	<p>Harness Excel's tools within a best practice framework</p>
	</li>
	<li>
	<p>Add flexibility to their models through the use of switches and flexible lookups</p>
	</li>
	<li>
	<p>Work efficiently with large data volumes</p>
	</li>
	<li>
	<p>Model debt effectively</p>
	</li>
	<li>
	<p>Approach modelling for tax, debt, pensions and disposals with confidence</p>
	</li>
	<li>
	<p>Build flexible charts and sensitivity analysis to aid the presentation of results</p>
	</li>
	<li>
	<p>Learn and apply Excel tools useful in financial forecasting</p>
	</li>
	<li>
	<p>Understand and design the layout of a flexible model</p>
	</li>
	<li>
	<p>Forecast financial statements of a public or private company</p>
	</li>
	<li>
	<p>Apply scenario analysis to the forecasted financial statements and prepare charts for data presentation</p>
	</li>
</ul>
<p>
							
							</p><div>
						
					</div>

GBA Corporate

Financial Modelling for Budgeting and Forecasting in Excel

Online

On Site

Redhill

<h3><b>Fibre Optic cabling training course description</b></h3>
        <p>A hands on course covering installation, splicing and
          testing of fibre optic cabling. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
        <li>Describe different types of fibre cable and where to use them</li>
        <li>Install fibre optic cable.</li>
        <li>Splice fibre optic cable.</li>
        <li>Test fibre optic cable.</li>
        </ul>
        <h5>
        <b>Fibre Optic cabling training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Cable installation professionals.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Fibre Optic cabling training course contents</b></h3>
      <ul>
        <li>Fibre optic transmission</li>
        <p> Physics of light, optical modes, light propagation,
          light guiding, dispersion, light spectrum, fibre
          versus copper comparison, fibre cable types and
          their uses, WDM and DWDM. </p>
        <li>Fibre optic cable</li>
        <p>Single mode, Multi mode, diameters, step-index
fibre, graded index fibre, loose tube, tight buffered,
cable jackets, distance limitations, indoor versus
outdoors.</p>
        <li>Fibre optic network components</li>
        <p>ST, SC, FC and other connectors, termination
methods, joint enclosures, transmitters, light
sources, laser, LED, receivers, detectors.</p>
        <li>Installation</li>
        <p>BS.7718. Safe working practices, site surveys,
recommended installation procedures, cable
handling issues, bending radius, techniques and
tools, documentation.</p>
        <li>Splicing</li>
        <p>Joining fibres, splicers, fusion splicing, mechanical
splicing, splicing procedure, cleaving, splicing
parameters, splicing vs. connectors.</p>
        <li>Measurement parameters and applications</li>
        <p>Power measurement, loss measurement, return
loss measurement, receiver sensitivity
measurement, budget calculations.
 </p>
        <li>Testing
</li>
        <p>Optical power meter, optical light source, optical
attenuator, return loss meter, continuity testing,
insertion loss testing, OTDR features and
principles, OTDR capabilities and limitations, 
using an OTDR, troubleshooting.</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Fibre optic cabling for engineers

General Admission

London

<h2>Better Business Cases™ Foundation and Practitioner: In-House Training</h2>
<p>Using this best-practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives.</p>
<p>The goal of the combined foundation and practitioner course is to develop a candidate's ability to deliver a comprehensive business case through encouraging expanded knowledge to guide the practical application of theoretical foundations. Upon the completion of this course, a candidate will be able to start applying the model to a real business case development project.</p>
<p>The outline presented in the course overview will be addressed in the first 2 days, with the Foundation exam conducted on the morning of Day 3. Then the topics will be revisited at a deeper level, for 2 more days, with the Practitioner exam conducted on the afternoon of Day 5.</p><h3>What you will Learn</h3>
<p>At the end of this program, you will be able to:</p>
<ul>
<li>Develop the lifecycle of a business case and establish the relationships between the five cases</li>
<li>Apply the steps in the business case development framework, in order to support the production of a business case, using the Five Case Model, for a given scenario.</li>
</ul><section>
                    <h3>Overview of Better Business Cases</h3><ul><li>Alignment with the strategic planning process</li><li>Importance of the Business Case using the Five Case Model</li><li>Overview of the Five Case Model</li><li>Purpose of the key stages in the development of a spending proposal</li><li>Purpose of a Business Justification Case</li><li>Business Case Development Process</li><li>Purpose of project / programme assurance and assurance reviews</li><li>Responsibility for producing the Business Case</li></ul><h3>Determining the Strategic Context and Undertaking the Strategic Assessment</h3><ul><li>Scoping the Scheme and Preparing the Strategic Outline Case</li><li>Planning the Scheme and Preparing the Outline Business Case</li><li>Procuring the Solution and Preparing the Full Business Case</li><li>Implementation and monitoring</li><li>Evaluation and feedback</li></ul><h3>Making the Case for Change</h3><ul><li>Agree on the strategic context</li><li>Determine spending objectives, existing arrangements, and business needs</li><li>Determine potential business scope and key service requirements</li><li>Determine benefits, risks, constraints, and dependencies</li></ul><h3>Exploring the Preferred Way Forward</h3><ul><li>Agree on critical success factors</li><li>Determine long list options and SWOT analysis</li><li>Recommend a preferred way forward</li></ul><h3>Determining Potential Value for Money</h3><ul><li>Revisit the short list</li><li>Prepare the economic appraisal for short-listed options</li><li>Undertake benefits appraisal</li><li>Undertake risk appraisal</li><li>Select preferred option and undertake sensitivity analysis</li></ul><h3>Preparing for the Potential Deal</h3><ul><li>Determine the procurement strategy</li><li>Determine service streams and required outputs</li><li>Outline potential risk apportionment</li><li>Outline potential payment mechanisms</li><li>Ascertain contractual issues and accountancy treatment</li></ul><h3>Ascertaining Affordability and Funding Requirement</h3><ul><li>Prepare the financial model</li><li>Prepare the financial appraisals</li></ul><h3>Planning for Successful Delivery</h3><ul><li>Plan programme / project management</li><li>Plan change and contract management</li><li>Plan benefits realization</li><li>Plan risk management</li><li>Plan programme / project assurance and post-project evaluation</li></ul><h3>Procuring the Value for Money Solution</h3><ul><li>Revisit the case for change</li><li>Revisit the OBC options</li><li>Detail procurement process and evaluation of best and final offers (BAFOs)</li></ul><h3>Contracting for the Deal</h3><ul><li>Set out the negotiated deal and contractual arrangements</li><li>Set out the financial implications of the deal</li></ul><h3>Ensuring Successful Delivery</h3><ul><li>Finalize project management arrangements and plans</li><li>Finalize change management arrangements and plans</li><li>Finalize benefits realization arrangements and plans</li><li>Finalize risk management arrangements and plans</li><li>Finalize contract management arrangements and plans</li><li>Finalize post-project evaluation arrangements and plans</li></ul>


                </section>

IIL Europe Ltd

Better Business Cases Foundation & Practitioner: In-House

Loughborough

<div>
		

		<div>
			
			<p>In this workshop, you will gain a better understanding of the benefits and challenges of working with neurodiverse people. Make your Organisation a more inclusive place for neurodiverse individuals.</p>
			<div><i></i> 4 Hours: Live Online</div>
			<div><i></i>  £534.00 incl. VAT</div>
			
			
		</div>
	</div>

	

	<div id="filters">
		
		
	</div>

	

    <div>

		
		 
		

		<div></div>

		<div>
			<p>Want to run this event in-house?  Enquire about running this event in-house </p>
			
		</div>

		<div>
			<p>Interested in attending? Have a suggestion about running this event near you?<br />Register your interest now</p>
			
		</div>
	</div>
	<div></div>
	
		
        <div>
			
		</div>
				

	
		<h3>Description</h3>
		<p></p><h3>In this 4-hour interactive virtual workshop, you will:</h3>
<ul>
<li>Appreciate the different strengths of talented neurodiverse candidates</li>
<li>Reduce interpersonal friction</li>
<li>Ensure equality in employment opportunities</li>
<li>Comply Equalities Act 2010</li>
</ul>
<p><strong>Available as private Face to Face and virtual sessions (max 12 delegates) - £1,745 Plus VAT</strong></p>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><h3>Different not deficient</h3>
<ul>
<li>Shifting perceptions</li>
<li>New business models need new thinking</li>
</ul>
<h3>Strengths</h3>
<ul>
<li>The gifts of neurodiversity</li>
<li>Successful neurodivergent hall of fame</li>
</ul>
<h3>Signs (diagnostic criteria and labels)</h3>
<ul>
<li>Biology</li>
<li>Brain differences (cognition)</li>
<li>Behaviours</li>
</ul>
<h3>Struggles</h3>
<ul>
<li>Sensory sensitivity</li>
<li>Social interactions</li>
<li>Anxiety and stress response</li>
</ul>
<h3>Inclusive Workplace Cultures</h3>
<p></p>
	
		<h3>Target Student</h3>
		<p></p><p>Open to everyone</p>
<p></p>

Mpi Learning - Professional Learning And Development Provider

Neurodiversity

Autism Spectrum Counselling & Training (ASPECT)

Equality & Diversity

Mental Health At Work

Disability Awareness

Diversity & Inclusion

In this workshop, you will gain a better understanding of the benefits and challenges of working with neurodiverse people. Make your Organisation a more inclusive place for neurodiverse individuals.

Neurodiversity Workshop Awareness: Signs, Strengths, Struggles

<h3><b>MySQL foundation training course description</b></h3>
        <p> The MySQL foundation course covers the basics of the
SQL language as implemented by MySQL. The course
is designed to give delegates practical experience in
writing SQL statements using the MySQL client
program and MySQL Workbench. The basic SQL
statements, including the use of SQL functions and the
basic table and view handling statements are
introduced.    </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                      <li>Create, alter and drop a MySQL database.</li>
						<li>Write SQL statements.</li>
						<li>Use SQL expressions and functions.</li>
                        <li>Create and alter tables, indexes and views.</li>
                        <li>Use transactions.</li>
                        <li>Grant and revoke access privileges.</li>
                        <li>Export and import data.</li>
                  </ul>
        <h5>
        <b>MySQL foundation training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone who needs to access and work with a MySQL Database.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>An understanding of databases and exposure to
information technology in general would be useful.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL foundation training course contents</b></h3>
      <ul>
        <li>Database concepts </li><p>
What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases.
<br /><span>Hands on</span> using a database.

</p><li>Using the MySQL client </li><p>
What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts.
<br /><span>Hands on</span> Using the MySQL client.

</p><li>Basic SELECT </li><p>
The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators.
<br /><span>Hands on</span> querying the sample database.

</p><li>LIMIT, UNION and AGGREGATE functions </li><p>
The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause.
<br /><span>Hands on</span> using limit, union and aggregate functions.

</p><li>Subqueries and joins </li><p>
Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. <br /><span>Hands on</span> using subqueries and joins.

</p><li>Numeric and character functions </li><p>
Function types, testing functions, numeric functions character functions.
<br /><span>Hands on</span> using numeric and character functions.

</p><li>Data, time and other functions </li><p>
Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions.
<br /><span>Hands on</span> using date, time and other functions.

</p><li>Databases and tables </li><p>
Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables.
<br /><span>Hands on</span> maintaining databases and tables.

</p><li>Indexes and views </li><p>
What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views.
<br /><span>Hands on</span> maintaining indexes and views.

</p><li>Managing data </li><p>
Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits.
<br /><span>Hands on</span> managing data.

</p><li>Access control </li><p>
Creating users, renaming users, dropping users, granting privileges, revoking privileges. <br /><span>Hands on</span> creating users, granting and revoking.

</p><li>Import and export </li><p>
Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line.
<br /><span>Hands on</span> export and import data.
</p>
      </ul>

MySQL foundation

<h2>Emotional Intelligence: In-House Training</h2>
 <p>Emotional Intelligence is a set of emotional and social skills that collectively establish how well we:</p>
 <ul>
 <li>Perceive and express ourselves</li>
 <li>Develop and maintain social relationships</li>
 <li>Cope with challenges</li>
 <li>Use emotional information in an effective and meaningful way</li>
 </ul>
 <p>It is a skill set that transfers across all categories of relationships. It is also a predictor of success - both in life and at work. This highly-interactive course delivers a practical approach to developing, improving, and sustaining effective and mutually beneficial relationships. The design of the course involves individual reflection and paired activities, interwoven with small and large group interactions.</p>
 <p>The EQ-i 2.0® assessment reports will be debriefed over the course of the two days. In addition, participants will delve into their personal strengths and blind spots, and will explore topics including: the neuroscience of emotion, the connection between empathy and performance, and how communication styles impact our perceptions of self and other. Role-play activities give participants the opportunity to try out new behaviors and techniques.</p>
 <p>The program includes:</p>
 <ul>
 <li>A personal behavioral profile, the results of which you will bring to your training</li>
 <li>2-day highly interactive workshop and experiential learning</li>
 <li>Optional professional coaching activities initiated in class that can continue over the four months after class ends</li>
 </ul><h3>What you will Learn</h3> <ul> <li>Recognize your interpersonal strengths and potential blind spots regarding Emotional Intelligence</li> <li>Identify the five domains within the EQ-i 2.0 assessment model</li> <li>Summarize what neuroscience research has discovered about emotions and actions</li> <li>Recognize ways that human beings are physiologically impacted by stress</li> <li>Articulate ways to develop and maintain strong working relationships</li> <li>Describe how emotional intelligence translates into high performance</li> <li>Make use of the EI model and associated competencies</li> <li>Employ strategies for enhancing leadership through Emotional Intelligence</li> </ul><section>
                    <h3>Foundation Concepts</h3> <ul> <li>The biology of emotion</li> <li>Why Emotional Intelligence matters</li> <li>The impact of EI on performance</li> </ul> <h3>The EQ-I 2.0 Model</h3> <ul> <li>Overview of the EQ-i 2.0 framework</li> <li>Exploring your report</li> <li>Balancing your EI domains</li> </ul> <h3>Self: Awareness and Sensitivity</h3> <ul> <li>Self-awareness and empathy</li> <li>Perception vs. reality</li> <li>Acting by choice, not impulse</li> </ul> <h3>Other: Communication and Relationship-Building</h3> <ul> <li>Elements of effective communication</li> <li>Communication styles</li> <li>Communication techniques</li> </ul> <h3>Neuroscience and Behavioral Change</h3> <ul> <li>Insights from social neuroscience</li> <li>Making a change</li> </ul>


                </section>

Emotional Intelligence: In-House Training

<h2>Better Business Cases™ Practitioner: In-House Training: In-House Training</h2>
 <p>Better Business Cases™ is based on the Five Case Model - which is the UK government's best practice approach to structuring spending proposals and making effective business decisions. Using this best-practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives.</p>
 <p>The goal of the practitioner course is to develop a candidate's ability to deliver a comprehensive business case, through encouraging expanded knowledge to guide the practical application of theoretical foundations. Upon the completion of this Practitioner course, a candidate will be able to start applying the model to a real business case development project.</p><h3>What You Will Learn</h3>
 <p>At the end of this program, you will be able to:</p>
 <ul>
 <li>Develop the lifecycle of a business case and to establish the relationships between the five cases</li>
 <li>Apply the steps in the business case development framework, in order to support the production of a business case, using the Five Case Model, for a given scenario</li>
 </ul><section>
                    <h3>Overview of Better Business Cases</h3> <ul> <li>Alignment with the strategic planning process</li> <li>Importance of the Business Case using the Five Case Model</li> <li>Overview of the Five Case Model</li> <li>Purpose of the key stages in the development of a spending proposal</li> <li>Purpose of a Business Justification Case</li> <li>Business Case Development Process</li> <li>Purpose of project / programme assurance and assurance reviews</li> <li>Responsibility for producing the Business Case</li> </ul> <h3>Determining the Strategic Context and Undertaking the Strategic Assessment</h3> <ul> <li>Scoping the Scheme and Preparing the Strategic Outline Case</li> <li>Planning the Scheme and Preparing the Outline Business Case</li> <li>Procuring the Solution and Preparing the Full Business Case</li> <li>Implementation and monitoring</li> <li>Evaluation and feedback</li> </ul> <h3>Making the Case for Change</h3> <ul> <li>Agree on the strategic context</li> <li>Determine spending objectives, existing arrangements, and business needs</li> <li>Determine potential business scope and key service requirements</li> <li>Determine benefits, risks, constraint, and dependencies</li> </ul> <h3>Exploring the Preferred Way Forward</h3> <ul> <li>Agree on critical success factors</li> <li>Determine long list options and SWOT analysis</li> <li>Recommend a preferred way forward</li> </ul> <h3>Determining Potential Value for Money</h3> <ul> <li>Revisit the short list</li> <li>Prepare the economic appraisal for short-listed options</li> <li>Undertake benefits appraisal</li> <li>Undertake risk appraisal</li> <li>Select preferred option and undertake sensitivity analysis</li> </ul> <h3>Preparing for the Potential Deal</h3> <ul> <li>Determine the procurement strategy</li> <li>Determine service streams and required outputs</li> <li>Outline potential risk apportionment</li> <li>Outline potential payment mechanisms</li> <li>Ascertain contractual issues and accountancy treatment</li> </ul> <h3>Ascertaining Affordability and Funding Requirement</h3> <ul> <li>Prepare the financial model</li> <li>Prepare the financial appraisals</li> </ul> <h3>Planning for Successful Delivery</h3> <ul> <li>Plan programme / project management</li> <li>Plan change and contract management</li> <li>Plan benefits realization</li> <li>Plan risk management</li> <li>Plan programme / project assurance and post project evaluation</li> </ul> <h3>Procuring the Value for Money Solution</h3> <ul> <li>Revisit the case for change</li> <li>Revisit the OBC options</li> <li>Detail procurement process and evaluation of best and final offers (BAFOs)</li> </ul> <h3>Contracting for the Deal</h3> <ul> <li>Set out the negotiated deal and contractual arrangements</li> <li>Set out the financial implications of the deal</li> </ul> <h3>Ensuring Successful Delivery</h3> <ul> <li>Finalize project management arrangements and plans</li> <li>Finalize change management arrangements and plans</li> <li>Finalize benefits realization arrangements and plans</li> <li>Finalize risk management arrangements and plans</li> <li>Finalize contract management arrangements and plans</li> <li>Finalize post-project evaluation arrangements and plans</li> </ul>


                </section>

Better Business Cases Practitioner: In-House Training

<h2>The Art of Negotiation: In-House Training</h2>
<p>Confidence, rapport, curiosity, and patience are essential ingredients to successfully handling a difficult conversation and negotiation. In this course, you will learn to identify and manage aspects of a negotiation, distinguish needs from wants, and manage expectations.</p>
<p>The course will cover communication best practices, strategies for handling difficult conversations, and the basics of the art of negotiation.</p><h3>What you Will Learn</h3><ul><li>Master the different ways to say 'no'</li><li>Determine negotiation strategies based on typical client strategies</li><li>Develop solutions to break deadlocks</li></ul><section>
                    <h3>Getting Started</h3><ul><li>Introductions</li><li>Course structure</li><li>Course goals and objectives</li><li>Establishing personal learning objectives</li></ul><h3>Foundation Concepts</h3><ul><li>Exercise: Most Challenging Scenarios and Outcomes</li><li>Debrief: Impact versus intent</li><li>Addressing customer expectations</li><li>Needs versus wants</li><li>Key skills for managing customer relationships</li><li>Elicitation (requirements gathering)</li><li>Communication and active listening</li><li>Sensitivity and empathy</li></ul><h3>Handling Difficult Conversations</h3><ul><li>Saying 'no'</li><li>The Ladder of Inference</li><li>4-Step approach for handling difficult conversations</li><li>Characteristics of a trusted advisor</li></ul><h3>Communication Best Practices</h3><ul><li>Attunement and active listening</li><li>Exercise: Identifying Effective Techniques</li><li>Communication pitfalls and best practices</li><li>Building rapport and influence</li><li>Words of wisdom</li><li>Exercise: Reflection on Challenges</li></ul><h3>Negotiation Strategies</h3><ul><li>Negotiation basics</li><li>Five phases of negotiation</li><li>Identifying different strategies</li><li>Traditional versus Progressive</li><li>Hard - Soft - Principled</li><li>Exercise: Your Preferred Techniques</li><li>Selecting appropriate strategy for project negotiations</li><li>Common pitfalls to avoid</li><li>The impact of culture on negotiation</li><li>Looking at conflict through the lens of negotiation</li><li>Exercise: Mapping a Resolution</li></ul>


                </section>

The Art of Negotiation: In-House Training

<p id="isPasted"><strong><span>Course Overview:</span></strong></p><p><span>The "An Understanding of Dysphagia and Safe Swallowing" course is designed to equip healthcare professionals with the necessary knowledge and skills to assess, manage, and support individuals with dysphagia - a condition characterised by difficulty swallowing. Dysphagia poses challenges that can lead to aspiration, malnutrition, and reduced quality of life. This course provides a comprehensive exploration of dysphagia, its underlying causes, assessment methods, and strategies for safe swallowing.</span></p><p><span><br /></span></p><p><span><strong>Course Duration:</strong> </span></p><p><span>1/2 day (3 hours)</span></p><p><span><br /></span></p><p><span><strong>Course Content:</strong></span></p><p><span>By the end of this course, participants will be able to:</span></p><p id="isPasted"><span>1. List the causes of dysphagia</span></p><p><span>2. Describe the signs and symptoms of dysphagia</span></p><p><span>3. Outline the professionals involved in the management of dysphagia </span></p><p><span>4. Describe the interventions and management strategies for dysphagia including IDDSI</span></p><p><span>5. Explain how to promote safe swallowing</span></p><p><span>6. Summarise the management of a casualty choking</span></p><p><span><br /></span></p><p id="isPasted"><span><strong>Course Objectives:</strong></span></p><p><span>1. Recognise the importance of dysphagia management: Understand the significance of identifying and managing dysphagia to prevent complications such as aspiration, malnutrition, and pneumonia.</span></p><p><span>2. Learn about dysphagia causes and types: Familiarise yourself with the different causes and types of dysphagia, including neurological, structural, and functional factors.</span></p><p><span>3. Acquire skills in dysphagia assessment: Develop hands-on skills in assessing swallowing difficulties, including observation, patient history, and using tools like modified barium swallow studies.</span></p><p><span>4. Understand safe swallowing practices: Learn evidence-based techniques and strategies to promote safe swallowing and reduce the risk of aspiration during oral intake.</span></p><p><span>5. Address diet modifications and feeding techniques: Gain knowledge about modifying food consistencies and textures, as well as using adaptive feeding techniques to meet patients' nutritional needs.</span></p><p><span>6. Develop communication skills: Learn effective communication techniques to educate patients, caregivers, and family members about dysphagia management, safe swallowing practices, and the importance of compliance.</span></p><p><span>7. Address ethical considerations: Explore ethical issues related to patient autonomy, informed consent, and providing care with sensitivity, respect, and empathy.</span></p><p><span>8. Collaborative care: Understand the importance of interdisciplinary collaboration in dysphagia management, including working with speech therapists, dietitians, and other healthcare professionals.</span></p><p><span><br /></span></p><p><span><strong>Assessment and Certification:</strong></span></p><p><span>Participants will undergo both a written assessment and a practical evaluation of their skills. Successful completion will result in a certification of achievement in "An Understanding of Dysphagia and Safe Swallowing."</span></p><p id="isPasted"><span><strong><span>Note: This course overview is a general guideline and can be customised to suit specific local requirements and preferences, therefore, we recommend that you contact us to discuss your requirements prior to making a booking.</span></strong></span></p>

Guardian Angels Training

Gain the knowledge and skills to assess, manage, and support individuals with dysphagia through our comprehensive "Understanding Dysphagia and Safe Swallowing" course. Learn about its causes, assessment methods, and strategies for safe swallowing.

An Understanding of Dysphagia and Safe Swallowing

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Educators providing Courses in Belfast

Courses matching "sensitivity"

Financial Modelling for Budgeting and Forecasting in Excel

By GBA Corporate

Fibre optic cabling for engineers

By Systems & Network Training

Better Business Cases Foundation & Practitioner: In-House

By IIL Europe Ltd

Neurodiversity Workshop Awareness: Signs, Strengths, Struggles

By Mpi Learning - Professional Learning And Development Provider

MySQL foundation

By Systems & Network Training

Emotional Intelligence: In-House Training

By IIL Europe Ltd

Better Business Cases Practitioner: In-House Training

By IIL Europe Ltd

The Art of Negotiation: In-House Training

By IIL Europe Ltd

An Understanding of Dysphagia and Safe Swallowing

By Guardian Angels Training

MySQL for developers

By Systems & Network Training

Search By Location