3402 Courses

Merge the worlds of Electrical Engineering and Trigonometry with our comprehensive course. Gain practical skills and theoretical knowledge to excel in the field.

Dive into the world of structured data manipulation and management with the SQL course. Explore database fundamentals, constraints, functions, clauses, and advanced concepts such as joins and wild cards. From creating to altering databases, this course empowers you with a versatile skill set to navigate and manipulate data efficiently using SQL. Learning Outcomes: Acquire a foundational understanding of SQL, its role, and importance in database management. Master the creation, organization, and manipulation of databases. Implement constraints to ensure data integrity and enforce business rules. Utilize SQL functions to transform and manipulate data effectively. Employ SQL clauses to filter, sort, and analyze data for specific purposes. Perform alterations on databases and tables to accommodate evolving data needs. Explore the intricacies of joins and relationships to retrieve and consolidate data from multiple tables. Harness the power of wild cards to perform flexible and dynamic data searches. Why buy this SQL Database Management? 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 SQL Database Management 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 SQL Database Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring Database Administrators and SQL Developers. Software Engineers Seeking Proficiency in SQL for Application Development. Data Analysts and Business Intelligence Professionals. IT Professionals Looking to Enhance Their Database Management Skills. Prerequisites This SQL Database Management 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 SQL Developer - $70,000 to $110,000/year. Database Administrator - $60,000 to $100,000/year. Data Analyst - $60,000 to $90,000/year. Business Intelligence Developer - $70,000 to $120,000/year. Database Manager - $80,000 to $130,000/year. Course Curriculum Unit 01: Introduction Module 01: Introduction 00:09:00 Module 02: Xampp (PHPmyadmin) installation 00:05:00 Unit 02: Getting Started With Databases Module 01: Creating a database 00:02:00 Module 02: Creating Tables 00:03:00 Module 03: More about Tables 00:01:00 Module 04: Inserting into Tables 00:03:00 Module 05: Updating and Deleting 00:04:00 Module 06: Data Types 00:03:00 Module 07: Conditional and comparison operators 00:04:00 Unit 03: Constraints Module 01: Primary Keys 00:05:00 Module 02: Foreign Keys 00:07:00 Module 03: Indexes 00:03:00 Module 04: Unique Indexes 00:03:00 Unit 04: SQL Functions Module 01: Functions (Part: 01) 00:02:00 Module 02: Functions (Part: 02) 00:03:00 Unit 05: SQL Clauses Module 01: Basic Queries and Where Claueses 00:04:00 Module 02: Order by 00:03:00 Module 03: Distinct 00:05:00 Module 04: In 00:04:00 Module 05: Group by 00:07:00 Unit 06: Alters Module 01: Alters (Part: 01) 00:03:00 Module 02: Alters (Part: 02) 00:05:00 Module 03: Alters (Part: 03) 00:05:00 Unit 07: All about Joins and SQL Relations Module 01: Aliases 00:04:00 Module 02: Inner joins 00:07:00 Module 03: Left and right joins 00:06:00 Module 04: Unions 00:06:00 Unit 08: Wild Cards Module 01: Wild Cards (Part: 01) 00:07:00 Module 02: Wild cards (Part: 02) 00:05:00 Unit 09: More Advanced Areas of SQL Module 01: Views 00:09:00 Module 02: Creating Functions 00:07:00 Module 03: Triggers 00:09:00 Assignment Assignment - SQL 00:00:00

Dive into the world of purchasing and procurement in the upstream oil & gas sector with EnergyEdge's specialized classroom training program.

This course offers an immersive experience in data analysis, guiding you from initial setup with Python and Pandas, through series and DataFrame manipulation, to advanced data visualization techniques. Perfect for enhancing your data handling and analysis skills.

Python Machine Learning algorithms can derive trends (learn) from data and make predictions on data by extrapolating on existing trends. Companies can take advantage of this to gain insights and ultimately improve business. Using Python Machine Learning scikit-learn, practice how to use Python Machine Learning algorithms to perform predictions on data. Learn the below listed algorithms, a small collection of available Python Machine Learning algorithms.

Welcome to Microsoft sql server development for everyone Course. The world of data is a vast and complex one. But with the right tools, it can be yours to explore. SQL Server is one of those tools. It's a powerful database management system that can help you store, manage, and analyse data in ways that were never before possible.   In this Microsoft SQL Server Development for Everyone! course, you'll learn the basics of SQL Server development. You'll learn how to create and manage databases, tables, and data. You'll also learn how to write SQL queries to manipulate data.   Starting with a solid Introduction to SQL, you'll grasp core concepts and gain a strong foundation. We'll then dive into Manipulating Tables and Data, equipping you with effective skills for storing, retrieving, updating, and deleting information.   But we won't stop there! Our in-depth exploration of Relationships and Foreign Keys will ensure you understand the importance of data integrity and how to establish connections between tables. You'll create robust and reliable databases with enforced referential integrity. Next, we'll empower you with the tools of Group By and Aggregate Functions, enabling efficient data analysis and summarisation. Extracting meaningful insights from vast amounts of information will become second nature to you.   To become a well-rounded SQL Server developer, we'll conclude the course with Advanced SQL Server Objects and Concepts. You'll gain a deep understanding of essential elements like stored procedures, views, triggers, and indexes. This knowledge will optimise performance and streamline your development process.   By the end of this Microsoft SQL Server Development for Everyone! course, you'll have a strong understanding of how to use SQL Server to manage and manipulate data. You'll be able to build powerful applications that make better decisions. Become a sought-after SQL Server developer and master the art of data management. Join us today and unlock your data-driven potential!   Learning Outcomes: Through this comprehensive course, you should be able to:   Understand core concepts and gain a strong foundation in SQL Server development. Acquire skills to effectively manipulate tables and data. Establish relationships and enforce data integrity using foreign keys. Utilise group by and aggregate functions for efficient data analysis. Explore advanced SQL Server objects and concepts like stored procedures and views. Gain proficiency in implementing triggers and optimising database performance. Develop the ability to create robust and reliable databases.   Who is this course for? This Microsoft SQL Server Development for Everyone! course is perfect for:   Aspiring developers looking to enhance their programming skills. Professionals seeking to expand their knowledge of SQL Server development. Individuals interested in exploring the world of databases and data management. Students or graduates pursuing a career in database administration or development. Curious learners eager to harness the power of SQL Server.   Career Path Our course will help you to pursue a range of careers, including:   Database Administrator: £25,000 - £60,000 per year. SQL Developer: £30,000 - £65,000 per year. Data Analyst: £25,000 - £55,000 per year. Business Intelligence Developer: £35,000 - £70,000 per year. Software Engineer: £30,000 - £70,000 per year. Data Engineer: £40,000 - £80,000 per year. Database Architect: £45,000 - £90,000 per year. Certification After studying the course materials of the Microsoft SQL Server Development for Everyone! 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. Prerequisites This Microsoft SQL Server Development for Everyone! does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft SQL Server Development for Everyone! 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.   Course Curriculum Introduction Introduction to SQL Server and Databases 00:04:00 Download and Install SQL Server Express 00:05:00 Manipulating Tables and Data Connect to Database Instance and Create a Database 00:06:00 Drop or Remove Database 00:04:00 What is a Database Table? 00:02:00 Create an SQL Database Table 00:32:00 Insert Data into the Table with SQL Script 00:15:00 Insert Data into the Table with Management Studio 00:05:00 Select Data from the Table with SQL Script 00:09:00 More Advanced Select Queries Part 1 00:18:00 Update Data in the Table 00:10:00 Update Data in the Table with Management Studio GUI 00:02:00 Delete Data from the Table with SQL Script 00:06:00 Delete Data from the Table with Management Studio GUI 00:01:00 Relationships and Foreign Keys What are Relationships, Foreign Keys and Normalization 00:11:00 Create a Relationship in SQL Server 00:19:00 Insert Records in Related Tables 00:13:00 Run Queries on Related Tables 00:19:00 Left, Right and Full Joins 00:11:00 Group By and Aggregate Functions Grouping Data using SQL GROUP BY Clause 00:12:00 SQL AVG Aggregate Function 00:11:00 SQL COUNT Aggregate Function 00:04:00 SQL MAX and MIN Aggregate Functions 00:04:00 SQL SUM Aggregate Function 00:04:00 Advanced SQL Server Objects and Concepts Create and Manage Views 00:23:00 Scalar Valued Functions 00:27:00 Inline Table Valued Functions 00:09:00 Multi Statement Table Valued Functions 00:12:00 Stored Procedures 00:28:00 Table Triggers 00:19:00 Database Scripting, Backup and Restore 00:15:00 Assignment Assignment - Microsoft SQL Server Development for Everyone! 00:00:00

About this Training Course Whether you are maintaining an oil rig or processing plant, good quality maintenance is critical to delivering a safe reliable product to your customers. Whatever your level of maintenance experience, this course will equip you with the valuable skills and understanding that will enhance your maintenance career. Too often the maintenance department is seen as the cause of why assets are unavailable, in poor condition yet are costing too much to maintain. By comparison, pace setting companies see maintenance as adding value to their assets and employ an integrated, holistic approach to their maintenance activities. This course will help you move towards that pace setting performance. This course is based on an integrated maintenance model that has been used by leading companies and consultants with success and recognised as best practice. Participants will learn the total impact that maintenance can have on a business, identify key elements (and value) of effective maintenance for their own plants to not only reduce costs but also improve performance. The critical types of maintenance will be covered from day-to-day activities to shutdowns and reliability improvement. The course will break down traditional functional boundaries and encourage a holistic approach to maintenance. With an organisation's maintenance process only as good as its weakest link, this course will guide participants through all the key steps of a maintenance process and its supply chain. Participants will understand what is considered a good standard for each step in the maintenance process, how to identify the weakest links and subsequently how they can accelerate their performance improvement. Participants will have the option of gaining a Bronze Level qualification from the Academy of Turnarounds Operations of Maintenance. For those who obtain a pass, they will receive a Pass certificate and for those who achieve the top quartile score, they will receive a Distinction level pass. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By the end of the course, participants will be able to: Explain the challenges and objectives facing maintenance organisations today Demonstrate the importance of work order systems and use techniques for time estimations and priority assignments Prepare a preventive maintenance program Apply project management techniques to effectively manage major maintenance activities and shut downs Use capital budgeting techniques to evaluate maintenance capital expenditures Demonstrate understanding of how to maintain the optimal stock levels of spare parts to ensure operational continuity Prepare the right Key Performance Indicators (KPIs) to evaluate and improve performance in maintenance Target Audience This course is not just for maintenance professionals. Maintenance teams cannot perform without effective integration with operations and supply chain functions. Availability losses are often caused by operations or design issues and pace setting companies have generated significant benefits by integrating operation and maintenance strategies and working more collaboratively. This course will help all members of the operations and maintenance teams and their supply chain better understand their respective roles in ensuring that maintenance is benefitting and not inhibiting their business. Course Level Basic or Foundation Trainer Your expert course leader is a highly experienced facilitator in maintenance improvement, change management, continuous improvement and capability development as a management coach and trainer. He has a strong focus on people with an emphasis on developing people and the practicalities of improving maintenance performance rather than just the theory. He has worked internationally across Europe, America, the Middle East and Africa with extensive experience in Oil and Gas, the Chemicals sector and manufacturing as well as working with clients in Steel and Power Generation. As a result, he can bring best practice from a wide variety of sources. He spent the first fifteen years of his career as a specialist trainer working for companies such as Lloyds British Training Services and Rolls Royce. He then went on to work as a Principal consultant for ABB consulting for 15 years. During this time, he refined some of the established improvement tools including how and when to apply them for maximum impact whilst still continuing to develop and deliver training in support of this. Recent work has included improvements to the Work Order to Work Execution processes of Engineering departments and focused on Reliability, Planning and Scheduling. This ongoing field experience has helped him test and refine specialist training in a number of areas. He has been able to use his own experience to contribute with other maintenance specialists to the Carcharodon models of excellence. Its methodologies are recognised as 'Best of the Best' standards providing the inspiration for two books, projects that have won awards such as the prodigious UK Chemical Industries annual Excellence in Engineering award and form the basis of this training. He was recently awarded a national award as coach of the year. He uses the same skills to ensure that he does not just preach maintenance best practice, he discusses it, explains it and ensures that delegates have a much more personal and flexible experience. 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

Start your data science journey with this carefully constructed comprehensive course and get hands-on experience with Python for data science. Gain in-depth knowledge about core Python and essential mathematical concepts in linear algebra, probability, and statistics. Complete data science training with 13+ hours of content.

Management of Value (MoV®) Foundation: Virtual In-House Training This interactive MoV® Foundation course provides a modular and case-study-driven approach to learning Management of Value (MoV). The core knowledge is structured and comprehensive; and well-rounded modules cover the methodology and various techniques. A case study is used to help appreciate the relevance of MoV in its practical application. What you will Learn Upon completion of an MoV course candidates should be able to discuss and explain: The main processes and techniques used within MoV and the reasons for using them How MoV may be applied at portfolio, program, project and operational levels The differences in applying MoV at different stages in a project and the expected outputs from a MoV Study at each stage The circumstances under which MoV should be used The concept of value and how value may be improved The main benefits arising from the use of MoV Approaches for implementing MoV How to respond to external and internal influences The principles of embedding MoV into an organization The key topics in document checklists, the toolbox, health check, organizational maturity and individual competence. Upon successful completion of this course, you will be able to: Organize and contribute constructively to a Management of Value (MoV) Study Demonstrate a knowledge of MoV principles, processes, approach and environment Analyse a company, program or project to establish its organizational value; includes identification and weighting of Value Drivers Pass the AXELOS MoV Foundation Examination Introduction to value management and MoV Value and Value Management Capabilities, Outcomes, Benefits and Disbenefits What is Value? What is Management of Value (MoV)? Why use MoV? Where use MoV? When MoV should be used? What using MoV involve? Selected MoV benefits Relationship with other AXELOS Global Best Practices and Models How MoV fits with other AXELOS Global Best Practice Guides MoV principles Align with organization's objectives Focus on functions and required outcomes Balance the variables to maximise value Apply throughout the investment decision Tailor MoV to suit the subject Learn from experience and improve Assign clear roles and responsibilities and build a supportive culture MoV processes Frame the programme or project Gather information Analyse information Process information Evaluate and select Develop Value Improving Proposals Implement and share outputs MoV techniques Function Analysis Function Analysis System Technique (FAST) Traditional (or classic) FAST Technical FAST Customer FAST Value Trees Measuring value Value profiling (a.k.a. value benchmarking) Simple multi-attribute rating technique (a.k.a. SMART) Value index Value metrics Value for money (VfM) ratio Value Engineering / Analysis Common techniques used in MoV Analysis of information Benchmarking Process Mapping Root Cause Analysis Discounted Cash Flow Analysis Generating Ideas Brainstorming Evaluation and option selection Option Selection Matrix Idea selection Allocation to Categories Idea Selection Matrix Weighting techniques Paired Comparisons Points Distribution Developing VIPs Developing Proposals Cost Benefit Analysis Building Decisions Implementing VIPs Implementation Plans Feedback Following up Tracking Benefits Approach to Implementation Generic approach to MoV implementation Plan the MoV activities Understand and articulate value Prioritize value Improve value Quantify value Monitor improvements in value Learn lessons Environmental factors Portfolio Considerations Programme considerations Project considerations Operational Considerations Embedding MoV into an organization Benefits of Embedding MoV into an organization MoV Policy MoV Policy Composition Embedding MoV into an organisation Key steps Suggested MoV Management Structure Overcoming barriers We do it anyway It takes up too much time We can't afford to make the changes What's in it for me? Don't fix it if it ain't broke Fixed returns on investment MoV products Briefing Meeting Agenda (A.1) Communications Checklist (A.2) Equipment list for an Effective Study/Workshop (A.3) Invitation to join the Study Team (A.4) Option Evaluation Matrix (A.5) Plan the Study (A.6) Recording Idea Selection (A.7) Reporting Study outputs (A.8) Scoping the Study (A.9) Study or Workshop Handbook (A.10) Value-Improvement Proposal Forms (A.11) Value Improvement Tracking Report (A.12) MoV toolbox MoV health check and maturity model P3M3 Maturity Model MoV Maturity Model (aligned with P3M3)

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support