In this fourth and final course in PostgreSQL for Everybody, learners will explore databses architectures, CRUD operations and how ACID requirements are implemented in PostgreSQL. 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.
Class Deals by MOOC List - Click here and see EdX'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.
This course is part of the PostgreSQL for Everybody Professional Certificate.
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