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.
Overview
Syllabus
- 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.
- Cloud Scale Applications
- This week, we'll compare and contrast ACID and BASE style architectures and analyze the impact of first generation cloud applications.
- Elasticsearch
- This week, we'll focus on creating and utilizing an Elasticsearch index in different contexts.
- Wrap Up
Taught by
Charles Russell Severance
