Professional Certificate of Competency of Data Engineering Foundations

The course is composed of 12 modules. These modules cover a range of aspects to provide you with maximum practical coverage in Data Analytics and Automation in all streams of Engineering.

Module 1: Introduction to Data Engineering

• The modern data ecosystem and its components
• Development of data engineering
• Skillsets of a data engineer
• Career opportunities and learning paths in data engineering

Module 2: Data Engineering Ecosystem

• Different types of file formats
• Data repositories
  • RDBMS
  • NoSQL
  • Data marts, data warehouses and data lakes
• Selection criteria of a data repository
  • Data pipelines, ETL and ELT
  • Data integration platformS

Module 3: Lifecycle of Data Engineering

• Architecture of the data platform
• Selection and design of data stores
• Data security and its importance
• Other aspects of data engineering
  • Data import and export
  • Data munging and its process
  • Query and data analysis
  • Performance fine-tuning and governance

Module 4: Python for Data Science – 1

• Introduction to Python
• Python data structures
  • Lists and tuples
  • Dictionaries
  • Sets
• Fundamentals of Python Programming
  • Objects and classes
  • Functions
  • Conditions and branching
  • Loops

Module 5: Python for Data Science – 2

• Data in Python
  • Loading, working and saving data with Pandas
• NumPy Arrays and Simple APIs
  • NumPy 1D, 2D Arrays
  • Simple APIs and their setup

Module 6: Web Data Collection – Web Scraping & API

• API
• REST APIs and HTTP requests
• Web scraping
• Working with other formats

Module 7: Relational Database Concepts

• Data fundamentals, information, and data model
• Erd’s, relationship types and entity-to-table mapping
• Data types and database architecture
• Clustered databases and usage patterns
• Introduction to relational database offerings – Db2, MySQL, PostgreSQL

Module 8: Using Relational Databases

• Categories of SQL statements
• Creating DROP, ALTER and truncate tables
• Data movement and loading data
• Database objects and hierarchy
• Main keys and foreign keys
• Summary of indexes and normalization
• Model of relational constraints

Module 9: SQL and PostgreSQL

• Database and tables in SQL
• Keys and constraints of SQL
• Introduction to Postgresql
• Databases and data loading in Postgresql

Module 10: Linux

• Introduction to Linux – architecture, terminal
• Linux commands
  • Shell
  • File and directory navigation and management
• Scripting in shell

Module 11: Data Conversion – Raw to Analytics

• Techniques to process data
  • ETL
  • ETL vs ELT
• ETL and data pipelines
• Building data pipelines – Apache airflow
• Building streaming pipelines – Apache Kafka

Module 12: Data Warehousing and BI Analytics

• Data – warehouse, marts and lakes
• Data warehouse – design, model and implementation
• Data analytics
  • Business intelligence tools
  • Cognos Analytics

To obtain a certificate of completion for EIT’s Professional Certificate of Competency, students must achieve a 65% attendance rate at the live, online fortnightly webinars.  Detailed summaries/notes can be submitted in lieu of attendance.  In addition, students must obtain a mark of 60% in the set assignments which could take the form of written assignments and practical assignments. Students must also obtain a mark of 100% in quizzes.  If a student does not achieve the required score, they will be given an opportunity to resubmit the assignment to obtain the required score.

Please note: This 3-month programme is non-credit-bearing and non-accredited, delivered by ECT’s affiliated institute, EIT, and therefore your certificate of completion will be awarded by EIT.

You will be required to pay your tuition fee upfront before the programme start date.

For a limited time, a promotional fee of £599 applies to new applications submitted between 1 July 2026 and 30 November 2026. The standard tuition fee is £933.

Payment can be made by credit card (Visa and Mastercard only). Upfront payments must be received prior to the programme’s start date.

Please note that if the course does not proceed, you will be issued with a full refund.

The promotional fee cannot be used in conjunction with any other offer unless otherwise stated. We reserve the right to amend, extend or withdraw this promotion after the advertised closing date.

Our courses are delivered by experienced engineers and technical experts from around the world. Many have tackled real-world engineering challenges and bring practical, applied knowledge directly into the classroom.

We draw from a global pool of instructors and lecturers across our organisation. Explore our full team of expert educators on the Instructors & Lecturers page here.

Please note: Not all lecturers and instructors listed on this page will teach every course. The team teaching your course will be confirmed as part of your course enrolment.

You are expected to spend approximately 5-8 hours per week learning the course content. This includes attending fortnightly webinars that run for about 90 minutes to facilitate class discussion and allow you to ask questions. This program has a 65% attendance requirement in the live webinars in order to graduate from the program.  If you are unable to attend the live webinars, you have the option of watching the recording of completed webinars and sending a summary of what you have learnt from the webinar to the Learning Support officer.  The summaries go towards your attendance requirement for the program.

This program is run online on an intensive part-time basis and has been designed to fit around full-time work. It will take three months to complete.

We understand that sometimes work commitments and personal circumstances can get in the way of your studies, so if at any point you feel that you are struggling with the pace of the course or finding a particular module challenging, you are encouraged to contact your designated Learning Support Officer for assistance.

Registrations are open for our upcoming intakes. Please ensure you book your place at least one week before the start date of the program.
If the course is not currently scheduled, please contact us.