3812 Engineer courses in Horsforth delivered Online

About this Training Front End Loading (FEL) is a methodology that takes a deliberate approach to capital project planning. Where traditional project plans seek to help an operator reach production targets and budgets, FEL methodology aligns an operator's technical and business goals to create a more comprehensive development plan. The FEL approach increases project definition and lowers risk to positively impact total investment costs and return on investment. Training Objectives Upon completion of this course, participants will be able to: Learn the methods applied for Pre-FEL and FEL process Understand the importance of FEL, FEL stages; visualisation, conceptualisation, definition Uncover how to apply project management during FEL Determine risk management in the FEL process Understand benchmarking & value improving practices   Target Audience The course is recommended for anyone who wish to gain in-depth knowledge and understanding of the importance of Front-End Loading and how to apply Front End Loading best practices, including: Team Leaders Senior Managers (Line and Function) Project Managers Development Engineers Graduate Engineers Quality Assurance Engineers Key Contractor's Management FEED engineers Design engineers Mechanical engineers Process engineers   Course Level Basic or Foundation Trainer Your expert course leader is a subsea pipeline consultant with extensive experience in the design, construction, and installation of subsea pipelines for the oil and gas industry. As a consultant, he provides technical expertise and support to clients on all aspects of subsea pipeline projects, from the initial planning and design phase through to construction and commissioning. He is knowledgeable about industry standards, regulations, and best practices for subsea pipelines, and works closely with clients to ensure that projects are delivered safely, on time, and within budget. He has over thirty years' experience in early concept and front-end studies for the initiation of numerous high value upstream oil and gas projects worldwide. He has worked for both Operating Companies and Consultants managing the FEL process for complex, multi-discipline and technically challenging concepts, combining both his technical and project management skills. He has been working with companies like ExxonMobil, Quantum Power, North Caspian Operating Company, OMV Petrom, Port Meridian, BG Group, and etc.   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

Overview of Diploma in Basic Chemistry Level 3 Unleash your curiosity with our Basic Chemistry Course. In an era where science and technology underpin our lives, understanding the chemical nature of the world around us is a key skill. The UK chemical industry alone contributed £20.9bn to the economy in 2020, offering diverse opportunities for chemists. Whether your interest lies in healthcare, the environment, or manufacturing, this Basic Chemistry course provides a strong foundation. Master the ABCs of atoms, bonding, and compounds with us. Enrich your understanding and become a part of the chemical revolution. Join our Basic Chemistry Course and navigate the periodic table like a pro! This Diploma in Basic Chemistry Level 3 Course will help you to learn: Comprehend core concepts of basic and applied chemistry. Interpret chemical reactions and understand their impacts. Grasp the interplay between chemistry and energy. Assess chemical safety and laboratory hygiene protocols. Apply chemistry knowledge to environmental and industrial scenarios. This course covers the topics you must know to stand against the tough competition. The future is truly yours to seize with this Diploma in Basic Chemistry Level 3. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion – Digital / PDF Certificate After completing the Diploma in Basic Chemistry Level 3 course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This course is designed for learners with a keen interest in science, particularly in understanding the world at a molecular level. It caters to those wanting to lay a solid foundation for further studies in chemistry or related fields. Moreover, anyone wishing to augment their knowledge base, perhaps for a career change or to make informed decisions about chemistry matters, would find the Course beneficial. Those in professions such as teaching, nursing, or even culinary arts, where a basic understanding of chemistry can enhance performance and outcomes, may also find this Basic Chemistry Course helpful. Requirements You don’t need any educational qualification or experience to enrol in the Diploma in Basic Chemistry Level 3 course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path Laboratory Technician - £18K to £27K/year. Quality Control Analyst - £20K to £35K/year. Environmental Consultant - £22K to £40K/year. Chemical Engineer - £27K to £52K/year. Research Scientist - £30K to £50K/year.

About this Training Subsea pipelines play a critical role in the transportation of hydrocarbons (e.g. oil and gas) from offshore production sites to onshore facilities or other platforms. This course will cover design and construction of subsea pipelines with respect to: design for pressure containment, design for collapse, on-bottom stability, freespans, global (lateral and upheaval buckling), corrosion, materials selection, cathodic protection and coatings. Training Objectives Upon completion of this course, participants will be able to understand: Issues and challenges in subsea pipeline design Methods in applying pipeline design codes Techniques in how to specify a pipeline Key considerations in the main methods of pipeline construction Methods and issues surrounding pipeline intervention Target Audience The course is recommended for anyone who wish to gain in-depth knowledge and appreciation of the fundamental principles of the design and construction of subsea pipelines, including: Team Leaders Senior Managers (Line and Function) Project Managers Graduate Engineers Pipeline Engineers Senior Pipeline Engineers Subsea Engineers Integrity Engineers Quality Assurance Engineers Key Contractor's Management Course Level Basic or Foundation Trainer Your expert course leader is a subsea pipeline consultant with extensive experience in the design, construction, and installation of subsea pipelines for the oil and gas industry. As a consultant, he provides technical expertise and support to clients on all aspects of subsea pipeline projects, from the initial planning and design phase through to construction and commissioning. He is knowledgeable about industry standards, regulations, and best practices for subsea pipelines, and works closely with clients to ensure that projects are delivered safely, on time, and within budget. He has over thirty years' experience in early concept and front-end studies for the initiation of numerous high value upstream oil and gas projects worldwide. He has worked for both Operating Companies and Consultants managing the FEL process for complex, multi-discipline and technically challenging concepts, combining both his technical and project management skills. He has been working with companies like ExxonMobil, Quantum Power, North Caspian Operating Company, OMV Petrom, Port Meridian, BG Group, and etc. 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

Duration 5 Days 30 CPD hours This course is intended for Fabric Architect Administrator Developer Overview Please refer to Overview. There is no course like this available on the market; it will start from the beginning of standing up a Hyperledger Fabric v1.4 Network. This course will accommodate architects with very little-to-no experience on Fabric, and give them the knowledge necessary for perform the role of a Fabric Architect, Administrator and Developer.This course is a combination of the following two courses:Hyperledger Fabric v1.4: Architecting, Designing and Deploying a Network (3 days)Hyperledger Training: Developing on Hyperledger Fabric (2 days) This course is a combination of these two courses, view each for the combined outline: Hyperledger Fabric v1.4 - Architecting, Designing and Deploying a Network Developing on Hyperledger Fabric 1.4

Course Overview Find the ultimate guide for learning Django framework by taking this Django REST Framework - Full Stack Python APIs using Python course. In this course, you will learn the techniques to build Python Rest APIs using the Django framework. This Django REST Framework - Full Stack Python APIs using Python course breaks tools and techniques to enhance your understanding of the Django framework and its features. The project-based course provides step-by-step instructions on how to create a Rest API from scratch. You will start the course by learning how to set up a Django development environment and proceed towards the fundamental steps in creating a Rest API project. You will gain the knowledge to develop Rest APIs using function-based views and class-based views. You will also learn the best practices to secure your Rest APIs. Learning Outcomes Gain in-depth knowledge Rest API Learn hope to configure the Rest API Identify the importance of Django Framework Deepen your understanding of mixins and generic views Know how to create Rest APIs using function based views Learn how to create viewset Be able to create Rest APIs with class based views Who Is This Course For? The Django REST Framework - Full Stack Python APIs using Python course is incredibly beneficial for professionals interested in learning how to create Python Rest APIs in Django Framework.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path Django REST Framework - Full Stack Python APIs using Python provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as Full Stack- Lead Software Developer Python/Django Developer Backend Developer Software Engineer-Python Unit 01: Start Here Module 01: Course and Instructor Introduction 00:03:00 Module 02: How to make the best of this course 00:02:00 Unit 02: Introduction Module 01: What is REST? 00:06:00 Module 02: Why REST 00:08:00 Module 03: What and Why DJango REST Framework 00:06:00 Unit 03: Software Setup Module 01: Install DJango 00:03:00 Module 02: Install DJango REST Framework 00:01:00 Module 03: Install MySql and MySql workbench 00:03:00 Module 04: Launch MySql workbench 00:02:00 Module 05: Install python mysqlclient 00:01:00 Module 06: Install ATOM 00:03:00 Module 07: Install Postman 00:01:00 Unit 04: REST in Action Module 01: Create the Project 00:03:00 Module 02: Create a view 00:02:00 Module 03: Configure the URL and TEST 00:03:00 Module 04: Create app level urls 00:02:00 Module 05: Create a model class 00:03:00 Module 06: Configure the database and run migrations 00:03:00 Module 07: Use the model in the view and test 00:03:00 Unit 05: Function Based Views and Serializers Module 01: DRF Components 00:06:00 Module 02: Function Based Views 00:05:00 Module 03: Serializers 00:04:00 Module 04: Create the Project 00:02:00 Module 05: Create the Model 00:02:00 Module 06: Create the Serializer 00:02:00 Module 07: GET single student 00:04:00 Module 08: Create Student 00:04:00 Module 09: Implement Non Primary Key Based Operations 00:07:00 Module 10: Use @api_view 00:01:00 Module 11: Configure the URLs 00:02:00 Module 12: Test 00:07:00 Module 13: Test Using Postman 00:04:00 Unit 06: Class Based Views Module 01: Introduction 00:03:00 Module 02: Create the Project 00:03:00 Module 03: Implement Non Primary Key Based Operations 00:06:00 Module 04: Implement Primary Key Based Operations 00:07:00 Module 05: Configure the URLs and TEST 00:04:00 Unit 07: Mixins Module 01: Introduction 00:05:00 Module 02: Non Primary Key based operations 00:04:00 Module 03: Primary Key based operations 00:02:00 Module 04: Configure the URLs and TEST 00:02:00 Unit 08: Generic Views Module 01: Generics 00:03:00 Module 02: Generics in action 00:03:00 Unit 09: ViewSets Module 01: Introduction 00:03:00 Module 02: Create ViewSet 00:02:00 Module 03: Configure URLs and Test 00:04:00 Unit 10: Nested Serializers Module 01: Create the project 00:02:00 Module 02: Create model 00:03:00 Module 03: Create Serializers 00:04:00 Module 04: Create REST endpoints 00:03:00 Module 05: Configure URLs 00:02:00 Module 06: Test 00:03:00 Unit 11: Pagination Module 01: Introduction 00:06:00 Module 02: Pagination in action 00:05:00 Module 03: Pagination at class level 00:03:00 Module 04: Using LimitOffsetPagination 00:01:00 Unit 12: Security Module 01: Introduction 00:04:00 Module 02: Authentication in action 00:03:00 Module 03: Authorization in action 00:06:00 Module 04: Global Security 00:04:00 Unit 13: Flight Reservation API Module 01: Usecase 00:01:00 Module 02: Create the Project 00:01:00 Module 03: Create Model Classes 00:03:00 Module 04: Create Reservation Model 00:01:00 Module 05: Create Serializers 00:01:00 Module 06: Create ViewSets 00:02:00 Module 07: Configure the Router 00:02:00 Module 08: Run Migrations 00:01:00 Module 09: Initial round of testing 00:04:00 Module 10: Implement findFlights endpoint 00:03:00 Module 11: Test findFlights 00:05:00 Module 12: Implement Save Reservation 00:06:00 Module 13: Test Save Reservation 00:04:00 Unit 14: Validations Module 01: In-Built Validations 00:04:00 Module 02: Allowing Blank and Null Values 00:02:00 Module 03: Create Custom Validator 00:05:00 Module 04: Two more ways 00:07:00 Unit 15: Token Auth Module 01: Introduction 00:03:00 Module 02: Configure Token Auth 00:05:00 Module 03: Create Users and Token 00:04:00 Module 04: Token Auth in action 00:03:00 Module 05: Automate Token Creation 00:09:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

About this Course Batteries are going to play an increasingly important role in the energy grid. An increasing number of developers are looking to add battery storage systems (BESS) into their existing projects. However future cash flows are highly uncertain and they are often unsure exactly how battery technology can be monetised. A strong revenue model requires stacking of different revenue sources. As the share of variable renewable sources in electricity systems further increase, battery systems are expected to play a growing role by providing frequency control and operational reserves as well as for wholesale arbitrage, while helping reduce grid integration costs. The more volatile electricity prices are, the greater the earning potential of batteries trading electricity on various electricity markets. BESS can generate revenue streams in several different ways; through a frequency response contract with the TSO, by providing grid services in other ways or by arbitrage through buying cheap power and selling power for a higher price in a liquid wholesale market. Because batteries are efficient, the round trip efficiency is also high. They can spread arbitrage trading much better than other storage types and in many cases, other asset classes. For companies that combine a battery with other tasks, for example to store power from their own panels, or to avoid a costly heavy power connection, the investment is less risky than for those that purely focus on arbitrage trading. It is uncertain whether electricity prices will fluctuate more violently in the coming years, or whether the peaks will actually level off. During this highly interactive training, the trainer will provide you with the latest insights and best practices on how to obtain the maximum economic benefits when participating with BESS in the electricity market. Training Objectives By the end of this course, the participants will be able to: Discover the different BESS battery technologies and their impact on the grid Understand the role of storage in providing flexibility to the power system Examine the potential revenue streams from BESS models Learn how profit can generated with BESS trading strategies Determine how to optimize the value from BESS projects Find out how to combine BESS with renewable PPAs Target Audience Professionals and executives from Power Utilities, Energy Companies, Financial & Investment Banks, Renewable Power Project Developers, Transmission System Operators and Energy Industry Regulators will find this training course useful. Electricity Marketing and Traders New Venture or Business Development Executives Corporate Finance and Treasury Executives Audit and Risk Management Executives Power or Utility Market Research Analysts Investment Managers for Renewable Power Projects Origination Professionals Regulation, Compliance and Documentation Officers Lawyers and Accountants Power Transmission and Distributions Engineers Trainer Our key expert is a skilled and accomplished professional with over 25 years' of extensive senior management / board level experience in the energy markets worldwide. Next to advising energy companies, banks, consultants and regulators regarding PPAs, our key expert has also conducted several highly successful training courses about Power Purchase Agreements, Power Project Finance, IPPs, and Project Risk Management to over 1,000 high level participants from Asia, Africa, Europe and Middle East. He was a member of the expert commission of the Dutch Government for 2 offshore wind parks, Hollandse Kust (zuid) Wind Farm Zone Sites 3 and 4 that advised on which of the 5 applicants did provide the best security and solutions associated with the electricity and green certificate prices, the construction and operational risks of the project. 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

Ready to power up your career? Join our Electrician course to learn everything from basic electricity to circuit analysis. Get certified and step into a rewarding profession! Enroll now!

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

About this Virtual Instructor Led Training (VILT) Governments, regulators and energy companies are pursuing CO2 storage technologies to meet their net-zero carbon commitments as well as targets set by the international Paris Agreement on climate change. For successfully executing Carbon Capture & Storage (CCS) projects, various technical, operational, economic and environmental risks and associated stakeholders need to be managed. In this 5 half-day Virtual Instructor Led Training (VILT) course, the methods for managing risk in CCS projects are addressed with a focus on CO2 injection and storage. The VILT course will also demonstrate how to assess storage capacity of a potential CO2 storage reservoir, model framing techniques, and well injectivity issues related to CO2 injection. The potential leak paths will be discussed such as reservoir seals, leakage along faults and aspects of well integrity. In the VILT course, the design of a monitoring programme will also be discussed. The VILT course will be supported by various case studies. This VILT course will cover the following modules: CCS projects in an international context Site selection and site characterization Storage capacity assessment Injectivity assessment Containment assessment Measurement, monitoring & verification Training Objectives On completion of this VILT course, participants will be able to: Uncover the functions and associated components required to capture, transport and store CO2 in subsurface aquifers and (depleted) hydrocarbon reservoirs Find a systematic and integrated approach to risk identification and assessment for CO2 storage projects (maturation) Appreciate the requirements (physics modelling) and uncertainties to assess the CO2 storage capacity of a selected site. Understand the challenges, data and methods to assess CO2 well injectivity and well integrity Identify the leakage pathways of a selected storage site, and understand the assessment methods and associated uncertainties Learn how to design a monitoring program Target Audience This VILT course is intended for all surface and subsurface engineers such as facility engineers, geologists, geophysicists, reservoir engineers, petrophysicists, production technologists/engineers, well engineers and geomechanical specialists. Also, (sub)surface team leads, project managers, business opportunity managers, decision executives, and technical risk assessment & assurance specialists will benefit from this VILT course as it provides a common framework and workflow to develop a CCS project. For each class, it is highly recommended that a mix of disciplines mentioned above are represented to facilitate discussions from different perspectives. Course Level Basic or Foundation Training Methods This VILT course is built around cases in which teams work to identify and assess CO2 storage site issues using a systematic thought approach in this course. In addition, exercises are used to practise the aspects of the CCS risk assessment process. The VILT course provides a venue for discussion and sharing of good practices as well as opportunities to practise multi-discipline co-operation and facilitation. Participants are encouraged to bring their own work issues and challenges and seek advice from the expert course leaders and other participants about all aspects of CCS. This VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Trainer Trainer 1: Your expert course leader has more than 36 years of experience in the oil & gas industry with Shell. He gained broad experience in petroleum engineering, with expertise in integrated production systems from subsurface, wells and surface. He has had assignments in Production Technology, R&D, Production Chemistry, Rock Mechanics and Reservoir Engineering cEOR, with a proven track record in technology screening, development and deployment, field development planning, conceptual well design and Production System Optimization (PSO) of gas and oil fields as well as preparing Well, Reservoir & Facility Management (WRFM) strategies and plans. He had also worked on assignments in NAM and did fieldwork in Oman, Gabon and Shell Nigeria. He is a skilled workshop facilitator. He discovered his passion for teaching following an assignment in Shell Learning. During his time in Shell, he developed and taught technical courses to Shell professionals via blended learning. Trainer 2: Your second expert course leader has over 30 years of experience identifying, assessing and mitigating technical risks with Shell. The main focal point of his experience is in subsurface and Geomechanical risks. He is the the founding father of various innovations in how we assess risks by tool development (for bore hole stability, 3D geomechanical field evaluations and probabilistic assessment). He also developed an eye for people motivation, change management and facilitation. He was also responsible for the Geomechanical competence framework, and associated virtual and classroom training programme in Shell for 10 years. Trainer 3: Your third expert course leader has more than 30 years of experience in Shell, focusing on research and development in drilling and offshore systems. His areas of expertise is in project management, finance, business planning, investment, development studies and economics models. In 2021, he worked on a project that looked into the economic evaluation of P18A field complex for CO2 storage. He has an MSc in Mechanical Engineering (M.E.) TU Delft Netherlands (Hons) and a baccalaureate from Erasmus University Rotterdam. 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

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