200 HR (Human Resources) courses in South Shields delivered Live Online

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.

In this workshop, you will gain a better understanding of the benefits and challenges of working with neurodiverse people. Make your Organisation a more inclusive place for neurodiverse individuals.

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.

CPD Accredited, Interactive Short Course 2 or 3.5 hour hr sessions What are the autistic spectrum disorder, autism and asperger's syndrome? How can you best understand, and thus help, those affected? Course Contents of the shorter course: What is ASD Autism and Asperger's Syndrome Understanding those on the Spectrum How to approach and help those on the Autistic Spectrum Great for teachers and TAs in schools, and for those working in care with older people with ASD Benefits of this Short Course: About 1% of the population is thought to be on the Autistic Spectrum That is several children per nursery and primary school and a significant amount of young people in secondary schools Many with Asperger's Syndrome will also go to university The way they experience the world is very different to 'neuro-typical' people Understanding their condition helps to support them and give them the best chance

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

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.

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.

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.