#35ãSQLã§æ©æ¢°åŠç¿ãåŠãŒããéããŒã¿ãµã€ãšã³ãã£ã¹ãã®ããã®æ©æ¢°åŠç¿å ¥éãã³ãºãªã³ïŒ
ã€ãã³ãå 容
ã€ãã³ãã«ã€ããŠ
å®å šãªã³ã©ã€ã³ã§å®æœããŸãã æŠèŠã¯ã¿ã€ã ã¹ã±ãžã¥ãŒã«ãã芧ãã ããã
ã€ãã³ãã®å 容
æšä»ãããããããŒã¿ãåéããŠåæããããžãã¹ã«æŽ»ããããšãäŒæ¥ã®ç«¶äºåã®æºãšãªã£ãŠãããAI/æ©æ¢°åŠç¿ã®ããŒãºãé«ãŸã£ãŠããããšã¯ã¿ãªããããæ¿ç¥ããšæããŸãã äžæ¹ã§ããŒã¿ãµã€ãšã³ãã£ã¹ã/æ©æ¢°åŠç¿ãšã³ãžãã¢ã§ãªãå Žåã«ã¯ãæ·å± ãé«ããšæããããæ¹ ãå€ãã®ã§ã¯ãªãã§ããããïŒ
åœå匷äŒã¯æ©æ¢°åŠç¿ã®å°éç¥èããŸã£ãããªãæ¹ã§ããã®ç¹åŸŽãšä»çµã¿ãçè§£ã§ããããã«ããã®æŠèŠãåããããã解説ããŸãã è¬çŸ©ã§æ±ãå 容ã¯ä»¥äžã®éãã§ãã
- åŸæ¥ã®ããã°ã©ãã³ã°ã𿩿¢°åŠç¿ã®ã¢ãããŒãã®éã
- æ©æ¢°åŠç¿ã®åé¡
- æ©æ¢°åŠç¿ã®æµã(ããŒã¿ã®æºåããã¬ãŒãã³ã°ãè©äŸ¡ãäºæž¬)
ãããŠãè¬çŸ©åœ¢åŒã®å匷äŒã®åŸãSQLãçšããŠæ©æ¢°åŠç¿ãè¡ãããšãã§ããGCPã®ãããã¯ãBigQuery MLãçšããŠãã³ãºãªã³ãè¡ããPythonãªã©ã®é«åºŠãªããã°ã©ãã³ã°ãè¡ããã«ãæ©æ¢°åŠç¿ã¢ãã«ã®ãã¬ãŒãã³ã°ïœè©äŸ¡ïœäºæž¬ã®äžé£ã®ã¿ã¹ã¯ãäœæããã ããŸãã
åœå匷äŒãç®æãããšã¯ä»¥äžã®éãã§ãã
- åŸæ¥ã®ããã°ã©ãã³ã°ã𿩿¢°åŠç¿ã®ã¢ãããŒãã®éããçè§£ãã
- æ©æ¢°åŠç¿ã®çš®é¡ãšããããã®ç¹åŸŽãçè§£ãã
- æ©æ¢°åŠç¿ã«ãããããŒã¿æºåïœäºæž¬ã®äžé£ã®ã¿ã¹ã¯ããã³ãºãªã³ãéããŠäœæããã
æ©æ¢°åŠç¿ã®ç¥èã»ã¹ãã«ã¯ä»åŸãŸããŸãéèŠãé«ãŸã£ãŠããããšã¯ç¢ºå®ã§ããåœå匷äŒããã£ããã«æ©æ¢°åŠç¿ã®äžçã«ã¯ããã®1æ©ãèžã¿åºããåžå ŽäŸ¡å€ã®é«ããšã³ãžãã¢ãç®æããŸãããïŒ
é²è¡
岩ïšäžæ
ããªãŒã©ã³ã¹ãšã³ãžãã¢ã»ããããã¬ãŒãçµãŠãŠã§ãå¶äœäŒç€Ÿãèµ·æ¥ã ããŒãœãã«ãã¬ãŒãã³ã°ãžã ãããã塟CTOãå Œåã ã¯ãã¹ãã©ãããã©ãŒã 察å¿ã®ã¹ããã¢ããªéçºãã¬ãŒã ã¯ãŒã¯ã§ããReactNativeã®ãšãã¹ããŒãã§ãç°¡åãªã¢ããªãªãïŒæ¥ã§å®æãããããšãã§ãããè¶£å³ã¯çãã¬ãçãã¬ããŠããã¢ããªéçºè ãå¢ããããšãå¯ãã«çããããšããŠããã
è¬åž«
å°æ³éä¹ç¥
倧æSIerã«å€åããåããç«ã¡äžãéããªããã³ãã£ãŒäŒæ¥ã®ã¯ã©ãŠãã€ã³ãã©ãèšèšããæ§ç¯ãŸã§äžæ°é貫ã§å®æœãããã¯ã©ãŠãã®ãããã§ã·ã§ãã«ãæè¿ã¯ãã¯ãã«ã«äººæã®è²æã«åŸäºããåå¿è åãã®å匷äŒããé«åºŠäººæã®æåºãŸã§ãæ·±ãç¥èŠãå ã«å¹ åºã掻åããŠããã Google Cloudèªå®Professional Data EngineerååŸã
â»è¬åž«ã¯æ©æ¢°åŠç¿ãšã³ãžãã¢ã§ã¯ãããŸãããã¯ã©ãŠããšã³ãžãã¢ãšããŠåªãããããã¯ãã®æŽ»çšãæ©æ¢°åŠç¿åå¿è ã®èŠç¹ãããåããããã䟡å€ã®ããè¬çŸ©ãå¿æããŸãã
ã¿ã€ã ã¹ã±ãžã¥ãŒã«
ã€ãã³ãæ§æ 120å
| æé | å 容 |
|---|---|
| 5å | æšæ¶ãç°¡åãªèªå·±çŽ¹ä» |
| 45å | è¬çŸ©ãéããŒã¿ãµã€ãšã³ãã£ã¹ãã®ããã®æ©æ¢°åŠç¿å ¥éã |
| 5å | å°äŒæ© |
| 45å | BIgQuery MLãçšããSQLã«ããæ©æ¢°åŠç¿äœéšãã³ãºãªã³ |
| 5å | ã¢ã³ã±ãŒãåç |
| 15å | 質çå¿ç |
ãããªäººã«ãããã
- æ©æ¢°åŠç¿ã«èå³ãããããæ·å± ãé«ãå§ããã®ãé£ãããšæããŠããæ¹
- ã¯ã©ãŠãã«èå³ããããèªèº«ã®åžå ŽäŸ¡å€ãé«ããŠããããæ¹
- ãSQLã ãã§æ©æ¢°åŠç¿ã§ããã£ãŠããžïŒïŒããšæãããæ¹
ïŒæ©æ¢°åŠç¿åå¿è ã®æ¹ã«åããå 容ãšãªããŸãã®ã§ãçµéšè ã®æ¹ã«ãšã£ãŠã¯æ¢ç¥ã®å 容ãšãªããããããŸããã
äºåæºå
ãã³ãºãªã³ããŒãã§ã¯GCPã䜿çšãããããåœæ¥ãŸã§ã«ãã¡ãã®ãµã€ãã®æé ãåèã«ç¡æãã©ã€ã¢ã«ã®ç»é²ããã³GCPãããžã§ã¯ãã®æ°èŠäœæãã宿œããŠãã ããã
- GCPãããžã§ã¯ããæºåããã ããŠããªãå Žåã¯ãã³ãºãªã³ãåè¬ã§ããŸããã
- ãããžã§ã¯ãåã¯ãbqml-handsonããšããŠãã ããã(ä»»æã®åç§°ã§ãæ§ããŸããããåœæ¥ã®æ¡å ãã¹ã ãŒãºã«è¡ããã)
- ããããžã§ã¯ãã§å©çšãããµãŒãã¹ãæå¹åãã¯åœæ¥å®æœããŸãã®ã§ãäºåã®å¯Ÿå¿ã¯äžèŠã§ãã
- GCPã®ç¡æãã©ã€ã¢ã«ãæ¢ã«äœ¿çšæžã¿ã®å Žåãåœãã³ãºãªã³ã«ãããè²»çšã¯ãèªèº«ã§ãè² æ ããã ãããšãäºããäºæ¿ãã ããããã³ãºãªã³çµäºåŸããã«ãªãœãŒã¹ãåé€ããã°è²»çšã¯100å以äžã§ãã
å°äŒæ©ã§ã¯ããã£ãããã¹ããè¡ããŸãïŒ
NPOæ³äººFitnessEngineerïŒãã£ãããã¹ã»ãšã³ãžãã¢ïŒã¯ãå¥åº·ã§äžå€«ãªäœãšèåŸãå¥å šã«åããé ãè²ãŠããå£äœã§ãæ å ±æè¡ãåŠã³ãé ããè²ãŠããšãšãã«ã座ãä»äºã§ãæ¯éãããããªãå¥åº·ãªãäœããäœãããšã倧åã«ããŠããŸãã
ãã®ãããåœã€ãã³ãäžã®å°äŒæ©ïŒçŽïŒåéïŒãšããã³ã³ãã¯ããªæéã§å®éã«äœãåããæŽ»åã宿œããŸãã
å®éã«äœãåããæŽ»åã§ã¯ãããŒãœãã«ãã¬ãŒãã³ã°ãžã ã®ç£ä¿®ãåããããã¹ã¯ã¯ãŒã«ãŒã®ããã®è©ããè§£æ¶ãšã¯ãµãµã€ãºããè¡ããŸãã
â» ã€ãã³ãã®ããã£ãããã¹ãã«é¢ããŠã¯ãåå ã¯ä»»æã§ãããæ³ãéããŠãäœã®äžèª¿ã«æ©ãŸãããªãããããããŠãæ¯æ¥ãããã©ããšéãããŠããããã«åœ¹ç«ã€ã®ã§ãªãã¬ãã·ã¥ããŠããã©ã€ããŠã¿ãŸãããïŒ
ã€ãã³ãäŒå Žãžã®åå æ¹æ³
â æ¬ããŒãžã®ãäŒå Žãã®æ¬ããããFitnessEngineerã®ãã£ããã«ãŒã ããã¯ãªãã¯ããŠãã ããã

â¡ãã©ãŠã¶ã«ãŠéããããŒãžã§ããDiscordã§éãããæŒããŠãã ããã

â¢Discordã¢ã«ãŠã³ãããæã¡ã®æ¹ã¯ãã°ã€ã³ããæã¡ã§ãªãæ¹ã¯ç»é²ããŠãã ããã

â£ãããŠãFitnessEngineerã®ãã£ããã«ãŒã ã«å
¥ã£ãããèµ€ã§å²ã£ããã€ãã³ãäŒå Žããšããé³å£°ã«ãŒã ã«ãŠã€ãã³ããè¡ããŸãããªããéã§å²ã£ãéšåã®åœæ¥ã®æ¥ã«ã¡ã®ã«ãŒã ïŒã€ãã³ãæ¥ã2020幎8æ1æ¥ãªããã#2020-8-1ãã®ã«ãŒã ãã¯ãªãã¯ããŠãã ãããïŒã«ãŠãè³æå
±æãªã©ãè¡ãããŠããã ããŸãã®ã§ãã¡ããåãããŠã確èªãã ããã

â€é³å£°ã«ãŒã ãã€ãã³ãäŒå Žãã«å
¥ãããããåœã€ãã³ãã®ãã¬ãŒã³ã¿ãŒããã©ã€ãïŒäžèšã®åçïŒããè¡ãªã£ãŠããã®ã§ããã©ã€ãããšããæåãã¯ãªãã¯ãããé
ä¿¡ãèŠãããæŒããŠãã ããã

æšå¥šç°å¢
- [å¿ é ]ã€ã³ã¿ãŒãããã«æ¥ç¶ã§ããPC
- [æšå¥š]ã¢ãã¿ãŒã«æ¥ç¶
- ãã³ãºãªã³ããŒãã§ã¯è€æ°ã®ãã£ã¹ãã¬ã€ã䜿çšã§ãããšæäœããããã§ããå¿ é ã§ã¯ãããŸãã
- Windows/Macã®ã©ã¡ãã§ãåå ããã ããŸã
泚æäºé
â» ãã¡ãã®ã€ãã³ãæ å ±ã¯ãå€éšãµã€ãããååŸããæ å ±ãæ²èŒããŠããŸãã
â» æ²èŒã¿ã€ãã³ã°ãæŽæ°é »åºŠã«ãã£ãŠã¯ãæ å ±æäŸå ããŒãžã®å 容ãšå·®ç°ãçºçããŸãã®ã§äºããäºæ¿ãã ããã
â» ææ°æ å ±ã®ç¢ºèªãåå ç³èŸŒæç¶ããã€ãã³ãã«é¢ãããåãåããçã¯æ å ±æäŸå ããŒãžã«ãŠãé¡ãããŸãã

ãåãåãã
é¢é£ããã€ãã³ã
ãåå¿è 察象ãUnityïŒæ¥éäžè¬åº§ïŒåºç€ç·šïŒ
2026/04/30(æš) éå¬
5/15ãçŸåœ¹ãšã³ãžãã¢ã®ç¡æãã£ãªã¢çžè«ä»ããAIç«¶äºã§éèŠæ¥å¢äžã®ãPythonããåŠãã§ãã£ãªã¢ã¢ãããç®æãã in æ±äº¬
2026/05/15(é) éå¬
ãããã¯ãŒã¯ãã³ãºãªã³ïŒCCNAå®ç¿ãAWSæ¥ç¶ã»L3ã¹ã€ããã»ãã¡ã€ã¢ãŠã©ãŒã«å®ç¿ïŒ
2026/04/29(æ°Ž) éå¬
ãåå¿è æè¿ã»ç¡æããŒãããå§ããClaude Codeè¬åº§
2026/05/02(å) éå¬
ãåå¿è æè¿ã»ç¡æããŒãããå§ããClaude Codeè¬åº§
2026/05/09(å) éå¬- TOP
- ã€ãã³ã
- #35ãSQLã§æ©æ¢°åŠç¿ãåŠãŒããéããŒã¿ãµã€ãšã³ãã£ã¹ãã®ããã®æ©æ¢°åŠç¿å ¥éãã³ãºãªã³ïŒ
