Тёмный

SQL Portfolio Project | Data Analytics | Danny's Diner SQL Challenge 

Turn To Data
Подписаться 1 тыс.
Просмотров 7 тыс.
50% 1

Here's the consolidated video that comprises of all solved questions in Danny's Diner SQL Case Study # 1. The questions discussed here help you understand the concepts of Aggregate functions, windows functions, basic SQL syntax and CTEs. Dive deep into the world of Data Analytics by learning SQL with ‪@TurnToData‬
Table creation and insert statements are provided here:
embed.db-fiddle.com/912b55b7-...
🎤🎤 Mic I use for recording videos: amzn.to/3HcF6cb
📚📚 Book Recommendation:
Learn Storytelling with Data: amzn.to/3vv8Xdg
Timecodes:
0:00 - Intro
4:40 - Question No. 1
10:36 - Question No. 2
14:45 - Question No. 3
23:52 - Question No. 4
29:42 - Question No. 5
36:42 - Question No. 6
44:03 - Question No. 7
46:08 - Question No. 8
50:32 - Question No. 9
58:18 - Question No. 10
01:07:41 - Bonus Question No. 1
01:12:21 - Bonus Question No. 2
Checkout the Videos page to explore other videos that you may find interesting!
💜💜 Spread some love by Subscribing to the channel. Hit the 👍Like button if you enjoyed this video! 💜💜
I would really appreciate your feedback. Please let me know your thoughts via comments.
🌱 "Never cease to Learn & Grow!" 🌱
#sql #dannydiner #sqlcasestudy #dataanalyst #dataanalytics #windowfunctions #aggregate #commontableexpression #turntodata

Опубликовано:

 

27 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 28   
@karunakaranr2473
@karunakaranr2473 Месяц назад
Thanks for your time and effort. Awesome explanation.
@TurnToData
@TurnToData Месяц назад
Appreciate your feedback. Glad it was helpful!
@Userm2040
@Userm2040 Месяц назад
Full Projects are always helpful. Thank you so much for this Full Project.
@TurnToData
@TurnToData Месяц назад
You are most welcome! Stay tuned for more such projects.
@user-ex5oj4fb9g
@user-ex5oj4fb9g Месяц назад
Thanks for the video👏, waiting for next project, Good work
@TurnToData
@TurnToData Месяц назад
You are welcome! Glad you liked the video. More projects coming very shortly. Please subscribe and hit the bell icon to stay updated!
@ganakc1837
@ganakc1837 Месяц назад
Great work, keep them coming 👏👏
@TurnToData
@TurnToData Месяц назад
Thanks, Gana! Glad you liked it :)
@PriyaSathya-ng3bi
@PriyaSathya-ng3bi Месяц назад
I am thankful for your time and effort ,it was very useful .Looking forward for more such SQL Projects .
@TurnToData
@TurnToData Месяц назад
I'm glad you liked it. Stay tuned for more such projects!
@pradeeppapireddy
@pradeeppapireddy Месяц назад
Thank you Anna , you are really so kind to share such quality information
@TurnToData
@TurnToData Месяц назад
Thanks. Glad to know you liked it. More videos coming out soon.
@slrahman8723
@slrahman8723 Месяц назад
Highly appreciated ..expecting to upload more videos regarding real life projects.
@TurnToData
@TurnToData Месяц назад
Thanks, glad you enjoyed the video :)
@BHARATHEEYUDU.
@BHARATHEEYUDU. Месяц назад
Great job 👍
@TurnToData
@TurnToData Месяц назад
Thank you! Cheers!
@koa1663
@koa1663 Месяц назад
How do you document your findings for the portfolio? What format is the information presented in?
@TurnToData
@TurnToData Месяц назад
It's a good question. Thoroughly describe the goals of your project (in this case, it is to analyze the data from a fictional diner to help the owner, Danny, understand his customers' behaviors and preferences.), the SQL queries you executed, and the insights you derived (these are the results of each query). This documentation demonstrates your analytical thinking and ability to communicate effectively. From next video onwards, I will also showcase how you can document your findings. This information can be presented in any form you wish, but a PDF is highly recommended. Just upload your SQL queries onto your github repository as that will be the best source of your portfolio.
@VickyShrivastav-oi4pm
@VickyShrivastav-oi4pm Месяц назад
good explanation
@TurnToData
@TurnToData Месяц назад
Thanks. I'm glad you enjoyed the video!
@vicky1840
@vicky1840 Месяц назад
I hope u can bring more project like this ❤​@@TurnToData
@TurnToData
@TurnToData Месяц назад
Definitely. More SQL Projects will be uploaded in the coming days 👍
@srikantha2884
@srikantha2884 Месяц назад
Hi Sir, I need SQL training for Azure Data engineering. Any possibility to provide 1:1 training. I will pay accordingly. Please reply 🙏.
@TurnToData
@TurnToData Месяц назад
Hi, appreciate your request, but I'm presently unavailable for a 1:1 training. I would recommend taking a 1:1 training through an established training center near you (or online) as you are interested in a particular domain.
@lenkaladivya5707
@lenkaladivya5707 Месяц назад
Where r u from ,,,
@srikantha2884
@srikantha2884 Месяц назад
@@lenkaladivya5707 :: Vijayawada
@soheilpalermo491
@soheilpalermo491 Месяц назад
thanks
@TurnToData
@TurnToData Месяц назад
Glad you liked it!
Далее
Data Analyst Portfolios Are Dead
4:59
Просмотров 10 тыс.
Thank you 3M❤️
00:14
Просмотров 807 тыс.
Roadmap for Learning SQL
4:52
Просмотров 288 тыс.
SQL & PowerBI Portfolio Project for Data Analysts
1:24:32
Database Indexing for Dumb Developers
15:59
Просмотров 43 тыс.
Thank you 3M❤️
00:14
Просмотров 807 тыс.