Structural Differences Between OLTP and OLAP Systems
In one of my previous articles, we discussed the main differences between OLTP (Online Transaction Processing) and OLAP (Online...
top of page
Jul 86 min read
Ace Your SQL Interview: Top 9 Must-Know Questions and Answers
This article report the most common SQL interview questions to help anyone who want to work in data related job to ace the interview.
3 views0 comments
Jul 44 min read
Data Warehouse Schemas Explained: Star, Snowflake, Galaxy
Unlock the secrets of Star, Snowflake, and Galaxy schemas in data warehousing. Enhance your data analysis skills with our latest article!
63 views0 comments
Jun 264 min read
OLTP vs OLAP: An Introduction to Database Systems
This is an introduction to Database systems in which I have explored the main differences between an OLTP and OLAP system
11 views0 comments
Jun 17 min read
SQL’s components — DDL, DML, DCL and TCL
Although the vendors of relational database management system have their own implemented version of the SQL language, exist anyway an...
10 views0 comments
Jun 13 min read
Introduction to a relational database (SQL)
A relational database is a collection of data elements with predefined relations between them. These elements are represented in the...
4 views0 comments
bottom of page