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

4438 Courses

Anti Social Behaviour (ASB) Awareness

5.0(1)

By Course Gate

Anti-Social Behaviour (ASB) Awareness Course provides a thorough understanding of ASB types, family influences, and prevention strategies. Suitable for HR professionals, managers, social workers, and concerned individuals, it offers CPD certification and accessible learning materials.

 Anti Social Behaviour (ASB) Awareness
Delivered Online On Demand2 hours 48 minutes
£11.99

CBT Practitioner

4.5(3)

By Studyhub UK

With the help of our extensive 'CBT Practitioner' course, take a revolutionary step into the field of cognitive wellness. In just a blink, our succinct Introduction sets the stage, inviting you into the realms of this therapeutic art. Delve into Lesson 1.1 as we unravel the nuanced 'Definition of Concept' in a swift 5-minute session, laying the foundation for your CBT expertise. Traverse the intricate landscape of Lesson 1.2's '4 Factor Model,' discovering the keys to client understanding. With each lesson, from the dynamic exploration of client strengths and weaknesses to the artistry of structuring a CBT session in Lesson 1.5, this course is a symphony of knowledge, finely tuned to empower you as a CBT practitioner. Journey deeper into Lesson 2, where the intricacies of identifying triggers, feelings, physical reactions, and thoughts unfold like chapters in a gripping novel. Brace yourself for the transformative experience of cognitive restructuring and problem-solving in Lessons 3.1 to 3.4. The final crescendo leads you through behavioral activation and exposure therapy, equipping you with the skills to catalyze positive change. This course isn't just education; it's a roadmap to becoming a proficient CBT Practitioner, where every lesson is a stepping stone towards mastery. Learning Outcomes Define and articulate the concept of Cognitive Behavioral Therapy. Apply the 4 Factor Model for a holistic understanding of client dynamics. Demonstrate the skill of identifying triggers, feelings, physical reactions, and thoughts. Execute cognitive restructuring and problem-solving techniques effectively. Implement behavioral activation and exposure therapy for comprehensive client care. Why choose this CBT Practitioner course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this CBT Practitioner course for? Aspiring mental health professionals seeking CBT specialization. Psychology students desiring practical skills in client engagement. Counselors and therapists enhancing their toolkit with evidence-based practices. Individuals passionate about fostering positive behavioral change in themselves and others. Professionals aiming to contribute to mental wellness in various contexts. Career path CBT Practitioner: £30,000 - £50,000 Clinical Psychologist: £40,000 - £70,000 Counseling Therapist: £28,000 - £45,000 Behavioral Health Specialist: £35,000 - £55,000 Psychotherapist: £30,000 - £50,000 Mental Health Consultant: £35,000 - £60,000 Prerequisites This CBT Practitioner does not require you to have any prior qualifications or experience. You can just enrol and start learning. This CBT Practitioner was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum CBT Practitioner Introdution and overview 00:02:00 Lesson 1.1: Definition of Concept 00:05:00 Lesson 1.2: 4 Factor model 00:05:00 Lesson 1.3: Client strength+weakness 00:05:00 Lesson 1.4: Developing Goals 00:05:00 Lesson 1.5: structuring CBT session 00:05:00 Lesson 2.1: Identifying triggers 00:05:00 Lesson 2.2: Identifying feelings 00:05:00 Lesson 2.3: Identifying physical reactions 00:05:00 Lesson 2.4: Identifying thought part 1 00:05:00 Lesson 3.1: Cognitive restructuring part 1 00:05:00 Lesson 3.2: Cognitive restructuring part 2 00:05:00 Lesson 3.3: Problem solving part 1 00:05:00 Lesson 3.4: Problem Solving Part 2 00:05:00 Lesson 3.5: Behavioural Activation Part 1 00:05:00 Lesson 3.6: Behavioural activation part 2 00:05:00 Lesson 3.7: Exposure therapy part 1 00:05:00 Lesson 3.8: Exposure therapy part 2 00:05:00 Conclusion 00:02:00

CBT Practitioner
Delivered Online On Demand1 hour 29 minutes
£10.99

Financial Modelling at QLS Level 3

4.5(3)

By Studyhub UK

Are you ready to unravel the mysteries of numbers? Dive into our compelling Financial Modelling at QLS Level 3 course and be at the heart of smart business decisions. Financial models don't just predict the future; they shape it. Our introduction lets you grasp this powerful tool's essence, preparing you for the exhilarating journey ahead. As you immerse deeper, you'll befriend a restaurant. Not just any restaurant, but one that becomes your canvas to paint financial concepts on. From the hustle of acquiring customers to the nitty-gritty of costs, the case study becomes your guide, blending theory with tangible examples. Learning Outcomes Understand the core principles and applications of financial modelling. Develop financial models anchored in real-world scenarios, using the case study approach. Gain proficiency in customer acquisition, revenue, and cost modelling. Master the intricacies of the three financial statement models. Acquire the skills to identify and rectify errors in financial models. Why choose this Financial Modelling at QLS Level 3 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Financial Modelling at QLS Level 3 course for? Aspiring financial analysts keen to bolster their modelling expertise. Business owners aiming to gain insights into their company's financial health. Finance students looking to apply theoretical knowledge in practical scenarios. Investment bankers and consultants seeking to refine their financial modelling skills. Professionals in corporate finance aiming to understand business financials better. Career path Financial Analyst: £30,000 - £55,000 Investment Banker: £50,000 - £100,000+ Business Valuation Consultant: £40,000 - £70,000 Corporate Finance Manager: £60,000 - £90,000 Equity Research Analyst: £35,000 - £65,000 Financial Consultant: £40,000 - £75,000 Prerequisites This Financial Modelling at QLS Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Financial Modelling at QLS Level 3 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £85 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Section 01: Introduction Introduction to the course 00:02:00 Introducton to the Business Priocess 00:03:00 What is Financial Modelling 00:08:00 Starting Point of a Financial Model 00:04:00 First Steps before Starting to create Financial Model and Linking Business Model 00:07:00 Section 02: Case Study: Restaurant - Basic Model for Selecting Initial Idea Starting with End in Mind-Comparative P&L 00:13:00 Customer Acquisition Model 00:16:00 Revenue and Cost Models 00:22:00 Adding Product and Modelling Labour and Other Costs 00:21:00 Modelling Capital Investments and ROI Calc 00:10:00 Case Study: Restaurant - Basic Model for Selecting Initial Idea 00:00:00 Section 03: Business Plan and 3 Financial Statement Models Detailed Customer Acquisition Model and Revenue Model 00:17:00 Cost of Sale Model 00:08:00 Modelling Labour Cost 00:07:00 Modelling Other Operating Expenses 00:14:00 Modelling Balance Sheet 00:14:00 Fixing the Error in Financial Model and Brief of RR 00:07:00 Financial Model for Business plan for New Business 00:00:00 Assignment Assignment - Financial Modelling at QLS Level 3 02:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Financial Modelling at QLS Level 3
Delivered Online On Demand4 hours 53 minutes
£10.99

Level 2 Certificate in Food Hygiene and Safety for Catering

4.3(43)

By John Academy

This Level 2 Food Hygiene and Safety for Catering course has been designed to help you improve your knowledge of handling food in a catering environment. You will discover the legal requirements to prepare and serve food in the service industry. You will also discover HACCP, the multiple levels of hazards and their preventive measures, and much more including temperature control and handling basics. Knowledge and understanding of basic food hygiene and safety is a legal requirement so as not to contaminate food and to be safe at work at all times. The course provides learners with up-to-date food hygiene information using a range of written text, and video content to ensure learners thoroughly comprehend their food safety responsibilities. Who is the course for? All food handlers are required by European Union Regulation laws to go through an orientation training prior to starting a food handling job. This Level 2 Certificate in Food Hygiene and Safety for Catering course allows readers to learn about the basic food hygiene practices in order to be able to comply with all the legal requirements. This course is suitable for food handlers in any sector including fast-food outlets, takeaways, food trucks, bars, restaurants, hotels, cafes, hospitals, schools and colleges. 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 & Certification: Once you complete all the lessons/units, you are required to sit an exam which is multiple-choice. The pass mark is 60%. After successfully passing the exam you can obtain your certificate of achievement at an additional cost of £9. 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: Level 2 Certificate in Food Hygiene and Safety for Catering is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Restaurateurs Hospitality managers Chefs Hotel and restaurant service staff Professional hygiene and safety officer. Food Hygiene and Safety for Catering Introduction to Food Safety and the Law 00:30:00 Bacteria and Microbiological Hazards 00:27:00 Physical, Chemical and Allergenic Hazards 00:25:00 Food Poisoning and Control Measures 00:23:00 Food Spoilage and Food Storage 00:25:00 Personal Hygiene 00:24:00 HACCP and Food Premises Part-01 00:27:00 HACCP and Food Premises Part -02 00:26:00 Cleaning 00:20:00 Mock Exam Mock Exam - Level 2 Certificate in Food Hygiene and Safety for Catering 00:20:00 Final Exam Final Exam - Level 2 Certificate in Food Hygiene and Safety for Catering 00:20:00 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 2 Certificate in Food Hygiene and Safety for Catering
Delivered Online On Demand4 hours 27 minutes
£12

Chef Training Certificate

4.5(3)

By Studyhub UK

Embark on the 'Chef Training Certificate' journey to transform your culinary passion into a prestigious career. This course transcends mere recipe learning, offering a deep dive into cooking mastery, from essential knife skills to crafting diverse, intricate dishes. It's a comprehensive pathway to becoming a culinary expert, encompassing everything from pastry chef intricacies to the rigorous chef training courses in the UK. As you progress, you'll engage in continuous learning and adapt to the dynamic demands of being a chef, including perfecting saucier skills, choosing specialties, and understanding restaurant management. This UK-based program equips you with a diverse skill set, preparing you for a successful career in the ever-changing culinary world, shaping you from an enthusiast to a professional chef. Learning Outcomes Acquire comprehensive knowledge of cooking techniques and food preparation skills. Develop expertise in catering to diverse taste preferences and dietary requirements. Master the art of using kitchen equipment efficiently and safely. Gain insights into the business aspects of culinary arts, including restaurant management. Enhance creativity in meal presentation and recipe innovation. Why buy this Chef Training Certificate? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Chef Training Certificate there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Chef Training Certificate course for? Aspiring chefs seeking foundational and advanced culinary skills. Culinary enthusiasts aiming to professionalize their cooking abilities. Individuals interested in specializing in pastry or gourmet cuisine. Career changers exploring opportunities in the culinary industry. Hospitality professionals looking to expand their culinary expertise. Prerequisites This Chef Training Certificate does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Chef Training Certificate was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Head Chef: £28,000 - £55,000 Per Annum Pastry Chef: £20,000 - £35,000 Per Annum Sous Chef: £22,000 - £30,000 Per Annum Catering Manager: £25,000 - £40,000 Per Annum Food Stylist: £20,000 - £45,000 Per Annum Restaurant Manager: £24,000 - £50,000 Per Annum Course Curriculum Cooking (Chef) Course Can TV Chefs Teach You To Cook? 00:05:00 Improving Cooking And Food Preparation Skills 00:05:00 Catering To Unique Tastes 00:30:00 Qualities Of A Successful Chef 00:30:00 Achieve Perfection As A Saucier 00:05:00 Becoming The Perfect Chef 00:25:00 Equipment For Perfect Chefs 00:15:00 How To Become The Perfect Chef: Attending School 00:05:00 The Keys To Getting and Using Feedback 00:05:00 What Can You Do With A Culinary Degree 00:20:00 Knife Skills For The Perfect Chef 00:10:00 Making Meals Easy to Eat Healthy 00:05:00 Plating for the At Home Chef 00:10:00 Perfect Chefs Choose A Speciality 00:05:00 Finding Local Cooking Classes 00:05:00 How Can You Become a Professional Chef 00:10:00 The Physical Qualities of the Perfect Chef 00:05:00 The Importance of Testing Recipes 00:05:00 The Chefs Important Baking Tools 00:25:00 The Learning Curve To Becoming The Perfect Chef 00:05:00 The Job of a Professional Chef 00:05:00 The Mix of Sweet, Spicy and Savory 00:05:00 The Perfect At Home Chef 00:10:00 The Perfect Chef Opens A Restaurant 00:05:00 The Physical Demand of Being a Chef 00:05:00 Recipes Recipe - I 00:10:00 Recipe - II 00:10:00 Recipe - III 01:00:00 Recipe - IV 00:10:00 Recipe - V 00:10:00 Recipe - VI 00:10:00 Recipe - VII 00:10:00 Recipe - VIII 00:10:00 Recipe - IX 00:10:00 Recipe - X 00:10:00 Recipe - XI 00:10:00 Recipe - XII 00:15:00 Recipe - XIII 00:10:00 Recipe - XIV 00:10:00 Recipe - XV 00:00:00 Recipe - XVI 00:10:00 Recipe -XVIII 00:10:00 Recipe -XVIII 00:10:00 Recipe -XIX 00:10:00 Recipe -XX 00:10:00 Recipe-XXI 00:10:00 Recipe-XXII 00:10:00 Recipe-XXIII 00:10:00 Recipe-XXIV 00:10:00 Recipe-XXV 01:00:00 Recipe-XXVI 01:00:00 Recipe-XXVII 01:00:00 Recipe-XXVIII 01:00:00 Recipe-XXIX 01:00:00 Recipe-XXX 01:00:00 Recipe-XXXI 01:00:00 Recipe-XXXII 01:00:00 Recipe-XXXIII 01:00:00 Recipe-XXXIV 01:00:00 Recipe-XXXV 01:00:00 Recipe-XXXVI 01:00:00 Recommended Reading Recommended Reading : Chef Training Certificate 00:00:00 Assignment Assignment - Chef Training Certificate 00:00:00

Chef Training Certificate
Delivered Online On Demand21 hours 5 minutes
£10.99

The Power of Mindfulness

4.3(43)

By John Academy

The key to happiness is the capacity to control your feelings and know how to control the way you think. In this course, you will be learning what mindfulness means, and you could use it. You will also be introduced to cognitive restructuring and how to use it in the real world. Moreover, you will learn about stress and flow states that can be a hindrance in your peaceful thinking. You will also learn how to visualize and the importance of it. Thus, in this course, you will surely be able to know the power of mindfulness and how it can affect your life. Who is the course for? Professionals who are helping people build their personal goals People who have an interest in the personal development concepts 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 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: The Power of Mindfulness is a useful qualification to possess, and would be beneficial for the following careers: Career Coach Guidance Counsellors Life Coach Mentors Psychologists. The Power of Mindfulness Introduction 00:15:00 What is Mindfulness? 01:00:00 Starting Your Mindfulness Using Meditation 01:00:00 Introducing Cognitive Restructuring 00:30:00 How to Use Cognitive Restructuring in the Real World 00:30:00 Stress and Flow States 01:00:00 Why You Should Visualize 01:00:00 The Power of Belief 00:30:00 Conclusions 00:30:00 Mock Exam Mock Exam- The Power of Mindfulness 00:20:00 Final Exam Final Exam- The Power of Mindfulness 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Power of Mindfulness
Delivered Online On Demand6 hours 55 minutes
£11.99

Learn MySQL from Scratch for Data Science and Analytics

4.5(3)

By Studyhub UK

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Learn MySQL from Scratch for Data Science and Analytics
Delivered Online On Demand5 hours 47 minutes
£10.99

Housekeeping and Cleaning Course

5.0(1)

By Course Gate

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Housekeeping and Cleaning Course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Housekeeping and Cleaning Course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Housekeeping and Cleaning Course and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Housekeeping and Cleaning Course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Housekeeping and Cleaning Course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Housekeeping and Cleaning Course will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Housekeeping Introduction to Housekeeping 00:30:00 Housekeeping Principles 00:15:00 Understanding Staff Duties 00:45:00 Cleaning 00:30:00 Inventory Control 00:45:00 Planning & Organising the Housekeeping Department 00:30:00 Understanding Budgeting 00:45:00 Carpet Maintenance 00:30:00 Wall, Ceiling and Window Cleaning and Maintenance 00:30:00 Staffing 00:45:00 Standard Operational Procedures in Hotel Housekeeping 00:15:00 Laundry Operation in Hotel 00:30:00 Health and Safety 00:20:00 Cleaning Cleaning 00:15:00 Cleaning Procedures 00:30:00 Office Cleaning 00:30:00 Entryways and lobbies 00:30:00 Hard Floor Maintenance 00:15:00 Floor Stripping 00:30:00 Carpet Maintenance 00:15:00 Carpet Extraction Cleaning 00:15:00 Restrooms 00:30:00 Spills 00:15:00 Pest Management 00:15:00 People with special needs 00:15:00 Cleaning products 01:00:00 Medical Cleaning 01:30:00 Cleaning Business 00:30:00 Tidying or Cleaning? 01:00:00 Ensuring Chemical Safety 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Housekeeping and Cleaning Course
Delivered Online On Demand15 hours 35 minutes
£11.99

Diploma in Nutrition Course - CPD Accredited

By Training Tale

Nutrition: Diploma in Nutrition Course Online We must make important dietary and nutritional decisions regularly due to the dramatic rise in diet-related illnesses. The importance of understanding the role of nutrition in our growth and development throughout our lives cannot be overstated. Because of the importance of nutritional balance, millions of adults worldwide have begun to pay more attention to their eating habits, tracking and restricting what they put into their bodies. This Diploma in Nutrition covers everything there is to know about nutrition. This Diploma in Nutrition course will be extremely beneficial if you want to work as a certified nutrition advisor. It will help you learn about a skilled nutrition counsellor's crucial role and build some valuable life skills. Enrol in this Diploma in Nutrition course to learn why professional nutritionists are in higher demand than ever before and get started on your path to a lifetime of success. Main Course: Level 5 Diploma in Nutrition GIFT COURSES Course 01: Level 2 Award in Nutrition and Health Course 02: Level 2 Certificate in Understanding Nutrition and Health Course 03: Level 2 Award in Improving Personal Exercise, Health and Nutrition Course 04: Diploma in Sports Nutrition [ Note: Free PDF certificate as soon as completing the Nutrition: Diploma in Nutrition Course] Nutrition: Diploma in Nutrition Course Online Industry Experts Designed this Diploma in Nutrition course into 08 detailed modules. Course Curriculum of Diploma in Nutrition Course Module 01: Introduction Module 02: Dietary Guidelines Module 03: Nourishment and the Human Body Module 04: Metabolism and Blood Function Module 05: Macronutrients in the Diet: Protein Module 06: Macronutrients in the Diet: Lipids Module 07: Nutrition throughout the Life Cycle Module 08: Nourishment and Society: Food Politics and Views Assessment Method of Diploma in Nutrition Course After completing each module of the Nutrition: Diploma in Nutrition Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Diploma in Nutrition Course After completing the MCQ/Assignment assessment for this Nutrition: Diploma in Nutrition Course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Nutrition: Diploma in Nutrition Course Online This Nutrition: Diploma in Nutrition Course is highly recommended for people interested in learning more about nutrition and working as a professional counsellor. This Nutrition: Diploma in Nutrition Course is also beneficial to people who wish to start a diet and fitness business from scratch and those who already work in the industry and want to expand their knowledge and skills. This lesson is required for all parents and nurses. Requirements Nutrition: Diploma in Nutrition Course Online Students who intend to enrol in this Nutrition: Diploma in Nutrition Course must meet the following requirements: Nutrition: Good command of the English language Nutrition: Must be vivacious and self-driven Nutrition: Basic computer knowledge Nutrition: A minimum of 16 years of age is required Career path Nutrition: Diploma in Nutrition Course Online Candidates who successfully complete our Nutrition: Diploma in Nutrition Course can pursue a wide range of careers. Certificates Certificate of completion Digital certificate - Included

Diploma in Nutrition Course - CPD Accredited
Delivered Online On Demand25 hours
£15

70-640 - Configuring Windows Server 2008 R2 Active Directory

4.3(43)

By John Academy

Description: The 70-640 - Configuring Windows Server 2008 R2 Active Directory course provides the required information that you should know about 70-640: Configuring Windows Server 2008 R2 Active Directory. The course will teach you how to install the Active Directory role, or how to work with Active Directory objects. In the course, you will also learn about the GPOs (Group Policy Adjectives), what Group Policy objects are, restricted Group Policies. You will know analysing security settings, using the Security Configuration Wizard, deploying software with Group Policy, understanding Group Policy Scope, how Group Policy settings are processed, verifying Group Policy settings, and enabling Auditing. You will also be able to manage users and groups with the AD, working With Domain Controllers, adding DNS, securing the authentication process, monitoring and supporting AD, planning Active Directory deployment, IDA solutions, and Active Directory Certificate Services. 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? 70-640 - Configuring Windows Server 2008 R2 Active Directory 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 70-640 - Configuring Windows Server 2008 R2 Active Directory 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. Installing the Active Directory Role What is IDA? FREE 00:16:00 How to Install the AD DS Role 00:11:00 Creating a Windows Server 2008 Forest 00:22:00 The New Windows 2008 Server Core 00:09:00 Installing AD DS Server Core 00:02:00 Domain Controller 00:20:00 Working With Active Directory Objects Working with the MMC 00:19:00 Custom MMC 00:14:00 Working with Objects in Active Directory 00:12:00 How to Search Through Active Directory 00:07:00 Using Active Directory 00:13:00 Securing and Delegating AD Objects 00:12:00 Delegation 00:05:00 Adding Computer Accounts to AD 00:08:00 Organizing AD with Container Objects 00:13:00 Joining the Demo 00:08:00 Working With Computer Objects and Accounts 00:17:00 Recycling the Computer Account 00:01:00 Automating Computer Account Creation 00:08:00 Automating Computer Creation 00:04:00 Understanding GPOs Using Group Policy 00:04:00 What Are Group Policy Objects 00:21:00 Group Policy 00:05:00 Restricted Group Policies 00:02:00 Restrcted Group 00:03:00 Analyzing Security Settings 00:12:00 Using The Security Configuration Wizard 00:05:00 SCW 00:08:00 Deploying Software with Group Policy 00:10:00 Software Deployment 00:02:00 Understanding Group Policy Scope 00:11:00 How Group Policy Settings are Processed 00:09:00 Group Policy Scope 00:11:00 Verifying Group Policy Settings 00:05:00 Verifying Group Policy 00:03:00 Enabling Auditing 00:13:00 Auditing 00:05:00 Managing Users and Groups with AD Automating User Account Creation 00:10:00 Automating User Accounts 00:07:00 Working with User Attributes 00:15:00 User Account Administrative Tasks 00:05:00 Supporting User Accounts 00:04:00 Using PowerShell to Create User Accounts 00:09:00 Creating Users with PowerShell 00:07:00 Creation and Management 00:08:00 The Basics of Groups 00:25:00 Managing Group 00:08:00 Best Practices for Using AD Groups 00:08:00 Automating Group Creation 00:05:00 Automating Creation of Groups 00:06:00 Advanced Group Options 00:09:00 Administering Groups 00:05:00 Working With Domain Controllers Installation Options 00:06:00 How to Install a Domain Controller 00:06:00 Introducing the Operations Masters 00:11:00 Designing Where to Deploy the Operation Masters 00:14:00 FSMO 00:03:00 SYSVOL Replication with DFS 00:02:00 Adding DNS DNS Basics 00:15:00 DNS Definitions and Terms 00:17:00 DNS 00:05:00 Setting up DNS for the Enterprise 00:09:00 Global Names 00:09:00 Securing the Authentication Process Password Security Policies 00:15:00 Passwords 00:03:00 Introducing the Read-Only Domain Controller 00:06:00 Installing the RODC 00:05:00 Auditing Authentication Events 00:03:00 Account Logging 00:03:00 Monitoring and Supporting AD Preparing for Recovery 00:10:00 Active Directory Tools 00:24:00 Monitoring Active Directory Performance 00:11:00 Performance Monitor 00:09:00 Planning Active Directory Deployment What Are Sites 00:27:00 Deciding on Site Boundaries 00:07:00 Sites and Subnets 00:08:00 Working with Global Catalog Placement with AD Partitions 00:09:00 Controlling Replication Between Sites 00:20:00 Managing the Global Catalog 00:04:00 Configuring AD Trust Relationships 00:32:00 Trusts 00:03:00 Choosing the Domain and Forest Functional Levels 00:07:00 IDA Solutions Understanding AD FS 00:10:00 Installing AD FS 00:01:00 Configuring and Using AD FS 00:03:00 Understanding AD RMS 00:10:00 Installing AD RMS 00:03:00 Configuring and Using AD RMS 00:07:00 Understanding AD LDS 00:08:00 Installing AD LDS 00:02:00 Installing AD LDS 00:05:00 Configuring and Using AD LDS 00:07:00 Security Review 00:04:00 Active Directory Certificate Services Understanding AD CS 00:29:00 Installing AD CS 00:02:00 Configuring and Using AD CS 00:08:00 Mock Exam Mock Exam- 70-640 - Configuring Windows Server 2008 R2 Active Directory 00:20:00 Final Exam Final Exam- 70-640 - Configuring Windows Server 2008 R2 Active Directory 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

70-640 - Configuring Windows Server 2008 R2 Active Directory
Delivered Online On Demand15 hours 23 minutes
£11.99