1316 Courses

Feedback Mastery Unleashed: 28 day online mini-programme to ignite high performance leadership for high achieving teams

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.

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

How to Fix Lower Back Pain in Just 21 Days  When back pain strikes, it can ruin your life. Reaching for painkillers or having surgery can be ineffective and even dangerous for your health. Chronic pain affects 100 million people each year, and low back pain is the most common complaint. When the body's pain signals keep firing in the nervous system, it can have a draining effect on the quality of life-physically, mentally, and spiritually. In the United States, 8 out of 10 people will experience low back pain at some time in their lives. Low back pain is the second most frequent reason for doctor visits, next to the common cold, and it is the leading cause of job-related disabilities. What you'll learn You will learn the 9 worst back exercises for back pain (with better alternatives) You will learn a highly effective 21-day, 30-minutes or less, back pain exercise routine You will learn a 15-minute, Doctor-recommended back pain exercise routine You will learn 6 foam rolling moves to conquer back pain You will learn a 6-minute emergency back pain treatment that's safe for both herniated and bulging discs You will learn 7 exercises you need to be doing to prevent back spasms and herniated discs You will learn 7 resistance-band exercises that will help strengthen your low back and hips And You will learn 4 moves to do before you roll out of bed in the morning Requirements You should have basic computer skills and access to a wifi connection No fancy gym equipment is needed. All you need is a comfortable surface like a carpet, rug or yoga mat. You will need to 15-30 minutes a day to do this at home back pain relief exercise routine. You will also need the will and determination to do the exercises. I did them for 21 days and BOOM - my back pain vanished! So can yours if you follow my program. Low Back Pain Relief Secrets Welcome to Low Back Pain Relief FREE 00:02:00 4 Most Common Reasons for Lower Back Pain FREE 00:02:00 9 Worst Back Exercises for Back Pain 00:04:00 21 Day Low Back Pain Relief 00:15:00 15 Minute Doctor 00:08:00 Top 7 Exercises To Prevent 00:05:00 6 Minute Emergency Back Pain Treatment 00:03:00 7 Resistance Band Exercises for Low Back Pain 00:06:00 6 Foam Rolling Moves to Conqier Back Pain 00:03:00 4 Moves To Do Before You Roll Out of Bed 00:02:00 Bonus Better Posture Reports Prolonged Sitting and Back Pain 00:10:00 Stand The Right Way in 8 Moves 00:10:00 6 Exercises to Reverse Bad Posture 00:10:00

Course Description Get instant knowledge from this bite-sized Cattery Management Part - 1 course. This course is very short and you can complete it within a very short time. In this Cattery Management Part - 1 course you will get fundamental ideas of cattery management, the key understanding of designing your cattery, equipment required and so on. Enrol in this course today and start your instant first step towards learning about catteries. Learn faster for instant implementation. Learning Outcome Familiarise with catteries Understand the planning and designing of your cattery Gain in-depth knowledge of the equipment required and daily routine Learn about licences and legislation How Much Do Cattery Managers Earn? Senior - £135,000 (Apprx.) Average - £69,000 (Apprx.) Starting - £36,000 (Apprx.) Requirement Our Cattery Management Part - 1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Cattery Management Part - 1 Module 01: Introduction to Catteries 00:14:00 Module 02: Licences and Legislation 00:18:00 Module 03: Planning and Designing your Cattery 00:24:00 Module 04: Equipment Required and Daily Routine 00:19:00 Assignment Assignment - Cattery Management Part - 1 00:00:00

Course Description Get instant knowledge from this bite-sized Phlebotomist Training Part - 1 course. This course is very short and you can complete it within a very short time. In this Phlebotomist Training Part - 1 course you will get fundamental ideas of phlebotomy, the key understanding of blood circulation, function and so on. Enrol in this course today and start your instant first step towards learning phlebotomy. Learn faster for instant implementation. Learning Outcome Understand phlebotomy Gain in-depth knowledge of the blood circulation, function, and composition Deepen your understanding of phlebotomy equipment Understand routine venipuncture Learn about venipuncture complications and pre-examination variables How Much Do Phlebotomists Earn? Senior - £39,000 (Apprx.) Average - £25,000 (Apprx.) Starting - £16,000 (Apprx.) Requirement Our Phlebotomist Training Part - 1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Phlebotomist Training Part - 1 Introduction to Phlebotomy 00:17:00 Blood Circulation, Function, and Composition 00:27:00 Phlebotomy Equipment 00:16:00 Routine Venipuncture 00:24:00 Venipuncture Complications and Pre-Examination Variables 00:26:00 Assignment Assignment - Phlebotomist Training Part - 1 00:00:00

Description Pilates Trainer Professional Diploma Pilates is a physical fitness system developed in the early 20th century by Joseph Pilates. Pilates improves flexibility, strength and develops control of the entire body. It emphasises on alignment, breathing, building a strong core and improving coordination and balance of the body. Pilates helps alleviate lower back pain and helps the elderly live a healthy life. Pilates helps practitioners have better posture, makes them less prone to injury and lets them experience good health. Routine following Pilates builds flexibility of the body, strength, endurance and coordination without bulking up the person. It has been widely used by dancers, gymnasts as well as actors to maintain a healthy body. The course helps to train oneself to be a professional Pilates trainer. It can be taken up without affecting the daily routine, course of study or job. The course will also benefit those who are already engaged in the fitness industry. An additional diploma in Pilates will enhance the opportunities to train a wide range of people and add variety to the fitness regime. The course offers insights from the fundamentals of the Pilates system and guides the learner to run his/her own classes. The eight units will give the learner knowledge that he/she can integrate into a variety of disciplines, such as yoga or dance. The learner can also apply it as his/her specialised area. It is also desired that a Pilates teacher is a good communicator, patient, persistent, organised, creative, sociable and an effective motivator. To motivate the trainees, he/she should lead a healthy lifestyle and be a role models for them. This course will help the learner to be well-versed in the science of human body movement and its adaptations to different situations. It will enable the learner to develop and apply solutions in varying circumstances and according to the requirement of each individual. The ones taking the course will find employment in Pilates studios, health centres, fitness centres, and community centres and can also become personal trainers. What you will learn 1: DEVELOPING YOURSELF AS A PILATES TRAINER 2: THE BENEFITS OF PILATES 3: THE EIGHT PRINCIPLES OF PILATES 4: BASIC ANATOMY 5: PREVENTING INJURY 6: PILATES IN PREGNANCY 7: PILATES ON THE BALL 8: RELAXATION AND IMAGERY Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Build your foundation on Phlebotomy Training. Explore the ins and outs of venipuncture. Learn Routine Venipuncture, Special Blood Collection Procedures, and Venepuncture for Blood Donation.

Discover the secrets of crafting the perfect espresso from the comfort of your home with our interactive Home Barista Workshop at Etude Coffee. In this immersive two-hour session, set in the inviting atmosphere of our local roastery, you'll explore the essentials of espresso creation under the guidance of our expert baristas. Designed for coffee lovers at any skill level, this workshop is dedicated to unraveling the intricacies of using a home espresso machine. From selecting the ideal beans to achieving the perfect grind and tamp, you'll gain hands-on experience in extracting that flawless espresso shot. Moreover, we'll delve into the art of milk texturing, enabling you to prepare velvety smooth lattes and cappuccinos that elevate your home coffee experience to new heights. Whether you're a novice aiming to improve your morning coffee routine or a seasoned enthusiast looking to polish your espresso-making skills, this workshop offers valuable insights, practical expertise, and a warm community of coffee aficionados.