2914 Engineer courses in Banstead delivered On Demand

Learn to effectively integrate and build RESTful API clients into Java and Spring Boot applications using WireMock.

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

This is a comprehensive and practical Apache Spark course. In this course, you will learn and master the art of framing data analysis problems as Spark problems through 20+ hands-on examples, and then scale them up to run on cloud computing services. Explore Spark 3, IntelliJ, Structured Streaming, and a stronger focus on the DataSet API.

The Energy Management Mini Bundle offers a smart mix of technical systems and regulatory awareness. From heating and ventilation to gas operations and renewable alternatives, this bundle gives you insight into how modern energy setups are structured—and kept safe. With modules on PUWER (Provision and Use of Work Equipment Regulations) and basic electrical engineering, it supports those managing energy equipment or supporting technical environments. Whether you're looking at solar or sockets, this course keeps the voltage under control and the learning consistent. ✅ Learning Outcomes Understand core systems used in renewable energy installations. Learn basic concepts in domestic and trade-level gas engineering. Explore HVAC components and general maintenance structures. Gain clarity on PUWER guidelines and equipment responsibilities. Identify common electrical functions within energy-based systems. Navigate energy-related processes in regulated environments. ✅ Who is this Course For Learners interested in energy systems and technical frameworks. Staff working near gas or electrical installations and equipment. HVAC support workers seeking system knowledge and basics. Admins assisting in energy compliance or risk documentation. Junior engineers involved in gas, HVAC, or renewables. Facilities staff maintaining heating, gas or ventilation areas. Safety personnel working around equipment-based operations. Energy consultants building familiarity with infrastructure systems. ✅ Career Path Energy Support Technician – £30,000 average UK salary HVAC Assistant – £28,000 average UK salary Junior Gas Engineer – £32,000 average UK salary Electrical Systems Assistant – £29,500 average UK salary PUWER Compliance Clerk – £27,500 average UK salary Renewable Energy Trainee – £31,000 average UK salary

The Mechanic Training: 8 in 1 Premium Courses Bundle covers a nuts-and-bolts approach to vehicle and machinery knowledge — minus the oily fingers. From car and bike maintenance to the mathematics behind motion and the principles of mechanical engineering, this bundle brings essential topics together for learners who like their content with a bit of torque. With added modules in welding, basic electrical engineering, and electrician skills, it’s the academic tune-up you didn’t know you needed. Whether you’re looking to expand your understanding of how things work or simply want to grasp the concepts behind mechanics without the spanners, this course bundle has the gears turning in the right direction. Learning Outcomes: Understand core concepts in mechanical and electrical engineering Learn car maintenance theory and parts identification knowledge Study the foundations of bicycle and motorbike systems Explore basic mathematics applied to mechanical operations Understand the theory behind welding and joint techniques Gain insight into electrician duties and electrical safety basics Who is this Course For: Motor enthusiasts with an interest in vehicle systems Mechanical engineering learners needing flexible study options Electrician students exploring combined maintenance concepts Car or bike lovers keen to understand theory Learners pursuing entry-level roles in maintenance or mechanics Hobbyists exploring vehicle maintenance through online study Those interested in welding theory and mechanical fabrication Anyone curious about how machines work internally Career Path (UK Average Salaries): Vehicle Technician – £29,000/year Bicycle Mechanic – £23,000/year Mechanical Engineering Assistant – £32,000/year Electrician – £34,500/year Welding Technician – £30,000/year Maintenance Engineer – £36,000/year

Dive into the captivating world of programming with our course titled 'Python Basic Programming for Absolute Beginners'. Whether you're a novice looking to embark on a new journey or someone eager to grasp the foundational elements of Python, this course is tailored for you. From setting up Python to crafting your first game and understanding the intricacies of control flow statements, our comprehensive curriculum ensures you grasp every fundamental aspect, setting a robust foundation for your future coding endeavours. Learning Outcomes Understand the core concepts and foundational elements of Python programming. Develop proficiency in working with Python strings, operators, and sequences. Master the art of creating control flow statements and basic Python games. Gain insights into file structures and the application of regular expressions in Python. Successfully complete a Python project, showcasing your newfound knowledge. Why buy this Python Basic Programming for Absolute Beginners? 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 Python Basic Programming for Absolute Beginners 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 Python Basic Programming for Absolute Beginners for? Beginners with no prior knowledge of programming seeking a structured introduction. Individuals with a curiosity to explore coding as a new skill or hobby. Students desiring to enhance their academic learning with foundational programming knowledge. Professionals from diverse fields looking to broaden their skill set. Educators wishing to acquire beginner-level knowledge for instructional purposes. Prerequisites This Python Basic Programming for Absolute Beginners does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Basic Programming for Absolute Beginners 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 Python Developer: Average salary range £45,000 - £70,000. Data Analyst: Average salary range £30,000 - £55,000. Web Developer: Average salary range £25,000 - £50,000. Software Engineer: Average salary range £35,000 - £75,000. Automation Tester: Average salary range £40,000 - £65,000. Game Developer: Average salary range £30,000 - £60,000 Course Curriculum Section 01: Introduction Course Introduction 00:02:00 Course Curriculum 00:04:00 How to get Pre-requisites 00:02:00 Getting Started on Windows, Linux or Mac 00:01:00 Section 02: Introduction To Python And Setting Up Introduction to Python 00:02:00 Python vs Other Languages 00:04:00 Why It's Popular 00:04:00 Command Line Basics 00:07:00 Python Installation (Step By Step) 00:06:00 PyCharm IDE Installation 00:08:00 Getting Start PyCharm IDE 00:05:00 First Python Hello World Program 00:07:00 Assessment Test1 00:01:00 Solution for Assessment Test1 00:01:00 Summary 00:02:00 Section 03: PythonBasic Introduction 00:02:00 Variables 00:16:00 Data Types 00:13:00 Type Casting 00:07:00 User Inputs 00:08:00 Comments 00:04:00 Assessment Test2 00:01:00 Solution for Assessment Test2 00:02:00 Summary 00:02:00 Section 04: Python Strings Introduction 00:02:00 Strings 00:05:00 String Indexing 00:05:00 String Slicing 00:04:00 String Built-in Functions 00:09:00 Formatting String (Dynamic Data) 00:05:00 Assessment Test 00:01:00 Solution for Assessment Test 00:01:00 Summary 00:01:00 Section 05: Python Operators Introduction 00:03:00 Arithmetic Operators 00:08:00 Assignment Operators 00:05:00 Comparison Operators 00:05:00 Logical Operators 00:02:00 AND Operator 00:04:00 OR Operator 00:02:00 NOT Operator 00:03:00 Booleans 00:02:00 Assessment Test4 00:02:00 Solution for Assessment Test4 00:01:00 Summary 00:01:00 Section 06: Python Sequences Introduction 00:02:00 Arrays in Earlier 00:02:00 Lists 00:06:00 Add List Items 00:03:00 Remove List Items 00:01:00 Sort Lists 00:03:00 Join Lists 00:08:00 Tuples 00:08:00 Update tuples 00:07:00 Join tuples 00:02:00 Dictionaries 00:06:00 Add Dictionary Items 00:04:00 Remove Dictionary Items 00:03:00 Nested Dictionaries 00:04:00 Sets 00:04:00 Add Set Items 00:03:00 Remove Set Items 00:01:00 Join Set Items 00:04:00 Assessment Test 00:01:00 Solution for Assessment Test 00:02:00 Summary 00:01:00 Section 07: Python Statements Introduction 00:03:00 If Statement 00:03:00 If-else Statement 00:04:00 If-elif-else Statement 00:04:00 If Statement Coding Exercise 00:05:00 Assessment Test 00:02:00 Solution for Assessment Test 00:02:00 Summary 00:02:00 Section 08: Python Control Flow Statements Introduction 00:04:00 Flow Charts 00:04:00 While Loops Statement 00:10:00 For Loops Statement 00:06:00 Loop through a String 00:03:00 The Break Statement 00:03:00 The Continue Statement 00:02:00 The range() Function 00:04:00 Nested Loops 00:04:00 2D List using Nested Loop 00:04:00 Assessment Test 00:01:00 Solution for Assessment Test 00:03:00 Summary 00:01:00 Section 09: Python Games For Beginners Introduction 00:01:00 Guessing Game 00:07:00 Car Game 00:10:00 Summary 00:01:00 Section 10: Python Functions Introduction 00:02:00 Creating a Function 00:03:00 Calling a Function 00:06:00 Function with Arguments 00:05:00 args, Arbitrary Arguments 00:04:00 kwargs, Arbitrary Keyword Arguments 00:06:00 Summary 00:01:00 Section 11: Working With File Structure Introduction 00:03:00 Reading Files 00:10:00 Creating / Writing Files 00:06:00 Delete Files 00:03:00 Summary 00:01:00 Section 12: Regular Expressions Introduction 00:02:00 RegEx Module 00:07:00 RegEx Functions 00:08:00 Summary 00:02:00 Section 13: PythonProject Introduction 00:02:00 Project Overview 00:03:00 ATM RealTime Project 00:13:00 Summary 00:01:00

Electricity powers our lives, and understanding its principles is key to many technical roles. This Electrical/Electrician Training: 8 in 1 Premium Bundle offers essential knowledge covering electrician fundamentals, electrical safety management, mathematics, DC analysis, and important UK regulations such as RIDDOR and PUWER. It is an excellent resource for those wanting to boost their theoretical understanding without leaving their desk. Designed to enhance your grasp of both technical content and safety standards, this bundle fits neatly around busy schedules. It provides solid grounding in core electrical topics and relevant legislation, helping you prepare for a career in electrical engineering or related fields with clarity and confidence. Learning Outcomes Understand the basics of electrical systems and components. Learn principles of electrical safety and risk management. Develop skills in DC electrical circuit analysis. Study essential mathematical concepts for electrical work. Review key UK regulations including RIDDOR and PUWER. Gain knowledge to support electrician roles and tasks. Who is this Course For Trainee electricians building knowledge of electrical principles. Electrical engineers reviewing safety regulations and maths. Health and safety officers managing electrical risk assessment. Technical students preparing for electrical engineering careers. Maintenance staff working with electrical systems and equipment. Supervisors overseeing electrical safety in workplaces. Individuals interested in compliance and electrical legislation. Career changers seeking foundational electrical training online. Career Path Electrician – £28,000 to £38,000 per year Electrical Engineer – £30,000 to £45,000 per year Health and Safety Officer – £26,000 to £36,000 per year Maintenance Technician – £25,000 to £33,000 per year Electrical Safety Advisor – £28,000 to £40,000 per year Compliance Officer – £27,000 to £37,000 per year

The complete manual to help you master real-world AWS concepts and pass the AWS Developer Associate - Exam

🔧 Unlock the Potential of Power Analysis in AC Circuits! 🔧 Are you ready to take your understanding of electrical circuits to the next level? Introducing our comprehensive course: Power Analysis in AC Circuits. This dynamic program is designed for engineers, technicians, and anyone eager to master the intricacies of power in alternating current (AC) circuits.   Course Highlights: 📚 In-Depth Curriculum: Dive deep into the fundamental principles of power analysis, exploring concepts such as power factor, reactive power, and complex power. 🌐 Real-World Applications: Gain practical insights into how power analysis is applied in various industries, from electronics to power systems, ensuring you can implement your knowledge in real-world scenarios. 🎓 Expert-Led Instruction: Learn from seasoned professionals with extensive experience in electrical engineering. Our instructors are committed to providing clear, engaging, and hands-on lessons that bridge the gap between theory and application. 💻 Interactive Simulations: Reinforce your learning with interactive simulations that allow you to experiment with different circuit scenarios, enhancing your ability to analyze and troubleshoot AC circuits. 📈 Career Advancement: Elevate your career prospects by acquiring specialized skills that are in high demand across industries. Power analysis expertise is a valuable asset in today's competitive job market. 🏆 Certification: Upon successful completion, receive a recognized certification, validating your proficiency in power analysis in AC circuits. Showcase your accomplishment to employers and colleagues. 🤝 Community Support: Join a community of like-minded individuals, fostering collaboration and knowledge sharing. Expand your professional network and stay updated on the latest industry trends.   ⏰ Flexible Learning: Our course is designed to accommodate your busy schedule. Access lectures, materials, and resources at your convenience, allowing you to progress at your own pace.   🚀 Enroll Today and Empower Your Electrical Engineering Journey! Don't miss this opportunity to master power analysis in AC circuits. Whether you're a student, professional, or enthusiast, this course is your gateway to unlocking the full potential of AC circuits. Join us on a transformative learning experience and gain the skills that will set you apart in the field. Enroll now and harness the power of knowledge! ️🔍 Course Curriculum Introduction To Power Analysis In Ac Circuits Course Introduction To Power Analysis In Ac Circuits Course 00:00 Power Energy Defined Power Energy Defined 00:00 Power In Reactive Circuits Part A Power In Reactive Circuits Part A 00:00 Power In Reactive Circuits Part B Power In Reactive Circuits Part B 00:00 Power Trig Identities Power Trig Identities 00:00 Power, Real And Reactive Power, Real And Reactive 00:00 Power More On Average, Real Reactive Power More On Average, Real Reactive 00:00 Power - Complex Power Power - Complex Power 00:00 Power Factor Correction Power Factor Correction 00:00 Power In 3 Phase Circuits Power In 3 Phase Circuits 00:00

The Level 3 Foundation Diploma in Engineering (Accredited by Ofqual, UK) was created to help students gain insight and knowledge of a variety of Engineering techniques. The qualification allows students to gain important information in areas such as engineering concepts, design technology, electrical, mechanics, statistics, and maths. This qualification will prepare learners for work in the engineering sector or further education. Key Highlights of this Level 3 Foundation Diploma in Engineering qualification are: Program Duration: 9 Months (Fast Track 6 months duration course also available) Program Credits: 60 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Requirements Level 3 Foundation Diploma in Engineering Level 3 Foundation Diploma in Engineering qualifications can be offered to learners from age 16. Although there are no formal entry requirements for this qualification, it is critical that learners are able to comprehend and articulate the concepts contained in the syllabus in the language in which the course will be delivered and assessed. Career path Progress to Year 1 of a 3 Year UK Undergraduate Degree qualification after completion of your Level 3 Foundation Diploma Engineering Completion of your Level 3 Foundation Diploma in Engineering qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry Certificates Certificate of Achievement Digital certificate - Included Once you complete the course, you would be receiving a digital copy of your Diploma along with its Transcript which can be downloaded from the awarding body website without any additional charge. You can also order Hard copy certificate by paying a nominal cost directly to the awarding body.