1637 Courses delivered Online

This course will fully prepare you for virtually any Excel-related career path

Course Overview Microsoft Excel has brought a revolutionary change in the field of data management. It is one of the key skills that every employer looks for in a potential employee. The 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is designed to equip you with adequate expertise in Excel. This course is a golden opportunity to add a highly beneficial skill to your resume and impress your employers. In this 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course, you will receive a wide range of valuable tips to elevate your MS Excel skills. The course will show you the process of adding a link in the formula bar and adding multiple columns and rows within a blink. You will become skilled in quick calculations in the status bar. From the informative modules, you will identify the shortcut keys and learn to navigate between worksheets. The lessons will introduce you to the method of ZIP code format. You will understand how to move cell directions and convert numbers to text.  This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is packed with valuable information about MS Excel. So enroll in the course and become a proficient MS Excel user. Learning Outcomes Learn how to navigate between worksheets using shortcut keys Understand the process of creating a custom autofill list and importing data from webpages Build the skills to hide workbook elements Enrich your understanding of advanced transpose Grasp the techniques of moving cell directions and deleting data Know how to convert text to numbers Who is this course for? This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is for those who want to improve their Excel skills. 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 you have successfully completed the course, 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 the cost of £39 or in PDF format at the 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 50 MS Excel Tips to Upgrade your Excel Skill to next Level course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Administrative Assistant Data Analyst Accountants Financial Analyst Retail Store Manager Project Manager Business Analyst Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 Camera Tool 00:05:00 Add Line Break in Formula Bar 00:03:00 Advanced Copy-Paste using Office Clipboard 00:03:00 Navigation between Worksheets using Shortcut Keys 00:01:00 Flash Fill 00:02:00 Add Multiple Rows and Columns Quickly 00:02:00 Delete Blank Rows 00:03:00 Multi Level Row and Column Sorting 00:04:00 Add Sparklines 00:03:00 Paste Special - Transpose 00:03:00 Unit 03: Excel Productivity Tips - Part 2 Snap to Grid 00:03:00 Create Custom Auto fill List 00:06:00 Absolute Cell Reference 00:03:00 Import Data from Web page 00:04:00 Move Cell Direction 00:03:00 Delete Data using Mouse 00:02:00 Status Bar Quick Calculations 00:03:00 Link Text Boxes to Cell 00:04:00 Phone Number and ZIP Code Format 00:04:00 Speaking Cell 00:05:00 Unit 04: Excel Productivity Tips - Part 3 Invisible Text 00:03:00 Worksheet Grouping 00:04:00 Advanced Transpose 00:04:00 XLStart Folder 00:03:00 Use Slicers 00:05:00 Convert Text to Numbers 00:03:00 Hiding Workbook Elements 00:02:00 Useful Shortcut Keys 00:03:00 Sort data from Left to Right 00:03:00 Advanced Filter (Complex) 00:11:00 Unit 05: Excel Productivity Tips - Part 4 Email as PDF 00:02:00 Synchronous Scrolling 00:03:00 Quick Analysis of data within Excel 00:02:00 Fill blank cells with Value 00:03:00 Hidden Chart Source Data 00:03:00 Two more Shortcuts 00:03:00 Add Blank Rows 00:03:00 Custom views in Excel 00:06:00 EMBED Feature 00:04:00 Adding Country code in Mobile Numbers 00:04:00 Unit 05: Excel Productivity Tips - Part 5 Plot an Average Line to a Chart 00:04:00 3D Referencing 00:04:00 Extract Unique Values 00:03:00 Excel Array Formula 00:04:00 Forecast Sheet 00:04:00 Add Spin Controls in Excel 00:05:00 Move Data using Mouse 00:01:00 Add new entry in Auto Correct to use across Office Applications 00:05:00 Find Differences between Two Lists 00:02:00 Find formulas Quickly 00:02:00 Unit: 06 Wrap Up Thank You 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want You can illuminate your photography skills with our Flash photography course. In this course, you will learn to use external flashes to capture stunning images in any lighting condition. From light control to creating captivating compositions, you will learn every essential skill of Flash photography. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme What is flash photography Handling the photographic tools and equipment The skills required to take flash photography How to change the shapes and values of the strobes How to make the lighting decisions for taking better flash photos Locations, Challenges and Surfaces in photography About the lighting physics and the types of flashlights used in flash photos How can you get artistic with the light and effects How to use different kinds of flashlights for taking photographs Why Flash Photography Course right for you? This online flash photography course is designed to help anyone who wants to work as a photographer or improve their photographic skills. This course will help you make decisions regarding lighting and ambience to gain perfection in photography. This professional course will also help you manage location, surface, and tools as per the photoshoot requirements. This online flash photography course will also help you learn about the challenges you have to face while taking pictures and how you can overcome them with your knowledge. This course will also give you a comprehensive understanding of the equipment required to enhance your photographic skills. By the end of the course, you will have theoretical and practical knowledge of flash photography and also help you develop the skills and understanding required to become a professional photographer. Flash Photography Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Overview of The Course Course Overview in the Field In the Studio Overview About the Instructor Getting a Handle on The Equipment How Will You Create 'Wow' Images Flash and Strobe Safety Equipment and How it Changes Your Photography Equipment Overview External Flash Triggers The Best Photography Upgrade Making Lighting Decisions Flash Lighting Decisions Aperture Controls Portrait Lighting Types Light Position Names Quality and Modification Quality of Light Ambient Balance Color Balance Lighting modifiers Gobo and Snoots Locations, Surfaces, and Challenges Lighting for Texture Cross Lighting Backlight as Key Corner Lighting Handling Glasses Reflections Changing Shapes and The Value of Strobes Long Throw Hard Lighting Flashes vs Hot Always On Lighting Lighting Physics Distance Ratio Lighting Falloff Relative Light Sizes Stops of light relative to f-stops Flash Types and Tools Flash Sync Types Flash Theory - How Flashes Work Flash Trigger Types Artistry With Lighting Lighting Color, Artistic Control Reverse Engineering Lighting to Learn Concepts and Continuous Learning Lighting Experimentation Image Visualization Overlighting Lighting Folder Course Conclusions Final Remarks Who should take this course? This online flash photography course is ideal for the person willing to make a career in the field of photography. You can opt for this extensive course if you are looking to improve your job prospects and want to gain a deep understanding of photography. This online course is perfect for those who want to improve their photographic skills. Entry Requirements There are no academic entry requirements for this Flash Photography course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This flash photography online Course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Increase your Excel and Pivot Table skills and knowledge within hours which will get you noticed by top management and prospective employers. Become more productive at using Excel which will save you hours each day and eliminate stress at work. This course helps you learn about Pivot Tables that can be used for data analysis with a proper approach.

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

Overview This Microsoft Excel: Master Power Query course will unlock your full potential and will show you how to excel in a career in Microsoft Excel: Master Power Query. So upskill now and reach your full potential. Everything you need to get started in Microsoft Excel: Master Power Query is available in this course. Learning and progressing are the hallmarks of personal development. This Microsoft Excel: Master Power Query will quickly teach you the must-have skills needed to start in the relevant industry. In This Microsoft Excel: Master Power Query Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Microsoft Excel: Master Power Query skills to help you advance your career. Acquire a comprehensive understanding of various Microsoft Excel: Master Power Query topics and tips from industry experts. Learn in-demand Microsoft Excel: Master Power Query skills that are in high demand among UK employers, which will help you to kickstart your career. This Microsoft Excel: Master Power Query course covers everything you must know to stand against the tough competition in the Microsoft Excel: Master Power Query field.  The future is truly yours to seize with this Microsoft Excel: Master Power Query. Enrol today and complete the course to achieve a Microsoft Excel: Master Power Query certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Microsoft Excel: Master Power Query course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Microsoft Excel: Master Power Query course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Microsoft Excel: Master Power Query course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Microsoft Excel: Master Power Query is suitable for anyone aspiring to start a career in Microsoft Excel: Master Power Query; even if you are new to this and have no prior knowledge on Microsoft Excel: Master Power Query, this course is going to be very easy for you to understand.  And if you are already working in the Microsoft Excel: Master Power Query field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Microsoft Excel: Master Power Query course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Microsoft Excel: Master Power Query course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Microsoft Excel: Master Power Query course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Microsoft Excel: Master Power Query course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Microsoft Excel: Master Power Query Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

Tulip flower art class painting larger scale flowers using impressionist techniques in acrylic paint.

This Course at a Glance Understand the basics of Control of Substances Hazardous to Health (COSHH) Gain knowledge about certain regulations such as the Classification, Labelling and Packaging Regulation (CLP) Identify hazardous substances in the workplace and understand the need to control hazards Understand your responsibility as an employer to protect the health of your employee Assess different types of exposure and know what constitutes it Understand the legal duties and responsibilities of an employer entrusted by certain legislations Understand how to conduct effective COSHH risk assessment within your workplace Identify appropriate measures to control the exposure to hazardous substances Learn how to implement Occupational Exposure Limit Values (OELVs) and Workplace Exposure Limits (WELs) Learn to review risk assessments and ensure regular maintenance of control measures Understand the importance of proper planning to deal with emergencies Control of Substances Hazardous to Health (COSHH) Course Overview This COSHH training course covers the basics of Control of Substances Hazardous to Health (COSHH) regulations that employers are required to abide by to protect themselves and their employees from health risks caused by hazardous substances. It is aimed at workers exposed to hazardous substances at work, as well as managers assigned with the responsibility of ensuring the safety of these people. This course is designed to equip you with the essential skills and knowledge to effectively carry out a regular COSHH risk assessment to identify hazardous substances used within your workplace. This course will also provide you with an overview of the available legislation relating to the Control of Substances Hazardous to Health (COSHH) that must be obeyed to ensure a high level of protection for human health and the environment from the use of chemicals. Hazardous substances are potentially hazardous to the health of you and your workers working in any environment. Even the slightest exposure to certain hazardous substances can result in life-threatening injuries and illnesses with no cure. The International Labour Organisation estimates that some 651,279 deaths are caused in a year by exposure to hazardous substances at work. This Control of Substances Hazardous to Health (COSHH) Course Online will train your employees to scale down the number of deaths or prevent mishaps from occurring. Upon successful completion of this Coshh Training course, you will be able to conduct an effective COSHH risk assessment and gain knowledge about various control and preventive measures that can be implemented to protect your employees from potentially life-threatening situations. Who should take this course? This COSHH Training Course is suitable for: Any employee exposed to hazardous substances on a regular basis Owners of any company exposed to hazardous substance Anyone responsible for supervising and ensuring the safety of employees Anyone interested to learn about safety protocols relating to the handling of hazardous substances Whether you are the owner of any company that deals with hazardous substances on a regular basis looking to ensure the safety of your employees or anyone simply looking to gain extensive knowledge about Control of Substances Hazardous to Health (COSHH), this course will set you up with the appropriate skills and knowledge to control and prevent the hazardous substance from causing an adverse effect on health . Entry Requirements There are no academic entry requirements for this Control of Substances Hazardous to Health (COSHH) Course Online course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This COSHH Training Course assesses learners through multiple-choice questions (MCQs). Upon successful completion of each module, learners must answer MCQs to step into the next module. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 75%. Course Curriculum Module 1: Introducing COSHH Module 2: Different Types of Hazard Module 3: Different Types of Exposure Module 4: Regulations and Approved Labelling Module 5: Assessing COSHH Risks Module 6: The Risk Assessment in Practice Module 7: Exposure Control Module 8: Staying in Control Module 9: Training and Emergency Planning Module 10: Course Summary Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Advanced SQL Programming (TTSQL005) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for application programmers who need to write embedded SQL COBOL or PL/I programs in either a DB2 9 or DB2 10 for z/OS environment. Overview Incorporate static SQL statements in an application program Prepare the program for execution Validate execution results are correct Produce code to support multiple rows being returned from the database manager using cursors Identify considerations regarding units of work, concurrency, and restart of programs Identify differences between static and dynamic SQL Provide test data for applications Discuss program and DB2 options relative to performance of static SQL This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution. CV720G;CF82G;DB2 Concepts Identify DB2 family products Explain DB2 workstation component functions Identify DB2 objects Identify the key differences between static SQL and other application alternatives for accessing DB2 data Program Structure I Embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs Effectively communicate with DB2 when processing NULL values and determining success of statement execution Demonstrate use of DB2 coding aids Code CONNECT statements within an application program Identify connection types and impacts on a unit of work Program for the Call Attach Facility (CAF) Program Preparation Identify the additional steps necessary to prepare a program that contains embedded SQL for execution Describe the functions of the DB2 PRECOMPILE and BIND processes Describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements Program Structure II Use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs Issue positioned UPDATE and DELETE statements Identify how scrollable cursors can be used Recovery and Locking Concepts Define a unit of recovery Identify the basic locking strategies used by DB2 Dynamic SQL Introduction Describe the difference between static and dynamic SQL List the types of dynamic statements Code dynamic SQL in a program Managing Test Data Identify methods to insert data into a table Use the LOAD or IMPORT utility Identify the purpose of the RUNSTATS utility Identify the purpose of the REORG utility Performance Considerations Use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts Identify the access paths available to DB2 List common causes of deadlocks and avoid such causes when possible Use the EXPLAIN tools as aids to develop applications that emphasize performance Additional course details: Nexus Humans CV722 IBM DB2 11 for z/OS Application Programming Workshop training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CV722 IBM DB2 11 for z/OS Application Programming Workshop course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.