Advanced Topics and Future Trends in Database Technologies

Advanced Topics and Future Trends in Database Technologies

This course is part of Databases for Data Scientists Specialization

Instructors: Di Wu

Access provided by SmartStream

8,771 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

79 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

79 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

In-depth and advanced areas of database technologies
The future of database software and where the industry is heading
Understand and differentiate four leading NoSQL implementations: MongoDB, Cassandra, Redis, Neo4j.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 assignments

Taught in English

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

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Databases for Data Scientists Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 4 modules in this course

This course consists of four modules covering some of the more in-depth and advanced areas of database technologies, followed by a look at the future of database software and where the industry is heading.

Advanced Topics and Future Trends in Database Technologies can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform. The MS-DS is an interdisciplinary degree that brings together faculty from CU Boulder’s departments of Applied Mathematics, Computer Science, Information Science, and others. With performance-based admissions and no application process, the MS-DS is ideal for individuals with a broad range of undergraduate education and/or professional experience in computer science, information science, mathematics, and statistics. Learn more about the MS-DS program at https://www.coursera.org/degrees/master-of-science-data-science-boulder.

In this module we will take a deeper look into the internals of DBMS software to better understand how it works. We will examine the role of the DBA (Database Administrator), the Data Scientist, the Data Architect, and other career paths in the realm of database technologies. This module covers DBMS essentials such as concurrency management, backup & recovery, and transaction logging.

What's included

6 videos2 readings3 assignments1 peer review1 discussion prompt

6 videos Total 95 minutes

Module 1 - Welcome and Introduction 3 minutes
Transaction Logs: Part 1 18 minutes
Transaction Logs: Part 2 15 minutes
Database Backup and Recovery 19 minutes
Database Concurrency 25 minutes
Careers in Database Technologies 16 minutes

2 readings Total 20 minutes

Earn Academic Credit for your Work! 10 minutes
Course Support 10 minutes

3 assignments Total 90 minutes

Transaction Logs 30 minutes
Database Backup and Recovery 30 minutes
Database Concurrency 30 minutes

1 peer review Total 120 minutes

Exploring Careers in Database Technologies 120 minutes

1 discussion prompt Total 10 minutes

Introduce Yourself! 10 minutes

We have learned to design a Relational Database around the typical transactions or activities a business might have. However, in case we need to analyze data, rather than collect data, we need to create a database for the subject of interest to support decision making. In this module, we are going to learn a different perspective of organizing the data, Data Warehouse, or Online Analytical Processing.

What's included

5 videos1 peer review

We are in the era of data explosion. While relational databases are still widely used, we are having new problems to deal with data that is different than the one we have been organizing. This new type of data, with 10 V's in the definition, is called Big Data. We are going to explore the definitions, the challenges, and the architecture of the Big Data in this module.

What's included

4 videos1 peer review

Although relational database software has been in use for decades, relational database systems still command a huge share of the database software marketplace. However, with the more recent explosion of Big Data, relational systems are struggling to keep up. Big Data has opened the door for non-relational database solutions ("NoSQL") to capture marketshare from relational systems. In this module we will take a deeper look into the most popular NoSQL database technologies.

What's included

6 videos2 assignments1 peer review

6 videos Total 106 minutes

The Relational Problem: Part 1 14 minutes
The Relational Problem: Part 2 18 minutes
NoSQL Systems: Part 1 10 minutes
NoSQL Systems: Part 2 20 minutes
MongoDB Overview and Demo 28 minutes
Cassandra Overview and Demo 17 minutes

2 assignments Total 60 minutes

The Relational Problem 30 minutes
NoSQL Systems 30 minutes

1 peer review Total 120 minutes

Solving the Relational Problem 120 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Build toward a degree

This course is part of the following degree program(s) offered by University of Colorado Boulder. If you are admitted and enroll, your completed coursework may count toward your degree learning and your progress can transfer with you.¹