7

Database Fundamentals

The database is your workstation, and you are the architect and keeper of the data as a data engineer. So, it’s essential to thoroughly understand databases, how they work, and all of their subtleties. Beginning with the fundamental foundational concepts, we will gradually move on to more complicated features of databases in this chapter before dissecting these principles via the context of a data engineering interview.

This chapter will walk you through various topics, whether you’re a novice just entering this industry or a seasoned professional trying to brush up on your knowledge. These include database types, normalization, and indexing fundamentals. In a series of common interview questions and responses, we will ...

Get Cracking the Data Engineering Interview now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.