In this video we are going to create an end to end SQL and Python Project for Data Analyst portfolio. It has codes for SQL as well as Python. This video is most suitable for all aspiring data analyst, data engineers or someone who wants to get theirs hands dirty with code.
To get the driver name in your system: https://stackoverflow.com/questions/33254191/how-to-find-the-odbc-driver-name-for-a-connection-string
GitHub Link for the project: https://github.com/akshatagrawal1998/Python-SQL-Project/tree/main
Link to dataset: https://www.kaggle.com/datasets/akshatagrawal9431/shipment-orders-dataset
Join us to master SQL & Python and elevate your data/business analytics expertise!
SQL Portfolio Project (Data Analyst or Business Analyst)
https://www.youtube.com/watch?v=xaRlc4BLZHs
Business Analyst Interview Question
https://youtu.be/gRQuYPKSy9A?si=jkIVuEAmYrz8zi8b
Year on Year Growth Rate in SQL
https://youtu.be/2D1KENj5UGI?si=_m62_IpP6B1fd51d
SQL Order of Execution -
https://youtu.be/-2ujeFLEi6E?si=pxgW304dN4j1tGNr
Group BY & Having vs where in SQL
https://youtu.be/fAShoMp-2bQ?si=1FefPAsAUeYwzd-6
SQL Joins
https://youtu.be/lYqqmKqtApk?si=qSH6_cxZhGe7NyLN
SQL Joins Interview Question
https://youtu.be/14ShY0_uRIk?si=IyzBEQHYIXaH5HXZ
CTE vs Temp Tables in SQL -
https://youtu.be/NPrkMatFyLM?si=7dT0gM35BcplZG8e
Window Functions Explained
https://youtu.be/Vp6p1q-QJP4?si=MkFsBu5QQo2g1oaI
Let's connect:
Instagram - https://www.instagram.com/the_dataholics/
LinkedIN - https://www.linkedin.com/company/101999286/admin/feed/posts/
#SQL #DataAnalytics #BusinessAnalysis #HandsOnLearning #CareerSkills #akshatagrawal #dataholics #the_dataholics