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

59274 Courses

SQL Developer 2014 Intermediate

4.3(43)

By John Academy

Description Due to technology advancement and the increasing reliance on data, SQL developers are in high demand. Many find this path relatively easy in comparison to other technical careers. If you have completed SQL Developer 2014 beginner course and want to get more in-depth knowledge of SQL Server, then this SQL Developer 2014 Intermediate is just for you. Through this course, you will understand the structured query language (SQL) for manipulating business data in the most effective and sensible approach. Obtain the power of Microsoft SQL Server and grasp how to maximise the performance of any SQL that you draft. Take your knowledge to the next level to fully to perform the essential tasks within your business or employment to improve your prospects to succeed in the long run. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module: 01 Topic A Aggregates FREE 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 02 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 03 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 04 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 05 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 06 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 07 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 08 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 09 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

SQL Developer 2014 Intermediate
Delivered Online On Demand8 hours 29 minutes
£25

SQL Developer 2014 Advanced

4.3(43)

By John Academy

Description Take your steps towards learning the advanced concepts of SQL by taking this SQL Developer 2014 Advanced. Through the course, you will master SQL skills and be able to take full command of SQL. You will learn to create materialised views and improve performance by using simple SQL syntax. Learn about partition the tables and performance optimisation using SQL partitioning and explore how to use analytic SQL to aggregate, analyse and report, and model data using the SQL analytic capabilities. You will also learn to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure by practising SQL Hierarchical features. Use of regular expressions and sub-expressions to search, match and replace strings using SQL built-in functions also explained in this course. Step up to the next level to learn more about the advanced SQL theories which will put you better in your performance and career advancement. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module: 01 Topic A Partitioning FREE 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 02 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 03 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 04 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

SQL Developer 2014 Advanced
Delivered Online On Demand5 hours 8 minutes
£25

Spiritual Development Complete Course

4.3(43)

By John Academy

Prosper in life through Spiritual Development Who is spiritual development for? Well, the question should be, who is it not for. If you are having rage fits, unable to find happiness or depressed, want to live a peaceful and relaxed life; then this is the course for you. The spiritual development combines ideas of meditation and mantras in order to focus the mind. In this course, you will be able to sharpen your mind by learning more about spiritual development. You will be initially introduced to spiritual mantra and learn to find the correct mantras for you. Furthermore, you will learn about different breathing techniques and how to tune into your own brain. All of these will help your mind to be able to focus and change your life for the better and help people with conditions such as ADHD. Through this course you need to be able to get a deep understanding and build up of your interests, convictions, ethics, measures, values and much more in order to truly develop your spirits. So instead of delaying you should definitely get this course now, and get cracking. 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 a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Spiritual and Mental Development Introduction 00:15:00 Understanding your Mental and Physical Mind to Development of Self Spiritual 00:30:00 Spiritual Acceleration Mental Learning in Physical Self Development 00:15:00 Physical Acceleration Mental Learning in Spiritual Self Development 00:30:00 Self Development through Speed Learning in Mental Physical and Spiritual Awakenings 00:30:00 Motivation Self Development Techniques for Mental Physical and Spiritual States 01:00:00 Self Development in Improving Mental Physical and Spiritual High Court 00:30:00 Growing in Mental Physical Spiritual through Self Development 00:30:00 Relationships in Self Development of Mental Physical and Spiritual States 00:30:00 Planning your Future in Mental Physical and Spiritual Self Development 01:00:00 Benefiting from Subliminal Mental Physical and Spiritual Self Development 00:30:00 Benefiting from Mind Attitude Fleshly and Spiritual Aplomb Development 00:30:00 Innate Mental Physical and Spiritual Self Development Intimate Positive self-image in Personality Physical and Glorified Inner strength Development 01:00:00 Self Development Tactics in Mental Physical and Spiritual Subliminal Training 01:00:00 Concentrating on Self Development of Mental Physical and Spiritual Improvement 00:30:00 Suggestology in Self Development of Spiritual Mental and Physical States 00:30:00 Optimism Strengths in Self Development of Mental Spiritual and Physical States 00:15:00 Self Development of Awareness in Mental Spiritual and Physical Learning 01:00:00 Routine Self Development in Mental Spiritual and Physical Recovery 00:30:00 Viewpoints in Mental Spiritual and Physical Self Development 00:15:00 Breaking Down Mental Spiritual and Physical Self Development 00:15:00 Logic in Mental Spiritual and Physical Self Development 00:15:00 Aspects in Mental Spiritual and Physical Self Development 00:15:00 Emotions in Development Mental Spiritual and Physical Self 00:15:00 Self Development of Mental Spiritual and Physical Meditation 00:15:00 Development of Mental Untainted and Physical Self 00:15:00 Battle Common Problems in Mental Spiritual and Physical Self Development 00:30:00 Exploring the Past in Mental Spiritual and Physical Self Development 00:15:00 Reducing Stress in Mental Spiritual and Physical Self Development 01:00:00 Reviewing You in Mental Spiritual and Physical Self Development 00:15:00 Discovering Humanity in Mental Spiritual and Physical Self Development 01:00:00 Self-Headway Tactics in Mind Physical and Spiritual 00:15:00 Mental Structures in Physical and Spiritual Self Development 00:30:00 Mental Spiritual and Physical Self Development Processes 00:15:00 Unzipping the Subliminal in Mental Spiritual and Physical Self Development 00:15:00 Beneficial of Positive Mental Spiritual and Physical Self Development 00:30:00 Success in Mental Spiritual and Physical Self Development 00:15:00 Abolishing the Master of Failure in Mental Spiritual and Physical Self Development 00:15:00 Suggestions in Mental Spiritual and Physical Self Development Suggestions 00:15:00 Hypnosis in Mental Spiritual and Physical Self Development 00:15:00 Thinking Processes in Mental Spiritual and Physical Self Development 00:15:00 Mental Power in Spiritual and Physical Self Development 00:15:00 Optimising your Power to Mental Spiritual and Physical Self Development 00:30:00 Diaries of the Mind in Mental Spiritual and Physical Self Development 00:15:00 Persuading Resources in Mental Spiritual and Physical Self Development 00:15:00 Building Inner Strengths in Mental Spiritual and Physical Self Development 00:15:00 Reforming your Mental Spiritual and Physical Self through Development 00:15:00 Brain Enhancers in Mental Spiritual and Physical Self Development 00:30:00 Innate Relaxation Control to Mental Spiritual and Physical Self Development 00:15:00 Enhancing Techniques in Mental Spiritual and Physical Self Development 00:15:00 Holistic Training in Mental Spiritual and Physical Self Development 00:30:00 Commonsense Practices in Mental Spiritual and Physical Self Development 00:15:00 Conclusion 00:15:00 Spiritual Mantras Spiritual Mantra Basics 00:30:00 Find The Correct Mantra For What You Are Trying To Achieve 00:30:00 Learn To Breathe Correctly While Reciting 00:30:00 How To Tune Your Own Brain 00:15:00 Allow Your Thoughts To Come And Go 01:00:00 Use Mantras To Focus Your Mind And Change Your Life 00:30:00 Wrapping Up 00:15:00 Mock Exam Mock Exam- Spiritual Development Complete Course 00:30:00 Final Exam Final Exam- Spiritual Development Complete Course 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Spiritual Development Complete Course
Delivered Online On Demand27 hours
£25

Sociology Diploma Level 3

4.3(43)

By John Academy

Description: Sociology is the study of society and the social world. The Sociology Diploma Level 3 is designed for people who wish to gain an understanding of principles and practice of Sociology. Through the course you will get a key skills and knowledge related to families and households, from a traditional perspective, to a more contemporary approach, religion, mass media influences and more. You will receive a great insight into this field of study with the use of practical examples throughout the course.  On completion this Sociology Diploma Level 3 you will be able to understand the origins of sociology, what methods of enquiry are employed and describe some of the general sociological theories that have been established over the years, demonstrate your understanding of the socialisation process, describe the social institutions that exist in society and explain their role in maintaining the stability of society, and more. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Sociology Diploma Level 3 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Sociology Diploma Level 3 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Sociology Diploma Level 3 Introduction to Sociology 00:05:00 History of sociology and some major theories 00:30:00 Theoretical Perspectives 00:15:00 Sociological Perspectives on Family and Marriage 00:30:00 Mass Media 00:15:00 Crime in Sociology 00:05:00 Theories of Deviance 00:15:00 Social Inequality and Stratification 00:15:00 Sociological Perspectives on Health and Illness 00:15:00 Sociological Theories of Religion 00:15:00 Culture in Sociology 00:15:00 Pop Culture, Subculture and Cultural Globalization 00:15:00 Subculture Theory 00:15:00 Gender, Sex and Sexuality 00:30:00 Sociological perspectives on Gender and Sexuality 00:30:00 Research Methods 00:30:00 Mock Exam Mock Exam - Sociology Diploma Level 3 00:20:00 Final Exam Final Exam - Sociology Diploma Level 3 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Sociology Diploma Level 3
Delivered Online On Demand5 hours 35 minutes
£25

Secretarial, PA & Office Administration Diploma

4.3(43)

By John Academy

Description: The Secretarial, PA & Office Administration Diploma course is designed for the people who want to exceed their role as a secretary, PA or office administrator. The responsibilities of a secretary, PA or office administrator require several skills. Throughout the course, you will explore all the essential skills for becoming an efficient secretary or PA. Focuses will be given on how to take notes, using right tools, negotiation skill, communication skill, soft skills, time & meeting management, and more. Fundamental lessons regarding how to use Microsoft Office, Excel, Access and Powerpoint will also be presented to you. Who is the course for? This course is ideal for those wanting to improve their base skills in office administrative tasks This course would be ideal people who want to start working as a receptionist, office administrator, office manager, administration assistant or secretary Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally 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: Secretarial, PA & Office Administration Diploma is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Administrator support staff Administrative assistant Office managers Receptionist Office administrator Secretarial Interpersonal Skills Module One - Getting Started 00:30:00 Module Two - Verbal Communication Skills 01:00:00 Module Three - Non-Verbal Communication Skills 01:00:00 Module Four - Making Small Talk and Moving Beyond 01:00:00 Module Five - Moving the Conversation Along 00:30:00 Module Six - Remembering Names 01:00:00 Module Seven - Influencing Skills 01:00:00 Module Eight - Bringing People to Your Side 01:00:00 Module Nine - Sharing Your Opinion 01:00:00 Module Ten - Negotiation Basics 01:00:00 Module Eleven - Making an Impact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Developing Interpersonal Skills Course- Activities 00:00:00 Personal Assistant Module One - Getting Started 00:30:00 Module Two - Working with Your Manager 01:00:00 Module Three - Administrative Soft Skills 01:00:00 Module Four - Effective Time Management 01:00:00 Module Five - Meeting Management 01:00:00 Module Six - Tools of the Trade (I) 01:00:00 Module Seven - Tools of the Trade (II) 01:00:00 Module Eight - Being an Effective Gatekeeper 01:00:00 Module Nine - Organizational Skills 01:00:00 Module Ten - Confidentiality Guidelines 01:00:00 Module Eleven - Special Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Business Writing Module One - Getting Started 00:30:00 Module Two - Working with Words 01:00:00 Module Three - Constructing Sentences 01:00:00 Module Four - Creating Paragraphs 01:00:00 Module Five - Writing Meeting Agendas 01:00:00 Module Six - Writing E-mails 01:00:00 Module Seven - Writing Business Letters 01:00:00 Module Eight - Writing Proposals 01:00:00 Module Nine - Writing Reports 01:00:00 Module Ten - Other Types of Documents 01:00:00 Module Eleven - Proofreading and Finishing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Self Esteem & Confidence Building Module One - Getting Started 01:00:00 Module Two - What Does Self-Confidence Mean To You 01:00:00 Module Three - Obstacles to Our Goals 01:00:00 Module Four - Communication Skills 01:00:00 Module Five - The Importance of Goal Setting 01:00:00 Module Six - Feeling the Part 01:00:00 Module Seven - Looking the Part 01:00:00 Module Eight - Sounding the Part 01:00:00 Module Nine - Powerful Presentations 00:30:00 Module Ten - Coping Techniques 01:00:00 Module Eleven - Dealing with Difficult Behavior 00:30:00 Module Twelve - Wrapping Up 00:15:00 Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Module One - Getting Started 00:30:00 Module Two - Remove the Clutter 01:00:00 Module Three - Prioritize 01:00:00 Module Four - Scheduling Your Time 01:00:00 Module Five - To Do Lists 01:00:00 Module Six - Paper and Paperless Storage 01:00:00 Module Seven - Organization in Your Work Area 01:00:00 Module Eight - Tools to Fight Procrastination 01:00:00 Module Nine - Organizing Your Inbox 01:00:00 Module Ten - Avoid the Causes of Disorganization 01:00:00 Module Eleven - Discipline is the Key to Stay Organized 01:00:00 Module Twelve - Wrapping Up 00:30:00 Office Management Building Your Management Team 01:00:00 Building A Successful Brand 01:00:00 Achieving Quality Through Teamwork 00:30:00 Keys To Staying Motivated 00:30:00 Improve Your Marketing 01:00:00 Provide Top Customer Service 00:30:00 Wrapping Up 00:30:00 Bookkeeping & Payroll Module One - Introduction 00:30:00 Module Two - Basic Terminology 01:00:00 Module Three - Basic Terminology (II) 01:00:00 Module Four - Accounting Methods 01:00:00 Module Five - Keeping Track of Your Business 01:00:00 Module Six - Understanding the Balance Sheet 01:00:00 Module Seven - Other Financial Statements 01:00:00 Module Eight - Payroll Accounting Terminology 01:00:00 Module Nine - End of Period Procedures 01:00:00 Module Ten - Financial Planning, Budgeting and Control 01:00:00 Module Eleven - Auditing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 PowerPoint Essential Activities 00:00:00 Microsoft Excel Module One - Getting Started 00:30:00 Module Two - Opening Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Excel for Newbies - Activities 00:00:00 Mock Exam Mock Exam- Secretarial, PA & Office Administration Diploma 00:30:00 Final Exam Final Exam- Secretarial, PA & Office Administration Diploma 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Secretarial, PA & Office Administration Diploma
Delivered Online On Demand5 days
£25

Save Lives with Alternative Medicine & Treatments

4.3(43)

By John Academy

Description:  This course is for everyone, be they medical students, family doctors, nurses, physicians and people who are keen to learn the alternative medicine and treatments. This course will provide reliable information for various subjects and present cases to outline the important learning for safe and efficient practice with regards to alternative medicine and treatments. There are video materials you will have access in this course. In this course you will learn the necessary skills, knowledge and information of alternative medicine & treatments.  Who is the course for? This course would be ideal for individuals who have a general interest in the medical field. 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 a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Save Lives with Alternative Medicine and Treatments course would be beneficial for the following professionals: Medical Student Consultant Emergency Medicine Speciality Doctor in Emergency Medicine Locum Doctor in Emergency Medicine General Practitioner. Module 1: Holistic & Alternative Medicine General Holistic Health Tips 01:00:00 Vitamins and Herbs 01:00:00 Natural Food Choices 01:00:00 Skin Remedies 01:00:00 Module 2: Natural Cures for Common Diseases What Is Nature Cure? 00:30:00 Catechism of Nature Cure 00:15:00 What Is Life? 01:00:00 The Unity of Disease and Treatment 01:00:00 The Unity of Acute Diseases 01:00:00 The Laws of Cure 01:00:00 Suppression Versus Elimination 01:00:00 Inflammation 01:00:00 The Effects of Suppression of Venereal Diseases 01:00:00 Suppressive Surgical Treatment of Tonsillitis and Enlarged Adenoids 00:30:00 Cancer 00:30:00 Women's Suffering 01:00:00 The Treatment of Acute Diseases by Natural Methods 01:00:00 The True Scope of Medicine 01:00:00 Homeopathy 01:00:00 The Diphtheria Antitoxin 01:00:00 Vaccination 01:00:00 Surgery 01:00:00 Chronic Diseases 00:30:00 Crises 00:30:00 Periodicity 01:00:00 What About The 'Chronic'? It Takes So Long 01:00:00 The Treatment of Chronic Diseases 01:00:00 Vitality 01:00:00 Natural Dietetics 01:00:00 Acid Diseases 00:30:00 Fasting 00:30:00 Hydrotherapy Treatment of Chronic Disease 01:00:00 Air and Light Baths 00:30:00 Correct Breathing 00:30:00 Physical Exercise 01:00:00 Manipulative Treatment Massage 00:30:00 Legitimate Scope and Natural Limitations of Mental and Metaphysical Healing 00:30:00 The Difference Between Functional and Organic Disease 01:00:00 The Two-fold Attitude of Mind and Soul 01:00:00 The Symphony of Life 00:30:00 The Three-fold Constitution of Man 01:00:00 Mental Therapeutics 01:00:00 How Shall We Pray? 00:15:00 Scientific Relaxation and Normal Suggestion 01:00:00 Conclusion 00:15:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Save Lives with Alternative Medicine & Treatments
Delivered Online On Demand36 hours
£25

Fleet Management Diploma

4.3(43)

By John Academy

Description: Every company that manufactures products or supplies manufacturers requires the services of a fleet manager. This means that people in this industry are sought after for their ability to manage the practical demands of vehicle selection and management, procurement and maintenance, this Diploma is ideal answer to the demand. The Fleet Management Diploma aims to provide you with an analysis of the motor industry, as well as an in-depth understanding of Vehicle Selection and Procurement, Maintenance Management and relevant systems. Understand the concepts of Fleet Management as a discipline and related applicable scientific principles. Formulate a Fleet Policy and have a full view of critical policy issues that have to be included in that fleet policy. Learn about the fleet life cycle and how intertwined and interdependent the life cycle stages are on one another. Drive your career forward with this course and take your success to the next level. Assessment and Certification: This course does not involve any assessment. Students can order their course completion Certificate at an additional cost of £39 for hard copy and in PDF format at £24. Who is this Course for? Fleet Management Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Fleet Management Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module: 01 Introduction to Fleet Management 00:15:00 Purpose of Fleet Management 00:20:00 Role of Fleet Manager 00:20:00 Motor Industry Market 00:30:00 Fleet Management System 00:30:00 Fleet Lifecycle 00:30:00 Fleet Management Solutions 00:30:00 Fleet Management Implementation 00:20:00 Module: 02 Fleet Analysis 00:30:00 Architecture of Fleet Management Systems 00:30:00 Central System 00:30:00 Map Display 00:20:00 Vehicle Selection and Management 00:30:00 Vehicle Maintenance 00:30:00 Fleet Risk Management 00:15:00 Health, Safety & Security. 00:15:00 Critical issues in FM 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Fleet Management Diploma
Delivered Online On Demand6 hours 55 minutes
£25

Financial Management and Business Accounting Diploma

4.3(43)

By John Academy

Description: Build the financial and accounting skillset needed to rise to an executive level of responsibility and earning power. Financial management is an essential part of any successful business. The Financial Management and Business Accounting Diploma focuses on specialist modules including financial accounting, management accounting, business finance, financial management, strategic management accounting and international financial reporting. If you are looking forward to advancing your career and move toward an organizational leadership position, this Financial Management and Business Accounting Diploma will help you build the skills you'll need to make high-level decisions that impact your organization's current operations and financial future. The course will equip you with the potential to become a senior manager, administrator or executive in business management, accounting and finance, in commercial and public organisations. This course will teach the framework of managing business finances. It can also be the first step to qualification as an accountant. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Financial Management and Business Accounting Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Financial Management and Business Accounting Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Personal Finance Calculations Personal Finance Introduction FREE 00:01:00 Calculating Your Net Worth 00:01:00 Calculating Your Real Hourly Wage 00:02:00 Expenses for Life Energy 00:02:00 Calculating a Monthly Budgeting 00:05:00 Saving for Retirement Paying Off Debt 00:02:00 Build an Emergency Fund 00:02:00 Personal Savings 00:04:00 401K Basics 00:03:00 Asset Allocation 00:04:00 Investment Strategies 00:02:00 Advice on Financial Advisors 00:01:00 3h- Questions About Investing 00:15:00 Building Credit to Buy a Home FICO Score 00:09:00 Starting Credit 00:03:00 Increasing Credit Score 00:02:00 Owning vs. Renting 00:02:00 Types of Mortages 00:03:00 Personal Finance Guides for Beginners Advice to Teenagers 00:04:00 Guide to Buying a Car 00:05:00 Professional Bookkeeper Introduction Professional Bookkeeper FREE 00:09:00 Introduction to Accounting and Business Defining a Business 00:07:00 Ethics in Accounting 00:05:00 Generally Accepted Accounting Principles (GAAP) 00:10:00 The Accounting Equation The Accounting Equation 00:07:00 Transactions 00:11:00 Financial Statements 00:13:00 Analyzing Transactions The Accounting Equation and Transactions 00:16:00 Double-Entry System 00:11:00 Transactions - Journalizing 00:17:00 Journal Entries 00:38:00 Entering Information - Posting Entries Posting Entries 00:10:00 The Trial Balance 00:10:00 Finding Errors Using Horizontal Analysis 00:09:00 Horizontal Trend : Balance Sheet 00:21:00 Horizontal Trend: Income Statement 00:36:00 Adjusting Process The Purpose of the Adjusting Process 00:15:00 Adjusting Entries Adjusting Entries - Prepaid Expenses 00:13:00 Adjusting Entries - Accrued Revenues 00:10:00 Adjusting Entries - Depreciation Expense 00:09:00 Adjustment Summary Adjustment Summary - Review 00:13:00 Vertical Analysis 00:33:00 Preparing a Worksheet Preparing a Worksheet 00:06:00 Financial Statements The Income Statement 00:11:00 Financial Statements - Definitions 00:12:00 Completing the Accounting Cycle Temporary vs. Permanent Accounts 00:19:00 The Accounting Cycle Illustrated Accounting Cycle Illustrated - Steps 1-5 00:11:00 Accounting Cycle Illustrated - Steps 6-10 00:12:00 Fiscal Year Fiscal Year 00:09:00 Spreadsheet Exercise Spreadsheet Exercise - Steps 1-4 00:11:00 Spreadsheet Exercise - Steps 5-7 00:37:00 Assessment Assignment - Financial Management and Business Accounting Diploma 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Financial Management and Business Accounting Diploma
Delivered Online On Demand8 hours 43 minutes
£25

Finance and Financial Analysis Diploma Level 3

4.3(43)

By John Academy

[vc_row][vc_column][vc_column_text] Description: Financial literacy is crucial in today's business world. Financial analysis is about analysing the past to understand the present and foresee the future of a company. Want to become an accountant or research analyst? This Finance and Financial Analysis Diploma Level 3 Course is designed to teach you the practical skills and knowledge to help you to fast-track a career in corporate finance.  In this financial analyst course, you'll learn career-enhancing financial market knowledge and will acquire a strong foundation in real-world investment analysis and portfolio management skills. You will also learn essential accounting and finance concepts and methods of financial analysis. Throughout this course, you will familiarise with calculations to help you to perform managerial responsibilities more effectively.  On course completion, you will be able to evaluate business operations involving basic arithmetic and fundamental formulas. You will also be able to interpret and evaluate financial statements to measure financial performance. You will then be able to apply concepts and methods of economic analysis to manage day-to-day business operations. Budgeting, balance sheets, financial reporting, fixed incomes, financial models and investment banking will also be discussed in this course. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Finance and Financial Analysis Diploma Level 3 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Finance and Financial Analysis Diploma Level 3 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.[/vc_column_text][/vc_column][/vc_row] Personal Finance Calculations Calculating Your Net Worth 00:01:00 Calculating Your Real Hourly Wage 00:02:00 Expenses for Life Energy 00:02:00 Calculating a Monthly Budgeting 00:05:00 Saving for Retirement Paying Off Debt 00:02:00 Build an Emergency Fund 00:02:00 Personal Savings 00:04:00 401K Basics 00:03:00 Asset Allocation 00:04:00 Investment Strategies 00:02:00 Advice on Financial Advisors 00:01:00 3h- Questions About Investing 00:15:00 Building Credit to Buy a Home FICO Score 00:09:00 Starting Credit 00:03:00 Increasing Credit Score 00:02:00 Owning vs. Renting 00:02:00 Types of Mortages 00:03:00 Personal Finance Guides for Beginners Advice to Teenagers 00:04:00 Guide to Buying a Car 00:05:00 Cashflow Management Forecasting 00:07:00 What is Cashflow? 00:05:00 Planning and Management 00:08:00 Planning Part 2 00:12:00 Where it can go Wrong 00:09:00 Personal Cashflow Analysis 00:05:00 Personal Cashflow Analysis my Numbers Story 00:06:00 Debt 00:10:00 Budgets and Money Management Finance Jeopardy 00:15:00 The Fundamentals of Finance 00:15:00 The Basics of Budgeting 00:15:00 Parts of a Budget 00:15:00 The Budgeting Process 00:30:00 Budgeting Tips and Tricks 00:15:00 Monitoring and Managing Budgets 00:15:00 Crunching the Numbers 00:15:00 Getting Your Budget Approved 00:15:00 Comparing Investment Opportunities 00:15:00 ISO 9001:2008 00:15:00 Directing the Peerless Data Corporation 00:30:00 Assessment Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Finance and Financial Analysis Diploma Level 3
Delivered Online On Demand5 hours 43 minutes
£25

Family Support Worker Course

4.3(43)

By John Academy

Description: Family support workers are social services professionals who provide assistance and guidance to children and families in need. They work in settings such as foster care or adoption agencies, child protective services agencies or family services organizations. The Family Support Worker Course aims to provide great insight into the skills and knowledge related to working with children and families. This course will discuss the key skills and knowledge related to working with families, identifying and resolving family difficulties, safeguarding in the home and more. This course will provide a great insight into this field of study with the use of practical examples throughout the course. Whether working in this field already, you want to get started working in within the field of family support work, or just interested in this field of study, this course will cover a range of modules and provide multiple examples for assessment. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Family Support Worker Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Family Support Worker Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 1 - The role of family support worker The functions, work environment, and daily activities of a family support worker 00:15:00 The key responsibilities of a family support worker and different specialisations 00:15:00 The key qualities of a family support worker and what a family support worker should expect 00:15:00 Duties as a family support worker 00:15:00 Professional development, career prospects, and anticipated salary as a family support worker 00:05:00 A day in the life of a family support worker 00:15:00 Pros and cons of being a family support worker 00:05:00 Work-life balance as a family support worker 00:15:00 Top tips for family support workers 00:05:00 Module 2 - Legislation, policy, and guidance Introduction to legislation, policy, and guidance 00:05:00 Overview of legislation - England 00:15:00 The Children and Families Act 2014 00:30:00 Policy and guidance - England 00:15:00 Overview of legislation - Scotland 00:05:00 Policy and guidance - Scotland 00:15:00 Overview of legislation - Northern Ireland 00:05:00 Policy and guidance - Northern Ireland 00:05:00 Overview of legislation - Wales 00:05:00 Policy and guidance - Wales 00:05:00 Module 3 - The family issues and solving them Parental mental health - how to help children living with parents with mental health problems 00:15:00 Parental mental health - assessing the risk of mental health problems 00:05:00 Parental mental health - intervention and support for children and families 00:15:00 Parental substance misuse - how to help children living with parents who misuse alcohol and drugs 00:05:00 Parental substance misuse - assessing the risk of parental alcohol and drug misuse 00:05:00 Parental substance misuse - intervention and support for children and families 00:05:00 Domestic abuse - what is domestic abuse? 00:05:00 Separation, divorce, and parental responsibility 00:05:00 Separation, divorce, and contact 00:05:00 General advice on talking about difficult topics 00:15:00 Books to help talking about difficult topics 00:15:00 Module 4 - Safeguarding - assessing need and providing help Introduction to safeguarding - a child-centred, coordinated approach 00:30:00 Early help 00:30:00 Access, referral, and information sharing 00:30:00 Disabled children, carers, youth establishments, and contextual safeguarding 00:15:00 Assessment purpose, protocols, principles, and parameters 00:15:00 Analysis, outcomes, and timeliness 00:30:00 Processes for managing individual Part 1 00:30:00 Processes for managing individual Part 2 00:15:00 Processes for managing individual Part 3 00:15:00 Module 5 - Building relationships Types of family and what makes healthy families 00:15:00 Why relationships are key to good social work 00:30:00 The importance of relationships in social work to relationships in social work 00:30:00 The personal qualities required for relationship building 00:15:00 Working on empathy to build relationships 00:15:00 The professional attributes required for relationship building 00:15:00 Self-knowledge and professional use of self in relationship building 00:15:00 Taking an individualised approach, involving the parents, what parents want from the relationship, sharing information, and building trust 00:30:00 Challenges in relationship building 00:15:00 The difference between getting the relationship right and getting it wrongb 00:30:00 Mock Exam Mock Exam- Family Support Worker Course 00:30:00 Final Exam Final Exam- Family Support Worker Course 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Family Support Worker Course
Delivered Online On Demand13 hours 5 minutes
£25