2530 Maintenance courses in Cardiff delivered Online

Abrasive Wheels Approved Online Training

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

Level 5 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

Crafting Educational Excellence: Education Management Course Embark on a transformative journey into the heart of educational leadership with our 'Education Management' course. Beyond the traditional realm of administration, this course is a symphony of knowledge, blending the art and science of fostering an exceptional learning environment. Dive into the core modules, where you'll unravel the intricacies of educational administration and learn the nuanced skills required for effective school management. From cultivating professional development opportunities for teaching assistants to ensuring the highest standards of teaching for pupils with special educational needs (SEN), this course is a beacon of educational excellence. Learning Outcomes Master the principles of educational administration and management. Develop strategies for creating and maintaining a positive school culture. Implement high-quality teaching methodologies for pupils with SEN. Acquire skills in workplace development and stress management. Safeguard students through comprehensive knowledge of safety and maintenance protocols. Why choose this Education Management course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Education Management course for? Aspiring and current educational administrators. Teaching assistants seeking professional growth. Individuals interested in school culture and leadership. Education professionals aiming for self-improvement. Anyone passionate about fostering a safe and positive learning environment . Career path School Administrator: £25,000 - £40,000 Educational Manager: £30,000 - £50,000 Special Education Coordinator: £25,000 - £40,000 Curriculum Developer: £30,000 - £45,000 Education Consultant: £35,000 - £55,000 School Safety Officer: £25,000 - £35,000 Prerequisites This Education Management course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Education Management course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Educational Administration and Management Educational Administration and Management 00:11:00 Module 02: Introduction to School Administration Introduction to School Administration 00:12:00 Module 03: Professional Developments for a TA Professional Developments for a TA 00:29:00 Module 04: Providing the Best Learning Environment Providing the Best Learning Environment 00:20:00 Module 05: Creating and Maintaining a School Culture Creating and Maintaining a School Culture 00:13:00 Module 06: SEN Support SEN Support 00:12:00 Module 07: High Quality Teaching for Pupils with SEN High Quality Teaching for Pupils with SEN 00:09:00 Module 08: Workplace Development Workplace Development 00:12:00 Module 09: Safeguarding Students Safeguarding Students 00:14:00 Module 10: Safety and Maintenance As an Administrator Safety and Maintenance As an Administrator 00:08:00 Module 11: Self-Management and Dealing with Stress Self-Management and Dealing with Stress 00:13:00

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

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

Overview According to the Health and Safety Executive (HSE), improper handling or inadequate equipment is responsible for over 30% of the workplace accidents reported yearly. The PUWER course offers an extensive curriculum that covers everything from the selection and conformity of work equipment to its safe functionality, monitoring, evaluation, maintenance, and training. This in-depth knowledge ensures that professionals are well-equipped to navigate the complexities of work equipment usage, ensuring safety and compliance.But PUWER doesn't stop at safe functionality. It is recognising the dynamic nature of the equipment and the environments. The course dedicates extensive modules to monitoring and evaluating work equipment. In essence, the PUWER course isn't just about regulations-it's about understanding the life cycle of work equipment, the human-machine interface, and the overarching ethos of safety and efficiency in the industrial workspace. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this 'PUWER'. It is available to all students, of all academic backgrounds. Requirements Our 'PUWER' is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 5 sections • 5 lectures • 02:31:00 total length •Provision and Use of Work Equipment Regulations: 00:48:00 •Selection and Conformity of Work Equipment: 00:25:00 •Safe Functionality of Work Equipment: 00:36:00 •Monitoring and Evaluation of Work Equipment: 00:28:00 •Maintenance and Training of Work Equipment: 00:14:00

Are you ready to Hop on a journey into the future of gardening? Picture this: a lush, vibrant oasis flourishing within the confines of your own home or greenhouse. Dive deep into the realm of hydroponics, where soil is but a memory and plants thrive in nutrient-rich waters. Our comprehensive course opens the gates to this fascinating world, guiding you through each stage with expert knowledge and hands-on techniques. Key Features: CPD Certified Developed by Specialist Lifetime Access Delve into the heart of hydroponic culture, discovering the intricate systems that sustain plant life without the need for traditional soil. From understanding plant nutrition to mastering the art of equipment selection, each module equips you with essential skills to nurture your botanical wonders. Dive into the realm of rooting media, seedling care, and plant maintenance, ensuring your green companions reach their full potential. Encounter and overcome nutritional challenges with confidence, learning to troubleshoot and adapt as you cultivate your own green paradise. And with a special focus on greenhouse growing, you'll unlock the secrets to creating thriving ecosystems in controlled environments, harnessing the power of nature to transform your surroundings into a haven of abundance. Course Curriculum Module 01: Introduction to Hydroponics Module 02: Systems of hydroponic culture Module 03: Plant Nutrition Module 04: Equipment Module 05: Rooting media Module 06: Seedling and Plant Maintenance Module 07: Nutritional Problems and Solutions in Plant Module 08: Growing in Greenhouses Learning Outcomes: Understand fundamentals of hydroponic gardening for efficient plant cultivation. Identify various hydroponic systems and their suitability for different plants. Analyze plant nutrition requirements and implement appropriate feeding schedules. Select and utilize equipment necessary for successful hydroponic gardening operations. Explore different rooting media options and their impact on plant growth. Demonstrate proficiency in greenhouse hydroponic cultivation techniques for optimal yields. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Beginners interested in innovative gardening techniques. Horticulture enthusiasts seeking advanced cultivation methods. Farmers aiming to enhance crop productivity and sustainability. Urban dwellers keen on indoor gardening solutions. Students pursuing agricultural or botanical studies. Career path Hydroponic Farm Manager Greenhouse Technician Agricultural Research Assistant Urban Agriculture Consultant Hydroponic Equipment Sales Representative Botanical Garden Curator Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

🛠️ Forge a Healthier Workplace: Ergonomics in Industrial Facilities Training Course! 🌐 Are you ready to revolutionize the well-being of your workforce and enhance productivity in industrial settings? Enroll in our Ergonomics in Industrial Facilities Training Course, a comprehensive program crafted to identify, assess, and address ergonomic risk factors unique to industrial environments. Join us on a journey where ergonomic excellence meets industrial innovation. 🌟 Module 1: Introduction to Identifying and Assessing Ergonomic Risk Factors Embark on your journey with Module 1, providing a comprehensive introduction to identifying and assessing ergonomic risk factors in industrial facilities. Develop the skills to recognize potential hazards, conduct thorough assessments, and lay the foundation for a proactive approach to ergonomic safety. 🔧 Module 2: Ergonomic Solutions and Interventions Training for Industrial Facility Master the art of ergonomic solutions in Module 2, focusing on interventions tailored for industrial facilities. Explore innovative strategies to address ergonomic challenges, implement effective solutions, and enhance the ergonomic design of workstations and processes in industrial settings. 🚀 Module 3: Ergonomics Committees and Coordinators for Industrial Facility Design and Planning Optimize your ergonomic practices with Module 3, dedicated to establishing ergonomic committees and coordinators for industrial facility design and planning. Learn how to integrate ergonomic considerations into facility design, fostering a collaborative approach to ergonomic excellence. 📊 Module 4: Ergonomic Assessments and Improvements of Interventions and Sustaining Programs Enhance your ergonomic initiatives in Module 4, focusing on assessments, improvements, and sustaining ergonomic programs. Learn to conduct regular assessments, implement improvements based on feedback, and ensure the longevity and effectiveness of ergonomic interventions in industrial facilities. 🌐 Module 5: Emerging Trends and Technologies for Holistic Approach Stay ahead of the curve with Module 5, exploring emerging trends and technologies for a holistic ergonomic approach. Delve into the latest advancements shaping the field of industrial ergonomics, ensuring your workplace is at the forefront of innovation and well-being. 🌟 Module 6: Ergonomics Maintenance Evaluation and Future Considerations Cap off your training with Module 6, where you'll focus on ergonomics maintenance evaluation and future considerations. Summarize key takeaways, assess the success of your ergonomic initiatives, and explore future considerations to keep your industrial facility at the forefront of ergonomic excellence. ️ Why Choose Our Ergonomics in Industrial Facilities Training Course? Expert-Led Training: Learn from seasoned ergonomics professionals with expertise in industrial settings. Practical Simulations: Engage in hands-on simulations, real-world scenarios, and practical exercises to reinforce theoretical knowledge. Customizable Training: Tailor the course to suit the specific needs of your industrial facility, ensuring maximum relevance. Future-Ready Focus: Explore emerging trends and technologies, future-proofing your ergonomic practices in industrial environments. Don't let ergonomic challenges hinder the well-being and productivity of your workforce! Enroll now in the Ergonomics in Industrial Facilities Training Course and empower yourself with the knowledge and skills needed to create a healthier and more efficient workplace. Your journey to ergonomic excellence in industrial settings begins here! 🛠️✨🎓 Course Curriculum Module 1 Introduction to Identifying and Assessing Ergonomic Risk Factors Introduction to Identifying and Assessing Ergonomic Risk Factors 00:00 Module 2 Ergonomic Solutions and Interventions Training for Industrial Facility Ergonomic Solutions and Interventions Training for Industrial Facility 00:00 Module 3 Ergonomics Committees and Coordinators for Industrial Facility Design and Planning Ergonomics Committees and Coordinators for Industrial Facility Design and Planning 00:00 Module 4 Ergonomic Assessments and Improvements of Interventions and Sustaining Programs Ergonomic Assessments and Improvements of Interventions and Sustaining Programs 00:00 Module 5 Emerging Trends and Technologies for Holistic Approach Emerging Trends and Technologies for Holistic Approach 00:00 Module 6 Ergonomics Maintenance Evaluation and Future Considerations Ergonomics Maintenance Evaluation and Future Considerations 00:00

🌬️ Breathe Clean, Breathe Safe: Indoor Air Quality Training Course! 🌿 Are you ready to create a healthier indoor environment for yourself and others? Enroll in our Indoor Air Quality Training Course, a comprehensive program meticulously designed to equip you with the knowledge and strategies needed to improve and maintain optimal indoor air quality. Join us on a journey where clean air meets well-being, fostering a living and working space that prioritizes respiratory health. 🌟 Module 1: Introduction to Indoor Air Quality - Sources and Types of Air Pollutants Embark on your journey with Module 1, providing a comprehensive introduction to indoor air quality. Understand the sources and types of air pollutants, laying the foundation for proactive measures in creating a healthier indoor environment. 💨 Module 2: Ventilation and Air Filtration for Improved Indoor Air Quality Master the art of ventilation and air filtration in Module 2, focusing on techniques to enhance indoor air quality. Explore the principles of effective ventilation, and understand the role of air filtration in removing pollutants and promoting a fresher, healthier atmosphere. 💧 Module 3: Humidity Control for Healthy Furnishings in Indoor Air Quality Optimize your indoor environment with Module 3, dedicated to humidity control. Learn to manage humidity levels to protect furnishings, prevent mold growth, and ensure a comfortable and healthy indoor space. 🔧 Module 4: Maintenance and Monitoring - IAQ Assessments for Continuous Improvement Enhance your indoor air quality practices with Module 4, focusing on maintenance and monitoring. Explore strategies for regular assessments, understand the importance of continuous improvement, and establish a routine for maintaining optimal indoor air quality. 👥 Module 5: Occupant Behavior - Holistic Approach to IAQ Management Foster a culture of responsibility in Module 5, where you'll explore occupant behavior and its impact on indoor air quality. Learn to engage occupants in promoting a healthy indoor environment, ensuring a holistic approach to IAQ management. 🌟 Module 6: Case Studies and IAQ Policies - Future Trends Cap off your training with Module 6, where you'll delve into case studies, explore IAQ policies, and discover future trends. Gain insights from real-world scenarios, understand the importance of policies, and stay ahead of emerging trends in indoor air quality management. 🚀 Why Choose Our Indoor Air Quality Training Course? Expert-Led Training: Learn from seasoned professionals specializing in indoor air quality and environmental health. 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. Well-Being Priority: Prioritize the health and well-being of occupants, creating environments that support respiratory health. Don't compromise on the air you breathe! Enroll now in the Indoor Air Quality Training Course and empower yourself with the knowledge and skills needed to create and maintain a healthy indoor environment. Your journey to cleaner, fresher air begins here! 🍃✨🎓 Course Curriculum Module 1 Introduction to Indoor Air Quality Sources and Types of Air Pollutants Introduction to Indoor Air Quality Sources and Types of Air Pollutants 00:00 Module 2 Ventilation and Air Filtration for Improved Indoor Air Quality Ventilation and Air Filtration for Improved Indoor Air Quality 00:00 Module 3 Humidity Control for Healthy Furnishings in Indoor Air Quality Humidity Control for Healthy Furnishings in Indoor Air Quality 00:00 Module 4 Maintenance and Monitoring IAQ Assessments for Continuous Improvement Module 4 Maintenance and Monitoring IAQ Assessments for Continuous Improvement 00:00 Module 5 Occupant Behavior Holistic Approach to IAQ Management Occupant Behavior Holistic Approach to IAQ Management 00:00 Module 6 Case Studies and IAQ Policies Future Trends Case Studies and IAQ Policies Future Trends 00:00