342 Courses in Manchester

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

A workshop for independent schools that are inspected by Ofsted. Providing a proven strategy for ensuring compliance with the independent school standards.

⭐ Unleash your creativity and practice your drawing skills in our public life drawing workshop at Revolution Bar! Join us for an immersive artistic experience where you will have the opportunity to capture the human form in all its grace and complexity in a relaxed and welcoming atmosphere. At our workshops, life drawing is not just about producing art; it is about engaging in a process of mindfulness, discovery, and personal growth. No prior drawing experience is necessary – our workshops is open to all levels, from first-timers and beginners to those with more experience. Come as you are and join our life drawing workshop at Impossible bar, whether you are seeking a moment of relaxation, a deeper connection with your creativity or simply a space to quiet the mind. Highlights 🎨 An untutored life drawing workshop ⭐ Professional Nude Model ⏳ Dynamic Poses ranging from 1 minute to 20 minutes 🎵 Relaxing Jazz and Classical Music 🍷 Drinks available from the Bar General Info 📅 Dates and times: select your dates/times directly in the ticket selector ⏳ Duration: 2 Hours 📍 Location: Revolution Bar, Deansgate Locks 👤 Age required: 18+ with valid ID ♿ Accessibility: unfortunately this venue is not wheelchair accessible

Phoenix Pottery and Art Studio hosts a calendar of creative workshops, pottery classes and courses, glass fusing courses, watercolour painting classes and much more. Situated in Golborne, near Warrington, St Helens, Wigan and approx 20 miles from Manchester and Liverpool. Easy motorway access for the Northest UK.

Better Business Cases™ Foundation: In-House Training: In-House Training Better Business Cases™ is based on the Five Case Model - which is the UK government's best practice approach to structuring spending proposals and making effective business decisions. Using this best practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives. The goal of the foundation course is to enable participants to work effectively with a team to develop a strong business case in their work environment. What You Will Learn At the end of this program, you will be able to: Describe the philosophy and the underlying rationale of the Five Case Model Identify different types of business case, their purpose, who is responsible for them Recognize when the different types are required in the development of a spending proposal Develop the business case in relation to other recognized and recommended best practices for programme and project management Overview of the Five Case Model Five key components of a business case and the order in which they are presented Three key stages in the development of a spending proposal Definition of a programme / project and the key differences between programmes and projects Purpose of a Business Justification Case (BJC) and in what circumstances it should be considered Purpose of a Strategic Outline Case (SOC) Purpose of an Outline Business Case (OBC) Purpose of a Full Business Case (FBC) Relationship between policies, strategies, programmes, and projects and their deliverables Developing the Strategic Case Purpose and core content of a Strategic Case Purpose of SMART robust spending objectives and the key objectives for spend: economy, efficiency, effectiveness, re-procurement, and statutory or regulatory compliance Four main categories of benefits criteria and the parties involved in their development Three key categories of risk Purpose of identifying constraints and dependencies Difference between direct and indirect benefits Developing the Economic Case Purpose and core content of an Economic Case Purpose of critical success factors and the key critical success factors based upon the Five Case Model Purpose of the long list options and how to generate options and undertake SWOT analysis Minimum of four short-list options, how they are derived, and what they should include (Reference Project / Public Sector Comparator [PSC]) Difference between the preferred way forward and the preferred option Purpose, objectives, key participants, and outputs of Workshop Stage 2 - identifying and assessing the options Rules that should be followed for the treatment of costs and benefits Key differences between economic appraisals and financial appraisals Factors considered when selecting the preferred option Developing the Commercial Case Purpose and core content of a Commercial Case Guiding principles when apportioning risk between the contractual parties Purpose of payment mechanisms Purpose of Step 9 in the development framework: Contracting for the deal Developing the Financial Case Purpose and core content of a Financial Case The financial statements required for all projects The possible impacts to consider Developing the Management Case Purpose and core content of a Management Case Purpose of a programme / project management strategy, framework, and plan Purpose of a change management strategy, framework, and plan Purpose of a benefits realization strategy, framework, and register / plan Purpose of a risk management strategy, framework and register / plan Purpose of a post programme / project evaluation strategy, framework, and plan

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com

A study day designed for HCAs who are working in a supportive role in primary care, offering care for patients with asthma. This day provides an overview of how asthma is diagnosed and managed and includes a practical inhaler delivery systems workshop.

Effective Presentation Skills: In-House Training In today's results-oriented, global working environment, the ability to create and deliver presentations effectively is a necessary skill set for people at all levels of an organization. Regardless of your role, it's important to know how to synthesize your ideas into a coherent and focused narrative, add visuals that support and reinforce your message, and deliver it in a way that resonates with your audience. In this highly interactive course, we will unpack and practice some of the tools and techniques used by top speakers and influencers all over the world. In this engaging two-day course, you will plan, write, refine, practice, and deliver a presentation to the class. Your presentation will be filmed on both days, and you will leave the course with a flash-drive copy of your videos; participants of the virtual classroom workshop should be prepared to present via webcam. In addition to discovering and enhancing your own personal delivery style, you will learn how to create an overarching goal for your presentation and then organize and structure it for maximum impact. You'll gain insight into how to anticipate your audience's needs and tailor the content and delivery in a way that connects with them and sustains their attention and engagement. You will also learn skills that will help you control nervous energy, remain focused on and attuned to your audience, improvise under pressure, deal effectively with questions, and build a compelling call to action. What you will Learn At the end of this program, you will be able to: Construct an effective presentation goal statement, opening, body, and closing that connect with an audience Analyze an audience's needs and style preferences, including relevant DiSC®-related elements Deliver a complete criteria-based presentation that will persuade others Align usage of visuals as well as verbal and non-verbal techniques to maximize the impact of your presentation Getting Started Introductions and social agreements Course structure Course goals and objectives Opening activities Planning and Organizing Video: 'The Art of Misdirection' Setting your presentation goal Writing a goal statement Analyzing your audience Applying the 'reality' test Creating and strengthening supports Structuring your presentation 5 components of an effective opening Presentation body Presentation closing Write your presentation opening Audience Analysis Video: 'How to Tie Your Shoes' Everything DiSC® introduction Audience DiSC® Styles Analyzing your audience Further audience analysis Effective Delivery Delivery challenges: virtual and in-person Keeping your audience engaged Your body as your instrument Verbal / paraverbal elements Body stance and nonverbal communication What are your 'tells?' Controlling nervousness Staying attuned to your audience Responding to questions Review and edit your opening Deliver your opening Visuals and Enriching Elements Using images in your presentation Guidelines for visual composition Using questions to engage your audience The power of the pause Practicing and Applying What You've Learned Preparation Delivery Feedback Opportunity to put into practice the program content and receive a video copy Summary and Next Steps What did we learn and how can we implement this in our work environment? Your personal action plan