<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p><p>In this 3 day customized Intermediate SQL course students will learn additional commands and functions using labs/activities/content that correlates with this content. By understanding SQL, you get the knowledge of fundamental queries associated with data management so that you can verify, monitor, and control all the activities operating in the database.</p></div><div id="course-pills-2"><h4>Lesson 1</h4><ul><li>Substring</li><li>Instr / CharIndex</li><li>Convert (data types and with Formatting) </li><li>Replace</li><li>RowCount / RowNum / Top )n) Ã¿(Oracle/SQL Server functions)</li><li>Case / If Then Else statements</li><li>Exists Clause </li><li>Find Duplicates using Group by and have clause (and other tips for analyzing data)</li></ul><h4>Lesson 2</h4><ul><li>Set operations (UNION, UNION ALL, INTERSECT, MINUS)</li><li>GROUP BY extensions (ROLLUP, CUBE, and GROUPING SETS)</li><li>Loops / Cursors</li><li>Common Table Expressions (CTEs)</li></ul><h4>Lesson 3</h4><ul><li>Temp Tables / Views</li><li>Advanced Subqueries</li><li>Regular Expressions (RegEx)</li><li>Linked Server Queries</li><li>Qualified subquery predicates</li><li>Aggregate functions</li><li>Optimizing queries</li><li>SQL Injection</li></ul><h4>Lesson 4</h4><ul><li>JSON Parsing</li><li>With</li><li>Partition By With Over</li><li>Fuzzy Logic - MDS.mdq.[Similarity]Ã¿</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Intermediate SQL Custom 3-Day Private Class Outline 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 Intermediate SQL Custom 3-Day Private Class Outline 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

Online Course Creation

Sup Instructor

Trainers Course

Microsoft AZ-303

Intermediate SQL Custom 3-Day Private Class Outline

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>System administrators and security operations personnel, including analysts and managers</p>Overview<p>By the end of the course, you should be able to meet the following objectives:<br />Describe the components and capabilities of the Carbon Black EDR server<br />Identify the architecture and data flows for Carbon Black EDR communication<br />Identify the architecture for a cluster configuration and Carbon Black EDR cluster communication<br />Describe the Carbon Black EDR server data types and data locations<br />Use the API to interact with the Carbon Black EDR server without using the UI<br />Create custom threat feeds for use in the Carbon Black EDR server<br />Perform the integration with a syslog server<br />Use different server-side scripts for troubleshooting<br />Troubleshoot sensor-side configurations and communication</p><p>This course teaches you how to use the advanced features of the VMware Carbon BlackÂ© EDR? product. This usage includes gaining access to the Linux server for management and troubleshooting in addition to configuring integrations and using the API. This course provides an in-depth, technical understanding of the Carbon Black EDR product through comprehensive coursework and hands-on scenario-based labs. This class focuses exclusively on advanced technical topics related to the technical back-end configuration and maintenance</p></div><div id="course-pills-2"><h4>Course Introduction</h4><ul><li>Introductions and course logistics</li><li>Course objectives</li><li></li></ul><h4>Architecture</h4><ul><li>Data flows and channels</li><li>Sizing considerations</li><li>Communication channels and ports</li></ul><h4>Server Datastores</h4><ul><li>SOLR database</li><li>Storage configurations and data aging</li><li>Partition states </li><li>Postgres</li><li>Modulestore</li></ul><h4>EDR API</h4><ul><li>CBAPI overview</li><li>Viewing API calls in the browser</li><li>Utilizing the API to access data</li><li></li></ul><h4>Threat Intelligence Feeds</h4><ul><li>Feed structure</li><li>Report indicator types</li><li>Custom threat feed creation and addition</li></ul><h4>Syslog Integration</h4><ul><li>SIEM support</li><li>Configuration</li></ul><h4>Troubleshooting</h4><ul><li>Server-side scripts</li><li>Server logs</li><li>Sensor operations</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br />Notes<p>Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC)</p><p>Nexus Humans VMware Carbon Black EDR Advanced Administrator 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 VMware Carbon Black EDR Advanced Administrator 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>

VMware Vsphere

IT Certifications

AWS Certified Developer

Microsoft Virtual Academy (MVA)

Certified Ethical Hacker (CEH)

VMware Carbon Black EDR Advanced Administrator

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Developed for IT Professionals interested in learning how to manage Citrix Endpoint Management on-premises or cloud environments using leading practices. Potential students include Administrators and Implementers.</p>Overview<p>How to manage a Citrix Endpoint Management implementation in a On-premises or cloud environment How to perform common enterprise mobility management tasks and mobile application managementUnderstand the device enrollment processHow to perform monitoring, troubleshooting, and reporting on a Citrix Endpoint Management Enterprise solution</p><p>Students will explore how to manage Citrix Endpoint Management in this course. Venture into the cloud as students learn to manage devices, apps, and users. Students will learn how the architecture, management, and communication flow function with Citrix Endpoint Management Service and how they can fit their organization?s needs. Students will learn how to administer their Citrix Endpoint Management environment and how to support your end users, as well as working with applications and securing a variety of endpoints.</p></div><div id="course-pills-2"><h4>Introduction to Citrix Endpoint Management </h4><ul><li>Citrix Endpoint Management Features</li><li>Citrix Cloud and Citrix Endpoint Management</li><li>Citrix Endpoint Management User Experience and Security</li><li>Citrix Endpoint Management Entitlements </li></ul><h4>Citrix Endpoint Management  Architecture</h4><ul><li>Citrix Endpoint Management Prerequisites</li><li>Citrix Endpoint Management Server</li><li>Citrix Endpoint Management and Microsoft Intune</li><li>Apple APNs and Google Firebase Cloud Messaging</li><li>MDX Architecture and Features </li></ul><h4>Cloud Components </h4><ul><li>Cloud Component Overview</li><li>Onboarding and Access</li><li>Cloud Connector and Cloud Resource Locations</li><li>Cloud Migration</li><li>Cloud Updates and Features</li></ul><h4>Common Device Management Tasks  </h4><ul><li>Administrative Console Overview</li><li>Delivery Groups</li><li>Device Policies </li></ul><h4>Device Enrollment </h4><ul><li>Enrollment Methods</li><li>iOS Device Enrollment</li><li>Android Device Enrollment</li><li>Windows 10 Enrollment</li><li>Other Devices </li></ul><h4>Managing Device Security </h4><ul><li>Security Policies</li><li>Automated Actions</li><li>Android for Work</li><li>ActiveSync Filtering</li><li>Shared Devices</li></ul><h4>Working with Apps </h4><ul><li>Application Integration</li><li>Citrix Endpoint Management Productivity Apps</li><li>Application Security with MDX</li><li>3rd Part Applications</li></ul><h4>Integrating Citrix Content Collaboration </h4><ul><li>Citrix Content Collaboration Overview</li><li>Integrating Citrix Endpoint Management with Content Collaboration</li><li>Content Collaboration Workflows </li></ul><h4>Maintaining and Troubleshooting  </h4><ul><li>Maintaining Citrix Endpoint Management</li><li>Maintaining Certificates</li><li>Troubleshooting Citrix Gateway (formerly NetScaler Gateway)</li><li>Troubleshooting Tools for Citrix Productivity Apps</li><li>Firewall Issues</li></ul><h4>Monitoring and Reporting  </h4><ul><li>Monitoring and Reporting of Devices</li><li>Monitoring and Reporting of Citrix Content Collaboration  </li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CEM-205 Manage Citrix Endpoint Management 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 CEM-205 Manage Citrix Endpoint Management 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 Energy Manager (CEM)

Certificate in Information Security Management Principles (CISMP)

Commercial & Contract Management Certification Program (CCM)

Cisco Certified Entry Networking Technician (CCENT)

Microsoft Certified Trainer (MCT)

Citrix

CEM-205 Manage Citrix Endpoint Management

<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 IBM Integration Bus administrators and developers who administer IBM Integration Bus.</p>Overview<p>After completing this course, you should be able to:Install and configure an IBM Integration Bus instanceEstablish, maintain, and manage an integration nodeAdminister IBM Integration Bus components and message flow applications by using the IBM Integration web user interface and command interfaceConfigure connectivity to IBM MQ to enable IBM Integration Bus to get messages from, or put messages to, queues on a local or remote queue managerImplement IBM Integration Bus administration and message flow securityUse problem determination aids to diagnose and solve development and runtime errorsUse the IBM Integration web user interface to generate and display message flow statisticsUse IBM MQ or MQTT to publish and subscribe to IBM Integration Bus topicsImplement an IBM Integration Bus global cache to store, reuse, and share data between integration nodesUse workload management policies to adjust the processing speed of messages and control the actions that are taken on unresponsive flows and threadsUse the IBM Integration web user interface and a database to record events and replay messagesEnable an integration node to connect to a database with ODBC and JDBCConfigure a Java Message Services (JMS) provider for use with the JMS nodesConfigure IBM Integration Bus for the secure file transfer protocol (SFTP)Find and install IBM Integration Bus SupportPac components</p><p>In this course, students learn how to administer IBM Integration Bus on distributed operating systems, such as Windows and AIX, by using the IBM Integration Bus administrative interfaces.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>Course introduction</li><li>IBM Integration Bus overview</li><li>Product installation, configuration, and security planning</li><li>Exercise: Integration node setup and customization</li><li>Connecting to IBM MQ</li><li>Exercise: Connecting to IBM MQ</li><li>Administration in the IBM Integration Toolkit</li><li>Exercise: Using the IBM Integration Toolkit</li><li>Administration basics</li><li>Exercise: Administering the IBM Integration Bus runtime components</li><li>Implementing IBM Integration Bus administration security</li><li>Exercise: Using file-based security to control administration access</li><li>Exercise: Using queue-based security to control administration access</li><li>Implementing IBM Integration Bus message flow security</li><li>Administering web services and web service security</li><li>Exercise: Implementing web services and web services security</li><li>Diagnosing problems</li><li>Exercise: Using problem diagnosis tools</li><li>Exercise: Identifying runtime problems</li><li>Monitoring the integration node and message flow performance</li><li>Publish/subscribe implementation overview</li><li>Exercise: Viewing runtime statistics</li><li>Configuring IBM Integration Bus for high availability</li><li>Exercise: Administering workload management policies</li><li>Monitoring, recording, and replaying message flow events</li><li>Exercise: Recording and replaying message flow data</li><li>Extending IBM Integration Bus</li><li>Course summary</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans WM646 IBM Integration Bus V10 System Administration 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 WM646 IBM Integration Bus V10 System Administration 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>

International Business Management

IBM MQ

Manager Training

WM646 IBM Integration Bus V10 System Administration

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is designed for security administrators and Check Point resellers who need to manage and monitor issues that may occur within their Security Management environment.</p>Overview<p>Understand how to use Check Point resources for support.<br />Understand how to perform packet captures using tcmdump and FW Monitor command tools.<br />Understand the basic process of kernel debugging, and how debug commands are structured.<br />Recognize how to use various Linux commands for troubleshooting system issues.<br />Recognize communication issues that may occur between SmartConsole and the SMS and how to resolve them.<br />Understand how to troubleshoot SmartConsole login and authentication issues.<br />Understand how to prevent and resolve licensing and contract issues.<br />Understand how to troubleshoot issues that may occur during policy installation.<br />Understand communication issues that may occur when collecting logs and how to resolve them.<br />Recall various tools to use when analyzing issues with logs.<br />Understand how to restore interrupted communications during heavy logging.<br />Understand how NAT works and how to troubleshoot issues.<br />Understand Client Side and Server Side NAT.<br />Understand how the Access Control Policy functions and how the access control applications work together.<br />Understand how to troubleshoot issues that may occur with Application Control and URL Filtering.<br />Understand how the HTTPS Inspection process works and how to resolve issues that may occur during the process.<br />Understand how to troubleshoot Content Awareness issues.<br />Recognize how to troubleshoot VPN-related issues.<br />Understand how to monitor cluster status and work with critical devices.<br />Recognize how to troubleshoot State Synchronization.<br />Understand how to troubleshoot communication issues between Identity Sources and Security Gateways.<br />Understand how to troubleshoot and debug issues with internal Identity Awareness processes.</p><p>The goal of this course is to provide an understanding of the concepts and skills necessary to troubleshoot issues which may occur when managing the Check Point Security Management architecture and Security Gateways.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>An Introduction to Troubleshooting</li><li>SmartConsole and Policy Management Troubleshooting</li><li>Monitoring Logging Activity</li><li>Troubleshooting Issues with NAT</li><li>Understanding the Unified Access Control Policy</li><li>Basic VPN Troubleshooting</li><li>Monitoring ClusterXL Connections</li><li>Understanding Identity Awareness</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CCTA Check Point Troubleshooting Administration 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 CCTA Check Point Troubleshooting Administration 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 Technology Specialist (CTS)

Certificate in Teaching Program (CTP)

Certificate of Completion of Training (CCT)

CompTIA Network+

CompTIA Security+

CCTA Check Point Troubleshooting Administration

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators.</p>Overview<p>Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language.  They will learn the syntax, structure and features of the language.</p><p>In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c.</p></div><div id="course-pills-2"><h4>Selection &amp; Setup of the Database Interface</h4><ul><li>Considering Available Tools</li><li>Selecting the Appropriate Tool</li><li>Oracle Net Database Connections</li><li>Oracle PAAS Database Connections</li><li>Setup SQL Developer</li><li>Setup SQL*Plus</li><li>Setup Jdeveloper</li></ul><h4>About Bind &amp; Substitution Variables</h4><ul><li>Using SQL Developer</li><li>Using SQL*Plus</li></ul><h4>Choosing a Database Programming Language</h4><ul><li>What is Database Programming?</li><li>PL?SQL Performance Advantages</li><li>Integration wth Other Languages</li></ul><h4>PL/SQL Language Fundamentals</h4><ul><li>PL/SQL Program Structure</li><li>LANGUAGE SYNTAX RULES </li><li>EMBEDDING SQL</li><li>WRITING READABLE CODE </li><li>GENERATING DATABASE OUTPUT </li><li>SQL*PLUS INPUT OF A PROGRAM BLOCK</li></ul><h4>Declare Section</h4><ul><li>About the Declare Section</li><li>DECLARE PRIMITIVE TYPES </li><li>DECLARATION OPTIONS </li><li>NOT NULL </li><li>CONSTANT</li><li>DATA DICTIONARY INTEGRATION </li><li>%TYPE</li><li>DECLARE SIMPLE USER---DEFINED TYPES</li><li>TYPE... TABLE </li><li>TYPE... RECORD </li><li>EXTENDED USER---DEFINED TYPES</li></ul><h4>Begin Section</h4><ul><li>About the Begin Section</li><li>Manipulating Program Data</li><li>Logic Control &amp; Branching</li><li>GOTO</li><li>LOOP</li><li>IF-THEN-ELSE</li><li>CASE</li></ul><h4>Exception Section</h4><ul><li>ABOUT THE EXCEPTION SECTION</li><li>ISOLATING THE SPECIFIC EXCEPTION</li><li>PRAGMA EXCEPTION_INIT </li><li>SQLCODE &amp;SQLERRM Example </li><li>SQL%ROWCOUNT &amp;SELECT...INTO</li></ul><h4>Beyond the Basics: Explicit Cursors</h4><ul><li>ABOUT EXPLICIT CURSORS</li><li>EXTENDED CURSOR TECHNIQUES </li><li>FOR UPDATE OF Clause </li><li>WHERE CURRENT OF Clause </li><li>Using FOR?LOOP Cursors</li></ul><h4>Beyond the Basics: Nested Blocks</h4><h4>Beyond the Basics: Declared Subprograms</h4><ul><li>USING DECLARED SUBPROGRAMS</li><li>DECLARED PROCEDURE</li><li>DECLARED FUNCTION</li></ul><h4>Introducing Databse-Resident Program Units</h4><ul><li>ABOUT DATABASE---RESIDENT PROGRAMS</li><li>PHYSICAL STORAGE &amp; EXECUTION </li><li>TYPES OF STORED PROGRAM UNITS</li><li>STORED PROGRAM UNIT ADVANTAGES</li><li>MODULAR DESIGN PRINCIPLES</li></ul><h4>Creating Stored Procedures &amp; Functions</h4><ul><li>STORED PROCEDURES &amp; FUNCTIONS</li><li>CREATE PROCEDURE / CREATE FUNCTION </li><li>CREATING PROCEDURES &amp; FUNCTIONS </li><li>RAISE_SALARY() Procedure </li><li>SALARY_VALID() Function </li><li>THE PARAMETER SPECIFICATION</li><li>DEFAULT Clause </li><li>SYSTEM &amp; OBJECT PRIVILEGES </li><li>USING THE DEVELOPMENT TOOLS</li></ul><h4>Executing Stored Procedures &amp; Functions</h4><ul><li>CALLING PROCEDURES &amp; FUNCTIONS</li><li>UNIT TESTING WITH EXECUTE</li><li>ANONYMOUS BLOCK UNIT TESTING</li><li>SPECIFYING A PARAMETER NOTATION</li><li>SQL WORKSHEET UNIT TESTING</li><li>CALLING FUNCTIONS FROM SQL</li></ul><h4>Maintaining Stored Program Units</h4><ul><li>RECOMPILING PROGRAMS</li><li>Mass Recompilation Using UTL_RECOMP()</li><li>DROPPING PROCEDURES &amp; FUNCTIONS</li><li>DROP PROCEDURE / FUNCTION</li><li>DATA DICTIONARY METADATA </li><li>Using USER_OBJECTS </li><li>Using USER_SOURCE </li><li>Using USER_ERRORS </li><li>Using USER_OBJECT_SIZE </li><li>Using USER_DEPENDENCIES</li></ul><h4>Managing Dependencies</h4><ul><li>DEPENDENCY INTERNALS</li><li>TRACKING DEPENDENCIES</li><li>THE DEPENDENCY TRACKING UTILITY</li><li>SQL DEVELOPER DEPENDENCY INFO</li><li>DEPENDENCY STRATEGY CHECKLISTS</li></ul><h4>Creating &amp; Maintaining Packages</h4><ul><li>ABOUT PACKAGES</li><li>CREATING PACKAGES</li><li>MAINTAINING PACKAGES</li><li>PERFORMANCE CONSIDERATIONS</li></ul><h4>Advanced Package Capabilities</h4><ul><li>DEFINER &amp; INVOKER RIGHTS</li><li>WHITE LITS &amp; ACCESSIBLE BY</li><li>PERSISTENT GLOBAL OBJECTS</li><li>DEFINING INITIALIZATION LOGIC</li><li>OBJECT ORIENTATION SUPPORT</li></ul><h4>Advanced Cursor Techniques</h4><ul><li>USING CUSROS VARIABLES</li><li>USING SYS_REFCURSOR</li><li>USING CURSOR EXPRESSIONS</li></ul><h4>Using System-Supplied Package</h4><ul><li>DBMS_OUTPUT()</li><li>UTL_FILE()</li><li>FOPEN() EXAMPLE</li></ul><h4>Database Trigger Concepts</h4><ul><li>ABOUT DATABASE TRIGGERS</li><li>DML EVENT TRIGGER SUB---TYPES</li><li>DATABASE TRIGGER SCENARIO</li><li>TRIGGER EXECUTION MECHANISMS </li><li>TRIGGERS WITHIN SQL WORKSHEET</li></ul><h4>Creating Database Triggers</h4><ul><li>STATEMENT-LEVEL TRIGGERS</li><li>Using RAISE_APPLICATION_ERROR() </li><li>ROW---LEVEL TRIGGERS</li><li>EXAMPLES OF TRIGGERS </li><li>EMPLOYEE_SALARY_CHECK Example </li><li>EMPLOYEE_JOURNAL Example </li><li>BUDGET_EVENT Example </li><li>INSTEAD OF TRIGGERS</li><li>TRIGGERS WITHIN AN APPLICATION</li></ul><h4>Maintaining Database Triggers</h4><ul><li>CALL SYNTAX</li><li>TRIGGER MAINTENANCE TASKS </li><li>SHOW ERRORS TRIGGER </li><li>DROP TRIGGER</li><li>ALTER TRIGGER</li><li>MULTIPLE TRIGGERS FOR A TABLE </li><li>HANDLING MUTATING TABLE ISSUES</li></ul><h4>Implementing System Event Triggers</h4><ul><li>WHAT ARE SYSTEM EVENT TRIGGERS?</li><li>DEFININGTHE SCOPE</li><li>AVAILABLE SYSTEM EVENTS</li><li>SYSTEM EVENT ATTRIBUTES</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle 12c PL/SQL Fundamentals 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 12c PL/SQL Fundamentals 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>

Programming Fundamentals

Oracle SQL

Database Programming

Oracle

Oracle 1Z0-819

Oracle Database

Oracle 12c PL/SQL Fundamentals

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Security operations personnel, including analysts and incident responders</p>Overview<p>By the end of the course, you should be able to meet the following objectives:<br />Utilize Carbon Black EDR throughout an incident Implement a baseline configuration for Carbon Black EDR Determine if an alert is a true or false positive Fully scope out an attack from moment of compromise Describe Carbon Black EDR capabilities available to respond to an incident Create addition detection controls to increase security</p><p>This course teaches you how to use the VMware Carbon BlackÂ© EDR? product during incident response. Using the SANS PICERL framework, you will configure the server and perform an investigation on a possible incident. This course provides guidance on using Carbon Black EDR capabilities throughout an incident with an in-depth, hands-on, scenariobased lab.</p></div><div id="course-pills-2"><h4>Course Introduction</h4><ul><li>Introductions and course logistics</li><li>Course objectives</li></ul><h4>VMware Carbon Black EDR &amp; Incident Response</h4><ul><li>Framework identification and process</li></ul><h4>Preparation</h4><ul><li>Implement the Carbon Black EDR instance according to organizational requirements</li></ul><h4>Identification</h4><ul><li>Use initial detection mechanisms</li><li>Process alerts</li><li>Proactive threat hunting</li><li>Incident determination</li></ul><h4>Containment</h4><ul><li>Incident scoping</li><li>Artifact collection</li><li>Investigation </li></ul><h4>Eradication</h4><ul><li>Hash banning</li><li>Removing artifacts</li><li>Continuous monitoring</li></ul><h4>Recovery</h4><ul><li>Rebuilding endpoints</li><li>Getting to a more secure state</li></ul><h4>Lessons Learned</h4><ul><li>Tuning Carbon Black EDR</li><li>Incident close out</li></ul></div>

Certificate in Emergency Response Ambulance Driving (CERAD)

Incident Response

VMware Carbon Black EDR Advanced Analyst

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This is a basic-level programming course designed for attendees with prior development experience in another language, such as COBOL, 4GL, Mainframe or other non-object oriented languages. This course is not geared for non-developers.</p>Overview<p>This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in core OO coding and Java development skills, coupling the most current, effective techniques with the soundest industry practices.  Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom.<br />Working within in a hands-on learning environment, guided by our expert team, attendees will learn to:<br />Understand what OO programming is and what the advantages of OO are in today's world<br />Work with objects, classes, and OO implementations<br />Understand the basic concepts of OO such as encapsulation, inheritance, polymorphism, and abstraction<br />Understand not only the fundamentals of the Java language, but also its importance, uses, strengths and weaknesses<br />Understand the basics of the Java language and how it relates to OO programming and the Object Model<br />Work with the Modular system (Project Jigsaw)<br />Understand and use classes, inheritance and polymorphism<br />Understand and use collections, generics, autoboxing, and enumerations<br />Process large amount of data using Lambda expressions and the Stream API<br />Abstract, static and private methods in interfaces<br />Take advantage of the Java tooling that is available with the programming environment being used in the class<br />Java 11 features covered: Using the Local Variable Type in Lambda expressions; Updates made to the String API</p><p>This course provides hands-on Java 11 training for developers who have little or no prior working knowledge of object-oriented programming languages such as C, COBOL, and 4GL. You will learn the best practices for writing great object-oriented programs in Java 11, using sound development techniques, new improved features for better performance, and new capabilities for addressing rapid application development. Special emphasis is placed on object oriented concepts and best practices.</p></div><div id="course-pills-2"><h4>A First Look</h4><ul><li>The Java Platform</li><li>Using the JDK</li><li>The Eclipse Paradigm</li></ul><h4>Getting Started with Java</h4><ul><li>Writing a Simple Class</li><li>Adding Methods to the Class</li></ul><h4>OO Concepts</h4><ul><li>Object-Oriented Programming</li><li>Inheritance, Abstraction, and Polymorphism</li></ul><h4>Essential Java Programming</h4><ul><li>Language Statements</li><li>Using Strings</li><li>Specializing in a Subclass</li><li>Fields and Variables</li><li>Using Arrays</li><li>Local-Variable Type Inference</li><li>Java Packages and Visibility</li></ul><h4>Object Oriented Development</h4><ul><li>Inheritance and Polymorphism</li><li>Interfaces and Abstract Classes</li><li>Introduction to Exception Handling</li><li>Exceptions</li></ul><h4>Java Developer's ToolboxÃ¿</h4><ul><li>Utility Classes</li><li>Java Date/Time</li></ul><h4>Advanced Java Programming</h4><ul><li>Introduction to Generics</li><li>Lambda Expressions and Functional Interface</li></ul><h4>Working with Collections</h4><ul><li>Collections</li><li>Using Collections</li></ul><h4>Stream APIÃ¿</h4><ul><li>Streams</li><li>Collectors</li></ul><h4>The Java Module System</h4><ul><li>Introduction to the Module System</li></ul><h4>Time Permitting</h4><ul><li>Formatting Strings</li><li>Introduction to Annotations</li><li>Java 12 and beyond</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Basic Java 11 and OO Programming for Developers New to OO (TT2120-J11) 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 Basic Java 11 and OO Programming for Developers New to OO (TT2120-J11) 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>

Java

MOOC

Object Oriented Programming (OOP)

Basic Java 11 and OO Programming for Developers New to OO (TT2120-J11)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Application Consultant<br />Business Analyst<br />Business Process Architect<br />Business Process Owner / Team Lead / Power User<br />Data Consultant / Manager<br />Help Desk / COE Support<br />Program / Project Manager<br />Solution Architect<br />System Architect<br />Technology Consultant<br />Trainer</p>Overview<p>Please refer to overview</p><p>This course will provide you with a deep understanding of the production planning process, how to configure it, and how to apply the concepts of demand management and material requirements planning in SAP S4/HANA.</p></div><div id="course-pills-2"><h4>SAP S/4HANA Production Planning Overview</h4><ul><li>Outlining Production Planning in SAP S/4HANA</li><li>Considering Prerequisites for Production Planning in SAP S/4HANA</li></ul><h4>Master Data for SAP S/4HANA Production Planning</h4><ul><li>Outlining Master Data for SAP S/4HANA Production Planning</li></ul><h4>Prerequisites and Tools for Advanced Planning in SAP S/4HANA</h4><ul><li>Outlining Advanced Planning: PP/DS in SAP S/4HANA</li><li>Reviewing Master Data for Advanced Planning</li><li>Activating Advanced Planning</li><li>Evaluating Alerts with the Alert Monitor</li><li>Planning Production with the Product View</li></ul><h4>Demand Management in SAP S/4HANA with Planning Strategies</h4><ul><li>Applying Planning Strategies for Make-to-Order Production</li><li>Applying Planning Strategies for Make-to-Stock Production</li></ul><h4>Advanced Production Planning in SAP S/4HANA</h4><ul><li>Exploring Steps in PP/DS Material Requirements Planning</li><li>Exploring Heuristics and Functions in PP/DS</li><li>Applying the PP/DS Planning Run</li></ul><h4>Detailed Scheduling in SAP S/4HANA</h4><ul><li>Exploring Concepts and Principles for Detailed Scheduling</li><li>Applying transactional Tools for Detailed Scheduling</li><li>Applying Apps for Detailed Scheduling</li><li>Using Detailed Scheduling in the Planning Run</li><li>Using the PP/DS Optimizer</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans S4220 SAP Production Planning in SAP S/4HANA 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 S4220 SAP Production Planning in SAP S/4HANA 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>

SAP Human Capital Management

SAP Materials Management

SAP Project

SAP Sales & Distribution

SAP S/4HANA

S4220 SAP Production Planning in SAP S/4HANA

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for all Oracle Professionals.  Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and  other IT Management Professionals.</p>Overview<p>Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator.  This course introduces many of the powerful capabilities of the Oracle database.</p><p>In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties.</p></div><div id="course-pills-2"><h4>Introduction: Managing the Database Instance</h4><ul><li>The Database Management Tools</li><li>EM Database Express</li><li>EM Cloud Control</li><li>SQL Developer</li><li>Database Administrator</li></ul><h4>Introduction: Database Architecture Review</h4><ul><li>Database Instance Configurations</li><li>Memory Structures</li><li>Process Structures</li><li>Storage Architecture</li></ul><h4>Introduction: Starting &amp; Stopping Databse Services</h4><ul><li>Start &amp; Stop the Database Listener</li><li>ABOUT DATABASE STARTUP/SHUTDOWN </li><li>SYSOPER </li><li>SYSDBA </li><li>DATABASE STATE &amp; STAGES </li><li>STARTUP WITH EM CLOUD CONTROL </li><li>STARTUP WITH SQL*PLUS </li><li>SHUTDOWN WITH EM CLOUD CONTROL </li><li>SHUTDOWN WITH SQL*PLUS </li><li>USING MS WINDOWS SERVICES</li></ul><h4>Introduction: Oracle Network Environment</h4><ul><li>Oracle Net Services Architecture</li><li>ORACLE NET CONFIGURATION ASSISTANT </li><li>ORACLE NET MANAGER </li><li>USING EM CLOUD CONTROL </li><li>ADVANCED NETWORK COMPRESSION </li><li>TROUBLESHOOTING NETWORK PROBLEMS</li></ul><h4>Introduction: Diagnostics &amp; Oracle Support</h4><ul><li>About Database Diagnostics</li><li>Fault Diagnosability Infrastructure</li><li>DATABASE INSTANCE HEALTH SNAPSHOT </li><li>THE SUPPORT WORKBENCH </li><li>PROACTIVE DATABASE HEALTH CHECKS </li><li>PACKAGE DIAGNOSTIC DATA </li><li>WORKING WITH THE KNOWLEDGE BASE</li></ul><h4>Storage: Tablespace Management</h4><ul><li>Starter Tablespaces</li><li>CREATE TABLESPACE WITH EM CC </li><li>CREATE TABLESPACE WITH SQL </li><li>MANAGE TABLESPACES WITH EM CC </li><li>MANAGE TABLESPACES WITH EM DE </li><li>MANAGE TABLESPACES WITH SQL </li><li>DROP TABLESPACE </li><li>ALTER TABLESPACE</li><li></li></ul><h4>Storage: Advanced Tablespace Management</h4><ul><li>Managing Temporary Tablespaces</li><li>TEMP TABLESPACE GROUPS WITH EM</li><li>TEMP TABLESPACE GROUPS WITH SQL</li><li>DEFAULT PERMANENT TABLESPACES</li><li>BIGFILE TABLESPACES</li><li>MANAGING THE SYSAUX TABLESPACE</li></ul><h4>Storage: Data Files &amp; Temp Files Management</h4><ul><li>Manage Data Files with EM</li><li>ACCESS METADATA WITH SQL</li><li>MANAGE DATA FILES WITH SQL</li><li>MANAGE TEMP FILES</li><li>ORACLE-MANAGED FILES (OMF)</li></ul><h4>Storage: UNDO Data &amp; UNDO Tablespaces</h4><ul><li>About UNDO Space Management</li><li>GUARANTEE UNDO RETENTION </li><li>MONITOR UNDO SPACE WITH SQL </li><li>USE THE EM UNDO ADVISOR</li></ul><h4>Security &amp; Schemas: Security Overview &amp; Database Privileges</h4><ul><li>Database Security Principles</li><li>DATABASE SYSTEM PRIVILEGES</li><li>DATABASE OBJECT PRIVILEGES</li><li>SUPER ADMINISTRATOR ROLES</li><li>PRIVILEGE ANALYSIS</li></ul><h4>Security &amp; Schemas: User Security</h4><ul><li>Create &amp; Manage User Accounts</li><li>MANAGE USERS WITH EM</li><li>MANAGE USERS WITH SQL</li><li>CREATE USER</li><li>ALTER USER</li><li>DROP USER</li><li>GRANT &amp; REVOKE PRIVILEGES</li><li>RESOURCE LIMITS VIA PROFILES</li><li>ALTER PROFILE</li><li>DROP PROFILE</li><li>PASSWORD MANAGEMENT VIA PROFILES</li><li>ROLE-BASED SECURITY MANAGEMENT</li><li>ALTER USER...DEFAULT ROLE</li><li>SET ROLE</li><li>DELEGATING PRIVILEGE AUTHORIZATION</li><li>WITH ADMIN OPTION &amp; System Privileges</li><li>WITH GRANT OPTION &amp; Object Privileges</li><li>PRINCIPLE OF LEAST PRIVILEGE CHECKLIST</li></ul><h4>Security &amp; Schemas: Database Auditing</h4><ul><li>Auditing Database Activity</li><li>Traditional Auditing</li><li>Unified Auditing</li><li>Create Audit Policy</li></ul><h4>Security &amp; Schemas: SQL Loader</h4><ul><li>Loader Concepts</li><li>Loader From the Command Line</li><li>control File Options</li><li>Load Methods</li><li>Loader Express Mode</li><li>Loader From EM</li></ul><h4>Security &amp; Schemas: Export &amp; Import</h4><ul><li>Manage Directory Objects</li><li>The Data Pump Architecture</li><li>Data Pump Export</li><li>Data Pump Import</li><li>Data Pump Dictionary Views</li><li>Using the EM CC Interface</li></ul><h4>Performance &amp; Availability: Managing Performance &amp; SQL Tuning</h4><ul><li>Management Advisory Framework</li><li>Performance Monitoring &amp; AWR</li><li>The SQL Tuning Advisor</li><li>Monitoring Exceptions with Metrics</li></ul><h4>Performance &amp; Availability: Data Concurrency</h4><ul><li>About System &amp; User Locks</li><li>Monitor &amp; Manage User Locks</li><li>Moitor Locks with Data Dictionary</li><li>Manage Locks with EM</li></ul><h4>Performance &amp; Availability: Backup  &amp; Recovery Concepts</h4><ul><li>Backup &amp; Recovery Structures</li><li>Managing REDO Data</li><li>Configuring for Recoverability</li><li>Instance Recovery</li><li>Recoverability Checklist</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle 12c Administration II 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 12c Administration II 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 Certified Database

Oracle Fusion HCM

Database Administration

Oracle 12c Administration II

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The primary audience for this course is any IT, facilities or data centre professional, who are involved in the design/build, renovation or relocation of a mission-critical data centre.</p>Overview<p>This 5-day course is designed to prepare participants to analyse a given business case and perform technical evaluation for a project plan and a set of designs for the implementation of a mission critical data centre.<br />The course also engages participants in product evaluations and demonstrates how to select equipment and develop equipment test scripts (IET) and integrated performance and validation testing (IPVT). CDCEÂ© builds upon knowledge gained in CDCP and CDCS courses. Participants who pass the exam will join the industry's elite data centre project design experts.<br />CDCEÂ© is the highest level training in the EPI Design and Build training track under the EPI Data Centre Training Framework. Participants must hold a valid CDCS certificate in order to be able to register for the CDCE class.</p><p>CDCEÂ© is the premier certification for data centre professionals in the data centre design/build and related fields.</p></div><div id="course-pills-2"><h4>Data Centre Life Cycle</h4><ul><li>Data centre lifecycle stages and phases<br />Exercise: Stage/Phase/Milestone/Document mapping</li></ul><h4>Design Preparation</h4><ul><li>Creation of a SON ? Statement Of Need<br />Technology review<br />Conceptual sizing<br />How to calculate for computer room space<br />How to calculate facility space<br />How to calculate incoming power<br />Exercise: Conceptual sizing building and power<br />Analysing capacity of existing facility<br />Analysing investment options<br />Site selection<br />Permits and approvals<br />Exercise: Site selection<br />Conceptual design<br />Budget and project timeline<br />Business case preparation<br />Project delivery structure<br />Project management options<br />Project manager and team</li></ul><h4>Design Planning</h4><ul><li>OSRA?Operational Systems Requirement Analysis<br />TFRA?Technical Facilities Requirement Analysis<br />Operations and maintenance review<br />RFP?Request For Proposal process<br />Vendor selection</li></ul><h4>Design Development</h4><ul><li>Project planning<br />Design development<br />PDR ? Preliminary Design Review<br />Equipment selection<br />FDR/V ? Final Design Review/Validation<br />Exercise: Full design validation of power, cooling, floor plans, fire suppression<br />Design freeze and LLTI<br />Creation of construction documents<br />BOM/BOQ ? Bill Of Material/Bill Of Quantity<br />Exercise: Equipment selection</li></ul><h4>Acquire</h4><ul><li>Requirements of purchase orders<br />Shipping terms<br />FWT/FAT ? Factory Witness Test/Factory Acceptance Test<br />Sequencing<br />Incoming goods inspection and handling<br />Asset management</li></ul><h4>Construct</h4><ul><li>Temporary essential services<br />Erection of the building<br />Permanent essential services<br />Building inspection<br />Snag list<br />COF?Certificate Of Fitness</li></ul><h4>Fit-Out</h4><ul><li>Fit-Out<br />Builders cleaning<br />As-Built Drawings</li></ul><h4>Test &amp; Commissioning</h4><ul><li>IET?Individual Equipment Test<br />IPVT/IST?Integrated Performance Verification Test/Integrated Systems Test<br />Common mistakes with IET/IPVT<br />Deep cleaning<br />Exercise: IET/IPVT scripting</li></ul><h4>Hand-Over</h4><ul><li>Facility hand-over requirements and documents<br />PCC?Practical Completion Certificate<br />DLP?Defect Liability Period<br />Defect Management<br />ICT Systems Installation<br />ICT Systems Testing<br />Hand-Over/DLP Expiry<br />FCC?Final Completion Certificate</li></ul><h4>Retirement</h4><ul><li>Reasons and definitions of retirement<br />Building the business case and project plan<br />Sequencing<br />Transfer of site<br />Demolishing of site<br />Legal matters<br />FCC?Final Completion Certificate</li></ul><h4>Exam: Certified Data Centre Expert (CDCEÂ©)</h4><ul><li>The CDCEÂ© exam is in two parts: Part A is a 90-minute closed book exam, with 60 multiple-choice questions. For Part A, the candidate requires a minimum of 45 correct answers to pass the exam. Part B is a 90-minute closed book exam, with 25 open questions. For Part B the candidate needs to obtain a minimum of 75% to pass.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Certified Data Centre Expert (CDCE) 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 Expert (CDCE) 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)

Construction Design & Management (CDM)

Cisco Certified Internetwork Expert (CCIE)

Certified in Data Protection (CDP)

Certified Cyber Professional (CCP)

Certified Data Centre Expert (CDCE)

General Admission

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>The Microsoft 365 Endpoint Administrator is responsible for deploying, configuring, securing, managing, and monitoring devices and client applications in a corporate setting. Their duties include managing identity, access, policies, updates, and apps. They work alongside the M365 Enterprise Administrator to develop and execute a device strategy that aligns with the requirements of a modern organization. Microsoft 365 Endpoint Administrators should be well-versed in M365 workloads and possess extensive skills and experience in deploying, configuring, and maintaining Windows 11 and later, as well as non-Windows devices. Their role emphasizes cloud services over on-premises management technologies.</p><p></p><p></p><p>In this course, students will learn to plan and execute an endpoint deployment strategy using contemporary deployment techniques and implementing update strategies. The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Microsoft Entra ID, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data.</p><p></p>Prerequisites<p>The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 11 and later, and non-Windows devices.</p></div><div id="course-pills-2"><h3>1 - Explore the Enterprise Desktop</h3> <ul> <li>Examine benefits of modern management</li> <li>Examine the enterprise desktop life-cycle model</li> <li>Examine planning and purchasing</li> <li>Examine desktop deployment</li> <li>Plan an application deployment</li> <li>Plan for upgrades and retirement</li> </ul> <h3>2 - Explore Windows Editions</h3> <ul> <li>Examine Windows client editions and capabilities</li> <li>Select client edition</li> <li>Examine hardware requirements</li> </ul> <h3>3 - Understand Microsoft Entra ID</h3> <ul> <li>Examine Microsoft Entra ID</li> <li>Compare Microsoft Entra ID and Active Directory Domain Services</li> <li>Examine Microsoft Entra ID as a directory service for cloud apps</li> <li>Compare Microsoft Entra ID P1 and P2 plans</li> <li>Examine Microsoft Entra Domain Services</li> </ul> <h3>4 - Manage Microsoft Entra identities</h3> <ul> <li>Examine RBAC and user roles in Microsoft Entra ID</li> <li>Create and manage users in Microsoft Entra ID</li> <li>Create and manage groups in Microsoft Entra ID</li> <li>Manage Microsoft Entra objects with PowerShell</li> <li>Synchronize objects from AD DS to Microsoft Entra ID</li> </ul> <h3>5 - Manage device authentication</h3> <ul> <li>Describe Microsoft Entra join </li> <li>Examine Microsoft Entra join prerequisites limitations and benefits</li> <li>Join devices to Microsoft Entra ID</li> <li>Manage devices joined to Microsoft Entra ID</li> </ul> <h3>6 - Enroll devices using Microsoft Configuration Manager</h3> <ul> <li>Deploy the Microsoft Configuration Manager client</li> <li>Monitor the Microsoft Configuration Manager client</li> <li>Manage the Microsoft Configuration Manager client</li> </ul> <h3>7 - Enroll devices using Microsoft Intune</h3> <ul> <li>Manage mobile devices with Intune</li> <li>Enable mobile device management</li> <li>Explain considerations for device enrollment</li> <li>Manage corporate enrollment policy</li> <li>Enroll Windows devices in Intune</li> <li>Enroll Android devices in Intune</li> <li>Enroll iOS devices in Intune</li> <li>Explore device enrollment manager</li> <li>Monitor device enrollment</li> <li>Manage devices remotely</li> </ul> <h3>8 - Execute device profiles</h3> <ul> <li>Explore Intune device profiles</li> <li>Create device profiles</li> <li>Create a custom device profile</li> </ul> <h3>9 - Oversee device profiles</h3> <ul> <li>Monitor device profiles in Intune</li> <li>Manage device sync in Intune</li> <li>Manage devices in Intune using scripts</li> </ul> <h3>10 - Maintain user profiles</h3> <ul> <li>Examine user profile</li> <li>Explore user profile types</li> <li>Examine options for minimizing user profile size</li> <li>Deploy and configure folder redirection</li> <li>Sync user state with Enterprise State Roaming</li> <li>Configure Enterprise State Roaming in Azure</li> </ul> <h3>11 - Execute mobile application management</h3> <ul> <li>Examine mobile application management</li> <li>Examine considerations for mobile application management</li> <li>Prepare line-of-business apps for app protection policies</li> <li>Implement mobile application management policies in Intune</li> <li>Manage mobile application management policies in Intune</li> </ul> <h3>12 - Deploy and update applications</h3> <ul> <li>Deploy applications with Intune</li> <li>Add apps to Intune</li> <li>Manage Win32 apps with Intune</li> <li>Deploy applications with Configuration Manager</li> <li>Deploying applications with Group Policy</li> <li>Assign and publish software</li> <li>Explore Microsoft Store for Business</li> <li>Implement Microsoft Store Apps</li> <li>Update Microsoft Store Apps with Intune</li> <li>Assign apps to company employees</li> </ul> <h3>13 - Administer endpoint applications</h3> <ul> <li>Manage apps with Intune</li> <li>Manage Apps on non-enrolled devices</li> <li>Deploy Microsoft 365 Apps with Intune</li> <li>Additional Microsoft 365 Apps Deployment Tools</li> <li>Configure Microsoft Edge Internet Explorer mode</li> <li>App Inventory Review</li> </ul> <h3>14 - Protect identities in Microsoft Entra ID</h3> <ul> <li>Explore Windows Hello for Business</li> <li>Deploy Windows Hello</li> <li>Manage Windows Hello for Business</li> <li>Explore Microsoft Entra ID Protection</li> <li>Manage self-service password reset in Microsoft Entra ID</li> <li>Implement multi-factor authentication</li> </ul> <h3>15 - Enable organizational access</h3> <ul> <li>Enable access to organization resources</li> <li>Explore VPN types and configuration</li> <li>Explore Always On VPN</li> <li>Deploy Always On VPN</li> </ul> <h3>16 - Implement device compliance</h3> <ul> <li>Protect access to resources using Intune</li> <li>Explore device compliance policy</li> <li>Deploy a device compliance policy</li> <li>Explore conditional access</li> <li>Create conditional access policies</li> </ul> <h3>17 - Generate inventory and compliance reports</h3> <ul> <li>Report enrolled devices inventory in Intune</li> <li>Monitor and report device compliance</li> <li>Build custom Intune inventory reports</li> <li>Access Intune using Microsoft Graph API</li> </ul> <h3>18 - Deploy device data protection</h3> <ul> <li>Explore Windows Information Protection</li> <li>Plan Windows Information Protection</li> <li>Implement and use Windows Information Protection</li> <li>Explore Encrypting File System in Windows client</li> <li>Explore BitLocker</li> </ul> <h3>19 - Manage Microsoft Defender for Endpoint</h3> <ul> <li>Explore Microsoft Defender for Endpoint</li> <li>Examine key capabilities of Microsoft Defender for Endpoint</li> <li>Explore Windows Defender Application Control and Device Guard</li> <li>Explore Microsoft Defender Application Guard</li> <li>Examine Windows Defender Exploit Guard</li> <li>Explore Windows Defender System Guard</li> </ul> <h3>20 - Manage Microsoft Defender in Windows client</h3> <ul> <li>Explore Windows Security Center</li> <li>Explore Windows Defender Credential Guard</li> <li>Manage Microsoft Defender Antivirus</li> <li>Manage Windows Defender Firewall</li> <li>Explore Windows Defender Firewall with Advanced Security</li> </ul> <h3>21 - Manage Microsoft Defender for Cloud Apps</h3> <ul> <li>Explore Microsoft Defender for Cloud Apps</li> <li>Planning Microsoft Defender for Cloud Apps</li> <li>Implement Microsoft Defender for Cloud Apps</li> </ul> <h3>22 - Assess deployment readiness</h3> <ul> <li>Examine deployment guidelines</li> <li>Explore readiness tools</li> <li>Assess application compatibility</li> <li>Explore tools for application compatibility mitigation</li> <li>Prepare network and directory for deployment</li> <li>Plan a pilot</li> </ul> <h3>23 - Deploy using the Microsoft Deployment Toolkit</h3> <ul> <li>Evaluate traditional deployment methods</li> <li>Set up the Microsoft Deployment Toolkit for client deployment</li> <li>Manage and deploy images using the Microsoft Deployment Toolkit</li> </ul> <h3>24 - Deploy using Microsoft Configuration Manager</h3> <ul> <li>Explore client deployment using Configuration Manager</li> <li>Examine deployment components of Configuration Manager</li> <li>Manage client deployment using Configuration Manager</li> <li>Plan in-place upgrades using Configuration Manager</li> </ul> <h3>25 - Deploy Devices using Windows Autopilot</h3> <ul> <li>Use Autopilot for modern deployment</li> <li>Examine requirements for Windows Autopilot</li> <li>Prepare device IDs for Autopilot</li> <li>Implement device registration and out-of-the-box customization</li> <li>Examine Autopilot scenarios</li> <li>Troubleshoot Windows Autopilot</li> </ul> <h3>26 - Implement dynamic deployment methods</h3> <ul> <li>Examine subscription activation</li> <li>Deploy using provisioning packages</li> <li>Use Windows Configuration Designer</li> <li>Use Microsoft Entra join with automatic MDM enrollment</li> </ul> <h3>27 - Plan a transition to modern endpoint management</h3> <ul> <li>Explore using co-management to transition to modern endpoint management</li> <li>Examine prerequisites for co-management</li> <li>Evaluate modern management considerations</li> <li>Evaluate upgrades and migrations in modern transitioning</li> <li>Migrate data when modern transitioning</li> <li>Migrate workloads when modern transitioning</li> </ul> <h3>28 - Manage Windows 365</h3> <ul> <li>Explore Windows 365</li> <li>Configure Windows 365</li> <li>Administer Windows 365</li> </ul> <h3>29 - Manage Azure Virtual Desktop</h3> <ul> <li>Examine Azure Virtual Desktop</li> <li>Explore Azure Virtual Desktop</li> <li>Configure Azure Virtual Desktop</li> <li>Administer Azure Virtual Desktop</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans MD-102T00 : Microsoft 365 Endpoint Administrator 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 MD-102T00 : Microsoft 365 Endpoint Administrator 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 Certification

Microsoft 365

Microsoft AZ-900

Microsoft AZ-104

Microsoft AZ-700

MD-102T00 Microsoft 365 Endpoint Administrator

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is targeted toward an IT Professional that has the technical knowledge and skills required to conceptualize, design, and engineer secure solutions across complex enterprise environments. Students should have a minimum of 10 years experience including at least 5 years of hands-on technical security experience.</p>Overview<p>Upon successful completion of this course, students will be able to:  Identify enterprise security fundamentals.  Apply enterprise security technology solutions.  Implement security design and solutions.  Manage risk, policies and procedures within an enterprise.  Integrate security solutions within an enterprise.  Conduct security research and analysis.</p><p>In this course, students will examine advanced security concepts, principles, and implementations that pertain to enterprise level security.</p>Prerequisites<p></p><ul><li>CompTIA Cybersecurity Analyst (CySA+) Certification</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Enterprise Security Architecture</h3> <ul> <li>The Basics of Enterprise Security</li> <li>The Enterprise Structure</li> <li>Enterprise Security Requirements</li> </ul> <h3>2 - Enterprise Security Technology</h3> <ul> <li>Common Network Security Components and Technologies</li> <li>Communications and Collaboration Security</li> <li>Cryptographic Tools and Techniques</li> <li>Advanced Authentication</li> </ul> <h3>3 - Enterprise Resource Technology</h3> <ul> <li>Enterprise Storage Security Issues</li> <li>Distributed, Shared, and Virtualized Computing</li> <li>Cloud Computing and Security</li> </ul> <h3>4 - Security Design and Solutions</h3> <ul> <li>Network Security Design</li> <li>Conduct a Security Assessment</li> <li>Host Security</li> </ul> <h3>5 - Application Security Design</h3> <ul> <li>Application Security Basics</li> <li>Web Application Security</li> </ul> <h3>6 - Managing Risk, Security Policies, and Security Procedures</h3> <ul> <li>Analyze Security Risk</li> <li>Implement Risk Mitigation Strategies and Controls</li> <li>Implement Enterprise-Level Security Policies and Procedures</li> <li>Prepare for Incident Response and Recovery</li> </ul> <h3>7 - Enterprise Security Integration</h3> <ul> <li>The Technology Life Cycle</li> <li>Inter-Organizational Change</li> <li>Integrate Enterprise Disciplines to Achieve Secure Solutions</li> </ul> <h3>8 - Security Research and Analysis</h3> <ul> <li>Perform an Industry Trends and Impact Analysis</li> <li>Perform an Enterprise Security Analysis</li> </ul></div>

Certified Cloud Security Professional (CCSP)

ASIS Certified Protection Professional (CPP)

Cissp

CompTIA Advanced Security Practitioner (CASP+)

<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 IT professionals who wish to develop cloud computing skills to enable them to move IT workloads to the cloud and integrate products and services from different providers and industries. Their focus is to ensure that cloud deployments are secure, that automation and orchestration are used effectively to bring business value from the cloud, and that costs are controlled through effective management of cloud vendors.   This course is also designed for students who are preparing to take the CompTIA Cloud+ certification exam CV0-003, or who plan to use Cloud+ as the foundation for more advanced cloud certifications or career roles.</p>Overview<p>In this course, you will deploy, test, secure, manage, optimize, and troubleshoot a cloud solution.   You will:  - Prepare to deploy cloud solutions  - Deploy a pilot project  - Test a pilot project deployment  - Design a secure network for cloud deployment  - Determine CPU and memory sizing for cloud deployments  - Determine storage requirements for cloud deployments  - Plan Identity and Access Management for cloud deployments  - Analyze workload characteristics to ensure successful migration to the cloud  - Secure systems to meet access requirements  - Maintain cloud systems  - Implement backup, restore, and business continuity measures  - Analyze cloud systems for required performance  - Analyze cloud systems for anomalies and growth forecasting  - Troubleshoot deployment, capacity, automation, and orchestration issues  - Troubleshoot connectivity issues  - Troubleshoot security issues</p><p>In this course, you will learn how to implement, maintain, and deliver cloud technologies including network, storage, and virtualization technologies to create cloud solutions.</p></div><div id="course-pills-2"><h3>1 - PREPARING TO DEPLOY CLOUD SOLUTIONS</h3> <ul> <li>Describe Interaction of Cloud Components and Services</li> <li>Describe Interaction of Non-cloud Components and Services</li> <li>Evaluate Existing Components and Services for Cloud Deployment</li> <li>Evaluate Automation and Orchestration Options</li> <li>Prepare for Cloud Deployment</li> </ul> <h3>2 - DEPLOYING A PILOT PROJECT</h3> <ul> <li>Manage Change in a Pilot Project</li> <li>Execute Cloud Deployment Workflow</li> <li>Complete Post-Deployment Configuration</li> </ul> <h3>3 - TESTING PILOT PROJECT DEPLOYMENTS</h3> <ul> <li>Identify Cloud Service Components for Testing</li> <li>Test for High Availability and Accessibility</li> <li>Perform Deployment Load Testing</li> <li>Analyze Test Results</li> </ul> <h3>4 - DESIGNING A SECURE AND COMPLIANT CLOUD INFRASTRUCTURE</h3> <ul> <li>Design Cloud Infrastructure for Security</li> <li>Determine Organizational Compliance Needs</li> </ul> <h3>5 - DESIGNING AND IMPLEMENTING A SECURE CLOUD ENVIRONMENT</h3> <ul> <li>Design Virtual Network for Cloud Deployment</li> <li>Determine Network Access Requirements</li> <li>Secure Networks for Cloud Interaction</li> <li>Manage Cloud Component Security</li> <li>Implement Security Technologies</li> </ul> <h3>6 - PLANNING IDENTITY AND ACCESS MANAGEMENT FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Identity Management and Authentication Technologies</li> <li>Plan Account Management Policies for the Network and Systems</li> <li>Control Access to Cloud Objects</li> <li>Provision Accounts</li> </ul> <h3>7 - DETERMINING CPU AND MEMORY SIZING FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine CPU Size for Cloud Deployment</li> <li>Determine Memory Size for Cloud Deployment</li> </ul> <h3>8 - DETERMINING STORAGE REQUIREMENTS FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Storage Technology Requirements</li> <li>Select Storage Options for Deployment</li> <li>Determine Storage Access and Provisioning Requirements</li> <li>Determine Storage Security Options</li> </ul> <h3>9 - ANALYZING WORKLOAD CHARACTERISTICS TO ENSURE SUCCESSFUL MIGRATION</h3> <ul> <li>Determine the Type of Cloud Deployment to Perform</li> <li>Manage Virtual Machine and Container Migration</li> <li>Manage Network, Storage, and Data Migration</li> </ul> <h3>10 - MAINTAINING CLOUD SYSTEMS</h3> <ul> <li>Patch Cloud Systems</li> <li>Design and Implement Automation and Orchestration for Maintenance</li> </ul> <h3>11 - IMPLEMENTING BACKUP, RESTORE, DISASTER RECOVERY, AND BUSINESS CONTINUITY MEASURES</h3> <ul> <li>Back Up and Restore Cloud Data</li> <li>Implement Disaster Recovery Plans</li> <li>Implement Business Continuity Plans</li> </ul> <h3>12 - ANALYZING CLOUD SYSTEMS FOR PERFORMANCE</h3> <ul> <li>Monitor Cloud Systems to Measure Performance</li> <li>Optimize Cloud Systems to Meet Performance Criteria</li> </ul> <h3>13 - ANALYZING CLOUD SYSTEMS FOR ANOMALIES AND GROWTH FORECASTING</h3> <ul> <li>Monitor for Anomalies and Resource Needs</li> <li>Plan for Capacity</li> <li>Create Reports on Cloud System Metrics</li> </ul> <h3>14 - TROUBLESHOOTING DEPLOYMENT, CAPACITY, AUTOMATION, AND ORCHESTRATION ISSUES</h3> <ul> <li>Troubleshoot Deployment Issues</li> <li>Troubleshoot Capacity Issues</li> <li>Troubleshoot Automation and Orchestration Issues</li> </ul> <h3>15 - TROUBLESHOOTING CONNECTIVITY ISSUES</h3> <ul> <li>Identify Connectivity Issues</li> <li>Troubleshoot Connectivity Issues</li> </ul> <h3>16 - TROUBLESHOOTING SECURITY ISSUES</h3> <ul> <li>Troubleshoot Identity and Access Issues</li> <li>Troubleshoot Attacks</li> <li>Troubleshoot Other Security Issues</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Cloud Plus Certification (Exam CV0-003) 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 Cloud Plus Certification (Exam CV0-003) 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>

Cloud Architecture

AWS Certified Cloud Practitioner

CompTIA A+

CompTIA Cloud+

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.</p>Overview<p>Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries</p><p>This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.</p>Prerequisites<p></p><ul> <li>Basic understanding of relational databases.</li> <li>Basic Windows knowledge.</li> </ul><p></p></div><div id="course-pills-2"><h3>Module 1: Introduction to Transact-SQL</h3><ul> <li>What is Transact-SQL</li> <li>The SELECT statement</li> <li>The WHERE clause</li> <li>Sorting results</li> <li>Calculations</li> <li>CASE expressions</li> </ul>   <h3>Module 2: Joining tables with Transact-SQL</h3><ul> <li>The JOIN clause</li> <li>Inner joins</li> <li>Outer joins</li> <li>Self joins and cross joins</li> </ul>  <h3>Module 3: Filtering and sorting results</h3><ul> <li>Implement the ORDER BY clause</li> <li>Filter data with the WHERE clause</li> <li>Limit the number of rows returned by a query</li> <li>Implement NULL logic</li> </ul>  <h3>Module 4: SQL Server data types</h3><ul> <li>Understand data types</li> <li>Implement string data types</li> <li>Implement temporal data types</li> </ul>  <h3>Module 5: Inserting, updating and deleting data</h3><ul> <li>Insert new records</li> <li>Update existing records</li> <li>Delete data</li> </ul>   <h3>Module 6: Using SQL Server functions with Transact-SQL</h3><ul> <li>Understand function types in SQL Server</li> <li>Convert data using functions</li> <li>Implement logical functions</li> <li>Work with NULL data using functions</li> </ul>  <h3>Module 7: Aggregating data with Transact-SQL</h3><ul> <li>Implement aggregation in SQL Server</li> <li>Group records in SQL Server</li> <li>Filter aggregated data</li> </ul>   <h3>Module 8: Implement subqueries with Transact-SQL</h3><ul> <li>Implement scalar and multi-valued sub-queries</li> <li>Implement correlated subqueries</li> <li>Implement existence checks with subqueries</li> </ul>   <h3>Module 9: Create queries that use table expressions</h3><ul> <li>Create views</li> <li>Create table-valued functions</li> <li>Implement derived tables</li> <li>Implement common table expressions</li> </ul>  <h3>Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data</h3><ul> <li>Write queries with the UNION operator</li> <li>Write queries with the INTERSECT and EXCEPT operators</li> <li>Write queries with the APPLY operator</li> </ul>    <h3>Module 11: Implement window functions in queries</h3><ul> <li>Understand window functions</li> <li>Impement window functions</li> </ul>    <h3>Module 12: Use PIVOT and grouping sets in queries</h3><ul> <li>Implement PIVOT in queries</li> <li>Implement grouping sets in queries</li> </ul>   <h3>Module 13: Use stored procedures in queries</h3><ul> <li>Query data with stored procedures</li> <li>Interact with stored procedures using input and output parameters</li> <li>Write simple stored procedures</li> <li>Pass dynamic SQL to SQL Server</li> </ul>    <h3>Module 14: Implement programming features in Transact-SQL</h3><ul> <li>Understand T-SQL programming elements</li> <li>Implement loops and conditions in T-SQL queries</li> </ul>   <h3>Module 15: Add error handling to queries</h3><ul> <li>Understand SQL Server error handling</li> <li>Implemet structured exception handling</li> </ul>   <h3>Module 16: Use transactions in queries</h3><ul> <li>Understand database transactions</li> <li>Implement transactions in T-SQL</li> </ul></div>

Computing Skills

Microsoft SQL

Data Skills

SQL Server

55366 Querying Data with Transact-SQL

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for anyone seeking CCNA certification. The course also provides foundational knowledge for all support technicians involved in the basic installation, operation, and verification of Cisco networks. The job roles best suited to the material in this course are:<br />Entry-level network engineer<br />Network administrator<br />Network support technician<br />Help desk technician</p>Overview<p>This course will help you:<br />Learn the knowledge and skills to install, configure, and operate a small- to medium-sized network<br />Gain a foundation in the essentials of networking, security, and automation<br />Earn 30 CE credits toward recertification</p><p>The Implementing and Administering Cisco Solutions (CCNA) v2.0 course gives you a broad range of fundamental knowledge for all IT careers. Through a combination of lecture, hands-on labs, and self-study, you will learn how to install, operate, configure, and verify basic IPv4 and IPv6 networks. The course covers configuring network components such as switches, routers, and wireless LAN controllers; managing network devices; and identifying basic security threats. The course also gives you a foundation in network programmability, automation, and software-defined networking. This course helps you prepare to take the 200-301 CiscoÂ© Certified Network Associate (CCNAÂ©) exam. By passing this one exam, you earn the CCNA certification. This course also earns you 30 Continuing Education (CE) credits towards recertification.</p></div><div id="course-pills-2"><h4>Course Outline </h4><ul><li>Exploring the Functions of Networking ? Lecture</li><li>Introducing the Host-to-Host Communications Model ? Lecture</li><li>Operating Cisco IOS Software ? Lecture</li><li>Introducing LANs ? Lecture</li><li>Exploring the TCP/IP Link Layer ? Lecture</li><li>Starting a Switch ? Lecture</li><li>Introducing the TCP/IP Internet Layer, IPv4 Addressing, and Subnets ? Lecture</li><li>Explaining the TCP/IP Transport Layer and Application Layer ? Lecture</li><li>Exploring the Functions of Routing ? Lecture</li><li>Configuring a Cisco Router ? Lecture</li><li>Exploring the Packet Delivery Process ? Lecture</li><li>Troubleshooting a Simple Network ? Lecture</li><li>Introducing Basic IPv6 ? Lecture</li><li>Configuring Static Routing ? Lecture</li><li>Implementing VLANs and Trunks ? Lecture</li><li>Routing Between VLANs ? Lecture</li><li>Introducing OSPF ? Lecture</li><li>Building Redundant Switched Topologies ? Self-study</li><li>Improving Redundant Switched Topologies with EtherChannel ? Lecture</li><li>Exploring Layer 3 Redundancy ? Self-study</li><li>Introducing WAN Technologies ? Self-study</li><li>Explaining Basics of ACL ? Lecture</li><li>Enabling Internet Connectivity ? Lecture</li><li>Introducing QoS ? Self-study</li><li>Explaining Wireless Fundamentals ? Self-study</li><li>Introducing Architectures and Virtualization ? Self-study</li><li>Explaining the Evolution of Intelligent Networks ? Lecture</li><li>Introducing System Monitoring ? Lecture</li><li>Managing Cisco Devices ? Lecture</li><li>Examining the Security Threat Landscape ? Self-study</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Cisco Certified Network Associate (CCNA)

Cisco Certified Network Professional certification (CCNP)

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

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

IT Networking Fundamentals

Computer Networking

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

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.</p>Overview<p>Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment. Analyze data by using queries and reports. Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Intune. Deploy and manage the Configuration Manager client. Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. Identify and configure the most appropriate method to distribute and manage content used for deployments. Distribute, deploy, and monitor applications for managed users and systems. Maintain software updates for PCs that Configuration Manager manages. Implement Endpoint Protection for managed PCs. Configure an operating-system deployment strategy by using Configuration Manager. Manage and maintain a Configuration Manager site.</p><p>This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports.  Although this course and the associated labs are written for Microsoft Endpoint Configuration Manager and Windows 11, the skills taught will also be backwards compatible with previous editions of System Center Configuration Manager and Windows 10.</p>Prerequisites<p></p><li>Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.</li>  <li>Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.</li>  <li>Installation, configuration, and troubleshooting for Windows-based personal computers.</li>  <li>Basic concepts of public key infrastructure (PKI) security.</li>  <li>Basic understanding of scripting and Windows PowerShell syntax.</li>  <li>Basic understanding of Windows Server roles and services.</li>  <li>Basic understanding of the configuration options for iOS and Android Mobile device platforms.</li><p></p></div><div id="course-pills-2"><h3>1 - Managing computers and mobile devices in the enterprise</h3> <ul> <li>Overview of systems management by using enterprise management solutions</li> <li>Overview of the Configuration Manager architecture</li> <li>Overview of the Configuration Manager administrative tools</li> <li>Tools for monitoring and troubleshooting a Configuration Manager site</li> </ul> <h3>2 - Analyzing data using queries, reports, and CMPivot</h3> <ul> <li>Introduction to queries</li> <li>Configuring SQL Server Reporting Services</li> <li>Analyzing the real-time state of a device by using CMPivot</li> </ul> <h3>3 - Preparing the Configuration Manager management infrastructure</h3> <ul> <li>Configuring site boundaries and boundary groups</li> <li>Configuring resource discovery</li> <li>Organizing resources using device and user collections</li> </ul> <h3>4 - Deploying and managing the Configuration Manager client</h3> <ul> <li>Overview of the Configuration Manager client</li> <li>Deploying the Configuration Manager client</li> <li>Configuring and monitoring client status</li> <li>Managing client settings and performing management operations</li> </ul> <h3>5 - Managing inventory for PCs and applications</h3> <ul> <li>Overview of inventory collection</li> <li>Configuring hardware and software inventory</li> <li>Managing inventory collection</li> <li>Configuring software metering</li> <li>Configuring and managing Asset Intelligence</li> </ul> <h3>6 - Distributing and managing content used for deployments</h3> <ul> <li>Preparing the infrastructure for content management</li> <li>Distributing and managing content on distribution points</li> </ul> <h3>7 - Deploying and managing applications</h3> <ul> <li>Overview of application management</li> <li>Creating applications</li> <li>Deploying applications</li> <li>Managing applications</li> <li>Deploying and managing Windows apps</li> </ul> <h3>8 - Maintaining software updates for managed PCs</h3> <ul> <li>The software updates process</li> <li>Preparing a Configuration Manager site for software updates</li> <li>Managing software updates</li> <li>Configuring automatic deployment rules</li> <li>Monitoring and troubleshooting software updates</li> <li>Enabling third-party updates</li> </ul> <h3>9 - Implementing Defender Protection for managed PCs</h3> <ul> <li>Overview of Endpoint Protection in Configuration Manager</li> <li>Configuring, deploying, and monitoring Endpoint Protection policies</li> <li>Configuring and deploying advanced threat policies</li> <h3>10 - Managing compliance and secure data access</h3> <ul> <li>Overview of Compliance Settings</li> <li>Configuring compliance settings</li> <li>Viewing compliance results</li> <li>Managing resource and data access</li> <h3>11 - Managing operating system deployment</h3> <ul> <li>An overview of operating system deployment</li> <li>Preparing a site for operating system deployment</li> <li>Deploying an operating system</li> <li>Managing Windows as a service</li> <h3>12 - Managing and maintaining a Configuration Manager site</h3> <ul> <li>Configuring role-based administration</li> <li>Configuring Remote Tools</li> <li>Overview of Configuration Manager site maintenance and Management Insights</li> <li>Backing up and recovering a Configuration Manager site</li> <li>Updating the Configuration Manager infrastructure</li> <h3>13 - What?s new in Microsoft Endpoint Configuration Manager</h3> <ul> <li>Whats new in Microsoft Endpoint Manager covering each semi annual release</li> </ul></ul></ul></ul></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55348: Administering Microsoft Endpoint Configuration Manager 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 55348: Administering Microsoft Endpoint Configuration Manager 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>

Sccm

Microsoft Certified Technology Specialist (MCTS)

IT Manager

55348 Administering Microsoft Endpoint Configuration Manager

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for existing IT professionals who have some networking knowledge and experience and are looking for a single course that provides insight into core and advanced networking technologies in Windows Server. This audience would typically include: Network administrators who are looking to reinforce existing skills and learn about new networking technology changes and functionality in Windows Server. System or Infrastructure Administrators with general networking knowledge who are looking to gain core and advanced networking knowledge and skills on Windows Server.</p>Overview<p>Plan and implement an IPv4 network. Implement Dynamic Host Configuration Protocol (DHCP). Implement IPv6. Implement Domain Name System (DNS). Implement and manage IP address management (IPAM). Plan for remote access. Implement DirectAccess. Implement virtual private networks (VPNs). Implement networking for branch offices. Configure advanced networking features. Implement Software Defined Networking.</p><p>55343A is the Community Courseware equivalent of retired Legacy Course 20741BC - Networking with Windows Server 2016. This 5-day classroom-based course provides the fundamental networking skills required to deploy and support Windows Server in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking. Although this course and the associated labs are written for Windows Server 2022, the skills taught will also be backwards compatible for Server 2016 and Server 2019.</p>Prerequisites<p>In addition to professional experience, students who attend this training should already have the following technical knowledge:  </p><li>Experience working with Windows Server  </li><li>Knowledge of the Open Systems Interconnection (OSI) model  </li><li>Understanding of core networking infrastructure components and technologies such as cabling, routers and switches  </li><li>Familiarity with networking topologies and architectures such as local area networks (LANs), wide area networks (WANs) and wireless networking  </li><li>Some basic knowledge of the TCP/IP protocol stack, addressing and name resolution  </li><li>Experience with and knowledge of virtualization  </li><li>Hands-on experience working with the Windows client operating systems such as Windows 10 or Windows 11<p></p></li></div><div id="course-pills-2"><h3>1 - Planning and implementing an IPv4 network</h3> <ul> <li>Planning IPv4 addressing</li> <li>Configuring an IPv4 host</li> <li>Managing and troubleshooting IPv4 network connectivity</li> </ul> <h3>2 - Implementing DHCP</h3> <ul> <li>Overview of the DHCP server role</li> <li>Deploying DHCP</li> <li>Managing and troubleshooting DHCP</li> </ul> <h3>3 - Implementing IPv6</h3> <ul> <li>Overview of IPv6 addressing</li> <li>Configuring an IPv6 host</li> <li>Implementing IPv6 and IPv4 coexistence</li> <li>Transitioning from IPv4 to IPv6</li> </ul> <h3>4 - Implementing DNS</h3> <ul> <li>Implementing DNS servers</li> <li>Configuring zones in DNS</li> <li>Configuring name resolution between DNS zones</li> <li>Configuring DNS integration with Active Directory Domain Services (AD DS)</li> <li>Configuring advanced DNS settings</li> </ul> <h3>5 - Implementing and managing IPAM</h3> <ul> <li>Overview of IPAM</li> <li>Deploying IPAM</li> <li>Managing IP address spaces by using IPAM</li> </ul> <h3>6 - Remote access in Windows Server</h3> <ul> <li>Overview of remote access</li> <li>Implementing the Web Application Proxy</li> </ul> <h3>7 - Implementing DirectAccess</h3> <ul> <li>Overview of DirectAccess</li> <li>Implementing DirectAccess by using the Getting Started Wizard</li> <li>Implementing and managing an advanced DirectAccess infrastructure</li> </ul> <h3>8 - Implementing VPNs</h3> <ul> <li>Planning VPNs</li> <li>Implementing VPNs</li> </ul> <h3>9 - Implementing networking for branch offices</h3> <ul> <li>Networking features and considerations for branch offices</li> <li>Implementing Distributed File System (DFS) for branch offices</li> <li>Implementing BranchCache for branch offices</li> </ul> <h3>10 - Configuring advanced networking features</h3> <ul> <li>Overview of high performance networking features</li> <li>Configuring advanced Microsoft Hyper-V networking features</li> </ul> <h3>11 - Implementing Software Defined Networking</h3> <ul> <li>Overview of SDN.</li> <li>Implementing network virtualization</li> <li>Implementing Network Controller</li> </ul></div>

Networking Skills

55343 Networking with Windows Server

5385 Computing courses delivered Online

Intermediate SQL Custom 3-Day Private Class Outline

By Nexus Human

VMware Carbon Black EDR Advanced Administrator

By Nexus Human

CEM-205 Manage Citrix Endpoint Management

By Nexus Human

WM646 IBM Integration Bus V10 System Administration

By Nexus Human

CCTA Check Point Troubleshooting Administration

By Nexus Human

Oracle 12c PL/SQL Fundamentals

By Nexus Human

VMware Carbon Black EDR Advanced Analyst

By Nexus Human

Basic Java 11 and OO Programming for Developers New to OO (TT2120-J11)

By Nexus Human

S4220 SAP Production Planning in SAP S/4HANA

By Nexus Human

Oracle 12c Administration II

By Nexus Human