1551 Design courses in London

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 This 5 full-day course will focus on geological fundamentals: how different basin types differ in subsidence mechanisms, basin cycles, heat flow through time, depositional systems, structural styles and their type of petroleum systems. This will allow participants to make realistic interpretations in new areas; interpretations that are consistent with the specific basin type and to be expected depositional systems and structural styles. In addition, through simple paper-based exercises, the course will provide background and understanding of how some of the typical PBE products are made: creaming curves, Field-size plots and Yet-to-find. Finally, the essentials of commercial assessments will be covered. Training Objectives To provide participants with a sound understanding how, and under which conditions different basin types develop, and what the impact of their development is on the typical petroleum systems of these different basin types. To teach evaluation techniques that assist in the regional understanding and illustration of sedimentary basins and their development. While some of these techniques can be done using computers, in the course these will be done 'by hand' for maximum understanding. Target Audience This course is designed in the first place for geoscientists working in exploration and their direct supervisors. The course is also very instructive for specialist staff working closely with exploration staff such as (bio)stratigraphers, geochemists, basin modelers, structural geologists, geophysicists, reservoir engineers and petrophysicists. Course Level Intermediate Training Methods Each topic is introduced by a lecture, and leaning is re-enforced by practical exercises (on paper). There is ample time for discussions of general issues and any specific questions participants may have. For several exercises participants will be invited to do exercises on a basin of their choice, which will make the course more impactful for the participants. Participants will be provided with the following pre-read material: Concepts of Conventional Petroleum Systems. De Jager, J. (2020). Invited contribution for Regional Geology and Tectonics Volume 1: Global Concepts, Techniques and Methodology (eds: Adam, J., Chiarelly, D. & Scarselli, N. Play-Based Exploration of the petroleum potential of the Tremp-Graus, Ainsa and eastern Jaca Sub-basins in the southern De Jager, J & van Winden, M. (2020). invited contribution for Digital Learning - Multi-scale analysis of depositional systems and their subsurface workflows (eds: Grötsch, J. & Pöppelreiter, M.), EAGE. Trainer Your expert course leader has a PhD in Geology from the University of Utrecht. He worked for 31 years (1979 -2010) with Shell as an exploration geologist in a variety of functions across the globe. As Principle Technical Expert, he was responsible for ensuring that Risk & Volume assessments were carried out consistently and correctly in all of Shell's exploration units. In this capacity, he led and participated in countless prospect review sessions and developed and conducted a successful in-house course on Risks & Volume assessment. As manager of the Exploration Excellence Team, he performed in depth analysis of basins and plays and provided advice on exploration opportunities to senior management. Together with his team, he visited most of Shell's exploration offices, working hands-on with Shell's local exploration teams to generate new play and prospect ideas and to suggest evaluation techniques and technologies to apply. In 2010, he was appointed as extraordinary professor Regional and Petroleum Geology at the VU university of Amsterdam and in 2012 also at the University of Utrecht. He was visiting professor at the University of Malaya (Malaysia). Through his own consultancy, as of 2010, he provides advice on exploration activities to several companies and is regularly invited to carry out technical reviews. Activities cover all continents and include Portfolio Reviews, Prospect assessment, Play-based Exploration, and Geothermal activities. He conducts courses on several topics including Risk & Volume Assessment, Prospect Maturation, Basin Analysis, Play-based Exploration, Trap & Seal Analysis, Petroleum Geology for Non-geologists. Some of his recent publications include: De Jager, J. & van Winden, M. (2020): Play-Based Exploration of the petroleum potential of the Tremp-Graus, Aínsa and eastern Jaca Sub-basins in the southern Pyrenees. Invited contribution for Digital Geology, EAGE special publication (eds: Grötsch, J. & Pöppelreiter, M.) De Jager, J. (2020). Concepts of Conventional Petroleum Systems. Invited contribution for Regional Geology and Tectonics Volume 1: Global Concepts, Techniques and Methodology (eds: Adam, J., Chiarelly, D. & Scarselli, N.) De Jager, J. (2021): Handbook Risk & Volume Assessment. Self-published De Jager, J., Van Ojik, K & Smit, R. (2023 - in preparation): Geological Development of The Netherlands. In: Geology of The Netherlands (eds: Ten Veen, J., Vis, G-J., De Jager, J. @ Wong, T.) 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

The “ISO 42001:2023 Lead Implementer Course” is designed to provide participants with the knowledge and skills necessary to lead the implementation of an Artificial Intelligence Management System based on ISO 42001:2023. This comprehensive course covers the key principles, requirements, and best practices for establishing and maintaining an effective Artificial Intelligence management system. Participants will learn how to develop, implement, and manage processes that comply with the ISO 42001 standard.

This three-day investigation and interviewing skills course is an advanced course designed specifically for specialist investigators or those who undertake investigations on a full-time basis.

Mother's Day flower basket arranging workshop. A gift for your mum that you've made yourself with love!

This half-day Suicide First Aid Lite training course gives learners the knowledge and tools to understand that suicide is one of the most preventable deaths and some basic skills can help someone with thoughts of suicide stay safe from their thoughts and stay alive.

The "Foundations of Immunisation and Vaccines for Non-Registered Practitioners" course is fully compliant with the National Minimum Standards and Core Curriculum for Immunisation Training and is designed to equip non-registered healthcare professionals with a solid understanding of immunisation concepts, vaccine administration, and the importance of vaccination in public health.

A course designed for occupational health nurses. Updating on latest immunisation advice. giving a complete understanding of vaccinations, agendas, schedules, vaccine ingredients, contraindications and side effects.

This is the follow on course for those who want complete knowledge of all Beauty Therapy. Students will need to have completed their NVQ Level 2 in order to progress to this level. This is the perfect course for being able to offer any treatment you require. You can choose from 25 evening or a 'Fast Track' of ONLY 10 Days plus coursework, case studies and homework. This course is accredited by the VTCT and recognised by the HABIA- Hair and Beauty regulated government standards. Although our Tutors have been teaching NVQ levels at many Colleges for over 15 years now, we started the 'Academy' so that the teaching revolved around the student and not around making targets, politics and college protocols! Although we set dates, our students have an opportunity to pick and choose and to the best of our ability, we will structure special dates around them. This is what makes us completely unique and probably why we are the most features teaching school on a multitude of TV Channels!! There are many Colleges and Schools that can teach you but whatever you do, even if you do not choose us to learn with us, please make sure the school has 100% pass rate as some of the biggest private schools only have between 50-75% pass rates!! You will need to BOOK SOON TO AVOID DISAPPOINTMENT!! Here at 'The Angel Academy of Teaching and Training', we have 2 different routes of NVQ Level 3: Here are the two NVQ Level 3 options: NVQ Level 3 Massage Route: Swedish Body Massage This unit will teach a variety of massage moves which can be used effectively on paying clients to help them maintain good health. Performed on massage couches, each student will receive guidance on how to effectively use massage moves on different parts of the body. Instruction will be given in order for a student to effectively perform a 60 minute massage routine. The Course will teach the following: Client Consultation Contra-indications and contra-actions Health and Safety in the workplace Related Anatomy and Physiology Massage moves to include, effleurage, petrissage, percussion and tapotement Correct application of oil and correct pressure application After-care Indian Head Massage Indian Head Massage traditionally was an ancient healing process known to relieve headaches, stress and tension. Hair was strengthened and conditioned too with the use of certain oils. Today, the fashionable hair salons provide the use of Indian Head Massage as a means of relaxation, and it ' s popularity is increasing rapidly. On-Site practitioners now visit offices to provide treatments, bringing Indian Head Massage into our working day. In fact, Indian Head Massage is more than a massage, it is an overall healing therapy which involves chakra, colour and crystal therapy. Essential oils can be added to the scalp by a trained aromatherapist to induce a real state of well-being. Benefits of becoming certified at Indian Head Massage: Take Indian Head Massage to the employees in the large corporations Incorporate it as an extra into existing treatments to give you 'the edge' Many customers prefer to keep their clothes on Very little workspace is needed. Just a chair! Pre-Blended Aromatherapy This unit is designed to give you an insight into aromatherapy oils. Enjoy discovering the therapeutic and relaxing effects of acupressure massage using pre-blended essentials oils The course will teach the following: The benefits of using pre-blended oils Shiatsu massage Pressure points Oils and their benefits Health and Safety Related Anatomy and Physiology Client Consultation and Contra-indications After-Care Hot Stone Treatment Hot Stone Massage is an ancient treatment which involves both the Placement Of Stones and the Application and Massage using them. They are a brilliant aid for the Therapist to work deeply on a client without any trauma to their hands. One stone massage stroke is equivalent to 10 normal massage strokes. The physical and spiritual well-being induced by the stones is amazing. The treatment is a lovely one to give that brings immediate benefits. Aches and Pains Swollen Muscle and Joint Pains Aids Blood Circulation Stimulates the Lymphatic system to eliminate waste It can help relieve pain Improve Bodily Functions Helps to maintain health and well-being Your extra unit is: Facial Electrical Treatments This course is becoming more popular than ever before due to the amazing electrical equipment now available at reasonable prices for salons and therapist. Microdermabrasion Micro-Current Galvanic- Iontopheresis and Desincrustation Faradic- Electrical Muscle Stimulation Micro-Lance Direct and In-direct High Frequency Realated Anatomy Health and Safety Client Consultation and Contra-indications Related Anatomy & Physiology To enable students to identify all bodily systems relating to Anatomy and Physiology, allowing them to apply their knowledge and understanding into their therapeutic working life. The course will teach the following: Cells and Tissues The Skeletal System The Integumentary System The Blood Lymph Systems The Muscular System Neurology The Digestive and Excretory Systems The Respiratory and Olfactory Systems The Endocrine and Reproductive Systems Arthrology Health and Safety Issues Hygiene in the Workplace NVQ Level 3 General Route: Body Electrical Treatments This course is becoming more popular than ever before due to the amazing electrical equipment now available at reasonable prices for salons and therapist. An Electrical body treatment can postpone early signs of ageing, improve the appearance of the skin and erase minor sun damage, scarring, pigmentation, cellulite and 'Orange Peel' creping. The course will teach the following: Microdermabrasion Micro-Current Galvanic- Iontopheresis and Desincrustation Faradic- Electrical Muscle Stimulation Direct and In-direct High Frequency Related Anatomy & Physiology Health and Safety Client Consultation and Contra-indications Facial Electrical Treatments This course is becoming more popular than ever before due to the amazing electrical equipment now available at reasonable prices for salons and therapist. An Electrical facial treatment can postpone early signs of ageing, improve the appearance of the skin and erase minor sun damage, scarring and pigmentation. The course will teach the following: Microdermabrasion Micro-Current Galvanic- Iontopheresis and Desincrustation Faradic- Electrical Muscle Stimulation Micro-Lance Direct and In-direct High Frequency Related Anatomy & Physiology Health and Safety Client Consultation and Contra-indications Swedish Body Massage This unit will teach a variety of massage moves which can be used effectively on paying clients to help them maintain good health. Performed on massage couches, each student will receive guidance on how to effectively use massage moves on different parts of the body. Instruction will be given in order for a student to effectively perform a 60 minute massage routine. The course will teach the following: Client Consultation Contra-indications and contra-actions Health and Safety in the workplace Related Anatomy and Physiology Massage moves to include, effleurage, petrissage, percussion and tapotement Correct application of oil and correct pressure application After-care Electrical Epilation Electrolysis gives you the skills necessary for a treatment to remove unwanted hair, using alternating current and blend techniques. Individual hairs can be treated effectively and safely. The course will teach the following: Be able to safely carry out an electrical epilation treatment on most areas of the body Understand how to correctly work to remove unwanted hair Related Anatomy and Physiology Preparation of the work area Health and Safety Client Consultation and Contra-indications After-Care Your extra unit is: Hot Stone Treatment Hot Stone Massage is an ancient treatment which involves both the Placement Of Stones and the Application and Massage using them. They are a brilliant aid for the Therapist to work deeply on a client without any trauma to their hands. One stone massage stroke is equivalent to 10 normal massage strokes. The physical and spiritual well-being induced by the stones is amazing. The treatment is a lovely one to give that brings immediate benefits. Aches and Pains Swollen Muscle and Joint Pains Aids Blood Circulation Stimulates the Lymphatic system to eliminate waste It can help relieve pain Improve Bodily Functions Helps to maintain health and well-being Related Anatomy & Physiology To enable students to identify all bodily systems relating to Anatomy and Physiology, allowing them to apply their knowledge and understanding into their therapeutic working life. The course will teach the following: Cells and Tissues The Skeletal System The Integumentary System The Blood Lymph Systems The Muscular System Neurology The Digestive and Excretory Systems The Respiratory and Olfactory Systems The Endocrine and Reproductive Systems Arthrology Health and Safety Issues Hygiene in the Workplace IF YOU REQUIRE ANY FURTHER INFORMATION CHECK OUT OUR PROSPECTUS, CALL US, ASK A QUESTION ONLINE AND PAY YOUR DEPOSIT NOW TO AVOID DISAPPOINTMENT! Dates and Costs Please see below our list of upcoming courses. Click on the course for further information, request a call or email regarding the course or book now! We are quite flexible in terms of course dates so if you would like to organise a course around your timetable, please contact us! Course Days Dates Cost NVQ Level 3 ** FAST TRACK OPTION ** 14 OPEN OPEN £2499 NVQ Level 3 ** FAST TRACK OPTION ** 14 2/10/2023 15/10/2023 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 12/11/2023 25/11/2023 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 8/12/2023 21/12/2023 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 1/01/2024 14/01/2024 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 15/02/2024 28/02/2024 £2499 NVQ Level 3 ** FAST TRACK OPTION 14 2/03/2024 16/03/2024 £2499

About this training course This 5-day intensive training course is designed to improve the skills of those involved in the financial and contractual auditing of upstream Oil & Gas Exploration and Production activities. The objective of this course is to enhance your understanding of the various audit principles and practices being applied in this industry today and to equip you with the knowledge and tools to deal with complex audit cases. The course concentrates on aspects of auditing unique to the E&P business. Training Objectives After the completion of this training course, participants will be able to: Apply a structured methodology for conducting oil industry internal, production sharing and joint venture audits Implement the benefits of a multi-discipline team audit approach Adopt a model of best practice for conducting audits Analyse, interpret and decide complex cases using the contracts and documents, the principles and auditor's judgement Target Audience This training course is suitable and will greatly benefit the following specific groups: Personnel with an Internal audit background who are totally new to the discipline of Joint Venture (JV) or Production Sharing Contract (PSC) audit Experienced audit practitioners who wish to update their auditing techniques Personnel from Finance or any discipline who intend to take part in internal or joint venture audits Personnel with a background in statutory audit in the accountancy profession who require an insight into the internal and joint venture audit areas Course Level Intermediate Training Methods 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 environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 25. Trainer Your expert course leader has more than 30 years of experience in the international oil and gas industry, covering all areas of Finance and Audit, including involvement in Commercial roles. During her 19 years with ENI she worked in Italy, Netherlands, Egypt and UK and was CFO for 2 major ENI subsidiaries. She has delivered training courses in Accounting, Audit, Economics and Commercial topics in many Countries. She has a Degree in Economics & Accounting and is a Certified Chartered Accountant. She is also a Chartered Auditor and an International Petroleum Negotiator. Outside of work, she is inspired by the beauty of nature and art, helping disadvantaged people, sports (football, golf) and her cat. Courses Delivered Internationally: E&P Accounting, Auditing in the Oil & Gas Industry Cost Control & Budgeting Introduction to the Oil & Gas Industry Petroleum Project Economics Contracts Strategy International O&G Exploitation Contracts 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