-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Fundamentals of Analytics Engineering
By :

Data comes in many forms, from text and numbers to images and sound clips. Data is stored across diverse platforms, from basic spreadsheets to data warehouses. For example, a spreadsheet that tracks your monthly expenses is a simple form of a database. Yet, spreadsheets cannot protect sensitive data, such as a company’s financials or customer information. They are not secure enough, don’t offer an easy way to retrieve data, and can’t handle large volumes of information (Excel has a limitation of 1 million records). Database systems are designed to tackle these issues. They offer a way to organize, safeguard, and efficiently manage data while supporting various applications. We’ll focus on two of them.
Transactional databases are fine-tuned to handle numerous transaction updates, new entries, and removals while maintaining data integrity and quickly processing each record. They are the go-to for everyday business...