991 Courses in Liverpool delivered Live 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.

This training covers two essential aspects: Understanding the highway Code and road safety measures to handle accidents, incidents, and breakdowns. Driver Health and Wellbeing: Understand the impact of physical and mental health on driving performance. Identify early warning signs of fatigue, stress, and other health issues. Learn effective strategies for managing work-life balance and reducing stress. Promote a healthy lifestyle to enhance overall well-being and driving safety. Drivers’ Hours and Working Time Regulations: Master the Rules of the Road Ensure compliance with complex driving and rest regulations. Understand the impact of hours worked on driver safety and well-being. Learn how to effectively manage driving and rest periods, breaks, and exemptions to avoid penalties and protect your business. Join us to enhance your knowledge of the Highway Code and road safety preparedness. Register today to ensure your drivers are well-versed in the rules of the road and equipped to handle unexpected challenges on their journeys. Please review our Terms and Conditions for more information.

This training covers two essential aspects: Understanding the highway Code and road safety measures to handle accidents, incidents, and breakdowns. Driver Health and Wellbeing: Understand the impact of physical and mental health on driving performance. Identify early warning signs of fatigue, stress, and other health issues. Learn effective strategies for managing work-life balance and reducing stress. Promote a healthy lifestyle to enhance overall well-being and driving safety. Drivers’ Hours and Working Time Regulations: Master the Rules of the Road Ensure compliance with complex driving and rest regulations. Understand the impact of hours worked on driver safety and well-being. Learn how to effectively manage driving and rest periods, breaks, and exemptions to avoid penalties and protect your business. Join us to enhance your knowledge of the Highway Code and road safety preparedness. Register today to ensure your drivers are well-versed in the rules of the road and equipped to handle unexpected challenges on their journeys. Please review our Terms and Conditions for more information.

Duration 5 Days 30 CPD hours This course is intended for This advanced course is for: AIX technical support personnel Performance benchmarking personnel AIX system administrators Overview Define performance terminology Describe the methodology for tuning a system Identify the set of basic AIX tools to monitor, analyze, and tune a system Use AIX tools to determine common bottlenecks in the Central Processing Unit (CPU), Virtual Memory Manager (VMM), Logical Volume Manager (LVM), internal disk Input/Output (I/O), and network subsystems Use AIX tools to demonstrate techniques to tune the subsystems In this course, students will develop the skills to measure, analyze, and tune common performance issues on IBM Power Systems running AIX. Day 1 Performance analysis and tuning overview Data collection Monitoring, analyzing, and tuning CPU usage Day 2 Virtual memory performance monitoring and tuning Day 3 Physical and logical volume performance File system performance monitoring and tuning Day 4 File system performance monitoring and tuning Network performance Day 5 NFS performance Performance management methodology

Learn how to create and manage a successful YouTube channel for your business. This workshop will cover everything you need to know when setting up and using YouTube in your business. You will also learn how to use YouTube analytics to track your channel's performance to help you make improvements.

About this Training Course Gas wells are the most uncertain hence critical component of any gas production system. A successful gas project relies on a reliable forecast of gas well production and on timely implementation of measures that restore, sustain and improve gas well capacity, and maximize reserves. This 5-day course provides the skills to understand and analyze (changes in) gas well performance, and to select and design those remedial measures. It addresses all four gas well components i.e. reservoir performance, inflow performance, outflow performance and surface performance, individually and combined. In depletion-drive reservoirs, the gas well outflow performance becomes inevitably compromised as the reservoir pressure depletes and the gas rate becomes insufficient to lift liquid water and condensate to surface. This condition is referred to as liquid loading and causes significant loss of well capacity and reserves. This 5-day course provides the means to recognize and predict liquid loading, introduces the deliquification techniques that mitigate liquid loading, and then teaches how to select, design, install and operate the optimum suite of deliquification measures. Training Objectives On completion of this course, participants will be able to: Recognize and model gas well reservoir, inflow, outflow and surface performance Understand and model gas well production forecast and reserves Identify and model gas well performance threats and opportunities, specifically liquid loading and deliquification Select and justify remedial measures that mitigate those threats or realize those opportunities, specifically deliquification measures Understand design, installation and operation of those deliquification measures Target Audience This course is intended for production engineer, surveillance engineer, completion engineer, production/process chemist, reservoir engineer, production programmer, production operator, as well as other professionals responsible for selecting, installing, operating, monitoring and optimizing deliquification. Course Level Basic or Foundation Training Methods This course consists of a series of lectures and exercises. The lectures are interactive with field examples to illustrate models and concepts, where participants are encouraged to contribute their own relevant field examples. The exercises make use of a series of Excel worksheets for model calculations. Participants are invited to implement their own field specific well data. When arranged beforehand, PROSPER gas well performance software can be used as well. This course addresses ways and means to monitor and manage gas well performance and deliquification. It covers the purpose, outcome and benefit of gas well surveillance and capacity measures to assist future surveillance and capacity planning. Specifically, it addresses the selection and implementation of deliquification measures. This course introduces the skills and tools required for periodic review of gas well performance in support of critical business processes Trainer Your expert course leader brings with him 38 years of oil and gas field experience largely within Shell of which 25 years as gas well production engineer. He has covered the full spectrum of activities moving from R&D to green field development to brown field surveillance and optimisation, to become a leading gas well performance and deliquification specialist. He likes to capture the complex reality of gas well inflow, outflow and reservoir performance by means of practical data-driven rules and tools that cover a wide range of conditions i.e. shallow-to-deep, prolific-to-tight, dry-to-wet, green-to-brown, 1-1/2'-to-9-5/8' tubing, and depletion-to-aquifer drive. Before his retirement end 2020, He worked for Shell affiliated oil and gas companies including Shell Malaysia, Petroleum Development Oman, NAM Netherlands and Shell R&D in Netherlands and USA. Since then, he has been active as an independent trainer and consultant, amongst others for Cairn India. 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 Performance management is a continuous process which involves making sure the performance of your employees contributes to organisational and team goals. Having effective employment management in place helps everyone in the organisation to know what the business is trying to achieve, the skill and competencies they need to fulfil their role and how they can develop their performance to develop the organisation.

Overview Objective Describing the HR role and Strategies Describe different approaches to employee training Describe different approaches to professional development Describe different approaches to performance appraisals Summarize different forms of employee compensation

Overview This course is designed to integrate or upgrade your Key Performance Management System. The course will relate to the activities with tactic through accomplished features and performance measures.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for managers, supervisors, human resource personnel, and team leaders who are seeking to inspire employees and optimize their performance. Overview In this course, you will identify strategies for motivating employees and developing them through the application of basic performance-management techniques. You will: Commit to employee motivation. Motivate employees. Develop self-motivated employees. Establish a foundation for performance management. Optimize employee performance using performance-management strategies. Create employee performance and development plans. Motivation has a profound effect on employees' productivity and performance. An organization improves its likelihood of success by maintaining a motivated work force. As a leader within your organization, you share in the responsibility of motivating your employees.You also want to be able to lead the individuals on your team effectively by conducting ongoing performance appraisals; delivering helpful and instructive feedback, training, and coaching; and designing and implementing performance standards. You want to develop talent within your team by employing effective performance-management strategies on the job. This course will help you cultivate the skills necessary to motivate your employees and give you essential performance-management skills. Committing to Employee Motivation Topic A: Recognize the Importance of Motivation Topic B: Assess Employee Motivation Levels Motivating Employees Topic A: Communicate Effectively Topic B: Clarify Expectations Topic C: Establish Meaningful Professional Goals Topic D: Provide Effective Feedback Topic E: Choose Rewards or Recognition Developing Self-Motivation in Employees Topic A: Encourage Self-Motivation Topic B: Create a Sense of Employee Ownership Topic C: Provide Development Opportunities through Mentoring Topic D: Build a Sense of Accomplishment Topic E: Encourage Enthusiasm Establishing a Foundation for Performance Management Topic A: Identify Performance Management Elements Topic B: Elicit Engagement Topic C: Onboard New Employees Topic D: Develop Talent Optimizing Employee Performance Topic A: Assess Available Talent Via Interviews Topic B: Determine Individual Performance Goals Topic C: Discuss Performance Appraisals Creating Performance and Development Plans Topic A: Initiate a Performance Plan Topic B: Create an Improvement Plan for Performance Problems Topic C: Create a Development Plan for Career Growth