47225 Courses in Sheffield delivered On Demand

Overview Acquire the language of databases with this SQL Programming Complete Bundlecourse. In this data-driven world, data is used to make strategies, find solutions and do a thousand other tasks. Businesses across the world are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This SQL Programming Complete Bundlecourse will teach you the language of databases, SQL, and help you gain proficiency in SQL tools. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this SQL Programming Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our SQL Programming Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 53 lectures • 07:50:00 total length •Introduction: 00:04:00 •Course Curriculum Overview: 00:05:00 •Overview of Databases: 00:10:00 •MySQL Installation: 00:16:00 •MySQL Workbench Installation: 00:09:00 •Connecting to MySQL using Console: 00:09:00 •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 •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 •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 •Timestamps: 00:12:00 •EXTRACT from timestamp: 00:10:00 •Mathematical Functions: 00:12:00 •String Functions: 00:22:00 •SUBQUERY: 00:13:00 •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 •Creating a Database backup: 00:12:00 •10a Overview of Databases and Tables: 00:05:00 •10c Restoring a Database: 00:07:00 •Assignment - SQL Programming Complete Bundle: 00:00:00

Overview This comprehensive course on Sports Massage and Therapy will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Sports Massage and Therapy comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Sports Massage and Therapy. It is available to all students, of all academic backgrounds. Requirements Our Sports Massage and Therapy is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 13 sections • 13 lectures • 04:40:00 total length •Introduction to Sports Therapy: 00:18:00 •Professionalism and Ethics of Sports Therapy: 00:18:00 •Anatomy & Kinesiology: 00:18:00 •Assessment of Sports Injuries: 00:27:00 •Sports Injuries Depend on Sports Profile: 00:23:00 •Common Sports Injuries: 00:33:00 •Major Sports Injure: 00:45:00 •First Aid Treatment: 00:31:00 •Sports Nutrition: 00:17:00 •Rehabilitation Exercise: 00:16:00 •Sports Massage Treatments: 00:18:00 •Hydrotherapy &amp & Electrotherapy: 00:16:00 •Assignment - Sports Therapy: 3 days

Overview This comprehensive course on Spanish Language : Intermediate Level will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Spanish Language : Intermediate Level comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Spanish Language : Intermediate Level. It is available to all students, of all academic backgrounds. Requirements Our Spanish Language : Intermediate Level is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 21 lectures • 03:59:00 total length •Learn Spanish - The Past I- Simple and Compound: 00:10:00 •Learn Spanish - The Past I- Simple and Compound (Contrast): 00:14:00 •Learn Spanish - The Past II- Past Perfect: 00:07:00 •Learn Spanish - The Past III- Past Imperfect: 00:09:00 •Learn Spanish - The past IV- Contrast: 00:10:00 •Learn Spanish - The Gender of nouns: 00:15:00 •Learn Spanish - The Number of nouns: 00:07:00 •Learn Spanish - Informal affirmative imperative 1: 00:11:00 •Learn Spanish - Informal affirmative imperative 2: 00:04:00 •Learn Spanish - Formal affirmative imperative: 00:09:00 •Learn Spanish - Affirmative imperative: 00:12:00 •Learn Spanish - The indefinite: 00:14:00 •Learn Spanish - Quantifiers: 00:16:00 •Learn Spanish - The frequency: 00:14:00 •Learn Spanish - Perfect future: 00:09:00 •Learn Spanish - The simple conditional: 00:10:00 •Learn Spanish - Conditional Sentences: 00:14:00 •Learn Spanish - In the car: 00:10:00 •Learn Spanish - The negative imperative: 00:10:00 •Learn Spanish - Pronouns: 00:10:00 •Learn Spanish - Present Subjunctive: 00:24:00

Overview Get ready to bake, and become skilled enough to create cakes that aren't just delicious but are also works of art. This Sophisticated Baking and Cake Decorating Level 2 course will take your baking skills to the next level and train you to design and serve immaculately decorated treats. You will receive the expert tuition that you'll need to successfully choose a design that fits the event, make the icing and fondant, produce stunning decorations, and assemble everything into a show-stopping centrepiece. Make creative cakes that will bring celebrations and parties to life, and cement your reputation as a star baker. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Sophisticated Baking and Cake Decorating Level 2. It is available to all students, of all academic backgrounds. Requirements Our Sophisticated Baking and Cake Decorating Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 6 lectures • 01:11:00 total length •Module 01: Sophisticated Baking & Cake Design: 00:13:00 •Module 02: Icing: 00:15:00 •Module 03: Fondant Making: 00:12:00 •Module 04: Decorating with Fondant: 00:13:00 •Module 05: Everything in Brief: 00:13:00 •Assignment - Sophisticated Baking and Cake Decorating Level 2: 00:05:00

Overview This comprehensive course on Sage 50 Payroll Advanced Diploma will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Sage 50 Payroll Advanced Diploma comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Sage 50 Payroll Advanced Diploma. It is available to all students, of all academic backgrounds. Requirements Our Sage 50 Payroll Advanced Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 18 sections • 17 lectures • 03:22:00 total length •Module 01: The Outline View and Criteria: 00:11:00 •Module 02: Global Changes: 00:07:00 •Module 03: Timesheets: 00:12:00 •Module 04: Departments and Analysis: 00:11:00 •Module 05: Holiday Schemes: 00:10:00 •Module 06: Recording Holidays: 00:12:00 •Module 07: Absence Reasons: 00:13:00 •Module 08: Statutory Sick Pay: 00:16:00 •Module 09: Statutory Maternity Pay: 00:17:00 •Module 10: Student Loans: 00:09:00 •Module 11: Company Cars: 00:13:00 •Module 12: Workplace Pensions: 00:21:00 •Module 13: Holiday Funds: 00:13:00 •Module 14: Process Payroll (November): 00:11:00 •Module 15: Passwords and Access Rights: 00:08:00 •Module 16: Options and Links: 00:10:00 •Module 17: Linking Payroll to Accounts: 00:08:00

Overview This comprehensive course on Risk Management Level 7 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Risk Management Level 7 comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on thisRisk Management Level 7. It is available to all students, of all academic backgrounds. Requirements Our Risk Management Level 7 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 15 sections • 15 lectures • 05:50:00 total length •Introduction to Risk Management: 00:20:00 •Risk and Types of Risk: 00:20:00 •Benefits of Risk Management: 00:13:00 •Enterprise Risk Management: 00:23:00 •Risk Management Process: 00:11:00 •Risk Analysis & Assessment: 00:28:00 •The Risk Evaluation Process: 00:32:00 •Managing Financial Risks: 00:31:00 •The Fundamentals of Operational Risk Management: 00:31:00 •Managing Technology Risks: 00:19:00 •Managing Legal & Political Risk: 00:23:00 •Environmental Risk Assessment: 00:26:00 •Risk Assessment at Workplace: 00:15:00 •Market & Social Risk Assessment: 00:36:00 •Preparing Risk Management Plan: Step by Step: 00:22:00

Overview This comprehensive course on Restaurant Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Restaurant Management comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Restaurant Management. It is available to all students, of all academic backgrounds. Requirements Our Restaurant Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 22 sections • 22 lectures • 08:59:00 total length •Introduction to Hospitality Management: 00:21:00 •An Overview of Hotel Industry: 00:15:00 •Restaurant Industry: 00:32:00 •Restaurant Leadership and Management: 00:22:00 •The Process of Selection and Recruitment in Hospitality Industry: 00:18:00 •The Process of Development and Training in Hospitality Industry: 00:21:00 •Management of Front Office Operations: 00:16:00 •Management of Food and Beverage Operations: 00:17:00 •Food Safety - An Introduction: 00:26:00 •Supervision of Food Safety: 00:34:00 •Food Safety Legislation: 00:31:00 •Food Safety Management System: 00:41:00 •Food Safety Management Tools: 00:27:00 •Contamination Hazards: 00:26:00 •Controlling Contamination: 00:36:00 •Food Poisoning (Bacterial) and Food-Borne Illness: 00:29:00 •Food Poisoning (Non-Bacterial): 00:29:00 •Personal Hygiene: 00:27:00 •Food Premises and Equipment: The Design and Construction: 00:30:00 •Pest Management: 00:26:00 •Food Safety Training for the Staff: 00:15:00 •Assignment - Restaurant Management: 00:00:00

Overview This comprehensive course on Receptionist will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Receptionist comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Receptionist. It is available to all students, of all academic backgrounds. Requirements Our Receptionist is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 16 sections • 15 lectures • 06:34:00 total length •Introduction to Reception and Receptionist: 00:26:00 •Business Telephone Skills: 00:19:00 •Representing Your Boss and Company: 00:34:00 •Mail Services and Shipping: 00:25:00 •Travel Arrangements: 00:24:00 •Organising Meeting and Conferences: 00:24:00 •Time Management: 00:35:00 •Record Keeping and Filing Systems: 00:28:00 •Business Writing Skills: 00:40:00 •Organisational Skills: 00:25:00 •Communication Skills: 00:25:00 •Customer Service: 00:16:00 •Effective Planning and Scheduling: 00:46:00 •Invoicing/Petty Cash: 00:27:00 •Assignment - Receptionist: 00:00:00

Overview This comprehensive course on Quick Data Science Approach from Scratch will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Quick Data Science Approach from Scratch comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Quick Data Science Approach from Scratch. It is available to all students, of all academic backgrounds. Requirements Our Quick Data Science Approach from Scratch is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 4 sections • 15 lectures • 01:00:00 total length •Introduction: 00:02:00 •Data Science Explanation: 00:05:00 •Need of Data Science: 00:02:00 •8 Common mistakes by Aspiring Data Scientists/Data Science Enthusiasts: 00:08:00 •Myths about Data Science: 00:03:00 •Data Types and Variables: 00:04:00 •Descriptive Analysis: 00:02:00 •Data Cleaning: 00:02:00 •Feature Engineering: 00:02:00 •Data Thinking Development: 00:03:00 •Problem Definition: 00:05:00 •Algorithms: 00:14:00 •Prediction: 00:03:00 •Learning Methods: 00:05:00 •Assignment - Quick Data Science Approach from Scratch: 00:00:00

Overview Enrol in our Quality Management today and build the necessary skills, knowledge and experience to transform your career. The Quality Management could enhance your continuing professional development thus propelling you more towards your dream job. This Quality Management could be your key, if you are interested in a long term career in the field of Quality Management. This Quality Management course consists of a number of easy to digest, in-depth modules which are designed to provide you with detailed knowledge on Quality Management. This Quality Management aims to accompany you through your journey to help you become a master of Quality Management. Learn through a mixture of interactive lessons and online study materials. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Quality Management. It is available to all students, of all academic backgrounds. Requirements Our Quality Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 9 lectures • 02:39:00 total length •Introduction to Quality Management: 00:26:00 •Total Quality Management: 00:17:00 •Quality Measurement and Improvement: 00:25:00 •Quality Control: 00:13:00 •Understanding Customer Expectations and Needs: 00:16:00 •Six Sigma: 00:21:00 •Supply Chain Management: 00:25:00 •Quality Audits: 00:16:00 •Order your Certificate: 00:00:00