1747 Courses in Cardiff delivered Live Online

Modern calligraphy online workshop by CalligrAbility, for beginners and improvers. Perfect style for stationary, bullet journalling and greeting cards. Three-hour online session with recording available for a month. £40 enrolment fee and a basic calligraphy kit available for an extra £15.

Duration 5 Days 30 CPD hours Overview Mining data Manipulating data Visualizing and reporting data Applying basic statistical methods Analyzing complex datasets while adhering to governance and quality standards throughout the entire data life cycle CompTIA Data+ is an early-career data analytics certification for professionals tasked with developing and promoting data-driven business decision-making. CompTIA Data+ gives you the confidence to bring data analysis to life. As the importance for data analytics grows, more job roles are required to set context and better communicate vital business intelligence. Collecting, analyzing, and reporting on data can drive priorities and lead business decision-making. 1 - Identifying Basic Concepts of Data Schemas Identify Relational and Non-Relational Databases Understand the Way We Use Tables, Primary Keys, and Normalization 2 - Understanding Different Data Systems Describe Types of Data Processing and Storage Systems Explain How Data Changes 3 - Understanding Types and Characteristics of Data Understand Types of Data Break Down the Field Data Types 4 - Comparing and Contrasting Different Data Structures, Formats, and Markup Languages Differentiate between Structured Data and Unstructured Data Recognize Different File Formats Understand the Different Code Languages Used for Data 5 - Explaining Data Integration and Collection Methods Understand the Processes of Extracting, Transforming, and Loading Data Explain API/Web Scraping and Other Collection Methods Collect and Use Public and Publicly-Available Data Use and Collect Survey Data 6 - Identifying Common Reasons for Cleansing and Profiling Data Learn to Profile Data Address Redundant, Duplicated, and Unnecessary Data Work with Missing Value Address Invalid Data Convert Data to Meet Specifications 7 - Executing Different Data Manipulation Techniques Manipulate Field Data and Create Variables Transpose and Append Data Query Data 8 - Explaining Common Techniques for Data Manipulation and Optimization Use Functions to Manipulate Data Use Common Techniques for Query Optimization 9 - Applying Descriptive Statistical Methods Use Measures of Central Tendency Use Measures of Dispersion Use Frequency and Percentages 10 - Describing Key Analysis Techniques Get Started with Analysis Recognize Types of Analysis 11 - Understanding the Use of Different Statistical Methods Understand the Importance of Statistical Tests Break Down the Hypothesis Test Understand Tests and Methods to Determine Relationships Between Variables 12 - Using the Appropriate Type of Visualization Use Basic Visuals Build Advanced Visuals Build Maps with Geographical Data Use Visuals to Tell a Story 13 - Expressing Business Requirements in a Report Format Consider Audience Needs When Developing a Report Describe Data Source Considerations For Reporting Describe Considerations for Delivering Reports and Dashboards Develop Reports or Dashboards Understand Ways to Sort and Filter Data 14 - Designing Components for Reports and Dashboards Design Elements for Reports and Dashboards Utilize Standard Elements Creating a Narrative and Other Written Elements Understand Deployment Considerations 15 - Understand Deployment Considerations Understand How Updates and Timing Affect Reporting Differentiate Between Types of Reports 16 - Summarizing the Importance of Data Governance Define Data Governance Understand Access Requirements and Policies Understand Security Requirements Understand Entity Relationship Requirements 17 - Applying Quality Control to Data Describe Characteristics, Rules, and Metrics of Data Quality Identify Reasons to Quality Check Data and Methods of Data Validation 18 - Explaining Master Data Management Concepts Explain the Basics of Master Data Management Describe Master Data Management Processes Additional course details: Nexus Humans CompTIA Data Plus (DA0-001) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the CompTIA Data Plus (DA0-001) 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. 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.

Make your goals and dreams reality in 2023: Create a Vision Board

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the 55232 Writing Analytical Queries for Business Intelligence 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. 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.

In this course we explore Mental Health and address how such needs can be met in mainstream classrooms. Course Category Behaviour and Relationships Meeting Emotional Needs Description This is our lead workshop/training day on understanding mental health, behaviour and relationship work in schools other settings and is both a values primer and a practical guide to successful innovative strategies for improving behaviour and strengthening relationships for challenging children and young people of all ages. Not just another day on ‘Behaviour Management’ – Our Mental Health Day goes well beyond a rewards and sanctions approach to ‘behaviour’. We will be focused on those young people for whom rewards and punishments do not always work and who confuse the adults who work with them. We aim to take a relationships-based approach and to give those attending an opportunity to think more deeply about why young people do the things they do and what our part as adults is in creating, sustaining and changing these behaviours. The day gives those present opportunities to reflect on their attitudes and practice in relation to children’s behaviour and relationship building.   If your usual approaches to managing tackling mental health needs aren’t working with particular individuals then take a tour through this range of cutting edge strategies for bringing about positive behaviour change, and for meeting challenging emotional needs  Learning Objectives reinforce and affirm good practice re-energise, stimulate and challenge thinking about inclusion of challenging pupils and children increased understanding of mental health increased confidence in managing challenging pupils in mainstream schools access to a wider range of practical strategies to impact on behaviour problems opportunity to reflect on professional attitudes and behaviour towards mental health in families and pupils Who Is It For ?  Anyone concerned with understanding and meeting emotional and mental health needs  Course Content Circle of Courage – belonging-achievement-generosity – independence – model for understanding mental health Compass of Anxiety – understanding and going deeper Active listening – Listening to the person underneath the behaviour Involving other children and young people in solutions and interventions - Circles of friends: peer support, counselling and mediation Team Problem Solving – Solution Circles: a 30 minute group problem solving process to get Teams ‘unstuck’ and to generate positive first action steps Restorative justice and restitution: principles and practice of this approach to repairing harm and restoring relationships without reliance on punishment Understanding the effects of Separation, Loss, Trauma and Neglect on children’s learning and relationships in school and what adults can do to reach and support these children

Restorative Interventions in Schools A “Restorative Solution” is a non-adversarial approach to conflict resolution where the person who has done something wrong in a given situation becomes accountable to those s/he has harmed. This person is then given the opportunity to “make up” for their inappropriate behaviour through agreement and reparation. An intervention can involve a formal conference, or it can be a simple conversation on a corridor or playground. Restorative Interventions work with all ages of young people, and the techniques can be used in parental meetings, can prevent exclusions and challenge poor behaviour. Our feedback tells us that when problems between young people are addressed in this way, those problems rarely reoccur. Course Category Behaviour and Relationships Teaching and Learning Description Restorative Interventions in Schools A “Restorative Solution” is a non-adversarial approach to conflict resolution where the person who has done something wrong in a given situation becomes accountable to those s/he has harmed. This person is then given the opportunity to “make up” for their inappropriate behaviour through agreement and reparation. An intervention can involve a formal conference, or it can be a simple conversation on a corridor or playground. Restorative Interventions work with all ages of young people, and the techniques can be used in parental meetings, can prevent exclusions and challenge poor behaviour. Our feedback tells us that when problems between young people are addressed in this way, those problems rarely reoccur. Also Available on line– self paced learning… give it a try! Testimonials ‘Interesting. A different approach. Another ‘weapon’ in the armoury. Will try to use.’ ‘Made me think how I can approach confrontations differently. Useful, reminded me where my focus should be and that things will be difficult at times, but that’s no excuse to stay in the comfort zone!’ ‘Excellent day. Lots of ideas to take away and use on a daily basis. Thanks.’ ‘Nice to do some work on behaviour without sanctions and restraints in mind’ Learning Objectives To introduce participants to Restorative Interventions To develop understanding of value and role in developing inclusive practice of Restorative Interventions To develop and practise Restorative Intervention skills processes Opportunity to reflect on professional practice Mutual support established with other ‘front line’ practitioners Who Is It For ? Multi Agency Teams Social workers CAMHS teams Year Managers Primary and secondary staff Early Years and School based Practitioners Heads and Deputies SENCOs Advanced Skills Teachers Primary and secondary teachers Local Authority Support Services Course Content This can be introduced in one day or as a workshop but is better offered over a series of sessions. The course answers the questions: What should we do if rewards and punishments do not work? Can we find an alternative process to recommending permanent exclusion or special unit or school placement? Struggling with a child for whom praise and sanctions seem ineffective? Want to develop a more restorative school or team? I need a process which works with relationships not just behaviour. What will work for our relationships policy? This day’s training will enable participants to facilitate Short Restorative Conferences, and will suggest ways of working with young people and others that will help to repair broken relationships, and challenge some difficult behaviour. Including all those affected by an incident in its resolution is a powerful way of producing significant improvements in behaviour. We will cover: What are restorative solutions? Background and detailed teaching of processes Inclusion values underpinning this work Processes modelled and opportunities to try process out Practical setting up of restorative conferences Stories and outcomes

Duration 1 Days 6 CPD hours This course is intended for This course is intended for individuals who desire to supervise others more effectively. Overview Upon successful completion of this course, students will be equipped to supervise others more effectively and efficiently, contributing to job satisfaction and productivity. In this course, students will develop the skills required to be more efficient and proficient supervisors. 1 - GETTING STARTED Icebreaker Housekeeping Items The Parking Lot Workshop Objectives 2 - SETTING EXPECTATIONS Defining the Requirements Identifying Opportunities for Improvement and Growth Setting Verbal Expectations Putting Expectations in Writing 3 - SETTING GOALS Understanding Cascading Goals The SMART Way Helping Others Set Goals 4 - ASSIGNING WORK General Principles The Dictatorial Approach The Apple-Picking Approach The Collaborative Approach 5 - DEGREES OF DELEGATION Level One: Complete Supervision Level Two: Partial Supervision Level Three: Complete Independence 6 - IMPLEMENT DELEGATION Deciding to Delegate To Whom Should You Delegate? Providing Instructions Monitoring the Results Troubleshooting Delegation 7 - PROVIDING FEEDBACK Characteristics of Good Feedback Feedback Delivery Tools Informal Feedback Formal Feedback 8 - MANAGING YOUR TIME The 80/20 Rule Prioritizing with the Urgent-Important Matrix Using a Productivity Journal Using Routines and Rituals to Simplify Your Workday 9 - RESOLVING CONFLICT Using a conflict Resolution Process Maintaining Fairness Seeking help from Within the Team Seeking Help for Outside the Team 10 - TIPS FOR SPECIAL SITUATIONS What to Do If You?ve Been Promoted from within the Team What to Do If You're Leading a Brand New Team What to Do if You're Taking on an Established Team 11 - A SURVIVAL GUIDE FOR THE NEW SUPERVISOR Ask the Right Questions of the Right People Go to Gemba Keep Learning 12 - WRAPPING UP Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations

With Sarah Hannah Introduction With the recent resurgence of period dramas both on stage and especially on the screen, the demand for ‘Classically Trained’ actors has never been greater. Changes in the way we audition has also seen an increase in actors being called upon to audition and self-tape with Shakespearean monologues leaving many actors intimidated and uncertain about how to best prepare. Ideal for actors of all ability, this online workshop will teach you all of the basic rules for acting in verse, perfect for any period drama work on screen… and then learn how Shakespeare and others break the rules! What these ‘rule breaks’ are for and the amazing help that this gives you when speaking these lines and bringing your character to life. This course can be complimented by our Secrets of Acting Shakespeare: First Folio Technique course. Meet Your Tutor Sarah Hannah Actress, Acting and Audition Coach Sarah Hannah is a highly experienced professional actress, acting and audition coach. Bringing her extensive experience of working on stage and screen, Sarah will focus on enhancing your passion and understanding of the works of William Shakespeare. Course Outline *You will be sent a pdf worksheet for this workshop that you will need to write on. It is therefore recommended that you print it out if you can. A strong internet connection is required to join our live online courses and workshops. Please test your connection before booking as we cannot refund due to technical issues. Please familarise yourself with Zoom before attending your workshop. Your camera will be required to be switch on during the workshop. Additional Information Features Suitable if you are (17 yrs+) and looking to discover Shakespeare Attracts a varied age range from 17 yrs+. International Students Welcome The course is taught in English, so it is important that you have proficient English language skills Learning Outcomes Appreciate a deeper understanding of Shakespeare Course Location Held Online Via Zoom

The mentorship program for all wedding photographer, from one of the worlds top 100. A course aimed around your interests and bespoke to you, from portfolio critique to business review with the option of joining me on a shoot.

Duration 2 Days 12 CPD hours This course is intended for The target audience for the DevSecOps Foundation course are professionals including: Anyone involved or interested in learning about DevSecOps strategies and automation Anyone involved in Continuous Delivery toolchain architectures Compliance Team Business managers Delivery Staff DevOps Engineers IT Managers IT Security Professionals, Practitioners, and Managers Maintenance and support staff Managed Service Providers Project & Product Managers Quality Assurance Teams Release Managers Scrum Masters Site Reliability Engineers Software Engineers Testers Overview You will learn: The purpose, benefits, concepts, and vocabulary of DevSecOps How DevOps security practices differ from other security approaches Business-driven security strategies and Best Practices Understanding and applying data and security sciences Integrating corporate stakeholders into DevSecOps Practices Enhancing communication between Dev, Sec, and Ops teams How DevSecOps roles fit with a DevOps culture and organization In this course, students will gain a solid understanding of how DevSecOps provides business value, enhancing your business opportunities, and improving corporate value. The core DevSecOps principles taught can support an organizational transformation, increase productivity, reduce risk, and optimize resource usage. This course explains how DevOps security practices differ from other approaches then delivers the education needed to apply changes to your organization. Participants learn the purpose, benefits, concepts, vocabulary and applications of DevSecOps. Most importantly, students learn how DevSecOps roles fit with a DevOps culture and organization. At the course?s end, participants will understand ?security as code? to make security and compliance value consumable as a service. This course prepares you for the DevSecOps Foundation (DSOF) certification. Realizing DevSecOps Outcomes Origins of DevOps Evolution of DevSecOps CALMS The Three Ways Defining the Cyberthreat Landscape What is the Cyber Threat Landscape? What is the threat? What do we protect from? What do we protect, and why? How do I talk to security? Building a Responsive DevSecOps Model Demonstrate Model Technical, business and human outcomes What?s being measured? Gating and thresholding Integrating DevSecOps Stakeholders The DevSecOps State of Mind The DevSecOps Stakeholders What?s at stake for who? Participating in the DevSecOps model Establishing DevSecOps Best Practices Start where you are Integrating people, process and technology and governance DevSecOps operating model Communication practices and boundaries Focusing on outcomes Best Practices to get Started The Three Ways Identifying target states Value stream-centric thinking DevOps Pipelines and Continuous Compliance The goal of a DevOps pipeline Why continuous compliance is important Archetypes and reference architectures Coordinating DevOps Pipeline construction DevSecOps tool categories, types and examples Learning Using Outcomes Security Training Options Training as Policy Experiential Learning Cross-Skilling The DevSecOps Collective Body of Knowledge Preparing for the DevSecOps Foundation certification exam Additional course details: Nexus Humans DevSecOps Foundation (DevOps Institute) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the DevSecOps Foundation (DevOps Institute) 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. 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.