ISO Standards Course in Database Interoperability
Online 300-hour course in ISO standards for database interoperability. 6 modules covering ISO/IEC 9075 (SQL), ISO/IEC 11179 (metadata registries) and PostgreSQL. Assigned tutor and open enrolment.
Take the controls.
Run a real engineering trade-off from this programme. Move the sliders, watch the model react in real time and beat the challenge.
What you will be able to do
Understand the levels of data interoperability.
Write portable queries conforming to standardised SQL.
Manage metadata in accordance with ISO/IEC 11179.
Assess data quality using standardised metrics.
Select exchange formats suited to each integration.
Apply security and governance controls to shared data.
Develop an interoperable integration project between databases.
Who it's for
- Data architect looking to specialise in ISO Standards for database interoperability.
- Data integration engineer looking to specialise in ISO Standards for database interoperability.
- Database administrator looking to specialise in ISO Standards for database interoperability.
- Data governance manager looking to specialise in ISO Standards for database interoperability.
- Data quality analyst looking to specialise in ISO Standards for database interoperability.
- ETL engineer looking to specialise in ISO Standards for database interoperability.
- Engineering or science graduates seeking to enter information technology.
What you'll work with
- ISO/IEC 9075 (SQL)
- ISO/IEC 11179 (Metadata Records)
- ISO 8000 (data quality)
- ISO/IEC 25012 (data quality model)
- ISO 8601 (dates and times)
- ISO/IEC 21778 (JSON)
- ISO/IEC 27001 (Information Security)
6 modules · 300 h
1.1Levels of interoperability: technical, syntactic and semantic1.2LCIM conceptual interoperability model1.3Relational and non-relational databases1.4Schemas, metadata and data dictionaries1.5ETL and ELT integration1.6Federated architectures and data mesh1.7European Interoperability Framework (EIF)1.8National Interoperability Scheme (ENI)1.9NATO data exchange standards1.10Workshop: interoperability diagnosis of two schemas
2.1ISO/IEC 9075: structure and parts of the SQL standard2.2SQL/Foundation and data types2.3Proprietary extensions versus the standard2.4SQL/MED and external data2.5SQL/JSON in ISO/IEC 9075:20162.6SQL/PGQ and graph queries (2023)2.7ISO/IEC 39075: GQL language2.8Portability across database management systems2.9Connectivity: ODBC (ISO/IEC 9075-3) and JDBC2.10Lab: migrating queries between PostgreSQL and Oracle
3.1ISO/IEC 11179: metadata registries3.2Data elements and value domains3.3ISO 8000: master data quality3.4ISO/IEC 25012: data quality model3.5ISO/IEC 25024: measurement of data quality3.6Data lineage and provenance3.7Data catalogues and DCAT3.8Master data management (MDM)3.9Data governance and DAMA-DMBOK3.10Practice: metadata registry in accordance with ISO/IEC 11179
4.1XML and XML Schema4.2JSON and JSON Schema4.3ISO 8601 for dates and times4.4ISO 3166, 4217 and 639 as reference codes4.5ISO 19115 for geographic metadata4.6OGC standards and geospatial services4.7HL7 FHIR as a sector-specific example4.8REST APIs and OpenAPI4.9Messaging and events: Kafka and AMQP4.10Lab: validating a JSON exchange against a schema
5.1ISO/IEC 27001 and controls over data5.2ISO/IEC 27701 and privacy5.3ISO/IEC 38505: data governance5.4Access control and security labelling5.5Data encryption in transit and at rest5.6Auditing and access logging5.7Personal data protection in integrations5.8Data sovereignty and Gaia-X5.9Interoperability in classified environments5.10Case study: governance plan for integrating two systems
6.1Analysis of the source databases6.2Definition of the canonical model6.3Metadata registry and dictionary6.4Design of integration processes6.5Implementation of standard queries6.6Data quality testing6.7Security and privacy controls6.8Documentation of standards compliance6.9Report and presentation6.10Final review with the tutor
How you'll learn
Fully 100 % online training on the SEIUM campus, with downloadable material, recorded classes and an assigned technical tutor. No fixed timetable: students progress at their own pace within the intake, which makes it possible to combine the programme with work.
Each module combines theory, guided reading of the original standard and applied exercises. The working software is PostgreSQL, Talend, Apache NiFi, DBeaver, Python (pandas), in free, academic or evaluation versions. Practical exercises are based on real data migration procedures between heterogeneous systems, data profiling and cleansing, and the design of metadata dictionaries. Assessment is continuous, module by module, plus a final integrative project.
Build it end to end
Your final project follows the real engineering workflow, step by step, reviewed by your tutor.
Understand the levels of data interoperability.
Write portable queries conforming to standardised SQL.
Manage metadata in accordance with ISO/IEC 11179.
Assess data quality using standardised metrics.
Select exchange formats suited to each integration.
Where this takes you
Requirements
- No prior degree is required.
- Internet connection and a computer capable of running the programme's software.
- Sufficient level of Spanish to follow technical standards texts.
Ready to start?
Send your application today. Our admissions team replies within 72 hours with your study plan and funding options.
Frequently asked questions
The programme is 300 total hours spread over 3 to 5 months. That is between 10 and 15 hours a week on average, compatible with full-time work.
You work with PostgreSQL, Talend, Apache NiFi, DBeaver, Python (pandas). Free, academic or evaluation versions are used, and the tutor indicates the free alternative where one exists.
A SEIUM Institute own diploma upon passing continuous assessment and the final integrative project. It is in-house training, not an official qualification from the Ministry.
Yes. Modules passed in a course or postgraduate diploma in the same area are recognised towards the advanced programme. Check the recognition policy when you enrol.
Related programmes
ESG Impact Course in Transport Insurance
Online 300-hour course in ESG impact in transport insurance. 6 modules covering Directive (EU) 2022/2464 (CSRD), Delegated Regulation (EU) 2023/2772 (ESRS) and Workiva. Dedicated tutor and…
RAMS in Automotive: Metrics and KPIs Course
300-hour online course in RAMS in Automotive: Metrics and KPIs. 6 modules covering IATF 16949 (automotive quality), ISO 26262 (functional safety) and ReliaSoft Weibull++. Assigned tutor…
Course in Ethics in Campaign Digital Infrastructure
Online course of 300 h in ethics in campaign digital infrastructure. 6 modules with Esquema Nacional de Seguridad (Royal Decree 311/2022), Directive (EU) 2022/2555 (NIS2) and…
More in Defense, Military Engineering & Land Systems
All Defense, Military Engineering & Land Systems programmes → · How to apply · Fees & financing · Scholarships