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
Bleeding control for general public and security industry.
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?
Photoshop basic to fundamentals Training Course bespoke and customized
Who is this course for? Beginner to Intermediate 3ds Max Training Program. Learn 3D modeling with our in-depth 3ds Max training program. Beginners to intermediate learners, this course is led by certified instructors and industry professionals. Learn 3D modeling, animation, and visualization. In-person or live online sessions. Click here for more info: Website Duration: 20 hours Method: 1-on-1 Personalized Attention. Schedule: Design your own schedule, hours of your choice, offered Mon to Sat from 9 am to 7 pm. 3ds Max and Vray Basic to Intermediate Training Course - 20 Hours Course Outline: Module 1: Introduction to 3ds Max (2 hours) Familiarizing with the 3ds Max interface and navigation Understanding the workspace setup for efficient workflow Mastering object creation, modification, and manipulation Exploring the basics of scene organization and management Module 2: 3D Modeling in 3ds Max (4 hours) Creating primitive and complex shapes using standard tools Utilizing modifiers for advanced modeling techniques Mastering spline modeling for precision and creativity Combining multiple objects for seamless compositions Module 3: Texture Mapping and Material Creation (4 hours) Understanding UVW mapping and texture coordinates Applying materials and shaders for realistic surfaces Utilizing Vray materials for enhanced visual effects Customizing materials for unique and captivating designs Module 4: Lighting and Rendering with Vray (4 hours) Implementing Vray lights for various lighting setups Exploring Vray's global illumination for realism Configuring render settings for high-quality output Fine-tuning the rendering process for efficiency and speed Module 5: Animation and Camera Techniques (4 hours) Setting up animation keyframes for dynamic motion Utilizing cameras for captivating viewpoints and perspectives Creating smooth camera animations and walkthroughs Incorporating animated objects to bring scenes to life Module 6: Scene Optimization and Advanced Features (2 hours) Streamlining scene organization for better workflow Leveraging Vray proxies for optimized performance Exploring advanced Vray features for stunning effects Using Vray render elements for post-processing control Module 7: Project Work and Review (2 hours) Applying the learned skills in hands-on projects Reviewing and refining the projects with instructor guidance Consolidating knowledge and addressing any remaining queries Course Requirements: A computer with 3ds Max and Vray installed (trial versions available on Autodesk and Chaos Group websites) Basic familiarity with 3D modeling concepts is beneficial but not mandatory Enthusiasm for learning 3ds Max and Vray to create impressive 3D models, visualizations, and animations By the end of the 3ds Max and Vray Basic to Intermediate Training Course, participants will be able to: Navigate and utilize the 3ds Max interface with ease for efficient 3D modeling and scene management. Create a variety of 3D models using different techniques, including primitive shapes, modifiers, and spline modeling. Apply textures and materials to their models, utilizing Vray materials for enhanced visual effects. Set up lighting and render scenes using Vray, understanding global illumination for realistic renders. Animate objects and cameras, producing dynamic and engaging animations within their 3D scenes. Optimize scenes and use advanced Vray features, like proxies and render elements, for improved performance and post-processing control. Apply the learned skills to hands-on projects, gaining practical experience in creating captivating 3D models and animations. Review and refine their projects, receiving instructor guidance and feedback to enhance their work. Gain confidence in using 3ds Max and Vray, allowing them to continue exploring and advancing their 3D modeling and rendering skills independently. Showcase their newfound abilities through an impressive portfolio of 3D models and animations, ready to take on new creative challenges in various industries. Skills Acquired: Mastering Fundamental 3D Modeling Techniques in 3ds Max Developing Texturing and Material Application Skills Understanding Lighting and Rendering Fundamentals Grasping Animation Basics and Keyframe Animation Gaining Proficiency in Scene Composition and Camera Setup Career Opportunities: Entry-Level 3D Modeler Junior 3D Animator Texturing and Lighting Assistant CAD Designer in Architectural Firms Product Visualization Artist in Marketing Agencies Upon completing our 3ds Max Beginner Course, students will acquire foundational 3D modeling and animation skills, opening doors to entry-level positions in various industries, including animation studios, architectural firms, and marketing agencies. Personalized Guidance: Expert trainers cater to your unique learning needs through tailored one-on-one coaching. Hands-On Learning: Engage in practical demonstrations, reinforcing skills applicable to industries like design, gaming, and film. Comprehensive Resources: Access a Certificate of Attendance and detailed training guides for continuous reference. Interactive Sessions: Interact live with tutors, receiving valuable feedback and access to recorded sessions. Flexible Options: Choose between online or in-person sessions, fitting your schedule and preferences. Value and Support: Enjoy competitive rates, discounts for referrals, and lifetime assistance via email and phone. Smooth Start: Receive assistance with software installation, ensuring a seamless learning experience.
About this Training Course This 3 full-day course covers the design of systems for natural gas handling and treatment from the wellhead to the gas processing plant to achieve marketable products that meet desired product specifications. This course will emphasize on field handling equipment and separation systems, dehydration, fluid measurement, sampling and analysis as well as introduction into reciprocating and centrifugal compressors. It will comprise interactive presentations including exercises/quizzes. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives At the end of the course, the participants will be able to describe and explain the following: Gas processing principles of dehydration (water removal) by absorption, adsorption, refrigeration and low temperature separation (JT effect) and basic associated equipment Gas processing in-depth by absorption using glycol and glycol proper (Pre- Cooling requirements, Dew Point control and related processes). Glycol regeneration including principles of stripping, DRIZO and Coldfinger. Process equipment involved for water removal by absorption. (Knock out drums; Contactor - absorber and internals, heat exchangers, re-boilers, pumps, filters and glycol storage). Principles of gas metering and types of meter (Measurement Units (MJ, BTU, nM3, scf and conversions). Typical gas contracts & sales specifications. Gas pipeline operations. Target Audience Production and processing personnel involved with natural gas and associated liquids to acquaint or reacquaint themselves with gas conditioning and processing unit operations. This course is for production operations engineers, operations field supervisors, facility engineers, process engineers, design engineers, operations personnel and others who select, design, install, evaluate or operate gas processing plants and related facilities. Course Level Intermediate Trainer Your expert course leader has more than 25 years of accumulated experience in the Oil & Gas Industry, particularly in LNG / Offshore LNG Industry as Project Manager (8 years) and Process Technology Design (12 years). From 2010 to 2012, he worked for TOTAL E&P as Manager of R&D activities related to LNG, FLNG, Gas Treatment and Safety Engineering. From 1992 to 2010, he worked for Technip, spending 12 years (1992 to 2004) in the Process and Technology Division, where he was the Principal Engineer on gas treatment and LNG projects such as Yemen LNG and Nigeria LNG. From 2004 to 2010, he was actively involved in the development of Technip Offshore LNG technologies as Project Manager - several patents filed, author or co-author of different publications on LNG transfer technologies. He has also been a member of: the Foreign Advisory Committee on the 2nd Trondheim Technology Gas Conference, Norway, 2-3 November 2011 the Steering Committee on the SPE Forum 'Economic and Sustainability Challenges in the Future Development of Sour Gas', Bali, Indonesia, 8-13 May 2011 The Technip 'Experts Network' as 'Main Expert - LNG' for several years He holds a 'summa cum laude' master's degree in Chemical Engineering from Rome University 'La apienza' (1992) and has been a member of the Italian Register of Engineers. 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 about post training coaching support and fees applicable for this. Accreditions And Affliations
Learn the basics of bartending and have a fun-filled week in Manchester City Center! Fast-track your way into the bartending industry with 1 week of hands-on training with our highly-experienced instructors. Next Available Sessions (please write in the note which one you prefer) 📅 18th-21th March 2024 ⏰ Monday to Thursday 12.00-4.00pm, Friday 19.00-23.00📍 Sicilian NQ - Bar and Restaurant, 14 Turner St, Manchester M4 1DZ 📅 13th-17th May 2024⏰ Monday to Thursday 12.00-4.00pm, Friday 19.00-23.00📍 Sicilian NQ - Bar and Restaurant, 14 Turner St, Manchester M4 1DZ 📅 22nd-26th Jul 2024 ⏰ Monday to Thursday 12.00-4.00pm, Friday 19.00-23.00📍 Sicilian NQ - Bar and Restaurant, 14 Turner St, Manchester M4 1DZ Calendar: Monday to Thursday 12pm to 16pm plus one evening of real experience from 17 to 23 on Friday Gain the equivalent of 3 months bar experience Master 20 classic cocktails You be awarded with a Dirextra's certificate to showcase your skills to employers at the end of your course Licensed Premises Staff Training Online Course and Certificate included in the course to be done online after the week of practical experience A fun experience Suitable for beginners Duration: 20 hours over 1 weekDestinations: Manchester City Center Why Is This Course for You? Add some new certified skills to your CV (get 2 certificates) Start working as soon as you finish the course Earn some extra cash while studying or working Get a taste of the fast-paced bartending industry and see if it’s for you Start in an entry level bartending position and work your way up to the top Course Programme You’ll learn: The bartender’s role and responsibilities How to set up the bar Basic pour techniques How to make simple garnishes The art of perfect service how to make 20+ classic cocktails from limoncello bramble and whiskey sours to espresso martini and old fashion using fresh ingredients Learn basic bartending techniques like muddling, churning, shaking and stirring. You’ll learn how to layer shots, blend cocktails, pour and use a jigger. You’ll also become familiar with key bar tools and basic equipment Learn the fundamentals of your favourite spirits and their origins to impress friends, customers and potential employers. We’ll cover vodka, gin, rum, tequila, whiskey and brandy. You will also gain an insight into beer and wine On the practical night you will put in place what you learned in a fast-pace bar serving and preparing cocktails for real customers Course Venue Sicilian NQ, award winning "Best Neighbourhood Bar 2023 - Central Manchester", it's a charming mediterranean style wine bar, relaxed and characterful venue nestled in Manchester’s trendy Northern Quarter, right in the heart of the city center. Northern Quarter is a cool neighbourhood, with lively street art, bohemian bars and independent shops. It's home to lively restaurants and some of the city's biggest music venues, featuring concerts from trendy independent bands and famous artists.
HTML5 development training course description This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-375, and build an understanding of these topics: Manage the Application Life Cycle, Build the User Interface by Using HTML5, Format the User Interface by Using CSS, Code by Using JavaScript. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam. What will you learn Manage the Application Life Cycle. Build the User Interface by Using HTML5. Format the User Interface by Using CSS. Code by Using JavaScript. HTML5 development training course details Who will benefit: Anyone working with HTML5. Prerequisites: None. Duration 3 days HTML5 development training course contents Managing the Application Life Cycle Platform fundamentals Packaging and the runtime environment: app package, app container, credentials/permission sets, host process, leverage existing HTML5 skills and content for slate/tablet applications. Manage the state of an application Manage session state, app state and persist state information; understand states of an application; understand the differences between local and session storage. Debug and test a HTML5 touch-enabled application Touch gestures; gestures you test on a device. HTML5 UI: Text, Graphics, and Media HTML5 tags for text content and graphics. When, why and how to use Canvas; when, why and how to use scalable vector graphics (SVG). HTML5 tags to play media. Video and audio tags. HTML5 UI: Organization, Input, and Validation HTML5 tags to organise content and forms Tables, lists, sections; semantic HTML. HTML5 tags for input and validation CSS Essentials: Content Flow, Positioning, styling Core CSS concepts Separate presentation from content (create content with HTML and style content with CSS); manage content flow (inline versus block flow); manage positioning of individual elements( float versus absolute positioning); manage content overflow (scrolling, visible and hidden); basic CSS styling. CSS Essentials: Layouts Arrange UI content by using CSS Use flexible box and grid layouts to establish content alignment, direction and orientation; proportional scaling and use of "free scale" for elements within a flexible box or grid; order and arrange content; concepts for using flex box for simple layouts and grid for complex layouts; grid content properties for rows and columns; use application templates. Managing Text Flow by Using CSS Regions and using regions to flow text content between multiple sections (content source, content container, dynamic flow, flow-into, flow-from, msRegionUpdate, msRegionOverflow, msGetRegionContent); columns and hyphenation and using these CSS settings to optimise the readability of text; use "positioned floats" to create text flow around a floating object Managing the Graphical Interface by Using CSS Graphics effects (rounded edges, shadows, transparency, background gradients, typography and Web Open Font Format); 2-D 3-D transformations (translate, scale, rotate, skew and 3-D perspective transitions and animations); SVG filter effects; Canvas. JavaScript and coding essentials Manage and maintain JavaScript, Create and use functions; jQuery and other third-party libraries. Update the UI by using JavaScript Locate/access elements; listen and respond to events; show and hide elements; update the content of elements. Animations, Graphics, and Accessing Data Code animations with JavaScript animation; manipulate the canvas; work with images, shapes and other graphics. Access data access by using JavaScript Send and receive data; transmit complex objects and parsing; load and save files; App Cache; datatypes; forms; cookies; localStorage JavaScript coding for Touch Interface, Device and Operating System Resources, and More Respond to the touch interface, Gestures, how to capture and respond to gestures, Code additional HTML5 APIs, GeoLocation, Web Workers, WebSocket; File API, Access device and operating system resources, In- memory resources, such as contact lists and calendar; hardware capabilities, such as GPS, accelerometer and camera.
You've always wanted to try macramé, and now's your chance! We're offering a beginners' workshop where you'll learn a variety of knots and styles, and then you can choose from a range of macramé products to make. Starting with the basics and moving onto more complex knots and products. The workshop will be held at our studio in the beautiful Shropshire Hills. When you leave the workshop, you'll have beautiful macramé products that you'll be proud of—and more importantly, you'll be able to turn your new skills into a new hobby or craft business.