block 07 databases and big data
Master database design, normalisation, and SQL. Essential skills for your project and future career.
Almost every major application you use relies on a database behind the scenes to store and manage information securely. In this block, you will move beyond basic file storage to design efficient relational databases using entity-relationship modelling and normalisation. You will learn how to interrogate and modify data using Structured Query Language (SQL), manage concurrent users safely, and explore how modern systems handle massive volumes of information. Whether building a database for your independent project or understanding the scale of global data analytics, these skills are essential for any software developer.
Comparing flat-file limitations like data redundancy with the structured integrity of relational database systems.
Define relational database entities, attributes, and keys. Differentiate primary, foreign, and secondary keys for schema design.
Designing relational database schemas using entity-relationship diagrams, cardinality, primary keys, and foreign keys.
This page is mainly about 07-04_normal_forms
This page is mainly about 07-05_introduction_to_sql_and_ddl
This page is mainly about 07-06_sql,_dml,_select,_insert,_update,_delete
This page is mainly about 07_advanced_sql_joins_and_subqueries
Last modified: September 21st, 2026
