5654 Courses

Overview of Counselling Skills Training Counselling is a powerful tool to help people overcome challenges and live happier, more fulfilling lives. In today's fast-paced and often stressful world, counselling is more important than ever. The counselling industry in the UK is increasing, with more and more people seeking professional help to deal with a wide range of issues, including mental health problems, relationship difficulties, and workplace stress. Join our Counselling Skills Training course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Counselling Skills Training course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Counselling Skills Training course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! This Counselling Skills Training Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Counselling Skills Training. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion – Digital / PDF Certificate After completing the Counselling Skills Training course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Counselling Skills Training is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don’t have the time to devote to traditional education. Requirements You don’t need any educational qualification or experience to enrol in the Counselling Skills Training course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Counselling Skills Training Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Counselling Skills Training Module 1: Counselling and Counsellors 00:15:00 Module 2: Theories and Models of Counselling (Part 1) 00:17:00 Module 3: Theories and Models of Counselling (Part 2) 00:21:00 Module 4: Legal, Cultural and Ethical Issues in Professional Counselling 00:17:00 Module 5: Forms of Psychotherapy 00:23:00 Module 6: Engaging and Assessing the Patients 00:18:00 Module 7: Helping the Client in Crisis 00:13:00 Module 8: Crisis Intervention 00:13:00 Module 9: Low Intensity CBT Treatment 00:15:00 Module 10: Medication and Therapy in the Treatment of Mental Illness 00:23:00 Module 11: Communication Skills and Empathy in Counselling 00:20:00 Assignment Assignment - Counselling Skills Training 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about productivity and growth Understand the core competencies and principles of productivity and growth Explore the various areas of productivity and growth Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert life coach 10 Daily Goals to set for Humans to Enjoy a Happy and Productive Life! Course Master the skills you need to propel your career forward in productivity and growth. This course will equip you with the essential knowledge and skillset that will make you a confident life coach and take your career to the next level. This comprehensive happy and productive life course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this happy and productive life course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This 10 daily goals to set for humans to enjoy a happy and productive life! course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. 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.  This comprehensive course will teach you the theory of effective productivity and growth practice and equip you with the essential skills, confidence and competence to assist you in the productivity and growth industry. You'll gain a solid understanding of the core competencies required to drive a successful career in productivity and growth. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for life coach or for people who are aspiring to specialise in productivity and growth.This 10 daily goals to set for humans to enjoy a happy and productive life! course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification.  Enrol in this happy and productive life course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive happy and productive life course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this productivity and growth can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This happy and productive life course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This happy and productive life course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This happy and productive life course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. 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. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. 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. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Add Daily Goal Setting to Your Life and Remove Stress of Long Term Goals. Welcome to 10 Daily goals for Humans 00:02:00 The Entire Value of This Course in The First Video by Showing my Workflow. 00:05:00 The Old Way of Setting Goals in Time Versus The New Way Setting Goals for Today 00:04:00 Example Of a Daily Goal Versus a Long Term Goal in My Workflow 00:08:00 The Benefits of Daily Goal Setting Explained. Time Spent Working And Enjoying Long Term Goals Versus Daily 00:03:00 I Can Still Set Long Term Goals as Long as They Fall Within a Daily Goal 00:05:00 Problems Solved with Setting Goals Each Day Instead of Making Long Term Goals. Daily Goal Setting Eliminates Setting Goals Where I Do Not Control The Outcome 00:06:00 When You Control The Outcome of a Daily Goal, Jealousy Does Not Appear 00:07:00 Anything That Blocks Progress on a Daily Goal I Work to Eliminate 00:06:00 Days of Failing to Accomplish The Goal Become Okay Because of so Much Success 00:07:00 The Data Saved me From Telling a Story of My Failure After Having a Baby 00:06:00 Tracking Daily Goals Is Essential for Learning and Consistency. Microsoft Excel Works for Me to Track My Professional Progress 00:05:00 MyFitnessPal Works For me to Track my Diet, Exercise, And Weight 00:10:00 Mint Works For Me to Track My Finances 00:05:00 I Participate in a Support Group Each Day to Track My Sanity 00:08:00 Prayer And Inspirational Books Help Me Track My Mood at Morning And at Night 00:07:00 Everyone Helps Me Track my Service and Purpose For Living 00:03:00 What Are My Daily Goals and How Do I Practice Them What Are My 10 Daily Goals. Saying Them Out Loud Helps Me Practice Them 00:03:00 Stay Sane by Not Creating More Pain and Suffering For Myself and Others 00:07:00 Make a Positive Contribution to My Family Members and Friends 00:07:00 Eat a Balanced Healthy Diet And Feel I Can Eat Whatever I Want to 00:07:00 Exercise 00:03:00 Do The Right Amount of Something Productive 00:05:00 Have Some Fun 00:05:00 Stay Curious 00:10:00 Help Someone 00:08:00 Clean Up And Fix Up 00:08:00 Practice Saying Thank You and Staying Grateful 00:07:00 Building A Life Defined by Accomplishing Daily Goals. How Do I Do It Nothing I Get Involved in is More Important Than My Daily Goals 00:05:00 Sometimes it Comes Down to a Walk at The Doctor's Office 00:05:00 Laziness is My Friend And I Design My Life Around Accepting How Lazy I Am 00:05:00 Habits Are My Friend Because a Few Good Habits Accomplish Most all The Goals 00:05:00 Anything That Gets in The Way of Daily Goals I Consistently Fix 00:04:00 Accepting The Things I Cannot Change and Changing The Things I Can 00:05:00 Daily Goal Setting Looks Easy. What Makes It Difficult and How to Fix It This Seems Too Easy to Be Really Work The Mind Loves Complexities 00:05:00 Any Sickness That Exists Will Trample on Daily Goals 00:06:00 Being Above or Below Accomplishing Daily Goals And Humility 00:06:00 Too Busy to Have 10 Things to Do Every Day 00:05:00 If You See You Cannot Live Right on Your Own, The Only Solution is To Get Help 00:05:00 Congratulations on Completing the Course! What Next Thank You For Finishing This Course.What Did it Motivate You To Do 00:02:00 A Year Later, How Does My Life Look After Doing These Goals 00:08:00 What if I Fail The Goals 00:06:00 Practicing Unconditional Love For Others 00:11:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Duration 5 Days 30 CPD hours This course is intended for Senior Linux system administrators who use high-availability clustering and fault-tolerant shared storage technologies to maximize resiliency of production services. Overview Install and configure a Pacemaker-based high availability cluster. Create and manage highly available services. Troubleshoot common cluster issues. Work with shared storage (iSCSI) and configure multipathing. Implement Logical Volume Manager (LVM) in cluster-aware configurations. Configure GFS2 file systems on storage shared by multiple nodes. Deploy reliable, available critical production services in a high availability cluster In the Red Hat High Availability Clustering (RH436) course, you will learn how to provide highly available network services to a mission-critical enterprise environment through the deployment and management of shared storage and server clusters. Created for senior Linux system administrators, this 4-day course strongly emphasizes lab-based activities. You will set up a cluster of systems running the Pacemaker component of the Red Hat Enterprise Linux High-Availability Add-On, and deploy Linux-based services such as web servers and databases on that cluster. Cluster storage components from the Resilient Storage Add-On are also covered; installations and applications that require multiple cluster nodes can access the same storage simultaneously. This includes Logical Volume Manager (LVM) Shared Volume Groups, Red Hat Global File System 2 (GFS2), and Device-Mapper Multipath. This course is based on Red Hat Enterprise Linux 8.3. Prerequisites Red Hat Certified System Administrator (RHCSA) exam (EX200) and associated courses. Red Hat Cerfitied Engineer (RHCE) exam (EX294) and associated courses. 1 - Creating high availability clusters Create a basic high availability cluster. 2 - Managing cluster nodes and quorum Manage node membership in the cluster and describe how it impacts cluster operation. 3 - Isolating malfunctioning cluster nodes Isolate unresponsive cluster nodes to protect data and recover services and resources after a failure. 4 - Creating and configuring resources Create basic resources and resource groups to provide highly available services. 5 - Troubleshooting high availability clusters Identify, diagnose, and fix cluster issues. 6 - Automating cluster and resource deployment Deploy a new high availability cluster and cluster resources using Ansible automation. 7 - Managing two-node clusters Operate two-node clusters while identifying and avoiding issues specific to a two-node cluster configuration. 8 - Accessing iSCSI storage Configure iSCSI initiators on your servers to access block-based storage devices provided by network storage arrays or Ceph storage clusters. 9 - Accessing storage devices resiliently Configure resilient access to storage devices that have multiple access paths. 10 - Configuring LVM in clusters Select, configure, and manage the correct LVM configuration for use in your cluster. 11 - Providing storage with the GFS2 cluster file system Use the GFS2 cluster file system to simultaneously pProvide tightly coupled shared storage that can be accessed by multiple nodes. 12 - Eliminating single points of failure Identify and eliminate single points of failure in your cluster to decrease risk and increase average service availability. Note: Course outline is subject to change with technology advances and as the nature of the underlying job evolves. For questions or confirmation on a specific objective or topic, please contact a training specialist. Additional course details: Nexus Humans Red Hat High Availability Clustering (RH436) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Red Hat High Availability Clustering (RH436) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1.875 Days 11.25 CPD hours This course is intended for The job roles best suited to the material in this course are: team leaders, project managers, managers of scrum teams, teams transitioning to scrum, professionals intending to pursue the scrum master certification. Overview How to use the Scrum Framework to deliver products and services faster and with higher quality. How to leverage lean principles to identify waste in a system, process, or organization. Techniques and metics Scrum Masters use to improve. team happiness and performance. The patterns and practices of high-performing teams. How the Scrum Master role scales in an Agile implementation. This course is an adaptive, repeatable process that equips individuals and organizations in how to thrive in a world where change is the only constant. From Fortune 100 companies (Google, Amazon, Apple, etc) to nonprofits. Scrum has a proven record of reducing burnout, doubling throughput in half the time, and increase employee happiness. Core Scrum The Scrum Framework The Origins of Scrum (Optional) The Scrum Team Developers Scrum Master Leadership/Management Scrum Events The Sprint Product Backlog Re1nement Estimation Sprint Planning Sprint Review Sprint Retrospective Daily Scrum Scrum Artifacts Lean Principles Describe a Kaizen mindset and explain how small, iterative changes can lead to revolutionary leaps. Describe the three pillars of Scrum ? Transparency, Inspection, and Adaptation,? which implement the work of Ogunnaike and Ray. Explain the importance of reducing and eliminating waste in the system. Perform a root-cause analysis (e.g., using the ?5 Whys? technique). Assess the Process EZciency of their Scrum Team and recall that the de1nition of Lean is a Process EZciency of 25% or higher. Explain how the work of Takeuchi and Nonaka on Lean and the Toyota Production System paved the way for Scrum. Describe the origins of the name ?Scrum? from Takeuchi and Nonaka?s ?New New Product Development Game. Recognize that a Lean mindset suggests that you address a defect immediately after it is identi1ed as opposed to a mindset where defects are stored to be 1xed later. Agile Manifesto Recognize the four values of the Agile Manifesto and their signi1cance in the context of complex adaptive systems. Identify the 12 principles of the Agile Manifesto and describe their function in guiding practices that support teams in implementing and executing with agility. Explain that Scrum is one of the driving forces that gave rise to the Agile movement and predates the Agile Manifesto. Explain why the majority of ?Agile? teams are late, over-budget, and with unhappy customers (i.e., not agile) and explain what needs to be done to 1x that. Patterns of High Performing Teams Yesterday?s Weather Happiness Metric Teams that Finish Early Accelerate Faster Stable Teams Swarming Interrupt Buffer Good Housekeeping (formerly Daily Clean Code) Scrum Emergency Procedure Scrum@Scale Descaling Scaling the Scrum Master Registered Scrum Master Credential Access and complete the Registered Scrum Master by Scrum Inc. exam. Download their Registered Scrum Master Credential (upon successful completion of the exam). Be Recognized in the International Registry of Agile ProfesstionalsTM State the renewal process. Additional course details: Nexus Humans Agile Scrum training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Agile Scrum course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Overview This Hormone Health & Testosterone Course will unlock your full potential and will show you how to excel in a career in Hormone Health & Testosterone Course. So upskill now and reach your full potential. Everything you need to get started in Hormone Health & Testosterone Course is available in this course. Learning and progressing are the hallmarks of personal development. This Hormone Health & Testosterone Course will quickly teach you the must-have skills needed to start in the relevant industry. In This Hormone Health & Testosterone Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Hormone Health & Testosterone Course skills to help you advance your career. Acquire a comprehensive understanding of various Hormone Health & Testosterone Course topics and tips from industry experts. Learn in-demand Hormone Health & Testosterone Course skills that are in high demand among UK employers, which will help you to kickstart your career. This Hormone Health & Testosterone Course covers everything you must know to stand against the tough competition in the Hormone Health & Testosterone Course field.  The future is truly yours to seize with this Hormone Health & Testosterone Course. Enrol today and complete the course to achieve a Hormone Health & Testosterone Course certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Hormone Health & Testosterone Course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Hormone Health & Testosterone Course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Hormone Health & Testosterone Course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Hormone Health & Testosterone Course is suitable for anyone aspiring to start a career in Hormone Health & Testosterone Course; even if you are new to this and have no prior knowledge on Hormone Health & Testosterone Course, this course is going to be very easy for you to understand.  And if you are already working in the Hormone Health & Testosterone Course field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Hormone Health & Testosterone Course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Hormone Health & Testosterone Course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Hormone Health & Testosterone Course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Hormone Health & Testosterone Course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Introduction Course Overview & What you will learn 00:02:00 The Endocrine System Explained Hormones Introduction 00:02:00 The 3 Types Of Hormones 00:03:00 The Endocrine System explained 00:04:00 Cholesterol, Hormones And Heart Disease 00:04:00 Module 02: Drugs and Their Effects 00:40:00 Individual Hormones Explained Overview: Most Important Hormones 00:01:00 Insulin 00:04:00 Glucagon 00:02:00 Adrenaline 00:03:00 Cortisol 00:04:00 Ghrelin 00:02:00 Leptin 00:03:00 Thyroid Hormones 00:02:00 Estrogen 00:03:00 Growth Hormone 00:01:00 Testosterone 00:01:00 Optimizing Testosterone Levels: Introduction Testosterone Explained 00:03:00 Why testosterone is also important for women 00:02:00 How to check if you suffer from low testosterone levels 00:04:00 Diet Strategies To Boost Testosterone & Balance Hormones Diet Introduction 00:01:00 Calories & Testosterone 00:04:00 Carbohydrates & Testosterone 00:02:00 Fat & Testosterone 00:02:00 Protein & Testosterone 00:01:00 Meal Timing & Testosterone 00:03:00 Setting Up Your Diet Setting Up Your Diet Overview 00:01:00 How to determine your calorie maintenance level (TDEE) 00:03:00 How to track calories 00:05:00 Ideal Protein Intake 00:01:00 Ideal Fat Intake 00:01:00 What about the remaining calories 00:02:00 Determining Meal Structure 00:03:00 Quality Protein Foods 00:01:00 Quality Fat Foods 00:01:00 Adjusting your diet for weight loss 00:05:00 Adjusting Your Diet For Muscle Gains 00:04:00 Cheat Meals & Cheat Days 00:05:00 Testosterone Boosting Workout Workout Introduction 00:02:00 The best gym exercises to boost testosterone 00:03:00 Muscle Building Formula 00:07:00 Progressive Overload 00:03:00 How to set up your workout 00:01:00 Your Gym Workout Routine 00:06:00 Bench Press 00:01:00 Squats 00:01:00 Military Press 00:01:00 Deadlift 00:01:00 Lat Pulldown 00:01:00 Underhand Grip Row 00:01:00 HIIT Explained 00:07:00 How To Design Your HIIT Workout 00:05:00 How To Design Your HIIT Workout 00:05:00 Rest & Sleep Rest & Sleep Introduction 00:02:00 Sleeping Correctly 00:04:00 6 Tips to fall asleep faster 00:03:00 Supplements for better sleep 00:02:00 Lifestyle Improvements Lifestyle Improvements Introduction 00:01:00 Body language 00:04:00 Managing Stress 00:05:00 The Right Foods To Reduce Stress 00:03:00 Work and life balance 00:04:00 Cold Showers 00:03:00 BPA 00:02:00 Sex 00:02:00 Alcohol 00:02:00 Supplements Testosterone Supplements Introduction 00:01:00 Maca 00:02:00 Tribulus 00:02:00 Vitamin D 00:02:00 Zinc 00:01:00 DHEA 00:01:00

Overview of Control and Administration of Medicines In the ever-evolving landscape of healthcare, the control and administration of medicines stand as pillars of patient safety and well-being. The UK's healthcare sector is witnessing a surge in demand for skilled professionals adept in medicine management. With an ageing population and increasingly complex medical needs, the importance of effective medication control cannot be overstated. Recent statistics reveal that medication errors cost the NHS in England over £98 million annually and cause 712 deaths on average per year. This underscores the critical need for comprehensive training in the administration of medicines. Our course on Control and Administration of Medicines addresses this pressing need, equipping learners with the knowledge to navigate the intricate world of pharmacology and medicine management. From understanding the fundamentals of medicine management to exploring the nuances of palliative care, this course offers a thorough grounding in essential concepts. Delve into the four principles of medicine optimisation, unravel common pharmacological challenges, and gain insights into the legal landscape governing medication control. By mastering these crucial aspects, you'll be poised to make a significant impact in healthcare settings, enhancing patient outcomes and contributing to a safer, more efficient healthcare system. This Control and Administration of Medicines Course will help you to learn: Explain the fundamentals of medicine management and administration. Discuss the importance of effective medicine management. Demonstrate how to prescribe medication appropriately. Identify common medication problems and solutions. Recognises commonly used medicines. Apply principles of palliative care medicine. Apply the four principles of medicine optimisation. Manage medication in aged care facilities. Understand relevant laws and legislation. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Control and Administration of Medicines Online Training Course. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Control and Administration of Medicines Online Training Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Caregivers: Enhance your knowledge and confidence in medication administration for loved ones. Healthcare Professionals: Refine your skills and stay up-to-date with best practices in medication management. Pharmacy Staff: Deepen your understanding of medicines and their role in patient care. Community Workers: Equip yourself to support individuals in managing their medications effectively. Aspiring Healthcare Professionals: Lay a strong foundation for a rewarding healthcare career. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Control and Administration of Medicines Online Training Course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Control and Administration of Medicines Online Training Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.  Mental Health Nurse: £22K to £33K/year. Community Nurse: £35K to £45K/year. Pharmacist: £30K to £50K/year. Pharmacy Technician: £18K to £28K/year. Healthcare Assistant: £16K to £28K/year.   Course Curriculum Module 01: Medicine Management Fundamentals Medicine Management Fundamentals 00:37:00 Module 02: Importance of Medicine Management Importance of Medicine Management 00:25:00 Module 03: Prescribing Medication Effectively Prescribing Medication Effectively 00:27:00 Module 04: Common Problems - Pharmacological Management Common Problems - Pharmacological Management 01:05:00 Module 05: Common Medicines to Use Common Medicines to Use 00:18:00 Module 06: Palliative Care Palliative Care 00:24:00 Module 07: The Four Principles of Medicine Optimisation The Four Principles of Medicine Optimisation 00:00:00 Module 08: Managing Medication in Residential Aged Care Facilities Managing Medication in Residential Aged Care Facilities (RACFs) 00:35:00 Module 09: Law and Legislation Law and Legislation 00:25:00 Assignment Assignment - Control and Administration of Medicines Online Training Course 00:00:00

Join our Renewable Energy: Solar course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Renewable Energy: Solar course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Renewable Energy: Solar course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Renewable Energy: Solar. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Renewable Energy: Solar course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Renewable Energy: Solar is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Renewable Energy: Solar course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Renewable Energy: Solar Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 1- Basics of Solar Energy System Module 1- Introduction To PV System Construction 00:24:00 Module 2- Solar Heating, Solar Irradiation And Panels 00:38:00 Module 3- Effect of Insolation and Temperature on V-I Curve 00:05:00 Module 4- PV Installation, Short Circuit And Open Circuit Tests Using Avometer 00:15:00 Module 5- Solar Wires And Cables Installation Process 00:22:00 Module 6- Mounting Of PV System 00:04:00 Module 7- Shading and Tilt angle In Solar Energy 00:15:00 Module 8- Half Cut Cell Technology In PV System For Solar Engineering 00:25:00 Module 9- Importance Of Charge Controller In Solar Energy System 00:03:00 Module 10- PWM And MPPT Charge Controllers 00:14:00 Module 11- Understanding More about MPPT Solar Charge Controller For Solar Energy Course 00:24:00 Module 12- Junction Box In Solar Energy System 00:04:00 Module 13- Wiring of Junction Box In Solar Energy System 00:05:00 Module 14- Function, Types And Data Sheet Of Inverter 00:55:00 Module 15- Determining PV Array Maximum System Voltage 00:09:00 Unit 2- Batteries in PV System Module 1- Construction And Types Of Batteries In Solar Energy System 00:09:00 Module 2- Charging Of Lead Acid Batteries And Hydrometer In Solar Energy System 00:07:00 Module 3- Maintenance Of Batteries And Methods Of Charging In Solar Energy System 00:03:00 Module 4- Cycle of Batteries 00:04:00 Unit 3- Components and Design of Off Grid Solar Energy System Module 1- Off-Grid Solar System 00:02:00 Module 2- Advantages of Off-Grid Solar System 00:02:00 Module 3- Equipment of Off-Grid Solar System 00:04:00 Module 4- Selection and Datasheet of the Panel 00:04:00 Module 5- Inverter Selection 00:02:00 Module 6- Example 1 On Designing Off Grid System 00:01:00 Module 7- Determine Power Consumption Demands 00:04:00 Module 8- Size the PV modules 00:05:00 Module 9- Inverter sizing 00:04:00 Module 10- Battery Sizing 00:08:00 Module 11- Solar Charge Controller Sizing 00:05:00 Module 12- MPPT Charge Controller Sizing 00:10:00 Module 13- Example 2 Design of an OFF Grid System 00:20:00 Unit 4- Designing of ON Grid Solar Energy System Module 1- Grid-Tied Solar System 00:03:00 Module 2- Advantages of Grid-Tied Solar System 00:04:00 Module 3- Equipment of Grid-Tied Solar System 00:03:00 Module 4- Example Design of an On Grid System 00:10:00 Module 5- PV Energy According to Area 00:02:00 Unit 5- Design of PV System Using PVSyst Programme Module 1- Design of an Off Grid Solar Energy System Using PVSYST Program 00:28:00 Module 2- Design Of An On Grid Solar Energy System Using PVSyst Program 00:12:00 Module 3- Mega PV System Design Using PVSyst Program For Solar Energy 00:29:00 Unit 6- Solar Water Pumping System Module 1- Introduction To Water Pumping System And Steps Of Design 00:24:00 Module 2- Solved Example On Solar Pumping System Design 00:23:00 Unit 7- Protection of PV System Module 1- Introduction to Protection Of PV System 00:07:00 Module 2- Selection of Fuses and Protection of String 00:13:00 Module 3- Protection of Arrays 00:07:00 Module 4- Protection of Inverter 00:07:00 Module 5- Protection of Transformer 00:07:00 Module 6- Surge Protection Device 00:02:00 Module 7- Grounding of PV System 00:07:00 Module 8- Types of BusBars in PV System and Selection of BusBars 00:12:00 Unit 8- Design Using Excel Sheet Module 1-Design Of Off Grid PV System Using Excel Sheet 00:26:00 Unit 9- Single Line Diagram of PV System Module 1- Single Line Diagram Of PV System And Selection Of Fuses And Breakers 00:45:00 Unit 10- MATLAB and ETAP PV Simulation Module 1- Simulation Of PV Cell In MATLAB And Obtaining V-I Characteristics 00:28:00 Module 2- Get a Complete Grid Connected PV Solar Energy System In MATLAB Simulink 00:25:00 Module 3- PV System Simulation Using ETAP Lesson 00:24:00

Description: The art of managing multiple financial accounts is called accounting. It is required for businesses in order to manage and predict financial encounters for the company. Whatever the case, accounting is a crucial part of running a business and with the help of this Advanced Accounting Diploma you could be just as important. This course is divided into four parts, and you start with learning the basics of accounting career. You will learn how to be successful, different careers in accounting, business softwares and much more. You will also discover more about accounting career training, how to find jobs in accounting, forensic accounting and free softwares. In the next section you indulge in bookkeeping and payroll management as part of this course and will be able to find out about terminologies, understand balance sheet, financial planning, budgeting and control. Finally you look into the American taxing system including focusing on specific states. This is the ultimate guide to accounting as you get to look into additional subjects such as tax, bookkeeping and payroll as well. So take this course now otherwise your balance sheet will only be weighed down. Who is the course for? Professionals who are seeking work in finance department, particularly in accounting activities People who want to get into banking and understand the financial sector 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 Accounting Diploma is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accounting Mangers Accountants Bankers Finance Officer Payroll Officer Bookkeeper Finance Administrator Accounting Course Overview (Accounting) 00:05:00 Getting the Facts Straight 00:30:00 The Accounting Cycle 00:30:00 The Key Reports 00:30:00 A Review of Financial Terms 00:30:00 Understanding Debits and Credits 00:15:00 Your Financial Analysis Toolbox 00:30:00 Identifying High and Low Risk Companies 00:30:00 The Basics of Budgeting 00:30:00 Working Smarter 00:10:00 Bookkeeping 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 Payroll Management What Is Payroll? 00:30:00 Principles Of Payroll Systems 01:00:00 Confidentiality And Security Of Information 00:30:00 Effective Payroll Processing 01:00:00 Increasing Payroll Efficiency 01:00:00 Risk Management in Payroll 00:30:00 Time Management 00:30:00 Personnel Filing 00:30:00 When Workers Leave Employment 01:00:00 Hiring Employees 00:30:00 Paye and Payroll for Employers 01:00:00 Tell HMRC about a New Employee 01:00:00 Net And Gross Pay 00:30:00 Statutory Sick Pay 00:30:00 Minimum Wage for Different types of Work 01:00:00 Tax System in the UK Tax System in the UK 01:00:00 Tax Management USA Individual Tax Saving Ideas 01:00:00 Tax Saving Measures For Business 01:00:00 The Tax Audit 01:00:00 The Ins And Outs Of Federal Payroll Taxes 02:00:00 Why People File Taxes Online 00:30:00 What Are Your County Property Taxes Used For? 00:30:00 Offering Personal Financial Advice -Ameriprise Financial Services 01:00:00 Using Free Tax Preparation Software 00:30:00 Consulting Tax Attorneys - Tax Law Specialists 00:30:00 Delinquent Property Taxes- Three Steps To Deal With Your Delinquent Property Taxes 01:00:00 Federal Income Taxes - How To Deal With Federal Income Taxes? 01:00:00 File State Taxes- E-File System Is The Best Way To File Your State Taxes 00:30:00 Filing Income Taxes- How To File Income Taxes? 01:00:00 Financial Planning Software- Nine Benefits Of Financial Planning Software 01:00:00 Free Taxes- Benefits Of Filing Free Taxes Online 00:30:00 Income Tax Forms- Three Must To Follow If You Desire To Fill Your Income Tax Forms Yourself 00:30:00 LLC Tax Savings- How To Avail LLC Tax Savings 00:30:00 Benefits Of Online Tax Forms Over Traditional Methods 00:30:00 Save On Taxes By Refinancing Your Mortgage 00:30:00 Save On Taxes By Spending Less On Credit 00:30:00 Save On Taxes By Investing In Life Insurance 00:30:00 Save On Taxes: Hot Tips 01:00:00 Save On Taxes With Tax Deductions 01:00:00 Federal Tax Law 2005 For Nonprofit Organizations 00:30:00 Understanding California State Taxes 00:30:00 Make Your Personal Finances Work for You 01:00:00 The Importance of Acquiring a Financial Planning Certificate 00:30:00 Social Development and Financial Planning 01:00:00 An Overview Of Hennepin County Property Taxes 00:30:00 Kentucky State Taxes 01:00:00 Maryland State Taxes 01:00:00 Ohio State Taxes 00:30:00 UBS Financial Services For Small And Large Business 00:30:00 What Is A VP Financial Planner? 00:15:00 Accounting Career Basics A Career in Accounting: Tips on How You Can be Successful 00:30:00 Accountancy Auditing Careers 00:30:00 Accountancy Career Change 00:30:00 Accountancy Career: The Reasons Why You Should Choose Accounting 01:00:00 Accounting/Accountancy Career: Steps to Success 00:30:00 Accounting Auditing Careers 00:30:00 Accounting Careers in Pontypridd 00:30:00 Accounting Careers: Promising Opportunities and Tips 00:30:00 Accounting Dictionary 00:30:00 Accounting Principles and Tulsa 00:30:00 Accounting Software for Small Businesses 00:30:00 Accounting Terms - Profit, Loss and Other Terms 00:30:00 Accounting Career Fundamentals Accounting 00:30:00 Advanced Accounting Career Training 00:30:00 Careers in Accountancy 01:00:00 Church Accounting Software 00:30:00 Finding an Accounting Job 00:30:00 Forensic Accounting 00:30:00 Free Accounting Software 00:30:00 List of Accounting Careers 00:30:00 Services in Financial Accounting 00:30:00 Successful Career in Accounting Even if You're Hit Forty! 00:30:00 The Benefits of an Accountancy Career 00:30:00 Types of Accountancy Career 00:30:00 Accounting Calculation 00:15:00 Reference Books Accounting Principles 00:00:00 Financial Accounting & Reporting 00:00:00 Mock Exam Mock Exam- Advanced Accounting Diploma 00:30:00 Final Exam Final Exam- Advanced Accounting Diploma 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Friday 26th April, 3pm, Muirhead Tower, University of Birmingham, Arts Building – LR6, Room 222 The Department of Public Administration and Policy and CEDAR are delighted to host a public seminar on The Politics of Becoming: Anonymity and Democracy in the Digital Age by Hans Asenbaum   Oxford University Press   When we participate in political debate or protests, we are judged by how we look, which clothes we wear, by our skin colour, gender and body language. This results in exclusions and limits our freedom of expression. The Politics of Becoming explores radical democratic acts of disidentification to counter this problem. Anonymity in masked protest, graffiti, and online debate interrupts our everyday identities. This allows us to live our multiple selves. In the digital age, anonymity becomes an inherent part of everyday communication. Through our smart devices we express our selves differently. As cyborgs our identities are disrupted and reassembled. We curate self-representations on social media, create avatars, share selfies and choose the skin colour of our emojis.   The Politics of Becoming encourages us to engage in a revolution of the self. Democratic pluralism is not only a matter of institutional design but also about how we express our identities. Inner revolutions change our personal realities and plant a seed for democratic futures.   Hans Asenbaum is a Senior Research Fellow at the Centre for Deliberative Democracy and Global Governance at the University of Canberra. His research interests include radical democracy, queer and gender studies, digital politics, and participatory research methods. In 2022 he received the ECPR Rising Star Award. Hans is the author of The Politics of Becoming: Anonymity and Democracy in the Digital Age (Oxford University Press, 2023) and co-editor of Research Methods in Deliberative Democracy (with Ercan, Curato and Mendonça, Oxford University Press, 2022). His work has been published in the American Political Science Review, New Media & Society, Politics & Gender, and the International Journal of Qualitative Methods. Friday 26th April, 3pm, Arts Building – LR6, Room 222, University of Birmingham Edgbaston Birmingham B15 2TT

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