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

5522 Courses

Python for Data Analysis

5.0(10)

By Apex Learning

Overview This comprehensive course on Python for Data Analysis will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Python for Data Analysis comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Python for Data Analysis. It is available to all students, of all academic backgrounds. Requirements Our Python for Data Analysis is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 19 sections • 99 lectures • 00:08:00 total length •Welcome & Course Overview: 00:07:00 •Set-up the Environment for the Course (lecture 1): 00:09:00 •Set-up the Environment for the Course (lecture 2): 00:25:00 •Two other options to setup environment: 00:04:00 •Python data types Part 1: 00:21:00 •Python Data Types Part 2: 00:15:00 •Loops, List Comprehension, Functions, Lambda Expression, Map and Filter (Part 1): 00:16:00 •Loops, List Comprehension, Functions, Lambda Expression, Map and Filter (Part 2): 00:20:00 •Python Essentials Exercises Overview: 00:02:00 •Python Essentials Exercises Solutions: 00:22:00 •What is Numpy? A brief introduction and installation instructions.: 00:03:00 •NumPy Essentials - NumPy arrays, built-in methods, array methods and attributes.: 00:28:00 •NumPy Essentials - Indexing, slicing, broadcasting & boolean masking: 00:26:00 •NumPy Essentials - Arithmetic Operations & Universal Functions: 00:07:00 •NumPy Essentials Exercises Overview: 00:02:00 •NumPy Essentials Exercises Solutions: 00:25:00 •What is pandas? A brief introduction and installation instructions.: 00:02:00 •Pandas Introduction: 00:02:00 •Pandas Essentials - Pandas Data Structures - Series: 00:20:00 •Pandas Essentials - Pandas Data Structures - DataFrame: 00:30:00 •Pandas Essentials - Handling Missing Data: 00:12:00 •Pandas Essentials - Data Wrangling - Combining, merging, joining: 00:20:00 •Pandas Essentials - Groupby: 00:10:00 •Pandas Essentials - Useful Methods and Operations: 00:26:00 •Pandas Essentials - Project 1 (Overview) Customer Purchases Data: 00:08:00 •Pandas Essentials - Project 1 (Solutions) Customer Purchases Data: 00:31:00 •Pandas Essentials - Project 2 (Overview) Chicago Payroll Data: 00:04:00 •Pandas Essentials - Project 2 (Solutions Part 1) Chicago Payroll Data: 00:18:00 •Matplotlib Essentials (Part 1) - Basic Plotting & Object Oriented Approach: 00:13:00 •Matplotlib Essentials (Part 2) - Basic Plotting & Object Oriented Approach: 00:22:00 •Matplotlib Essentials (Part 3) - Basic Plotting & Object Oriented Approach: 00:22:00 •Matplotlib Essentials - Exercises Overview: 00:06:00 •Matplotlib Essentials - Exercises Solutions: 00:21:00 •Seaborn - Introduction & Installation: 00:04:00 •Seaborn - Distribution Plots: 00:25:00 •Seaborn - Categorical Plots (Part 1): 00:21:00 •Seaborn - Categorical Plots (Part 2): 00:16:00 •Seborn-Axis Grids: 00:25:00 •Seaborn - Matrix Plots: 00:13:00 •Seaborn - Regression Plots: 00:11:00 •Seaborn - Controlling Figure Aesthetics: 00:10:00 •Seaborn - Exercises Overview: 00:04:00 •Seaborn - Exercise Solutions: 00:19:00 •Pandas Built-in Data Visualization: 00:34:00 •Pandas Data Visualization Exercises Overview: 00:03:00 •Panda Data Visualization Exercises Solutions: 00:13:00 •Plotly & Cufflinks - Interactive & Geographical Plotting (Part 1): 00:19:00 •Plotly & Cufflinks - Interactive & Geographical Plotting (Part 2): 00:14:00 •Plotly & Cufflinks - Interactive & Geographical Plotting Exercises (Overview): 00:11:00 •Plotly & Cufflinks - Interactive & Geographical Plotting Exercises (Solutions): 00:37:00 •Project 1 - Oil vs Banks Stock Price during recession (Overview): 00:15:00 •Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 1): 00:18:00 •Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 2): 00:18:00 •Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 3): 00:17:00 •Project 2 (Optional) - Emergency Calls from Montgomery County, PA (Overview): 00:03:00 •Introduction to ML - What, Why and Types..: 00:15:00 •Theory Lecture on Linear Regression Model, No Free Lunch, Bias Variance Tradeoff: 00:15:00 •scikit-learn - Linear Regression Model - Hands-on (Part 1): 00:17:00 •scikit-learn - Linear Regression Model Hands-on (Part 2): 00:19:00 •Good to know! How to save and load your trained Machine Learning Model!: 00:01:00 •scikit-learn - Linear Regression Model (Insurance Data Project Overview): 00:08:00 •scikit-learn - Linear Regression Model (Insurance Data Project Solutions): 00:30:00 •Theory: Logistic Regression, conf. mat., TP, TN, Accuracy, Specificityetc.: 00:10:00 •scikit-learn - Logistic Regression Model - Hands-on (Part 1): 00:17:00 •scikit-learn - Logistic Regression Model - Hands-on (Part 2): 00:20:00 •scikit-learn - Logistic Regression Model - Hands-on (Part 3): 00:11:00 •scikit-learn - Logistic Regression Model - Hands-on (Project Overview): 00:05:00 •scikit-learn - Logistic Regression Model - Hands-on (Project Solutions): 00:15:00 •Theory: K Nearest Neighbors, Curse of dimensionality .: 00:08:00 •scikit-learn - K Nearest Neighbors - Hands-on: 00:25:00 •scikt-learn - K Nearest Neighbors (Project Overview): 00:04:00 •scikit-learn - K Nearest Neighbors (Project Solutions): 00:14:00 •Theory: D-Tree & Random Forests, splitting, Entropy, IG, Bootstrap, Bagging.: 00:18:00 •scikit-learn - Decision Tree and Random Forests - Hands-on (Part 1): 00:19:00 •scikit-learn - Decision Tree and Random Forests (Project Overview): 00:05:00 •scikit-learn - Decision Tree and Random Forests (Project Solutions): 00:15:00 •Support Vector Machines (SVMs) - (Theory Lecture): 00:07:00 •scikit-learn - Support Vector Machines - Hands-on (SVMs): 00:30:00 •scikit-learn - Support Vector Machines (Project 1 Overview): 00:07:00 •scikit-learn - Support Vector Machines (Project 1 Solutions): 00:20:00 •scikit-learn - Support Vector Machines (Optional Project 2 - Overview): 00:02:00 •Theory: K Means Clustering, Elbow method ..: 00:11:00 •scikit-learn - K Means Clustering - Hands-on: 00:23:00 •scikit-learn - K Means Clustering (Project Overview): 00:07:00 •scikit-learn - K Means Clustering (Project Solutions): 00:22:00 •Theory: Principal Component Analysis (PCA): 00:09:00 •scikit-learn - Principal Component Analysis (PCA) - Hands-on: 00:22:00 •scikit-learn - Principal Component Analysis (PCA) - (Project Overview): 00:02:00 •scikit-learn - Principal Component Analysis (PCA) - (Project Solutions): 00:17:00 •Theory: Recommender Systems their Types and Importance: 00:06:00 •Python for Recommender Systems - Hands-on (Part 1): 00:18:00 •Python for Recommender Systems - - Hands-on (Part 2): 00:19:00 •Natural Language Processing (NLP) - (Theory Lecture): 00:13:00 •NLTK - NLP-Challenges, Data Sources, Data Processing ..: 00:13:00 •NLTK - Feature Engineering and Text Preprocessing in Natural Language Processing: 00:19:00 •NLTK - NLP - Tokenization, Text Normalization, Vectorization, BoW.: 00:19:00 •NLTK - BoW, TF-IDF, Machine Learning, Training & Evaluation, Naive Bayes : 00:13:00 •NLTK - NLP - Pipeline feature to assemble several steps for cross-validation: 00:09:00 •Resources- Python for Data Analysis: 00:00:00

Python for Data Analysis
Delivered Online On Demand8 minutes
£12

How does a UK company go about raising private equity?

By FD Capital

Private equity refers to investments made in private companies, where investors provide capital in exchange for equity ownership. Private equity refers to investments made in private companies, where investors provide capital in exchange for equity ownership. It’s a form of alternative investment that can help companies accelerate growth, expand operations, or make strategic acquisitions. For UK companies, private equity can be particularly attractive because it offers access to significant capital, strategic guidance, and industry expertise that can fuel their growth ambitions. Private equity CFOs are strategic leaders who strive to raise their company’s profile, engage with new talent, and attract the attention of private equity investors by creating an engaging investor story. CFOs with PE experience are growth-oriented, adopting a forward-looking approach, instead of looking through the rear-view mirror as financial often do. Private equity CFOs are multi-dimensional with a growing list of responsibilities. Many are set to become tomorrow’s CEOs, laying the groundwork by engaging with internal and external stakeholders. Organisations seeking private equity investment are increasingly recruiting CFOs during the early stages of their life cycle. CFOs with private equity house experience will drive value and nurture rich working relationships by boosting the company’s financial credibility with potential investors and traditional financial institutions. Companies seeking private equity funding in highly regulated industries, such as financial services and health care, will want to recruit a CFO who is an expert in that field. CFOs with industry-specific regulatory knowledge will understand the nuances and challenges that their company must contend with. To learn more visit our website at https://www.fdcapital.co.uk/cfo-recruitment/ Tags Online Events Things To Do Online Online Seminars Online Business Seminars #raising #uk #privateequity

How does a UK company go about raising private equity?
Delivered OnlineFlexible Dates
FREE

Counselling and Psychology - Training

By Training Tale

Counselling and Psychology is an advanced-level diploma course that analyzes and researches the responsibilities and duties of a professional psychiatrist. Do you have an interest in psychology and counselling? This course covers everything you need to know about this course and making a career out of it. Our expertly designed Counselling and Psychology course is here to solve all of your problems at once. Students can confidently learn all the necessary skills to join the psychology & counselling industry. 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. The Counselling and Psychology course was designed by expert instructors, industry-standard to guide you in the right direction and take a step on your career journey. This Counselling & Psychology course is ideal for those who are new to this profession and who want to increase their skills and knowledge. It covers the fundamentals of psychotherapy, as well as how to conduct online sessions. Explore the increasingly important role of the professional counselor and psychiatric. Discover why qualified counselors and psychiatrists are in higher demand and start working toward a rewarding profession for life. This bundle Counselling and Psychology course is an excellent medium if you want to improve your skills and understanding; it is one of the most popular courses. Through this Counselling and Psychology bundle course, you will gain a complete and informative understanding of Psychology and Counselling. Learn how to assist people in dealing with personal and professional challenges. There are numerous opportunities to work in well-established institutions and companies. Our Counselling and Psychology course will also help you to learn about potential psychotherapy clients and become familiar with the different types of psychotherapy, including Cognitive Behavioural Therapy (CBT). It covers how to conduct the first therapy session and counselling, form positive therapeutic relationships with your clients, and work with families, children, and groups, all with step-by-step instructions. Learning Outcomes After completing Counselling and Psychology 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 Counselling and Psychology Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. 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 Counselling & Psychology course. **Courses are included in this Counselling and Psychology Bundle Course Course 01: Counselling and Psychology Course 02: Clinical Psychology Diploma Course 03: Introduction to Psychology Course 04: Introduction to Psychotherapy Course 05: Child and Adolescent Mental Health Course Course 06: Adults Support Worker Course Course 07: Level 4 Diploma in Child Psychology Course ***Others Included of Counselling and Psychology Bundle Course Free 7 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Counselling and Psychology course] This Counselling and Psychology course can help you improve your reputation. You can tell the difference from the first lesson. This includes all of the teachings that you can easily understand and apply to your abilities. Individuals attempting to make a career in this field of psychology will benefit from this course's understanding of the fundamentals and comprehensive education. Whether you are new to this field or want to improve your skills and have a successful career, our course can help you get there. This course covers all relevant topics. We are committed to providing you with the best educational experience possible as one of the leading course providers and most renowned e-learning specialists online. This Counselling and Psychology course was created in collaboration with experts and mentors to help you learn quickly and efficiently, at your own pace and ease. We leave no stone unturned, and whether you are ready to take this Counselling and Psychology course in your career or simply want to improve your current skills, we will assist you every step of the way. When you study for a qualification online, you have complete control over your study schedule; there are no time-consuming classes to attend or long commutes to endure. The skills you learn here could lead to a lifelong career in counselling and psychology by which you can help those who are in need while also feeling proud of your accomplishments. Pursue your goals by enrolling in our course Counselling and Psychology now and gain the knowledge, skills, and information you need to advance your career. This course will help you empower yourself with the skills you need to get your ideal job. Detailed course curriculum of the Counselling and Psychology Course: Module 1: Introduction: Toward an Integrative Approach in Counselling Introduction Historical Background Integration I: Counselling in Positive Psychology Integration II: Counselling in Multicultural Populations Module 2: Therapeutic Relationship: Exploring Clients' Symptoms and Strengths What is Positive Empathetic Rapport? Understand Clients' Strengths and Characters Positive Empathetic Rapport in a Multicultural Context Module 3: Powered by Struggles and Strengths Current Counselling Theories: Are They Enough? What is Missing from the Current Theories? Positive Psychology: A New Blood to the Field? Module 4: Positive Psychology in Counselling: What is It? Definition of Positive Psychology Historical Context Theoretical Principles Limitations of Positive Psychology Positive Psychology for Multicultural Population Module 5: Psychoanalytic Therapy Historical Context Theoretical Principles An Integration: Positive Psychology and Psychoanalytic Therapy Multiculturalism the Integration Module 6: Adlerian Therapy Historical Context View of Human Nature Theoretical Principles An Integration: Positive Psychology and Adlerian Therapy Multiculturalism the Integration Module 7: Existential Therapy Historical Context View of Human Nature Theoretical Principles An Integration: Positive Psychology and Existential Therapy Multiculturalism the Integration Module 8: Person‐Centred Therapy Historical Context View of Human Nature Theoretical Principles An Integration: Positive Psychology and Person‐Centred Therapy Multiculturalism the Integration Module 9: Gestalt Therapy Historical Context View of Human Nature Theoretical Principles An Integration: Positive Psychology and Gestalt Therapy Multiculturalism the Integration Module 10: Behaviour Therapy Historical Context View of Human Nature Theoretical Principles An Integration: Positive Psychology and Behaviour Therapy Multiculturalism the Integration Module 11: Cognitive‐Behaviour Therapy Historical Context View of Human Nature Theoretical Principles An Integration: Positive Psychology and Cognitive‐Behaviour Therapy Multiculturalism the Integration Module 12: Reality Therapy Historical Context View of Human Nature Theoretical Principles An Integration: Positive Psychology and Reality Therapy Multiculturalism the Integration Module 13: Feminist Therapy Historical Context View of Human Nature Theoretical Principles An Integration: Positive Psychology and Feminist Therapy Multiculturalism the Integration Module 14: Family Therapy Historical Context Theoretical Principles An Integration: Positive Psychology and Family Therapy Multiculturalism the Integration ------------------- ***Clinical Psychology Diploma*** Module 01: An Overview of Mental Health Module 02: Different Viewpoints in Psychology Module 03: Social Psychology Module 04: Utilising Cognitive Psychology Module 05: Understanding Childhood and Adolescent Psychiatric Disorders Module 06: Understanding Stress and Anxiety Disorders Module 07: Understanding Schizophrenia Module 08: Understanding Personality Disorders Module 09: Understanding Mood Disorders Module 10: Understanding Eating & Sleeping Disorders Module 11: Understanding Self-Harm and Suicide Module 12: Treating Mental Illness: Medication and Therapy ------------------- ***Introduction to Psychology*** Module 01: Introducing Psychology Module 02: The Evolution of Psychology: Central Questions, History, and Contemporary Perspectives Module 03: Sensation and Perception Module 04: States of Consciousness Module 05: Learning Module 06: Memories and Forgetting Module 07: Thinking and Intelligence Module 08: Emotion and Motivation Module 09: Human Development Module 10: Personality Module 11: Social Psychology Module 12: Psychological Disorders Module 13: Treating Psychological Disorders Module 14: Health Stress and Coping ------------------- ***Introduction to Psychotherapy*** Module 01: Overview of Psychotherapy Module 02: Psychotherapy Practice Module 03: Prospective Clients in Therapy Module 04: Stages of Psychotherapeutic Relationship ------------------- ***Child and Adolescent Mental Health Course*** Module 01: An Overview of Mental Health Module 02: Understanding Child Psychology Module 03: Understanding Attachment and Relationship Building Module 04: How Separation and Loss Affects Attachment Module 05: Understanding Child Development Module 06: Mental Health Problems in Adolescent Module 07: Other Mental Health Problems in Adolescent Module 08: Impact of Autism, ADHD and Dyslexia in Adolescent Module 09: Coping With Autism, ADHD and Dyslexia in Adolescents Module 10: The Ways of Treating Mental Health Module 11: Mental Health over Life Span and Society in the UK Module 12: Relevant Mental Health Legislations in the UK ------------------- ***Adults Support Worker Course*** ------------------- ***Level 4 Diploma in Child Psychology Course*** Assessment Method After completing each module of the 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 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 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 Students who intend to enrol in this 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 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

Counselling and Psychology - Training
Delivered Online On Demand41 hours
£24

The Complete SQL : Bootcamp

By IOMH - Institute of Mental Health

Overview This The Complete SQL : Bootcamp course will unlock your full potential and will show you how to excel in a career in The Complete SQL : Bootcamp. So upskill now and reach your full potential. Everything you need to get started in The Complete SQL : Bootcamp is available in this course. Learning and progressing are the hallmarks of personal development. This The Complete SQL : Bootcamp will quickly teach you the must-have skills needed to start in the relevant industry. In This The Complete SQL : Bootcamp Course, You Will: Learn strategies to boost your workplace efficiency. Hone your The Complete SQL : Bootcamp skills to help you advance your career. Acquire a comprehensive understanding of various The Complete SQL : Bootcamp topics and tips from industry experts. Learn in-demand The Complete SQL : Bootcamp skills that are in high demand among UK employers, which will help you to kickstart your career. This The Complete SQL : Bootcamp course covers everything you must know to stand against the tough competition in the The Complete SQL : Bootcamp field.  The future is truly yours to seize with this The Complete SQL : Bootcamp. Enrol today and complete the course to achieve a The Complete SQL : Bootcamp 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 The Complete SQL : Bootcamp 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 The Complete SQL : Bootcamp 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 The Complete SQL : Bootcamp 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 The Complete SQL : Bootcamp is suitable for anyone aspiring to start a career in The Complete SQL : Bootcamp; even if you are new to this and have no prior knowledge on The Complete SQL : Bootcamp, this course is going to be very easy for you to understand.  And if you are already working in the The Complete SQL : Bootcamp 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 The Complete SQL : Bootcamp 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 The Complete SQL : Bootcamp course has no prerequisite.  You don't need any educational qualification or experience to enrol in the The Complete SQL : Bootcamp 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 The Complete SQL : Bootcamp course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum overview 00:04:00 Overview of Databases 00:08:00 SQL Environment Setup PostgreSQL Installation 00:13:00 Connecting to PostgreSQL using psql 00:04:00 Connecting to PostgreSQL using PgAdmin 00:07:00 Creating Database and Tables Basic of Database and Tables 00:06:00 Data Types 00:07:00 Primary Keys and Foreign Keys 00:04:00 Create Table in SQL Script 00:17:00 Insert 00:05:00 Update 00:05:00 Delete 00:03:00 Alter Table 00:05:00 Drop Table 00:02:00 Check Constraint 00:12:00 NOT NULL Constraint 00:04:00 UNIQUE Constraint 00:06:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:07:00 SELECT Statement 00:12:00 SELECT DISTINCT 00:10:00 Column AS Statement 00:07:00 COUNT 00:07:00 SELECT WHERE Clause - One 00:06:00 SELECT WHERE Clause - Two 00:11:00 ORDER 00:05:00 LIMIT 00:04:00 BETWEEN keyword usage on real time 00:08:00 IN Operator 00:06:00 LIKE and ILIKE 00:10:00 GROUP BY Statements Overview of GROUP BY 00:03:00 Aggregation Function 00:12:00 GROUP BY - One 00:05:00 GROUP BY - Two 00:06:00 HAVING on SQL Statement 00:04:00 JOINS Overview of JOINS 00:07:00 Introduction to JOINS 00:06:00 AS Statement table 00:05:00 INNER Joins 00:14:00 Full Outer Joins 00:04:00 Left Outer join 00:03:00 Right Outer Join 00:05:00 Union 00:05:00 Advanced SQL Commands Basic of Advanced SQL Commands 00:04:00 Timestamps 00:17:00 Extract from Timestamp 00:05:00 Mathematical Functions 00:06:00 String Functions 00:16:00 SubQuery 00:08:00 Databases and Tables Overview of Databases and Tables 00:02:00 Creating a Database backup 00:03:00 Restoring a Database from backup 00:04:00 Mock Exam Mock Exam - The Complete SQL from Scratch: Bootcamp 00:20:00 Final Exam Final Exam - The Complete SQL from Scratch: Bootcamp 00:20:00

The Complete SQL : Bootcamp
Delivered Online On Demand6 hours 37 minutes
£11.99

Overview This Agile Scrum course will unlock your full potential and will show you how to excel in a career in Agile Scrum. So upskill now and reach your full potential. Everything you need to get started in Agile Scrum is available in this course. Learning and progressing are the hallmarks of personal development. This Agile Scrum will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Agile Scrum skills to help you advance your career. Acquire a comprehensive understanding of various Agile Scrum topics and tips from industry experts. Learn in-demand Agile Scrum skills that are in high demand among UK employers, which will help you to kickstart your career. This Agile Scrum course covers everything you must know to stand against the tough competition in the Agile Scrum field.  The future is truly yours to seize with this Agile Scrum. Enrol today and complete the course to achieve a Agile Scrum 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 Agile Scrum 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 Agile Scrum 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 Agile Scrum 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 Agile Scrum is suitable for anyone aspiring to start a career in Agile Scrum; even if you are new to this and have no prior knowledge on Agile Scrum, this course is going to be very easy for you to understand.  And if you are already working in the Agile Scrum 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 Agile Scrum 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 Agile Scrum course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Agile Scrum 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 Agile Scrum course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum OBJECTIVES AND TARGETS Objectives and Targets 00:09:00 Download: course curriculum in pdf 00:05:00 FROM THE TRADITIONAL DEVELOPMENT MODEL TO THE AGILE Waterfall. Typical challenges 00:05:00 Agile history and 2001's Manifesto 00:11:00 Agile. A different approach 00:04:00 Agile benefits 00:02:00 When agile is best applied + success factors 00:03:00 Download: Agile Vs Waterfall. Overview diagram 00:01:00 Download: Agile Vs Waterfall side by side by project stage 00:04:00 2020 SCRUM GUIDE: WHAT'S NEW! 2020 SCRUM GUIDE: WHAT'S NEW! 00:22:00 BONUS: FULL EBOOK OF THE COURSE! BONUS - Full eBOOK of the Course 00:01:00 SCRUM Download: the Scrum Guide 00:14:00 Download: the Scrum Glossary 00:08:00 Download: Framework Navigator 00:01:00 Scrum introduction 00:12:00 Theory and values 00:08:00 THE SCRUM TEAM The Scrum Team - Introduction 00:08:00 Product, Product Goal and Product Owner 00:14:00 Developers 00:03:00 The scrum master 00:08:00 Characteristics of a perfect scrum master 00:23:00 SCRUM EVENTS Introduction 00:03:00 The Sprint 00:06:00 Download: Diagram of a typical Sprint (with events, roles, artifacts) 00:01:00 The sprint planning 00:10:00 The daily scrum 00:04:00 The sprint review 00:06:00 The sprint retrospective 00:05:00 SCRUM ARTIFACTS Product backlog 00:08:00 Sprint backlog 00:02:00 Increment and definition of done 00:04:00 Commitments 00:04:00 SCALING SCRUM Introduction 00:02:00 Scrum of scrums 00:02:00 Nexus framework 00:05:00 Download: the Nexus Framework poster 00:01:00 SCRUM IN PRACTICE ! A day in the life of a typical Sprint 00:32:00 AGILE REQUIREMENTS Products, Initiatives, Epics, Features, Stories and Tasks 00:11:00 ESTIMATION TECHNIQUES Underlying theory, t-shirt sizing, planning poker 00:09:00 Bucket system, affinity mapping, time unit 00:04:00 AGILE METRICS Underlying theory. Velocity 00:07:00 Sprint burn-down 00:08:00 Release burn-up, cumulative flow, other metrics 00:06:00 PSM1 CERTIFICATION PREPARATION GUIDELINES, TIPS & TRICKS How to best prepare for PSM I Certification 00:09:00 PSM1 CERTIFICATION PREPARATION GUIDELINES, TIPS & TRICKS PSM I EXAM SIMULATOR #1 and #2 (80+80 HIGH QUALITY QUESTIONS. REAL MODE) 00:01:00

Agile Scrum
Delivered Online On Demand5 hours 16 minutes
£11.99

AutoCAD VBA Programming - Beginner course

4.5(3)

By Studyhub UK

Embark upon a journey of discovery with the 'AutoCAD VBA Programming - Beginner course,' where your first steps into the realm of programming within AutoCAD will lay a solid foundation for future innovation. This course is meticulously designed to guide you through the essentials, commencing with a comprehensive introduction that sets the stage for your learning adventure. As the curtain rises, you will be introduced to the robust Integrated Development Environment (IDE) where the magic of coding comes to life. Progressing through the syllabus, your insight into the AutoCAD Object Model will expand, revealing the intricacies of harnessing VBA to manipulate this powerful design tool. You'll delve into the world of variables, learning to juggle the data that acts as the building blocks of robust programming structures. As you advance, the course unveils the secret to crafting interactive user interfaces with User Forms and Controls, enabling you to tailor the AutoCAD experience like never before. The crescendo of your learning expedition peaks with mastering decision-making through Conditionals and exploiting the power of Looping to automate repetitive tasks, culminating in your ability to conjure up precise drawing objects with VBA scripts. Your newfound competence will also include troubleshooting your own code with Debugging techniques and navigating unforeseen errors with adept Error Handling strategies, ensuring that you conclude the course poised to tackle real-world challenges with confidence. Learning Outcomes: Gain an understanding of VBA within AutoCAD to create custom scripts. Develop the capability to construct and manipulate user interfaces in AutoCAD. Acquire the skills to make logical decisions and automate tasks through coding. Learn the strategies to identify and correct errors in VBA scripts. Master the application of VBA to enhance precision in AutoCAD drawings. Why buy this AutoCAD VBA Programming - Beginner course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the AutoCAD VBA Programming - Beginner course Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? Individuals keen to learn programming within a CAD environment. Professionals in the design industry looking to add automation to their toolkits. Beginners in programming aiming to apply their skills in technical drawing. CAD technicians aspiring to increase efficiency in their workflow. Design students seeking to supplement their studies with technical scripting abilities. Prerequisites This AutoCAD VBA Programming - Beginner course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This AutoCAD VBA Programming - Beginner course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path CAD Technician - £20,000 to £35,000 per annum VBA Developer - £30,000 to £60,000 per annum AutoCAD Designer - £25,000 to £40,000 per annum BIM Coordinator - £35,000 to £50,000 per annum Structural Engineer - £28,000 to £48,000 per annum Architectural Technologist - £22,000 to £35,000 per annum Course Curriculum Unit 01: Introduction Module 01: Introduction 00:04:00 Module 02: Course Content Identified 00:06:00 Unit 02: VBA Integrated Development Environment (IDE) Module 01: Setting-up the Environment (Installing VBA IDE) 00:01:00 Module 02: Downloading and Installing AutoCAD VBA IDE 00:04:00 Module 03: Identify and Understand VBA IDE Components (Toolbars and Windows) 00:03:00 Module 04: VBA IDE Walkthrough 00:14:00 Unit 03: Understanding AutoCAD Object Model in VBA Module 01: Examining AutoCAD VBA Object Model Structure 00:07:00 Module 02: Examining AutoCAD Object Model Structure Part 2 00:06:00 Unit 04: Using Variables in VBA Module 01: Working on Variables 00:01:00 Module 02: Using Variables in the Program 00:14:00 Unit 05: User Forms and Controls Module 01: User Forms and Controls Topic Breakdown 00:02:00 Module 02: Using Label, Textbox and Command Button Controls 00:10:00 Module 03: Using ListBox Control 00:06:00 Module 04: Using ComboBox Control 00:09:00 Module 05: Using CheckBox Control 00:08:00 Module 06: Using OptionButton Control 00:03:00 Module 07: Using MultiPage Control 00:10:00 Module 08: Using MultiPage Control Continued 00:14:00 Module 09: Using Frame Control 00:03:00 Unit 06: Conditionals and Decisions in VBA Module 01: Conditions and Decisions Course Outline 00:01:00 Module 02: IF-THEN-ELSE Condition 00:02:00 Module 03: IF-THEN-ELSEIF Condition 00:04:00 Module 04: Conditional Operators in VBA 00:04:00 Module 05: Logical Operators in VBA 00:07:00 Module 06: SELECT CASE Statement in VBA 00:05:00 Unit 07: Looping and Iterations in VBA Module 01: Looping and Iterations Overview 00:02:00 Module 02: Using DO-WHILE Loop in VBA 00:04:00 Module 03: Using DO-UNTIL Loop in VBA 00:02:00 Module 04: Using FORNEXT Loop in VBA 00:02:00 Module 05: Using FOREACHNEXT Loop in VBA 00:03:00 Unit 08: Drawings Objects in VBA Module 01: Drawing Objects Overview 00:01:00 Module 02: Draw a Line Object using Utility Function 00:03:00 Module 03: Draw a Line Object using Points from User's Input 00:07:00 Module 04: Draw a Circle Object Using Utility Functions 00:03:00 Module 05: Draw a Text Object using Utility Functions 00:05:00 Module 06: Draw a LWPolyline and Polyline Objects 00:06:00 Unit 09: Code Debugging in VBA Module 01: Code Debugging Overview3 00:01:00 Module 02: Code Debugging in VBA Demo3 00:12:00 Module 03: Code Debugging in VBA Demo Continued 00:02:00 Unit 10: Error Handling in VBA Module 01: Error Handling Course Outline 00:02:00 Module 02: Error Handling in VBA Demo 00:13:00 Unit 11: Conclusion Module 01: Conclusion and Thank you! 00:01:00 Assignment Assignment - AutoCAD VBA Programming - Beginner course 00:00:00

AutoCAD VBA Programming - Beginner course
Delivered Online On Demand3 hours 37 minutes
£10.99

Weight Loss Coach Certification (Accredited): All Levels

4.5(3)

By Studyhub UK

Embarking on a journey towards a healthier self is an adventure many dreams of, yet only some understand how to navigate effectively. The 'Weight Loss Coach Certification (Accredited): All Levels' course is a beacon of hope, guiding you through the maze of weight loss injections, ozempic weight loss, and the myriad of weight loss pills with precision. It's not just about shedding pounds; it's a transformative experience that incorporates the science of weight loss calculators and the inspiring stories of individuals like Peter Kay, Letitia Dean, Mark Labbett, Alison Hammond, and Nikocado Avocado. This course is meticulously designed to equip you with the knowledge and tools to make meaningful changes in your life and the lives of others. Learning Outcomes of Weight Loss Coach Certification: Understand the foundational principles of weight loss nutrition and the effectiveness of various diets. Master the coaching process tailored for weight management and how to personalise plans for diverse needs. Gain insights into solving common weight related challenges using scientific and motivational strategies. Learn to build and promote a personal brand in the fitness coaching industry. Acquire the skills to motivate clients and monitor their progress through practical and theoretical approaches. Why buy this Weight Loss Coach Certification? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Weight Loss Coach Certification (Accredited): All Levels there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Weight Loss Coach Certification for? Individuals passionate about health, wellness, and nutrition seeking to guide others in their weight-loss journeys. Fitness professionals aiming to broaden their expertise in weight management coaching. Anyone interested in understanding the science behind losing weight and how to apply it effectively. Career changers looking for a rewarding profession in the health and wellness industry. Health bloggers or influencers wanting to enhance their knowledge and credibility in losing weight. Prerequisites This Weight Loss Coach Certification (Accredited): All Levels does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Weight Loss Coach Certification (Accredited): All Levels was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Weight Loss Coach: £25,000 - £35,000 per annum Nutritionist: £20,000 - £40,000 per annum Personal Trainer: £18,000 - £50,000 per annum Health and Wellness Blogger/Influencer: Variable depending on reach and engagement Corporate Wellness Consultant: £30,000 - £45,000 per annum Health Club Manager: £24,000 - £40,000 per annum Course Curriculum Introduction Introduction 00:03:00 The Roles & Responsibilities Of A Weight Loss Coach 00:02:00 5 Reasons For Becoming A Weight Loss Coach 00:04:00 The Skills Your Need As A Weight Loss Coach 00:03:00 How Much Does A Weight Loss Coach Earn 00:03:00 Coaching Process The Different Coaching Business Models 00:04:00 Client Assesment Introduction 00:01:00 Getting To Know Your Client 00:04:00 Understanding Your Client's Painpoints 00:03:00 How To Set SMART Goals 00:06:00 Body Mass Index Explained 00:03:00 How To Keep Clients Motivated During The Coaching Process 00:04:00 Weight Loss Nutrition Theory Common Weight Loss Myths Debunked 00:09:00 The Weight Loss Nutrition Pyramid 00:05:00 The Science Of Successful Weight Loss 00:05:00 Weight Loss vs Fat Loss 00:03:00 What About Fat Loss Foods? 00:06:00 Determining calorie need (TDEE) 00:03:00 Adjusting A Diet For Weight Loss 00:03:00 How Much Protein For Weight Loss 00:02:00 How Much Fat For Weight Loss 00:01:00 How Many Carbs For Weight Loss 00:01:00 Combining Macronutrients 00:02:00 Ideal Meal Timing & Meal Frequency 00:04:00 How to create a diet plan for a client 00:09:00 The Best Fat Loss Supplements 00:04:00 Common Diets Explained Gluten Free Diet 00:03:00 Paleo Diet 00:04:00 Low Carb Diet 00:03:00 Intermittent Fasting 00:03:00 Vegan Diet 00:05:00 Ketogenic Diet 00:06:00 Weight Loss Training Theory Common Weight Loss Exercising Myths Debunked 00:08:00 The Perfect Weight Loss Workout 00:07:00 HIIT Explained 00:07:00 How To Progress With HIIT Workouts 00:02:00 Can You Build Muscle & Lose Fat At The Same Time? 00:08:00 Strength Training & Weight Loss 00:01:00 Why You Shouldn't Do More Reps When Trying To Lose Weight 00:03:00 Should You Train Fasted? 00:06:00 How To Solve Common Weight Loss Problems The Right Cheat Meals 00:05:00 How To Correctly Take Diet Breaks 00:05:00 How To Break Through A Fat Loss Plateau 00:04:00 How To Explain Sudden Weight Changes 00:03:00 Is Starvation Mode Real? 00:03:00 Weight Loss Motivation Weight Loss Motivation Overview 00:01:00 How To Track Progress 00:04:00 What's The Ideal Rate Of Fat Loss? 00:02:00 How To Stop Relying On Willpower 00:02:00 How To Avoid The 'What The Hell Effect' 00:01:00 Building Your Brand Marketing & Selling Introduction 00:02:00 Your Marketing Game Plan 00:02:00 Your Sales Approach 00:05:00 Content Marketing For Coaches 00:06:00 How To Define Your Mission Statement 00:03:00 Your Coaching Outline 00:02:00

Weight Loss Coach Certification (Accredited): All Levels
Delivered Online On Demand3 hours 33 minutes
£10.99

Rust Programming 2023 - A Comprehensive Course for Beginners

By Packt

This comprehensive Rust-focused course is perfect for individuals seeking in-depth knowledge and expertise in the fields of systems programming, concurrency, and web development. Through practical examples, code-along, and expert theory, you will master Rust and become proficient in building efficient and scalable programs for various applications.

Rust Programming 2023 - A Comprehensive Course for Beginners
Delivered Online On Demand6 hours 42 minutes
£82.99

Managing Mental Health & Wellbeing in Law Webinar

By Authentically Speaking

With the ongoing impact post pandemic and the shift to more remote working longer term, managing the mental health and well-being of our lawyers has become more important than ever. We know that as a HR professional / Head of People, you play a crucial role in ensuring the mental health and well-being of your firm. Often juggling this alongside many other responsibilities and demands on your time. A Head of People recently commented on what a lonely role this can be and we want to offer some support. That's why we're excited to invite you to our upcoming webinar on managing mental health and well-being in your firm. Webinar host, lawyer, coach and trainer specialising in lawyer wellbeing for the last 7 years, will offer valuable insights and practical tips on how you can support your lawyers' mental health during increasingly challenging times.

Managing Mental Health & Wellbeing in Law Webinar
Delivered OnlineFlexible Dates
FREE

TEFL (TESOL) Course

4.7(160)

By Janets

Course Overview Learn the Latest Skills | Acknowledged by CPD & QLS | Acknowledged Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training  Even while there are millions of people who aspire to start a new life abroad, the vast majority of them will never realize their ambitions. Taking a TEFL (TESOL) Course is a terrific way to get started on the path to a new life of living and working abroad if you want to be one of those people who make it happen. Through this course, you will acquire the fundamental abilities required to train as an English language teacher. This involves a critical comprehension of the grammar and structure of the English language as well as a variety of classroom management abilities and language teaching methodologies. What Will You Learn? Gain the fundamental knowledge of the principles of teaching English as a foreign language Discover a wide range of approaches and methods for teaching foreign students Develop the practical skills to deliver engaging, informative and inclusive lessons Explore the role and responsibilities of a TESOL teacher & understand the challenges teacher and students may face Receive an internationally acknowledged teacher education lesson on successful course completion Learn effective methods for teaching the four language skills: reading, writing, speaking and listening Understand the basics of classroom management to create dynamic lesson plans Get expert career guidance and understand your job opportunities & requirements for teaching roles What classes are included in this package? Earn a digital certificate upon successful completion There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you'll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? You will learn everything that is needed regarding Teaching English as a Foreign Language. This is an excellent opportunity for anyone from any academic background to learn more and advance their learning, launch a new career or reinvigorate an existing one. Career Path Training offered by the TEFL (TESOL) Course could potentially benefit a range of roles, but would particularly enhance careers in: Teacher Consultancy Life Coach Career Counsellor Other Administrative Roles Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment On successful completion of the TEFL (TESOL) Course, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for a Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately. Course Content Module 01: Introduction to English Language Teaching & Learning Module 02: Linguistics Module 03: English Pronunciation Module 04: Teaching Grammar and Vocabulary Module 05: Language Teaching Methodologies Module 06: Teaching Receptive Skills: Reading Module 07: Teaching Productive Skills: Writing Module 08: Teaching Receptive Skills: Listening Module 09: Teaching Productive Skills: Speaking Module 10: Lesson Planning and Creating Materials Module 11: Use of Games and Activities Module 12: Technology in Second Language Teaching & Learning Module 13: Classroom Management and Student Motivation Module 14: Teaching English: Situational Approach Module 15: Professional Development and Employment

TEFL (TESOL) Course
Delivered Online On Demand4 weeks
£9.99