Name: Learn Linux in 5 Days
Price: 12 GBP
Availability: InStock

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span lang="EN-GB">This comprehensive course on <strong>Django Rest Framework Level 4</strong> will deepen your understanding on this topic.</span></p><p><span lang="EN-GB">After successful completion of this course you can acquire the required skills in this sector. This <strong>Django Rest Framework Level 4</strong> comes with accredited certification, which will enhance your CV and make you worthy in the job market.</span></p><p><span lang="EN-GB">So enrol in this course today to fast track your career ladder.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span lang="EN-GB">There is no experience or previous qualifications required for enrolment on this <strong>Django Rest Framework Level 4</strong>. It is available to all students, of all academic backgrounds.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span lang="EN-GB">Our <strong>Django Rest Framework Level 4</strong> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</span></p><p><span lang="EN-GB">There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span lang="EN-GB">Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>15 sections • 82 lectures • 04:40:00 total length</p></div><div><div><div><div><div><div><div><p>•Module 01: Course and Instructor Introduction: 00:03:00</p></div><div><div><p>•Module 02: How to make the best of this course: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: What is REST?: 00:06:00</p></div><div><div><p>•Module 02: Why REST: 00:08:00</p></div><div><div><p>•Module 03: What and Why DJango REST Framework: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Install DJango: 00:03:00</p></div><div><div><p>•Module 02: Install DJango REST Framework: 00:01:00</p></div><div><div><p>•Module 03: Install MySql and MySql workbench: 00:03:00</p></div><div><div><p>•Module 04: Launch MySql workbench: 00:02:00</p></div><div><div><p>•Module 05: Install python mysqlclient: 00:01:00</p></div><div><div><p>•Module 06: Install ATOM: 00:03:00</p></div><div><div><p>•Module 07: Install Postman: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Create the project: 00:02:00</p></div><div><div><p>•Module 02: Create a view: 00:02:00</p></div><div><div><p>•Module 03: Configure the URL and TEST: 00:03:00</p></div><div><div><p>•Module 04: Create app level urls: 00:02:00</p></div><div><div><p>•Module 05: Create a model class: 00:03:00</p></div><div><div><p>•Module 06: Configure the database and run migrations: 00:03:00</p></div><div><div><p>•Module 07: Use the model in the view and test: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: DRF Components: 00:06:00</p></div><div><div><p>•Module 02: Function Based Views: 00:05:00</p></div><div><div><p>•Module 03: Serializers: 00:04:00</p></div><div><div><p>•Module 04: Create the Project: 00:02:00</p></div><div><div><p>•Module 05: Create the Model: 00:02:00</p></div><div><div><p>•Module 06: Create the Serializer: 00:02:00</p></div><div><div><p>•Module 07: GET single student: 00:04:00</p></div><div><div><p>•Module 08: Create Student: 00:04:00</p></div><div><div><p>•Module 09: Implement Non Primary Key Based Operations: 00:07:00</p></div><div><div><p>•Module 10: Use @api_view: 00:01:00</p></div><div><div><p>•Module 11: Configure the URLs: 00:02:00</p></div><div><div><p>•Module 12: Test: 00:07:00</p></div><div><div><p>•Module 13: Test Using Postman: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Introduction: 00:01:00</p></div><div><div><p>•Module 02: Create the Project: 00:01:00</p></div><div><div><p>•Module 03: Implement Non Primary Key Based Operations: 00:06:00</p></div><div><div><p>•Module 04: Implement Primary Key Based Operations: 00:07:00</p></div><div><div><p>•Module 05: Configure the URLs and TEST: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Introduction: 00:05:00</p></div><div><div><p>•Module 02: Non Primary Key based operations: 00:04:00</p></div><div><div><p>•Module 03: Primary Key based operations: 00:02:00</p></div><div><div><p>•Module 04: Configure the URLs and TEST: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Generics: 00:03:00</p></div><div><div><p>•Module 02: Generics in action: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Introduction: 00:03:00</p></div><div><div><p>•Module 02: Create ViewSet: 00:02:00</p></div><div><div><p>•Module 03: Configure URLs and Test: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Create the Project: 00:03:00</p></div><div><div><p>•Module 02: Create model: 00:03:00</p></div><div><div><p>•Module 03: Create Serializers: 00:04:00</p></div><div><div><p>•Module 04: Create REST endpoints: 00:03:00</p></div><div><div><p>•Module 05: Configure URLs: 00:02:00</p></div><div><div><p>•Module 06: Test: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Introduction: 00:06:00</p></div><div><div><p>•Module 02: Pagination in action: 00:05:00</p></div><div><div><p>•Module 03: Pagination at class level: 00:03:00</p></div><div><div><p>•Module 04: Using LimitOffsetPagination: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Introduction: 00:04:00</p></div><div><div><p>•Module 02: Authentication in action: 00:03:00</p></div><div><div><p>•Module 03: Authorization in action: 00:06:00</p></div><div><div><p>•Module 04: Global Security: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Usecase: 00:01:00</p></div><div><div><p>•Module 02: Create the Project: 00:01:00</p></div><div><div><p>•Module 03: Create Model Classes: 00:03:00</p></div><div><div><p>•Module 04: Create Reservation Model: 00:01:00</p></div><div><div><p>•Module 05: Create Serializers: 00:01:00</p></div><div><div><p>•Module 06: Create ViewSets: 00:02:00</p></div><div><div><p>•Module 07: Configure the Router: 00:02:00</p></div><div><div><p>•Module 08: Run Migrations: 00:01:00</p></div><div><div><p>•Module 09: Initial round of testing: 00:04:00</p></div><div><div><p>•Module 10: Implement findFlights endpoint: 00:03:00</p></div><div><div><p>•Module 11: Test findFlights: 00:05:00</p></div><div><div><p>•Module 12: Implement Save Reservation: 00:06:00</p></div><div><div><p>•Module 13: Test Save Reservation: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: In-Built Validations: 00:04:00</p></div><div><div><p>•Module 02: Allowing Blank and Null Values: 00:02:00</p></div><div><div><p>•Module 03: Create Custom Validator: 00:05:00</p></div><div><div><p>•Module 04: Two more ways: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Introduction: 00:03:00</p></div><div><div><p>•Module 02: Configure Token Auth: 00:05:00</p></div><div><div><p>•Module 03: Create Users and Token: 00:04:00</p></div><div><div><p>•Module 04: Token Auth in action: 00:03:00</p></div><div><div><p>•Module 05: Automate Token Creation: 00:09:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Online Course Creation

Trainers Course

Django Rest Framework Level 4

General Admission

<h3><strong>Overview</strong></h3>
<span>Acquire the language of databases with this <strong>SQL Programming Complete Bundle</strong></span><b> </b><span>course. </span><span>In this data-driven world, data </span><span>is used</span><span> to make strategies, find solutions and do a thousand other </span><span>tasks</span><span>. Businesses </span><span>across the world</span><span> are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This <strong>SQL Programming Complete Bundle</strong></span><b> </b><span>course will teach you the language of databases, SQL</span><span>,</span><span> and </span><span>help</span><span> you </span><span>gain</span><span> proficiency in SQL tools. </span>
<h3><strong>How will I get my certificate?</strong></h3>
At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price.
<h3><strong>Who is this course for?</strong></h3>
There is no experience or previous qualifications required for enrolment on this <strong>SQL Programming Complete Bundle</strong>. It is available to all students, of all academic backgrounds.
<h3><strong>Requirements</strong></h3>
Our <strong>SQL Programming Complete Bundle</strong> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace.
<h3><strong>Career path</strong></h3>
Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management , Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc. <h3>Course Curriculum</h3><div><p>9 sections • 53 lectures • 07:50:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:04:00</p></div><div><div><p>•Course Curriculum Overview: 00:05:00</p></div><div><div><p>•Overview of Databases: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•MySQL Installation: 00:16:00</p></div><div><div><p>•MySQL Workbench Installation: 00:09:00</p></div><div><div><p>•Connecting to MySQL using Console: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Overview of Challenges: 00:04:00</p></div><div><div><p>•SQL Statement Basic: 00:16:00</p></div><div><div><p>•SELECT Statement: 00:09:00</p></div><div><div><p>•SELECT DISTINCT: 00:05:00</p></div><div><div><p>•Column AS Statement: 00:12:00</p></div><div><div><p>•COUNT built-in Method usage: 00:11:00</p></div><div><div><p>•SELECT WHERE Clause - Part One: 00:05:00</p></div><div><div><p>•SELECT WHERE Clause - Part Two: 00:11:00</p></div><div><div><p>•SQL Statement Basic: 00:16:00</p></div><div><div><p>•SQL Limit Clause Statement: 00:09:00</p></div><div><div><p>•SQL Using BETWEEN with Same Column Data: 00:11:00</p></div><div><div><p>•How to Apply IN Operator: 00:11:00</p></div><div><div><p>•Wildcard Characters with LIKE and ILIKE: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Overview of GROUP BY: 00:06:00</p></div><div><div><p>•Aggregation function SUM(): 00:09:00</p></div><div><div><p>•Aggregation MIN() and MAX(): 00:05:00</p></div><div><div><p>•GROUP BY - One: 00:09:00</p></div><div><div><p>•GROUP BY - Two: 00:12:00</p></div><div><div><p>•HAVING Clause: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Overview of JOINS: 00:04:00</p></div><div><div><p>•Introduction to JOINS: 00:04:00</p></div><div><div><p>•AS Statement table: 00:03:00</p></div><div><div><p>•INNER Joins: 00:14:00</p></div><div><div><p>•FULL Outer Join: 00:11:00</p></div><div><div><p>•LEFT Outer JOIN: 00:08:00</p></div><div><div><p>•RIGHT JOIN: 00:08:00</p></div><div><div><p>•Union: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Timestamps: 00:12:00</p></div><div><div><p>•EXTRACT from timestamp: 00:10:00</p></div><div><div><p>•Mathematical Functions: 00:12:00</p></div><div><div><p>•String Functions: 00:22:00</p></div><div><div><p>•SUBQUERY: 00:13:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Basic of Database and Tables: 00:06:00</p></div><div><div><p>•DataTypes: 00:10:00</p></div><div><div><p>•Primarykey and Foreignkey: 00:06:00</p></div><div><div><p>•Create Table in SQL Script: 00:13:00</p></div><div><div><p>•Insert: 00:11:00</p></div><div><div><p>•Update: 00:07:00</p></div><div><div><p>•Delete: 00:04:00</p></div><div><div><p>•Alter Table: 00:09:00</p></div><div><div><p>•Drop Table: 00:05:00</p></div><div><div><p>•NOT NULL Constraint: 00:08:00</p></div><div><div><p>•UNIQUE Constraint: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Creating a Database backup: 00:12:00</p></div><div><div><p>•10a Overview of Databases and Tables: 00:05:00</p></div><div><div><p>•10c Restoring a Database: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - SQL Programming Complete Bundle: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Computing Skills

Microsoft SQL

Database Programming

AWS Certified Database

SQL Programming Complete Bundle

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>SQL NoSQL Big Data and Hadoop</span></b> will deepen your understanding on this topic.</p><p><span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>SQL NoSQL Big Data and Hadoop</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>SQL NoSQL Big Data and Hadoop</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>SQL NoSQL Big Data and Hadoop</span></b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p><span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>14 sections • 130 lectures • 22:34:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:07:00</p></div><div><div><p>•Building a Data-driven Organization - Introduction: 00:04:00</p></div><div><div><p>•Data Engineering: 00:06:00</p></div><div><div><p>•Learning Environment &amp; Course Material: 00:04:00</p></div><div><div><p>•Movielens Dataset: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Relational Databases: 00:09:00</p></div><div><div><p>•SQL: 00:05:00</p></div><div><div><p>•Movielens Relational Model: 00:15:00</p></div><div><div><p>•Movielens Relational Model: Normalization vs Denormalization: 00:16:00</p></div><div><div><p>•MySQL: 00:05:00</p></div><div><div><p>•Movielens in MySQL: Database import: 00:06:00</p></div><div><div><p>•OLTP in RDBMS: CRUD Applications: 00:17:00</p></div><div><div><p>•Indexes: 00:16:00</p></div><div><div><p>•Data Warehousing: 00:15:00</p></div><div><div><p>•Analytical Processing: 00:17:00</p></div><div><div><p>•Transaction Logs: 00:06:00</p></div><div><div><p>•Relational Databases  - Wrap Up: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Distributed Databases: 00:07:00</p></div><div><div><p>•CAP Theorem: 00:10:00</p></div><div><div><p>•BASE: 00:07:00</p></div><div><div><p>•Other Classifications: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to KV Stores: 00:02:00</p></div><div><div><p>•Redis: 00:04:00</p></div><div><div><p>•Install Redis: 00:07:00</p></div><div><div><p>•Time Complexity of Algorithm: 00:05:00</p></div><div><div><p>•Data Structures in Redis : Key &amp; String: 00:20:00</p></div><div><div><p>•Data Structures in Redis II : Hash &amp; List: 00:18:00</p></div><div><div><p>•Data structures in Redis III : Set &amp; Sorted Set: 00:21:00</p></div><div><div><p>•Data structures in Redis IV : Geo &amp; HyperLogLog: 00:11:00</p></div><div><div><p>•Data structures in Redis V : Pubsub &amp; Transaction: 00:08:00</p></div><div><div><p>•Modelling Movielens in Redis: 00:11:00</p></div><div><div><p>•Redis Example in Application: 00:29:00</p></div><div><div><p>•KV Stores: Wrap Up: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Document-Oriented Databases: 00:05:00</p></div><div><div><p>•MongoDB: 00:04:00</p></div><div><div><p>•MongoDB Installation: 00:02:00</p></div><div><div><p>•Movielens in MongoDB: 00:13:00</p></div><div><div><p>•Movielens in MongoDB: Normalization vs Denormalization: 00:11:00</p></div><div><div><p>•Movielens in MongoDB: Implementation: 00:10:00</p></div><div><div><p>•CRUD Operations in MongoDB: 00:13:00</p></div><div><div><p>•Indexes: 00:16:00</p></div><div><div><p>•MongoDB Aggregation Query - MapReduce function: 00:09:00</p></div><div><div><p>•MongoDB Aggregation Query - Aggregation Framework: 00:16:00</p></div><div><div><p>•Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00</p></div><div><div><p>•Document Stores: Wrap Up: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Search Engine Stores: 00:05:00</p></div><div><div><p>•Elasticsearch: 00:09:00</p></div><div><div><p>•Basic Terms Concepts and Description: 00:13:00</p></div><div><div><p>•Movielens in Elastisearch: 00:12:00</p></div><div><div><p>•CRUD in Elasticsearch: 00:15:00</p></div><div><div><p>•Search Queries in Elasticsearch: 00:23:00</p></div><div><div><p>•Aggregation Queries in Elasticsearch: 00:23:00</p></div><div><div><p>•The Elastic Stack (ELK): 00:12:00</p></div><div><div><p>•Use case: UFO Sighting in ElasticSearch: 00:29:00</p></div><div><div><p>•Search Engines: Wrap Up: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Columnar databases: 00:06:00</p></div><div><div><p>•HBase: 00:07:00</p></div><div><div><p>•HBase Architecture: 00:09:00</p></div><div><div><p>•HBase Installation: 00:09:00</p></div><div><div><p>•Apache Zookeeper: 00:06:00</p></div><div><div><p>•Movielens Data in HBase: 00:17:00</p></div><div><div><p>•Performing CRUD in HBase: 00:24:00</p></div><div><div><p>•SQL on HBase - Apache Phoenix: 00:14:00</p></div><div><div><p>•SQL on HBase - Apache Phoenix - Movielens: 00:10:00</p></div><div><div><p>•Demo : GeoLife GPS Trajectories: 00:02:00</p></div><div><div><p>•Wide Column Store: Wrap Up: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Time Series: 00:09:00</p></div><div><div><p>•InfluxDB: 00:03:00</p></div><div><div><p>•InfluxDB Installation: 00:07:00</p></div><div><div><p>•InfluxDB Data Model: 00:07:00</p></div><div><div><p>•Data manipulation in InfluxDB: 00:17:00</p></div><div><div><p>•TICK Stack I: 00:12:00</p></div><div><div><p>•TICK Stack II: 00:23:00</p></div><div><div><p>•Time Series Databases: Wrap Up: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Graph Databases: 00:05:00</p></div><div><div><p>•Modelling in Graph: 00:14:00</p></div><div><div><p>•Modelling Movielens as a Graph: 00:10:00</p></div><div><div><p>•Neo4J: 00:04:00</p></div><div><div><p>•Neo4J installation: 00:08:00</p></div><div><div><p>•Cypher: 00:12:00</p></div><div><div><p>•Cypher II: 00:19:00</p></div><div><div><p>•Movielens in Neo4J: Data Import: 00:17:00</p></div><div><div><p>•Movielens in Neo4J: Spring Application: 00:12:00</p></div><div><div><p>•Data Analysis in Graph Databases: 00:05:00</p></div><div><div><p>•Examples of Graph Algorithms in Neo4J: 00:18:00</p></div><div><div><p>•Graph Databases: Wrap Up: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Big Data With Apache Hadoop: 00:06:00</p></div><div><div><p>•Big Data Storage in Hadoop (HDFS): 00:16:00</p></div><div><div><p>•Big Data Processing : YARN: 00:11:00</p></div><div><div><p>•Installation: 00:13:00</p></div><div><div><p>•Data Processing in Hadoop (MapReduce): 00:14:00</p></div><div><div><p>•Examples in MapReduce: 00:25:00</p></div><div><div><p>•Data Processing in Hadoop (Pig): 00:12:00</p></div><div><div><p>•Examples in Pig: 00:21:00</p></div><div><div><p>•Data Processing in Hadoop (Spark): 00:23:00</p></div><div><div><p>•Examples in Spark: 00:23:00</p></div><div><div><p>•Data Analytics with Apache Spark: 00:09:00</p></div><div><div><p>•Data Compression: 00:06:00</p></div><div><div><p>•Data serialization and storage formats: 00:20:00</p></div><div><div><p>•Hadoop: Wrap Up: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction Big Data SQL Engines: 00:03:00</p></div><div><div><p>•Apache Hive: 00:10:00</p></div><div><div><p>•Apache Hive : Demonstration: 00:20:00</p></div><div><div><p>•MPP SQL-on-Hadoop: Introduction: 00:03:00</p></div><div><div><p>•Impala: 00:06:00</p></div><div><div><p>•Impala : Demonstration: 00:18:00</p></div><div><div><p>•PrestoDB: 00:13:00</p></div><div><div><p>•PrestoDB : Demonstration: 00:14:00</p></div><div><div><p>•SQL-on-Hadoop: Wrap Up: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Data Architectures: 00:05:00</p></div><div><div><p>•Introduction to Distributed Commit Logs: 00:07:00</p></div><div><div><p>•Apache Kafka: 00:03:00</p></div><div><div><p>•Confluent Platform Installation: 00:10:00</p></div><div><div><p>•Data Modeling in Kafka I: 00:13:00</p></div><div><div><p>•Data Modeling in Kafka II: 00:15:00</p></div><div><div><p>•Data Generation for Testing: 00:09:00</p></div><div><div><p>•Use case: Toll fee Collection: 00:04:00</p></div><div><div><p>•Stream processing: 00:11:00</p></div><div><div><p>•Stream Processing II with Stream + Connect APIs: 00:19:00</p></div><div><div><p>•Example: Kafka Streams: 00:15:00</p></div><div><div><p>•KSQL : Streaming Processing in SQL: 00:04:00</p></div><div><div><p>•KSQL: Example: 00:14:00</p></div><div><div><p>•Demonstration: NYC Taxi and Fares: 00:01:00</p></div><div><div><p>•Streaming: Wrap Up: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Database Polyglot: 00:04:00</p></div><div><div><p>•Extending your knowledge: 00:08:00</p></div><div><div><p>•Data Visualization: 00:11:00</p></div><div><div><p>•Building a Data-driven Organization - Conclusion: 00:07:00</p></div><div><div><p>•Conclusion: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Data Engineering

Hadoop

Data Skills

SQL NoSQL Big Data and Hadoop

<div>
	<h3><b>Description:</b></h3>
<p>In today's world websites are a basic necessity for everyone. All businesses have a website to advertise their products and services to existing and new customers. This course is <b>what you need to understand</b> web development basics as it will help you discover niche, identify platforms, select web host, use SEO &amp; social sites and more. You do not want to fall behind everyone else, which is why you should consider taking this <b>accredited Web Development Complete Course.</b></p>
<p>You will be able to find out website design terminologies, discover new techniques to build your website for free, creating your site layout and a lot more. This is all geared towards helping you build your desired websites. In the next section, you focus on<b> programming languages including HTML, CSS and PHP</b> to see if these intrigue you enough to take the challenging yet unique road to web development. If you decide against that though, this course is prepared to teach you to use Joomla in order to <b>get started in creating</b> your first ever website.</p>
<h3><b>Who is the course for?</b></h3>
<ul>
<li><span>People who want to learn PHP, HTML and CSS programming</span></li>
<li><span>People interested in website development</span></li>
<li><span>Entrepreneurs or business owners wanting to develop a website for their business</span></li>
</ul>
<h3><b>Entry Requirement:</b></h3>
<ul>
<li><span>This course is available to all learners, of all academic backgrounds.</span></li>
<li><span>Learners should be aged 16 or over to undertake the qualification.</span></li>
<li><span>Good understanding of English language, numeracy and ICT are required to attend this course.</span></li>
</ul>
<h3><b>Assessment:  </b></h3>
<ul>
<li><span>At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.</span></li>
<li><span>Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam.</span></li>
</ul>
<h3><b>Certification:</b></h3>
<ul>
<li><span>After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24.</span></li>
<li><span>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</span></li>
</ul>
<h3><b>Why choose us?</b></h3>
<ul>
<li><span>Affordable, engaging &amp; high-quality e-learning study materials;</span></li>
<li><span>Tutorial videos/materials from the industry leading experts;</span></li>
<li><span>Study in a user-friendly, advanced online learning platform;</span></li>
<li><span>Efficient exam systems for the assessment and instant result;</span></li>
<li><span>The UK &amp; internationally recognized accredited qualification;</span></li>
<li><span>Access to course content on mobile, tablet or desktop from anywhere anytime;</span></li>
<li><span>The benefit of career advancement opportunities;</span></li>
<li><span>24/7 student support via email.</span></li>
</ul>
<h3><b>Career Path:</b></h3>
<p><span>Web Development Complete Course is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as:</span></p>
<ul>
<li><span>Web developers</span></li>
<li><span>Entrepreneurs</span></li>
<li><span>Website designers</span></li>
<li><span>Programmers</span></li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Basic Coding for Web Development</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>HTML Basics</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>CSS Basics</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Web Design &amp; Development: HTML5, CSS3 and JavaScript</td>
					<td> </td>
					<td><span><i></i> 02:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Web Development Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Are Niche Website?</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Role Of Visualization In Education</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Identify Your Best Platform Or Software</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Select A Web Host</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Collect Your Site</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Building A Content Rich Website</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Build Backlinks</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use SEO, Multimedia And Social Sites</td>
					<td> </td>
					<td><span><i></i> 01:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Analytics</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Web Designing</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Best Website Design for Your Business</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What's in a Domain Suffixes</td>
					<td> </td>
					<td><span><i></i> 00:31:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Website Design Terminology</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>CSS Explanation</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Website Designs &amp; Power Stations</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How Can I Build my Website for Free</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Six Steps to Website Design for Beginners</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dreamweaver or CoffeeCup for Website Design</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Dreamweaver to Create your Site Layout</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Three Crucial Steps to Creating Your Website</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dos and Don'ts of Website Creation9</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SEO Basics for Effective Website Design</td>
					<td> </td>
					<td><span><i></i> 01:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Ideas for Your Internet Business Website Design</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Immediately Applicable Design Tips for a User-Friendly Website</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6 Best Reasons to Create a Website</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Common Mistakes in Website Design</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Too Much or Too Little</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Why Successful Website Development is Committed to Design</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Ideas for Your Personal Website Design</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to Create a Social Networking Website to Enhance your Business</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tips for Designing an Affiliate Website</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to Use WordPress for your Website</td>
					<td> </td>
					<td><span><i></i> 01:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Top 14 Reasons to Create a Blog</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tips for Designing a Successful Blog</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>More Tips Ahead</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">PHP Programming</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Welcome to the world of programming!</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Getting Started</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Let's Start Coding!</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PHP Strings</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PHP Variables</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Useful Variables</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PHP Includes &amp; Problem Solving</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tip When Creating Inc Pages</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Redirecting Using PHP</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Multiple Conditions</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PHP Arrays</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PHP Loops</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Note on PHP Math Functions:</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Functions</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PHP Sessions</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Cookies</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to MySQL</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Making The Connection</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting Data</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Deleting / Removing Data</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using Joomla</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>INTRODUCTION TO JOOMLA</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SCOPE OF JOOMLA</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>BENEFITS OF JOOMLA</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>COMPARISON WITH OTHER CONTENT MANAGEMENT SYSTEMS</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>WHY DEVELOPERS DRAWS TO JOOMLA?</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How do I in install Joomla?</td>
					<td> </td>
					<td><span><i></i> 03:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Refer A Friend</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Refer A Friend</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam- Web Development Complete Course</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- Web Development Complete Course</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

John Academy

Online Course Marketing

Web Development

Web Developer

Web Design

Web Development Complete Course

<p>The Web Applications for Specialisation on Development is all you need to advance your career in the relevant fields.</p><p>Enrol now to discover everything you need to know about The Web Applications for Specialisation on Development and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><p><strong>Section 01: CSS Introduction</strong></p><ul><li>Introduction</li><li>How to ask a great questions</li><li>Introduction CSS</li><li>Choosing Code Editor</li><li>Installing Code Editor (Sublime Text)</li><li>CSS Syntax</li><li>Creating a first page with CSS Style</li></ul><p><strong>Section 02: CSS Basic</strong></p><ul><li>Inline CSS</li><li>Internal CSS</li><li>External CSS</li><li>CSS Classes</li><li>CSS IDs</li><li>Colors</li><li>Backgrounds</li><li>Floating</li><li>Positioning</li><li>Margins</li><li>Padding</li><li>Borders</li></ul><p><strong>Section 03: CSS Intermediate</strong></p><ul><li>Styling Text</li><li>Aligning Text</li><li>Styling Links</li><li>Font Family</li><li>Font Styles</li><li>Applying Google Fonts</li><li>Box Model</li><li>Icons</li><li>Tables</li><li>Navigation-Menu</li><li>Dropdowns</li></ul><p><strong>Section 04: CSS Advanced</strong></p><ul><li>Advanced Selectors</li><li>Forms</li><li>Website Layout</li><li>Rounded Corners</li><li>Color Keywords</li><li>Animations</li><li>Pseudo Classes</li><li>Gradients</li><li>Shadows</li><li>Calculations</li><li>Creating Responsive Page</li></ul><p><strong>Section 05: CSS Expert</strong></p><ul><li>Button Styles</li><li>Pagination</li><li>Multiple Columns</li><li>Image Reflection</li><li>UI - UX Design</li><li>Social Media Icons</li><li>External CSS Style adding</li></ul><p><strong>Section 06: PHP Introduction</strong></p><ul><li>What is PHP</li><li>Installing XAMPP for PHP, MySQL and Apache</li><li>Installing Code Editor(Visual Studio Code)</li><li>Creating PHP Project on XAMPP</li><li>Hello World Program</li></ul><p><strong>Section 07: PHP Basic</strong></p><ul><li>Variables</li><li>Echo and Print</li><li>Data Types</li><li>Numbers</li><li>Boolean</li><li>Arrays</li><li>Multi-Dimensional Array</li><li>Sorting Arrays</li><li>Constants</li></ul><p><strong>Section 08: PHP Strings</strong></p><ul><li>Strings</li><li>String Formatting</li><li>String Methods</li><li>Coding Exercise</li><li>Solution for Coding Exercise</li></ul><p><strong>Section 09: PHP Operators</strong></p><ul><li>Arithmetic operators</li><li>Assignment operators</li><li>Comparison operators</li><li>Increment - decrement operators</li><li>Logical operators</li><li>Ternary operator</li></ul><p><strong>Section 10: PHP Decision making system</strong></p><ul><li>If statement</li><li>If-else statement</li><li>If-elseif-else statement</li><li>Switch-case statement</li></ul><p><strong>Section 11: PHP Control flow statements</strong></p><ul><li>Flow Chart</li><li>While loop</li><li>Do-while loop</li><li>For loop</li><li>For each loop</li><li>Coding Exercise</li><li>Solution for Coding Exercise</li></ul><p><strong>Section 12: PHP Functions</strong></p><ul><li>Creating a Function</li><li>Function with Arguments</li><li>Default Argument</li><li>Function return values</li><li>Call-by-value</li><li>Call-by-reference</li></ul><p><strong>Section 13: PHP Super globals</strong></p><ul><li>$_POST Method</li><li>$_GET Method</li></ul><p><strong>Section 14: PHP Advanced </strong></p><ul><li>Form Handling</li><li>Date and Time</li><li>Include</li><li>Require</li><li>Sessions</li><li>File Reading</li><li>File Upload</li></ul><p><strong>Section 15: PHP Object oriented programming[OOPs]</strong></p><ul><li>What is OOP</li><li>Class and Objects</li><li>Constructor</li><li>Destructor</li><li>Access Modifiers</li><li>Inheritance</li><li>Method overriding</li><li>Abstract Class</li><li>Interface</li></ul><p><strong>Section 16: PHP - MySQL Application [CRUD]</strong></p><ul><li>MySQL Basic PhpMyAdmin</li><li>Creating Database and Table</li><li>Database Connection</li><li>PHP Form Create records</li><li>PHP Form Reading records</li><li>PHP Form Update Data</li><li>PHP Form Delete records</li></ul><p><strong>Section 17: PHP Real world code forms</strong></p><ul><li>Registration Form</li><li>MD5 Algorithm for Encrypting</li><li>Sha Algorithm</li><li>Login Form</li></ul><p><strong>Section 18: PHP Validations</strong></p><ul><li>On Submit Validation</li><li>Input Numeric Validation</li><li>Login Form Validation</li><li>Form Server-side all Data Validation</li><li>Form Server-side Validation</li></ul><p><strong>Section 19: PHP Error handling</strong></p><ul><li>Try-throw-catch</li><li>Try-throw-catch-finally</li></ul><p><strong>Section 20: MYSQL introduction </strong></p><ul><li>Overview of Databases</li><li>MySQL Installation</li><li>MySQL Workbench Installation</li><li>Connecting to MySQL using Console</li></ul><p><strong>Section 21: MySQL basic</strong></p><ul><li>Overview of Challenges</li><li>SQL Statement Basic</li><li>SELECT Statement</li><li>SELECT DISTINCT</li><li>Column AS Statement</li><li>COUNT function</li></ul><p><strong>Section 22: MySQL filtering data</strong></p><ul><li>SELECT WHERE Clause - One</li><li>SELECT WHERE Clause - Two</li><li>ORDER BY</li><li>LIMIT</li><li>BETWEEN</li><li>IN Operator</li><li>LIKE and ILIKE</li></ul><p><strong>Section 23: MySQL functions</strong></p><ul><li>Overview of GROUP BY</li><li>Aggregation function SUM()</li><li>Aggregation MIN() and MAX()</li><li>GROUP BY - One</li><li>GROUP BY - Two</li><li>HAVING Clause</li></ul><p><strong>Section 24: MySQL joins</strong></p><ul><li>Overview Assessment</li><li>Overview of JOINS</li><li>Introduction to JOINS</li><li>AS Statement table</li><li>INNER JOIN</li><li>FULL Outer Join</li><li>LEFT Outer JOIN</li><li>RIGHT JOIN</li><li>Union</li></ul><p><strong>Section 25: MySQL advanced commands </strong></p><ul><li>Advanced SQL Commands</li><li>Timestamps</li><li>EXTRACT from timestamp</li><li>Mathematical Functions</li><li>String Functions</li><li>SUBQUERY</li></ul><p><strong>Section 26: MySQL structure creation</strong></p><ul><li>Database and Tables</li><li>Data Types</li><li>Primary key and Foreign key</li><li>Create Table in SQL Script</li></ul><p><strong>Section 27: MySQL data queries</strong></p><ul><li>Insert</li><li>Update</li><li>Delete</li></ul><p><strong>Section 28: MySQL structure queries</strong></p><ul><li>Alter Table</li><li>Drop Table</li></ul><p><strong>Section 29: MySQL constraints</strong></p><ul><li>NOT NULL Constraint</li><li>UNIQUE Constraint</li></ul><p><strong>Section 30: MySQL backup and restore</strong></p><ul><li>Overview of Databases and Tables</li><li>Backup database using phpMyAdmin</li><li>Restoring a Database</li></ul><p><strong>Course Assessment </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 will be 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 order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Exam &amp; Retakes:</strong><br />It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.</p><p><strong>Certification</strong><br />Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Web Applications for Specialisation on Development course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Web Applications for Specialisation on Development course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon successful completion of The Web Applications for Specialisation on Development Course, learners will be equipped with many indispensable skills and have the opportunity to grab.</p>
                        </div>

One Education

Web Applications for Specialisation on Development Course

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on <strong>Data Visualization and Reporting with Power BI</strong></span> will deepen your understanding on this topic.</p>
<p><span><span>After successful completion of this course you can acquire the required skills in this sector. This <strong>Data Visualization and Reporting with Power BI</strong></span> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p>
<p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.<br /></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this <strong>Data Visualization and Reporting with Power BI</strong></span>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our <strong>Data Visualization and Reporting with Power BI</strong></span> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p><span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>15 sections • 140 lectures • 14:25:00 total length</p></div><div><div><div><div><div><div><div><p>•Welcome!: 00:01:00</p></div><div><div><p>•What is Power BI?: 00:03:00</p></div><div><div><p>•Download &amp; Installing Power BI Desktop: 00:04:00</p></div><div><div><p>•Getting to know the interface: 00:03:00</p></div><div><div><p>•Mini Project: Transform Data: 00:07:00</p></div><div><div><p>•Mini Project: Visualize Data: 00:05:00</p></div><div><div><p>•Mini Project: Creating a Data Model: 00:07:00</p></div><div><div><p>•Course Outline: What will you learn in this course?: 00:05:00</p></div><div><div><p>•How to learn best with this course?: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Creating our initial project file: 00:04:00</p></div><div><div><p>•Working with the attached project files: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Exploring the Query Editor: 00:06:00</p></div><div><div><p>•Connecting to our data source: 00:07:00</p></div><div><div><p>•Editing rows: 00:08:00</p></div><div><div><p>•Changing data types: 00:08:00</p></div><div><div><p>•Replacing values: 00:03:00</p></div><div><div><p>•Close &amp; Apply: 00:03:00</p></div><div><div><p>•Connecting to a csv file: 00:03:00</p></div><div><div><p>•Connecting to a web page: 00:05:00</p></div><div><div><p>•Extracting characters: 00:06:00</p></div><div><div><p>•Splitting &amp; merging columns: 00:09:00</p></div><div><div><p>•Creating conditional columns: 00:06:00</p></div><div><div><p>•Creating columns from examples: 00:09:00</p></div><div><div><p>•Merging Queries: 00:17:00</p></div><div><div><p>•Pivoting &amp; Unpivoting: 00:06:00</p></div><div><div><p>•Appending Queries: 00:08:00</p></div><div><div><p>•Practice &amp; Solution: Population table: 00:15:00</p></div><div><div><p>•The Fact-Dimension-Model: 00:09:00</p></div><div><div><p>•Practice: Load the dimension table: 00:04:00</p></div><div><div><p>•Organizing our queries in groups: 00:03:00</p></div><div><div><p>•Entering data manually: 00:05:00</p></div><div><div><p>•Creating an index column: 00:03:00</p></div><div><div><p>•Workflow &amp; more transformations: 00:05:00</p></div><div><div><p>•Module summary: 00:05:00</p></div><div><div><p>•Exercise  1 - Instruction: 00:02:00</p></div><div><div><p>•Exercise  1 - Exercise Solution: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Advanced Editor - Best practices: 00:09:00</p></div><div><div><p>•Performance: References vs. Duplicating: 00:10:00</p></div><div><div><p>•Performance: Enable / Disable Load &amp; Report Refresh: 00:05:00</p></div><div><div><p>•Group by: 00:05:00</p></div><div><div><p>•Mathematical Operations: 00:05:00</p></div><div><div><p>•Run R Script: 00:15:00</p></div><div><div><p>•Using Parameters to dynamically transform data: 00:06:00</p></div><div><div><p>•M formula language: Basics: 00:07:00</p></div><div><div><p>•M formula language: Values, Lists &amp; Tables: 00:14:00</p></div><div><div><p>•M formula language: Functions: 00:13:00</p></div><div><div><p>•M formula language: More functions &amp; steps: 00:05:00</p></div><div><div><p>•Exercise 2 - Instructions: 00:01:00</p></div><div><div><p>•Exercise 2 - solution: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Understanding the relationship: 00:05:00</p></div><div><div><p>•Create &amp; edit relationships: 00:06:00</p></div><div><div><p>•One-to-many &amp; one-to-one relationship: 00:06:00</p></div><div><div><p>•Many-to-many (m:n) relationship: 00:08:00</p></div><div><div><p>•Cross filter direction: 00:06:00</p></div><div><div><p>•Activate &amp; deactivate relationships: 00:06:00</p></div><div><div><p>•Model summary: 00:03:00</p></div><div><div><p>•Exercise 3 Create Model: 00:02:00</p></div><div><div><p>•Exercise 3 Solution: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Our first visual: 00:08:00</p></div><div><div><p>•The format tab: 00:12:00</p></div><div><div><p>•Understanding tables: 00:10:00</p></div><div><div><p>•Conditional formatting: 00:09:00</p></div><div><div><p>•The Pie Chart: 00:06:00</p></div><div><div><p>•All about the filter visual: 00:13:00</p></div><div><div><p>•The filter pane for developers: 00:09:00</p></div><div><div><p>•Cross filtering &amp; edit interactions: 00:04:00</p></div><div><div><p>•Syncing slicers across pages: 00:07:00</p></div><div><div><p>•Creating drill downs: 00:08:00</p></div><div><div><p>•Creating drill throughs: 00:07:00</p></div><div><div><p>•The tree map visual: 00:07:00</p></div><div><div><p>•The decomposition tree: 00:05:00</p></div><div><div><p>•Understanding the matrix visual: 00:05:00</p></div><div><div><p>•Editing pages: 00:07:00</p></div><div><div><p>•Buttons &amp; Actions: 00:09:00</p></div><div><div><p>•Bookmarks to customize your report: 00:10:00</p></div><div><div><p>•Analytics and Forecasts with line charts: 00:10:00</p></div><div><div><p>•Working with custom visuals: 00:07:00</p></div><div><div><p>•Get data using R Script &amp; R Script visual: 00:08:00</p></div><div><div><p>•Asking questions - Q&amp;A visual: 00:04:00</p></div><div><div><p>•Wrap up - data visualization: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Python in Power BI - Plan of attack: 00:03:00</p></div><div><div><p>•Setting up Python for Power BI: 00:03:00</p></div><div><div><p>•Transforming data using Python: 00:11:00</p></div><div><div><p>•Creating visualizations using Python: 00:08:00</p></div><div><div><p>•Violin plots, pair plots &amp; ridge plots using Python: 00:15:00</p></div><div><div><p>•Machine learning (BayesTextAnalyzer) using Python: 00:00:00</p></div><div><div><p>•Performance &amp; Troubleshooting: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Show Empathy &amp; Identify the Requirement: 00:03:00</p></div><div><div><p>•Finding the Most Suitable KPI's: 00:02:00</p></div><div><div><p>•Choose an Effective Visualization: 00:04:00</p></div><div><div><p>•Make Use of Natural Reading Pattern: 00:03:00</p></div><div><div><p>•Tell a Story Using Visual Cues: 00:05:00</p></div><div><div><p>•Avoid Chaos &amp; Group Information: 00:02:00</p></div><div><div><p>•Warp Up - Storytelling with Data: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:03:00</p></div><div><div><p>•The project data: 00:04:00</p></div><div><div><p>•Measures vs. Calculated Columns: 00:15:00</p></div><div><div><p>•Automatically creating a date table in DAX: 00:08:00</p></div><div><div><p>•CALENDAR: 00:05:00</p></div><div><div><p>•Creating a complete date table with features: 00:04:00</p></div><div><div><p>•Creating key measure table: 00:03:00</p></div><div><div><p>•Aggregation functions: 00:06:00</p></div><div><div><p>•The different versions of COUNT: 00:14:00</p></div><div><div><p>•SUMX - Row based calculations: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•CALCULATE - The basics: 00:11:00</p></div><div><div><p>•Changing the context with FILTER: 00:07:00</p></div><div><div><p>•ALL: 00:08:00</p></div><div><div><p>•ALL SELECTED: 00:03:00</p></div><div><div><p>•ALL EXCEPT: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•How to go on now?: 00:03:00</p></div><div><div><p>•Power BI Pro vs Premium &amp; Signing up: 00:04:00</p></div><div><div><p>•Exploring the interface: 00:04:00</p></div><div><div><p>•Discovering your workspace: 00:03:00</p></div><div><div><p>•Connecting Power BI Desktop &amp; Cloud: 00:04:00</p></div><div><div><p>•Understanding datasets &amp; reports: 00:03:00</p></div><div><div><p>•Working on reports: 00:04:00</p></div><div><div><p>•Updating reports from Power BI Desktop: 00:04:00</p></div><div><div><p>•Creating and working with workspaces: 00:07:00</p></div><div><div><p>•Installing &amp; using a data gateway: 00:13:00</p></div><div><div><p>•Get Quick Insights: 00:03:00</p></div><div><div><p>•Creating dashboards: 00:04:00</p></div><div><div><p>•Sharing our results through Apps: 00:10:00</p></div><div><div><p>•Power BI Mobile App: 00:05:00</p></div><div><div><p>•Creating the layout for the Mobile App: 00:04:00</p></div><div><div><p>•Wrap up - Power BI Cloud: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:03:00</p></div><div><div><p>•Creating a Row-Level Security: 00:05:00</p></div><div><div><p>•Row-Level Security in the Cloud: 00:04:00</p></div><div><div><p>•Row-Level Security &amp; Data Model: 00:05:00</p></div><div><div><p>•Dynamic Row-Level Security: 00:07:00</p></div><div><div><p>•Dynamic Many-to-Many RLS: 00:04:00</p></div><div><div><p>•Hierarchical Row-Level Security: 00:13:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•JSON &amp; REST API: 00:10:00</p></div><div><div><p>•Setting up a local MySQL database: 00:14:00</p></div><div><div><p>•Connecting to a MySQL database in Power BI: 00:05:00</p></div><div><div><p>•Connecting to a SQL database (PostgreSQL): 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Congratulations &amp; next steps: 00:06:00</p></div><div><div><p>•The End: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - Data Visualization and Reporting with Power BI: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Data Visualization

Microsoft BI

Data Visualization and Reporting with Power BI

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>Complete Microsoft Power BI 2021</span></b> will deepen your understanding on this topic.</p><p><span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>Complete Microsoft Power BI 2021</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.<br /></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>Complete Microsoft Power BI 2021</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>Complete Microsoft Power BI 2021</span></b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p><span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>15 sections • 140 lectures • 14:25:00 total length</p></div><div><div><div><div><div><div><div><p>•Welcome!: 00:01:00</p></div><div><div><p>•What is Power BI?: 00:03:00</p></div><div><div><p>•Download &amp; Installing Power BI Desktop: 00:04:00</p></div><div><div><p>•Getting to know the interface: 00:03:00</p></div><div><div><p>•Mini Project: Transform Data: 00:07:00</p></div><div><div><p>•Mini Project: Visualize Data: 00:05:00</p></div><div><div><p>•Mini Project: Creating a Data Model: 00:07:00</p></div><div><div><p>•Course Outline: What will you learn in this course?: 00:05:00</p></div><div><div><p>•How to learn best with this course?: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Creating our initial project file: 00:04:00</p></div><div><div><p>•Working with the attached project files: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Exploring the Query Editor: 00:06:00</p></div><div><div><p>•Connecting to our data source: 00:07:00</p></div><div><div><p>•Editing rows: 00:08:00</p></div><div><div><p>•Changing data types: 00:08:00</p></div><div><div><p>•Replacing values: 00:03:00</p></div><div><div><p>•Close &amp; Apply: 00:03:00</p></div><div><div><p>•Connecting to a csv file: 00:03:00</p></div><div><div><p>•Connecting to a web page: 00:05:00</p></div><div><div><p>•Extracting characters: 00:06:00</p></div><div><div><p>•Splitting &amp; merging columns: 00:09:00</p></div><div><div><p>•Creating conditional columns: 00:06:00</p></div><div><div><p>•Creating columns from examples: 00:09:00</p></div><div><div><p>•Merging Queries: 00:17:00</p></div><div><div><p>•Pivoting &amp; Unpivoting: 00:06:00</p></div><div><div><p>•Appending Queries: 00:08:00</p></div><div><div><p>•Practice &amp; Solution: Population table: 00:15:00</p></div><div><div><p>•The Fact-Dimension-Model: 00:09:00</p></div><div><div><p>•Practice: Load the dimension table: 00:04:00</p></div><div><div><p>•Organizing our queries in groups: 00:03:00</p></div><div><div><p>•Entering data manually: 00:05:00</p></div><div><div><p>•Creating an index column: 00:03:00</p></div><div><div><p>•Workflow &amp; more transformations: 00:05:00</p></div><div><div><p>•Module summary: 00:05:00</p></div><div><div><p>•Exercise  1 - Instruction: 00:02:00</p></div><div><div><p>•Exercise  1 - Exercise Solution: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Advanced Editor - Best practices: 00:09:00</p></div><div><div><p>•Performance: References vs. Duplicating: 00:10:00</p></div><div><div><p>•Performance: Enable / Disable Load &amp; Report Refresh: 00:05:00</p></div><div><div><p>•Group by: 00:05:00</p></div><div><div><p>•Mathematical Operations: 00:05:00</p></div><div><div><p>•Run R Script: 00:15:00</p></div><div><div><p>•Using Parameters to dynamically transform data: 00:06:00</p></div><div><div><p>•M formula language: Basics: 00:07:00</p></div><div><div><p>•M formula language: Values, Lists &amp; Tables: 00:14:00</p></div><div><div><p>•M formula language: Functions: 00:13:00</p></div><div><div><p>•M formula language: More functions &amp; steps: 00:05:00</p></div><div><div><p>•Exercise 2 - Instructions: 00:01:00</p></div><div><div><p>•Exercise 2 - solution: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Understanding the relationship: 00:05:00</p></div><div><div><p>•Create &amp; edit relationships: 00:06:00</p></div><div><div><p>•One-to-many &amp; one-to-one relationship: 00:06:00</p></div><div><div><p>•Many-to-many (m:n) relationship: 00:08:00</p></div><div><div><p>•Cross filter direction: 00:06:00</p></div><div><div><p>•Activate &amp; deactivate relationships: 00:06:00</p></div><div><div><p>•Model summary: 00:03:00</p></div><div><div><p>•Exercise 3 Create Model: 00:02:00</p></div><div><div><p>•Exercise 3 Solution: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Our first visual: 00:08:00</p></div><div><div><p>•The format tab: 00:12:00</p></div><div><div><p>•Understanding tables: 00:10:00</p></div><div><div><p>•Conditional formatting: 00:09:00</p></div><div><div><p>•The Pie Chart: 00:06:00</p></div><div><div><p>•All about the filter visual: 00:13:00</p></div><div><div><p>•The filter pane for developers: 00:09:00</p></div><div><div><p>•Cross filtering &amp; edit interactions: 00:04:00</p></div><div><div><p>•Syncing slicers across pages: 00:07:00</p></div><div><div><p>•Creating drill downs: 00:08:00</p></div><div><div><p>•Creating drill throughs: 00:07:00</p></div><div><div><p>•The tree map visual: 00:07:00</p></div><div><div><p>•The decomposition tree: 00:05:00</p></div><div><div><p>•Understanding the matrix visual: 00:05:00</p></div><div><div><p>•Editing pages: 00:07:00</p></div><div><div><p>•Buttons &amp; Actions: 00:09:00</p></div><div><div><p>•Bookmarks to customize your report: 00:10:00</p></div><div><div><p>•Analytics and Forecasts with line charts: 00:10:00</p></div><div><div><p>•Working with custom visuals: 00:07:00</p></div><div><div><p>•Get data using R Script &amp; R Script visual: 00:08:00</p></div><div><div><p>•Asking questions - Q&amp;A visual: 00:04:00</p></div><div><div><p>•Wrap up - data visualization: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Python in Power BI - Plan of attack: 00:03:00</p></div><div><div><p>•Setting up Python for Power BI: 00:03:00</p></div><div><div><p>•Transforming data using Python: 00:11:00</p></div><div><div><p>•Creating visualizations using Python: 00:08:00</p></div><div><div><p>•Violin plots, pair plots &amp; ridge plots using Python: 00:15:00</p></div><div><div><p>•Machine learning (BayesTextAnalyzer) using Python: 00:00:00</p></div><div><div><p>•Performance &amp; Troubleshooting: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Show Empathy &amp; Identify the Requirement: 00:03:00</p></div><div><div><p>•Finding the Most Suitable KPI's: 00:02:00</p></div><div><div><p>•Choose an Effective Visualization: 00:04:00</p></div><div><div><p>•Make Use of Natural Reading Pattern: 00:03:00</p></div><div><div><p>•Tell a Story Using Visual Cues: 00:05:00</p></div><div><div><p>•Avoid Chaos &amp; Group Information: 00:02:00</p></div><div><div><p>•Warp Up - Storytelling with Data: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:03:00</p></div><div><div><p>•The project data: 00:04:00</p></div><div><div><p>•Measures vs. Calculated Columns: 00:15:00</p></div><div><div><p>•Automatically creating a date table in DAX: 00:08:00</p></div><div><div><p>•CALENDAR: 00:05:00</p></div><div><div><p>•Creating a complete date table with features: 00:04:00</p></div><div><div><p>•Creating key measure table: 00:03:00</p></div><div><div><p>•Aggregation functions: 00:06:00</p></div><div><div><p>•The different versions of COUNT: 00:14:00</p></div><div><div><p>•SUMX - Row based calculations: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•CALCULATE - The basics: 00:11:00</p></div><div><div><p>•Changing the context with FILTER: 00:07:00</p></div><div><div><p>•ALL: 00:08:00</p></div><div><div><p>•ALL SELECTED: 00:03:00</p></div><div><div><p>•ALL EXCEPT: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•How to go on now?: 00:03:00</p></div><div><div><p>•Power BI Pro vs Premium &amp; Signing up: 00:04:00</p></div><div><div><p>•Exploring the interface: 00:04:00</p></div><div><div><p>•Discovering your workspace: 00:03:00</p></div><div><div><p>•Connecting Power BI Desktop &amp; Cloud: 00:04:00</p></div><div><div><p>•Understanding datasets &amp; reports: 00:03:00</p></div><div><div><p>•Working on reports: 00:04:00</p></div><div><div><p>•Updating reports from Power BI Desktop: 00:04:00</p></div><div><div><p>•Creating and working with workspaces: 00:07:00</p></div><div><div><p>•Installing &amp; using a data gateway: 00:13:00</p></div><div><div><p>•Get Quick Insights: 00:03:00</p></div><div><div><p>•Creating dashboards: 00:04:00</p></div><div><div><p>•Sharing our results through Apps: 00:10:00</p></div><div><div><p>•Power BI Mobile App: 00:05:00</p></div><div><div><p>•Creating the layout for the Mobile App: 00:04:00</p></div><div><div><p>•Wrap up - Power BI Cloud: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:03:00</p></div><div><div><p>•Creating a Row-Level Security: 00:05:00</p></div><div><div><p>•Row-Level Security in the Cloud: 00:04:00</p></div><div><div><p>•Row-Level Security &amp; Data Model: 00:05:00</p></div><div><div><p>•Dynamic Row-Level Security: 00:07:00</p></div><div><div><p>•Dynamic Many-to-Many RLS: 00:04:00</p></div><div><div><p>•Hierarchical Row-Level Security: 00:13:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•JSON &amp; REST API: 00:10:00</p></div><div><div><p>•Setting up a local MySQL database: 00:14:00</p></div><div><div><p>•Connecting to a MySQL database in Power BI: 00:05:00</p></div><div><div><p>•Connecting to a SQL database (PostgreSQL): 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Congratulations &amp; next steps: 00:06:00</p></div><div><div><p>•The End: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - Complete Microsoft Power BI 2021: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Microsoft Power Apps

Microsoft Power Platform

Complete Microsoft Power BI 2021

<p><strong>***Want to Unlock the Secrets of Data? Become a Database Mastermind!***</strong></p><p>The world runs on data, and <strong>Database Administrators</strong> (DBAs) are the heroes behind the scenes ensuring its smooth operation. Database administrators in the UK are in high demand, with an average<strong> salary of £41,501</strong> per year. The job market is expected to grow by 9% in the next few years, so now is a great time to start a career as a database administrator. As a database administrator, you will be responsible for the design, implementation, and maintenance of databases. You will also be responsible for ensuring the security and integrity of the data. If you are interested in a challenging and rewarding career in technology, then database administration is a great option for you.</p><p>Our Database Administrator course starts with the basics of Database Administrator and gradually progresses towards advanced topics. Therefore, each lesson of this Database Administrator course is intuitive and easy to understand.</p><strong>Learning Outcomes</strong><p>By the end of this Database Administrator course, you'll be able to:</p><ul><li>Install and configure MySQL Server and MySQL Workbench.</li><li>Create, manage, and manipulate databases and tables using SQL.</li><li>Insert, update, and delete data efficiently.</li><li>Design and implement database relationships to ensure data integrity.</li><li>Utilize aggregate functions to summarize and analyze data.</li><li>Reverse engineer existing databases and forward engineer data models.</li></ul><p><strong>Why would you choose the Database Administrator course from Compliance Central:</strong></p><ul><li>Lifetime access to Database Administrator course materials</li><li>Full tutor support is available from Monday to Friday with the Database Administrator course</li><li>Learn Database Administrator skills at your own pace from the comfort of your home</li><li>Gain a complete understanding of Database Administrator course</li><li>Accessible, informative Database Administrator learning modules designed by experts</li><li>Get 24/7 help or advice from our email and live chat teams with the Database Administrator</li><li>Study Database Administrator in your own time through your computer, tablet or mobile device</li><li>A 100% learning satisfaction guarantee with your Database Administrator Course</li></ul><p><strong> Database Administrator </strong></p><p><strong>Curriculum Breakdown of the Database Administrator Course</strong></p><p><strong>Unit 01: Introduction</strong><br />Gain foundational knowledge of MySQL Server and databases, including installation and initial setup.</p><ul><li><strong>Module 01</strong>: Introduction to MySQL Server and Databases</li><li><strong>Module 02</strong>: Download and Install MySQL Server and MySQL Workbench</li></ul><p><strong>Unit 02: Manipulating Tables and Data - CRUD Operations</strong><br />Learn to manage databases through creating, reading, updating, and deleting (CRUD) data in SQL and MySQL Workbench.</p><ul><li><strong>Module 01</strong>: Connect and Create a Database</li><li><strong>Module 02</strong>: Drop or Remove Database</li><li><strong>Module 03</strong>: Create an SQL Database Table</li><li><strong>Module 04</strong>: Insert Data into the Table with SQL Script</li><li><strong>Module 05</strong>: Insert Data into the Table with Workbench</li><li><strong>Module 06</strong>: Select Data from the Table with SQL Script</li><li><strong>Module 07</strong>: Select Data with Filters</li><li><strong>Module 08</strong>: Update Data in the Table</li><li><strong>Module 09</strong>: Delete Data from the Table</li><li><strong>Module 10</strong>: Reverse Engineer Database into Model</li><li><strong>Module 11</strong>: Forward Engineer Data Model into Database</li></ul><p><strong>Unit 03: Relationships and Foreign Keys</strong><br />Understand and implement relationships, foreign keys, and normalization in databases, enhancing data integrity and querying capabilities.ys</p><ul><li><strong>Module 01</strong>: What are Relationships, Foreign Keys and Normalization?</li><li><strong>Module 02</strong>: Create Relationships with Data Modeling</li><li><strong>Module 03</strong>: Create Relationships with Workbench Table Design Tool</li><li><strong>Module 04</strong>: Insert Records in Related Tables</li><li><strong>Module 05</strong>: Run Queries on Related Tables (Inner Joins)</li><li><strong>Module 06</strong>: Left, Right and Cross-Joins</li></ul><p><strong>Unit 04: Aggregate Functions</strong><br />Explore aggregate functions to perform calculations on data sets, including grouping, averaging, counting, and summing data.</p><ul><li><strong>Module 01</strong>: Grouping Data using SQL GROUP BY Clause</li><li><strong>Module 02</strong>: SQL AVG Aggregate Function</li><li><strong>Module 03</strong>: SQL COUNT Aggregate Function</li><li><strong>Module 04</strong>: SQL MIN &amp; MAX Aggregate Functions</li><li><strong>Module 05</strong>: SQL SUM Aggregate Function</li><li><strong>Module 06</strong>: Splitting Groups using HAVING Clause</li></ul><h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p>This Database Administrator course is ideal for:</p><ul><li>Individuals with an interest in data management and database systems.</li><li>IT professionals seeking to expand their skillset and transition into a Database Administrator role.</li><li>Business analysts who want to gain a deeper understanding of data structures and manipulation techniques.</li><li>Anyone passionate about building and maintaining robust and efficient databases.</li><li>Those looking to enhance their career prospects in the ever-growing field of data.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>To enrol in this Database Administrator course, all you need is a basic understanding of the English Language and an internet connection.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>A successful career as a Database Administrator can open doors to exciting opportunities. Here are some potential career paths to consider:</p><ul><li>Database Administrator</li><li>Database Analyst</li><li>Database Architect</li><li>Data Warehouse Specialist</li><li>Business Intelligence Analyst</li><li>Data Scientist (with further specialization)</li><li>Database Security Specialist</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD Accredited PDF Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p><strong>CPD Accredited PDF Certificate</strong></p></div>
        <h4>CPD Accredited Hard Copy Certificate</h4>
        <p>
            Hard copy certificate -
            £10.79
        </p>
            <div><p><strong>CPD Accredited Hard Copy Certificate</strong></p><p><strong>Delivery Charge:</strong></p><ul><li>Inside the UK: Free</li><li>Outside of the UK: £9.99 each</li></ul></div>

                        </div>

Compliance Central

Database Administrator

<p>The PHP Webforms for Everyone is all you need to advance your career in the relevant fields.</p><p>Enrol now to discover everything you need to know about the PHP Webforms for Everyone and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><p><strong><strong>Getting Started</strong></strong></p><ul><li>Introduction</li><li>Course Curriculum</li><li>How to Get Pre-Requisites</li><li>Getting Started on Windows, Linux or Mac</li><li>How to ask a Great Questions</li><li>FAQ's</li></ul><p><strong><strong>Setting up Local Development Environment</strong></strong></p><ul><li>What is PHP</li><li>Installing XAMPP for PHP, MySQL and Apache</li><li>Choosing Code Editor</li><li>Installing Code Editor (Sublime Text)</li><li>Installing Code Editor (Visual Studio Code)</li><li>Creating PHP Project on XAMPP</li><li>Hello World Program</li><li>Summary</li></ul><p><strong><strong>PHP Fundamentals</strong></strong></p><ul><li>Section Introduction</li><li>Variables</li><li>Echo and Print</li><li>Data Types</li><li>Numbers</li><li>Boolean</li><li>Arrays</li><li>Multi-Dimensional Array</li><li>Sorting Arrays</li><li>Constants</li><li>Comments</li><li>Summary</li></ul><p><strong><strong>PHP Strings</strong></strong></p><ul><li>Section Introduction</li><li>Strings</li><li>String Formatting</li><li>String Methods</li><li>Coding Exercise</li><li>Solution for Coding Exercise</li><li>Summary</li></ul><p><strong><strong>PHP Operators</strong></strong></p><ul><li>Section Introduction</li><li>Arithmetic operators</li><li>Assignment operators</li><li>Comparison operators</li><li>Increment - decrement operators</li><li>Logical operators</li><li>Ternary operator</li><li>Summary</li></ul><p><strong><strong>PHP Conditional Statements</strong></strong></p><ul><li>Section Introduction</li><li>If statement</li><li>If-else statement</li><li>If-else if-else statement</li><li>Switch-case statement</li><li>Summary</li></ul><p><strong><strong>PHP Control Flow Statements</strong></strong></p><ul><li>Section Introduction</li><li>Flow Chart</li><li>While loop</li><li>Do-while loop</li><li>For loop</li><li>Foreach loop</li><li>Break</li><li>Continue</li><li>Coding Exercise</li><li>Solution for Coding Exercise</li><li>Summary</li></ul><p><strong><strong>PHP Functions</strong></strong></p><ul><li>Section Introduction</li><li>Creating a Function</li><li>Function with Arguments</li><li>Default Argument</li><li>Function return values</li><li>Call-by-value</li><li>Call-by-reference</li><li>Summary</li></ul><p><strong><strong>PHP Superglobals</strong></strong></p><ul><li>Section Introduction</li><li>$_SERVER</li><li>$_REQUEST</li><li>$_POST Method</li><li>$_GET Method</li><li>Summary</li></ul><p><strong><strong>PHP Advanced</strong></strong></p><ul><li>Section Introduction</li><li>Form Handling</li><li>Date and Time</li><li>Include</li><li>Require</li><li>Cookies</li><li>Sessions</li><li>File Reading</li><li>File Writing</li><li>File Upload</li><li>Summary</li></ul><p><strong><strong>PHP OOPs - [Object Oriented Programming]</strong></strong></p><ul><li>Section Introduction</li><li>What is OOP</li><li>Class and Objects</li><li>Constructor</li><li>Destructor</li><li>Access Modifiers</li><li>Inheritance</li><li>Method overriding</li><li>Abstract Class</li><li>Interface</li><li>Summary</li></ul><p><strong><strong>PHP - MySQL Database(CRUD)</strong></strong></p><ul><li>Section Introduction</li><li>MySQL Basic PhpMyAdmin</li><li>Creating Database and Table</li><li>Database Connection</li><li>PHP Form Create records</li><li>PHP Form Reading records</li><li>PHP Form Update Data</li><li>PHP Form Delete records</li><li>Summary</li></ul><p><strong><strong>PHP Real-World App Forms</strong></strong></p><ul><li>Section Introduction</li><li>Registration Form</li><li>MD5 Algorithm for Encrypting</li><li>Sha Algorithm</li><li>Login Form</li><li>Dashboard</li><li>Summary</li></ul><p><strong><strong>PHP Client-side Validations</strong></strong></p><ul><li>Section Introduction</li><li>On Submit Validation</li><li>Input Numeric Validation</li><li>Login Form Validation</li><li>Password Strength Check Validation</li><li>Summary</li></ul><p><strong><strong>PHP Server-Side Validations</strong></strong></p><ul><li>Section Introduction</li><li>Form Server-side all Data Validation</li><li>Form Server-side Validation</li><li>Summary</li></ul><p><strong><strong>PHP Error Handling</strong></strong></p><ul><li>Try-throw-catch</li><li>Try-throw-catch-finally</li></ul><p><strong>Course Assessment </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 will be 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 order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Exam &amp; Retakes:</strong><br />It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.</p><p><strong>Certification</strong><br />Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This PHP Webforms for Everyone course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This PHP Webforms for Everyone course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon successful completion of the PHP Webforms for Everyone Course, learners will be equipped with many indispensable skills and have the opportunity to grab.</p>
                        </div>

PHP Webforms for Everyone Course

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on <b>Learn Linux in 5 Days</b> will deepen your understanding on this topic.</span></p><p><span>After successful completion of this course you can acquire the required skills in this sector. This <b>Learn Linux in 5 Days</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span>So enrol in this course today to fast track your career ladder.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this <b>Learn Linux in 5 Days</b>. It is available to all students, of all academic backgrounds.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our <b>Learn Linux in 5 Days</b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</span></p><p><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</span></p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>10 sections • 45 lectures • 05:58:00 total length</p></div><div><div><div><div><div><div><div><p>•Course Overview: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Background and Introduction: 00:07:00</p></div><div><div><p>•Linux Distributions: 00:05:00</p></div><div><div><p>•Installing VirtualBox on Windows: 00:03:00</p></div><div><div><p>•Installing VirtualBox on Mac: 00:03:00</p></div><div><div><p>•Installing Linux Using an Image for VirtualBox: 00:05:00</p></div><div><div><p>•VirtualBox Troubleshooting Tips: 00:02:00</p></div><div><div><p>•When to Install Linux from Scratch: 00:15:00</p></div><div><div><p>•Installing CentOS from Scratch / CentOS Manual Installation Process: 00:23:00</p></div><div><div><p>•Getting Connected: 00:11:00</p></div><div><div><p>•Connect Directly: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•The Linux Directory Structure: 00:10:00</p></div><div><div><p>•The Shell: 00:08:00</p></div><div><div><p>•Basic Linux Commands: 00:05:00</p></div><div><div><p>•Teach Yourself to Fish: 00:06:00</p></div><div><div><p>•Working with Directories: 00:09:00</p></div><div><div><p>•Listing Files and Understanding LS Output: 00:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•File and Directory Permissions Explained - Part One: 00:11:00</p></div><div><div><p>•File and Directory Permissions Explained - Part Two: 00:09:00</p></div><div><div><p>•View Files and the Nano Editor: 00:05:00</p></div><div><div><p>•Editing Files in Vi: 00:10:00</p></div><div><div><p>•Editing Files with Emacs: 00:06:00</p></div><div><div><p>•Finding Files and Directories: 00:07:00</p></div><div><div><p>•Graphical Editors: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Deleting, Copying, Moving, and Renaming Files: 00:11:00</p></div><div><div><p>•Wildcards - Part One: 00:05:00</p></div><div><div><p>•Wildcards - Part Two: 00:07:00</p></div><div><div><p>•Input, Output, and Redirection: 00:08:00</p></div><div><div><p>•Comparing Files: 00:04:00</p></div><div><div><p>•Searching in Files and Using Pipes: 00:10:00</p></div><div><div><p>•Transferring and Copying Files over the Network: 00:07:00</p></div><div><div><p>•Customizing the Shell Prompt: 00:05:00</p></div><div><div><p>•Shell Aliases: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Environment Variables: 00:08:00</p></div><div><div><p>•Processes and Job Control: 00:12:00</p></div><div><div><p>•Scheduling Repeated Jobs with Cron: 00:06:00</p></div><div><div><p>•Switching Users and Running Commands as Others: 00:08:00</p></div><div><div><p>•Shell History and Tab Completion: 00:13:00</p></div><div><div><p>•Installing Software on RPM Based Linux Distros: RedHat, CentOS, AlmaLinux, Rocky: 00:21:00</p></div><div><div><p>•Installing Software on Debian Based Linux Distros: Debian, Ubuntu, Kali Linux: 00:12:00</p></div><div><div><p>•Conclusion - Congratulations and Thank You!: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Connecting to a Linux Virtual Machine over the Network: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Bonus - Installing NGINX, MySQL, PHP, and WordPress on Ubuntu: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Learn Linux in 5 Days: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Linux Command Line

Linux Administration

LPIC-1:Linux Administrator

Learn Linux in 5 Days

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

Django Rest Framework Level 4

By Apex Learning

SQL Programming Complete Bundle

By Apex Learning

SQL NoSQL Big Data and Hadoop

By Apex Learning

Web Development Complete Course

By John Academy

Web Applications for Specialisation on Development Course

By One Education

Data Visualization and Reporting with Power BI

By Apex Learning

Complete Microsoft Power BI 2021

By Apex Learning

Database Administrator

By Compliance Central

PHP Webforms for Everyone Course

By One Education

Learn Linux in 5 Days

By Apex Learning

Search By Location