5188 Cat courses in Cardiff delivered 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.

Do you need a qualification in data protection or are you thinking about learning more about data protection for your organisation? The BCS Practitioner Certificate in Data Protection designed for those with some data protection responsibilities in an organisation and wish to achieve and demonstrate a broad understanding of the law and progresses from what is taught in the BCS Foundation Certificate in Data Protection.

Social Services and Health Care Units AB Training Academy Scottish Vocational Qualification 3 Social Services and Healthcare at SCQF level 7 Core/mandatory Units H5RY 04 (SCDHSC 0031) — 9 SCQF Credits at SCQF level 7 Promote effecBve communicaBon ♦ Establish understanding about individuals’ communication ♦ Support individuals to interact through communication ♦ Communicate effectively about difficult, complex and sensitive issues ♦ Communicate using records and reports H5LD 04 (SCDHSC0032) — 10 SCQF Credits at SCQF level 7 Promote health, safety and security in the work setting ♦ Maintain health, safety and security in the work setting ♦ Promote health and safety in the work setting ♦ Minimise risks arising from emergencies H5LE 04 (SCDHSC0033) — 9 SCQF Credits at SCQF level 7 Develop your pracBce through reflecBon and learning ♦ Reflect on your own practice ♦ Take action to enhance your practice H5S0 04 (SCDHSC0035) — 9 SCQF Credits at SCQF level 7 Promote the safeguarding of Individuals ♦ Maintain your understanding and awareness of harm, abuse and safeguarding ♦ Implement practices that help to safeguard individuals from harm or abuse ♦ Develop relationships that promote safeguarding ♦ Promote rights and inclusion ♦ Work in ways that promote wellbeing ♦ Support individuals to keep themselves safe Op;onal DK3M 04 (SFH CHS17) — 8 SCQF Credits at SCQF level 7 Carry out extended feeding techniques to ensure individuals nutriBonal and fluid intake FP8N 04 (SFH CHS19) — 8 SCQF Credits at SCQF level 6 Undertake rouBne clinical measurements DK2X 04 (SFH CHS3) — 8 SCQF Credits at SCQF level 6 Administer medicaBon to individuals FP8D 04 (SFHC HS8) — 8 SCQF Credits at SCQF level 7 Insert and secure urethral catheters and monitor and respond to the effects of urethral catheterisaBon DL00 04 (SFH CHS132) — 8 SCQF Credits at SCQF level 7 Obtain venous blood samples FP8F 04 (SFH CHS4) — 8 SCQF Credits at SCQF level 7 Undertake Bssue viability risk assessment for in

Navigating the world of dog training can sometimes feel like trying to teach a cat to fetch — a bit tricky but certainly rewarding. Our Leash Training Course is designed to guide you through the essential techniques and strategies to help your canine companion walk calmly and confidently by your side. This course breaks down the mysteries behind leash manners, from reducing pulling to mastering polite walking behaviour, all delivered in a clear, easy-to-follow format that suits any dog owner or enthusiast. Whether you’re dealing with a lively puppy eager to explore or an older dog with a few quirks, this course offers insightful tips to improve your daily walks. Expect straightforward advice, sprinkled with a dash of humour, that transforms stressful strolls into pleasant outings. With an emphasis on understanding canine behaviour and consistent communication, this training provides you with the know-how to enjoy harmonious walks — no more tug-of-war matches or unexpected detours into the flowerbeds. Ideal for those who prefer to learn at their own pace from the comfort of home, this course is your trusty guide to better leash manners and happier walks. Learning outcomes: Understand the importance of dog leash training and its benefits for both the dog and its owner. Learn how to prepare for a walk with your dog, including selecting the right equipment and identifying potential hazards. Master the art of leash training, including teaching your dog to walk on a loose leash and avoid pulling. Learn effective recall training techniques to ensure your dog comes back to you when called. Develop an understanding of how to establish a positive relationship with your dog and become the pack leader. The Dog Leash Training course is a comprehensive program that covers everything you need to know about training your dog to walk on a leash. The curriculum is divided into five modules: In this module, you'll hear from people who have successfully trained their dogs using the methods taught in this course. You'll learn from their experiences and get motivated to start your own training journey. This module provides an overview of what you can expect to learn from this course. You'll understand the importance of dog leash training and the benefits of having a well-trained dog. This module focuses on preparing for the walk, including selecting the right equipment and identifying potential hazards. You'll also learn how to establish a positive relationship with your dog before the walk. In this module, you'll learn how to train your dog to walk on a loose leash and avoid pulling. You'll also get tips and tricks for dealing with common challenges, such as distractions and other dogs. The final module covers recall training techniques to ensure your dog comes back to you when called. You'll also receive a comprehensive e-book that covers all aspects of dog leash training. How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Here are some potential options: Dog Trainer: £16,000 - £30,000 per year Dog Walker: £10 - £15 per hour Pet Sitter: £10 - £20 per hour Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Leading People through Change: In-House Training Research shows that 70% of change initiatives fail in large organizations. The largest factor contributing to this failure rate is leadership - the inability to plan and lead people through change. In many change situations, tremendous focus is put on strategy, processes, and systems, while the issue of changing people's behavior is assumed it will 'just happen'. In this interactive course, you will learn why the people side of change is crucial. We will begin by understanding why and how people resist change, and how important it is to become strong and effective change champions. Next, we will focus on critical change management practices - creating our vision of the future state, planning for acceptance in our change audience and stakeholders, mitigating threats, and capitalizing on opportunities. We will use metrics to plan, show progress, and confirm success. Lastly, we will focus on the need to reinforce and sustain change, and to prevent relapse to old ways and methods. What you will Learn At the end of this program, you will be able to: Realize the nature of change and describe how resistance manifests in people Compare prevalent change models and categorize their similarities Identify and rate the skills, traits, and behaviors of effective change champions Envision the future state and assess stakeholders Plan for change communication, training, and risks Evaluate change effectiveness using feedback and metrics Develop reinforcement practices for benefits and communication Foundation Concepts What is Change? Resistance to Change Common Change Management Theories Becoming a Change Champion Plan Envisioning the future state Planning for people Change management plan Do Change communication Training Piloting Risks Study Feedback Metrics Variance analysis Act Benefits realization Change sustainment Reinforcement messaging and communications

Emotional Intelligence: In-House Training Emotional Intelligence is a set of emotional and social skills that collectively establish how well we: Perceive and express ourselves Develop and maintain social relationships Cope with challenges Use emotional information in an effective and meaningful way It is a skill set that transfers across all categories of relationships. It is also a predictor of success - both in life and at work. This highly-interactive course delivers a practical approach to developing, improving, and sustaining effective and mutually beneficial relationships. The design of the course involves individual reflection and paired activities, interwoven with small and large group interactions. The EQ-i 2.0® assessment reports will be debriefed over the course of the two days. In addition, participants will delve into their personal strengths and blind spots, and will explore topics including: the neuroscience of emotion, the connection between empathy and performance, and how communication styles impact our perceptions of self and other. Role-play activities give participants the opportunity to try out new behaviors and techniques. The program includes: A personal behavioral profile, the results of which you will bring to your training 2-day highly interactive workshop and experiential learning Optional professional coaching activities initiated in class that can continue over the four months after class ends What you will Learn Recognize your interpersonal strengths and potential blind spots regarding Emotional Intelligence Identify the five domains within the EQ-i 2.0 assessment model Summarize what neuroscience research has discovered about emotions and actions Recognize ways that human beings are physiologically impacted by stress Articulate ways to develop and maintain strong working relationships Describe how emotional intelligence translates into high performance Make use of the EI model and associated competencies Employ strategies for enhancing leadership through Emotional Intelligence Foundation Concepts The biology of emotion Why Emotional Intelligence matters The impact of EI on performance The EQ-I 2.0 Model Overview of the EQ-i 2.0 framework Exploring your report Balancing your EI domains Self: Awareness and Sensitivity Self-awareness and empathy Perception vs. reality Acting by choice, not impulse Other: Communication and Relationship-Building Elements of effective communication Communication styles Communication techniques Neuroscience and Behavioral Change Insights from social neuroscience Making a change

DevOps demystified training course description This course is an introduction to DevOps. The course emphasizes communication, collaboration , integration, and automation to improve the workflow between developers and IT operations professionals. Improved workflows lead to more opportunities to design software and services in a more agile fashion. This course is a basis for discovering the most important DevOps concepts and to understand the principles and methods behind this. The course will leave you with the inspiration to be the advocate of change. What will you learn Explain DevOps principles. Describe the relationship between Agile , Lean and IT Service Management ( ITSM). Describe methods for automation and technology factors. Describe considerations when changing. Describe challenges, risks and critical success factors. DevOps demystifieds training course details Who will benefit: Non-technical staff involved with DevOps. Prerequisites: None. Duration 1 day DevOps demystified training course contents Why DevOps? From a business perspective From an IT perspective Stereotypes of Dev and Ops: perception and reality What is DevOps? Introduction DevOps Goals DevOps Added value of DevOps Proven Results DevOps for businesses DevOps principles (The Three Ways) DevOps and other frameworks DevOps and Agile DevOps and Lean DevOps and IT Service Management DevOps culture Characteristics of a DevOps culture Organizational Considerations DevOps DevOps stakeholders DevOps roles DevOps teams DevOps organizational structures DevOps methods Continuous Integration Continuous delivery Continuous deployment Value stream mapping Kanban Theory of Constraints Improvement Kata Deming's quality circle ITSM processes DevOps and Automation Methods for DevOps automation Longevity and tools categories DevOps applications Transitioning to a DevOps culture Implementation Challenges, risks and critical success factors Measuring DevOps successes

Unleash your teachers potential, embrace resilience, and effortlessly cater to every child's needs across your school with the abundance of resources included with RISE: Resilience in Schools and Education.

Who are these qualifications for? These qualifications are designed for managers and leaders who have the authority and responsibility for developing and implementing a coaching and mentoring strategy across the organisation. The qualifications require managers and leaders to build on their strategic management and leadership skills and to focus on the requirements of embedding the organisation’s strategy.

The Level 4 Certificate gives a broad understanding of the professional and provides the skills needed to complete complex, non-routine tasks within workplace and facilities management. It's for you if you work at an operational management level or if you are aspiring to these roles and want to stretch and develop your knowledge and capability.