874 Courses in Bristol

PRINCE2 Agile® Foundation: In-House Training PRINCE2 Agile® provides structure, governance, and control when working with agile concepts, methods, and techniques. It is a solution combining the flexibility and responsiveness of Agile with the clearly defined framework of PRINCE2. PRINCE2 Agile® framework covers a wide range of agile concepts, including SCRUM, Kanban, and Lean Startup. The PRINCE2 Agile® Foundation certificate is designed to help professionals deliver agile projects by tailoring PRINCE2® management controls with a broad toolset of agile delivery techniques and frameworks. PRINCE2 Agile® is an extension module tailored for forward-thinking organizations and individuals already benefiting from PRINCE2®. It provides further guidance on how to apply agile methods to the world's most recognized project management method. The purpose of the Practitioner qualification is to demonstrate that you can apply and tailor PRINCE2 Agile® in a scenario situation. What you will Learn Understand the key aspects of PRINCE2® Understand basic concepts behind common agile ways of working Demonstrate the purpose of combining PRINCE2® with agile Be able to fix and flex the aspects of a project in an agile context Apply the PRINCE2® principles and tailor the themes, processes, and management products to a project in an agile context Incorporate the areas that can support a PRINCE2 Agile® implementation To prepare Participants for the PRINCE2 Agile® Foundation exam Benefits Agile methods allow organizations to realize the benefits of products and potentially an earlier return on investment while products are being developed and improved. Improved communication through the use of common terminology across PRINCE2® and agile disciplines. Develop a clear definition of how agile can govern a project's delivery, while PRINCE2® governs projects as a whole. Seamless integration: PRINCE2 Agile® will complementPMBOK® GuideandAPM Body of Knowledge®just as PRINCE2® does currently. It will also be of interest for Program Managers with MSP® who need to understand how projects relate to the delivery mechanism. The most up-to-date and relevant view of Agile project management methodologies, PRINCE2 Agile® references the 'flow-based' working featured in Kanban in addition to other agile concepts not covered in other qualifications. Introduction - Getting Started Part 1 An overview of PRINCE2 Agile Overview Blending PRINCE2 and Agile What to fix and what to flex Part 2 Agile behaviors ad the PRINCE2 Principles Agile and the PRINCE2 Themes Part 3 Focus areas Agile and the PRINCE2 Processes Examination preparation Examination. Summary - What did we learn, and how can we implement this in our work environment?

Agile Release Plans: In-House Training While many Agile frameworks provide guidance on a focus on value and iterative development, many do not explain how that value is delivered to the customer. Release Plans have become an accepted and common practice to bridge the gap between the Product Vision and the Product Backlog (Agile requirements). In this course, you will be provided with an introduction to Agile and to Scrum, the most utilized Agile framework. You will also learn how the Vision, Roadmap, and Charter help to establish the Release Plan. The goal of this course is to equip you with the necessary knowledge, skills, and techniques to build Release Plans to ensure you deliver the most value to your customers. What you will Learn At the end of this program, you will be able to: Recall the Scrum framework elements (roles, events, and artifacts) Examine the benefits of Agile Develop a Product Vision and Roadmap Create an Agile Project Charter Prepare a Release Plan Write user stories to support a Product Backlog Foundation Concepts Introduction to Scrum Scrum Overview Agile Benefits Product Definition Business Goals Product Vision Product Roadmap Agile Project Charter Product Scope Project Risks Release Deadlines Sprint Durations Team Norms Release Planning Release Plan Process Select Stories and a Release Date Product Backlog User stories Building the product backlog Product Backlog Refinement Transitioning to the Scrum Team

The NVQ Level 2 Diploma in Insulation and Building Treatments provides a nationally recognised qualification for those working in the construction and the built environment sector and specialise in one or more of the following categories: Cavity Wall Insulation Solid floor Insulation Under Floor Insulation Cold Roof Insulation Wall Tie Replacement Wood Preserving & Damp Proofing The qualification modules will be discussed and agreed upon with each individual candidate to ensure that the qualification will be suited to your job role and will be achievable in order to demonstrate their competence and become eligible for the Blue CSCS Card. Each candidate will be allocated a designated and qualified assessor to provide support throughout the qualification and provide information, advice and guidance to candidates in order that they can achieve the qualification. If you require further information or are looking to undertake this qualification, please contact us. CSCS Cards Candidates can undertake the CSCS test and obtain the red (Provisional) CSCS card on signing up for various qualifications. The red card can usually be obtained within 7 to 14 days and can be used to access the construction sites for a period of 12 months. On completion of the qualification, you will receive a full 5 year CSCS card.

Introducing Therapy for Repressed Emotions Package: Unlocking Emotional Freedom and Healing Are you struggling with repressed emotions, finding it difficult to express and process your feelings from the past? Miss Date Doctor’s Therapy for Repressed Emotions Package offers you compassionate support and guidance to unlock emotional freedom, heal past wounds, and embrace a healthier emotional state. Repressed emotions are feelings that have been pushed aside or buried due to various reasons, leading to unresolved emotional baggage. Our experienced therapists are dedicated to helping you navigate through these suppressed emotions, fostering emotional release, and promoting healing. Here’s how the Therapy for Repressed Emotions Package can support you: Understanding Repressed Emotions: Our therapists will help you understand the nature of repressed emotions and how they impact your current emotional well-being. Creating a Safe Space: We offer a safe and non-judgmental environment where you can freely explore and express your suppressed emotions. Emotional Release: Therapy will focus on facilitating emotional release, allowing you to process and express feelings that have been held back. Healing Past Wounds: We’ll work on addressing and healing the unresolved emotional wounds from the past. Coping Strategies: Our therapists will equip you with healthy coping strategies to manage overwhelming emotions as they arise. Self-Compassion and Acceptance: Therapy encourages self-compassion and self-acceptance as you navigate through your emotional journey. Building Emotional Resilience: We’ll focus on developing emotional resilience to face and process emotions in a healthy way. Mindfulness Practices: Therapy for repressed emotions may incorporate mindfulness techniques to cultivate present-moment awareness. The Therapy for Repressed Emotions Package at Miss Date Doctor is designed to empower you to release the emotional burden of the past and find emotional freedom. Our compassionate therapists provide gentle guidance and support to help you navigate through your emotional journey. Invest in your emotional well-being and take the first step towards unlocking emotional freedom with the Therapy for Repressed Emotions Package. Embrace the opportunity to heal past wounds, express your feelings, and foster a healthier emotional state. Let our experienced therapists guide you towards emotional release, healing, and a brighter emotional future. 8 SESSIONS X 1 HOUR https://relationshipsmdd.com/product/therapy-for-repressed-emotions-package/

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/

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

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.

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