From the course: Implementing a Data Warehouse with SQL Server 2022
Join today to access over 24,900 courses taught by industry experts.
Transactional DBs vs. data warehouses - SQL Server Tutorial
From the course: Implementing a Data Warehouse with SQL Server 2022
Transactional DBs 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 transactional 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 the 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 related tables. For instance, you might have the details about a specific customer stored in one table about their user account, another table that stores…
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.