Completed Case Study #1: Danny's Diner from the 8 Week SQL Challenge by ππππ ππ’ππ‘ πππ§π§π²
Solved business questions with PostgreSQL using joins, CTEs, aggregations, CASE statements, and window functions.
#SQL #PostgreSQL #DataAnalytics #8WeekSQLChallenge
3
48
16 Jan 2024
I decided to work on a case study from 8 weeks SQL challenge by @DataWithDanny.
I worked on three case study questions from the dataset Dannyβs diner. I thoroughly enjoyed working on this, all three case study were answered using a single SQL statement.
#8WeekSQLChallenge
2
9
324
Okay. I can say I'm pretty confident with subqueries in SQL now. Here's my first unguided SQL project. I joined the #8WeekSQLChallenge and tbh, it was actually challenging π
Take a look at how I helped Danny at his Diner here
medium.com/@oluwasegunzion/dβ¦
First SQL Project β
The case study helped me understand better how Subqueries and Set Theory (in SQL) work
3
17
52
6,785
19 Sep 2023
Hello #datafam! After inspiration from @cheftee_lead and @Jessicalevi13, I have started participating in the #8weeksqlchallenge.
I selected Case Study #8 - Fresh Segments. Here is my code for the data exploration and cleansing phase:
2
4
8
1,133
11 Sep 2023
New article up! ππ₯
I completed the third installment of Danny Maβs #8WeekSQLChallenge, where I analyzed Foodie-Fiβs data to proffer actual business solutions. Read all about it, leave a clap or 50 and RT!
link.medium.com/v7jqr6gr0Cb
1
14
22
4,161
1 Sep 2023
And it's a wrap π₯
I have successfully completed the first section of the second case study #8weeksqlchallenge
I'm glad I took it up as I have learned more about SQL and how to utilize its abilities to answer business questions.
Happy September π€π
6
3
29
1,098
30 Aug 2023
Day 49 of #100DaysOfCode
β’ Worked on the Contact Me page for my portfolio website.
β’ Solved 4 Hackerrank SQL questions.
β’ Started with Case Study 2 for #8weeksqlchallenge
#SQL
ππ
36
634
25 Aug 2023
Unto the next case study in the #8weekSQLchallenge
Excited about delving inπ€. May this one not stress me ππ
#SQLAugust
8
14
104
10,876
23 Aug 2023
Day 42 of #100DaysOfCode
β’ Finally done with Case study 1 - Danny's Dinner from #8weekSQLChallenge by @DataWithDanny.
β’ Day 3 of MDS Fest 2023
β’ Learned about Kafka architecture, and how things work under the hood.
#moderndatastack #SQL #kafka
ππ
37
670
21 Aug 2023
New article up! ππ
This is Pizza Runner, the second installment of my #8WeekSQLChallenge series by Danny Ma. Iβll be honest, this challenge was in no way easy. Read all about it here:
link.medium.com/dtz6FlsArCb
Please read, comment, leave a clap or 10, and RT!
11
5
920
20 Aug 2023
Day 39 of #100DaysOfCode
β’ Solved 2 case-study-1 questions.
β’ Worked on my portfolio website, Updated Home and Projects pages.
β’ Continued learning docker from udemy. Learned docker tags and creating a Dockerfile from scratch.
#8WeekSQLChallenge #docker
ππ
3
42
1,193
19 Aug 2023
Day 38 of #100DaysOfCode
β’ Solved 3 case study 1 questions.
β’ Completed a pyspark streaming video using docker.
β’ Started watching Kafka video.
#8WeekSQLChallenge
ππ
43
912
18 Aug 2023
Day 37 of #100DaysOfCode
β’ Solved 4 Medium level SQL Questions from Leetcode.
β’ Started with pyspark project.
β’ Created database for #8WeekSQLChallenge case study 1.
ππ
38
968
17 Aug 2023
I got the basic knowledge of SQL someweeks ago and I also decided to embark on the journey of #8weekSQLchallenge brought up by @cheftee_lead to advance my knowledge in SQL Iβm going to be solving a lot of queries in this challenge Iβm so happy to be part of the challenge.
17 Aug 2023
After getting a background knowledge of SQL, I decided to embark on the #8weeksSQLchallenge shared by @Jessicalevi13 alongside @pinnacle_paul @dadadayo254 @Owolabi_mighty
Looks challenging but we doing this. I'll be asking questions on the TL. My bosses don't air me o
#SQLAugust
1
2
104
17 Aug 2023
Day 36 of #100DaysOfCode
β’ Solved 4 Bit Manipulation Questions
β’ Solved 1 Medium Leetcode SQL question
β’ Started with 8 Seek SQL challenge Case study by @DataWithDanny
β’ Added Blog section to my portfolio website (still a lot to be done)!
#8WeekSQLChallenge
ππ
1
28
590
14 Aug 2023
In my latest attempt at improving on using SQL to complete real projects, I joined Danny Maβs #8WeekSQLChallenge, with other Women in Data. This is the first of 8 case studies, all of which I shall be working and writing about.
link.medium.com/GopqZYs6fCb
2
23
31
2,900
17 Jul 2023
6. 8WeekSQLChallenge
Practice solving 8 real-world business problems across 8 well-crafted case studies.
Learn more: 8weeksqlchallenge.com
1
4
627
10 Jul 2023
Another New Week, Another Opportunity Week
1. Continue my #8WeekSQLChallenge with Danny
2. Improved my Power BI knowledge
#SQLChallenge #BuildinPublic #DataAnalyst
3
197
7 Jul 2023
This is my solution to Danny's Dinner #8WeekSQLChallenge that i hop on, reviews will be highly appreciated.
Thanks.
@iam_Uchenna @_NafulaC @DavidAbu_
2
1
13
495
7 Jul 2023
I am officially starting the #8WeekSQLChallenge - Cant wait to improve my SQL skills with Danny Ma!
3
30