Precious Nwachukwu

Previously banned \ Data Engineering student | Building pipelines & documenting the journey | 365 days of learning in public 📈 | Next stop: Canada 🚀

[Precious Nwachukwu @buildwithprecio]

Day 21 of Data Engineering ✅
still on the windows function, i practiced more questions and also learnt about key terms like running total and rolling total and also how they get formed (window frames)
#365DaysOfDE #SQL #DataEngineering

[Precious Nwachukwu @buildwithprecio]

Day 20 of Data Engineering ✅
Today I worked on more windows functions particularly the windows frame section.
#365DaysOfDE #SQL #DataEngineering

[Precious Nwachukwu @buildwithprecio]

Day 19/365 of Data Engineering ✅
still on windows functions today i explored the rank functions which include the ROW NUMBER (), RANK (), DENSE_RANK () and PERCENT RANK (), and then finally i wrapped it up with the usual practice test
#365DaysOfDE #SQL #DataEngineering

[Precious Nwachukwu @buildwithprecio]

Day 18/365 of Data Engineering ✅ today i learnt about the aggregate Functions and windows function extensively. Also learnt aboru ur bathe use cases of the windows function and the group by use cases. finally I concluded with the tests #365DaysOfDE #SQL #DataEngineering

[Precious Nwachukwu @buildwithprecio]

@Femiforge C

[Precious Nwachukwu @buildwithprecio]

@iam_daniiell Very brilliant

[Precious Nwachukwu @buildwithprecio]

i concluded the lesson with doing some hands on practical and then uploaded to github.

[Precious Nwachukwu @buildwithprecio]

Day 17/365 of Data Engineering ✅ today i met the python version of if else statement on sql, CASE STATETMENT and its a very useful command because it replaces other replacing commands. I'm putting it at the top of my fav commands #365DaysOfDE #100Day #SQL #DataEngineering

[Precious Nwachukwu @buildwithprecio]

For the first time I’m actually terrified of Ai advancement….What if after doing all this studying I can’t get a job😭

[Precious Nwachukwu @buildwithprecio]

This whole time I thought it was a substitute for the other 2 not knowing that they are entirely different and each has its effect on the memory.

After that I practiced null functions by attempting the exercise provided.

[Precious Nwachukwu @buildwithprecio]

Day 16/365 of Data Engineering ✅

Today I learnt about null functions and most importantly their application but the part of this lesson that surprised me was realizing a Null value isn’t the same as an empty string or blank spa
#365DaysOfDE #100DaysOfCode #SQL #DataEngineering

[Precious Nwachukwu @buildwithprecio]

previous thread https://t.co/JQinStxsMI

[Precious Nwachukwu @buildwithprecio]

Day 14/365 ✅

Today I learnt about sql single row functions, manipulation, concat, upper, lower, trim, replace, Len, left, right and substrings.

#365DaysOfDE #100DaysOfCode #SQL #DataEngineering

[Precious Nwachukwu @buildwithprecio]

Day 15/365 of Data Engineering ✅

Today I moved into the date and time commands and boy they are quite a number of them. From the part extractions command to CAST, CONVERT AND FORMAT, to the DATE CALCULATION commands

#365DaysOfDE #100DaysOfCode #SQL #DataEngineering

[Precious Nwachukwu @buildwithprecio]

at a point i got pissed because even the DQL which i thought had more commands didnt even have that much. anyways eventually i concluded it and did the practice question which utilized the LAG function and for the first time ever i pushed those codes to my github

[Precious Nwachukwu @buildwithprecio]

@RahulKu22532718 Resume

[Precious Nwachukwu @buildwithprecio]

@RahulKu22532718 Resume

[Precious Nwachukwu @buildwithprecio]

@iam_daniiell Oboy this is really crazy

[Precious Nwachukwu @buildwithprecio]

Later I moved to the DATE and TIME functions , explored all it’s part extraction sub functions and then finally I concluded with the CAST, CONVERT AND FORMA commands

[Precious Nwachukwu @buildwithprecio]

Day 14/365 ✅

Today I learnt about sql single row functions, manipulation, concat, upper, lower, trim, replace, Len, left, right and substrings.

#365DaysOfDE #100DaysOfCode #SQL #DataEngineering

[Precious Nwachukwu @buildwithprecio]

I explored all 4 except included and then moved to column joining which is subdivided into 9 different types and played around with it as well and then finally I concluded with the set operator rules.

#365DaysOfDE #100DaysOfCode #SQL #DataEngineering

[Precious Nwachukwu @buildwithprecio]

Day 12&13/365 ✅

One of the topics I hated while growing up was set. even tho I loved maths I just couldn’t bring myself to love the set topic but for some reason every year something keep bringing me back to this evil topic😭……guess who I just met again

[Precious Nwachukwu @buildwithprecio]

Today’s study was about data joining and we have 2 types. The rows joining and column joining. The rows joining have 4types and 3 out of them happened to be my set enemies (union, intersect and union all)😂