274 Courses in Glasgow

This one-day or Two Session workshop will focus on a key but often ignored communication skill: Focused Listening.

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

This very practical workshop has a simple objective: to help you prepare, design and deliver memorable and high-quality presentations. This programme will help you: Use a proven, structured tool-kit when designing and developing presentations Benefit from short cuts and best practice when designing and using Powerpoint presentations Select the right information, examples, exercises and activities - and use them well Prepare and structure a presentation or session appropriate to the audience, and to best achieve your objectives Maintain audience or group interest Develop and practise presentation skills to improve your voice tone, speech power and body language Use practical methods to control nerves and anxiety - develop higher levels of confidence and credibility Command a room, hold attention and create a high impact 1 Introduction Personal objectives Key messages and learning objectives of the workshop 2 Presentation skills What does good look like? Exercise: Characteristics of high/low impact presentations Presenting yourself as a 'winner' The energy / attitude model Exercise: Being a winner 3 Preparation skills - eight steps to preparing a great presentation, plus Powerpoint tips •The magic circle• How to 'assume the role' when presenting• The eight steps• Step 1 - develop your objectives- The five questions that you must answer before preparing your presentation- Defining your objectives and outcomes- Creating a first draft- Step 1 exercise• Step 2 - analyse your audience- Doing your homework: audience, event, venue- Developing a pre-event check-list- Methods and means for researching your audience- Step 2 exercise• Steps 3 and 4 - structure the main body of your presentation and state the main ideas- Ways to structure your presentation for maximum impact- Balancing and managing content and topics- Organising your information: 6 options and methods- Your 'one main point' and creating a 30-second summary- Steps 3 and 4 exercises• Step 5 - decide on supporting information, using the toolkit- Making your case convincing: ways to support your claims- Selecting and using relevant and interesting examples- Quotes, case studies and printed material- Presenting statistics, tables and graphs- Ways of maintaining visual interest- Transitions and links, creating a 'golden thread'- Step 5 exercise: Creating compelling stories and anecdotes4• Step 6 - create an effective 'opening'- Claiming the stage and creating a good first impression- The three most powerful ways of opening a presentation- The five elements of a strong opening- Step 6 exercise: Participants work individually to prepare an opening, focusing onpersonal introduction, and then deliver to the group, with structured feedback• Step 7 - develop transitions- Step 7 exercise / examples• Step 8 - create an effective close- Signalling and sign-posting; the importance of, and how to do it effectively- Five ways to close a presentation successfully- Step 8 exercise / examples• Presentation design and Powerpoint- An interactive review of participants' own real-life past presentations and advanced tipsand techniques on using Powerpoint effectively 4 Facilitation skills The three main types of group activity - triads, teams and main group How to select the right activity, define the objectives, set it up and run the debrief Using energisers - with examples Exercise: Dealing with 'difficult' behaviours Exercise: Working in triads, design and deliver 5 Tips and tricks: presentation and facilitation 10 reasons why facilitation fails Five golden rules for success Defining the session goals and the facilitation plan Open and closed questions - why and when to use Using a 'car park' to manage unresolved issues Using AV aids - tips and tricks Exercises: Including participants working in pairs to prepare a short section form of one of their own presentations 6 Putting it all together Summary of key learning points Action plan

Stress can affect your ability to think clearly and rationally and to perform well. This session aims to help you better deal with stress by sharing key insights and strategies to reduce stress and optimize your work-life balance, particularly as we face uncertainties in the economy, the workplace and the environment.

Effective communication is a skill. This half-day workshop is very interactive - participants can practise their communication skills in a positive, supportive environment. 1 Welcome, introductions and objectives The definition of effective communication Exercise: sending a message 2 Verbal communications Effective communicators - who are they? What skills or attributes do they have? Listening skills, clear use of words, presence, eye contact, body language 3 How good a listener are you? Exercise: listening skills questionnaire and evaluation 4 Impact versus intent - what did you really mean to say? Attitudes influence behaviour and behaviour breeds behaviour Exercise: 'I never said she stole money' The need to avoid misunderstanding or misinterpretation 5 The 5 key principles to effective communication Exercise: 'What would you say?' 6 Written communication What makes an effective written communication? Kipling's 6 Honest Men: who, what, where, when, why and how Planning to write an email 7 Fuzzy meanings Probabilities for misunderstandings and misinterpretations 8 Practical exercise Hone written communication skills and put into practice hints and tips from the session 9 Review of key learning points and objectives

About this Training Course Liquefied Natural Gas (LNG) has provided intercontinental mobility to natural gas, which now provides about 25% of the global primary energy. Being the cleanest fossil fuel, natural gas/LNG consumption is forecasted to grow in all future scenarios. With the entry of various players, including Trading companies, the LNG value chain is becoming increasingly complex, and a solid understanding of its economics and management of its interfaces have become crucial to identify and assess investment opportunities and risks. Recent market disturbances caused by COVID-19, Oil & Gas price instabilities - coupled with the political (Ukraine/Russia) challenges - make a deep understanding of LNG Value Chain Logistics and Economics even more essential to ensure the security of energy supplies sustainably and profitably. This intermediate level 3 full-day course starts with a concise introduction to the LNG business. Thereafter, the elements of the LNG value chain are described, and their individual economics analysed. A Business Activity Model along the value chain will be developed and discussed in depth, covering the following key processes: 'Buy Gas - Transport Gas - Liquefy Gas - Sell LNG/Products - Ship LNG - Regasify LNG' The integrated chain economics will then be developed and quantified. A hands-on group workshop/exercise developing the economic case of a full-sized Liquefaction project will be carried out, considering the forecasted cash flows throughout the project life, the location of the plant, its markets, project sensitivities and profitability assessment. Participants will be provided with Excel based tools/models (LNG Liquefaction project development Net Present Value (NPV) analyses, Shipping Freight Calculations and Economics) to work through the exercises and also for their future personal use. Training Objectives After the completion of this course, participants will be able to: Understand how the LNG Value Chain operates, bound by the relevant Contracts and Agreements. Learn the basic economic parameters (operating, capital costs, financing, profitability) of each major element of the value chain. Appreciate the complexity of the value chain, and the associated opportunities and risks. Develop quantitative project evaluation skills. Explore options to maximise profitability in a given LNG value chain. Discuss best practices on how to manage, steer and govern these activities. Target Audience Technical, Operational, Shipping, Commercial, Project and Governance professionals who are already active in a specific section of the LNG Value Chain will directly benefit in developing a wider and deeper perspective on how the LNG Value Chain operations and can be optimised. Managers (Technical, Financial, Legal and Governance) less familiar with the specifics of the LNG Industry will also benefit from attending this VILT course, as they will obtain the required background to be able to set sharper targets, suitable performance indicators, and governance and performance assessment guidelines for units engaged in the chain. The course is most relevant for professionals engaged in the LNG industry at: National and International Oil & Gas/Energy Companies LNG Importers/Exporters/Traders/Shippers Government & Regulatory Agencies Finance Institutions It will also apply to the following audience: Business Development Managers Corporate Planning Professionals Project Developers Supply Planners & Scheduling Professionals Regulators Tax & Finance Advisors Compliance Officers Equity Analyst and Bankers Joint Venture Representatives, Board Directors Negotiators and Contracting Staff Trading Professionals Course Level Intermediate Trainer Your expert course leader is an Oil & Gas/LNG professional with more than 35 years of international experience, majority of which was gained at Shell International Joint Ventures engaged in Oil Refining, Supply / Trading, Gas Supply and LNG Businesses in the Netherlands, France, Thailand, Dominican Republic and Nigeria. Since 2004, he has had several roles in the management of the LNG Value Chain including the Commercial Operational Management of Nigeria LNG (NLNG). He played an active role in the start-up and integration of LNG trains 4, 5 and 6 with NLNG becoming the 3rd largest LNG producer in the world in 2007. Commercial operations spanned 4 Gas Supply, 11 LNG Sales & Purchase Agreements, ad-hoc LPG and Condensate Sales and LNG Ship Chartering contracts. Under his supervision, more than 2,000 LNG cargoes were exported. He was part of the organizational transformation of the company from a Project-based set-up to a Production / Commercial based structure and implemented an 'Integrated Planning and Scheduling Department' in which he optimized the value chain (Buy-Gas - Liquify Gas to LNG - Sell - Ship LNG). Staff competence management was one of his focus areas during this period. He was also the NLNG representative on JV Technical, Commercial, Shipping Committees where he interfaced with Government & Regulatory authorities. In 2014, he was appointed as Shell Shareholder representative to NLNG and became a Non-Executive Board member to NLNG companies, including Bonny Gas Transport (BGT) managing 24 LNG Ships. During this period, he was involved in the Economic and Technical steering of the Shipping Fleet and Liquefaction Plant Rejuvenation projects and a further capacity expansion of liquefaction plant which resulted in the achievement of NLNG train 7 project FID in 2019. Since 2016, he has been active as an independent consultant. He co-authored 2 patents and more than 30 published papers/presentations. He holds a PhD from Delft University of Technology in the Netherlands and a MSc and BSc in Chemical Engineering 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

ISO 3834:2021 (Quality requirements for fusion welding of metallic materials) Lead Auditor” course provides comprehensive training for participants to be able to understand and audit each and every ISO 3834:2021 guidelines in ensuring orgnaisation compliance and continual improvement in the welding industry

About this Training Course This five-day training course will cover aspects of FPSO operations with an emphasis on management of safety. A background of the methodology used to generate the various safety plans and codes used in the operational safety case will be covered. The course will also review general operational guidelines in the offshore environment to ensure that the operations are completed as designed. This will include offtake operations and maintenance processes for the plant and vessel as well as a session on subsea. Training Objectives To enable participants to obtain an in-depth understanding of FPSO operations, safety and maintenance: Provide a broad overview of how an FPSO operation is set up and established in the field Grasp the various methods used to moor the production units Analyse information and methods required to establish the operation according to local and international regulations. Assess the methods used to calculate the safety parameters and requirements to construct an approved valid safety case Explore conditions to monitor during operations with regards to safety and structure Inspect various types of hazards associated with production and produced materials Review regular and emergency operational maintenance requirements Examine cyclones and weather events causing disconnection Comprehend manning, training requirements and operations including cargo Case studies and Exercises: The training course uses real life examples and case studies to explain the setup, preparation, implementation and operational activities required to successfully complete FPSO operations from a safety and maintenance perspective. This will allow the application of participants' newly-acquired knowledge. Case studies also stimulate independent thinking and discussion among the participants. Case Studies The case studies proposed for this course will include: A group exercise to consider what is the minimum requirement for the production of a safety case Generic plan for the development of a maintenance management system using computer software systems (e.g. Amos) Construction of a UWILD plan to include scope and potential tendering requirements Quizzes The various quizzes can be expanded or arranged to suit the group/interests and topics covered but will generally include the following topics: Mooring types and location where they are primarily used Safety cases Safety management systems Process hazards and mitigation UWILD components and regulations Operations management Offtake operations Target Audience The course is generally aimed at personnel who are involved in FPSO operations as either offshore crew or onshore support team members. This course will also greatly benefit the following groups but not limited to: Process engineers Surveyors Facility engineers Naval architects Operations engineer Health, Safety, Environment (HSE) specialists and managers Maintenance engineers Course Level Intermediate Training Methods The training course is presented in an interactive workshop format that allows for discussion. The course will be delivered through analysis of case studies and running examples of problems. Course Duration: 5 days in total (35 hours) The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training comprises of information supplemented by visual activities including photographs from various operations and videos of operational and safety activities. Interaction verbally will be necessary to achieve the best learning outcome from the materials. Course timings and breaks  0830 - Registration 0900 - Start of training 1030 - Morning break 1045 - Training recommences 1230 - Lunch break 1330 - Training recommences 1515 - Afternoon break 1530 - Training recommences 1700 - End of training Trainer Your expert course leader has been involved in the Oil and Gas industry for over 28 years in several different roles commencing as a second deck officer on FPSO's and moving through the industry from deck officer to Master, OIM and Field Superintendent. He has also been in charge of semisubmersible and fixed production platforms as field superintendent before moving ashore into senior management roles. On completion of industry specific activities, he moved to teaching roles at South Tyneside Maritime College in the department of marine and simulation and presented live courses to maritime students from cadet to Master.  Prior to returning to Perth in March 2019, he was training manager for a subsidiary of Gaz Transport and Technigaz of France. He has a Master Class 1 certificate with endorsements for hazardous cargoes and a Graduate Certificate in Business Administration as well as multiple course certificates required to operate FPSO's, platforms and semisubmersible facilities. He has been involved in the preparation of national standards for Safety Cases (Australia); Designing and structural setup of competency-based training systems in South East Asia. He was also involved in the development of minimum standards, competency profiles position based and preparation and implementation of training plans to ensure competency in the local staff in Asian operations. He was part of the development team for minimum standards of offshore safety in Australian offshore operations including the implementation of the Common Safety Training Program (CSTP). He was also involved in implementing training plans for both simulator and classroom based courses in LNG operations and cargo tank design and construction. Highlighted work experience: Premier Petroleum Myanmar Ltd Petronas Carigali Newfield Australia (Cartier) Pty Ltd: FPSO Jabiru Venture FPSO Challis Venture Onshore OIM Australian FPSO Management Pty. Ltd. 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

Our workshop packages are perfect for groups looking for an alternative activity to take part in as part of a corporate event, team building exercise, stag or hen do, birthday party, Christmas party or any other occasion you’d like to embellish with a unique creative spin.  Below is a list of ‘off the shelf’ workshops and packages we currently offer however each of these can be customised to suit your needs. So if you like the look of tie due but also want to give t-shirt printing a go drop us an email and we’ll do our best to make it happen. Similarly if you’d like any of these experiences to come to you please get in touch as a selection of our equipment is portable. Booking a workshop as a group would give you a discount price as well. If you are more than 5 people, you can get it from 50£ per person (regular price 75£) for our usual 6h workshop. We also offer short courses (2/3 hours) for 25£ per person. - TSHIRT PRINTING WORKSHOP - PAPER PRINTING WORKSHOP - FABRIC PRINTING WORKSHOP Email hello@3rdrailprintspace.co.uk for a quote.

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