498 Courses in Sheffield

If you have at least 5 years working experience and you would like to attain Gold Card status via the Experienced Worker route by joining the City & Guilds 2346 NVQ Level 3, you will also need to hold the below two pre-requisite qualifications: City & Guilds 2391-52 Inspection and Testing Course C&G 2382-22 BS7671 18th Edition

MYSQL FOUNDATION TRAINING COURSE DESCRIPTION The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. WHAT WILL YOU LEARN * Create, alter and drop a MySQL database. * Write SQL statements. * Use SQL expressions and functions. * Create and alter tables, indexes and views. * Use transactions. * Grant and revoke access privileges. * Export and import data. MYSQL FOUNDATION TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to access and work with a MySQL Database. * Prerequisites: An understanding of databases and exposure to information technology in general would be useful. * Duration 3 days MYSQL FOUNDATION TRAINING COURSE CONTENTS * Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. * Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. * Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. * LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. * Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. * Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. * Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. * Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. * Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. * Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. * Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. * Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

Plasma pen fibroblast training for the face and body including soft surgery. Train one to one or very small groups. International accreditation. Lifelong support. Train with Carol May LMA Skin Clinic. On completion you will be able to offer your clients: Wrinkle rejuvenation & face lifting Hooded eyes & eye bags Glabella lines Nasal labia Marionette lines Neck lines Stretch marks & scar repair Mole removal Skin tags Cherry angioma Thread veins Xanthelasma Seborrheic keratosis plus many more soft surgery options You will benefit from online pre study plus in-clinic training and ongoing support Models can be provided if required You will receive a genuine medical grade plasma device (not electrical arcing) Total price is £2400 Your training fee can be paid in installments with Klarna We welcome national and International students

Blue CSCS Card NVQ Level 2 Specialist This qualification provides you with the opportunity to showcase their knowledge, skills and understanding in their chosen specialism. You will have the relevant experience in one of the specific areas. You will work in one of the following areas: * Formwork * Insulation and Building Treatments * Steelfixing Occupations * Highways Maintenance * Construction Operations * Steel Erecting 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 [https://sitecompetence.co.uk/wp-content/uploads/2022/01/NVQ-Level-2-Specialist.pdf].

Enhance your knowledge in petroleum geochemistry with EnergyEdge's course on petroleum exploration. Enroll now!

This half-day Suicide First Aid Lite training course gives learners the knowledge and tools to understand that suicide is one of the most preventable deaths and some basic skills can help someone with thoughts of suicide stay safe from their thoughts and stay alive.

ABOUT THIS TRAINING COURSE In turbulent times for the entire Energy Sector, Oil & Gas E & P segments are coming under tremendous pressure to reinvigorate. Oil Majors like Shell Plc are no longer termed as Oil & Gas Company but also branded as SHELL Energy, with technology at its forefront. The Risks, Scope and Context of Engineering, Procurement, Construction, Installation and Commissioning (EPCIC) Projects is evolving rapidly. Thus, the success of a project is dependent on the practical 'know how' in scoping, contract drafting, negotiation and execution competencies. Understanding the essential ingredients of contracts and mastering the international contracting principles will equip the participants to identify vague and ambiguous clauses, avoid dangerous and often hidden terms, and better understand the controlling position in a project. In this 3 full-day course, the participants will find out how to negotiate legacy contracts where parties are not allowed to edit any clauses during the bidding process. The participants will learn from the Case Law Reports and analysis to take home lessons learned from bitter experiences of their peers in the industry. It is designed to help those who need a solution to manage current contractual issues or those who execute contracts regularly and want to be more proficient in managing their contracts and projects, with changing contexts. The course is developed with the underlying objectives for the participants to: 1. Enhance their current knowledge of the legal principles governing international Contracts from formation, execution to breaches, redresses and dispute resolution either as a party or as a consortium member or as a coverture. 2. Manage Consortium and Joint Venture Partners inter-relationship and contractual responsibilities. 3. Identify dangerous exposures due to joint and severally liable requirements of consortium-based contracts. 4. Effectively Manage Risks of Projects, with Enforceable Contract Documents, by learning the purpose and potential benefits of maintaining evidence in compliance to the contract clauses. 5. Learn the Contract Enforcement Nuggets of Owners and the Variation Claims Strategies of the Contractors. 6. Allocation of contract management related roles / assignments and WBS within consortium partners for effective project management and profitable results. 7. Use of Contract Terms & Conditions for enhancing project performance, monitoring, reporting, and achieving timely completion, thereby avoiding delays and disputes. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Upon completion of the course, the participants will have learnt: * Project management strictly in accordance with the contract and the corporate strategies. * How to ensure that Variations Order claims are appropriately managed in turnkey and lump-sum contracts. * Manage contemporary challenges and market factors with direct or indirect impact on the contracts. * Managing all members of the Supply Chain from vendors to logistics services providers. * Cost Engineering and Performance Management. * How to manage Consortium Partners, Contractors, and Owner's representatives. * When and how to obtain / grant extension of time (EOT) and costs. * Ability to identify rights and obligations of each party to a contract instead of making subjective decisions. * Ability to be firm in negotiations without violating terms of the agreements. * Ability to spot different legal systems, contract laws and arbitration rules. * Ability to negotiate and avoidance of disputes and resolution in amicable manner, in accordance with the provisions of the contract. * Competency in developing and maintaining documentary evidence and traceability for all works executed during the project. Target Audience This course is specially curated for professionals from International Oil & Gas Industries including Offshore & Marine Sectors. They include the heads of strategic business units, contracts managers, project directors, project managers, general managers, corporate legal counsels, procurements and supply chain managers, lawyers and legal professionals engaged in the EPCIC Segments of the Oil & Gas Industry.   Course Level * Intermediate Trainer Principal Management Consultant Chartered Valuer and Appraiser (CVA) FACICA | FAMTAC | FAIADR | M.S.I.D | Member, AIEN LL.M. (IP Law), M. Sc. (Maritime Studies), M. Tech (Knowledge Engineering), MBA, First Class CoC (MCA, UK), B. E. (Elect) Your expert course leader, during the last 47 year period, has worked and consulted in the industry verticals encompassing: Technology, Oil & Gas Exploration & Production, Petrochemical Process Plants and Power Plant Construction Projects, Logistics & Warehousing, Marine, Offshore, Oil & Gas Pipelines, Infrastructure Development Projects (Ports, Offshore Supply Bases, Oil & Gas Terminals and Airports etc), EPCIC Contracts, and Shipyards, in South East Asia, Africa, Middle East, Americas and Europe. He serves as the Principal Management Consultant with a management consultancy in Hong Kong and Singapore, specialising in the fields of corporate management consultancy, international contracts reviews and alternative dispute resolutions services. He undertakes special assignments for conducting audits and valuation of intangible properties involving proprietary processes for licensed production, and licensing of intellectual property rights (IP Rights) in patents, trademarks, and industrial designs. He is frequently engaged for assignments like due diligence, acquisitions, mergers, resolving various operational issues, technology transfer and agency services contracts reviews, cost controls, and enhancement of Supply Chain Management. He has been conferred the credentials of Chartered Valuer & Appraiser (CVA) by SAC and IVAS, in accordance with the international valuation standards setting body IVSC. His consulting experience includes Charterparty Management, Business Process Re-engineering, Diversifications, Corporate Development, Marketing, Complex Project Management, Feasibility Studies, Dispute Resolutions and Market Research. He has successfully assisted Marine and offshore E & P clients in managing contractual disputes arising from various international contracts for upgrading & conversion projects. He continues to be actively engaged in claims reviews, mediation, arbitration, litigation, and expert witness related assignments, arising from international contracts and Charterparty Agreements. He graduated with a Bachelor's degree in Electrical Engineering, MBA in General Management, Master of Technology in Knowledge Engineering, Master of Science in Maritime Studies, and LL.M. (IP Law). He also holds professional qualifications in Business Valuations and Appraisers for CVA, arbitration, law, and marine engineering, including the Chief Engineer's First-Class Certificate of Competency (MCA, UK). He is further qualified and accredited as Certified International Arbitrator, Chartered Arbitrator, Sports arbitrator under CAS Rules, WIPO Neutral, Australian Communications and Media Authority (ACMA) Bargaining Code Arbitrator, Accredited Adjudicator and Accredited Mediator (Malaysia). He is admitted to the international panels of arbitrators and neutrals with WIPO, Geneva; ACICA, AMTAC and ACMA, Australia; BVIAC (British Virgin Islands); JIAC (Jamaica); HKIAC Hong Kong; AIAC, Malaysia; AIADR, Malaysia; KCAB, Seoul, South Korea; ICA, Delhi, India; ICC (Singapore); SISV, Singapore; SCMA, Singapore; SCCA, Saudi Arabia; VIAC Vienna, Austria; Thailand Arbitration Centre (THAC), and Mediator with AIAC Malaysia, CMC, and SIMI Singapore. 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

ADVANCED KIBANA TRAINING COURSE DESCRIPTION This training course is aimed at users who already have some experience with Kibana, who are looking to further their knowledge. WHAT WILL YOU LEARN * Lens * Timelion * Maps * Custom Visualisations with Vega * Canvas * Filters and Controls * Drilldown and Dashboards * KQSL and ElasticQueries * Scripted and RunTime Fields * Alerts and Alarms ADVANCED KIBANA TRAINING COURSE DETAILS * Who will benefit: Users who already have some experience with Kibana, who are looking to further their knowledge. * Prerequisites: None * Duration 1 day ADVANCED KIBANA TRAINING COURSE CONTENTS Topics * Lens Visualisation types (tables,bars,charts) Category breakdown Adding multiple metrics Using formulas in metrics Labels Adding reference layer Limitations * Visualise Library Timeseries, Metrics Different types of aggregations * Maps GeoMapping Heat Maps Using ES index as data source Visualisation, tool tips * Custom Visualisations with Vega Introduction to vega scripting * Canvas Widgets and Texts Elasticsearch SQL Canvas Expressions * Filters and Controls Dropdown filters Ad-hoc filters Searchbar filters * Drilldown Dashboards Linking one dashboard to another * KQSL and ElasticQueries Bool Query AND/OR Phrase Part match vs keyword search Wildcard search * Scripted and RunTime Fields Creating ad-hoc calculated fields using scripts Performance issues * Alerts and Alarms Query Based Formatting output Connector types(email,index,teams etc)

Enhance your expertise in HV/MV power system design and protection coordination with EnergyEdge's virtual instructor-led training. Join now!

* Solution-Focused Coaching Model * Grow Coaching Model * 0SKAR Coaching Model * CLEAR Coaching Model * AOR Coaching Model * FUEL Coaching Model * WOOP Coaching Model COACHING PROCEDURE FOR COACHING FOR CEOS: * Pre-session check-in and questionnaire and assessment * Mindset Analysis and introspection testing * Psychological analysis * Follow up for feedback and well-being and progress check-up calls * Accountability Coaching * Anxiety Coaching * Target-driven coaching helpful for individuals with procrastination issues or issues tackling challenging career goals * Leadership Coaching and Self-belief Coaching * Organizational objective coaching * Bring awareness to self-talk and unconscious biases * 24/7 ACCESS TO YOUR COACH * Coach available on Whatsapp, Phone, Zoom, and Face to Face   CEO Coaching helps coach the world’s best CEOs, executives, entrepreneurs, and companies to increase revenue and grow their business. Our coaches have extensive real-world experience in overcoming the challenges, inherent in entrepreneurship and executive leadership. Consult with a CEO coach today to receive a customized business plan that will enable you to achieve extraordinary results. We work with you by understanding the business issues and strategic imperatives of the enterprise. We then use a combination of 360 feedback (including Board members) and formal assessment tools to ensure we have a clear picture of you as an individual leader and the environment in which you need to create success. We assess your team and work with you to understand where you’ve got the capability and where the team may be vulnerable. https://relationshipsmdd.com/product/coaching-for-ceos-package/ [https://relationshipsmdd.com/product/coaching-for-ceos-package/]