Clinical Professor, School of Information
Database Architecture and NoSQL at Scale with Deno
What You'll Learn
- Understand PostgreSQL architecture; analyze and compare SQL and NoSQL
- Compare and contrast ACID and BASE style architectures and databases
- Create and utilize an Elasticsearch index in different contexts
4 Modules
12 Hours
3 hrs per module (approx.)
Rating
About Database Architecture and NoSQL at Scale with Deno
In this final course of the PostgreSQL for Everybody specialization, you’ll explore how modern databases are built and scaled. You’ll begin by examining PostgreSQL’s architecture, including how it implements CRUD operations, indexing, transactions, and ACID (Atomicity, Consistency, Isolation, Durability) guarantees.
Then you’ll shift to NoSQL systems using the Deno environment. You’ll learn how Deno implements a distributed Key-Value store and how it applies BASE (Basic Availability, Soft State, Eventual Consistency) principles. Through hands-on projects, you’ll deploy your own Deno KV service on Deno’s global infrastructure and build a Deno client to interact with it. By the end, you’ll understand the design tradeoffs between ACID and BASE databases and gain practical experience deploying and scaling both relational and NoSQL systems.
Skills You'll Gain
- Database Architecture
- Database Design
- Data Management
- NoSQL
What You'll Earn
- Certificate of Completion:
- Certificates of completion acknowledge knowledge acquired upon completion of a non-credit course or program.
Welcome Message
Database Architecture and NoSQL at Scale with Deno, the final course in the PostgreSQL for Everybody series, learn how PostgreSQL handles CRUD operations, indexing, transactions, and ACID guarantees. You’ll explore NoSQL with Deno, gain hands-on experience with both relational and NoSQL systems, understand the tradeoffs between ACID and BASE models, and master the skills needed to design, deploy, and scale databases in real-world applications..
This abbreviated syllabus description was created with the help of AI tools and reviewed by staff. The full syllabus is available to those who enroll in the course.
Course Schedule
Module 1: Scaling Databases
- Video: Welcome to the Course
- Reading: Help Us Learn More About You
- Reading: Syllabus
- Reading: Database Architectures - Critical Thinking
- Video: Lecture: To SQL or to NoSQL?
- Video: Scaling Relational Databases
- Reading: Assessment Philosophy
- Video: Office Hours, Breda, Netherlands
- Video: Office Hours, Bletchley Park, Milton Keynes, UK
- Graded: Scaling Databases
- Graded: Mini-Paper - Scaling Relational Databases
Module 2: Cloud Scale Applications
- Video: First Generation Cloud Applications 1/2
- Reading: Searching / Scatter - Gather (Marissa Mayer @ Google I/O 2008 - YouTube)
- Reading: Google Container Data Center Tour (YouTube)
- Reading: How Search Works (Matt Cutts - YouTube)
- Video: First Generation Cloud Applications 2/2
- Video: Second Generation Cloud Applications
- Video: The Emergence of BASE Solutions (i.e. NoSQL)
- Video: Reacting to the Rise of NoSQL
- Reading: About the Mini-Paper
- Video: Office Hours- Kitchener, Ontario, Canada
- Video: Office Hours - Mumbai, India (IIT TechFest)
- Graded: Cloud Architectures
- Graded: Mini-Paper - ACID versus BASE Architectures
Module 3 - DenoKV
- Reading: DenoKV Online Resources
- Video: Intro to Deno and Deno KV
- Video: Exploring Deno KV Architecture Through B-Trees
- Video: JavaScript in Three Slides (For Python Developers)
- Video: Exploring CRUD in Deno KV Using KVAdmin.py
- Video: Building a Deno KV Model with Secondary Indexes
- Video: Code Walkthrough: Installing KVAdmin.py Client and Server on Deno Deploy
- Video: Code Walkthrough - KVAdmin.py Client and Server
- Video: Office Hours - Seattle, Washington, USA
- Video: Office Hours, Phoenix, Arizona, USA
- Graded: Autograder: DenoKV and KVAdmin Install
- Graded: Autograder: DenoKV Insert Text
- Graded: Autograder: DenoKV Book Data Model
Module 4: Wrap Up
- Video: Course Wrap Up
Grading Policy
There are seven assignments in this course, ranging in weight from 10% of your final grade to 25% of your final grade.
Intermediate Level
Completion of first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python
