åºæ¬æ å ±æè¡è 詊éšã«åãã£ã話~å匷æ³ãªã©~
ããã«ã¡ã¯ããã§ã»ãã³ãã³ã§ãã

å æ¥ãåºæ¬æ å ±æè¡è 詊éšãšãããã®ã«åæ ŒããŸãããåºæ¬æ å ±æè¡è 詊éšãšã¯ãã·ã¹ãã ã»ãšã³ãžãã¢ãã¯ãããšããITäŒæ¥å€åè ãæåã«åãè³æ Œã®ãããªãã®ã§ããçµæžç£æ¥å€§è£ãä»åã£ãŠããåœå®¶è³æ Œã®äžã€ã§ã倧åŠçã«ãšã£ãŠã¯å°±æŽ»ã®æã®æŠåšã«ãªãã瀟äŒäººã«ãšã£ãŠã¯è»¢è·ã®æŠåšã«ãªã詊éšã§ãã
åæ Œçã¯å¹³å20%ããããšãå°ãå³ãããã®ããããŸããæ¯å¹Ž4æã»10æã«éå¬ãããã®ã§ãåéšãã£ã³ã¹ã¯æ¯èŒçå€ã詊éšãšãªã£ãŠãããŸãã
ç§ã¯ã·ã¹ãã ã»ãšã³ãžãã¢ãšããŠåããŠãããã®ã®ã瀟äŒäºº3幎ç®ãšé ããªããã®ååŸãšãªããŸãããä»åã¯ãåéšã®çµç·¯ããå匷æ³ãŸã§èªã£ãŠããããšæããŸããåéšãèããŠããæ¹ã®è¯ãã¢ããã€ã¹ã«ãªãã°ãšæããŸãã
åéšåæ©
â»é·æãªã®ã§ãèªã¿é£ã°ããŠããã£ãŠçµæ§ã§ãã
å®ã¯ã2åãã®è©Šéšã«èœã¡ãŠãããä»å3床ç®ã®æ£çŽã§åããŸãããäœçšã®çç±ããªããã°ãæ¯å5,700åãã®ãéãæã£ãŠ3åãåéšããªãã¯ãã§ããäœæ ãç§ããããŸã§ããŠååŸããã®ãã«ã¯çç±ããããŸãã
ããã¯ãºããªã瀟äŒäºº3幎ç®ãšãªãããã£ãªã¢ãã¹ã«ã€ããŠèããããã«ãªã£ãŠããããã§ãã
ç§ã¯é«æ ¡æä»£ãããã³ã³ãã¥ãŒã¿ã«ã¯èå³ãæã£ãŠããŠã髿 ¡2幎çã®æã«ã¯ã¢ã¡ãªã«ã«çæITçåŠãããå€§åŠæä»£ã«ã¯é«æ ¡æ å ±ç§ã®æå¡å èš±ãååŸããçºã«ãããã°ã©ãã³ã°ã®å匷ãããŠããã®ã§ãããæåããããã°ã©ãã³ã°ã¯å«ãã§ãããæ£çŽãèš³ãåãããªãã£ãã®ã§ããããã°ã©ãã³ã°ã¯æžããéãã«ããåããªããšããã®ã¯ãååãããããã®ã§ãããããäºãããçºã«å¿ èŠãªãã®ãçšæããŠãããã«ãã®å¿ èŠãªãã®ãçšæããçºã«å¥ã®ãã®ãçšæãããšããç ©éãã«ãã©ã¹ãã¬ãŒã·ã§ã³ãæºãŸããŸããã
å°±æŽ»ã®æã¯ãæåããããã°ã©ãã³ã°ãSEã®éãé¿ããŠããã®ã§ããã120瀟è¿ãèœã¡ãŠããŸã就掻ææãæè²å®ç¿ãšéãªã£ãŠããããšããããçŠãããéäžã§ITäŒæ¥ãåéšããããã«ãªããŸãããå®éã«å°±æŽ»ãããŠæ°ã¥ããããšãªã®ã§ããã髿 ¡æ å ±ç§ã®æå¡å èš±ãæ¡çšããŠããçã¯ã»ãšãã©ãªããããæ å ±ç§æè²ã ããã°ã©ãã³ã°æè²ã ãšå«ã°ããªããæ¥æ¬ã®æè²çŸå Žã¯æ°åŠãç©çã®å çããããã¯ãã ã®ããœã³ã³ãªã¿ã¯ãæããŠãããšããã²ã©ãç¶æ³ã«å¹»æ» ããŸããã
ããã§ä»ã®äŒç€Ÿã«å€ããŠããã®ã§ãããåããŠã¿ãŠããã®ä»äºãèªåã«åããŠããªãã®ã§ã¯ãšæãããã«ãªããŸãããç§ã®å€ããŠããäŒç€Ÿã¯120瀟以äžèœã¡ãæ«ã«å ¥ã£ãäŒç€ŸãšããŠã¯ã³ã£ããããããããã¯ã€ãäŒæ¥ã§ããäŒç€Ÿã®é£²ã¿äŒã§ãäžèžãæ«é²ãããããªããšããªãããSNSã調ã¹ãããããšããªããåæ¥ç¥æ¥ã¯å®å šã«äŒã¿ã§ãã©ããªã«æ¡ä»¶ãçäžããŠããŠãæçµŠã¯åãããŠããããåºæ¬çã«ã¯ãé ããŠã20æã«ã¯ç€Ÿå¡ã®ã»ãšãã©ãããªããªãäŒç€Ÿã§ãããŒãã¹ã幎2åããããããã¯ãã©ã»ã¯ãã©ã¯ãã¡ãããªãã
ãã ãããã ãã«èªåã®ä»äºã®é ããäžåºæ¥ãã«å¹»æ» ããŠããã®ã§ããã³ãŒãã£ã³ã°ã®æ¥åã§ã¯ã倿°ãã倿°ã远ã£ãŠãããã¡ã«é ã®äžããšã£æ£ããããå šãæ¯ãç«ããªããææžã¯ãæ¯å现ãããšãããææãããçŽè¡çãæªããŠãããããããã©ããªã«çšæããŠãã£ãŠããè«ççã«è©°ããããŠå·®ãæ»ããé£ãã£ãŠããŸããäžåžãå 茩ã®è©±ã¯è«ççã§åè«ã®ããããã§ããªããããå®ç§ã§ãèšèãåžžã«æ£ç¢ºãªèšèã䜿ã£ãŠããæ ã«è©±ãåã¿åããªããäœæ ãç°å¢èšå®æžã»ç°å¢èšèšæžã¿ããã«çŽããããããã¥ã¡ã³ããå€ãã®ã«åœŒãã¯ééããªãã®ããã ãã ãèªåã«èªèº«ããªããªããééãããããªãå Žæã§ããã¹ãããå 茩ããæããããå 茩ããè«ççæèã空æ°ãåžãããã«ã§ããã®ã§ããããã§ããªãèªåãçè§£ããŠããããªããèªåããè«ççéããå 茩ãäžåžã®ããšãããããããªããªãããããŠèªåã®èšæ¶ã§ã¯ããã¯ééã£ãŠããªãã¯ããªã®ã«ééã£ãŠããããšãé »çºããããã«ãªã鬱ã«ãªã£ãŠãããŸããã
æè¿ããããžã§ã¯ããããŒãžã£ãŒã«æé²ããã®ã§ãããäœãæ£ãããŠäœãæ£ãããªãã®ããåãããªããªããææãããã¯ã«ãªã£ãããèšèãåã£ãŠå 茩ã«äœãåãçãããã§ããªããªãããšããããæããããšã¯å¥œãã§ãåŸèŒ©æå°ã¯åŸæãåŸèŒ©ãšã®ä»²ã¯è¯å¥œãªã®ã§ãããæ°äººæè²ã¯ãªããªãææŠãããŠããããªãããã®ãŸãŸã ãšç²Ÿç¥çã«èªåãæœ°ãããªãšæããŸããã
ããããŠæ¬æ Œçã«èªåã®ãã£ãªã¢ãèŠçŽãããšã«ãªã£ãã®ã§ãã
ããèããéã«ãäžã€ã転è·ãšããæãè³è£ããã©ã€ããŸããããã ãä»ãã®ãŸãŸé¢è·ããŠããäœãæŠåšããããŸãããæ¢ã«å°±æŽ»ã®æã®èŠåŽãããã®ã§ãæŠåšãªãã§è»¢è·æŽ»åããŠãå³ããããšã¯ç®ã«èŠããŠããŸãã
ãŸãç§ã®ç¹æã§ãããç©æžãã¹ãã«ãç¹ã«æ ç»ã芳çµãã£ãé ã«ã¯æ°ååã®ææ³ãè³è£ã«ã§ããŠããèœåã¯è»¢è·ã§ã¯åœ¹ã«ç«ããªãã§ããããç§ãããã°ãæ¯æ¥æžããŠããã®ãããã¯ãããŸã§è¶£å³ã®ç¯çã§ãããæ®éã®è·æ¥ã§ã¯å šã圹ã«ç«ããªãã¹ãã«ã§ããã
ã ã£ããã2åèœã¡ãåºæ¬æ å ±æè¡è 詊éšã«åããæŠåšãšããæ¹ãè¯ãã§ããããšèããŸãããã·ã¹ãã ãšã³ãžãã¢ã§åºæ¬æ å ±æè¡è 詊éšåæ Œè ãšããèœãäœã£ãŠããããšã¯ååæŠåšã«ãªãã¯ãã ã

ãããŠãæ¥å¹Žããåºæ¬æ å ±æè¡è 詊éšã¯ãåºé¡èŠçŽããè¡ãããååŸè©Šéšã«ããããããŒã¿æ§é åã³ã¢ãªãŽãªãºã ããšããœãããŠã§ã¢éçºãã®é ç¹ãåèš40ç¹ãã50ç¹ã«åŒãäžãããããŸãç¹åãåé¡ã§ããããããžã§ã¯ããããžã¡ã³ããããã·ã¹ãã æŠç¥ãããçµå¶æŠç¥ãã«é¢ããåºé¡ã2åãã1åã«æžããããŠããŸããšã®ããšã§ãã
ç§ãåããã«ã¯ä»åãããªããšæãåéšããŸããã
â»æ¥å¹ŽåºŠããCOBOLã詊éšç§ç®ãããªããªã代ããã«Pythonãåéšã§ããããã«ãªããŸãã

çµæã¯ãããªæãã§ããåå67.50ç¹ãååŸ64.00ç¹ãšã®ãªã®ãªã§ãããåæ Œããããšãã§ããŸãããåååé¡ã¯ãåºé¡åŸåèŠçŽããæ¢ã«è¡ãããŠããããã§ãããããšçæ°ç³»åé¡ãå€ããŠçŠããŸãããæ°åŠããã®åé¡ã§ãªããšããã©ããŒããŸãã(ç§ã¯æ°åŠã ãåŸæã§ãç©çãæ å ±å·¥åŠãçµ±èšæ°åŠã«ãªããšæ¥ã«èŠæã«ãªãåŸåããããŸã)ã
ååŸåé¡ã¯ãäžåºŠCèšèªããä»äºã§ãã£ãŠããéšåã®åºé¡ã ã£ãã ãã«åœæŸãããŸããã

仿ãéµäŸ¿å±ããããè³ç¶ãå±ããŸãããæ£çŽããã¡ããã¡ãå¬ããã£ãã§ãã
ããŠããããªç§ã®å匷æ³ãæžããŠããããšæããŸãã
ææ

ææã«é¢ããŠã¯ãåºé¡åŸåèŠçŽãããã£ããšããŠãæ¬2å+åéšèšèªã«é¢ããæ¬1å+åéšå¯Ÿçãµã€ãã®4çš®é¡ã§ååã ãšæããŸãã
1.åºæ¬æ å ±æè¡è 詊éšåæ Œææ¬(æè¡è©è«ç€Ÿ)
åºæ¬æ å ±æè¡è 詊éšã¯ITäŒæ¥ã«åããäººå šè¬åãã®è©Šéšãªã®ã§ãåºé¡ç¯å²ãç°åžžã«åºãã§ãããããã¯ãŒã¯ãããŒããŠã§ã¢ã®ããšã¯ãã¡ãããæ³åŸãçµå¶ã«é¢ããããšãªã©å€å²ã«æž¡ã£ãŠããŸãããããç¶²çŸ ããŠããæ¬ãããã§ãããããæäœã§ã5åšã¯èªã¿èŸŒã¿ãå顿ã«åºãŠããçšèªãæ¬ã®ã©ã®èŸºã«æžãããŠãããæãæµ®ãã¶ããã«ãªããŸã§ããŠããã°åååé¡ã¯å€§äžå€«ã ãšæããŸãã
2.åºããšãã ã!åºæ¬æ å ±æè¡è ååŸ(ç¿æ³³è )
æ£çŽãè³æ Œè©Šéšã®å¯Ÿçæ¬ã¯ã©ã®è©Šéšãããã§ããäœã䜿ã£ãŠã倧ããããšãªããšè³æ Œãã³ã¿ãŒã§ããç§ã¯æããŸãã倧æµãæ¬ããã¡ã ãšèšã£ãŠãã人ã¯ããã£ãããã®æ¬ãæãèªã¿èŸŒãã§ããªãåŸåããããŸããããã§ãç§ãèšãããã®ã¯ãååãšååŸã®å¯Ÿçæ¬ã¯å¥ã ã«è²·ã£ãæ¹ããããšèšãããšã§ããååã®ãã¹ãã«åæ Œããã®ã¯ç°¡åã§ããç§ã¯3ååéšããŠå šãŠåæ ŒããŠããŸããåé¡ã¯ååŸã§ãåååé¡ã®ç¥èãå¿çšãããã ãã§ãã?ãšãªããŠããããšçãç®ã«ãããŸãããšããã®ããã©ãããåºæ¬æ å ±æè¡è 詊éšã¯å¶ç¶ã«ããæ£è§£ãäžæ£è§£ãšã¿ãªãåŸåãããã倧åã®ååã§ééãããšããã®åŸå šãŠã®åé¡ãããã«ãªãå Žåããããã ãšããã ããèªèº«ããã£ãŠããäœæ ãèœã¡ãŠãããããã®ã§ãã
ç§ã®å Žåã1åç®ã¯3æ¥ããããã察çããªãã£ãããå šãæ¯ãç«ããææ²ã2åç®ã¯å¯ŸçããŠåéšãããã®ã®ãã©ããã§å€§å¹ åç¹é£ãã£ãããã§èœã¡ãŠããŸãã
3åç®ã®åéšãã®ãªã®ãªã§ããããšãããèã¥ãåŒã«äžæ£è§£ãé£ãã£ãŠããå¯èœæ§ãé«ãã§ããããŠããããªååŸåé¡å¯Ÿçæ¬ã«éžãã ãåºããšãã ã!åºæ¬æ å ±æè¡è ååŸãã¯ç¹åãåé¡ã§ããSQLããåããã°æ¥œåãªèšç®ãè«çæŒç®åé¡ãäŸé¡ã€ãã§åããããã解説ããŠããæ¬ã§ãã3åç®ã®åéšã®æã¯ãå°ããã®æ¬ãçèªããŠæã¿ãŸããã
çç³»ã®åé¡ãèŠæãªäººããæäœéSQLãšè«çåè·¯ãæ±ºå®è¡šé¢ä¿ã®åé¡ã¯å®ç§ã«ããŠãããŸããããããã ãã§åæ Œçã¯ã°ããšããããŸãã
3.åéšèšèªã«é¢ããæ¬1å
äžèšã®æ¬ã«ã¯ããœãããŠã§ã¢éçºã«é¢ãã察çã¯æ²èŒãããŠããŸããããããããªããããã°ã©ãã³ã°ãæ¥åã§è¡ãªã£ãŠããã®ã§ããã°ãæ¥åãéããŠèŠããŠããæ¹ãå¹çè¯ãã§ãããã匷ããŠèšãã°ãåéšèšèªã«é¢ããæ¬ã1åèªã¿èŸŒãã§æãã æ¹ãè¯ãã§ãã
ç§ã®å Žåã¯ãä»äºãå¿ãããå匷æéãããŸãåããªãã£ãã®ã§ãæ¥åããªããCèšèªå¯ŸçããŸãããä»åã¯å¥è·¡çã«ãããããå¶åŸ¡ãœããä¿®æ£ã§åŠãã ãããæŒç®ã®ç¥èã倧掻èºããŠåå©ã«å°ãããšãã§ããŸããã
4.åºæ¬æ å ±æè¡è éå»åéå Ž

æ£çŽãäžçªå¹çã®ããå匷æ³ã¯ãåºæ¬æ å ±æè¡è 詊éšã®éå»åããšã³ãã¬ã¹ã«è§£ãããšãã§ããåºæ¬æ å ±æè¡è éå»åéå Žãå»¶ã ãšè§£ããŠããããšã§ããããååŸåé¡ã®è§£èª¬ã匱ããšãããé£ç¹ã§ããããµã¯ãµã¯åé¡ã«ææŠã§ããã®ã§ãæŒäŒã¿ãä»äºã®åéãäŒæ¥ã«ããããã£ãšãã£ãŠããŸãããç§ã®è·å Žã¯ãå匷ãä»äºæéäžã«ããããšã«ã€ããŠæ¯èŒçå¯å®¹ã§ã寧ãèªåã«ã¯ä»äºã«å·®ãæ¯ããªãçšåºŠã«å匷ããªãããšäžåžãèšã£ãŠãã ãã£ãã®ã§ãç©æ¥µçã«å匷ããŸããã
ååŒ·æ¹æ³
åºæ¬çã«ç§ã®å匷ã¹ã¿ã€ã«ã¯ããšã«ããæç§æžãèªã¿èŸŒããåé¡ãèªã¿èŸŒããšããããå§ãŸããŸãããã ããŸãšããŠæéããšã£ãŠå匷ããã®ãèŠæãªç§ã¯ãæŒäŒã¿ãé»è»ã«ä¹ã£ãŠããæãééæéãæŽ»çšããŠå匷ããŠããŸããã
åºæ¬æ å ±æè¡è 詊éšã®å ŽåãååãšååŸåé¡ã¯å¥ã ã«å¯Ÿçããå¿ èŠããããŸããååäžã®èšç®åé¡ãããã§ãããæ¯èŒçèšç®ããåé¡ãå€ãã®ã§ããããã£ãåé¡ã®å¯Ÿçãããå Žåã«ã¯èœã¡çããå Žæã§ãã£ããè °ãæ®ããŠå匷ããæ¹ãè¯ãã§ããç¹ã«èšç®åé¡ã¯ããã£ãããã³ã䜿ã£ãŠæžããŠå匷ããªããšãã€ãã€ãå匷ããæ°ã«ãªã£ãŠãæ¬çªãããã¯ã«ãªããŸãã
ãŸãã詊éšçŽåã«ã¯å®éã«æéãæž¬ã£ãп𡿬ãã¹ããããæ¹ãè¯ãã§ããååã»ååŸ2æéåãã€ãšããé·äžå Žã§ãããååŸã¯æ¬åœã«æéããªããªããŸãã
æ¬çªåœæ¥
æ¬çªã¯æ°ãå®ããã«åéšããŸããããåæ¥ã¯æ©ãã«å¯ãŠäœèª¿ãæŽããããšã倧äºã§ããååã¯è§£ããªãåé¡ããã£ããããã§ãã¯ã€ããŠé£ã°ãèŠæã§ãšããããäžéãè§£ããŸãããããã®åŸã«åä»ãªèšç®åé¡ãçŽããããåé¡ããã£ããè§£ãããã«ããã°é ããŠã30ååã«ã¯çµããããããšãã§ããã§ãããã
ååŸã¯ãè§£ãå§ããåã«ãäžéãåé¡ããã§ãã¯ããç°¡åãããªåé¡ããã§ãã¯å ¥ããŠãããŸãããããœãããŠã§ã¢éçºåé¡ã¯ãåéšèšèªãšäžå¿è¡šèšç®ãœããåé¡ãæ¯èŒããåéšèšèªãé£ããããå Žåã¯è¡šèšç®ãœããåé¡ã«éããããšã念é ã«å ¥ããŠèšã¿ãŸãããã
åºæ¬çã«ãååŸåé¡ã¯äžåŠåéšã»é«æ ¡åéšã®åœèªåé¡ã«è¿ããšèšããŸããããã«èªåã®å å ¥èŠ³ãåžžèã«åããããèšå€§ãªæç« ã®äžã«é ããããã³ããçµã¿åãããŠè«ççã«è§£ããŠããã®ããã³ãã§ããç§ã¯è«ççæèãéåžžã«åŒ±ãã£ãã®ã§ããããã£ãããšæç« 1è¡ãã€èªã¿èŸŒã¿ãçããæ¢ããŠãããŸããã
åéšããããŠ...
詊éšã«åæ Œããã®ã§ãçŽå±ã®äžåžã«å ±åãããåãã§ããããŸããããã ãç§ã®äŒç€Ÿã¯ãè³æ Œæåœããªããã§ããã...ãäžåºŠã瀟å èŠåã®æ¹å®ææã ã£ãã®ã§ãç©ç³ããŠã¿ãŸããããã ãèŠæãªå 茩ããã¯ãè³æ ŒæåœãŠãªããŠçµŠææ³¥æ£ã ããä»äºãã§ãããã©ããã§ãã?ããšé£²ã¿ã®åžã§èšããããã¯ãæºã¯æ·±ããŸãŸã ãªãšæããŸããããŸããæè¿ã®ããžãã¹æŠç¥ãã¿ãŠããŠãããã®ãŸãŸã¬ããŸæ¹¯ã®ãããªç°å¢ã«ãããšããã§ããžãªãžãªåèœããŠããã ãããé ã®çé ã«èªåã®ãã£ãªã¢ãã¹ãæãæµ®ãã¹ãªããšããããçãç®ãèŠããšæããŸããã
転è·ãããã¯ããŠãããäžã€æŠåšãæã«å ¥ããŸããã2020幎代ã¯ã€ã³ããã·ã¢ãèºé²ããã°ããŒãã«ããžãã¹ã®äžå¿ã«ãªã£ãŠãããšããã®ã§ããã£ãªã¢ã®å¹ ãåºããçºã«ã€ã³ããã·ã¢èªæ€å®ã§ãåããŠã¿ããããª?
ãšããããã§ãæ¥å¹Žä»¥éåããæ¹ã®å¥éãç¥ããŸãã
ãããªãšæã£ããå¿æŽãããïŒ
æ ç»ããã°ããã§ã»ãã³ãã³ã®ãã£ãŒããã®ç®¡ç人ã§ãããããããã°ãµããŒããããããé¡ãããŸããè¬ã®æ ç»æ¢ãã®è³éãšããŠæŽ»çšãããŠããã ããŸãã