2261 Maintenance courses delivered On Demand

This Oracle 11g PL/SQL Part 2 course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you'll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP). Upon successful completion of this course, you'll stand out from your competition while you're chasing your dream job! What Will I Learn? Prepare your environment Introducing Database Program Units Creating and Maintaining Stored Procedures & Functions Creating and Maintaining Packages Advanced Cursor Techniques Using System-Supplied Packages Creating and Maintaining Database Triggers Implementing System Event Triggers Requirements Familiarity with database and programming principles Who is the target audience? Application designers and developers Database administrators Business users and non-technical senior end users Introduction Introduction 00:03:00 Install Oracle XE 00:11:00 SQL Developer Installation 00:00: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 Course Certification

Looking to advance your career in electrical inspection and testing? Our comprehensive 2391-52 Inspection & Testing Online Course is designed for electricians, electrical engineers, and professionals in the field. Gain your City & Guilds qualification with our streamlined approach. Enrol now for just £210.00 and get access to expert guidance and study materials. Prepare at your own pace and excel in your final examinations!

Step into the realm of Security Management with our comprehensive course. Master risk analysis, physical and information security, legal frameworks, and the use of technology in security. Elevate your skills for a robust career in security management.

***Secure Your Future in Social Housing: Expert Knowledge Awaits*** According to a recent report by the National Housing Federation, there is a significant shortage of social housing in the UK, with an estimated need for 90,000 new social rented homes every year. This growing demand highlights the crucial role that social housing managers play in providing secure and affordable housing for countless individuals and families. This comprehensive Social Housing Management course equips you with the theoretical knowledge and understanding necessary to thrive in this rewarding career path. Learning Outcomes By the end of this course, you will be able to: Grasp the core principles of social housing and its role within the UK housing system. Effectively manage the tenant selection process, ensuring suitable placements and fostering positive landlord-tenant relationships. Implement strategies for rent collection and arrears management, maintaining financial stability within social housing properties. Oversee the maintenance, safety, and security of social housing, creating a comfortable and secure living environment for tenants. Encourage resident involvement and foster a sense of community within social housing developments. Identify and address anti-social behaviours, promoting a peaceful and harmonious living environment. This Social Housing Management course delves into six key modules, providing a well-rounded understanding of the field. Module 1: Introduction to Social Housing establishes the foundation, exploring the history, policy framework, and different types of social housing in the UK. Module 2: Tenant Selection and Tenant Management equips you with the skills to effectively assess applications, select suitable tenants, and manage tenancy agreements. Module 3: Managing Rental Income and Arrears explores strategies for rent collection, budgeting, and dealing with arrears in a professional and sensitive manner. Module 4: Maintenance, Safety, and Security of Social Housing equips you with the knowledge to oversee property maintenance, ensure adherence to safety regulations, and implement security measures. Module 5: Resident Involvement in Social Housing explores strategies for fostering resident engagement, building a sense of community, and addressing resident concerns. Module 6: Dealing with Anti-Social Behaviours equips you with the skills to identify and address anti-social behaviours, promoting a positive living environment for all residents. This course adopts a theoretical approach, providing a strong knowledge base for a successful career in social housing management. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This social housing course is ideal for: Individuals seeking a career change in the social housing sector. Those who aspire to become social housing managers. Housing professionals looking to enhance their theoretical knowledge. Volunteers or charity workers supporting social housing initiatives. University graduates interested in social housing policy and management. Anyone passionate about creating positive change in the housing sector. Requirements There are no specific prerequisites for this course. However, a basic understanding of housing issues in the UK and an interest in social housing management would be beneficial. Career path A career in social housing management offers a rewarding path to make a real difference in people's lives. Here are some potential career paths: Social Housing Letting Officer Social Housing Neighbourhood Manager Tenancy Sustainment Officer Anti-Social Behaviour Officer Resident Liaison Officer Social Housing Area Manager Housing Policy Officer (Social Housing) Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

🚚 Smooth Operations, Secure Docking: Loading Dock Safety Online Training Course! 🛡️ Are you ready to fortify the safety of your loading dock operations? Enroll in our Loading Dock Safety Online Training Course, a comprehensive program meticulously designed to equip you with the knowledge and strategies needed to ensure secure and efficient loading dock procedures. Join us on a journey where productivity meets safety, creating a workplace culture that values the well-being of everyone involved in the loading process. 🌟 Module 1: Introduction to Loading Dock Safety - Equipment and Maintenance Embark on your safety journey with Module 1, providing a comprehensive introduction to loading dock safety. Understand the importance of proper equipment usage and maintenance, laying the foundation for a proactive approach to safety in the loading dock area. 🚧 Module 2: Safe Forklift Operations and Hazardous Materials Handling Master the art of safe forklift operations and hazardous materials handling in Module 2. Explore techniques for operating forklifts securely, and understand best practices for handling hazardous materials during loading and unloading operations. 🔥 Module 3: Fall Protection and Fire Safety Optimize your loading dock environment with Module 3, dedicated to fall protection and fire safety. Learn to implement fall protection measures for elevated work areas and ensure fire safety protocols are in place, creating a secure loading dock environment. 📦 Module 4: Material Handling and Traffic Management Enhance material handling practices with Module 4, focusing on efficient techniques and traffic management strategies. Learn to streamline material handling procedures, manage traffic flow effectively, and prevent congestion for a smoother loading dock operation. 🚦 Module 5: Hazard Communication and Security Awareness Maintain a secure loading dock with Module 5, where you'll focus on hazard communication and security awareness. Explore strategies for effective communication about potential hazards and enhance security awareness for a vigilant loading dock team. 🌟 Module 6: Incident Reporting and Safety Culture Cap off your training with Module 6, where you'll delve into incident reporting and building a safety culture. Learn the importance of prompt incident reporting, foster a culture that prioritizes safety, and ensure that every team member is committed to a secure loading dock environment. 🚀 Why Choose Our Loading Dock Safety Online Training Course? Expert-Led Training: Learn from seasoned professionals and safety experts specializing in loading dock safety. Interactive Learning: Engage in practical simulations, real-world scenarios, and interactive exercises to apply theoretical knowledge. Customizable Training: Tailor the course to suit the specific needs of your industry or organization, ensuring maximum relevance. Productivity Booster: Establish a loading dock culture that prioritizes safety, fostering an environment where every team member contributes to the efficiency of operations. Don't let safety be a missing link in your loading dock operations! Enroll now in the Loading Dock Safety Online Training Course and empower your team with the knowledge and skills needed to navigate loading and unloading operations securely. Your journey to a safer loading dock begins here! 🚛✨🎓 Course Curriculum Module 1 Introduction to Loading Dock Safety Equipment and Maintenance Introduction to Loading Dock Safety Equipment and Maintenance 00:00 Module 2 Safe Forklift Operations and Hazardous Materials Handling Safe Forklift Operations and Hazardous Materials Handling 00:00 Module 3 Fall Protection and Fire Safety Fall Protection and Fire Safety 00:00 Module 4 Material Handling and Traffic Management Material Handling and Traffic Management 00:00 Module 5 Hazard Communication and Security Awareness Hazard Communication and Security Awareness 00:00 Module 6 Incident Reporting and Safety Culture Incident Reporting and Safety Culture 00:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

48-Hour Knowledge Knockdown! Prices were reduced like never before. Boost Your Career By Enrolling In This PAT Testing Bundle To Overcome Your Challenges! 06 in 1 PAT Testing Bundle Improve your knowledge and enhance your skills to succeed with this PAT testing bundle. This PAT testing bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow. This PAT Testing Bundle contains 6 of our premium courses for one discounted price: Course 01: Portable Appliance Testing (PAT) Course 02: Basic Electricity Course Course 03: Electricity and DC Circuit Analysis Course 04: Heating, Ventilation and Air Conditioning (HVAC) Technician Course 05: Domestic Appliances Repairing Course Course 06: Handyperson All the courses under this PAT Testing bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the PAT Testing bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want. With this comprehensive PAT testing bundle, you can achieve your dreams and train for your ideal career. This PAT testing bundle covers essential aspects in order to progress in your chosen career. Why prefer us? All-in-one package of 6 premium courses' PAT Testing bundle Get a free student ID card! (£10 postal charge will be applicable for international delivery.) Get instant access to this PAT testing course. Learn PAT Testing from anywhere in the world PAT Testing is affordable and simple to understand PAT Testing is entirely online, interactive lesson with voiceover audio Lifetime access to the PAT Testing course materials PAT Testing comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Our PAT Testing bundle courses consist of the following learning modules: Course 01: Portable Appliance Testing (PAT) Introduction to PAT Relevant Statutory Provisions for PAT Risk Assessment Reducing and Controlling Risks Electrical Units and Appliance Classification Initial Visual Examination Instruments for Testing and Equipment Inspection Electrical Installation Testing Safety Precautions in Electrical Testing Reporting and Record-keeping Assessment Process Once you have completed all the courses in the PAT Testing bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Electricians and Electrical Engineers Facility and Maintenance Managers Health and Safety Officers Small Business Owners and Managers Individuals responsible for workplace safety Career path This PAT Testing Bundle will improve your knowledge, allowing you to advance professionally and look for a variety of job prospects, including - PAT risk assessor Maintenance Staff Electrician Shop Owners These career prospects pay between £10,000 and £40,000 per year in the United Kingdom. Certificates CPDQS Digital certificate Digital certificate - Included CPDQS Hard copy certificate Hard copy certificate - £29 Upon passing the Bundle, you need to order to receive a Hard copy Certificate for each of the courses inside this bundle. If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Diploma in Housekeeping Management Description The Diploma in Housekeeping Management is designed to prepare you for a management role within the hospitality industry. Housekeeping covers all the essential areas of room maintenance and cleaning in a hotel, to ensure that guests feel welcome and at home. This CPD accredited online course will benefit anyone who wishes to work in the housekeeping department of a hotel. In addition, it is perfect for those who want to understand the basics of managing a household. This housekeeping management course will focus on essential housekeeping training duties, such as laundry operations, health and safety, cleaning. It will also cover lessons on staffing, budgeting and inventory control. Furthermore you will be able to look at the role hospitality plays in meeting the evolving demands of today's customer. As you complete each module, you will develop key skills in hotel housekeeping and will expand your knowledge of the procedures involved in this role. On course completion, you will receive a certificate of achievement which you can use to advance your career prospects in this field. 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 Diploma in Housekeeping Management Course for? The Diploma in Housekeeping Management course 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 course 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. Diploma in Housekeeping Management Introduction to Housekeeping 00:30:00 Housekeeping Principles 00:15:00 An Overview of Hotel Industry 00:18:00 Introduction to Hospitality Management 00:23:00 Management of Housekeeping, Engineering and Security Operations 00:27:00 Understanding Staff Duties 00:45:00 Cleaning 00:30:00 Inventory Control 00:45:00 Planning & Organising the Housekeeping Department 00:30:00 Understanding Budgeting 00:45:00 Carpet Maintenance 00:30:00 Wall, Ceiling and Window Cleaning and Maintenance 00:30:00 Staffing 00:45:00 Standard Operational Procedures in Hotel Housekeeping 00:15:00 Management of Service Quality in the Hospitality Industry 00:20:00 Laundry Operation in Hotel 00:30:00 Health and Safety 00:20:00 E-Hospitality and Technology 00:22:00 Customer Satisfaction 00:23:00 Mock Exam Mock Exam - Diploma in Housekeeping Management 00:20:00 Final Exam Final Exam - Diploma in Housekeeping Management 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00