top of page
Jul 24, 20243 min read
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...
1 view0 comments
Jul 8, 20246 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 4, 20244 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!
146 views0 comments
Jun 26, 20244 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
12 views0 comments
Jun 1, 20247 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 1, 20243 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...
5 views0 comments
bottom of page