4167 Administration courses

Advance your career with SENCO - Special Educational Needs Coordination Level 5. Gain expertise in managing SEN support and driving inclusive education strategies.

This course teaches intermediate-level skills in Primavera Project Manager P6 PPM professional client. Explore user and admin preferences, create roles and resources, assign expenses, and resource optimization. Discover methods to resolve conflicts and update schedules. Improve your project management skills with the latest techniques and workshops.

Welcome to the 'Elderly Care Worker' course, your gateway to a fulfilling career in healthcare. In this transformative journey, you will embark on a comprehensive exploration of the healthcare profession, focusing on adult nursing and health and social care training. Our innovative approach to learning will equip you with the knowledge and skills needed to provide exceptional care to elderly individuals. Throughout this course, you'll dive into essential topics such as effective communication, infection control, medication administration, and nutrition. You will also gain a deep understanding of legal and ethical aspects of healthcare, ensuring that you provide care that meets the highest standards. By the end of your training, you'll be well-prepared to make a positive impact on the lives of elderly individuals, promoting their health, well-being, and quality of life. Learning Outcomes Master the fundamentals of nursing and healthcare. Demonstrate effective communication in a healthcare setting. Ensure the safety and well-being of patients through infection control. Administer medications with precision and care. Provide comprehensive health and social care to elderly individuals. Why choose this Elderly Care Worker course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments 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. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Elderly Care Worker course for? Aspiring healthcare professionals. Individuals passionate about elderly care. Students pursuing a career in nursing. Those looking to make a meaningful difference in the lives of the elderly. Anyone seeking a rewarding career in healthcare. Career path Elderly Care Worker: £18,000 - £25,000 Registered Nurse: £24,000 - £39,000 Healthcare Assistant: £17,000 - £21,000 Nursing Home Manager: £30,000 - £45,000 Community Support Worker: £18,000 - £25,000 Social Worker: £25,000 - £40,000 Prerequisites This Elderly Care Worker 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. Course Curriculum Adult Nursing Training Module 01: Introduction to Nursing 00:17:00 Working in Different Healthcare Settings 00:15:00 Module 03: Understanding legal, professional standards of practice and ethical aspects of health care- Part 1 00:52:00 Module 04: Understanding legal, professional standards of practice and ethical aspects of health care- Part 2 00:50:00 Module 05: Effective Communication in Nursing 00:47:00 Health and Safety in Nursing 00:47:00 Hygiene in Nursing 00:30:00 Infection Control 00:57:00 Asepsis in Nursing 00:16:00 Medication Administration in Nursing 00:18:00 Module 11: Adult Care in Different Life Stages 00:17:00 Module 12: Understanding Immune System in Nursing 00:28:00 Module 13: Rest and Sleep Management in Nursing 00:19:00 Module 14: Mobility and Immobility Issues of Patients in Nursing 00:17:00 Module 15: Pain Management for Nurses 00:24:00 Module 16: Nutrition in Nursing 00:25:00 Module 17: Fluid and Electrolyte Balance 00:23:00 Module 18: Assisting with Elimination 00:30:00 Module 19: Oxygenation in Nursing 00:30:00 Health and Social Care Training Module 01: Introduction to Health and Social Care 00:19:00 Communication and its Relevance 00:41:00 Rights and Responsibilities as a Health and Social Care Worker 00:39:00 Role as A Caregiver and Healthcare Professional 00:23:00 Working in Health and Social Care; Promoting Equality, Diversity and Rights 00:46:00 Important Principles and Policies in Health and Social Care Work 00:20:00 Module 7: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 00:50:00 Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 2 00:48:00 Safeguarding Vulnerable Individuals 00:49:00 Health and Safety Responsibilities 00:51:00 Module 11: Risk Management in Health and Social Care 00:03:00 Mock Exam Mock Exam - Elderly Care Worker 00:20:00 Final Exam Final Exam - Elderly Care Worker 00:20:00

Welcome to a transformative journey into the world of finance with our course, 'Accounting Essentials and UK Taxation.' Picture a learning adventure where accounting principles come alive, and the intricacies of UK taxation unfold like a captivating narrative. In Module 01, you'll traverse the landscape of accounting, laying the foundation with an enchanting introduction. As you progress, modules become chapters in an epic tale, covering income statements, balance sheets, and the symphony of trial balances, fixed assets, and stock movements. Unlock the secrets of the UK tax system in Module 04, exploring individual and corporate taxation, National Insurance, and the art of submitting a self-assessment tax return. The finale, Module 13, unveils the grandeur of a career as a Tax Accountant in the UK, inviting you to join the league of financial maestros. Learning Outcomes Foundational Accounting Mastery: Develop a solid understanding of accounting principles. UK Taxation Proficiency: Navigate the complexities of the UK tax system. Practical Tax Return Submission: Learn the art of submitting a self-assessment tax return. Double Entry Accounting Expertise: Master the technique of double-entry accounting. Career-Ready Skills: Prepare for a rewarding career as a Tax Accountant in the UK. Why choose this Accounting Essentials and UK Taxation course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments 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. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Accounting Essentials and UK Taxation course for? Aspiring accountants seeking comprehensive knowledge. Individuals interested in UK tax regulations. Entrepreneurs managing their financial affairs. Students pursuing accounting and finance studies. Professionals wanting to enhance their financial acumen. Career path Tax Accountant: £30,000 - £50,000 Financial Analyst: £32,000 - £45,000 Audit Manager: £40,000 - £60,000 Corporate Tax Advisor: £35,000 - £55,000 Management Accountant: £35,000 - £50,000 Financial Controller: £45,000 - £70,000 Prerequisites This Accounting Essentials and UK Taxation does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Accounting Essentials and UK Taxation 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. Course Curriculum Module 01: Introduction to Accounting Introduction 00:03:00 First Transactions 00:05:00 T Accounts introduction 00:03:00 T-Accounts conclusion 00:03:00 Trial Balance 00:02:00 Income Statement 00:03:00 Balance Sheet 00:03:00 Module 02: Income Statement and Balance Sheet Balance Sheet Variations 00:03:00 Accounts in practise 00:05:00 Balance Sheets what are they 00:05:00 Balance Sheet Level 2 00:03:00 Income Statement Introduction 00:06:00 Are they Expenses or Assets 00:03:00 Accunting Jargon 00:02:00 Module 03: Trial Balance, Fixed Assets and Stock Movements Accruals Accounting is Fundemental 00:03:00 Trial Balance 3 days ago More 00:04:00 Fixed Assets and how it is shown in the Income Statement 00:03:00 Stock movements and how this affects the financials 00:03:00 Accounts Receivable 00:03:00 How to calculate the Return on Capital Employed 00:05:00 Transfer Pricing - International Rules 00:02:00 Module 04: Tax System and Administration in the UK Tax System and Administration in the UK 00:25:00 Module 05: Tax on Individuals Tax on Individuals 00:23:00 Module 06: National Insurance National Insurance 00:13:00 Module 07: How to Submit a Self-Assessment Tax Return How to Submit a Self-Assessment Tax Return 00:12:00 Module 08: Fundamentals of Income Tax Fundamentals of Income Tax 00:22:00 Module 09: Payee, Payroll and Wages Payee, Payroll and Wages 00:18:00 Module 10: Value Added Tax Value Added Tax 00:24:00 Module 11: Corporation Tax Corporation Tax 00:17:00 Module 12: Double Entry Accounting Double Entry Accounting 00:11:00 Module 13: Career as a Tax Accountant in the UK Career as a Tax Accountant in the UK 00:16:00

FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter

***24 Hour Limited Time Flash Sale*** Computer Maintenance Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Do you ever feel frustrated by your computer running slow, crashing unexpectedly or showing error messages? According to a recent study by YouGov, nearly 70% of UK adults have experienced a computer problem they couldn't fix themselves. This comprehensive Computer Maintenance Bundle equips you with the skills to not only troubleshoot these everyday issues but potentially pursue a career in IT support. Are you ready to take control of your technology and maybe even help others with theirs? This extensive bundle offers a one-stop shop for everything computer maintenance related. Whether you're a complete beginner or an experienced IT professional, you'll find a course to suit your needs. Learn how to build your own PC, troubleshoot Windows 10 issues, and become a certified computer maintenance specialist. Power up your knowledge of electrical systems and network security. The bundle even covers essential soft skills like communication and critical thinking, making you a well-rounded IT professional. Courses are Included in This Computer Maintenance Bundle: Course 01: Building Your Own Computer Course 02: Electronic & Electrical Devices Maintenance Course 03: PAT Level 4 Course 04: Complete Windows 10 Troubleshooting for IT Helpdesk Course 05: Computer Maintenance Specialist Training Course 06: Certificate in Computer Operating System and Troubleshooting Course 07: Display Screen Equipment (DSE) Course 08: Basic Electricity Course Course 09: Computer Hacking Forensic Investigator Course 10: IT Support Technician Course 11: Internet and Computing - Tools & Networking Guide Course 12: Information Technology and Networking Course 13: Cyber Security Awareness Training Course 14: Cyber Security Incident Handling and Incident Response Course 15: IT Administration and Networking Course 16: CompTIA Network+ Certification Course 17: CompTIA Security+ Certification Course 18: Cisco ASA Firewall Training Course 19: Digital Risk Protection Training Course 20: Data Protection Assistant Course 21: Data Center Training Essentials: Power & Electrical Course 22: Workplace Confidentiality Course 23: Information Management Course 24: Effective Communication Skills Course 25: Network Security Level 2 Course 26: Encryption Course 27: Decision Making and Critical Thinking Course 28: Internet of Things Course 29: Functional Skills IT Course 30: Web Application Penetration Testing Course Take control of your technology and open doors to exciting new career opportunities. This computer maintenance bundle equips you with the knowledge and skills to diagnose, solve, and prevent computer problems. Enrol today and take the first step towards a successful IT career! Learning Outcomes of Computer Maintenance Gain proficiency in building, maintaining, and troubleshooting computer systems. Master essential IT support skills for resolving common Windows 10 issues. Prepare for industry-recognized certifications like CompTIA Network+ and Security+. Develop a strong understanding of network security principles and data protection practices. Enhance your communication and decision-making skills for a successful IT career. Explore emerging technologies like the Internet of Things (IoT) and web application security. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Computer Maintenance Get a free student ID card with Computer Maintenance Training program (£10 postal charge will be applicable for international delivery) The Computer Maintenance is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Computer Maintenance course materials The Computer Maintenance comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Building Your Own Computer Module 01: Introduction To Computer & Building PC Module 02: Overview Of Hardware And Parts Module 03: Building The Computer Module 04: Input And Output Devices Module 05: Software Installation Module 06: Computer Networking Module 07: Building A Gaming PC Module 08: Maintenance Of Computers Course 02: Electronic & Electrical Devices Maintenance Section 1: Introduction & Getting Started Section 2: Electronic And Electrical Maintenance Repair Section 3: Tools Needed Section 4: Electronic Components Section 5: Testing Section 6: Troubleshooting Section 7: Introduction To Electronic Components: A Step By Step Guide Course 03: PAT Level 4 Module 01: Introduction To PAT Module 02: Relevant Statutory Provisions For PAT Module 03: Safety Responsibilities & Maintenance Provisions Module 04: Risk Assessment Module 05: Reducing And Controlling Risks Module 06: Electrical Units And Appliance Classification Module 07: Equipment Coverage & Maintenance Needs Module 08: Initial Visual Examination Module 09: Instruments For Testing And Equipment Inspection Module 10: Electrical Installation Testing Module 11: Lead & RCD Testing Module 12: Safety Precautions In Electrical Testing Module 13: Reporting And Record-Keeping Module 14: Testing For New Or Used Equipment Module 15: British Standards And Latest Changes =========>>>>> And 27 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*30 = £389) CPD Hard Copy Certificate: Free ( For The First Course: Previously it was £29.99) CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: DIY Tech Enthusiasts IT Support Aspirants Cybersecurity Professionals Network Administrators Data Protection Specialists Career Changers Career Path Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. IT Technician Helpdesk Analyst Network Engineer Security Analyst Data Center Specialist IT Consultant Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

***24 Hour Limited Time Flash Deal*** Recruitment: HRM, External & Internal Sources Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Recruitment: HRM, External & Internal Sources Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Recruitment: HRM, External & Internal Sources bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Recruitment: HRM, External & Internal Sources Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Recruitment: HRM, External & Internal Sources Career Bundle: Course 01: Recruitment Officer Diploma Course 02: HR and Recruitment Consultant Training Course 03: HR and Marketing Level 4 Course 04: Human Resources (HR) Audit Course 05: HR Assistant Skills Certification Course 06: Employment Law Course 07: HR - Crisis Communication Course 08: Key Performance Indicators Professional Course 09: Payroll Management Course Course 10: Virtual Interviewing for HR Course 11: Virtual Training Masterclass Course 12: Office Administration Certificate Course 13: Complete Guide to HR systems Course 14: Motivational Interviewing Course 15: People Management Skills Level 3 Course 16: HR Practice Essentials Level 4 Course 17: Dealing With Difficult People Training Course Course 18: Contract Manager Diploma Course 19: Stress Management Training Course 20: Team Management Course 21: Delegation Skills Course 22: Emotional Intelligence and Human Behaviour Course 23: Public Speaking and Presentation Skill Course Course 24: Positive Psychology Masterclass Course 25: HR and Payroll Management Course 26: HR Management Course Course 27: Organizational Behaviour, HR and Leadership Course 28: Crisis Communication for HR Course 29: Recruitment Consultant Diploma Course 30: Recruitment and Selection With Recruitment: HRM, External & Internal Sources, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Recruitment: HRM, External & Internal Sources today and take the first step towards achieving your goals and dreams. Why buy this Recruitment: HRM, External & Internal Sources? Free CPD Accredited Certificate upon completion of Recruitment: HRM, External & Internal Sources Get a free student ID card with Recruitment: HRM, External & Internal Sources Lifetime access to the Recruitment: HRM, External & Internal Sources course materials Get instant access to this Recruitment: HRM, External & Internal Sources course Learn Recruitment: HRM, External & Internal Sources from anywhere in the world 24/7 tutor support with the Recruitment: HRM, External & Internal Sources course. Start your learning journey straightaway! *** Course Curriculum *** Course 01: Recruitment Officer Diploma Module 01: Introduction To Recruitment Process Model Module 02: Recruitment Method Module 03: Human Resource Management Module 04: Key Skills And Issues In Recruitment Module 05: Virtual Interviewing Module 06: Employee On-Boarding Course 02: HR and Recruitment Consultant Training Module 1 - Introduction To Recruitment: Importance And Implications Module 2 - An Overview Of The Recruitment Industry Module 3 - The UK Recruitment Legislation Module 4 - Sales And Selling In The Recruitment Industry Module 5 - The Recruitment Process Module 6 - Key Performance Indicators For The Recruitment Industry Module 7 - Candidate Attraction For Recruitment Module 8 - Candidate Management Module 9 - Candidate Interview Processes Module 10 - Client Acquisition Module 11 - Client Strategy In The Recruitment Sector Module 12: Client Management Module 13 - Steps To Starting And Running A Successful Recruiting Service Course 06: Employment Law Module 01: Basic Of Employment Law Module 02: Legal Recruitment Process Module 03: Employment Contracts Module 04: Employee Handbook Module 05: Disciplinary Procedure Module 06: National Minimum Wage & National Living Wage Module 07: Parental Right, Sick Pay & Pension Scheme Module 08: Discrimination In The Workplace Module 09: Health & Safety At Work Module 10: Dismissal, Grievances And Employment Tribunals Module 11: Workplace Monitoring & Data Protection =========>>>>> And 27 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*30 = £389) CPD Hard Copy Certificate: £29.99 CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Recruitment: HRM, External & Internal Sources course is ideal for: Students seeking mastery in Recruitment: HRM, External & Internal Sources Professionals seeking to enhance Recruitment: HRM, External & Internal Sources skills Individuals looking for a Recruitment: HRM, External & Internal Sources-related career. Anyone passionate about Recruitment: HRM, External & Internal Sources Requirements This Recruitment: HRM, External & Internal Sources doesn't require prior experience and is suitable for diverse learners. Career path This Recruitment: HRM, External & Internal Sources 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 If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

A dental nurse is a crucial member of the dental team who assists each team member as needed. Dental nurses must be personable, dependable, calm, and flexible enough to react to unforeseen circumstances as they occur. This Dental Nurse course will give you many insights into the profession. You would strive for and receive assistance in achieving the highest knowledge and skill levels. The interests of the patients must always come first, among other clinical, technical, and professional qualities, as well as being able to recognise and respect their limitations - all these topics are covered in this training. The dental nurse course aims to develop people who can prove they have the skills to achieve the results necessary to become dental experts. Enrol in the Dental Nurse course now and learn the knowledge, skills, and attitudes required to thrive in the field. This Dental Nurse Bundle Consists of the following Premium courses: Courses are included in this Dental Nurse Bundle? Course 01: Dental Nurse Course 02: Medical Receptionist: Responsibilities and Skills Course 03: Sterile Services Technician Training Level 4 Course 04: Medical Law Course 05: Medication Administration Level 4 Course 06: Medical Transcription Course 07: Wound Care Level 2 Course 08: GDPR in Healthcare Course 09: Workplace Mental Health First Aid and Advocacy Training Course 10: Immunisation Nurse Course 11: Infection Prevention Training Learning Outcome Dental Nurse Course: Get introduced to the basics of dental nursing. Know about the required clinical and technical skills to deliver direct care. Learn about essential communication skills. Acquire the professionalism to put patients' needs first and promote confidence in the dental team. Gain the skills and knowledge required to work effectively in a dental team. Enrol now in Dental Nurse To advance your career and use the premium study materials from Apex Learning. The Dental Nurse bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Dental Nurse Expertise and essential knowledge, which will assist you in reaching your goal. Course Curriculum: Dental Nurse Module 01: Introduction to Dental Assisting Module 02: General Dentistry Instruments Module 03: Dental Office Management Module 04: Oral Diagnosis, Treatment Planning and Dental Terminology Module 05: General Handling and Safety of Dental Materials in the Dental Office Module 06: Infection Control and Instruments Module 07: Dental Radiology Module 08: Paediatric Dentistry Module 09: The Professional Dental Assistant Module 10: Standards of Dental Practice in the UK CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Dental Nurse Bundle. Please note: This Dental Nurse course doesn't entitle you to practice as a professional in this specific field. Rather, this course will assist you in understanding the fundamentals so that you can improve your knowledge in the relevant field. Requirements This Dental Nurse Course has been designed to be fully compatible with tablets and smartphones. Career path Dental Nurse Upon completing this course, you will have the knowledge to pursue a career as a Dental Nurse or onto other career pathways. For example, Dental Hygienist, Senior Nurse, Laboratory Technician, Teachers and Assessor of trainee Dental Nurse. In the UK, Dental nurse salaries vary from £28,000 to £58,500 annually. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Dental Nurse) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.

Understanding the Safe Handling of Medication in Health & Social Care The purpose of this Level 2 - Understanding the Safe Handling of Medication in Health & Social Care course is to provide everyone who is involved in the care sector with the essential knowledge required to provide the best professional approach to the managing and safe handling of medicines. The Level 2 - Understanding the Safe Handling of Medication in Health & Social Care qualification covers the different medications and their applications. You will also learn how to safely store and dispose of medicines, how to administer medicines safely, and how to ensure that record-keeping and audits are completed properly. Learning Outcomes After completing this Level 2 - Understanding the Safe Handling of Medication in Health & Social Care course, the learner will be able to: Gain a general understanding of different types of medication and their use. Gain in-depth knowledge of the procedures for obtaining, storing, administering and disposing of medication. Understand the legislation and the audit process related to medication and issues of responsibility and accountability. Understand the record-keeping process for medication. ***Courses are included in this Level 2 - Safe Handling of Medication in Health & Social Care Bundle Course Course 01: Level 2 - Safe Handling of Medication in Health & Social Care Course 02: Level 6 Diploma in Health and Social Care Management Course 03: Level 3 Diploma in Healthcare Support Course 04: Level 2 Award in Support Work in Schools and Colleges Course 05: Level 2 Certificate in Understanding Nutrition and Health Course 06: Social Worker: Social Work Diploma Course 07: Drug and Alcohol Awareness Training Course 08: Healthcare Management Training [ Note: Free PDF certificate as soon as completing the Level 2 - Safe Handling of Medication in Health & Social Care course] Understanding the Safe Handling of Medication in Health & Social Care Course Curriculum of Level 2 - Understanding the Safe Handling of Medication in Health & Social Care Module 01: Understand Medication and Prescriptions Module 02: Supply, Storage and Disposal of Medication Module 03: Understand the Requirements for the Safe Administration of Medication Module 04: Record Keeping and Audit Processes for Medication Assessment Method of Understanding the Safe Handling of Medication in Health & Social Care After completing each module of the Understanding the Safe Handling of Medication in Health & Social Care Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Understanding the Safe Handling of Medication in Health & Social Care After completing the MCQ/Assignment assessment for this Understanding the Safe Handling of Medication in Health & Social Care course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Understanding the Safe Handling of Medication in Health & Social Care This qualification is ideal for students who want to improve their knowledge of the safe handling of medicines. Requirements Understanding the Safe Handling of Medication in Health & Social Care There are no specific requirements for this Certificate in Understanding the Safe Handling of Medication in Health & Social Care course because it does not require any advanced knowledge or skills. Career path Understanding the Safe Handling of Medication in Health & Social Care Level 2 - Understanding the Safe Handling of Medication in Health & Social Care course is designed for anyone who wants to start a career in care and wishes to handle medication. It can lead to roles such as Care Worker or Pharmacy Assistant. Certificates Certificate of completion Digital certificate - Included