Data and analytics · Free online course

SQL for PLC and SCADA Engineers

A first database for engineers who already read tags: what a relational database holds and how it differs from a CSV export, installing MySQL or SQL Server and connecting a client, tables, data types, keys and constraints, INSERT, UPDATE and DELETE, SELECT with filters, sorting, limits and calculated columns, aggregates and GROUP BY, string, date and number functions, the whole join family, UNION and temporary tables, subqueries, EXISTS and views, and normalisation up to third normal form. The video lessons teach standard SQL; the plant framing, the practice tasks and the assessments are written by EDWartens.

  • 15 modules
  • 9h 31m of video
  • Beginner
  • English
  • ₹0, free
SQL for PLC and SCADA Engineers course cover

₹0Free for good

Worth ₹4,999 by length and depth against classroom training. It has always been free; that is not a former price.

No card. Checkout takes a minute and gives you a receipt.

Overview

About SQL for PLC and SCADA Engineers

A first database for engineers who already read tags: what a relational database holds and how it differs from a CSV export, installing MySQL or SQL Server and connecting a client, tables, data types, keys and constraints, INSERT, UPDATE and DELETE, SELECT with filters, sorting, limits and calculated columns, aggregates and GROUP BY, string, date and number functions, the whole join family, UNION and temporary tables, subqueries, EXISTS and views, and normalisation up to third normal form. The video lessons teach standard SQL; the plant framing, the practice tasks and the assessments are written by EDWartens.

SQL for PLC and SCADA Engineers is a free, self-paced online course from EDWartens for automation engineers working with plant data. It has 15 modules and 9h 31m of video lessons by Software Testing Mentor, Simplilearn, NetworkChuck and others, with written notes and worked problems, a practical project with a document pack and a 15-question final assessment (pass mark 60%). Learning is free with an account; an optional certificate with a public verification code is issued when you pass. Last updated 27 September 2026.

Who it is for: Automation engineers working with plant data

This course includes

  • 9h 31m of video lessons
  • 15 modules with written notes and diagrams
  • One final assessment: 15 questions, pass mark 60%
  • Ask-an-engineer support from practising engineers
  • Lifetime access, the course does not expire
  • Optional verifiable certificate when you finish
  1. Step 1 of 3

    Learn the 15 modules

    9h 31m of video lessons, written notes and a practice task per module, at your own pace.

  2. Step 2 of 3

    Pass the final assessment

    15 questions drawn from every module, pass mark 60%, 3 attempts.

  3. Step 3 of 3

    Take the certificate, if you want it

    Optional, paid once, only if you choose it. The course stays free either way.

    See the certificate and its price

A look inside

SQL for PLC and SCADA Engineers: Syllabus at a glance
Syllabus at a glance
SQL for PLC and SCADA Engineers: What you will be able to do
What you will be able to do
SQL for PLC and SCADA Engineers: Tools and credits
Tools and credits

From the lessons

  • What Is SQL? | SQL Explained in 2 Minutes | What Is SQL Database? | SQL For Beginners |Simplilearn

    Why plant data ends up in a database

    by Simplilearn

  • SQL Tutorial #5 - Understanding SQL Statements and Syntax

    Statements, tables and data types

    by Software Testing Mentor

  • SQL Tutorial #8 - How to Insert Data in SQL Table

    Writing rows: INSERT, UPDATE and DELETE

    by Software Testing Mentor

  • SQL Tutorial #15 - BETWEEN Operator in SQL | SQL BETWEEN Operator

    Ranges, patterns, lists and missing values

    by Software Testing Mentor

  • SQL Tutorial #27 - Aggregate Functions in SQL | SQL Aggregate Functions

    Aggregates and GROUP BY: the shift report

    by Software Testing Mentor

  • SQL Tutorial #31 - SQL Join | SQL Inner Join | SQL Joins Tutorial

    Joining tables

    by Software Testing Mentor

Lesson frames belong to the creators named in the Credits and are shown from YouTube.

What you learn

What you will be able to do

Install MySQL or SQL Server and connect a client to it; create tables with the right data types and constraints; insert, update and delete rows without damaging a table; write SELECT queries with filters, sorting, limits and calculated columns; total and group rows with the aggregate functions, GROUP BY and HAVING; clean codes and timestamps with the string and date functions; join tables and predict what an inner, left, cross or self join will return before you run it; answer a question with a subquery, EXISTS or a view; and take a flat spreadsheet to a normalised schema with keys you can defend in a design review. Every one of those is ordinary SQL. What makes it a plant course is EDWartens' own notes, practice tasks and assessments, which set all of it on machine, production, alarm and downtime records.

  • Install MySQL or SQL Server, connect a client, and read a refused connection for whether the server, the port or the password is wrong
  • Create tables with the right data types, primary keys and constraints, and predict which INSERT a constraint will reject
  • Insert, update and delete rows safely, running the SELECT first so you know how many rows will change
  • Write SELECT queries with WHERE, BETWEEN, LIKE, IN and IS NULL, then sort, limit and calculate columns inside the query
  • Produce shift-wise totals with COUNT, SUM and AVG, GROUP BY and HAVING, and clean batch codes and timestamps with the string and date functions
  • Join machine, production and stoppage tables and predict the rows each join returns, answer harder questions with subqueries, EXISTS and views, and take a flat spreadsheet to third normal form

Syllabus

Course content, module by module

In order, at whatever pace suits you. Each module ends with a practice task that builds on the last.

Modules
15
Video lessons
54
Of video
9h 31m
Final questions
15
  1. 01

    Why plant data ends up in a database

    3 lessons · 20m
  2. 02

    Installing a database and connecting a client

    5 lessons · 1h 9m
  3. 03

    Statements, tables and data types

    4 lessons · 41m
  4. 04

    Keys and constraints

    4 lessons · 33m
  5. 05

    Writing rows: INSERT, UPDATE and DELETE

    4 lessons · 53m
  6. 06

    SELECT and the WHERE clause

    4 lessons · 34m
  7. 07

    Ranges, patterns, lists and missing values

    4 lessons · 29m
  8. 08

    Sorting, limiting and calculated columns

    3 lessons · 21m
  9. Final assessment · 15 questions, pass mark 60%

Project

The course project

Optional practice that ends in the kind of job the course prepares you for, with the documents that go with it.

About 14 hours

SCADA production database for a three-line packaging plant: schema, tag mapping, nightly ETL and OEE queries validated against paper logs

Design and build the reporting database behind a flexible-packaging plant's SCADA: a normalised schema for lines, jobs, batches, downtime and quality with the keys and indexes defended in writing, a tag-to-column register for the logger, a nightly job that turns raw tag rows into batch and OEE tables, the shift and Pareto queries with their expected results, and a validation against one week of paper shift logs. You deliver the DDL, the loaded database, your own register, queries, validation report and O&M manual. The sample pack shows what a SCADA engineer hands to a plant that has only ever had Excel.

Sample document pack, 7 documents, filled in for the scenario

  • URSUser Requirements: Production Reporting Database, Łódź Plant
  • SDSSoftware Design Specification: Schema, Keys, Indexes and the Nightly Build
  • RegisterTag-to-Column Register: Logger Tags to Database Columns
  • ProcedureProcedure: Nightly Build, Backup and Restore Test
  • ReportReport Definitions and Expected Results: OEE by Shift, Downtime Pareto, Traceability
  • Test reportValidation Report: Schema, Load, One Week Against the Paper Logs, Traceability, ETL and Backup
  • O&M manualOperation and Maintenance Manual: Production Reporting Database

Read inside the course and download as a workbook. The project is optional practice, marked when you submit it; the certificate needs only the modules and the final assessment.

Tools

Software, hardware and lessons

Software

MySQL Community Server with MySQL Workbench, or SQL Server Express with SQL Server Management Studio. Both are free downloads and a laptop is enough.

Hardware

None. Any Windows or Linux laptop that can run a database server locally.

Who it is for

Beginner. No database experience assumed and no programming background needed. If you can read a PLC tag list and a shift report, you can follow this course.

Video lessons by

  • Software Testing Mentor
  • Simplilearn
  • NetworkChuck
  • Luke Barousse

Independent creators, credited in full under Credits.

Software you need

What to download, where from, what it costs and how to install it. Every link goes to the maker's own site, never a mirror.

One database with its editor

Any one is enough.

  1. 01

    MySQL Community Server and MySQL Workbench

    Oracle

    Free
    Runs on
    Windows 64-bit, macOS, Ubuntu, Debian, Red Hat / Oracle Linux, Fedora, SUSE and generic Linux
    Account
    None needed
    Size
    Windows MSI installer about 126 MB (server) and about 261 MB (Workbench)

    MySQL Community Server and MySQL Workbench Community are free and open source under the GPL.

  2. 02

    SQL Server Express and SQL Server Management Studio (SSMS)

    Microsoft

    Free
    Runs on
    SQL Server: Windows (also Linux). SSMS 22: Windows 11 64-bit (including Arm64) or Windows Server 2019, 2022 or 2025; not Windows 10.
    Account
    None needed
    Size
    SSMS 22 needs 4 GB to 50 GB of free space depending on features (typical 20 GB to 50 GB)

    SQL Server Express is free, including for small production apps, with limits: 50 GB per database, 1,410 MB buffer pool memory, and the lesser of 1 socket or 4 cores. Developer editions are also free but only for development and testing. SSMS is free.

    Alternatives

Checked against each maker's own page on 27 September 2026. Trial lengths and editions change; the maker's page is the final word.

What you walk away with

Your certificate for SQL for PLC and SCADA Engineers

Finish the course, pass the final, and this is the document with your name on it.

Sample Wartens Certificate of Completion for SQL for PLC and SCADA Engineers, issued through the EDWartens training portal
Sample. The issued certificate carries your name, your final score, a unique certificate ID and its own QR code.
  • Verifiable by anyone

  • Adds to LinkedIn in one click

  • QR code on the certificate

  • Names what you can do

  • A permanent link

  • Earned, not attended

Learning is free. The certificate is optional.

Add it now and pay only when you have finished the course, or come back for it later. One-off, US$23.99, with a receipt.

Issued by Wartens Ltd (England and Wales, company no. 15262249) through the EDWartens training portal, as a Certificate of Completion for this self-paced course. Sold in India by Wartens Automation Private Limited. It is not a vendor certification, a university award or a CPD-accredited activity, and it does not certify competence on live equipment. Delivered electronically; see the refund policy.

FAQ

Common questions

Do I need any database experience?

No. The course starts at what a table, a row and a column are, and assumes only that you can read a tag list and a shift report. There is no programming prerequisite. If you keep production or downtime records in Excel today, the first module will feel familiar and the rest shows you what a database does that a spreadsheet cannot.

Do the video lessons use plant data?

No, and it is worth being plain about it. Every video lesson in this course teaches SQL in general. Not one of them mentions a historian, a plant tag, SCADA or a production database, because no free course of that kind exists. The plant application is written by EDWartens: the notes, the worked examples, the practice tasks and every assessment question are set on machine, production, alarm and downtime records. You take the language from the lessons and apply it to your plant in the practice.

Is this the same as an Oracle or Microsoft database certification?

No. Oracle's Database SQL certification and Microsoft's data platform exams are sat with those vendors and paid for separately. This course is preparation for the SQL they test and for the SQL a plant or MES job asks for. It is not that certification, it does not count towards one, and it is never described as one.

MySQL or SQL Server, which should I install?

Either, and the course walks through installing both. Nearly everything taught here is standard SQL that runs on both, and the places where they differ, such as LIMIT against TOP and FETCH FIRST, are pointed out where they come up. MySQL Community Server with Workbench is the lighter download; SQL Server Express with SSMS is the same family as the SQL Server that many SCADA, historian and MES products are installed against.

What will I practise on?

Each module ends with a written task on your own line's records: the ten things a shift records and which table each belongs in, a downtime table with its keys and constraints, the LIKE patterns that match your tag families, the row counts an inner join and a left join would each return. One worked example runs through the course, a machine master with a production log and a downtime log, so a learner who is not in a plant today can do every task on that instead.

Is the SQL for PLC and SCADA Engineers course really free?

Yes. Every module, practice task and assessment. You create an account so your progress is saved and the assessments can be marked. The certificate is the only paid item, and only if you want it.

What certificate does the SQL for PLC and SCADA Engineers course give?

An EDWartens Certificate of Completion, issued when you have worked through every module and passed the final assessment at 60%, with a verification code anyone can check. It is not a vendor credential and is never described as one.

Who made the video lessons in the SQL for PLC and SCADA Engineers course?

The creators named in the Credits block at the foot of this page, on their own YouTube channels. EDWartens did not make the videos and the creators are not affiliated with EDWartens. What EDWartens wrote is the study plan, the notes, the practice tasks and the assessments.

Is the SQL for PLC and SCADA Engineers course free in India, and what does the certificate cost?

Yes. Learning costs ₹0 in India: every module, the written notes, the practice tasks and the final assessment, with no card and no trial period. The only paid item is the optional EDWartens Certificate of Completion, ₹499 including GST for this beginner course, paid in rupees through Razorpay, and only if you want it after passing the final assessment.

All course facts
Price
₹0, free for good. No trial, no card. Comparable classroom training of this length costs about ₹4,999.
Who it is for
Automation engineers working with plant data
Format
15 self-paced modules, 9h 31m of video, written notes, a practice task per module and one final assessment.
Level
Beginner. Beginner. No database experience assumed and no programming background needed. If you can read a PLC tag list and a shift report, you can follow this course.
Brand
Vendor-neutral
Software
MySQL Community Server with MySQL Workbench, or SQL Server Express with SQL Server Management Studio. Both are free downloads and a laptop is enough.
Hardware
None. Any Windows or Linux laptop that can run a database server locally.
Certificate
Optional EDWartens Certificate of Completion, ₹499 inclusive of GST for learners in India, verifiable by code. Not a vendor credential.
Video lessons by
Software Testing Mentor, Simplilearn, NetworkChuck, Luke Barousse (independent creators, credited below)
Language
English
Last updated
27 September 2026

More free courses: Free SCADA courses · Free Industry 4.0 and IIoT courses

Classroom course, Bangalore

PLC training in Bangalore

The Automation Engineer Program (AEP) is our classroom course in PLC programming and industrial automation, taught in person at our Electronic City centre.

Credits

Who made the video lessons

The video lessons in this course were created by the people below, not by EDWartens. Every lesson streams from its creator's own YouTube channel; EDWartens neither hosts nor sells that footage, and the creators are not affiliated with EDWartens and do not endorse this course. What EDWartens wrote is the study plan, the notes, the practice tasks and the assessments.

  • Software Testing Mentorthe numbered SQL Tutorial series that carries most of the course: statements and syntax, DDL against DML, creating databases and tables, data types, constraints, INSERT, UPDATE and DELETE, SELECT and WHERE, the operators, sorting and limits, aggregates, GROUP BY and HAVING, the string, date and maths functions, the joins, UNION, subqueries and views
  • Simplilearnthe two-minute introduction to SQL, the MySQL, SQL Server and Ubuntu installation walkthroughs, and the long-form sessions on joins, GROUP BY and HAVING, temporary tables, subqueries, date types, ER diagrams and normalisation
  • NetworkChuckthe opening case for learning SQL now, with a first query run in the video
  • Luke Baroussethe analyst's walkthrough of SELECT, ORDER BY and LIMIT used in the sorting and calculated columns module

If you are one of these creators and would like a lesson removed or credited differently, write to info@wartens.com.