• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

14151 Courses

Child Neglect Awareness Training

4.3(43)

By John Academy

Overview Negligence towards children can have a long-term impact on their physical and mental health. That is why safeguarding children from neglect is vital for their growth and development. Understand how you can protect children from negligence with our Child Neglect Awareness Training course.  Through the course, you will develop a clear understanding of child what is neglect. Then the course will educate you on the signs and risk factors of child neglect. Then, you will learn about the law and legislation related to child neglect. Here, you will also develop the competence to respond to child neglect and report when necessary.  By the end of the course, they will be equipped with the skills required to prevent child neglect. So, enrol in the course and create a better-growing environment for the future generation. Course Preview Learning Outcomes Understand the definition of child neglect Identify the signs and risk factors of child neglect Learn the impact of neglect in a child's life Enhance your knowledge about the legislation related to child neglect Know how to respond and report child neglect Develop the skills to prevent child neglect Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Child safeguarding Reporting neglect Preventing child neglect Who Should Take This Child Neglect Awareness Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Child Neglect Awareness Training is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Child Neglect Awareness Training Certification After completing and passing the Child Neglect Awareness Training successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Child Neglect Awareness Training will equip you with effective skills and abilities and help you explore career paths such as  Child care worker Teacher Social worker Module 01: Introduction To Child Neglect Introduction to Child Neglect 00:26:00 Module 02: Signs Of Child Neglect Signs of Child Neglect 00:49:00 Module 03: Risk Factors For Neglect Risk Factors for Neglect 00:38:00 Module 04: The Impact Of Child Neglect The Impact of Child Neglect 00:36:00 Module 05: Child Neglect Cases Child Neglect Cases 00:41:00 Module 06: Legislation Surrounding Child Neglect Legislation Surrounding Child Neglect 00:34:00 Module 07: Responding To And Reporting Child Neglect Responding to and Reporting Child Neglect 00:38:00 Module 08: Prevent Child Negligence Prevent Child Negligence 00:34:00 Assignment Assignment - Child Neglect Awareness Certificate Course 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Child Neglect Awareness Training
Delivered Online On Demand4 hours 56 minutes
£24.99

Professional Photography Masterclass

4.3(43)

By John Academy

Description: Due to technological advancements, digital photography is expanding both the opportunities and challenges for professional photographers. This Professional Photography Masterclass course is intended for individuals who are interested in learning the techniques of world-class photography and explore detailed explanations of the fundamentals of digital photography. This course teaches you the techniques applied by professional photographers to take the perfect shot in all conditions. Enhance your knowledge of some basic rules, and strategies, including how to work with different cameras, the secrets of exposure, lighting and lenses, editing photos, add filters, colours, and many more. In addition to that, you will receive coaching on proper composition in varying scenarios, such as weddings, nature, landscapes, wildlife, portraits, studio, still life, etc. To sum up, this comprehensive course will teach you everything that allows you to take absolute control of your camera. Who is the course for? Anyone who wants to take better photos Absolute beginners who want to become skilled photographers Moms, dads, kids, grandparents, and anyone else who wants to document their lives in a beautiful way Amateur photographers wanting to improve their skills Photographers looking to make money with their skills 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 completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. 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: After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

Professional Photography Masterclass
Delivered Online On Demand20 hours 30 minutes
£12

Sales & Marketing with Negotiation Skills With Complete Career Guide Course

5.0(2)

By Training Express

Sales and marketing are no longer just about pitching products—they're about understanding people, patterns, and persuasion. This course is crafted for learners keen to grasp the essentials of both disciplines while developing sharp negotiation techniques along the way. It’s designed with a keen focus on strategy, consumer psychology, and smart communication—blended with techniques to help you navigate professional scenarios with confidence and clarity. From decoding buyer behaviour to crafting impactful messages, you’ll explore the core frameworks that drive successful campaigns and confident conversations. Whether you're aiming to refine your pitch, attract new customers, or negotiate smarter deals, this guide gives you a strong foundation to build upon. The added career segment rounds things off neatly, offering practical insights into professional growth and industry expectations. ________________________________________________________________________ Key Features: CPD Certified Sales & Marketing with Negotiation Skills With Complete Career Guide 11 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Sales and Marketing Sales Part Module 01: Understanding the Talk Module 02: Getting Prepared to Make the Call Module 03: Creative Openings Module 04: Making Your Pitch Module 05: Handling Objections Module 06: Sealing the Deal Module 07: Following Up Module 08: Setting Goals Module 09: Managing Your Data Module 10: Using a Prospect Board Marketing Part Module 01: What is Marketing? Module 02: Common Marketing Types (I) Module 03: Common Marketing Types (II) Module 04: The Marketing Mix Module 05: Communicating the Right Way Module 06: Customer Communications Module 07: Marketing Goals Module 08: The Marketing Funnel Module 09: Marketing Mistakes (I) Module 10: Marketing Mistakes (II) Negotiation Skills Module 01: Negotiation Techniques Module 02: Conflict Management Module 03: Influencing People Module 04: Handling Objections ________________________________________________________________________ Complete Career Guide for Sales & Marketing with Negotiation Skills (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Sales & Marketing. In addition to mastering the essentials of Sales & Marketing, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Sales & Marketing. Your dream career starts here! List of career guide courses included in Sales & Marketing with Negotiation Skills With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Develop effective communication skills for successful sales interactions. Demonstrate strategic preparation and planning for sales calls and pitches. Craft compelling and creative openings to capture customer interest. Master objection-handling techniques to overcome customer hesitations. Implement negotiation skills and conflict management in sales scenarios. Create and execute comprehensive marketing strategies, avoiding common mistakes. ________________________________________________________________________ Accreditation All of our courses, including this Course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Course, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to excel in sales and marketing roles. Entrepreneurs seeking to enhance their business development skills. Marketing professionals aiming to refine their strategic approach. Anyone looking to master negotiation and conflict resolution techniques. Career path Sales Executive - £25K to 45K/year. Marketing Coordinator - £22K to 38K/year. Business Development Manager - £30K to 55K/year. Account Manager - £28K to 50K/year. Marketing Specialist - £25K to 42K/year. Certificates 11 CPD Accredited e-Certificates Digital certificate - Included 11 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Sales & Marketing with Negotiation Skills With Complete Career Guide Course
Delivered Online On Demand1 hour
£65

Leadership Management & High-Performing Team Management With Complete Career Guide Course

5.0(2)

By Training Express

Leadership Management & High-Performing Team Management is a course designed to help individuals develop the skills to lead teams effectively and enhance their leadership abilities. Whether you're in charge of a team or looking to improve your leadership style, this course provides the tools you need to foster collaboration, drive performance, and guide teams to success. With insights into key leadership techniques, communication strategies, and team dynamics, this course is a step towards mastering team management and excelling in leadership roles. By the end of the course, you'll be equipped to manage diverse teams, adapt to various leadership challenges, and create an environment where high performance is the norm. You'll learn how to build trust, establish clear goals, and navigate conflicts with ease. This course is perfect for anyone aiming to refine their leadership style, enhance their ability to manage teams, and contribute to an organisation’s success. Prepare to develop an approach that not only motivates your team but also improves overall team efficiency and satisfaction. ________________________________________________________________________ Key Features: CPD Certified 11 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Leadership Management Training Module 01: Getting Started Module 02: Situational Leadership Module 03: A Personal Inventory Module 04: Modeling the Way Module 05: Inspiring a Shared Vision Module 06: Challenging the Process Module 07: Enabling Others to Act Module 08: Encouraging the Heart Module 09: Basic Influencing Skills Module 10: Setting Goals Team Management Module 01: Defining Team Module 02: Understanding Management and Leadership Module 03: Building High Performing Teams Module 04: Motivating Team Members Module 05: Talent Management Module 06: Stress Management and Mental Health Module 07: Succession Planning Module 08: Communication Skills Module 09: Negotiation Techniques Module 10: Managing Change Module 11: Managing Time Module 12: Managing Conflict Module 13: Risk Management Process Module 14: Managing Virtual Teams ________________________________________________________________________ Complete Career Guide for Leadership Management & High-Performing Team Management(A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Leadership Management. In addition to mastering the essentials of Leadership Management, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Leadership Management. Your dream career starts here! List of career guide courses included in Leadership Management & High-Performing Team Management With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Understand situational leadership for adaptive managerial approaches. Develop a personal inventory for effective self-awareness and leadership. Inspire shared visions and challenge conventional processes with confidence. Acquire essential influencing and negotiation skills for successful leadership. Master stress management and mental health strategies for team well-being. Handle the challenges of virtual team leadership and managing risks. ________________________________________________________________________ Accreditation All of our courses, including this Course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Course, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring and current leaders seeking comprehensive leadership skills. Professionals aiming to enhance team performance and synergy. Individuals eager to master effective communication and negotiation. those seeking knowledge in workplace mental health and handling stress. Anyone aspiring to lead virtual teams and effectively manage change. Career path Team Leader - £28K to 45K/year. HR Manager - £35K to 60K/year. Change managing Specialist - £40K to 70K/year. Communication Manager - £30K to 50K/year. Risk Analyst - £25K to 45K/year. Certificates 11 CPD Accredited e-Certificates Digital certificate - Included 11 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Leadership Management & High-Performing Team Management With Complete Career Guide Course
Delivered Online On Demand1 hour
£65

Youth Work & Leadership - CPD Certified

4.7(47)

By Academy for Health and Fitness

24-Hour Flash Sale! Prices Reduced Like Never Before!! 6 in 1 Youth Work & Leadership - CPD Certified Bundle Youth workers and leaders play a pivotal role in the heart of every community, shaping the future by guiding young individuals through their formative years. Recent statistics highlight a growing concern within the UK regarding youth engagement, with over 600,000 young people reported to be not in education, employment, or training. This underscores the urgent need for skilled youth workers and leaders who can address these challenges, providing support, guidance, and leadership to empower the next generation. The Youth Work & Leadership bundle is designed to equip you with the necessary skills and knowledge to make a significant impact in the lives of young people. You'll get to learn the fundamentals of Youth Work and Leadership, the complexities of Social Work Studies, and explore the nuances of Child Counselling. It also addresses critical issues such as Anti-social Behaviour, Stress Management, and Depression Management, offering strategies to manage and mitigate these challenges effectively. Through this training, you'll gain a deep understanding of the social, emotional, and psychological needs of young individuals and learn how to inspire, motivate, and support them in their journey. This Youth Work & Leadership -CPD Certified Bundle Contains 6 of Our Premium Courses for One Discounted Price: Course 01: Youth Work & Leadership Course 02: Social Work Studies Diploma Course 03: Child Counselling and Youth Course 04: Anti-Social Behaviour Course Course 05: Stress Management Diploma Course 06: Online Depression Management Stepping into a role within youth work and leadership not only offers a chance to profoundly impact young lives but also opens up a pathway to a rewarding and fulfilling career. This course bundle presents an invaluable opportunity to those aspiring to enhance their skills or carve out a new career path in youth work. Enrol now to make a long-lasting difference in the lives of young people and contribute to a brighter future for all! Learning Outcomes of this Youth Work & Leadership Bundle: Understand the core principles and techniques of effective youth work and leadership. Apply social work theories and practices to support young people. Offer counselling and support for children and youth facing challenges. Develop strategies to manage and reduce anti-social behaviour. Implement effective workplace stress management techniques. Address and manage depression among young individuals. Why Prefer this Youth Work & Leadership Bundle? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straightaway! Curriculum Breakdown Course 01: Youth Work & Leadership Module 01: Introduction to Youth Work Module 02: Who Are the Youth Workers? Module 03: Youth Worker Role and Methods Module 04: Legal Responsibilities Module 05: Youth Work as a Career (Social Work) Module 06: Social Influences Module 07: Youth Work in Mental Health Module 08: Social Work and Criminal Justice Course 02: Social Work Studies Diploma Module 01: An Overview of Social Work Module 02: Social Work Basics Module 03: Theories of Social Work and Sociology Module 04: Casework Process and Teamwork Module 05: Dimensions of Social Work / Models of Intervention Module 06: Practice Contexts and Application Module 07: Working with Adults Module 08: Principles of Conduct and Role as Social Care Worker Course 03: Child Counselling and Youth Module 01: Definition of Counselling Module 02: The Counselling Relationship Module 03: The Development Cycle Module 04: Parent, Child, Teacher Relationships Module 05: The Complexities of Growth Module 06: Psychological Development Module 07: Conflict and Stress Module 08: Behavioural Therapies Module 09: Working with Children Module 10: The Use of Language Module 11: Memory Module 12: Grief and Bereavement Module 13: Exploring Grief and Letting Go Module 14: Dysfunctional Families Module 15: What is Co-Dependency Module 16: Child Bullying and Child Abuse Module 17: Psychological Study of Education Module 18: Transformation Module 19: Using Newly Found Skills Module 20: Recovery: The Therapeutic Process Module 21: Moving on: Emotional Intimacy Module 22: Setting Up a Practice =========>>>>> And 3 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*6 = £78) CPD 60 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: Aspiring youth workers Social workers Educators Counsellors Community leaders Career changers Please note: This 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 You will not need any prior background or expertise to enrol in this Youth Work & Leadership Course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Youth Worker - £20,000 to £30,000 Social Worker - £28,000 to £40,000 Child Counsellor - £25,000 to £35,000 Community Leader - £23,000 to £35,000 School Welfare Officer - £22,000 to £30,000 Mental Health Support Worker - £18,000 to £25,000 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 - £29 Please note that International students have to pay an additional £10 as a shipment fee.

Youth Work & Leadership - CPD Certified
Delivered Online On Demand20 hours
£39

Diploma in Counselling and Psychology Training Course

By Training Tale

Are you concerned about your prospects? Our expertly designed Diploma in Counselling and Psychology course is here to solve all of your problems at once. Learn all the necessary skills to join the psychology & counselling industry with confidence. It is a demanding profession, with the average salary of a Psychologist in the UK around 55,000 GBP. This qualification enables you to pursue a rewarding career in a rapidly growing counselling and psychology sector. Through this Diploma in Counselling and Psychology course, you will gain a thorough understanding of Counselling and Psychology. Learn how to assist people in dealing with personal and professional challenges. There are numerous opportunities to work in well-established institutions and companies. Enrol on our Diploma in Counselling and Psychology course today, become an expert in human minds, and take the first step toward a psychologist or counsellor career. Learning Outcomes After completing this course, the learner will be able to: Gain a thorough understanding of counselling. Understand the therapeutic relationship. Gain in-depth knowledge about positive psychology. Understand psychoanalytic therapy. Understand person‐Centred therapy. Understand Adlerian therapy. Understand psychoanalytic therapy. Understand Gestalt Therapy & cognitive‐behaviour therapy. Understand family therapy & feminist therapy. Why Choose Diploma in Counselling and Psychology Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Diploma in Counselling and Psychology 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 the Diploma in Counselling and Psychology course. **Courses are included in this Diploma in Counselling and Psychology Bundle Course Course 01: Diploma in Counselling and Psychology Course 02: Introduction to Psychology Course 03: Introduction to Psychotherapy Course 04: Clinical Psychology Diploma Course 05: Diploma in Mastering Psychology Course 06: Primary Teaching Diploma Course 07: Adults Support Worker Course Course 08: Level 4 Diploma in Child Counselling Course Course 09: Child and Adolescent Mental Health Course Course 10: Level 4 Diploma in Child Psychology Course Course 11: Level 5 Childcare Training ***Others Included of Diploma in Counselling and Psychology Bundle Course Free 11 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 Diploma in Counselling and Psychology Course: Module 1: Introduction: Toward an Integrative Approach in Counselling Module 2: Therapeutic Relationship: Exploring Clients' Symptoms and Strengths Module 3: Powered by Struggles and Strengths Module 4: Positive Psychology in Counselling: What is It? Module 5: Psychoanalytic Therapy Module 6: Adlerian Therapy Module 7: Existential Therapy Module 8: Person‐Centred Therapy Module 9: Gestalt Therapy Module 10: Behaviour Therapy Module 11: Cognitive‐Behaviour Therapy Module 12: Reality Therapy Module 13: Feminist Therapy Module 14: Family Therapy ------------------- Assessment Method After completing each module of the Diploma in Counselling and Psychology, 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 Diploma in Counselling and Psychology 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 Diploma in Counselling and Psychology course is suitable for anyone who wants to start a career as a psychologist or counsellor, as well as professionals who want to test their existing skills and knowledge. Requirements There are no specific requirements for this course because it does not require any advanced knowledge or skills. Students who intend to enrol in this Diploma in Counselling and Psychology 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 Diploma in Counselling and Psychology course, candidates may pursue careers such as: Operating Own Counselling Practice Careers Counsellor or Adviser Family and Marriage Counsellor Rehabilitation Counsellor Certificates Certificate of completion Digital certificate - Included

Diploma in Counselling and Psychology Training Course
Delivered Online On Demand4 days
£34

Introduction to Writing SQL Queries (TTSQL003)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert practitioner, attendees will learn to: Maximize the potential of SQL to build powerful, complex and robust SQL queries Query multiple tables with inner joins, outer joins and self joins Construct recursive common table expressions Summarize data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Thoroughly test SQL queries to avoid common errors Select the most efficient solution to complex SQL problems A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation. Introduction: Quick Tools Review Introduction to SQL and its development environments Using SQL*PLUS Using SQL Developer Using the SQL SELECT Statement Capabilities of the SELECT statement Arithmetic expressions and NULL values in the SELECT statement Column aliases Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Use of the DESCRIBE command Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command Single-Row Functions Describe the differences between single row and multiple row functions Manipulate strings with character function in the SELECT and WHERE clauses Manipulate numbers with the ROUND, TRUNC and MOD functions Perform arithmetic with date data Manipulate dates with the date functions Conversion Functions and Expressions Describe implicit and explicit data type conversion Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nest multiple functions Apply the NVL, NULLIF, and COALESCE functions to data Decode/Case Statements Using the Group Functions and Aggregated Data Group Functions Creating Groups of Data Having Clause Cube/Rollup Clause SQL Joins and Join Types Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join Using Subqueries Introduction to Subqueries Single Row Subqueries Multiple Row Subqueries Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using Data Manipulation Language (DML) statements Data Manipulation Language Database Transactions Insert Update Delete Merge Using Data Definition Language (DDL) Data Definition Language Create Alter Drop Data Dictionary Views Introduction to Data Dictionary Describe the Data Dictionary Structure Using the Data Dictionary views Querying the Data Dictionary Views Dynamic Performance Views Creating Sequences, Synonyms, Indexes Creating sequences Creating synonyms Creating indexes Index Types Creating Views Creating Views Altering Views Replacing Views Managing Schema Objects Managing constraints Creating and using temporary tables Creating and using external tables Retrieving Data Using Subqueries Retrieving Data by Using a Subquery as Source Working with Multiple-Column subqueries Correlated Subqueries Non-Correlated Subqueries Using Subqueries to Manipulate Data Using the Check Option Subqueries in Updates and Deletes In-line Views Data Control Language (DCL) System privileges Creating a role Object privileges Revoking object privileges Manipulating Data Overview of the Explicit Default Feature Using multitable INSERTs Using the MERGE statement Tracking Changes in Data

Introduction to Writing SQL Queries (TTSQL003)
Delivered OnlineFlexible Dates
Price on Enquiry

UX Design Course Online

By Lead Academy

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want From this UX Design Course, you will discover the key to crafting exceptional user experiences. You will learn user-centred design principles, usability testings equipping you to create engaging digital products that delight users and drive business success. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Define ACT and understand its fundamental aspects .A comprehensive outline of how to design better products for humans. All about user expectations. Anatomy of working memory and our attention span. Limits of Peripheral Vision. Analysis of human behavior, decision paralysis, and why humans hate changes. A brief understanding of why humans don't like barriers. A thorough overview of how the developers can improve user experience. Why UX Design Course right for you? UX design course is an ideal choice for you if you are starting from scratch. If you are ready to get started in UX Design, you might as well study from an online context where you will discover the Ux Roles and how to become a leading UX Designer. Examine human decision-making (how old and new brain works? along with examples of F & Z reading patterns and why humans don't like barriers. The course offers you a detailed overview of how to design better products for humans. Once you have completed this UX design course and obtained your certification, you will be equipped to understand and inculcate: Double Diamond Model Of Design Root cause Analysis Principles & Behavior Patterns Scanning Patterns And Change Blindness Designing For Humans UX Design Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Introduction To User Expericne, Ux Roles and How to Be a UX Designer Can I be a UX Designer. Different roles of UX Designers Major Parts Of Every UX Design What is Human Centered Design (HCD) What is Agile UX. (Student Request Headshot Video) Double Diamond Model of Design by Don Norman Using Root Cause Analysis in UX Design Seven Stages of Action by Don Norman 5 Second Usability Test What Are Affordances, Anti-affordances and Signifiers. Human Centered Design, Double Diamond Model Of Design And Root cause Analysis Examples of Affordances and Signifiers Affordances & Signifiers explained → Headshot Video What is Mapping and Natural Mapping. Conceptual and Mental Models in UX Working Memory and Our Attention Span Examples of Working Memory and Attention Recognition Rather Than Recall Examples of Recognition Rather Than Recall How User Expectations Actually Work. User Expectations Example → Headshot Video Examples of User Expectations Limits of Peripheral Vision Examples of limited Peripheral Vision What is Context of Use in User Experience. Explanation of Context of use → Headshot Video Why Stakeholders Are as Important as Users What is Information Architecture. (Headshot Video) Examples of Information Architecture (Navigation Best Practices) Examples of Information Architecture (Navigation Best Practices) Principles & Behavior Patterns, Decision Making, Scanning Patterns And Change Blindness Human Decision Making → How Old and New Brain Works? Human Decision Making → How Old and New Brain Works. Humans Hate Change Our Goals and Change Blindness Examples of Human Behavior, Decision Paralysis and Why We Hate Change Examples of F & Z Reading Patterns and Why Humans Don't Like Barriers Designing For Humans → How to Design Better Products For Humans Discoverability → Can Your Users Discover Your Product's Features Learnability → Can Your Users Learn to Use Your Product Easily Feedback → Do Users Know What is Happening or Just Happened? Feedback → Do Users Know What is Happening or Just Happened. Examples of Visual and Audio Feedback Feedback within the context → Walmart Example Consistency in Design & Function with Examples Constraints and how to use them to improve UX What Are Slips & Mistakes and How to Avoid Them Designing for errors with Examples User always in control with Examples Using Grouping and Chunking to Improve UX Physical & Mental limitations of Humans How Developers Can Improve User Experience? Using Design Patterns → Don't Re-invent the Wheel Don't Let Users Think → Do Heavy Calculation Yourself Why Users Always Need Speed and When to Use Delays. Power of Smart Defaults & Suggestion Guiding and Training Users at Every Step Reduce Number of Barriers to Entry for Users Use Natural Language Rather Than Codes Examples of Natural Language or Conversational Forms Timing of Notifications and Our Perception Using Google Analytics to Know More About Users Data Driven Design and Anticipatory Design With Examples Case Study Solution → GPtools App Who should take this course? This comprehensive UX design course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of UX design. Entry Requirements There are no academic entry requirements for this UX design course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

UX Design Course Online
Delivered Online On Demand
£25

Diploma in Paediatric Nurse Assistant Training

4.3(43)

By John Academy

Diploma in Paediatric Nurse Assistant Training Overview Transform your compassion into a career that matters. Earn your Diploma in Paediatric Nurse Assistant to become the caring, skilled professional that patients and healthcare facilities rely on.  Get introduced to Nursing and know what it's like working in different healthcare settings, and learn the standards and ethical aspects of practice in nursing from this course. It will also cover effective communication in nursing, along with caring for children in their early stages.  Empower yourself with knowledge and start making a real impact on people's lives. Don't wait-your future in healthcare begins here! Enrol today and start your journey toward a brighter, more rewarding future!  Learning Outcomes Get introduced to nursing and learn more about healthcare settings. Understand legal, professional standards of practice and ethical aspects of health care. Learn effective communication for nursing Understand the growth, development, and safety of children Know how to safeguard and protect young children Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted, engaging and informative tutorial videos and materials Efficient assessment system with instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Effective communication Nursing practices Who Should Take This Paediatric Nurse Assistant Training Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Diploma in Paediatric Nurse Assistant Training course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Diploma in Paediatric Nurse Assistant Certification After completing and passing the Diploma in Nursing Assistant Online Training course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path This exclusive Diploma in Paediatric Nurse Assistant course will equip you with effective skills and abilities and help you explore relevant career paths. Diploma in Paediatric Nurse Assistant Training Module 01: Introduction to Nursing 00:15:00 Module 02: Working in Different Healthcare Settings 00:13:00 Module 03: Understanding legal, professional standards of practice and ethical aspects of health care- Part 1 00:50:00 Module 04: Understanding legal, professional standards of practice and ethical aspects of health care- Part 2 00:48:00 Module 05: Effective Communication in Nursing 00:46:00 Module 06: Understanding the Growth and Development of Children 00:26:00 Module 07: Safeguarding, Protection and Welfare of Young Children 00:26:00 Module 08: Health and Safety of Children in the Early Years 00:35:00 Module 09: Nutrition and Healthy Food for Children 00:31:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Paediatric Nurse Assistant Training
Delivered Online On Demand4 hours 50 minutes
£18.99

Equality, Diversity & Inclusion (EDI) - CPD Certified

4.7(47)

By Academy for Health and Fitness

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Creating a fair and inclusive environment is essential for any organisation. In the UK, diversity and inclusion are not just buzzwords but essential components of a thriving society. According to a recent report, over 40% of the UK workforce comes from ethnic minority backgrounds. However 21% of employees believe they have been discriminated against in the workplace based on their race or ethnicity. Are you committed to creating an equitable and inclusive environment where everyone can thrive? This course will equip you with the knowledge and skills to navigate the complexities of diversity and build a more positive and productive work environment. This Equality, Diversity & Inclusion (EDI) course provides an in-depth understanding of diversity, stereotypes, and the barriers that hinder inclusion. You will learn effective verbal and non-verbal communication skills to navigate diverse environments. The course also covers proactive strategies for promoting inclusivity, coping with discrimination, and dealing with diversity complaints at individual, managerial, and organisational levels. Learning Outcomes of Equality, Diversity & Inclusion (EDI) Grasp the significance and dimensions of societal diversity. Recognize and address prevalent stereotypes in daily scenarios. Detect and counteract obstacles to fostering inclusive environments. Develop and refine effective verbal communication techniques. Understand and master non-verbal cues for enhanced communication. Cultivate a proactive mindset for positive personal change. Strategize and adapt to discrimination encounters effectively. Address personal diversity-related complaints empathetically. Implement managerial strategies for handling diversity complaints. Establish organizational procedures for addressing diversity complaints. Why Choose Us? Learn Equality, Diversity and Inclusion from anywhere in the world The Equality, Diversity & Inclusion is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Equality, Diversity & Inclusion course materials The Equality, Diversity & Inclusion comes with 24/7 tutor support Free Gift Courses Are Course 01: Resilience Training Course Course 02: Conflict Management Training Equality, Diversity and Inclusion (EDI) - CPD Certified This Equality, Diversity & Inclusion (EDI) course teaches you diversity and inclusion principles, understanding stereotypes, breaking down barriers, effective communication skills, proactive strategies for inclusivity, coping with discrimination, and handling diversity complaints at individual, managerial, and organisational levels to create a culture of respect and equal opportunities. This not only benefits your colleagues and creates a more harmonious work environment, but can also enhance your career prospects by demonstrating your commitment to diversity and fostering a culture of respect. Course Curriculum Overview for Diversity and Inclusion TrainingModule 01: Understanding Diversity Explores the concept of diversity, its significance in the workplace, and how to appreciate and respect individual differences. It emphasizes the value of diverse perspectives and inclusive practices in creating a positive and productive environment. Module 02: Understanding Stereotypes Discusses common stereotypes, their impact on individuals and groups, and strategies to challenge and overcome them. The module aims to foster awareness and promote a culture of inclusion by breaking down prejudiced views. Module 03: Breaking Down the Barriers Identifies barriers to diversity and inclusion, and provides practical approaches to dismantle these obstacles. It focuses on creating an environment where everyone feels valued and respected. Module 04: Verbal Communication Skills Enhances verbal communication skills to ensure clear, respectful, and inclusive interactions in diverse settings. It covers effective listening, appropriate language use, and fostering open dialogue. Module 05: Non-Verbal Communication Skills Focuses on body language, facial expressions, and gestures in effective and inclusive communication. The module emphasizes understanding and interpreting non-verbal cues to improve interactions. Module 06: Being Proactive Encourages proactive behaviour in promoting diversity and inclusion, including taking initiatives and personal actions. It highlights the importance of leading by example and advocating for inclusive practices. Module 07: Coping with Discrimination Provides strategies for coping with and addressing discrimination in the workplace and other settings. It includes techniques for managing emotional responses and seeking support. Module 08: Dealing with Diversity Complaints as a Person Guidance on how individuals can handle diversity-related complaints, including personal and professional strategies. The module focuses on effective communication and conflict resolution. Module 09: Dealing with Diversity Complaints as a Manager Offers managers tools and techniques for addressing and resolving diversity complaints within their teams. It covers best practices for fair and impartial handling of issues. Module 10: Dealing with Diversity Complaints as an Organization Provides a comprehensive approach for organizations to manage diversity complaints, including policy development, training programs, and creating a culture of accountability and support. Enrol today in this Equality, Diversity and Inclusion (EDI) course and advance your career! CPD 140 CPD hours / points Accredited by CPD Quality Standards Module 01: Understanding Diversity 17:21 1: Introduction Video Preview 01:21 2: Understanding Diversity 16:00 Module 02: Understanding Stereotypes 03:10 3: Understanding Stereotypes 03:10 Module 03: Breaking Down the Barriers 05:51 4: Breaking Down the Barriers 05:51 Module 04: Verbal Communication Skills 08:48 5: Verbal Communication Skills 08:48 Module 05: Non-Verbal Communication Skills 05:04 6: Non-Verbal Communication Skills 05:04 Module 06: Being Proactive 08:33 7: Being Proactive 08:33 Module 07: Coping with Discrimination 10:20 8: Coping with Discrimination 10:20 Module 08: Dealing with Diversity Complaints as a Person 03:47 9: Dealing with Diversity Complaints as a Person 03:47 Module 09: Dealing with Diversity Complaints as a Manager 03:31 10: Dealing with Diversity Complaints as a Manager 03:31 Module 10: Dealing Diversity Complaints as a Organization 07:11 11: Dealing with Diversity Complaints as an Organization 07:11 Order Your Certificate 02:00 12: Order Your CPD Certificate 01:00 13: Order Your QLS Endorsed Certificate 01:00 Who is this course for? Anyone interested in learning more about the topic is advised to take this Equality, Diversity and Inclusion (EDI) course. This course is ideal for: Diversity and inclusion professionals. Human resources specialists. Managers and team leaders. Educators and trainers. Social workers and counselors. Requirements You will not need any prior background or expertise to enrol in this Equality, Diversity and Inclusion (EDI) course. Career path After completing this Equality, Diversity and Inclusion (EDI) course, you are to start your career or begin the next phase of your career. HR Specialist Diversity Officer Inclusion Consultant Change Manager Team Leader Manager Certificates Cademy certificate of completion Digital certificate - Included Will be downloadable when all lectures have been completed Certification Accredited by CPDQS Digital certificate - £10 Certification Accredited by CPDQS Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Equality, Diversity & Inclusion (EDI) - CPD Certified
Delivered Online On Demand1 hour 18 minutes
£12