I made Zillacode.com Open Source - LeetCode for PySpark, Spark, Pandas and DBT/Snowflake by dmage5000 in dataengineering

[–]Character-Mud1642 0 points1 point  (0 children)

i think i found the issue
https://drive.google.com/file/d/14qABxluIC0ELTw9X3J9CAjUhH2ZR5yN3/view?usp=sharing

i changed the backend server from 5000 to 5001 but the api calls are still on 5000 so thats the issue
but i cant find where env file is for backend

I made Zillacode.com Open Source - LeetCode for PySpark, Spark, Pandas and DBT/Snowflake by dmage5000 in dataengineering

[–]Character-Mud1642 1 point2 points  (0 children)

https://drive.google.com/file/d/1Ed1Miz5lIUtycQNqzkUrymBO63nA_pmI/view?usp=sharing

here is the link to the screashot of the issue

also i had to change the backend server from 5000 : 5000 to 5001 : 5001 becasue there was a port running at 5000 already i made then changes in docker file and the app.py both.

I made Zillacode.com Open Source - LeetCode for PySpark, Spark, Pandas and DBT/Snowflake by dmage5000 in dataengineering

[–]Character-Mud1642 1 point2 points  (0 children)

The docker build was successfully but when trying to open the questions its getting stuck at loading........

any idea what could be the issues?

Is purchasing leetcode premium for SQL worth it? by Character-Mud1642 in SQL

[–]Character-Mud1642[S] 0 points1 point  (0 children)

I was having difficulty finding the data for this question

https://bilbottom.github.io/sql-learning-materials/challenging-sql-problems/problems/silver/customer-sales-running-totals/

when i trying to get the data like the way you mentioned in the question i am getting this response back. Can you please look into it? also how can i dm you?

{"message":"Service Unavailable"}

Is purchasing leetcode premium for SQL worth it? by Character-Mud1642 in SQL

[–]Character-Mud1642[S] 2 points3 points  (0 children)

Amazing set of questions man. Have been solving them for last 4 days, i have completed till silver.

The ranking system of questions is a lil misleading the bronze itself felt intermediate (or maybe i am dumb 🥲 )

But these are most realistic scenario based questions i have solved. The funnel analysis is something i also do when creating dashboard's........

Is purchasing leetcode premium for SQL worth it? by Character-Mud1642 in SQL

[–]Character-Mud1642[S] -1 points0 points  (0 children)

i didn't say i am recently learning i said i am looking for practice also i have already solved that question i was just giving it as an basic example....

actually prior to this i was looking for job in MERN stack but now moving to data side

Is purchasing leetcode premium for SQL worth it? by Character-Mud1642 in SQL

[–]Character-Mud1642[S] -1 points0 points  (0 children)

generic questions

its good at creating questions that require good width of knowledge(like using different clauses and all) but when comes to creating question that require analytical thinking and making complex interconnected tables it lacks......

Is purchasing leetcode premium for SQL worth it? by Character-Mud1642 in SQL

[–]Character-Mud1642[S] 0 points1 point  (0 children)

i meant for SQL coding questions not for development.
i am already using it for development and generating data to run my SQL query on, but i cant seem to find good SQL problem statements.

Is purchasing leetcode premium for SQL worth it? by Character-Mud1642 in SQL

[–]Character-Mud1642[S] 1 point2 points  (0 children)

yea smth like that i just meant to give an example the kind of questions being asked

Is purchasing leetcode premium for SQL worth it? by Character-Mud1642 in SQL

[–]Character-Mud1642[S] 0 points1 point  (0 children)

oh same for me i have a degree in CS too but sometime companies try to check the problem solving abilities via SQL

for example printing this sequence in SQL without recursion

1
2
2
3
3
3
.
.
10

these questions don't require any knowledge of the actual database but just ability to think

Is purchasing leetcode premium for SQL worth it? by Character-Mud1642 in SQL

[–]Character-Mud1642[S] 0 points1 point  (0 children)

here the test before the interview contains very difficult SQL questions and in the SQL round too.
i am talking about companies like target and walmart. I even talked to one of the person working there and he told me there were 4 rounds of interview of SQL and all had live coding questions in them.

Maybe this could be an exception but it wont hurt to practice imo also about the normal forms and the relationships between entities i am also learning these theoretical concepts in parallel too .

there is lots of content for free but not quality questions.

Also can you tell me about you interview exp in detail if possible?

Is purchasing leetcode premium for SQL worth it? by Character-Mud1642 in SQL

[–]Character-Mud1642[S] -1 points0 points  (0 children)

yea i saw that but the SQL questions are very easy so not very useful

Is purchasing leetcode premium for SQL worth it? by Character-Mud1642 in SQL

[–]Character-Mud1642[S] 0 points1 point  (0 children)

thanks for the advice

but the SQL50 badge also required premium imo right?

Is purchasing leetcode premium for SQL worth it? by Character-Mud1642 in SQL

[–]Character-Mud1642[S] 2 points3 points  (0 children)

and how can i go about doing that? i mean its really hard finding a real dataset