370 Courses in Cardiff delivered Live Online

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

Learn how to work with data using Python (the coding language) as a tool. Learn how data is structured and how to manipulate it into a usable, clean form ready for analysis. Work on a small real-life project from conception to solution, in a team or on your own.

Scrum Product Owner Exam Prep: Virtual In-House Training This workshop prepares you for the Scrum.org PSPO™ I certification. A voucher for the exam and the access information you will need to take the exam will be provided to you via email after you have completed the course. NOTE: If you have participated in any of IIL's other Scrum workshops, you can bypass this program and focus on reading/studying the Scrum Guide and taking practice exams from Scrum.org The Product Owner is responsible for maximizing the value of the product and the work of the Development Team. The Product Owner must be knowledgeable, available, and empowered to make decisions quickly in order for an Agile project to be successful. The Product Owner's key accountability is the Product Backlog. Managing, maintaining, and evolving the Product Backlog involves: Establishing a clear vision that engages the Development Team and stakeholders Clearly expressing Product Backlog items Ordering the items in the Product Backlog to best achieve the vision and goals Ensuring that the Product Backlog is visible, transparent, and clear to all Working with the Development Team throughout the project to create a product that fits the customer's need What you will Learn You'll learn how to: Successfully prepare for the Scrum.org PSPO I exam Identify the characteristics of a successful Product Owner Create a powerful vision statement Apply techniques to understand your customers and the market Manage and engage stakeholders Write effective user stories with acceptance criteria Utilize techniques to visualize and prioritize the Product Backlog Participate in the 5 Scrum events as the Product Owner Understand the Product Owner's role in closing a Scrum project Getting Started Introductions Workshop orientation Exam prep preview Fundamentals Recap Agile Manifesto, values, and mindset Product Owner characteristics Good vs. great Product Owner Product Ownership Product ownership Project vision Understand your customers and market Personas Stakeholder management and engagement The Product Backlog User Stories and Acceptance Criteria Preparing User Stories for a Sprint The Product Backlog Visualizing the Product Backlog Product Backlog Prioritization Technical Debt Sprint Planning and Daily Standups Sprint Planning Planning Poker Team Engagement Daily Standups Sprint Review, Retrospectives, and Closing Sprint Reviews Key Agile Patterns Retrospectives Closing the Project

https://www.valuex2.com/agile-hr-certification/ https://www.linkedin.com/company/80563537/

In this lively interactive workshop we will explore the challenges faced by leaders of schools when tackling inclusion issues. We develop the concept of the leader as being central to the web of an organisation and the web of inclusion. Information flows freely to and from the leaders and interconnections are a premium. We explore shared leadership and consensus building using the Native American ‘Medicine Wheel’ to guide and structure our management of change. Course Category Inclusion Description In this lively interactive workshop we will explore the challenges faced by leaders of schools when tackling inclusion issues. We develop the concept of the leader as being central to the web of an organisation and the web of inclusion. Information flows freely to and from the leaders and interconnections are a premium. We explore shared leadership and consensus building using the Native American ‘Medicine Wheel’ to guide and structure our management of change. Testimonials ‘Inclusive practice has become more daring, more radical, more inspirational, more inclusive. How exciting and encouraging!’ ‘What a moving and energising day – there is so much we can do together’ Learning Objectives Increased confidence regarding developing leadership for inclusive practice in mainstream schools Access to a wider range of practical strategies to impact on team building Deeper understanding of developing vision and consensus Opportunity to reflect on professional attitudes and behaviour towards staff, parents and pupils New skills and processes to make inclusion successful Who Is It For? Heads and Deputies Leaders Managers of Chidren’s Centres Managers of Early Years settings Local Authority Support Services Course Content The course answers the questions: How to get a team thinking and working more inclusively? How to create and share my vision? Where do I start to think about developing a more inclusive setting? How can I get the best out of my team? We will cover a range of areas including: Establishing a welcoming team Building Vision and values Developing Trust Creating inclusive staff teams and communities of acceptance Creative Team problem solving Organisational models Curriculum access and curriculum design for inclusion Work with parents Consensus building If you liked this course you may well like: LEADERSHIP: CREATING AND SHARING YOUR VISION

Learning Outcomes for 'Minor Illness Update' Day for Experienced Registered Healthcare Professionals   By catering to experienced registered healthcare professionals already practicing in the area of minor illness, this 'Minor Illness Update' Day equips participants to elevate their existing skills, apply the latest insights, and enhance patient care through informed, compassionate, and effective practices. Agenda: 09.15Coffee and registration 09.30Introduction and course objectives 09.40Perspective on changes and safe practice within primary care 10.00Respiratory Tract infections 10.45Coffee 11.00Ears, Nose and Throat 13.00Lunch 14.00Abdominal pain and UTIs 14.30Head, Neck and Back Pain 14.30Eye infections 15.00Skin Rashes 15.30Injuries 15.45Evaluations and Close Learning Outcomes: Upon completion of the 'Minor Illness Update' Day, aimed at registered and experienced healthcare professionals already practicing in the field of minor illness, participants will be able to: 1. Stay Current in Minor Illness Management: - Demonstrate an updated and well-informed understanding of the latest developments in minor illness management within the primary care context. - Stay informed about current prescribing guidelines and adjustments in the field of minor illness treatment. 2. Critical Analysis of Consultation Dynamics: - Exhibit a critical comprehension of the significant dynamics at play during patient consultations related to minor illness cases. - Apply analytical skills to assess the complexities of patient presentations and prioritize appropriate diagnostic and treatment strategies. 3. Effective Problem-Solving in Practice: - Discuss and analyse practical challenges that arise during minor illness consultations, and propose effective solutions tailored to individual patient needs. - Employ problem-solving abilities to navigate diverse patient scenarios, enhancing overall patient care. 4. Integration of Attitudes and Values: - Develop an understanding of how personal attitudes and values may influence patient interactions and treatment decisions. - Apply self-awareness to ensure professional conduct aligns with ethical and patient-centred principles. 5. Awareness of Professional Growth: - Recognize the ongoing nature of professional development and the importance of staying updated in the rapidly evolving field of minor illness management. - Acknowledge the responsibility for continuous growth, embracing opportunities for learning and improvement. 6. CPD Contribution and Revalidation: - Identify the applicability of these study days as part of Continuing Professional Development (CPD) requirements for experienced registered healthcare professionals already practicing in minor illness. - Understand how participation contributes to professional revalidation, ensuring compliance with professional standards. 7. Virtual Engagement for Learning: - Leverage virtual learning environments effectively to enhance knowledge and skills related to minor illness management. - Demonstrate adaptability in engaging with virtual platforms for professional development and learning. 8. Holistic Patient Care Approach: - Integrate the acquired knowledge to provide holistic care to patients presenting with minor illness, recognizing the interconnectedness of physical and psychosocial aspects. - Foster a patient-centred approach by considering patients' needs, preferences, and well-being.  

Get to the heart of what matters to you. This course will empower you to gain clarity, find meaning and motivate yourself to achieve the things you care about with energy and grit. You will learn practical tools you can use in your day-to-day life.

This workshop gives an opportunity to focus on the emotional needs of girls and how to meet these. We lift the lid on a less well explored inclusion issue, meeting the emotional needs of girls. Everyone knows a girl or woman. They may be pupil, daughter, sister, parent or partner. Course Category Meeting emotional needs Behaviour and Relationships Inclusion Early Years Description This workshop gives an opportunity to focus on the emotional needs of girls and how to meet these. We lift the lid on a less well explored inclusion issue, meeting the emotional needs of girls. Everyone knows a girl or woman. They may be pupil, daughter, sister, parent or partner. Girls will often withdraw, attack or even hurt themselves when under emotional stress and this is not always obvious in the way it is with boys. 1 in 4 women experience domestic violence and every week 2 women are killed by a current or ex partner. Whilst the world assumes girls have no problems processing their emotions, we lift the lid on this and question what is really happening for girls this century? Testimonials Learning Objectives Increased understanding of girls’ 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 Opportunity to reflect on professional attitudes and behaviour towards girls and their emotional challenges New skills and processes to make girls’ 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 an invisible problem with girls? What can we do to meet the emotional needs of girls? What helps? What should our priority be with girls? This workshop will explore: Cultural and historical expectations of girls in our society Shared experiences of teaching and parenting girls Circle of Courage as a way of understanding emotional needs Fathers, mothers and daughters Solution Circle Problem Solving around girls’ needs What girls really need If you you want something similar, but not gender specific try: FRESH APPROACHES TO BEHAVIOUR AND RELATIONSHIPS or you may like: RESTORATIVE INTERVENTIONS

https://www.valuex2.com/agile-hr-certification/ https://www.linkedin.com/company/80563537/

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