6998 Courses

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes Establish a strong foundation in SQL database administration, covering setup and configuration. Master SQL statement basics, including querying, filtering, and sorting data effectively. Utilize GROUP BY statements for data aggregation and summarization. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. Why choose this SQL Database Administrator at QLS Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this SQL Database Administrator at QLS Level 5 course for? Aspiring Database Administrators and SQL Professionals. Software Developers Seeking to Expand Their Database Management Skills. IT Professionals Interested in Database Administration. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge Career path SQL Database Administrator - $60,000 to $110,000/year. Database Developer - $70,000 to $120,000/year. Data Engineer - $80,000 to $130,000/year. Database Manager - $90,000 to $150,000/year. Database Architect - $100,000 to $160,000/year Prerequisites This SQL Database Administrator at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

The Payroll Manager and HR Management course offers comprehensive training in using Sage 50 Payroll software for beginners and intermediate users. Covering payroll basics, company settings, pension schemes, employee records, statutory payments, and year-end procedures, participants will gain proficiency in payroll processing and HR management using Sage 50 Payroll. Learning Outcomes: Understand payroll fundamentals, company settings, and legislative requirements. Master pension scheme basics, pay elements, and processing employee payments. Learn to handle employee records, generate reports, and navigate year-end procedures. Gain proficiency in handling timesheets, department analysis, and holiday schemes. Manage statutory sick pay, maternity pay, student loans, and workplace pensions. Explore managing company cars, holiday funds, and roll-back procedures. Understand password management, access rights, and linking payroll to accounts. Develop intermediate-level skills in Sage 50 Payroll, including global changes and advanced features. Why buy this Payroll Manager and HR Management? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Payroll Manager and HR Management you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Aspiring payroll managers and administrators looking to gain Sage 50 Payroll skills. Human resource professionals aiming to enhance their payroll and HR management skills. Small business owners and managers responsible for payroll and employee management. Individuals seeking to enter the field of payroll processing and HR administration. Prerequisites This Payroll Manager and HR Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Payroll Manager: Oversee payroll processing, employee records, and statutory payments. HR Manager: Manage HR operations, employee benefits, and compliance with payroll regulations. Payroll Administrator: Handle day-to-day payroll tasks, including processing payments and reports. Small Business Owner: Efficiently manage payroll and HR functions in a small business setting. HR Coordinator: Assist in HR tasks, employee records, and payroll administration. Course Curriculum Sage 50 Payroll for Beginners Module 1: Payroll Basics Payroll Basics 00:10:00 Module 2: Company Settings Company Settings 00:08:00 Module 3: Legislation Settings Legislation Settings 00:07:00 Module 4: Pension Scheme Basics Pension Scheme Basics 00:06:00 Module 5: Pay Elements Pay Elements 00:14:00 Module 6: The Processing Date The Processing Date 00:07:00 Module 7: Adding Existing Employees Adding Existing Employees 00:08:00 Module 8: Adding New Employees Adding New Employees 00:12:00 Module 9: Payroll Processing Basics Payroll Processing Basics 00:11:00 Module 10: Entering Payments Entering Payments 00:12:00 Module 11: Pre-Update Reports Pre-Update Reports 00:09:00 Module 12: Updating Records Updating Records 00:09:00 Module 13: e-Submissions Basics e-Submissions Basics 00:09:00 Module 14: Process Payroll (November) Process Payroll (November) 00:16:00 Module 15: Employee Records and Reports Employee Records and Reports 00:13:00 Module 16: Editing Employee Records Editing Employee Records 00:07:00 Module 17: Process Payroll (December) Process Payroll (December) 00:12:00 Module 18: Resetting Payments Resetting Payments 00:05:00 Module 19: Quick SSP Quick SSP 00:09:00 Module 20: An Employee Leaves An Employee Leaves 00:13:00 Module 21: Final Payroll Run Final Payroll Run 00:07:00 Module 22: Reports and Historical Data Reports and Historical Data 00:08:00 Module 23: Year-End Procedures Year-End Procedures 00:09:00 Sage 50 Payroll Intermediate Level Module 1: The Outline View and Criteria Module 01: The Outline View and Criteria 00:11:00 Module 2: Global Changes Module 02: Global Changes 00:07:00 Module 3: Timesheets Module 03: Timesheets 00:12:00 Module 4: Departments and Analysis Module 04: Departments and Analysis 00:11:00 Module 5: Holiday Schemes Module 05: Holiday Schemes 00:10:00 Module 6: Recording Holidays Module 06: Recording Holidays 00:12:00 Module 7: Absence Reasons Module 07: Absence Reasons 00:13:00 Module 8: Statutory Sick Pay Module 08: Statutory Sick Pay 00:16:00 Module 9: Statutory Maternity Pay Module 09: Statutory Maternity Pay 00:17:00 Module 10: Student Loans Module 10: Student Loans 00:09:00 Module 11: Company Cars Module 11: Company Cars 00:13:00 Module 12: Workplace Pensions Module 12: Workplace Pensions 00:21:00 Module 13: Holiday Funds Module 13: Holiday Funds 00:13:00 Module 14: Roll Back Module 14: Process Payroll (November) 00:11:00 Module 15: Passwords and Access Rights Module 15: Passwords and Access Rights 00:08:00 Module 16: Options and Links Module 16: Options and Links 00:10:00 Module 17: Linking Payroll to Accounts Module 17: Linking Payroll to Accounts 00:08:00 Mock Exam Mock Exam - Payroll Manager and HR Management 00:20:00 Final Exam Final Exam - Payroll Manager and HR Management 00:20:00

Logistics for Traders: Importance, Role and Benefits. This session will look at how logistics is a critical component within the supply chain but is often overlooked.

This course is aimed at people starting out in the construction industry and can be used as part of their induction process or as preparation for the online accredited exam. Whilst this course, Level 1 Health & Safety in a Construction environment provides you with a qualification in its own right, it can also form part of your CSCS green card application. This exam is the follow up to the Level 1 Health and Safety in a Construction Environment (Leading to CSCS Green Card) course which if passed qualifies you for green CSCS card.

Each year in the UK, people are killed, injured and suffer work-related illnesses while carrying out their jobs. So Health & Safety is a significant concern. The government, employers and workers all have an essential role to play in reducing deaths and accidents and preventing ill-health at work. This course is aimed at people starting out in the construction industry and can be used as part of their induction process or as preparation for the online accredited exam. Whilst this course, Level 1 Health & Safety in a Construction environment provides you with a qualification in its own right, it can also form part of your CSCS green card application. The course starts with an introduction to the legal aspects of health and safety before covering the basics of risk assessment and safe working practices. It then goes into detail to cover the most common hazards encountered in construction environments from Working at Height and Respiratory Hazards to electrical and chemical hazards.

Construction (Design & Management) Regulations 2015 - this law applies to the whole construction...

Level 3 QLS Endorsed Diploma | 120 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Highlights of the Course Course Type: Online Learning Duration: 2 Hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about emotional intelligence Understand the core competencies and principles of emotional intelligence Explore the various areas of emotional intelligence Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert manager Emotional Intelligence and Collaboration Course  Master the skills you need to propel your career forward in emotional intelligence. This course will equip you with the essential knowledge and skillset that will make you a confident manager and take your career to the next level. This comprehensive emotional intelligence and collaboration course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this emotional intelligence and collaboration course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective emotional intelligence practice and equip you with the essential skills, confidence and competence to assist you in the emotional intelligence industry. You'll gain a solid understanding of the core competencies required to drive a successful career in emotional intelligence. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for manager or for people who are aspiring to specialise in emotional intelligence. Enrol in this emotional intelligence and collaboration course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive emotional intelligence and collaboration course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this emotional intelligence can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This emotional intelligence and collaboration course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This emotional intelligence and collaboration course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This emotional intelligence and collaboration course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction to the Collaboration and Emotional Intelligence Course Introduction To The Course On Collaboration And Emotional Intelligence 00:02:00 The Learning Objectives Of The Course 00:02:00 How Taking A Different View On Team Working Can Make A Big Difference 00:03:00 Giving And Receiving Feedback In Collaboration 00:06:00 Tips To Develop Your Emotional Intelligence In Collaboration 00:05:00 The Role of Emotional Intelligence in Collaboration Defining Emotional Intelligence 00:03:00 What Is The Difference Between EI And EQ 00:03:00 An Insight into Emotions 00:01:00 Emotional Intelligence At Work 00:06:00 Working With The Emotional Climate 00:03:00 Running Virtual Meeting With Emotional Intelligence 00:03:00 Collaborative Working Introducing The Working Practice Of Collaboration 00:04:00 Why Win-Win Collaboration Is Important 00:06:00 Emotional Intelligence And Win-Win Collaboration 00:01:00 Why Collaborate And When To Collaborate 00:02:00 The Principles And Characteristics Of Collaboration. 00:03:00 The 3 Levels Of Collaboration 00:02:00 The Modes Of Collaboration 00:02:00 An Overview Of Some Of Difficulties With Collaboration 00:02:00 The Importance of Trust in Collaboration Conflict And Trust In Collaboration - Factors And Questions To Consider 00:03:00 The Important Role Of Trust 00:04:00 Building Trust Using An Emotional Bank Account 00:05:00 Behaviors and Collaboration The Four Behavioural Styles In Collaboration - Learning Outcomes 00:02:00 The Importance Of Behavioural Flexibility 00:03:00 William Moulton Marston's Model Of The Behavioural Expression Of Emotions 00:02:00 The High Dominance Behavioural Style 00:02:00 The High Influence Behavioural Style 00:03:00 The High Steadiness Behavioural Style 00:03:00 The High Compliance Behavioural Style 00:03:00 The Ideal Behaviours For Ideal Interactions with Each Behavioural Style 00:05:00 Using Behavioural Styles To Build Collaborative Relationships 00:03:00 Review of the Course A Review - Facilitating Collaborative Meetings 00:04:00 Review Of The Course On Collaboration And Emotional Intelligence 00:03:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Asbestos was once a common material used in construction and manufacturing, but it's now known to be a dangerous carcinogen. Even though asbestos use has declined, it can still be found in many older buildings and equipment. Don't risk exposure. Enrol now in our comprehensive Asbestos Awareness online training bundle and gain the knowledge you need to identify asbestos hazards and handle them safely. With this Asbestos Awareness course, you will get 20 CPD Accredited PDF Certificates, Hard Copy Certificate of Asbestos Awareness and our exclusive student ID card absolutely free. Courses Are Included In This Asbestos Awareness Bundle: Course 01: Asbestos Awareness Course 02: Asbestos Surveying & Management Training Course 03: Abrasive Wheels Course 04: Manual Handling Training Course 05: Working in Confined Spaces Course 06: Construction Project Management Course 07: Building Surveying Practice Course 08: Diploma in Construction Industry Scheme (CIS): QLS Endorsed Course 09: Site Management Safety Training Scheme (SMSTS) at QLS Level 5 Course 10: Construction Safety Course 11: Spill Management Training Course 12: CDM Regulations Training Course 13: COSHH Training Course 14: RIDDOR Training Course 15: LOLER Training Course 16: Lone Worker Safety Course 17: Ladder Safety Course 18: Electrical Safety Course 19: Fire Risk Assessment With Health and Safety Training Course 20: Workplace First Aid Level 4 Embarking on Asbestos Awareness is more than just taking an online course; it's an investment in your future. By completing this Asbestos Awareness bundle, you'll not only gain invaluable skills but also open doors to new career opportunities and advancements, boosting your earning potential. Learning Outcomes of Asbestos Awareness Bundle: Identify asbestos-containing materials safely. Understand health risks of asbestos exposure. Follow regulations for asbestos management. Use proper asbestos handling procedures. Conduct asbestos inspections and surveys. Implement asbestos control and abatement plans. Don't miss this chance to elevate your career and skillset. Enrol in Asbestos Awareness Today and take the first step towards achieving your goals and dreams. Why buy this Asbestos Awareness? Free CPD Accredited Certificate upon completion of Asbestos Awareness Get a free student ID card with Asbestos Awareness Lifetime access to the Asbestos Awareness course materials Get instant access to this Asbestos Awareness course Learn Asbestos Awareness from anywhere in the world 24/7 tutor support with the Asbestos Awareness course. Asbestos Awareness is an entirely online, interactive lesson with voice-over audio. Start your learning journey straightaway with our Asbestos Awareness Training! Asbestos Awareness premium bundle consists of 20 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Asbestos Awareness meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Asbestos Awareness course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the Asbestos Awareness exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 320 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Asbestos Awareness course is ideal for: Students seeking mastery in Asbestos Awareness Professionals seeking to enhance Asbestos Awareness Individuals looking for a Asbestos Awareness career. Anyone passionate about Asbestos Awareness Requirements This Asbestos Awareness doesn't require prior experience and is suitable for diverse learners. Career path This Asbestos Awareness bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included

Food Safety Level 1 Certification  Understanding sanitation is crucial for the two managers and workers in the catering business to guarantee an effective, reputable and safe business! This course gives an exhaustive understanding into each part of sanitation, how to guarantee it, what forestalls it and how you can protect your business and your food. From disclosing how to guard food at each stage, to initiating procedural plans and understanding your legitimate prerequisites, this course covers each angle that everybody in the cooking business has to know. You Will Learn About the dangers to sanitation and how to evade them. Instructions to guarantee sanitation from providers and during transport. Instructions to get ready and serve food securely. About food sensitivities and how to stay away from the dangers. Instructions to be on the correct side of the law by building up a procedural arrangement. Advantages of Taking This Course You will actually want to draw up a food handling procedural arrangement and follow administrative necessities while keeping your clients protected and upbeat. You will actually want to pick your providers and transport strategies admirably and keep away from dangers to food handling. You will actually want to dispense with the danger of hypersensitive responses in any of your food items.