37497 Courses in Leeds delivered Online

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

This accredited course provides knowledge and understanding in relation to health, wellbeing and personal safety - extremely useful in life!

If you can give your dog the proper training then it'll listen to you forever and be your ideal pet, your friend and your ideal walking buddy. This Dog Training - Leash Training - Simple Dog Training Methods course is designed to teach you how you can give proper leash training to your dog. This course was made by expert Sharon Bolt, who was the featured trainer in BBC Documentary 'Britain's Most Embarrassing Pets'. Sharon has had a regular slot on BBC Radio since 2008 where she answers numerous listeners' doggy dilemmas and has been featured in over 40 local and national newspapers, magazines, television and radio stations. So, rest assured that this course is made by the expert and you're guaranteed a thorough training on this subject. Dogs often seem to dislike leashes and they pull on them constantly, chew the leash and zig-zag in front of you. And when you let them off the leash they don't come back on your command. All these things are annoying and could be dangerous for the dog. That is why we bring you this best-selling Dog Training - Leash Training - Simple Dog Training Methods course. It is one of the most comprehensive courses available on dog training. This is an amazing training program that'll quickly and easily teach you all the things you need to know to stop your dog from pulling on the leash. And you'll learn why your dog pulls the leash and seems bothered by it. You'll gain the skills needed to train your dog to listen to your command and come back to you when you command it to. You'll also learn many more things about dogs and how to train them properly.  So if you're a dog owner then this course is a must for you. Enrol Now! Course Highlights Learn simple, clear, concise communication and dog training methods that dogs love and that stops your dog from: Pulling on the leash Chewing the leash Zigzagging on the leash Coming back when it wants - it comes back when you call them instead. What you'll learn Learn what the walk really means to a dog and why it's vital that you get this area right. Easy and very successful techniques you can do before you leave the house that makes a remarkable difference to your walk. Calm, kind and confident methods you can do during the walk, when your dog pulls, that will give them the message they need to walk calmly by your side. How to stop your dog from 'zig-zagging' in front of you and pulling you to every lamp post and bush when walking. How to stop your dog from biting and chewing the lead when out. Learn simple and easy methods that will get your dog to come back when called when they are off the leash. Perform dog training methods that are easy to do and get quick results. Get your dog to pay attention to you and respond favourably to your commands. Obtain the knowledge and confidence needed in order to be your dog's pack leader, in a kind and gentle way, during the walk. Communicate to your dog in a language they understand. Have a pleasurable and enjoyable walk. Who is this Course for? This Dog Training - Leash Training - Simple Dog Training Methods course is perfect for  Any dog owner, regardless of experience, who likes the pack leader theory as well as using positive reinforcement techniques. If you want to learn how to be your dog's pack leader without having to shout at, hit or pin down your dog, then this course is for you. If you're a dog owner whose dog is constantly pulling on the leash and you want them to stop, or doesn't come back when it's off the leash, then this is the ideal course for you. If you want to train your dog to become the ideal pet, then this is the course for you. If you want to learn how to properly communicate with your dog, then this is the course for you. Requirements  Our Dog Training - Leash Training - Simple Dog Training Methods course is fully compatible with any kind of device. Whether you are using a Windows computer, Mac, smartphone or tablet, 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. This course requires no qualifications and is ideal for you if you have a dog who pulls on the leash and doesn't come back when called when off the leash, or zigzags in front of you while walking on a leash. It's also ideal for anyone with a desire to learn more about dogs. Career Path You will be ready to enter the relevant job market after completing this course and will be equipped with the necessary knowledge and skills required to succeed in this sector. All of our courses are CPD and IAO accredited, so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. The Proof Is In The Pudding - This Is What People Say Why Getting 2, 8 Week Old Parson Terrier Puppies Changed My Life And My Career! FREE 00:03:00 What People Say Who've Used My Methods 00:01:00 Don't Take My Word For It - This Is What People Say! 00:01:00 This Could Be You Too! 00:15:00 Here's What You'll Get From This Course Here's What You'll Get From This Course 00:05:00 The Missing Link - Preparing For The Walk Why Preparing For The Walk Is Essential To Getting Great Results FAST! 00:10:00 This is Exactly How To Do It... 00:07:00 **Bonus Video ** Dog Frightened Of The Leash Question - Answered December 2015 00:09:00 The Walk How to Get Your Dog to Easily Walk by Your Side 00:09:00 This Video Shows You Exactly What To Do 00:06:00 Here's Another Method That Is Really Effective 00:04:00 Recall Training How to Teach Your Dog to Come Back When Off Leash - Why People Get This Wrong 00:08:00 Here's Step-By-Step How To Do It 00:04:00 Points To Remember When Your Dog Is Off Leash 00:02:00 Who's Walking Who? E-Book Here's an E-Book I've written about dog walking and recall training 00:30:00

Overview With the ever-increasing demand for High Ticket Sales Training in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in High Ticket Sales Training may be. Learning about High Ticket Sales Training or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in High Ticket Sales Training . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on High Ticket Sales Training is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this High Ticket Sales Training course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this High Ticket Sales Training course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this High Ticket Sales Training course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of High Ticket Sales Training , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in High Ticket Sales Training , Anyone looking for a certificate of completion on doing an online training on this topic, Students of High Ticket Sales Training , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This High Ticket Sales Training course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Chapter 1_ Basics of High Tickets Basics of High Tickets 00:00 Chapter 2_ Examples of High Ticket Products Examples of High Ticket Products 00:00 Chapter 3_ Packaging a High Ticket Coaching Product Packaging a High Ticket Coaching Product 00:00 Chapter 4_ Content Creation and Length Content Creation and Length 00:00 Chapter 5_ Selling Your Product Selling Your Product 00:00 Chapter 6_ Extra Tools and Tips Extra Tools and Tips 00:00

Get Noticed By Recruiters in this Hiring Season by Developing Your Skills! Every student deserves a champion-a teacher who will never give up on them, understands the power of connection, and insists that they become the best they can possibly be. So if you are interested in being that teacher, the one who lights the way for others and want to accelerate your career in this noble teaching profession, then our Higher Level Teaching Assistant Qualification is the right choice for you. This Higher Level Teaching Assistant Qualification is Ofqual regulated (the UK Govt. recognised) and offers you 36 credits in this programme so that you can improve your teaching skills and enhance your chances of employability. This course was precisely created by renowned world-leading professors to thoroughly prepare you for the academic year-end assessment for the Higher Level Teaching Assistant Qualification. The Higher Level Teaching Assistant Qualification course has been accredited by Focus Awards, the UK's fastest-growing awarding organisation, allowing you to learn from the best. Focus Awards is a well-known awarding organisation governed by Ofqual, ensuring professionalism and recognition of your credentials. You will have the opportunity to explore education and training ideas, principles, and models. As a result, you can rest assured that your learning experience will be exceptional. Additionally, you'll receive not one but 20 Premium CPD-approved courses for FREE with this Higher Level Teaching Assistant Qualification certificate!!! The courses are: With this Higher Level Teaching Assistant Qualification Course, learners will get the 20 Premium courses absolutely FREE. Course 01: Education Management Course 02: Educational Psychology and Development Course 03: Advanced Teaching Assistant Diploma Course 04: Special Education Needs (SEN) Training - Level 2 Course 05: EYFS Teaching - Level 3 Course 06: Phonics Teaching Diploma Level 3 Course 07: Leadership in Teaching Course 08: Lesson Planning for Teaching Course 09: Remote Teaching Online Course 10: Classroom Behaviour Management Course 11: Performance Management Course 12: People Management Skills Level 3 Course 13: Report Writing Course 14: Domestic Violence and Abuse Awareness - Level 2 Course 15: Child Neglect Awareness Certificate Course Course 16: Level 3 Mental Health and Adolescent Course Course 17: Safeguarding Children Level 3 Course 18: Functional Skills English Practice Level 2 Course 19: Train the Trainer Course 20: Leadership & Management Diploma These courses will help you expand your knowledge and understanding of teaching assistantship, SEN teaching, EYFS education, and much more! Enrol today and grab this once-in-a-lifetime opportunity. Why is this Higher Level Teaching Assistant Qualification Course perfect for You? Choose & Advance Your Career: Join today and make a life-changing decision, learn with our Regulated qualifications and move up to the next level in your organisation with expertise. 20 Additional Courses: With a single payment, you will get access to the Higher Level Teaching Assistant Qualification along with 20 additional CPD courses. Upgrade Your Skills: Add value to your current educational profile and gain the skill sets to compete in your job role with unlimited dedicated personal tutor support. Enhance Your Credibility: Quality assured for your peace of mind - qualification regulated by Ofqual. The Higher Level Teaching Assistant Qualification course is Ofqual, UK Govt. Regulated and Awarded by Focus Awards, which adds value to your educational profile. 100% Money-Back Guarantee: We are confident about our course quality and want to provide the best service to our invaluable learners. That's why we provide 14 day Unconditional Full Money-Back Guarantee with this course to ensure a hassle-free purchase. Qualification Summary Qualification type: Occupational Qualification Qualification title: Higher Level Teaching Assistant Qualification Accreditation status: Accredited Level: 4 Guided Learning Hours (GLH): 87 Total Qualification Time (TQT): 360 Qualification number (QN): 601/8533/8. ****Qualification Curriculum**** **Level 4 Certificate for Higher Level Teaching Assistants (RQF)** Awareness of special educational needs Child development and welfare Curriculum planning, delivery and assessment Developing skills to promote positive working relationships Promoting positive behaviour in children and young people Providing support for individual learners and small groups Understand the Higher Level Teaching Assistant role Course Duration Guided Learning Hours These hours are made up of all contact time, guidance, or supervision of a learner by a lecturer, supervisor, tutor, trainer, or other appropriate education or training providers. Guided Learning Hours for this qualification is 87. Total Qualification Time Total Qualification Time comprises GLH and an estimate of the number of hours a learner is likely to spend in preparation, study or any other learning, including assessment, which takes place as directed by, but not under the supervision of a lecturer supervisor or tutor. The credit value, where given for qualification, is determined by TQT, as one credit corresponds to 10 hours of learning. Total Qualification Time for this qualification is 360 hours. Assessment The qualification assessments will be taken through tutor-marked assignments. Upon completing each unit, the learner must attempt a series of questions with comprehensive answers, which will be marked by the tutor. The tutor-marked tasks are required to be assessed by a professional as well. Thereupon, to ensure all the course assignments have met the standards properly by both the learners and assessors, the tasks are subjected to internal and external moderation. NB: At least 50 hours of work placement within a school is required to accomplish this assessment. The work setting can either be a primary, secondary or special school with pupils aged 5+ and studying Key Stage 1 or above. As a part of this placement, learners will require a member with occupational competence in supervising and signing the witness testimonies, to ensure they have gained the work-based learning outcomes of this programme properly. Method of Assessment Assessment activities consist of a few short assignments that you have to complete to show evidence of general reading while adding references to your work. All assignments should be submitted via the online portal. All learning outcomes must be met to achieve a Pass - there is no grading. Certification Successful candidates will be awarded a Level 4 Certificate for Higher Level Teaching Assistants (RQF) from Focus Awards Limited. You will also get CPD accredited Teach the Teachers Level 3, Education Management, Educational Psychology and Development, Lesson Planning for Teaching, and Home Education courses certificates from Apex Learning. Progression Successful learners may wish to progress to teaching qualifications such as: Level 3 Award in Education and Training Level 4 Certificate in Education and Training Level 5 Diploma in Education and Training Who is this course for? Our comprehensive Level 4 Certificate for Higher Level Teaching Assistants (RQF) course is designed for ambitious students who are currently employed or seeking employment in the teaching field. The qualification is also suitable for individuals who: Wish to join in a teaching professionals Beginner this field and wish to acquire in-demand assessing skills Wish to gain formal recognition of their skills Want to study from home at their own convenience Requirements There are no specific entry requirements. The qualification is suitable for learners who are 16 years and above. NB: At least 50 hours of work placement within a school is required to accomplish this assessment. The work setting can either be a primary, secondary or special school with pupils aged 5+ and studying Key Stage 1 or above. As a part of this placement, learners will require a member with occupational competence in supervising and signing the witness testimonies to ensure they have gained the work-based learning outcomes of this programme properly. Career path You will have the ability to accomplish a lot of things with this certificate. Here are just a few examples: Teacher Education professional Education trainer Teaching Assistant Education and Training Officer

Unlock Your Potential as a Learning & Development Practitioner with Our Level 3 Course This qualification allows candidates to learn, develop and practice the skills required for employment and a career in Learning & Development. The content covers all essential areas of learning & development and is mapped out to the institute of apprenticeships standards. It’s a work-based program combining on-the-job training with classroom learning, equipping you with skills to support employee learning and development (L&D) within an organisation. Learn about the Cavity Training Learning & Development Practitioner Course You will be introduced to the role and responsibilities and essential attributes and behaviours required in the various L&D roles that may be required for effective learning and development in an organisation. Additionally, it will teach you the policies and processes required for effective organisation learning. You will learn how to identify and analyse learning needs, establish team and individual capability and learning gaps, in line with organisational performance outcomes and to enable effective evaluation. This may include the needs of the staff impacted by the move to a net carbon zero economy by 2050 and the requirements for a just transition. Fees This course can be completed as an government funded apprenticeship, through Cavity Training, or as a privately funded course for £2500. You can either pay as a lump sum or alternatively, you can split into 12 instalments. Entry Requirements Whilst any entry requirements will be a matter for individual employers, typically an apprentice will have an area of technical, vocational or behavioural expertise in which the organisation needs others to acquire through training. And a minimum of English & Maths GCSE. Structure Our candidates are trained to the highest standards and are fully supported to develop all of the knowledge, skills and behaviours required to be an outstanding Learning & Development practitioner. The course duration is typically 18-24 months. Knowledge Our course is delivered via live training webinars with specialist tutors. Skills and Behaviours You will be appointed a designated Learning & Skills Teacher, who will coach you through your qualification and complete regular assessments with you to support you to complete your qualification. You will have weekly contact from your tutor. How we compare with our competitors? Don't just take our word for it, here is what our staff think Bridget I did my course years ago. It was classroom based one night per week. I think I would prefer to be more ‘hands on’ like it is now. Cavity really are a great company to work for. I truly believe that there expertise will ensure the next generation are amazing! Gina I did mine over an apprenticeship but the company my employer used wasn’t great and I didn’t get much support. Although I passed I can only imagine the length that Cavity have gone to to ensure that the students feel supported. As an employee, its super! Enquire Today

Register on the TV Presenter Training today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The TV Presenter Training is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The TV Presenter Training Receive an e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification 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. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the TV Presenter Training, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Module 01: Who is a TV Presenter? Who is a TV Presenter 00:31:00 Module 02: Qualifications and Skills Required to Become a Presenter Qualifications and Skills Required to Become a Presenter 00:30:00 Module 03: Essentials to Become a Presenter Essentials to Become a Presenter 00:32:00 Module 04: Talking To/ Speaking in Front of The Camera Talking To/ Speaking in Front of The Camera 00:39:00 Module 05: Talk Back and Teleprompter Talk Back and Teleprompter 00:26:00 Module 06: Creating a Showreel Creating a Showreel 00:26:00 Module 07: Interviewing Techniques Interviewing Techniques 00:38:00 Module 08: Scripting Techniques Scripting Techniques 00:27:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 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.

Certificate in Intellectual Property (CIP) Why Attend As international trade and business continues to evolve, the importance of Intellectual Property Rights (IPRs) becomes increasingly vital. With new technologies and products relying heavily on IPRs, governments around the world are competing to offer higher levels of protection in order to attract investments and promote local innovation and production. Due to the complex nature of the scientific, economic, social, and theoretical aspects of IPRs, it is crucial for entities to have a comprehensive understanding of these issues. During this course, through practical workshops, case studies and expert knowledge, participants will gain an understanding of the concepts, theories, legislative and practical elements necessary to develop a successful IP strategy for their organization. Course Methodology In this interactive training course participants will frequently work in pairs as well as in larger groups to complete exercises, and regional and international case studies Course Objectives By the end of the course, participants will be able to: Understand the theoretical background of Intellectual Property (IP) and the various types of IP existence Understand the international and local set of conventions and laws governing IPRs Demonstrate deep knowledge of the conditions that should exist in each type of IPR, their registration, licensing and enforcement Apply knowledge of IPRs in all legal fields including contracts and litigation Participate effectively in building a comprehensive IP strategy for their organization Target Audience This course is suitable for professionals working in the legal and IP filed, including but not limited to; lawyers, in-house counsels, governmental officials, police, customs, health authorities, researchers, university lecturers, publishers, IP agents as well as researchers who are interested in having deeper knowledge about IP in the GCC. It will also highly benefit in-house councils who recently joined their companies in the GCC as it will give them all the knowledge needed to handle all IP issues within the region. Target Competencies General principles of IPRs Trademarks, Patents, Copyright Principles of IP Enforcement Building IP Strategy Note The Dubai Government Legal Affairs Department has introduced a Continuing Legal Professional Development (CLPD) programme to legal consultants authorised to practise through a licensed firm in the Emirate of Dubai. We are proud to announce that the Dubai Government Legal Affairs Department has accredited EMG Associates as a CLPD provider. In addition, all our legal programmes have been approved. This PLUS Specialty Training Legal course qualifies for 4 elective CLPD points. Introduction and basic concepts Types of IPRs Main theories justifying IP protection The role of IP in economic development The Role of IP in innovation and creativity The globalization of IPRs protection International conventions Trade-Related Aspects of Intellectual Property Rights (TRIPS) and the World Trade Organization The GCC Cooperation in the field of IP protection Trademarks and copyright Definition and types of marks Scope of trade marks protection Registration procedures and rights conferred to trade mark owner Legal protection of trade marks Subject matter and conditions of copyright Types of protected works Financial and moral rights Fair use, duration of protection and legal protection for copyright Patents and trade secrets Patentable inventions and types of patents Registration process Ownership and rights conferred to patent owner Employer-employee inventions and legal protection for patents Definition of trade secrets and confidential information Elements of trade secrets Utilization of trade secrets commercially Legal protection of trade secrets Building a strong IP strategy and strategic management of IPRs Overview and basic concepts Understand your business and your IP needs IP audit and building the portfolio Onward licensing (licensing process and contracts) IP commercialization mechanisms and maximizing the benefits Practical steps to building a successful IP strategy IP valuation - your gateway to know how much your IP worth Assessment of the IP strategy for further success

Register on the Barista Training today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Barista Training is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Barista Training Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Barista Training, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Section 01: Introduction to Coffee Coffee Tree and Brief History of Coffee 00:15:00 Coffee Varieties 00:21:00 Coffee Growing and Harvest 00:06:00 Coffee Processing Methods 00:08:00 Coffee Grading 00:09:00 First, Second and Third Wave of Coffee 00:11:00 Coffee Defects and Sorting 00:06:00 Section 02: Espresso Machine Introduction to Espresso Machine 00:21:00 Manual, Semi-Auto and Full Auto (Volumetric) Espresso Machines 00:05:00 Working Principles of Volumetric Machines 00:02:00 Espresso Machines Boiler Types 00:05:00 Section 03: Espresso Grinder Espresso Grinder 00:10:00 Grinder Burrs 00:03:00 How to Adjust the Grinder? 00:03:00 Section 04: Introduction to Espresso & Espresso Mechanics Dosing 00:02:00 Distribution 00:02:00 Tamping and Tampers 00:13:00 Inserting the Portafilter 00:03:00 Starting the Pump 00:01:00 Flushing the Group and Cleaning the Portafilter 00:02:00 What is Naked Portafilter? Why is it used? 00:02:00 The Importance of Water 00:04:00 Section 05: Let's Wrap Up Understanding Time Concept and Practices 00:15:00 Under and Over Extraction 00:10:00 Chanelling 00:11:00 Section 06: Milk Frothing Steam Boiler and Steam Wand 00:04:00 Milk Selection 00:06:00 Milk Frothing and Heat Targets 00:17:00 Milk Splitting 00:04:00 The Difference Between Cappuccino and Latte Foam 00:05:00 Section 07: Latte Art First Half 00:05:00 Second Half 00:07:00 Maneuvers 00:04:00 Heart - Positioning and Cutting 00:01:00 Pouring Workouts 00:07:00 Section 08: Menu Espresso Variations 00:04:00 Espresso with Water 00:03:00 Espresso with Milk 00:15:00 Espresso with Ice 00:03:00 Section 09: Behind The Bar Coffee Bar Layout 00:07:00 Work Flow 00:06:00 Clothing & Apparel 00:04:00 Hygiene 00:03:00 Real Life Scenarios and Simulation 00:07:00 Espresso Machine Cleaning and Maintenance 00:11: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.

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins