11726 Courses in Cardiff delivered Online

The Level 3 Certificate in Assessing Vocational Achievement, also known as the Level 3 CAVA Assessor course, replaces the A1 course and is considered an industry-standard qualification for people looking to assess learners for accredited courses.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for all project managers and project team leaders. This class is intended for PMP?s looking to earn PDU's, or for Project Managers looking to learn more about Project Team Leadership techniques. Project success depends on choosing, motivating, and leading the project team. This course focuses on improving the project manager?s human resource expertise, from initial planning through project closure. Participants will apply all course principles to a work-related case study taken directly from their work environment. At course completion, students will be able to develop a human resource plan, acquire optimal team members, develop and motivate team members, and manage team members to accomplish project goals. NOTE: This course will earn you 14 PDUs. 1 - Project Teams Overview Project Human Resource Management Project Human Resources Management Processes Case Study Selection 2 - Develop Human Resource Plan Plan Human Resource Management Roles and Responsibilities Project Organizational Chart Staffing Management Plan Resource Histogram 3 - Acquire Project Team Acquire Project Team Overview Multi-Criteria Decision Analysis Acquire Contract Resources Optimize Virtual Teams Best Practices Social Identity Theory Virtual Teams and Social Identity Theory Team Building Activities for Virtual Teams Cultural Diversity Individualism and Communitarianism Perspectives of Time and Space Fate and Personal Responsibility Face and Saving Face Body Language Create Resource Calendars 4 - Develop Project Team Develop Project Team Overview Ground Rules Form, Storm, Norm, Perform, Adjourn Team Building Team Building ? Personality Profiles Collaborative, Delphi, Majority and Plurality Decision Making Recognition and Rewards Expectancy Theory Maslow?s Hierarchy Of Needs Operant Conditioning Team Performance Assessment 5 - Manage Project Team Manage Project Team Overview Performance Problems Challenging Stakeholders Stress Management Conflict Management and Resolution Views of Conflict Sources of Project Management Conflict Conflict Resolution Survey Conflict Resolution Techniques Additional course details: Nexus Humans Project Team Leadership 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 Project Team Leadership 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.

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.

The Level 4 Certificate for Higher Level Teaching Assistants (HLTA) is a UK OFQUAL accredited, 100% online, competency-based Teaching Assistant (TA) qualification.

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Product Owner Advanced™ training (PSPO Advanced) to master the role of a Product Owner. Learn how to advance your training of Product Ownership and apply it to deliver even more value. Course Description Agile techniques and the Scrum framework revolutionise project and product delivery, enabling teams to work faster and align closely with business needs. A product owner's role within this delivery is critical. Unlike traditional team managers, Product Owners focus on maximising product value rather than individual elements of project delivery. To excel in this role, product owners must combine business strategy with product vision and delivery roadmaps. The ability to operate within complex environments highlights the need for specific training and qualifications. Product Owner Advanced training is specifically designed to empower experienced Product Owners to deliver greater value. An exceptional Product Owner requires skillsets beyond core Agility and Scrum. These include clear decision-making, vision, communication, and influence. Practical experience is highly valued, and the PSPO 2 course emphasises interactive workshops, discussions, and exercises to provide a comprehensive understanding of the multifaceted Product Owner role. This course elevates existing Product Owners' capabilities, providing a clear path for your professional growth and delivering increased value to product stakeholders. Through collaborative and exploratory training, Product Owners' knowledge and experience will reach new heights, improving various aspects of your role. Key areas covered include: Deepening understanding of the Product Owner role, including product understanding, customer identification, and effective communication of product vision and strategy. Leveraging product vision and strategy to gain a competitive edge. Embracing diverse roles and stances essential for Product Owners. Enhancing stakeholder communication and management skills with a focus on different stakeholder groups. Navigating Agile governance, budgeting, and contracting within the Scrum framework. Scaling the Product Owner role for larger projects and products. By the end of this product owner advanced training, participants will be equipped to excel as Product Owners, driving success and value across their product journey. Why Train With Us? Develop advanced product owner skillsets that build on your existing knowledge of the Scrum framework and product owner accountabilities with our immersive two-day online PSPO Advanced course. Led by experienced industry professionals and support Professional Scrum Trainers & Product Owners, the course values team-based exercises and a hands-on learning experience. We help you grow within your Product Owner role through this advanced training, enabling you to better communicate product vision and strategy to teams, ultimately delivering higher value through projects and products with larger scopes. Who Should Attend This Course? The Professional Product Owner – Advanced course is designed for: Experienced Product Owners, ideally with at least one year of experience in the role Scrum Masters and stakeholders collaborating with Product Owners Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials

Discover Ethereum blockchain development with our comprehensive course. From the fundamentals of Solidity to advanced topics such as NFTs and Truffle, we will gain practical skills through hands-on projects. Whether a beginner or an experienced developer, this course equips us with the tools and knowledge to excel in Ethereum blockchain development.

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

This training is for lawyers and covers key topics to ensure compliance with the Lexcel standard and other regulations.

This workshop gives an opportunity to focus on the emotional needs of boys and how to meet these. We lift the lid on an emerging urgent inclusion issue,namely meeting the emotional needs of boys. Everyone knows a boy. They may be pupil, son, brother, parent or partner. Boys when they become adults are over represented in the prison, and mental health system. Course Category Meeting emotional needs Description This workshop gives an opportunity to focus on the emotional needs of boys and how to meet these. We lift the lid on an emerging urgent inclusion issue,namely meeting the emotional needs of boys. Everyone knows a boy. They may be pupil, son, brother, parent or partner. Boys when they become adults are over represented in the prison, and mental health system. In one recent year 1300 young men committed suicide in the UK. In the UK the commonest cause of death among those aged 16-35 is suicide. Three men for every one woman kill themselves every year (Guardian, June 2006). 1 in 4 women experience domestic violence and 2 women a week are killed by a current or ex partner. Boys and men are a major concern. We need to find ways to allow them to unclench their hearts and learn to experience, process, communicate and manage their own emotional lives for their own and for the good of the wider community. Testimonials ‘Thanks for a super day, lots of good ideas for our citizens of the future. We need to offer them the best and what we would offer our own children’?? ‘Enjoyed the day very much. Brilliant ideas and lots of food for thought. Will use the solution circle. A great tool!’ ‘went well and the ethos/participation was commendably facilititated. well done’. ‘Wonderful day!’ ‘Still getting lots of positive messages this end.’ Learning Objectives Increased understanding of boys’ emotional needs Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems Deeper understanding of core values surrounding inclusion of boys Opportunity to reflect on professional attitudes and behaviour towards boys and their emotional challenges New skills and processes to make boys’ inclusion and achievement more successful Who Is It For ? Early years and school based practitioners Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local authority support services Course Content The course explores the questions : Is there a problem with boys? What can we do to meet the emotional needs of boys? What helps? What should our priority be with boys? This workshop will explore: Cultural and historical expectations of boys in our society Shared experiences of teaching and parenting boys Circle of Courage as away of understanding emotional needs Fathers, mothers and sons Drinking and drugs: filling the emotional void Depression and suicide Anger and violence Solution Circle Problem Solving around boys needs What boys really need

This is a masterclass in managing emotions at work, leveraging the power of self-understanding along with effective conflict management strategies to achieve successful outcomes