OLAP vs OLTP

OLAP vs OLTP

Data Lake, Data Warehouse, Data Mart

LIKE and REGEXP in SQL

How to find a column name in large list of tables in a database?

CTE and VIEWS in SQL

Any and All

Numpy Part 4

Numpy Part 1

Numpy Part 3

Lambda Function

NUMPY Part 2

Entity Constraints

Functions in Python

Introduction to SQL

Loops in Python(for/while/if-else)

Lists In Python

Sets in Python

Dictionaries in Python

Tuples in Python

String Operations in Python

Indexing in SQL

3rd, 4th and 5th Normal Form

Python Data Types

Database Schemas (Star and Snowflake Schema)