Name: SQL for Data Science, Data Analytics and Data Visualization
Price: 10.99 GBP
Availability: InStock

<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;">Overview
</h2></div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">This comprehensive course on </span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Introduction to Dog Breeds and Basic Anatomy</span></strong> will deepen your understanding on this topic.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">After successful completion of this course you can acquire the required skills in this sector. This </span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Introduction to Dog Breeds and Basic Anatomy</strong> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">So enrol in this course today to fast track your career ladder.</span></span></p></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
</div>
</div>
</div>
</div>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;">How will I get my certificate?</h2></div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p></div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;">Who is This course for?</h2></div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">There is no experience or previous qualifications required for enrolment on this </span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Introduction to Dog Breeds and Basic Anatomy</span></strong>. It is available to all students, of all academic backgrounds.</p></div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;">Requirements</h2></div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Our </span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Introduction to Dog Breeds and Basic Anatomy</span></strong> is fully compatible with PC&#39;s, Mac&#39;s, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p></div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;">Career Path</h2></div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Open doors of opportunities</li><li fr-original-style="" style="box-sizing: border-box;">Increase your adaptability</li><li fr-original-style="" style="box-sizing: border-box;">Keep you relevant</li><li fr-original-style="" style="box-sizing: border-box;">Boost confidence</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">And much more!</p></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
</div>
</div>
</div> <h3 fr-original-style="" style="box-sizing: border-box;">Course Curriculum</h3><div fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">5 sections &bull; 5 lectures &bull; 01:04:00 total length</p></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull;Understanding Basic Dog Anatomy: 00:12:00</p></div></div></div></div></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull;Different Dog Breeds Toy Group and Working Group: 00:11:00</p></div></div></div></div></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull;Herding Group and Hound Group: 00:14:00</p></div></div></div></div></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull;Different Dog Breeds Terrier Group and Sporting Group: 00:14:00</p></div></div></div></div></div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull;Non-Sporting Group and Mixed Breeds: 00:13:00</p></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Dog First Aid

Accredited Dog

Institute of Modern Dog Trainers (IMDT)

Canine Behaviour

Trainers Course

Working Dog

Introduction to Dog Breeds and Basic Anatomy

General Admission

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>This comprehensive course on <strong>Mechanical Engineering</strong> will deepen your understanding on this topic.</p><p>After successful completion of this course you can acquire the required skills in this sector. This <strong>Mechanical Engineering</strong> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</p><p>So enrol in this course today to fast track your career ladder.</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>There is no experience or previous qualifications required for enrolment on this <strong>Mechanical Engineering</strong>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Our <strong>Mechanical Engineering</strong> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</span></p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>14 sections • 68 lectures • 07:29:00 total length</p></div><div><div><div><div><div><div><div><p>•Lecture 1 Introduction: 00:02:00</p></div><div><div><p>•Lecture 2 Multiplying any digit number by 11, 22, and 33: 00:09:00</p></div><div><div><p>•Lecture 3 Integers and ordering of integers: 00:06:00</p></div><div><div><p>•: 00:00:00</p></div><div><div><p>•Lecture 5 Operations on Integers: 00:04:00</p></div><div><div><p>•Lecture 6 Multiplication and Division of Integers: 00:04:00</p></div><div><div><p>•Lecture 7 Powers of Integers (Exponents): 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 8 Complete knowledge about factors and multiples: 00:06:00</p></div><div><div><p>•Lecture 9 Divisibility tests for 2,3,4,5,6: 00:07:00</p></div><div><div><p>•Lecture 10 Divisibility rules 7,8,9,10,11: 00:06:00</p></div><div><div><p>•Lecture 11 Prime Factorization: 00:06:00</p></div><div><div><p>•Lecture 12 Highest Common Factor HCF: 00:10:00</p></div><div><div><p>•Lecture 13 Least Common Multiple LCM: 00:16:00</p></div><div><div><p>•Lecture 14 Relation between LCM and HCF: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 15 Classification of Fractions: 00:04:00</p></div><div><div><p>•Lecture 16 Convert mixed to improper and improper to mixed fractions: 00:03:00</p></div><div><div><p>•Lecture 17 Equivalent Fractions: 00:04:00</p></div><div><div><p>•Lecture 18 Comparing Fractions after converting to like fractions: 00:09:00</p></div><div><div><p>•Lecture 19 Reducing a fraction to lowest term: 00:04:00</p></div><div><div><p>•Lecture 20 Addition and subtraction OF fractions: 00:08:00</p></div><div><div><p>•Lecture 21 Multiplication and division of fractions: 00:11:00</p></div><div><div><p>•Lecture 22 Word problems on fractions: 00:16:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 23 BODMAS and rules to remove brackets: 00:03:00</p></div><div><div><p>•Lecture 24 Simplify expressions using BODMAS rules: 00:05:00</p></div><div><div><p>•Lecture 25 Simplify expressions involving fractions using BODMAS: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 26 Decimal numbers in relation to fractions: 00:08:00</p></div><div><div><p>•Lecture 27 Like and unlike Decimals: 00:05:00</p></div><div><div><p>•Lecture 28 Ordering of Decimal numbers: 00:10:00</p></div><div><div><p>•Lecture 29 Addition and subtraction of Decimal: 00:07:00</p></div><div><div><p>•Lecture 30 Multiplication of Decimal: 00:03:00</p></div><div><div><p>•Lecture 31 Division of Decimal: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 32 Rational number: 00:02:00</p></div><div><div><p>•Lecture 33 Representation of Rational Numbers on Number line: 00:04:00</p></div><div><div><p>•Lecture 34 Determining which fraction is terminating or non terminating: 00:05:00</p></div><div><div><p>•Lecture 35 shortcut method of writing decimal expansion of fraction to decimal: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 36 Rounding to whole number: 00:06:00</p></div><div><div><p>•Lecture 37 Rounding to required number of decimals (1 d.p. ): 00:05:00</p></div><div><div><p>•Lecture 38 rounding to significant digits: 00:07:00</p></div><div><div><p>•Lecture 39 Practice question on three methods of approximation: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 40 Estimation: 00:05:00</p></div><div><div><p>•Lecture 41 Scientific Notation: 00:07:00</p></div><div><div><p>•Lecture 42 Operation on numbers when they are in scientific notation: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 43 Percentage to fraction and fraction to percentage: 00:06:00</p></div><div><div><p>•Lecture 44 Percentage of a quantity and conversation to decimal: 00:06:00</p></div><div><div><p>•Lecture 45 Expressing one quantity as percentage of another quantity: 00:06:00</p></div><div><div><p>•Lecture 46 Finding increase decrease percent: 00:05:00</p></div><div><div><p>•Lecture 47 Uses of percentages-Word Problems: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 48 Ratio- How to express as simple ratio: 00:09:00</p></div><div><div><p>•Lecture 49 How to compare Ratios: 00:04:00</p></div><div><div><p>•Lecture 50 Word problems on finding ratios: 00:07:00</p></div><div><div><p>•Lecture 51To divide a given quantity into a given Ratio: 00:11:00</p></div><div><div><p>•Lecture 52 Proportion: 00:04:00</p></div><div><div><p>•Lecture 53 Practice problems on Proportion: 00:06:00</p></div><div><div><p>•Lecture 54 Continued proportion: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 55 Direct Variation ( or proportion): 00:04:00</p></div><div><div><p>•Lecture 56 Problems based on Direct proportion: 00:10:00</p></div><div><div><p>•Lecture 57 Inverse Variation ( or proportion): 00:10:00</p></div><div><div><p>•Lecture 58 Multiple Ratios: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 59 Basics - Profit and Loss: 00:04:00</p></div><div><div><p>•Lecture 60 More practice problems on Profit &amp; Loss: 00:06:00</p></div><div><div><p>•Lecture 61 Selling price formula and Problems: 00:04:00</p></div><div><div><p>•Lecture 62 Cost price formula and Problems: 00:03:00</p></div><div><div><p>•Lecture 63 Higher problems on Profit and Loss: 00:08:00</p></div><div><div><p>•Lecture 64 Basics - Discount.mp4: 00:05:00</p></div><div><div><p>•Lecture 65 Practice problems on Discount: 00:04:00</p></div><div><div><p>•Lecture 66 Tax: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Mock Exam - Functional Skills Maths Teacher: 00:20:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Final Exam - Functional Skills Maths Teacher: 00:20:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Mechanical Engineering

Computing Skills

Maths Teacher

Further Maths

Computer Skills

Professional Skills Course (PSC)

Functional Skills Maths Teacher

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on <strong>Content Writing &amp; Copy Writing For SEO and Sales</strong></span> will deepen your understanding on this topic.</p><p><span><span>After successful completion of this course you can acquire the required skills in this sector. This <strong>Content Writing &amp; Copy Writing For </strong></span></span><strong><span>SEO</span><span> and Sales</span></strong><span> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this <strong>Content Writing &amp; Copy Writing For SEO and Sales</strong></span>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our <strong>Content Writing &amp; Copy Writing For SEO and Sales</strong></span> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p><span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</span></p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>18 sections • 65 lectures • 05:34:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:05:00</p></div><div><div><p>•How to Navigate This Course - Watch This Video: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•13 Copywriting and Sales Buttons You Need to Know How to Push: 00:07:00</p></div><div><div><p>•Copywriting to Sell 10 Steps you must know: 00:06:00</p></div><div><div><p>•14 Step Formula to Writing Great Sales Copy: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•AIDA is not just an Opera!: 00:02:00</p></div><div><div><p>•Have you any idea who you are talking to?: 00:02:00</p></div><div><div><p>•Who cares what format you use?: 00:03:00</p></div><div><div><p>•Hurting? Want someone to heal your pain?: 00:02:00</p></div><div><div><p>•I haven't got time or money for Objections!: 00:02:00</p></div><div><div><p>•Don't worry, there's always plenty of Scarcity to go round!: 00:02:00</p></div><div><div><p>•So, why are YOU reading my Headlines?: 00:02:00</p></div><div><div><p>•Why do you always want to know whats in it for you?: 00:02:00</p></div><div><div><p>•Endorsements? Pah! Prove it to me!: 00:03:00</p></div><div><div><p>•I Guarantee to you that I love Risk! Or do I?: 00:02:00</p></div><div><div><p>•Right it Wright to Be Red! or you won't be Readable!: 00:03:00</p></div><div><div><p>•Keep it Simple S. and throw away your Theasaurus: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Copywriting Formulation: 00:02:00</p></div><div><div><p>•Starting with AIDA: 00:06:00</p></div><div><div><p>•PAS - Problem, Agitation, Solution: 00:00:00</p></div><div><div><p>•The 4 Ps: 00:03:00</p></div><div><div><p>•QUEST: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•What You Need to Know to Write Great Headlines: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Writing Editing: Can You Write Better Copy?: 00:06:00</p></div><div><div><p>•Proof Reading and Editing: 20 Ways to Write Better Copy: 00:11:00</p></div><div><div><p>•Editing Writing: Seven Guidelines for Editing Writing: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Get Your Copywriting Psychology Right!: 00:06:00</p></div><div><div><p>•What are the Eight Universal Motivators?: 00:07:00</p></div><div><div><p>•100-Motivations-for-People-to-Buy: 00:06:00</p></div><div><div><p>•Overcoming Objections: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Copywriting for Blogs: 00:07:00</p></div><div><div><p>•A Simple Formula for Blog Posts: 00:04:00</p></div><div><div><p>•Blog Post Copywriting Formula: 00:09:00</p></div><div><div><p>•Blog Post Editing Checklist: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Copywriting for Landing Pages: 00:04:00</p></div><div><div><p>•Copywriting for Testimonials: 00:06:00</p></div><div><div><p>•Copywriting for Bullet Points: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Five Formulations for Sales Letters: 00:03:00</p></div><div><div><p>•The Five Point Sales Letter Formula: 00:03:00</p></div><div><div><p>•The Seven Step Copywriting Formula for Sales Letters: 00:05:00</p></div><div><div><p>•The Nine Point Formula: 00:06:00</p></div><div><div><p>•The 18 Step Sales Letter: 00:06:00</p></div><div><div><p>•The 21 Part Sales Letter Formula: 00:08:00</p></div><div><div><p>•Bonus: 32 Step Power Copywriting Formula: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•What is a Video Sales Letter: 00:03:00</p></div><div><div><p>•How to Write an Attention Grabbing Video Sales Letter Headline: 00:03:00</p></div><div><div><p>•Video Sales Letter Basics - Some Simple Guidance for Better VSLs: 00:04:00</p></div><div><div><p>•Video Sales Letter Outline - with Downloadable Templates: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Copywriting for Email: 00:07:00</p></div><div><div><p>•How to Write Effective Welcome Emails: 00:10:00</p></div><div><div><p>•ACTIVITY: Analysis of a Long Form Story Telling Email: 00:07:00</p></div><div><div><p>•Email Copywriting Analysis 1: 00:05:00</p></div><div><div><p>•Copywriting Formulas for Email Sequences: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Copywriting for Advertisements: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Copywriting for Twitter - Engage, Entertain, Be Brief!: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•How to Create a High Converting Promotional Video: 00:06:00</p></div><div><div><p>•The Promotional Video for This Course Following the Script: 00:02:00</p></div><div><div><p>•The Promotional Video - Version 2: 00:02:00</p></div><div><div><p>•Promotional Video SlideDeck: 00:40:00</p></div><div><div><p>•Promotional Video Script Checklist: 00:04:00</p></div><div><div><p>•2018 Update: The Formula for an Effective Promotional Video: 00:04:00</p></div><div><div><p>•2018 New Copywriting Course Promo Video: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Conclusion and Course Wrap Up: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Additional File: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Content Writing &amp; Copy Writing For SEO and Sales: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Online Course Marketing

Online Course Creation

Seo Copywriting

Content Writing

Writing Skills

Resume & CV Writing

Content Writing & Copy Writing For SEO and Sales

Course Gate

Office Skills & Productivity

Administrative Assistant

Office Skills

Office Management

Office Administration

Business Admin

Support Assistant

Admin Support Diploma

Adobe Photoshop

Photo Editing

Image Editing

Photography Tools

Adobe Premiere Pro

Adobe Lightroom

Lightroom

Adobe Lightroom Complete Training

Child Safeguarding

Care Home Advocate

Safeguarding

Health & Social Care

FA Level 1

Online Safeguarding

Social Care

Adult Safeguarding Level 3

Property Management

Estate Agent

Letting Agent

Bar Professional Training Course (BPTC)

Property Development

Real Estate Marketing

Property Administrator Training

Certificate in Further Education & Training (Cert Ed)

Complementary Therapy

Holistic Medicine

Alternative Medicine

Natural Medicine

Herbal Medicine

Medical Herbalist

Nursing Diploma

Diploma in Alternative Medicine

Art Teacher

City & Guilds

Painting

Painting & Decorating

Fine Art

Painting Skills & Techniques

Diploma in Professional Studies (DPS)

Diploma in Art and Painting

<div>
<div>
<div>
<div>
<div>
<div>
<p>This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals.</p>
<h3><strong>Learning Outcomes:</strong></h3>
<ul>
<li>Set up and configure SQL Server and SQL Azure Data Studio for data analysis.</li>
<li>Master SQL statements for data manipulation, data structure, and user management.</li>
<li>Utilize SQL queries, joins, and aggregate functions for efficient data analysis.</li>
<li>Understand SQL constraints, views, and advanced commands for in-depth data exploration.</li>
<li>Create and implement SQL stored procedures to automate tasks.</li>
<li>Leverage Azure Data Studio for data visualization and perform data analysis with SQL.</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
<h3><b>Why buy this SQL for Data Science, Data Analytics and Data Visualization?</b></h3>
<ol>
<li><span>Unlimited access to the course for forever</span></li>
<li><b>Digital Certificate, Transcript, student ID</b><span> all included in the price</span></li>
<li><span>Absolutely no hidden fees</span></li>
<li><span>Directly receive </span><b>CPD </b><span>accredited qualifications after course completion</span></li>
<li><span>Receive one to one assistance on every weekday from professionals</span></li>
<li><span>Immediately receive the PDF certificate after passing</span></li>
<li><span>Receive the original copies of your certificate and transcript on the next working day</span></li>
<li><span>Easily learn the skills and knowledge from the comfort of your home</span></li>
</ol>
<h3><b>Certification</b></h3>
<p><span>After studying the course materials of the </span><b>SQL for Data Science, Data Analytics and Data Visualization</b><span> there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.</span></p>
<h3><b>Who is this course for?</b></h3>
<p><span>This </span><b>SQL for Data Science, Data Analytics and Data Visualization</b><span> course is ideal for</span></p>
<ul>
<li><span>Students</span></li>
<li><span>Recent graduates</span></li>
<li><span>Job Seekers</span></li>
<li><span>Anyone interested in this topic</span></li>
<li><span>People already working in the relevant fields and want to polish their knowledge and skill.</span></li>
</ul>
<h3><b>Prerequisites</b></h3>
<p><span>This </span><b>SQL for Data Science, Data Analytics and Data Visualization</b><span> does not require you to have any prior qualifications or experience. You can just enrol and start learning.This </span><b>SQL for Data Science, Data Analytics and Data Visualization</b><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p>
<h3><b>Career path</b></h3>
<p><span>As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This </span><b>SQL for Data Science, Data Analytics and Data Visualization </b><span>is a great way for you to gain multiple skills from the comfort of your home.</span></p><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Section 01: Getting Started</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to get course requirements</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Getting started on Windows, Linux or Docker</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to ask great questions</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>FAQ's</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 02: SQL Server setting up</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Microsoft SQL Server Installation</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Server Management Studio (SSMS) Installation</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to connect MS SQL (Windows Authentication)</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to connect MS SQL (SQL Server Authentication)</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download and Restore Sample Database</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 03: SQL Azure Data Studio</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is Azure Data Studio</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Azure Data Studio Installation steps</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Azure Data Studio to Connect SQL Server</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Database</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Table</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Data rows</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>View the Data returned by Query</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 04: SQL Database basic SSMS</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of Databases8</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Database</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Data Types</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Column Data Types on SSMS</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Table</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of Primary Key and Foreign Key</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Primary Key</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Foreign Key</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Temporary tables</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 05: SQL Statements for DATA</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert statement</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Update statement</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Delete statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 06: SQL Data Structure statements</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>CREATE table statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DROP statement</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>ALTER statement</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>TRUNCATE statement</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>COMMENT in query</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>RENAME</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 07: SQL User Management</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Database user</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>GRANT permissions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>REVOKE permissions</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 08: SQL Statement Basic</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Statement basic</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT Statement</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT DISTINCT</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT with column headings</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Column AS statement</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 09: Filtering Data rows</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT WHERE Clause - theory</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT WHERE Clause - practical</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 10: Aggregate functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sum()</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Min()-Max()</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 11: SQL Query statements</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order By statement</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT TOP clause in SQL</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>BETWEEN command</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>IN operator</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wildcard Characters and LIKE</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 12: SQL Group by statement</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Group by - theory8</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Group by - practical</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>HAVING statement</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 13: JOINS for Multiple table Data Analysis</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of Joins</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What are Joins</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inner join</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Left outer join</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Right outer join</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Full outer join</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Union</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Cartesian Product with the Cross Join</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Query Exercise</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Solution for Query Exercise</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 14: SQL Constraints</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Check constraint</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NOT NULL constraint</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>UNIQUE constraint</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 15: Views</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Views</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Reporting with multiple tables</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 16: Advanced SQL commands</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Timestamp</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Extract from timestamp</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mathematical scalar functions</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>String functions</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sub Query</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT with calculations</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 17: SQL Stored procedures</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create stored procedure</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Stored procedure with parameter</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 18: Azure Data Studio Visualization</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installing SandDance Extension</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Visualization Charts</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Multiple Table Data Charts</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 19: Azure Studio SQL for Data Analysis</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Type Decision for Data Analysis</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Analysis with Case Statement and String Text</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 20: Import &amp; Export data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Import Flat File</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Import .csv or excel file</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Export Data to Excel or any format</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 21: Backup and Restore Database</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Database backup</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Restoring Database backup</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Azure SQL Database

Microsoft SQL Server

Microsoft SQL

Data Skills

SQL Server

Data Studio

SQL for Data Science, Data Analytics and Data Visualization

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p></p><p>The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.</p><p></p>Overview<p>Describe core data concepts Identify considerations for relational data on Azure Describe considerations for working with non-relational data on Azure Describe an analytics workload on Azure</p><p></p><p>In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization.</p><p></p></div><div id="course-pills-2"><h3>1 - Explore core data concepts</h3> <ul> <li>Identify data formats</li> <li>Explore file storage</li> <li>Explore databases</li> <li>Explore transactional data processing</li> <li>Explore analytical data processing</li> </ul> <h3>2 - Explore data roles and services</h3> <ul> <li>Explore job roles in the world of data</li> <li>Identify data services</li> </ul> <h3>3 - Explore fundamental relational data concepts</h3> <ul> <li>Understand relational data</li> <li>Understand normalization</li> <li>Explore SQL</li> <li>Describe database objects</li> </ul> <h3>4 - Explore relational database services in Azure</h3> <ul> <li>Describe Azure SQL services and capabilities</li> <li>Describe Azure services for open-source databases</li> </ul> <h3>5 - Explore Azure Storage for non-relational data</h3> <ul> <li>Explore Azure blob storage</li> <li>Explore Azure DataLake Storage Gen2</li> <li>Explore Azure Files</li> <li>Explore Azure Tables</li> </ul> <h3>6 - Explore fundamentals of Azure Cosmos DB</h3> <ul> <li>Describe Azure Cosmos DB</li> <li>Identify Azure Cosmos DB APIs</li> </ul> <h3>7 - Explore fundamentals of large-scale data warehousing</h3> <ul> <li>Describe data warehousing architecture</li> <li>Explore data ingestion pipelines</li> <li>Explore analytical data stores</li> </ul> <h3>8 - Explore fundamentals of real-time analytics</h3> <ul> <li>Understand batch and stream processing</li> <li>Explore common elements of stream processing architecture</li> <li>Explore Azure Stream Analytics</li> <li>Explore Apache Spark on Microsoft Azure</li> </ul> <h3>9 - Explore fundamentals of data visualization</h3> <ul> <li>Describe Power BI tools and workflow</li> <li>Describe core concepts of data modeling</li> <li>Describe considerations for data visualization</li> </ul></div>

Nexus Human

Microsoft AZ-900

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

DP-900T00 Microsoft Azure Data Fundamentals

Manchester

Slough

Portsmouth

Bingley

Cardiff

Milton Keynes 

Nottingham

Birmingham

Bedford

<div data-testid="richTextElement" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">ONLINE STUDY - In your own time (approx. 6 hours study time) +</span></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Awarding Body:</strong>&nbsp;Open College Network (OCN) Credit for Learning</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Award Level:</strong>&nbsp;Level 3 (Advanced Level) - Ireland Level 5</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPD Certified:</strong>&nbsp;Yes (CPD Accreditation)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Minimum Age:&nbsp;</strong>18 (16 with parental consent)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry requirements:&nbsp;</strong>None. (English Level 2 desirable)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Training Locations:</strong>&nbsp;Study online + Classroom</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><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);">OCN Accredited at UK Level 3 (Ireland Level 5)</span><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 1 - Theory:</strong>&nbsp;Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 2 - Skills and Practical Development:</strong><br fr-original-style="" style="box-sizing: border-box;">Safely and competently set up and maintain a Peripheral IV Infusion.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Attend a classroom location to complete your practical training.<br fr-original-style="" style="box-sizing: border-box;"></strong></p><div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></p></div><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Itinerary:</strong></div><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></div><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 1 - THEORY (ONLINE)</strong><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M1 - Peripheral IV Cannulation - Introduction:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Definitions - understanding terminology relating to PIVC.<br fr-original-style="" style="box-sizing: border-box;">IV Therapy and NMC guidelines.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M2 - Legal &amp; Professional Responsibilities:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Legal Obligations and Accountability. Criminal, Civil and<br fr-original-style="" style="box-sizing: border-box;">Contractual law in Healthcare. Vicarious Liability and your<br fr-original-style="" style="box-sizing: border-box;">Duty of Care.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M3 - Anatomy &amp; Physiology:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Sites appropriate to IV cannulation. Hand vs. arm.<br fr-original-style="" style="box-sizing: border-box;">Advantages and disadvantages of relevant veins.<br fr-original-style="" style="box-sizing: border-box;">An overview of Homeostasis and Fluid Balance.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M4 - Hygiene and Infection Prevention &amp; Control (IPC):</strong></span><br fr-original-style="" style="box-sizing: border-box;">Reducing healthcare-associated infections. Keeping Safe.<br fr-original-style="" style="box-sizing: border-box;">Bloodborne Pathogens and Work Practice Controls.<br fr-original-style="" style="box-sizing: border-box;">Standard Precautions. Waste Disposal. Needle-stick injuries.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M5 - Indications and Advantages:</strong></span><br fr-original-style="" style="box-sizing: border-box;">When to cannulate, infusion types and benefits over<br fr-original-style="" style="box-sizing: border-box;">alternative infusion routes. Continuous and intermittent infusion.<br fr-original-style="" style="box-sizing: border-box;">Prophylactic use before procedures and in unstable patients.<br fr-original-style="" style="box-sizing: border-box;">Contraindications.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M6 - Equipment:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Cannula types, sizes and colour coding. How to select<br fr-original-style="" style="box-sizing: border-box;">appropriate size. Equipment overview for total procedure.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M7 - Vein Choice for Cannulation:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Correct vein selection. Which veins to avoid.<br fr-original-style="" style="box-sizing: border-box;">How to manage an unsuccessful cannulation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8 - Procedures:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Full procedure for cannulation including correct documentation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8: Guide to Cannulation - revision</strong></span><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8: Video - Recap with full procedure</strong></span><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M9 - Contraindications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">When inappropriate to cannulate including patients with specific health conditions.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M10 - Complications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">A detailed look at potential complications during and after<br fr-original-style="" style="box-sizing: border-box;">cannulation, including phlebitis, infections, petechiae and haematomas. Clinical signs and corrective actions.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED</strong><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">BEFORE JOINING US FOR YOUR PRACTICAL TRAINING</strong><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART 2 (CLASSROOM:</span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></strong><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">1 - Welcome, introductions and overview:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Classroom - registration and introductions.<br fr-original-style="" style="box-sizing: border-box;">Virtual Classroom - audio/visual checks and registration.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">2 - Legal &amp; Professional Responsibilities:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Overview and discussion.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">3 - Anatomy - key points (appropriate to PIVC):</strong></span><br fr-original-style="" style="box-sizing: border-box;">Arteries and veins. Selecting an approprate site. Sites to avoid and &ldquo;first choice&rdquo; sites.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">4 - Cannulae - selection and types:</strong></span><br fr-original-style="" style="box-sizing: border-box;">A detailed look at different types of cannulas, respective benefits and attributes. Selectinng an appropriate pVAD.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">5 - Complications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Complications of pVAD insertion including examples of<br fr-original-style="" style="box-sizing: border-box;">infiltration, haematoma, extravasation and transfixation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">6 - VIP Score:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Understanding and using the Visual Infusion Phlebitis score.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">7 - Equipment - overview:</strong></span><br fr-original-style="" style="box-sizing: border-box;">We take a look at all essential equipment required for PIVC.<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">8 - PRACTICAL SESSIONS:</strong><br fr-original-style="" style="box-sizing: border-box;">Multiple practical sessions throughout the session.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">9 - Fluids:</strong></span><br fr-original-style="" style="box-sizing: border-box;">The importance of understanding fluids. Includes detailed overview of: maintenance fluids, Hartmann&rsquo;s solution, Colloids (and risks), blood products.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">10 - Infusion Rates:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Calculating infusion rates and drops per minute.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.</em></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)</strong></em></p></div></div><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>

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



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

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

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


Attend a classroom location to complete your practical training.


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


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

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

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

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



Geopace Training

Allied Health Professions (AHP)

Intravenous Cannulation

Aesthetics

Medicine & Nursing

Venepuncture & Cannulation

Learn how to cannulate ...

    Nationally Recognised Qualification

    OCN Accredited - Level 3 (advanced) - Ireland Level 5

    CPD Accredited - The CPD Certification Service

    Classroom or Virtual Classroom options

    Covers all steps for cannulating in arm or hand

    Practise on artificial arms and fake blood!

    Essential qualification for all IV therapies

    Phlebotomy training desirable but not essential

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Peripheral I.V. Cannulation Course (GPT008)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for anyone seeking CCNA certification. The course also provides foundational knowledge for all support technicians involved in the basic installation, operation, and verification of Cisco networks. The job roles best suited to the material in this course are:<br />Entry-level network engineer<br />Network administrator<br />Network support technician<br />Help desk technician</p>Overview<p>This course will help you:<br />Learn the knowledge and skills to install, configure, and operate a small- to medium-sized network<br />Gain a foundation in the essentials of networking, security, and automation<br />Earn 30 CE credits toward recertification</p><p>The Implementing and Administering Cisco Solutions (CCNA) v2.0 course gives you a broad range of fundamental knowledge for all IT careers. Through a combination of lecture, hands-on labs, and self-study, you will learn how to install, operate, configure, and verify basic IPv4 and IPv6 networks. The course covers configuring network components such as switches, routers, and wireless LAN controllers; managing network devices; and identifying basic security threats. The course also gives you a foundation in network programmability, automation, and software-defined networking. This course helps you prepare to take the 200-301 CiscoÂ© Certified Network Associate (CCNAÂ©) exam. By passing this one exam, you earn the CCNA certification. This course also earns you 30 Continuing Education (CE) credits towards recertification.</p></div><div id="course-pills-2"><h4>Course Outline </h4><ul><li>Exploring the Functions of Networking ? Lecture</li><li>Introducing the Host-to-Host Communications Model ? Lecture</li><li>Operating Cisco IOS Software ? Lecture</li><li>Introducing LANs ? Lecture</li><li>Exploring the TCP/IP Link Layer ? Lecture</li><li>Starting a Switch ? Lecture</li><li>Introducing the TCP/IP Internet Layer, IPv4 Addressing, and Subnets ? Lecture</li><li>Explaining the TCP/IP Transport Layer and Application Layer ? Lecture</li><li>Exploring the Functions of Routing ? Lecture</li><li>Configuring a Cisco Router ? Lecture</li><li>Exploring the Packet Delivery Process ? Lecture</li><li>Troubleshooting a Simple Network ? Lecture</li><li>Introducing Basic IPv6 ? Lecture</li><li>Configuring Static Routing ? Lecture</li><li>Implementing VLANs and Trunks ? Lecture</li><li>Routing Between VLANs ? Lecture</li><li>Introducing OSPF ? Lecture</li><li>Building Redundant Switched Topologies ? Self-study</li><li>Improving Redundant Switched Topologies with EtherChannel ? Lecture</li><li>Exploring Layer 3 Redundancy ? Self-study</li><li>Introducing WAN Technologies ? Self-study</li><li>Explaining Basics of ACL ? Lecture</li><li>Enabling Internet Connectivity ? Lecture</li><li>Introducing QoS ? Self-study</li><li>Explaining Wireless Fundamentals ? Self-study</li><li>Introducing Architectures and Virtualization ? Self-study</li><li>Explaining the Evolution of Intelligent Networks ? Lecture</li><li>Introducing System Monitoring ? Lecture</li><li>Managing Cisco Devices ? Lecture</li><li>Examining the Security Threat Landscape ? Self-study</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) 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 Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) 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>

Cisco Certified Network Associate (CCNA)

Certified in Cybersecurity (CC)

Cisco Certified Network Professional certification (CCNP)

CompTIA Network+

Cisco Certified Entry Networking Technician (CCENT)

Cisco Certified Internetwork Expert (CCIE)

Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.</p>Overview<p>After completing this course, students will be able to:<br />Create a technical design<br />Configure Common Data Service<br />Create and configure Power Apps<br />Configure business process automation<br />Extend the user experience<br />Extend the platform<br />Develop Integrations</p><p>The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.</p></div><div id="course-pills-2"><h4>Create a model-driven application in Power Apps</h4><ul><li>This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.</li></ul><h4>Get started using Common Data Service</h4><ul><li>This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.</li></ul><h4>Create a canvas app in Power Apps</h4><ul><li>This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.</li></ul><h4>Automate a business process using Power Automate</h4><ul><li>This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.</li></ul><h4>Create a business process flow in Power Automate</h4><ul><li>This module introduces you to creating business process flows in Power Automate</li></ul><h4>Introduction to developing with Power Platform</h4><ul><li>This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform</li></ul><h4>Extending the Power Platform user experience Model Driven apps</h4><ul><li>This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.</li></ul><h4>Create components with Power Apps Component Framework</h4><ul><li>This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.</li></ul><h4>Extending the Power Platform Common Data Service</h4><ul><li>This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.</li></ul><h4>Integrate with Power Platform and Common Data Service</h4><ul><li>This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.</li></ul><h4>Extend Power Apps portals</h4><ul><li>This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-400T00 Microsoft Power Platform Developer 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 PL-400T00 Microsoft Power Platform Developer 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 PL-900

Microsoft Power Apps

Power Apps

Microsoft Power Platform

Microsoft Power Automate

PL-400T00 Microsoft Power Platform Developer

Microsoft Certification

Microsoft 365

MS-102T00 Microsoft 365 Administrator Essentials

Hayes

Research Quality Association

Good Clinical Practice Auditing - Principles and Practice

RQA Member

Non Member

Broxburn

<h3 style="color: rgb(6, 49, 77); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(6, 49, 77);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Online courses take 5 days and are spread over two weeks.</strong></h3><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">2024 Dates:&nbsp;</u></strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">October </strong>Week 1 - 14th, 15th, 16th / Week 2 - 23rd &amp; 24th&nbsp;</p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">2025 Dates:</u>&nbsp;</strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">January&nbsp;</strong>Week 1 - <span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">13th, 14th 15th /&nbsp;</span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">January&nbsp;</strong>Week 2 - <span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">20th &amp; 21st</span></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">April&nbsp;</strong>Week 1 - <span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">22nd, 23rd</span><span dir="ltr" fr-original-style="" style="box-sizing: border-box;">&nbsp;&amp; 24th / <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">April&nbsp;</strong></span>Week 2 - <span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">29th &amp; 30th</span></p><p id="isPasted" style="color: rgb(6, 49, 77); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(6, 49, 77);">Ember Compliance is delighted to offer a new FD&amp;FA BS5839-1 RQF Certified 5-Day Combined Course which encompasses all our FD&amp;FA courses from Introduction to Maintenance complete with RQF Exam at the end of the week.</p><p style="color: rgb(6, 49, 77); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(6, 49, 77);">At the end of the 5 days, Learners will attain an RQF Award in the requirements of FD&amp;FA systems for non-domestic buildings BS 5839-1: 2017.</p><p style="color: rgb(6, 49, 77); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(6, 49, 77);">As an accredited training provider affiliated with FireQual, recognised by both SQA and Ofqual, our courses are meticulously designed to align with the stringent standards outlined by the BAFE SP203-1 competence scheme.&nbsp;</p><p style="color: rgb(6, 49, 77); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(6, 49, 77);">Details of the course are as follows:</p><p style="color: rgb(6, 49, 77); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(6, 49, 77);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 1: Introduction to BS 5839-1</strong><br fr-original-style="" style="box-sizing: border-box;">Learners are introduced to the requirements of BS 5839-1. This module includes basic principles of fire safety and an introduction to FD&amp;FA systems requirements within the boundaries of the various legal frameworks within the UK.<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(6, 49, 77); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(6, 49, 77);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 2: Design -BS 5839-1</strong><br fr-original-style="" style="box-sizing: border-box;">In this module, emphasis is placed on the process of fire alarm design, enquiry, survey, design, certification and the appropriate recording and documentation requirements.<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(6, 49, 77); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(6, 49, 77);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 3: Installation -BS 5839-1</strong><br fr-original-style="" style="box-sizing: border-box;">This module explores compliance with the standard and how the installer may deal with issues not known to the designer during the installation.<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(6, 49, 77); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(6, 49, 77);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 4: Commissioning - BS 5839-1</strong><br fr-original-style="" style="box-sizing: border-box;">This module explores the process of commissioning, the requirements of testing and inspecting a newly installed system and how the commissioner may deal with issues not known to the designer and/or nonconformities with the standard.</p><p style="color: rgb(6, 49, 77); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(6, 49, 77);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 5: Maintenance - BS 5839-1</strong><br fr-original-style="" style="box-sizing: border-box;">This module explores the process of maintenance, the requirements of inspection &amp; servicing existing systems and how the maintainer may deal with non-conformities with the standard.</p><p style="color: rgb(6, 49, 77); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(6, 49, 77);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Exam - L3 Award in the Requirements of FD&amp;FA Systems for Non-Domestic Buildings BS 5839-1: 2017</strong><br fr-original-style="" style="box-sizing: border-box;">The RQF examination allows learners to demonstrate knowledge of BS 5839-1: 2017 as part of competence in the design, installation, commissioning, and maintenance of FD&amp;FA systems. Learners will demonstrate knowledge gained within our previous modules and industry experience.</p><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Notes:</strong></span></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please bring a valid form of identification (such as a driving license or passport). This identification must be shown for verification purposes and recorded by our invigilator</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, please ensure that you have a non-scientific calculator with you for the exam. Calculators on phones are not permitted.</p><p style="color: rgb(6, 49, 77); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(6, 49, 77);"><img src="https://images.cademy.co.uk/88d338d8-7dc4-4054-bf9e-401495774eee/80ddaf3c-277e-490d-aad9-f53db6cf9e22/original.png" style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable"></p><h3 style="color: rgb(6, 49, 77); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(6, 49, 77);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Online courses take 5 days and are spread over two weeks.</strong></h3><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">October Dates:&nbsp;</strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);">Week 1 - 14th, 15th, 16th&nbsp;</p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);">Week 2 - 21st &amp; 22nd</p>

Online courses take 5 days and are spread over two weeks.
2024 Dates: 
October Week 1 - 14th, 15th, 16th / Week 2 - 23rd & 24th 
2025 Dates: 
January Week 1 - 13th, 14th 15th / January Week 2 - 20th & 21st
April Week 1 - 22nd, 23rd & 24th / April Week 2 - 29th & 30th
Ember Compliance is delighted to offer a new FD&FA BS5839-1 RQF Certified 5-Day Combined Course which encompasses all our FD&FA courses from Introduction to Maintenance complete with RQF Exam at the end of the week.
At the end of the 5 days, Learners will attain an RQF Award in the requirements of FD&FA systems for non-domestic buildings BS 5839-1: 2017.
As an accredited training provider affiliated with FireQual, recognised by both SQA and Ofqual, our courses are meticulously designed to align with the stringent standards outlined by the BAFE SP203-1 competence scheme. 
Details of the course are as follows:
Module 1: Introduction to BS 5839-1
Learners are introduced to the requirements of BS 5839-1. This module includes basic principles of fire safety and an introduction to FD&FA systems requirements within the boundaries of the various legal frameworks within the UK.


Module 2: Design -BS 5839-1
In this module, emphasis is placed on the process of fire alarm design, enquiry, survey, design, certification and the appropriate recording and documentation requirements.


Module 3: Installation -BS 5839-1
This module explores compliance with the standard and how the installer may deal with issues not known to the designer during the installation.


Module 4: Commissioning - BS 5839-1
This module explores the process of commissioning, the requirements of testing and inspecting a newly installed system and how the commissioner may deal with issues not known to the designer and/or nonconformities with the standard.
Module 5: Maintenance - BS 5839-1
This module explores the process of maintenance, the requirements of inspection & servicing existing systems and how the maintainer may deal with non-conformities with the standard.
Exam - L3 Award in the Requirements of FD&FA Systems for Non-Domestic Buildings BS 5839-1: 2017
The RQF examination allows learners to demonstrate knowledge of BS 5839-1: 2017 as part of competence in the design, installation, commissioning, and maintenance of FD&FA systems. Learners will demonstrate knowledge gained within our previous modules and industry experience.
Notes:
Please bring a valid form of identification (such as a driving license or passport). This identification must be shown for verification purposes and recorded by our invigilator
Additionally, please ensure that you have a non-scientific calculator with you for the exam. Calculators on phones are not permitted.

Online courses take 5 days and are spread over two weeks.
October Dates: 
Week 1 - 14th, 15th, 16th 
Week 2 - 21st & 22nd

Ember Compliance

Fire Alarm

Professional Development

Engineer

Continuous Professional Development (CPD)

At the end of the 5 days, Learners will attain an RQF Award in the requirements of FD&FA systems for non-domestic buildings BS 5839-1: 2017.

FD&FA BS5839-1 RQF Certified 5-Day Combined Course - 2 Part Course

<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 IT professionals who are responsible for planning, configuring, and managing an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). In addition, they should have a general understanding of Microsoft Exchange Server, Microsoft Teams, and Microsoft SharePoint.</p>Overview<p>Plan and provision Office 365 Manage Users and Groups in Office 365 Deploy and Configure Tools and Applications for Office 365 Plan and Manage Exchange Online Plan and Manage SharePoint Online Plan and Manage Microsoft Teams Plan and Manage other Office 365 Services Implement Security and Compliance in Office 365 Report, Monitor and Troubleshoot Office 365</p><p>This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics. <br /><br /> Although this course and the associated labs are written for Office 365 with Windows 11, the skills taught will also be backwards compatible with Windows 10. This course is based on the features available in the Office 365 E3 license as these are the core features in Office 365 and Microsoft 365 plans.</p></div><div id="course-pills-2"><h3>1 - Planning and Provisioning Office 365</h3> <ul> <li>Overview of Office 365</li> <li>Core Services of Office 365</li> <li>Requirements for an Office 365 Tenant</li> <li>Planning a Pilot and Deployment</li> <li>Creating an Office 365 Tenant</li> <li>Adding Custom Domains and Managing DNS Settings</li> <li>Lab: Provisioning Office 365</li> </ul> <h3>2 - Managing Users and Groups in Office 365</h3> <ul> <li>Managing User Accounts and Licences</li> <li>Managing Passwords and Authentication</li> <li>Create and Managing the Different Types of Groups in Office 365</li> <li>Managing Users and Groups with PowerShell</li> <li>Managing Users and Groups in the Azure AD Admin Center</li> <li>Role Based Access and Administrative Roles</li> <li>Planning and Configuring Directory Synchronization</li> <li>Lab: Managing Users and Groups in Office 365</li> <li>Lab: Planning and Configuring Directory Synchronisation</li> </ul> <h3>3 - Deploying and Configuring Tools and Applications for Office 365</h3> <ul> <li>Planning Network Configuration for Office 365 Tools and Applications</li> <li>Using the Office Configuration Tool</li> <li>Click to Run Installation Use and Control</li> <li>Managing Centralized Deployment of Tools, Applications and Add-ins</li> <li>Reporting</li> <li>Lab: Deploying and Configuring Tools and Applications for Office 365</li> </ul> <h3>4 - Planning and Managing Exchange Online</h3> <ul> <li>What is Exchange Online</li> <li>Managing Exchange Online Mailboxes</li> <li>Managing Office 365 Groups in Exchange Online</li> <li>Configuring Exchange Online Permissions</li> <li>Managing Exchange Online using PowerShell</li> <li>Plan and Configure Mail Flow</li> <li>Plan and Configure Email Protection</li> <li>Lab: Planning and Managing Exchange Online</li> </ul> <h3>5 - Planning and Managing SharePoint Online</h3> <ul> <li>What is SharePoint Online</li> <li>Understanding the relationship between SharePoint, OneDrive, Teams, and Office 365 Groups</li> <li>SharePoint Online Architecture</li> <li>Configure SharePoint Online</li> <li>Configure and Control External Sharing</li> <li>Managing SharePoint Online Site Collections</li> <li>Managing SharePoint Online using PowerShell</li> <li>Lab: Planning and Managing SharePoint Online</li> </ul> <h3>6 - Planning and Managing Microsoft Teams</h3> <ul> <li>What is Microsoft Teams</li> <li>How Microsoft Teams integrates with other Office 365 Services</li> <li>Create and Manage Organization Wide Settings</li> <li>Create, Manage and Assign Microsoft Teams Policies</li> <li>Plan and Configure External and Guest Access</li> <li>Managing Microsoft Teams using PowerShell</li> <li>Lab: Planning and Managing Microsoft Teams</li> </ul> <h3>7 - Planning and Managing Other Office 365 Services</h3> <ul> <li>Yammer</li> <li>Planner</li> <li>Visio</li> <li>Bookings</li> <li>Delve</li> <li>Forms</li> <li>Power Platform</li> <li>Stream</li> <li>Sway</li> <li>Viva</li> <li>Scheduler</li> <li>Add-ins, including Find Time and Junk Reporter</li> <li>Lab: Planning and Managing Office 365 Services</li> </ul> <h3>8 - Security and Compliance in Office 365</h3> <ul> <li>Overview of Security and Compliance Features in Office 365</li> <li>Extending Security and compliance Features with Additional Licences</li> <li>Using the Microsoft Defender Portal and Secure Score</li> <li>Using the Office 365 Compliance Portal and Compliance Score</li> <li>Plan and Configure Retention Labels and Policies</li> <li>Plan and Configure Data Loss Prevention Policies</li> <li>Create and Assign Sensitivity Labels</li> <li>Configure Safe Attachments and Safe Links Policies</li> <li>Plan and Configure Multi Factor Authentication</li> <li>Lab: Configure Security and Compliance in Office 365</li> </ul> <h3>9 - Reporting, Monitoring and Troubleshooting Office 365</h3> <ul> <li>Monitoring Office 365 Service Health</li> <li>Troubleshooting Administrative Access in Office 365</li> <li>Troubleshoot Directory Synchronization</li> <li>Troubleshooting Exchange Online</li> <li>Troubleshooting SharePoint Online</li> <li>Troubleshooting Microsoft Teams</li> <li>Troubleshooting Office 365 Security and Compliance</li> <li>Lab: Reporting, Monitoring and Troubleshooting in Office 365</li> </ul></div>

55354 Administering Office 365

<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 Enterprise network staff responsible for help desk support, system administration, and network design.</p>Overview<p>At Course Completion: - Features and functions of Group Policy - Use Group Policy management tools to manage security policies - Design a Group Policy infrastructure - Group Policy processing architecture - Back up, restore, import, and copy Group Policy Objects through the Group Policy - Management Console - Use Windows PowerShell to manage Group Policy - Implement security using Group Policy - Configure the desktop environment with Group Policy - Configure roaming profiles and Folder Redirection - Assign and publish software packages - Implement AppLocker and software restriction policies - Create and deploy Administrative Templates - Configure Group Policy preferences</p><p>In this course, you will learn how to reduce costs and increase efficiencies in your network. You will discover how to consolidate the administration of an enterprise IT infrastructure with Group Policy, and you will learn to control and manage computer systems and domain users running Windows Server 2016 and Windows clients. Create Group Policies, implement administrative and security templates, and determine best practices when deploying software packages. Walk away with the experience and tools needed to optimize your enterprise systems and networks, implement administrative and security templates, and determine best practices when deploying software packages.</p></div><div id="course-pills-2"><h3>1 - Introduction to Configuration Management</h3> <ul> <li>Configuration Management Overview</li> <li>Configuration Management Using Group Policy</li> <li>Group Policy Features Introduced with Later Versions of Windows</li> <li>Using Windows PowerShell in the Configuration Management Process</li> </ul> <h3>2 - Using Group Policy Management Tools</h3> <ul> <li>Local and Domain Policies</li> <li>Using Group Policy Management Console</li> <li>Understanding Group Policy Refresh</li> </ul> <h3>3 - Designing a Group Policy Infrastructure</h3> <ul> <li>Design Stages for a Group Policy Infrastructure</li> <li>Planning your Group Policy Design</li> <li>Designing Your Group Policy Solution</li> <li>Deploying Your Group Policy Solution</li> <li>Managing Your Group Policy Solution</li> </ul> <h3>4 - Understanding the Architecture of Group Policy Processing</h3> <ul> <li>Group Policy Components in AD DS</li> <li>Understanding the Group Policy Deployment Order</li> <li>Modifying Group Policy Processing</li> </ul> <h3>5 - Troubleshooting and Backing Up GPOs</h3> <ul> <li>Using Group Policy Troubleshooting Tools</li> <li>Integration of RSoP Functionality</li> <li>Group Policy Logging Options</li> <li>Backing Up, Restoring, Importing, and Copying GPOs</li> <li>Building Migration Tables</li> </ul> <h3>6 - Securing Windows Using Group Policy</h3> <ul> <li>Exploring the Windows Security Architecture</li> <li>Securing User Accounts</li> <li>Exploring Security Policies</li> <li>Windows Firewall with Advanced Security</li> <li>Implementing Domain Security</li> <li>Security Policy Options for Window Client and Windows Server</li> </ul> <h3>7 - Implementing Application Security Using Group Policy</h3> <ul> <li>Managing UAC Settings</li> <li>Defending Against Malware</li> <li>Using AppLocker to Restrict Software</li> <li>Implementing Windows App Security Settings</li> </ul> <h3>8 - Configuring the Desktop Environment with Group Policy</h3> <ul> <li>Exploring Script Types and Controlling Script Execution</li> <li>Defining the Desktop, Start Menu, and Taskbar Settings</li> <li>Defining the Control Panel Settings</li> <li>Defining the Windows Components Settings</li> <li>Configuring the Printer Management and Pruning Settings</li> <li>Defining the Network Settings</li> <li>Discovering the new Group Policy Settings</li> </ul> <h3>9 - Implementing User State Virtualization</h3> <ul> <li>Configuring Folder Redirection</li> <li>Managing Offline Files</li> <li>Implementing User Experience Virtualization</li> <li>OneDrive for Business</li> </ul> <h3>10 - Assigning and Publishing Software Packages</h3> <ul> <li>Using MSI Packages to Distribute Software</li> <li>Using Group Policy as a Software Deployment Method</li> <li>Deploying Software</li> <li>Setting Up Distribution Points</li> <li>Using the Systems Center Configuration Manager to Distribute Software</li> </ul> <h3>11 - Configuration Management with Windows PowerShell</h3> <ul> <li>Introducing Windows PowerShell</li> <li>Using Windows PowerShell</li> <li>Writing PowerShell Scripts</li> <li>Windows PowerShell Library for Group Policy</li> <li>Windows PowerShell-Based Logon Scripts</li> </ul> <h3>12 - Implementing PowerShell Desired State Configuration</h3> <ul> <li>Introducing Group Policy Preferences</li> <li>Comparing Preferences and Policy Settings</li> <li>Options for Applying Preferences</li> <li>Configure Preference Settings</li> </ul> <h3>13 - Configuring Group Policy Preferences</h3> <ul> <li>Introducing Group Policy Preferences</li> <li>Comparing Preferences and Policy Settings</li> <li>Options for Applying Preferences</li> <li>Configuring Preferences Settings</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 50255 Managing Windows Environments with Group Policy 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 50255 Managing Windows Environments with Group Policy course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

CompTIA Security+

50255 Managing Windows Environments with Group Policy

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.</p><p></p><p></p><p>This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.</p><p></p>Prerequisites<p>To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces.</p></div><div id="course-pills-2"><h3>1 - Explore Azure App Service</h3> <ul> <li>Examine Azure App Service</li> <li>Examine Azure App Service plans</li> <li>Deploy to App Service</li> <li>Explore authentication and authorization in App Service</li> <li>Discover App Service networking features</li> </ul> <h3>2 - Configure web app settings</h3> <ul> <li>Configure application settings</li> <li>Configure general settings</li> <li>Configure path mappings</li> <li>Enable diagnostic logging</li> <li>Configure security certificates</li> </ul> <h3>3 - Scale apps in Azure App Service</h3> <ul> <li>Examine autoscale factors</li> <li>Identify autoscale factors</li> <li>Enable autoscale in App Service</li> <li>Explore autoscale best practices</li> </ul> <h3>4 - Explore Azure App Service deployment slots</h3> <ul> <li>Explore staging environments</li> <li>Examine slot swapping</li> <li>Swap deployment slots</li> <li>Route traffic in App Service</li> </ul> <h3>5 - Explore Azure Functions</h3> <ul> <li>Discover Azure Functions</li> <li>Compare Azure Functions hosting options</li> <li>Scale Azure Functions</li> </ul> <h3>6 - Develop Azure Functions</h3> <ul> <li>Explore Azure Functions development</li> <li>Create triggers and bindings</li> <li>Connect functions to Azure services</li> </ul> <h3>7 - Explore Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage</li> <li>Discover Azure Blob storage resource types</li> <li>Explore Azure Storage security features</li> <li>Discover static website hosting in Azure Storage</li> </ul> <h3>8 - Manage the Azure Blob storage lifecycle</h3> <ul> <li>Explore the Azure Blob storage lifecycle</li> <li>Discover Blob storage lifecycle policies</li> <li>Implement Blob storage lifecycle policies</li> <li>Rehydrate blob data from the archive tier</li> </ul> <h3>9 - Work with Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage client library</li> <li>Create a client object</li> <li>Manage container properties and metadata by using .NET</li> <li>Set and retrieve properties and metadata for blob resources by using REST</li> </ul> <h3>10 - Explore Azure Cosmos DB</h3> <ul> <li>Identify key benefits of Azure Cosmos DB</li> <li>Explore the resource hierarchy</li> <li>Explore consistency levels</li> <li>Choose the right consistency level</li> <li>Explore supported APIs</li> <li>Discover request units</li> </ul> <h3>11 - Work with Azure Cosmos DB</h3> <ul> <li>Explore Microsoft .NET SDK v3 for Azure Cosmos DB</li> <li>Create stored procedures</li> <li>Create triggers and user-defined functions</li> <li>Explore change feed in Azure Cosmos DB</li> </ul> <h3>12 - Manage container images in Azure Container Registry</h3> <ul> <li>Discover the Azure Container Registry</li> <li>Explore storage capabilities</li> <li>Build and manage containers with tasks</li> <li>Explore elements of a Dockerfile</li> </ul> <h3>13 - Run container images in Azure Container Instances</h3> <ul> <li>Explore Azure Container Instances</li> <li>Run containerized tasks with restart policies</li> <li>Set environment variables in container instances</li> <li>Mount an Azure file share in Azure Container Instances</li> </ul> <h3>14 - Implement Azure Container Apps</h3> <ul> <li>Explore Azure Container Apps</li> <li>Explore containers in Azure Container Apps</li> <li>Implement authentication and authorization in Azure Container Apps</li> <li>Manage revisions and secrets in Azure Container Apps</li> <li>Explore Dapr integration with Azure Container Apps</li> </ul> <h3>15 - Explore the Microsoft identity platform</h3> <ul> <li>Explore the Microsoft identity platform</li> <li>Explore service principals</li> <li>Discover permissions and consent</li> <li>Discover conditional access</li> </ul> <h3>16 - Implement authentication by using the Microsoft Authentication Library</h3> <ul> <li>Explore the Microsoft Authentication Library</li> <li>Initialize client applications</li> </ul> <h3>17 - Implement shared access signatures</h3> <ul> <li>Discover shared access signatures</li> <li>Choose when to use shared access signatures</li> <li>Explore stored access policies</li> </ul> <h3>18 - Explore Microsoft Graph</h3> <ul> <li>Discover Microsoft Graph</li> <li>Query Microsoft Graph by using REST</li> <li>Query Microsoft Graph by using SDKs</li> <li>Apply best practices to Microsoft Graph</li> </ul> <h3>19 - Implement Azure Key Vault</h3> <ul> <li>Explore Azure Key Vault</li> <li>Discover Azure Key Vault best practices</li> <li>Authenticate to Azure Key Vault</li> </ul> <h3>20 - Implement managed identities</h3> <ul> <li>Explore managed identities</li> <li>Discover the managed identities authentication flow</li> <li>Configure managed identities</li> <li>Acquire an access token</li> </ul> <h3>21 - Implement Azure App Configuration</h3> <ul> <li>Explore the Azure App Configuration service</li> <li>Create paired keys and values</li> <li>Manage application features</li> <li>Secure app configuration data</li> </ul> <h3>22 - Explore API Management</h3> <ul> <li>Discover the API Management service</li> <li>Explore API gateways</li> <li>Explore API Management policies</li> <li>Create advanced policies</li> <li>Secure APIs by using subscriptions</li> <li>Secure APIs by using certificates</li> </ul> <h3>23 - Explore Azure Event Grid</h3> <ul> <li>Explore Azure Event Grid</li> <li>Discover event schemas</li> <li>Explore event delivery durability</li> <li>Control access to events</li> <li>Receive events by using webhooks</li> <li>Filter events</li> </ul> <h3>24 - Explore Azure Event Hubs</h3> <ul> <li>Discover Azure Event Hubs</li> <li>Explore Event Hubs Capture</li> <li>Scale your processing application</li> <li>Control access to events</li> <li>Perform common operations with the Event Hubs client library</li> </ul> <h3>25 - Discover Azure message queues</h3> <ul> <li>Choose a message queue solution</li> <li>Explore Azure Service Bus</li> <li>Discover Service Bus queues, topics, and subscriptions</li> <li>Explore Service Bus message payloads and serialization</li> <li>Explore Azure Queue Storage</li> <li>Create and manage Azure Queue Storage and messages by using .NET</li> </ul> <h3>26 - Monitor app performance</h3> <ul> <li>Explore Application Insights</li> <li>Discover log-based metrics</li> <li>Instrument an app for monitoring</li> <li>Select an availability test</li> <li>Troubleshoot app performance by using Application Map</li> </ul> <h3>27 - Develop for Azure Cache for Redis</h3> <ul> <li>Explore Azure Cache for Redis</li> <li>Configure Azure Cache for Redis</li> <li>Interact with Azure Cache for Redis by using .NET</li> </ul> <h3>28 - Develop for storage on CDNs</h3> <ul> <li>Explore Azure Content Delivery Networks</li> <li>Control cache behavior on Azure Content Delivery Networks</li> <li>Interact with Azure Content Delivery Networks by using .NET</li> </ul></div>

AWS Certified Solutions Architect

AZ-204T00 Developing Solutions for Microsoft Azure

39372 Courses

Introduction to Dog Breeds and Basic Anatomy

By Apex Learning

Functional Skills Maths Teacher

By Apex Learning

Content Writing & Copy Writing For SEO and Sales

By Apex Learning

Admin Support Diploma

By Course Gate

Adobe Lightroom Complete Training

By Course Gate

Adult Safeguarding Level 3

By Course Gate

Property Administrator Training

By Course Gate

Diploma in Alternative Medicine

By Course Gate

Diploma in Art and Painting

By Course Gate

SQL for Data Science, Data Analytics and Data Visualization

By Studyhub UK

Search By Location