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.
Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.
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.
What You Will 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
Course 4 of 4 in the PostgreSQL for Everybody Specialization
Syllabus
WEEK 1
Scaling Databases
In this first week, we'll introduce you to the topics covered in this course, including the comparison between SQL and NoSQL and scaling relational databases.
WEEK 2
Cloud Scale Applications
This week, we'll compare and contrast ACID and BASE style architectures and analyze the impact of first generation cloud applications.
WEEK 3
Elasticsearch
This week, we'll focus on creating and utilizing an Elasticsearch index in different contexts.
WEEK 4
Wrap Up
