Name: Node JS Fundamentals Course
Price: 100 GBP
Availability: InStock

<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h2>Overview</h2>		</div>
				</div>
				<div>
				<div>
							<p><span>By enroling in MySql Masterclass, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic.</span></p><p><span>The MySql Masterclass course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent MySql Masterclass course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our MySql Masterclass Program.</span></p><p><span>So enrol in our MySql Masterclass course right away if you're keen to envision yourself in a rewarding career.</span></p>						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h2><b>Description</b>
</h2>		</div>
				</div>
				<div>
				<div>
							<p><span>Enroling in this MySql Masterclass course can improve your MySql Masterclass perspective, regardless of your skill levels in the MySql Masterclass topics you want to master. If you're already a MySql Masterclass expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced MySql Masterclass insights that will help you make the most of your time. This MySql Masterclass course will act as a guide for you if you've ever wished to excel at MySql Masterclass.</span></p>						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h2>Why Choose Us?</h2>		</div>
				</div>
				<div>
				<div>
							<ul><li><span>After successfully completing the MySql Masterclass Course, you will receive a </span><b>FREE PDF Certificate </b><span>as evidence of your newly acquired abilities.</span></li><li><span>Lifetime access to the whole collection of MySql Masterclass learning materials.</span></li><li><span>Online test with immediate results</span></li><li><span>Enroling in the course has no additional cost.</span></li><li><span>You can study and complete the MySql Masterclass course at your own pace.</span></li><li><span>Study for the MySql Masterclass course using any internet-connected device, such as a computer, tablet, or mobile device.</span></li></ul>						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h2>Who Is This Course For?</h2>		</div>
				</div>
				<div>
				<div>
							<p><span>This MySql Masterclass course is a great place to start if you're looking to start a new career in MySql Masterclass field. This training is for anyone interested in gaining in-demand MySql Masterclass proficiency to help launch a career or their business aptitude. </span></p>						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
							<p><span>The MySql Masterclass course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of MySql Masterclass, without any fuss.</span></p>						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
							<p><span>This MySql Masterclass training will assist you develop your MySql Masterclass ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a  MySql Masterclass professional story and personalise your path to a new career. Furthermore, developing this MySql Masterclass skillset can lead to numerous opportunities for high-paying jobs in a variety of fields.</span></p>						</div>
				</div>
					</div>
		</div>
							</div>
		</section> <div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table>				<tbody><tr>
					<td colspan="4">MySql Masterclass</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 1: Introduction on MySQL</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 2: Data Types</td>
					<td> </td>
					<td><span><i></i> 00:51:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 3: SELECT Statements</td>
					<td> </td>
					<td><span><i></i> 00:59:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 4: Backticks</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 5: NULL</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 6: Limit and Offset</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 7: Creating databases</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 8: Using Variables</td>
					<td> </td>
					<td><span><i></i> 00:25:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 9: Comment MySQL</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 10: INSERT Statements</td>
					<td> </td>
					<td><span><i></i> 00:29:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 11: DELETE Statements</td>
					<td> </td>
					<td><span><i></i> 00:21:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 12: UPDATE Statements</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 13: ORDER BY Clause</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 14: Group By</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 15: Errors in MySQL</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 16: Joins</td>
					<td> </td>
					<td><span><i></i> 00:37:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 17: Joins continued</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 18: UNION</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 19: Arithmetic</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 20: String operations</td>
					<td> </td>
					<td><span><i></i> 00:33:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 21: Date and Time Operations</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 22: Handling Time Zones</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 23: Regular Expressions</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 24: VIEWS</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 25: Table Creation</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 26: ALTER TABLE</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 27: Drop Table</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 28: MySQL LOCK TABLE</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 29: Error codes</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 30: Stored routines (procedures and functions)</td>
					<td> </td>
					<td><span><i></i> 00:29:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 31: Indexes and Keys</td>
					<td> </td>
					<td><span><i></i> 00:24:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 32: Full-Text search</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 33: PREPARE Statements</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 34: JSON</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 35: Extract values from JSON type</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 36: MySQL Admin</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 37: TRIGGERS</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 38: Configuration and tuning</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 39: Events</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 40: ENUM</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 41: Collations, Transactions, Log files, Replication, Backup</td>
					<td> </td>
					<td><span><i></i> 00:41:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Assignment </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - MySql Masterclass</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

NextGen Learning

MySql Masterclass Course

General Admission

Packt

JavaScript

AJAX

Web Development

jQuery

Learn about the jQuery library from scratch and stretch your journey from a beginner-level to advanced-level professional with a step-by-step and comprehensive course.

A basic understanding of the JavaScript Document Object Model and CSS is suggested as a prerequisite to this course.

The Complete jQuery Course - Beginner to Professional

<div>
					<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				</div>
		<div>
				<div>
				<div>
			<h4>Overview</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<p><span>By enroling in The Complete MySQL Server from Scratch: Bootcamp, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic.</span></p><p><span>The The Complete MySQL Server from Scratch: Bootcamp course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent The Complete MySQL Server from Scratch: Bootcamp course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our The Complete MySQL Server from Scratch: Bootcamp Program.</span></p><p><span>So enrol in our The Complete MySQL Server from Scratch: Bootcamp course right away if you're keen to envision yourself in a rewarding career.</span></p>						</div>
				</div>
				</div>
					</div>
				</div>
		<div>
					<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				</div>
		<div>
				<div>
				<div>
			<h4>Description</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<p><span>Enroling in this The Complete MySQL Server from Scratch: Bootcamp course can improve your The Complete MySQL Server from Scratch: Bootcamp perspective, regardless of your skill levels in the The Complete MySQL Server from Scratch: Bootcamp topics you want to master. If you're already a The Complete MySQL Server from Scratch: Bootcamp expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced The Complete MySQL Server from Scratch: Bootcamp insights that will help you make the most of your time. This The Complete MySQL Server from Scratch: Bootcamp course will act as a guide for you if you've ever wished to excel at The Complete MySQL Server from Scratch: Bootcamp.</span></p>						</div>
				</div>
				</div>
					</div>
				</div>
		<div>
					<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				</div>
		<div>
				<div>
				<div>
			<h4>Why Choose Us?</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>This course is accredited by the CPD Quality Standards.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Lifetime access to the whole collection of the learning materials.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Online test with immediate results.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Enroling in the course has no additional cost.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You can study and complete the course at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study for the course using any internet-connected device, such as a computer, tablet, or mobile device.</span>
									</li>
						</ul>
				</div>
				</div>
				</div>
					</div>
				</div>
		<div>
					<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				</div>
		<div>
				<div>
				<div>
			<h4>Will I Receive A Certificate Of Completion?</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<p>Upon successful completion, you will qualify for the UK and internationally-recognised CPD certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £4.99 and Hardcopy Certificate for £9.99.</p>						</div>
				</div>
				</div>
					</div>
				</div>
		<div>
					<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				</div>
		<div>
				<div>
				<div>
			<h4>Who Is This Course For?</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<p><span>This The Complete MySQL Server from Scratch: Bootcamp course is a great place to start if you're looking to start a new career in The Complete MySQL Server from Scratch: Bootcamp field. This training is for anyone interested in gaining in-demand The Complete MySQL Server from Scratch: Bootcamp proficiency to help launch a career or their business aptitude. </span></p>						</div>
				</div>
				</div>
					</div>
				</div>
		<div>
					<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				</div>
		<div>
				<div>
				<div>
			<h4>Requirements</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<p><span>The The Complete MySQL Server from Scratch: Bootcamp course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of The Complete MySQL Server from Scratch: Bootcamp, without any fuss.</span></p>						</div>
				</div>
				</div>
					</div>
				</div>
		<div>
					<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				</div>
		<div>
				<div>
				<div>
			<h4>Career Path</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<p><span>This The Complete MySQL Server from Scratch: Bootcamp training will assist you develop your The Complete MySQL Server from Scratch: Bootcamp ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a  The Complete MySQL Server from Scratch: Bootcamp professional story and personalise your path to a new career. Furthermore, developing this The Complete MySQL Server from Scratch: Bootcamp skillset can lead to numerous opportunities for high-paying jobs in a variety of fields.</span></p>						</div>
				</div>
				</div>
					</div>
				</div>
		<div>
					<div>
		<div>
				<div>
				<div>
					<div>
			<div>
						</div>
		</div>
				</div>
				</div>
				</div>
		<div>
				<div>
				<div>
			<h4>Order Your Certificate</h4>		</div>
				</div>
				</div>
		<div>
				<div>
				<div>
							<div><div><div><div id="1693981461.590199"><div><div><div><div><div><div><div><div><div><div><div>To order CPD Quality Standard Certificate, we kindly invite you to visit the following link:</div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>						</div>
				</div>
				<div>
				<div>
					<div>
			
						<span>
						
		</span>
					
		</div>
				</div>
				</div>
				</div>
					</div>
				</div> <div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table>				<tbody><tr>
					<td colspan="4">Course Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Course Curriculum Overview</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of Databases</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4">SQL Environment Setup</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MySQL Installation</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MySQL Workbench Installation</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Connecting to MySQL using Console</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">SQL Statement Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of Challenges</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Statement Basic</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT Statement</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT DISTINCT</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Column AS Statement</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>COUNT built-in Method usage</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT WHERE Clause - Part One</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT WHERE Clause - Part Two</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Statement Basic</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Limit Clause Statement</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Using BETWEEN with Same Column Data</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to Apply IN Operator</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wildcard Characters with LIKE and ILIKE</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">GROUP BY Statements</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of GROUP BY</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Aggregation function SUM()</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Aggregation MIN() and MAX()</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>GROUP BY - One</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>GROUP BY - Two</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>HAVING Clause</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">JOINS</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of JOINS</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to JOINS</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>AS Statement table</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>INNER Joins</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>FULL Outer Join</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>LEFT Outer JOIN</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>RIGHT JOIN</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Union</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced SQL Commands / Statements</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Timestamps</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>EXTRACT from timestamp</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mathematical Functions</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>String Functions</td>
					<td> </td>
					<td><span><i></i> 00:22:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SUBQUERY</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating Database and Tables</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Basic of Database and Tables</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DataTypes</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Primarykey and Foreignkey</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Table in SQL Script</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Update</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Delete</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Alter Table</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Drop Table</td>
					<td> </td>
					<td><span><i></i> 00:05: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:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Databases and Tables</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Database backup</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>10a Overview of Databases and Tables</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>10c Restoring a Database</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Order Your Certificate</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificate</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

The Complete MySQL Server from Scratch: Bootcamp Course

<strong>A complete course on Sqoop, Flume, and Hive: Ideal for achieving CCA175 and Hortonworks Spark Certification</strong>
        <p>In this course, you will start by learning about the Hadoop Distributed File System (HDFS) and the most common Hadoop commands required to work with HDFS. Next, you'll be introduced to Sqoop Import, which will help you gain insights into the lifecycle of the Sqoop command and how to use the import command to migrate data from MySQL to HDFS, and from MySQL to Hive. 

In addition to this, you will get up to speed with Sqoop Export for migrating data effectively, along with using Apache Flume to ingest data. As you progress, you will delve into Apache Hive, external and managed tables, working with different files, and Parquet and Avro. Toward the concluding section, you will focus on Spark DataFrames and Spark SQL. 

By the end of this course, you will have gained comprehensive insights into big data ingestion and analytics with Flume, Sqoop, Hive, and Spark. 

All code and supporting files are available at - https://github.com/PacktPublishing/Master-Big-Data-Ingestion-and-Analytics-with-Flume-Sqoop-Hive-and-Spark</p>
        <h2>What You Will Learn</h2><p>Explore the Hadoop Distributed File System (HDFS) and commands <br>Get to grips with the lifecycle of the Sqoop command <br>Use the Sqoop Import command to migrate data from MySQL to HDFS and Hive <br>Understand split-by and boundary queries <br>Use the incremental mode to migrate data from MySQL to HDFS <br>Employ Sqoop Export to migrate data from HDFS to MySQL <br>Discover Spark DataFrames  and gain insights into  working with different file formats and compression</p>
        <h2>Audience</h2><p>This course is for anyone who wants to learn Sqoop and Flume or those looking to achieve CCA and HDP certification.</p>
        <h2>Approach</h2><p>A complete course packed with step-by-step instructions, working examples, and helpful advice. This course is systematically divided into small sections that will help you understand each part individually and learn at your own pace.</p>
        <h2>Key Features</h2><p>Learn Sqoop, Flume, and Hive and successfully achieve CCA175 and Hortonworks Spark Certification  * Understand the Hadoop Distributed File System (HDFS), along with exploring Hadoop commands to work effectively with HDFS</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/master-big-data-ingestion-and-analytics-with-flume-sqoop-hive-and-spark</p>
        <h2>About the Author</h2><h3>Navdeep Kaur</h3><p>Navdeep Kaur - Technical Trainer
Navdeep Kaur is a big data professionals with 11 years of industry experience in different technologies and domains. She has a keen interest in providing training in new technologies. She has received CCA175 Hadoop and Spark developer certification and AWS solution architect certification. She loves guiding people and helping them achieves new goals.</p>
        <h2>Course Outline</h2><h4>1. Hadoop Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. HDFS and Hadoop Commands</p><p style='margin: 0'>Hadoop Introduction: HDFS and Hadoop Commands</p></td></tr></tbody></table><br><h4>2. Sqoop Import</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Sqoop Introduction</p><p style='margin: 0'>Sqoop Import: Sqoop Introduction</p></td></tr><tr><td style='padding: 15px;'><p>2. Managing Target Directories</p><p style='margin: 0'>Sqoop Import: Managing Target Directories</p></td></tr><tr><td style='padding: 15px;'><p>3. Working with Different File Formats</p><p style='margin: 0'>Sqoop Import: Working with Different File Formats</p></td></tr><tr><td style='padding: 15px;'><p>4. Working with Different Compressions</p><p style='margin: 0'>Sqoop Import: Working with Different Compressions</p></td></tr><tr><td style='padding: 15px;'><p>5. Conditional Imports</p><p style='margin: 0'>Sqoop Import: Conditional Imports</p></td></tr><tr><td style='padding: 15px;'><p>6. Split-by and Boundary Queries</p><p style='margin: 0'>Sqoop Import: Split-by and Boundary Queries</p></td></tr><tr><td style='padding: 15px;'><p>7. Field delimeters</p><p style='margin: 0'>Sqoop Import: Field delimeters</p></td></tr><tr><td style='padding: 15px;'><p>8. Incremental Appends</p><p style='margin: 0'>Sqoop Import: Incremental Appends</p></td></tr><tr><td style='padding: 15px;'><p>9. Sqoop Hive Import</p><p style='margin: 0'>Sqoop Import: Sqoop Hive Import</p></td></tr><tr><td style='padding: 15px;'><p>10. Sqoop List Tables/Database</p><p style='margin: 0'>Sqoop Import: Sqoop List Tables/Database</p></td></tr><tr><td style='padding: 15px;'><p>11. Sqoop Import Practice1</p><p style='margin: 0'>Sqoop Import: Sqoop Import Practice1</p></td></tr><tr><td style='padding: 15px;'><p>12. Sqoop Import Practice2</p><p style='margin: 0'>Sqoop Import: Sqoop Import Practice2</p></td></tr><tr><td style='padding: 15px;'><p>13. Sqoop Import Practice3</p><p style='margin: 0'>Sqoop Import: Sqoop Import Practice3</p></td></tr></tbody></table><br><h4>3. Sqoop Export</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Export from Hdfs to Mysql</p><p style='margin: 0'>Sqoop Export: Export from Hdfs to Mysql</p></td></tr><tr><td style='padding: 15px;'><p>2. Export from Hive to Mysql</p><p style='margin: 0'>Sqoop Export: Export from Hive to Mysql</p></td></tr></tbody></table><br><h4>4. Apache Flume</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Flume Introduction & Architecture</p><p style='margin: 0'>Apache Flume: Flume Introduction & Architecture</p></td></tr><tr><td style='padding: 15px;'><p>2. Exec Source and Logger Sink</p><p style='margin: 0'>Apache Flume: Exec Source and Logger Sink</p></td></tr><tr><td style='padding: 15px;'><p>3. Moving data from Twitter to HDFS</p><p style='margin: 0'>Apache Flume: Moving data from Twitter to HDFS</p></td></tr><tr><td style='padding: 15px;'><p>4. Moving data from NetCat to HDFS</p><p style='margin: 0'>Apache Flume: Moving data from NetCat to HDFS</p></td></tr><tr><td style='padding: 15px;'><p>5. Flume Interceptors</p><p style='margin: 0'>Apache Flume: Flume Interceptors</p></td></tr><tr><td style='padding: 15px;'><p>6. Flume Interceptor Example</p><p style='margin: 0'>Apache Flume: Flume Interceptor Example</p></td></tr><tr><td style='padding: 15px;'><p>7. Flume Multi-Agent Flow</p><p style='margin: 0'>Apache Flume: Flume Multi-Agent Flow</p></td></tr><tr><td style='padding: 15px;'><p>8. Flume Consolidation</p><p style='margin: 0'>Apache Flume: Flume Consolidation</p></td></tr></tbody></table><br><h4>5. Apache Hive</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Hive Introduction</p><p style='margin: 0'>Apache Hive: Hive Introduction</p></td></tr><tr><td style='padding: 15px;'><p>2. Hive Database</p><p style='margin: 0'>Apache Hive: Hive Database</p></td></tr><tr><td style='padding: 15px;'><p>3. Hive Managed Tables</p><p style='margin: 0'>Apache Hive: Hive Managed Tables</p></td></tr><tr><td style='padding: 15px;'><p>4. Hive External Tables</p><p style='margin: 0'>Apache Hive: Hive External Tables</p></td></tr><tr><td style='padding: 15px;'><p>5. Hive Inserts</p><p style='margin: 0'>Apache Hive: Hive Inserts</p></td></tr><tr><td style='padding: 15px;'><p>6. Hive Analytics</p><p style='margin: 0'>Apache Hive: Hive Analytics</p></td></tr><tr><td style='padding: 15px;'><p>7. Working with Parquet</p><p style='margin: 0'>Apache Hive: Working with Parquet</p></td></tr><tr><td style='padding: 15px;'><p>8. Compressing Parquet</p><p style='margin: 0'>Apache Hive: Compressing Parquet</p></td></tr><tr><td style='padding: 15px;'><p>9. Working with Fixed File Format</p><p style='margin: 0'>Apache Hive: Working with Fixed File Format</p></td></tr><tr><td style='padding: 15px;'><p>10. Alter Command</p><p style='margin: 0'>Apache Hive: Alter Command</p></td></tr><tr><td style='padding: 15px;'><p>11. Hive String Functions</p><p style='margin: 0'>Apache Hive: Hive String Functions</p></td></tr><tr><td style='padding: 15px;'><p>12. Hive Date Functions</p><p style='margin: 0'>Apache Hive: Hive Date Functions</p></td></tr><tr><td style='padding: 15px;'><p>13. Hive Partitioning</p><p style='margin: 0'>Apache Hive: Hive Partitioning</p></td></tr><tr><td style='padding: 15px;'><p>14. Hive Bucketing</p><p style='margin: 0'>Apache Hive: Hive Bucketing</p></td></tr></tbody></table><br><h4>6. Spark Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Spark Introduction</p><p style='margin: 0'>Spark Introduction: Spark Introduction</p></td></tr><tr><td style='padding: 15px;'><p>2. Resilient Distributed Datasets</p><p style='margin: 0'>Spark Introduction: Resilient Distributed Datasets</p></td></tr><tr><td style='padding: 15px;'><p>3. Cluster Overview</p><p style='margin: 0'>Spark Introduction: Cluster Overview</p></td></tr><tr><td style='padding: 15px;'><p>4. Directed Acyclic Graph (DAG) & Stages</p><p style='margin: 0'>Spark Introduction: Directed Acyclic Graph (DAG) & Stages</p></td></tr></tbody></table><br><h4>7. Spark Transformations & Actions</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Map/FlatMap Transformation</p><p style='margin: 0'>Spark Transformations & Actions: Map/FlatMap Transformation</p></td></tr><tr><td style='padding: 15px;'><p>2. Filter/Intersection</p><p style='margin: 0'>Spark Transformations & Actions: Filter/Intersection</p></td></tr><tr><td style='padding: 15px;'><p>3. Union/Distinct Transformation</p><p style='margin: 0'>Spark Transformations & Actions: Union/Distinct Transformation</p></td></tr><tr><td style='padding: 15px;'><p>4. GroupByKey/ Group people based on Birthday months</p><p style='margin: 0'>Spark Transformations & Actions: GroupByKey/ Group people based on Birthday months</p></td></tr><tr><td style='padding: 15px;'><p>5. ReduceByKey / Total Number of students in each Subject</p><p style='margin: 0'>Spark Transformations & Actions: ReduceByKey / Total Number of students in each Subject</p></td></tr><tr><td style='padding: 15px;'><p>6. SortByKey / Sort students based on their rollno</p><p style='margin: 0'>Spark Transformations & Actions: SortByKey / Sort students based on their rollno</p></td></tr><tr><td style='padding: 15px;'><p>7. MapPartition / MapPartitionWithIndex</p><p style='margin: 0'>Spark Transformations & Actions: MapPartition / MapPartitionWithIndex</p></td></tr><tr><td style='padding: 15px;'><p>8. Change number of Partitions</p><p style='margin: 0'>Spark Transformations & Actions: Change number of Partitions</p></td></tr><tr><td style='padding: 15px;'><p>9. Join / Join email address based on customer name</p><p style='margin: 0'>Spark Transformations & Actions: Join / Join email address based on customer name</p></td></tr><tr><td style='padding: 15px;'><p>10. Spark Actions</p><p style='margin: 0'>Spark Transformations & Actions: Spark Actions</p></td></tr></tbody></table><br><h4>8. Spark RDD Practice</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Scala Tuples</p><p style='margin: 0'>Spark RDD Practice: Scala Tuples</p></td></tr><tr><td style='padding: 15px;'><p>2. Extract Error Logs from log files</p><p style='margin: 0'>Spark RDD Practice: Extract Error Logs from log files</p></td></tr><tr><td style='padding: 15px;'><p>3. Frequency of word in Text File</p><p style='margin: 0'>Spark RDD Practice: Frequency of word in Text File</p></td></tr><tr><td style='padding: 15px;'><p>4. Population of each City</p><p style='margin: 0'>Spark RDD Practice: Population of each City</p></td></tr><tr><td style='padding: 15px;'><p>5. Orders placed by Customers</p><p style='margin: 0'>Spark RDD Practice: Orders placed by Customers</p></td></tr><tr><td style='padding: 15px;'><p>6. Movie Average Rating greater than 3</p><p style='margin: 0'>Spark RDD Practice: Movie Average Rating greater than 3</p></td></tr></tbody></table><br><h4>9. Spark Dataframes & Spark SQL</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Dataframe Intro</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Dataframe Intro</p></td></tr><tr><td style='padding: 15px;'><p>2. Dafaframe from Json Files</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Dafaframe from Json Files</p></td></tr><tr><td style='padding: 15px;'><p>3. Dataframe from Parquet Files</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Dataframe from Parquet Files</p></td></tr><tr><td style='padding: 15px;'><p>4. Dataframe from CSV Files</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Dataframe from CSV Files</p></td></tr><tr><td style='padding: 15px;'><p>5. Dataframe from Avro/XML Files</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Dataframe from Avro/XML Files</p></td></tr><tr><td style='padding: 15px;'><p>6. Working with Different Compressions</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Working with Different Compressions</p></td></tr><tr><td style='padding: 15px;'><p>7. DataFrame API Part1</p><p style='margin: 0'>Spark Dataframes & Spark SQL: DataFrame API Part1</p></td></tr><tr><td style='padding: 15px;'><p>8. DataFrame API Part2</p><p style='margin: 0'>Spark Dataframes & Spark SQL: DataFrame API Part2</p></td></tr><tr><td style='padding: 15px;'><p>9. Spark SQL</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Spark SQL</p></td></tr><tr><td style='padding: 15px;'><p>10. Working with Hive Tables in Spark</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Working with Hive Tables in Spark</p></td></tr></tbody></table>

Hadoop

Database Administration

Big Data

A complete course on Sqoop, Flume, and Hive: Ideal for achieving CCA175 and Hortonworks Spark Certification

Master Big Data Ingestion and Analytics with Flume, Sqoop, Hive and Spark

<p><strong>Ready to unlock the next level of your digital life?</strong> This online bundle course is your ultimate power-up, equipping you with the skills and knowledge to conquer the ever-evolving world of computing and technology.</p><p><strong>Boost your stats:</strong></p><ul><li><strong>Essential IT Skills:</strong> Master basic attacks like troubleshooting and software navigation, building a solid foundation for your digital prowess. </li><li><strong>Advanced Tech Arsenal:</strong> Unlock abilities in cloud computing and data analytics, gaining powerful tools to tackle complex digital challenges. </li><li><strong>Choose Your Specialisation:</strong> Become a data analysis mage, a cyber security warrior, or a web development champion - customise your digital skillset for ultimate mastery.  </li></ul><p><br /><strong>With 15 in-depth courses, this bundle is your ultimate skill tree, empowering you to dominate the digital landscape.</strong><strong>Don't stay a noob - level up your tech skills today!</strong>  </p><p><strong>Course list:</strong></p><ol><li> Essential IT Skills</li><li>IT Administration and Networking</li><li>IT for Beginners</li><li>IT Professional 2.0 Take Your Career To The Next Level</li><li>Start an IT Asset Department</li><li>Principles of Information &amp; Digital Technology</li><li>Cloud Computing / CompTIA Cloud+ (CV0-002)</li><li>Diploma in Data Analytics with Tableau</li><li>Google Data Studio: Data Analytics</li><li>MySQL Database Development</li><li>Microsoft Access Databases Forms and Reports</li><li>Website Hacking From Scratch</li><li>Web Application Penetration Testing</li><li>Create Videos, Motion Graphics and Animation Using Canva</li><li>Computer Science With Python </li></ol><h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <ul><li>Individuals with no prior IT experience seeking to enter the tech field</li><li>Professionals looking to enhance their existing IT skillset and knowledge</li><li>Those interested in specialising in areas like data analytics, cyber security, or web development</li><li>Anyone passionate about technology who wants to unlock their digital potential</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This bundle has minimal entry requirements, requiring only access to a computer or mobile device with internet connectivity, basic computer literacy, proficiency in the English language, and a genuine eagerness to learn. We welcome learners from all backgrounds to join us in exploring new subjects and expanding their knowledge.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>IT Administrator</li><li>Network Administrator</li><li>Data Analyst</li><li>Web Developer</li><li>Cyber Security Analyst</li><li>IT Project Manager</li><li>Software Developer</li><li>Database Administrator</li></ul><p>And many more!</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Digital certificate</h4>
        <p>
            Digital certificate -
            £9
        </p>
        <h4> Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            £15
        </p>
            <div><p>A Hardcopy Certificate (international): £15 + £10 (postal charge) = £25</p></div>

                        </div>

One Education

Computing and Technology Course

<p><strong>*** Software Engineering - Software Development ***</strong></p><p>Welcome to the Ultimate Software Development Online Course Bundle! Whether you're a beginner eager to start your programming adventure or a seasoned developer looking to level up your skills, this bundle is your passport to becoming a software wizard!</p><p>Are you ready to embark on a transformative journey into the world of code and creativity?</p><p>Enrol NOW!!!</p><p>This power-packed <strong>Software Engineering - Software Development </strong>bundle comprises our 19 best-selling software development courses:</p><ul><li>Course 1: How To Startup Your Own SaaS (Software As a Service) Company (SaaS Evolution)</li><li>Course 2: Diploma in Python Programming</li><li>Course 3: The Complete Full-Stack JavaScript Course!</li><li>Course 4: Mastering Java for Beginners &amp; Experts</li><li>Course 5: C++ Programming Certificate Course</li><li>Course 6: HTML and CSS Coding: Beginner to Advanced</li><li>Course 7: Building Web Applications with Django and PostgreSQL</li><li>Course 8: SQL NoSQL Big Data and Hadoop</li><li>Course 9: Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku</li><li>Course 10: Easy to Advanced Data Structures</li><li>Course 11: Web Application Penetration Testing</li><li>Course 12: Cloud Computing / CompTIA Cloud+ (CV0-002)</li><li>Course 13: Azure Administrator Essentials</li><li>Course 14: Amazon Web Services (AWS)</li><li>Course 15: Cyber Security Advanced Training</li><li>Course 16: Flutter &amp; Dart Development for Building iOS and Android Apps</li><li>Course 17: Project Management</li><li>Course 18: Machine Learning for Apps</li><li>Course 19: Internet of Things</li></ul><p><strong>What's more in this Software Engineering - Software Development Bundle?</strong></p><ul><li><strong>Quality License Scheme (QLS) </strong>endorsed<strong> Certificate of Completion,</strong> recorgnised globally</li><li><strong>CPD QS</strong> accredited <strong>Certificate of Completion,</strong> recorgnised globally</li><li>Dedicated Expert Support</li><li>1735 CPD points</li><li>FREE Assessment on all the Software Engineering - Software Development Bundle Courses</li><li>Lowest Price Guarantee Worldwide</li></ul><p><strong>Software Engineering - Software Development</strong></p><p>From mastering the Software Development fundamentals with Python, JavaScript, and Java to creating stunning web applications using HTML, CSS, and React, this bundle covers it all. You'll dive deep into mobile app development with Flutter and React Native, becoming proficient in both iOS and Android platforms.</p><p>By the end of this course bundle, you'll emerge as a seasoned Software Development professional with a diverse skill set, ready to tackle any digital challenge. Don't miss this opportunity to embark on a transformative journey into the world of software mastery. Enrol today!</p><h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p><strong>Software Engineering - Software Development</strong></p><p>Are you curious about the ever-evolving world of software development? Do you aspire to become a coding virtuoso or a tech-savvy wizard? If you resonate with any of the following descriptions, then this course is tailor-made for you:</p><ul><li>Beginners in Software Development</li><li>Aspiring Developers</li><li>Career Changers</li><li>Experienced Developers</li><li>Entrepreneurs and Innovators</li><li>Tech Enthusiasts</li><li>Professionals in IT and Tech</li><li>Students and Academics</li><li>Lifelong Learners</li><li>Global Learners</li></ul><p>No matter where you stand on your journey, our "Comprehensive Software Development Mastery Bundle" welcomes you to explore, learn, and master the art of software development. Join us and embark on a transformative learning adventure today!</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Embarking on a journey of software development mastery is an exciting endeavor, and to help you succeed, we've designed this course bundle with minimal prerequisites. Here are the fundamental requirements:</p><ul><li>Basic Computer Skills</li><li>Internet Access</li><li>A Computer</li><li>Passion and Curiosity</li><li>Determination and Patience</li><li>No Prior Coding Experience Required</li><li>Hardware for Coding</li></ul><p>Remember, everyone starts somewhere, and this course bundle is designed to be accessible to a wide range of learners. It's a fantastic opportunity to embark on a transformative journey into the world of software development, regardless of your current skill level.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>The world of software development offers a vast and exciting array of career paths, each with its unique challenges and rewards.</p><ul><li>Software Developer/Engineer</li><li>Web Developer</li><li>Mobile App Developer</li><li>Data Scientist/Data Analyst</li><li>DevOps Engineer</li><li>Software Architect</li><li>UX/UI Designer</li><li>Quality Assurance (QA) Engineer</li><li>Cloud Engineer/Cloud Architect</li><li>Game Developer</li><li>Product Manager</li><li>Freelancer/Consultant</li></ul>
                        </div>

Software Engineering - Software Development Course

<p>Feeling Stuck in Your Career? The Java Certification: Javascript with Coding, HTML, &amp; CSS Training Course  Bundle is Your Skill-Building Solution. This exceptional collection of <strong>20 premium courses</strong> is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the  Javascript with Coding, HTML, &amp; CSS Training Course bundle provides an engaging learning experience, helping you learn skills across various disciplines.</p><p>With Java Certification: Javascript with Coding, HTML, &amp; CSS Training Course  Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The  Javascript with Coding, HTML, &amp; CSS Training Course bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set.</p><p>By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Java Certification: Javascript with Coding, HTML, &amp; CSS Training Course bundle on your job life and career growth!</p><p><strong>This Java Certification: Javascript with Coding, HTML, &amp; CSS Training Course  Bundle Comprises the Following CPD Accredited Courses:</strong></p><ul><li><strong>Course 01</strong>: Java Certification Cryptography Architecture</li><li><strong>Course 02</strong>: jQuery: JavaScript and AJAX Coding</li><li><strong>Course 03</strong>: SQL Programming Masterclass</li><li><strong>Course 04</strong>: Ultimate PHP &amp; MySQL Web Development Course &amp; OOP Coding</li><li><strong>Course 05</strong>: Cocos2d-x v3 JavaScript: Game Development</li><li><strong>Course 06</strong>: jQuery: JavaScript and AJAX Coding Bible</li><li><strong>Course 07</strong>: Intermediate Python Coding</li><li><strong>Course 08</strong>: Mastering Java for Beginners &amp; Experts</li><li><strong>Course 09</strong>: Coding with HTML, CSS, &amp; Javascript</li><li><strong>Course 10</strong>: WordPress Website Creation and Hosting System with Affiliate Marketing!</li><li><strong>Course 11</strong>: Front End Web Development Diploma</li><li><strong>Course 12</strong>: Learn Ethical Hacking From A-Z: Beginner To Expert</li><li><strong>Course 13</strong>: Master JavaScript with Data Visualization</li><li><strong>Course 14</strong>: Creative Thinking for Everyday Life</li><li><strong>Course 15</strong>: Stress Management Training</li><li><strong>Course 16</strong>: Career Development Plan Fundamentals</li><li><strong>Course 17</strong>: CV Writing and Job Searching</li><li><strong>Course 18</strong>: Learn to Level Up Your Leadership</li><li><strong>Course 19</strong>: Networking Skills for Personal Success</li><li><strong>Course 20</strong>: Ace Your Presentations: Public Speaking Masterclass</li></ul><p><strong>What will make you stand out?</strong></p><p>Upon completion of this online Java Certification: Javascript with Coding, HTML, &amp; CSS Training Course Bundle, you will gain the following:</p><ul><li>CPD QS Accredited Proficiency with this  Javascript with Coding, HTML, &amp; CSS Training Course Bundle </li><li>After successfully completing the  Javascript with Coding, HTML, &amp; CSS Training Course bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities.</li><li>Lifetime access to the whole collection of learning materials of this  Javascript with Coding, HTML, &amp; CSS Training Course Bundle</li><li>The online test with immediate results </li><li>You can study and complete the  Javascript with Coding, HTML, &amp; CSS Training Course bundle at your own pace.</li><li>Study for the  Javascript with Coding, HTML, &amp; CSS Training Course bundle using any internet-connected device, such as a computer, tablet, or mobile device.</li></ul><p>The Java Certification: Javascript with Coding, HTML, &amp; CSS Training Course bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development.</p><p>Advance the future of learning with the Javascript with Coding, HTML, &amp; CSS Training Course bundle, a comprehensive, complete collection of 20 courses. Each course in the  Javascript with Coding, HTML, &amp; CSS Training Course bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience.</p><p>Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Javascript with Coding, HTML, &amp; CSS Training Course bundle offers the flexibility and convenience to learn at your own pace. Make the   Javascript with Coding, HTML, &amp; CSS Training Course package your trusted partner in your lifelong learning journey.</p><h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p>The Java Certification: Javascript with Coding, HTML, &amp; CSS Training Course  is perfect for:</p><ul><li>Expand your knowledge and skillset for a fulfilling career with the  Javascript with Coding, HTML, &amp; CSS Training Course bundle.</li><li>Become a more valuable professional by earning CPD certification and mastering in-demand skills with the  Javascript with Coding, HTML, &amp; CSS Training Course bundle.</li><li>Discover your passion or explore new career options with the diverse learning opportunities in the  Javascript with Coding, HTML, &amp; CSS Training Course bundle.</li><li>Learn on your schedule, in the comfort of your home - the  Javascript with Coding, HTML, &amp; CSS Training Course bundle offers ultimate flexibility for busy individuals.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the  Javascript with Coding, HTML, &amp; CSS Training Course bundle.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD Certificates</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Compliance Central

Java Certification: Javascript with Coding, HTML, & CSS Training Course

<p><strong>Develop in-demand skills for a better future with a super-saver bundle deal for just </strong><strong>£100</strong><strong> and instantly save </strong><strong>£1599</strong><strong>!</strong></p><p><strong>This Node JS Fundamentals bundle includes 1 best selling course endorsed by the Quality Licence Scheme with 5 additional CPD-accredited courses, expert assistance and course assessment. Enjoy 12 months of access to this bundle of courses FREE of charge and master a range of in-demand professional skills to advance your career. No hidden costs - simply enrol this bundle.</strong></p><p>This bundle package includes:</p><ul><li>An endorsed certificate</li><li>5 additional CPD accredited courses -</li></ul><ul><ol><li>The Complete Nodejs MySQL Login System</li><li>Node JS: API Development with Swagger</li><li>JavaScript Functions</li><li>Refactor Javascript</li><li>Start Coding Browser Extensions Using JavaScript!</li></ol></ul><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality bundle. Get the help you require and the answers to all your queries throughout the comprehensive syllabus of this Node JS Fundamentals bundle.</p><p>This premium online course bundle ensures your professional development with endorsement from Quality Licence Scheme and also CPD accreditation. You'll have the privilege of learning in your own time, at your own pace and earning an accredited certification.</p><p>With this bundle program, success becomes a lot easier that enables you to monetise your skills. This Node JS Fundamentals bundle is designed for both part-time and full-time students and can be completed at a pace that suits your learning style.</p><p><strong>Why People Enrol this Bundle from One Education:</strong></p><ul><li>Receive a Quality Licence Scheme-endorsed certificate upon successful completion of the bundle</li><li>5 additional CPD accredited courses to enrich your knowledge and skills</li><li>Learning materials of our bundle contains engaging voiceover and visual elements for your comfort</li><li>Get 24/7 access to all bundle content for a full year</li><li>Complete the bundle at your own pace</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li><li>Efficient assessments and instant results upon completion of our bundle</li></ul><p><strong>Course Curriculum:</strong></p><p>Here is a curriculum breakdown of the course:</p><p><strong>Unit 01: Introduction</strong></p><ul><li>Module 01: Introduction</li></ul><p><strong>Unit 02: Node.js Basics</strong></p><ul><li>Module 01: Introduction</li><li>Module 02: What's &amp; Why Node.js?</li><li>Module 03: Installation</li><li>Module 04: First Node.js app</li><li>Module 05: Mechanism of Node.js</li><li>Module 06: Event Loop</li><li>Module 07: Loop tick</li><li>Module 08: Modules</li></ul><p><strong>Unit 03: Asynchronous JavaScript</strong></p><ul><li>Module 01: Introduction</li><li>Module 02: JSON format</li><li>Module 03: Callback pattern 1</li><li>Module 04: Callback pattern 2</li><li>Module 05: Callback hell</li><li>Module 06: Promises pattern 1</li><li>Module 07: Promises pattern 2</li><li>Module 08: Master promises 1</li><li>Module 09: Master promises 2</li><li>Module 10: async/await pattern 1</li><li>Module 11: async/await pattern 2</li><li>Module 12: Promisify a function</li></ul><p><strong>Unit 04: Core Modules</strong></p><ul><li>Module 01: Introduction</li><li>Module 02: Event emitter I</li><li>Module 03: Event emitter II</li><li>Module 04: Event emitter III</li><li>Module 05: File system I</li><li>Module 06: File system II</li><li>Module 07: File system III</li><li>Module 08: Streams I</li><li>Module 09: Streams II</li><li>Module 10: Path I</li><li>Module 11: Path II</li><li>Module 12: Path III</li></ul><p><strong>Unit 05: npm</strong></p><ul><li>Module 01: Introduction</li><li>Module 02: package.json file</li><li>Module 03: Commands I</li><li>Module 04: Commands II</li><li>Module 05: Commands III</li></ul><p><strong>How is the bundle assessed?</strong></p><p>To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score displayed for your perusal. For each test, the pass mark will be set to 60%.</p><p>When all tests have been successfully passed, you will be able to claim a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Certificate of Achievement</strong></p><p><strong>Endorsed Certificate of Achievement from the Quality Licence Scheme</strong></p><p>After successfully completing the bundle, learners will get an endorsed certificate (included with the course) delivered right at their doorstep by post, without paying a single penny! Note that learners residing outside the UK have to pay a £10 postage charge.</p><p><strong>For Additional Courses</strong></p><p>For the additional Quality Licence Scheme endorsed certificates from the additional courses, you have to pay the fees based on level of each course:</p><ul><li>No Level- £29</li><li>Level 1 - £29</li><li>Level 2 - £59</li><li>Level 3 - £69</li><li>Level 4 - £79</li><li>Level 5 - £99</li><li>Level 6 - £109</li><li>Level 7 - £119</li></ul><p><strong>CPD Accredited Certification from One Education</strong></p><p>After successfully completing the courses under this bundle, you will also qualify for CPD Accredited Certificates for each of the courses. Certification is available in PDF format, at the cost of £9, or a hard copy can be sent to you via post at £15.</p><h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p>The bundle training is ideal for highly motivated individuals who want to enhance their professional skills and train for the job they want! This bundle also suits people aspiring for some in-depth knowledge on this topic and keep up to date with the latest information.</p><p>Study the Node JS Fundamentals bundle today and increase your professional skillset from the comfort of your home!</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>There are no formal entry requirements for the bundle, with enrollment open to anyone!<strong> Anyone and everyone</strong> with a knack for learning can enrol on this course without any hesitation.</p><p>Learn online from any internet device, including your computer, tablet or smartphone. Study when it suits you and complete the bundle at your own pace.</p><p>All students must have a passion for learning and literacy, as well as being over the age of 16.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Studying the bundle is designed to help you get the job of your dreams, or even that promotion you've always wanted. Learn the essential skills and knowledge you need to exceed in your professional life with the help &amp; guidance from our bundle.</p>
                        </div>

Node JS Fundamentals Course

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The CHFI course will benefit:<br />Police and other laws enforcement personnel<br />Defense and Military personnel<br />e-Business Security professionals<br />Systems administrators<br />Legal professionals<br />Banking, Insurance and other professionals<br />Government agencies</p>Overview<p>At the end of this course, you will possess the skills needed to:<br />Understand the fundamentals of computer forensics<br />Understand the computer forensic investigation process<br />Describe in detail different types of hard disks and file systems<br />Understand data acquisition and duplication<br />Counteract anti-forensic techniques<br />Leverage forensic skills in Windows, Linux, and Mac<br />Investigate web attacks<br />Understand dark web forensics<br />Deploy forensic techniques for databases, cloud, and networks<br />Investigate email crimes including malware<br />Perform forensics in mobile and IoT environments</p><p>Every crime leaves a digital footprint, and you need the skills to track those footprints. In this course, students will learn to unravel these pieces of evidence, decode them and report them. From decoding a hack to taking legal action against the perpetrators, they will become an active respondent in times of cyber-breaches.</p></div><div id="course-pills-2"><h4>Computer Forensics in Today?s World </h4><ul><li>1.1. Understand the Fundamentals of Computer Forensics </li><li>1.2. Understand Cybercrimes and their Investigation Procedures </li><li>1.3. Understand Digital Evidence </li><li>1.4. Understand Forensic Readiness, Incident Response and the Role of SOC (Security </li><li>       Operations Center) in Computer Forensics </li><li>1.5. Identify the Roles and Responsibilities of a Forensic Investigator </li><li>1.6. Understand the Challenges Faced in Investigating Cybercrimes </li><li>1.7. Understand Legal Compliance in Computer Forensics </li><li></li></ul><h4>Computer Forensics Investigation Process </h4><ul><li>2.1. Understand the Forensic Investigation Process and its Importance </li><li>2.2. Understand the Pre-investigation Phase </li><li>2.3. Understand First Response </li><li>2.4. Understand the Investigation Phase </li><li>2.5. Understand the Post-investigation Phase </li><li></li></ul><h4>Understanding Hard Disks and File Systems </h4><ul><li>3.1. Describe Different Types of Disk Drives and their Characteristics </li><li>3.2. Explain the Logical Structure of a Disk </li><li>3.3. Understand Booting Process of Windows, Linux and Mac Operating Systems </li><li>3.4. Understand Various File Systems of Windows, Linux and Mac Operating Systems </li><li>3.5. Examine File System Using Autopsy and The Sleuth Kit Tools </li><li>3.6 Understand Storage Systems</li><li>3.7. Understand Encoding Standards and Hex Editors </li><li>3.8. Analyze Popular File Formats Using Hex Editor </li><li></li></ul><h4>Data Acquisition and Duplication </h4><ul><li>4.1. Understand Data Acquisition Fundamentals</li><li>4.2. Understand Data Acquisition Methodology </li><li>4.3. Prepare an Image File for Examination </li><li></li></ul><h4>Defeating Anti-forensics Techniques </h4><ul><li>5.1. Understand Anti-forensics Techniques </li><li>5.2. Discuss Data Deletion and Recycle Bin Forensics </li><li>5.3. Illustrate File Carving Techniques and Ways to Recover Evidence from Deleted Partitions </li><li>5.4. Explore Password Cracking/Bypassing Techniques </li><li>5.5. Detect Steganography, Hidden Data in File System Structures, Trail Obfuscation, and File Extension Mismatch </li><li>5.6. Understand Techniques of Artifact Wiping, Overwritten Data/Metadata Detection, and Encryption </li><li>5.7. Detect Program Packers and Footprint Minimizing Techniques</li><li>5.8. Understand Anti-forensics Countermeasures </li><li></li></ul><h4>Windows Forensics </h4><ul><li>6.1. Collect Volatile and Non-volatile Information </li><li>6.2. Perform Windows Memory and Registry Analysis </li><li>6.3. Examine the Cache, Cookie and History Recorded in Web Browsers </li><li>6.4. Examine Windows Files and Metadata </li><li>6.5. Understand ShellBags, LNK Files, and Jump Lists </li><li>6.6. Understand Text-based Logs and Windows Event Logs </li><li></li></ul><h4>Linux and Mac Forensics </h4><ul><li>7.1. Understand Volatile and Non-volatile Data in Linux </li><li>7.2. Analyze Filesystem Images Using The Sleuth Kit </li><li>7.3. Demonstrate Memory Forensics Using Volatility &amp; PhotoRec </li><li>7.4. Understand Mac Forensics </li><li></li><li></li></ul><h4>Network Forensics </h4><ul><li>8.1. Understand Network Forensics </li><li>8.2. Explain Logging Fundamentals and Network Forensic Readiness </li><li>8.3. Summarize Event Correlation Concepts </li><li>8.4. Identify Indicators of Compromise (IoCs) from Network Logs </li><li>8.5. Investigate Network Traffic </li><li>8.6. Perform Incident Detection and Examination with SIEM Tools </li><li>8.7. Monitor and Detect Wireless Network Attacks </li><li></li></ul><h4>Investigating Web Attacks </h4><ul><li>9.1. Understand Web Application Forensics </li><li>9.2. Understand Internet Information Services (IIS) Logs </li><li>9.3. Understand Apache Web Server Logs </li><li>9.4. Understand the Functionality of Intrusion Detection System (IDS) </li><li>9.5. Understand the Functionality of Web Application Firewall (WAF) </li><li>9.6. Investigate Web Attacks on Windows-based Servers </li><li>9.7. Detect and Investigate Various Attacks on Web Applications </li><li></li></ul><h4>Dark Web Forensics </h4><ul><li>10.1. Understand the Dark Web </li><li>10.2. Determine How to Identify the Traces of Tor Browser during Investigation </li><li>10.3. Perform Tor Browser Forensics </li><li></li></ul><h4>Database Forensics </h4><ul><li>11.1. Understand Database Forensics and its Importance </li><li>11.2. Determine Data Storage and Database Evidence Repositories in MSSQL Server </li><li>11.3. Collect Evidence Files on MSSQL Server </li><li>11.4. Perform MSSQL Forensics </li><li>11.5. Understand Internal Architecture of MySQL and Structure of Data Directory </li><li>11.6. Understand Information Schema and List MySQL Utilities for Performing Forensic Analysis </li><li>11.7. Perform MySQL Forensics on WordPress Web Application Database </li><li></li></ul><h4>Cloud Forensics </h4><ul><li>12.1. Understand the Basic Cloud Computing Concepts </li><li>12.2. Understand Cloud Forensics </li><li>12.3. Understand the Fundamentals of Amazon Web Services (AWS) </li><li>12.4. Determine How to Investigate Security Incidents in AWS </li><li>12.5. Understand the Fundamentals of Microsoft Azure </li><li>12.6. Determine How to Investigate Security Incidents in Azure  </li><li>12.7. Understand Forensic Methodologies for Containers and Microservices </li><li></li></ul><h4>Investigating Email Crimes </h4><ul><li>13.1. Understand Email Basics </li><li>13.2. Understand Email Crime Investigation and its Steps </li><li>13.3. U.S. Laws Against Email Crime </li><li></li></ul><h4>Malware Forensics </h4><ul><li>14.1. Define Malware and Identify the Common Techniques Attackers Use to Spread Malware </li><li>14.2. Understand Malware Forensics Fundamentals and Recognize Types of Malware Analysis </li><li>14.3. Understand and Perform Static Analysis of Malware </li><li>14.4. Analyze Suspicious Word and PDF Documents </li><li>14.5. Understand Dynamic Malware Analysis Fundamentals and Approaches </li><li>14.6. Analyze Malware Behavior on System Properties in Real-time </li><li>14.7. Analyze Malware Behavior on Network in Real-time </li><li>14.8. Describe Fileless Malware Attacks and How they Happen </li><li>14.9. Perform Fileless Malware Analysis - Emotet </li><li></li></ul><h4>Mobile Forensics </h4><ul><li>15.1. Understand the Importance of Mobile Device Forensics </li><li>15.2. Illustrate Architectural Layers and Boot Processes of Android and iOS Devices </li><li>15.3. Explain the Steps Involved in Mobile Forensics Process </li><li>15.4. Investigate Cellular Network Data </li><li>15.5. Understand SIM File System and its Data Acquisition Method </li><li>15.6. Illustrate Phone Locks and Discuss Rooting of Android and Jailbreaking of iOS Devices </li><li>15.7. Perform Logical Acquisition on Android and iOS Devices </li><li>15.8. Perform Physical Acquisition on Android and iOS Devices </li><li>15.9. Discuss Mobile Forensics Challenges and Prepare Investigation Report </li><li></li></ul><h4>IoT Forensics </h4><ul><li>16.1. Understand IoT and IoT Security Problems </li><li>16.2. Recognize Different Types of IoT Threats </li><li>16.3. Understand IoT Forensics </li><li>16.4. Perform Forensics on IoT Devices </li><li></li></ul></div>

Nexus Human

Forensic Science

Certified Cryptocurrency Investigator Course (CCI)

Cyber Security

Certified Ethical Hacker (CEH)

Cyber Security Foundation

Ethical Hacking

EC-Council Computer Hacking Forensic Investigator (CHFI) v10.0

Redhill

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Systems & Network Training

Network & Security

Network Engineer

MySQL for developers

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

MySQL server administration

<h3><b>MySQL Performance &amp; Tuning training course description</b></h3>
        <p> This MySQL Performance &amp; Tuning course is designed
for Database Administrators, Application Developers and
Technical Consultants who need to monitor and tune the
performance of MySQL servers and databases. The
course provides practical experience in monitoring and
tuning MySQL servers and databases. <br />
<b>Note:</b><br />
This MySQL Performance &amp; Tuning course does not
cover clustering (other than at overview level),
replication or non-standard storage engines such as
Falcon and PBXT. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                       <li>Develop a monitoring and tuning plan</li>
                        <li>Use server configuration and status variables.</li>
                        <li>Identify and improve problem queries.</li>
                        <li>Make efficient use of indexes.</li>
                        <li>Monitor and size memory caches and locks.</li>
                        <li>Tune the MyISAM and InnoDB storage engine.</li>
                        <li>Evaluate the use of partitioning for performance.</li>
                                      
                  </ul>
        <h5>
        <b>MySQL Performance &amp; Tuning training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone who wishes to monitor and tune MySQL performance.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Delegates must have a working knowledge of MySQL Database Administration</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL Performance &amp; Tuning training course contents</b></h3>
      <ul>
        <li>Introduction to performance tuning </li><p>
Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals.

				</p><li>MySQL performance tuning tools </li><p>
Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog.
<br /><span>Hands on</span> Obtaining performance information.

</p><li>Schema design </li><p>
Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines.
<br /><span>Hands on</span> effects of design on performance.

</p><li>Statement tuning </li><p>
Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended.
<br /><span>Hands on</span> identifying problem queries and using explain.

</p><li>Indexes </li><p>
Index overview, Types of index, Index tuning, Indexes and joins.
<br /><span>Hands on</span> Indexes and performance.

</p><li>Server configuration and monitoring </li><p>
Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache.
<br /><span>Hands on</span> setting and interpreting server variables and caching.

</p><li>Locking </li><p>
Types of locking, locking and storage engines, effects of locking on performance.
<br /><span>Hands on</span> locking and performance.

</p><li>The InnoDB engine </li><p>
Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files.
<br /><span>Hands on</span> InnoDB configuration and performance.

</p><li>Other storage engines </li><p>
MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines.
<br /><span>Hands on</span> storage engine performance.

</p><li>Overview of clustering and performance </li><p>
Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview.

</p><li>Dumping and loading data </li><p>
SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance.
<br /><span>Hands on</span> dump and load performance.

</p><li>Partitioned tables </li><p>
Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning.
<br /><span>Hands on</span> partitioned table performance.
				</p>
      </ul>

MySQL Performance & Tuning

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

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

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

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

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

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

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

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

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

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

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

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

MySQL foundation

<h3><b>UNIX system administration training course description</b></h3>
      <p> This five day hands on course provides a
comprehensive coverage of core UNIX administration
tasks. The course covers generic UNIX and is available
for any UNIX distribution required.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			<li>Administer &amp; configure UNIX systems.</li>
					<li>Maintain UNIX by handling disk space and taking
regular backups.</li>
					<li>Manage software packages.</li>
                    <li>Perform basic troubleshooting.</li>
                    <li>Maintain a secure UNIX system.</li>
                    <li>Describe the organisation and implementation of the
filesystem.</li>                  </ul>
        <h5>
        <b>UNIX system administration training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>System administrators<br /> Network administrators.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>UNIX fundamentals.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>UNIX system administration training course contents</b></h3>
      <ul>
				<li><span>Part 1 </span></li><p>
</p><li>Exploring UNIX command-line tools </li><p>
Using a shell, shell configuration, environment variables, getting help, streams, redirection and pipes, processing text using filters, manipulating files, regular expressions, grep, sed.

			</p><li>Managing software </li><p>
Package concepts, comparison of package formats, RPM, rpm commands, yum, dpkg, apt-cache, apt-get, dselect, aptitude, converting between package formats, dependencies and conflicts, startup script problems, shared libraries, library management, managing processes, the kernel: the first process, process lists, foreground &amp; background processes, process priorities, killing processes.

</p><li>Configuring hardware </li><p>
Configuring firmware and hardware, RQs, I/O addresses, DMA addresses, Boot disks, coldplug and hotplug devices, configuring expansion cards and PCI cards, kernel modules, USB devices, UNIX USB crivers, configuring hard disks, partitioning systems, LVM, common layouts, creating partitions and filesystems, maintaining filesystem health, tuning, journals, checking filesystems, monitoring disk use, mounting and unmounting filesystems.

</p><li>Managing files </li><p>
File management commands, file naming and wildcards, file archiving, links, directory commands, file ownership and group, file access control, permissions, chmod, defaults, file attributes, disk quotas, enabling and setting quotas, locating files, the FHS.

</p><li>	Booting UNIX and editing files </li><p>
Installing boot loaders, GRUB legacy, GRUB 2, alternative boot loaders, the boot process, boot messages, runlevels and the initialization process, runlevel functions, runlevel services, alternative boot systems, upstart, system.

</p><li><span>Part 2 </span></li><p>
</p><li>Configuring the X window system </li><p>
Localization, configuring basic X features, X server options, methods of configuring X, X display information, X fonts, the X GUI login system, XDMCP server, using X for remote access, screen display settings, setting your time zone, your locale, configuring printing, conceptualizing the UNIX printing architecture, understanding PostScript and ghostscript, running a printing system, configuring CUPS, monitoring and controlling the print queue.

</p><li>Administering the system </li><p>
Managing users and groups, tuning user and system environments, using system log files, understanding syslogd, setting logging options, manually logging data, rotating l;og files, reviewing log file contents, maintaining the system time, UNIX time concepts, manually setting the time, using NTP, running jobs in the future, understanding the role of cron, creating system cron jobs, creating user cron jobs, using anacron, using at.

</p><li>Configuring basic networking </li><p>
TCP/IP, network hardware, network addresses, hostnames, network ports, configuring UNIX for a local network, configuring with DHCP, static IP address, configuring routing, using GUI configuration tools, ifup and ifdown, diagnosing network connections, testing connectivity, tracing a route, checking network status , examining network traffic, additional tools.

</p><li>Writing scripts, configuring email, and using databases </li><p>
The shell environment, aliases, shell configuration files, writing scripts, commands, variables, conditional expressions, loops, functions, managing email, choosing email software, securing your email server, managing data with SQL, picking a SQL package, understanding SQL basics, using MySQL.

</p><li>Securing your system 	 </li><p>
Administering network security, super server restrictions, disabling unused servers, administering local security, securing passwords, limiting root access, setting login, process, SUID/SGID files, configuring SSH, using GPG, generating, importing and revoking keys, encrypting and decrypting data, signing messages and verifying signatures.</p>
      </ul>

UNIX system administration

<h3><b>LPIC-1 training course description</b></h3>
      <p>   This five day hands on course provides a
comprehensive coverage of core Linux administration
tasks. The course covers generic Linux and is available
for any Linux distribution required. It closely follows the
LPIC curriculum allowing delegates to achieve the
relevant certification if required. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	 <li>Administer &amp; configure Linux systems.</li>
                    <li>Maintain Linux by handling disk space and taking
regular backups.</li>
                    <li>Manage software packages.</li>
                    <li>Perform basic troubleshooting.</li>
                    <li>Maintain a secure Linux system.</li>
                    <li>Describe the organisation and implementation of the
filesystem.</li>
                  </ul>
        <h5>
        <b>LPIC-1 training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>System administrators.<br />
                    Network administrators.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Linux fundamentals (LPI 010)
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>LPIC-1 training course contents</b></h3>
      <ul>
				<li><b>Part I Exam 101 </b></li><p>
</p><li>Exploring Linux Command-Line Tools </li><p>
Using a Shell, Shell Configuration, Environment
Variables, Getting Help, Streams, Redirection and Pipes,
Processing Text Using Filters, Manipulating files,
Regular Expressions, grep,sed.
</p><li>Managing Software </li><p>
Package Concepts, Comparison of package formats,
RPM, rpm Commands, Yum, Debian Packages, dpkg,
apt-cache, apt-get, dselect, aptitude, Converting
Between Package Formats, Dependencies and Conflicts,
Startup Script Problems, Shared Libraries, Library
Management, Managing Processes, the Kernel: The
First Process, Process Lists, Foreground &amp; Background
Processes, Process Priorities, Killing Processes.
</p><li>Configuring Hardware </li><p>
Configuring Firmware and Hardware, IRQs, I/O
Addresses, DMA Addresses, Boot Disks, Coldplug and
Hotplug Devices, Configuring Expansion Cards and PCI
Cards, Kernel Modules, USB Devices, Linux USB
Drivers, Configuring Hard Disks, Partitioning Systems,
LVM, Common Layouts, Creating Partitions and
Filesystems, Maintaining Filesystem Health, Tuning,
Journals, Checking Filesystems, Monitoring Disk Use,
Mounting and Unmounting Filesystems.
</p><li>Managing Files </li><p>
File Management Commands, File Naming and
Wildcards, File Archiving, Links, Directory Commands,
File Ownership and Group, File access control,
Permissions, chmod, Defaults, File Attributes, Disk
Quotas, Enabling and setting Quotas, Locating Files,
The FHS.
</p><li>Booting Linux and Editing Files </li><p>
Installing Boot Loaders, GRUB Legacy, GRUB 2,
Alternative Boot Loaders, the Boot Process, Boot
Messages, Runlevels and the Initialization Process,
Runlevel Functions, Runlevel Services, Alternative Boot
Systems , Upstart, system.
	</p><li><b>Part II Exam 102 265</b> </li><p>
</p><li>Securing the X Window System </li><p>
Localization, Configuring Basic X Features, X Server
Options, Methods of Configuring X, X Display
Information, X Fonts, The X GUI Login System, XDMCP
Server, Using X for Remote Access, Screen Display
Settings, Setting Your Time Zone, Your Locale,
Configuring Printing, Conceptualizing the Linux Printing
Architecture, Understanding PostScript and Ghostscript,
Running a Printing System, Configuring CUPS,
Monitoring and Controlling the Print Queue.
</p><li>Administering the System </li><p>
Managing Users and Groups, Tuning User and System
Environments, Using System Log Files, Understanding
syslogd , Setting Logging Options, Manually Logging
Data, Rotating Log Files, Reviewing Log File Contents,
Maintaining the System Time, Linux Time Concepts,
Manually Setting the Time, Using NTP, Running Jobs in
the Future, Understanding the Role of cron, Creating
System cron Jobs, Creating User cron Jobs, Using
anacron, Using at.
</p><li>Configuring Basic Networking </li><p>
TCP/IP, Network Hardware, Network Addresses,
Hostnames, Network Ports, Configuring Linux for a
Local Network, Configuring with DHCP, Static IP
Address, Configuring Routing, Using GUI Configuration
Tools, ifup and ifdown, Diagnosing Network
Connections, Testing Connectivity, Tracing a Route,
Checking Network Status , Examining Network Traffic,
Additional Tools.
</p><li>Writing Scripts, Configuring Email,
and Using Databases </li><p>
The Shell Environment, Aliases, Shell Configuration
Files, Writing Scripts, Commands, Variables,
Conditional Expressions, Loops, Functions, Managing
Email, Choosing Email Software, Securing Your Email
Server, Managing Data with SQL, Picking a SQL
Package, Understanding SQL Basics, Using MySQL
</p><li>Securing Your System </li><p>
Administering Network Security, Super Server
Restrictions, Disabling Unused Servers, Administering
Local Security, Securing Passwords, Limiting root
Access, Setting Login, Process, SUID/SGID Files,
Configuring SSH, Using GPG, Generating, Importing
and Revoking Keys, Encrypting and Decrypting Data,
Signing Messages and Verifying Signatures.
</p>
      </ul>

Linux system administration (LPIC-1)

<h3><b>Advanced Asterisk training course description</b></h3>
      <p> This 2 day hands-on Asterisk training course covers advanced Asterisk configuration including fault tolerant clusters, upgrading and patching Asterisk servers, firewall and NAT transversal, using databases to store Asterisk data. Practical sessions follow each major section to reinforce the theory.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
          <li>Configure advanced Asterisk features.</li>
										   	 <li>Utilise databases from Asterisk</li>
											 <li>Integrate Asterisk with SIP servers.</li>
                    						 <li>Build High Availability Asterisk clusters.</li>
                    						 <li>Maintain and secure Asterisk servers.</li>
                  </ul>
       
        <h5>
        <b>Advanced Asterisk training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical staff working with or evaluating Asterisk. </p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Definitive Asterisk for engineers</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Advanced Asterisk training course contents</b></h3>
      <ul>
				<li>Best Practice</li><p>
Review of basics, Channel best practice, dial plan
best practise.
				</p><li>Call Centre Features</li><p>
GUI, Asterisk Manager Interface, billing, CDR,
advanced IVR, ACD, Vici Dial. <br /><span>Hands on</span> Install
Vici-Dial
</p><li>Asterisk and Databases</li><p>
MySQL, LDAP, ODBC, dial plan from a Database,
storing CDR in a Database, <br /><span>Hands on</span> Dial plan in
MySQL, CDR in MySQL.
</p><li>TDM over Ethernet</li><p>
What is TDMoE, Asterisk to Asterisk TDMoE,
Phone Bridge. <br /><span>Hands on</span> * 2 * via TDMoE.
</p><li>High Availability Asterisk</li><p>
HA Linux - Virtual Servers, Fail-over steps, setting
up HA Linux, configuring Asterisk for fail-over on
HA Linux, <br /><span>Hands on</span> Configure Asterisk HA.
</p><li>Advanced Dial plans</li><p>
Asterisk Gateway Interface, AGI IVR applications,
Multiple switches sharing Dial plans, ENUM,
DUNDI. <br /><span>Hands on</span> Configure DUNDI.
</p><li>Integration</li><p>
Legacy PBX, SIP Proxys, OpenSER. <br /><span>Hands on</span>
Configure SER to work with Asterisk.
</p><li>Asterisk Maintenance</li><p>
Asterisk upgrades, implementing patches,
advanced debugging,
</p><li>Security</li><p>
Firewalls, NAT, Asterisk security issues. <br /><span>Hands on</span> Configure Asterisk to work through a Firewall
and NAT. 
</p>
      </ul>

Advanced Asterisk for Engineers

<h3><b>Total PHP training course description</b></h3>
      <p>   PHP provides for the creation of dynamic web sites. This hands on training course looks at programming with PHP with an emphasis of building dynamic websites. Forms, state management and database integration are all covered with practicals used throughout the course to reinforce theory sessions.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	  
                        <li>Create dynamic web sites using PHP.</li>
					<li>Write PHP programs.</li>
                    <li>Debug PHP programs.</li>
                    <li>Examine existing code and determine its function. </li>
                  </ul>
        <h5>
        <b>Total PHP training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone creating dynamic web sites.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Software development fundamentals
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Total PHP training course contents</b></h3>
      <ul>
				<li>What is PHP? </li><p>
PHP history, dynamic web pages, how PHP works, alternatives to PHP. Downloading and installing PHP. Installing MySQL, installing Apache, platform issues.

</p><li>A first PHP web page </li><p>
A basic PHP script, PHP page structure. PHP comments. Integrating PHP and HTML.

</p><li>PHP forms </li><p>
HTML forms, taking values from forms.

</p><li>PHP and HTML </li><p>
Page inputs, environment inputs. phpinfo(), other form elements, sticky fields, generalised code, tables, forms, form elements, style sheets, JavaScript.

</p><li>Variables operators and expressions </li><p>
Expressions, data types, assignments, scope, constants, HTTP environment variables, getting data from forms using variables.

</p><li>Operators </li><p>
Arithmetic, logical, relational, Boolean, others.

</p><li>Control statements </li><p>
Conditional: if, else, elseif, switch. Loops: while, do while, for, break, continue, exit.

</p><li>Functions </li><p>
Built in functions, declaration, arguments, scope, loading functions from other files, defaulting parameters, call by value/ name.

</p><li>Arrays </li><p>
Indexes, array initialisation, array manipulation, multi dimensional arrays, array functions.

</p><li>String handling </li><p>
What is a string, string functions, matching, extraction, replacement. String operations, cleansing, sprintf, formatting web pages, strops and others, splitting strings, REs.

</p><li>PHP and databases </li><p>
Database structure, Database APIs, MySQL, Creating tables, Editing tables, simple SQL queries using PHP, building HTML tables using SQL queries, SQL injection, security issues, error handling.

</p><li>File I/O </li><p>
Opening, reading, writing files. Permissions, ownership, locking, directories.

</p><li>PHP, cookies and sessions </li><p> 
State, Cookie properties, setting cookies, retrieving cookies, expiring/deleting cookies. Sessions, session variables, session IDs.

</p><li>PHP and email </li><p>
Emailing from servers, attachments.

</p><li>Objects </li><p>
OOP, PHP classes, constructors, instances.</p>
			
      </ul>

Total PHP for developers

<h3><b>Samba training course description</b></h3>
      <p>Samba enables UNIX/Linux machines to act as Microsoft File and Print servers. This two day hands on training course progresses from the basics of installing samba and simple configurations through to authentication issues and troubleshooting.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
       <li>Install and configure Samba.</li>
					<li>Administrate file and printer sharing.</li>
					<li>Secure Samba servers.</li>
                    <li>Troubleshoot Samba</li>
                  </ul>
       
        <h5>
        <b>Samba training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical staff working with Samba.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p> Intro to UNIX Systems Administration<br />
                    TCP/IP Foundation.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Samba training course contents</b></h3>
      <ul>
				<li>What is Samba?</li><p>
File and print servers, Samba server roles,
Windows networking, NetBIOS, SMB. <br /><span>Hands on</span>
Microsoft File and Print shares, analysing the
network traffic.
</p><li>Installing Samba</li><p>
Source, binaries, where to find samba, building
and compiling Samba. <br /><span>Hands on</span> Download and
install Samba.
</p><li>Controlling Samba</li><p>
Samba daemons, starting and stopping Samba,
smbcontrol, Samba net command, smb.conf.
Viewing Samba status, smbclient. <br /><span>Hands on</span>
Starting and stopping Samba, testing the server.
</p><li>Samba configuration</li><p>
Simple shares, smb.conf variables, configuration
from a web browser, swat, enabling access to
swat. <br /><span>Hands on</span> Configuring samba servers and
clients.
</p><li>File sharing</li><p>
Basic shares, [homes], locking options, UNIX file
permissions, controlling user access, Windows
ACLs, virtual samba servers, browsing. <br /><span>Hands on</span>
File sharing and browsing.
</p><li>Print sharing</li><p>
Sharing printers, UNIX printing, CUPS, printer
drivers, [printers], PRINT$. <br /><span>Hands on</span> Samba print
server.
</p><li>Authentication</li><p>
Workgroups, domains, users and passwords,
Samba domain security, Samba password
backends: smbpasswd, tdbsam, nisplus, mysql,
Active Directory. <br /><span>Hands on</span> Securing samba
shares.
	</p><li>Troubleshooting</li><p>
Logging options, controlling logs, Samba utilities,
network protocols, .SMB/CIFS. Performance
tuning. <br /><span>Hands on</span> Troubleshooting Samba 
</p>
      </ul>

331 Courses delivered Online

MySql Masterclass Course

By NextGen Learning

The Complete jQuery Course - Beginner to Professional

By Packt

The Complete MySQL Server from Scratch: Bootcamp Course

By NextGen Learning

Master Big Data Ingestion and Analytics with Flume, Sqoop, Hive and Spark

By Packt

Computing and Technology Course

By One Education

Software Engineering - Software Development Course

By One Education

Java Certification: Javascript with Coding, HTML, & CSS Training Course

By Compliance Central

Node JS Fundamentals Course

By One Education

Node JS Fundamentals Course

By One Education

Node JS Fundamentals Course

By One Education