39230 Courses delivered Online

Highlights of the Course Course Type: Online Learning Duration: 5 Hours 16 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about dog training Understand the core competencies and principles of dog training Explore the various areas of dog training Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert dog trainer Dog Training Masterclass Course Master the skills you need to propel your career forward in dog training. This course will equip you with the essential knowledge and skillset that will make you a confident dog trainer and take your career to the next level. This comprehensive dog training masterclass course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this dog training masterclass course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective dog training practice and equip you with the essential skills, confidence and competence to assist you in the dog training industry. You'll gain a solid understanding of the core competencies required to drive a successful career in dog training. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for dog trainer or for people who are aspiring to specialise in dog training. Enrol in this dog training masterclass course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive dog training masterclass course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this dog training can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This dog training masterclass course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This dog training masterclass course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This dog training masterclass course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum The Proof Is In The Pudding Why Getting 2, 8 Week Old Parson Terrier Puppies Changed My Life And My Career 00:02:00 Here's What You'll Get From This Course Here's What You'll Get From This Course… 00:03:00 Feeding Time - Aggression and Stealing Food How To Communicate You're In Charge During Feeding Time 00:10:00 How To Stop Food Aggression And Stealing Food 00:07:00 This Dog Is A Professional At Stealing Food, You'll Be Amazed At What He Does! 00:04:00 The Right Way To Greet A Dog And Stop Jumping Up How You Greet Your Dog Says So Much More Than Hello - Here's Why 00:12:00 It's Not As Difficult As You May Think To Do And Makes The World Of Difference 00:05:00 Here's The Right Way For Guests To Enter Your Home And Stop Jumping Up 00:02:00 Here's The Right Way For Guests To Enter Your Home And Stop Jumping Up 00:02:00 Separation Anxiety How To Stop Dogs Barking, Chewing, Panting And Pacing When Left Alone 00:13:00 The Time To Get This Right Is When They Are A Puppy - Here's How To Do It 00:02:00 Can You Resolve Separation In Dogs Of All Ages? Yes! Here's How… 00:02:00 Dog Language - What They're Really Saying Is Your Dog Trying To Calm You Down?! Find Out Here… 00:09:00 This ONE Technique Works Like Magic With Numerous Unwanted Behaviours 00:10:00 The 3 F's For Dogs And Top Tips 00:10:00 The Answers To Commonly Asked Dog Questions You Are Likely To Be Asked Here's The Answers To Frequently Asked Dog Training Questions Numbers 1 and 2 00:09:00 Here's The Answers To Commonly Asked Dog Training Questions Numbers 3 and 4 00:09:00 Here's The Answers To Frequently Asked Dog Training Questions Numbers 5 and 6 00:06:00 Here's The Answers To Top Dog Training Questions 7 and 8 00:08:00 Here's The Answers To Commonly Asked Dog Training Questions 9 and 10 00:08:00 The Answers To 10 Common Puppy Training Questions You Are Likely To Be Asked Here's The Answers To Commonly Asked Puppy Training Questions Numbers 1 and 2 00:10:00 Here's The Answers To Popular Puppy Training Questions 3 and 4 00:05:00 Here's The Answers To Common Puppy Training Questions Numbers 5 and 6 00:07:00 Here's The Answers To Popular Puppy Training Questions Numbers 7 and 8 00:05:00 Here' The Answers To Common Puppy Training Questions Numbers 9 and 10 00:08:00 Dog Training Consultations With Clients Someone Has Said Yes To A Dog Training Consultation With You - Here's What To Do 00:08:00 Top Tips Of What To Include During Your Dog Training Consultation 00:14:00 **Bonus Video** A Demonstration Of A Real-Life Dog Training Consultation 00:21:00 Agreement Letters To Be Signed After The Consultation 00:06:00 How To Leave A Consultation On A High 00:02:00 Bonus Video Here's How To Integrate Dogs Who Do Not Like Travelling In Cars 00:14:00 Here's How To Best Work With Dogs Who Chase Joggers & Cyclists 00:07:00 How To Best Work With Dogs Who Are Fearful Of Children 00:05:00 Assessment Assessment - Dog Training Masterclass 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Traibcert Awareness online course is a comprehensive package that delves into every nook and corner you deserve to know about ISO 17025, including all the erstwhile requirements and pragmatic impeccability for compliance. The course is durably defined for novices who exhibit great affinity towards testing and calibration management and ISO standards.

Unlock the art of effective leadership with Supervisor Training. Delve into the fundamentals of supervision, understand your role, and cultivate essential skills for managing teams. Explore employee management, communication, conflict resolution, and cybersecurity, empowering you to excel as a proficient and confident supervisor. Learning Outcomes: Establish a strong foundation in supervisor training, understanding its key principles and significance. Define the role of a supervisor and develop insights into effective team leadership. Cultivate essential skills, including delegation, motivation, performance evaluation, and time management. Master recruitment and dismissal processes, ensuring the right fit for your team. Acquire techniques to manage and lead employees, promoting productivity and job satisfaction. Enhance communication skills to foster clear, open, and efficient dialogue with your team. Equip new supervisors with interactive training to ensure a seamless transition into their roles. Develop strategies for conflict management and resolution in a professional and collaborative manner. Why buy this Supervisor Training? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Supervisor Training there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Supervisor Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring Supervisors and Team Leaders. Professionals Transitioning into Supervisory Roles. Current Supervisors Seeking Skill Enhancement and Career Growth. Managers Interested in Enhancing Their Leadership Abilities. Prerequisites This Supervisor Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Supervisor/Team Leader - $50,000 to $90,000/year. Operations Manager - $70,000 to $120,000/year. Training and Development Specialist - $50,000 to $80,000/year. Human Resources Manager - $60,000 to $100,000/year. Leadership Coach - $60,000 to $100,000/year. Course Curriculum Module 01 - Fundamentals of Supervisor Training Fundamentals of Supervisor Training 00:25:00 Module 02 - Understanding the Role of Supervision Understanding the Role of Supervision 00:24:00 Module 03 - Essential Skills in Supervision Essential Skills in Supervision 00:29:00 Module 04 - Recruitment and Dismissal Recruitment and Dismissal 00:37:00 Module 05 - Employee Management Employee Management 00:22:00 Module 06 - Communication Skill Development Communication Skill Development 00:22:00 Module 07 - Interactive Training for New Supervisors Interactive Training for New Supervisor 00:31:00 Module 08 - Conflict Management Conflict Management 00:26:00 Module 09 - Cybersecurity for Employees Cybersecurity for Employees 00:27:00 Assignment Assignment - Supervisor Training 00:00:00

Addigy ACE course, Addigy certificate, Addigy Training

Face to face One to one.

Step into a world where learning differences are understood, not overlooked. The SEN Teaching Assistant and SENCO Training Diploma With Complete Career Guide Course is designed for those who want to make a meaningful impact in the lives of pupils with special educational needs. Whether you're supporting one child or guiding a classroom, this course gives you the tools to better understand learning challenges and work alongside teaching staff to meet each pupil’s needs. All content is online, easy to follow, and designed with real classroom settings in mind—without needing to set foot in one. This training includes everything from SEN teaching techniques to the responsibilities of a SENCO. With rising demand across the UK for SEN roles, there’s no better time to learn the theory and approaches behind the scenes. Gain confidence, know the policies, and learn how to support behaviour, emotional needs, and learning difficulties—all from your device. The course also includes a complete guide to roles, duties, and progression routes within the SEN education sector. Perfect for anyone ready to contribute meaningfully in schools while learning at their own pace. Key Features: CPD Certified SEN Teaching Assistant and SENCO Training Diploma With Complete Career Guide 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Module 01: Special Education Needs (SEN): An Overview Module 02: SEN Support Module 03: High-Quality Teaching for Pupils with SEN Module 04: SEN Teaching Methodologies Module 05: Communication and Interaction Module 06: Cognition and Learning Module 07: Social, Emotional and Mental Health Difficulties Module 08: Sensory or Physical Needs Module 09: The SENCO Role in Policy and Practice Module 10: Roles and Responsibilities within whole School SEN Co-ordination Module 11: The SENCO and the Senior Leadership Team Module 12: Supporting Colleagues and working with Professionals and Organisations beyond the School Module 13: Developing Relationships with Pupils and Parents Module 14: SENCO's Role in Leading and Managing SEND Administration Module 15: Challenges and Opportunities Module 16: Developing Inclusive Practice and the Future SENCO Role ________________________________________________________________________ Complete Career Guide for SEN Teaching Assistant and SENCO Training Diploma : This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the SEN Teaching Assistant sector. In addition to mastering the essentials of SEN Teaching Assistant, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in SEN Teaching Assistant. Your dream career starts here! List of career guide courses included in SEN Teaching Assistant and SENCO Training Diploma With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Understand the fundamental principles of Special Education Needs (SEN). Implement effective SEN support strategies in an educational setting. Apply high-quality teaching methods tailored to pupils with SEN. Employ diverse teaching methodologies suitable for SEN learners. Enhance communication and interaction skills for pupils with SEN. Demonstrate proficiency in managing and addressing social, emotional, and mental health difficulties in SEN students. Accreditation All of our courses, including the SEN Teaching Assistant and SENCO Training Diploma With Complete Career Guide course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your SEN Teaching Assistant and SENCO Training Diploma With Complete Career Guide, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring SEN Teaching Assistants and SENCOs. Educators seeking to enhance their SEN support skills. Individuals interested in understanding SEN teaching methodologies. Professionals looking to take on the SENCO role within schools. Career path SEN Teaching Assistant - £18K to 25K/year. SEN Coordinator (SENCO) - £30K to 45K/year. Educational Inclusion Officer - £25K to 35K/year. Special Educational Needs Teacher - £25K to 40K/year. Behaviour Mentor - £20K to 30K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Register on the Fire and Rescue Services Training Manager today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as proof of your course completion. The Fire and Rescue Services Training Manager is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Fire and Rescue Services Training Manager Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Fire and Rescue Services Training Manager, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Module 01: Introduction to Firefighter Introduction to Firefighter 00:13:00 Module 02: Fire Safety Legislation Fire Safety Legislation 00:24:00 Module 03: Understanding Fire Understanding Fire 00:25:00 Module 04: Fire Risk Assessment Fire Risk Assessment 00:30:00 Module 05: Fire Safety Arrangements Fire Safety Arrangements 00:30:00 Module 06: Evacuation & Safety Evacuation & Safety 00:18:00 Module 07: Fire Extinguishers Fire Extinguishers 00:17:00 Module 08: Emergency First Aid at Work Emergency First Aid at Work 00:13:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Overview Building a business from scratch is not a piece of cake. It requires a great deal of business knowledge and skills. Our Advanced Entrepreneurship Training course is here to help you in building your business. It aims to enlighten you with the knowledge of entrepreneurship. From this course, you will learn the techniques to set up your mindset for the business. The course will help you generate business ideas and show you different types of business modules. Furthermore, you will develop the skills to write and evaluate business plans.  The course will also include lessons on fundraising and green entrepreneurship.  In addition, you will get a clear understanding of why businesses fail. So, if you have the desire to build a business empire, enrol today! Course Preview Learning Outcomes Build up an entrepreneurial mindset Learn how to generate ideas for your business Enhance your knowledge of different types of business models Know how to write and evaluate business plan Develop the skills to gather funding for your business Understand why businesses don't work out Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Business planning Fundraising Who Should Take This Advanced Entrepreneurship Training Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Advanced Entrepreneurship Training course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Advanced Entrepreneurship Training Certification After completing and passing the Advanced Entrepreneurship Training course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Advanced Entrepreneurship Training will equip you with effective skills and abilities and help you explore career paths such as  Entrepreneurs Module 01: Introduction To Entrepreneurship Introduction to Entrepreneurship 00:31:00 Module 02: Entrepreneurship And Innovation Entrepreneurship and Innovation 00:27:00 Module 03: The Entrepreneurial Mindset The Entrepreneurial Mindset 00:22:00 Module 04: Introduction To Idea Generation Introduction to Idea Generation 00:32:00 Module 05: Business Models Business Models 00:34:00 Module 06: Writing And Evaluating Business Plan Writing and Evaluating Business plan 00:26:00 Module 07: Fundraising Fundraising 00:27:00 Module 08: The Reasons Why New Businesses Fail The Reasons Why New Businesses Fail 00:43:00 Module 09: Green Entrepreneurship: A Sustainable Development Challenge Green Entrepreneurship A Sustainable Development Challenge 00:23:00 Assignment Assignment - Entrepreneurship Training 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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 Virtual Instructor Led Training (VILT) Hydrogen will play an increasingly critical role in the future of energy system as it moves forward to supplement and potentially replace fossil fuels in the long run. Offshore wind offers a clean and sustainable renewable resource for green hydrogen production. However, it can also be volatile and presents inherent risks that need to be managed. Even though offshore production of hydrogen has yet to achieve a high state of maturity, many current projects are already dealing with the conditions and effects of offshore production of hydrogen and are grappling with the technological requirements and necessary gas transportation with grid integration. This 2 half-day Virtual Instructor Lead Training (VILT) course will examine the technological options for on-site production of hydrogen by electrolysis (onshore or offshore directly at the platform) as well as the transport of hydrogen (pipeline or ship). This VILT course will also explore the economic considerations and the outlook on future market opportunities. There will be exercises for the participants to work on over the two half-days. This course is delivered in partnership with Fraunhofer IEE. Training Objectives By the end of this VILT course, participants will be able to: Understand the technological attributes and options for green hydrogen production based on electricity from offshore wind. Explore the associated economic analysis for offshore wind hydrogen production, including CAPEX, OPEX, LCOE and LCOH Identify the critical infrastructure and technical configuration required for offshore green hydrogen including transportation networks and grid connectivity Learn from recent findings from current Research & Development projects concerning the differences between onshore and offshore hydrogen production. Target Audience This VILT course is intended: Renewable energy developers and operators Offshore oil & gas operators Energy transport and marine operators Energy policy makers and regulators IPPs and power utilities Training Methods The VILT course will be delivered online in 2 half-day sessions comprising 4 hours 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 Trainer 1: Your expert course leader is Director of Energy Process Technology Division at the Fraunhofer Institute for Energy Economics and Energy System Technology, IEE. The research activities of the division link the areas of energy conversion processes and control engineering. The application fields covered are renewable energy technologies, energy storage systems and power to gas with a strong focus on green hydrogen. From 2006 - 2007, he worked as a research analyst of the German Advisory Council on Global Change, WBGU, Berlin. He has extensive training experience from Bachelor and Master courses at different universities as well as in the context of international training activities - recently on hydrogen and PtX for partners in the MENA region and South America. He holds a University degree (Diploma) in Physics, University of Karlsruhe (KIT). Trainer 2: Your expert course leader is Deputy Head of Energy Storage Department at Fraunhofer IEE. Prior to this, he was the director of the Grid Integration Department at SMA Solar Technology AG, one of the world's largest manufacturers of PV power converters. Before joining SMA, he was manager of the Front Office System Planning at Amprion GmbH (formerly RWE TSO), one of the four German transmission system operators. He holds a Degree of Electrical Engineering from the University of Kassel, Germany. In 2003, he finished his Ph.D. (Dr.-Ing.) on the topic of wind power forecasting at the Institute of Solar Energy Supply Technology (now known as Fraunhofer IEE) in Kassel. In 2004, he started his career at RWE TSO with a main focus on wind power integration and congestion management. He is Chairman of the IEC SC 8A 'Grid Integration of Large-capacity Renewable Energy (RE) Generation' and has published several papers about grid integration of renewable energy source and forecasting systems on books, magazines, international conferences and workshops. Trainer 3: Your expert course leader is Deputy Director of the Energy Process Technology division and Head of the Renewable Gases and Bio Energy Department at Fraunhofer IEE. His work is mainly focused on the integration of renewable gases and bioenergy systems into the energy supply structures. He has been working in this field since more than 20 years. He is a university lecturer in national and international master courses. He is member of the scientific advisory council of the European Biogas Association, member of the steering committee of the Association for Technology and Structures in Agriculture, member of the International Advisory Committee (ISAC) of the European Biomass Conference and member of the scientific committees of national bioenergy conferences. He studied mechanical engineering at the University of Darmstadt, Germany. He received his Doctoral degree on the topic of aerothermodynamics of gas turbine combustion chambers. He started his career in renewable energies in 2001, with the topic of biogas fired micro gas turbines. Trainer 4: Your expert course leader has an M. Sc. and she joined Fraunhofer IEE in 2018. In the Division of Energy Process Technology, she is currently working as a Research Associate on various projects related to techno-economic analysis of international PtX projects and advises KfW Development Bank on PtX projects in North Africa. Her focus is on the calculation of electricity, hydrogen and derivative production costs (LCOE, LCOH, LCOA, etc) based on various methods of dynamic investment costing. She also supervises the development of models that simulate different PtX plant configurations to analyze the influence of different parameters on the cost of the final product, and to find the configuration that gives the lowest production cost. She received her Bachelor's degree in Industrial Engineering at the HAWK in Göttingen and her Master's degree in renewable energy and energy efficiency at the University of Kassel. 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