Data Ware House Concepts





Data Formats :

Structured (csv, excel..etc)
Semi-Structured (json, xml) 
un-structured (mp3, mp4)

   

OLAP(Online Analytical Processing)


OLTP(Online Transactional Processing)





OLTP vs OLAP




Schemas:

Star vs Snowflake



Popular posts from this blog

How to Install Oracle SQL Developer on Windows

Image
  Step-by-step guide to install Oracle Sql Developer on Windows :      Create Oracle Account with gmail and password      Downlaod Oracle Database XE (Express Edition) :  Oracle Database XE       Download SQL Developer :  Oracle Sql Developer     Once Downloaded Oracle Database XE      C:\Users\Sandeep\Sql Developer\OracleXE112_Win64\DISK1      You can double click on Setup --MakeSure remember password              Verify Installation YouTube Link:  How to Install Oracle SQL Developer on Windows
Read more

How to Install pyspark on Windows

Image
step-by-step guide to install Spark on Windows : How to Install  Spark on Windows  1. System Requirements/ Pre-requisites       Prerequisites of Apache Spark Installation:            1. Download Java :  java            2. Download Python :  python          3. Download Apache Spark :  spark          4. Download Hadoop Winutils and hadoop.dll :              winutils              hadoop.dll          5. Set Environmental variables          6. Test PySpark and Spark Shell       2. Validate Java jdk:  3.Validate python and install pyspark module using pip  (pip install  pyspark==3.3.2)          4. Install Apache Spark : Check comparability version and do...
Read more

Database Constraints

Image
Database constraints are rules applied to table columns to ensure the accuracy, integrity, and consistency of data. They prevent invalid or unintended modifications to the database. Here are some common types of constraints: Types of Constraints: Primary Key – Ensures that a column (or set of columns) has unique values and cannot be NULL. Foreign Key – Enforces referential integrity by linking a column to another table’s primary key. Unique Constraint – Guarantees that all values in a column are distinct and  Not Null – Prevents NULL values in a column. Check Constraint – Defines conditions that data must meet (e.g., age >= 18). Default Constraint – Provides a default value when none is specified. Why Constraints Are Important: Data Integrity – Constraints prevent incorrect or inconsistent data entry. Referential Integrity – Foreign keys ensure relationships between tables remain valid. Error Prevention – Helps detect and avoid mistakes before they affect the database. ...
Read more