<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>Administrators</p>Overview<p>Please refer to course overview</p><p>This offering covers the fundamental concepts of installing and configuring IBM Cognos Analytics, and administering servers and content, in a distributed environment. In the course, participants will identify requirements for the installation and configuration of a distributed IBM Cognos Analytics software environment, implement security in the environment, and manage the server components. Students will also monitor and schedule tasks, create data sources, and manage and deploy content in the portal and IBM Cognos Administration.</p></div><div id="course-pills-2"><h4>Introduction to IBM Cognos Analytics administration</h4><ul><li>IBM Cognos Analytics components</li><li>Administration workflow</li><li>IBM Cognos Administration</li><li>IBM Cognos Configuration</li></ul><h4>Identify IBM Cognos Analytics architecture</h4><ul><li>Features of the IBM Cognos Analytics architecture</li><li>Examine the multi-tiered architecture, and identify logging types and files</li><li>Examine IBM Cognos Analytics servlets</li><li>Performance and installation planning</li><li>Balance the request load</li><li>Configure IBM Cognos Analytics</li></ul><h4>Secure the IBM Cognos Analytics environment</h4><ul><li>Identify the IBM Cognos Analytics security model</li><li>Define authentication in IBM Cognos Analytics</li><li>Define authorization in IBM Cognos Analytics</li><li>Identify security policies</li><li>Secure the IBM Cognos Analytics environment</li></ul><h4>Administer the IBM Cognos Analytics server environment</h4><ul><li>Administer IBM Cognos Analytics servers</li><li>Monitor system performance</li><li>Manage dispatchers and services</li><li>Tune system performance, and troubleshoot the server</li><li>Audit logging</li><li>Dynamic cube data source administration workflow</li></ul><h4>Manage run activities</h4><ul><li> View current, past, and upcoming activities</li><li>Manage schedules</li></ul><h4>Manage content in IBM Cognos Administration</h4><ul><li>Data sources and packages</li><li>Manage visualizations in the library</li><li>Deployment</li><li>Other content management tasks</li></ul><h4>Examine departmental administration capabilities</h4><ul><li>Create and manage team members</li><li>Manage activities</li><li>Create and manage content and data</li><li>Manage system settings</li><li>Manage Themes, Extensions, and Views</li><li>Share services with multiple tenants</li></ul></div>

Nexus Human

Cognos

Business Analytics & Intelligence

Oracle Business Intelligence

Excel Analytics

AWS Certified Cloud Practitioner

Commercial & Contract Management Certification Program (CCM)

B6155 IBM Cognos Analytics - Enterprise Administration (v11.0.x)

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

Programming Fundamentals

Oracle SQL

Database Programming

Oracle

Oracle 1Z0-819

Oracle Database

Oracle 12c - PL/SQL Fundamentals

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>Administrators</p>Overview<p>Please refer to course overview</p><p>This offering covers the fundamental concepts of installing and configuring IBM Cognos Analytics, and administering servers and content, in a distributed environment. In the course, participants will identify requirements for the installation and configuration of a distributed IBM Cognos Analytics software environment, implement security in the environment, and manage the server components. Students will also monitor and schedule tasks, create data sources, and manage and deploy content in the portal and IBM Cognos Administration.</p></div><div id="course-pills-2"><h4>Introduction to IBM Cognos Analytics administration</h4><ul><li>IBM Cognos Analytics components</li><li>Administration workflow</li><li>IBM Cognos Administration</li><li>IBM Cognos Configuration</li></ul><h4>Identify IBM Cognos Analytics architecture</h4><ul><li>Features of the IBM Cognos Analytics architecture</li><li>Examine the multi-tiered architecture, and identify logging types and files</li><li>Examine IBM Cognos Analytics servlets</li><li>Performance and installation planning</li><li>Balance the request load</li><li>Configure IBM Cognos Analytics</li></ul><h4>Secure the IBM Cognos Analytics environment</h4><ul><li>Identify the IBM Cognos Analytics security model</li><li>Define authentication in IBM Cognos Analytics</li><li>Define authorization in IBM Cognos Analytics</li><li>Identify security policies</li><li>Secure the IBM Cognos Analytics environment</li></ul><h4>Administer the IBM Cognos Analytics server environment</h4><ul><li>Administer IBM Cognos Analytics servers</li><li>Monitor system performance</li><li>Manage dispatchers and services</li><li>Tune system performance, and troubleshoot the server</li><li>Audit logging</li><li>Dynamic cube data source administration workflow</li></ul><h4>Manage run activities</h4><ul><li>View current, past, and upcoming activities</li><li>Manage schedules</li></ul><h4>Manage content in IBM Cognos Administration</h4><ul><li>Data sources and packages</li><li>Manage visualizations in the library</li><li>Deployment</li><li>Other content management tasks</li></ul><h4>Examine departmental administration capabilities</h4><ul><li>Create and manage team members</li><li>Manage activities</li><li>Create and manage content and data</li><li>Manage system settings</li><li>Manage Themes, Extensions, and Views</li><li>Share services with multiple tenants</li></ul></div>

B6255 IBM Cognos Analytics - Enterprise Administration (V11.1.x)

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Experienced universe designers upgrading from a previous version of SAP BusinessObjects Designer to SAP BusinessObjects Information Design Tool 4.1. NOTE: This workshop is not designed for users new to the tool.</p><p>In this course, participants will gain an understanding of the Delta between Universe Design and the Information Design Tool.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>New File extension</li><li>Universe components -Projects -Connections -Data foundation -Business Layer</li><li>Universe Testing</li><li>Lists of Values</li><li>Parameters</li><li>@Execute function</li><li>Calculated Columns</li><li>Multisource universe</li><li>Federated Tables</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans WNAI41 SAP Information Design Tool Delta 4.1 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 WNAI41 SAP Information Design Tool Delta 4.1 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>

Service Design Courses (SDC)

SAP Project

ABAP with SAP Netweaver

SAP S/4HANA

SAP Fiori

WNAI41 SAP Information Design Tool Delta 4.1

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Microsoft 365.</p>Overview<p>In this course, you will optimize an Access database. You will:<br />Provide input validation features to promote the entry of quality data into a database.<br />Organize a database for efficiency and performance, and to maintain data integrity.<br />Improve the usability of Access tables.<br />Create advanced queries to join and summarize data.<br />Use advanced formatting and controls to improve form presentation.<br />Use advanced formatting and calculated fields to improve reports.</p><p>Your training and experience using MicrosoftÂ© AccessÂ© has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access.MicrosoftÂ© AccessÂ© for Office 365?: Part 1 : Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.MicrosoftÂ© AccessÂ© for Office 365?: Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.MicrosoftÂ© AccessÂ© for Office 365?: Part 3 : Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam.</p></div><div id="course-pills-2"><h4>Lesson 1: Promoting Quality Data Input</h4><ul><li>Topic A: Restrict Data Input Through Field Validation</li><li>Topic B: Restrict Data Input Through Forms and Record Validation</li></ul><h4>Lesson 2: Improving Efficiency and Data Integrity</h4><ul><li>Topic A: Data Normalization</li><li>Topic B: Associate Unrelated Tables</li><li>Topic C: Enforce Referential Integrity</li></ul><h4>Lesson 3: Improving Table Usability</h4><ul><li>Topic A: Create Lookups Within a Table</li><li>Topic B: Work with Subdatasheets</li></ul><h4>Lesson 4: Creating Advanced Queries</h4><ul><li>Topic A: Create Query Joins</li><li>Topic B: Create Subqueries</li><li>Topic C: Summarize Data</li></ul><h4>Lesson 5: Improving Form Presentation</h4><ul><li>Topic A: Apply Conditional Formatting</li><li>Topic B: Create Tab Pages with Subforms and Other Controls</li></ul><h4>Lesson 6: Creating Advanced Reports</h4><ul><li>Topic A: Apply Advanced Formatting to a Report</li><li>Topic B: Add a Calculated Field to a Report</li><li>Topic C: Control Pagination and Print Quality</li><li>Topic D: Add a Chart to a Report</li></ul></div>

Microsoft 365

Microsoft AZ-900

Microsoft AZ-104

Microsoft Access

Microsoft AZ-303

Microsoft AZ-700

Microsoft Access for Office 365: Part 2

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

Online Course Creation

Sup Instructor

Trainers Course

Intermediate SQL Custom 3-Day Private Class Outline

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

Cisco Certified Entry Networking Technician (CCENT)

Microsoft Certified Trainer (MCT)

Citrix

CEM-205 Manage Citrix Endpoint Management

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Multi-role (consumers, business authors, professional authors, developers, administrators, modelers, project managers)</p><p>This course provides students with an overview of the IBM Cognos Analytics suite of products and their underlying architecture. Students will examine each component as it relates to an Analytics solution &amp; will be shown a range of resources.</p></div><div id="course-pills-2"><h4>IBM Cognos Analytics</h4><ul><li>Describe IBM Cognos Analytics</li><li>Describe IBM Cognos Analytics components</li><li>Describe IBM Cognos architecture at a high level</li><li>Describe IBM Cognos security at a high level</li></ul><h4>Consume Content in IBM Cognos Analytics</h4><ul><li>Where do consumers access BI content?</li><li>Use published reports</li><li>Drill through to related data</li><li>Specify run report options</li><li>Specify properties of an entry</li><li>Alerts and Watch Items</li></ul><h4>Create Reports in IBM Cognos Analytics</h4><ul><li>Overview of reporting and report authoring</li><li>Identify package types, uploaded files, and data modules available for reporting</li><li>Examine IBM Cognos Analytics - Reporting</li><li>Examine the interface</li><li>Explore different report types</li><li>Create a simple, sorted, and formatted report</li><li>Create a report view</li><li>Create a subscription</li><li>Create an Active Report</li><li>Import and report on personal data</li></ul><h4>Create Dashboards in IBM Cognos Analytics</h4><ul><li>Describe IBM Cognos Dashboarding</li><li>Identify the IBM Cognos Dashboarding user interface</li><li>Add report content and tools to create dashboards</li><li>Widget-to-widget communication</li><li>Filter data in the dashboard</li><li>Sort, group and ungroup, and calculate data</li></ul><h4>Create Metadata Models in IBM Cognos Analytics</h4><ul><li>Define IBM Cognos Framework Manager and its purpose</li><li>Describe the IBM Cognos Framework Manager environment</li><li>Describe IBM Cognos Cube Designer</li><li>Get high-level content from Dynamic Cubes course and/or FM course</li><li>Web-based Modeling</li><li>Create Data Modules</li></ul><h4>Extend IBM Cognos Analytics</h4><ul><li>Introduction to IBM Cognos Mobile</li><li>Key features</li><li>Examine Cognos Mobile architecture</li><li>Identify supported products</li><li>Introduction to IBM Cognos BI for Microsoft Office</li><li>Describe Cognos Analysis for Excel (CAFÂ)</li></ul><h4>Compare IBM Cognos Analytics &amp; IBM Cognos BI</h4><ul><li>New features in IBM Cognos Analytics</li><li>Changes from IBM Cognos BI to IBM Cognos Analytics</li><li>Legacy option</li><li>Examine Event Studio</li><li>Examine the role of Event Studio in Performance Management</li><li>List the benefits of Event Studio</li><li>Examine Metric Studio</li><li>Identify scorecards, metrics, and metric types</li><li>Organize metrics with strategies</li><li>Track initiatives with projects</li></ul></div>

IMS Productivity Analyst

Microsoft BI

B6008 Overview of IBM Cognos Analytics (v11.0)

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

Oracle 12c PL/SQL Fundamentals

<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>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This course is for Azure Security Engineers who are planning to take the associated certification exam, or who are performing security tasks in their day-to-day job. This course would also be helpful to an engineer that wants to specialize in providing security for Azure-based digital platforms and play an integral role in protecting an organization's data.</p><p></p><p></p><p>This course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization?s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations.</p><p></p>Prerequisites<p></p><li>AZ-104T00 - Microsoft Azure Administrator</li>  <li>Security best practices and industry security requirements such as defense in depth, least privileged access, role-based access control, multi-factor authentication, shared responsibility, and zero trust model.</li>  <li>Be familiar with security protocols such as Virtual Private Networks (VPN), Internet Security Protocol (IPSec), Secure Socket Layer (SSL), disk and data encryption methods.</li>  <li>Have some experience deploying Azure workloads. This course does not cover the basics of Azure administration, instead the course content builds on that knowledge by adding security specific information.</li>  <li>Have experience with Windows and Linux operating systems and scripting languages. Course labs may use PowerShell and the CLI.</li><p></p></div><div id="course-pills-2"><h3>1 - Manage identities in Microsoft Entra ID</h3> <ul> <li>Secure users in Microsoft Entra ID</li> <li>Secure groups in Microsoft Entra ID</li> <li>Recommend when to use external identities</li> <li>Secure external identities</li> <li>Implement Microsoft Entra Identity protection</li> </ul> <h3>2 - Manage authentication by using Microsoft Entra ID</h3> <ul> <li>Configure Microsoft Entra Verified ID</li> <li>Implement multifactor authentication (MFA)</li> <li>Implement passwordless authentication</li> <li>Implement password protection</li> <li>Implement single sign-on (SSO)</li> <li>Integrate single sign-on (SSO) and identity providers</li> <li>Recommend and enforce modern authentication protocols </li> </ul> <h3>3 - Manage authorization by using Microsoft Entra ID</h3> <ul> <li>Configure Azure role permissions for management groups, subscriptions, resource groups, and resources</li> <li>Assign built-in roles in Microsoft Entra ID</li> <li>Assign built-in roles in Azure</li> <li>Create and assign a custom role in Microsoft Entra ID</li> <li>Implement and manage Microsoft Entra Permissions Management</li> <li>Configure Microsoft Entra Privileged Identity Management </li> <li>Configure role management and access reviews by using Microsoft Entra Identity Governance</li> <li>Implement Conditional Access policies</li> </ul> <h3>4 - Manage application access in Microsoft Entra ID</h3> <ul> <li>Manage access to enterprise applications in Microsoft Entra ID, including OAuth permission grants</li> <li>Manage app registrations in Microsoft Entra ID</li> <li>Configure app registration permission scopes</li> <li>Manage app registration permission consent</li> <li>Manage and use service principals</li> <li>Manage managed identities for Azure resources</li> <li>Recommend when to use and configure a Microsoft Entra Application Proxy, including authentication</li> </ul> <h3>5 - Plan and implement security for virtual networks</h3> <ul> <li>Plan and implement Network Security Groups (NSGs) and Application Security Groups (ASGs)</li> <li>Plan and implement User-Defined Routes (UDRs)</li> <li>Plan and implement Virtual Network peering or gateway</li> <li>Plan and implement Virtual Wide Area Network, including secured virtual hub</li> <li>Secure VPN connectivity, including point-to-site and site-to-site</li> <li>Implement encryption over ExpressRoute</li> <li>Configure firewall settings on PaaS resources</li> <li>Monitor network security by using Network Watcher, including NSG flow logging</li> </ul> <h3>6 - Plan and implement security for private access to Azure resources</h3> <ul> <li>Plan and implement virtual network Service Endpoints</li> <li>Plan and implement Private Endpoints</li> <li>Plan and implement Private Link services</li> <li>Plan and implement network integration for Azure App Service and Azure Functions</li> <li>Plan and implement network security configurations for an App Service Environment (ASE)</li> <li>Plan and implement network security configurations for an Azure SQL Managed Instance</li> </ul> <h3>7 - Plan and implement security for public access to Azure resources</h3> <ul> <li>Plan and implement Transport Layer Security (TLS) to applications, including Azure App Service and API Management</li> <li>Plan, implement, and manage an Azure Firewall, Azure Firewall Manager and firewall policies</li> <li>Plan and implement an Azure Application Gateway</li> <li>Plan and implement an Azure Front Door, including Content Delivery Network (CDN)</li> <li>Plan and implement a Web Application Firewall (WAF)</li> <li>Recommend when to use Azure DDoS Protection Standard</li> </ul> <h3>8 - Plan and implement advanced security for compute</h3> <ul> <li>Plan and implement remote access to public endpoints, Azure Bastion and just-in-time (JIT) virtual machine (VM) access</li> <li>Configure network isolation for Azure Kubernetes Service (AKS)</li> <li>Secure and monitor AKS</li> <li>Configure authentication for AKS</li> <li>Configure security for Azure Container Instances (ACIs)</li> <li>Configure security for Azure Container Apps (ACAs)</li> <li>Manage access to Azure Container Registry (ACR)</li> <li>Configure disk encryption, Azure Disk Encryption (ADE), encryption as host, and confidential disk encryption</li> <li>Recommend security configurations for Azure API Management</li> </ul> <h3>9 - Plan and implement security for storage</h3> <ul> <li>Configure access control for storage accounts</li> <li>Manage life cycle for storage account access keys</li> <li>Select and configure an appropriate method for access to Azure Files</li> <li>Select and configure an appropriate method for access to Azure Blob Storage</li> <li>Select and configure an appropriate method for access to Azure Tables</li> <li>Select and configure an appropriate method for access to Azure Queues</li> <li>Select and configure appropriate methods for protecting against data security threats, including soft delete, backups, versioning, and immutable storage</li> <li>Configure Bring your own key (BYOK)</li> <li>Enable double encryption at the Azure Storage infrastructure level</li> </ul> <h3>10 - Plan and implement security for Azure SQL Database and Azure SQL Managed Instance</h3> <ul> <li>Enable database authentication by using Microsoft Entra ID</li> <li>Enable and monitor database audit</li> <li>Identify use cases for the Microsoft Purview governance portal</li> <li>Implement data classification of sensitive information by using the Microsoft Purview governance portal</li> <li>Plan and implement dynamic mask</li> <li>Implement transparent data encryption?</li> <li>Recommend when to use Azure SQL Database Always Encrypted</li> </ul> <h3>11 - Plan, implement, and manage governance for security</h3> <ul> <li>Create, assign, and interpret security policies and initiatives in Azure Policy</li> <li>Configure security settings by using Azure Blueprint</li> <li>Deploy secure infrastructures by using a landing zone</li> <li>Create and configure an Azure Key Vault</li> <li>Recommend when to use a dedicated Hardware Security Module (HSM)</li> <li>Configure access to Key Vault, including vault access policies and Azure Role Based Access Control</li> <li>Manage certificates, secrets, and keys</li> <li>Configure key rotation</li> <li>Configure backup and recovery of certificates, secrets, and keys</li> </ul> <h3>12 - Manage security posture by using Microsoft Defender for Cloud</h3> <ul> <li>Implement Microsoft Defender for Cloud</li> <li>Identify and remediate security risks by using the Microsoft Defender for Cloud Secure Score and Inventory</li> <li>Assess compliance against security frameworks and Microsoft Defender for Cloud</li> <li>Add industry and regulatory standards to Microsoft Defender for Cloud</li> <li>Add custom initiatives to Microsoft Defender for Cloud</li> <li>Connect hybrid cloud and multicloud environments to Microsoft Defender for Cloud</li> <li>Identify and monitor external assets by using Microsoft Defender External Attack Surface Management</li> </ul> <h3>13 - Configure and manage threat protection by using Microsoft Defender for Cloud</h3> <ul> <li>Enable workload protection services in Microsoft Defender for Cloud, including Microsoft Defender for Storage, Databases, Containers, App Service, Key Vault, Resource Manager, and DNS</li> <li>Configure Microsoft Defender for Servers</li> <li>Configure Microsoft Defender for Azure SQL Database</li> <li>Manage and respond to security alerts in Microsoft Defender for Cloud</li> <li>Configure workflow automation by using Microsoft Defender for Cloud</li> <li>Evaluate vulnerability scans from Microsoft Defender for Server</li> </ul> <h3>14 - Configure and manage security monitoring and automation solutions</h3> <ul> <li>Monitor security events by using Azure Monitor</li> <li>Configure data connectors in Microsoft Sentinel</li> <li>Create and customize analytics rules in Microsoft Sentinel</li> <li>Configure automation in Microsoft Sentinel</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans AZ-500T00 Microsoft Azure Security Technologies 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 AZ-500T00 Microsoft Azure Security Technologies 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 Azure

CompTIA Security+

AZ-500T00 Microsoft Azure Security Technologies

General Admission

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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>

Learning & Development

Design & Technology Courses (DT)

Data Skills

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p></p><p>The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.</p><p></p>Overview<p>Describe core data concepts Identify considerations for relational data on Azure Describe considerations for working with non-relational data on Azure Describe an analytics workload on Azure</p><p></p><p>In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization.</p><p></p></div><div id="course-pills-2"><h3>1 - Explore core data concepts</h3> <ul> <li>Identify data formats</li> <li>Explore file storage</li> <li>Explore databases</li> <li>Explore transactional data processing</li> <li>Explore analytical data processing</li> </ul> <h3>2 - Explore data roles and services</h3> <ul> <li>Explore job roles in the world of data</li> <li>Identify data services</li> </ul> <h3>3 - Explore fundamental relational data concepts</h3> <ul> <li>Understand relational data</li> <li>Understand normalization</li> <li>Explore SQL</li> <li>Describe database objects</li> </ul> <h3>4 - Explore relational database services in Azure</h3> <ul> <li>Describe Azure SQL services and capabilities</li> <li>Describe Azure services for open-source databases</li> </ul> <h3>5 - Explore Azure Storage for non-relational data</h3> <ul> <li>Explore Azure blob storage</li> <li>Explore Azure DataLake Storage Gen2</li> <li>Explore Azure Files</li> <li>Explore Azure Tables</li> </ul> <h3>6 - Explore fundamentals of Azure Cosmos DB</h3> <ul> <li>Describe Azure Cosmos DB</li> <li>Identify Azure Cosmos DB APIs</li> </ul> <h3>7 - Explore fundamentals of large-scale data warehousing</h3> <ul> <li>Describe data warehousing architecture</li> <li>Explore data ingestion pipelines</li> <li>Explore analytical data stores</li> </ul> <h3>8 - Explore fundamentals of real-time analytics</h3> <ul> <li>Understand batch and stream processing</li> <li>Explore common elements of stream processing architecture</li> <li>Explore Azure Stream Analytics</li> <li>Explore Apache Spark on Microsoft Azure</li> </ul> <h3>9 - Explore fundamentals of data visualization</h3> <ul> <li>Describe Power BI tools and workflow</li> <li>Describe core concepts of data modeling</li> <li>Describe considerations for data visualization</li> </ul></div>

Azure SQL Database

DP-900T00 Microsoft Azure Data Fundamentals

<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 IT professionals who are responsible for planning, configuring, and managing an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). In addition, they should have a general understanding of Microsoft Exchange Server, Microsoft Teams, and Microsoft SharePoint.</p>Overview<p>Plan and provision Office 365 Manage Users and Groups in Office 365 Deploy and Configure Tools and Applications for Office 365 Plan and Manage Exchange Online Plan and Manage SharePoint Online Plan and Manage Microsoft Teams Plan and Manage other Office 365 Services Implement Security and Compliance in Office 365 Report, Monitor and Troubleshoot Office 365</p><p>This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics. <br /><br /> Although this course and the associated labs are written for Office 365 with Windows 11, the skills taught will also be backwards compatible with Windows 10. This course is based on the features available in the Office 365 E3 license as these are the core features in Office 365 and Microsoft 365 plans.</p></div><div id="course-pills-2"><h3>1 - Planning and Provisioning Office 365</h3> <ul> <li>Overview of Office 365</li> <li>Core Services of Office 365</li> <li>Requirements for an Office 365 Tenant</li> <li>Planning a Pilot and Deployment</li> <li>Creating an Office 365 Tenant</li> <li>Adding Custom Domains and Managing DNS Settings</li> <li>Lab: Provisioning Office 365</li> </ul> <h3>2 - Managing Users and Groups in Office 365</h3> <ul> <li>Managing User Accounts and Licences</li> <li>Managing Passwords and Authentication</li> <li>Create and Managing the Different Types of Groups in Office 365</li> <li>Managing Users and Groups with PowerShell</li> <li>Managing Users and Groups in the Azure AD Admin Center</li> <li>Role Based Access and Administrative Roles</li> <li>Planning and Configuring Directory Synchronization</li> <li>Lab: Managing Users and Groups in Office 365</li> <li>Lab: Planning and Configuring Directory Synchronisation</li> </ul> <h3>3 - Deploying and Configuring Tools and Applications for Office 365</h3> <ul> <li>Planning Network Configuration for Office 365 Tools and Applications</li> <li>Using the Office Configuration Tool</li> <li>Click to Run Installation Use and Control</li> <li>Managing Centralized Deployment of Tools, Applications and Add-ins</li> <li>Reporting</li> <li>Lab: Deploying and Configuring Tools and Applications for Office 365</li> </ul> <h3>4 - Planning and Managing Exchange Online</h3> <ul> <li>What is Exchange Online</li> <li>Managing Exchange Online Mailboxes</li> <li>Managing Office 365 Groups in Exchange Online</li> <li>Configuring Exchange Online Permissions</li> <li>Managing Exchange Online using PowerShell</li> <li>Plan and Configure Mail Flow</li> <li>Plan and Configure Email Protection</li> <li>Lab: Planning and Managing Exchange Online</li> </ul> <h3>5 - Planning and Managing SharePoint Online</h3> <ul> <li>What is SharePoint Online</li> <li>Understanding the relationship between SharePoint, OneDrive, Teams, and Office 365 Groups</li> <li>SharePoint Online Architecture</li> <li>Configure SharePoint Online</li> <li>Configure and Control External Sharing</li> <li>Managing SharePoint Online Site Collections</li> <li>Managing SharePoint Online using PowerShell</li> <li>Lab: Planning and Managing SharePoint Online</li> </ul> <h3>6 - Planning and Managing Microsoft Teams</h3> <ul> <li>What is Microsoft Teams</li> <li>How Microsoft Teams integrates with other Office 365 Services</li> <li>Create and Manage Organization Wide Settings</li> <li>Create, Manage and Assign Microsoft Teams Policies</li> <li>Plan and Configure External and Guest Access</li> <li>Managing Microsoft Teams using PowerShell</li> <li>Lab: Planning and Managing Microsoft Teams</li> </ul> <h3>7 - Planning and Managing Other Office 365 Services</h3> <ul> <li>Yammer</li> <li>Planner</li> <li>Visio</li> <li>Bookings</li> <li>Delve</li> <li>Forms</li> <li>Power Platform</li> <li>Stream</li> <li>Sway</li> <li>Viva</li> <li>Scheduler</li> <li>Add-ins, including Find Time and Junk Reporter</li> <li>Lab: Planning and Managing Office 365 Services</li> </ul> <h3>8 - Security and Compliance in Office 365</h3> <ul> <li>Overview of Security and Compliance Features in Office 365</li> <li>Extending Security and compliance Features with Additional Licences</li> <li>Using the Microsoft Defender Portal and Secure Score</li> <li>Using the Office 365 Compliance Portal and Compliance Score</li> <li>Plan and Configure Retention Labels and Policies</li> <li>Plan and Configure Data Loss Prevention Policies</li> <li>Create and Assign Sensitivity Labels</li> <li>Configure Safe Attachments and Safe Links Policies</li> <li>Plan and Configure Multi Factor Authentication</li> <li>Lab: Configure Security and Compliance in Office 365</li> </ul> <h3>9 - Reporting, Monitoring and Troubleshooting Office 365</h3> <ul> <li>Monitoring Office 365 Service Health</li> <li>Troubleshooting Administrative Access in Office 365</li> <li>Troubleshoot Directory Synchronization</li> <li>Troubleshooting Exchange Online</li> <li>Troubleshooting SharePoint Online</li> <li>Troubleshooting Microsoft Teams</li> <li>Troubleshooting Office 365 Security and Compliance</li> <li>Lab: Reporting, Monitoring and Troubleshooting in Office 365</li> </ul></div>

Microsoft Certification

55354 Administering Office 365

<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 Enterprise network staff responsible for help desk support, system administration, and network design.</p>Overview<p>At Course Completion: - Features and functions of Group Policy - Use Group Policy management tools to manage security policies - Design a Group Policy infrastructure - Group Policy processing architecture - Back up, restore, import, and copy Group Policy Objects through the Group Policy - Management Console - Use Windows PowerShell to manage Group Policy - Implement security using Group Policy - Configure the desktop environment with Group Policy - Configure roaming profiles and Folder Redirection - Assign and publish software packages - Implement AppLocker and software restriction policies - Create and deploy Administrative Templates - Configure Group Policy preferences</p><p>In this course, you will learn how to reduce costs and increase efficiencies in your network. You will discover how to consolidate the administration of an enterprise IT infrastructure with Group Policy, and you will learn to control and manage computer systems and domain users running Windows Server 2016 and Windows clients. Create Group Policies, implement administrative and security templates, and determine best practices when deploying software packages. Walk away with the experience and tools needed to optimize your enterprise systems and networks, implement administrative and security templates, and determine best practices when deploying software packages.</p></div><div id="course-pills-2"><h3>1 - Introduction to Configuration Management</h3> <ul> <li>Configuration Management Overview</li> <li>Configuration Management Using Group Policy</li> <li>Group Policy Features Introduced with Later Versions of Windows</li> <li>Using Windows PowerShell in the Configuration Management Process</li> </ul> <h3>2 - Using Group Policy Management Tools</h3> <ul> <li>Local and Domain Policies</li> <li>Using Group Policy Management Console</li> <li>Understanding Group Policy Refresh</li> </ul> <h3>3 - Designing a Group Policy Infrastructure</h3> <ul> <li>Design Stages for a Group Policy Infrastructure</li> <li>Planning your Group Policy Design</li> <li>Designing Your Group Policy Solution</li> <li>Deploying Your Group Policy Solution</li> <li>Managing Your Group Policy Solution</li> </ul> <h3>4 - Understanding the Architecture of Group Policy Processing</h3> <ul> <li>Group Policy Components in AD DS</li> <li>Understanding the Group Policy Deployment Order</li> <li>Modifying Group Policy Processing</li> </ul> <h3>5 - Troubleshooting and Backing Up GPOs</h3> <ul> <li>Using Group Policy Troubleshooting Tools</li> <li>Integration of RSoP Functionality</li> <li>Group Policy Logging Options</li> <li>Backing Up, Restoring, Importing, and Copying GPOs</li> <li>Building Migration Tables</li> </ul> <h3>6 - Securing Windows Using Group Policy</h3> <ul> <li>Exploring the Windows Security Architecture</li> <li>Securing User Accounts</li> <li>Exploring Security Policies</li> <li>Windows Firewall with Advanced Security</li> <li>Implementing Domain Security</li> <li>Security Policy Options for Window Client and Windows Server</li> </ul> <h3>7 - Implementing Application Security Using Group Policy</h3> <ul> <li>Managing UAC Settings</li> <li>Defending Against Malware</li> <li>Using AppLocker to Restrict Software</li> <li>Implementing Windows App Security Settings</li> </ul> <h3>8 - Configuring the Desktop Environment with Group Policy</h3> <ul> <li>Exploring Script Types and Controlling Script Execution</li> <li>Defining the Desktop, Start Menu, and Taskbar Settings</li> <li>Defining the Control Panel Settings</li> <li>Defining the Windows Components Settings</li> <li>Configuring the Printer Management and Pruning Settings</li> <li>Defining the Network Settings</li> <li>Discovering the new Group Policy Settings</li> </ul> <h3>9 - Implementing User State Virtualization</h3> <ul> <li>Configuring Folder Redirection</li> <li>Managing Offline Files</li> <li>Implementing User Experience Virtualization</li> <li>OneDrive for Business</li> </ul> <h3>10 - Assigning and Publishing Software Packages</h3> <ul> <li>Using MSI Packages to Distribute Software</li> <li>Using Group Policy as a Software Deployment Method</li> <li>Deploying Software</li> <li>Setting Up Distribution Points</li> <li>Using the Systems Center Configuration Manager to Distribute Software</li> </ul> <h3>11 - Configuration Management with Windows PowerShell</h3> <ul> <li>Introducing Windows PowerShell</li> <li>Using Windows PowerShell</li> <li>Writing PowerShell Scripts</li> <li>Windows PowerShell Library for Group Policy</li> <li>Windows PowerShell-Based Logon Scripts</li> </ul> <h3>12 - Implementing PowerShell Desired State Configuration</h3> <ul> <li>Introducing Group Policy Preferences</li> <li>Comparing Preferences and Policy Settings</li> <li>Options for Applying Preferences</li> <li>Configure Preference Settings</li> </ul> <h3>13 - Configuring Group Policy Preferences</h3> <ul> <li>Introducing Group Policy Preferences</li> <li>Comparing Preferences and Policy Settings</li> <li>Options for Applying Preferences</li> <li>Configuring Preferences Settings</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 50255 Managing Windows Environments with Group Policy 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 50255 Managing Windows Environments with Group Policy 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>

Professional Skills Course (PSC)

50255 Managing Windows Environments with Group Policy

MS-102T00 Microsoft 365 Administrator Essentials

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.</p>Overview<p>After completing this course, students will be able to:<br />Create a technical design<br />Configure Common Data Service<br />Create and configure Power Apps<br />Configure business process automation<br />Extend the user experience<br />Extend the platform<br />Develop Integrations</p><p>The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.</p></div><div id="course-pills-2"><h4>Create a model-driven application in Power Apps</h4><ul><li>This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.</li></ul><h4>Get started using Common Data Service</h4><ul><li>This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.</li></ul><h4>Create a canvas app in Power Apps</h4><ul><li>This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.</li></ul><h4>Automate a business process using Power Automate</h4><ul><li>This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.</li></ul><h4>Create a business process flow in Power Automate</h4><ul><li>This module introduces you to creating business process flows in Power Automate</li></ul><h4>Introduction to developing with Power Platform</h4><ul><li>This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform</li></ul><h4>Extending the Power Platform user experience Model Driven apps</h4><ul><li>This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.</li></ul><h4>Create components with Power Apps Component Framework</h4><ul><li>This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.</li></ul><h4>Extending the Power Platform Common Data Service</h4><ul><li>This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.</li></ul><h4>Integrate with Power Platform and Common Data Service</h4><ul><li>This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.</li></ul><h4>Extend Power Apps portals</h4><ul><li>This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-400T00 Microsoft Power Platform Developer 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 PL-400T00 Microsoft Power Platform Developer 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 PL-900

Microsoft Power Apps

Power Apps

Microsoft Power Platform

Microsoft Power Automate

PL-400T00 Microsoft Power Platform Developer

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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>

Powerbi

Microsoft Power BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.</p><p></p><p></p><p>This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.</p><p></p>Prerequisites<p>To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces.</p></div><div id="course-pills-2"><h3>1 - Explore Azure App Service</h3> <ul> <li>Examine Azure App Service</li> <li>Examine Azure App Service plans</li> <li>Deploy to App Service</li> <li>Explore authentication and authorization in App Service</li> <li>Discover App Service networking features</li> </ul> <h3>2 - Configure web app settings</h3> <ul> <li>Configure application settings</li> <li>Configure general settings</li> <li>Configure path mappings</li> <li>Enable diagnostic logging</li> <li>Configure security certificates</li> </ul> <h3>3 - Scale apps in Azure App Service</h3> <ul> <li>Examine autoscale factors</li> <li>Identify autoscale factors</li> <li>Enable autoscale in App Service</li> <li>Explore autoscale best practices</li> </ul> <h3>4 - Explore Azure App Service deployment slots</h3> <ul> <li>Explore staging environments</li> <li>Examine slot swapping</li> <li>Swap deployment slots</li> <li>Route traffic in App Service</li> </ul> <h3>5 - Explore Azure Functions</h3> <ul> <li>Discover Azure Functions</li> <li>Compare Azure Functions hosting options</li> <li>Scale Azure Functions</li> </ul> <h3>6 - Develop Azure Functions</h3> <ul> <li>Explore Azure Functions development</li> <li>Create triggers and bindings</li> <li>Connect functions to Azure services</li> </ul> <h3>7 - Explore Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage</li> <li>Discover Azure Blob storage resource types</li> <li>Explore Azure Storage security features</li> <li>Discover static website hosting in Azure Storage</li> </ul> <h3>8 - Manage the Azure Blob storage lifecycle</h3> <ul> <li>Explore the Azure Blob storage lifecycle</li> <li>Discover Blob storage lifecycle policies</li> <li>Implement Blob storage lifecycle policies</li> <li>Rehydrate blob data from the archive tier</li> </ul> <h3>9 - Work with Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage client library</li> <li>Create a client object</li> <li>Manage container properties and metadata by using .NET</li> <li>Set and retrieve properties and metadata for blob resources by using REST</li> </ul> <h3>10 - Explore Azure Cosmos DB</h3> <ul> <li>Identify key benefits of Azure Cosmos DB</li> <li>Explore the resource hierarchy</li> <li>Explore consistency levels</li> <li>Choose the right consistency level</li> <li>Explore supported APIs</li> <li>Discover request units</li> </ul> <h3>11 - Work with Azure Cosmos DB</h3> <ul> <li>Explore Microsoft .NET SDK v3 for Azure Cosmos DB</li> <li>Create stored procedures</li> <li>Create triggers and user-defined functions</li> <li>Explore change feed in Azure Cosmos DB</li> </ul> <h3>12 - Manage container images in Azure Container Registry</h3> <ul> <li>Discover the Azure Container Registry</li> <li>Explore storage capabilities</li> <li>Build and manage containers with tasks</li> <li>Explore elements of a Dockerfile</li> </ul> <h3>13 - Run container images in Azure Container Instances</h3> <ul> <li>Explore Azure Container Instances</li> <li>Run containerized tasks with restart policies</li> <li>Set environment variables in container instances</li> <li>Mount an Azure file share in Azure Container Instances</li> </ul> <h3>14 - Implement Azure Container Apps</h3> <ul> <li>Explore Azure Container Apps</li> <li>Explore containers in Azure Container Apps</li> <li>Implement authentication and authorization in Azure Container Apps</li> <li>Manage revisions and secrets in Azure Container Apps</li> <li>Explore Dapr integration with Azure Container Apps</li> </ul> <h3>15 - Explore the Microsoft identity platform</h3> <ul> <li>Explore the Microsoft identity platform</li> <li>Explore service principals</li> <li>Discover permissions and consent</li> <li>Discover conditional access</li> </ul> <h3>16 - Implement authentication by using the Microsoft Authentication Library</h3> <ul> <li>Explore the Microsoft Authentication Library</li> <li>Initialize client applications</li> </ul> <h3>17 - Implement shared access signatures</h3> <ul> <li>Discover shared access signatures</li> <li>Choose when to use shared access signatures</li> <li>Explore stored access policies</li> </ul> <h3>18 - Explore Microsoft Graph</h3> <ul> <li>Discover Microsoft Graph</li> <li>Query Microsoft Graph by using REST</li> <li>Query Microsoft Graph by using SDKs</li> <li>Apply best practices to Microsoft Graph</li> </ul> <h3>19 - Implement Azure Key Vault</h3> <ul> <li>Explore Azure Key Vault</li> <li>Discover Azure Key Vault best practices</li> <li>Authenticate to Azure Key Vault</li> </ul> <h3>20 - Implement managed identities</h3> <ul> <li>Explore managed identities</li> <li>Discover the managed identities authentication flow</li> <li>Configure managed identities</li> <li>Acquire an access token</li> </ul> <h3>21 - Implement Azure App Configuration</h3> <ul> <li>Explore the Azure App Configuration service</li> <li>Create paired keys and values</li> <li>Manage application features</li> <li>Secure app configuration data</li> </ul> <h3>22 - Explore API Management</h3> <ul> <li>Discover the API Management service</li> <li>Explore API gateways</li> <li>Explore API Management policies</li> <li>Create advanced policies</li> <li>Secure APIs by using subscriptions</li> <li>Secure APIs by using certificates</li> </ul> <h3>23 - Explore Azure Event Grid</h3> <ul> <li>Explore Azure Event Grid</li> <li>Discover event schemas</li> <li>Explore event delivery durability</li> <li>Control access to events</li> <li>Receive events by using webhooks</li> <li>Filter events</li> </ul> <h3>24 - Explore Azure Event Hubs</h3> <ul> <li>Discover Azure Event Hubs</li> <li>Explore Event Hubs Capture</li> <li>Scale your processing application</li> <li>Control access to events</li> <li>Perform common operations with the Event Hubs client library</li> </ul> <h3>25 - Discover Azure message queues</h3> <ul> <li>Choose a message queue solution</li> <li>Explore Azure Service Bus</li> <li>Discover Service Bus queues, topics, and subscriptions</li> <li>Explore Service Bus message payloads and serialization</li> <li>Explore Azure Queue Storage</li> <li>Create and manage Azure Queue Storage and messages by using .NET</li> </ul> <h3>26 - Monitor app performance</h3> <ul> <li>Explore Application Insights</li> <li>Discover log-based metrics</li> <li>Instrument an app for monitoring</li> <li>Select an availability test</li> <li>Troubleshoot app performance by using Application Map</li> </ul> <h3>27 - Develop for Azure Cache for Redis</h3> <ul> <li>Explore Azure Cache for Redis</li> <li>Configure Azure Cache for Redis</li> <li>Interact with Azure Cache for Redis by using .NET</li> </ul> <h3>28 - Develop for storage on CDNs</h3> <ul> <li>Explore Azure Content Delivery Networks</li> <li>Control cache behavior on Azure Content Delivery Networks</li> <li>Interact with Azure Content Delivery Networks by using .NET</li> </ul></div>

AWS Certified Solutions Architect

AZ-204T00 Developing Solutions for Microsoft Azure

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p><p>This three-day instructor-led course is aimed at modern device management professionals looking to manage their enterprise devices using Microsoft Intune. This course will cover Enrolment, Application Management, Endpoint Security and Windows Autopilot as well as Azure Active Directory Conditional Access and Identity Protection. The delegates will learn how to enroll devices, deploy applications and manage them to maximize user productivity and device security.</p></div><div id="course-pills-2"><h3>1: Introduction to Microsoft Intune</h3> <ul> <li> Mobile Device Management</li> <li>Microsoft Intune</li> <li> Azure Active Directory</li> <li>AAD Identity Protection</li> <li> AAD Conditional Access</li></ul>  <h3>2: Microsoft Intune Device Management</h3><ul> <li>Enrolling Devices</li> <li> Device Compliance</li> <li> Device Profiles</li> <li>Device Updates</li></ul>  <h3>3: Microsoft Intune Application Management</h3><ul> <li> Application Management</li> <li> Deploying Applications</li> <li> Application Configuration</li> <li> Managing Applications</li> <li> Policy Sets and Guided Scenarios</li></ul>  <h3>4: Microsoft Intune Endpoint Security</h3><ul> <li> Security Baselines and tasks</li> <li> Antivirus</li> <li>Disk Encryption</li> <li>Firewall</li> <li>Atack Surface reduction</li> <li> Endpoint detection and response</li> <li> Account Protection</li></ul>  <h3>5: Deploying Windows with Windows Autopilot</h3><ul> <li> Windows Autopilot overview</li> <li> Preparing for Windows Autopilot deployment</li> <li>Deploying Windows 11 using Windows Autopilot</li></ul>  <h3>6: Microsoft Intune Additional and Premium Features</h3><ul> <li> Remote Help</li> <li> Tunnel for Mobile Application Management</li> <li>Endpoint Privilege Management</li> <li> Advanced Endpoint Analytics</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55399 Implementing and Managing Microsoft Intune 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 55399 Implementing and Managing Microsoft Intune 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>

Manager Training

55399 Implementing and Managing Microsoft Intune

3376 Courses delivered Online

B6155 IBM Cognos Analytics - Enterprise Administration (v11.0.x)

By Nexus Human

Oracle 12c - PL/SQL Fundamentals

By Nexus Human

B6255 IBM Cognos Analytics - Enterprise Administration (V11.1.x)

By Nexus Human

WNAI41 SAP Information Design Tool Delta 4.1

By Nexus Human

Microsoft Access for Office 365: Part 2

By Nexus Human

Intermediate SQL Custom 3-Day Private Class Outline

By Nexus Human

CEM-205 Manage Citrix Endpoint Management

By Nexus Human

B6008 Overview of IBM Cognos Analytics (v11.0)

By Nexus Human

Oracle 12c PL/SQL Fundamentals

By Nexus Human

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

By Nexus Human