Curriculum

11 Chapters · 11 Lessons

  1. 1

    Free Preview

    1. Free Preview Free preview
  2. 2

    Chapter 1: Organize or Die: Learning from Data

    1. (Included in full purchase)

      Organize or Die: Learning from Data

  3. 3

    Chapter 2: Brief Overview of Relational Model

    1. (Included in full purchase)

      Brief Overview of Relational Model

  4. 4

    Chapter 3: Data Modeling and Normalization

    1. (Included in full purchase)

      Data Modeling and Normalization

  5. 5

    Chapter 4: Learning About Normalization

    1. (Included in full purchase)

      Learning About Normalization

  6. 6

    Chapter 5: Beginning with SQL

    1. (Included in full purchase)

      Beginning with SQL

  7. 7

    Chapter 6: Intermediate SQL Part 1

    1. (Included in full purchase)

      Intermediate SQL Part 1

  8. 8

    Chapter 7: Intermediate SQL Part 2

    1. (Included in full purchase)

      Intermediate SQL Part 2

  9. 9

    Chapter 8: Putting it All Together

    1. (Included in full purchase)

      Putting it All Together

  10. 10

    ADDENDUM Case Study Quick-Serve Retail Coffee Shop

    1. (Included in full purchase)

      ADDENDUM Case Study Quick-Serve Retail Coffee Shop

  11. 11

    Index

    1. (Included in full purchase)

      Index

About the Course

Ultimate SQL for Relational Database Design guides readers step by step from understanding why structured data matters to building and querying fully functional relational databases. The book begins with the foundations of data organization and the relational model, establishing how tables, keys, and relationships support accurate and scalable systems. The book then walks through Normalization from Unstructured Data (UNF) to Third Normal Form (3NF), showing how to eliminate redundancy, enforce data integrity, and design databases optimized for performance. You transition into hands-on SQL development—using Data Definition Language (DDL) to create and modify schemas, followed by Data Manipulation Language (DML) to retrieve, insert, update, and delete data effectively. The journey concludes with intermediate SQL techniques—including joins, grouping, filtering, and built-in functions—before integrating all concepts into a comprehensive case study so that the readers can confidently design, implement, and query relational databases from scratch.

About the Author

Gregory Thomas Hay holds a master’s degree in Information Management from the University of Washington and has accumulated various technical certifications since 1992. In a career spanning more than 26 years, Gregory has experience as an employee or contractor at several prominent companies in the greater Seattle metropolitan region, including Microsoft, Walt Disney Internet Group, and the Bill and Melinda Gates Foundation.