Slowly Changing Dimensions in Data Science
Avoiding a common pitfall in data science by enabling history mode.
Star Schema vs. OBT for Data Warehouse Performance
Michael Kaminsky of Gradient Metrics takes us through a benchmark comparison of data architectures.
The Modern Data Science Stack
Automated data integration can help you jump-start your machine learning efforts.
Databases Demystified Chapter 10 – Query Planning and Optimization
Take a look under the hood to learn how you can help databases execute queries more efficiently.
Databases Demystified Chapter 9 – Indexes
Indexes aren’t just for catalogs or textbooks. Learn how indexes make queries faster.
Databases Demystified Chapter 8 – Distributed Databases Part 3
What is “consensus,” and what does it have to do with distributed databases?
Databases Demystified Chapter 7 – Distributed Databases Part 2
Distributed databases are powerful, but they come with lots of complications.
Databases Demystified Chapter 6 – Distributed Databases Part 1
What is the difference between distributed and single-node databases?
Databases Demystified Chapter 5 – Transactions Part 2
Learn about the relationship between isolation and concurrency.
Databases Demystified Chapter 4 – Transactions Part 1
Take a deep dive into transactional databases.
Databases Demystified Chapter 3 – Row Store vs. Column Store
Take a closer look at the differences in architecture between row- and column-based databases
Databases Demystified Chapter 2 – Analytical vs. Transactional Databases
Learn about the differences between databases designed to perform day-to-day operations and those designed for analyzing data.
Databases Demystified Chapter 1 – Databases and SQL
Learn about the history of databases, important terminology, and different types of databases you might encounter.
Start analyzing your data in minutes, not months
Launch any Fivetran connector instantly.