This course is part of the PostgreSQL for Everybody Specialization

4.3
stars
80 ratings

Charles Russell Severance

6,354 already enrolled

Offered By

PostgreSQL for Everybody SpecializationUniversity of Michigan

About this Course

11,339 recent views

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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 4 of 4 in the

PostgreSQL for Everybody Specialization

Intermediate Level

Completion of first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python

Approx. 10 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

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

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 4 of 4 in the

PostgreSQL for Everybody Specialization

Intermediate Level

Completion of first two courses in the Python for Everybody specialization or an equivalent basic understanding of Python

Approx. 10 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.62/5 (16 Ratings)

Charles Russell Severance

Clinical Professor

School of Information

3,772,695 Learners

56 Courses

Offered by

University of Michigan

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week1

Week 1

3 hours to complete

Scaling Databases

3 hours to complete

5 videos (Total 44 min), 4 readings, 2 quizzes

Week2

Week 2

3 hours to complete

Cloud Scale Applications

3 hours to complete

7 videos (Total 68 min), 4 readings, 2 quizzes

7 videos

First Generation Cloud Applications 1/210mFirst Generation Cloud Applications 2/2 13mSecond Generation Cloud Applications8mThe Emergence of BASE Solutions (i.e. NoSQL)12mReacting to the Rise of NoSQL17mOffice Hours- Kitchener, Ontario, Canada2mOffice Hours - Mumbai, India (IIT TechFest)2m

4 readings

Searching / Scatter - Gather (Marissa Mayer @ Google I/O 2008 - YouTube)10mGoogle Container Data Center Tour (YouTube)10mHow Search Works (Matt Cutts - YouTube)10mAbout the Mini-Paper10m

1 practice exercise

Cloud Architectures30m

Week3

Week 3

4 hours to complete

Elasticsearch

4 hours to complete

7 videos (Total 46 min), 1 reading, 3 quizzes

Week4

Week 4

6 minutes to complete

Wrap Up

6 minutes to complete

1 video (Total 1 min), 1 reading

Reviews

4.3

22 reviews

5 stars
60%
4 stars
23.75%
3 stars
7.50%
2 stars
2.50%
1 star
6.25%

TOP REVIEWS FROM DATABASE ARCHITECTURE, SCALE, AND NOSQL WITH ELASTICSEARCH

by IRMay 24, 2021

Excellent course, very good teacher, masters the subject.

by WZMar 15, 2023

This class is very helpful. Professor not only taught technologies, he also told the scenarios and stories. This make me to understand what and why much easier. Thanks for the excellent class!

by AVJul 16, 2021

Excellent course. I knew a littel SQL before the course but this class has greatly improved my knowledge of not only SQL, but Postgresql knowledge, and overall database systems and design.

by CGMay 23, 2021

Very Good Course and Help me refresh my SQL Database knowledge and give me new knowledge in NoSQL area.

View all reviews

About the PostgreSQL for Everybody Specialization

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Database Architecture, Scale, and NoSQL with Elasticsearch

About this Course

What you will learn