2530 Maintenance courses in Cardiff delivered Online

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

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.

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!

***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

Explore the intricacies of laboratory safety with our comprehensive course, 'Laboratory Safety: Protocols & Best Practices.' Gain expertise in risk assessment, PPE usage, chemical safety, fire and electrical safety, equipment handling, and fostering a safety culture. Elevate your understanding of best practices, ensuring a secure laboratory environment. Join us to empower yourself with the knowledge and skills to champion safety in the pursuit of groundbreaking research. Enroll now for a transformative learning experience!

Take steps to become an experienced facilities manager and ensure that buildings and their services meet the needs of people that work in them, with the Facilities Management. In this comprehensive course, you will receive practical training in all areas of facilities management, from exploring the facilities life cycle to inventory management. Our experienced instructor will teach you everything you need to know about maintaining the working environment and providing a quality service.  By the end of this training program, you will be equipped with the practical skills and knowledge to manage facilities of all types, including hospitals, retail stores, hotels and office buildings. Learning Objectives Understand the purpose, nature and scope of facilities management Know the proper use of facilities management terms and definitions Learn about sustainability in facilities management, sustainable developments and trends Demonstrate an in-depth understanding of the facilities life cycle, from design to construction and maintenance Familiarise with the role of a facilities operations manager Develop your understanding of the fundamental steps in inventory management and waste management Understand how to evaluate life-cycle costs in facilities management Learn about quality control, inspections, reporting and record-keeping Develop your project management skills and demonstrate an understanding of a project's life cycle Who is this Course for? This Diploma in Facilities Management is ideal for aspiring facilities managers and existing managers who want to update their skills and knowledge. Our online courses are specially designed for distance learning, offering flexible virtual classroom modules that can be studied on a full-time or part-time basis. Increase your chances of working for a top organisation and gain a Certificate of Achievement to take your career to the next level. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the course. Good understanding of English language, numeracy and ICT are required to attend this course. Certificate of Completion from Course Gate At the successful completion of the course, the learners may order the Certificate of Completion from Course Gate (soft copy) by paying only £2. For the Printed hard copy of the certificate, the learners have to pay £9. There is an additional £10 delivery charge for international students. Career path This advanced diploma in Facilities Management provides a stepping stone to work your way up to becoming a successful facilities manager. Career opportunities and roles in the field include: Facilities Manager Facilities Coordinator Facilities Assistant Course Curriculum Module 1: Facility Management Introduction to Facility Management 00:20:00 Terms and Definitions 00:05:00 Assessment Module 1 Module 01 Final Quiz Exam - Facilities Management 00:10:00 Module 2: Facilities Management in the Workplace Workplace Facilities 00:35:00 Assessment Module 2 Module 02 Final Quiz Exam - Facilities Management 00:10:00 Module 3: Sustainable Development and Facilities Management Sustainable Development and Facilities Management 00:30:00 Facilities Life Cycle 00:15:00 Assessment Module 3 Module 03 Final Quiz Exam - Facilities Management 00:10:00 Module 4: Facility Operations Operations of Facilities 00:25:00 Assessment Module 4 Module 04 Final Quiz Exam - Facilities Management 00:10:00 Module 5: Operations and Maintenance Operations and Maintenance 00:30:00 Assessment Module 5 Module 05 Final Quiz Exam - Facilities Management 00:10:00 Module 6: Facilities Maintenance Planning, Budgeting and Method Facilities Maintenance Planning 00:10:00 Maintenance Costs, Finance and Methods 00:10:00 Factors Affecting Maintenance 00:10:00 Assessment Module 6 Module 06 Final Quiz Exam - Facilities Management 00:10:00 Module 7: Performance and Installations Management Performance Management 00:10:00 Installations Management 00:20:00 Assessment Module 7 Module 07 Final Quiz Exam - Facilities Management 00:10:00 Module 8: Project Management Project Management 00:30:00 Assessment Module 8 Module 08 Final Quiz Exam - Facilities Management 00:10:00 Module 9: HR Management Human Resource Management 00:30:00 Assessment Module 9 Module 09 Final Quiz Exam - Facilities Management 00:10:00 Module 10: Real Estate Management, Client Delivery Models & Outsourcing Real Estate 00:30:00 Client Delivery Models 00:05:00 Outsourcing of Services or In-House Staff 00:15:00 Assessment Module 10 Module 10 Final Quiz Exam - Facilities Management 00:10:00 Order Your Certificate