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/Databases in the cloud

Databases in the cloud

coming soon

Up next

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

In this chapter

  • Databases in the cloud