Monthly Subscription Starting at AED 99 + VAT

Database Architecture, Scale, and NoSQL with Elasticsearch
  • Level Professional
  • Duration 10 hours
  • Course by University of Michigan
  • Offered by

About

In this final course, you will explore database architecture, PostgreSQL, and various scalable deployment configurations. You will see how PostgreSQL implements basic CRUD operations and indexes, and review how transactions and the ACID (Atomicity, Consistency, Isolation, Durability) requirements are implemented. You’ll learn to use Elasticsearch NoSQL, which is a common NoSQL database and a supplement to a relational database to high-speed search and indexing. We will examine Elasticsearch as an example of a BASE-style (Basic Availability, Soft State, Eventual Consistency) database approach, as well as compare and contrast the advantages and challenges associated with ACID and BASE databases.

Modules

Lectures

    • 3 Videos
    • 3 Readings
Show info about module content

3 Videos

  • Welcome to the Course
  • Lecture: To SQL or to NoSQL?
  • Scaling Relational Databases

3 Readings

  • Help Us Learn More About You
  • Syllabus
  • Database Architectures - Critical Thinking

Assignments

    • 1 Readings
    • 1 ExternalTool
    • 1 Assignment
Show info about module content

1 Assignment

  • Scaling Databases

1 External Tool

  • Mini-Paper - Scaling Relational Databases

1 Readings

  • Assessment Philosophy

Bonus

    • 2 Videos
Show info about module content

2 Videos

  • Office Hours, Breda, Netherlands
  • Office Hours, Bletchley Park, Milton Keynes, UK

Lectures

    • 5 Videos
    • 3 Readings
Show info about module content

5 Videos

  • First Generation Cloud Applications 1/2
  • First Generation Cloud Applications 2/2
  • Second Generation Cloud Applications
  • The Emergence of BASE Solutions (i.e. NoSQL)
  • Reacting to the Rise of NoSQL

3 Readings

  • Searching / Scatter - Gather (Marissa Mayer @ Google I/O 2008 - YouTube)
  • Google Container Data Center Tour (YouTube)
  • How Search Works (Matt Cutts - YouTube)

Assignments

    • 1 Readings
    • 1 ExternalTool
    • 1 Assignment
Show info about module content

1 Assignment

  • Cloud Architectures

1 External Tool

  • Mini-Paper - ACID versus BASE Architectures

1 Readings

  • About the Mini-Paper

Bonus

    • 2 Videos
Show info about module content

2 Videos

  • Office Hours- Kitchener, Ontario, Canada
  • Office Hours - Mumbai, India (IIT TechFest)

Lectures

    • 5 Videos
Show info about module content

5 Videos

  • Elasticsearch Overview
  • Programming Elasticsearch
  • Demonstration: Loading a Book into Elasticsearch
  • Demonstration: Loading Email into Elasticsearch
  • Demonstration: Elasticsearch Tweets

Assignments

    • 1 Readings
    • 3 ExternalTool
Show info about module content

3 External Tool

  • Elasticsearch Book
  • Elasticsearch Email
  • Elasticsearch Tweets

1 Readings

  • How Elasticsearch Assignments Work

Bonus

    • 2 Videos
Show info about module content

2 Videos

  • Office Hours - Seattle, Washington, USA
  • Office Hours, Phoenix, Arizona, USA

Wrap Up

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Course Wrap Up

1 Readings

  • Post-Course Survey

Auto Summary

Explore the essentials of database architecture, PostgreSQL, and Elasticsearch NoSQL in this professional IT course by Coursera. Over 600 minutes, delve into CRUD operations, ACID transactions, and scalable deployments. Learn the contrasts between ACID and BASE databases, and master high-speed search and indexing with Elasticsearch. Ideal for IT professionals seeking advanced database management skills. Available with a Starter subscription.

Charles Russell Severance
Instructor

Charles Russell Severance