117. Databricks | Pyspark| SQL Coding Interview: Total Grand Slam Titles Winner

Azure Databricks Learning: Coding Interview Exercise: Pyspark and Spark SQL
=================================================================================
Coding exercises are very common in most of the Bigdata interviews. It is important to develop coding skills before appearing for Spark/Databricks interviews.
In this video, I have explained a coding scenario to find the total number grand slam titles won by each player. This is Leet Code SQL Exercise number 1783. This is also one of common coding exercise asked in MAANG/FAANG/GAMAM companies such as Google,Apple, Microsoft, Amazon, Meta etc.,
To get more understanding, watch this video
#GrandSlamWinner, #LeetCodeGrandSlam, #LeetCodeSQL-1783, #LeetCodeSQL, #HackerRankSQL,#MAANG/FAANG/GAMAM,#FAANGCodingQuestion, #SQLCoding, #PysparkCoding, #CodingInterviewQuestion, #ApacheSparkInterview, #SparkCodingExercise, #DatabricksCodingInterview,#SparkWindowFunctions,#SparkDevelopment,#DatabricksDevelopment, #DatabricksPyspark,#PysparkTips, #DatabricksTutorial, #AzureDatabricks, #Databricks, #Databricksforbeginners,#datascientists, #datasciencecommunity,#bigdataengineers,#machinelearningengineers

[@sumitchandwani9970]

Awesome explanation!

[@rajasdataengineering7585]

Thanks Sumit!

[@rajanib9057]

Hello andi...first of all thank for making these videos they are very helpful. can you please also share basic level understanding of the procedure of getting/transfering data in below scenarios 1. When the source is on-premise storage/database 2.When the source is cloude storage/database 3.When the target is on-premise database/storage 4.When the target is cloude database/storage

[@DreamyTwinkle]

Very helpful

[@rajasdataengineering7585]

Glad to hear that

[@bharatpurohit8331]

Other approach : Unpivot tournament column and then join with player dimension

[@rajasdataengineering7585]

Thanks for sharing your approach!

[@abiramgurusamy1820]

Thanks Sir

[@rajasdataengineering7585]

Welcome! Glad it helps

[@navnathjarare4829]

good job

[@rajasdataengineering7585]

Thanks!

[@adarshverma5429]

Hi Raja, I have an usecase where I am facing few challenges to do using pyspark. Could you please help?

[@niladridey9666]

please shear the notebook ,it will be helpul for us for quick hands on after we watch

[@oiwelder]

who doesn't write. It does not fix knowledge.

[@landchennai8549]

commented both SQL and PySpark scripts