10494 Courses

Blue CSCS Card NVQ Level 2 Craft This qualification provides you with the opportunity to showcase their knowledge, skills and understanding in their chosen craft. You will have the relevant experience in one of the trade specific areas. You will work in one of the following areas: Trowel Occupations (Bricklayer) Building Maintenance Painting and Decorating Wall and Floor Tiling Stone Masonry Wood Occupations (site Carpentry) Plastering Roofing Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor, you will get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion, and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be applied for. To download our PDF for this course then please click here.

Become an expert in DIY and transform your gloomy, neglected basement into a sleek and stylish living space with the Basement Improvement & Renovation Course. This instructor-led course is a complete introduction to basement remodelling and includes expert audio-visual material to develop your practical skills for everyday DIY projects. You will learn the basics of electrical and plumbing installation, how to make the most of natural lighting, repair walls, control mould and much more. This course also provides step-by-step guidance on waterproofing your basement and installing adequate heating and air conditioning. You will also be trained on the fundamentals of basement repair and maintenance to ensure a healthy and safe living space. On completion, you will be equipped with the knowledge and skills to plan your transformation project and utilise your space to create a beautiful sanctuary that everyone can enjoy. Your Learning Goals: Save money and do it yourself - the faster and more affordable way! Develop the practical skills to transform your basement into a stylish and useful living space Get handy tips and tricks from the experts in home DIY Understand the basics of plumbing and electrical installation Learn how to control moisture levels, temperature and lighting quality Familiarise with tools of the trade required for everyday DIY projects Discover everything you need to know about subfloors, partition walls and basement ceilings Be able to repair beams and walls, seal cracks, and ensure adequate insulation Who is this Course for? Basement Improvement & Renovation is 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. 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. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Week#1: Intro & Assessment Week#1: Intro & Assessment 00:05:00 Week#1 - Lesson#1 : The Benefits & Challenges of Finishing a Basement 00:15:00 Week#1 - Lesson#2: Assessing Your Basement Space 00:00:00 Week#1 - Lesson#3: Do-It-Yourself, Contractor or Both? 00:00:00 Week#2: Basement Finishing Options Week#2: Lesson#1 : Anatomy of a Basement 00:30:00 Week#2 - Lesson#2: Basement Finishing Best Practices 02:00:00 Week#3: Moisture-proofing, Electricity, Plumbing & Tearing Out An Old Basement Week#3 - Lesson#1: Moisture-Proofing Strategies 00:20:00 Week#3 - Lesson#2: Power, Lighting & Plumbing Best Practices 00:40:00 Week#3 - Lesson#3: Tearing Out an Old Basement Best Practices 00:20:00 Week#4: Basement Planning and Layout Week#4: Lesson#1 : Understanding Layout Options 00:15:00 Week#4 - Lesson#2: Experience your layout in full size 00:15:00 Week#5: Special Basement Features Week#5 - Lesson#1: Basement Bathrooms, Saunas & Steam Rooms 00:30:00 Week#5 - Lesson#2: Building a Second Suite 00:05:00 Week#5 - Lesson#3: How to Create a Basement Kitchen 00:10:00 Week#5 - Lesson#4: Basement Cold Rooms & Cellars 00:30:00 Week#5 - Lesson#5: Bring Outdoor Light Into Your Basement 00:10:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview Construction engineering is the backbone of every great structure, requiring expertise in design, cost estimation, safety, and surveying. Our Construction Engineering: Construction Scheme, Surveying, Design, Estimation & Safety Bundle equips you with the essential knowledge and skills to excel in this dynamic field. If you’re interested in construction management, surveying, or cost estimation, this bundle gives you all the basics you need for your career. With premium courses like Diploma in Construction Management, Building Surveyor, and Land Surveying, you'll gain practical skills in key areas of construction. Learn to estimate costs using RSMeans, understand sustainable building standards like LEED V4 and WELL Building Standard, and dive into safety with Construction Safety, First Aid, and LOLER Training. You’ll also enhance your technical skills with AutoCAD VBA Programming and gain specialized knowledge in bricklaying, construction schemes and more. This Construction Engineering Bundle Consists of the following Premium courses: Course 01: Diploma in Construction Management Course 02: Building Surveyor Course 03: Land Surveying Course 04: LEED V4: Building Design and Construction Course 05: WELL Building Standard Course 06: Construction Industry Scheme (CIS) Course 07: AutoCAD VBA Programming - Beginner course Course 08: Construction Cost Estimation Diploma Course 09: Construction Estimation using RSMeans Course 10: Bricklaying Course 11: LOLER Training Course 12: PUWER Course 13: Construction Safety Course 14: First Aid Training Benefits you'll get from this bundle course: Pay once and get lifetime access to 14 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Certificates Digital certificate - Included You will get the PDF Certificate for the title course (Diploma in Construction Management) absolutely Free! Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Diploma in Construction Management) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Description Begin your journey with Apex Learning right away! The Construction Engineering: Construction Scheme, Surveying, Design, Estimation & Safety course provides essential skills for anyone looking to work in construction. This course will help you build a solid foundation for a successful career in the construction industry. Course curriculum: Course 01: Diploma in Construction Management Introduction to Construction Management Project Life Cycle and Success Cost Management Preliminary Site Investigation and Site Organization Site Management Planning and Management of Equipment Construction Materials Management Vendor Analysis in Construction Management Construction Procurement Stock Control Supply Chain Management The Main Participators Quality Assurance and Customer Care Legal Aspects of Contracting Human Resources Management Risk and Value Management Communications, Information and Documentation of Construction Health and Safety in Construction Management Course 02: Building Surveyor Building Survey: An Introduction Building Law Principles Building Procurement and Contract Administration Building Information Modelling Building Technology The Procedure of Building Survey and Surveys of Historic Buildings Beginning of the Survey: Foundation and In-depth Survey in Walls Ground Level Investigation: Floors and Investigation Above the Ground: Roofs and Chimneys Course 03: Land Surveying Introduction to Land Surveying Land Surveying Basics Land Surveying Instrumentation Land Surveying Methods and Techniques Topographic Surveying and Mapping Boundary Surveying Surveying Health and Safety Course 04: LEED V4: Building Design and Construction Introduction Integrative Process Location & Transportation Sustainable Sites Water Efficiency Energy & Atmosphere Materials & Resources Course 05: WELL Building Standard Introduction Air Water Nourishment Light Fitness Comfort Mind Course 06: Construction Industry Scheme (CIS) Construction Industry Scheme (CIS) Coverage of the Scheme Contractors and Registration for the Scheme Verification Process The CIS Returns Record Keeping and CIS Certificates Course 07: AutoCAD VBA Programming - Beginner course Introduction VBA Integrated Development Environment (IDE) Understanding AutoCAD Object Model in VBA Using Variables in VBA User Forms and Controls Conditionals and Decisions in VBA Looping and Iterations in VBA Drawings Objects in VBA Code Debugging in VBA Error Handling in VBA Conclusion Course 08: Construction Cost Estimation Diploma Introduction to Construction Management Cost Estimation Role of Cost Estimator and New Aspects of Cost Estimation Elements and Factors influencing Cost Estimation Cost Estimation in Construction Industry Cost Management Management of Materials for construction Course 09: Construction Estimation using RSMeans Introduction Quantity Take Off Cost Estimation using RSMeans Course 10: Bricklaying Introduction to Bricklaying Tools of Bricklaying Bonding of Bricklaying Basic Techniques of Bricklaying Constructing Walls Basic Joint Finishes Course 11: LOLER Training Introduction to LOLER Selecting Lifting Equipment and Accessories Planning the Lifting Operation Factors Affecting Safe Lifting Operation Roles and Responsibilities Risk Assessment Examination and Inspection Reports and Defects Course 12: PUWER Provision and Use of Work Equipment Regulations Selection and Conformity of Work Equipment Safe Functionality of Work Equipment Monitoring and Evaluation of Work Equipment Maintenance of Work Equipment Course 13: Construction Safety Managing Health and Safety Risk Assessment and Common Risks Health and Safety Guidelines and Legislations Reporting Accidents at Work General Site Issues Working at Height Excavation Work and Confined spaces And Many More... Course 14: First Aid Training Introduction to Workplace First Aid Legal Framework for Workplace First Aid Incident Management at Work Primary Survey Secondary Survey Basic First-Aid Techniques And Many More... CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is for anyone who wants to start or grow a career in construction. It’s great for people who want to be construction managers, surveyors, designers, or cost estimators, and for those interested in construction safety. If you want to learn about construction projects, from design to cost and safety, this course is for you. Requirements Our Construction Engineering course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Completing this course can open up various career opportunities in construction engineering. Construction Assistant – £20,000 to £30,000 Surveyor – £30,000 to £45,000 Cost Estimator – £35,000 to £50,000 Construction Designer – £40,000 to £55,000 Construction Manager – £45,000 to £70,000 Project Manager – £50,000 to £75,000 Health & Safety Officer – £30,000 to £45,000 Senior Surveyor – £50,000 to £70,000

The demand for structural engineers has increased in the UK in recent years. This is because millions of structures are being built worldwide every day. And these numbers will never decrease as we constantly need buildings like offices, houses, bridges, and schools; this list will continue. For those thinking of embarking upon a career in structural engineering, this ultimate career bundle will fill you in on everything you need to know about this buoyant industry and provide the necessary knowledge on how to gain your first big break. In the UK, on average, Structural Engineers earn around £38,000 - £55,000 per annum. So enrol in this course and take your next step towards a successful career! Package Details: Number of Courses: 30 Courses Accreditation: CPD Quality Standards Free Certificates:PDF: 30Hardcopy: 30 (Delivery Charge Applicable) Courses Access: Lifetime Instalment Payment Available Structural Engineering Related Courses Course 01: Read Construction & Structural Drawing Like Expert Course 02: Diploma in Construction Management Course 03: Quantity Surveyor Diploma Course 04: Building Surveyor Course 05: Land Surveying Course 06: Bricklaying Course 07: Construction Cost Estimation Diploma Course 08: Construction Estimation using RSMeans Course 09: Construction Cost Estimation Using Xactimate Course 10: Cost Estimation for Multiplex Building Using Xactimate Course 11: Property Law and Legislation Course 12: Construction Industry Scheme (CIS) Course 13: WELL Building Standard Course 14: LEED V4: Building Design and Construction Course 15: LEED V4 - Building Design and Construction Architecture & AutoCAD Related Courses Course 01: Architectural Studies Course 02: AutoCAD Programming using C# with Windows Forms Course 03: CAD Design Course: Assemblies, Modelling And Civil Drawings Course 04: Autocad Electrical Design Course 05: Intermediate Solidworks Course Course 06: Solidworks Foundation Training Course 07: Interior Design Professional Diploma Course 08: Professional Interior Design & Construction Constraction Safety Related Courses Course 01: Construction Safety Course 02: Fire Safety | Online Course Course 03: Emergency First Aid and Incident Management at Work Course 04: RIDDOR Training Course 05: LOLER Training Course 06: COSHH Training and Safety - Level 2 Course 07: DSEAR Training Benefits you'll get from choosing Apex Learning for this training: Pay once and get lifetime access Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn anytime, from anywhere Study from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills CPD 305 CPD hours / points Accredited by CPD Quality Standards Career path This bundle will help you learn the necessary skills to explore opportunities such as- Structural Engineer £36,000 - £38,000 per annum Engineer £27,000 - £45,000 per annum Construction Engineer £3,000 - £45,000 per annum Engineer Surveyor £28,000 - £32,500 per annum Civil Engineer £29,000 - £38,000 per annum

Facilitating Effective Meetings (In-Person) Billions of dollars and exorbitant amounts of time are wasted annually across the globe because of organizations' meeting practices. This contributes to serious performance problems for both organizations and employees, and it has a serious impact on culture and morale. But despite the costs and consequences, every-day people in any role have the ability to change that. They can reduce cost, improve productivity, and enhance their workplace cultures by improving their meeting facilitation skills. And that is because facilitation skills start in the planning stage, not in the live meeting stage. In this course, participants will learn that their responsibility as a facilitator is to be a steward of time, money, relationships, and performance. To do that, they will learn to estimate costs of meetings and practice a variety of strategic thinking and analysis tasks to effectively plan results-aligned meetings. They will also apply several techniques and strategies to proactively prevent and deal with conflict in meetings, as well as give objective, constructive feedback to others in order to create behavior change during meetings. Participants must bring laptops with them and have internet access during the course (both virtual classroom and traditional classroom). The laptops are needed for specific activities. Also note that this course pairs well with IIL's Conflict Resolution Skills and Decision Making and Problem Solving courses, which go much deeper into related skills and tools that support effective meeting facilitation. What you will Learn At the end of this program, you will be able to: Estimate the financial and time costs of attendance for real-world meetings Use a performance formula to define the purpose of meetings Describe the responsibilities and qualities of an effective facilitator Analyze situations to determine when a meeting is necessary Articulate performance-driven meeting goals and results Align meeting goals and results Strategize to invite, involve, and exclude appropriate attendees Explain research-based best practices for meeting decisions and agenda development Create an effective agenda for a results-driven meeting Apply proactive tools and strategies for relationship-building dealing with meeting conflict Give constructive behavioral feedback using the Situation-Behavior-Impact® technique Getting Started The Business Case for Effective Facilitation Embracing the research on meetings Estimating the real costs of meetings Determining a meeting's performance value Clarifying the meeting facilitator's role Facilitating the Meeting Plan Determining if a meeting is necessary Aligning meeting goals with meeting types Identifying the right attendees Creating a strategically effective agenda Facilitating the Live Meeting Building relationships from the start Dealing with conflict proactively Giving feedback on unproductive behavior Summary and Next Steps

Duration 3 Days 18 CPD hours This course is intended for This course is ideal for Professionals preparing to become CRISC certified. Risk practitioners Students or recent graduates Overview At course completions, students will understand the essential concepts in the 4 ISACA CRISC domains: Governance IT Risk Assessment Risk Response and Reporting Information Technology and Security This 3 Day CRISC course is geared towards preparing students to pass the ISACA Certified in Risk and Information Systems Control examination. The course covers all four of the CRISC domains, and each section corresponds directly to the CRISC job practice. CRISC validates your experience in building a well-defined, agile risk-management program, based on best practices to identify, analyze, evaluate, assess, prioritize and respond to risks. This enhances benefits realization and delivers optimal value to stakeholders. GOVERNANCE - a. Organizational Governance Organizational Strategy, Goals, and Objectives Organizational Structure, Roles, and Responsibilities Organizational Culture Policies and Standards Business Processes Organizational Assets GOVERNANCE - b. Risk Governance Enterprise Risk Management and Risk Management Framework Three Lines of Defense Risk Profile Risk Appetite and Risk Tolerance Legal, Regulatory, and Contractual Requirements Professional Ethics of Risk Management IT RISK ASSESSMENT - a. IT Risk Identification Risk Events (e.g., contributing conditions, loss result) Threat Modelling and Threat Landscape Vulnerability and Control Deficiency Analysis (e.g., root cause analysis) Risk Scenario Development IT RISK ASSESSMENT - b. IT Risk Analysis and Evaluation Risk Assessment Concepts, Standards, and Frameworks Risk Register Risk Analysis Methodologies Business Impact Analysis Inherent and Residual Risk RISK RESPONSE AND REPORTING - a. Risk Response Risk Treatment / Risk Response Options Risk and Control Ownership Third-Party Risk Management Issue, Finding, and Exception Management Management of Emerging Risk RISK RESPONSE AND REPORTING - b. Control Design and Implementation Control Types, Standards, and Frameworks Control Design, Selection, and Analysis Control Implementation Control Testing and Effectiveness Evaluation RISK RESPONSE AND REPORTING - c. Risk Monitoring and Reporting Risk Treatment Plans Data Collection, Aggregation, Analysis, and Validation Risk and Control Monitoring Techniques Risk and Control Reporting Techniques (heatmap, scorecards, dashboards) Key Performance Indicators Key Risk Indicators (KRIs) Key Control Indicators (KCIs) INFORMATION TECHNOLOGY AND SECURITY - a. Information Technology Principles Enterprise Architecture IT Operations Management (e.g., change management, IT assets, problems, incidents) Project Management Disaster Recovery Management (DRM) Data Lifecycle Management System Development Life Cycle (SDLC) Emerging Technologies INFORMATION TECHNOLOGY AND SECURITY - b. Information Security Principles Information Security Concepts, Frameworks, and Standards Information Security Awareness Training Business Continuity Management Data Privacy and Data Protection Principles

Overview Without proper knowledge and skills, conducting proper surveying can be quite challenging. So, before you step into this world, polish your skills and enhance your knowledge. Our Online Surveying Training is designed to help you work on your abilities. It will introduce you to the ABCs of surveying in no time. First, the course will demonstrate the basic principles of building surveying. Then, you will be introduced to the necessary instruments and techniques used for surveying. The course will also include lessons on area measurements, measurement volumes, etc. Here, you will grab the chance to clear your knowledge of distance measurement, levelling, contouring, etc. Finally, the course will help you enhance your understanding of survey reporting. So, if you are ready to take your career to the next level, join now! Course Preview Learning Outcomes Get introduced to the basic concepts of surveying Learn about the major tools and techniques of surveying Develop your skills in area measurements, measurement volumes, and levelling Understand the fundamentals of distance measurement Know how to create a survey report 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? Distance measurement Levelling Distance measurement Area measurement Who Should Take This Online Surveying Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Online Surveying Training 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. Online Surveying Training Certification After completing and passing the Online Surveying Training 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 Online Surveying Training will equip you with effective skills and abilities and help you explore career paths such as  Land Surveyor Surveying Technician Construction Project Manager Module 01: Basics Of Surveying Basics of Surveying 00:38:00 Module 02: Tools And Techniques Of Surveying Tools and Techniques of Surveying 00:32:00 Module 03: Surveying Instrumentation Surveying Instrumentation 00:25:00 Module 04: Area Measurement Area Measurement 00:41:00 Module 05: Measurement Volumes Measurement of Volumes 00:33:00 Module 06: Levelling Levelling 00:39:00 Module 07: Contouring Contouring 00:30:00 Module 08: Distance Measurement Distance Measurement 00:38:00 Module 09: Angles And Directions Angles and Directions 00:28:00 Module 10: Error And Uncertainty Error and Uncertainty 00:35:00 Module 11: Survey Report Survey Report 00:25:00 Assignment Assignment - Surveying Basics 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Master the art of crime report writing with our comprehensive course in Criminal Justice. Explore topics such as report structure, legal considerations, and writing techniques for accuracy. Elevate your skills in documenting information, crafting objective reports, and navigating ethical considerations. Perfect for law enforcement professionals seeking to enhance their proficiency in producing effective and impactful crime reports.

Person Centred Planning: the act of listening to each other creates relationship and strengthening trust and inclusion within the team. If well facilitated In creating a shared vision, groups of people build a sense of commitment together. They develop images of the future they want to create together, along with the values that will be important in getting there and the goals they want to see achieved along the way. Course Category Person Centred Planning Team Building and Leadership Description How to facilitate Person Centred Planning? How is it different from any other kind of meeting or planning? Person Centred working is great – but how exactly is it facilitated? How does it differ from ‘chairing a meeting” What skills and processes enable the group to work together effectively and avoid going off at tangents or dissolving into an unfocussed ‘discussion’ Person Centred Planning: the act of listening to each other creates relationship and strengthening trust and inclusion within the team. If well facilitated In creating a shared vision, groups of people build a sense of commitment together. They develop images of the future they want to create together, along with the values that will be important in getting there and the goals they want to see achieved along the way. Making inclusive action plans using full participation and graphic facilitation Drawing on the planning tools MAPS and PATH (Pearpoint, Forest and OBrien 1997) and other facilitation sources we use both process and graphic facilitation to enable the group to build their picture of what they would love to see happening within their organisation/community in the future and we encourage this to be a positive naming, not just a list of the things they want to avoid. In this training we make this facilitation explicit and attempt to model, teach and enable practice of key skills and processes. Jack Pearpoint, Marsha Forest and John O’Brien developed these innovative PCP approaches in North America and they are being used successfully in many parts of the UK. The planning can focus on an individual, group or organisation and provides a powerful problem solving opportunity, which is flexible and robust enough for many occasions. Tell the story, find the dream, touch the nightmare, and explore who you are, what are the gifts and strengths of the person or group, what are the needs of those present and what is the action plan for the future? Testimonials Learning Objectives Participants understand group and graphic facilitation processes for Person Centred Planning Participants have skills and confidence to facilitate PATH/MAP processes Participants learn graphic as well as process facilitation skills. Strengthens practitioners inclusive practice Provides additional tools for those involved in inclusive work in schools and the wider community Further develop problem solving and planning skills Who Is It For ? Person Centred Planning Facilitators Multi Agency Teams Social workers CAMHS teams Year Managers Primary and secondary staff teams Early Years and School based Practitioners Heads and Deputies SENCOs Advanced Skills Teachers Primary and secondary teachers Local Authority Support Services Voluntary Organisations Course Content The course answers the questions: Need to find new ways to facilitate Planning? How to facilitate Person Centred Planning? How is it different to any other kind of meeting or planning? Person Centred working is great – but how exactly is it facilitated? What are the skills and processes that will make the group work really well and a wonderful graphic to be created? Bored with annual reviews, transition plans and review meetings? Want to find a way of making meetings and planning feel more real and engaging? Need an approach, which engages a young person respectfully together with his or her family and friends? Want the ultimate visual record of the process of a meeting, which will help everyone, keep track? Want to problem solve and plan for the future of a small or large group, service or organisation up to the size of an LA? Inclusive Solutions offer an introductory day to facilitating person centred planning or a 3 – 10 session course which is practical as well as values based. Participants will receive direct individualised coaching and training. We will cover: Group and Graphic Facilitation processes Use of music and dramatic participation methodology The person being at the centre Family members and friends being full partners Planning reflecting the person’s capacities, what is important to the person and specifying the support they require to make a full contribution to their community Planning building a shared commitment to action that will uphold the person’s rights Planning leading to continual listening, learning and action and helping the person get what they want out of life. Essential Lifestyle Planning, PATH MAPS Personal Futures Planning

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.