30405 TEC courses

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.

Oracle Database 12c Admin training course description This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs. What will you learn Administer an Oracle database instance. Monitor an Oracle database. Configure the Oracle network environment. Create and manage database storage structures. Manage users, profiles, privileges and roles. Manage undo data and temporary segments. Monitor and resolve lock conflicts. Maintain database security. Implement database auditing. Monitor the performance of the Database. Load and unload data. Use the job scheduler. Configure a database for backup and recovery. Oracle Database 12c Admin training course details Who will benefit: This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. Prerequisites: An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended. Duration 5 days Oracle Database 12c Admin training course contents Introduction to Oracle database 12c Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks. Oracle Database 12c Architecture Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance. Administer a database instance Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files. Configure the Oracle network environment Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager. Storage Structures Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles. Manage users Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions. Manage profiles and resources Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles. Manage privileges Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles. Database auditing Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options. Data concurrency and lock conflicts Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts. Undo management Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size. Proactive database management Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/ Performance management Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory. SQL tuning SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor. Moving data Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables. Automate tasks with the scheduler Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule. Managing resources with Resource Manager Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans. Manage space Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments. Backup and recovery configuration Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability Oracle support The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch

Course Summary Taught by Sports Massage Therapist Laura Simmons, this practical course will cover everything you need to know, enabling you to incorporate Dry Suction Cupping into your current treatments. Covering all the theory as well as ensuring you have plenty of practical demonstration and practice during the course. This is a great addition to any manual therapist treatment for both the therapist and the patient. You will be introduced to the use of Dry Cupping therapy for the purpose of muscular pain relief via a blend of theory and practical components. With a substantial amount of practical work where you will gain adequate practice to hone your skills enabling you to use all the techniques shown within your practice. Course Content Introduction History of Cupping Different Cups Cupping Application Effects of Cupping Contractions & Contraindications Effects of Cupping Gathering Information Cupping Application; Massage, Stationary, Pin and Stretch and Active Cupping We only have small numbers on all our courses ensuring you have plenty of time with Laura to really develop your technique and feel confident in offering this technique to your patients. We pride ourselves on always being there ready to help and offer advise not only during the course but after as well, all you need to do is ask! Course Prerequisites Physiotherapists Osteopaths Chiropractors Manual Therapists Sports Therapists Sports Massage Therapists Personal trainers We may ask you to provide a copy of your qualification. Assessment Observation during the course day Once completed you will be able to add Dry Cupping therapy on to your own indemnity insurance Venue BTST Academy & Clinic, Holly Farm, Clipstone Road, Edwinstowe, Nottingham, NG21 9JD Course Times 9:30am – 4:30pm Course Price £ 175 Course Terms & Conditions: Course payment is non refundable , Click here for the terms and conditions. Course Accreditation Accredited by Active IQ

About this training course This 5 full-day course provide a comprehensive understanding of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, HART protocol, control valves, actuators, and smart technology. This course will focus on maximizing the efficiency, reliability, and longevity of these systems and equipment by providing an understanding of the characteristics, selection criteria, common problems and repair techniques, preventive and predictive maintenance. This course is a MUST for anyone who is involved in the selection, applications, or maintenance of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology because it covers how these systems and equipment operate, the latest maintenance techniques, and provides guidelines and rules that ensure their successful operation. In addition, this course will cover in detail the basic design, operating characteristics, specification, selection criteria, advanced fault detection techniques, critical components and all preventive and predictive maintenance methods in order to increase the reliability of these systems andequipment and reduce their operation and maintenance cost This course will provide the following information for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology: Basic Design Specification Selection Criteria Sizing Calculations Enclosures and Sealing Arrangements Codes and Standards Common Operational Problems All Diagnostics, Troubleshooting, Testing, and Maintenance Practical applications of smart instrumentation, SCADA, and Distributed Control Systems, control valves, actuators, etc in the following industries will be discussed in detail: Chemical and petrochemical Power generation Pulp and paper Aerospace Water and sewage treatment Electrical power grids Environmental monitoring and control systems Pharmaceutical plants Training Objectives Equipment Operation: Gain a thorough understanding of the operating characteristics of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Diagnostics and Inspection: Learn in detail all the diagnostic techniques and inspections required of critical components of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Testing: Understand thoroughly all the tests required for the various types of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Maintenance and Troubleshooting: Determine all the maintenance and troubleshooting activities required to minimize the downtime and operating cost of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Repair and Refurbishment: Gain a detailed understanding of the various methods used to repair and refurbish modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Efficiency, Reliability, and Longevity: Learn the various methods used to maximize the efficiency, reliability, and longevity of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Sizing: Gain a detailed understanding of all the calculations and sizing techniques used for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Design Features: Understand all the design features that improve the efficiency and reliability of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Selection: Learn how to select modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology by using the performance characteristics and selection criteria that you will learn in this course Equipment Enclosures and Sealing Methods Learn about the various types of enclosures and sealing arrangements used for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Commissioning: Understand all the commissioning requirements for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Codes and Standards: Learn all the codes and standards applicable for modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology Equipment Causes and Modes of Failure: Understand the causes and modes of failure of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology System Design: Learn all the requirements for designing different types of modern control systems, digital control, distributed control systems (DCSs), supervisory control and data acquisition (SCADA) systems, industrial instrumentation, control valves, actuators, and smart technology 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 copy of the following materials written by the instructor: Industrial Instrumentation and Modern Control Systems Practical Manual (400 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

About this Virtual Instructor Led Training (VILT) This Virtual Instructor Led Training (VILT) course is designed with the aim of showing the degree of integration necessary in developing an offshore petroleum discovery, from field appraisal to development. The 5 half-day VILT course gives a comprehensive account of the methodology, processes and techniques utilised in developing an offshore oil or gas discovery. Technically, integration of expected reservoir behavior, well planning and design, and facilities concepts and selection are exemplified through detailed case histories, group discussions and exercises. Commercial aspects related to overall project evaluation are also covered. Training Objectives Course participants will obtain a comprehensive understanding of key aspects of offshore field development, from appraisal through to development planning and leading up to sanction. The VILT course covers the three key elements: reservoirs, wells and facilities, and covers the integration of these with commercial aspects, and the required management aspects, including uncertainty and risk. Target Audience This VILT course is designed for project managers, field development and planning engineers, asset managers, petroleum engineers, reservoir engineers as well as field geoscientists and managers who have an interest in or are involved in field development feasibility and planning. In particular, this VILT course would be of interest to managers leading multidisciplinary and diverse functional teams. Course Level Basic or Foundation 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 Trainer 1: Your first expert course leader is a specialist in reservoir engineering, field development planning and petroleum management. Having worked for over 40 years in the petroleum industry, his most recent full-time position was Chief Operating Officer and Project Director for AED Oil and East Puffin (2007-09) for the Puffin offshore development, Timor Sea. Prior to his academic career (2001-2006), commencing in 2001 as head of the new School of Petroleum Engineering and Management at the UA, he worked for 16 years for BHP Petroleum (now BHP Billiton), most recently as Chief Reservoir Engineer for their worldwide operations. Other positions with BHP Billiton involved mainly technical and project management, and general management positions, including member of the BHP Board. He was project manager (feasibility) for two FPSO projects, the Skua and Griffin area fields, offshore Australia. He was also the Technical Manager for the Dai Hung project, offshore Vietnam where first oil was achieved in just 18 months from sanction. Before that time, he worked for Shell International (8 years) in the Netherlands, including two years as Senior Lecturer Reservoir Engineering at Shell's training centre and in Australia, seconded to Woodside Energy, with a key role in Australia's largest capital project (at the time), the Northwest Shelf Gas development. He started his career in Calgary, Canada, first with Hudson's Bay Oil and Gas and subsequently with the US consulting company, Scientific Software Corporation. He holds a BSc degree in Physics from the University of British Columbia and a MS degree in Nuclear Engineering from Stanford University. He has been an active member of the Society of Petroleum Engineers, including Director for the Asia-Pacific region (1996-98) and as a member of the Board. He was an SPE Distinguished Lecturer during 2001-02 and a PESA Distinguished Lecturer during 2002. He has lectured at many institutions and was a visiting professor at Stanford University in 2000. He has published over 50 papers on both technical and managerial topics. His professional interests are in optimal planning and project management of offshore petroleum discoveries. His primary research interests are in the area of special core analysis and the development of predictive models for reservoir characterisation. Trainer 2: Your other course leader is currently an independent consultant and trainer after 37 years in the upstream petroleum industry. His previous roles included Chief Geologist for GALP Energy, Consultant/ Head of Exploration for Qatar Petroleum, Technical/ Asset Manager for SASOL, and various technical and technical management roles in BHP Billiton Petroleum and Chevron. He managed/ executed many projects in diverse locations: West Grimes gas field development - California; Port Arguello heavy oil development - offshore California; exploration & development projects - Nigeria; Tengiz field early development, Korolev appraisal - Kazakhstan; Nkossa field development, Moho/ Bilondo exploration - offshore Congo; PNG divestment, Bayu-Undan LNG development - Australia; Ohanet acquisition, appraisal & development - Algeria; Pande development, Pande/ Temane gas plant expansion & near field exploration - Mozambique; Pre-Khuff (HP/HT) exploration, multiple blocks & operators - Qatar; Coral/ Mamba appraisal - Mozambique; Blocks 14/32 exploration & development - Angola; exploration & appraisal - onshore & offshore Brazil. He has an MSc in Geophysics from Stanford, an MBA from St. Mary's College of California, and a BSc in Geology (Honors) from Western Illinois University. He is a member of SEG, AAPG, SPE, PESGB, and PESA and is a Fellow of the Energy Institute (UK). His professional interests centre around deploying this extensive and international experience base to add value to future projects via training and consultancy, and to provide the leadership needed to execute, deliver, and ensure profitability of new projects. 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

About this training course This 5 full-day course provides a comprehensive understanding of the inspection, diagnostic testing, troubleshooting, maintenance, overhaul and refurbishment of all steam and gas turbines. This course will focus on maximizing the efficiency, reliability, and longevity of this equipment by providing an understanding of the common problems and repair techniques, preventive and predictive maintenance of all steam and gas turbines. This course is a MUST for anyone who is involved in diagnostic testing, troubleshooting, or maintenance of steam and gas turbines because it covers the various maintenance strategies, troubleshooting techniques, and the latest testing and refurbishment methods of all steam and gas turbines. The course provides also guidelines and rules that ensure successful refurbishment of all types of steam and gas turbines. In addition, this course will cover in detail advanced fault detection techniques, critical components and all preventive and predictive maintenance methods of steam and gas turbines in order to increase their reliability and reduce their operation and maintenance cost. This course will provide the following information for all types of steam and gas turbines: Diagnostic Testing Techniques Troubleshooting Methods Latest Maintenance Strategies Modern Refurbishment Methods Enclosures and Sealing Arrangements Codes and Standards Common Operational Problems All Predictive and Preventive Maintenance Methods Performance Surveillance Methods Training Objectives Equipment Maintenance: Gain a thorough understanding of the latest maintenance strategies of steam and gas turbines Equipment Diagnostics and Inspection: Learn in detail all the diagnostic techniques and inspections required for critical components of steam and gas turbines Equipment Testing: Understand thoroughly all the tests required for the various types of steam and gas turbines Equipment Troubleshooting: Determine all the troubleshooting activities required to minimize the downtime and operating cost of steam and gas turbines Equipment Repair and Refurbishment: Gain a detailed understanding of the various methods used to repair and refurbish steam and gas turbines Efficiency, Reliability, and Longevity: Learn the various methods used to maximize the efficiency, reliability, and longevity of steam and gas turbines Equipment Performance Surveillance: Gain a detailed understanding of the various methods used to perform performance surveillance on steam and gas turbines Design Features: Understand all the design features that improve the efficiency and reliability of steam and gas turbines Equipment Enclosures and Sealing Methods: Learn about the various types of enclosures and sealing arrangements used for steam and gas turbines Equipment Commissioning: Understand all the commissioning requirements for steam and gas turbines Equipment Codes and Standards: Learn all the codes and standards applicable for steam and gas turbines Equipment Causes and Modes of Failure: Understand the causes and modes of failure of steam and gas turbines 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 copy of the following materials written by the instructor: Excerpt in digital format of the relevant chapters from the 'POWER PLANT EQUIPMENT OPERATION AND MAINTENANCE GUIDE' published by McGraw-Hill in 2012 (800 pages) Excerpt in digital format of the relevant chapters from the 'POWER GENERATION HANDBOOK' second edition, published by McGraw-Hill in 2011 (800 pages) Steam and Gas Turbines Maintenance Manual (300 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

About this Training Course This 5 full-day course provides a comprehensive understanding of the various types of generators, exciters, automatic voltage regulators (AVRs), governing systems, and protective systems. The focus will be on maximizing the efficiency, reliability and longevity of these equipment by providing an understanding of the characteristics, selection criteria, common problems and repair techniques, preventive and predictive maintenance. The emphasis of this course is on protective systems, inspection methods, diagnostic testing, troubleshooting, modern maintenance techniques, refurbishment, rewind and upgrade options, as well as advanced methods for preventing partial discharge and other failures. Training Objectives Equipment Operation: Gain a thorough understanding of the operating characteristics of generators, exciters, AVR's and protective systems Equipment Diagnostics and Inspection: Learn in detail all the diagnostic techniques and inspections required of critical components of generators, exciters, AVR's and protective systems Equipment Testing: Understand thoroughly all the tests required for the various types of generators, exciters, AVR's and protective systems Electrical Generator Protective Systems: Gain a thorough understanding of all Electrical generator protective systems including: all electrical relays, tripping mechanisms, protective systems for negative phase sequence (unbalance loading), loss of excitation, over fluxing protection (over-voltage and underfrequency), reverse power (generator monitoring), over-speeding, pole slipping / out of step (sudden increase in torque or weakness in excitation), Class A protection, Class B protection Equipment Maintenance and Troubleshooting: Determine all the maintenance and troubleshooting activities required to minimize the downtime and operating cost of generators, exciters, AVR's and protective systems Equipment Repair and Refurbishment: Gain a detailed understanding of the various methods used to repair and refurbish generators, exciters, AVR's and protective systems Equipment Rewind and Upgrade Options: Discover all options available to rewind and upgrade the generator rotor and stator to enhance the output and reduce downtime Efficiency, Reliability, and Longevity: Learn the various methods used to maximize the efficiency, reliability, and longevity of generators, exciters, AVR's and protective systems Advanced Methods to Prevent Failure: Gain a thorough understanding of all the methods used to prevent partial discharge, and other failures in generators, exciters, AVR's and protective systems Equipment Sizing: Gain a detailed understanding of all the calculations and sizing techniques used for generators, exciters, AVR's and protective systems Design Features: Understand all the design features that improve the efficiency, reliability of generators, exciters, AVR's and protective systems Equipment Selection: Learn how to select generators, exciters, AVR's and protective systems by using the performance characteristics and selection criteria that you will learn in this course Equipment Enclosures and Sealing Methods: Learn about the various types of enclosures and sealing arrangements used for generators, exciters, AVR's and protective systems Equipment Commissioning: Understand all the commissioning requirements for generators, exciters, AVR's and protective systems Equipment Codes and Standards: Learn all the codes and standards applicable for generators, exciters, AVR's and protective systems Equipment Causes and Modes of Failures: Understand causes and modes of failures of generators, exciters, AVR's and protective systems System Design: Learn all the requirements for designing different types of generators, exciters, AVR's and protective systems 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: ELECTRICAL EQUIPMENT HANDBOOK' published by McGraw-Hill in 2003 (600 pages) Generator Inspection, Testing, Maintenance, Protective Systems and Refurbishment Manual (this manual covers all the inspection and maintenance activities as well as all protective systems required for generators - 400 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

Cosmetic College is excited to introduce our new combined training package, designed to provide in-depth expertise in two of the most sought-after cosmetic procedures: microblading and micropigmentation. This unique program combines our VTCT Level 4 Certificate courses in Enhancing Eyebrows with Microblading Techniques and in Micropigmentation, offering a holistic approach to advanced cosmetic training. Course Details: VTCT Level 4 Certificate in Enhancing Eyebrows with Microblading TechniquesDuration: 3 daysContent Overview:Anatomy and physiology for microblading techniques.Health, safety, and hygiene for the microblading sector.Consultation, treatment planning, and preparation.Enhancing eyebrows with microblading techniques.Managing and marketing your microblading business. VTCT Level 4 Certificate in MicropigmentationDuration: [Specify Duration]Content Overview:Advanced techniques in micropigmentation.Comprehensive understanding of color theory and pigment selection.Skin anatomy and physiology relevant to micropigmentation.Health, safety, and hygiene standards for micropigmentation.Client consultation, design, and aftercare procedures. Combined Package Benefits: Comprehensive Skill Set: Gain expertise in both microblading and micropigmentation, enhancing your versatility and employability in the beauty industry. Cost-Effective Learning: Enroll in both courses at a reduced total cost compared to taking the courses separately. Integrated Curriculum: Experience a curriculum that seamlessly integrates the knowledge and skills from both courses, providing a cohesive learning journey. Expert Instructors: Learn from industry experts with extensive experience in cosmetic procedures. Certification and Recognition: Upon successful completion, receive two VTCT Level 4 Certificates, recognised internationally for their high standards in the beauty sector. Who Should Enrol? This package is ideal for beauty professionals looking to expand their service offerings, individuals seeking a career in advanced cosmetic procedures, and those aspiring to become experts in eyebrow enhancement and skin pigmentation techniques.

About this Training Course This course will provide detailed learning to the various aspects of the design, analysis and operation of subsea control systems for a variety of field development options to allow effective management of subsea facilities either from offshore structures or from shore bases. This will include power and telemetry focussing on electrical, hydraulic and electro-hydraulic systems, shut down systems, and application of intelligent monitoring and 'smart' fields. Training Objectives By attending this course, participants will be able to: To provide detailed knowledge and understanding of the requirements for, and design of, subsea electrical, electro-hydraulic, hydraulic and programmable control systems. Knowledge of the components and uses of a wide variety of subsea control systems the requirements for and design implications, of umbilicals and control lines (power and telemetry) Knowledge of, and ability to model, power requirements subsea and detailed understanding of the requirements and objectives of pre-commissioning, both at the factory and in situ. Knowledge of the standards involved in design of equipment, control and application of manual and automatic shut-down valves, and emergency response systems Introduction to design of redundancy and the role of spare capacity and to be able to put this knowledge to effect to contribute to detailed field design. An understanding of obsolescence management in subsea control systems Target Audience This course is intended for Offshore and Onshore Subsea Production Control Systems; Engineers, Technicians, Supervisors, Operators; Graduates; Apprentices; transfers from other industries, and existing staff with a limited exposure to Production Control and a need to understand the more technical aspects of the system. Companies not directly involved in the day-to-day support of the industry, but occasionally involved in supplying and supporting operators; manufacturers and suppliers of Oil and Gas equipment and services may also find this a useful course to understand how their equipment and technical expertise is integrated into the Offshore system. Trainer For most of his working life, your expert course leader has been in a role that has enabled him to pass on skills and knowledge to others. A full-time role in Training and Development came about in 1996 with the offer to take up a full-time teaching post at Aberdeen College. In 1998, he was recruited by Kvaerner Oilfield Products, an Oil & Gas industry company, specialising in Subsea Control Systems, to develop and implement a Training & Competence program acceptable for its staff of over 600 and their client companies - a challenge he could not resist. In 2003, he broadened his horizons and became an independent Training & Development consultant. Building a reputation for delivering training and development to the Oil & Gas industry to the highest standards, he later joined Jee Ltd, a leading subsea engineering and training company based in Aberdeen. He was tasked with a wide portfolio of training, coaching & mentoring to achieve high levels of competence for the client's staff and customers. He is also a Science and Engineering Ambassador (Scotland), promoting the need for engineers and technicians for Scotland's industries, a frequent consultant to the European Economic & Social Committee for standardising Vocational Skills training and competence throughout the EU. He holds memberships in the Society of Operations Engineers, Chartered Institute of Personnel & Development and Society of Underwater Technologies. 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

EnergyEdge offers a comprehensive course on geomechanics at well and field scale. Expand your knowledge and skills in this domain.