data academy
![Demystifying the transactional database](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/636a8aa08e6f9e82d8eba24f_Transactional%20Database.png)
Demystifying the transactional database
Transactional databases are essential to many apps and software. Learn more about them and their benefits with Fivetran.
![Build vs. buy data pipelines: Costs to consider](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/65f8925fe358e001e97ba996_Build%20vs.%20buy%20data%20pipelines_%20Costs%20to%20consider.png)
Build vs. buy data pipelines: Costs to consider
A few simple calculations illustrate why it's ill-advised to build your own data pipeline.
![The modern data science stack](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/61919538767c35ca149905e3_6133a1c7a488ba4b8f284790_featured_blog-mdss.png)
The modern data science stack
Automated data integration can help you jump-start your machine learning efforts.
![What is the architecture of automated data integration?](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/61aa81984c11109890b1307c_2021-12-03_20h44_01.jpg)
What is the architecture of automated data integration?
Automated data integration depends on several key concepts.
![Announcing the Modern Data Stack Boot Camp](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/6191951494e4100bb0e898d9_6133a2880fd5a07286c88d2d_featured_bootcamp.png)
Announcing the Modern Data Stack Boot Camp
Learn how to set up a modern data stack and transform your analytics in three steps.
![Databases Demystified Chapter 10 – Query Planning and Optimization](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/6191950c42545a29afca3b36_6133a29950bc6fd9b367edf8_featured_2009-db-demystified_Chapter10.png)
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](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/6191950f65c3fd827dae0605_6133a292bd95a1e333b8f3d9_featured_2008-dd-_Chapter9.png)
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](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/6191950a7528a16d9eb388db_6133a29ee072d70de1a0bd37_featured_2008-dd-_Chapter8.png)
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](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/61919509756c4cceeee7b03a_6133a2a06761dec281844d82_featured_2008-dd-_Chapter7.png)
Databases Demystified Chapter 7 – Distributed Databases Part 2
Distributed databases are powerful, but they come with lots of complications.
![Databases Demystified Chapter 5 – Transactions Part 2](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/61919512130a2b8708383274_6133a28c4d5daacfdfbfcb00_featured_2008-dd-_Chapter5.png)
Databases Demystified Chapter 5 – Transactions Part 2
Learn about the relationship between isolation and concurrency.
![Databases Demystified Chapter 4 – Transactions Part 1](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/6191950d767c3588e6990435_6133a2971db83af664f92d8d_featured_2008-dd-_Chapter4.png)
Databases Demystified Chapter 4 – Transactions Part 1
Take a deep dive into transactional databases.
![Databases Demystified Chapter 3 – Row Store vs. Column Store](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/619195063a8d5aa67506a426_6133a2a68b0c547ac6edd9b8_featured_2008-dd-_Chapter3.png)
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 1 – Databases and SQL](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/619195103a8d5aeb9206a42d_6133a290c59af550ebbf2e1f_featured_2008-dd-_Chapter1.png)
Databases Demystified Chapter 1 – Databases and SQL
Learn about the history of databases, important terminology, and different types of databases you might encounter.
![What is idempotence?](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/619194e4abb00310abd322ff_6133a2d24cee2c12a26d37c1_featured_2008-blogs_idempotence-abstract.png)
What is idempotence?
Idempotence is an important characteristic of many systems, including Fivetran. Here's what it means.
![Drizly uses analytics to deliver what customers want](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/619194d4767c35671a990147_6133a2f17d14b1e7913c9ffc_featured_2008-blog_analytics_20with_20drizly.png)
Drizly uses analytics to deliver what customers want
With the right data, Drizly can more easily connect customers with their favorite beverages.
![Three kinds of metrics GitHub data can answer](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/619194de94e41022d1e89851_6133a2df3e88926b2b8d83e3_featured_github.png)
Three kinds of metrics GitHub data can answer
Data from GitHub can help your engineers quantify how they are doing.
![Five dashboards to jump-start your analytics](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/619194e3514f50499c289ba0_6133a2d5ae21bddcb44f9449_featured_dashboards-blogcard.png)
Five dashboards to jump-start your analytics
Consider building these dashboards that help answer essential business questions.
![How no-code empowers non-engineers without sacrificing data and analytics](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/619194d8d1875017cc7c7f9e_6133a2eb2122c11b64fb0b7a_featured_2007_no-maintenance.png)
How no-code empowers non-engineers without sacrificing data and analytics
You don’t have to build all of the systems that support your business functions.
![Use Fivetran to sync any unsupported source](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/619194d5514f50daab289b9a_6133a2ef814796d1deb9ce04_featured_2007_cloud-functions.png)
Use Fivetran to sync any unsupported source
Learn how Fivetran cloud function connectors can pull data when there is no prebuilt connector.
![Why you need automated schema migration](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/6191942cebd9a281f4f69be1_6133a27fc78755fef4fc99d8_sized_2F1920_9999_100_2F2006-blog_automated_20schema_20migrations.png)
Why you need automated schema migration
Schema changes can completely disrupt a data pipeline. Automated data integration offers a solution.
![How to organize your analytics team](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/619193fbe6b961835cb6e007_6133a4e209a5f548cf4761b4_featured_2006-blog_analytics-teams_analytics-teams.png)
How to organize your analytics team
People and processes matter as much as your technology stack.
![How to migrate your enterprise data warehouse to a cloud data warehouse](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/61919543d6736dab05c74d51_6133a1af9346770481d175b6_featured_2005-blogs_migrate-cloud.png)
How to migrate your enterprise data warehouse to a cloud data warehouse
The modern data stack lives in the cloud. Here are the steps you'll need to take to migrate your on-prem system.
![The definitive glossary of data integration terms](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/6191953230687d4f59bac4b5_6141de13d3a45c5c7f6c2709_6133a1d2148cd35720ac79e1_featured_2005-blog_data-glossary.png)
The definitive glossary of data integration terms
New to analytics? Don’t know what an ERD is? Read this comprehensive list of important data integration terms.
![How Fivetran built its Klaviyo connector](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/6191947eebd9a22fb3f69bf3_6133a42a0fd5a0d8efc91495_featured_2005-blog_klaviyo.png)
How Fivetran built its Klaviyo connector
The process of building a connector is inextricably linked with schema design.
Kostenlos starten
Schließen auch Sie sich den Tausenden von Unternehmen an, die ihre Daten mithilfe von Fivetran zentralisieren und transformieren.