SQL Tutorial: OLTP and OLAP
Want to learn more? Take the full course at https://learn.datacamp.com/courses/database-design at your own pace. More than a video, you'll learn hands-on coding & quickly apply skills to your daily work.
---
Hello! My name is Lis, I'm a Curriculum Manager here at DataCamp.
In this course, we'll be talking about database design. So, what does that entail exactly?
To put it simply, in this course we're asking the question: How should we organize and manage data?
To answer this, we have to consider the different schemas, management options, and objects that make up a database. Some examples are listed here, and they are covered throughout the course.
These topics all affect the way data is stored and accessed. Some enable faster query speeds. Some take up less memory than others. And notably, some cost more money than others.
And as we will soon find out in this course, there is no one right answer to this motivating question. It will come down to how the data will be used.
Okay, let's dive in.
OLTP and OLAP are approaches to processing data, and they will be referenced throughout this course.
They help define the way data is going to flow, be structured, and stored. If you figure out which fits your business case, designing your database will be much easier.
OLTP stands for Online Transaction Processing.
OLAP stands for Online Analytical Processing.
As the names hint, the OLTP approach is oriented around transactions, while the other is oriented around analytics.
Before going into formal definitions, let's look at some use cases of each.
Say you are in charge of data management at a bookstore. You would use an OLTP approach to keep track of the prices of books, while to analyze the most profitable books, an OLAP approach would be more appropriate.
To keep track of all customer transactions, you would use an OLTP approach to insert sales as customers finish paying. However, if you wanted to do sophisticated analysis on sales, like most loyal customers - y
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from DataCamp · DataCamp · 55 of 60
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
▶
56
57
58
59
60
SQL Server Tutorial: Date manipulation
DataCamp
R Tutorial: Intermediate Interactive Data Visualization with plotly in R
DataCamp
R Tutorial: Adding aesthetics to represent a variable
DataCamp
R Tutorial: Moving Beyond Simple Interactivity
DataCamp
Python Tutorial: Why use ML for marketing? Strategies and use cases
DataCamp
Python Tutorial: Preparation for modeling
DataCamp
Python Tutorial: Machine Learning modeling steps
DataCamp
R Tutorial: The prior model
DataCamp
R Tutorial: Data & the likelihood
DataCamp
R Tutorial: The posterior model
DataCamp
R Tutorial: An Introduction to plotly
DataCamp
R Tutorial: Plotting a single variable
DataCamp
R Tutorial: Bivariate graphics
DataCamp
Python Tutorial: Customer Segmentation in Python
DataCamp
Python Tutorial: Time cohorts
DataCamp
Python Tutorial: Calculate cohort metrics
DataCamp
Python Tutorial: Cohort analysis visualization
DataCamp
R Tutorial: Building Dashboards with flexdashboard
DataCamp
R Tutorial: Anatomy of a flexdashboard
DataCamp
R Tutorial: Layout basics
DataCamp
R Tutorial: Advanced layouts
DataCamp
Python Tutorial: Time Series Analysis in Python
DataCamp
Python Tutorial: Correlation of Two Time Series
DataCamp
Python Tutorial: Simple Linear Regressions
DataCamp
Python Tutorial: Autocorrelation
DataCamp
R Tutorial: The gapminder dataset
DataCamp
R Tutorial: The filter verb
DataCamp
R Tutorial: The arrange verb
DataCamp
R Tutorial: The mutate verb
DataCamp
R Tutorial: What is cluster analysis?
DataCamp
R Tutorial: Distance between two observations
DataCamp
R Tutorial: The importance of scale
DataCamp
R Tutorial: Measuring distance for categorical data
DataCamp
Python Tutorial: Plotting multiple graphs
DataCamp
Python Tutorial: Customizing axes
DataCamp
Python Tutorial: Legends, annotations, & styles
DataCamp
Python Tutorial: Introduction to iterators
DataCamp
Python Tutorial: Playing with iterators
DataCamp
Python Tutorial: Using iterators to load large files into memory
DataCamp
SQL Tutorial: Introduction to Relational Databases in SQL
DataCamp
SQL Tutorial: Tables: At the core of every database
DataCamp
SQL Tutorial: Update your database as the structure changes
DataCamp
Python Tutorial: Classification-Tree Learning
DataCamp
Python Tutorial: Decision-Tree for Classification
DataCamp
Python Tutorial: Decision-Tree for Regression
DataCamp
Python Tutorial: Census Subject Tables
DataCamp
Python Tutorial: Census Geography
DataCamp
Python Tutorial: Using the Census API
DataCamp
R Tutorial: A/B Testing in R
DataCamp
R Tutorial: Baseline Conversion Rates
DataCamp
R Tutorial: Designing an Experiment - Power Analysis
DataCamp
R Tutorial: Introduction to qualitative data
DataCamp
R Tutorial: Understanding your qualitative variables
DataCamp
R Tutorial: Making Better Plots
DataCamp
SQL Tutorial: OLTP and OLAP
DataCamp
SQL Tutorial: Storing data
DataCamp
SQL Tutorial: Database design
DataCamp
Python Tutorial: Introduction to spaCy
DataCamp
Python Tutorial: Statistical Models
DataCamp
Python Tutorial: Rule-based Matching
DataCamp
Related AI Lessons
⚡
⚡
⚡
⚡
Growth Isn’t a Straight Line: My Journey Through UC Berkeley’s MIDS and the Art of the Pivot
Medium · Data Science
A Simple Guide to Building Phylogenetic Trees and Heatmaps in R
Medium · Python
The Over-Engineered Solution Was Never the Real Problem
Dev.to · ruth mhlanga
The Assumption That Cost Retailers Millions: Income Has Nothing To Do With Spending
Medium · Python
🎓
Tutor Explanation
DeepCamp AI