<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Data Warehouse AdministratorDatabase Administrators</p>Overview<p>Use the Oracle Database tuning methodology appropriate to the available toolsUtilize database advisors to proactively tune an Oracle Database InstanceUse the tools based on the Automatic Workload Repository to tune the databaseDiagnose and tune common SQL related performance problemsDiagnose and tune common Instance related performance problemsUse Enterprise Manager performance-related pages to monitor an Oracle DatabaseGain an understanding of the Oracle Database Cloud Service</p><p>In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service.</p></div><div id="course-pills-2"><h4>Introduction</h4><ul><li>Course Objectives</li><li>Course Organization</li><li>Course Agenda</li><li>Topics Not Included in the Course</li><li>Who Tunes?</li><li>What Does the DBA Tune?</li><li>How to Tune</li><li>Tuning Methodology</li></ul><h4>Basic Tuning Diagnostics</h4><ul><li>Performance Tuning Diagnostics</li><li>Performance Tuning Tools</li><li>Tuning Objectives</li><li>Top Timed Events</li><li>DB Time</li><li>CPU and Wait Time Tuning Dimensions</li><li>Time Model</li><li>Dynamic Performance Views</li></ul><h4>Using Automatic Workload Repository</h4><ul><li>Automatic Workload Repository Overview</li><li>Automatic Workload Repository Data</li><li>Enterprise Manager Cloud Control and AWR</li><li>Snapshots</li><li>Reports</li><li>Compare Periods</li></ul><h4>Defining the Scope of Performance Issues</h4><ul><li>Defining the Problem</li><li>Limiting the Scope</li><li>Setting the Priority</li><li>Top SQL Reports</li><li>Common Tuning Problems</li><li>Tuning During the Life Cycle</li><li>ADDM Tuning Session</li><li>Performance Versus Business Requirements</li></ul><h4>Using Metrics and Alerts</h4><ul><li>Metrics and Alerts Overview</li><li>Limitation of Base Statistics</li><li>Benefits of Metrics</li><li>Viewing Metric History Information</li><li>Viewing Histograms</li><li>Server-Generated Alerts</li><li>Setting Thresholds</li><li>Metrics and Alerts Views</li></ul><h4>Using Baselines</h4><ul><li>Comparative Performance Analysis with AWR Baselines</li><li>Automatic Workload Repository Baselines</li><li>Moving Window Baseline</li><li>Baselines in Performance Page Settings</li><li>Baseline Templates</li><li>AWR Baseslines</li><li>Creating AWR Baselines</li><li>Managing Baselines with PL/SQL</li></ul><h4>Using AWR-Based Tools</h4><ul><li>Automatic Maintenance Tasks</li><li>ADDM Performance Monitoring</li><li>Using Compare Periods ADDM</li><li>Active Session History</li><li>New or Enhanced Automatic Workload Repository Views</li><li>Emergency Monitoring</li><li>Real-time ADDM</li></ul><h4>Real-Time Database Operation Monitoring</h4><ul><li>Overview</li><li>Use Cases</li><li>Defining a Database Operation</li><li>Scope of a Composite Database Operation</li><li>Database Operation Concepts</li><li>Identifying a Database Operation</li><li>Enabling Monitoring of Database Operations</li><li>Identifying, Starting, and Completing a Database Operation</li></ul><h4>Monitoring Applications</h4><ul><li>What is a Service?</li><li>Service Attributes</li><li>Service Types</li><li>Creating Services</li><li>Managing Services in a Single-Instance Environment</li><li>Where are Services Used?</li><li>Using Services with Client Applications</li><li>Services and Pluggable Databases</li></ul><h4>Identifying Problem SQL Statements</h4><ul><li>SQL Statement Processing Phases</li><li>Role of the Oracle Optimizer</li><li>Identifying Bad SQL</li><li>Top SQL Reports</li><li>SQL Monitoring</li><li>What is an Execution Plan?</li><li>Methods for Viewing Execution Plans</li><li>Uses of Execution Plans</li></ul><h4>Influencing the Optimizer</h4><ul><li>Functions of the Query Optimizer</li><li>Selectivity</li><li>Cardinality and Cost</li><li>Changing Optimizer Behavior</li><li>Optimizer Statistics</li><li>Extended Statistics</li><li>Controlling the Behavior of the Optimizer with Parameters</li><li>Enabling Query Optimizer Features</li></ul><h4>Reducing the Cost of SQL Operations</h4><ul><li>Reducing the Cost</li><li>Index Maintenance</li><li>SQL Access Advisor</li><li>Table Maintenance for Performance</li><li>Table Reorganization Methods</li><li>Space Management</li><li>Extent Management</li><li>Data Storage</li></ul><h4>Using SQL Performance Analyzer</h4><ul><li>Real Application Testing: Overview</li><li>Real Application Testing: Use Cases</li><li>SQL Performance Analyzer: Process</li><li>Capturing the SQL Workload</li><li>Creating a SQL Performance Analyzer Task</li><li>SQL Performance Analyzer: Tasks</li><li>Parameter Change</li><li>SQL Performance Analyzer Task Page</li></ul><h4>SQL Performance Management</h4><ul><li>Maintaining SQL Performance</li><li>Maintaining Optimizer Statistics</li><li>Automated Maintenance Tasks</li><li>Statistic Gathering Options</li><li>Setting Statistic Preferences</li><li>Restore Statistics</li><li>Deferred Statistics Publishing</li><li>Automatic SQL Tuning</li></ul><h4>Using Database Replay</h4><ul><li>Using Database Replay</li><li>The Big Picture</li><li>System Architecture</li><li>Capture Considerations</li><li>Replay Considerations: Preparation</li><li>Replay Considerations</li><li>Replay Options</li><li>Replay Analysis</li></ul><h4>Tuning the Shared Pool</h4><ul><li>Shared Pool Architecture</li><li>Shared Pool Operation</li><li>The Library Cache</li><li>Latch and Mutex</li><li>Diagnostic Tools for Tuning the Shared Pool</li><li>Avoiding Hard Parses</li><li>Reducing the Cost of Soft Parses</li><li>Sizing the Shared Pool</li></ul><h4>Tuning the Buffer Cache</h4><ul><li>Oracle Database Architecture: Buffer Cache</li><li>Buffer Cache: Highlights</li><li>Database Buffers</li><li>Buffer Hash Table for Lookups</li><li>Working Sets</li><li>Buffer Cache Tuning Goals and Techniques</li><li>Buffer Cache Performance Symptoms</li><li>Buffer Cache Performance Solutions</li></ul><h4>Tuning PGA and Temporary Space</h4><ul><li>SQL Memory Usage</li><li>Performance Impact</li><li>Automatic PGA Memory</li><li>SQL Memory Manager</li><li>Configuring Automatic PGA Memory</li><li>Setting PGA_AGGREGATE_TARGET Initially</li><li>Limiting the size of the Program Global Area (PGA)</li><li>SQL Memory Usage</li></ul><h4>Automatic Memory</h4><ul><li>Oracle Database Architecture</li><li>Dynamic SGA</li><li>Granule</li><li>Memory Advisories</li><li>Manually Adding Granules to Components</li><li>Increasing the Size of an SGA Component</li><li>Automatic Shared Memory Management: Overview</li><li>SGA Sizing Parameters: Overview</li></ul><h4>Performance Tuning Summary with Waits</h4><ul><li>Commonly Observed Wait Events</li><li>Additional Statistics</li><li>Top 10 Mistakes Found in Customer Systems</li><li>Symptoms</li></ul><h4>Oracle Database Cloud Service: Overview</h4><ul><li>Database as a Service Architecture, Features and Tooling</li><li>Software Editions: Included Database Options and Management Packs</li><li>Accessing the Oracle Database Cloud Service Console Automated Database Provisioning</li><li>Managing the Compute Node Associated With a Database Deployment</li><li>Managing Network Access to Database as a Service Scaling a Database Deployment</li><li>Performance Management in the Database Cloud Environment</li><li>Performance Monitoring and Tuning</li><li>What Can be Tuned in a DBCS Environment?</li></ul></div>

Nexus Human

Oracle Primavera

Oracle SQL

Oracle Business Intelligence

Oracle

Oracle 1Z0-819

Oracle Database

Oracle Database 12c - Performance Management and Tuning

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Data Warehouse Administrator<br />Database Administrators<br />Database Designers<br />Support Engineer<br />Technical Administrator</p>Overview<p>Back up, restore, and patch DBCS database deployments<br />Describe the DBaaS and on-premises Oracle Database architectures<br />Manage database instances<br />Manage UNDO data<br />Move data between databases<br />Implement basic backup and recovery procedures<br />Monitor and tune database performance<br />Tune SQL to improve performance<br />Manage resources with Oracle Database Resource Manager<br />Create pluggable databases (PDBs)<br />Configure the Oracle network environment<br />Administer user security and implement auditing<br />Create and manage tablespaces<br />Manage storage space<br />Create and manage Database as a Cloud Service (DBCS) database deployments<br />Register databases and manage performance with Enterprise Manager Cloud Control</p><p>The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide students with a firm foundation in administration of an Oracle Database. In this course students will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.</p></div><div id="course-pills-2"><h4>Exploring Oracle Database Architecture</h4><ul><li>Introducing Oracle Database</li><li>Relation Database Models</li><li>Oracle SQL and PL/SQL</li><li>Oracle Database Server Architecture</li><li>Connecting to Oracle Databases</li><li>Oracle Database Tools</li><li>Oracle-Supplied User Accounts</li><li>Querying the Oracle Data Dictionary</li></ul><h4>Managing Database Instances</h4><ul><li>Initialization Parameter Files</li><li>Starting Up Oracle Databases</li><li>Shutting Down Oracle Databases</li><li>Opening and Closing PDBs</li><li>Working with the Automatic Diagnostic Repository (ADR)</li><li>Querying Dynamic Performance Views</li></ul><h4>Creating PDBs</h4><ul><li>Methods and Tools to Create PDBs</li><li>Creating PDBs from Seed with SQL*Plus</li><li>Cloning PDBs with SQL*Plus</li><li>Unplugging and Pluggin In PDBs with SQL*Plus</li><li>Dropping PDBs with SQL*Plus</li></ul><h4>Configuring the Oracle Network Environment</h4><ul><li>Oracle Net Services</li><li>How Listeners Work</li><li>Configuring Listeners for Dynamic Service Registration</li><li>Configuring Listeners for Static Service Registration</li><li>Configuring Local Naming for Connections</li><li>Testing Oracle Net Connectivity with tnsping</li><li>Configuring Communication Between Databases</li><li>Dedicated Versus Shared Server Configurations</li></ul><h4>Administering User Security</h4><ul><li>Creating Users</li><li>Granting Privileges</li><li>Creating and Granting Roles</li><li>Revoking Privileges and Roles</li><li>Creating and Assigning Profiles</li><li>Authenticating Users</li><li>Assigning Quotas to Users</li><li>Applying the Principal of Least Privilege</li></ul><h4>Creating and Managing Tablespaces</h4><ul><li>How Table Data is Stored</li><li>Creating Tablespaces in SQL*Plus</li><li>Altering and Dropping Tablespaces in SQL*Plus</li><li>Viewing Tablespace Information in SQL*Plus</li><li>Implementing Oracle Managed Files</li><li>Moving and Renaming Online Data Files in SQL*Plus</li></ul><h4>Managing Storage Space</h4><ul><li>Oracle Database Space Management Features</li><li>Block Space Management</li><li>Row Chaining and Migration</li><li>Free Space Management Within Segments</li><li>Types of Segments</li><li>Allocating Extents</li><li>Understanding Deferred Segment Creation</li><li>Space-Saving Features</li></ul><h4>Managing UNDO Data</h4><ul><li>Undo Data: Overview</li><li>Transactions and Undo Data</li><li>Storing Undo Information</li><li>Comparing Undo Data and Redo Data</li><li>Managing Undo</li><li>Local Undo Mode Versus Shared Undo Mode</li><li>Configuring Undo Retention</li><li>Categories of Undo</li></ul><h4>Moving Data</h4><ul><li>Moving Data: General Architecture</li><li>Oracle Data Pump: Overview</li><li>Oracle Data Pump: Benefits</li><li>Data Pump Export and Import Clients</li><li>Data Pump Utility: Interfaces and Modes</li><li>Data Pump Import: Transformations</li><li>SQL*Loader Overview</li><li>Loading Methods</li></ul><h4>Backup and Recovery Concepts</h4><ul><li>DBA Responsibilities</li><li>Categories of Failure</li><li>Understanding Instance Recovery</li><li>Understanding Types of Backups</li><li>Comparing Complete and Incomplete Recovery</li><li>Oracle Data Protection Solutions</li><li>Flashback Technology</li></ul><h4>Monitoring and Tuning Database Performance</h4><ul><li>Managing Performance Activities</li><li>Performance Planning Considerations</li><li>Database Maintenance</li><li>Automatic Workload Repository (AWR)</li><li>Automatic Database Diagnostic Monitor</li><li>Performance Monitoring</li><li>Performance Tuning Methodology</li><li>Database Server Statistics and Metrics</li></ul><h4>SQL Tuning</h4><ul><li>SQL Tuning Process</li><li>Oracle Optimizer</li><li>Optimizer Statistics</li><li>SQL Plan Directives</li><li>Adaptive Execution Plans</li><li>SQL Tuning Advisor</li><li>SQL Access Advisor</li><li>SQL Performance Analyzer</li></ul><h4>Oracle Database Resource Manager</h4><ul><li>Oracle Database Resource Manager: Overview</li><li>Resource Manager Elements</li><li>Using Resource Manager to Allocate Resources</li><li>Creating a Simple Resource Plan</li><li>Creating a Complex Resource Plan</li><li>Using the Active Session Pool Feature</li><li>Limiting CPU Utilization at the Database Level</li><li>Limiting CPU Utilization at the Server Level</li></ul><h4>Enterprise Manager Cloud Control</h4><ul><li>Controlling the Enterprise Manager Cloud Control Framework</li><li>Starting the Enterprise Manager Cloud Control Framework</li><li>Stopping the Enterprise Manager Cloud Control Framework</li></ul><h4>Introduction to Oracle Database Cloud Service</h4><ul><li>Oracle Cloud: Overview</li><li>Database Cloud Service Offerings</li><li>DBCS Architecture</li><li>Features and Tooling</li><li>Additional Database Configuration Options</li></ul><h4>Creating DBCS Database Deployments</h4><ul><li>Automated Database Provisioning</li><li>Creating a Database Deployment</li><li>How SSH Key Pairs are Used</li><li>Creating an SSH Key Pair</li><li>Storage Used for Database Files</li></ul><h4>Managing DBCS Database Deployments</h4><ul><li>Cloud Tooling</li><li>Accessing Tools and Features from the DBCS Console</li><li>Managing the Compute Node Associated With a Database Deployment</li><li>Managing Network Access to DBCS</li><li>Enabling Access to a Compute Node Port</li><li>Scaling a Database Deployment</li></ul><h4>Backing Up and Restoring DBCS Database Deployments</h4><ul><li>Backing Up and Recovering Databases on DBCS</li><li>Backup Destination Choices</li><li>Backup Configuration</li><li>Creating an On-Demand Backup</li><li>Customizing the Backup Configuration</li><li>Performing Recovery by Using the Console</li><li>Performing Recovery by Using the dbaascli Utility</li></ul><h4>Patching DBCS Database Deployments</h4><ul><li>Patching DBCS</li><li>Using the DBCS Console to Manage Patches</li><li>Using the dbaascli Utility to Manage Patches</li></ul><h4>Creating Master Encryption Keys for PDBs</h4><ul><li>CDB and PDB Master Encryption Keys</li><li>Determining Whether You Need to Create and Activate and Encryption Key for a PDB</li><li>Creating and Activating an Encryption Key</li></ul><h4>Tablespace Encryption by Default</h4><ul><li>Tablespace Encryption by Default in DBCS</li><li>Transparent Data Encryption (TDE) Overview</li><li>Components of TDE</li><li>Using TDE</li><li>Defining the Keystore Location</li><li>Controlling Tablespace Encryption by Default</li><li>Managing the Software Keystore and Master Encryption Key</li><li>Managing the Keystore in CDBs and PDBs</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle Database 12c R2 - Administration Workshop Ed 3 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Oracle Database 12c R2 - Administration Workshop Ed 3 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

AWS Certified Database

Database Administration

Oracle Database 12c R2 - Administration Workshop Ed 3

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>In this course, students will learn how to establish routines, set goals, create an efficient environment, and use time-honored planning and organizational tools to use their time more effectively.</p>Overview<p>Upon successful completion of this course, students will take ownership of their time management in order to achieve their goals and lead a more productive life.</p><p>In this course, students will learn how to establish routines, set goals, create an efficient environment, and use time-honored planning and organizational tools to use their time more effectively.<br /></p></div><div id="course-pills-2"><h4>Getting Started</h4><ul><li>Icebreaker<br />Housekeeping Items<br />The Parking Lot<br />Workshop Objectives</li></ul><h4>Setting SMART Goals</h4><ul><li>The Three P's<br />The SMART Way<br />Prioritizing Your Goals<br />Evaluating and Adapting</li></ul><h4>The Power of Routines</h4><ul><li>What is a Routine?<br />Personal Routines<br />Professional Routines<br />Six Easy Ways to Simplify Your Life</li></ul><h4>Scheduling Yourself</h4><ul><li>The Simple Secret of Successful Time Management<br />Developing a Tracking System<br />Scheduling Appointments<br />Scheduling Tasks</li></ul><h4>Keeping Yourself on Top of Tasks</h4><ul><li>The One-Minute Rule<br />The Five-Minute Rule<br />What To Do When You Feel Like You're Sinking</li></ul><h4>Tackling New Tasks and Projects</h4><ul><li>Why We Procrastinate<br />Nine Ways to Overcome Procrastination<br />Eat That Frog!</li></ul><h4>Using Project Management Techniques</h4><ul><li>The Triple Constraint<br />Creating the Schedule<br />Using a RACI Chart</li></ul><h4>Creating a Workspace</h4><ul><li>Setting Up the Physical Layout<br />Ergonomics 101<br />Using Your Computer Efficiently</li></ul><h4>Organizing Files and Folders</h4><ul><li>Organizing Paper Files<br />Organizing Electronic Files<br />Scheduling Archive and Clean-Up</li></ul><h4>Managing E-Mail</h4><ul><li>Using E-mail Time Wisely<br />Taking Action!<br />Making the Most of Your E-mail Program<br />Taking Time Back from Handheld Devices</li></ul><h4>Tackling Procrastination</h4><ul><li>Why We Procrastinate<br />Nine Ways to Overcome Procrastination<br />Eat That Frog</li></ul><h4>Wrapping Up</h4><ul><li>Words from the Wise <br />Review of Parking Lot <br />Lessons Learned <br />Completion of Action Plans and Evaluations</li></ul></div>

Office Skills & Productivity

Time Management

Office Skills

Office Productivity

Management Skills

Personal Productivity

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is designed for 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 Office 365.</p>Overview<p>In this course, you will optimize an Access database.<br />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>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 covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification.</p></div><div id="course-pills-2"><h4>Improving Table Usability</h4><ul><li>Topic A: Create Lookups Within a Table</li><li>Topic B: Work with Subdatasheets</li></ul><h4>Creating Advanced Queries</h4><ul><li>Topic A: Create Query Joins</li><li>Topic B: Create Subqueries</li><li>Topic C: Summarize Data</li><li></li></ul><h4>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>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><li></li></ul><h4>Importing and Exporting Table Data</h4><ul><li>Topic A: Import and Link Data</li><li>Topic B: Export Data</li><li>Topic C: Create a Mail Merge</li></ul><h4>Using Queries to Manage Data</h4><ul><li>Topic A: Create Action Queries</li><li>Topic B: Create Unmatched and Duplicate Queries</li><li></li></ul><h4>Creating Complex Reports and Forms</h4><ul><li>Topic A: Create Subreports</li><li>Topic B: Create a Navigation Form</li><li>Topic C: Show Details in Subforms and Popup Forms</li></ul><h4>Creating Access Macros</h4><ul><li>Topic A: Create a Standalone Macro to Automate Repetitive Tasks </li><li>Topic B: Create a Macro to Program a User Interface Component </li><li>Topic C: Filter Records by Using a Condition</li><li>Topic D: Create a Data Macro</li></ul><h4>Using VBA to Extend Database Capabilities</h4><ul><li>Topic A: Introduction to VBA</li><li>Topic B: Using VBA with Form Controls</li><li></li></ul><h4>Managing a Database</h4><ul><li>Topic A: Back Up a Database</li><li>Topic B: Manage Performance Issues</li><li>Topic C: Document a Database</li></ul><h4>Distributing and Securing a Database</h4><ul><li>Topic A: Split a Database for Multiple-User Access</li><li>Topic B: Implement Security</li><li>Topic C: Convert an Access Database to an ACCDE File</li><li>Topic D: Package a Database with a Digital Signature</li></ul></div>

Microsoft Certification

Microsoft AZ-900

Microsoft AZ-104

Microsoft Access

Microsoft AZ-303

Microsoft AZ-700

Microsoft Access for Office 365 (Desktop or Online) - Part 2

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is designed for students looking to establish a foundational understanding of Microsoft Access for Office 365, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.</p>Overview<p>In this course, you will create and manage an Access database.<br />You will:<br />Navigate within the Access application environment, create a simple database, and customize Access configuration options.<br />Organize and manage data stored within Access tables.<br />Use queries to join, sort, and filter data from different tables.<br />Use forms to make it easier to view, access, and input data.<br />Create and format custom reports.</p><p>In this introductory course, you will discover the capabilities of MicrosoftÂ© AccessÂ©, a relational database application that can help you and your organization manage your complex data.</p></div><div id="course-pills-2"><h4>Working with an Access Database</h4><ul><li>Topic A: Launch Access and Open a Database</li><li>Topic B: Use Tables to Store Data</li><li>Topic C: Use Queries to Combine, Find, Filter, and Sort Data</li><li>Topic D: Use Forms to View, Add, and Update Data</li><li>Topic E: Use Reports to Present Data</li><li>Topic F: Get Help and Configure Options in Microsoft Access</li></ul><h4>Creating Tables</h4><ul><li>Topic A: Plan an Access Database</li><li>Topic B: Start a New Access Database</li><li>Topic C: Create a New Table</li><li>Topic D: Establish Table Relationships</li></ul><h4>Creating Queries</h4><ul><li>Topic A: Create Basic Queries</li><li>Topic B: Add Calculated Columns in a Query</li><li>Topic C: Sort and Filter Data in a Query</li></ul><h4>Creating Forms</h4><ul><li>Topic A: Start a New Form</li><li>Topic B: Enhance a Form</li></ul><h4>Creating Reports</h4><ul><li>Topic A: Start a New Report</li><li>Topic B: Enhance Report Layout</li></ul><h4>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>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></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Microsoft Access for Office 365 (Desktop or Online) - Part 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 Microsoft Access for Office 365 (Desktop or Online) - Part 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>

Online Course Creation

Microsoft 365

Trainers Course

Microsoft Access for Office 365 (Desktop or Online) - Part 1

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This is an Introductory level course for experienced Linux system administrators, DevOps engineers, infrastructure automation engineers, and systems design engineers.  Ideally students should have familiarity with basic Python scripting.  Attendees without programming skills can follow along with the scripting portion of the labs.</p>Overview<p>This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert practitioner attendees will explore how to:<br />Describe Ansible concepts and install Red Hat Ansible Engine (optional - we can pre-install is as well if desired, depending on the audience)<br />Deploy Ansible and Configure Ansible to manage hosts and run ad hoc Ansible commands.<br />Implement playbooks<br />Write a simple Ansible playbook and run it to automate tasks on multiple managed hosts.<br />Manage variables and facts<br />Write playbooks that use variables to simplify management of the playbook and facts to reference information about managed hosts.<br />Implement task control; Manage task control, handlers, and task errors in Ansible playbooks.<br />Deploy files to managed hosts<br />Deploy, manage, and adjust files on hosts managed by Ansible.<br />Manage large projects<br />Write playbooks that are optimized for larger, more complex projects.<br />Simplify playbooks with roles<br />Use Ansible roles to develop playbooks more quickly and to reuse Ansible code.<br />Troubleshoot Ansible<br />Troubleshoot playbooks and managed hosts.<br />Automate Linux administration tasks<br />Automate common Linux system administration tasks with Ansible</p><p>This lab-intensive course is geared toward those responsible for automation of configuration management; consistent and repeatable application deployment; provisioning and deployment of development, testing, and production servers; and integration with DevOps CI/CD workflows.  Throughout the course you will explore core Ansible features such as automatic provisioning, configuration management, service deployment and operational processes.</p></div><div id="course-pills-2"><h4>Ansible Overview</h4><ul><li>Overview of Architecture</li><li>Overview of Deployments</li><li>Inventory</li></ul><h4>Deploying Ansible</h4><ul><li>Installing</li><li>Configuration Files</li><li>Running Ad Hoc Commands</li><li>Dynamic Inventory</li></ul><h4>Playbooks</h4><ul><li>Writing YAML Files</li><li>Modules</li></ul><h4>Variables and Inclusions</h4><ul><li>Variables</li><li>Facts</li><li>Inclusions</li></ul><h4>Task Control</h4><ul><li>Constructing Flow Control</li><li>Handlers</li><li>Tags</li><li>Handling Errors</li></ul><h4>Jinja2 Templates</h4><ul><li>Jinja2 Templates</li><li>Jinja2 Templates</li></ul><h4>Roles</h4><ul><li>Role Structure</li><li>Creating Roles</li><li>Deploying Roles with Ansible Galaxy</li></ul><h4>Optimizing Ansible</h4><ul><li>Configuring Connection Types</li><li>Configuring Delegation</li><li>Configuring Parallelism</li></ul><h4>Ansible Vault</h4><ul><li>Configuring Ansible Vault</li><li>Executing with Ansible Vault</li></ul><h4>Troubleshooting Ansible</h4><ul><li>Troubleshooting Playbooks</li><li>Troubleshooting Managed Hosts</li></ul><h4>Ansible Tower</h4><ul><li>Ansible Tower overview</li><li>Installing</li><li>Account management</li><li>Hosts</li><li>Jobs</li></ul><h4>Optional: Ansible in a DevOps Environment</h4><ul><li>Provisioning Vagrant Machines</li><li>Deploying Vagrant in a DevOps Environment</li><li>Deploying Docker in a DevOps Environment</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Introduction to Ansible: Automation with Ansible (TTDV7580) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Introduction to Ansible: Automation with Ansible (TTDV7580) 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>

Introduction to Ansible: Automation with Ansible (TTDV7580)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform</p>Overview<p>This course teaches students the following skills:<br />Derive insights from data using the analysis and visualization tools on Google Cloud Platform<br />Interactively query datasets using Google BigQuery<br />Load, clean, and transform data at scale<br />Visualize data using Google Data Studio and other third-party platforms<br />Distinguish between exploratory and explanatory analytics and when to use each approach<br />Explore new datasets and uncover hidden insights quickly and effectively<br />Optimizing data models and queries for price and performance</p><p>Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course! This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing performance, query pricing, and data visualization. This specialization is intended for the following participants: Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform To get the most out of this specialization, we recommend participants have some proficiency with ANSI SQL.</p></div><div id="course-pills-2"><h4>Introduction to Data on the Google Cloud Platform</h4><ul><li>Highlight Analytics Challenges Faced by Data Analysts</li><li>Compare Big Data On-Premises vs on the Cloud</li><li>Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud</li><li>Navigate Google Cloud Platform Project Basics</li><li>Lab: Getting started with Google Cloud Platform</li></ul><h4>Big Data Tools Overview</h4><ul><li>Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools</li><li>Demo: Analyze 10 Billion Records with Google BigQuery</li><li>Explore 9 Fundamental Google BigQuery Features</li><li>Compare GCP Tools for Analysts, Data Scientists, and Data Engineers</li><li>Lab: Exploring Datasets with Google BigQuery</li></ul><h4>Exploring your Data with SQL</h4><ul><li>Compare Common Data Exploration Techniques</li><li>Learn How to Code High Quality Standard SQL</li><li>Explore Google BigQuery Public Datasets</li><li>Visualization Preview: Google Data Studio</li><li>Lab: Troubleshoot Common SQL Errors</li></ul><h4>Google BigQuery Pricing</h4><ul><li>Walkthrough of a BigQuery Job</li><li>Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs</li><li>Optimize Queries for Cost</li><li>Lab: Calculate Google BigQuery Pricing</li></ul><h4>Cleaning and Transforming your Data</h4><ul><li>Examine the 5 Principles of Dataset Integrity</li><li>Characterize Dataset Shape and Skew</li><li>Clean and Transform Data using SQL</li><li>Clean and Transform Data using a new UI: Introducing Cloud Dataprep</li><li>Lab: Explore and Shape Data with Cloud Dataprep</li></ul><h4>Storing and Exporting Data</h4><ul><li>Compare Permanent vs Temporary Tables</li><li>Save and Export Query Results</li><li>Performance Preview: Query Cache</li><li>Lab: Creating new Permanent Tables</li></ul><h4>Ingesting New Datasets into Google BigQuery</h4><ul><li>Query from External Data Sources</li><li>Avoid Data Ingesting Pitfalls</li><li>Ingest New Data into Permanent Tables</li><li>Discuss Streaming Inserts</li><li>Lab: Ingesting and Querying New Datasets</li></ul><h4>Data Visualization</h4><ul><li>Overview of Data Visualization Principles</li><li>Exploratory vs Explanatory Analysis Approaches</li><li>Demo: Google Data Studio UI</li><li>Connect Google Data Studio to Google BigQuery</li><li>Lab: Exploring a Dataset in Google Data Studio</li></ul><h4>Joining and Merging Datasets</h4><ul><li>Merge Historical Data Tables with UNION</li><li>Introduce Table Wildcards for Easy Merges</li><li>Review Data Schemas: Linking Data Across Multiple Tables</li><li>Walkthrough JOIN Examples and Pitfalls</li><li>Lab: Join and Union Data from Multiple Tables</li></ul><h4>Advanced Functions and Clauses</h4><ul><li>Review SQL Case Statements</li><li>Introduce Analytical Window Functions</li><li>Safeguard Data with One-Way Field Encryption</li><li>Discuss Effective Sub-query and CTE design</li><li>Compare SQL and Javascript UDFs</li><li>Lab: Deriving Insights with Advanced SQL Functions</li></ul><h4>Schema Design and Nested Data Structures</h4><ul><li>Compare Google BigQuery vs Traditional RDBMS Data Architecture</li><li>Normalization vs Denormalization: Performance Tradeoffs</li><li>Schema Review: The Good, The Bad, and The Ugly</li><li>Arrays and Nested Data in Google BigQuery</li><li>Lab: Querying Nested and Repeated Data</li></ul><h4>More Visualization with Google Data Studio</h4><ul><li>Create Case Statements and Calculated Fields</li><li>Avoid Performance Pitfalls with Cache considerations</li><li>Share Dashboards and Discuss Data Access considerations</li></ul><h4>Optimizing for Performance</h4><ul><li>Avoid Google BigQuery Performance Pitfalls</li><li>Prevent Hotspots in your Data</li><li>Diagnose Performance Issues with the Query Explanation map</li><li>Lab: Optimizing and Troubleshooting Query Performance</li></ul><h4>Advanced Insights</h4><ul><li>Introducing Cloud Datalab</li><li>Cloud Datalab Notebooks and Cells</li><li>Benefits of Cloud Datalab</li></ul><h4>Data Access</h4><ul><li>Compare IAM and BigQuery Dataset Roles</li><li>Avoid Access Pitfalls</li><li>Review Members, Roles, Organizations, Account Administration, and Service Accounts</li></ul></div>

Google Data Studio

Google Data Analytics

Business Analytics & Intelligence

Data Engineering

Big Data Analytics

Google Cloud

From Data to Insights with Google Cloud Platform

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Experienced system administrators and system integrators responsible for designing and implementing vRealize Automation</p>Overview<p>By the end of the course, you should be able to meet the following objectives:<br />Describe the vRealize Automation architecture and use cases in cloud environments<br />Manage vRealize Automation entities on VMware and third-party virtual and cloud infrastructures<br />Configure and manage Cloud Accounts, Projects, Flavor Mappings, Image Mappings, Network Profiles, Storage Profiles, Volumes, Tags, and Services<br />Create, modify, manage, and deploy Cloud Templates<br />Connect to a Kubernetes Cluster and manage namespaces<br />Customize services and virtual machines with cloudConfig<br />Configure and manage the Service Broker<br />Configure and manage ABX actions, custom properties, event broker subscriptions, and vRealize Orchestrator workflows<br />Integrate with vRealize Orchestrator<br />Install vRealize Automation with Lifecycle Configuration Manager<br />Describe Cloud Automation Services (Cloud Assembly and Code Stream).<br />Integrate Cloud Assembly with Terraform and SaltStack<br />Use logs and CLI commands to monitor and troubleshoot vRealize Automation</p><p>During this five-day course, you focus on installing, configuring, and managing VMware vRealizeÂ© Automation?. You learn about how vRealize Automation can be used to automate the delivery of virtual machines, applications, and personalized IT services across different data centers and hybrid cloud environments. The course covers how to manage both on-premise systems and cloud services. The course covers how vRealize Automation Service Broker can aggregate content in native formats from multiple clouds and platforms into a common catalog.  This course also covers interfacing vRealize Automation with other systems using VMware vRealizeÂ© Orchestrator? and how to use vRealize Automation to manage Kubernetes systems and leverage other systems. The course also covers integrating with Terraform and using SaltStack as a configuration management tool.</p></div><div id="course-pills-2"><h4>Course Introduction</h4><ul><li>Introductions and course logistics</li><li>Course objectives</li></ul><h4> vRealize Automation Overview and Architecture</h4><ul><li>Describe the purpose and functionality of vRealize Automation</li><li>Describe the vRealize Automation architecture</li><li>Describe the use of VMware Workspace ONEÂ© AccessTM</li><li>Describe the relationship between Kubernetes clusters, containers, and vRealize Automation services</li><li>Describe CLI commands for vRealize Automation 8 cluster management</li><li>Describe Cloud Assembly</li><li>Describe Service Broker</li><li>Describe Code Stream</li></ul><h4>Installing vRealize Automation</h4><ul><li>List the different vRealize Automation deployment types</li><li>Describe the purpose of vRealize easy installer</li><li>Describe the vRealize Automation installation process</li></ul><h4>Authentication and Authorization</h4><ul><li>Identity the steps involved in integrating Workspace One with Active Directory</li><li>Describe features of Workspace One</li><li>Describe the user roles available in vRealize Automation</li><li>Identify the key tasks performed by each user role</li><li>Define custom roles</li><li>Configure branding and multitenancy</li></ul><h4>Basic Initial Configuration</h4><ul><li>Quickly create a basic configuration with a cloud account, cloud zone, project, flavor mapping, and image mapping.</li></ul><h4>VMware Cloud Templates</h4><ul><li>Configure and deploy a basic cloud template</li><li>Create cloud templates that can run on any cloud</li><li>Use cloudConfig to run commands, install software, and create users</li><li>Use YAML for inputs, variables, and conditional deployments</li></ul><h4>Tags and Storage Configuration</h4><ul><li>Configure tags</li><li>Describe different types of tags</li><li>Manage tags</li><li>Configure storage profiles</li><li>Use tags and storage profiles</li></ul><h4>Integrating NSX-T Data Center</h4><ul><li>List the capabilities and use cases of NSX-T Data Center</li><li>Describe the NSX-T Data Center architecture and components</li><li>Integrate NSX-T Data Center with vRealize Automation</li><li>List the supported network profiles in vRealize Automation</li><li>Use NSX-T Data Center components to design a multitier application Cloud Template</li><li>Identify the network and security options available in design canvas</li><li>Create and manage on-demand networks and security groups</li><li>Configure NSX-T day 2 actions</li></ul><h4>Integrating with Public Clouds</h4><ul><li>Configure and use VMware Cloud Foundation accounts</li><li>Configure and use an AWS cloud account</li><li>Configure and use an Azure cloud account</li><li>Configure and use a Google Cloud Platform cloud account</li></ul><h4>Using Service Broker for Catalog Management</h4><ul><li>Release a VMware Cloud Template?</li><li>Define content source and content sharing</li><li>Define Service Broker policy enforcement</li><li>Use custom forms for catalog items</li></ul><h4>vRealize Automation Extensibility</h4><ul><li>Describe Extensibility</li><li>Use event topics</li><li>Create a subscription</li><li>Call a vRealize Orchestrator workflow</li><li>Create ABX actions</li></ul><h4>Using Code Stream </h4><ul><li>Introduction to Code Stream</li><li>The CI/CD process</li><li>Integrate GitLab with Code Stream and Cloud Assembly</li><li>Use Code Stream to install software</li></ul><h4>Using Terraform  </h4><ul><li>Integrate Cloud Assembly with Terraform</li><li>Use Terraform with a VMware Cloud Template</li><li>Use Terraform with Code Stream</li></ul><h4>Using Kubernetes Clusters</h4><ul><li>Introduction to Kubernetes</li><li>Connect to an existing Kubernetes Cluster</li><li>Integrate VMware Tanzu? Grid Integrated Edition</li><li>Create a Supervisor Namespace as a catalog item</li></ul><h4>Using SaltStack for Configuration Management </h4><ul><li>Introduction SaltStack with vRealize Automation</li><li>Use SaltStack for software deployment</li><li>Use SaltStack for configuration management</li><li>Use SaltStack with event-driven orchestration</li></ul><h4>vRealize Automation Troubleshooting and Integration</h4><ul><li>Location of logs</li><li>Using Activity</li><li>Monitoring deployment history</li><li>Basic troubleshooting</li><li>CLI commands</li><li>Collecting logs (VAMI console)</li><li>Integration with VMware vRealizeÂ© Log Insight?</li><li>Integration with vRealize Operations</li><li>Migrating vRealize Automation 7.x to 8</li></ul></div>

VMware Vsphere

AWS Certification

vSphere

AWS Certified Cloud Practitioner

Microsoft Virtual Academy (MVA)

AWS Certified Solutions Architect

VMware vRealize Automation: Install, Configure, Manage [v8.3]

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is for employees of Sun Life who want to expand their skills when using HUE to work with SQL databases.</p>Overview<p>Upon successful completion of this course, students will be able to better operate HUE when interacting with SQL databases.</p><p>In this course, students will learn additional skills when using HUE to interact with SQL databases.</p></div><div id="course-pills-2"><h4>Using Subqueries to Perform Advanced Querying</h4><ul><li>Search Based on Unknown Values</li><li>Compare a Value with Unknown Values</li><li>Search Based on the Existence of Records</li><li>Generate Output Using Correlated Subqueries</li><li>Filter Grouped Data Within Subqueries</li><li>Perform Multiple-Level Subqueries</li></ul><h4>Manipulating Table Data</h4><ul><li>Insert Data</li><li>Modify and Delete Data</li></ul><h4>Manipulating the Table Structure</h4><ul><li>Create a Table</li><li>Create a Table with Constraints</li><li>Modify a Table's Structure</li><li>Back Up Tables</li><li>Delete Tables</li></ul><h4>Working with Views</h4><ul><li>Create a View</li><li>Manipulate Data in Views</li><li>Create Aliases</li><li>Modify and Delete Views</li></ul><h4>Indexing Data</h4><ul><li>Create Indexes</li><li>Drop Indexes</li></ul><h4>Managing Transactions</h4><ul><li>Create Transactions</li><li>Commit Transactions</li></ul></div>

SQL Querying Fundamentals with HUE - Part 2

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is intended for SQL professionals, Microsoft Analysis Services cube and report developers, and business intelligence professionals.</p>Overview<p>?Understand common Analysis Services solutions.?Understand version changes of SSAS from 2008-2014.?Understand Analysis Services installation and architecture.?Understand how to choose the right model.?Understand the Analysis Services tools available.?Understand the multidimensional model.?Utilize data sources and data source views.?Create a cube.?Understand and utilize dimensions.?Understand and utilize attributes.?Understand and utilize relationships.?Understand and utilize hierarchies.?Understand and utilize measures and measure groups.?Understand and utilize calculated members.?Understand and utilize perspectives.?Understand and utilize translations.?Browse perspectives and translations.?Understand and utilize deployment options.?Understand and utilize processing strategies.?Understand and utilize security.?Deploy a multidimensional model.?Understand the tabular model.?Create a tabular project.?Analyze the data using Microsoft Excel.?Create and configure calculated measures and calculated fields.?Backup and Restore.</p><p>This course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution.</p></div><div id="course-pills-2"><h4>Course Overview</h4><ul><li>Introduction</li><li>Course Materials</li><li>Facilities</li><li>Prerequisites</li><li>What We'll Be Discussing</li><li>Lab 1: Course Overview</li></ul><h4>Introduction to Microsoft SQL Server Analysis Services</h4><ul><li>Common Analysis Services Solutions</li><li>Version Changes of SSAS from 2008-2014</li><li>Analysis Services Installation and Architecture: One Product, Two Models</li><li>Choosing the Right Model</li><li>Analysis Services Tools</li><li>Lab 1: Introduction to Microsoft SQL Server Analysis Services</li></ul><h4>The Multidimensional Solution</h4><ul><li>Understanding the Multidimensional Model</li><li>Utilizing Data Sources and Data Source Views</li><li>Creating a Cube</li><li>Lab 1: The Multidimensional Solution</li></ul><h4>Dissecting with Dimensions</h4><ul><li>Developing Dimensions</li><li>Utilizing Attributes</li><li>Relating with Relationships</li><li>Handling Hierarchies</li><li>Lab 1: Dissecting with Dimensions</li><li></li></ul><h4>Managing Measures</h4><ul><li>Measures and Measure Groups</li><li>Calculated Members</li><li>Lab 1: Managing Measures</li></ul><h4>Configuring Cube Options</h4><ul><li>Understanding Perspectives</li><li>Utilizing Translations</li><li>Browsing Perspectives and Translations</li><li>Lab 1: Configuring Cube Options</li></ul><h4>Deploying</h4><ul><li>Examining Deployment Options</li><li>Processing Strategies</li><li>Exploring Security</li><li>Lab 1: Deploying</li></ul><h4>The Tabular Solution </h4><ul><li>Understanding the Tabular Model</li><li>Creating a Tabular Project</li><li>Deploying</li><li>Browsing the Model</li><li>Querying the Solution and Understanding DAX</li><li>Maintaining and Optimizing</li><li>Lab 1: The Tabular Solution</li></ul></div>

SSRS

Business Analysis

Excel Analytics

Microsoft BI

Data Analyst

55125 Quick SQL Server Analysis Services

Advance your expertise in food safety management with our FSSC 22000 v6 Lead Auditor course, certified by CQI and IRCA. This comprehensive program is designed for professionals aiming to conduct first, second, and third-party audits of Food Safety Management Systems (FSMS) against the FSSC 22000 v6 standard.
This course offers in-depth training on the principles and practices of auditing, providing you with the skills needed to lead audit teams and evaluate the conformance and effectiveness of FSMS within organizations. You will learn how to plan, execute, report, and follow up on audits in alignment with ISO 19011 guidelines and ISO/IEC 17021 standards.
Key Features of the Course:
Certified Expertise: Obtain a globally recognized CQI and IRCA certification, significantly boosting your professional credibility in the food safety sector.
Expert-Led Training: Benefit from the knowledge of seasoned instructors with extensive experience in food safety management and auditing, who provide practical insights and real-world applications.
Hands-On Learning: Participate in interactive exercises, case studies, and role-playing scenarios that replicate real audit situations, ensuring that you can apply your skills directly in your workplace.
Comprehensive Coverage: Gain a thorough understanding of the FSSC 22000 v6 standard, audit methodologies, risk management, and the process approach to food safety.
Career Advancement: Ideal for those aspiring to become lead auditors, food safety managers, or consultants, this course opens doors to new professional opportunities and recognition in the industry.
Upon successful completion of the course and examination, you will receive the prestigious CQI and IRCA certification, recognized globally as a mark of excellence in food safety auditing. This qualification will enable you to conduct audits for certification bodies and support organizations in achieving compliance and continual improvement in food safety management.
Enroll in our FSSC 22000 v6 Lead Auditor course today and take the next step in your journey to becoming a leader in food safety management.

QUALITY ACADEMY

Food Safety

Accredited Food Hygiene

Quality Auditor

Accredited Food Safety

Become an FSSC 22000 v6 Lead Auditor with our CQI and IRCA certified course. Gain the skills to lead food safety management audits and elevate your career. Enroll today!

FSSC 22000 v6 Lead Auditor (CQI and IRCA Certified)

General Admission

Bournemouth

London Waterloo Academy

Dental Nurse

Dental Assistant

VIRTUAL DENTAL NURSING DIPLOMA

Registration Fee

Tuition Fee

Exam Fee

One Day Introduction Course

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Aims:&nbsp;</strong>To develop the exercise professional&rsquo;s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Outcome:</strong>&nbsp;You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Qualification Structure:</strong></span></p><ol start="1" type="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learners will cover:</span><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Key mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The relationships between mental health, society and lifestyle</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Legislation and government policy relating to mental health</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The role of national organisations relating to mental health</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Roles and boundaries of the people involved in programming physical activity for individuals with mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to motivate and support individuals with mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to evaluate the usefulness of a range of resources of information on mental health and its relationship to physical activity</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to evaluate the effectiveness of a range of mental health interventions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to program physical activity for individuals with mental health conditions How to deliver physical activity programmes to individuals with mental health conditions</li></ul></ol><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Entry Requirements:</strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">We recommend you hold an Exercise Referral Qualification</span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></div><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Assessments:</strong></span></div><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Theory paper</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Research worksheet</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Analysis task</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Knowledge questions</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Programme design</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Programme delivery</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Professional discussion (programme delivery)</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Evaluation of programme delivery</p></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div>

Aims: To develop the exercise professional’s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.
Outcome: You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.
Qualification Structure:
Learners will cover:
Key mental health conditions
The relationships between mental health, society and lifestyle
Legislation and government policy relating to mental health
The role of national organisations relating to mental health
Roles and boundaries of the people involved in programming physical activity for individuals with mental health conditions
How to motivate and support individuals with mental health conditions
How to evaluate the usefulness of a range of resources of information on mental health and its relationship to physical activity
How to evaluate the effectiveness of a range of mental health interventions
How to program physical activity for individuals with mental health conditions How to deliver physical activity programmes to individuals with mental health conditions
Entry Requirements:We recommend you hold an Exercise Referral QualificationAssessments:
Theory paper
Research worksheet
Analysis task
Knowledge questions
Programme design
Programme delivery
Professional discussion (programme delivery)
Evaluation of programme delivery

Platinum Training Institute

Physical Activity

Health

Mental Health

Aims: To develop the exercise professional’s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.

Outcome: You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.

YMCA Level 4 Certificate in Delivering Physical Activity for Individuals with Mental Health Conditions

Hi-Tech Training

CCTV

Hi-Tech Training Closed Circuit Television (CCTV) Installation Course is designed to give participants a practical knowledge of the operation and installation of CCTV systems at a foundation level.

CCTV Installation Course

Deposit Only

Full Price (including Deposit)

Burnley

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Would you like to develop further your practise of Reiki and learn about the Reiki Master symbol to be able to give advanced healing.</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This Reiki Master Practitioner level 3 course is for you if you would like to practise Reiki at a more advanced higher level. On this third level of Reiki training you are taught the Reiki Master symbol, and given a third empowerment or attunement.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">On this course you receive the fullest attention at this highest level of your Reiki training. I teach the course live online using Zoom. &nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What does this course offer?</strong></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">How to use the Reiki Master symbol</li><li fr-original-style="" style="box-sizing: border-box;">Dai Ko Myo symbol and mantra</li><li fr-original-style="" style="box-sizing: border-box;">Attunement to Reiki level 3 energy</li><li fr-original-style="" style="box-sizing: border-box;">Traditional Japanese Reiki cleansing techniques</li><li fr-original-style="" style="box-sizing: border-box;">How to compile your own Reiki Lineage</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">You will be initiated to the Reiki energy by a level 3 attunement and you will receive a full instruction manual and your course certificate will be awarded to you at the end of the course.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you receive the fullest attention at this highest level of your Reiki training. &nbsp;&nbsp;</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">I am a Reiki Master and teacher and I am one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your course.</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This course is for those of you who have completed your level 2 Reiki course and would like to participate in the greatest gift of being able to help heal others with Reiki.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">If you have completed your Reiki training elsewhere you may still do this course, just simply bring your Reiki Level 2 certificate with you or details of where you completed your training.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);">The course can be booked online here and you will receive instructions on how to access the course.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="box-sizing: border-box;">Testimonials:- What other students who have attended my courses are saying</em></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Reiki Master Level 3 Course</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&ldquo;Margaret&rsquo;s courses are always well thought through, full of valuable information, and easy to follow.&rdquo; (Sarah W)</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&ldquo;I loved the relaxed pace of this class and how I can refer back to the course work materials whenever I need&rdquo; (Charlotte Q)</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&ldquo;Margaret is a wonderful reiki master and she has been a joy to learn from!&rdquo; (Mark T)</p>

Would you like to develop further your practise of Reiki and learn about the Reiki Master symbol to be able to give advanced healing.
This Reiki Master Practitioner level 3 course is for you if you would like to practise Reiki at a more advanced higher level. On this third level of Reiki training you are taught the Reiki Master symbol, and given a third empowerment or attunement.
On this course you receive the fullest attention at this highest level of your Reiki training. I teach the course live online using Zoom. 
What does this course offer?
How to use the Reiki Master symbol
Dai Ko Myo symbol and mantra
Attunement to Reiki level 3 energy
Traditional Japanese Reiki cleansing techniques
How to compile your own Reiki Lineage
You will be initiated to the Reiki energy by a level 3 attunement and you will receive a full instruction manual and your course certificate will be awarded to you at the end of the course.
On this course you receive the fullest attention at this highest level of your Reiki training. 
I am a Reiki Master and teacher and I am one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your course.
This course is for those of you who have completed your level 2 Reiki course and would like to participate in the greatest gift of being able to help heal others with Reiki.
If you have completed your Reiki training elsewhere you may still do this course, just simply bring your Reiki Level 2 certificate with you or details of where you completed your training.
The course can be booked online here and you will receive instructions on how to access the course.
Testimonials:- What other students who have attended my courses are saying
Reiki Master Level 3 Course
“Margaret’s courses are always well thought through, full of valuable information, and easy to follow.” (Sarah W)
“I loved the relaxed pace of this class and how I can refer back to the course work materials whenever I need” (Charlotte Q)
“Margaret is a wonderful reiki master and she has been a joy to learn from!” (Mark T)

Margaret Cook - Learn More About Reiki

Energy Healing

Reiki

Reiki Healer

I am a Reiki Teacher in Manchester and one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your course. I teach all three levels of Reiki courses, level 1 reiki. level 2 reiki and reiki master level 3

Reiki Master Practitioner Level 3 Online Course

Manchester

Slough

Portsmouth

Bingley

Cardiff

Milton Keynes 

Nottingham

Birmingham

Bedford

<div data-testid="richTextElement" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">ONLINE STUDY - In your own time (approx. 6 hours study time) +</span></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Awarding Body:</strong>&nbsp;Open College Network (OCN) Credit for Learning</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Award Level:</strong>&nbsp;Level 3 (Advanced Level) - Ireland Level 5</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPD Certified:</strong>&nbsp;Yes (CPD Accreditation)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Minimum Age:&nbsp;</strong>18 (16 with parental consent)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry requirements:&nbsp;</strong>None. (English Level 2 desirable)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Training Locations:</strong>&nbsp;Study online + Classroom</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(255, 0, 0);">OCN Accredited at UK Level 3 (Ireland Level 5)</span><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 1 - Theory:</strong>&nbsp;Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 2 - Skills and Practical Development:</strong><br fr-original-style="" style="box-sizing: border-box;">Safely and competently set up and maintain a Peripheral IV Infusion.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Attend a classroom location to complete your practical training.<br fr-original-style="" style="box-sizing: border-box;"></strong></p><div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></p></div><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Itinerary:</strong></div><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></div><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 1 - THEORY (ONLINE)</strong><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M1 - Peripheral IV Cannulation - Introduction:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Definitions - understanding terminology relating to PIVC.<br fr-original-style="" style="box-sizing: border-box;">IV Therapy and NMC guidelines.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M2 - Legal &amp; Professional Responsibilities:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Legal Obligations and Accountability. Criminal, Civil and<br fr-original-style="" style="box-sizing: border-box;">Contractual law in Healthcare. Vicarious Liability and your<br fr-original-style="" style="box-sizing: border-box;">Duty of Care.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M3 - Anatomy &amp; Physiology:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Sites appropriate to IV cannulation. Hand vs. arm.<br fr-original-style="" style="box-sizing: border-box;">Advantages and disadvantages of relevant veins.<br fr-original-style="" style="box-sizing: border-box;">An overview of Homeostasis and Fluid Balance.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M4 - Hygiene and Infection Prevention &amp; Control (IPC):</strong></span><br fr-original-style="" style="box-sizing: border-box;">Reducing healthcare-associated infections. Keeping Safe.<br fr-original-style="" style="box-sizing: border-box;">Bloodborne Pathogens and Work Practice Controls.<br fr-original-style="" style="box-sizing: border-box;">Standard Precautions. Waste Disposal. Needle-stick injuries.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M5 - Indications and Advantages:</strong></span><br fr-original-style="" style="box-sizing: border-box;">When to cannulate, infusion types and benefits over<br fr-original-style="" style="box-sizing: border-box;">alternative infusion routes. Continuous and intermittent infusion.<br fr-original-style="" style="box-sizing: border-box;">Prophylactic use before procedures and in unstable patients.<br fr-original-style="" style="box-sizing: border-box;">Contraindications.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M6 - Equipment:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Cannula types, sizes and colour coding. How to select<br fr-original-style="" style="box-sizing: border-box;">appropriate size. Equipment overview for total procedure.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M7 - Vein Choice for Cannulation:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Correct vein selection. Which veins to avoid.<br fr-original-style="" style="box-sizing: border-box;">How to manage an unsuccessful cannulation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8 - Procedures:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Full procedure for cannulation including correct documentation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8: Guide to Cannulation - revision</strong></span><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8: Video - Recap with full procedure</strong></span><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M9 - Contraindications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">When inappropriate to cannulate including patients with specific health conditions.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M10 - Complications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">A detailed look at potential complications during and after<br fr-original-style="" style="box-sizing: border-box;">cannulation, including phlebitis, infections, petechiae and haematomas. Clinical signs and corrective actions.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED</strong><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">BEFORE JOINING US FOR YOUR PRACTICAL TRAINING</strong><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART 2 (CLASSROOM:</span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></strong><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">1 - Welcome, introductions and overview:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Classroom - registration and introductions.<br fr-original-style="" style="box-sizing: border-box;">Virtual Classroom - audio/visual checks and registration.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">2 - Legal &amp; Professional Responsibilities:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Overview and discussion.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">3 - Anatomy - key points (appropriate to PIVC):</strong></span><br fr-original-style="" style="box-sizing: border-box;">Arteries and veins. Selecting an approprate site. Sites to avoid and &ldquo;first choice&rdquo; sites.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">4 - Cannulae - selection and types:</strong></span><br fr-original-style="" style="box-sizing: border-box;">A detailed look at different types of cannulas, respective benefits and attributes. Selectinng an appropriate pVAD.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">5 - Complications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Complications of pVAD insertion including examples of<br fr-original-style="" style="box-sizing: border-box;">infiltration, haematoma, extravasation and transfixation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">6 - VIP Score:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Understanding and using the Visual Infusion Phlebitis score.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">7 - Equipment - overview:</strong></span><br fr-original-style="" style="box-sizing: border-box;">We take a look at all essential equipment required for PIVC.<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">8 - PRACTICAL SESSIONS:</strong><br fr-original-style="" style="box-sizing: border-box;">Multiple practical sessions throughout the session.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">9 - Fluids:</strong></span><br fr-original-style="" style="box-sizing: border-box;">The importance of understanding fluids. Includes detailed overview of: maintenance fluids, Hartmann&rsquo;s solution, Colloids (and risks), blood products.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">10 - Infusion Rates:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Calculating infusion rates and drops per minute.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.</em></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)</strong></em></p></div></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

ONLINE STUDY - In your own time (approx. 6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)



Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 3 (Advanced Level) - Ireland Level 5
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 3 (Ireland Level 5)

 
PART 1 - Theory: Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.

PART 2 - Skills and Practical Development:
Safely and competently set up and maintain a Peripheral IV Infusion.


Attend a classroom location to complete your practical training.


Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


Course Itinerary:
PART 1 - THEORY (ONLINE)
M1 - Peripheral IV Cannulation - Introduction:
Definitions - understanding terminology relating to PIVC.
IV Therapy and NMC guidelines.
M2 - Legal & Professional Responsibilities:
Legal Obligations and Accountability. Criminal, Civil and
Contractual law in Healthcare. Vicarious Liability and your
Duty of Care.
M3 - Anatomy & Physiology:
Sites appropriate to IV cannulation. Hand vs. arm.
Advantages and disadvantages of relevant veins.
An overview of Homeostasis and Fluid Balance.
M4 - Hygiene and Infection Prevention & Control (IPC):
Reducing healthcare-associated infections. Keeping Safe.
Bloodborne Pathogens and Work Practice Controls.
Standard Precautions. Waste Disposal. Needle-stick injuries.
M5 - Indications and Advantages:
When to cannulate, infusion types and benefits over
alternative infusion routes. Continuous and intermittent infusion.
Prophylactic use before procedures and in unstable patients.
Contraindications.
M6 - Equipment:
Cannula types, sizes and colour coding. How to select
appropriate size. Equipment overview for total procedure.
M7 - Vein Choice for Cannulation:
Correct vein selection. Which veins to avoid.
How to manage an unsuccessful cannulation.
M8 - Procedures:
Full procedure for cannulation including correct documentation.
M8: Guide to Cannulation - revision
M8: Video - Recap with full procedure
M9 - Contraindications:
When inappropriate to cannulate including patients with specific health conditions.
M10 - Complications:
A detailed look at potential complications during and after
cannulation, including phlebitis, infections, petechiae and haematomas. Clinical signs and corrective actions.

PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING

PART 2 (CLASSROOM:
1 - Welcome, introductions and overview:
Classroom - registration and introductions.
Virtual Classroom - audio/visual checks and registration.
2 - Legal & Professional Responsibilities:
Overview and discussion.
3 - Anatomy - key points (appropriate to PIVC):
Arteries and veins. Selecting an approprate site. Sites to avoid and “first choice” sites.
4 - Cannulae - selection and types:
A detailed look at different types of cannulas, respective benefits and attributes. Selectinng an appropriate pVAD.
5 - Complications:
Complications of pVAD insertion including examples of
infiltration, haematoma, extravasation and transfixation.
6 - VIP Score:
Understanding and using the Visual Infusion Phlebitis score.
7 - Equipment - overview:
We take a look at all essential equipment required for PIVC.
8 - PRACTICAL SESSIONS:
Multiple practical sessions throughout the session.
9 - Fluids:
The importance of understanding fluids. Includes detailed overview of: maintenance fluids, Hartmann’s solution, Colloids (and risks), blood products.
10 - Infusion Rates:
Calculating infusion rates and drops per minute.

This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.
 
(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)



Geopace Training

Allied Health Professions (AHP)

Intravenous Cannulation

Aesthetics

Medicine & Nursing

Venepuncture & Cannulation

Learn how to cannulate ...

    Nationally Recognised Qualification

    OCN Accredited - Level 3 (advanced) - Ireland Level 5

    CPD Accredited - The CPD Certification Service

    Classroom or Virtual Classroom options

    Covers all steps for cannulating in arm or hand

    Practise on artificial arms and fake blood!

    Essential qualification for all IV therapies

    Phlebotomy training desirable but not essential

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Peripheral I.V. Cannulation Course (GPT008)

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

Cisco Certified Network Associate (CCNA)

Certified in Cybersecurity (CC)

Cisco Certified Network Professional certification (CCNP)

CompTIA Network+

Cisco Certified Entry Networking Technician (CCENT)

Cisco Certified Internetwork Expert (CCIE)

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

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is for those who would like to start a business as a Colour Consultant. </p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is designed for trainees worldwide and is delivered over five colour modules plus one marketing module, each lasting four hours. Including homework, the complete course will take up approximately 30 hours of your time.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">There are no prerequisites for signing up for this course, we will take you through all the theory and practical sessions, building your knowledge and confidence in the subjects.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our virtual approach to training means that you really do have the best seat in the house!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">All of the sessions are conducted &lsquo;live&rsquo; and online by your Colour Me Beautiful trainer. Classes are kept deliberately small to enhance your learning; maximum number 4.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Immediately after your virtual training you will have the flexibility to run your own&nbsp;Colour Me Beautiful&nbsp;business as a colour consultant, meaning you can start to earn money straight away.</p><div style="color: rgb(10, 10, 10); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(10, 10, 10);"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">TOPICS</h5></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" fr-original-style=" color: rgb(10, 10, 10);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">The History of Colour Me Beautiful</li><li fr-original-style="" style="box-sizing: border-box;">The Colour Me Beautiful System</li><li fr-original-style="" style="box-sizing: border-box;">Dominant Colour Types</li><li fr-original-style="" style="box-sizing: border-box;">Understanding colour terms</li><li fr-original-style="" style="box-sizing: border-box;">Draping techniques for women &amp; men</li><li fr-original-style="" style="box-sizing: border-box;">Practise on volunteers</li><li fr-original-style="" style="box-sizing: border-box;">Cosmetic colour selection and application</li><li fr-original-style="" style="box-sizing: border-box;">Conducting a consultation</li><li fr-original-style="" style="box-sizing: border-box;">Setting up and marketing your business</li><li fr-original-style="" style="box-sizing: border-box;">How to conduct group presentations</li></ul><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">As well as training in colour, we also include business and marketing, sales and presentation skills, along with ongoing training to enhance your skills.</span></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(10, 10, 10);"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">By the end of this course you will</h5></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" fr-original-style=" color: rgb(10, 10, 10);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Be confident in assessing the dominant colouring using the Colour Me Beautiful system</li><li fr-original-style="" style="box-sizing: border-box;">Be able to conduct a colour analysis using the dominant colours</li><li fr-original-style="" style="box-sizing: border-box;">Be confident in applying a simple make-up routine to your client</li><li fr-original-style="" style="box-sizing: border-box;">Have the required knowledge to market your business</li><li fr-original-style="" style="box-sizing: border-box;">Understand the Colour Me Beautiful back office procedures</li></ul><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">You will receive</strong></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" fr-original-style=" color: rgb(10, 10, 10);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">20 hours of live online colour tuition with your tutor</li><li fr-original-style="" style="box-sizing: border-box;">4 hours live online business &amp; marketing training</li><li fr-original-style="" style="box-sizing: border-box;">Starter Kit</li><li fr-original-style="" style="box-sizing: border-box;">Comprehensive training manual</li><li fr-original-style="" style="box-sizing: border-box;">Certificate upon completion</li><li fr-original-style="" style="box-sizing: border-box;">Trade account</li><li fr-original-style="" style="box-sizing: border-box;">Access to the consultant support forum</li><li fr-original-style="" style="box-sizing: border-box;">Access to consultant lounge</li><li fr-original-style="" style="box-sizing: border-box;">International directory listing</li><li fr-original-style="" style="box-sizing: border-box;">12 months Colour Me Beautiful licence upon course completion</li></ul></div></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div>

Colour Me Beautiful

Beauty Specialist

Color Theory

Cosmetics

Beauty & Makeup

Beauty Therapy

Learn the foundation to colour analysis with this 5 day live and online, interactive course

Intermediate Colour Analysis

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>

50872 Courses delivered Online

Oracle Database 12c - Performance Management and Tuning

By Nexus Human

Oracle Database 12c R2 - Administration Workshop Ed 3

By Nexus Human

Personal Productivity

By Nexus Human

Microsoft Access for Office 365 (Desktop or Online) - Part 2

By Nexus Human

Microsoft Access for Office 365 (Desktop or Online) - Part 1

By Nexus Human

Introduction to Ansible: Automation with Ansible (TTDV7580)

By Nexus Human

From Data to Insights with Google Cloud Platform

By Nexus Human

VMware vRealize Automation: Install, Configure, Manage [v8.3]

By Nexus Human

SQL Querying Fundamentals with HUE - Part 2

By Nexus Human

55125 Quick SQL Server Analysis Services

By Nexus Human