2260 Maintenance courses delivered On Demand

Onboarding Tools Certification Onboarding is a critical piece of the enrollment interaction. Everybody, paying little mind to job or industry, should go through the onboarding cycle. These projects are more top to bottom than ordinary instructional classes, giving your new staff individuals important data about your organization, their part inside it and the corporate culture. Studies show that organizations that offer these projects have more significant levels of representative maintenance and fulfillment. Numerous HR offices across the UK are embracing these projects consequently, to build the odds that new workers see a positive outcome from the beginning. This course expounds on the onboarding devices that your association needs, to adequately and productively deal with your new workers. It starts by giving you a concise outline of the idea of onboarding, remembering a definition and its significance for the working environment. Then, it covers the instruments that you should use for accepting and conveying data to your new staff individuals. The devices that you can use to keep tabs on their development are additionally talked about in detail. At long last, we will give you the data that you need, to pick the best onboarding instruments for your association's exceptional requirements. You will Learn: The job of innovation in How you can utilize advanced structures to make the onboarding cycle simpler Data with respect to learning the board frameworks and how they can be useful Instructions to utilize agendas and Excel to follow progress Why you ought not zero in on cost Why you need to consider how regularly these onboarding programs are probably going to be utilized Advantages of taking this Course: Seeing more about the significance of Why and how to utilize recordings in your onboarding Figuring out how RACI can be applied to the onboarding cycle What explicit organization needs you ought to consider while picking onboarding apparatuses Seeing precisely what onboarding is and how it applies to each industry

Introduction to Computer & Building PC Overview Ever felt like your computer is a mystery box? Ever wished you could build your own, super-powered machine, exactly the way you want it? This 'Introduction to Computer & Building PC' course is your key to tech freedom! Forget boring, pre-built computers. This course dives deep into the cool stuff inside them, teaching you what everything does and how it works together. No geek talk, just clear explanations and fun exercises. By the end, you'll be a whiz at picking the right parts and putting them together like a pro, building a PC that's perfect for you, whether you're a gamer, a creative whizz, or just someone who wants a computer that works the way you do. This course is made for people who are new to computers, so don't worry if you're starting from scratch. With easy-to-follow videos, interactive quizzes, and friendly experts to guide you, you'll learn at your own pace and have a blast doing it. Imagine the satisfaction of building your own computer and the endless possibilities it unlocks! Learning Outcomes: Master the key terminology associated with computer hardware and software, empowering you to make informed decisions and confidently navigate the tech world. Gain the practical skills to meticulously assemble your own PC, from selecting compatible parts to carefully installing them within the case. Craft a machine that perfectly aligns with your needs and budget, whether you're a gamer, a creative professional, or simply a tech enthusiast. Learn how to optimize your PC's configuration for maximum speed and efficiency, ensuring a seamless and enjoyable computing experience. Equip yourself with the knowledge to identify and resolve common computer issues, maintaining your machine in top condition. Why You Should Choose Introduction to Computer & Building PC Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Introduction to Computer & Building PC is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Introduction to Computer & Building PC 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' 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. Introduction to Computer & Building PC Module 01: Introduction to Computer & Building PC Introduction to Computer & Building PC 00:17:00 Module 02: Overview of Hardware and Parts Overview of Hardware and Parts 00:27:00 Module 03: Building the Computer Building the Computer 00:25:00 Module 04: Input and Output Devices Input and Output Devices 00:22:00 Module 05: Software Installation Software Installation 00:35:00 Module 06: Computer Networking Computer Networking 00:21:00 Module 07: Building a Gaming PC Building a Gaming PC 00:19:00 Module 08: Maintenance of Computers Maintenance of Computers 00:19:00

The UK's green-fingered are in high demand! The gardening industry is expected to grow by a healthy 11% by 2027, creating over 21,000 new jobs. Whether you prefer the satisfaction of landscaping dream gardens (average UK salary of £26,000) or the bounty of selling homegrown produce at farmers markets (estimated annual revenue of £6,000-£20,000), there's a lucrative path for you. Dive into the flourishing world of garden design, cultivate your expertise with the Level 5 Diploma, and watch your passion blossom into a thriving and sustainable career. With the growing focus on eco-friendly living and locally sourced food, the future of gardening is bright, promising a harvest of both personal fulfillment and financial success. So, get your hands dirty, embrace the green wave, and let your gardening passion bloom into a rewarding future! Learning Outcome of the Gardening Course Master key design principles of gardening. Craft functional & beautiful garden spaces. Apply practical skills for successful gardens. Design sustainable & eco-friendly gardens. Communicate design ideas clearly & effectively. Uphold professional ethics in the gardening field. Solve gardening problems & adapt designs with creativity. Level 5 Diploma in Gardening Module 01: Introduction to Garden Design Module 02: The Role of the Garden Designer Module 03: The Basic Principles of Garden Design Module 04: Components of Garden Design Module 05: Garden Design Process Module 06: Designing a Rain Garden Module 07: Essential Tools & Machinery Module 08: Plant Selection and Material Guide Module 09: Garden Maintenance Module 10: Costing and Estimation Certificate of Achievement 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 Free 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. Who is this course for? Level 5 Diploma in Gardening Garden Design Consultant Landscape Architect Horticultural Specialist Garden Planning Analyst Green Infrastructure Planner Environmental Landscape Designer Requirements Level 5 Diploma in Gardening To enrol in this Level 5 Diploma in Gardening, Purchasing & Procurement course, all you need is a basic understanding of the English Language and an internet connection. Career path Level 5 Diploma in Gardening Professional Gardener/Landscaper: £18,000 to £35,000 per year Garden Center Manager: £25,000 to £45,000 per year Horticultural Therapist: £20,000 to £35,000 per year Arborist/Tree Surgeon: £20,000 to £40,000 per year Parks and Recreation Officer: £20,000 to £35,000 per year Environmental Consultant: £25,000 to £45,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - £9.99 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Overview The food industry is one of the biggest and most profitable sectors in the United Kingdom. Grasp the basic skills and ability required to build a career in this field with our Training in Kitchen Management online program.  This course includes 11 highly informative and engaging modules. Through these modules, you will grasp the basics of Kitchen management. Here, you will receive detailed lectures on Food Safety Management. You will also grasp the skills required for planning menu, cost control and staff management. In addition, the course will ensure you have a good grasp of customer management and kitchen supervision. After the completion of the course you will acquire a certificate of achievement. This certificate will help you prove your expertise in this area and boost your employability in the food industry. Join now! Course Preview Learning Outcomes Recognise the main principles of Food Safety Management Enhance your understanding of contamination and poison control Learn the skills required to ensure kitchen safety Develop your expertise in cost control, purchasing and inventory management Grasp the core strategies of customer management and staff management Acquire the adequate competence required for kitchen supervision Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Food Safety Management Cost Control Customer Management Staff Management Who Should Take this Training in Kitchen Management Course? Whether you're an existing practitioner or an aspiring professional, this course will enhance your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Training in Kitchen Management course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Training in Kitchen Management Certification After completing and passing the Training in Kitchen Management course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Training in Kitchen Management course will equip you with effective skills and abilities and help you explore career paths such as  Chef Catering Manager Restaurant Manager Food and Beverage Supervisor Module 01: Introduction to Kitchen Manager Introduction to Kitchen Manager 00:15:00 Module 02: Contamination and Poisoning Control Contamination and Poison Control 00:25:00 Module 03: Food Safety Management Food Safety Management 00:35:00 Module 04: Hygiene Maintenance Hygiene Maintenance 00:30:00 Module 05: Kitchen Safety Kitchen Safety 00:15:00 Module 06: Cost Control Cost Control in Kitchen Management 00:20:00 Module 07: Menu Planning Menu Planning1 00:25:00 Module 08: Kitchen Supervision Kitchen Supervision 00:30:00 Module 09: Purchasing and Inventory Management Purchasing and Inventory Management 00:15:00 Module 10: Customer Management Customer Management 00:25:00 Module 11: Staff Management Staff Management 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

[vc_row][vc_column][vc_column_text] Description: Want to avoid falling victim to security glitches that may compromise you or your colleagues', clients', family's and business's security? Protect your sensitive online information from cyber threats with this risk management course. This Diploma in Cyber Security Course is the ultimate guide to internet security, designed to help you safeguard your computer's system from malware, viruses, hackers and identity thieves. With the rapid growth of internet and information technology, the risks that come with storing sensitive data online is also increasing. Understanding how cybersecurity works is the first step to protecting yourself against cybercriminals. Learn how to safeguard your data, personal information and financial credentials from high-profile cyber attacks. Discover how to prevent hackers from stealing your information, money and identity that could damage your reputation and cause your financial status to be at risk. You will also familiarise with common scams and how to spot them. Key topics explored include online banking, child safety, virus and password protection. Who is the course for? Professionals who are using the internet in their daily life especially for their professions. Everyone who wants to protect themselves from harm the internet might cause it. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email.   Career Path: The Diploma in Internet Security Management will be very beneficial and helpful, especially to: Businessmen Parents Professionals Students And Everyone who Uses Internet and Computers! [/vc_column_text][/vc_column][/vc_row] Introduction Introduction 00:30:00 Child Safety Online Child Safety Online 01:00:00 Secure Payment Sites Secure Payment Sites 01:00:00 Online Banking Online Banking 00:30:00 How To Keep Your Password Safe How To Keep Your Password Safe 00:30:00 Common Scams Common Scams 01:00:00 How I Got Pharmed How I Got Pharmed 01:00:00 Virus Protection Virus Protection 01:00:00 Self Maintenance Self Maintenance 00:30:00 Personal Information Online Personal Information Online 01:00:00 Is The Internet Safe? Is The Internet Safe? 00:30:00 Recommended Reading Recommended Reading: Diploma in Cyber Security 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Diploma in Cyber Security 00:20:00 Final Exam Final Exam- Diploma in Cyber Security 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support

🛡️ Protect Yourself, Protect Others! Unveiling the Power of Personal Protective Equipment Course! 🛡️ Are you ready to safeguard yourself and those around you? Dive into the world of Personal Protective Equipment (PPE) and fortify your safety arsenal with our comprehensive course! 🚀 In today's fast-paced world, where unforeseen hazards lurk around every corner, the importance of PPE cannot be overstated. Whether you're working in healthcare, construction, manufacturing, or any other industry, equipping yourself with the knowledge of PPE is crucial for maintaining safety and preventing potential harm. Our course is your gateway to mastering the art of protection!   Benefits Galore! 🌟 🔍 Enhanced Safety Awareness: Gain a deep understanding of various types of PPE and how they shield you from different hazards. Acquire the knowledge needed to assess risks and select the most suitable protective gear. 📚 Empowering Knowledge: Arm yourself with invaluable information on the proper usage, maintenance, and disposal of PPE. Learn the best practices to maximize effectiveness and longevity, ensuring you stay safe in any situation. 💼 Professional Advancement: Stand out in your field by demonstrating your commitment to safety. Employers value individuals who prioritize the well-being of themselves and their colleagues, making you an indispensable asset to any team. 💡 Peace of Mind: Equip yourself with the confidence to tackle any task knowing you have the right protection in place. From head to toe, our course equips you with the knowledge to mitigate risks and handle challenges with ease.   Who is this for? 🎯 👩‍️ Healthcare Professionals: Nurses, doctors, and healthcare workers will benefit immensely from understanding the intricacies of PPE, especially in high-risk environments such as hospitals and clinics. 👷‍️ Construction Workers: From hard hats to safety glasses, construction sites are filled with potential dangers. Equip yourself with the knowledge to navigate these hazards safely and effectively. 🏭 Manufacturing Personnel: Whether operating heavy machinery or handling hazardous materials, knowledge of PPE is essential for maintaining a safe working environment in manufacturing facilities. 👨‍🔬 Laboratory Technicians: Protect yourself from chemical spills, biohazards, and other laboratory risks by mastering the use of appropriate PPE tailored to the laboratory setting.   Career Path 🚀 Completing our Personal Protective Equipment course opens doors to a myriad of career opportunities across various industries: 👨‍🔬 Occupational Health and Safety Specialist: Ensure workplace safety by advising employers on the proper use of PPE and implementing safety protocols. 👷‍️ Safety Coordinator: Oversee safety procedures and PPE compliance within organizations to minimize accidents and injuries. 👩‍️ Infection Control Practitioner: Play a crucial role in preventing the spread of infectious diseases by implementing PPE protocols in healthcare settings. 🏭 Industrial Hygienist: Assess workplace environments for potential hazards and recommend PPE solutions to protect workers from harm.   With the demand for safety-conscious professionals on the rise, now is the perfect time to equip yourself with the skills and knowledge needed to thrive in the field of occupational safety and health. Don't wait until it's too late! Enroll in our Personal Protective Equipment course today and embark on a journey towards a safer, brighter future! 🌟 Course Curriculum Module 1 What is Personal Protective Equipment What is Personal Protective Equipment 00:00 Module 2 Types of PPE Types of PPE 00:00 Module 3 Assessing Hazards and Determining PPE Needs Assessing Hazards and Determining PPE Needs 00:00 Module 4 PPE Regulations and Standards PPE Regulations and Standards 00:00 Module 5 Emergency Situations and PPE Emergency Situations and PPE 00:00 Module 6 PPE for Specific Industries PPE for Specific Industries 00:00 Module 7 Donning and Doffing PPE Donning and Doffing PPE 00:00 Module 8 PPE for Children PPE for Children 00:00 Module 9 Maintenance and Replacement of PPE Maintenance and Replacement of PPE 00:00

Facilities Management Online This unique Facilities Management offers a thorough introduction to one of the world's most in-demand specialized professions. Learn about the operations and goals of facilities management at an advanced level, gaining the skills and information you will need to pursue a fulfilling career for the rest of your life. The Facilities Management course content teaches numerous interconnected disciplines that create facilities management, with no prior knowledge or expertise required. This Facilities Management course ensures that an organization has the resources and infrastructure to fulfil its tasks successfully and efficiently, both in the public and private sectors. The Facilities Manager is in charge of everything from building maintenance and renovations to contract management, security, and sustainability. Facilities Management is a dynamic and demanding field, which can also be quite rewarding for successful candidates. Courses are included in this Facilities Management Course. Course 1: Facilities Management - Course Course 2: Operations Management Course 3: Office Management Course 4: Leadership & Management Course 5: Level 1 Certificate in Well-being Course 6: Level 5 Diploma in Leadership and Management for Residential Childcare Course 7: Level 5 Diploma in Risk Management Course 8: Level 7 Business Management Course 9: Time Management Course 10: Equality and Diversity Course 11: Level 7 Project Management Course 12: Level 5 Diploma in Business Analysis Course 13: HR and Payroll Management Course 14: Level 3 Business Administration Course 15: Level 4 Logistics Management [ Note: Free PDF certificate as soon as completing the Facilities Management course] Facilities Management Detailed course curriculum of Facilities Management This Facilities Management course consists of 12 modules. Assessment Method After completing each module of this Facilities Management Course, you will find automated MCQ quizzes. Certification After completing the MCQ/Assignment assessment for this Facilities Management Course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Facilities Management This Facilities Management course is perfect for - Students Fresh graduates Job Seekers Anyone interested in business analysis People who are already employed in related fields and wish to improve their knowledge and abilities. Requirements Facilities Management There are no specific requirements for this Facilities Management Course because it does not require any advanced knowledge or skills. Career path Facilities Management The Facilities Management Course could prove instrumental in taking your career to the next level. Typical job titles and roles that fall within the field of FM.

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 This course will teach you practical strategies to declutter your workspace, manage paperwork and boost productivity. In this course, you will learn effective filing systems, digital organisation techniques and time-saving methods to keep your documents in order. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Learn how to build a plan to get started Know what to keep in paper organisation Understand how to let go of difficult papers Know how it is like to go paperless and the application recommendations Learn the keys to successful maintenance Know how to deal with receipts Learn how to create a system Understand how to declutter step by step Know the techniques to start and finish successful projects Discover the industry's best practices to follow for maximising desirable results Why Paper Organisation Course right for you? This extensive course is beneficial for those who want to learn how to quickly organise research papers and team the paper clutter. You will learn the benefits of taming the paper clutter, what essential papers to keep, building a plan, and let go of difficult papers. This interactive course will educate you on the steps of decluttering, organising and finding homes and keys to successful maintenance. You will discover real-life examples such as steps to deal with receipts, personal finances, home office, and personal finances. By the end of the course, you will have a clear understanding of paper clutter, its benefits, steps of decluttering, and the process to organise and find homes. Paper Organisation 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 About The Course Tame the Paper Clutter Introduction Team The Paper Clutter Forms of Paper Clutter Benefits of Taming The Paper Clutter Building a Plan to Get Started What to Keep Letting Go of Difficult Papers Steps of Decluttering Organizing and Finding Homes Going Paperless and Application Recommendations Keys to Successful Maintenance Real Life Example Decluttering Step by Step Home Office's Project Dealing with Receipts Personal Finances Business Month Closure Creating a System Home Office Next Steps Next Steps Who should take this course? This comprehensive paper organisation course is suitable for those who want to gain in-depth knowledge in paper cluttering, its benefits, and decluttering. It is ideal for those who want to have control over their paper or wish to go paperless. Entry Requirements There are no academic entry requirements for this paper organisation 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 paper organisation 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 could 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

Description The Oracle Database server composes PL/SQL units and stores it in the database. Mainly, PL/SQL functions to hold to hold SQL declaration within its sentence structure. Do you want to know more about SL/SQL function? How does it bring optimal proficiency in 'procedural language'? if so, take a look at the Oracle 11g PL/SQL Intermediate course. It will assist you in understanding all you need to know about Oracle 11g PL/SQL. The course designs to help the learners to know its function incorporation with different strings, numbers, table row record, and error management. The Oracle 11g PL/SQL Intermediate course teaches the fundamental form and structure of the program unit saved within database, creating and managing stored methods, functions, packaged programs, and database prompts. Its contents aim to take you further in your quest to teach the effective methods including variables and cursor expressions. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Oracle 11g PL/SQL Intermediate 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 Oracle 11g PL/SQL Intermediate 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. Introduction Introduction FREE 00:03:00 Preparing Your Environment Install Oracle XE 00:11:00 SQL Developer Installation 00:20:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00