918 Courses in Leeds

Introducing Adjustment Counselling Package: Navigating Life Transitions and Embracing Change Are you facing challenges in adjusting to major life transitions and seeking support to cope with change? Miss Date Doctor’s Adjustment Counselling Package offers you a compassionate and understanding space to navigate through life’s adjustments and embrace positive transformation. Life transitions, such as moving to a new city, starting a new job, or going through significant life changes, can be overwhelming and emotionally taxing. Our experienced counsellors are here to help you navigate these adjustments, find coping strategies, and embrace change with resilience and optimism. Here’s how the Adjustment Counselling Package can support you: Understanding Transitions: Our counsellors will help you understand the nature of the life transition you are experiencing and its impact on your emotions and well-being. Coping with Change: Adjustment counselling equips you with coping strategies to manage stress, anxiety, and uncertainty during times of change. Supportive Environment: Our counsellors provide a safe and non-judgmental space where you can freely express your feelings and concerns related to the adjustment process. Finding Balance: We’ll work with you to find a balance between embracing change and maintaining stability in other areas of your life. Creating a Support System: Adjustment counselling helps you identify and build a support system to lean on during times of transition. Growth and Resilience: As you navigate through adjustments, our counsellors will help you discover strengths and develop resilience to embrace change positively. Setting Realistic Expectations: We’ll assist you in setting realistic expectations for yourself during the adjustment period, fostering self-compassion and patience. Embracing New Opportunities: Adjustment counselling can help you see transitions as opportunities for growth and new experiences. The Adjustment Counselling Package at Miss Date Doctor is designed to empower you to navigate life’s transitions with grace and confidence. Our compassionate counsellors provide guidance and support to help you find stability, embrace change, and thrive through life’s adjustments. Invest in your well-being and take the first step towards embracing change with the Adjustment Counselling Package. Embrace the opportunities for growth and transformation that life transitions bring. Let our skilled counsellors guide you towards a more resilient, positive, and fulfilling journey through life’s adjustments. 3 x 1 hour https://relationshipsmdd.com/product/adjustment-counselling-package/

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.

Introducing “Hire a Therapist” Package: Personalized Support for Your Mental Health and Emotional Well-being Are you considering seeking professional support for your mental health and emotional well-being? Miss Date Doctor’s “Hire a Therapist” Package offers you personalized and confidential counselling sessions with experienced therapists to help you navigate life’s challenges, overcome obstacles, and achieve personal growth. Therapy provides a safe and supportive space to explore your thoughts, emotions, and concerns with the guidance of a skilled therapist. Our team of dedicated therapists is committed to helping you enhance your overall well-being and lead a more fulfilling life. Here’s how the “Hire a Therapist” Package can support you: Personalized Assessment: Our therapists will conduct a thorough assessment to understand your unique needs and goals for therapy. Individualized Approach: Your therapy sessions will be tailored to address your specific concerns and support your personal growth. Emotional Support: We offer a compassionate and non-judgmental environment where you can freely express your feelings and experiences. Confidentiality: Your therapy sessions are completely confidential, ensuring a safe space for open and honest communication. Coping Strategies: Our therapists will equip you with practical coping strategies to manage stress, anxiety, and other emotional difficulties. Self-Exploration: Therapy encourages self-discovery and self-awareness, helping you gain insights into your thoughts, behaviours, and emotions. Goal Setting: Together with your therapist, you’ll set achievable goals to work towards positive change and personal growth. Flexible Sessions: “Hire a Therapist” Package offers flexibility in scheduling sessions, accommodating your availability and preferences. The “Hire a Therapist” Package at Miss Date Doctor is designed to provide you with personalized support and guidance on your journey to better mental health and emotional well-being. Our skilled therapists are committed to helping you overcome challenges, enhance your resilience, and lead a more fulfilling life. Invest in your mental and emotional health and take the first step towards positive change with the “Hire a Therapist” Package. Embrace the opportunity to explore your thoughts and feelings in a confidential and supportive environment. Let our experienced therapists guide you towards a brighter and more empowered future. 3 x 1 hour sessions https://relationshipsmdd.com/product/hire-a-therapist-package/

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/

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

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/

Introducing the Dating Profile Consultant Package: Expert Guidance for an Outstanding Online Dating Presence Are you looking to maximize the impact of your online dating profile and improve your chances of connecting with compatible matches? Miss Date Doctor’s Dating Profile Consultant Package offers you personalized support and insights from experienced consultants who specialize in optimizing online dating profiles. Crafting an effective online dating profile requires a strategic approach and understanding of what resonates with potential matches. Our dedicated dating profile consultants are here to assist you in creating a profile that showcases your unique qualities and attracts genuine connections. Here’s how the Dating Profile Consultant Package can support you: Personalized Evaluation: Our dating profile consultants will conduct a thorough evaluation to understand your personality, preferences, and dating objectives. Strategic Profile Enhancement: We’ll collaborate with you to strategically enhance your profile text, photos, and overall presentation. Photo Selection and Arrangement: Our experts will guide you in selecting and arranging photos that project a genuine and appealing image. Compelling Bio Creation: We’ll assist you in creating a compelling and authentic bio that piques the interest of potential matches. Showcasing Your Uniqueness: Our consultants will work with you to emphasize your unique qualities and values that make you stand out. Initiating Engaging Conversations: We’ll provide insights into starting conversations and maintaining engaging communication with your matches. Boosting Self-Confidence: The Dating Profile Consultant Package aims to boost your confidence by helping you create a polished and attractive profile. Attracting Compatible Matches: We’ll focus on attracting matches who align with your dating preferences and aspirations. The Dating Profile Consultant Package at Miss Date Doctor is designed to empower you with a refined and attention-grabbing online dating profile. Our experienced dating profile consultants offer personalized guidance and practical tips to help you make a lasting impression in the online dating world. Invest in your online dating success and take the first step towards an optimized dating profile with the Dating Profile Consultant Package. Embrace the opportunity to present your best self and attract matches that resonate with your personality and interests. Let our consultants guide you towards an elevated online dating experience filled with meaningful connections. 15 pictures AI approved dating app high standard excellence photos 4×1 hour sessions https://relationshipsmdd.com/product/dating-profile-consultant/