195 HR (Human Resources) courses in Cardiff delivered Live Online

For insights into how the four colour energies will transform your team dynamics and performance, join this virtual workshop and find out how to embed the four colour energies within your team. Find out your own communication preferences and how to work effectively with colleagues with a different preference.

A four-hour Neurodiversity Workshop aimed at Leaders looking to understand Neurodiversity and how to create an environment to allow Neurodiverse colleagues to thrive.

This half-day Suicide First Aid Lite training course gives learners the knowledge and tools to understand that suicide is one of the most preventable deaths and some basic skills can help someone with thoughts of suicide stay safe from their thoughts and stay alive.

Discover how to elevate your career as an executive assistant or personal assistant with our comprehensive EA Mastery Workshop. Gain new skills, strategies, and tools to maximize your impact and achieve success.

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.

A pioneering provider of independent mentoring services  For adults who are training to be teachers and Early Career Teachers (ECTs), our mission is to support and empower aspiring educators as they navigate their journey towards becoming skilled and confident professionals in the teaching profession. As a mentorship program tailored specifically for adults pursuing a teaching career, we understand the unique challenges and expectations placed upon trainees in the profession. We are committed to providing comprehensive and personalised support to help trainees meet the teaching standards set by the Department for Education in England. The teaching standards and expectations in England Our experienced mentors are well-versed in the teaching standards and expectations in England. We provide guidance and practical assistance to trainees in areas such as lesson planning, classroom management, assessment strategies, and creating inclusive learning environments. Our aim is to help trainees develop a deep understanding of the curriculum, pedagogical approaches, and effective teaching techniques. Planning Planning is a crucial aspect of a teacher's role, and we offer specialised support to trainees in this area. Our mentors work closely with trainees to develop effective lesson plans that align with curriculum requirements and engage students in meaningful learning experiences. We provide guidance on designing differentiated instruction to meet the diverse needs of students, fostering a supportive and inclusive classroom environment. Confidence Confidence is essential for success in the teaching profession, and we are dedicated to helping trainees build their self-assurance. Our mentors provide individualised coaching and feedback, helping trainees develop their teaching skills, classroom presence, communication abilities, and interpersonal skills with other staff. We create a safe and supportive environment where trainees can explore their strengths, identify areas for growth, and gain the confidence needed to deliver impactful lessons and engage with students and the wider school community effectively. High quality resources In addition to planning and confidence-building, GLA Tutorsoffers a range of other support services to trainees. We provide resources and guidance on effective behavior management strategies, assessment and feedback techniques, and effective use of technology in the classroom. Our mentors also offer guidance on professional development opportunities, helping trainees stay updated with the latest educational research and best practices in teaching. A collaborative and ongoing process At GLA Tutors, we believe that mentorship is a collaborative and ongoing process. Our mentors build strong relationships with trainees, offering ongoing support, guidance, and encouragement throughout their training and early career stages. We understand the challenges and triumphs that trainees may encounter, and we are dedicated to helping them navigate their journey towards becoming successful and impactful teachers. ChooseGLA Tutorsas your trusted partner in your teaching journey. With our experienced mentors, personalised support, and comprehensive resources, we are committed to helping you meet the teaching standards, develop as a confident educator, and make a positive impact in the lives of your students.  Invest in your future as a teacher and join us at GLA Tutors today.

You have the pieces of the Leadership Puzzle; the knowledge of child Development, the knowledge of best practise, the knowledge of health and safety plus much more.  Now let's use these pieces of knowledge to help you connect and lead a team to excellence.

QA Level 1 Award In Health And Safety In The Workplace (RQF) Face to Face: Half-day course Virtual Classroom: Spread over 2 sessions of 2½ hr duration A basic course to train your workers in basic health and safety Teaches workers how to keep themselves and others safe at work Course Contents: Roles and responsibilities of employers and employees The importance of health and safety in the workplace Workplace hazards and Risks, including:Slips, Trips and FallsManual HandlingFireWorking from HeightElectricityHazardous SubstancesMachinery and Vehicles Workplace conditions that can affect health and safety Health and Safety Signage Personal Protective Equipment and its uses Importance of Personal hygiene The Purpose of First Aid Provision The need for Reporting Incidents and ill Health Benefits of this course: In 2023/24, 1.7 million people suffered from a work-related illness 600,000 sustained a non-fatal injury 138 People lost their lives 776,000 Workers suffered from work-related stress, depression or anxiety The estimated cost of injuries and ill health last year was £21.6 billion 33.7 million working days, or 140,417 working years, were lost due to work-related illnesses and injuries It is an employer's duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk Our QA Level 1 Award in Health and Safety in the Workplace (RQF) course helps employs gain a bit more understanding of health and safety issues and their own role within that. Accredited, Ofqual regulated qualification: Our Health and Safety Training Course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Health and Safety Certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained in Health and Safety. The Ofqual Register number for this course is 603/0774/2

Board members face a huge amount of information and review before the board meeting. Here is step-by-step process for mastering your board meeting prep challenge.

Talent Management and Succession Planning,” the podcast where we explore the critical aspects of attracting and retaining top finance talen Talent management is the lifeblood of any organisation, and finance departments are no exception. In a competitive business landscape, attracting and retaining top finance talent can make a significant difference. Highly skilled and motivated professionals drive innovation, improve financial performance, and contribute to strategic decision-making. By investing in talent management, CFOs ensure their organisations have the right people in the right roles, which is vital for sustainable growth and success. Talent management also enables CFOs to build a culture of continuous learning and development. By nurturing the skills and capabilities of finance professionals, we create an environment that fosters innovation and adaptability. This is crucial in today’s rapidly changing business landscape, where finance teams need to keep pace with evolving technologies, regulations, and industry trends. Talent management provides a foundation for building a resilient and agile finance function. Succession planning is an integral part of talent management. How do CFOs approach succession planning, particularly in finance leadership roles? Succession planning is a proactive approach to ensure a smooth transition of leadership roles. CFOs need to identify high-potential individuals within their finance teams and provide them with opportunities for growth and development. This includes mentorship, training programs, and exposure to cross-functional experiences. By preparing a pipeline of future finance leaders, CFOs can mitigate the risks associated with unexpected departures or retirements, ensuring continuity and stability in finance leadership. Additionally, succession planning should encompass diversity and inclusion. CFOs recognize the importance of building diverse finance teams that reflect the broader talent pool. By providing equal opportunities for underrepresented groups and promoting inclusivity, we foster a culture of belonging and tap into a wider range of perspectives and ideas. Diverse teams drive innovation and improve decision-making, contributing to the overall success of the organisation. How do CFOs create a talent development culture within their finance teams, and what initiatives can be implemented to foster continuous growth? CFOs can create a talent development culture by prioritizing learning and development initiatives. This includes offering ongoing training programs, supporting professional certifications, and providing access to resources that enhance technical and soft skills. CFOs should encourage finance professionals to take ownership of their own development and provide opportunities for them to stretch their capabilities. This may involve cross-functional projects, exposure to different areas of the business, or participation in industry conferences and networking events. Additionally, mentorship and coaching programs play a crucial role in talent development. CFOs can pair experienced finance leaders with up-and-coming talent, fostering knowledge transfer, and providing guidance and support. Encouraging regular feedback and performance discussions helps finance professionals understand their strengths and areas for improvement, enabling targeted development plans. By creating a culture that values continuous learning and growth, CFOs empower their finance teams to reach their full potential. https://www.fdcapital.co.uk/podcast/talent-management-and-succession-planning/ Tags Online Events Things To Do Online Online Classes Online Business Classes #leadership #development #successionplanning #employees #talentmanagement