Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Database Design for Data Engineers

This course will teach you the concepts and best practices for database design spanning relational, non-relational, graph, doc, key-value, and semi-relational, and the architectures, formats, and real-world considerations of each approach.

Russ Thomas - Pluralsight course - Database Design for Data Engineers
by Russ Thomas

What you'll learn

We live in the era of data. As a data engineer, you are expected to gather data from any number of sources and store it where it can be reliably, consistently, and easily accessed by a wide variety of end users. Database design is too important of a discipline to be anything other than deliberate.

In this course, Database Design for Data Engineers, you’ll gain the ability to objectively assess the data you have as well as the requirements and outcomes needed, and properly develop your database design approach to run efficiently, reliably, and securely.

First, you’ll explore relational data and ACID concepts, the key benefits and properties that define each relational approach, and the limitations and restrictions of each design approach.

Next, you’ll discover the variety of non-relational approaches to data storage, how new capabilities blur the lines that used to define what a non-relational database could do, tradeoffs of the CAP theorem, and other important concepts for making design decisions such as schema flexibility and scalability.

Finally, you’ll learn how to implement your design with confidence, and gain further confidence in securing your databases while addressing data integrity, data consistency, and the overall quality of your database.

When you’re finished with this course, you will have the skills and knowledge of essential database design concepts to confidently assess your data and make design decisions that will scale, perform, and reliably meet the needs of your organization.

Table of contents

About the author

Russ Thomas - Pluralsight course - Database Design for Data Engineers
Russ Thomas

Currently an IT leader in Denver Colorado's financial sector Russ has focused on database development, modelling, administration, and BI since 1997 across the Microsoft stack. Russ is a passionate trainer and SQL community volunteer presenting regularly at PASS SQL Saturday events and local user groups around the US.

More Courses by Russ