152 Materials courses in Glasgow

Fibre splicing training course description A short, concise hands on fibre optic cable splicing course providing comprehensive coverage of fibre splicing. Over 50% of the course is practical based. What will you learn Prepare cable for splicing. Splice fibre optic cable. Fibre splicing training course details Who will benefit: Those wishing to be able to splice fibre. Prerequisites: None. Duration 1 day Fibre splicing training course contents Fibre optic essential review Fibre cable types. SMF, MMF. Safe working practices. Cable handling issues. Hands on: Handling fibre optic cable. Preparing fibre for splicing Cutting and stripping tools, cleaving methods, fibre cleaning materials. Hands on: Fibre preparation. Splicing Joining fibres, splicers, fusion splicing, mechanical splicing, splicing procedure. cleaving, splicing parameters. Splicing vs. connectors. Which splice? Hands on: Splicing fibre. Splice loss mechanisms End gap, concentricity, end angle, NA mismatch, finish and dirt, coaxiality, Axial run out, core mismatch, back reflection. Testing Testing successful fibre splicing. Hands on: Testing spliced fibre.

Take your knowledge to the next level with EnergyEdge course on Layer of Protection Analysis (LOPA). Enroll now to advance your career.

About this Training Course This 3 full-day course provides a sound review of Pipeline Integrity Management strategies, in compliance with regulatory requirements, including self-assessment. The course is highly interactive and takes the form of lectures and case studies. On completion of the course, the participants will have a solid understanding of the procedures, strengths, limitations, and applicability of the main issues that comprise a Pipeline Integrity Management Program. The course incorporates API 1160 / 1173 and ASME B31.8S, and explains in detail the pipeline integrity requirements described in these standards. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Objectives of this course: Explore the latest techniques used to develop a comprehensive integrity management program covering both pipelines and their associated facilities Determine the necessary elements of such a program described in detail with examples of typical program content including an overarching view of where detailed risk analysis and defect assessment fits in the program Understand the scopes and contents of pipeline integrity standards i.e. API 1160 / 1173 and ASME B31.8S On completion of this course, the participants will be able to understand: Codes used in developing Integrity Management Plans, API 1160 / 1173 and ASME B31.8S, others The elements of an Integrity Management Plan Threat assessment Critical aspects of risk assessment Prevention and mitigation measures Characteristics and limitations of different inspection methods A risk-based approach to maintenance Target Audience The course is intended for supervisors, engineers and technicians responsible for ensuring the adequate protection of pipeline assets. In addition, maintenance planners, regulators and service providers to the pipeline industry will also benefit from attending this course. Course Level Basic or Foundation Trainer Your expert course leader is a Ph.D. Metallurgical Engineer with advanced expertise in asset integrity management of oil & gas production facilities, corrosion control, materials selection, chemical treatments, pipeline pigging, inspections, fitness-for-service evaluations, failure analysis and related consulting. He has 40 years of experience working for BP in Asia and South America, Amoco in the US, Intertek, and four years with Applus-Velosi in Southeast Asia. Practical Work Experience: AIM consultant with focus on Southeast Asia operations and clients Direct technical interface with clients on Velosi services Technical consultant for ongoing regional contracts and lead roles as auditor, instructor or facilitator Main clients have included the following organisations: BP and Vico Indonesia, Pertamina Offshore Northwest Java and West Madura Offshore (Indonesia), NCSP (Vietnam), ADCO-OPCO (Abu Dhabi), Thang Long (Vietnam), Exxon-Mobil (Malaysia) and Mubadala Petroleum (Indonesia). 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

About this Training Course  Exploration and production technology, equipment specification and processes have a unique language that must be conquered by executives such as you. A confident understanding of the technical jargon and a visual appreciation of the various pieces of equipment used provides for an overall 'big picture' of industry value chain. This serves as an excellent foundation for smooth communication and increased efficiency in inter-department project team efforts. Gain a comprehensive overview of the entire value chain and process of oil & gas upstream operations and business in this 3 full-day training course. Training Objectives By attending this industry fundamentals training course, participants will be better able to: Appreciate the dynamics of world energy demand & supply and its impact on pricing Understand the formation of petroleum reservoirs and basic geological considerations Examine the exploration process to gain an overview of the technical processes involved Gain a comprehensive overview of drilling activities - from pre-drilling preparation, through to well drilling, well evaluations and post drilling activities Get familiarised with the common production methods and the different stages of its processes Integrate your understanding of asset maintenance and downstream supply chain activities Better visualise through video presentations the various exploration equipment/ technologies and understand the major cost components Target Audience This course will be useful and applicable, but not limited to: Accounting Administration Business Development Commercial Construction E & P IT / Data Finance Finance & Treasury Health & Safety Human Resource Joint Venture Co-ordinators Legal Logistics Materials Planning Procurement Sales & Marketing Senior Management Sourcing Strategic Planning Supply Chain Tender Contract Course Level Basic or Foundation Training Methods Multi-media presentation methodology to enable better understanding and appreciation technical jargon and equipment applied in the field A pre-course questionnaire to help us focus on your key learning objectives Detailed reference manual for continuous learning and sharing Limited class size to ensure one to one interactivity Trainer Your expert course leader worked for BP for 28 years as a Research Associate and Team Leader, working on Feasibility Studies and acting as a trouble shooter covering all aspects of BPs businesses. These covered field Development Project in the North Sea and several novel resource recovery techniques which were taken from Concept to Field Pilot trials in Canada. His specific work in the offshore area covered Subsea Robotics / Automation, Seabed Production Concepts, Seabed Excavation Methods, Underwater Repair Techniques, Flexible Riser Studies and Maintenance Cost Reductions. After leaving BP in 1992, he continued working in the offshore oil industry through Azur Offshore Ltd, including activities in the assessment of Emerging and Novel Technologies, Technical and Economic Audits, Studies, Production Sharing Agreement Evaluations, Safety and Environmental issues. Clients have included Chevron UK, BP Exploration, British Gas, Technomare, Trident Consultants, Fina UK and Cameron France. He is a regular University lecturer at Crandfield School of Industrial Sciences (UK) and is a course Group Project external examiner for Crandfield. He also lectures on offshore oil industry activities at ENSIETA (France), the Technical University of Delft (Holland) and the Northern Territories University in Darwin (Australia). He is an active member of the UK Society for Underwater Technology (SUT) and serves on their Subsea Engineering and Operations Committee. 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

If you got a call from a TV producer asking you to appear on Newsnight, would you say ‘yes’? And if you did, could you make your argument in a way that captured the attention of the audience without being interrupted? Our media training courses are aimed at senior spokespeople and experts who give interviews on TV, radio or in print. We equip them with the skills and confidence to take control and give engaging, memorable and effective performances in which they deliver their key messages, no matter what the circumstances. Highly interactive and practical, each course includes a series of realistic print, radio and television exercises with experienced journalists. We provide immediate feedback following each interview, including techniques for improvement, advice about potential answers and the framing of key messages. While all our media training courses are bespoke, on a typical course we will cover: how the media operates how to prepare for interviews the differences between TV, radio and print interviews how to conduct different types of interview, such as pro-active, reactive, expert commentator and hostile (crisis communications) developing key messages which convey your views persuasively how to take control of an interview, stick to your own agenda and deliver key messages successfully use of language, body language, dress and delivery After the course, each delegate receives the Rough House Media Toolkit, including written feedback, recorded copies of their interview exercises, the Rough House Media Guide to Interviews and further supporting materials. We also provide a confidential assessment to the PR team of each delegate’s suitability for different types of interview. Venue We deliver courses in the most appropriate format for your circumstances – whether face to face or online. Face to face courses are portable: they can be held in purpose-built studios, at your own offices or at an external venue. In the latter two cases, we create a mock studio for the practical exercises. Online courses give you flexibility and enable you to offer training to delegates from all over the world. We have run virtual courses for people from the Far East, South Asia, North America and Europe, as well as the UK.

About this Virtual Instructor Led Training (VILT)  A decision to drill an exploration well with the objective to find a new oil or gas field must be based on sound assessment of the prospect risk and of the volumes. What is the chance that a well will find hydrocarbons, and how much could it be? Risk and volume assessments form the basis for decisions to drill a well or not, and as such form the link between subsurface evaluation and the business aspects of the petroleum industry. This Virtual Instructor Led Training (VILT) course explains how risks and volumes can be assessed in a realistic manner, based on a sound understanding of the geological details of the prospect as well as its regional geological setting and current play understanding. Participants of this VILT course will receive a softcopy of Risk and Volume Assessment Handbook which explains the concepts that are associated with probabilistic Risk & Volume (R & V) Assessment and contains many practical recommendations on how to translate geological understanding into meaningful inputs for probabilistic R &V assessments. The book is fully compatible with any probabilistic R & V tool in the industry. Training Objectives By the end of this VILT course, participants will be able to understand: The fundamentals of risk and volumes assessment; translating geological understanding into reasonable numbers and ranges. The difference between risk and uncertainty. Fundamentals of statistics; including explanation of distribution curves, understanding of expectation curves, do's and don'ts for adding risked volumes, and Bayes theorem. Uncertainty of trap, reservoir, seal and charge, illustrated by examples. Guidelines and exercises for estimating risks realistically and consistently. Calculating volume ranges for prospects and for portfolios of prospects; how to add prospect volumes for a correct representation of prospect portfolios. Incorporation of geophysical evidence (DHIs) in a realistic risk assessment. Target Audience This VILT course has been designed in the first place for geoscientists working in exploration, for prospect portfolio analysts and for their direct supervisors. It will also benefit staff from disciplines working closely with exploration staff, such as reservoir engineers, petrophysicists and geophysicists. Course Level Intermediate Training Methods Learning, methods and tools 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. It is the intention to have at least 2 smaller exercises per day. Time will be reserved for recapitulation, questions and discussions. VILT will be conducted either via Zoom or Microsoft Teams. Presenting materials can easily be done on this platform. When participants need to ask a question, they can raise their hand, write notes or interrupt the Instructor by using their microphone. The presenter can switch to a screen where he/she can see all participants (also when each participant is sitting in another location e.g. at home). There is also a whiteboard functionality that can be used as one would use a flip chart. Exercises will be done on an online platform which provides each participant with a private work area that can be accessed by the Instructor to discuss the exercise in a similar manner as in a classroom course. Each topic is introduced by a lecture, and learning is re-enforced by practical exercises and discussions. Handout material in electronic format will be provided. Trainer Dr. Jan de Jager has a PhD in Geology from the University of Utrecht. He joined Shell in 1979 as an exploration geologist, and worked in several locations around the world such as Netherlands, Gabon, USA, Australia, Argentina, and Malaysia in technical and management positions. During the last 10 years of his career, he was responsible for the quality assurance of Shell's exploration prospects in many parts of the world and for upgrading and replenishing Shell's global exploration portfolio. During this period, he had also developed extensive expertise in Prospect Risk and Volume assessments for which he ran successful internal training programmes. Following his retirement from Shell in 2010, Dr Jan de Jager took on a position as part-time professor at the University of Amsterdam and also serves as a consultant exploration advisor for various E&P companies. 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

All organizations have policies and procedures that guide how decisions are made and how the work is done in that organization. Professionally written policies and procedures increase organizational accountability and transparency and are fundamental to quality/standards assurance and quality improvement.

About this training course This 5 full-day course will cover all aspects of gas turbines, co-generation and combined cycle power plants. It will cover in detail all the components of these types of power plants such as: compressors, gas and steam turbines, heat recovery steam generators, deaerators, condensers, lubricating systems, instrumentation, control systems, and economics. The design, selection considerations, operation, maintenance, pay-back period, economics of co-generation plants and combined cycles, as well as, emission limits, reliability, monitoring and governing systems are also covered in detail. This course will also provide up-dated information in respect to all the significant improvements that have been made to co-generation and combined cycles power plants, during the last two decades. The course will illustrate through sophisticated computer simulation how gas turbines, co-generation and combined cycle plants perform under steady-state and transient conditions. In addition, the participants will learn how to use the computer simulation program which provides the following benefits: Allow the operator to extend the gas turbine operating period by avoiding unnecessary outages and maintenance activities. Determination of essential gas turbine maintenance activities to reduce the duration of outages. Profit optimization of co-generation and combined cycle plants. Minimization of the environmental emissions of co-generation and combined cycle plants. Training Objectives Power Plant Computer simulation: Gain a thorough understanding of computer simulation of gas turbines, co-generation, and combined cycle plants. Power Plant Components and Systems: Learn about all components and subsystems of the various types of power plants such as gas turbines, co-generation and combined cycle plants Power Plants Economics: Examine the advantages, applications, performance and economics of power plants such as: gas turbines, co-generation, and combined cycle plants Power Plant Equipment: Learn about various power plant equipment including: compressors, turbines, governing systems, combustors, deaerators, feed water heaters, etc. Power Plant Maintenance: Learn all the maintenance activities required for power plants such as: gas turbines, co-generation plants and combined cycles to minimize their operating cost and maximize their efficiency, reliability, and longevity Power Plant Environmental Emissions: Learn about the monitoring and control of environmental emissions. Power Plant Instrumentation and Control Systems: Learn about the latest instrumentation and control systems of gas turbines, co-generation and combined cycles power plants Power Plant Reliability and Testing: Increase your knowledge of power plant predictive and preventive maintenance, reliability and testing. Power Plant Selection and Applications: Gain a detailed understanding of the selection considerations and applications of power plants such as: gas turbines, co-generation and combined-cycle power plants Power Plant Profitability: Learn about the reliability, life cycle cost, profitability, refurbishment, and life extension methods for gas turbines, co-generation and combined cycle power plants. Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: 'POWER GENERATION HANDBOOK' second edition, published by McGraw-Hill in 2012 (800 pages) Practical manual (500 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

About this Training Course Wind has surpassed hydro-power generation in many countries recently. Wind energy offers many advantages, which explains why it's one of the fastest-growing energy sources in the world. The following are the advantages of wind power: Wind power is cost effective: Land-based utility-scale wind is one of the lowest-priced energy sources available today The fuel for wind power is free. This reduces the operation and maintenance cost of wind power plants significantly Wind is a clean source of power generation that does not pollute the air like power plants which rely on combustion of fossil fuel Wind power plants create jobs. Wind turbine technician is the fastest growing career in many countries Wind enables industry growth and competitiveness due to its low cost Wind power is a domestic source of energy. The wind supply is abundant and inexhaustible. The wind power generation capacity has become the largest source of renewable power in many countries Wind turbines can be built on existing farms and ranches. This greatly benefits the economy in rural areas, where most of the best wind sites are found. Wind power plant owners make rent payments to the farmers or ranchers for the use of their land, providing landowners with additional income This 5 half-day course covers all aspects of wind power plants including evaluation of a potential location for a wind power plant using wind data and using statistical distributions to approximate available wind energy at a wind power plant site. It provides also an in-depth understanding of all wind power plant equipment including wind turbines, generators, instrumentation and control systems, drive trains, gearboxes, doubly fed induction generators, synchronous generators, nacelles, towers, transformers, etc. The economics of a wind power plant including economic analysis of wind power generation, economic comparison between a large- and small-scale wind power plant, economic decision making, rate of return from a wind power plant, economic life and replacement of a wind power plant as well as the cost of electricity from wind power plants are covered in detail in this course. A thorough explanation of the design, operation and maintenance of on-shore and off-shore wind farms is presented in detail in this course as well as all the significant improvements that have been made to wind power generating plants during the last two decades. Training Objectives Evaluation of a Potential Location for a Wind Power Plant Using Wind Data: Learn how to evaluate the potential location for a wind turbine power plant using wind data. Using Statistical 'Rayleigh' Distribution to Approximate Available Power Generation from a Wind Turbine at a Specific Site: Learn how to use statistical 'Rayleigh' distribution to approximate available power generation from a wind turbine at a specific site. Calculate the Wind Energy Available at a Site: Gain an understanding on how to calculate the wind energy available at a site. Rated Capacity of a Wind Facility and Capacity Factor: Understand how to determine the rated capacity of a wind facility and its capacity factor. Designing a Wind Power Generating Plant: Learn how to design a wind power generating plant. Wind Power Plant Equipment Operation and Maintenance: Understand the operation and maintenance requirements for all wind power plant equipment including wind turbines, generators, nacelles, towers, transformers, etc. Wind Power Plant Instrumentation and Control Systems: Gain a thorough understanding about the latest instrumentation and control systems of wind power plants. Economics of Wind Power Plants: Gain a thorough understanding of the economics of wind power plants including economic analysis of wind power generation, economic comparison between a large- and small-scale wind power plant, comparison of alternatives, rate of return from a wind power plant, financial statements for a wind power plant, cost of electricity from a wind power plant, and levelized cost of wind energy.   Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a soft copy of the following materials written by the instructor: POWER GENERATION HANDBOOK' second edition, published by McGraw-Hill in 2012 (800 pages) Wind Power Generating Plant Manual (500 pages) 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