6 Mar 2023
My first use of the windows functions in SQL to answer a business question.
The windows function is one part of SQL that I working towards getting a firmer grasp of.
Thank you @phaibooboo for calling my attention to it.
#8weeksofSQL #8weeksSQLchallenge #Dannyma
2
90
#100DaysOfCode Day 42
- Completed freecodecamp's Regex section ✅
- Finished with the queries for week1 of #8weeksOfSQL ✅
You can click on my github link to see both the business's questions and my queries:
github.com/EmmanuelAjibokun/…
ALT Screenshot of github's repo commit
ALT Screenshot of freecodecamp's Regular Expression completed course section
3
#100DaysOfCode Day 41
I was a able to write a query to answer one of the business's questions from #8weeksOfSQL challenge.
And I rested for most of the day
#DataAnalysis
#DataScience
#MySQL
2
5
#100DaysOfCode Day 39
- Done with freeCodeCamp ES6 session ✅
- I answered some of the businesses question for challenge 1 of #8weeksOfSQL
#javascript
#DataAnalytics
#DataScience
#100DaysOfCode Day 38
-Done with basics of javascript ✅
- ECMAScript: halfway through the section ✅
Tomorrow's plan is to finish up with the section on ES6 and hopefully have enough time to practice MySQL, and finish up week 1 challenge of #8weeksOfSQL
#javascript #DataScience
1
3
5
#100DaysOfCode Day 38
-Done with basics of javascript ✅
- ECMAScript: halfway through the section ✅
Tomorrow's plan is to finish up with the section on ES6 and hopefully have enough time to practice MySQL, and finish up week 1 challenge of #8weeksOfSQL
#javascript #DataScience
#100DaysOfCode Day 37
I am currently at a dead end and I do not know what to do.
I'm just going to go to bed and hopefully restart with a fresh mind tomorrow
#javascript #DataScientist
3
5
#100DaysOfCode Day 36
I am too lazy to type or go into the detail of how my day went😑
Continued the first challenge in 8weeksOfSQL. I was able to write some queries that answered some of the business questions.
#python #DataScience
#100daysofcoding Day 35
Data Analysis -
- practiced data visualization with Matplotlib
- joined the 8weeksOfSQL challenge by DataWithDanny.
The database code for the challenge is in postgresql, I had to reedit it to mysql for it to work on MySQL workbench
#DataScience #Python
2
2
#100daysofcoding Day 35
Data Analysis -
- practiced data visualization with Matplotlib
- joined the 8weeksOfSQL challenge by DataWithDanny.
The database code for the challenge is in postgresql, I had to reedit it to mysql for it to work on MySQL workbench
#DataScience #Python
#100daysofcoding Day 34
I was too lazy to code but I managed to complete my coding assignment on freecodecamp.
we will be starting with Javascript Objects tomorrow, yes I am a topic ahead🌚.
#javascript
1
5
27 Aug 2022
Day 4 of #100DaysOfSQL :
1. 6 more problems from #mbsisql puzzles
2. Cleared Advanced SQL @hackerrank
Next target - Completing #8weeksofSQL challenge set by @datawithdanny
#SQLChallenge #datachallenge
2
17 Feb 2022
#66daysofdata R2 D38 :
- investigated some tableau features vizs
- going back to @DataWithDanny #8weeksofsql week 2,
- data cleaning , table creation with SQL
- learned New Window functions :
* Rows, preceeding, following
8
29 Oct 2021
#66daysofdata R2 D24: started @DataWithDanny #8weeksofsql challange. Worked on day 1 with MySQL. Really liked it so far.
8