890 Courses in Leicester

What is Microneedling & BioRePeel? Microneedling is a popular treatment in staying youthful. It’s a procedure that uses fine needles to puncture the skin and create a controlled skin injury in order to rejuvenate skin. It’s also called skin needling, collagen induction therapy (CIT), and percutaneous collagen induction (PCI). During the procedure, a topical numbing cream is applied and then a mechanical derma pen ( we do not use derma rollers) is used to insert tiny needles into the skin to cause microinjuries or punctures. The idea is that the damage caused by the needles encourages your body to send healing agents (elastin and collagen) to the cuts to repair them. By making tiny columns of trauma in the dermis, the body is forced to make new collagen to fill them in and heal them. This new collagen makes skin look and feel slicker, tighter, and more youthful. BioRePeel is an innovative peel treatment, using patented 2-phase technology. This provides a bio-stimulating, revitalising and peel-like effect. The combination of these components results in a mild exfoliation, stimulating the biosynthetic process, restoring the structure of the skin. This process decreases damage from UV light, pigmentation and acne scars and effectively preventing the ageing of skin. The treatment is suitable for all skin types, including those with fine line wrinkles, acne, fresh scarring and blackheads. Please confirm dates and availability with us prior to purchasing Who Is This Course Suitable For? These are advanced treatments so you will need to have a relevant level 3 qualification. If you are a beginner then you can complete the VTCT Level 3 Access to Aesthetic Therapies which included Level 2 Facial Therapy . The link above has full details. If you are unsure, please contact us. Course Content You will cover; Client Consultation & Contraindications Skin Types & Conditions Microneedling with Epidermal Growth Factors Microneedling with BioRePeel BioRePeel protocols Course Duration & Cost You will be required to do home study of treatment theory before you attend the practical training. This will allow more time to work on models and get hands on experience. Full day course £599 Why Choose Us? This course will allow you to offer the most on trend and in demand treatments that are results driven. The key to a successful business is to offer services that clients will want to keep coming back for. All of the treatments within this diploma have proven results which will support you in customer retention. We do not offer online courses for treatments that require the skill that can only be performed in front an experienced trainer. We ensure we offer a practical course that allows you to work on 2 models per treatment. We want you to be confident in the skill so you can start your business straight away. We are not an Academy and we take pride in this. This means we offer more than just training you in a skill. We understand how difficult and overwhelming it can be to start a new business and our ethos is to provide guidance and support to get you started. All our sessions have an option of 1-2-1 sessions for a personalised experience and have a maximum of 4 students per session. Your journey with us doesn’t end in the practical training session. When you train with Elixir Skin Training you become a part of our brand. We stay in touch with all our graduates and provide that motivation to get you going, which you will not find in large Academies. Quality of training is important but so is what comes after- we support you in every aspect because we want to see you build your business. Categories: Advanced Skin Care Courses, Skin Injectables

Gold CSCS Card NVQ Level 3 Advanced craft This is the NVQ that provides those with the relevant experience to showcase their knowledge, skills and understanding in advanced craft. You will be required to provide evidence of more technical projects. The award requires you to support a team through setting constantly high standards. You will work in one of the following areas: Trowel Occupations (Bricklayer) Painting and Decorating Wall and Floor Tiling 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.

Gold CSCS Card NVQ Level 3 Advanced craft This is the NVQ that provides those with the relevant experience to showcase their knowledge, skills and understanding in advanced craft. You will be required to provide evidence of more technical projects. The award requires you to support a team through setting constantly high standards. You will work in one of the following areas: Trowel Occupations (Bricklayer) Painting and Decorating Wall and Floor Tiling 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.

Are you an EDI Officer, HR Specialist, Leader or Manager? Or the nominated EDI champion for your team? Maybe you've been given the EDI portfolio on behalf of your Board or department? Or if you're aiming to make a difference via your diverse staff network or union, all change-makers are welcome!

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

Developing the Business Case: In-House Training Business analysts must be able to create business case documents that highlight project benefits, costs, and risks. The business case is based on the real business need to be solved. These become parts of proposals, feasibility studies, and other decision support documents. This course teaches the purpose, structure, and content of a business case. It presents the basic techniques for determining financial ROI, non-tangible benefits, and the probability of meeting expectations. What you will Learn At the end of this program, you will be able to: Perform feasibility studies Justify the business investment to solve the business problem Prepare an effective business case document Plan and implement a business case approval process Foundation Concepts The role of the BA An introduction to the BABOK® Guide The business analyst and the product / project life cycle (PLC) The business case deliverable Introducing the Business Case Process The BA and strategy analysis The BA and the business case process (BCP) The BA during the business case process (BCP) The BA after the business case process (BCP) Importance of defining solution performance metrics Defining the Business Need Overview of defining the business need Business needs: problem / opportunity statement Product vision Objectives and constraints Exploring Business Case Solutions Overview of exploring solutions Solution identification for feasibility Solution definition for analysis Assessing project risks Justifying the Business Case Overview of justifying the business case Qualitative justification Quantitative justification Approving the Business Case Overview of business case approval Developing recommendations Preparing the decision package - documents Preparing the decision package - presentations

Discussion of past issues Support Divorce aftermath coaching Confidence building Self-assessment Analysation Dating support Dating assistance Emotional intelligence Dating languages training 7 sessions 45 mins https://relationshipsmdd.com/relationship-advice-for-men/

Introducing Crisis Life Coach Package: Navigating Challenges and Rediscovering Your Strength Are you currently facing a crisis or challenging situation that is causing distress and uncertainty in your life? Miss Date Doctor’s Crisis Life Coach Package offers you targeted support and guidance from a trained life coach to help you navigate through crises, regain stability, and transform challenges into opportunities for growth. Life can present unexpected hurdles that leave us feeling overwhelmed and lost. Our experienced crisis life coaches are dedicated to helping you harness your inner resilience, develop coping strategies, and create a path forward amidst difficult circumstances. Here’s how the Crisis Life Coach Package can support you: Personalized Assessment: Our crisis life coach will conduct an initial assessment to understand your situation, concerns, and immediate needs. Stabilization Strategies: We’ll work on strategies to help you manage immediate crisis-related stress and anxiety. Crisis Transformation: Our life coach will guide you in reframing challenges as opportunities for personal growth and positive change. Coping Techniques: We’ll equip you with practical coping techniques to manage emotions and navigate stressors. Goal Setting: Together with your life coach, you’ll set realistic short-term and long-term goals to work towards during and after the crisis. Resilience Building: Crisis life coaching focuses on building emotional and mental resilience to handle adversity with strength. Actionable Steps: Our coach will provide you with actionable steps and strategies to implement in your daily life. Supportive Partnership: The Crisis Life Coach Package offers you a supportive partnership to guide you through challenging times. The Crisis Life Coach Package at Miss Date Doctor is designed to provide you with targeted support during moments of crisis. Our experienced life coaches are committed to helping you find clarity, develop coping skills, and navigate the path towards renewal and transformation. Invest in your well-being and take the first step towards resilience with the Crisis Life Coach Package. Embrace the opportunity to transform challenges into opportunities for growth, navigate through crises, and emerge from them stronger than before. Let our skilled life coach guide you towards a brighter and more empowered future. 3 X 1 HOUR and daily calls https://relationshipsmdd.com/product/crisis-life-coach-package/

Scrum Product Owner Workshop: In-House Training The Product Owner is responsible for maximizing the value of the product and the work of the Development Team. The Product Owner must be knowledgeable, available, and empowered to make decisions quickly in order for an Agile project to be successful. The Product Owner's key accountability is the Product Backlog. Managing, maintaining, and evolving the Product Backlog involves: Establishing a clear Vision that engages the Development Team and stakeholders Clearly expressing Product Backlog items Ordering the items in the Product Backlog to best achieve the Vision and goals Ensuring that the Product Backlog is visible, transparent, and clear to all Working with the Development Team throughout the project to create a product that fits the customer's needs The overall course goal is to support you in becoming an effective Product Owner. What you will Learn You'll learn how to: Differentiate between poor, good, and great Product Owner attributes, and their impact on the team, product, stakeholders, and the organization Engage your stakeholders by knowing your customers and market Develop an effective and value-driven Product Backlog Evaluate the Product Owner's role in Scrum's 5 events and team engagement Foundation Concepts Agile foundation Product owner role Product Ownership Product ownership Project vision Understanding your customers and market Personas Stakeholder management and engagement The Product Backlog Epics and user stories Preparing user stories for a sprint The product backlog Visualizing the product backlog Product backlog prioritization Technical debt Sprint Planning and Delivery Sprint planning The sprint Sprint Reviews, Retrospectives, and Closing Sprint reviews Key agile patterns Retrospectives Closing the project

Well-being isn't just a 'nice to have' - it should be a core part of your employee strategy.