SQL for PLC and SCADA Engineers

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.

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.

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.

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.

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.

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.

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.

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.