920 Courses in Manchester

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 VILT Tripod can be used in any area of business where the organisation has a management system in place to prevent unwanted events e.g., health, safety, environment, quality, security, productivity, project management, and many more Tripod Beta is one of several tools based on Tripod's fundamental principles. Tripod Beta is based on proven theories, man years of academic research, and testing in the workplace. The Swiss Cheese Model originated from this work. Features of the methodology are: 1) the Tripod Beta diagram; it provides an easy-to-read summary of the entire investigation on a single page, 2) it accommodates deficiencies in leadership and worker participation, 3) it accommodates deficiencies in human behaviour, and 4) it highlights missing controls (not just controls that failed). Quality throughout all aspects of Tripod is assured by the Stichting Tripod Foundation (STF) and the Energy Institute. The participants will gain a theoretical understanding of the Tripod Beta methodology and terminology. They will be able to read Tripod diagrams and reports, and be able to assist incident investigation/analysis as a team member. This is the first step to becoming an accredited silver or gold practitioner. Tripod Beta Practitioner Accreditation is meant to build these skills, through a blend of support, coaching and assessments. Feedback is provided on Tripod incident investigation reports, giving the Practitioner the opportunity to hone their skills and become confident in their ability to use Tripod effectively. Training Objectives Upon completion of this course, participants will be able to: Pass the Tripod Beta Practitioner (Bronze Level) exam Act as a team member or Tripod facilitator on an incident investigation Plan and schedule activities for an incident investigation Focus line of enquiry during an investigation Engage with the most relevant people at each stage of the investigation Describe the incident causation paths in terms that align with their management system Consider issues relating to leadership, worker participation and human behaviour Assess the quality of an incident report Apply the process to any type of unwanted event that should have been prevented by a management system e.g., health, safety, environment, financial, security, productivity, quality, project management etc. Combine the findings from many incidents with data from other initiatives e.g., audits and inspections, to spot trends to prioritise actions and product a single improvement plan Target Audience The course is recommended for anyone who is expected to play a role in designing, reviewing, auditing, and following your organizations OH&S management system. Successful participants will be awarded the Stitching Tripod Foundation Tripod Beta Bronze certificate. The following oil & gas company personnel will benefit from the knowledge shared in this course: CEO Team Leaders Legal, insurance and finance departments Managers (Line and Function) Maintenance Engineers Quality Assurance Engineers Process Engineers Incident Investigators (Team member & Tripod facilitator) Project Managers System Custodians Technical Authorities Key Contractor's Management Contract Managers/Holders Safety Representatives Risk Management Engineers HSE Advisors Supervisors Auditors Regulators Course Level Basic or Foundation Trainer Your expert course leader has over 30 years of experience in construction, operations and maintenance with the upstream exploration and production sector. He joined Shell International E&P in 1971 and for 28 years worked in several locations around the world. Following the Piper Alpha incident he led Shell's two year, £10M major overhaul of their permit to work system. He first made use of the Tripod Beta principles during this period and since then he has delivered over 100 Tripod Beta courses in more than 25 locations around the world. He is a Chartered Engineer, a member of the Institution of Engineering and Technology and holds a postgraduate diploma from the University of Birmingham (UK). 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

About this Virtual Instructor Led Training (VILT) The 5 half-day Piping Stress Engineering Virtual Instructor Led Training (VILT) course will systematically expose participants to: The theory and practice of piping stress engineering, with special reference to ASME B 31.1 and ASME B 31.3 Standards. The basic principles and theories of stress and strain and piping stress engineering, through a series of lessons, case study presentations, in-class examples, multiple-choice questions (MCQs) and mandatory exercises. Principal stresses and shear stresses which form the backbone of stress analysis of a material. Expressions for these quantities will be derived using vector algebra from fundamentals. Thermal stress-range, sustained and occasional stresses, code stress equations, allowable stresses, how to increase flexibility of a piping system, cold spring. The historical development of computational techniques from hand calculations in the 1950s to the present-day software. Training Objectives On completion of this VILT course, participants will be able to: Identify potential loads the piping systems and categorise the loads to primary and secondary. Determine stresses that develop in a pipe due to various types of loads and how to derive stress-load relationships, starting from scratch. Treat the primary and secondary stresses in piping system in line with the intent of ASME Standards B 31.1 and B 31.3 and understand how the two codes deal with flexibility of piping systems, concepts of self-springing and relaxation/shake down, displacement stress range and fatigue, what is meant by code compliance. Understand the principles of flexibility analysis, piping elements and their individual effects, flexibility factor, flexibility characteristic, bending of a curved beam and importance of virtual length of an elbow in the flexibility of a piping system. Learn stress intensification factors of bends, branch connections and flanges. Understand how the stresses in the material should be controlled for the safety of the piping system, the user and the environment. Examine how codes give guidance to determine allowable stresses, stress range reduction due to cyclic loading, and effects sustained loads have on fatigue life of piping. Confidently handle terminal forces and moments on equipment. Understand the supplementary engineering standards required to establish acceptance of the equipment terminal loads and what can be done when there are no engineering standard governing equipment terminal loads is available and learn the techniques of local stress analysis. Get a thorough understanding of the concepts and the rules established by the ASME B 31.1 and ASME B 31.3 Standards. Perform flange load analysis calculations based on Kellogg's Equivalent Pressure method & Nuclear Code method. Perform the same using a piping stress analysis software and check for flange stresses and leakage. Confidently undertake formal training of piping stress analysis using any commercial software, with a clear understanding of what happens within the software rather than a 'blind' software training and start the journey of becoming a specialist piping stress engineer.   Target Audience The VILT course is intended for: Recent mechanical engineering graduates who desire to get into the specialist discipline of Piping Stress Engineering. Junior mechanical, chemical, structural and project engineers in the industry who wish to understand the basics of Piping Stress Engineering. Engineers with some process plant experience who desire to progress into the much sought-after specialist disciplines of Piping Stress Engineering. Mechanical, process and structural engineers with some process plant experience who desire to upskill themselves with the knowledge in piping stress engineering and to become a Piping Stress Engineer. Any piping engineer with some pipe stressing experience in the industry who wish to understand the theory and practice of Piping Stress Engineering at a greater depth. A comprehensive set of course notes, practice exercises and multiple-choice questions (MCQs) are included. Participants will be given time to raise questions and participants will be assessed and graded based on responses to MCQs and mandatory exercises. A certificate will be issued to each participant and it will carry one of the three performance levels: Commendable, Merit or Satisfactory, depending on how the participant has performed in MCQs and mandatory exercises. Training Methods The 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 is a fully qualified Chartered Professional Engineer with over 40 years of professional experience in Oil & Gas (onshore and offshore), Petrochemical and Mining industries in engineering, engineering/design management and quality technical management related to plant design and construction. At present, he is assisting a few Perth based oil & gas and mining companies in detail engineering, piping stress analysis, feasibility study and business development work related to plant design. He is a pioneer in piping stress engineering in Western Australia. His recent major accomplishments include the following roles and challenges: Quality Technical Support Manager of USD 54 billion (Gorgon LNG Project). This encompassed management of quality technical services connected with Welding, Welding Related Metallurgy, Non-Destructive Examination, Insulation /Refractory /Coating, AS2885 Pipelines Regulatory Compliance and Pressure Vessel Registration. Regional Piping Practice Lead and Lead Piping Engineer of Hatch Associates. In this role, he was responsible for providing discipline leadership to several mining projects for BHP Billiton (Ravensthorpe), ALCOA-Australia (Alumina), Maáden Saudi Arabia (Alumina), QSLIC China (Magnesium), COOEC China (O&G Gorgon). He was actively involved in the development of piping engineering practice in WA, including training and professional development of graduate, junior and senior engineers. This also includes the formation of the Piping Engineering Specialist Group. Lead Piping/Pipe Stress Engineer on ConocoPhillips' (COP) Bayu Undan Gas Recycle, Condensate production and processing platform. He was able to develop several novel design methodologies for the project and provided training to engineers on how to implement them. These methodologies were commended by COP and the underwriters of the project Lloyds Register of Shipping, UK. Creator of Piping Engineering Professional Course aimed at global engineering community. Professional Affiliations: Fellow, Institution of Mechanical Engineers, UK (IMechE) Fellow, Institution of Engineers, Australia (EA), National Register of Engineers (NER) Member American Society of Mechanical Engineers, USA (ASME) Honorary Life Member, Institution of Engineers, Sri Lanka (IESL)   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

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

PRINCE2 Agile® Practitioner: In-House Training PRINCE2 Agile® Practitioner 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® Practitioner certification teaches you to blend structure, governance, and control with agile methods, techniques, and approaches. The strength of PRINCE2® lies in the areas of project direction and project management, whereas Agile has a very strong focus on product delivery. When PRINCE2® and agile are combined, project direction, project management, and project delivery are optimized to create a complete project management solution. 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 basic concepts of common agile ways of working Understand the purpose and context for combining PRINCE2® and the agile way of working Able to apply and evaluate the focus areas to a project in an agile context 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 To learn through the use of theory and practical exercises Prepare for the PRINCE2 Agile® Practitioner 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 Agile Overview & Blending PRINCE2 and Agile Agile overview Blending PRINCE2 and Agile Fix and Flex, Agile and PRINCE2 Processes & Starting a Project Fix and Flex Agile and the PRINCE2 Processes; Starting up a project and Initiating a project Business case theme Change and Organization Themes& Principles Change theme Organization theme Agile and PRINCE2 Principles and the Agilometer Managing Product Delivery and Scrum & Plans and Progress Themes Managing product delivery and Scrum Plans Theme and Progress Theme Quality, Controlling & Managing a Stage and Directing Projects and Contracts Quality Theme Controlling a stage and Frequent Releases Managing a stage boundary Directing a project and contracts Closing a project Tailoring PRINCE2 Productsand Other Practices Tailoring PRINCE2 products and other practices

Decision Making and Problem Solving: In-House Training We may live in an era of fast technology and increasing reliance upon automation, but our human abilities to think critically, make careful decisions, and solve nuanced problems are more important than ever. Our personal lives depend on those things, and so do the lives of our organizations. Since business is now conducted at remarkable speeds, we put our organizations at great risk daily when we have weak competencies with decision-making and problem-solving. Decisions and solutions that are executed impulsively and without structured approaches can create more problems or make existing ones worse! This course aims to help participants improve their skills so they can execute well and add value to the workplace. Learners will experience multiple decision-making and problem-solving models, tools, and techniques meant for the real world. They will learn how to align their growing toolboxes with the right situational contexts so that they can transfer that skill to the workplace. They will also discover how indecision, cognitive bias, and default thought processes can create obstacles to effective decision-making and problem-solving. What you will Learn Recognize the importance of making a sound decision in a timely manner Infer types of cognitive biases and obstacles that impact decision-making Separate facts, requirements, ideas, and perceptions when making a decision or solving problems Apply structured decision-making and problem-solving approaches Conduct cause and effect and Force Field analyses Evaluate alternative solution methods using various techniques Analyze real world situations to determine the best aligned decision-making and problem-solving models, tools, and techniques Implement decision-making and problem-solving models, tools, and techniques Foundation Concepts Contextualizing decisiveness and problem-solving Discriminating between decisiveness and problem-solving Understanding Decision-Making Decision-making challenges and impacts Key drivers of good decision-making Thought processes and obstacles Knowledge, skills, and abilities (KSAs) Decision-Making Models and Supporting Tools Decision-making models, tools, and guidelines Tools to evaluate alternatives Translating requirements into action Problem-Solving Defining the problem Problem-solving models Cause and effect analysis Quick hit vs. innovative problem-solving Summary and Next Steps Course summary Personal action 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

This module aims to develop knowledge and practical skills in Import/Export Customs Diagnostic enabling the learner to create a procedural manual to complete international trade operations.

This course is designed to provide you with the required skills to either become employed in a dog grooming environment or set up your own grooming business.  At an appropriate time during your training, you will be given the option to pursue a nationally accredited qualification in addition to those detailed above. You may, of course, choose to complete the training only and not gain a qualification other than the ones included. The course will cover: The preparation, styling and finishing of dogs Preparation for practical assessments Theory study support Students will receive all course materials and it is recommended that students bring along a camera for before and after photographs as well as pens, high-lighters and notepads. COURSE LENGTH: 20 Days consisting of our Salon Assistant Course (below) plus an additional 12 days of clipping and styling training

Change management, dealing with change.