471 Courses delivered Online

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

Managing SARs Investigations - Best Practice Guide Are you doing everything you need to? Make sure you've got all your bases covered with this desktop guide, and get to grips with an area that can be perceived by some to be a legal minefield. Built on extensive practitioner knowledge, this course provides tips and advice on managing investigations that are practical and have real-life relevance. Understand which aspects to be aware of when reviewing and evaluating potentially suspicious or unusual activity Know the process for considering an internal alert about a suspicious transaction or account activity Equip yourself with the confidence to make decisions, which can have serious implications for you personally as well as others This course is designed to either complement SARs Investigations: Practice like a Professional or as standalone learning.

The Agile Project Manager (On-Demand) Change isn't coming, it's already here. The project environment is becoming more volatile, uncertain, complex, and ambiguous. Project management and project managers must transform and evolve in order to keep up with these changes. Agile has been a disruptor in the field of project management, having over 20 years of successes and benefits to organizations that have adopted their frameworks. The Agile frameworks have proven themselves to be more adept in dealing with this uncertainty. But Agile isn't just about following a different way of working. What do you need to learn, do, and become in order to continue in the current and future environment? It is a powerful combination of knowledge, competencies, and mindset. In an increasingly complicated project environment, this course provides participants with the knowledge needed to not only survive but thrive. What you will Learn At the end of this program, you will be able to: Evaluate the changing project environment and the needed knowledge, skills, and behaviors Demonstrate innovative project manager competencies of leading change, servant leadership, and focus on value Utilize Lean and Agile principles to maximize value and improve project performance Construct a hybrid Agile model that is unique to your project Assess your role in Business Agility as an Agile Project Manager Getting Started Introductions Workshop orientation Expectations Foundations Recap: What is Agile? A changed project environment The future project manager Agile Project Management Competencies Focusing on value Championing change Servant leadership Coaching / mentorship Facilitation Lean and Agile Principles Optimizing flow Making things small Continuous planning Just-In-Time requirements Visualizing work Hybrid Agile Considerations Considering a Hybrid Approach Examining Strengths and Weaknesses of Each Approach Selecting Waterfall / Agile Roles, Practices, and Techniques Reviewing Three Hybrid Scenarios Constructing the Hybrid Project Implementing Agile Pitfalls and Concerns Agile in the Organization Business Agility Summary and Next Steps

PMI-PBA® Exam Prep: In-House Training The course provides targeted exam preparation support for PMI®'s Professional in Business Analysis exam candidates, including a content review of The PMI Guide to Business Analysis, a review of the PMI-PBA® reference books, and an exam preparation tutorial. You will be given a Study Guide that you can re-use to assess your knowledge gaps as part of your Personal Action Plan. Your score on this for each Knowledge Area can be compared to your results on the quiz at the end of each course module to guide your study efforts. What you will Learn Upon completion, participants will be able to: Demonstrate familiarity with the structure, content and framework of The PMI Guide to Business Analysis Explain the six Knowledge Areas of The PMI Guide to Business Analysis, as well as, their inter-relationships with each other and the six Process Groups Differentiate among the five business analysis domains in the project life cycle Create a personal action plan to study and prepare for the PMI-PBA® Exam Getting Started PMI-PBA Examination Certification Process The Credential Examination Foundation Concepts for PMI-PBA® Prep Business analysis terminology and definitions Business analysis project, program, and portfolio management Product and project life cycles Skills and qualities of a business analyst Introduction to Business Analysis in Projects Business analysis overview How organizations implement business analysis Business analyst and project manager relationships Requirements definitions and types Practice quiz On-Demand Segment A: Define the Business Problem (Pre-work for Needs Assessment) Needs Assessment Review Needs Assessment knowledge area Identify problem or opportunity Assess current and future state Determine options and provide recommendations Facilitate product roadmap development Assemble business case Practice quiz Stakeholder Engagement Review Stakeholder Engagement knowledge area Identify Stakeholders and conduct analysis Determine Stakeholder engagement and communication approach Conduct business analysis planning Practice quiz On-Demand Segment B: The Elicitation Plan (Pre-work for Elicitation) Elicitation Review Elicitation knowledge area Determine Elicitation approach Preparing for Elicitation Conducting Elicitation Confirming Elicitation results Practice quiz On-Demand Segment C: Overview of Requirements Analysis (Pre-work for Analysis) Analysis Review Analysis knowledge area Determine Analysis approach Create and analyze models Define requirements and acceptance criteria Verify, validate, and prioritize requirements Identify and analyze product risks Assess product design options Practice quiz Traceability and Monitoring Review Traceability and Monitoring knowledge area Determine Traceability and Monitoring approach Establish relationships and dependencies Select and approve requirements Make changes to requirements and other product information Practice quiz Solution Evaluation Review Solution Evaluation knowledge area Evaluate solution performance Determine solution evaluation approach Evaluate acceptance results and address defects Obtain solution acceptance for release Practice quiz Exam Application and Preparation Process Applying for the Exam Studying for the Exam Sitting for the Exam Reviewing your Knowledge Gap Practice Exam Study Guide - a reliable learning aid Summary and Next Steps Crystallizing the Business Analysis Domains Developing a Personal Action Plan for Exam Study

Do you want to grow your business and beat the competitors with more efficiency? The Active Training Tools

Corporate Leadership and People Management are about delivering results through others. True business owners know how to leverage the best talent within their teams, and know how to transform the performance of their organization through people. Setting up the right vision, engagement people onto a strategy, setting goals and providing feedback: the set of skills that are required for a People Manager is enormous. At the end of the day, the ultimate skill of a leader is to adapt, and situation leadership is a proven model at the heart of leadership, which you are going to discover in this course. By the end of this course, you will be able to: Measure your level of credibility as a manager Put in place an action plan on how to increase the level of Trust with your key stakeholders Lead a Vision, Mission and Strategy workshop with your teams Ellicite your team's Values Facilitate effective team meetings Define clear goals for your teams Define clear goals for your direct reports Know exactly what process and steps to follow when reviewing team goals Know exactly what process and steps to follow when reviewing individual goals Learn how to engage your people and motivate them Discover the world class technique on how to adapt your leadership style This course is most suitable for: Recently promoted managers who want to accelerate their development path Managers with 2-3 years of experience who want to increase their performance Future managers who want to maximize their chances for being successful At the end of my course, students will be able to... Measure their level of credibility as a manager Put in place an action plan on how to increase the level of Trust with their key stakeholders Know precisely how to adjust their managerial style based on the situation and the individual Lead a Vision, Mission and Strategy workshop with their teams Elicit their team's Values Facilitate effective team meetings Define clear goals for their teams Define clear goals for their direct reports Know exactly what process and steps to follow when reviewing team goals Know exactly what process and steps to follow when reviewing individual goals Discover the world-class technique on how to adapt your leadership syle Learn how to engage your people and motivate them Who should take this course? Who should not? Managers with 2-3 years of experience who want to raise their standards Recently promoted managers who want to accelerate their development path Future managers who want to maximize their chances for being successful Corporate Leadership and People Management Prepare your environment PROMO FREE 00:07:00 Welcome 00:01:00 Step 1 prepare your environment 00:01:00 Creating your team Vision, Mission and Strategy 00:08:00 Eliciting your team Values 00:07:00 Defining your team Goals 00:06:00 Manage your team Step 2 Manage your team 00:01:00 Expanding Credibility 00:03:00 The Trust formula 00:05:00 The Situational Leadership model 00:15:00 Engaging your team with Gallup 00:06:00 Review your results Step 3 Review your results 00:01:00 Lead regular team meetings 00:06:00 Lead One on One meetings 00:04:00 Facilitate your quarterly team meetings 00:03:00 Closing 00:02:00 Additional Resource Resource : Corporate Leadership and People Management 00:00:00

Increase your customer revenue and expand the business area with this exclusive Introduction to Customer Relationship Management course.Customers

About this training course The aim of this exclusive 5-days training course is to raise an intermediate level to your knowledge and understanding of international E&P finance and accounting. This is achieved by in-depth examination of international practices and current developments across a broad range of relevant topics. You are encouraged to challenge existing methods as a basis for reviewing procedures and introducing improvements in your own work place. Training Objectives After the completion of this training course, participants will be able to: Enhance your comprehension of accounting and reporting issues unique to the E&P industry with emphasis on the application of International Financial Reporting Standards (IFRS) Improve your understanding of the accounting and reporting of Sales Revenue, Farm In/Farm Out, and Carried Interest Enhance your knowledge of Production Sharing Contracts and Joint Venture Accounting issues including Unitisation & Redetermination Advance your knowledge of the Corporate Budget and Planning process including a review of Key Performance Indicators and Company Strategy Raise your awareness of the E&P business activity for which we are accounting and reporting Target Audience We recommend that, to derive maximum benefit from this course, you should first attend our predecessor Level 1 course. Otherwise, this course is suitable for personnel with a good foundation knowledge in exploration and production accounting. 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. This course is also available through our Virtual Instructor Led Training (VILT) format. 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

  Delivered in either Live Online (4 days) or in our Classroom (5 days), the ISO 31000 Lead Risk Manager training enables you to acquire the expertise to support and lead an organization and its team to successfully identify, understand and manage a risk process based on ISO 31000. During this training course, you will also gain comprehensive knowledge of the best practices used to implement a Risk Management framework that provides the foundation for designing, implementing, monitoring, reviewing and continually improving a Risk Management process in an organization. About This Course   After mastering all the necessary concepts of Risk Management, you can sit for the exam and gain "Certified ISO 31000 Lead Risk Manager' credential. By holding this Certificate, you will be able to demonstrate that you have the professional capabilities and competencies to effectively manage a risk process in an organization.   Learning principles;   Acknowledge the correlation between ISO 31000, IEC/ISO 31010 and other standards and regulatory frameworks Master the concepts, approaches, methods and techniques used to manage risk within an organization Learn how to interpret the ISO 31000 principles and guidelines in the specific context of an organization Learn how to establish an effective risk communication plan and a risk recording and reporting process Acquire the expertise to support an organization to effectively manage and monitor risk based on best practices Prerequisites   A fundamental understanding of ISO 31000 and comprehensive knowledge of Risk Management. What's Included?   Refreshments & Lunch (Classroom courses only) Course Slide Deck Official Study Materials CPD Certificate The Exam Who Should Attend?   Managers or consultants seeking to master their skills to support an organization during the implementation of an organization-wide Risk Management framework and process based on the principles and recommendations of ISO 31000 Professionals responsible for the creation and protection of value in organizations through effective management of risks Expert advisors seeking to gain comprehensive knowledge of the key concepts, processes and strategies of Risk Management Risk Management team members Our Guarantee     We are an approved IECB Training Partner. You can learn wherever and whenever you want with our robust classroom and interactive online training courses. Our courses are taught by qualified practitioners with commercial experience. We strive to give our delegates the hands-on experience. Our courses are all-inclusive with no hidden extras.  The one-off cost covers the training, all course materials, and exam voucher. Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. Our Promise: Pass first time or 'train' again for FREE. *FREE training and exam retake offered Accreditation Assessment   The exam consists of a 12 question essay type format, to be completed within 150 minutes and a pass mark of 70% Exam results are provided within 24 hours. Provided by   This course is Accredited by NACS and Administered by the IECB.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Basics of Active training tools Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Basics of Active training tools Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Basics of Active training tools Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Basics of Active training tools Course, like every one of Study Hub's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Basics of Active training tools? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD QS-accredited qualifications after course completion Receive one-to-one assistance 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 Basics of Active training tools 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Basics of Active training tools course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Basics of Active training tools does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Basics of Active training tools was made by professionals and it is compatible with all PCs, Macs, 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 As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Basics of Active training tools is a great way for you to gain multiple skills from the comfort of your home. Module 01: Why This Course Drawing Learning from Experience 00:04:00 How to Taking a Bath Led to Archimedes Principal 00:03:00 Survey Help Us to Get the Training You Desire 00:01:00 Meet the Trainers 00:04:00 Module 02: Art: The Active Reviewing Toolkit Reviewing with playing cards - a practical model 00:04:00 Activity Map 00:04:00 Facts: Action Replay 00:06:00 Feelings: Empathy Test 00:03:00 Feelings: Storyline 00:03:00 Findings: Goal Keepers 00:04:00 Findings: Horseshoe 00:04:00 Futures: Back to the Future 00:04:00 Futures: Missing Person 00:05:00 BONUS: Interview with Roger Greenaway 00:15:00 Module 03: Implement Art into Your Training When to Review? 00:01:00 Not Enough Time for Reviewing? 00:03:00 What Could Possibly Go Wrong? 00:04:00 Top 10 Tips for Reviewing 00:05:00 Q&A: Get Answers to Your Questions 00:02:00 Module 04: What's Next Survey Helps Us Improve Toolkit 00:02:00 Bring Roger to Your Country 00:02:00 Experimental-ise Your Curriculum 00:02:00 Presentation to Persuasion 00:06:00 Final words 00:03:00 Resources Resources - Basics of Active training tools Assignment Assignment - Basics of Active training tools