6198 Courses in Cardiff delivered On Demand

This course delves into the complex relationship between safeguarding practices and counseling techniques. It explores the causes and types of depression, as well as various treatment approaches including medication and complementary therapies. Discover how counseling plays a vital role in addressing depression, exploring different approaches, and offering additional study materials to deepen your knowledge. Learning Outcomes: Understand the underlying causes of depression. Identify and differentiate between various types of depression. Explore the range of medication options for depression treatment. Learn about complementary alternative therapies for managing depression. Examine counseling approaches tailored to addressing depression. Develop insights into the intersection of safeguarding and counseling. Gain practical knowledge to support individuals dealing with depression. Access additional study materials for comprehensive learning. Why buy this Safeguarding and Counselling?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Safeguarding and Counselling you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Safeguarding and Counselling course is ideal for Mental health professionals and counselors. Healthcare practitioners. Individuals interested in mental health and wellbeing. Students pursuing psychology or counseling studies. Prerequisites This Safeguarding and Counselling was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Licensed Professional Counselor - Average Earnings: $40,000 - $70,000 per year. Clinical Psychologist - Average Earnings: $60,000 - $120,000 per year. Mental Health Therapist - Average Earnings: $40,000 - $70,000 per year. Social Worker (Mental Health) - Average Earnings: $40,000 - $70,000 per year. Psychiatric Nurse Practitioner - Average Earnings: $100,000 - $150,000 per year. Course Curriculum Safeguarding and Counselling Course Module 01: Introduction to Safeguarding 00:21:00 Module 02: An Introduction to Safeguarding of Vulnerable Adults 00:30:00 Module 03: Laws and Guidance 00:43:00 Module 04: Safeguarding Legislations 00:30:00 Module 05: Understanding Abuse and Neglect 00:36:00 Module 06: Child Abuse 00:49:00 Module 07: Sexual Abuse 00:38:00 Module 08: Understanding the Importance of Communication in Care 00:30:00 Module 09: Sharing Information and Responding To a Disclosure 00:30:00 Module 10: Record Keeping 00:18:00 Module 11: Risks and Risk Assessment 00:16:00 What Causes Depression Introduction 00:05:00 Melancholy and the History of Counselling 00:07:00 Signs of Depression 00:07:00 Depression and the Brain 00:06:00 Depression and Neurons 00:09:00 Stress and depression 00:10:00 Environmental and Health Factors 00:04:00 Depression and Sleep Disorders 00:06:00 Somatic Symptoms 00:06:00 Risk Factors 00:07:00 Module 1: Assessment Questions 00:05:00 Different Types of Depression Classifying Depression & Different Classification Methods 00:07:00 Cyclothymia 00:06:00 Depression and Creative Minds 00:07:00 Dysthymia, Pre-Menstrual Dysphoric Disorder, and Atypical Depression 00:07:00 Bipolar / Manic Depression 00:06:00 Antenatal & Postpartum Depression 00:09:00 Bereavement and Grief 00:09:00 Dysthymia in Children and Adolescents 00:04:00 Depression and the Elderly 00:06:00 Psychosocial & Health Factors in the Elderly 00:03:00 Module 2: Assessment Questions 00:04:00 Different Types of Medicine Neurogenesis 00:04:00 Monoamine Oxidase Inhibitors 00:04:00 Serotonin Syndrome 00:03:00 Selective Serotonin Reuptake Inhibitors 00:03:00 Tyramine 00:03:00 Medication Statistics and Doctors in the UK & USA 00:10:00 Module 3: Assessment Questions 00:03:00 Complementary Alternative Therapies Lifestyle management, Diet, Exercise, Meditation 00:07:00 St John's Wort (hypericum perforatum) 00:05:00 Omega 3 Fatty Acids 00:04:00 Tai chi, Qigong 00:04:00 Yoga 00:04:00 Acupuncture 00:03:00 Art Therapy & Music Therapy 00:08:00 Module 4 Assessment Questions 00:04:00 Counselling Approaches to Depression Person Centred Therapy 00:07:00 Family or Couples Therapy 00:09:00 Stepped Care Model (approach) 00:10:00 Psychodynamic/Dynamic Interpersonal Therapy 00:06:00 Rational Emotive Behavioural Therapy 00:06:00 Clinical Hypnotherapy & Cognitive Behavioural Therapy 00:05:00 Clinical Hypnotherapy for Post Traumatic Stress Disorder 00:05:00 Gestalt Therapy 00:06:00 The Therapeutic Relationship 00:07:00 Knowledge and Qualities Necessary to a Counsellor 00:03:00 Module 5 assessment questions 00:03:00 Thank You and Good Bye! 00:03:00 Additional Study Materials Additional Study Materials: Safeguarding and Counselling 00:00:00

This Paediatric First Aid Course will teach you how to give first aid to children during emergency situations.

The demand for highly skilled educators has never been higher in the United Kingdom. To excel in the dynamic world of education, teachers need more than just subject knowledge – they require a holistic set of management skills to foster an enriching learning environment. That's where our Management Skills Bundle Course for Teachers comes into play!

Food Safety in a 'Catering' Environment (Level 1) Approved Online Training

Level 1, 2 & 3 Diploma in Animal Care and First Aid Training This Animal Care course is designed to transform you into a connoisseur of animal care and welfare. Developed with precision and expertise, this all-encompassing animal care course unfolds the multi-faceted world of animal well-being, covering everything from basic health and nutrition to advanced animal care topics like Animal Psychology and First Aid. Learning Outcomes: Define 'animal care & welfare' with precision, assimilating the legal and ethical ramifications. Gain an authoritative grasp on animal care by learning how to meticulously assess an animal's health status by understanding behavioural, physical, and physiological indicators. Obtain a comprehensive list of animal health aspects that are crucial for animal care worker in maintaining an animal's well-being. Grasp the importance of treatments, and delve into the specifics of administering proper animal care, including protocols vital for recovery and ongoing health. Familiarise yourself with the imperative of microchipping, a cornerstone in modern animal care that safeguards against loss and aids in quick identification. Attain a comprehensive grasp of pet nutrition essentials, enabling you to make informed choices for sustaining animal care, health and well-being. Acquire specialised knowledge in animal first aid, including essential skills in managing cardiac and respiratory emergencies and administering CPR. Manage allergic reactions effectively, and ascertain how to position an animal during emergencies for optimal recovery. Learn to counteract animal poisoning, insect stings, heatstroke, and shock. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Level 1, 2 & 3 Diploma in Animal Care and First Aid Training Course Syllabus Animal Care & Welfare: Gain a comprehensive understanding of the principles and practices essential to Animal Care and welfare. This module is engineered to provide learners with a holistic understanding of the three foundational pillars of animal care & welfare: a robust biological function, a stable emotional state, and the liberty to manifest natural behaviours. Animal Health & Nutrition in Animal Care: This module is skillfully curated to equip you with the essentials for fostering a thriving environment for animals. Recognise the integral role a sound health and nutrition system plays in elevating the quality of life for your pets or animals under professional animal care. Master the fundamentals of animal health and nutrition as they relate to comprehensive Animal Care. Hygiene And First Aid for Animals: Acquire skills in maintaining hygiene and administering first aid in the context of Animal Care. Delve into the nitty-gritty of animal first aid, a crucial skill set for both pet owners and professionals. Learn what constitutes first aid, why it's indispensable, and the situations that demand veterinary intervention. This module educates you on identifying the main classifications of emergencies, including life-threatening situations that require immediate attention. Getting to Know The Dogs & Puppies: This section aims to enhance your relationship with arguably the most loyal companions in the animal kingdom: dogs. Despite their famed loyalty and affection, dogs can sometimes exhibit behaviours that are perplexing or challenging. This module helps demystify those behaviours, ushering you into a realm of understanding that elevates your interaction with dogs to unprecedented levels. Understand the specific needs and behaviours of dogs and puppies for effective Animal Care. Getting to Know The Kittens And Cats: This section kicks off with a deep dive into feline behavior. Explore the multifaceted aspects of what makes a cat tick, whether it's their notorious independence or their elusive playfulness. Decode the enigmatic nature of cats, ranging from their grooming habits to their complex social cues, so that you can appreciate and respond to them in a more meaningful way. Learn about the unique requirements and characteristics of kittens and cats in Animal Care. Animal Psychology through Animal Care: Gain insights into animal psychology and behaviour to enhance your Animal Care practices. Animal Psychology serves as an intellectual nexus where science meets empathy, dissecting the fascinating world of animal minds across different species. In this advanced and stimulating module, you'll embark on an investigative journey to unravel the cognitive and emotional intricacies of the animals that share our world, elevating your understanding from mere observation to deeply informed comprehension.

Learning Outcomes Build your expertise in employee selection and requirement Understand the process of performance appraisal management Learn about the accounting methods used in bookkeeping and payroll Develop the skills for financial budgeting, planning and control Enrich your knowledge of the principles of the payroll system Grasp the expertise for effective payroll processing Diploma in HR Bookkeeping and Payroll Management Description Every organisation needs skilled professionals to manage the employees and handle the accounts. That's why skilled HR professionals and bookkeepers are always in high demand. So, if you are looking for a demanding job with a lucrative salary, HR, bookkeeping, or payroll can be an excellent choice. Grab the chance to prepare yourself to pursue a career in these sectors with the Diploma In HR Bookkeeping And Payroll Management. Through this comprehensive course, you will get to learn the essentials of HR management, bookkeeping and payroll management. The course will provide you with an in-depth understanding of the recruitment process. It will teach you how to manage the employees and motivate or counsel them when necessary. In addition, you will learn the core strategies of bookkeeping and payroll management. The course will help you grasp the key skills to handle the financial aspects with proficiency. Then the course will help you develop a solid understanding of the payroll system. At the end of the course, you will receive a certificate of achievement endorsed by QLS. This certificate will add significant value to your resume and boost your employability. So, join now! Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. Method of Assessment At the end of the course, there will be an online MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, our team will examine it and deliver feedback.  Career path This course will help you develop a clear understanding of this area. After completing the course, you will be able to explore career options such as HR Professional Bookkeeper Payroll Manager Accountant Course Content HR & Leadership Human Resource Management Bookkeeping & Payroll Basics Managing Payroll

Description: Human Resource Management is part of a business that deals with managing the performance of employees in an organisation or business. The primary responsibility of this department is to ensure that employees are following the policies and systems of the business. To become part of the human resource management, you need to learn how to deal with employees, colleagues or contractors. Since the primary concern of this department is about organisation system and relationship, you have to learn how to implement these to all the manpower of your organisation. This course will be providing all the necessary lessons on human resource management and how to successfully help the development of the business you are part of. Who is the course for? Human Resources Management officers who want to learn more about their department. People who have an interest in knowing about human resources management. 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 the cost of £39 or in PDF format at the 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 recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Advanced Diploma in HR Management course is a useful qualification to possess, and would be beneficial for the following careers: Businessmen Consultant Human Resource Officer Labour Relations Officer Recruitment and Hiring Manager Relations Manager. Introduction To HR Management Module One - Getting Started 00:30:00 Module Two - Human Resources Today 01:00:00 Module Three - Recruiting and Interviewing 01:00:00 Module Four - Retention and Orientation 01:00:00 Module Five - Following Up With New Employees 01:00:00 Module Six - Workplace Health & Safety 01:00:00 Module Seven - Workplace Bullying, Harassment, and Violence 01:00:00 Module Eight - Workplace Wellness 01:00:00 Module Nine - Providing Feedback to Employees 01:00:00 Module Ten - Disciplining Employees 01:00:00 Module Eleven - Terminating Employees 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Diploma in Human Resource Management 00:00:00 HR and Leadership INTRODUCTION 00:30:00 WHAT MAKES A GREAT LEADER? 01:00:00 HOW TO INSPIRE YOUR TEAM 01:00:00 HOW TO INCENTIVIZE THE RIGHT WAY 01:00:00 HOW TO INCREASE YOUR CHARISMA AND AUTHORITY 01:00:00 HOW TO DEAL WITH A CRISIS 01:00:00 IS IT BETTER TO BE FEARED OR LIKED? 01:00:00 DEALING WITH DISSIDENTS 01:00:00 CREATING TEAMS AND ENCOURAGING TEAMWORK 00:30:00 UNDERSTANDING CHARACTERS AND CHOOSING THE RIGHT PERSON 00:30:00 THE 10 MOST POWERFUL TIPS FOR LEADERS 00:30:00 CONCLUSION 00:15:00 HR and Employee Onboarding Module One - Getting Started 00:30:00 Module Two - Purpose of Onboarding 01:00:00 Module Three - Introduction 01:00:00 Module Four - Onboarding Preparation 01:00:00 Module Five - Onboarding Checklist 01:00:00 Module Six - Creating an Engaging Program 01:00:00 Module Seven - Following Up with New Employees 01:00:00 Module Eight - Setting Expectations 01:00:00 Module Nine - Resiliency and Flexibility 00:30:00 Module Ten - Assigning Work 01:00:00 Module Eleven - Providing Feedback 01:00:00 Module Twelve - Wrapping Up 00:30:00 Employee Management Course: Millennial Onboarding- Activities 00:00:00 HR and Employee Motivation Module One - Getting Started 01:00:00 Module Two - A Psychological Approach 01:00:00 Module Three - Object-Oriented Theory 01:00:00 Module Four - Using Reinforcement Theory 01:00:00 Module Five - Using Expectancy Theory 01:00:00 Module Six - Personality's Role in Motivation 01:00:00 Module Seven - Setting Goals 01:00:00 Module Eight - A Personal Toolbox 01:00:00 Module Nine - Motivation on the Job 01:00:00 Module Ten - Addressing Specific Morale Issues 01:00:00 Module Eleven - Keeping Yourself Motivated 00:30:00 Module Twelve - Wrapping Up 00:30:00 HR Management: Employee Motivation- Activities 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Advanced Diploma in HR Management 00:30:00 Final Exam Final Exam- Advanced Diploma in HR Management 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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

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

Description: Managing an office requires great effort and a combination of skills such as attention to detail, communication, team work and general office management software. With the help of this Advanced Diploma in Office Administration course you will be able to develop all these skills and more, which only means you will stand head and shoulders above the competition. Initially you will learn about administrative management by focusing on needs of administrative procedures, using the right tools, and how to develop and use procedure guides. Then you look into the business writing portion of the course in order to learn how to write emails, letters, reports and various other documents in a professional manner. The next two sections overlook office management, bookkeeping and payroll and help you develop team work and customer service skills along with understanding balance sheets, keeping track of business and so much more. Finally you will also be taught the working mechanism of basic Microsoft Office programs such as Word, Excel and PowerPoint. Using all of these you will be able to sharpen up your skills and make certain that you remain on top of all the employers' lists. Who is the course for? This course is ideal for those wanting to improve their base skills in office administrative tasks This course would be ideal people who want to start working as a receptionist, office administrator, office manager, administration assistant or personal assistant 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 hardcopy at the cost of £39 or in PDF format at the 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 career advancement opportunities; 24/7 student support via email. Career Path: Advanced Diploma in Office Administration is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Administrator support staff Personal Assistant Administrative assistant Office managers Receptionist Office administrator Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 Module 13: Records Management: Filing Systems 00:30:00 Business Writing Module One - Getting Started 00:30:00 Module Two - Working with Words 01:00:00 Module Three - Constructing Sentences 01:00:00 Module Four - Creating Paragraphs 01:00:00 Module Five - Writing Meeting Agendas 01:00:00 Module Six - Writing E-mails 01:00:00 Module Seven - Writing Business Letters 01:00:00 Module Eight - Writing Proposals 01:00:00 Module Nine - Writing Reports 01:00:00 Module Ten - Other Types of Documents 01:00:00 Module Eleven - Proofreading and Finishing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Office Management Building Your Management Team 01:00:00 Building A Successful Brand 01:00:00 Achieving Quality Through Teamwork 00:30:00 Keys To Staying Motivated 00:30:00 Improve Your Marketing 01:00:00 Provide Top Customer Service 00:30:00 Wrapping Up 00:30:00 Bookkeeping & Payroll Module One - Introduction 00:30:00 Module Two - Basic Terminology 01:00:00 Module Three - Basic Terminology (II) 01:00:00 Module Four - Accounting Methods 01:00:00 Module Five - Keeping Track of Your Business 01:00:00 Module Six - Understanding the Balance Sheet 01:00:00 Module Seven - Other Financial Statements 01:00:00 Module Eight - Payroll Accounting Terminology 01:00:00 Module Nine - End of Period Procedures 01:00:00 Module Ten - Financial Planning, Budgeting and Control 01:00:00 Module Eleven - Auditing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Office Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Word for Newbies - Activities 00:00:00 Microsoft Office Powerpoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 PowerPoint Essential Activities 00:00:00 Microsoft Office Excel Module One - Getting Started 00:30:00 Module Two - Opening Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Advanced Diploma in Office Administration 00:30:00 Final Exam Final Exam- Advanced Diploma in Office Administration 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00