
ã³ã¢ã ãç°¡åã«ãã¿ããªã®SQLç§æ³ã¬ã·ã
mktcrmer8678
åå¿è ã®ããã®SQLã³ãŒãã£ã³ã°ã¬ã€ãïŒ SQLãäœæããè§£éããæ€èšŒã§ããç§æ³ãäŒæããŸãã
åçŽ
SQL, Big Data, Data Engineering
éçºè å¿æçãšããã°ããŒã¿å°±è·ã®ããã®å¿ é ç§ç®ïŒ
åè¬ç 34å
é£æåºŠ åçŽ
åè¬æé ç¡å¶é


MySQL
SQL
DB
ããŒã¿ããŒã¹
ååã
query
ããŒã¿
data
visualization
MongoDB
ã¿ãã
Tableau
çã®ããã®MySQLã倧åŠãšåãMySQLã®ãªã³ã©ã€ã³è¬çŸ©!!
ãã®è¬çŸ©ã§ã¯ïŒ
MySQL Workbenchã䜿çšããŠããŒã¿ããŒã¹ãäœæããããŒã¿ã®ã¢ããããŒã - 远å /åé€/ããŠã³ããŒã - ããã°ã©ãã³ã° - åæ - å¯èŠåããŸãïŒ
ãæè¿å¿
èŠãªã¹ãã«ã€ã³ããŒã¿ãæ±ãããšãç¥ã£ãŠããã¹ãã§ãããããããŒã¿ããŒã¹ïŒDBïŒã¯ãšãªãåŠã¶ã¹ãã§ããïŒã
ããæ¥ãŸããïŒ ããŠã¹ã®ã¯ãªãã¯ã§å§ããŠã³ãŒãã£ã³ã°ããçŽæ¥åŠã¶SQLè¬çŸ©ã§ãã
ã€ã³ã¹ãã©ã¯ã¿ãŒã«æ²¿ã£ãŠã³ãŒããæ¯æ¥å ¥åããªãããç°¡åãã€èªç¶ã«å 容ãç¿åŸã§ããããã«æ§æããŸããã
è¶ ïœäžçŽã¬ãã«ã®å®ç¿äžå¿ã§æ§æãããŠãããMySQL WorkbenchãTableauãStudio3TãMongoDBã䜿çšããŸãã
ãã®åž
ã人çã§èªåãæ¬²ããé¢çœãããšãããŠã¿ããããšèãã2016幎ã«ãã³ãã³çåŠéã«äžãããããŒã¿ãµã€ãšã³ã¹ãåŠã³ãŸããã
ç§ã¯è¬åž«ãšããŠãåè¬çã®çããã®è·åã驿§ãé²è·¯ãé¢çœããããããããšã«æ·±ãé¢å¿ããããŸãã
å±¥æŽ
Q. ã³ãŒãã£ã³ã°ããã ãšã©ãŒãçºçããæã¯ã©ããªããŸããïŒ
ãšã©ãŒã¡ãã»ãŒãžã®æåŸã®è¡ãèŠãŠããšã©ãŒã³ãŒããšã¡ãã»ãŒãžãSTACKOVERFLOW.COMãŸãã¯Googleã§æ€çŽ¢ããŠãã ããïŒ
Q. MySQLã¯ã©ãã§äœ¿çšããŸããïŒ
MySQLã¯ãäŒæ¥ãåŠæ ¡ãå ¬å ±æ©é¢ã®ããŒã¿ä¿åããŒã«ã§ãã
Q. NoSQLãšã¯äœã§ããïŒ
MySQLãæ°Žå¹³xåçŽãäžå®ã®ããŒãã«åœ¢åŒã®ããŒã¿ã§ããå ŽåãNoSQLã¯åã®æ°ãäžå®ã§ã¯ãªãèªç±ãªåœ¢åŒã®ããŒã¿ã§ãã
ðŸå®ç¿ïŒåŠç¿è³æã¬ã€ã
ð¢åè¬åã«ç¢ºèªããŠãã ãã
åŠç¿å¯Ÿè±¡ã¯
誰ã§ãããïŒ
ããŒã¿ç§åŠã人工ç¥èœã«èå³ã®ããæ¹
éçºè ã«ãªãããæ¹
ITéå°æ»è
å°±è·æºåç
倧åŠç/倧åŠé¢çãªã©åŠç
äŒç€Ÿå¡
SQLDåéšçãããã°ããŒã¿åæèšäºåéšç
è¬åž« ã€ã»ãã§ã³
人工ç¥èœé¢é£äŒæ¥ãéåœæŸéåºåæ¯èå ¬ç€Ÿãªã©ã§ãäŒç»ã»ã³ã³ãµã«ãã£ã³ã°æ¥åãéè¡ããŠããŸããã
ç§ã¯è¬åž«ãšããŠãåè¬çã®çããã®è·åã驿§ãé²è·¯ã楜ãããèå³ãããããããšã«æ·±ãé¢å¿ãæã£ãŠããã
çãããèªåèªèº«ã®å é¢çãªé²è·¯ãèŠã€ãããã£ãªã¢ãšããŠæãéããæåã§ãããããæäŒãããŸãïŒïŒ
䜿åœã«åŸããèª å®ã«æé«ã®è¬çŸ©ãæäŸããŸãïŒïŒ
(å ) ãã«ããã£ã³ãã¹ è¬åž«
(å ) åœæ°å€§åŠæ ¡ ãœãããŠã§ã¢èå倧åŠé¢ è¬åž«
(å) å å·ç§åŠæè¡é¢ 人工ç¥èœç ç©¶æ è¬åž«
(å ) ITã·ã¹ãã æ§ç¯ã»äŒç»ã³ã³ãµã«ã¿ã³ã
ãã³ãã³å€§åŠ ããŒã¿ãµã€ãšã³ã¹ä¿®å£«
ãœãŠã«å€§åŠæ ¡ ææå·¥åŠéš åŠå£«
å šäœ
81ä»¶ â (5æé 10å)
è¬åº§è³æïŒãããããããïŒ:
å šäœ
2ä»¶
3.5
2ä»¶ã®åè¬ã¬ãã¥ãŒ
åè¬ã¬ãã¥ãŒ 1
â
å¹³åè©äŸ¡ 5.0
5
åè¬çã®çæ§ 'ããŒã¿åæå®¶ãITãšã³ãžãã¢ã«å¿ èŠãªMySQLè¶ çæã³ãŒã¹ïŒ'ãåè¬ããŠããã ãããããšãããããŸãïŒ è¬åž«ã®è¬çŸ©è©äŸ¡ãšä»åŸã®è¬çŸ©çºå±ã®ããã现ããè©äŸ¡ããé¡ãããŸãã ã·ã«ãªãããã¿ã³ãªãã詳ããæžããŠãã ãã!!ð
åè¬ã¬ãã¥ãŒ 1
â
å¹³åè©äŸ¡ 2.0
2
è¬çŸ©å 容ãšã¯å¥ã«æè¡ãæç¶ãäžã®ãšã©ãŒã¯ãã£ãŠã¯ãªããªãã§ããããã çŸæç¹ã§ã¯ã次ã®ã¬ãã¹ã³ããªããããæè¡ãšã©ãŒã§ãããåçã§ããŸããã ã»ã¯ã·ã§ã³5ïŒçžäºçµå ã»ã¯ã·ã§ã³9ïŒå šäœ 解決ããé¡ãããŸãã
ããã«ã¡ã¯ïŒ 'ãã¹ãŠã®MySQL'ãåè¬ããŠããã ãããããšãããããŸãã ãè¿·æããããããŠç³ãèš³ãããŸããã§ããã ããã質åããããŸããããä»ã®ããã«æ®ããŠãã ããã è¯ãè¬çŸ©ã§ãè¿ãããŸããããããšãããããŸãïŒ :)
åãåéã®ä»ã®è¬åº§ãèŠãŠã¿ãŸãããïŒ