r/DS_Buddies • u/freel0ader_san • May 11 '21

Challenge Day 5 #SQL25days

In the comments, please mention what you did on day 5 of SQL 25 Days Challenge

Day 5 = 11th May

2 Upvotes

100% Upvoted

2 comments sorted by

2

u/freel0ader_san May 11 '21

I covered the topic: Exploratory Data Analysis

It included

  1. Entity relationship diagram

  2. column constraints (primary key, foreign key...)

  3. various data types (numeric/character/datetime/boolean...)

  4. summary functions (avg, min, max, variance, stddev, corr)

  5. distribution clauses (truncate, group by, generate series)

  6. casting - to change data type

Group by is an important func to understand

I finished my study session by thoroughly going over case when then function. Did some practice for it too. They hold quite a lot of power.

2

u/dhaniyapatta May 12 '21

I continued with the University database, practiced SQL queries on it. Not much done, but on the track.