6168 Systems courses in Liverpool delivered On Demand

IT support is the backbone of every modern workplace, handling everything from system glitches to data security concerns. This 8 in 1 IT Support Training Premium Bundle delivers a solid grounding in essential IT knowledge, covering cybersecurity, GDPR, and Microsoft Office tools like Word, Excel, Access, and Outlook. It’s tailored for those looking to improve technical understanding and boost their efficiency in digital environments. Alongside the technology, the course includes important regulation insights to help protect data and maintain ethical standards in any organisation. Whether you’re stepping into IT support or enhancing your current role, this bundle equips you with skills to manage systems and information confidently and responsibly. Learning Outcomes Understand core IT principles and system support basics. Learn cybersecurity fundamentals to safeguard digital environments. Gain knowledge of GDPR for data protection awareness. Develop proficiency in Microsoft Word and document creation. Improve spreadsheet skills using Microsoft Excel tools. Explore email management and database basics in Outlook and Access. Who is this Course For Aspiring IT support technicians entering the technology sector. Office staff managing IT-related tasks and communications. Data handlers responsible for maintaining privacy and GDPR rules. IT administrators improving Microsoft Office proficiency. Professionals supporting cybersecurity measures in organisations. Remote workers managing digital files and emails efficiently. Career changers interested in foundational IT and security skills. Helpdesk and technical support staff seeking online training. Career Path IT Support Technician – £22,000 to £30,000 per year Cybersecurity Analyst (Entry level) – £28,000 to £38,000 per year Data Protection Officer – £30,000 to £40,000 per year Microsoft Office Specialist – £24,000 to £32,000 per year Helpdesk Analyst – £22,000 to £29,000 per year IT Administrator – £25,000 to £33,000 per year

Unlock the full potential of product management with our comprehensive course. Dive deep into product management fundamentals, Agile methodologies, and gain hands-on experience with essential project management tools, including Trello, Jira, Microsoft Teams, Planner, and ChatGPT. Elevate your career and drive success in the digital age.

A medical secretary is responsible for ensuring that a doctor's office runs smoothly so that patients receive the best possible care. A medical secretary must understand office organisation and standard procedures to provide this secretarial support. They should also be able to use medical terminologies fluently. This Medical Receptionist Skills will teach you about the medical secretarial profession and the skills needed to do the job successfully. This Course will teach you about the roles and responsibilities of a medical secretary. You will also learn various medical secretary skills, including an effective filing system, medical transcription, medical writing, maintaining medical records, an appointment system, and more. Furthermore, this comprehensive Medical Receptionist Skills will teach you the critical concepts of patient confidentiality and other legal aspects of the healthcare industry. Learning Outcomes After completing this course, learner will be able to: Understand the fundamentals of the National Health Service. Understand the roles and responsibilities of a medical secretary. Know how to organise schedules and manage appointment systems. Gain a clear understanding of the Law, Ethics and Medicine. Gain a thorough understanding of the effective filing system in medical offices. Familiarise yourself with the concept of patient confidentiality and its dos and don'ts. Become skilled at controlling and ordering stocks and supplies. Gain in-depth knowledge of Medical Terminology and Clinical Aspects. Know the importance of health and safety in the healthcare sector. Have a solid understanding of Complementary Medicine Why Choose Diploma in Medical Receptionist and Secretary from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. This Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing this Course. **Courses are included in this Medical Receptionist Skills Bundle Course Course 01: Medical Receptionist Skills Course 02: Dealing With Difficult People Course 03: Communication Skills Course Course 04: Level 4 Time Management Course Course 05: Level 5 Negotiation Skills Course Course 06: Level 5 Report Writing Course Course 07: Level 5 Proofreading & Copy Editing ***Others Included of Medical Receptionist Skills Bundle Course Free 7 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] Detailed course curriculum of the Medical Receptionist Skills: Module 1: The National Health Service History Structure of the NHS The NHS Plan Resource Allocation Delivering Care Mental Health Services Public Health The NHS, the Regions and Devolution Module 2: Patient (Customer) Care The Medical Receptionist Putting Patient First Complaints Within the Health Service The Complaints Procedure Patient and Public Involvement Patient's Rights Access to Health Care Total Quality in Medical Practice Customer Care: Involving Patients and the Public Module 3: Communication Report Writing Electronic Mail & Mobile Phones: Text Messages Telephone Skills People Skills - Face to Face Meeting Performance Review & Counselling The Practice Leaflet & Hospital Information Leaflets Networking Module 4: Law, Ethics and Medicine Medical Ethics and Etiquette Doctor's Duties Patient's Right The Regulatory Bodies and Their Role Legal Aspects Certification Health and Safety at Work Module 5: Health & Safety in a Clinical Environment First Aid at Work Hazardous Substances The NHS National Patient Safety Agency (NPSA) Hepatitis & AIDS Fire Precautions Clinical Risk Management Coping With Aggression & Violence Module 6: Practical Reception Skills in General Practice Record Keeping and General Administration Information Technology Module 7: The Hospital Service The Patient's Route Through the Hospital Outpatient Appointments Admissions from the Waiting List Accident and Emergency Admissions Home From Hospital Support Day Cases and Ward Attendees Hospital Team Clinical Audit Star Ratings What is a Medical Record? Cases Notes Master Index Filing Room or Records Library Medical Records Procedure for Departments Retention of Records Destruction of Medical Records The Role of the Secretary in the Hospital Module 8: Private Medicine Private Clinic or Hospital The Secretary In Private Practice Module 9: Forms, Fees and Finances in General Practises Contracting Finance Practice Income Scotland Wales Northern Ireland Module 10: Using Information Technology Computers in General Practice Electronic Medicine Computers in Hospitals Maintaining Security Module 11: Medical Terminology and Clinical Aspects Pathology and X-ray Examinations Prescribing and Drugs Nurse Prescribing New Developments in Pharmacy Module 12: Audit, Health Economics and Ensuring Quality for the Medical Receptionist and Secretary Audit Health Economics and Cost-effective Medicine Private Finance Initiative Clinical Governance National Institute for Clinical Excellence (NICE) National Clinical Assessment Service (NCAS) National Service Framework (NSF) Patient Surveys Module 13: Complementary Medicine Acupuncture Alexander Technique Aromatherapy Chiropractic Homoeopathy Hydrotherapy Hypnotherapy Osteopathy Reflexology ------------------- ***Communication Skills Course*** Module 01: Introduction to Communication Module 02: The Communication Skills Module 03: Different Types of Communication Module 04: Different Methods of Communication Module 05: Styles of Communication Module 06: Barriers to Communication Module 07: Assessing Communication Competence: Relevant Criteria Module 08: Seven Actions for Effective Communication Module 09: Do's and Don'ts of Effective Communication ------------------- ***Level 4 Time Management Course*** Module 1: Basics of Time Management Module 2: Prioritise Your Time Module 3: Organise Your Time Module 4: Using Your Time Efficiently Module 5: Time Management in the Workplace Module 6: Time Management For Students Module 7: Time Management Software Module 8: Create a Value-Based Time Management Plan ------------------- ***Level 5 Proofreading & Copy Editing*** Module 01: An Overview of Proofreading Module 02: Use of the Style Guide Module 03: Spelling and Grammar Module 04: Paper-based Proofreading Module 05: On the Screen Proofreading Module 06: Basics of Copy Editing Module 07: Copy Editing - the Use of Language Module 08: Copy Editing - Checking Accuracy and Facts Module 09: Copy Editing - Legal Checks Module 10: Career Development ------------------- ***Dealing With Difficult People*** Module 01: Difficult People and Their Difficult Behaviour Module 02: Communicating With Difficult People Module 03: Standing Up to Difficult People Module 04: A Quick Guide to the Seven Classically Difficult Types Module 05: Dealing with Bosses Who Drive You Barmy Module 06: Colleagues to Throttle Module 07: Dealing With Impossible People Module 08: The Temper Tantrum Type ------------------- ***Level 5 Negotiation Skills Course*** Module 01: An Overview of Negotiation Module 02: How to Prepare For Negotiations Module 03: The Process of Negotiation Module 04: Ways of Developing Persuasion & Influencing Skills Module 05: Ways of Developing Communication Skills Module 06: How to Develop Active Listening Skills Module 07: Comprehending Body Language Module 08: Assertiveness and Self Confidence Module 09: Managing Anger Module 10: Managing Stress Module 11: Negotiation Tactics to Closing a Better Deal Module 12: Ways of Overcoming Sales Objections ------------------- ***Level 5 Report Writing Course*** Module 01: Introduction to Report Writing Module 02: The Basics of Business Report Writing Module 03: The Practical Side of Report Writing (Part-1): Preparation & Planning Module 04: The Practical Side of Report Writing (Part-2): Collecting and Handling Information Module 05: The Practical Side of Report Writing (Part-3): Writing and Revising Report Module 06: The Creative Side of Report Writing (Part -1): A Style Guide to Good Report Writing Module 07: The Creative Side of Report Writing (Part -2): Improving the Presentation of Your Report Module 08: Developing Research Skills Module 09: Developing Creativity & Innovation Module 10: Develop Critical Thinking Skills Module 11: Interpersonal Skill Development Assessment Method After completing each module of the Medical Receptionist Skills, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. 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 Medical Receptionist Skills is ideal for Health Care Professionals who work and will be working in healthcare settings such as hospitals, clinics, and healthcare facilities. Requirements There are no specific requirements for this Medical Receptionist Skills because it does not require any advanced knowledge or skills. Career path After completing this Medical Receptionist Skills, you will have developed a set of skills necessary for career advancement and will be able to pursue a variety of job opportunities, including - Medical Receptionist Medical Secretary Healthcare Administrator GP Receptionist Patient Coordinator Certificates Certificate of completion Digital certificate - Included

A medical secretary is responsible for ensuring that a doctor's office runs smoothly so that patients receive the best possible care. A medical secretary must understand office organisation and standard procedures to provide this secretarial support. They should also be able to use medical terminologies fluently. This course will teach you about the medical secretarial profession and the skills needed to do the job successfully. This course will teach you about the roles and responsibilities of a medical secretary. You will also learn various medical secretary skills, including an effective filing system, medical transcription, medical writing, maintaining medical records, an appointment system, and more. Furthermore, this comprehensive Medical Secretary - Essential Skills will teach you the critical concepts of patient confidentiality and other legal aspects of the healthcare industry. Learning Outcomes After completing this course, learner will be able to: Understand the fundamentals of the National Health Service. Understand the roles and responsibilities of a medical secretary. Know how to organise schedules and manage appointment systems. Gain a clear understanding of the Law, Ethics and Medicine. Gain a thorough understanding of the effective filing system in medical offices. Familiarise yourself with the concept of patient confidentiality and its dos and don'ts. Become skilled at controlling and ordering stocks and supplies. Gain in-depth knowledge of Medical Terminology and Clinical Aspects. Know the importance of health and safety in the healthcare sector. Have a solid understanding of Complementary Medicine Why Choose Diploma in Medical Receptionist and Secretary from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Medical Secretary - Essential Skills Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing this Course. **Courses are included in this Medical Secretary - Essential Skills Bundle Course Course 01: Medical Secretary - Essential Skills Course 02: Communication Skills Course Course 03: Level 4 Time Management Course Course 04: Level 5 Proofreading & Copy Editing Course 05: Level 2 Customer Service Course 06: Level 5 Report Writing Course Course 07: Level 5 Negotiation Skills Course ***Others Included of Medical Secretary - Essential Skills Bundle Course Free 7 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] Detailed course curriculum of the Medical Secretary - Essential Skills: Module 1: The National Health Service History Structure of the NHS The NHS Plan Resource Allocation Delivering Care Mental Health Services Public Health The NHS, the Regions and Devolution Module 2: Patient (Customer) Care The Medical Receptionist Putting Patient First Complaints Within the Health Service The Complaints Procedure Patient and Public Involvement Patient's Rights Access to Health Care Total Quality in Medical Practice Customer Care: Involving Patients and the Public Module 3: Communication Report Writing Electronic Mail & Mobile Phones: Text Messages Telephone Skills People Skills - Face to Face Meeting Performance Review & Counselling The Practice Leaflet & Hospital Information Leaflets Networking Module 4: Law, Ethics and Medicine Medical Ethics and Etiquette Doctor's Duties Patient's Right The Regulatory Bodies and Their Role Legal Aspects Certification Health and Safety at Work Module 5: Health & Safety in a Clinical Environment First Aid at Work Hazardous Substances The NHS National Patient Safety Agency (NPSA) Hepatitis & AIDS Fire Precautions Clinical Risk Management Coping With Aggression & Violence Module 6: Practical Reception Skills in General Practice Record Keeping and General Administration Information Technology Module 7: The Hospital Service The Patient's Route Through the Hospital Outpatient Appointments Admissions from the Waiting List Accident and Emergency Admissions Home From Hospital Support Day Cases and Ward Attendees Hospital Team Clinical Audit Star Ratings What is a Medical Record? Cases Notes Master Index Filing Room or Records Library Medical Records Procedure for Departments Retention of Records Destruction of Medical Records The Role of the Secretary in the Hospital Module 8: Private Medicine Private Clinic or Hospital The Secretary In Private Practice Module 9: Forms, Fees and Finances in General Practises Contracting Finance Practice Income Scotland Wales Northern Ireland Module 10: Using Information Technology Computers in General Practice Electronic Medicine Computers in Hospitals Maintaining Security Module 11: Medical Terminology and Clinical Aspects Pathology and X-ray Examinations Prescribing and Drugs Nurse Prescribing New Developments in Pharmacy Module 12: Audit, Health Economics and Ensuring Quality for the Medical Receptionist and Secretary Audit Health Economics and Cost-effective Medicine Private Finance Initiative Clinical Governance National Institute for Clinical Excellence (NICE) National Clinical Assessment Service (NCAS) National Service Framework (NSF) Patient Surveys Module 13: Complementary Medicine Acupuncture Alexander Technique Aromatherapy Chiropractic Homoeopathy Hydrotherapy Hypnotherapy Osteopathy Reflexology ------------------- ***Communication Skills Course*** Module 01: Introduction to Communication Module 02: The Communication Skills Module 03: Different Types of Communication Module 04: Different Methods of Communication Module 05: Styles of Communication Module 06: Barriers to Communication Module 07: Assessing Communication Competence: Relevant Criteria Module 08: Seven Actions for Effective Communication Module 09: Do's and Don'ts of Effective Communication ------------------- ***Level 4 Time Management Course*** Module 1: Basics of Time Management Module 2: Prioritise Your Time Module 3: Organise Your Time Module 4: Using Your Time Efficiently Module 5: Time Management in the Workplace Module 6: Time Management For Students Module 7: Time Management Software Module 8: Create a Value-Based Time Management Plan ------------------- ***Level 5 Proofreading & Copy Editing*** Module 01: An Overview of Proofreading Module 02: Use of the Style Guide Module 03: Spelling and Grammar Module 04: Paper-based Proofreading Module 05: On the Screen Proofreading Module 06: Basics of Copy Editing Module 07: Copy Editing - the Use of Language Module 08: Copy Editing - Checking Accuracy and Facts Module 09: Copy Editing - Legal Checks Module 10: Career Development ------------------- ***Level 2 Customer Service*** Module 1: Introduction to Customer Service Module 2: Understanding the Organisation Module 3: Prepare to Deliver Excellent Customer Service Module 4: Communication in the Customer Service Role Module 5: Understand Customers ------------------- ***Level 5 Report Writing Course*** Module 01: Introduction to Report Writing Module 02: The Basics of Business Report Writing Module 03: The Practical Side of Report Writing (Part-1): Preparation & Planning Module 04: The Practical Side of Report Writing (Part-2): Collecting and Handling Information Module 05: The Practical Side of Report Writing (Part-3): Writing and Revising Report Module 06: The Creative Side of Report Writing (Part -1): A Style Guide to Good Report Writing Module 07: The Creative Side of Report Writing (Part -2): Improving the Presentation of Your Report Module 08: Developing Research Skills Module 09: Developing Creativity & Innovation Module 10: Develop Critical Thinking Skills Module 11: Interpersonal Skill Development ------------------- ***Level 5 Negotiation Skills Course*** Module 01: An Overview of Negotiation Module 02: How to Prepare For Negotiations Module 03: The Process of Negotiation Module 04: Ways of Developing Persuasion & Influencing Skills Module 05: Ways of Developing Communication Skills Module 06: How to Develop Active Listening Skills Module 07: Comprehending Body Language Module 08: Assertiveness and Self Confidence Module 09: Managing Anger Module 10: Managing Stress Module 11: Negotiation Tactics to Closing a Better Deal Module 12: Ways of Overcoming Sales Objections Assessment Method After completing each module of the Medical Secretary - Essential Skills, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Medical Secretary - Essential Skills, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. 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 Medical Secretary - Essential Skills is ideal for Health Care Professionals who work and will be working in healthcare settings such as hospitals, clinics, and healthcare facilities. Requirements Students who intend to enrol in this 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 course, you will have developed a set of skills necessary for career advancement and will be able to pursue a variety of job opportunities, including - Medical Receptionist Medical Secretary Healthcare Administrator GP Receptionist Patient Coordinator Certificates Certificate of completion Digital certificate - Included

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

Are you someone who loves baking cakes and decoration? Do you aspire to become a professional cake decorator? Or are you currently a cake decorating business owner and you want to improve your skills? If yes, then this course is perfect for you and your needs! Description: This course will start by helping you realise that in beginning your new locally established business it might be tiring but you will rapidly find how energizing this industry can be. You will become a little apprehensive when you initially begin but you will then recover when you began this business since you have the energy for designing and having the capacity to communicate inventively. The most critical challenge you can take is to stay engaged in your business and trained in baking and decorating cakes. Start by registering your business to avoid conflicts with the government then start getting the word out to your group by promoting yourself each and every week, until you develop a strong client base. Never forget that your skills needed to be enhanced and this will only be possible the more you practice so whenever you are unsatisfied with a specific style you are working, continue in attempting to perfect it. You will be astounded at how your speed will increase and your capacities with time during the course. Who is the course for? Professionals or Entrepreneurs who are into Cake Decorating business. People who have an interest in starting up a Cake Decorating business. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of applying for NUS Extra Discount Card; 24/7 student support via email. Career Path: Cake Decorating Business Secrets course is a useful qualification to possess, especially to people with careers in: Baking Specialist Cake Decoration Business Owner Cake Decorator Cake Stylists Confectionery Baker Pastry Chef Professional Cake Maker. Course Curriculum Cake Decorating Business Secrets Introduction To Cake Decorating Business Secrets 00:30:00 Getting Started 00:30:00 Marketing Your Cake Decorating Business 00:45:00 Business Cards & Stationery 00:30:00 Selecting The Word Tactfully 00:30:00 Case Study: Promoting On A ShoeString Budget 01:00:00 Tools of The Trade 00:30:00 Lowering Your Business Costs 00:30:00 How To Accept Payment 00:15:00 Home Based Business Taxes 00:30:00 Organising Your Business For Success 00:30:00 Baking Secrets Revealed 00:30:00 Down To Baking Business 00:30:00 Insider Tips From A Professional Baker 00:30:00 Food Safety Tips 00:15:00 Wedding Cake Consultations 00:30:00 Time Management Secrets 00:30:00 It`s a Piece Of Cake 00:15:00 Cake Assembly Instruction 00:30:00 Cake Delivery & Packaging 00:30:00 Action Plan: Checklist 00:30:00 Conclusion: Final Words 00:15:00 Recommended Reading Recommended Reading: Cake Decorating Business Secrets 00:00:00 Mock Exam Mock Exam-Cake Decorating Business Secrets 00:20:00 Final Exam Final Exam-Cake Decorating Business Secrets 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

From the temperature to the storage system, everything needs to be maintained to ensure food safety. Therefore, supervising food safety in catering is a pretty challenging task. The Supervising Food Safety in Catering Level 3 course is designed to make this job easy for you. The Supervising Food Safety in Catering Level 3 course will educate you on food safety legislation. You will learn the principles of the food safety management system. The easy to follow modules will help you attain the skills for controlling contamination, supervising the temperature and pest management. The instructor will teach you the proper methods of waste disposal and cleaning. You will enrich your knowledge of food poisoning and learn to avoid the facts that can cause this disease. Upon successful completion of this Supervising Food Safety in Catering Level 3 course, you will receive a valuable certificate. This certificate will elevate your resume and help you pursue a promising career in the catering industry. Join now and start learning. Learning Objectives Enrich your knowledge of food safety legislation Understand the principles of the food safety management system and its tools Get introduced to the process of controlling contamination Deepen your understanding of food poisoning Develop the skills for supervising the temperature Learn about the proper process of waste disposal, cleaning and disinfecting Gain in-depth knowledge of pest management Who is this Course for? This Supervising Food Safety in Catering Level 3 course is ideal for aspiring professionals in the food industry or those who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of the principles of food hygiene and safety or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course; however, an eye for detail and a creative mind is essential. Entry Requirement This course is available to all learners of all academic backgrounds. A good understanding of the English language, numeracy, and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the Supervising Food Safety in Catering Level 3 course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career Path On successful completion of the Supervising Food Safety in Catering Level 3 course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Food handlers Catering Manager Food Safety Manager Restaurant owners Kitchen Manager Restaurant Manager Food Safety Officer Course Curriculum Module 01: Food Safety - An Introduction Food Safety - Introduction 00:26:00 Module 02: Supervision of Food Safety Supervision of Food Safety 00:34:00 Module 03: Food Safety Legislation Food Safety Legislation 00:28:00 Module 04: Food Safety Management System Food Safety Management Systems 00:41:00 Module 05: Food Safety Management Tools Food Safety Management Tools 00:27:00 Module 06: Microbiology Microbiology 00:25:00 Module 07: Contamination Hazards Contamination Hazards 00:25:00 Module 08: Controlling Contamination Controlling Contamination 00:38:00 Module 09: Food Poisoning (Bacterial) and Food-Borne Illness Food Poisoning (Bacterial) and Food-Borne Illness 00:29:00 Module 10: Food Poisoning (Non-Bacterial) Food Poisoning (Non-Bacterial) 00:29:00 Module 11: Personal Hygiene Personal Hygiene 00:21:00 Module 12: Food and Temperature Control Food and Temperature Control 00:31:00 Module 13: Checking, Verifying and Recording Temperature Checking, Verifying and Recording Temperature 00:22:00 Module 14: Food Spoilage and Preservation Food Spoilage and Preservation 00:35:00 Module 15: Food Premises and Equipment: The Design and Construction Food Premises and Equipment: The Design and Construction 00:30:00 Module 16: Waste Disposal, Cleaning and Disinfection Waste Disposal, Cleaning and Disinfection 00:32:00 Module 17: Pest Management Pest Management 00:26:00 Module 18: Food Safety Training for the Staff Food Safety Training for the Staff 00:15:00 Module 19: Reopening and Adapting Your Food Business During COVID-19 Reopening and Adapting Your Food Business during COVID-19 00:16:00 Mock Exam Mock Exam - Supervising Food Safety in Catering Level 3 00:20:00 Final Exam Final Exam - Supervising Food Safety in Catering Level 3 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Learn new Android APIs such as RoomDatabase, ML Kit for face recognition, Cloud Firestore, Firebase, Maps, and the Android Studio IDE (integrated development environment)

The Agricultural Science Mini Bundle brings together the essentials of plant life, soil health, floral work and the chemical principles behind them. With modules covering botany, chemistry, and greenhouse management, this bundle keeps things grounded yet analytical—perfect for those who enjoy greenhouses as much as they enjoy graphs. From understanding how roots function to learning how floral displays come together, the content delivers just enough complexity without growing wild. The balance of science and aesthetic gives learners a strong entry point into agricultural and plant-focused industries. ✅ Learning Outcomes Learn agricultural foundations including planting and soil composition. Understand plant physiology, parts, and botanical structure identification. Explore chemical reactions relating to plant and soil systems. Gain insight into how greenhouses regulate growth environments. Apply scientific concepts to horticultural and floral contexts. Identify basic floral types, arrangement structures, and classifications. ✅ Who is this Course For New learners exploring scientific concepts in agriculture. Individuals interested in greenhouse or nursery operations. Students keen on both science and floral environments. Hobby growers learning plant care and chemistry basics. Support staff in agricultural or botanical departments. Entry-level horticulture workers handling plant environments. Florists expanding their botanical and growing knowledge. Admins working in agricultural or nursery settings. ✅ Career Path Agricultural Science Assistant – £24,500 average UK salary Greenhouse Technician (Junior) – £25,000 average UK salary Botanical Lab Assistant – £26,000 average UK salary Floristry Technician – £22,000 average UK salary Plant Biology Assistant – £27,000 average UK salary Horticultural Chemist (Junior) – £28,000 average UK salary

The Environmental Science Mini Bundle mixes natural science with public wellbeing and workplace harmony. From botany to gardening and environmental planning, it’s a tidy package for those interested in the roots of sustainability—both literal and professional. Alongside that green focus comes modules on public health and equality—because sustainable systems work better when people and plants are both considered. Whether you're tracking plant growth or managing garden-friendly policies, this bundle keeps things growing in the right direction. ✅ Learning Outcomes Learn how environmental management supports sustainable ecosystems. Understand plant biology and natural growth processes through botany. Recognise workplace practices supporting equity and respectful conduct. Explore the link between public health and environmental surroundings. Gain awareness of safe gardening procedures and planting methods. Apply eco-friendly approaches to health and community projects. ✅ Who is this Course For Learners interested in nature, health and social wellbeing. Gardeners expanding knowledge on botany and sustainability. Council staff working on eco or diversity-led projects. Community workers supporting green or public health initiatives. Environmental assistants needing a broader view of people and nature. Charity volunteers focused on environmental outreach and health. Diversity officers seeking nature-based programme context. Admins supporting eco-awareness or environmental health efforts. ✅ Career Path Environmental Administrator – £28,500 average UK salary Diversity and Inclusion Assistant – £26,000 average UK salary Gardening Project Coordinator – £25,000 average UK salary Public Health Outreach Worker – £27,500 average UK salary Botanical Support Assistant – £24,500 average UK salary Eco Programme Support Officer – £29,000 average UK salary