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

4055 Courses delivered Online

Diploma in Body Language and Self-Esteem

4.3(43)

By John Academy

Description: This diploma in Body Language and Self-Esteem is an exclusive course that will show you how to read people's emotions and opinions before they even say a word, and to build your emotional intelligence. You will also learn how to judge your own body language, discover your appearance and learn to improve your body language to project a confident, interesting you. A dull posture can demonstrate a lack of confidence or boredom. Negative body language is either a conscious or an unconscious expression of negative feelings through movements of the body. Being skilled at noticing body language can assist one with personal or professional relationships and knowing when another is dissatisfied or unhappy. Who is the course for? Professionals who need to learn how to interpret body gestures and movements effectively People who are interested in learning more about the body language and how to utilize it 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. Introduction to Body Language What Is Body Language 00:15:00 How to Read Body Language 00:30:00 How to Read People's Minds 00:30:00 How To Understand Eyes Contact 00:15:00 The Role of Head and Face in Body Language 00:30:00 The Role of Neck, Chest and Back in Body Language 00:15:00 The Role of Hands and Arms in Body Language 00:30:00 The Role of Legs in Body Language 00:15:00 The Role of the Lips in Body Language 00:15:00 Tips to Improve Body Language 00:15:00 Wrapping Up 00:15:00 Body Language Secrets Introduction 00:15:00 Aggressive Body Language 00:15:00 Attentive Body Language 00:15:00 Closed Body Language 00:30:00 Deceptive Body Language 00:30:00 Defensive Body Language 00:15:00 Dominant Body Language 00:15:00 Emotional Body Language 00:30:00 Evaluating Body Language 00:15:00 Greeting Body Language 00:30:00 Open Body Language 00:15:00 Relaxed Body Language 00:15:00 Power Body Language 00:15:00 Ready Body Language 00:15:00 Romantic Body Language 00:15:00 Submissive Body Language 00:15:00 Conclusion 00:15:00 Mastering Your Body Language Introduction To Body Language 00:15:00 Understand The Positive And Negative Positions 00:15:00 Observe How People React To Certain Body Language 00:15:00 Set A Goal For The Image You Wish To Project 00:15:00 Practice Scenarios In The Mirror 00:15:00 Train Your Body To React Positively 00:30:00 Learn How To Take Down Someone's Wall with Positive Body Positions 00:30:00 Understand The Importance Of Symmetry 00:15:00 Understand The Importance Of Matching The Other Person 00:15:00 What You Can Get Into With The Incorrect Body Language 00:15:00 Communicating Effectively Module One - Getting Started 00:30:00 Module Two - Communicating with Body Language 01:00:00 Module Three - Reading Body Language 01:00:00 Module Four - Body Language Mistakes 00:30:00 Module Five - Gender Differences 00:30:00 Module Six - Nonverbal Communication 01:00:00 Module Seven - Facial Expressions 02:00:00 Module Eight - Body Language in Business 01:00:00 Module Nine - Lying and Body Language 01:00:00 Module Ten - Improve Your Body Language 01:00:00 Module Eleven - Matching Your Words to Your Movement 01:00:00 Module Twelve - Wrapping Up 00:30:00 Effective Communication: Body Language- Activities 00:00:00 Body Language and Sales Body Language 00:25:00 Give Me Some Space! 00:15:00 What's Your Face Saying? 00:30:00 What's Your Body Saying? 00:30:00 Mirroring and Leading 00:30:00 Monitoring Your Posture 00:15:00 Dressing Up 00:15:00 Shaking Hands 00:30:00 Self Esteem and Assertiveness Skills Course Module One - Getting Started 01:00:00 Module Two - What Does Self-Confidence Mean To You? 55 00:30: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 Mock Exam Mock Exam - Diploma in Body Language and Self-Esteem 00:20:00 Final Exam Final Exam - Diploma in Body Language and Self-Esteem 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Body Language and Self-Esteem
Delivered Online On Demand36 hours
£25

Diploma in Art and Painting

4.3(43)

By John Academy

Description: Painting is a medium of expression since a lot of artists use it to express their feelings or other significant events in their life. If you would like to express yourself and bring out your hidden artistic and creativity skills, consider getting this Diploma in Art and Painting. This Diploma in Art and Painting is designed for developing you basic knowledge and skills in art and painting. The course is divided into five modules and will help you focus on several different topics. You will get knowledge in canvas painting like understanding paints and how to choose brushes to use for your art. You will also be able to become a professional painter by learning to incorporate your painting skills and use this to offer your services as a business to those who need it. Lastly you will also learn about pencil art and the basics of drawing and sketching. There is a lot more covered within the course and if you are truly dedicated in succeeding as an artist you should consider getting this course now. Who is the course for? Artists or painters who want home paintings as a business. People who have an interest in professional painting Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at 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: Diploma in Art and Painting is a useful qualification to possess, and would be beneficial for the following careers: Visual Artists Portrait Specialist Sketch Artists Logo Designers Updated Version-Diploma in Art and Painting Introduction Introduction to Drawing and Painting 00:03:00 Materials 00:08:00 Perspective What is a Horizone Line 00:11:00 One Point Perspective of a Cube 00:10:00 Two Point Perspective of a Cube 00:12:00 Perspective of a Cylinder 00:17:00 How to draw a Perfect Sphere 00:09:00 Shading Shading a Sphere 00:22:00 Shading a Cylinder 00:18:00 Shading a Cube 00:13:00 Measuring How to Measure 00:07:00 Still Life Drawing Compostion and placement 00:09:00 Finding the perspective and drawing the box 00:18:00 Constructing the Cup 00:22:00 Drawing the Drapes 00:05:00 Shading - Part 1 00:14:00 Shading - Part 2 00:19:00 Shading - Part 3 00:22:00 Drawing a Portrait Drawing a Face - Part 1. Construction 00:21:00 Drawing a Face - Part 2. Refining the features 00:10:00 Drawing a Face - Part 3. Shading 00:18:00 Drawing a Face - Part 4. Final touches 00:12:00 Drawing a Tree Drawing a Tree 00:16:00 Order Your Certificate Order Your Certificates and Transcripts 00:00:00 Old Version-Diploma in Art and Painting Module-1 Painting 101 00:30:00 Understanding Paints 00:30:00 Choosing Your Brushes 00:30:00 Color Your World 00:30:00 Light Sources in Painting 00:30:00 What type of painter are you? 00:30:00 Module-2 Choosing A Subject 01:00:00 Setting Up Your Studio 00:30:00 Art Supply Resources 01:00:00 Clean Up Time 00:30:00 Free Art Lessons 01:00:00 Take Care of Your Creation 00:15:00 Module-3 Pay Attention to Detail 01:00:00 Enjoy Your Subject 01:00:00 Frequently Asked Questions 00:30:00 Art Schools 00:30:00 Museums of Fine Art 00:15:00 One Final Word 01:00:00 Module-4 INTRODUCTION 01:00:00 BRIEF HISTORY OF PENCIL DRAWING 00:15:00 GETTING STARTED 01:00:00 LEARNING THE BASICS OF DRAWING AND SKETCHING 01:00:00 Basic Perspectives on Drawing 01:00:00 Basic Elements of Light, Shadows, and Shading 01:00:00 Different Shading Techniques 00:15:00 How to Add Tones and Values? 00:30:00 FINISHING TOUCHES 00:30:00 MIXED MEDIA APPLICATIONS 01:00:00 Drawing with Pencils in Oil Painting 01:00:00 CONCLUSION 00:15:00 Module-5 Start Your Own Art Business 00:15:00 Steps to Creating a Successful Business from Your Art 01:00:00 How to Write an Artist Business Plan 00:30:00 Module-6 Introduction 00:30:00 Incorporate Your Business 01:00:00 Employing Or Contracting - What Is The Difference? 00:30:00 From Where Can You Hire Workers 01:00:00 Getting Insurance 01:00:00 Getting Ready - Portfolios, Flyers And Cards 00:30:00 What Do You Need For Outdoor Painting 01:00:00 What Do You Need To Know About Indoor Painting 01:00:00 Fancy Indoor Painting Touches - How To Get Them 00:30:00 Paint Primer 101 01:00:00 How To Get Customers 01:00:00 The Non-Paying Customers! 00:30:00 Mock Exam Mock Exam- Diploma in Art and Painting 00:20:00 Final Exam Final Exam- Diploma in Art and Painting 00:20:00

Diploma in Art and Painting
Delivered Online On Demand37 hours
£25

Python Basic to Advanced for Data Science Online Course

4.3(43)

By John Academy

[vc_row][vc_column][vc_column_text] Description: This Python Basic to Advanced for Data Science Online Course is a great way to get started in programming. It covers the study of the Python language used to build most of the world's object-oriented systems. The course is for interested students with a good level of computer literacy who wish to acquire programming skills. It is also ideal for those who wish to move to a developer role or areas such as software engineering. This is a great course to develop your coding skills. This Python Basic to Advanced for Data Science Online Course is an ideal preliminary to the Object-Oriented Programming using Python. Join the course now! 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. Certification: After completing 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; 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.[/vc_column_text][/vc_column][/vc_row] Python 3 Beginners Module 01 Introduction FREE 00:29:00 Starter Examples 00:33:00 Learning C Concepts 00:13:00 Module 02 Data Types and Inference 00:20:00 Sizeof and IEEE 754 00:33:00 Constants L and R Values 00:11:00 Operators and Precedence 00:25:00 Literals 00:26:00 Module 03 Classes and Structs FREE 00:22:00 Enums 00:14:00 Unions 00:16:00 Introduction to Pointers 00:11:00 Pointers and Array Indexing 00:12:00 Using Const with Pointers 00:09:00 Pointers to String Literals 00:12:00 References 00:14:00 Smart Pointers 00:22:00 Arrays 00:15:00 Standard Library Strings 00:13:00 More Standard Library Strings 00:18:00 Functions 00:06:00 More Functions 00:16:00 Function Pointers 00:15:00 Control Statements 00:18:00 Python 3 Intermediate Module 04 Installing Python FREE 00:17:00 Documentation 00:30:00 Command Line 00:17:00 Variables 00:29:00 Simple Python Syntax 00:15:00 Keywords 00:18:00 Import Module 00:17:00 Additional Topics 00:23:00 Module 05 If Elif Else 00:31:00 Iterable 00:10:00 For 00:11:00 Loops 00:20:00 Execute 00:05:00 Exceptions 00:18:00 Data Types 00:24:00 Module 06 Number Types 00:28:00 More Number Types 00:13:00 Strings 00:20:00 More Strings 00:11:00 Files 00:08:00 Lists 00:15:00 Dictionaries 00:04:00 Tuples 00:07:00 Sets 00:09:00 Module 07 Comprehensions 00:10:00 Definitions 00:02:00 Functions 00:06:00 Default Arguments 00:06:00 Doc Strings 00:06:00 Variadic Functions 00:07:00 Factorial 00:07:00 Function Objects 00:07:00 Module 08 Lambda 00:11:00 Generators 00:06:00 Closures 00:10:00 Classes 00:09:00 Object Initialization 00:05:00 Class Static Members 00:07:00 Classic Inheritance 00:10:00 Data Hiding 00:07:00 Python 3 Advanced Iterators and Generators FREE 00:16:00 Regular Expressions 00:19:00 Introspection and Lambda Functions 00:27:00 Metaclasses and Decorators 00:24:00 Modules and Packages 00:25:00 Working with APIs 00:15:00 Metaprogramming Primer 00:19:00 Decorators and Monkey Patching 00:21:00 XML and JSON Structure 00:10:00 Generating XML and JSON 00:17:00 Parsing XML and JSON 00:19:00 Implementing Algorithms 00:19:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Python Basic to Advanced for Data Science Online Course
Delivered Online On Demand19 hours 30 minutes
£12

Advanced Diploma in Health & Fitness

4.3(43)

By John Academy

Description: The Advanced Diploma in Health Fitness will help people in looking for nutritious guidance on staying healthy to help in upgrading well-being and wellness. Health Fitness is not just about weight loss, its main objective is to live healthily without sacrificing happiness in the duration of the course. You will be able to know the definition of what healthy is and how you can improve the status of your health in this course. You will be able to take the strategies, complemented by activity based worksheets and reasonable contextual analyses to be able to understand more about health and fitness. Lastly, you will be able to mind fitness and live a healthy emotional life. Who is the course for? Trainers, professionals and other busy people who are into health and fitness. Health conscious people who want to strengthen their bodies and maintain their wellness. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at 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 Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Advanced Diploma in Health Fitness will be very beneficial and helpful, especially to health and sport-related careers like: Athletes Fitness Instructor Personal Trainer Sports Administrator Sports Businessmen Sports Specialists Wellness Coach And Much More! Health and Fitness Introduction 00:30:00 Fitness And Where You Stand Right Now 01:00:00 Body Fitness And Its Effect On Your Life 00:30:00 Diet Fitness, You Are What You Eat, Really! 00:45:00 Mind Fitness, A Healthy Emotional Life 00:45:00 Lifestyle Fitness, You Are What You Do, Too 00:45:00 Conclusion 00:15:00 Fitness and Wellness Today's Concerns about Wellness and Fitness 01:00:00 The Blissful Union of Wellness and Fitness 00:30:00 The Interchangeability of Wellness, Fitness and Health 00:30:00 The Quality of Life: Is Health Important? 00:30:00 Wellness Terminology 00:30:00 What Makes Us Well? 00:30:00 Wellness 00:30:00 Information on Wellness 00:30:00 How Do We Evaluate Wellness? 00:30:00 What Are Your Wellness Needs? 00:30:00 Wellness of the Body 00:30:00 Wellness of the Spirit 00:30:00 Wellness of the Mind 00:30:00 Benefits of Meditation for the Wellness of Ourselves 00:30:00 Do We Need Meditation? 00:30:00 Are You Well? 00:30:00 Fitness Terminology 00:15:00 Fitness 00:30:00 Information on Fitness 00:30:00 What Are Your Fitness Needs? 00:30:00 Benefits from Being Fit 01:00:00 Metabolism: What Is It? 00:30:00 Metabolism for the Fit Individual 00:30:00 Metabolism: Can We Control It? 00:30:00 Obesity in Adolescents 00:30:00 Fitness of the Body 00:30:00 Fitness of the Spirit 00:30:00 Fitness of the Mind 00:30:00 Are You Fit? 00:30:00 Where You Live Affects Your Fitness 00:30:00 Fitness Centers: An Investigation 00:30:00 Does Your Income Affect Your Health? 00:30:00 What Role Does Our Intelligence Play in Our Health? 00:30:00 What Role Does Nutrition Play in Our Health? 00:30:00 Is There Health Without Water? 00:30:00 Vitamins: To Be or Not To Be? 00:30:00 How the Brain Affects Our Health 00:30:00 What Are Your Nutritional Needs? 00:30:00 Exercise and Play: What Do We Learn? 00:30:00 The Benefits of Walking 00:30:00 The Mind, Body and Soul Interconnectivity 00:30:00 Chiropractic Care: A Benefit to the Well Individual? 00:30:00 Acupuncture: A Benefit to the Well Individual? 00:30:00 The Benefits of Being Well 00:30:00 Where You Live Affects Your Wellness 00:30:00 The Benefits of Being Fit 00:30:00 Music: Our Connection to the Higher Conscious 00:30:00 The Yin and Yang of the Healthy Individual 00:30:00 Right Hand vs. Left Hand: Who's Healthier? 00:30:00 Is Your Mind Playing Tricks? 00:30:00 Diet and Nutrition Low Carb (No Carb) Diets 01:00:00 Women's Health Look Good Naked Diet 00:30:00 Prevention System's Flat Belly Diet 00:30:00 Weight Watchers International's Pro Points 01:00:00 Mike Geary's Truth about Abs Diet 00:30:00 HCG Diet 00:30:00 Diet Supplements and Weight Loss 00:30:00 Diets that Provide Food Supplements 00:30:00 Mock Exam Mock Exam- Advanced Diploma in Health & Fitness 00:20:00 Final Exam Final Exam- Advanced Diploma in Health & Fitness 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Diploma in Health & Fitness
Delivered Online On Demand35 hours
£21

Listening Masterclass

5.0(2)

By Institute of Beauty & Makeup

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Listening Masterclass
Delivered Online On Demand1 hour
£12

SQL Masterclass: SQL for Data Analytic

4.3(43)

By John Academy

Description Nowadays, SQL Developers are in-demand and becoming a SQL developer can be a rewarding and fulfilling profession. This SQL Masterclass: SQL for Data Analytic is intended for absolute beginners that concentrate on giving the appropriate knowledge of Microsoft SQL Server and help to acquire the skills and abilities to become an SQL Server developer as well as offer many job opportunities in the competitive job market. In this course, you will learn how to create databases, tables, design databases and tables. You will also learn to create flat file database, confidently use SSMS Tool as well as write basic T-SQL Queries. In addition to that, learn to create constraints and views in the most dynamic way possible. Enrol right now and start exploring SQL, the most popular relational database management system. 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. SQL for Data Analytic - Beginner Level Module: 01 Introduction FREE 00:16:00 Tools for Creating Views 00:11:00 Examples 00:21:00 Updating Data Using a View 00:13:00 Columns and Indexed Views 00:18:00 Module: 02 Introduction Stored Procedures 00:18:00 Creating Stored Procedures 00:19:00 Returning Data 00:14:00 Module: 03 Testing and Debugging 00:17:00 Execute with Result Sets 00:11:00 Creating Triggers 00:26:00 Module: 04 Overview and Scalar Functions 00:20:00 Inline Table Valued Functions 00:11:00 Multi Statement 00:16:00 Views and Stored Procedures 00:18:00 Module: 05 Transaction Concepts 00:30:00 Applications and Transactions 00:13:00 Creating Explicit Transactions 00:29:00 Structured Error Handling 00:25:00 Module: 06 Introduction to SQL CLR 00:08:00 Writing SQL CLR Code 00:24:00 Using SQL CLR Code 00:22:00 SQL CLR Code 00:13:00 SQL CLR Security 00:20:00 SQL for Data Analytic - Intermediate Level Module: 07 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: 08 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: 09 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: 10 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: 11 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: 12 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: 13 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: 14 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 15 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 SQL for Data Analytic - Advanced Level Module: 16 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: 17 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: 18 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 19 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

SQL Masterclass: SQL for Data Analytic
Delivered Online On Demand20 hours 50 minutes
£19

Microsoft Office 2007 Essentials

4.3(43)

By John Academy

Description: Microsoft Office is a group of different applications with different specific main functions that offer flexible and powerful tasks management. These applications can help you to organise, manage, and present information. Since the products of Microsoft Office are considered as the gold standard for businesses across the globe, knowing the functions of applications is a benefit for you. Through this course, you will learn all the essential skills, knowledge, and information about Microsoft Office 2007. You will know how to make use of all the programs and features of Microsoft Office. Who is the course for? New staff or workers who want to learn about the Microsoft Office 2007 Programs People who have an interest in all the features of the Microsoft Office 2007 Applications 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 Microsoft Office 2007 Essentials course is a useful qualification to possess and would be beneficial for any type of professions or career from any type of industry you are in, such as: Administrative Assistant Businessman Executive Assistant Office Administrator Office Manager Personal Assistant Secretary Senior Manager Staff. Microsoft Word 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Word 01:00:00 Module Three - Working with Documents 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 - Advanced Formatting Tasks 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Adding the Finishing Touches 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Word 2007 for Beginners 00:00:00 Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 for Beginners 00:00:00 Microsoft PowerPoint 2007 For Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing PowerPoint 01:00:00 Module Three - Working with Presentations 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Formatting Text 01:00:00 Module Six - Formatting Paragraphs 01:00:00 Module Seven - Working with Text 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Customizing Slide Elements 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 Activities-Microsoft PowerPoint 2007 for Beginners 00:00:00 Microsoft Access 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening Access 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activites- Microsoft Access 2007 for Beginners 00:00:00 Microsoft Outlook 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Outlook 01:00:00 Module Three - Working with E-mail 01:00:00 Module Four - Creating a New E-mail 01:00:00 Module Five - Managing E-mail 01:00:00 Module Six - Managing Junk Mail 01:00:00 Module Seven - Outlook's Organization Tools 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contacts 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Outlook 2007 for Beginners 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2007 Essentials
Delivered Online On Demand48 hours
£19

Online Microblading Course

By KBH Training Academy

Microblading Online Course What is Microblading? Microblading is a tattooing technique in which a small handheld tool made of several tiny needles is used to add semi-permanent pigment to the skin. Course Content History of Microblading Health & Safety at work How to do a risk assessment Preventing Legionella Control of substances hazardous to health regulations 2002 (COSHH) Code of Practice for hygiene in beauty salons The appearance of the therapist Sterilisation and disinfection The manual handling operations regulations 1992 Ergonomics The personal protective equipment at work regulations 1992 The provisions and use of work equipment regulations 1992 The Provisions and use of work equipment regulations 1998 The environmental protection act 1990 Safe disposal of sharps Tattoo regulations act W.E.E.E regulations 2006 The regulatory reform (fire safety) order 2005 Types of fire extinguishers The reporting or injuries, diseases and dangerous occurrences regulations 1995 Health and safety first aid regulations 1981 Electricity at work regulations 1989 Public liability and employers liability insurance The local authority licensing application Effective cleaning Types of cleaning agents Bloodborne pathogens Gloves Handwashing techniques Bloodborne pathogens policy and procedure Why clients may want Permanent Makeup Client satisfaction Equipment you will need Microblading consultation form Topical anaesthetic form Pre-procedure advice Permanent cosmetics aftercare Patch testing Contraindications Contra-actions Anatomy of skin Wound healing Lymphatic system Cardiovascular system Eyebrow symmetry Pigments Colour theory Colour correction/removal Trouble shootingTroubleshooting Skin tones Skin undertone test Colour changes Needle configuration Needle depths Microblading tools Anaesthetics Microblading information Worksheets Training Kit if purchased 2 x Pigment 1 x Piece Microblading Manual Pen 3 x Piece Eyebrow Practice Skin 1 x Piece Mapping String 1 x Piece Eyebrow Pen 3 x Sticky Stencil Ruler 5 x Pieces Microblading Needles 4 x Alcohol Pads 4 x Mixing Rings 4 x Mixing Swabs 4 x Mascara Wands 3 x Aftercare creams Certificate You will receive an end of course certificate which is accredited by the CPD Group and allows you to work in public. How do Online Courses work? http://www.kbhtrainingacademy.com/online-courses Duration of Course? You will have 6 months to complete the course before it expires. Will I require a model? Yes, 3 cases of studies are required to complete all of the required case studies. Are there video tutorials? Yes, you will have links to YouTube and training videos to watch the treatment being performed. Do I Need Experience Before Booking a Course? We’re pleased to offer courses to people with lots of different experiences. However, previous experience, nor qualifications are not necessary if you would like to enrol on our Course. We do however suggest our Eyebrow Shaping Course. Do you offer finance? http://www.kbhtrainingacademy.com/finance

Online Microblading Course
Delivered Online On Demand1 hour
£79 to £167

Complete Health: The Perfect Diet, Exercise And Motivation

5.0(2)

By Institute of Beauty & Makeup

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Complete Health: The Perfect Diet, Exercise And Motivation
Delivered Online On Demand1 hour
£12

Food Hygiene and Safety in Catering

4.7(160)

By Janets

The Food Hygiene and Safety in Catering is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with an acknowledged certificate. This Food Hygiene and Safety in Catering consists of several modules that take around 1 hour to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 assessment Certificate of Achievement 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 £59.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. 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 To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Course Content Introduction Introduction 00:03:00 Delivery: area of focus contamination Contamination 00:04:00 Back up storage: area of focus direct cross contamination Back up storage: area of focus sources direct cross contamination and fridges. 00:03:00 Back up storage: Area of focus requirements for bacterial growth Back up storage: Area of focus requirements for bacterial growth 00:05:00 A recap and tips for fridge safety 00:02:00 Back up storage tasks 00:01:00 Preparation: Area of focus indirect cross contamination An introduction to indirect cross contamination 00:01:00 Examples of indirect cross contamination 00:02:00 Cross contamination controls 00:02:00 Preparation: Area of focus personal hygiene. Personal Hygiene Exercise 00:01:00 Personal Hygiene standards and risks of poor hygiene 00:05:00 Hand washing task 00:01:00 Preparation: Area of focus food poisoning Introduction to food poisoning 00:02:00 Food Poisoning symptoms exercise 00:04:00 Course recap 00:05:00 The affect of temperature on bacteria The affect of temperature on bacteria 00:05:00 Focus on temperature 00:04:00 Introducing the temperature task 00:01:00 A reminder of the turkey 00:01:00 Service; areas of focus buffets and allergens Buffet temperatures 00:03:00 Allergens 00:06:00 Allergens: an update in legislation 00:01:00 Allergen and buffet task 00:01:00 A food safety audit: Area of focus pest control Examples of pests 00:03:00 Reducing the risk of pests 00:02:00 Pest task 00:01:00 A food safety audit; Area of focus structure 2 lectures Examining the structure 00:04:00 A structural task 00:01:00 A food safety audit: area of focus cleaning and disinfection. Cleaning and disinfection definitions 00:03:00 Checking your standards 00:01:00 Cleaning task 00:01:00 Paper work and revision Due Diligence 00:02:00 Paper work and revision 00:01:00 A final goodbye 00:01:00 Resources Resources - Food Hygiene And Safety In Catering 00:00:00 Assignment Assignment - Food Hygiene and Safety in Catering 2 days, 11 hours Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Food Hygiene and Safety in Catering
Delivered Online On Demand3 days
£25