Module Artifacts
A structured outline of the module's learning topics, progressing from SQL's role as a data modeling language and relational database fundamentals through logical modeling concepts, schema creation, and related definitions, used by instructors to organize content and by learners to navigate what will be covered.
This reading introduces SQL as a data modeling and definition language — not just a query tool — explaining how DDL statements shape database structure, and learners use it to reframe their understanding of SQL's role before studying schema design.
This reading explains the foundations of the relational model, including how data is organized into tables, rows, columns, keys, and relationships, giving learners and instructors a conceptual grounding before moving into SQL syntax and design.
This reading covers logical data modeling concepts such as entities, attributes, and relationships, explaining how to design a structured representation of a business domain before translating it into SQL, serving as a pre-coding design reference for learners.
This reading explains how to create and define a database schema using SQL DDL, covering tables, columns, data types, constraints, and relationships, so learners can translate a logical model into a working database structure.
This reading describes the end-to-end database design workflow — from gathering business requirements through logical and physical design to writing SQL — helping learners and instructors understand where each activity fits in the overall process.
This reading describes the end-to-end database design workflow — from gathering business requirements through logical and physical design to writing SQL — helping learners and instructors understand where each activity fits in the overall process.