MySQL server admins training course description This MySQL Server administration course is designed for MySQL Server administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands. The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, backing up and recovering data and optimising query performance. This MySQL Server administration course also covers MySQL replication and its role in high availability and scalability. What will you learn Use MySQL Workbench. Install and configure a MySQL Server . Administer and tune a MySQL server. Configure log files and interpret error messages.. Secure the Server. Administer a replication topology. MySQL server admin training course details Who will benefit: Database administrators, Database developers and Technical consultants. Prerequisites: Introduction to MySQL Duration 5 days MySQL server admin training course contents Introduction to Oracle Application Express APEX concepts APEX main components Workspaces, database applications and websheet applications Creating a workspace The Workspace Administrator Upgrading APEX Logging into APEX Running an application SWL Workshop Use APEX to browse, create and modify objects Process ad hoc SQL statements Manage scripts in APEX Create, run and save SQL queries Build a database application Application components Create an application Create an application from a spreadsheet Create reports Create reports using wizards Edit report attributes Add links to reports Create a link to a printer-friendly version of a report Save and print reports in different formats Using files Uploading images Creating cascading stylesheet files Uploading static files Adding an Image as an application logo Adding a reference to a Javascript file Pages and regions Web form behaviour in APEX Create a form based on a table Create a form based on a procedure Create a form with a report Create a tabular form Format a form Locking in APEX forms Creating lists of values Overview of application express shared Components Dynamic and static lists of values Create a dynamic list of values Create a static list of values Use a list of values to control data in a report Create a cascading list of values Items and buttons Understand the different Types of items Create items Understand and edit item attributes Use Javascript with item Manipulate items in tabular forms Add dynamic items to a report Create and edit buttons Page Processing Page rendering and page processing Create computations Validate input data Process Data Understand application branching Create conditional branches Shared components Overview of application express navigation components Manage parent and standard tabs Create navigation bar entries Create and use lists and list items Manage breadcrumbs Create shortcuts Shared component subscription User interface defaults Display dynamic content Filter reports with dynamic queries Create charts with a wizard Format charts Create calendars Add links to calendars Create hierarchical trees State and debugging Understand session state Set a session state value Clear the session state Review the session state Review the messages in debug mode Enabling feedback Managing feedback and team development Themes and templates Switch to a different theme View existing templates Understand and manage templates Create a new template Add references to cascading stylesheet and Javascript files Dynamic actions and plug-in components Identify plug-in components and their types Plug In a component Create dynamic actions Use a plug-in in a dynamic action Building website applications Websheet applications and their components Create a websheet application Enable SQL and PL/SQL in a websheet application Add sections and pages to a websheet application Add links on a websheet page Add a data grid to a websheet application Create SQL reports ion websheet applications Add annotations to a websheet application Implementing security Authentication and authorization Provide an authentication scheme Create an authorization scheme using access control Enable and configure session state protection Deploy an appliction Define supporting objects Package an application Export an application Import an application Install supporting objects Administer Apex workspaces Manage workspaces and users Request a schema or storage Purge session state Monitor developer activity log Monitor workspace activity View activity reports Import a workspace Utility programs Import and export data Generate DDL statements View objects reports
Emotional Intelligence Training
Blue CSCS Card Level 2 NVQ Diploma in Construction Operations and Civil Engineering Services - Roadbuilding This qualification provides you with the opportunity to showcase their knowledge, skills and understanding in their chosen within the Civil Engineering and Highways Sector. You will have the relevant experience at least one of the 14 specific specialisms. You will work in one of the following areas: Pathway 1: Bituminous Paving - Machine Pathway 2: Concrete Paving - Machine Pathway 3: Slurry/Micro Surfacing - Machine Pathway 4: Slurry/Micro Surfacing - Manual Pathway 5: Surface Dressing - Machine Pathway 6: High Friction Surfacing - Machine Pathway 7: High Friction Surfacing - Manual Pathway 8: Planing - Machine Pathway 9: Road Recycling - Machine Pathway 10: Soil Stabilisation - Machine Pathway 11: Surface Retexturing - Machine Pathway 12: Pavement Marking - Machine Pathway 13 Pavement Marking - Manual operations Pathway 14: Pavement Marking - Road Studs 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.
If you got a call from a TV producer asking you to appear on Newsnight, would you say ‘yes’? And if you did, could you make your argument in a way that captured the attention of the audience without being interrupted? Our media training courses are aimed at senior spokespeople and experts who give interviews on TV, radio or in print. We equip them with the skills and confidence to take control and give engaging, memorable and effective performances in which they deliver their key messages, no matter what the circumstances. Highly interactive and practical, each course includes a series of realistic print, radio and television exercises with experienced journalists. We provide immediate feedback following each interview, including techniques for improvement, advice about potential answers and the framing of key messages. While all our media training courses are bespoke, on a typical course we will cover: how the media operates how to prepare for interviews the differences between TV, radio and print interviews how to conduct different types of interview, such as pro-active, reactive, expert commentator and hostile (crisis communications) developing key messages which convey your views persuasively how to take control of an interview, stick to your own agenda and deliver key messages successfully use of language, body language, dress and delivery After the course, each delegate receives the Rough House Media Toolkit, including written feedback, recorded copies of their interview exercises, the Rough House Media Guide to Interviews and further supporting materials. We also provide a confidential assessment to the PR team of each delegate’s suitability for different types of interview. Venue We deliver courses in the most appropriate format for your circumstances – whether face to face or online. Face to face courses are portable: they can be held in purpose-built studios, at your own offices or at an external venue. In the latter two cases, we create a mock studio for the practical exercises. Online courses give you flexibility and enable you to offer training to delegates from all over the world. We have run virtual courses for people from the Far East, South Asia, North America and Europe, as well as the UK.
About this Training Course Process Hazard Assessment using the HAZOP Technique is an intensely participative course that will both explain the key facets of the HAZOP technique as well as provide ample opportunities for participants to practice and become familiar with the technique using generic and real-life examples. HAZOP Team Leader Training is an intensely participative course that will develop participants already familiar with the HAZOP technique, the skills, knowledge and attributes of a HAZOP Team Leader. An in-depth syndicate exercise will provide the opportunity to lead a HAZOP team (consisting of other participants) and to be observed performing the role for constructive feedback. This 5 full-day course has been reviewed and approved by the Institution of Chemical Engineers (IChemE). IChemE is the global professional membership organisation for chemical, biochemical and process engineers and other professionals involved in the chemical, process and bioprocess industries. Their knowledge of professional standards, close involvement with industry, education and regulators, and their expertise as a leading global training provider, means they are uniquely positioned to independently assess and approve training courses and professional development programmes across the world. Training Objectives Process Hazard Assessment using the HAZOP Technique By the end of this course, participants will be able to: Understand the basic HAZOP Technique Fulfill roles as competent HAZOP Team Members Understand the role of HAZOP in risk management Understand how Hazard Identification can predict accidents and incidents Understand how HAZOP complements other hazard identification tool HAZOP Team Leader Training By the end of this course, participants will be able to: Understand the role of the HAZOP Team Leader Practise the role in a classroom environment Provide feedback to participants on their performance as HAZOP Team Leaders Appreciate the leadership skills required as HAZOP Team Leader Plan, organise, manage and successfully undertake a Hazard and Operability study Target Audience This course will benefit: All key persons in the organisation, who by their discipline and/or position, are likely to be called on to initiate, participate or review a HAZOP study. All who have responsibility for the management and supervision of process & safety including but not limited to Senior Management, Plant Managers, Process and Maintenance Engineers (all disciplines), Line Supervisors, Team Leaders, Safety Specialists, and Process Training Instructors. Course Level Basic or Foundation Trainer Your expert course leader has 50 years' experience in chemical and process safety engineering. His early career included 20 years in design and project engineering with various fine chemical and pharmaceutical companies where he designed chemical processes, specified plant equipment and selected materials for highly corrosive and toxic processes, often where textbook data was not available. This was followed by 10 years in offshore oil and gas design projects where he was responsible for setting up a Technical Safety group to change design safety practices in the aftermath of the 1988 Piper Alpha disaster. In recent years, he has been called upon to conduct various offshore and onshore incident investigations. His career has given him experience in project engineering, project management, process design and operations, safety engineering and risk management. He is a Fellow of the UK Institution of Chemical Engineers. He served on the Scottish Branch committee, and was elected chairman for a two-year term in 1991. He has also been chairman of the Safety and Reliability Society - North of Scotland Branch. He has delivered training courses in Process Hazard Analysis (HAZOP and HAZID), Process Safety Management, Hazard Awareness, Risk Assessment, Root Cause Analysis, Failure Modes & Effect Analysis and has lectured on Reliability Analysis to the M.Sc. course in Process Safety and Loss Prevention at Sheffield University. In addition to delivering training courses, he currently facilitates HAZOP / HAZID / LOPA studies and undertakes expert witness roles advising lawyers engaged in contractual disputes, usually involving the design or construction of chemical plants or Oil & Gas production facilities, or criminal prosecutions. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations
Gain advanced knowledge and practical skills in instructing buccal midazolam administration for epilepsy with our Level 4 Award course.
Personalized matchmaking services to find compatible singles based on your criteria and preferences. Coaching support from experienced dating coaches to help you navigate the dating world with confidence and ease. At least 4 to 6 dates within a four-month period. A comprehensive personality assessment to better understand your personality, values, interests, and lifestyle. Ongoing feedback and support throughout the matchmaking process. Premium service with a focus on quality matches and personalized attention. Access to our exclusive network of high-quality, successful singles. Guidance and advice on everything from creating a compelling dating profile to planning your first date. A fun and positive dating experience that helps you build the foundation for a long-lasting relationship. https://relationshipsmdd.com/product/matchmaking-services-m-d-d-package/
SAFe® Agile Product Management: In-House Training Discover and apply the mindset, skills, and tools you need to create successful products and solutions that are desirable, viable, feasible, and sustainable. The Agile Product Management course harnesses the power of Design Thinking to develop innovative solutions with proven SAFe® capabilities to execute on those visions. Learn the right mindset, skills, and tools to create successful products from inception to retirement using Agile techniques. Recognize how Continuous Exploration fuels innovation and helps you define a vision, strategy, and roadmap to tap into new markets. Find out how to accelerate the product life cycle to get fast feedback and quickly deliver exceptional products and solutions that delight customers all while aligning with your organization's strategy, portfolio, evolving architecture, and solution intent. What you will Learn After completing the class, you should be able to: Use Design Thinking to achieve desirable, feasible, and sustainable outcomes Explore market needs, segmentation, sizing, and competitive landscape Manage value stream economics, including pricing and licensing Use empathy to drive design Apply product strategy and vision Develop and evolve roadmaps Execute and deliver value using SAFe® Explore innovation in the value stream Analyzing your Role as a Product Manager in the Lean Enterprise Continuously Exploring Markets and Users Driving Strategy with Market Segmentation Using Empathy to Drive Design Defining Product Strategy and Vision Creating Roadmaps to Build Solutions Delivering Value Managing Value Stream Economics Creating Innovation in the Value Stream
Do you have the skills and experience it takes to become a Human Givens Supervisor? Would you like to take your HG career to the next level? Course Dates: see below Length: 6 days (9.30am – 5.30pm) Venue: Leeds Tutors: Julian Penton, Rosalind Townsend Course requirements: See below Qualification: HG Supervisor / Supervisor-tutor This intensive 6 days of tuition, feedback, skills practice and ongoing assessment is your route to becoming a fully-qualified human givens supervisor. Effective supervision offers many opportunities for learning and growth, as well as providing invaluable support. Successfully completing this training will enable you to work as a supervisor-tutor with Part 3 trainees and as a supervisor with qualified HG therapists. What you will learn What HG supervision is and an understanding of the governance framework A structured approach to supporting a trainee though Part 3 How to support an experienced therapist How learning and memory works and why this matters How to use a range of supervisory approaches, methods and techniques How to assess and give feedback and how to notice if that has been received A deeper understanding of ethics, your role and your responsibilities How to address concerns about supervisees How to support a supervisee who is subject to a complaint The HG Supervisor-tutor’s Role How you will be assessed This course is designed to enhance the growth and development of your knowledge and skills, your understanding and practice and to assess your competence as a supervisor-tutor. It is therefore a combination of assessment and learning. Throughout the course, therapists practise and demonstrate through discussion, exploration and reflection, a broad range of skills and topics. Assessment will be on-going throughout the course by the two highly experienced tutors and you will also be given feedback from your peers and the experienced facilitators. Why apply Becoming a supervisor isn’t just about taking the next step; being a good supervisor also brings with it a wealth of new opportunities: Collaborative working Own learning and development Stretch and challenge – in a different way to therapy Career progression Quarterly CPD events Annual Supervisors’ CPD day Supervisors Peer Group Deadline for applications – to be advised when the next course dates are announced (provisionally Spring 2025) – how to apply. Course requirements: To apply, you must be an experienced HG therapist who has delivered a minimum of 1,000 sessions of one-to-one HG therapy and is registered with the HGI You must have the support of your supervisor/s, and Submit the information required by the application process by the deadline (this will be announced when we have the next course dates available, provisionally Spring 2025). Course Dates The HG Supervisor course is made up of two blocks of 3 days, held approx. a month apart. We typically run our supervisor training once every 18–24 months. The next course is provisionally planned for the Spring of 2025 – if you are interested in applying, please let us know via the form below. Next course: Part 1: Thursday–Saturday – dates TBC Part 2: Thursday–Saturday – dates TBC Venue: Novotel Leeds Centre Hotel, Leeds Please note: There are only 12 places available on this course, all subject to the application process. Meet your tutors Julian Penton Julian is a Human Givens (HG) practitioner who for the past 20 years has been mentoring HG therapists, teaching various HG seminars & workshops and delivering the HG College’s HG supervision training course. Read more Rosalind Townsend Ros Townsend is an experienced psychotherapist and supervisor with busy practices in SW England, where she combines private therapy work with referrals from Occupational Health and the NHS. Read more
Facilitating Effective Meetings: In-House Training Billions of dollars and exorbitant amounts of time are wasted annually across the globe because of organizations' meeting practices. This contributes to serious performance problems for both organizations and employees, and it has a serious impact on culture and morale. But despite the costs and consequences, every-day people in any role have the ability to change that. They can reduce cost, improve productivity, and enhance their workplace cultures by improving their meeting facilitation skills. And that is because facilitation skills start in the planning stage, not in the live meeting stage. In this course, participants will learn that their responsibility as a facilitator is to be a steward of time, money, relationships, and performance. To do that, they will learn to estimate costs of meetings and practice a variety of strategic thinking and analysis tasks to effectively plan results-aligned meetings. They will also apply several techniques and strategies to proactively prevent and deal with conflict in meetings, as well as give objective, constructive feedback to others in order to create behavior change during meetings. Participants must bring laptops with them and have internet access during the course (both virtual classroom and traditional classroom). The laptops are needed for specific activities. Also note that this course pairs well with IIL's Conflict Resolution Skills and Decision Making and Problem Solving courses, which go much deeper into related skills and tools that support effective meeting facilitation. What you will Learn At the end of this program, you will be able to: Estimate the financial and time costs of attendance for real-world meetings Use a performance formula to define the purpose of meetings Describe the responsibilities and qualities of an effective facilitator Analyze situations to determine when a meeting is necessary Articulate performance-driven meeting goals and results Align meeting goals and results Strategize to invite, involve, and exclude appropriate attendees Explain research-based best practices for meeting decisions and agenda development Create an effective agenda for a results-driven meeting Apply proactive tools and strategies for relationship-building dealing with meeting conflict Give constructive behavioral feedback using the Situation-Behavior-Impact® technique The Business Case for Effective Facilitation Embracing the research on meetings Estimating the real costs of meetings Determining a meeting's performance value Clarifying the meeting facilitator's role Facilitating the Meeting Plan Determining if a meeting is necessary Aligning meeting goals with meeting types Identifying the right attendees Creating a strategically effective agenda Facilitating the Live Meeting Building relationships from the start Dealing with conflict proactively Giving feedback on unproductive behavior