SQL and databases lessons

My blog on Data science and Structured query language

working with strings in SQL

databases

sql training

data manipulation

most data cleaning processes involve working with structured and unstructured character/string datatypes . the ability to manipulate string data can be a super power

4 February 2024

SQL Window Functions

databases

sql training

data manipulation

However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row:

4 February 2024

An SQL case study

databases

sql training

data manipulation

try to find out where the missing values are coming from , will check the row numbers with missing values.

4 February 2024

SQL and R compared

databases

sql training

data manipulation

The Notebook is divided into tabbed sections as seen below.

3 February 2024

Up and Running with SQL

Databases

SQL

Data engineering

We do realise that most of the softwares around are designed to solve a problem!. To better understand what databases are ,we need to first understand the problems that…

2 December 2023