294 Courses in Sheffield

Organisational development, Organisational culture, Organisational values, Organisational environment,

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

About this Virtual Instructor Led Training (VILT) A large amount of geological data is acquired at a substantial cost when carrying out a drilling operation. Ensuring optimal quality of this information and effective reporting plays a key role during well design and drilling operations. In addition, there is much to benefit from the later usage of the data in field studies. A critical component that ensures favourable and positive results is the close co-operation between geological, drilling and well engineering departments. Comprising 5 half-day sessions, this Virtual Instructor Led Training (VILT) course aims to provide the required knowledge in order for the collaboration to be most effective and successful. This VILT course will comprise lectures interspersed with practical and interactive exercises and quizzes to promote better understanding. Training Objectives At the end of this VILT course, participants will be able to: Understand the techniques used by wellsite geologists in formation evaluation via: Quick-look analysis to assess reservoir and hydrocarbons Mudlog data (lithology/cutting description, gas readings) Grasp the application of wellsite data in exploration and development Be able to read, assess and use drilling reports Acquire an understanding of drilling problems caused by subsurface conditions Understand the role and contributions of the geologist to the well maturation process Target Audience This VILT course is intended for geologists and other subsurface staff involved in drilling operations who would like to work and communicate more effectively with wellsite staff.  Please note that this VILT course is not a preparation course for a wellsite assignment. To be able to work independently on the wellsite, a more hands-on or on-site training would be required. Training Methods This VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Your expert course leader has close to 20 years of experience as a geologist in the Oil & Gas industry. Her main interest and passion is in well planning and operations. She had previously worked as a production geologist and technical authority in NAM (Netherlands), and as a discipline advisor tasked to coach young staff in Bangalore. She has been active in internal training sessions on drilling hazards, mudwindow assessment and project management. She obtained an MSc in hard rock structural geology from the University in Utrecht, a PhD at Brown University (RI, USA) and a post-doctoral at the RWTH Aachen. 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

Concise Cisco switches course description A hands on course covering the product specifics of Cisco switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. VLANs often take up a large part of the course. The course covers all interfaces but concentrates on using the command line interface. Delegates are, however, free to use the web based interface in all exercises. What will you learn Install Cisco switches. Use the command line interface and the web based interface to manage Cisco switches. Configure and troubleshoot Cisco switches. Perform software upgrades and maintain configurations using TFTP. Concise Cisco switches course details Who will benefit: Anyone working with Cisco switches. Particularly aimed at engineers and technicians supporting Cisco switches. Prerequisites: None. Duration 2 days Concise Cisco switches course content Ethernet review Single segment Ethernet, CSMA/CD, Broadcast domains, collision domains. Hubs, Extending the LAN. Hands on Hub based Ethernet. Cisco switches What are switches, frame forwarding and filtering, the forwarding database. Hands on Switched based Ethernet. Configuring Cisco switches Accessing the switch, installing the switch, The CLI, connecting PCs using the switch. Hands on Configuring Cisco switches. The command line interface User and privilege modes, online help, show, basic troubleshooting. The configuration editor, Global, major and sub commands, enable, secret and other passwords. Hands on Simple troubleshooting using the CLI. Port configuration Speed, duplex, security, trunking. Hands on Port trunking. Spanning Tree Protocol Spanning Tree, Loops, effect, root bridges, bridge port states, STP reconfiguration. RSTP and variants. Hands on STP. VLANS What are VLANs, configuring VLANs, access ports and trunks, 802.1Q, inter VLAN routing. Hands on Access ports, trunks, layer 3 switching. Housekeeping Configuration management, software management, password recovery. Hands on TFTP. Managing interconnection devices SNMP, RMON, RMON II. Troubleshooting LEDs, CDP, logging, Layer 1, layer 2, layer 3. Hands on Fixing things.

About this Training Course Geomechanical evaluations are about the assessment of deformations and failure in the subsurface due to oil & gas production, geothermal operations, CO2 storage and other operations. All geomechanical evaluations include four types of modelling assumptions, which will be systematically addressed in this training, namely: 1. Geometrical modelling assumption: Impact of structural styles on initial stress and stress redistribution due to operations 2. Formation (or constitutive) behaviour: Linear elastic and non-linear behaviour, associated models and their parameters, and methods how to constrain these using 3. Initial stress: Relation with structural setting and methods to quantify the in-situ stress condition 4. Loading conditions: Changes in pore pressure and temperature on wellbore and field scale This 5 full-day course starts with the determination of the stresses in the earth, the impact of different structural styles, salt bodies, faulting and folding on the orientation of the three main principal stress components. Different (field) data sources will be discussed to constrain their magnitude, while exercises will be made to gain hands-on experience. Subsequently, the concepts of stress and strain will be discussed, linear elasticity, total and effective stress and poro-elasticity in 1D, 2D and 3D, as well as thermal expansion. Participants will be able to construct and interpret a Mohr-circles. Also, different failure mechanisms and associated models (plastic, viscous) will be discussed. All these concepts apply on a material point level. Next, geomechanics on the wellbore scale is addressed, starting with the stress distribution around the wellbore (Kirsch equations). The impact of mudweight on shear and tensile failure (fracturing) will be calculated, and participants will be able to determine the mudweight window stable drilling operations, while considering well deviation and the use of oil-based and water-based muds (pore pressure penetration). Fracturing conditions and fracture propagation will be addressed. Field-scale geomechanics is addressed on the fourth day, focussing on building a 3D geomechanical model that is fit-for-purpose (focussing on the risks that need evaluation). Here, geological interpretation (layering), initial stress and formation property estimation (from petrophysical logs and lab experiments) as well as determining the loading conditions come together. The course is concluded with interpretation of the field-wide geomechanical response to reservoir depletion with special attention to reservoir compaction & subsidence, well failure and fault reactivation & induced seismicity. Special attention is paid to uncertainties and formulating advice that impacts decision-making during development and production stages of a project. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Upon completing of this course, the participants will be able to: Identify potential project risks that may need a geomechanical evaluation Construct a pressure-depth plot based on available field data (density logs, (X)LOT, FIT, RFT) Employ log-based correlation function to estimate mechanical properties Produce a simplified, but appropriate geometrical (layered, upscaled) model that honours contrasts in initial stress, formation properties and loading conditions, including Construct and interpret a Mohr-circle for shear and tensile failure Calculate the mud weight that leads to shear and tensile failure (fracturing conditions) Identify potential lab experiments to measure required formation properties Describe the workflow and data to develop a field-wide fit-for-purpose geomechanical model Discuss the qualitative impact of pressure and temperature change on the risk related to compaction, well failure, top-seal integrity and fault reactivation Target Audience This course is intended for Drilling Engineers, Well Engineers, Production Technologists, Completion Engineers, Well Superintendents, Directional Drillers, Wellsite Supervisors and others, who wish to further their understanding of rock mechanics and its application to drilling and completion. There is no specific formal pre-requisite for this course. However, the participants are requested to have been exposed to drilling, completions and production operations in their positions and to have a recommended minimum of 3 years of field experience. Course Level Intermediate Trainer Your expert course leader has over 30 years of experience in the Oil & Gas industry, covering all geomechanical issues in the petroleum industry for Shell. Some of his projects included doing research and providing operational advice in wellbore stability, sand failure prediction, and oil-shale retortion among others. He guided multi-disciplinary teams in compaction & subsidence, top-seal integrity, fault reactivation, induced-seismicity and containment. He was also involved in projects related to Carbon Capture Storage (CCS). He is the founding father of various innovations and assessment tools, and developed new insights into the root causes seismicity induced by Oil & Gas production. Furthermore, he was the regional coordinator for technology deployment in Africa, and Smart Fields (DOFF, iField) design advisor for Shell globally. He was responsible for the Geomechanical competence framework, and associated virtual and classroom training programme in Shell for the last 10 years. He served as one of the Subject Matter Expert (SME) on geomechanics, provided Technical Assurance to many risk assessments, and is a co-author of Shell's global minimun standard on top-seal integry and containment. He has a MSc and PhD in Civil Engineering and computational mechanics from Delft University of Technology, The Netherlands. Training experience: Developed and delivered the following (between 2010 and 2020): The competence framework for the global geomechanical discipline in Shell Online Geomechanical training programs for petroleum engineers (post-doc level) The global minimum standard for top-seal integrity assessment in Shell Over 50 learning nuggets with Subject Matter Experts Various Shell virtual Geomechanical training courses covering all subjects Developed Advanced Geomechanical training program for experienced staff in Shell Coaching of KPC staff on Geomechanics and containment issues on an internship at Shell in The Netherlands, Q4 2014 Lectured at the Utrecht University summer school (The Netherlands, 2020) on induced seismicity among renowned earthquake experts (Prof. Mark Zoback, Prof. Jean-Philippe Avouac, Prof. Jean-Pierre Ampuero and Prof. Torsten Dahm) (https://www.nwo.nl/onderzoeksprogrammas/deepnl/bijeenkomsten/6-10-juli-2020-deepnl-webinar-series-induced-seismicity) Lectured at the Danish Technical University summer school (Copenhagen, 2021) summer school on Carbon Capture and Storage (https://www.oilgas.dtu.dk/english/Events/DHRTC-Summer-School) Virtual Carbon Capture and Storage (CCS): Project Risks & How to Manage Them training course (October and November 2021) 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

Emotional Intelligence, EQ, EI, Moccasin Approach, Moccasin Manager,

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

Overview Networking has become a crucial factor in the modern workplace. It is the most effective method of developing your business or career and is a key component of your personal brand. This one day course will teach you how to be able to build strong business relationships, develop a level of personal credibility and increase your network of contacts in order to enhance your visibility and create opportunities for yourself and your organisation. Description This training course will help your participants build a professional reputation and develop a network of connections through the two key methods available to them; face-to-face and online. Attendees will discover how to effectively combine these two approaches and create a strategy for networking success that will generate their own community and actively grow their personal network. This will result in an improved performance in their approach to networking and consequently provide opportunities and prospects that will increase their business success. The training provides them with the tools and techniques to both plan a successful, strategic approach to networking and develop their personal communication skills, which will ensure they build effective business relationships. Topics covered: Why Network? – Establishing the importance of networking with some shocking statistics and an activity that defines the importance of networking to the individual. This is followed by some insight into the key aims of a networking strategy, what puts people off, as well as some personal revelations about networking. Increase Your Business Presence – Looking at the components of a strong business presence, including; credibility, personal brand, visibility and social capital. Developing a Networkers Attitude – An exercise that clarifies the perfect attitudes and behaviours of great networkers and comparing the participants against this. Thus identifying areas for development. Face to Face Networking – An overview and insight into the main types of face to face networking opportunities available with the benefits and pitfalls of each. Online Networking – An overview of the different social media and online networking tools and how to get the best out of them. Includes; LinkedIn, Twitter, Facebook and online forums. Communication Skills for Networking Success – Ensuring a good first impression, creating an opening sound bite and writing an online profile that promotes and engages. Developing a Conversation – Building on the opening sound bite and developing a conversation through good questioning techniques and following a selection of key networking rules. Including an activity to test and practice the skills. Working a Room – A fun activity that embeds and develops learning while encouraging practice and communication. This activity covers 10 of the main skills required to work a room. Breaking into a Group – Identifying body language to spot when a group or pair is open to new people entering the conversation or would rather not encourage participation. Knowing how to break into a group, what to say and how to remain professional. Exiting a Conversation – Developing some techniques to extricate oneself from a conversation without causing embarrassment or rudeness. The Follow-Up – Using a structure to identify the most important contacts created and establishing when and how to follow up with each group. Includes example follow-up email and a chance to develop their own. Creating a Network Plan – Participants are provided with a networking action plan to review and complete. This sets them on the journey of developing their networking skills and ensures they have a strategy and goals to target. Who should attend Anyone who is looking to improve their networking performance, or the networking performance of a management or sales team. Requirements for Attendees No pre-requisites required.

Overview Networking has become a crucial factor in the modern workplace. It is the most effective method of developing your business or career and is a key component of your personal brand. This one day course will teach you how to be able to build strong business relationships, develop a level of personal credibility and increase your network of contacts in order to enhance your visibility and create opportunities for yourself and your organisation. Description This training course will help your participants build a professional reputation and develop a network of connections through the two key methods available to them; face-to-face and online. Attendees will discover how to effectively combine these two approaches and create a strategy for networking success that will generate their own community and actively grow their personal network. This will result in an improved performance in their approach to networking and consequently provide opportunities and prospects that will increase their business success. The training provides them with the tools and techniques to both plan a successful, strategic approach to networking and develop their personal communication skills, which will ensure they build effective business relationships. Topics covered: Why Network? – Establishing the importance of networking with some shocking statistics and an activity that defines the importance of networking to the individual. This is followed by some insight into the key aims of a networking strategy, what puts people off, as well as some personal revelations about networking. Increase Your Business Presence – Looking at the components of a strong business presence, including; credibility, personal brand, visibility and social capital. Developing a Networkers Attitude – An exercise that clarifies the perfect attitudes and behaviours of great networkers and comparing the participants against this. Thus identifying areas for development. Face to Face Networking – An overview and insight into the main types of face to face networking opportunities available with the benefits and pitfalls of each. Online Networking – An overview of the different social media and online networking tools and how to get the best out of them. Includes; LinkedIn, Twitter, Facebook and online forums. Communication Skills for Networking Success – Ensuring a good first impression, creating an opening sound bite and writing an online profile that promotes and engages. Developing a Conversation – Building on the opening sound bite and developing a conversation through good questioning techniques and following a selection of key networking rules. Including an activity to test and practice the skills. Working a Room – A fun activity that embeds and develops learning while encouraging practice and communication. This activity covers 10 of the main skills required to work a room. Breaking into a Group – Identifying body language to spot when a group or pair is open to new people entering the conversation or would rather not encourage participation. Knowing how to break into a group, what to say and how to remain professional. Exiting a Conversation – Developing some techniques to extricate oneself from a conversation without causing embarrassment or rudeness. The Follow-Up – Using a structure to identify the most important contacts created and establishing when and how to follow up with each group. Includes example follow-up email and a chance to develop their own. Creating a Network Plan – Participants are provided with a networking action plan to review and complete. This sets them on the journey of developing their networking skills and ensures they have a strategy and goals to target. Who should attend Anyone who is looking to improve their networking performance, or the networking performance of a management or sales team. Requirements for Attendees No pre-requisites required.

Elevate your expertise in clean hydrogen derivatives - ammonia, methanol, and synthetic hydrocarbon with EnergyEdge's course. Enroll now for virtual instructor-led training!