17140 Other courses in Stranraer delivered Online

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.

Overview Financial Analysis and Decision Making specifies a financial outline to support the life cycle approach of managing tedious projects over a long time scale. This course includes the advanced level of accounting structures which are required to insert knowledgable information in order to make decisions or to support the decision-making process where accounting and financial information overlaps other decision-making processes. In order to manage the growth of the organisation and measure the profitability it is very important to do a financial analysis. This course will take you through different models of accounting and finance which is helpful for the decision-making process thereby helping ensure sustainable growth and success.

ICA Professional Postgraduate Diploma in Financial Crime Compliance (FCC) Course This leadership programme has been designed to sharpen the strategic skills of senior practitioners and those aspiring to hold the highest anti-money laundering/financial crime position within a firm. This expert qualification offers: Specialist knowledge - the highest level in the field Strategic thinking - helps your leadership ambitions Innovation - explores new ideas, best practice, and future developments from a global perspective Fellowship of ICA - become automatically eligible for the highest grade of membership Networking - grow with other like-minded, senior professionals. With a focus on anti-money laundering, managing fraud and anti-bribery, and corruption, this qualification has helped hundreds of senior financial crime compliance professionals from all over the world unlock career growth opportunities. This course is awarded in association with Alliance Manchester Business School, the University of Manchester. How will the course be delivered This course is delivered online with materials delivered for you to study in your own time and at your own pace. There will be eight 3-hour virtual masterclasses over four weekends and seven live virtual classrooms spread over the duration of the course. Upon successful completion of the course, course materials and assessment, you will be awarded the ICA Professional Postgraduate Diploma in Financial Crime Compliance (FCC). This qualification is awarded in association with Alliance Manchester Business School, the University of Manchester. Assessment This course will be assessed via: The production of 8 x 1000-1500 word masterclass commentaries: these are summaries of the key learning points outlined in the masterclasses and its impact on your own practice, which forms the reflective journal. A three hour competency-based interview, using information describing your career to date and other evidence you wish to submit to map your knowledge, skills and experience against the National Occupational Standards The syllabus covers a variety of key issues relevant at a senior level and is designed to provide an insight into risks and potential hurdles faced by your organisation. The syllabus is delivered by an exclusive series of high-profile masterclasses covering relevant topics. Standards, research and assessment Financial crime risks: science or art? Ethics, corporate governance & responsibility Managing the internal AML enemy Cyber security: threats to the organisation FinTech and financial crime compliance Fraud and internal threat Risk based approach: too busy or too afraid Sanctions: a changing landscape.

XML primer training course description This course has been designed for web and intranet developers who want to accelerate their learning of XML and its applications without the grind of book learning. Although a basic knowledge of HTML and JavaScript is assumed, it is also assumed you know very little about XML and how to use it. On completion of this course you should understand the benefits of using XML and be able to design XML solutions where applicable to your company's Internet/intranet requirements. The course will be particularly beneficial if you want to know how to communicate data to diverse applications over the Internet or company intranet. What will you learn Write XML. Debug XML. Examine existing code and determine its function. XML primer training course details Who will benefit: Anyone working with XML. Prerequisites: HTML5 development fundamentals Duration 3 days XML primer training course contents The origins of XML Markup languages, SGML, document type definitions and validity, introducing XML, IE and XML, accessing content and adding style. Basic XML XML document structure, elements and attributes, grammar, well formed documents, other XML elements and references. Document Type Definition (DTDs) Creating a DTD, basic declaration, declaring elements, content definitions, entities, entity declarations, notations, defining attributes, attribute types, forcing inclusion or exclusion of DTD sections, validation. Namespaces Declaring namespaces, scoping, removing and changing namespaces, qualified names, attribute namespaces. An introduction to schemas Constructing schemas, defining the root element and its contents,<ELEMENTTYPE>, defining root element contents, adding attributes definitions, <ATTRIBUTETYPE>, <ELEMENT>, <ATTRIBUTE>. XML & the Document Object Model (DOM) What the DOM offers, DOM and W3C. Basic DOM concepts XML documents as trees, terminology of tree elements. Key DOM Objects: The document object and its creation, base objects, IE specifics, the XML node hierarchy. Programming DOM Viewing a DOM model as XML, getting the root element of a document, iterating nodes of a DOM, basic node properties, collection objects, searching for specific values, filtering a nodelist by tagname, more filtering methods, selecting nodes from their attributes. Amending Content and Structure Creating/saving a DOM as XML, changing content/structure, dynamically building a DOM. Using ASP and other techniques ASP techniques, HTTPREQUEST object, XSL, transforming and formatting XML. Formatting Using CSS. CSS And XML. XSL Transformations - XSLT Introduction, the XSL root element, applying XSL stylesheets to XML, XSL elements and operations, instructions - creating text nodes and applying templates, a 'drill-down' approach, simple output formatting, pattern filters - patterns based on position, the Match and Select attributes and their patterns, formatting output, creating new XML in output.

Driver CPC - 1 Day Periodic 7 Hour Course The Compliant Driver / Trailer Checks and 3rd Party Trailers Join our online course from Total Compliance, designed to build your expertise in being a compliant driver and conducting essential trailer check. Driver Compliance: Understanding the responsibilities and legal requirements for maintaining compliance on the road. Trailer Checks: Conducting thorough pre-use and post-use trailer inspections to ensure safety and efficiency. 3rd Party Trailers: Best practices for managing and operating third-party trailers, including checks, handling procedures, and risk mitigation. Don't miss out on this opportunity to improve your driving practices! Please review our Terms and Conditions for more information.

LOOKING FOR: PICTURE BOOKS, CHAPTER BOOKS, MG, YA, CHILDREN'S NON-FICTION After a childhood buried in library books and Beanos, Lydia started her career in the editorial team at Egmont, where she commissioned books such as the Carnegie Medal-winning The Poet X. She joined the Darley Anderson team in 2018, and as well as building an engaging and diverse list of authors and illustrators, she was promoted to Director in March 2024. With experience on both sides of the commissioning desk, Lydia loves working editorially with her clients and developing ideas from an initial spark into a full manuscript. She represents clients across all age groups, including picture book, chapter book, middle grade and YA, and has a particular focus on non-fiction. Lydia reads and considers widely, and among other things she is looking for snort-inducing stories for younger readers, clever and contemporary teenage and YA fiction, and non-fiction projects that take big ideas and make them easily navigable, accessible and fun. No matter the story, Lydia is drawn to voice above anything else and will always be sucked in by a strong hook. Lydia represents clients including Soofiya, Gina Blaxill, Mark Bradley, Ryan Hammond, Alice Harman, Joyce Efia Harmer, Catherine Jacob, Hannah Moffatt, Rachel Morrisroe, Nick Sheridan, Rashmi Sirdeshpande and Eva Wong Nava. If you could sum up her tastes in three words, they would be curious, characterful and heartfelt, and in three books, they would be One of Us is Lying, Nevermoor and You Are Awesome. Lydia would like you to submit a covering letter, a 1 page synopsis and the first 3 chapters or 20 pages of your completed manuscript in a single word document. For Picture Books please submit a covering letter and texts for two completed stories. (In addition to the paid sessions, Lydia is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Monday 16th June 2025

About this Training Course This intermediate to advanced level 3 full-day training course has been designed to provide participants with a detailed and up-to-date overview of the fluid mechanic fundamentals and operating practice of pumps, compressors and gas and steam turbines. Upon the successful completion of this course, participants will have acquired the practical knowledge to enable them not only to choose the correct device for a particular application but also be in a position to resolve many commonly occurring operating problems. Troubleshooting is an important part of this course and will cover the important topics of Machinery Root Cause Failure Analysis (RCFA) together with Vibration Analysis. This course is ideal for those personnel in the oil, gas, petrochemical, chemical, power and other process industries who require a wider and deeper appreciation of pumps, compressors and turbines, including their design, performance and operation. The participants will be taken through an intensive primer of turbo-machinery principles, using the minimum of mathematics, and will learn how to solve the many and varied practical industrial problems that are encountered. The course makes use of an extensive collection of VIDEO material together with case studies and numerical exercises. Training Objectives Upon the successful completion of this course, each participant will be able to: Apply a comprehensive knowledge of pumps, compressors & turbines and troubleshoot rotating equipment in a professional manner Identify the different types of turbomachinery including basic design aspects and highlighted problem areas Minimise compressor work by understanding the processes involved and identifying their efficiency Understand the flow through turbomachines and the corresponding velocity triangles including torque and power calculations Analyse the different types of centrifugal machines including their design, installation, operation, maintenance, re-rate/retrofit, troubleshooting and control Recognise the various beneficial design aspects of turbomachines and understand the crucial process of cavitation Carry out proper methods of device installation, operation, maintenance and troubleshooting Understand and apply the powerful methods of Machinery Root Cause Failure Analysis Understand the various methods of vibration analysis applied to device diagnostics Target Audience This course provides an overview of all significant aspects and considerations of pumps, compressors and turbines for those who are involved in the design, selection, maintenance or troubleshooting of such equipment. This includes maintenance, reliability, integrity, engineering, production and operations managers, engineers and other technical staff. Course Level Intermediate Advanced Trainer Your expert course leader is a Senior Mechanical & Instrumentation Engineer (UK, B. Sc., M.Eng., Ph D) with over 45 years of industrial experience in Process Control & Instrumentation, Pumps, Compressors, Turbines and Control Valve Technology. He is currently a Senior Independent Consultant to various petrochemical industries in the UK, USA, Oman, Kuwait and KSA where he provides consultancy services on both the application and operational constraints of process equipment in the oil & gas industries. During his early career, he held key positions in Rolls Royce (UK) where he was involved in the design of turbine blading for jet engines, subject to pre-specified distributions of pressure. During this period and since, he has also been closely involved in various aspects of Turbomachinery, Thermodynamics and Fluid Mechanics where he has become a recognised authority in these areas. Later, he joined the academic staff of University of Liverpool in the UK as a Professor in Mechanical Engineering Courses. A substantial part of his work has been concerned with detailed aspects of Flowmetering - both of single & multiphase flows. He has supervised doctoral research students in this area in collaboration with various European flowmeter manufacturers. He joined Haward Technology Middle East in 2002 and was later appointed as European Manager (a post which has since lapsed) and has delivered over 150 training courses in Flowmeasurement (single- and multi-phase), Control, Heat Exchangers, Pumps, Turbines, Compressors, Valve and Valve Selection as well as other topics throughout the UK, USA, Oman and Kuwait. During the last two years, he has delivered courses with other training companies operating in the Far and Middle East. He has published about 150 papers in various Engineering Journals and International Conferences and has contributed to textbooks on the topics listed above. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Overview Cyber Security plays an important role in every business as it encompasses everything that relates to protecting sensitive data, personal information, intellectual property, data, and governmental and industry information systems from theft and damage attempted by criminals and adversaries. This course is designed to understand and gain practical skills to plan, deliver and monitor IT/cyber security to internal and external clients understanding a complete, knowledge in the areas of IT policies, Security-Operational-Run-Book, security/penetration testing, ethical hacking and black hat hacking including understanding the basics of Kali Operating System and its tools and techniques. It will also cover WiFi security, Website security, human factors, cyber forensics, and cyber security team management, including all other areas in relation to Cyber Security.

What past delegates said: "I started looking for a course in education and training when I was offered a chance to help deliver some health & safety training in my local area - I was incredibly lucky to have found Ottilia Pochat Training. Ottilia has a wealth of experience in teaching, and she managed to share those skills and techniques with us in a way that was both incredibly informative and fun! I can’t recommend Ottilia Pochat Training highly enough - why wouldn’t you want to learn how to teach from the best?" This course is fully tutor-led and teaches you how to become a good, quality trainer Virtual Classroom, this course is run over 8 weeks: 16 sessions of 2½ hour duration, from 10:00 -12:30 and 13:30 - 16:00 The virtually run course starting on Friday 7 July will be held over 8 consecutive Fridays Face to Face: Five-day course Run by a Dutch teacher who spent 4 years learning to teach and has international teaching experience in working with all age groups Course Contents Roles and responsibilities in education and training Ways to maintain a safe and supportive learning environment Relationships between teachers and other professionals Boundaries between the teaching role and other professionals Points of referral to meet the individual needs of learners Inclusive teaching, including:Ways to create an inclusive teaching and learning environmentCreating an inclusive teaching and learning planJustifying own selection of teaching and learning approaches, resources and assessment methods in relation to individual learner needsUsing teaching and learning approaches to meet learner needsEvaluating the delivery of inclusive teaching and learning including areas for improvementDelivering inclusive teaching and learning to meet individual needs Communicating with learners in a way that meets their needs Understanding assessment in education and training, including:Different methods of assessment and how they can be adapted to meet individual learner needsHow to involve learners and others in the assessment processThe role and use of constructive feedbackRecord keeping of assessments Benefits of this course: This Ofqual regulated course will allow you to work in adult education Or even, run online training sessions With this course, you'll also be able to run professional workshops Accredited, Ofqual regulated qualification Our QA Level 3 Award in Education and Training (RQF) Course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can rest assured that your level 3 Award in Education and Training fulfils the legal requirements to kick-start your own career in Education and Training. The Ofqual Register number for this course is 603/2770/4

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by: CPD UK & Quality License Scheme Tutor Support: Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime: With 1 year access to the course materials Online Learning: Learn from anywhere, whenever you want This course is a comprehensive program designed for experienced educators looking to elevate their teaching skills to a new level. In this course, learners will learn teaching methodologies, language acquisition theories and innovative classroom strategies. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand teaching theories and methodologies, conditionals and reported speech, lesson planning, and how to evaluate student's progress Know everything from planning effective lessons to classroom management Learn about teaching receptive skills, productive skills, pronunciation and phonology, course books and lesson materials, evaluation and testing Get to know about equipment and teaching aids, modals, phrasal verbs, passive voice, teaching special groups Learn how to identify the characteristics of effective classroom instructions and strategies Understand the personal traits, roles, and habits of successful EFL teachers and learners Able to explain the reasons and methods for testing English language learners Learn everything about languages such as parts of speech, present tenses, techniques to manage classes, past tenses, skills to teach a new language, and lesson planning Why TESOL Course - Advanced Concepts right for you? Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this TESOL - Advanced Concepts course will set you up with a solid foundation to become a confident TESOL teacher or instructor and develop more advanced skills. This comprehensive TESOL - Advanced Concepts course is the perfect way to kickstart your career in the field of TESOL. This course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. TESOL Course - Advanced Concepts Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Introduction Introduction Unit One Unit Two Unit Three Unit Four Who should take this course? This comprehensive TESOL - Advanced Concepts course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of TESOL. Entry Requirements There are no academic entry requirements for this TESOL - Advanced Concepts course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org