Database Architecture, Scale, and NoSQL with Elasticsearch

About

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.

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

Skills you learn

• Atomicity Consistency Isolation Durability (ACID)
• SQL (Programming Language)
• NoSQL
• Scalability
• Database Architecture
• PostgreSQL
• Operations
• Elasticsearch
• Relational Databases

Auto Summary

Discover the intricacies of database architecture and scalability with a focus on PostgreSQL and Elasticsearch NoSQL. This course delves into CRUD operations, indexing, and ACID transactions, contrasting them with the BASE database approach. Offered by edX, it's ideal for IT and Computer Science professionals seeking to enhance their knowledge. Suitable for awareness-level learners, it provides professional subscription options for flexible learning.