The Teachers Training

Discrete Math

Maths Teacher

Initial Teacher

Trainers Course

Teaching Online

Teaching & Training

Discrete Maths Teaching

General Admission

NextGen Learning

Learn MySQL from Scratch for Data Science and Analytics Course

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators.</p>Overview<p>Working in a hands on learning environment led by our expert practitioner, attendees will explore:<br />Basic RDBMS Principles<br />The SQL Language and Tools<br />Using SQL Developer<br />SQL Query Basics<br />WHERE and ORDER BY<br />Functions<br />ANSI 92 Joins<br />ANSI 99 Joins<br />Subqueries<br />Regular Expressions<br />Analytics</p><p>A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered.</p></div><div id="course-pills-2"><h4>Basic RDBMS Principles</h4><ul><li>Relational design principles</li><li>Accessing data through a structured query language</li><li>Entity relationship diagrams</li><li>Data Domains</li><li>Null values</li><li>Indexes</li><li>Views</li><li>Denormalization</li><li>Data Model Review</li></ul><h4>The SQL Language and Tools</h4><ul><li>Using SQL*Plus</li><li>Why Use SQL*Plus When</li><li>Other Tools Are Available?</li><li>Starting SQL*Plus</li><li>EZConnect</li><li>SQL Commands</li><li>PL/SQL Commands</li><li>SQL*Plus Commands</li><li>The COLUMN Command</li><li>The HEADING Clause</li><li>The FORMAT Clause</li><li>The NOPRINT Clause</li><li>The NULL Clause</li><li>The CLEAR Clause</li><li>Predefined define variables</li><li>LOGIN.SQL</li><li>Command history</li><li>Copy and paste in SQL*Plus</li><li>Entering SQL commands</li><li>Entering PL/SQL commands</li><li>Entering SQL*Plus commands</li><li>Default output from SQL*Plus</li><li>Entering Queries</li><li>What about PL/SQL?</li></ul><h4>Using SQL Developer</h4><ul><li>Choosing a SQL Developer version</li><li>Configuring connections</li><li>Creating A Basic Connection</li><li>Creating A TNS Connection</li><li>Connecting</li><li>Configuring preferences</li><li>Using SQL Developer</li><li>The Columns Tab</li><li>The Data Tab</li><li>The Constraints Tab</li><li>The Grants Tab</li><li>The Statistics Tab</li><li>Other Tabs</li><li>Queries In SQL Developer</li><li>Query Builder</li><li>Accessing Objects Owned By Other Users</li><li>The Actions Pulldown Menu</li><li>Differences between SQL Developer and SQL*Plus</li><li>Reporting Commands Missing In SQL Developer</li><li>General Commands Missing In SQL Developer</li><li>Data Dictionary report</li><li>User Defined reports</li><li>Using scripts in SQL Developer</li></ul><h4>WHERE and ORDER BY</h4><ul><li>WHERE clause basics</li><li>Comparison operators</li><li>Literals and Constants in SQL</li><li>Simple pattern matching</li><li>Logical operations</li><li>The DUAL table</li><li>Arithmetic operations</li><li>Expressions in SQL</li><li>Character operators</li><li>Pseudo columns</li><li>Order by clause basics</li><li>Ordering Nulls</li><li>Accent and case sensitive sorts</li><li>Sampling data</li><li>WHERE and ORDER BY in SQL Developer</li><li>All, Any, Some</li></ul><h4>Functions</h4><ul><li>The basics of Oracle functions</li><li>Number functions</li><li>Character functions</li><li>Date functions</li><li>Conversion functions</li><li>Other functions</li><li>Large object functions</li><li>Error functions</li><li>The RR format mode;</li><li>Leveraging your knowledge</li></ul><h4>ANSI 92 JOINS</h4><ul><li>Basics of ANSI 92 Joins</li><li>Using Query Builder with multiple tables</li><li>Table Aliases</li><li>Outer joins</li><li>Outer Joins In Query Builder</li><li>Set operators</li><li>Self-referential joins</li><li>Non-Equijoins</li></ul><h4>ANSI 99 Joins</h4><ul><li>Changes with ANSI99</li><li>CROSS Join</li><li>NATURAL Join</li><li>JOIN USING</li><li>JOIN ON</li><li>LEFT / RIGHT OUTER JOIN</li><li>FULL OUTER JOIN</li></ul><h4>Subqueries</h4><ul><li>Why use subqueries?</li><li>WHERE clause subqueries</li><li>FROM clause subqueries</li><li>HAVING clause subqueries</li><li>CORRELATED subqueries</li><li>SCALAR subqueries</li><li>DML and subqueries</li><li>EXISTS subqueries</li><li>Hierarchical queries</li><li>TOP N AND BOTTOM N queries</li><li>Creating subqueries using Query Builder</li></ul><h4>Regular Expressions</h4><ul><li>Available Regular Expressions</li><li>Regular Expression Operators</li><li>Character Classes</li><li>Pattern matching options</li><li>REGEX_LIKE</li><li>REGEXP_SUBSTR</li><li>REGEXP_INSTR</li><li>REGEXP_REPLACE</li><li>REGEXP_COUNT</li></ul><h4>Analytics</h4><ul><li>The WITH clause<br />Reporting aggregate functions<br />Analytical functions<br />User-Defined bucket histograms<br />The MODEL clause<br />PIVOT and UNPIVOT<br />Temporal validity</li></ul><h4>More Analytics</h4><ul><li>RANKING functions</li><li>RANK</li><li>DENSE_RANK</li><li>CUME_DIST</li><li>PERCENT_RANK</li><li>ROW_NUMBER</li><li>Windowing aggregate functions</li><li>RATIO_TO_REPORT</li><li>LAG / LEAD</li><li>Linear Regression functions</li><li>Inverse Percentile functions</li><li>Hypothetical ranking functions</li><li>Pattern Matching</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Introduction to SQL Programming Basics (TTSQL002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Introduction to SQL Programming Basics (TTSQL002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Oracle SQL

Microsoft SQL

Database Programming

Oracle 1Z0-819

Oracle Database

Introduction to SQL Programming Basics (TTSQL002)

An Introduction to Discrete Maths Course

Harpenden

<p>The aim of this programme is to help attendees create better quality technical documents in an organised and efficient manner. It will give those new to the topic an appreciation of how to approach the task professionally whilst those with more experience will be able to refresh and refine their skills.</p><p>The programme comprises three complementary one-day modules:</p><p>The programme presents a structured methodology for creating technical documents and provides a range of practical techniques that help delegates put principles into practice. Although not essential, it is strongly advised that delegates for modules 2 and 3 have already attended module 1, or another equivalent course.</p><p>Note: the content of each module as shown here is purely indicative and can be adapted to suit your particular requirements.</p>This course will:<ul><li>Explain the qualities and benefits of well written technical documents</li><li>Present a structured approach for producing technical documents</li><li>Review the essential skills of effective technical writing</li><li>Demonstrate practical methods to help create better documents</li><li>Provide tools and techniques for specification and report writing</li><li>Review how technical documents should be issued and controlled</li></ul><section>
                    					<p><em>Note: the content of each module as shown here is purely indicative and can be adapted to suit your particular requirements.</em></p>			  Module 1: Essential skills for technical writers <h3>1 Introduction to the programme</h3><ul><li>Aims and objectives of the module</li><li>Introductions and interests of participants</li></ul> <h3>2 Creating effective technical documents</h3><ul><li>What is technical writing? how does it differ from other writing?</li><li>Key qualities of an effective technical document</li><li>Communication essentials and the challenges faced by technical writers</li><li>The lessons of experience: how the best writers write</li><li>The five key steps : prepare - organise - write - edit - release <em>(POWER)</em></li></ul> <h3>3 Preparing to write</h3><ul><li>Defining the document aims and objectives; choosing the title</li><li>Understanding technical readers and their needs</li><li>Getting organised; planning and managing the process</li><li>Integrating technical and commercial elements</li><li>The role of intellectual property rights (IPR), eg, copyright</li></ul> <h3>4 Organising the content</h3><ul><li>The vital role of structure in technical documents</li><li>Deciding what to include and how to organise the information</li><li>Categorising information: introductory, key and supporting</li><li>Tools and techniques for scoping and structuring the document</li><li>Creating and using document templates - pro's and con's</li></ul> <h3>5 Writing the document</h3><ul><li>Avoiding 'blinding them with science': the qualities of clear writing</li><li>Problem words and words that confuse; building and using a glossary</li><li>Using sentence structure and punctuation to best effect</li><li>Understanding the impact of style, format and appearance</li><li>Avoiding common causes of ambiguity; being concise and ensuring clarity</li><li>Using diagrams and other graphics; avoiding potential pitfalls</li></ul> <h3>6 Editing and releasing the document</h3><ul><li>Why editing is difficult; developing a personal editing strategy</li><li>Some useful editing tools and techniques</li><li>Key requirements for document issue and control</li></ul> Module 2: Creating better specifications <h3>1 Introduction</h3><ul><li>Aims and objectives of the day</li><li>Introductions and interests of participants</li><li>The 'POWER' writing process for specifications</li></ul> <h3>2 Creating better specifications</h3><ul><li>The role and characteristics of an effective specification</li><li>Specifications and contracts; the legal role of specifications</li><li>Deciding how to specify; understanding functional and design requirements</li><li>Developing the specification design; applying the principles of BS 7373</li><li>Getting organised: the key stages in compiling an effective specification</li></ul> <h3>3 Preparing to write a specification</h3><ul><li>Defining the scope of the specification; deciding what to include and what not</li><li>Scoping techniques: scope maps, check lists, structured brainstorming</li><li>The why/what/how pyramid; establishing and understanding requirements</li><li>Clarifying priorities; separating needs and desires: the MoSCoW method</li><li>Useful quantitative techniques: cost benefit analysis, QFD, Pareto analysis</li><li>Dealing with requirements that are difficult to quantify</li></ul> <h3>4 Organising the content</h3><ul><li>The role of structure in specifications</li><li>Typical contents and layout for a specification</li><li>What goes where: introductory, key and supporting sections</li><li>Creating and using model forms: the sections and sub sections</li><li>Detailed contents of each sub-section</li><li><em>Exercise: applying the tools and techniques</em></li></ul> <h3>5 Writing the specification</h3><ul><li>Identifying and understanding the specification reader</li><li>Key words: will, shall, must; building and using a glossary</li><li>Writing performance targets that are clear and unambiguous</li><li>Choosing and using graphics</li><li>Exercise: writing a specification</li></ul> <h3>6 Editing and releasing the document</h3><ul><li>Key editing issues for specifications</li><li>Issue and control of specifications</li></ul> Module 3: Writing better reports <h3>1 Introduction</h3><ul><li>Aims and objectives of the day</li><li>Introductions and interests of participants</li><li>The 'POWER' technical writing process for technical reports</li></ul> <h3>2 Creating better reports</h3><ul><li>What is a technical report? types and formats of report</li><li>The role and characteristics of an effective technical report</li><li>Understanding technical report readers and their needs</li><li>The commercial role and impact of technical reports</li><li>Getting organised: the key stages in compiling a technical report</li></ul> <h3>3 Preparing to write reports</h3><ul><li>Agreeing the terms of reference; defining aims and objectives</li><li>Being clear about constraints; defining what is not to be included</li><li>Legal aspects and intellectual property rights (IPR) for reports</li><li>Preparing the ground; gathering information and reference documents</li><li>Keeping track of information: note making, cataloguing and cross referencing</li><li>Tools and techniques for developing a valid and convincing argument</li></ul> <h3>4 Organising the content</h3><ul><li>The role of structure reviewed; some typical report structures</li><li>Who needs what: identifying the varied needs of the readership</li><li>What goes where: introductory, key and supporting sections</li><li>Creating and using model forms: the sections and sub sections</li><li>Detailed contents of each sub-section</li><li>Exercise: applying the tools and techniques</li></ul> <h3>5 Writing the report</h3><ul><li>Planning the storyline: the report as a journey in understanding</li><li>Recognising assumptions about the reader; what they do and don't know</li><li>Converting complex concepts into understandable statements</li><li>Presenting technical data and its analysis; the role of graphics</li><li>Presenting the case simply whilst maintaining technical integrity</li><li><em>Exercise: writing a technical report</em></li></ul> <h3>6 Editing and releasing the report</h3><ul><li>Key editing issues for technical reports</li><li>Issue and control of technical reports</li></ul> 


                </section>

The In House Training Company

Technical Writing

Content Writing

Professional Skills Course (PSC)

Writing Skills

Book Writing

Business Writing

Effective technical writing (In-House)

<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<p><span>Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making.</span></p><p><b id="docs-internal-guid-6a582f22-7fff-d807-19e0-b5dad8f04cd9"><br /></b></p><p><span>Learning Outcomes:</span></p><ul><li><p><span>Establish a strong foundation in SQL and MySQL.</span></p></li><li><p><span>Set up and configure SQL Server for efficient data handling.</span></p></li><li><p><span>Master SQL's Data Manipulation, Definition, and Control Language.</span></p></li><li><p><span>Create and optimize SQL queries for data analysis.</span></p></li><li><p><span>Perform advanced data analytics using SQL.</span></p></li><li><p><span>Understand the power of GROUP BY and JOIN statements.</span></p></li><li><p><span>Implement data constraints and views for data integrity and security.</span></p></li><li><p><span>Develop proficiency in stored procedures, data import/export, and database backup/restore.</span></p></li></ul><p><b><br /></b></p><p><span>Why buy this Learn MySQL from Scratch for Data Science and Analytics?</span><span> </span></p><ul><li><p><span>Unlimited access to the course for forever</span></p></li><li><p><span>Digital Certificate, Transcript, student ID all included in the price</span></p></li><li><p><span>Absolutely no hidden fees</span></p></li><li><p><span>Directly receive CPD accredited qualifications after course completion</span></p></li><li><p><span>Receive one to one assistance on every weekday from professionals</span></p></li><li><p><span>Immediately receive the PDF certificate after passing</span></p></li><li><p><span>Receive the original copies of your certificate and transcript on the next working day</span></p></li><li><p><span>Easily learn the skills and knowledge from the comfort of your home</span></p></li></ul><p><b><br /></b></p><p><span>Certification</span></p><p><span>After studying the course materials of the </span><span>Learn MySQL from Scratch for Data Science and Analytics</span><span> you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.</span></p><p><b><br /></b></p><p><span>Who is this course for?</span></p><p><span>This </span><span>Learn MySQL from Scratch for Data Science and Analytics</span><span> course is ideal for</span></p><ul><li><p><span>Aspiring Data Scientists and Analysts.</span></p></li><li><p><span>Database Administrators and Developers.</span></p></li><li><p><span>Students and professionals seeking to enter the field of Data Science.</span></p></li><li><p><span>Anyone looking to enhance their SQL and MySQL skills for data-related roles.</span></p></li></ul><p><b><br /></b></p><p><span>Prerequisites</span></p><p><span>This </span><span>Learn MySQL from Scratch for Data Science and Analytics</span><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p><p><b><br /></b></p><p><span>Career path</span></p><p></p><ul><li><p><span>Data Analyst: £25,000 - £50,000 per year.</span></p></li><li><p><span>Database Administrator: £30,000 - £60,000 per year.</span></p></li><li><p><span>SQL Developer: £30,000 - £60,000 per year.</span></p></li><li><p><span>Data Scientist: £40,000 - £80,000 per year.</span></p></li><li><p><span>Business Intelligence Analyst: £35,000 - £65,000 per year.</span></p></li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Learn MySQL from Scratch for Data Science and Analytics</td>
				</tr>
								<tr>
					<td colspan="4">Section 01: Getting Started</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to get course requirements</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Getting started on Windows, Linux or Mac</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to ask great questions</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>FAQ's</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is Source Code?</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 02: SQL Server setting up</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MySQL Server Installation</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Connect MySQL Server Instance</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MySQL Workbench overview</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download and Restore Sample Database</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 03: SQL Database basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of Databases</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Database</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Data Types</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Column Data Types on Workbench</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Table</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of Primary and Foreign Key</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Primary Key</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Foreign Key</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Temporary tables</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>EER - Enhanced Entity Relationship Diagrams</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 04: SQL DML (Data Manipulation Language)</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert statement</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Update statement</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Delete statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 05: SQL DDL (Data Definition Language)</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>CREATE table statement</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DROP statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>ALTER statement</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>TRUNCATE statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>COMMENT in query</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>RENAME table</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 06: SQL DCL (Data Control Language)</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Database user</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>GRANT permissions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>REVOKE permissions</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 07: SQL Statement Basic</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Statement basic</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT Statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT DISTINCT</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT with column headings</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Column AS statement</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DASHBOARD Analytics</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 08: Filtering Data rows</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT WHERE Clause - theory</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT WHERE Clause - practical</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 09: Aggregate functions for Data Analysis</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sum()</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Min()-Max()</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 10: SQL Data Analyticstatements</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order By statement</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT TOP 3 records</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>BETWEEN command</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>IN operator</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Search Data usingLIKE cards</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 11: SQL Group by statement</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Group by - theory</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Analytics with Group By</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>HAVING statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 12: JOINS</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of Joins</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What are Joins</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inner join</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Left outer join</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Right outer join</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Union</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>CERTESIAN Product or Cross Join</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Query Exercise</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Solution for Query Exercise</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 13: SQL Constraints</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Check constraint</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NOT NULL constraint</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>UNIQUE constraint</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 14: Views</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Views</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Analytic Views from multiple tables</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 15: Advanced SQL Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Timestamp</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Extract from timestamp</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mathematical scalar functions</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>String functions3</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced functions</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sub Queries</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT with calculations</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 16: SQL Stored procedures</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create stored procedure</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Stored procedure with parameter</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Drop Procedure</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 17: Import &amp; Export data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Import .csv file</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Export Data to .csv file</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 18: Backup and Restore Database</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Database backup</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Restoring Database backup</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Learning & Development

Data Engineering

AWS Certified Database

Data Skills

Learn MySQL from Scratch for Data Science and Analytics

Advanced Diploma in User Experience UI/UX Design Course

Packt

GitHub

Programming

GitHub is a Git repository hosting service, but it adds many of its own features. While Git is a command line tool, GitHub provides a Web-based graphical interface. It also provides access control and several collaboration features, such as a wikis and basic task management tools for every project.

Complete Git Guide: Understand and Master Git and GitHub

This course will help you become familiar with the implementation of creational design patterns. Featuring real-world examples written in modern C++, each pattern is explained in detail to help you to understand how the pattern can be implemented efficiently using language features.

Creational Design Patterns in Modern C++

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This in an intermediate-level Java development course geared for students experienced with Java and Spring programming essentials.  This course does not cover Java or Spring development basics.</p>Overview<p>Working within in an engaging, hands-on learning environment, guided by our expert team, attendees will:<br />Understand the ReactiveX specification<br />Understand the basics of Reactive Programming<br />Discuss the advantages and limitations of Observables<br />Write a client application capable of handling Reactive events<br />Apply operators to event streams to filter, modify and combine the objects emitted by event publishers<br />Select the appropriate type of Event Source<br />Use both Cold and Hot Observables<br />Deal with backpressure problems in reactive programming<br />Develop a reactive web application using Spring WebFlux<br />Define application flows of a WebFlux application<br />Use the WebClient API to work with both synchronous and streaming APIs<br />Develop Unit and Integration tests to test WebFlux endpoints<br />Creating a reactive REST endpoint<br />Become familiar with the basics of WebSockets<br />Create a WebSocket endpoint using Spring<br />Create a WebSocket client<br />Understand the basics of NoSQL<br />Become familiar with the basics of MongoDB<br />Understand how the data in MongoDB can be retrieved using a Reactive API<br />Define Spring Data MongoDB repositories<br />Query the MongoDB using Spring Data<br />Define a reactive repository using MongoDB<br />Explore the Spring Data R2DBC API to perform reactive CRUD operations against a relational database</p><p>Spring Data reative allow us to implement database operations relying on Reative Programming APIs. While the Spring R2DBC initiative aims to bring reactive programming to relational databaes, several NoSQL databases already provide this possibility. After an introduction to NoSQL and the MongoDB, this courses covers the APIs available to communicate with this NoSQL database using both blocking and reactive APIs.Introdcution to Reactive Spring is a comprehensive Java training workshop geared for experienced developers who wish to explore concurrent, asynchronous and reactive programming APIs and techniques using Spring. After an introduction to reactive programming, Reactive Streams and the Project Reactor APIs, this course will show how this APIs are integrated into Spring. Spring 5 includes Spring WebFlux, providing a reactive programming model for web applications, including support for Reactive REST APIs. Spring WebSocket assists in the creation of web applications which provide a full-duplex, two-way communication between client and server.</p></div><div id="course-pills-2"><h4>Introduction to Reactive Programming</h4><ul><li>Reactive Manifesto</li><li>Introduce ReactiveX</li><li>ReactiveX implementations</li><li>The Observer, Iterator pattern and functional programming</li><li>Discuss hot and cold publishers</li></ul><h4>Reactive Streams API</h4><ul><li>Introduce the Reactive Streams specification</li><li>Publisher and Subscribers</li><li>java.util.concurrent.Flow</li><li>Transformation of Messages (Processor)</li><li>Controlling messages</li><li>Tutorial: Setup Eclipse for Using Maven</li></ul><h4>Introduction</h4><ul><li>Introduce the Reactor Building blocks</li><li>Flux and Mono</li><li>Creating observables</li><li>Subscribing to a stream</li></ul><h4>Testing Event Sources (introduction)</h4><ul><li>Testing reactive implementations</li><li>StepVerifier : test sequence of emitted items</li><li>Defining expectations</li><li>TestPublisher: produce test data to test downstream operators</li></ul><h4>Reactive Operators</h4><ul><li>Introduce Operators</li><li>Show the use of marble diagrams</li><li>Explain some commonly used operators</li><li>Callback operators</li></ul><h4>Schedulers (Multithreading)</h4><ul><li>Thread usage of subscriber and consumer</li><li>Using the subscribeOn method</li><li>Introduce the Scheduler interface</li><li>Using the observeOn method</li></ul><h4>Backpressure</h4><ul><li>Strategies for dealing with Backpressure</li><li>?reactive pull? backpressure</li></ul><h4>Exception Handling</h4><ul><li>Handling errors in onError</li><li>Exception handling strategies</li><li>Using onErrorReturn or onErrorNext operators</li><li>Using the retry operators</li><li>The Global Error Handler</li></ul><h4>Spring Data Review</h4><ul><li>Quick review of Spring Data repositories</li><li>Query return types</li><li>Defining Query methods</li><li>Pagination and sorting</li></ul><h4>R2DBC</h4><ul><li>Reactive Relational Database Connectivity</li><li>DatabaseClient</li><li>Performing CRUD operations</li><li>Reactive Query annotated methods</li></ul><h4>Spring WebFlux: Introduction</h4><ul><li>Annotated Controllers</li><li>Functional Endpoints</li><li>WebFlux configuration</li><li>Creating a reactive REST endpoint</li></ul><h4>Defining flows</h4><ul><li>Defining the application flow</li><li>Actions</li><li>Defining decision</li><li>Navigating flows</li><li>RouterFunction</li></ul><h4>View Technologies</h4><ul><li>View technologies</li><li>Using Thymeleaf to create the view</li><li>View Configuration</li></ul><h4>Spring WebClient: Introduction to WebClient</h4><ul><li>Working with asynchronous and streaming APIs</li><li>Making requests</li><li>Handling the response</li><li>Lab: WebClient</li></ul><h4>WebTestClient</h4><ul><li>Testing WebFlux server endpoints</li><li>Testing controllers or functions</li><li>Define integration tests</li></ul><h4>Introduction to Spring Reactive WebSockets</h4><ul><li>Be familiar with the basics of WebSockets</li><li>Understand the HTTP handshake and upgrade</li><li>Name some of the advantages of WebSockets</li></ul><h4>Defining the WebSocket</h4><ul><li>WebSocket Message Handling</li><li>WebSocketSession</li><li>Implementing the WebSockethandler</li><li>Creating a Browser WebSocket Client</li></ul><h4>WebSocket STOMP</h4><ul><li>Streaming (or Simple) text-orientated messaging protocol </li><li>Introduce SockJS </li><li>Connecting to the STOMP endpoint </li><li>Configuring the message broker </li><li>STOMP destinations</li></ul><h4>Reactive WebSocket</h4><ul><li>Reactive WebSocket support</li><li>Implement the reactive WebSocketHandler</li></ul><h4>BigData</h4><ul><li>Introduce Big Data</li><li>Explain the need for enhanced data storage</li></ul><h4>Introduction to MongoDB</h4><ul><li>JavaScript Object Notation Overview</li><li>Introduce Binary JSON (BSON)</li><li>Starting the database</li><li>Creating Collections and Documents</li><li>Executing ?simple? database commands</li><li>Introduce the ObjectID</li><li>Searching for documents using query operators</li><li>Updating and deleting documents</li><li>MongoDB Compass</li></ul><h4>Spring and MongoDB</h4><ul><li>MongoDB Support in Spring Data</li><li>MongoClient and MongoTemplate</li><li>Spring Data MongoDB configuration</li><li>@EnableMongoRepositories</li><li>Adding documents to the database</li><li>The @Document and @Field annotations</li><li>Polymorphism and the _class property</li><li>The Criteria object</li></ul><h4>Spring Data MongoDB</h4><ul><li>MongoRepository</li><li>Field naming strategy</li><li>Using JSON queries to find documents</li><li>The @PersistenceConstructor annotation</li></ul><h4>Reactive Repositories with MongoDB</h4><ul><li>Using reactive repositories</li><li>ReactiveMongoTemplate</li><li>RxJava or Reactor</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Introduction to Reactive Spring (TT3355 ) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Introduction to Reactive Spring (TT3355 ) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Spring Framework

Spring WebFlux

Introduction to Reactive Spring (TT3355 )

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for entry-level computer support professionals with a basic knowledge of computer hardware, software, and operating systems who wish to increase their knowledge and understanding of networking concepts and acquire the required skills to prepare for a career in network support or administration, or who wish to prepare for the CompTIA Network+ certification. CompTIA Network+ is the first certification IT professionals specializing in network administration and support should earn. Network+ is aimed at IT professionals with job roles such as network administrator, network technician, network installer, help desk technician, and IT cable installer. This course is also designed for students who are seeking the CompTIA Network+ certification and who want to prepare for the CompTIA Network+ N10-008 Certification Exam.</p>Overview<p>In this course, you will describe the major networking technologies and systems of modern networks and configure, manage, and troubleshoot modern networks. Explain the OSI and TCP/IP Models. Explain properties of network traffic. Install and configure switched networks. Configure IP networks. Install and configure routed networks. Configure and monitor ports and protocols. Explain network application and storage issues. Monitor and troubleshoot networks. Explain network attacks and mitigations. Install and configure security devices. Explain authentication and access controls. Deploy and troubleshoot cabling solutions. Implement and troubleshoot wireless technologies. Compare and contrast WAN technologies. Use remote access methods. Identify site policies and best practices.</p><p>CompTIA's Network+ certification is a foundation-level certification designed for IT professionals with around one year of experience, whose job role is focused on network administration.<br /><br />The CompTIA Network+ exam will certify the successful candidate has the knowledge and skills required to troubleshoot, configure, and manage common network devices; establish basic network connectivity; understand and maintain network documentation; identify network limitations and weaknesses; and implement network security, standards, and protocols. The candidate will have a basic understanding of enterprise technologies, including cloud and virtualization technologies.  <br /><br /> The Official CompTIAÂ© Network+Â© (Exam N10-008): will teach you the fundamental principles of installing, configuring, and troubleshooting network technologies and help you to progress a career in network administration. In this course, you will build on your existing user-level knowledge and experience with personal computer operating systems and networks to master the fundamental skills and concepts that you will need to use on the job in any type of networking career.</p>Prerequisites<p></p><ul><li>CompTIA A+ Certification (Exams 220-1001 and 220-1002)</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Explaining the OSI and TCP/IP Models</h3> <ul> <li>Topic A: Explain OSI Model Layers</li> <li> Topic B: Explain the TCP/IP Suite</li> </ul> <h3>2 - Explaining Properties of Network Traffic</h3> <ul> <li>Topic A: Explain Media Types and Access Methods</li> <li> Topic B: Deploy Ethernet Standards</li> <li> Topic C: Configure and Monitor Network Interfaces</li> </ul> <h3>3 - Installing and Configuring Switched Networks</h3> <ul> <li>Topic A: Install and Configure Hubs and Bridges</li> <li> Topic B: Install and Configure Switches</li> <li> Topic C: Compare and Contrast Network Topologies</li> <li> Topic D: Compare and Contrast Network Types</li> </ul> <h3>4 - Configuring IP Networks</h3> <ul> <li>Topic A: Configure IPv4 Addressing Components</li> <li> Topic B: Test IP Interfaces with Command Line Tools</li> <li> Topic C: Configure IPv4 Subnets</li> <li> Topic D: Configure Private and Public IPv4 Addressing Schemes</li> <li> Topic E: Configure IPv6 Addressing Components</li> <li> Topic F: Configure DHCP Services</li> </ul> <h3>5 - Installing and Configuring Routed Networks</h3> <ul> <li>Topic A: Explain Characteristics of Routing</li> <li> Topic B: Install and Configure Routers</li> </ul> <h3>6 - Configuring and Monitoring Ports and Protocols</h3> <ul> <li>Topic A: Explain the Uses of Ports and Protocols</li> <li> Topic B: Use Port Scanners and Protocol Analyzers</li> <li> Topic C: Explain the Use of Name Resolution Services</li> <li> Topic D: Configure DNS and IPAM Services</li> </ul> <h3>7 - Explaining Network Application and Storage Services</h3> <ul> <li>Topic A: Explain the Uses of Network Applications</li> <li> Topic B: Explain the Uses of Voice Services and Advanced Networking Devices</li> <li> Topic C: Explain the Uses of Virtualization and Network Storage Services</li> <li> Topic D: Summarize the Concepts of Cloud Services</li> </ul> <h3>8 - Monitoring and Troubleshooting Networks</h3> <ul> <li>Topic A: Monitor Network Interfaces and Logs</li> <li>Topic B: Explain Network Troubleshooting Methodology</li> <li>Topic C: Troubleshoot Common Network Services Issues</li> </ul> <h3>9 - Explaining Networking Attacks and Mitigations</h3> <ul> <li>Topic A: Summarize Common Networking Attacks</li> <li>Topic B: Explain the Characteristics of VLANs</li> <li>Topic C: Explain the Characteristics of NAT and Port Forwarding</li> </ul> <h3>10 - Installing and Configuring Security Devices</h3> <ul> <li>Topic A: Install and Configure Firewalls and Proxies</li> <li>Topic B: Explain the Uses of IDS/IPS and UTM</li> </ul> <h3>11 - Explaining Authentication and Access Controls</h3> <ul> <li>Topic A: Explain Authentication Controls and Attacks</li> <li>Topic B: Explain the Uses of Authentication Protocols and Directory Services</li> <li>Topic C: Explain the Uses of Port Security and NAC</li> <li>Topic D: Implement Network Device Hardening</li> <li>Topic E: Explain Patch Management and Vulnerability Scanning Processes</li> </ul> <h3>12 - Deploying and Troubleshooting Cabling Solutions</h3> <ul> <li>Topic A: Deploy Structured Cabling Systems</li> <li>Topic B: Deploy Twisted Pair Cabling Solutions</li> <li>Topic C: Test and Troubleshoot Twisted Pair Cabling Solutions</li> <li>Topic D: Deploy Fiber Optic Cabling Solutions</li> </ul> <h3>13 - Implementing and Troubleshooting Wireless Technologies</h3> <ul> <li>Topic A: Install and Configure Wireless Technologies</li> <li>Topic B: Troubleshoot Wireless Performance Issues</li> <li>Topic C: Secure and Troubleshoot Wireless Connectivity</li> </ul> <h3>14 - Comparing and Contrasting WAN Technologies</h3> <ul> <li>Topic A: Compare and Contrast WAN Core Service Types</li> <li>Topic B: Compare and Contrast WAN Subscriber Service Types</li> <li>Topic C: Compare and Contrast WAN Framing Service Types</li> <li>Topic D: Compae and Contrast Wireless and IoT WAN Technologies</li> </ul> <h3>15 - Using Remote Access Methods</h3> <ul> <li>Topic A: Use Remote Access VPNs</li> <li>Topic B: Use Remote Access Management Methods</li> </ul> <h3>16 - Identifying Site Policies and Best Practices</h3> <ul> <li>Topic A: Manage Networks with Documentation and Diagrams</li> <li>Topic B: Summarize the Purposes of Physical Security Devices</li> <li>Topic C: Compare and Contrast Business Continuity and Disaster Recovery Concepts</li> <li>Topic D: Identify Policies and Best Practices</li> </ul></div>

CompTIA Network+

Cisco Certified Entry Networking Technician (CCENT)

IT Networking Fundamentals

CompTIA A+

Computer Networking

CompTIA Security+

Tom Reynolds

Product Management

Agile

Agile PM

Productivity

Kanban

Agile Coach

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 24-26 September

Standard

Early Bird

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Microsoft Visio is a powerful tool for creating diagrams, flowcharts, organizational charts, and other visual representations of data. In this online course, you will learn how to use Visio&#39;s features and functions to design and customize professional-looking diagrams for various purposes and audiences. You will also learn how to collaborate with others, share your diagrams, and publish them in different formats. By the end of this course, you will be able to create and edit Visio diagrams with confidence and efficiency.</p>

Microsoft Visio is a powerful tool for creating diagrams, flowcharts, organizational charts, and other visual representations of data. In this online course, you will learn how to use Visio's features and functions to design and customize professional-looking diagrams for various purposes and audiences. You will also learn how to collaborate with others, share your diagrams, and publish them in different formats. By the end of this course, you will be able to create and edit Visio diagrams with confidence and efficiency.

IT's Easy Training

Business Process Model & Notation (BPMN)

Visio

Microsoft Visio

Process Modelling

Business Process Modeling

Are you looking for a way to create stunning diagrams, flowcharts, and visuals for your projects? Do you want to learn how to use Microsoft Visio, the industry-standard software for diagramming and vector graphics? If so, then this online course is for you!

In this course, you will learn everything you need to know about Microsoft Visio, from the basics to the advanced features. You will learn how to create and edit different types of diagrams, such as business process models, organisational charts, network diagrams, floor plans, and more. You will also learn how to customize your diagrams with shapes, colours, themes, styles, and data. You will discover how to collaborate with others on your diagrams using co-authoring, commenting, and sharing features. And you will explore how to integrate your diagrams with other Microsoft Office applications, such as Word, Excel, PowerPoint, and Outlook.

By the end of this course, you will be able to create professional-looking diagrams that communicate your ideas clearly and effectively.  Whether you are a beginner or an expert, this course will help you master Microsoft Visio and take your diagramming skills to the next level.


<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is an IT, facilities or data centre operations professional working in and around the data centre and having the responsibility to achieve and improve high-availability and manageability of the data centre.</p>Overview<p>After completion of the course the participant will be able to:? Understand the design life cycle of data centres and the stages involved? Discuss the data centre requirements in great level of detail with vendors, suppliers and contractors to ensure that these requirements are met? Validate design plans, quotes and offers proposed by vendors/contractors? Understand redundancy levels for both the data centre design/setup and maintenance? Understand the various building considerations such as bullet proofing, mitigation of seismic activity, fire ratings and thermal stability? Understand how to install a raised floor that meets requirements, avoiding misalignment, level differences and leakage? Understand how to read a Single Line Electrical Diagram to identify and avoid the most common design issues? Choose the correct UPS and parallel configuration, learn and avoid classic parallel installation mistakes? Understand how to calculate battery banks, validate offered configurations to ensure they meet requirements? Understand what distance to keep to avoid EMF issues for human safety and equipment disturbances? Understand the fundamental cooling setup, CFM, Delta-T and other important factors? Understand contamination factors and limitations? Understand full details of fire suppression options, how to calculate gas content and verify installations? Understand how to measure data centre energy efficiency and how to improve it</p><p>The course will bring participants to the level of a suitable sparring partner with suppliers. They will be able to verify offers provided by vendors for correctness, effectiveness and efficiency.</p></div><div id="course-pills-2"><h4>Data Centre Design/Life Cycle Overview</h4><ul><li>Overview of the phases of a data centre life cycle<br />Planning, re-alignment and continuous improvement</li></ul><h4>Standards and Rating Level Definitions</h4><ul><li>Rating level history<br />Difference between Uptime and TIA-942<br />Rating level definitions<br />Redundancy options (N+1), 2N, 2(N+1)<br />Concurrent Maintainability/Compartmentalisation<br />Example configurations<br />Substation and feed requirements<br />Maintenance options<br />Operational processes guidelines/standards<br />Skill development</li></ul><h4>Building Considerations</h4><ul><li>Building location considerations<br />Floor and hanging loads requirements<br />Fire rating for walls and glass<br />Blast protection<br />Bullet proofing<br />Forced entry protection</li></ul><h4>Advanced Raised Floor &amp; Suspended Ceiling</h4><ul><li>Raised floor installation guidelines<br />Techniques to install a proper and leveled raised access floor<br />Common mistakes<br />Choosing the right tiles and their locations<br />Seismic-mitigating floor constructions<br />Choosing the correct suspended ceiling</li></ul><h4>Advanced Power</h4><ul><li>Power infrastructure layout;<br />Formulas which you should know for the data centre<br />Single Line Electrical diagrams; how to read to ensure key components are present for protection<br />Over current protection devices (MCB/MCCB/VCB/ACB/Fuses) definitions and what to use where<br />Earth Leakage devices (RCB/RCD/ELCB/GFCI/ALCI/RCBO), definitions and what to use where<br />Sizing of protective components<br />Lightning strikes and surge protection devices (TVSS/SPD), how they operate, where to use and how to install<br />Power cabling and cable run considerations<br />PDU/DB setup and minimum requirements<br /><br />Generators;<br />Generator types: Standy/Prime/Continuous<br />Component make up and functions<br />Fuel storage and calculation<br />Paralleling of gen-sets<br />Generator room/area requirements<br /><br />UPS Systems;<br />Required specifications for UPS systems<br />How to read data sheets and select the correct UPS<br />Requirements for parallel configurations and avoid pitfalls such as single point of failures<br />How parallel installation should be done, classic mistakes made by installers and how to avoid these<br /><br />Harmonic Filters;<br />Active/Passive filters and their application<br /><br />Battery Banks;<br />Battery bank terminology<br />Designing battery banks, how to calculate, and double check the battery bank to be installed<br />Battery charging pitfalls and ensuring the right charger is being installed and used<br />Using parallel battery banks; how to properly install them, limitations and risks when using batteries in parallel<br />How to test batteries correctly and make decisions on cell/block or string replacement<br />Battery casing choices; ABS, V0, V1, V2<br />Alternative energy storage; flywheel, re-usable cell, compressed air UPS, etc.</li></ul><h4>Advanced Electro Magnetic Fields</h4><ul><li>Sources of EMF<br />Difference between single, three phase and bus-bar EMF<br />Options available to measure EMF and how to interpret the results from single-axes and composite measurements<br />Guidance on safe distance for equipment and humans<br />Calculation of EMF attenuation factor for shielding material permeability and saturation factors</li></ul><h4>Advanced Cooling</h4><ul><li>Important definitions; dry-bulb, wet-bulb, dew-point, RH, sensible and latent heat<br />Psychometric chart and ASHRAE recommendations<br />Environmental class definitions and thermal specifications<br />Temperature/humidity measurements guideline<br />Heat dissipation methods<br />Altitude impact on temperature intake to ICT equipment<br />Floor plan setup for effective cooling<br />Differences in tile surface and supporting structure and the air-flow performance impact<br />Rack door construction and the flow performance impact<br />Equipment Delta-T and its impact<br />Optimising air flow<br />Thermal units conversions<br />Calculations for air volume displacement (CFM/CMH)<br />Cooling capacity calculations<br />Air-conditioning selection<br />De- / humidifying options<br />Air conditioning efficiency<br />SHR impact on cost saving<br />Efficiency indicator<br />New cooling principle and techniques (Submerged, VSD/VRF/ECF/water- and air side economisers)<br />Redundancy guidelines for air-conditioners avoiding classic misconceptions and mistakes for meeting ANSI/TIA-942 compliant designs<br />Installation requirements<br />Connections to fire panel and EPO<br />Commissioning of air conditioners<br />Set points and calibration<br />CFD (Computational Fluid Dynamics)</li></ul><h4>Advanced Fire Protection</h4><ul><li>The fire triangle and elements to stop a fire<br />Detection systems in detail (VESDA, VIEW, smoke sensors)<br />Considerations for installation of sensors<br />Proper testing of smoke sensors<br />Water based systems i.e. deluge, wet-pipe, dry-pipe, pre-action and why most of them don't work and how to detect this<br />Details on Inert and Halocarbon systems and how to select the correct system for your data centre<br />How to calculate the gas content ensuring the appropriate level is installed to suppress the fire including safety considerations<br />Other requirements for gas systems such as release times, hold times, pipe install requirements and other important factors<br />Requirements for the fire detection panel<br />Installation verification, methods, what to check and how<br />New advanced fire suppression technologies</li></ul><h4>Design and Install Scalable Networking Cabling System</h4><ul><li>ANSI/TIA942 cabling structure topology<br />ToR, EoR Design<br />Intelligent patching systems<br />Installation best practice such as routing, bending radius, separation from power, containment fill ratio, fiber link loss calculator, bonding and grounding requirement<br />Standard for telecommunications labeling and administration</li></ul><h4>Environmental Specifications and Contamination Control</h4><ul><li>Acoustic noise effects, regulations, specifications and limits<br />Data centre contaminations and classifications<br />Measurements, standards and limits<br />Preventive measures and avoidance</li></ul><h4>Data Centre Efficiency</h4><ul><li>Business drivers to go Green<br />High-availability or Green?<br />Green guidelines and standards<br />How to measure it and what are acceptable numbers compared to the general industry<br />PUE classes defined by Green Grid and issues with PUE<br />Techniques for saving energy in all parts of the data centre i.e. application/system level, cooling, power distribution</li></ul><h4>Mock Exam</h4><h4>EXAM: Certified Data Centre Specialist</h4></div>

Service Design Courses (SDC)

IT Certifications

Construction Design & Management (CDM)

Certificate of Business Continuity Programme (CBCI)

Certified in Data Protection (CDP)

Electrical Design

Certified Data Centre Specialist (CDCS)

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					<div><p><span>The comprehensive Advanced Piping &amp; Instrumentation Diagrams P&amp;IDs has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Advanced Piping &amp; Instrumentation Diagrams P&amp;IDs today, and learn from the very best the industry has to offer!</span></p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div><p><span>This best selling Advanced Piping &amp; Instrumentation Diagrams P&amp;IDs has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced Piping &amp; Instrumentation Diagrams P&amp;IDs is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</span></p><p><span>The Advanced Piping &amp; Instrumentation Diagrams P&amp;IDs is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The Advanced Piping &amp; Instrumentation Diagrams P&amp;IDs is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</span></p><p><span>After successfully completing the Advanced Piping &amp; Instrumentation Diagrams P&amp;IDs, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Advanced Piping &amp; Instrumentation Diagrams P&amp;IDs will help you stand out from the crowd. You can also validate your certification on our website.</span></p><p><span>We know that you are busy and that time is precious, so we have designed the Advanced Piping &amp; Instrumentation Diagrams P&amp;IDs to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </span></p><p><span>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</span></p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>

Course Cloud

Chartered Institute of Personnel Development (CIPD)

Professional payroll & pensions qualifications (CIPP)

Diploma in Professional Studies (DPS)

Continuous Professional Development (CPD)

Advanced Piping & Instrumentation Diagrams P&IDs

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Looking to gain a thorough understanding of Piping &amp; Instrumentation Diagrams (P&amp;IDs)? Our online course is the ideal solution for both beginners and seasoned professionals. Our curriculum has been expertly crafted to cover all aspects of this intricate field.</p><p>In the first part of the course, we give a detailed introduction to P&amp;IDs, explaining their importance in various engineering and industrial processes. A key part of this segment is dedicated to familiarizing you with the numerous symbols used in P&amp;IDs. We have integrated practical exercises within the course content, allowing you to apply and practice using these symbols actively.</p><p>The course then progresses into an essential component of P&amp;IDs - process control. We take you through the fundamental elements of control theory and elucidate the structure and functioning of Basic Process Control Systems (BPCS). Gaining a comprehensive understanding of these systems will significantly improve your grasp of P&amp;IDs.</p><p>In the concluding part of the course, we concentrate on the safety systems in P&amp;IDs, primarily focusing on Safety Instrumented Systems (SIS), interlocks, and alarms. These critical safety elements are thoroughly explained with the aid of real-life P&amp;ID examples, enhancing your practical understanding.</p><p>Once you complete the Piping &amp; Instrumentation Diagrams P&amp;IDs course successfully, you'll be awarded a certificate as a testament to your newfound expertise in P&amp;IDs. Our course is a perfect blend of theoretical knowledge and practical application.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Gain a thorough understanding of P&amp;IDs.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Learn to identify and use P&amp;ID symbols.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Understand the basics and advanced concepts of process control.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Grasp the workings of Safety Instrumented Systems (SIS).</span>
									</li>
								<li>
											<span>
													</span>
										<span>Be proficient in reading and creating P&amp;IDs.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Develop a vital skill for a variety of engineering disciplines.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Improve your career prospects in fields like process engineering and plant design.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Understand safety systems and their importance in industry.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Develop a skill that's in high demand in sectors like oil and gas, and power generation.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get a certificate to validate your learning.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Career Path</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Process Engineer</span>
									</li>
								<li>
											<span>
													</span>
										<span>Piping Engineer</span>
									</li>
								<li>
											<span>
													</span>
										<span>Plant Designer</span>
									</li>
								<li>
											<span>
													</span>
										<span>Control Systems Engineer</span>
									</li>
								<li>
											<span>
													</span>
										<span>Safety Systems Engineer</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Basic understanding of engineering concepts.</span>
									</li>
								<li>
											<span>
													</span>
										<span>A keen interest in learning about process and instrumentation diagrams.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internet access for online learning.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>

Skill Up

Learn Piping and Instrumentation Diagrams (P&IDs) and enhance your engineering knowledge. Master P&ID symbols, control theory, and safety systems!

Piping & Instrumentation Diagrams P&IDs

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Are you looking to become a Computer Programmer? Then you will need to know how to communicate your designs and ideas to other programmers, analysts and architects, in an effective way. This is where UML comes in. </span></p><p><span>The<strong> UML Class Diagrams Level 2</strong> course will teach you the skills required to read and create UML class diagrams. It will show you how to use them as a valuable communication and software tool, where you will explore its different concepts from basic to advanced. By the end of this course, you will be able to design object-oriented classes in UML, write code based on UML class diagrams, and much more. You will also have an excellent understanding of the different elements of UML class diagrams.</span></p><p><span>This course has no particular entry requirements, however, a basic understanding of object-oriented programming concepts is ideal. </span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p><span>This best selling </span><b><span><b>UML Class Diagrams Level 2</b> </span></b><span>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth </span><b><span><b>UML Class Diagrams Level 2</b> </span></b><span>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</span></p><p><span><span>The </span><b>UML Class Diagrams Level 2</b> is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The </span><b><span><b>UML Class Diagrams Level 2</b> </span></b><span>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</span></p><p><span><span>After successfully completing the</span><b> UML Class Diagrams Level 2</b>, you will be awarded a certificate of completion  as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the </span><span><b>UML Class Diagrams Level 2</b></span> will help you stand out from the crowd. You can also validate your certification on our website.</p><p><span><span>We know that you are busy and that time is precious, so we have designed the </span><b>UML Class Diagrams Level 2 </b>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </span></p><p><span><span>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</span></span></p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

UML Class Diagrams Level 2

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The Certified Ethical Hacking v12 course will significantly benefit security officers, auditors, security professionals, site administrators, and anyone who is concerned about the integrity of the network infrastructure.</p>Overview<p>Information security controls, laws, and standards. Various types of footprinting, footprinting tools, and countermeasures. Network scanning techniques and scanning countermeasures Enumeration techniques and enumeration countermeasures Vulnerability analysis to identify security loopholes in the target organization?s network, communication infrastructure, and end systems. System hacking methodology, steganography, steganalysis attacks, and covering tracks to discover system and network vulnerabilities. Different types of malware (Trojan, Virus, worms, etc.), system auditing for malware attacks, malware analysis, and countermeasures. Packet sniffing techniques to discover network vulnerabilities and countermeasures to defend against sniffing. Social engineering techniques and how to identify theft attacks to audit human-level vulnerabilities and social engineering countermeasures. DoS/DDoS attack techniques and tools to audit a target and DoS/DDoS countermeasures. Session hijacking techniques to discover network-level session management, authentication/authorization, and cryptographic weaknesses and countermeasures. Webserver attacks and a comprehensive attack methodology to audit vulnerabilities in webserver infrastructure, and countermeasures. Web application attacks, comprehensive web application hacking methodology to audit vulnerabilities in web applications, and countermeasures. SQL injection attack techniques, injection detection tools to detect SQL injection attempts, and countermeasures. Wireless encryption, wireless hacking methodology, wireless hacking tools, and Wi-Fi security tools. Mobile platform attack vector, android vulnerability exploitations, and mobile security guidelines and tools. Firewall, IDS and honeypot evasion techniques, evasion tools and techniques to audit a network perimeter for weaknesses, and countermeasures. Cloud computing concepts (Container technology, serverless computing), the working of various threats and attacks, and security techniques and tools. Penetration testing, security audit, vulnerability assessment, and penetration testing roadmap. Threats to IoT and OT platforms and defending IoT and OT devices. Cryptography ciphers, Public Key Infrastructure (PKI), cryptography attacks, and cryptanalysis tools.</p><p>CEH provides an in-depth understanding of ethical hacking phases, various attack vectors, and preventative countermeasures. It will teach you how hackers think and act maliciously so you will be better positioned to setup your security infrastructure and defend against future attacks. An understanding of system weaknesses and vulnerabilities helps organizations strengthen their system security controls to minimize the risk of an incident. CEH was built to incorporate a hands-on environment and systematic process across each ethical hacking domain and methodology, giving you the opportunity to work towards proving the required knowledge and skills needed to achieve the CEH credential. You will be exposed to an entirely different posture toward the responsibilities and measures required to be secure. Now in its 12th version, CEH continues to evolve with the latest operating systems, tools, tactics, exploits, and technologies.</p></div><div id="course-pills-2"><h3>1 - Introduction to Ethical Hacking</h3> <ul> <li>Information Security Overview</li> <li>Cyber Kill Chain Concepts</li> <li>Hacking Concepts</li> <li>Ethical Hacking Concepts</li> <li>Information Security Controls</li> <li>Information Security Laws and Standards</li> </ul> <h3>2 - 2 - Foot-printing and Reconnaissance</h3> <ul> <li>Footprinting Concepts</li> <li>Footprinting through Search Engines</li> <li>Footprinting through Web Services</li> <li>Footprinting through Social Networking Sites</li> <li>Website Footprinting</li> <li>Email Footprinting</li> <li>Who is Footprinting</li> <li>DNS Footprinting</li> <li>Network Footprinting</li> <li>Footprinting through Social Engineering</li> <li>Footprinting Tools</li> <li>Footprinting Countermeasures</li> </ul> <h3>3 - Scanning Networks</h3> <ul> <li>Network Scanning Concepts</li> <li>Scanning Tools</li> <li>Host Discovery</li> <li>Port and Service Discovery</li> <li>OS Discovery (Banner Grabbing/OS Fingerprinting) </li><li>Scanning Beyond IDS and Firewall</li> <li>Draw Network Diagrams</li> </ul> <h3>4 - Enumeration</h3> <ul> <li>Enumeration Concepts</li> <li>NetBIOS Enumeration</li> <li>SNMP Enumeration</li> <li>LDAP Enumeration</li> <li>NTP and NFS Enumeration</li> <li>SMTP and DNS Enumeration</li> <li>Other Enumeration Techniques</li> <li>Enumeration Countermeasures</li> </ul> <h3>5 - Vulnerability Analysis</h3> <ul> <li>Vulnerability Assessment Concepts</li> <li>Vulnerability Classification and Assessment Types</li> <li>Vulnerability Assessment Solutions and Tools</li> <li>Vulnerability Assessment Reports</li> </ul> <h3>6 - System Hacking</h3> <ul> <li>System Hacking Concepts</li> <li>Gaining Access</li> <li>Escalating Privileges</li> <li>Maintaining Access</li> <li>Clearing Logs</li> </ul> <h3>7 - Malware Threats</h3> <ul> <li>Malware Concepts</li> <li>APT Concepts</li> <li>Trojan Concepts</li> <li>Virus and Worm Concepts</li> <li>Fileless Malware Concepts</li> <li>Malware Analysis</li> <li>Countermeasures</li> <li>Anti-Malware Software</li> </ul> <h3>8 - Sniffing</h3> <ul> <li>Sniffing Concepts</li> <li>Sniffing Technique: MAC Attacks</li> <li>Sniffing Technique: DHCP Attacks</li> <li>Sniffing Technique: ARP Poisoning</li> <li>Sniffing Technique: Spoofing Attacks</li> <li>Sniffing Technique: DNS Poisoning</li> <li>Sniffing Tools</li> <li>Countermeasures</li> <li>Sniffing Detection Techniques</li> </ul> <h3>9 - Social Engineering</h3> <ul> <li>Social Engineering Concepts</li> <li>Social Engineering Techniques</li> <li>Insider Threats</li> <li>Impersonation on Social Networking Sites</li> <li>Identity Theft</li> <li>Countermeasures</li> </ul> <h3>10 - Denial-of-Service</h3> <ul> <li>DoS/DDoS Concepts</li> <li>DoS/DDoS Attack Techniques</li> <li>BotnetsDDoS Case Study</li> <li>DoS/DDoS Attack Tools</li> <li>Countermeasures</li> <li>DoS/DDoS Protection Tools</li> </ul> <h3>11 - Session Hijacking</h3> <ul> <li>Session Hijacking Concepts</li> <li>Application Level Session Hijacking</li> <li>Network Level Session Hijacking</li> <li>Session Hijacking Tools</li> <li>Countermeasures</li> </ul> <h3>12 - Evading IDS, Firewalls, and Honeypots</h3> <ul> <li>IDS, IPS, Firewall, and Honeypot Concepts</li> <li>IDS, IPS, Firewall, and Honeypot Solutions</li> <li>Evading IDS</li> <li>Evading Firewalls</li> <li>IDS/Firewall Evading Tools</li> <li>Detecting Honeypots</li> <li>IDS/Firewall Evasion Countermeasures</li> </ul> <h3>13 - Hacking Web Servers</h3> <ul> <li>Web Server Concepts</li> <li>Web Server Attacks</li> <li>Web Server Attack Methodology</li> <li>Web Server Attack Tools</li> <li>Countermeasures</li> <li>Patch Management</li> <li>Web Server Security Tools</li> </ul> <h3>14 - Hacking Web Applications</h3> <ul> <li>Web Application Concepts</li> <li>Web Application Threats</li> <li>Web Application Hacking Methodology</li> <li>Web API, Webhooks, and Web Shell</li> <li>Web Application Security</li> </ul> <h3>15 - SQL Injection</h3> <ul> <li>SQL Injection Concepts</li> <li>Types of SQL Injection</li> <li>SQL Injection Methodology</li> <li>SQL Injection Tools</li> <li>Evasion Techniques</li> <li>Countermeasures</li> </ul> <h3>16 - Hacking Wireless Networks</h3> <ul> <li>Wireless Concepts</li> <li>Wireless Encryption</li> <li>Wireless Threats</li> <li>Wireless Hacking Methodology</li> <li>Wireless Hacking Tools</li> <li>Bluetooth Hacking</li> <li>Countermeasures</li> <li>Wireless Security Tools</li> </ul> <h3>17 - Hacking Mobile Platforms</h3> <ul> <li>Mobile Platform Attack Vectors</li> <li>Hacking Android OS</li> <li>Hacking iOS</li> <li>Mobile Device Management</li> <li>Mobile Security Guidelines and Tools</li> </ul> <h3>18 - IoT and OT Hacking</h3> <ul> <li>IoT Hacking</li> <li>IoT Concepts</li> <li>IoT Attacks</li> <li>IoT Hacking Methodology</li> <li>IoT Hacking Tools</li> <li>Countermeasures</li> <li>OT Hacking</li> <li>OT Concepts</li> <li>OT Attacks</li> <li>OT Hacking Methodology</li> <li>OT Hacking Tools</li> <li>Countermeasures</li> </ul> <h3>19 - Cloud Computing</h3> <ul> <li>Cloud Computing Concepts</li> <li>Container Technology</li> <li>Serverless Computing</li> <li>Cloud Computing Threats</li> <li>Cloud Hacking</li> <li>Cloud Security</li> </ul> <h3>20 - Cryptography</h3> <ul> <li>Cryptography Concepts</li> <li>Encryption Algorithms</li> <li>Cryptography Tools</li> <li>Public Key Infrastructure (PKI) </li><li>Email Encryption</li> <li>Disk Encryption</li> <li>Cryptanalysis</li> <li>Countermeasures</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans EC-Council Certified Ethical Hacker (CEH) v.12 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the EC-Council Certified Ethical Hacker (CEH) v.12 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Certified in Cybersecurity (CC)

Cyber Security

Certified Ethical Hacker (CEH)

Certified Cyber Professional (CCP)

Ethical Hacking

EC-Council Certified Ethical Hacker (CEH) v12

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>This comprehensive course on <strong>Understand Piping &amp; Instrumentation Diagrams P&amp;IDs</strong> will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This <strong>Understand Piping &amp; Instrumentation Diagrams P&amp;IDs</strong> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder.</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</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>There is no experience or previous qualifications required for enrolment on this <strong>Understand Piping &amp; Instrumentation Diagrams P&amp;IDs</strong>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Our <strong>Understand Piping &amp; Instrumentation Diagrams P&amp;IDs</strong> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>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>14 sections • 119 lectures • 08:26:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•What's a P&amp;ID ?: 00:03:00</p></div><div><div><p>•Why is a P&amp;ID so important ?: 00:02:00</p></div><div><div><p>•Who uses P&amp;ID's ?: 00:06:00</p></div><div><div><p>•How do P&amp;ID's look like ?: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction- PID READING: 00:02:00</p></div><div><div><p>•Anatomy of a P&amp;ID: 00:01:00</p></div><div><div><p>•The title block: 00:03:00</p></div><div><div><p>•The drawing scale: 00:03:00</p></div><div><div><p>•The grid system: 00:02:00</p></div><div><div><p>•The revision block: 00:03:00</p></div><div><div><p>•Changes: 00:02:00</p></div><div><div><p>•Notes and legends: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Valve symbols: 00:14:00</p></div><div><div><p>•Valve actuator symbols: 00:09:00</p></div><div><div><p>•Control valve designations: 00:02:00</p></div><div><div><p>•Standards and conventions for valve status: 00:07:00</p></div><div><div><p>•Process equipment symbols: 00:12:00</p></div><div><div><p>•Piping symbols: 00:03:00</p></div><div><div><p>•Pipe fitting symbols: 00:03:00</p></div><div><div><p>•Isolating, venting &amp; draining symbols for ease of maintenance: 00:05:00</p></div><div><div><p>•Instrumentation: 00:03:00</p></div><div><div><p>•Sensing devices and detectors: 00:04:00</p></div><div><div><p>•Location symbols: 00:04:00</p></div><div><div><p>•Modifiers and transmitters: 00:05:00</p></div><div><div><p>•Indicators and recorders: 00:03:00</p></div><div><div><p>•Controllers: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Example #1 : Identifying process equipment and flow paths: 00:05:00</p></div><div><div><p>•Example #2 : Identifying valve position and failure mode: 00:03:00</p></div><div><div><p>•Example #3 : Identifying the symbols: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Piping designation code: 00:06:00</p></div><div><div><p>•Equipment designation code: 00:03:00</p></div><div><div><p>•Instrument designation code: 00:02:00</p></div><div><div><p>•Miscellaneous designation codes: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•The process: 00:01:00</p></div><div><div><p>•Process control: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•The control loop: 00:02:00</p></div><div><div><p>•Process control terms: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Control loops : Feedback control: 00:02:00</p></div><div><div><p>•Pressure control loops: 00:01:00</p></div><div><div><p>•Flow control loops: 00:01:00</p></div><div><div><p>•Level control loops: 00:01:00</p></div><div><div><p>•Temperature control loops: 00:01:00</p></div><div><div><p>•Multi-variable loops: 00:02:00</p></div><div><div><p>•Feedforward control: 00:02:00</p></div><div><div><p>•Feedforward + Feedback: 00:01:00</p></div><div><div><p>•Cascade control: 00:08:00</p></div><div><div><p>•Split range control: 00:03:00</p></div><div><div><p>•Operations on control signals: 00:02:00</p></div><div><div><p>•Ratio control: 00:02:00</p></div><div><div><p>•Batch control: 00:01:00</p></div><div><div><p>•Selective control: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Do we need to control at all ?: 00:01:00</p></div><div><div><p>•Principles of equipment-wise control: 00:10:00</p></div><div><div><p>•Pipe control system: 00:02:00</p></div><div><div><p>•Control of a single pipe: 00:02:00</p></div><div><div><p>•Control of pressure in a pipe: 00:03:00</p></div><div><div><p>•Control of flow in a pipe: 00:04:00</p></div><div><div><p>•Flow merging: 00:08:00</p></div><div><div><p>•Flow splitting: 00:05:00</p></div><div><div><p>•Centrifugal pump control: 00:04:00</p></div><div><div><p>•Control valve vs Variable Frequency Drive (VFD) for centrifugal pumps: 00:03:00</p></div><div><div><p>•Minimum flow control for centrifugal pumps: 00:09:00</p></div><div><div><p>•Positive displacement pump control: 00:02:00</p></div><div><div><p>•Control by a recirculation pipe for PD pumps: 00:03:00</p></div><div><div><p>•Variable Speed Drive (VSD) control for PD pumps: 00:01:00</p></div><div><div><p>•Control by stroke adjustment for PD pumps: 00:01:00</p></div><div><div><p>•Compressor control system: 00:02:00</p></div><div><div><p>•Compressor capacity control: 00:12:00</p></div><div><div><p>•Compressor anti-surge control: 00:03:00</p></div><div><div><p>•Heat transfer equipment control: 00:02:00</p></div><div><div><p>•Heat exchanger direct control system: 00:04:00</p></div><div><div><p>•Heat exchanger bypass control system: 00:04:00</p></div><div><div><p>•Reactor temperature control: 00:06:00</p></div><div><div><p>•Air cooler control: 00:02:00</p></div><div><div><p>•Heat exchanger for heat recovery: 00:01:00</p></div><div><div><p>•Heat exchanger back pressure control: 00:02:00</p></div><div><div><p>•Basic fired heater control: 00:08:00</p></div><div><div><p>•Complex fired heater control: 00:05:00</p></div><div><div><p>•Container and vessel control: 00:07:00</p></div><div><div><p>•Container blanket gas control: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Safety strategies: 00:01:00</p></div><div><div><p>•Concept of Safety Instrumented Systems (SIS): 00:01:00</p></div><div><div><p>•SIS actions and types: 00:14:00</p></div><div><div><p>•SIS extent: 00:02:00</p></div><div><div><p>•SIS requirement: 00:03:00</p></div><div><div><p>•Anatomy of a SIS: 00:02:00</p></div><div><div><p>•SIS element symbols: 00:01:00</p></div><div><div><p>•SIS primary elements : Sensors: 00:03:00</p></div><div><div><p>•SIS final elements: 00:04:00</p></div><div><div><p>•Switching valve actuator arrangements: 00:02:00</p></div><div><div><p>•Valve position validation: 00:02:00</p></div><div><div><p>•Merging a switching valve and a control valve: 00:03:00</p></div><div><div><p>•SIS logics: 00:01:00</p></div><div><div><p>•Showing safety instrumented functions on P&amp;ID's: 00:07:00</p></div><div><div><p>•Discrete control: 00:05:00</p></div><div><div><p>•Alarm system: 00:02:00</p></div><div><div><p>•Anatomy of alarm systems: 00:02:00</p></div><div><div><p>•Alarm requirements: 00:06:00</p></div><div><div><p>•Alarm system symbology in P&amp;ID's: 00:06:00</p></div><div><div><p>•Concept of common alarms: 00:01:00</p></div><div><div><p>•Fire and Gas Detection Systems (FGS): 00:03:00</p></div><div><div><p>•Electric motor control: 00:07:00</p></div><div><div><p>•P&amp;ID representation of commands and responses: 00:05:00</p></div><div><div><p>•P&amp;ID representation of inspection and repair: 00:05:00</p></div><div><div><p>•P&amp;ID example of electro-motor control: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•P&amp;ID example #1 : Legend and specifications: 00:05:00</p></div><div><div><p>•P&amp;ID example #2 : Hydrogen delivery station: 00:16:00</p></div><div><div><p>•P&amp;ID example #3 : Acid system: 00:13:00</p></div><div><div><p>•P&amp;ID example #4 : Centrifugal pump: 00:09:00</p></div><div><div><p>•P&amp;ID example #5 : Utility station: 00:04:00</p></div><div><div><p>•P&amp;ID example #6 : Waste water filter: 00:08:00</p></div><div><div><p>•P&amp;ID example #7 : Steam separator: 00:15:00</p></div><div><div><p>•P&amp;ID example #8 : Flare knock-out drum: 00:14:00</p></div><div><div><p>•P&amp;ID example #9 : Centrifugal compressor: 00:05:00</p></div><div><div><p>•P&amp;ID example #10 : Hydrogen production from shale gas: 00:11:00</p></div><div><div><p>•P&amp;ID example #11 : Fired heater: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - Understand Piping &amp; Instrumentation Diagrams P&amp;IDs: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Understand Piping &amp; Instrumentation Diagrams P&amp;IDs: 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>

Apex Learning

Piping

Understand Piping & Instrumentation Diagrams P&IDs

Horsham

<div data-section-id="1695385309833" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695129103966" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695129424983" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695129508013" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Ensure you can fully utilize this powerful tool to create a range of flowcharts and diagrams.</p></div></div></section></div></div></div></section></div></div></div></section></div></div></div></section></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><div data-section-id="1695042071629" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/77df68e-28e4-057f-41d6-ca1d3577146_Course_Overview_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></div></div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Course overview</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration:&nbsp;</strong>1 day (6.5 hours)&nbsp;</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Microsoft Visio is a powerful tool designed to simplify complex information through the creation of simple, professional-looking diagrams.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">While Visio is capable of producing almost any type of drawing this training concentrates on flowcharts, swim lane process diagrams and organisation charts. You will also discover the real power of Visio by adding essential data to the content of your diagrams and producing reports in Excel using this data.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">This course is designed for either new users of Visio or those who have dabbled and can create basic diagrams. Our course will give you the skills and knowledge you need to navigate your way around this powerful program and produce different types of diagram.</p><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></section></div><div data-section-id="1695042071630" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/8ba0826-4fb5-333c-0ea4-28c13064336b_Objectives_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"><br fr-original-style="" style="box-sizing: border-box;"></div></div><div data-section-id="1694266245578" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Objectives&nbsp;</h3><div data-section-id="1695129553631" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By the end of the course you will be able to:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Create and amend flowcharts</li><li fr-original-style="" style="box-sizing: border-box;">Create cross functional (Swim Lane) process flows</li><li fr-original-style="" style="box-sizing: border-box;">Produce organisation charts by importing data</li><li fr-original-style="" style="box-sizing: border-box;">Add essential data to shapes</li><li fr-original-style="" style="box-sizing: border-box;">Export diagram data reports to Excel</li><li fr-original-style="" style="box-sizing: border-box;">Present, publish and print Visio diagrams</li></ul></div></div></section></div></div></div></section></div><div data-section-id="1694266514989" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/cbd24e-e374-8bf2-2a2e-66ae236e51d4_Content_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></p></section></div><div data-section-id="1695042071631" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695048787156" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Content</h3></div><div data-section-id="1695129424986" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Visio essentials</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Finding your way around Visio</li><li fr-original-style="" style="box-sizing: border-box;">Using the ribbon and Quick Access toolbar</li><li fr-original-style="" style="box-sizing: border-box;">Keyboard shortcuts</li><li fr-original-style="" style="box-sizing: border-box;">Shapes and stencils explained</li><li fr-original-style="" style="box-sizing: border-box;">What Visio can do for you</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Creating basic flowcharts</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Working with shapes</li><li fr-original-style="" style="box-sizing: border-box;">Adding and deleting shapes</li><li fr-original-style="" style="box-sizing: border-box;">Joining, aligning and sizing shapes</li><li fr-original-style="" style="box-sizing: border-box;">Using Auto-Connect</li><li fr-original-style="" style="box-sizing: border-box;">Labelling shapes and connectors</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Editing and improvinC flowcharts&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Amending shape and connector labels</li><li fr-original-style="" style="box-sizing: border-box;">Using colours to emphasise</li><li fr-original-style="" style="box-sizing: border-box;">Changing line styles</li><li fr-original-style="" style="box-sizing: border-box;">Moving and copying objects</li><li fr-original-style="" style="box-sizing: border-box;">Grouping diagram elements</li><li fr-original-style="" style="box-sizing: border-box;">Quick ways of working</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Cross functional flowcharts</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Creating Cross-Functional Flowcharts</li><li fr-original-style="" style="box-sizing: border-box;">Manipulating functional bands</li><li fr-original-style="" style="box-sizing: border-box;">Creating off-page references within diagrams and hyperlinks to other documentation</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Organising charts and shape data</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Using the wizard to create an organisation Chart</li><li fr-original-style="" style="box-sizing: border-box;">Importing existing Data into to create an organisation chart</li><li fr-original-style="" style="box-sizing: border-box;">Modifying an organisation chart</li><li fr-original-style="" style="box-sizing: border-box;">Shape Data</li><li fr-original-style="" style="box-sizing: border-box;">Adding shape data to a shape</li><li fr-original-style="" style="box-sizing: border-box;">Creating shape data sets</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Diagram reports</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Exporting data to a report in Excel</li><li fr-original-style="" style="box-sizing: border-box;">Exporting to HTML</li><li fr-original-style="" style="box-sizing: border-box;">Creating and customizing reports</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Presenting, publishing and printing</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Using Page Setup</li><li fr-original-style="" style="box-sizing: border-box;">Print previewing</li><li fr-original-style="" style="box-sizing: border-box;">Embedding backgrounds</li><li fr-original-style="" style="box-sizing: border-box;">Adding headers and footers</li><li fr-original-style="" style="box-sizing: border-box;">Converting your final documentation to PDF</li><li fr-original-style="" style="box-sizing: border-box;">Saving as HTML</li><li fr-original-style="" style="box-sizing: border-box;">Visio with PowerPoint</li></ul></div></section></div></div></section></div><div data-section-id="1695048787157" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></div></div></section></div>

Underscore Group

Visio Flowcharts and Diagrams

320 Courses delivered Online

Discrete Maths Teaching

By The Teachers Training

Learn MySQL from Scratch for Data Science and Analytics Course

By NextGen Learning

Introduction to SQL Programming Basics (TTSQL002)

By Nexus Human

An Introduction to Discrete Maths Course

By NextGen Learning

Effective technical writing (In-House)

By The In House Training Company

Learn MySQL from Scratch for Data Science and Analytics

By Studyhub UK

Advanced Diploma in User Experience UI/UX Design Course

By NextGen Learning

Complete Git Guide: Understand and Master Git and GitHub

By Packt

Creational Design Patterns in Modern C++

By Packt

Introduction to Reactive Spring (TT3355 )

By Nexus Human