Exploring and Using Database Architecture, Scale, and NoSQL with Elasticsearch


Deal Score+3



Expand your understanding and knowledge of database architecture, and learn when to use which models.

Join Other Email Learners

Follow the guide on landing page

About This Course

In this final installment of the University of Michigan series on PostgreSQL and Python programming language, you’ll not only learn more about this SQL but will also get to explore a NoSQL database management system.

Over the three weeks of the course, you’ll learn to use Elasticsearch (a common NoSQL database), and examine Elasticsearch as an example of a BASE (basic availability soft-state consistency) database approach.

You’ll also look at the differences between SQL and NoSQL data management systems, and between ACID (atomicity consistency isolation durability) and BASE database styles. Ultimately, you’ll be equipped to work with any database architecture.

Understand the differences in database architecture

You’ll move beyond seeing how PostgreSQL implements CRUD operations in Python programming language, and will analyse and compare the differences, pros and cons of SQL and NoSQL.

As you explore Elasticsearch in more detail, you’ll also see how it can supplement a relational database management system (RDBMS) like PostgreSQL and be used to facilitate high-speed searches and indexing.

Compare ACID and BASE styles

The biggest distinction between ACID and BASE styles is that ACID architecture provides more system consistency, while BASE architecture delivers higher availability.

On this course you’ll learn how this and other differences are built into the structures of these models, and how to evaluate whether an ACID or BASE system is right for specific situations.

Syllabus

  • Week 1

Scaling Databases

  • Week 2

Cloud Scale Applications

  • Week 3

Elasticsearch

Learning on this course

You can take this self-guided course and learn at your own pace. On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.

What will you achieve?

By the end of the course, you‘ll be able to…

  • Investigate the PostgreSQL architecture, and analyse and compare SQL and NoSQL
  • Compare and contrast ACID and BASE style architectures and databases
  • Create and utilise an Elasticsearch index in different contexts

Who is the course for?

This course is designed for anyone with a background in Python programming language who would like to develop their PostgreSQL skills and database architecture knowledge.

Free Course on Exploring and Using Database Architecture, Scale, and NoSQL with Elasticsearch


DISCLAIMER: Courses on Future Syllabus are free but subject to return to their original prices on host platforms upon coupon expiration. Enrol while they are free. To report any error, use the "Further Actions" tab.




Show full profile

Editor

Mass Communication Student, Federal University, Oye Ekiti and Content Creation Specialist. Join me on Twitter.

Stay active

Leave a Reply

Future Syllabus
Logo
Register New Account
Login/Register via your social accounts (fully secured)

or proceed manually
Reset Password