Duration
3 weeksWeekly study
2 hours
Database Architecture, Scale, and NoSQL with Elasticsearch
Other courses you might like
This course isn't running right now. We can email you when it starts again, or check out these other courses you might like.
Browse more in IT & Computer Science
Explore and use SQL, NoSQL, and ACID and BASE style architectures
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.
Let seasoned experts help you take your programming career further
The University of Michigan will support you at every stage of your learning journey. With exceptional academic support and experienced educators, you can trust that this course will help you take your programming career to new heights.
Syllabus
Week 1
Scaling Databases
Welcome
Welcome to the course!
Lectures
This week, we introduce SQL vs NoSQL and scaling relation databases.
Assignments
Assignment content for week 1.
Week Wrap-up
Wrapping up the week.
Week 2
Cloud Scale Applications
Lectures
This week introduces the impact of first generation cloud applications and compares both ACID and BASE style architectures.
Assignments
Assignment content for week 2.
Week Wrap-up
Wrapping up the week.
Week 3
Elasticsearch
Lectures
This final week's lectures will focus on Elasticsearch and utilizing it in different scenarios.
Assignments
Assignment content for week 3.
Week Wrap-up
Wrapping up the week.
Wrap-up
Wrapping up this course!
Learning on this course
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.
Who will you learn with?
Charles is a Clinical Professor and teaches in the School of Information at the University of Michigan. He is the Chair of the Sakai Project Management Committee (PMC).
Who developed the course?
Established
1817Location
Ann Arbor, Michigan, USAWorld ranking
Top 30Source: Times Higher Education World University Rankings 2020
Learning on FutureLearn
Your learning, your rules
- Courses are split into weeks, activities, and steps to help you keep track of your learning
- Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
- Stay motivated by using the Progress page to keep track of your step completion and assessment scores
Join a global classroom
- Experience the power of social learning, and get inspired by an international network of learners
- Share ideas with your peers and course educators on every step of the course
- Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others
Map your progress
- As you work through the course, use notifications and the Progress page to guide your learning
- Whenever you’re ready, mark each step as complete, you’re in control
- Complete 90% of course steps and all of the assessments to earn your certificate
Want to know more about learning on FutureLearn? Using FutureLearn