SQL – DataForecast

Things you can do in Python, but you can’t do in SQL

6 May, 24

Python and SQL are two different languages with distinct purposes.

Things you can do in SQL that you can’t do in Python

6 May, 24

SQL (Structured Query Language) and Python are two different tools

Dealing with Type 1 Slowly Changing Dimensions in SQL

12 Mar, 24

Here's a step-by-step guide on dealing with a Type 1

Dealing with new data for a type 2 slowly changing dimension using SQL Merge and Upsert

12 Mar, 24

Here's a step-by-step guide on dealing with a Type 2

Dealing with new data for a type 2 slowly changing dimension using SQL

12 Mar, 24

Here's a step-by-step guide for dealing with a Type 2

Programming languages used in data science

1 Jan, 24

Creating tables, joining them, and selecting only certain columns from them in SQL and Python

9 Dec, 23

Using SQL and Python Pandas to make inner and left joins

8 Dec, 23

How to become a data scientist

8 Dec, 23

Why is SQL still the most widely used language for databases

29 Nov, 23