Tableau è³æ Œè©Šéšå顿Œç¿
Gemma
Tableau Desktop FoundationsïŒæ§ Tableau Desktop SpecialistïŒè³æ Œã®äºæ³åé¡88åã解説ããŸããå®éã«Tableauããã°ã©ã ã䜿ã£ãŠå®ç¿ããŸãã
åçŽ
Tableau
Leetcode SQLã®åé¡ã解決ããªãããçæéã§åé¡ã®çš®é¡ãç¹å®ããSQLå®è£ ã®ã¹ãã«ãåäžãããããšãã§ããŸãã
åè¬ç 221å
é£æåºŠ åçŽ
åè¬æé ç¡å¶é
åŠç¿ããåè¬è ã®ã¬ãã¥ãŒ
5.0
Jenna
ãžã§ãããã®å£°ãçŽ æµãªã®ã§ã3åç¹°ãè¿ãèŽãã®ãäœè£ã§ããããã£ãã >< SQLã¯åããŠã§ãããäžçæžåœå匷ããŠã¿ãŸãïŒïŒïŒ
5.0
í륌찞ì
SQLã¯ãã€ãåªå é äœãäœããåŸåãã«ããŠããŸãããç°¡åãªCRUDãJOINçšåºŠãã䜿ã£ãŠãããããµãã¯ãšãªããŠã£ã³ããŠé¢æ°ãªã©ã¯ããã€ãå匷ããªããããšæããªããããã£ãšå å»¶ã°ãã«ããŠããŸãããä»ã¯åçŽãªç²Ÿè£œäœæ¥ã ããããŠããŸãããè€éãªããŒã¿ã«çŽé¢ãããšãã«æãè¶³ãåºãªãã®ã§ã¯ãªãããšããäžå®ããããŸãããAIã§ã©ãã«ã解決ãããšããŠãããã®å Žãã®ãã«éãããèªåã®ãã®ã«ã¯ãªããªããšæããŠããããã§ãã çµå±ãAIãã³ãŒããæžããŠããããšããŠããããŒã¿æ§é ãçè§£ããŠããªããã°ãšã©ãŒãä¿®æ£ããããšããé©åãªè³ªåãæããããããšãã§ããŸããã§ããã ç¹ã«å顿Œç¿ã¯ã©ã¹ã倧ããªå©ãã«ãªããŸããã匷å¶åãæã£ãŠç¶ç¶çã«è§£ããŠãããã¡ã«ãé ã§çè§£ããŠããã ãã®ææ³ã身ã«ã€ããŸãããèªåãã©ãã»ã©åºç€ãçãã«ããŠãããã«æ°ã¥ããããŸããã åºç€æ®µéã§åæ»ããŠããæ¹ãªããè¬çŸ©ãšå顿Œç¿ã¯ã©ã¹ã®çµã¿åããã匷ãããããããŸãïŒïŒ
5.0
fintesl
SQLããã§ã«ç¥ã£ãŠããŸããããæŠå¿µãããäžåºŠãã£ãããšåºããããšãã§ããè¬çŸ©ã§ããããã®è¬çŸ©ãéããŠå¿ããŠããSQLã®ææ³ãæŽçã§ããŠè¯ãã£ãã§ãããã¿ã€ãå¥ã«åãããŠããã®ã§äžè¶³ããŠããéšåãæ¢ããŠåè¬ããé ã®äžã§ã¿ã€ãå¥ã«åé¡ãæŽçããããšãã§ããŠè¯ãã£ãã§ãïŒ
SQLããžãã¯ã®å®è£
SQL颿°ã®æŽ»çš
SQLææ³å šäœããã°ãã調ã¹ã
SQLã³ãŒãã£ã³ã°ãã¹ãã®åé¡è§£æ±º
ããžãã¯å®è£
+æ§ã
ãªé¢æ°ãè¬çŸ©ã®äžã€ã«ïŒ
SQLã¯ãèšå€§ãªããŒã¿ã«é ãããŠããã€ã³ãµã€ããšãã¬ã³ããèŠã€ããã®ã«åœ¹ç«ã€ããã°ã©ãã³ã°èšèªã§ããç§ã欲ããéšåã ããããŒã¿ããæããŠç¢ºèªããããšãã§ããŸãã SQLã¯éå®çãªææ³ã䜿çšããŠãããããSQLããžãã¯ãå®è£ ããŠæ£ãã颿°ã䜿çšããããšãéèŠã§ãããã®ãããITäŒç€Ÿã«å ¥ãåãç¹ã«ããŒã¿ã«é¢é£ããè·çš®ã§ããã°ãã³ãŒãã£ã³ã°ãã¹ãåã®é¢éããåãåãèšèªã§ããå ¥ç€ŸåŸãå¿ é ã®èšèªã§ãã
ããããã©ãããæºåããã¹ããããããªãã®ã§ããïŒããŒã¿ããŒã¹ã®ååã®ãããªåºæ¬çãªãã®ããå§ããå¿ èŠããããŸãããè² æ ã倧ããè¿ã¥ããŠããŸããïŒãŸããã³ãŒãã£ã³ã°ãã¹ãçšã®SQLåé¡è§£æ±ºãç®æããŠå§ããŸãããïŒ
ðââïžã³ãŒãã£ã³ã°ãã¹ãæºåäž
ðââïž SQLããŒã«ãåç §ããŠå®åã«é©çšãããæ¹
ðââïž çè«ãããäŸãéããåŠç¿ããã£ãšè§Šããæ¹
çãæéå ã«å šäœçãªSQLåé¡ã®è§£æ±ºãã§ããããã«ããã®ã¬ãã¹ã³ã§ã¯Leetcodeã®SQL Easyé£æåºŠåé¡ïŒãã³ã°ã«ç¿»èš³æäŸïŒã«åŸããŸãã
ç¥èã®åºç€ã磚ããåŸã«ã¹ãã«ãè²ãŠãããšæããšããç§ã¯ããé£ããçè«ãèŠãã®ã§ã¯ãªãããŸã軜ãåé¡è§£æ±ºããå§ããŸããããããã°èªç¶ã«æŠå¿µã埩ç¿ããåé¡ãçŽæ¥è§£ãã®ã§é ã®äžã«ããã£ãšé·ãéèšæ¶ã«æ®ããŸããæ°åŠãçè«ã ãå匷ããŠåé¡è§£æ±ºãããªããã°çè§£ã§ããªãããã§ãã
SQLåé¡ãäžåºŠã«è§£æ±ºã§ããªãã£ãã®ã§å¿é ããªãã§ãã ãããææ³ãç¥ãããšãšåé¡ãè§£ãããšãã§ãããã®ã®éã«ééãããã®ã§ãç§ãæåã¯åé¡ãäžåºŠã«è§£æ±ºã§ãããæéãé·ãããããŸãããã¿ã€ãã身ã«ã€ããèšç·Žãå¿ èŠãªã®ã§ããã£ãããšè»œãæ°æã¡ã§è¿ã¥ããããã«ãã®è¬çŸ©ãäŒç»ããŸãããä»å¹Žã®SQLã³ãŒãã£ã³ã°ãã¹ãã«åããŠç¬¬äžæ©ãèžã¿åºããŠãã ããïŒ
MySQL WorkbenchããçŽæ¥SQLã«ãã¯ã¢ãã+ Github飿ºã«ããSQLããã¯ã¢ãã
Leetcodeããã³ããã§ç §äŒã§ããSQLã¯éå®çã§ããèªåãäœæããSQLãã©ã®ããŒã¿ãåºåããã®ããçŽæ¥ç¢ºèªããŠã¿ãã®ãå®ååäžã«äžå¯æ¬ ã§ããã ããåé¡ã®è§£æ±ºã«å ç«ã¡ãMySQLãã€ã³ã¹ããŒã«ããŠWorkbenchã§SQLãç §äŒã§ããããã«ç°å¢èšå®ãäžç·ã«ããŠã¿ãŸãããã
ä»ã«ãGithubãšé£åããç°å¢èšå®ãè¡ã£ãŠããŸãã Githubã«èªåã®ã³ãŒãã眮ããšããã€ã§ãã©ãã§ãã©ã®ããã€ã¹ã§ãïŒæºåž¯é»è©±ã§ãä»ã®ã³ã³ãã¥ãŒã¿ã§ãïŒç¢ºèªã§ãããããããã¯ã¢ããç®çã§å€§ããªå©ãã«ãªããŸãã Githubé£åã¯ä»åã®SQLã ãã§ãªããä»ã®ããã°ã©ãã³ã°èšèªã«ã掻çšã§ããã®ã§ãšãŠã圹ã«ç«ã€ã§ãããïŒ
ãã现ããSQLåé¡ã®çš®é¡+宿é¡ãæäŸ
Leetcodeã®Easyé£æåºŠã®äžã§ãç°¡åãªé£æåºŠãšé£ããé£æåºŠãååšããŸããåºç€ã«ã¯ãããç°¡åãªé£æåºŠãéããŠè»œãå§ããã§ããããé£æåºŠã«å ããŠãSQLã®åé¡ãåå¥ã«åããŸããã CASE WHENãGROUP BYãªã©ã®ããžãã¯é¢é£ã¿ã€ãããããLAGãLEADãRANKãªã©ã®é¢æ°é¢é£ã¿ã€ãããããŸããåãããã¿ã€ããéããŠãåã¿ã€ããã©ããªåœ¢ã§åºé¡ã«ãªãããäžç®ã§ç¢ºèªã§ããŸãã
æŠå¿µèª¬æã远å çã«å¿ èŠãªéšåã¯ãåè¬çã®ããã®çè«ææ¥PPTãæäŸãããŸãããŸããäžäººã§è¿œå ã®ç·Žç¿ãè¡ãããã«ãäžéäžã®å®¿é¡ãšãœãªã¥ãŒã·ã§ã³ãæäŸããŸããããªãã®SQLã¹ãã«ãçŽæ¥ãã§ãã¯ããŠãã ããïŒ
è¬çŸ©ã¯å€§ãã3ã€ã®ããŒãã«åãããŸãã
Leetcodeã®Easyé£æåºŠã®äžã§ããç°¡åãªé£æåºŠåé¡ãå ã«è§£ããªãããSQLã³ãŒãã£ã³ã°ãã¹ãã«å ¥éããæºåãããŸãã
ããžãã¯é¢é£ã®åé¡ãã¿ã€ãå¥ïŒäŸïŒ join ãgroup byãnot inãcase whenãªã©ïŒã«è§£æ±ºããŸãã
MySQL Workbenchã§SQLãæ®µéçã«ç §äŒããåŸãæçµã¯ãšãªãå°ãåºããŸãã
颿°åºæã®åé¡ãåå¥ïŒäŸïŒrankãdense_rankãrow_numberãlagãleadãªã©ïŒã«è§£æ±ºããŠãã ããã
MySQL Workbenchã§SQLãæ®µéçã«ç §äŒããåŸãæçµã¯ãšãªãå°ãåºããŸãã
Q. ãã®è¬çŸ©ã®å·®å¥ç¹ã¯äœã§ããïŒ
Q. éå°æ»è ãèããè¬çŸ©ã§ããïŒ
ãããããã®ã¬ãã¹ã³ã¯åºæ¬çãªSQLãç¥ã£ãŠãã人ã察象ãšããŠããŸãã SQLã³ãŒãã£ã³ã°ãã¹ããæºåäžã®å°±åŽçããã¡ããã©ããŒã¿è·çš®ã§å°±è·ãããæ¹ã«å¹ççãªè¬çŸ©ã§ãã
Q. ãã®è¬çŸ©ããã¹ãŠèããããåè¬çã®ç§ã¯ã©ã®ã¬ãã«ãŸã§äžããããšãã§ããŸããïŒ
å®éã®ã³ãŒãã£ã³ã°ãã¹ãã¯ã¢ã«ãŽãªãºã åé¡ãSQLåé¡ïŒ+ããŸã«Pandas DataFrameåŠçåé¡ïŒãæ··åšããŠããŸãããSQLåé¡ã¯ããã»ã©é£ãããããŸããïŒ ïŒã¢ã«ãŽãªãºã åé¡ããå€å¥åã®ããåé¡ãåºãŠããŸããïŒ
è¬çŸ©ã«ããåŸããã³ãŒãã£ã³ã°ãã¹ãäºå®æ¥ä»¥åã«Githubã«èŒããã³ãŒãã埩ç¿åŸã«è©ŠéšãèŠããšãSQLéšåã§ã¯ç¡çãªãåé¡ã解決ã§ããã¬ãã«ã«ãªããŸãã
åŠç¿å¯Ÿè±¡ã¯
誰ã§ãããïŒ
ã³ã³ãã¥ãŒã¿å·¥åŠå°æ»è
ã³ãŒãã£ã³ã°ãã¹ãæºåäž
ããŒã¿ã¢ããªã¹ã
åæç¥èã
å¿
èŠã§ããããïŒ
SQL
ãã£ãªã¢èªèšŒ
1,101
åè¬ç
136
åè¬ã¬ãã¥ãŒ
50
åç
4.9
è¬åº§è©äŸ¡
5
è¬åº§
æ°åŠããå§ãŸããéçºè ã®ãã£ãªã¢ãçµãŠãçµ±èšåŠã®å匷ãéããŠçŸåšã¯ããŒã¿ã¢ããªã¹ããšããŠæŽ»åããŠããGemmaã§ããããŒã¿åæã¯ã溢ããããããã°ããŒã¿ã®äžããæ¬æ°ãªã€ã³ãµã€ãããã¬ã³ããææ¡ããããšãæãéèŠã§ããèšãã®ã¯ç°¡åã§ãããïŒã§ãããé©åãªåæããŒã«ãšææ³ãæŽ»çšã§ããã°ã誰ã§ãååã«è²Žéãªå®ç³ãèŠã€ãåºãããšãã§ããŸãããã®ãããªã¡ãœãããçããã«å ±æããããšæããŸãã
(çŸ) LINE Plus ããŒã¿ã¢ããªã¹ã
(å) LINEã€ããŒïŒNAVERïŒããŒã¿ã¢ããªã¹ã
çµ±èšåŠä¿®å£«ãæ°åŠç§åŠå£«
'SQLå®è·µãã¬ãŒãã³ã°' èè : https://product.kyobobook.co.kr/detail/S000217223580
ã¡ãŒã«: sweetherb100@gmail.com
å人ããã°ïŒ
https://blog.naver.com/italian-lesson
å šäœ
22ä»¶ â (2æé 5å)
è¬åº§è³æïŒãããããããïŒ:
5. ã©ã
08:59
6. åå
07:24
8. æã£ãŠãã
04:25
9. min, max
01:22
10. ã«äž
04:20
å šäœ
19ä»¶
5.0
19ä»¶ã®åè¬ã¬ãã¥ãŒ
åè¬ã¬ãã¥ãŒ 5
â
å¹³åè©äŸ¡ 5.0
ä¿®æ£æžã¿
5
SQLããã§ã«ç¥ã£ãŠããŸããããæŠå¿µãããäžåºŠãã£ãããšåºããããšãã§ããè¬çŸ©ã§ããããã®è¬çŸ©ãéããŠå¿ããŠããSQLã®ææ³ãæŽçã§ããŠè¯ãã£ãã§ãããã¿ã€ãå¥ã«åãããŠããã®ã§äžè¶³ããŠããéšåãæ¢ããŠåè¬ããé ã®äžã§ã¿ã€ãå¥ã«åé¡ãæŽçããããšãã§ããŠè¯ãã£ãã§ãïŒ
åè¬ã¬ãã¥ãŒ 2
â
å¹³åè©äŸ¡ 5.0
åè¬ã¬ãã¥ãŒ 3
â
å¹³åè©äŸ¡ 5.0
5
æåã¯æ¿ãæ¥ãªããŠè¬çŸ©ã®å ±åã«è¿œãã€ããããæ¬¡ã ãšéããŠè¬çŸ©ãèŠãåã«å ã«è§£ããŠã¿ãŠãè¬çŸ©ã®äžã§åãäžããããŠããªãéšåã¯è³ªåããªããæèŠãã€ããã ããã§ããèª å¿èª æãŸã§çããŠãã ãã£ãŠçè§£ããã®ã«äžå±€ç°¡åã§ãããããããšãããããŸãïŒ
åè¬ã¬ãã¥ãŒ 2
â
å¹³åè©äŸ¡ 5.0
ä¿®æ£æžã¿
åè¬ã¬ãã¥ãŒ 7
â
å¹³åè©äŸ¡ 5.0
5
SQLã¯ãã€ãåªå é äœãäœããåŸåãã«ããŠããŸãããç°¡åãªCRUDãJOINçšåºŠãã䜿ã£ãŠãããããµãã¯ãšãªããŠã£ã³ããŠé¢æ°ãªã©ã¯ããã€ãå匷ããªããããšæããªããããã£ãšå å»¶ã°ãã«ããŠããŸãããä»ã¯åçŽãªç²Ÿè£œäœæ¥ã ããããŠããŸãããè€éãªããŒã¿ã«çŽé¢ãããšãã«æãè¶³ãåºãªãã®ã§ã¯ãªãããšããäžå®ããããŸãããAIã§ã©ãã«ã解決ãããšããŠãããã®å Žãã®ãã«éãããèªåã®ãã®ã«ã¯ãªããªããšæããŠããããã§ãã çµå±ãAIãã³ãŒããæžããŠããããšããŠããããŒã¿æ§é ãçè§£ããŠããªããã°ãšã©ãŒãä¿®æ£ããããšããé©åãªè³ªåãæããããããšãã§ããŸããã§ããã ç¹ã«å顿Œç¿ã¯ã©ã¹ã倧ããªå©ãã«ãªããŸããã匷å¶åãæã£ãŠç¶ç¶çã«è§£ããŠãããã¡ã«ãé ã§çè§£ããŠããã ãã®ææ³ã身ã«ã€ããŸãããèªåãã©ãã»ã©åºç€ãçãã«ããŠãããã«æ°ã¥ããããŸããã åºç€æ®µéã§åæ»ããŠããæ¹ãªããè¬çŸ©ãšå顿Œç¿ã¯ã©ã¹ã®çµã¿åããã匷ãããããããŸãïŒïŒ
ç¥èå ±æè ã®ä»ã®è¬åº§ãèŠãŠã¿ãŸãããïŒ
åãåéã®ä»ã®è¬åº§ãèŠãŠã¿ãŸãããïŒ