Level 4 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 120 CPD Points | Lifetime Access
Free Level 5 QLS Endorsed Certificate | CPD Accredited | 150 CPD Points | Advanced Learning Materials | Lifetime Access
Level 5 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 150 CPD Points | Lifetime Access
Level 3 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 120 CPD Points | Lifetime Access
This full day workshop is designed to follow on and build on the learning from the 1-hour webinar to provide an embedded learning experience leading to acceptance and change of culture around neurodiversity. We understand the pressure managers can experience working within a neurodiverse team, this training is designed with managers in mind.
People are a vital element in any organisation and managing and leading people is critically important for every manager. This course describes the key people management skills that contribute fully to organisational effectiveness.
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
Getting Started The ILM Level 6 Diploma in Management aims to sharpen learners' critical thinking skills and assess their performance to prepare them for senior leadership. It consists of two units that focus on developing oneself and the wider organisation, including optimising organisational capacity, managing operations research, and developing the executive manager. These skills provide learners with the knowledge and skills needed to work and advance in a wide range of career fields. Credits earned in this course can be transferred to Level 7 qualifications, making it a valuable bridge for learners moving from the Level 5 ILM qualification to the Level 7 ILM qualification. Key Benefits This qualification prepares learners to Understand the role of the senior manager Understand ways in which management models and theories influence management practice Develop the ability to critically evaluate your own performance Develop the ability to review ideas and practices Carry relevant research to inform the way you work Key Highlights This qualification is designed for senior managers who are new in their roles or middle managers who are preparing for promotion. We will ensure your access to the first-class education needed to achieve your goals and dreams and to maximise future opportunities. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our qualified tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. About Awarding Body Institute of Leadership & Management (ILM) is a professional body that helps people worldwide improve their leadership capabilities and advance their careers. All ILM qualifications are awarded by The City and Guilds of London Institute, founded in 1878 and incorporated into the Royal Charter. ILM qualifications are regulated and approved by Ofqual, the governing body for qualifications in the UK. Assessment Time-constrained scenario-based assignments No examinations Entry Requirements 1. A Level 5 Qualification 2. Considerable work experience as a manager Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Credit value: Learners must gain 42 credits to achieve this qualification Rules of Combination: Minimum 12 credits from Group 1 Minimum 30 credits from Group 2 More than 50% of credits must be achieved at Level 6 Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.
Transform your human resource and payroll management skills with our comprehensive "Payroll, HR & HR Systems" course bundle! Gain a solid theoretical grounding with three QLS-endorsed courses: Payroll Management, HR (Human Resource), and Complete Guide to HR Systems. On successful completion, enjoy the prestige of owning a hardcopy certificate for each, showcasing your dedication and knowledge. But the learning doesn't stop there. Our bundle includes five additional CPD QS accredited courses, handpicked for their relevance to modern HR operations. Sage 50 Payroll for Beginners provides a thorough introduction to the popular payroll software, while Organisational Behaviour, HR and Leadership unpacks the intricacies of organisational dynamics. With Certificate in HR Audit, you can dive deep into internal HR procedures, and with Virtual Interviewing for HR and Safer Recruitment Training, you'll master the art of virtual recruitment and talent acquisition, a skill crucial in today's digital age. Key Features of the Payroll, HR & HR Systems Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Payroll, HR & HR Systems bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Payroll: Payroll Management QLS Course 02: HR (Human Resource) QLS Course 03: Complete Guide to HR systems 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Sage 50 Payroll for BeginnersCourse 02: Organizational Behaviour, HR and LeadershipCourse 03: Certificate in HR AuditCourse 04: Virtual Interviewing for HRCourse 05: Safer Recruitment Training In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV WritingCourse 02: Job Search SkillsCourse 03: Self Esteem & Confidence BuildingCourse 04: Professional Diploma in Stress ManagementCourse 05: Complete Communication Skills Master Class Convenient Online Learning: Our courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. This incredible, comprehensive 8-course bundle guarantees a holistic understanding of Payroll, HR Systems, equipping you with the theoretical knowledge to make a mark in your professional journey. Learning Outcomes: Gain a strong theoretical foundation in payroll management. Understand the principles and practices of Human Resource Management. Learn the use and application of HR systems. Comprehend the basics of Sage 50 Payroll. Develop insights into Organisational Behaviour and Leadership in HR context. Master the techniques of HR Audit. Equip yourself with virtual interviewing skills and safer recruitment practices. Our Payroll, HR & HR Systems course bundle delivers an in-depth, theoretical understanding of key HR topics. It brings together knowledge from various fields like payroll management, HR audit, and HR systems, providing a holistic perspective on the overall management of human resources. The bundle further highlights the importance of organisational behaviour, leadership, and safer recruitment practices - pivotal aspects in maintaining a harmonious and productive work environment. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is ideal for: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic Career path HR Manager (Salary range: £35,000 - £60,000) Payroll Specialist (Salary range: £25,000 - £40,000) HR Systems Analyst (Salary range: £30,000 - £50,000) Recruitment Specialist (Salary range: £22,000 - £35,000) Organisational Development Manager (Salary range: £45,000 - £70,000) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included
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.