5415 Productivity courses in Cardiff 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.

Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Diploma in HACCP Training will assist you in producing the best possible outcome by mastering the skills. Those who want to succeed must enrol in the course Diploma in HACCP Training. By completing this course, you will acquire the skills required to become an expert in a comparable field. The basics of our Diploma in HACCP Training course are covered first, and then we move on to more advanced material. The lessons in this Diploma in HACCP Training course are therefore clear and easy to understand. Courses you'll get: Course 01: Diploma in HACCP Training Course 02: Food Hygiene & Safety Training-Level 1 Course 03: Food Hygiene and Safety Training for Retail-Level 2 Course 04: Food Labelling Course 05: Level 2 Food Hygiene and Safety for Catering Course 06: Food Handler Certificate: Food Safety & Food Hygiene Diploma in HACCP Training Course Basic Learning Outcomes: After completing this highly appreciated Diploma in HACCP Training course, you'll be a competent expert, besides- You can give assistance related to the Diploma in HACCP Training with complete knowledge and confidence. You'll be competent and proficient enough to explore Diploma in HACCP Training related job fields on your own. Furthermore, you can train up others and grow an efficient peer community in your locality and serve people. It will enhance your portfolio, you can use the certificate as proof of your efficiency to the employer. It will boost up your productivity, you can use the skill and credentials, and become more competent in your vocation with increased earning! Key Highlights of Diploma in HACCP Training Course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced Course Modules Curriculum Breakdown of the Course:- Module 01: An Introduction to HACCP Module 02: HACCP and Food Safety Legislation Module 03: Food Safety Hazards Module 04: Planning a HACCP System Module 05: Creating the HACCP System Module 06: Principle 1 - Hazard Analysis Module 07: Principle 2 - Critical Control Points Module 08: Principle 3 - Critical Limits Module 09: Principle 4 - Monitoring Critical Control Points Module 10: Principle 5 - Corrective Action Module 11: Principle 6 - Verification of the HACCP System Module 12: Principle 7 - Documentation Module 13: Implementing the HACCP System Module 14: HACCP Alternatives Certification: CPD Accredited (CPD QS) Certificate Digital (PDF) & Hardcopy certificates are available CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Diploma in HACCP Trainingcourse. This course particularly recommended for- Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Requirements Students seeking to enrol for Diploma in HACCP Trainingcourse should meet the following requirements; Basic knowledge of English Language Be age 16 years or above Basic Knowledge of Information & Communication Technologies for studying online or digital platform. Stable Internet or Data connection in your learning devices. Career path After completing this course, you can explore trendy and in-demand jobs related to Diploma in HACCP Training. Explore each of the roles available and how you can start your career in this platform. Certificates Certificate of completion Digital certificate - Included After successfully completing this course, you can get CPD accredited digital PDF certificate for free.

This course will start by covering the many benefits electricity brings to society, as well as its key components voltage, current and resistance. It will explain the two main types of electricity, cover UK accident and death statistics, and describe a simple way of remembering the electrical hazards. It then goes on to provide basic instructions about how you could safely help someone you suspect has received an electric shock.

This course acts as an introduction to personal safety for lone workers and applies to those that work alone within business premises, mobile workers and homeworkers. It covers the legal responsibilities of both employers and employees, some of the common security precautions that can be implemented, practical steps you can take to avoid conflict in lone worker situations and other elements that can contribute to lone worker safety.

Is your lifestyle too sedentary? Do you feel sluggish by the end of the day? Wrecked by the end of the week? You need to vary your regime at work. You need to work with, rather than against, your physicality in order to boost your energy levels in a sustainable way - without recourse to coffee, sugar or other stimulants. Take away: Four quick and easy ways to make you feel good and re-energised. You will have the opportunity to: Explore how even just small amounts of physical activity can impact your mental and general health and wellbeing, creativity and productivity. Learn what to do about a sedentary lifestyle Get some tips on what to do about your posture Deskercise - try out some easy stretches and exercises you can do at your desk

Overview Learn how to turn your business or organisation into a streamlined and efficient group that is capable of greatness. This Understanding Lean Organisation Management course provides the knowledge and tools to embrace truly effective business improvement practises from Lean culture quickly. Written with the aid of industry experts, you will be taught the principles of Lean organisation techniques and how to put them to immediate practical use. You will also be given masterclasses in promoting excellent teamwork and eliminating 'waste' from existing processes in your business. Upon completion of the training, the productivity and performance of your organisation is sure to improve. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Understanding Lean Organisation Management . It is available to all students, of all academic backgrounds. Requirements Our Understanding Lean Organisation Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 13 sections • 13 lectures • 03:30:00 total length •Module 1: Understanding Lean: 00:22:00 •Module 2: The Lean Culture: 00:19:00 •Module 3: The Five Principles of Lean: 00:10:00 •Module 4: Value and Waste: 00:19:00 •Module 5: Value Stream Mapping (VSM): 00:19:00 •Module 6: The Principles of Flow and Pull: 00:14:00 •Module 7: Overview of Six Sigma: 00:11:00 •Module 8: The Define Phase: 00:18:00 •Module 9: The Measure Phase: 00:21:00 •Module 10: The Analyse Phase: 00:22:00 •Module 11: The Improve Phase: 00:21:00 •Module 12: The Control Phase: 00:14:00 •Assignment - Understanding Lean Organisation Management: 00:00:00

Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Leadership, Project Management and Data Analysis - 3 in 1 course will set you up with a solid foundation to become a confident manager and develop more advanced skills. This comprehensive course is the perfect way to kickstart your career in the field of management. 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. How Will I Benefit? Boost your career in management Deepen your knowledge and skills in your chosen field just in hours not years! Study a course that is easy to follow. Save money and time by studying at your convenient time Have access to a tutor whenever you are in need So, what are you thinking about! Start getting the benefits by enrolling today! Why Choose Lead Academy: Lifetime Access High-quality e-learning study materials Learn the most in-demand skills Self-paced, no fixed schedules 24/7 customer support through email Available to students anywhere in the world No hidden fee Study in a user-friendly, advanced online learning platform Who is this course for? This comprehensive 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 management. Entry Requirement There are no academic entry requirements for this 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. Career path This course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Diploma in Leadership and Management at QLS Level 4 Personal Effectiveness - How to be an Awesome Professional Monday: Self-confidence Tuesday: Personal Time Management Wednesday: Assert Yourself Thursday: Problem Solving Friday: Presenting Managing Individuals - Howto Get the Best From Your People Monday: Goal Setting Tuesday: Delegation Wednesday: Feedback Thursday: Poor Performance Friday: Coaching Communication Skills - How to Make Your Management Voice Heard Monday: Listening Tuesday: Motivating Wednesday: Meetings Thursday: Negotiating riday: Conflict Team Management - How to Create and Keep a High Performance Team Monday: The Power of Teams Tuesday: Team Development Wednesday: Team Maintenance Thursday: The Four Essentials of Team Management Friday: Team Meetings Manager's Toolkit - How To Adapt to Whatever The Job Throws at You Monday: Emotional Intelligence Tuesday: Transactional Analysis Wednesday: The SCOPE Process Thursday: Selecting Management Styles Friday: The Powerhouse Loop Friday: The Powerhouse Loop Resources - Leadership & Management Level 4 Change Management and Leadership for Managers Introduction: Change at Work Step 1: Demonstrate the Need for Change Step 2: Create a Compelling Future Step 3: Expect an Argument Handling Resistance Steps 4, 5 & 6: Leading the Change Resources Data Analysis Data Analysis 101 Assessment

This course defines behavioural safety and explains the origins of the concept. It covers how it can be implemented in the workplace and some of the potential benefits. It includes analysis of some examples of ‘at risk behaviours’ and some examples of ways you can measure how well your organisation is doing when it comes to safety. Finally it touches on some of the key laws regarding health and safety in the workplace and how to ensure positive workforce attitudes.