2470 Maintenance courses delivered Online

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

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

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

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!

The IWFM Level 3 qualifications in workplace and facilities management are for you if you are a first-line manager or supervisor in workplace and facilities management or if you are new to the industry. They are designed to develop an understanding and knowledge of facilities management matters. The Award gives you a succinct overview of the basic skills and knowledge needed at this level.

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

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

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

Embark on a journey of exploration with our Exploring Travel, Tourism, and Leisure with Trends and Opportunities course. From leadership in the leisure industry to managing hotels and lodgings, our program covers a wide range of topics to equip you with the knowledge and skills needed to succeed in the leisure industry. Join us today and discover the endless opportunities in the world of leisure. Learning outcomes : Develop an understanding of leisure management and facility maintenance Learn about the travel, tourism and leisure industry Gain knowledge of managing hotels and lodgings Plan for leisure services and leadership in the leisure industry Understand human resource management and marketing in leisure and recreation Develop health, safety and welfare awareness in the leisure industry Our Exploring Travel, Tourism, and Leisure with Trends and Opportunities course is designed to equip you with a comprehensive understanding of the leisure industry. With modules covering leisure management, facility maintenance, travel, tourism, lodging management, leisure services planning, leadership, human resource management, marketing, health and safety, and welfare, our program prepares you to tackle the challenges and opportunities in the leisure industry. Whether you're an aspiring leisure professional, a student looking to learn more about the industry or simply interested in the leisure industry, our course is perfect for you. With our comprehensive program, you'll gain a thorough understanding of the leisure industry and the skills needed to succeed in it. So Enrol today and take the first step towards an exciting career in leisure. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring leisure professionals Students looking to learn more about the leisure industry Anyone interested in the leisure industry Professionals looking to expand their knowledge Career path Leisure Centre Manager (£25,000 - £45,000) Hotel Manager (£20,000 - £60,000) Event Manager (£20,000 - £45,000) Tourism Officer (£20,000 - £35,000) Leisure Services Planner (£18,000 - £40,000) Travel Agent (£15,000 - £30,000)