Aberdeen

Castleford

Exeter

Glasgow

Heathrow

Manchester

Middlesbrough

Rainham

Southampton

Wellingborough

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(61, 60, 62); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(61, 60, 62);">The aim of the CCNSG Safety Passport is to ensure a basic knowledge of &nbsp;health and safety for all site personnel to enable them, after appropriate site &nbsp;induction, to work on site more safely with lower risk to themselves and others. &nbsp;&nbsp;</span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Book via our website @&nbsp;<a href="https://www.vp-ess.com/training/workplace-safety/ccnsg-safety-passport-national/" id="isPasted" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ESS | Training Courses | Vp ESS (vp-ess.com)</a></p>

The aim of the CCNSG Safety Passport is to ensure a basic knowledge of health and safety for all site personnel to enable them, after appropriate site induction, to work on site more safely with lower risk to themselves and others. 
Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com)
or via email at: esstrainingsales@vpplc.com
or phone on: 0800 000 346

Vp ESS Training

Construction Safety

Workplace Health & Safety

Health & Safety

Health & Safety At Work

Safety Awareness

The aim of the CCNSG Safety Passport is to ensure a basic knowledge of  health and safety for all site personnel to enable them, after appropriate site  induction, to work on site more safely with lower risk to themselves and others.   

Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com)

or via email at: esstrainingsales@vpplc.com

or phone on: 0800 000 346


or via email at: esstrainingsales@vpplc.com

or phone on: 0800 000 346


CCNSG Safety Passport National

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is intended for those who need to use Tableau Desktop to build complex visuals and dashboards to present information or to monitor data about their organization.</p>Overview<p>Upon completion of this course, participants will be able to:Select the best method to work with multiple data sourcesCreate complex visuals using calculations and parametersApply best practices to improve the layout and aesthetics of dashboards</p><p>This course enables participants to create complex visualizations and to combine them into interactive dashboards to share with others using Tableau Desktop.</p></div><div id="course-pills-2"><h4>The Data</h4><ul><li>Data Interpreter</li><li>Data Joins</li><li>Same Database </li><li>Cross Databases</li><li>Spatial Join New!</li><li>Data Blending</li><li>New Union</li><li>Custom SQL</li><li>Tableau Extract</li><li>TDE</li><li>Hyper</li><li>Clipboard</li><li>Database Changes Automatic Updates </li></ul><h4>Calculations</h4><ul><li>Regular Calculations</li><li>Quick Table Calculations</li><li>Table Calculations</li><li>Level of Detail (LOD) Expressions </li></ul><h4>Complex Visualizations</h4><ul><li>Custom Background Map</li><li>Web Map Servers</li><li>Dual Maps</li><li>Bar in Bar Graph</li><li>Bullet Graph</li><li>Pareto Chart</li><li>Sparkline Report</li><li>Top N Within a Category Report</li><li>Waterfall Chart</li><li>Funnel Chart</li><li>Pattern Analysis using the Path Shelf</li></ul><h4>Building Better Dashboards</h4><ul><li>Best Practices for Design</li><li>Best Practices for Performance</li><li>Creating a Template Workbook</li><li>Using Layout Containers</li><li>Dashboard Extenders New!</li><li></li></ul><h4>Generating A Performance Summary</h4></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Tableau Advanced v10.3 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 Tableau Advanced v10.3 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

Tableau Desktop Specialist

Excel Analytics

Tableau

Data Skills

Trainers Course

Data Studio

Tableau Advanced v10.3

<div id="course-pills-1">Duration<p>2.5 Days</p><p>15 CPD hours</p>This course is intended for<p>This course is intended for those with a basic understanding of Tableau who want to pursue mastery of the advanced features.<br /><br /></p><div> </div><p></p>Overview<p>The goal of this course is to present essential Tableau concepts and its advanced functionalities to help better prepare and analyze data.<br /><br /></p><div> </div><p></p><p>This course will use Tableau Hyper, Tableau Prep and more.</p></div><div id="course-pills-2"><h4>Getting Up to Speed ? a Review of the Basics</h4><ul><li>Connecting Tableau to your data</li><li>Connecting to Tableau Server</li><li>Connecting to saved data sources</li><li>Measure Names and Measure Values</li><li>Three essential Tableau concepts</li><li>Exporting data to other devices</li><li>Summary</li><li></li></ul><h4>All About Data ? Getting Your Data Ready</h4><ul><li>Data mining and knowledge discovery process models CRISP?DM</li><li></li></ul><h4>All About Data ? Joins, Blends, and Data Structures</h4><ul><li>All About Data - Joins, Blends, and Data Structures</li><li>Introduction to joins</li><li>Introduction to complex joins</li><li>Exercise: observing join culling</li><li>Introduction to join calculations </li><li>Introduction to spatial joins</li><li>Introduction to unions</li><li>Understanding data blending</li><li>Order of operations</li><li>No dimensions from a secondary source</li><li>Introduction to scaffolding</li><li>Introduction to data structures</li><li>Exercise: adjusting the data structure for different questions</li><li>Summary</li><li></li></ul><h4>Table Calculations</h4><ul><li>Table Calculations</li><li>A definition and two questions</li><li>Introduction to functions</li><li>Directional and non-directional table calculations</li><li>Application of functions</li><li>Summary</li><li></li></ul><h4>Level of Detail Calculations</h4><ul><li>Level of Detail Calculations</li><li>Building playgrounds</li><li>Playground I: FIXED and EXCLUDE</li><li>Playground II: INCLUDE</li><li>Practical application</li><li>Exercise: practical FIXED</li><li>Exercise: practical INCLUDE</li><li>Exercise: practical EXCLUDE</li><li>Summary</li><li></li></ul><h4>Beyond the Basic Chart Types</h4><ul><li>Beyond the Basic Chart Types</li><li>Improving popular visualizations</li><li>Custom background images</li><li>Tableau extensions</li><li>Summary</li><li></li></ul><h4>Mapping</h4><ul><li>Mapping</li><li>Extending Tableau's mapping capabilities without leaving Tableau</li><li>Extending Tableau mapping with other technology</li><li>Exercise: connecting to a WMS server</li><li>Exploring the TMS file</li><li>Exploring Mapbox</li><li>Accessing different maps with a dashboard</li><li>Creating custom polygons</li><li>Converting shape files for Tableau</li><li>Exercise: polygons for Texas</li><li>Heatmaps</li><li>Summary</li><li></li></ul><h4>Tableau for Presentations</h4><ul><li>Tableau for Presentations</li><li>Getting the best images out of Tableau</li><li>From Tableau to PowerPoint</li><li>Embedding Tableau in PowerPoint</li><li>Animating Tableau</li><li>Story points and dashboards for Presentations</li><li>Summary</li><li></li></ul><h4>Visualization Best Practices and Dashboard Design</h4><ul><li>Visualization Best Practices and Dashboard Design</li><li>Visualization design theory</li><li>Formatting rules</li><li>Color rules</li><li>Visualization type rules</li><li>Compromises</li><li>Keeping visualizations simple</li><li>Dashboard design</li><li>Dashboard layout</li><li>Sheet selection</li><li>Summary</li><li></li></ul><h4>Advanced Analytics</h4><ul><li>Advanced Analytics</li><li>Self-service Analytics</li><li>Use case ? Self-service Analytics</li><li>Use case ? Geo-spatial Analytics</li><li>Summary</li><li></li></ul><h4>Improving Performance</h4><ul><li>Improving Performance</li><li>Understanding the performance-recording dashboard</li><li>Exercise: exploring performance recording in Tableau desktop</li><li>Performance-recording dashboard events</li><li>Behind the scenes of the performance- recording dashboard</li><li>Hardware and on-the-fly techniques</li><li>Hardware considerations</li><li>On-the-fly-techniques</li><li>Single Data Source &gt; Joining &gt; Blending</li><li>Three ways Tableau connects to data</li><li>Using referential integrity when joining</li><li>Advantages of blending</li><li>Efficiently working with data sources</li><li>Tuning data sources</li><li>Working efficiently with large data sources</li><li>Intelligent extracts</li><li>Understanding the Tableau data extract</li><li>Constructing an extract for optimal performance</li><li>Exercise: summary aggregates for improved performance</li><li>Optimizing extracts</li><li>Exercise: materialized calculations</li><li>Using filters wisely</li><li>Extract filter performance</li><li>Data source filter performance</li><li>Context filters</li><li>Dimension and measure filters</li><li>Table-calculation filters</li><li>Efficient calculations</li><li>Boolean/Numbers &gt; Date &gt; String</li><li>Additional performance considerations</li><li>Avoid overcrowding a dashboard</li><li>Fixing dashboard sizing</li><li>Setting expectations</li><li>Summary</li><li></li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Advanced Tableau 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 Advanced Tableau 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>

Data Visualization

Advanced Tableau

<h3 style="color: rgb(68, 68, 68); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(68, 68, 68);">Overview</h3><p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">All employees should be aware of and knowledgeable about health and safety in the workplace.</p><p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">This course is ideal for all staff and employees at all levels, providing them with the underpinning health and safety knowledge that they will require to work safely and efficiently on a daily basis.</p><p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">This training will equip employees with the measures necessary to control or reduce risks to the health and/or safety of anyone who might be affected by the activities of anyone at work.</p><h2 style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">Details</h2><h3 style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">What will I learn on this course?</h3><ul style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);"><li fr-original-style="" style="box-sizing: border-box;">The main hazards and risks to health and safety at work, how they are controlled, and your part in helping to control them</li><li fr-original-style="" style="box-sizing: border-box;">The responsibilities of employers and employees under health and safety legislation</li><li fr-original-style="" style="box-sizing: border-box;">The importance of, and the key factors in, risk assessments to control hazards and prevent risks</li><li fr-original-style="" style="box-sizing: border-box;">The hazards and ill-health effects associated with specific work activities and processes, and the key controls to remove or reduce these risks so that they do not cause harm</li></ul><h3 style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">Certification</h3><p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">Successful candidates will receive certification of achievement.</p>

Prima Cura Training

Occupational Health & Safety

Health & Safety Awareness

All employees should be aware of and knowledgeable about health and safety in the workplace. This course is ideal for all staff and employees at all levels, providing them with the underpinning health and safety knowledge that they will require to work safely and efficiently on a daily basis.

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why Study AAT</strong></p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Want a new direction for your career? Think Accountancy, according to statistics, the average salary for Accountants is &pound;50,000, it is the sector where the employability rate is higher than any other sector. Whether you&#39;re a school leaver, already employed or simply looking for a career change a career in accountancy could be a real option for you.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What is AAT?</strong></p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The AAT is an internationally recognised accounting qualification and over 100,000 people are currently benefiting from gaining an AAT qualification and full AAT membership. Gaining the qualification will help you support yourself throughout your accountancy career.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What are the benefits after I finish AAT Courses?</strong></p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A newly qualified AAT member can expect to earn an average of &pound;21,600. Moreover, the AAT member will have been earning throughout their training and will have avoided student debt. Accounting technicians work at all levels of finance and accounting, depending on the level of their career. Some accounting technicians work as accounts clerks, others go on to become managing directors or finance directors of well-known companies. Some go to work as a self employed accountant as AAT allows the student to become Accredited.</p>
<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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">AAT Qualification</strong></p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">AAT provides a range of accounting and bookkeeping qualification. If you prefer to pursue your career as an accountant you may choose to go for AAT Accounting qualification. However, if you prefer to build your career as a bookkeeper, you may choose to go for AAT Bookkeeping qualification.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Osborne Training is an AAT Approved Training Provider with centres in London , Watford, Birmingham and various other locations. In taking the Association of Accounting Technicians qualification with our Institute, you will make one of the greatest decision of your career.</p><section 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">AAT Accounting Courses</strong></p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">First of all, the AAT qualification consists of four&nbsp;progressive qualification levels (1, 2, 3 &amp; 4) which will cover the key areas of Financial Accounting, Management Accounting, Taxation, Audit and Report Writing. Although you can start from Level 1, you may start from Level 2 if you have basic math and numeracy skills.<br fr-original-style="" style="box-sizing: border-box;">In order to complete the full AAT Accounting qualification and gain full membership of the AAT, you will need to complete Level 3 and Level 4. Level 2 is recommended as an entry-level if you have no experience or knowledge of accounting and bookkeeping.<br fr-original-style="" style="box-sizing: border-box;">The AAT qualification for accounting is broken down into three levels:</p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">AAT Level 2&nbsp;</strong>Foundation Certificate in&nbsp; Accounting (5 Papers/Subjects)</li>
<li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">AAT Level 3&nbsp;</strong>Advanced Diploma&nbsp;in&nbsp; Accounting (6 Papers/Subjects)</li>
<li fr-original-style="" style="box-sizing: border-box;">Finally&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">AAT Level 4&nbsp;</strong>Professional Diploma&nbsp;in&nbsp; Accounting (6 Papers/Subjects)</li>
</ul>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Hence, the AAT Accounting Qualification gives you practical, internationally recognised finance and accountancy skills that can open doors for you in any industry across the world.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Finally, AAT offers a range of benefits for student members (including study support, career advice to help find the perfect job and exclusive discounts), as well as a route to progress into chartered accountancy. Moreover, if you choose to further your studies with any&nbsp;of the leading chartered accountancy professional bodies like ACCA, CIMA, CIPFA etc. your AAT qualification could make&nbsp;you eligible for generous exemptions.</p>


                </section>

Osborne Training

AAT Qualification

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>Overview<p>Upon completing this course, you will be able to meet the following objectives:<br />SD-WAN Overview<br />Cloud Concepts<br />Cloud Technologies<br />SD-WAN Direct Cloud Access (DCA)<br />SD-WAN SaaS<br />Cloud On-RAMP for IAAS (AWS)<br />Cloud On-RAMP for IAAS (AZURE)<br />Cloud Configuration for GCP<br />Cloud On-RAMP for MULTI-CLOUD<br />Cloud On-RAMP for CO-LOCATIONS</p><p>This is a 5 day hands-on course on Cisco SD-WAN Cloud Configuration, Monitoring and Troubleshooting. This course provides the student with the knowledge to connect SD-WAN to SaaS Applications, as well as the ability to connect their Branches to AWS, AZURE, GCP Data Centers in the Cloud. Students will also learn how to Configure, Monitor, and Troubleshoot SD-WAN Co-Locations and SD-WAN Multicloud.</p></div><div id="course-pills-2"><h4>SD-WAN Overview</h4><ul><li>SD-WAN Controller<br />SD-WAN WAN Edges supported in Cloud Instances</li></ul><h4>Cloud Concepts</h4><ul><li>Cloud Ops vs WAN Ops<br />Cloud Connectivity<br />Cloud Access Control<br />Cloud Network Connectivity<br />Cloud Regions<br />Cloud Availability Zones<br />Virtual Networks<br />Cloud Routing<br />Internet Gateways VS VPN Gateways<br />VPC/VNET: IP Addressing<br />Cloud Network Load Balancing<br />Cloud Peering<br />Cloud Transit Networks</li></ul><h4>Cloud Technologies</h4><ul><li>Azure<br />Azure Basics<br />Resource Groups<br />vNets<br />Availability zones<br />Availability Set<br />Workload and Public IP<br />Network Virtual Appliance<br />Load Balancer<br />User Defined Routes<br />Network Security Group<br />VPN Gateway<br />Express Routes<br />Creating VNET for SDWAN<br />AWS<br />AWS Basics<br />Region<br />VPCs<br />Availability zones<br />Subnets<br />EC2 Instance<br />Elastic IPs<br />Security Groups<br />Internet Gateway<br />NAT Gateway<br />Route Table<br />VPN Gateway<br />Direct Connect<br />Elastic Load Balancer<br />Subscribe to Amazon machine images<br />Setting AWS resource limits<br />AWS Transit Gateways<br />Creating VPC for SDWAN<br />AWS IAM Role<br />AWS Security Groups<br />Service limits<br />AWS SSH key pair<br />Google Cloud<br />GCP Basics<br />Project<br />Region<br />Virtual Private Cloud<br />Availability Zone<br />Subnets<br />Compute Engine<br />Cloud Load Balancer<br />Cloud DNS<br />VPC Routing<br />Cloud VPN &amp; VPC peering<br />VPC Firewall Rules</li></ul><h4>SD-WAN Direct Cloud Access (DCA)</h4><ul><li>DCA Prerequisites<br />DNS on VPN 0<br />DIA<br />Central Policy Configuration<br />Match Traffic<br />Set QOS<br />Set External Access</li></ul><h4>SD-WAN SaaS</h4><ul><li>Supported Platforms and Versions<br />SaaS Prerequisites<br />DNS on VPN 0<br />DIA<br />SaaS Access Methods<br />Cloud Access through Direct Internet Access Links<br />Cloud Access through a Gateway Site<br />Hybrid Approach<br />Supported SaaS  Applications<br />SaaS Security Options<br />SaaS Configuration<br />Common Scenarios for Using Cloud onRamp for SaaS<br />Specify Office 365 Traffic Category<br />Enable Cloud onRamp for SaaS, Cisco IOS XE SD-WAN Devices<br />Configure Applications for Cloud onRamp for SaaS Using Cisco vManage<br />Configure Sites for Cloud onRamp for SaaS Using Cisco vManage<br />View Details of Monitored Applications</li></ul><h4>Cloud On-RAMP for IAAS (AWS)</h4><ul><li>Prerequisite AWS Configuration<br />Verify prerequisites<br />Configure AWS for Cisco SD-WAN<br />Cloud On-RAMP for AWS Overview<br />Define WAN Edge Type used<br />Define Template<br />Attach Devices to Template<br />Deploy Cloud Onramp<br />AWS IAM Role<br />Select Region<br />Select CPU and Memory<br />Transit Networking IP Addresses<br />Discover and Map Host VPCs<br />AWS to SD-WAN Security<br />Monitor Cisco Cloud Onramp for AWS<br />Troubleshoot Cisco Cloud Onramp for AWS<br />Interconnecting Cisco SD-WAN with AWS Transit Gateway (TGW)</li></ul><h4>Cloud On-RAMP for IAAS (AZURE)</h4><ul><li>Prerequisite AZURE Configuration<br />Cloud On-RAMP for AZURE<br />Configure AWS for Cisco SD-WAN<br />Define WAN Edge Type used<br />Define Template<br />Attach Devices to Template<br />Deploy Cloud Onramp<br />Select Region<br />Discover and Map Host VPCs<br />Monitor Cisco Cloud Onramp for Azure<br />Troubleshoot Cisco Cloud Onramp for AZURE<br />Azure Virtual Wan (VWAN) Integration</li></ul><h4>Cloud Configuration for GCP</h4><ul><li>Prerequisite GCP Configuration<br />SD-WAN Configuration <br />Configure Google Cloud for SD-WAN<br />Google Cloud<br />GCP Basics<br />Deploy cEdge Catalyst 8000V Edges<br />Setup IPSEC Connections<br />Setup BGP Connections</li></ul><h4>Cloud On-RAMP for MULTI-CLOUD</h4><ul><li>AWS Transit Gateway<br />Microsoft vWAN<br />Create Cisco Cloud GW<br />Discover host VPCs/VNets<br />Map Branch nets to VPCs</li></ul><h4>Cloud On-RAMP for CO-LOCATIONS</h4><ul><li>SD-WAN CO-LOCATIONS Overview<br />Colocation facilities<br />Cisco Colocation Equipment<br />Cisco Cloud Services Platform 5444<br />Cisco Network Function Virtualization Infrastructure Software (NFVIS)<br />Virtual Network Functions<br />Network Fabric<br />Cisco Catalyst 9500-48Y4C switch<br />Cisco Catalyst 9500-40X switch<br />Device Configuration and Connectivity<br />Sizing the Colocation Solution Devices<br />Cisco Colocation Manager<br />Deploy Network Services at the Network Edge<br />Colocation Solution?Deployment Workflow<br />Monitor Cisco SD-WAN Colocation Devices<br />Cisco Colocation Manager States for Switch Configuration<br />Cisco Colocation Manager States and Transitions from Host<br />Cisco Colocation Manager Notifications<br />VM Alarms<br />Cloud Services Platform Real-Time Commands<br />Colocation High Availability<br />Troubleshoot Cisco SD-WAN Cloud onRamp for Colocation Solution<br />Troubleshoot Catalyst 9500 Issues<br />Troubleshoot Cloud Services Platform Issues<br />DHCP IP Address Assignment<br />Troubleshoot Cisco Colo Manager Issues<br />Troubleshoot Service Chain Issues<br /> Troubleshoot Physical Network Function Management Issues<br />Log Collection from CSP<br />Troubleshoot vManage Issues</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco SD-WAN Cloud (SDWAN-CLD-CT) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Cisco SD-WAN Cloud (SDWAN-CLD-CT) 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>

AWS Certification

Service Design Courses (SDC)

Cloud Architecture

AWS Certified Cloud Practitioner

Google Cloud

AWS Certified Solutions Architect

Cisco SD-WAN Cloud (SDWAN-CLD-CT)

Grantham

<p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Equip yourself and your team with the skills to act confidently in an emergency!</span></strong></strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Overview:</strong></strong></span></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This three days (6 hours)First Aid at Work (FAW) course provides learners with the essential knowledge and skills to respond effectively to first aid emergencies in low-risk workplaces. Our FAIB-approved course is delivered by experienced instructors who use a hands-on approach to ensure comprehensive learning.</span></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Benefits:</strong></strong></span></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Industry-standard training:</strong></strong>&nbsp;Meets all UK regulations and is recognised nationwide.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Qualified instructors:</strong></strong>&nbsp;Learn from experienced professionals who share valuable insights and practical skills.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Confidence in emergencies:</strong></strong>&nbsp;Gain the knowledge to act calmly and effectively in unexpected situations.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Peace of mind:</strong></strong>&nbsp;Ensure your workplace meets health and safety requirements.</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who should attend?</strong></strong></span></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This course is ideal for employees in low-risk workplaces such as offices, retail stores, and administrative environments who are designated as first aiders.</span></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content:</strong></strong></span></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Role and responsibilities of a first aid responder</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Assessing an incident scene</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Unresponsive casualties and CPR</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">AED (Automated External Defibrillator) awareness</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Managing seizures</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Choking emergencies</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">External bleeding control</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Shock management</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Burns and scalds</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Minor injuries (cuts, bruises, splinters)</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certification:</strong></strong></span></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Upon successful completion of the course, participants will receive a recognised FAW certificate valid for three years.</span></p>

Total Compliance 

First Aid At Work

Emergency First Aid At Work (EFAW)

Workplace First Aid

First Aid

Family First Aid

Child First Aid

First Aid at Work (FAAW):

General Admission

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This hands-on course is geared for experienced DBAs with basic Oracle 19c skills.</p>Overview<p>This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs andexercises. Working in a hands-on learning environment led by our expert facilitator, students will explore:<br />Creating CDBs and Regular PDBs<br />Managing CDBs and PDBs<br />Backup and Duplicate<br />Upgrading and Transporting CDBs and Regular PDBs<br />Backup Strategies and Terminology<br />Restore and Recovery Concepts<br />Using Flashback Technologies<br />Duplicating a Database<br />Installing Grid Infrastructure and Oracle Database<br />Patching Grid Infrastructure and Oracle Database<br />Upgrading to Oracle Grid Infrastructure<br />Using General Overall Database Enhancements<br />Monitoring and Tuning Database Performance<br />Managing Application PDBs<br />Managing Security in Multitenant databases<br />Recovery and Flashback<br />Configuring and Using RMAN<br />Diagnosing Failures<br />Performing Recovery<br />Transporting Data<br />RMAN Troubleshooting and Tuning<br />Creating an Oracle Database by using DBCA<br />Oracle Restart<br />Upgrading the Oracle Database<br />Installing Grid Infrastructure for a Standalone server<br />Using Availability Enhancements<br />Tuning SQL Statements</p><p>Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration II (Oracle DBA II) expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases.</p></div><div id="course-pills-2"><h4>Creating CDBs and Regular PDBs</h4><ul><li>Configure and create a CDB</li><li>Create a new PDB from the CDB seed</li><li>Explore the structure of PDBs</li></ul><h4>Manage CDBs and PDBs</h4><ul><li>Manage PDB service names and connections</li><li>Manage startup, shutdown and availability of CDBs and PDBs</li><li>Change the different modes and settings of PDBs</li><li>Evaluate the impact of parameter value changes</li><li>Performance management in CDBs and PDBs</li><li>Control CDB and PDB resource usage with the Oracle Resource Manager</li></ul><h4>Backup and Duplicate</h4><ul><li>Perform Backup and Recover CDBs and PDBs</li><li>Duplicate an active PDB</li><li>Duplicate a Database</li></ul><h4>Upgrading and Transporting CDBs and Regular PDBs</h4><ul><li>Upgrade an Oracle Database</li><li>Transport Data</li></ul><h4>Backup Strategies and Terminology</h4><ul><li>Perform Full and Incremental Backups and Recoveries</li><li>Compress and Encrypt RMAN Backups</li><li>Use a media manager</li><li>Create multi-section backups of exceptionally large files</li><li>Create duplexed backup sets</li><li>Create archival backups</li><li>Backup of recovery files</li><li>Backup non database files</li><li>Back up ASM meta data</li></ul><h4>Restore and Recovery Concepts</h4><ul><li>Employ the best Oracle Database recovery technology for your failure situation</li><li>Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery</li></ul><h4>Using Flashback Technologies</h4><ul><li>Configure your Database to support Flashback</li><li>Perform flashback operations</li></ul><h4>Duplicating a Database</h4><ul><li>Duplicate Databases</li></ul><h4>Install Grid Infrastructure and Oracle Database</h4><ul><li>Install Grid Infrastructure for a Standalone server<br />Install Oracle Database software</li></ul><h4>Patching Grid Infrastructure and Oracle Database</h4><ul><li>Patch Grid Infrastructure and Oracle Database</li></ul><h4>Upgrading to Oracle Grid Infrastructure</h4><ul><li>Upgrade Oracle Grid Infrastructure</li></ul><h4>Using General Overall Database Enhancements</h4><ul><li>Install Oracle Database software<br />Create, Delete and Configure Databases using DBCA<br />Creating CDBs and Regular PDBs<br />Use Miscellaneous 19c New Features</li></ul><h4>Monitoring and Tuning Database Performance</h4><ul><li>Managing Memory Components<br />Understanding the Automatic Workload Repository (AWR)<br />Understanding the Advisory Framework<br />Monitoring Wait Events, Sessions, and Services<br />Managing Metric Thresholds and Alerts<br />Understanding and Using the Performance Tuning Methodology<br />Performing Performance Planning<br />Understanding the Automatic<br />Database Diagnostic Monitor (ADDM)</li></ul><h4>Manage Application PDBs</h4><ul><li>Explain the purpose of application root and application seed<br />Define and create application PDBs<br />Install, upgrade and Patch applications <br />Create and administer Application PDBS<br />Clone PDBs and Application containers<br />Plug and unplug operations with PDBs and application containers<br />Comparing Local Undo Mode and Shared Undo Mode</li></ul><h4>Manage Security in Multitenant databases</h4><ul><li>Manage Security in Multitenant databases<br />Manage PDB lockdown profiles<br />Audit Users in CDBs and PDBs<br />Manage other types of policies in application containers</li></ul><h4>Recovery and Flashback</h4><ul><li>Restore and Recovering Databases with RMAN<br />Perform CDB and PDB flashback</li></ul><h4>Configuring and Using RMAN</h4><ul><li>Configure RMAN and the Database for Recoverability<br />Configure and Using an RMAN recovery catalog</li></ul><h4>Diagnosing Failures</h4><ul><li>Detect and repair database and database block corruption<br />Diagnosing Database Issues</li></ul><h4>Performing Recovery</h4><ul><li>Restore and Recovering Databases with RMAN<br />Perform Non RMAN database recovery</li></ul><h4>Transporting Data</h4><ul><li>Transport Data</li></ul><h4>RMAN Troubleshooting and Tuning</h4><ul><li>Interpret the RMAN message output<br />Diagnose RMAN performance issues</li></ul><h4>Creating an Oracle Database by using DBCA</h4><ul><li>Create, Delete and Configure<br />Databases using DBCA</li></ul><h4>Oracle Restart</h4><ul><li>Configure and use Oracle Restart to manage components</li></ul><h4>Upgrade the Oracle Database</h4><ul><li>Plan for Upgrading an Oracle Database<br />Upgrade an Oracle Database<br />Perform Post-Upgrade tasks</li></ul><h4>Install Grid Infrastructure for a Standalone server</h4><ul><li>Rapid Home Provisioning</li></ul><h4>Using Availability Enhancements</h4><ul><li>Use an RMAN recovery catalog<br />Use Flashback Database</li></ul><h4>Tuning SQL Statements</h4><ul><li>Understanding the Oracle Optimizer<br />Using the SQL Tuning Advisor<br />Managing Optimizer Statistics<br />Using the SQL Access Advisor<br />Understanding the SQL Tuning Process</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle 19c Database Administration II (DBA II) (TTOR20619) 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 Oracle 19c Database Administration II (DBA II) (TTOR20619) 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>

Oracle Primavera

Oracle SQL

AWS Certified Database

Oracle 1Z0-819

Database Administration

Oracle Database

Oracle 19c Database Administration II (DBA II) (TTOR20619)

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

Microsoft SQL

Database Programming

Introduction to SQL Programming Basics (TTSQL002)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Support culture change by giving line managers the skills to look at practices within their areas, role model appropriately and address unacceptable behaviours. Our dynamic, assertive trainer for EDI has a very practical approach, with plenty of real-life examples to help participants view the subject from a new angle. A bespoke course might include:</span></p><ul style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Key legislation for EDI and the workplace</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">The consequences of getting EDI wrong</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">What you say or do and how it can be interpreted</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Direct/indirect discrimination, harassment and victimisation</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Conscious and unconscious bias</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Being an &lsquo;active bystander&rsquo;.</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Culture and EDI</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Tackling unacceptable behaviour and difficult situations.</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Practical strategies and action plans</li></ul>

Sterling Training

Equality & Diversity

Inclusion

Gender Equality

Equality

Gender Diversity

Diversity & Inclusion

Support culture change by giving line managers the skills to look at practices within their areas, role model appropriately and address unacceptable behaviours. Our dynamic, assertive trainer for EDI has a very practical approach, with plenty of real-life examples to help participants view the subject from a new angle

Equality, Diversity and Inclusion

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and who has the responsibility to achieve and improve the availability and manageability of the data centre.</p>Overview<p>After completion of the course the participant will be able to:? Choose an optimum site for mission-critical data centre based on current and future needs? Describe all components that are important for high availability in a data centre and how to effectively setup the data centre? Name and apply the various industry standards? Describe the various technologies for UPS, fire suppression, cooling, monitoring systems, cabling standards, etc, and to select and apply them effectively to cost-efficiently enhance the high-availability of the data centre.? Review the electrical distribution system to avoid costly downtime? Enhance cooling capabilities and efficiency in the data centre by using existing and new techniques and technologies for the increased cooling requirements of the future? Design a highly reliable and scalable network architecture and learn how to ensure installers apply proper testing techniques? Create effective maintenance contracts with equipment suppliers ensuring the best return on investment? Setup effective data centre monitoring ensuring the right people get the right message? Ensure proper security measures, both procedural and technical, are established to safeguard your company's valuable information in the data centre</p><p>The course will address how to setup and improve key aspects such as power, cooling, security, cabling, safety, etc., to ensure a high available data centre. It will also address key operations and maintenance aspects.</p></div><div id="course-pills-2"><h4>The Data Centre, it?s Importance and Causes for Downtime</h4><h4>Data Centre Standards and Best Practices</h4><h4>Data Centre Location, Building and Construction</h4><ul><li>Selecting appropriate sites and buildings and how to avoid pitfalls<br />Various components of an effective data centre and supporting facilities setup</li></ul><h4>Raised Floor/Suspended Ceiling</h4><ul><li>Uniform, concentrated and rolling load definitions<br />Applicable standards<br />Raised Floor guidelines<br />Signal Reference Grid, grounding of racks<br />Disability act and regulations<br />Suspended ceiling usage and requirements</li></ul><h4>Light</h4><ul><li>Standards<br />Light fixture types and placement<br />Emergency lighting, Emergency Power Supply (EPS)</li></ul><h4>Power Infrastructure</h4><ul><li>Power infrastructure layout from generation to rack level<br />ATS and STS systems<br />Redundancy levels and techniques<br />Three-phase and single-phase usage<br />Power distribution options within the computer room<br />Power cabling versus bus bar trunking<br />Bonding versus grounding<br />Common Mode Noise and isolation transformers<br />Distribution boards, form factors and IP-protection grades<br />Power quality guidelines<br />Real power versus apparent power<br />How to size and calculate load in the data centre Generators<br />Static and dynamic UPS systems, selection criteria, how they operate and energy efficiency option<br />Battery types, correct selection and testing<br />Thermo-graphics</li></ul><h4>Electro Magnetic Fields</h4><ul><li>Electrical fields and magnetic fields definitions and units of measurements<br />Sources of EMF<br />Effects of EMF on human health and equipment<br />(H)EMP<br />Standards<br />EMF shielding solutions</li></ul><h4>Equipment Racks</h4><ul><li>Rack standards, properties and selection criteria<br />Security considerations<br />Power rail/strip options</li></ul><h4>Cooling Infrastructure</h4><ul><li>Temperature and humidity recommendations<br />Cooling measurement units and conversion rates<br />Sensible and latent heat definitions<br />Differences between comfort and precision cooling<br />Overview of different air conditioner technologies<br />Raised floor versus non-raised floor cooling<br />Placement of air conditioner units and limitations to be observed<br />Supplemental cooling options<br />Cold aisle/hot aisle containment</li></ul><h4>Water Supply</h4><ul><li>Importance of water supply and application areas<br />Backup water supply techniques</li></ul><h4>Designing a Scalable Network Infrastructure</h4><ul><li>The importance of a Structured Cabling System<br />Planning considerations<br />Copper and Fiber cable technology and standards<br />ANSI/TIA-942 Cabling hierarchy and recommendations<br />Testing and verification<br />SAN storage cabling<br />Network redundancy<br />Building-to-building connectivity<br />Network monitoring system requirements</li></ul><h4>Fire Suppression</h4><ul><li>Standards for fire suppression<br />Detection systems<br />Various total flooding fire suppression techniques and systems, their benefits and disadvantages<br />Handheld extinguishers<br />Signage and safety<br />Regulatory requirements and best practices</li></ul><h4>Data Centre Monitoring</h4><ul><li>Data centre monitoring requirements<br />EMS versus BMS<br />Water leak detection systems<br />Notification options and considerations</li></ul><h4>Operational Security and Safety Practices</h4><ul><li>Data centre security layers<br />Physical, infrastructure and organisational security<br />Safety measures and essential signage</li></ul><h4>Labelling</h4><ul><li>Choosing a labelling scheme<br />Recommended labelling practices<br />Network labelling</li></ul><h4>Documentation</h4><ul><li>How to setup proper documentation<br />Document management policies and procedures</li></ul><h4>Cleaning</h4><ul><li>Cleaning practices for the data centre</li></ul><h4>MTBF/MTTR</h4><ul><li>Standards and definitions<br />Calculation models<br />The ?real? value</li></ul><h4>Maintenance Contracts/SLA/OLA</h4><h4>EXAM: Certified Data Centre Professional</h4></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Certified Data Centre Professional (CDCP) 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 Certified Data Centre Professional (CDCP) 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>

IT Certifications

Construction Design & Management (CDM)

Certified Cloud Security Professional (CCSP)

Certified in Data Protection (CDP)

Certified Cyber Professional (CCP)

Certified Data Centre Professional (CDCP)

Bromley

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly in Kent.</p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

MJ Electrical Training 

Construction Industry Scheme (CIS)

City & Guilds

Electrical Testing

Wiring Regulations

Electrical Installation

Electrical Inspection & Testing

ECS Health & Safety Course with MJ Electrical Training. Available every week, use this course to complete the application process when applying for an ECS Labourers Card. 

ECS Card Health & Safety Course Kent

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly.</p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

ECS Card Health & Safety Course Bromley

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly in Dover.</p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

ECS Card Health & Safety Course Dover

ECS Card Health & Safety Course Liverpool

ECS Card Health & Safety Course Newcastle



Bayfield Training and the University of Cambridge Department of Land Economy
This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise.
If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you.
This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses.
 Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment.


On this course you will:
Become a competent model builder, building Real Estate Financial Models from scratch
Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia
Learn how to use Real Estate Financial Models to make informed investment decisions
Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill
This course is suitable for:
Chartered Surveyors
Asset Managers
Financial Controllers
Financial Analysts
Investment Managers
Property Managers
Real Estate Students/Recent Graduates
Course Outline:
Module 1 - Economic Context
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Why Real Estate Asset Modelling is important
Understanding the occupier, asset and development markets and the relevant modelling approaches for each
Real Estate Sub-Sector Key Performance Indicators
Introduction to conventional valuations and financial mathematics
Understanding and minimising errors in Financial Models


Module 2 - Cash Flow Fundamentals
Constructing a financial model from first principles.
Understanding all the components of a basic cash flow model
Understand why Corporate Finance Models and Real Estate Models are different
Financial Model Design
Making the link between valuations, income mathematics and discounted cash flows
Internal Rate of Return, Net Present Value,Worth and other metrics
Features and techniques to aid fast model building


Module 3 - Developing the Cash Flow
Adapting financial models for different periodicities and building rent functions for different rent behaviour.
Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc.
Developing the concept of a Rent Function in Excel
Logic mathematics and Logic functions
Projecting rent to adapt to different lease contracts and growth patterns
Alternative solutions to Logic functions
Comparative analysis of lease structures in different jurisdictions and adapting financial models


Module 4 - Real Estate Data
Understanding the different sources of data, constructing basic time series models and recognising basic patterns.
Key Property market indicators
Characteristics and application of key input metrics for Real Estate Appraisals
Understanding the eight components of Real Estate Price Dynamics
Awareness of the different sources of data
Reading and using general property market reports
Constructing basic time series models and recognising basic patterns


Module 5 - Development Appraisals
Constructing a development appraisal from first principles and understanding development return metrics.
Understanding the key components of a development project
Understanding the difference between development and investment appraisals
Residual Appraisals and Profit Calculations
Cost orientated cash flows and phased sales
Cumulative construction cost patterns: incidental, fixed, loaded and S-curve
Development return metrics and Modified IRRs


Module 6 - Multi-let Cash Flows
Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions.
Multi-let and portfolio model design principles
Building complex date functions and date series
The three multi-let rent projection techniques
Perpendicular Rent Functions
Incorporate advanced rent adjustments into the Rent Function
Incorporate sector and period varying rental growth rates
Simplifying OPEX and CAPEX projections
Discounting techniques on complex and volatile cash flows


Module 7 - Project Finance
Constructing a flexible Real Estate Debt Finance model.
Revision of the Mathematics of amortisation and debt finance
Basic senior debt models and geared net cash flow
LTV, IRR and Interest Rate Dynamics
Flexible term, repayment options and deferred interest
Loan covenant tests
Understanding different tranches of debt
Understanding how complex debt structures impact the returns to different parties


Module 8 - Model Interpretation and Risk Analysis
Learn how to read, analyse and report on real estate financial models.
Understand how to read models and develop an investment narrative
Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards
Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins
Learn how to construct varied project scenarios in a systematic way
Introduction to Monte Carlo Analysis and VBA
Optimising sale dates and other parameters
Create well written, attractive and persuasive reports


Included in the Course
Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge
64 CPD Hours
1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee
Course Files
Q&A Webinars and Guest Speaker Webinars
Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers


2024 Cohort Dates Include:
3rd June to 29th July
5th August to 25th September 2024
30th September to 25th November


For more information, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Microsoft Excel

Professional Development

Continuous Professional Development (CPD)

University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for people who are seeking to launch a career in cybersecurity.</p>Overview<p>Assess the security posture of an enterprise environment and recommend and implement appropriate security solutions; Monitor and secure hybrid environments, including cloud, mobile, and IoT; Operate with an awareness of applicable laws and policies, including principles of governance, risk, and compliance; Identify, analyze, and respond to security events and incidents.</p><p>CompTIA Security+ is a global certification that validates the baseline skills necessary to perform core security functions and is the first security certification a candidate should earn.<br /> <br /> CompTIA Security+ establishes the core knowledge required of any cybersecurity role and provides a springboard to intermediate-level cybersecurity jobs.</p></div><div id="course-pills-2"><h3>Lesson 1: Summarize Fundamental Security Concepts</h3> <ul> <li>Security Concepts</li> <li>Security Controls</li> </ul> <h3>Lesson 2: Compare Threat Types</h3> <ul> <li>Threat Actors</li> <li>Attack Surfaces</li> <li>Social Engineering</li> </ul> <h3>Lesson 3: Explain Cryptographic Solutions</h3> <ul> <li>Cryptographic Algorithms</li> <li>Public Key Infrastructure</li> <li>Cryptographic Solutions</li> </ul> <h3>Lesson 4: Implement Identity and Access Management</h3> <ul> <li>Authentication</li> <li>Authorization</li> <li>Identity Management</li> </ul> <h3>Lesson 5: Secure Enterprise Network Architecture</h3> <ul> <li>Enterprise Network Architecture</li> <li>Network Security Appliances</li> <li>Secure Communications</li> </ul> <h3>Lesson 6: Secure Cloud Network Architecture</h3> <ul> <li>Cloud Infrastructure</li> <li>Embedded Systems and Zero Trust Architecture</li> </ul> <h3>Lesson 7: Explain Resiliency and Site Security Concepts</h3> <ul> <li>Asset Management</li> <li>Redundancy Strategies</li> <li>Physical Security</li> </ul> <h3>Lesson 8: Explain Vulnerability Management</h3> <ul> <li>Device and OS Vulnerabilities</li> <li>Application and Cloud Vulnerabilities</li> <li>Vulnerability Identification Methods</li> <li>Vulnerability Analysis and Remediation</li> </ul> <h3>Lesson 9: Evaluate Network Security Capabilities</h3> <ul> <li>Network Security Baselines</li> <li>Network Security Capability Enhancement</li> </ul> <h3>Lesson 10: Assess Endpoint Security Capabilities</h3> <ul> <li>Implement Endpoint Security</li> <li>Mobile Device Hardening</li> </ul> <h3>Lesson 11: Enhance Application Security Capabilities</h3> <ul> <li>Application Protocol Security Baselines</li> <li>Cloud and Web Application Security Concepts</li> </ul> <h3>Lesson 12: Explain Incident Response and Monitoring Concepts</h3> <ul> <li>Incident Response</li> <li>Digital Forensics</li> <li>Data Sources</li> <li>Alerting and Monitoring Tools</li> </ul> <h3>Lesson 13: Analyze Indicators of Malicious Activity</h3> <ul> <li>Malware Attack Indicators</li> <li>Physical and Network Attack Indicators</li> <li>Application Attack Indicators</li> </ul> <h3>Lesson 14: Summarize Security Governance Concepts</h3> <ul> <li>Policies, Standards, and Procedures</li> <li>Change Management</li> <li>Automation and Orchestration</li> </ul> <h3>Lesson 15: Explain Risk Management Processes</h3> <ul> <li>Risk Management Processes and Concepts</li> <li>Vendor Management Concepts</li> <li>Audits and Assessments</li> </ul> <h3>Lesson 16: Summarize Data Protection and Compliance Concepts</h3> <ul> <li>Data Classification and Compliance</li> <li>Personnel Policies</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Security Plus Certification (Exam SY0-601) 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 CompTIA Security Plus Certification (Exam SY0-601) 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)

CompTIA Network+

Certificate in Information Security Management Principles (CISMP)

CompTIA A+

CompTIA Security+

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITILÂ© 4 Foundation certification and who want to prepare for ITILÂ© 4 Foundation exam.</p>Overview<p>By the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITILÂ© Practices, and the new Service Value Chain that incorporate the core of ITILÂ© version 4.</p><p>ITILÂ© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITILÂ© 4.  This course will earn you 21 PDUs. <br /><br /> <b>This class includes an exam voucher. </b></p></div><div id="course-pills-2"><h3>1 - ITIL 4 OVERVIEW</h3> <ul> <li>Introduction to ITIL</li> <li>Key Concepts of ITIL</li> </ul> <h3>2 - The ITIL Framework</h3> <ul> <li>The Four Dimensions of Service Management</li> <li>The ITIL Service Value System</li> </ul> <h3>3 - The ITIL Guiding Principles</h3> <ul> <li>Focus on Value</li> <li>Start Where You Are</li> <li>Progress Iteratively with Feedback</li> <li>Collaborate and Promote Visibility</li> <li>Think and Work Holistically</li> <li>Keep It Simple and Practical</li> <li>Optimize and Automate</li> </ul> <h3>4 - THE ITIL SERVICE VALUE SYSTEM (SVS)</h3> <ul> <li>Governance</li> <li>The Service Value Chain</li> <li>Continual Improvement</li> </ul> <h3>5 - Key ITIL Practices</h3> <ul> <li>Continual Improvement</li> <li>Service Level Management</li> <li>Change Control</li> <li>Incident Management</li> <li>Service Request Management</li> <li>Service Desk</li> <li>Problem Management</li> </ul> <h3>6 - Other ITIL Practices</h3> <ul> <li>General Management Practices</li> <li>Service Management Practices</li> <li>Technical Management Practices</li> </ul></div>

IT Service Management

ITIL

IT (Information Technology)

International Trauma Life Support (ITLS)

Institute of Leadership & Management (ILM)

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The Microsoft Security Operations Analyst collaborates with organizational stakeholders to secure information technology systems for the organization. Their goal is to reduce organizational risk by rapidly remediating active attacks in the environment, advising on improvements to threat protection practices, and referring violations of organizational policies to appropriate stakeholders. Responsibilities include threat management, monitoring, and response by using a variety of security solutions across their environment. The role primarily investigates, responds to, and hunts for threats using Microsoft Sentinel, Microsoft Defender for Cloud, Microsoft 365 Defender, and third-party security products. Since the Security Operations Analyst consumes the operational output of these tools, they are also a critical stakeholder in the configuration and deployment of these technologies.</p><p></p><p></p><p>Learn how to investigate, respond to, and hunt for threats using Microsoft Sentinel, Microsoft Defender for Cloud, and Microsoft 365 Defender. In this course you will learn how to mitigate cyberthreats using these technologies. Specifically, you will configure and use Microsoft Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting. The course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.</p><p></p>Prerequisites<p></p><li>Basic understanding of Microsoft 365</li>  <li>Fundamental understanding of Microsoft security, compliance, and identity products</li>   <li> Intermediate understanding of Windows 10</li>  <li> Familiarity with Azure services, specifically Azure SQL Database and Azure Storage</li>   <li> Familiarity with Azure virtual machines and virtual networking</li>   <li>Basic understanding of scripting concepts.</li><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Microsoft 365 threat protection</h3> <ul> <li>Explore Extended Detection &amp; Response (XDR) response use cases</li> <li>Understand Microsoft Defender XDR in a Security Operations Center (SOC)</li> <li>Explore Microsoft Security Graph</li> <li>Investigate security incidents in Microsoft Defender XDR</li> </ul> <h3>2 - Mitigate incidents using Microsoft 365 Defender</h3> <ul> <li>Use the Microsoft Defender portal</li> <li>Manage incidents</li> <li>Investigate incidents</li> <li>Manage and investigate alerts</li> <li>Manage automated investigations</li> <li>Use the action center</li> <li>Explore advanced hunting</li> <li>Investigate Microsoft Entra sign-in logs</li> <li>Understand Microsoft Secure Score</li> <li>Analyze threat analytics</li> <li>Analyze reports</li> <li>Configure the Microsoft Defender portal</li> </ul> <h3>3 - Protect your identities with Microsoft Entra ID Protection</h3> <ul> <li>Microsoft Entra ID Protection overview</li> <li>Detect risks with Microsoft Entra ID Protection policies</li> <li>Investigate and remediate risks detected by Microsoft Entra ID Protection</li> </ul> <h3>4 - Remediate risks with Microsoft Defender for Office 365</h3> <ul> <li>Automate, investigate, and remediate</li> <li>Configure, protect, and detect</li> <li>Simulate attacks</li> </ul> <h3>5 - Safeguard your environment with Microsoft Defender for Identity</h3> <ul> <li>Configure Microsoft Defender for Identity sensors</li> <li>Review compromised accounts or data</li> <li>Integrate with other Microsoft tools</li> </ul> <h3>6 - Secure your cloud apps and services with Microsoft Defender for Cloud Apps</h3> <ul> <li>Understand the Defender for Cloud Apps Framework</li> <li>Explore your cloud apps with Cloud Discovery</li> <li>Protect your data and apps with Conditional Access App Control</li> <li>Walk through discovery and access control with Microsoft Defender for Cloud Apps</li> <li>Classify and protect sensitive information</li> <li>Detect Threats</li> </ul> <h3>7 - Respond to data loss prevention alerts using Microsoft 365</h3> <ul> <li>Describe data loss prevention alerts</li> <li>Investigate data loss prevention alerts in Microsoft Purview</li> <li>Investigate data loss prevention alerts in Microsoft Defender for Cloud Apps</li> </ul> <h3>8 - Manage insider risk in Microsoft Purview</h3> <ul> <li>Insider risk management overview</li> <li>Create and manage insider risk policies</li> <li>Investigate insider risk alerts</li> <li>Take action on insider risk alerts through cases</li> <li>Manage insider risk management forensic evidence</li> <li>Create insider risk management notice templates</li> </ul> <h3>9 - Investigate threats by using audit features in Microsoft Defender XDR and Microsoft Purview Standard</h3> <ul> <li>Explore Microsoft Purview Audit solutions</li> <li>Implement Microsoft Purview Audit (Standard)</li> <li>Start recording activity in the Unified Audit Log</li> <li>Search the Unified Audit Log (UAL)</li> <li>Export, configure, and view audit log records</li> <li>Use audit log searching to investigate common support issues</li> </ul> <h3>10 - Investigate threats using audit in Microsoft Defender XDR and Microsoft Purview (Premium)</h3> <ul> <li>Explore Microsoft Purview Audit (Premium)</li> <li>Implement Microsoft Purview Audit (Premium)</li> <li>Manage audit log retention policies</li> <li>Investigate compromised email accounts using Purview Audit (Premium)</li> </ul> <h3>11 - Investigate threats with Content search in Microsoft Purview</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Create a content search</li> <li>View the search results and statistics</li> <li>Export the search results and search report</li> <li>Configure search permissions filtering</li> <li>Search for and delete email messages</li> </ul> <h3>12 - Protect against threats with Microsoft Defender for Endpoint</h3> <ul> <li>Practice security administration</li> <li>Hunt threats within your network</li> </ul> <h3>13 - Deploy the Microsoft Defender for Endpoint environment</h3> <ul> <li>Create your environment</li> <li>Understand operating systems compatibility and features</li> <li>Onboard devices</li> <li>Manage access</li> <li>Create and manage roles for role-based access control</li> <li>Configure device groups</li> <li>Configure environment advanced features</li> </ul> <h3>14 - Implement Windows security enhancements with Microsoft Defender for Endpoint</h3> <ul> <li>Understand attack surface reduction</li> <li>Enable attack surface reduction rules</li> </ul> <h3>15 - Perform device investigations in Microsoft Defender for Endpoint</h3> <ul> <li>Use the device inventory list</li> <li>Investigate the device</li> <li>Use behavioral blocking</li> <li>Detect devices with device discovery</li> </ul> <h3>16 - Perform actions on a device using Microsoft Defender for Endpoint</h3> <ul> <li>Explain device actions</li> <li>Run Microsoft Defender antivirus scan on devices</li> <li>Collect investigation package from devices</li> <li>Initiate live response session</li> </ul> <h3>17 - Perform evidence and entities investigations using Microsoft Defender for Endpoint</h3> <ul> <li>Investigate a file</li> <li>Investigate a user account</li> <li>Investigate an IP address</li> <li>Investigate a domain</li> </ul> <h3>18 - Configure and manage automation using Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Manage automation upload and folder settings</li> <li>Configure automated investigation and remediation capabilities</li> <li>Block at risk devices</li> </ul> <h3>19 - Configure for alerts and detections in Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Configure alert notifications</li> <li>Manage alert suppression</li> <li>Manage indicators</li> </ul> <h3>20 - Utilize Vulnerability Management in Microsoft Defender for Endpoint</h3> <ul> <li>Understand vulnerability management</li> <li>Explore vulnerabilities on your devices</li> <li>Manage remediation</li> </ul> <h3>21 - Plan for cloud workload protections using Microsoft Defender for Cloud</h3> <ul> <li>Explain Microsoft Defender for Cloud</li> <li>Describe Microsoft Defender for Cloud workload protections</li> <li>Enable Microsoft Defender for Cloud</li> </ul> <h3>22 - Connect Azure assets to Microsoft Defender for Cloud</h3> <ul> <li>Explore and manage your resources with asset inventory</li> <li>Configure auto provisioning</li> <li>Manual log analytics agent provisioning</li> </ul> <h3>23 - Connect non-Azure resources to Microsoft Defender for Cloud</h3> <ul> <li>Protect non-Azure resources</li> <li>Connect non-Azure machines</li> <li>Connect your AWS accounts</li> <li>Connect your GCP accounts</li> </ul> <h3>24 - Manage your cloud security posture management?</h3> <ul> <li>Explore Secure Score</li> <li>Explore Recommendations</li> <li>Measure and enforce regulatory compliance</li> <li>Understand Workbooks</li> </ul> <h3>25 - Explain cloud workload protections in Microsoft Defender for Cloud</h3> <ul> <li>Understand Microsoft Defender for servers</li> <li>Understand Microsoft Defender for App Service</li> <li>Understand Microsoft Defender for Storage</li> <li>Understand Microsoft Defender for SQL</li> <li>Understand Microsoft Defender for open-source databases</li> <li>Understand Microsoft Defender for Key Vault</li> <li>Understand Microsoft Defender for Resource Manager</li> <li>Understand Microsoft Defender for DNS</li> <li>Understand Microsoft Defender for Containers</li> <li>Understand Microsoft Defender additional protections</li> </ul> <h3>26 - Remediate security alerts using Microsoft Defender for Cloud</h3> <ul> <li>Understand security alerts</li> <li>Remediate alerts and automate responses</li> <li>Suppress alerts from Defender for Cloud</li> <li>Generate threat intelligence reports</li> <li>Respond to alerts from Azure resources</li> </ul> <h3>27 - Construct KQL statements for Microsoft Sentinel</h3> <ul> <li>Understand the Kusto Query Language statement structure</li> <li>Use the search operator</li> <li>Use the where operator</li> <li>Use the let statement</li> <li>Use the extend operator</li> <li>Use the order by operator</li> <li>Use the project operators</li> </ul> <h3>28 - Analyze query results using KQL</h3> <ul> <li>Use the summarize operator</li> <li>Use the summarize operator to filter results</li> <li>Use the summarize operator to prepare data</li> <li>Use the render operator to create visualizations</li> </ul> <h3>29 - Build multi-table statements using KQL</h3> <ul> <li>Use the union operator</li> <li>Use the join operator</li> </ul> <h3>30 - Work with data in Microsoft Sentinel using Kusto Query Language</h3> <ul> <li>Extract data from unstructured string fields</li> <li>Extract data from structured string data</li> <li>Integrate external data</li> <li>Create parsers with functions</li> </ul> <h3>31 - Introduction to Microsoft Sentinel</h3> <ul> <li>What is Microsoft Sentinel?</li> <li>How Microsoft Sentinel works</li> <li>When to use Microsoft Sentinel</li> </ul> <h3>32 - Create and manage Microsoft Sentinel workspaces</h3> <ul> <li>Plan for the Microsoft Sentinel workspace</li> <li>Create a Microsoft Sentinel workspace</li> <li>Manage workspaces across tenants using Azure Lighthouse</li> <li>Understand Microsoft Sentinel permissions and roles</li> <li>Manage Microsoft Sentinel settings</li> <li>Configure logs</li> </ul> <h3>33 - Query logs in Microsoft Sentinel</h3> <ul> <li>Query logs in the logs page</li> <li>Understand Microsoft Sentinel tables</li> <li>Understand common tables</li> <li>Understand Microsoft Defender XDR tables</li> </ul> <h3>34 - Use watchlists in Microsoft Sentinel</h3> <ul> <li>Plan for watchlists</li> <li>Create a watchlist</li> <li>Manage watchlists</li> </ul> <h3>35 - Utilize threat intelligence in Microsoft Sentinel</h3> <ul> <li>Define threat intelligence</li> <li>Manage your threat indicators</li> <li>View your threat indicators with KQL</li> </ul> <h3>36 - Connect data to Microsoft Sentinel using data connectors</h3> <ul> <li>Ingest log data with data connectors</li> <li>Understand data connector providers</li> <li>View connected hosts</li> </ul> <h3>37 - Connect Microsoft services to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft services connectors</li> <li>Connect the Microsoft Office 365 connector</li> <li>Connect the Microsoft Entra connector</li> <li>Connect the Microsoft Entra ID Protection connector</li> <li>Connect the Azure Activity connector</li> </ul> <h3>38 - Connect Microsoft Defender XDR to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft Defender XDR connectors</li> <li>Connect the Microsoft Defender XDR connector</li> <li>Connect Microsoft Defender for Cloud connector</li> <li>Connect Microsoft Defender for IoT</li> <li>Connect Microsoft Defender legacy connectors</li> </ul> <h3>39 - Connect Windows hosts to Microsoft Sentinel</h3> <ul> <li>Plan for Windows hosts security events connector</li> <li>Connect using the Windows Security Events via AMA Connector</li> <li>Connect using the Security Events via Legacy Agent Connector</li> <li>Collect Sysmon event logs</li> </ul> <h3>40 - Connect Common Event Format logs to Microsoft Sentinel</h3> <ul> <li>Plan for Common Event Format connector</li> <li>Connect your external solution using the Common Event Format connector</li> </ul> <h3>41 - Connect syslog data sources to Microsoft Sentinel</h3> <ul> <li>Plan for syslog data collection</li> <li>Collect data from Linux-based sources using syslog</li> <li>Configure the Data Collection Rule for Syslog Data Sources</li> <li>Parse syslog data with KQL</li> </ul> <h3>42 - Connect threat indicators to Microsoft Sentinel</h3> <ul> <li>Plan for threat intelligence connectors</li> <li>Connect the threat intelligence TAXII connector</li> <li>Connect the threat intelligence platforms connector</li> <li>View your threat indicators with KQL</li> </ul> <h3>43 - Threat detection with Microsoft Sentinel analytics</h3> <ul> <li>What is Microsoft Sentinel Analytics?</li> <li>Types of analytics rules</li> <li>Create an analytics rule from templates</li> <li>Create an analytics rule from wizard</li> <li>Manage analytics rules</li> </ul> <h3>44 - Automation in Microsoft Sentinel</h3> <ul> <li>Understand automation options</li> <li>Create automation rules</li> </ul> <h3>45 - Threat response with Microsoft Sentinel playbooks</h3> <ul> <li>What are Microsoft Sentinel playbooks?</li> <li>Trigger a playbook in real-time</li> <li>Run playbooks on demand</li> </ul> <h3>46 - Security incident management in Microsoft Sentinel</h3> <ul> <li>Understand incidents</li> <li>Incident evidence and entities</li> <li>Incident management</li> </ul> <h3>47 - Identify threats with Behavioral Analytics</h3> <ul> <li>Understand behavioral analytics</li> <li>Explore entities</li> <li>Display entity behavior information</li> <li>Use Anomaly detection analytical rule templates</li> </ul> <h3>48 - Data normalization in Microsoft Sentinel</h3> <ul> <li>Understand data normalization</li> <li>Use ASIM Parsers</li> <li>Understand parameterized KQL functions</li> <li>Create an ASIM Parser</li> <li>Configure Azure Monitor Data Collection Rules</li> </ul> <h3>49 - Query, visualize, and monitor data in Microsoft Sentinel</h3> <ul> <li>Monitor and visualize data</li> <li>Query data using Kusto Query Language</li> <li>Use default Microsoft Sentinel Workbooks</li> <li>Create a new Microsoft Sentinel Workbook</li> </ul> <h3>50 - Manage content in Microsoft Sentinel</h3> <ul> <li>Use solutions from the content hub</li> <li>Use repositories for deployment</li> </ul> <h3>51 - Explain threat hunting concepts in Microsoft Sentinel</h3> <ul> <li>Understand cybersecurity threat hunts</li> <li>Develop a hypothesis</li> <li>Explore MITRE ATT&amp;CK</li> </ul> <h3>52 - Threat hunting with Microsoft Sentinel</h3> <ul> <li>Explore creation and management of threat-hunting queries</li> <li>Save key findings with bookmarks</li> <li>Observe threats over time with livestream</li> </ul> <h3>53 - Use Search jobs in Microsoft Sentinel</h3> <ul> <li>Hunt with a Search Job</li> <li>Restore historical data</li> </ul> <h3>54 - Hunt for threats using notebooks in Microsoft Sentinel</h3> <ul> <li>Access Azure Sentinel data with external tools</li> <li>Hunt with notebooks</li> <li>Create a notebook</li> <li>Explore notebook code</li> </ul></div>

29123 Courses

CCNSG Safety Passport National

By Vp ESS Training

Tableau Advanced v10.3

By Nexus Human

Advanced Tableau

By Nexus Human

Health & Safety Awareness

By Prima Cura Training

AAT Qualification

By Osborne Training

Cisco SD-WAN Cloud (SDWAN-CLD-CT)

By Nexus Human

First Aid at Work (FAAW):

By Total Compliance

Oracle 19c Database Administration II (DBA II) (TTOR20619)

By Nexus Human

Introduction to SQL Programming Basics (TTSQL002)

By Nexus Human

Equality, Diversity and Inclusion

By Sterling Training

Search By Location