Relating to the Database

Relating to the Database

Joseph Clark
Buy on Leanpub

Table of Contents

Relating to the Database

  • About this book
    • An open-source book
    • Companion videos
    • Structure of chapters
    • Case studies
    • How to use the book
    • Instructors
  • Using Docker to install and run PostgreSQL
  • Chapter 1: Introducing databases and PostgreSQL
    • How databases fit in
    • Lab 1: your first PostgreSQL database
    • Summary
    • Challenges
  • Chapter 2: The Relational Model
    • There are other data models
    • Theoretical roots
    • A relational database is a database of relations
    • Lab 2: Creating and querying a relational database
    • Summary
    • Summary
    • Challenges
  • Chapter 3: Querying the data
    • A declarative query language
    • Relational operations
    • Queries within queries
    • Lab
  • Normalizing a data model
  • More relational patterns
  • Logic in the database
  • Advanced PostgreSQL tricks
  • Just enough physical database design
  • Dimensional modeling for analytics
  • Databases in the cloud
  • Appendix A: Installing PostgreSQL and accessing it from the command line
    • Setting up PostgreSQL in Windows 10
    • Setting up PostgreSQL on a Mac
    • Setting up PostgreSQL in Linux
  • About the Author
Relating to the Database/overview

Relating to the Database

course_overview

A no-nonsense introduction to relational databases for use as a textbook or for self-study.

count_chapters
begin_reading
download
p_implied_book_part_name

Relating to the Database14 chapters

Begin ›
  1. About this book

  2. Using Docker to install and run PostgreSQL

  3. Chapter 1: Introducing databases and PostgreSQL

  4. Chapter 2: The Relational Model

  5. Chapter 3: Querying the data

  6. Normalizing a data model

  7. More relational patterns

  8. Logic in the database

  9. Advanced PostgreSQL tricks

  10. Just enough physical database design

  11. Dimensional modeling for analytics

  12. Databases in the cloud

  13. Appendix A: Installing PostgreSQL and accessing it from the command line

  14. About the Author