2318 HR (Human Resources) courses

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.

Come and join Supported Loving's Community of Practice for anyone working with people with learning disabilities and/or autistic people delivering relationships and sex education, this can be formally groups or informally within your job role. Working in this area can be challenging but as a community we can grow and learn - there is always something new to learn! Each month we will take a topic to discuss and reflect upon what are the challenges and what has worked/ positive approaches. Each session will include a case study to explore , a section where we share our favourite resources to use on this topic and space to discuss our practice surrounding this topic. Please book on and lets get sharing :) This months topic- How to developing relationships 

Are you interested in pursuing a career in Human Resources (HR)? Or, are you an HR professional looking to upskill and advance in your career? Look no further, as we have the perfect solution for you! Our online course in HR is designed to cater to the needs of both beginners and seasoned professionals. HR is the backbone of any organisation, and it plays a crucial role in ensuring the smooth functioning of the company. HR professionals are responsible for attracting and retaining top talent, maintaining employee relations, ensuring compliance with labour laws, and creating a positive work environment. The demand for HR professionals in the UK is on the rise, with an estimated salary of £35,000 per month. Our comprehensive online course covers a range of topics, including the introduction to HR, employee recruitment and selection, training and development, performance appraisal management, employee relations, motivation and counselling, health and safety at the workplace, employee termination, employer records, and essential UK employment law. Upon completing this course, you will gain a thorough understanding of these key areas and be equipped with the necessary skills to succeed in the field of HR. Learning Outcomes of (HR) Human Resources Complete Bundle * Master the fundamentals of HR management, including its importance and impact on organisational success. * Develop expertise in effective recruitment and selection procedures to attract and retain top talent. * Learn cutting-edge employee training and development strategies to foster growth and drive performance. * Enhance your understanding of performance appraisal management, including setting goals, measuring progress, and providing constructive feedback. * Strengthen employee relations by addressing conflicts, fostering communication, and promoting a positive work environment. * Discover the motivation and counselling techniques to inspire and support your workforce, increasing productivity and job satisfaction. * Implement health and safety measures to ensure a safe and comfortable workplace that nurtures employee well-being. * Gain insights into employee termination, employer records, statistics, and essential UK employment law to make informed, compliant decisions. This (HR) Human Resources Complete Bundle Consists of the following Premium courses: * Course 01: HR Management Level 2 * Course 02: Recruitment Consultant - Level 4 * Course 03: Virtual Interviewing for HR * Course 04: HR - Crisis Communication * Course 05: Workplace Confidentiality * Course 06: Performance Management * Course 07: Payroll Management - Diploma * Course 08: Leadership & Management Diploma * Course 09: Equality and Diversity * Course 10: Cross-Cultural Awareness Training * Course 11: Effective Communication Skills Diploma * Course 12: Conflict Management * Course 13: GDPR Data Protection Level 5 * Course 14: People Management Skills Level 3 Curriculum of (HR) Human Resources Complete Bundle : Course 01: HR Management Level 2 * Introduction to Human Resources * Employee Recruitment and Selection Procedure * Employee Training and Development Process * Performance Appraisal Management * Employee Relations * Motivation and Counselling * Ensuring Health and Safety at the Workplace * Employee Termination * Employer Records and Statistics * Essential UK Employment Law ----------------- 13 more courses------------------ How will I get my Certificate? After successfully completing the (HR) Human Resources Complete Bundle course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. * PDF Certificate: Free (For The Title Course) * Hard Copy Certificate: Free (For The Title Course) CPD 140 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? Anyone from any background can enrol in this (HR) Human Resources bundle. REQUIREMENTS Our (HR) Human Resources course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. CAREER PATH * HR Assistant - £18-25k/year. * Recruitment Consultant - £22-35k/year. * HR Generalist - £30-45k/year. * HR Manager - £40-60k/year. * Learning & Development Specialist - £35-50k/year. * HR Director - £70-100k/year. CERTIFICATES CERTIFICATE OF COMPLETION Hard copy certificate - Included You will get the Hard Copy certificate for the title course (HR Management Level 2) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. CERTIFICATE OF COMPLETION Digital certificate - Included You will get the PDF Certificate for the title course (HR Management Level 2) absolutely Free!

Limited Time Offer | Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift | CPD QS Certified | 115 CPD Points | Lifetime Access

(HR) Human Resources: Workplace Confidentiality Training Level 1 In "HR: Workplace Confidentiality Training Level 1" become adept at HR protocols for upholding workplace confidentiality. Explore HR-endorsed business etiquette and colleague interactions, vital in maintaining confidentiality. Acquire HR strategies to proactively prevent breaches and safeguard sensitive data in HR operations. Learning Outcomes: * Understand HR role in workplace confidentiality. * Apply HR guidelines to business etiquette. * Maintain HR-driven confidentiality with colleagues. * Implement HR-approved breach prevention measures. * Recognize HR organizational responsibilities for confidentiality. More Benefits: * LIFETIME access * Device Compatibility * Free Workplace Management Toolkit (HR) Human Resources: Workplace Confidentiality Training Level 1 Course Syllabus * HR Protocols for Workplace Confidentiality: Grasp the HR-endorsed policies that uphold confidentiality and protect sensitive workplace data. * HR and Business Etiquette: Learn the HR perspective on integrating confidentiality into your professional interactions and adhering to ethical business etiquettes. * HR Guidelines for Confidentiality with Colleagues: Familiarize yourself with HR best practices for maintaining confidentiality when interacting with colleagues. * HR Strategies for Preventing Confidentiality Breach: Understand HR-approved methods to identify and mitigate the risks associated with breaches of confidentiality. * HR Role in Protecting Sensitive Data: Acquire HR-endorsed techniques for safeguarding confidential workplace information. * Organizational HR Responsibilities for Confidentiality: Comprehend the organizational responsibilities as mandated by HR policies, ensuring comprehensive confidentiality measures are in place.

Begin your career as an HR manager by enrolling in Course Cave's HR Management course. This course will help you pursue your goals and develop your knowledge, competence, and skill, whether you are a novice or a seasoned professional. It covers a wide range of topics to assist you in developing your HR management knowledge and skills. It provides step-by-step directions for hiring and selecting employees, improving employee relationships at work, and motivating and rewarding staff for better productivity. This HR manager course also provides in-depth knowledge of the various HR processes and functions. After completing this course, learners will be able to build the necessary HR skills and knowledge and manage an organization's HR functions. Upon registration, you will receive full course access and will be able to access the course materials from anywhere in the world, at any time, and on any internet-enabled device. Learning Outcomes You will be able to do the following at the end of the HR : HR course: * Examine the importance of human resources and their management in businesses. * Describe HRM Models. * Implement new employee recruitment and selection procedures in your business. * Recognise the significance of a positive employee partnership. * Create and execute a successful workplace training program. * Inspire and empower your staff. * Promote equality and manage diversity in your organisation * Examine current health and safety legislation and regulations and workplace health and safety management and risk assessment. * Talk about common employee complaints, disciplinary issues, and professional dismissal procedures. * Improve your communication abilities. * Prevent abuse and discrimination in the workplace. * Taking easy anti-Covid-19 precautions that will help protect your employees and your business. Course Curriculum *** HR : HR Course *** * Module 1: Introduction * Module 2: Recruitment and Selection * Module 3: Employee Relationship * Module 4: Performance Management * Module 5: The Necessity of Training & Development in the Workplace * Module 6: Motivating and Rewarding Employees * Module 7: Equality and Diversity * Module 8: Health and Safety of Employees * Module 9: Talent Management * Module 10: Succession Planning * Module 11: Absence Management and Attendance * Module 12: Handling Grievance, Discipline, Termination and Dismissal * Module 13: Communication Techniques for the Workplace * Module 14: Preventing Workplace Violence and Harassment * Module 15: Conflict Resolution * Module 16: Occupational Health Safety, Hygiene and Workplace Wellbeing of Employees * Module17: COVID-19 and the Workplace Assessment Method After completing each module of the HR Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this HR course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. WHO IS THIS COURSE FOR? This HR Course is highly recommended for anyone considering a career in human resources. This is something that existing Human Resources workers who are desperate for promotion should think about. This HR Course is open to business management students and anybody looking to improve their resume and career opportunities. REQUIREMENTS Students who intend to enrol in this HR Course must meet the following requirements: * Good command of the English language * Must be vivacious and self-driven * Basic computer knowledge * A minimum of 16 years of age is required CAREER PATH After completing this HR course, you will be capable of applying for a variety of positions. After completing this course, you can continue your education with our updated version of Human Resources Management if you want to keep up with your colleagues and peers or advance in your profession. CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - Included

Begin your career as an HR manager by enrolling in Course Cave's HR Management course. This course will help you pursue your goals and develop your knowledge, competence, and skill, whether you are a novice or a seasoned professional. It covers a wide range of topics to assist you in developing your HR management knowledge and skills. It provides step-by-step directions for hiring and selecting employees, improving employee relationships at work, and motivating and rewarding staff for better productivity. This HR manager course also provides in-depth knowledge of the various HR processes and functions. After completing this course, learners will be able to build the necessary HR skills and knowledge and manage an organization's HR functions. Upon registration, you will receive full course access and will be able to access the course materials from anywhere in the world, at any time, and on any internet-enabled device. Learning Outcomes You will be able to do the following at the end of the HR : HR course: * Examine the importance of human resources and their management in businesses. * Describe HRM Models. * Implement new employee recruitment and selection procedures in your business. * Recognise the significance of a positive employee partnership. * Create and execute a successful workplace training program. * Inspire and empower your staff. * Promote equality and manage diversity in your organisation * Examine current health and safety legislation and regulations and workplace health and safety management and risk assessment. * Talk about common employee complaints, disciplinary issues, and professional dismissal procedures. * Improve your communication abilities. * Prevent abuse and discrimination in the workplace. * Taking easy anti-Covid-19 precautions that will help protect your employees and your business. Course Curriculum *** HR : HR Course *** * Module 1: Introduction * Module 2: Recruitment and Selection * Module 3: Employee Relationship * Module 4: Performance Management * Module 5: The Necessity of Training & Development in the Workplace * Module 6: Motivating and Rewarding Employees * Module 7: Equality and Diversity * Module 8: Health and Safety of Employees * Module 9: Talent Management * Module 10: Succession Planning * Module 11: Absence Management and Attendance * Module 12: Handling Grievance, Discipline, Termination and Dismissal * Module 13: Communication Techniques for the Workplace * Module 14: Preventing Workplace Violence and Harassment * Module 15: Conflict Resolution * Module 16: Occupational Health Safety, Hygiene and Workplace Wellbeing of Employees * Module17: COVID-19 and the Workplace Assessment Method After completing each module of the HR Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this HR course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. WHO IS THIS COURSE FOR? This HR Course is highly recommended for anyone considering a career in human resources. This is something that existing Human Resources workers who are desperate for promotion should think about. This HR Course is open to business management students and anybody looking to improve their resume and career opportunities. REQUIREMENTS Students who intend to enrol in this HR Course must meet the following requirements: * Good command of the English language * Must be vivacious and self-driven * Basic computer knowledge * A minimum of 16 years of age is required CAREER PATH After completing this HR course, you will be capable of applying for a variety of positions. After completing this course, you can continue your education with our updated version of Human Resources Management if you want to keep up with your colleagues and peers or advance in your profession. CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - Included

(HR) Human Resources: Preventing Sexual Harassment at Work Master HR guidelines on preventing workplace sexual harassment. Learn HR practices for legal compliance and effective incident response. Equip your HR toolkit with robust prevention measures. Learning Outcomes: * Define HR role in sexual harassment identification. * Analyze HR-related legal implications of harassment. * Detect HR-critical instances of workplace harassment. * Implement HR-endorsed harassment response protocols. * Establish HR-driven preventive workplace measures. More Benefits: * LIFETIME access * Device Compatibility * Free Workplace Management Toolkit (HR) Human Resources: Preventing Sexual Harassment at Work Course Syllabus * HR Guidelines for Understanding Harassment: Grasp the multifaceted HR perspectives on what constitutes sexual harassment in workplaces. * Legal HR Frameworks on Harassment: Explore HR's role in understanding the legal implications and necessary compliance measures related to sexual harassment. * HR Skills in Identifying Harassment: Acquire HR competency in recognizing sexual harassment instances proactively. * HR Protocols for Harassment Responses: Master HR-endorsed strategies for responding to sexual harassment effectively, fostering a secure workplace. * HR Measures for Harassment Prevention: Learn HR-approved proactive measures for establishing a harassment-deterrent work environment. * Employee Rights Under HR: Understand the HR obligations in safeguarding the rights and protections for employees who report sexual harassment.

Duration 1 Days 6 CPD hours This course is intended for Business professionals who are either at the managerial level, or are interested in becoming team leaders will benefit from this course. Overview Determine the roles that a manager must fill on a team, and explore the key areas of personal development. Discover how to detect silent messages through body language and other means of nonverbal communication. You will also bolster your listening skills through active listening. Discover ways of identifying problems, prioritizing problems, and implementing solutions effectively. Empower your workgroup through delegation and coaching. Discover the stages of team development and examine the need for regular team meetings. In this course, students will gain an understanding of the basic fundamentals of becoming an effective manager for their team. 1. DEVELOPING AS A MANAGER * Identify Effective Manager Roles * Develop Personal Skills 2. COMMUNICATING SUCCESSFULLY * Communicate Without Talking * Manage Better by Listening * Assert to Achieve 3. CULTIVATING GREAT TEAMS * Create an Invincible Team * Inspire Team Success * Run Team Meetings * Resolve Conflicts Positively 4. EMPOWERING YOUR WORKGROUP * Delegate For Results * Coach for Achievement * Optimize Staff Performance 5. CREATING SUCCESSFUL SOLUTIONS * Identify and Define the Problem * Determine the Root Cause * Identify a Solution * Implement Solutions Decisively ADDITIONAL COURSE DETAILS: Nexus Humans Effective Management 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 Effective Management 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 1 Days 6 CPD hours This course is intended for This course is intended for managers, team leads, and individual contributors on techniques and best practices for continual improvement of themselves as leaders. Overview Define leadership. Assess your own leadership traits. Establish your leadership development plan. Develop your communication skills. Build your reputation. You have transitioned from an individual contributor to a manager, or as an individual contributor, you\'ve acquired practical skills to enhance your leadership abilities. When you want to take your leadership skills to the next level, you assess your leadership traits, develop your communication skills, and build your reputation. These strategies can increase your ability to effectively influence others and get results. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. Prerequisites Students taking this course should have completed the course: Practical Leadership (Second Edition) 1. DEFINING LEADERSHIP * Topic A: Identify Leadership Attributes * Topic B: Identify Leadership Responsibilities 2. ASSESSING YOUR LEADERSHIP TRAITS * Topic A: Assess Your Leadership Characteristics * Topic B: Determine How Colleagues View Your Leadership * Topic C: Evaluate Factors that Affect Your Leadership 3. ESTABLISHING YOUR LEADERSHIP DEVELOPMENT PLAN * Topic A: Identify Your Destination * Topic B: Establish Your Map * Topic C: Build a Leadership Development Plan 4. DEVELOPING YOUR COMMUNICATION SKILLS * Topic A: Upgrade Your Listening Skills * Topic B: Improve Your Communication Effectiveness 5. BUILDING YOUR REPUTATION * Topic A: Establish Your Credibility * Topic B: Use Influence to Get Results ADDITIONAL COURSE DETAILS: Nexus Humans Developing Yourself as a Leader (Second Edition) 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 Developing Yourself as a Leader (Second Edition) 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.