MichiganX: Database Architecture, Scale, and NoSQL with Elasticsearch
In this fourth and final course in PostgreSQL for Everybody, learners will explore database architectures, CRUD operations and how ACID requirements are implemented in PostgreSQL. Learners will compare how to scale SQL and NoSQL database services and build NoSQL applications using ElasticSearch.
Learning Journey Context
Works well as a continuation after mastering Computer Science fundamentals. It bridges the gap toward advanced, production-level engineering.
Relevant for professionals pursuing roles within Computer Science.
Quick Facts
What You’ll Learn
Within this 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.
Outcomes
- 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.
FAQs
Top Alternatives
Highly-rated courses worth your attention
