1637 Courses delivered Online

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

Scrum Master Exam Prep This workshop prepares you for the Scrum.org Professional Scrum Master (PSM)™ I certification. A voucher for the exam and the access information you will need to take the exam will be provided to you via email after you have completed the course. NOTE: If you have participated in any of IIL's other Scrum workshops, you can bypass this program and focus on reading/studying the Scrum Guide and taking practice exams from Scrum.org. A Scrum Master helps project teams properly use the Scrum framework, increasing the likelihood of the project's overall success. Scrum Masters understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. Scrum Masters act as 'servant leaders', helping the rest of the Scrum Team work together and learn the Scrum framework. Scrum Masters also protect the team from both internal and external distractions. The Professional Scrum Master™ I (PSM I) certificate is a Scrum.org credential that enables successful candidates to demonstrate a fundamental level of Scrum mastery. PSM I credential holders will grasp Scrum as described inThe Scrum Guide™1 and recognize how those concepts can be applied. They will also share a consistent terminology and approach to Scrum with other certified professionals. What you will Learn You'll learn how to: Successfully prepare for the Scrum.org PSM I exam Comprehend the Agile Manifesto and mindset Explain the fundamental principles of Scrum, including events, artifacts, and roles Guide the Scrum team in their responsibilities Define Ready and Done Write requirements in the form of user stories Estimate using planning poker and prioritize using MoSCoW Facilitate the team through the 5 Sprint events Fulfill the role of Scrum Master in a Scrum project Create Information Radiators to enable transparency Define the structure of the retrospective Getting Started Introductions Workshop orientation Exam prep preview Foundation Concepts Agile History, Values, and Mindset Introduction to Scrum Scrum events Scrum artifacts Scrum Roles and Responsibilities Product Owner responsibilities Scrum Master responsibilities The Team responsibilities Cross-functional teams Building effective teams The Product Backlog and User Stories The Product Backlog User Stories Definition of Done Backlog grooming Estimating User Stories Story points, planning poker Prioritizing User Stories The Sprint Team capacity and velocity The Sprint Planning Meeting The Sprint Backlog The Sprint Learning to self-manage, self-organize, self-improve Sprint Review and Retrospective Project Progress and Completion The Daily Scrum The Task Board and The Burndown Chart Information Radiators Closing a Scrum Project Summary and Next Steps Review of course goals, objectives, and content Exam prep next steps

The Negative Thought Pattern Interrupt does exactly what it says Course curriculum 1 Welcome to the course! Welcome from Simon Lee Maryan, Course Creator What is the Somato-Limbic Metacognitive Process (SLM Process)? CPD Accreditation About the Course Creator How to Navigate this course What Are Your Initial Outcomes SLM Process Course Learning Outcomes Individual Change Readiness Assessment 2 Part 1 - Theory Part 1 - Introduction Video 3 Bonus Module 1: Psychological and Physiological Effects of Stress Lesson BM1.1: Stress and Work Lesson BM1.2: Types of Stress and Causes Lesson BM1.3: Physical Effects of Stress - Musculoskeletal Lesson BM1.4: Physical Effects of Stress - Respiratory Lesson BM 1.5: Physical Effects of Stress - Cardiovascular Lesson BM 1.6: Physical Effects of Stress - Endocrine Lesson BM 1.7: Physical Effects of Stress - Gastrointestinal Lesson BM 1.8: Physical Effects of Stress - Nervous Lesson BM1.9 - Psychological Effects of Stress 4 Bonus Module 2: Psychological and Physiological Effects of Fatigue Lesson BM2.1: Definition of Fatigue Lesson BM2.2: Types of fatigue and Causes Lesson BM2.3: Psychological Effects of Fatigue Lesson BM2.4: Methods to Manage Stress and Fatigue 5 Module 1: Foundation Theory Lesson 1.1: The Principles for SuccessFREE PREVIEW Lesson 1.2: Creating Outcomes with Positive Effect Lesson 1.3: Setting an Intervention Up For Success Lesson 1.4: Cause and Effect Lesson 1.5: The Mind-Body Connection Lesson 1.6: Neurological Connections Lesson 1.7: The Presuppositions for Life Module 1 Assessment 6 Module 2: Communication Principles and Skills Module 2: Introduction Video Lesson 2.1: A Communication Model Lesson 2.2: Observing Body Language and Non-Verbal Communication Lesson 2.2.1: Behavioural Profiling Aide Memoire Lesson 2.2.2: Basic Behavioural Profiling Exercises Lesson 2.3: Rapport - What is it, how do we build and maintain it? Lesson 2.4: Our Senses and Language Lesson 2.4.1: Exercise - Sensory Preference Lesson 2.4.1 - Exercise Worksheet Lesson 2.5: Predicate Language Module 2 Assessment 7 Module 3: Eye Movement Patterns Module 3 Introduction Video Lesson 3.1: Eye Movement Pattern Cues Lesson 3.2: How to Elicit Eye Patterns Lesson 3.3: Eye Tracking Exercise Lesson 3.3.1 Eye Tracking Exercise Sheet - PDF Lesson 3.4: Synesthesia Module 3 Assessment 8 Module 4: Submodalities Module 4 Introduction Video Lesson 4.1: Modalities and Submodalities Lesson 4.2: Possible uses for Changing Submodalities and How to Elicit Them Lesson 4.3: Using Submodalities for Change Lesson 4.3.1: Exercise - Submodality Change Video: How to use the Submodality Checklist Lesson 4.3.2: Submodality Checklist PDF Module 4 Assessment 9 Module 5: The Limbic System, Memory and Brain Activity Module 5: Introduction Video Lesson 5.1: How the Limbic System Affects Memory Lesson 5.1.1: Memory Graphics - Downloads Lesson 5.2: Perceptual Blindness and Conscious Overload Lesson 5.3: Brain Activity and Brain Waves Lesson 5.4: Circadian Rhythm Lesson 5.4.1: Exercise Worksheet - Sleep Diary Lesson 5.5:Ultradian Rhythm Module 5 Assessment 10 Module 6: Influences on Your State of Mind, Emotions, Beliefs and Decisions Module 6: Introduction Video Lesson 6.1: Influences on Your State of Mind Lesson 6.2: Emotional Response vs Decisions Lesson 6.3: Beliefs Lesson 6.4: Identifying Limiting Beliefs Lesson 6.4.1: Exercise Worksheet - Identify Your Limiting Beliefs Lesson 6.5: Limiting Beliefs - Framing Principle, Frame of Reference Lesson 6.5.1: Reframing, Schemas, Meaning Lesson 6.5.2 - Exercise Worksheet - Identify Your Frames of Reference, Schemas and Meaning Lesson 6.6: Values Lesson 6.6.1: Values Exercise Video Explanation Lesson 6.6.1 - Values Exercise WorkSheet Lesson 6.6.2: Beliefs Behind Your Values Video Explanation Lesson 6.6.2 - Exercise Worksheet 2 - Beliefs Behind Your Values Module 6 Assessment 11 Module 7:The Logical Levels Model for Personal Change Module 7: Introduction Video Lesson 7.1: An Introduction to the Logical Levels Model Lesson 7.2: Logical Levels - Environment Lesson 7.3: The logical Levels - Behaviour Lesson 7.4: The Logical Levels - Capability Lesson 7.5: The Logical Levels Model - Beliefs and Values Lesson 7.6: The Logical Levels Model - Identity Lesson 7.7: The Logical Levels Model - Purpose Video Explanation of Personal Exploration Exercise Lesson 7.8: Personal Exploration Exercise - PDF Module 7 Assessment 12 Module 8: Behavioural Change Module 8: Introduction Video Lesson 8.1: The Behavioural Change Learning Cycle Behavioural Change Learning Cycle - Video Explanation Behavioural Change Learning Cycle PDF Lesson 8.2: The Intentional Change Model Lesson 8.2.1: Reflective Exercise - Who Helped Me and Who Tried Lesson 8.3: The Intentional Change Model Cont. Module 8 Assessment 13 Part 2 - Techniques Part 2 - Techniques Introduction 14 Module 9: Negative Thought Pattern Interrupt Lesson 9.1: Negative Thought Pattern Interrupt - What Is It? Lesson 9.2: NTPI - The Process Overview Lesson 9.3: NTPI - The Process in Detail Lesson 9.4: NTPI - Live Video Demo with Client Lesson 9.5: NTPI Assignment 15 Module 10: The Whole Brain State Lesson 10.1: The Whole Brain State (WBS) - Description Lesson 10.2: WBS - The Process Lesson 10.3: The Whole Brain State - Live Video Demo with Client Lesson 10.4: Whole Brain State Assignment 16 Module 11: Anchoring Lesson 11.1: Brief History of Anchoring Lesson 11.2: Uses of Anchoring Lesson 11.3: 5 Keys to Anchoring - ITURN Lesson 11.4: The Anchoring Process Lesson 11.4.1: Icarus Anchoring Process - PDF Download Lesson 11.5: Anchoring - Live Video Demo with Client Lesson 11.6: Anchoring Assignment Lesson 11.7: How to Bring all Three Techniques Together 17 Module 12: Eye Patterning and Re-imprinting Lesson 12.1: What Is Eye Patterning and Re-Imprinting Lesson 12.2: What Are Memories & Imprints & How Are They Created? Lesson 12.3: Brick Walls and Feeling Stuck Lesson 12.4: Eye Patterning and Re-imprinting Process Lesson 12.5: EPRI - Live Video Demo with Client Lesson 12.6: Eye Patterning and Re-imprinting Assignment 18 Module 13: Swish Pattern Lesson 13.1: The Swish Pattern Lesson 13.2: Keys To Successful SWISH Patterns Lesson 13.3: SWISH Pattern Guide Script 19 Module 14: Purpose Lesson 14.1: Purpose Lesson 14.2: Your Purpose Statement - Exercise Worksheet 20 Module 15: Case Studies Assignment Lesson 15.1 - Case Study Assignment Lesson 15.2: Sample Case Studies and Informed Consent Form 21 Bonus Module 3: Personal Needs Lesson B3.1: How are Your Personal Needs Being Fulfilled? Lesson B3.1 - Exercise Worksheet - Hierarchy of Needs 22 Next steps More resources for you Before you go...Please leave us your thoughts on your experience of this course. This is invaluable to us as it means you are helping us to continuously improve our courses as we learn from you.

Introducing the Dating Profile Helper Package: Crafting an Authentic and Irresistible Online Dating Presence Are you looking to enhance your online dating experience and attract meaningful connections? Miss Date Doctor’s Dating Profile Helper Package offers you expert guidance and support to create a captivating and genuine dating profile that reflects your true self and increases your chances of finding a compatible partner. In today’s digital age, your online dating profile serves as your first impression. Our experienced dating experts are dedicated to helping you stand out in a positive way, guiding you through the process of crafting a profile that effectively showcases your personality, interests, and aspirations. Here’s how the Dating Profile Helper Package can support you: Personalized Consultation: Our dating experts will conduct a personalized consultation to understand your personality, values, and dating goals. Profile Optimization: We’ll assist you in optimizing your profile text, ensuring it effectively communicates who you are and what you’re looking for. Photo Selection: We’ll provide guidance on selecting photos that capture your authentic self and present you in the best light. Creating a Compelling Bio: We’ll help you write a compelling and engaging bio that intrigues potential matches and sparks conversations. Highlighting Your Unique Qualities: Our experts will assist in showcasing your unique qualities, hobbies, and interests that make you stand out. Navigating Online Etiquette: We’ll provide guidance on how to interact with matches, initiate conversations, and maintain engaging communication. Building Confidence: The Dating Profile Helper Package can boost your confidence by providing expert support in creating a profile that accurately represents you. Attracting Compatible Matches: We’ll work towards attracting matches who resonate with your values and are looking for a genuine connection. The Dating Profile Helper Package at Miss Date Doctor is designed to empower you to present your authentic self in the online dating world. Our experienced dating experts provide personalized guidance and practical tips to enhance your online presence and increase your chances of finding meaningful connections. Invest in your dating success and take the first step towards crafting an appealing online dating profile with the Dating Profile Helper Package. Embrace the opportunity to authentically showcase who you are and attract matches that align with your values and aspirations. Let our experts guide you towards a more rewarding and fulfilling online dating experience. Get 6 new photos as a bonus 3 sessions x 1 hour https://relationshipsmdd.com/product/dating-profile-helper/

The most imperative components of marriage are respect, communication, understanding, intimacy, core values and matched expectations. When any of these components become problematic we have a marriage that is in trouble. This package helps to restore a rocky marriage that is in danger of imploding. You will be assigned to a ICF/BACP qualified relationship coach to help you and your partner learn relationship skills over the course of 8 weeks The Gottman Method Emotionally focused therapy Relationship and Marriage counselling Improving communication skills Conflict Management Introspection tests for each spouse Cognitive behavioural therapy Relationship skills training Mediation Cognitive training Building trust and transparency Rebuilding the marriage foundation Eliminating family issues Examining spouses values, needs and requirements Unlearning negative marriage habits Concession Calls Couples Therapy Exercises 8 Week marriage care package for marriage breakdown WAS £1100 SPECIAL OFFER https://relationshipsmdd.com/product/marriage-relationship-counselling-service-package/

The Negative Thought Pattern Interrupt does exactly what it says Course curriculum Welcome to the course! Welcome from Simon Lee Maryan, Course Creator What is the Somato-Limbic Metacognitive Process (SLM Process)? CPD Accreditation About the Course Creator How to Navigate this course What Are Your Initial Outcomes SLM Process Course Learning Outcomes Individual Change Readiness Assessment 2 Part 1 - Theory Part 1 - Introduction Video 3 Bonus Module 1: Psychological and Physiological Effects of Stress Lesson BM1.1: Stress and Work Lesson BM1.2: Types of Stress and Causes Lesson BM1.3: Physical Effects of Stress - Musculoskeletal Lesson BM1.4: Physical Effects of Stress - Respiratory Lesson BM 1.5: Physical Effects of Stress - Cardiovascular Lesson BM 1.6: Physical Effects of Stress - Endocrine Lesson BM 1.7: Physical Effects of Stress - Gastrointestinal Lesson BM 1.8: Physical Effects of Stress - Nervous Lesson BM1.9 - Psychological Effects of Stress 4 Bonus Module 2: Psychological and Physiological Effects of Fatigue Lesson BM2.1: Definition of Fatigue Lesson BM2.2: Types of fatigue and Causes Lesson BM2.3: Psychological Effects of Fatigue Lesson BM2.4: Methods to Manage Stress and Fatigue 5 Module 1: Foundation Theory Lesson 1.1: The Principles for Success Lesson 1.2: Creating Outcomes with Positive Effect Lesson 1.3: Setting a Coaching Intervention Up For Success Lesson 1.4: Cause and Effect Lesson 1.5: The Mind-Body Connection Lesson 1.6: Neurological Connections Lesson 1.7: The Presuppositions for Life Module 1 Assessment 6 Module 2: Communication Principles and Skills Module 2: Introduction Video Lesson 2.1: A Communication Model Lesson 2.2: Observing Body Language and Non-Verbal Communication Lesson 2.2.1: Behavioural Profiling Aide Memoire Lesson 2.2.2: Basic Behavioural Profiling Exercises Lesson 2.3: Rapport - What is it, how do we build and maintain it? Lesson 2.4: Our Senses and Language Lesson 2.4.1: Exercise - Sensory Preference Lesson 2.4.1 - Exercise Worksheet Lesson 2.5: Predicate Language Module 2 Assessment 7 Module 3: Eye Movement Patterns Module 3 Introduction Video Lesson 3.1: Eye Movement Pattern Cues Lesson 3.2: How to Elicit Eye Patterns Lesson 3.3: Eye Tracking Exercise Lesson 3.3.1 Eye Tracking Exercise Sheet - PDF Lesson 3.4: Synesthesia Module 3 Assessment 8 Module 4: Submodalities Module 4 Introduction Video Lesson 4.1: Modalities and Submodalities Lesson 4.2: Possible uses for Changing Submodalities and How to Elicit Them Lesson 4.3: Using Submodalities for Change Lesson 4.3.1: Exercise - Submodality Change Video: How to use the Submodality Checklist Lesson 4.3.2: Submodality Checklist PDF Module 4 Assessment 9 Module 5: The Limbic System, Memory and Brain Activity Module 5: Introduction Video Lesson 5.1: How the Limbic System Affects Memory Lesson 5.1.1: Memory Graphics - Downloads Lesson 5.2: Perceptual Blindness and Conscious Overload Lesson 5.3: Brain Activity and Brain Waves Lesson 5.4: Circadian Rhythm Lesson 5.4.1: Exercise Worksheet - Sleep Diary Lesson 5.5:Ultradian Rhythm Module 5 Assessment 10 Module 6: Influences on Your State of Mind, Emotions, Beliefs and Decisions Module 6: Introduction Video Lesson 6.1: Influences on Your State of Mind Lesson 6.2: Emotional Response vs Decisions Lesson 6.3: Beliefs Lesson 6.4: Identifying Limiting Beliefs Lesson 6.4.1: Exercise Worksheet - Identify Your Limiting Beliefs Lesson 6.5: Limiting Beliefs - Framing Principle, Frame of Reference Lesson 6.5.1: Reframing, Schemas, Meaning Lesson 6.5.2 - Exercise Worksheet - Identify Your Frames of Reference, Schemas and Meaning Lesson 6.6: Values Lesson 6.6.1: Values Exercise Video Explanation Lesson 6.6.1 - Values Exercise WorkSheet Lesson 6.6.2: Beliefs Behind Your Values Video Explanation Lesson 6.6.2 - Exercise Worksheet 2 - Beliefs Behind Your Values Module 6 Assessment 11 Module 7:The Logical Levels Model for Personal Change Module 7: Introduction Video Lesson 7.1: An Introduction to the Logical Levels Model Lesson 7.2: Logical Levels - Environment Lesson 7.3: The logical Levels - Behaviour Lesson 7.4: The Logical Levels - Capability Lesson 7.5: The Logical Levels Model - Beliefs and Values Lesson 7.6: The Logical Levels Model - Identity Lesson 7.7: The Logical Levels Model - Purpose Video Explanation of Personal Exploration Exercise Lesson 7.8: Personal Exploration Exercise - PDF Module 7 Assessment 12 Module 8: Behavioural Change Module 8: Introduction Video Lesson 8.1: The Behavioural Change Learning Cycle Behavioural Change Learning Cycle - Video Explanation Behavioural Change Learning Cycle PDF Lesson 8.2: The Intentional Change Model Lesson 8.2.1: Reflective Exercise - Who Helped Me and Who Tried Lesson 8.3: The Intentional Change Model Cont. Module 8 Assessment 13 Part 2 - Techniques Part 2 - Techniques Introduction 14 Module 9: Negative Thought Pattern Interrupt Lesson 9.1: Negative Thought Pattern Interrupt - What Is It? Lesson 9.2: NTPI - The Process Overview Lesson 9.3: NTPI - The Process in Detail Lesson 9.4: NTPI - Live Video Demo with Client Lesson 9.5: NTPI Assignment 15 Module 10: The Whole Brain State Lesson 10.1: The Whole Brain State (WBS) - Description Lesson 10.2: WBS - The Process Lesson 10.3: The Whole Brain State - Live Video Demo with Client Lesson 10.4: Whole Brain State Assignment 16 Module 11: Anchoring Lesson 11.1: Brief History of Anchoring Lesson 11.2: Uses of Anchoring Lesson 11.3: 5 Keys to Anchoring - ITURN Lesson 11.4: The Anchoring Process Lesson 11.4.1: Icarus Anchoring Process - PDF Download Lesson 11.5: Anchoring - Live Video Demo with Client Lesson 11.6: Anchoring Assignment Lesson 11.7: How to Bring all Three Techniques Together 17 Bonus Module 3: Personal Needs Lesson B3.1: How are Your Personal Needs Being Fulfilled? Lesson B3.2 - Exercise Worksheet - Hierarchy of Needs 18 Module 12: Purpose Lesson 12.1: Purpose Lesson 12.2: Your Purpose Statement - Exercise Worksheet 19 Module 13: Case Studies Assignment Lesson 13.1 - Case Study Assignment Sample Case Studies and Informed Consent Form 20 Next steps Congratulations, you're Almost Done!! Here's What's Next Before you go...Please leave us your thoughts on your experience of this course.

Learn how to create easy to read accessible person centred profiles for children of all ages and young adults. Course Category Person Centred Planning Inclusion Description Person centred planning is a way of expressing a set of inclusive values through a unique range of tools and techniques. The most easily used approach is called creating a one page plan or a person centred profile. All person centred planning tools and processes are driven by a commitment to achieve inclusive outcomes for the person whose plan it is, and the young people involved are always present throughout their planning session. The focus of all person centred approaches is the whole person irrespective of the label they carry. Two people, a process facilitator and a graphic facilitator, typically facilitate plans. The role of the support service staff in this work is as a facilitator not as an expert participant, problem solver, assessor or provider of consultation. One Page Plans are especially effective tools in planning and supporting children and young people with additional support needs and for through-care planning for young people who are looked after or accommodated. Over time person centred working will reveal areas of unmet need in current provision and thereby inform the ongoing strategic planning within any particular region. Testimonials Be the first… Learning Objectives To Explore the values underpinning person centred working To show how One Page Plans naturally capture young people’s strengths and capacities A demonstration of how person centred planning encourages meaningful consultation and participation with young people (particularly for those who cannot make their views known in typical ways To show how Person Centred Planning leads to the building of stronger parent/school partnerships To indicate how person centred planning can promote multi-agency teamwork and shared responsibilities To increase understanding the how of process and graphic facilitation in person centred work. Who Is It For ? Teachers and School Staff Education Services Social Care Staff Health Professionals Transition Coordinators Family Support Workers Link Workers Course Content An introduction to the person centred planning tool of creating a One Page Plan We would stress that this is an introductory day and that participants will be expected to make plans for their own follow up and further practice of the tools covered in the course of the day. If you liked this course you may well like: PERSON CENTRED REVIEWS

Duration 1 Days 6 CPD hours This course is intended for Individuals taking this course may be new managers and individual contributors seeking to develop or enhance leadership abilities with practical skills. Overview Transition from an individual contributor to a leader. Develop an effective team. Lead a team effectively. Increase your effectiveness in leading different types of teams. Develop a team mission, values statement, and vision to achieve business results. You have developed skills to be successful in your field. In this course, you will learn the practical skills you need to be an effective leader in your organization. Leadership enhances the skills employees at all levels need to be truly successful. When you learn practical leadership skills, you\'ll have the ability to motivate, coach, communicate with, and teach employees in such a way that they are more effective in their jobs and, as a result, you become more effective in your job. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. Prerequisites Students should possess experience working in an organization as an individual contributor or possibly as a manager. 1. Transitioning from Individual Contributor to Leader Define Leadership Identify Your Leadership Style Redefine Your Role 2. Developing an Effective Team Build an Effective Team Coach for Performance Empower Your Team Members 3. Leading a Team Effectively Influence for Results Lead Your Team Through Organizational Change 4. Leading Different Types of Teams Work with Different Types of Teams Overcome Communication Barriers Overcome Issues Among Team Members 5. Aligning Your Strategy for Business Results Establish a Team Mission Determine Team Core Values Write a Team Vision Statement

About this Virtual Instructor Led Training (VILT)  This 2-half-day Virtual Instructor Led Training (VILT) course will discuss the chemical aspects of the water-steam cycle in a power plant. The VILT course will examine the different types of chemicals used in boilers, potential issues in a water-steam cycle as well as aspects of monitoring and specifications regarding target values and alarm levels. Participants will also be equipped on what to do or key action steps to take in the event of chemistry-related incidents. This course is delivered in partnership with ENGIE Laborelec. Training Objectives The VILT course will cover the following: Detailed aspects of chemistry in a water steam cycle, including types of chemicals used in boilers depending on the treatment and type of boiler Potential issues in a water-steam cycle such as corrosion and deposition Monitoring & analytical programmes and knowledge of specifications for the water steam cycle (normal values targets - alarm levels) Chemistry aspects during transition periods: start-up, shutdown and preservation Actions to be taken in the event of an alarm Examples of incidents or deviations compared to normal chemistry Target Audience The VILT course is intended for: Power plant chemists Plant operation or maintenance engineers Consultants and technical project managers Boiler engineers Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 2 half-day sessions comprising 4 hours per day, with 2 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Course Duration: 2 half-day sessions, 4 hours per session (8 hours in total). Trainer Your expert course leader is a chemistry consultant in the energy sector. He works with operators of power plants and industrial facilities. He is active in water-steam cycle chemistry, where he provides support to increase chemistry maturity through audits, trainings or development of key performance indicators. His role also includes operational assistance in the field of chemical cleaning and troubleshooting. More recently, he expanded his field of competence towards electrical storage. In this regard, he specializes in electrochemistry and is in charge of different tests on batteries and their components within the ENGIE Batteries Lab. 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

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