From the course: Implementing a Data Warehouse SQL Server 2019
Join today to access over 25,500 courses taught by industry experts.
Transactional databases vs. data warehouses - SQL Server Tutorial
From the course: Implementing a Data Warehouse SQL Server 2019
Transactional databases vs. data warehouses
- [Instructor] There are two terms that come into play when you start digging into how data warehouses work within the Enterprise. Particularly when you come from the world of traditional relational database theory it's important to understand the difference between OLTP versus OLAP. OLTP stands for Online Transaction Processing. It's a term that describes the traditional role of a database to quickly and efficiently collect and modify records, or what's known as performing a transaction. The goal of OLTP databases is to quickly write data to the database while maintaining strict control over their reliability, consistency, and integrity of the data. This is accomplished by having the data structure follow a normalized relational model where data is spread out across multiple related records. For instance, you might have details about a specific customer stored in one table about their user account, another table that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.