1. ã¯ããã«
æåã«ãSQLãšããèšèã«ã€ããŠå ·äœçã«ç解ãããããã©ã掻çšãã¹ããã®èŠç¹ãæã€ããšããå§ããŸãããã
1.1 SQLãšã¯
SQLãšã¯ãé¢ä¿ããŒã¿ããŒã¹ç®¡çã·ã¹ãã ïŒRDBMSïŒã§ããŒã¿ãæãããã®èšèªã§ãã”Structured Query Language”ã®é æåããšã£ããã®ã§ããã®åã®éããæ§é åãããåãåãããè¡ãããã®èšèªã§ãã
å ·äœçã«ã¯ãããŒã¿ã®æ¿å ¥ãæŽæ°ãåé€ãªã©ã®ããŒã¿æäœã®åºæ¬çãªæäœå šè¬ãè¡ããŸãããŸããããŒã¿ã®éžæããœãŒãã®ãããªåãåããããããŒã¿ããŒã¹ãã®ãã®ã®äœæãå€æŽãå¯èœã§ãã
1.2 SQLè³æ Œã®å¿ èŠæ§
ã§ã¯ããªãSQLã®è³æ Œãå¿ èŠãªã®ã§ãããããããã¯ãèªèº«ã®ã¹ãã«ã客芳çã«è©äŸ¡ããããããããŠããã蚌æããããã§ãã
æè¡ã®äžçã§ã¯ããåºæ¥ããåºæ¥ãªããããéåžžã«éèŠã§ãããã®ããã客芳çã«èªåã®ã¹ãã«ãè©äŸ¡ããæ段ãã»ãããšããã§ããSQLè³æ Œã¯ããã®äžå©ãšãªã蚌ææžã§ãã
ããã«ãSQLè³æ Œã¯äººæåžå Žã§ã®ä¿¡é Œæ§åäžã«ãã€ãªãããŸããèªåã®ã¹ãã«ã蚌æã§ããã°ãæ±äººåžå Žã§ã¯åªéãããŸãããã¹ãã«ã¢ãããå³ãäžã§ãæå©ã«åããŸãã
ãããã£ãçç±ãããç§ãã¡ã¯SQLè³æ Œãç®æãã¹ãã§ãã
2. SQLè³æ Œã®çš®é¡
SQLã®ç¥èã蚌æããè³æ Œã«ã¯ã©ã®ãããªãã®ãããã®ã§ãããããäž»èŠãªãã®ãšããŠã¯Oracleèªå®è³æ ŒãMOSïŒMicrosoft Office SpecialistïŒSQLèªå®è©ŠéšããããŠæ¥æ¬æ å ±æè¡è è©ŠéšåäŒïŒITPECïŒã®è³æ ŒãæããããŸããããããã®è©³çŽ°ã«ã€ããŠèŠãŠãããŸãããã
2.1 Oracleèªå®è³æ Œ
Oracleèªå®è³æ Œã¯ãäžççãªããŒã¿ããŒã¹ãœãããŠã§ã¢äŒæ¥ã§ããOracle瀟ã®è£œåã«é¢ããç¥èã蚌æããè³æ Œã§ãããã®äžã§ãOracle Database SQLèªå®è©Šéšã¯ãSQLã®ç¥èãåãè©Šéšãšãªã£ãŠãããSQLæã®äœæãããŒã¿ããŒã¹ã»ãªããžã§ã¯ãã®ç解ãªã©ãæ±ããããŸããäžã€ã®è³æ Œãšã¯ãããåå¿è ããäžçŽè ãŸã§å¹ åºãã¬ãã«ã®èªå®è©ŠéšãååšããŠããŸãã
2.2 MOSïŒMicrosoft Office SpecialistïŒSQLèªå®è©Šéš
MOSïŒMicrosoft Office SpecialistïŒSQLèªå®è©Šéšã¯ãMicrosoft瀟ãèªå®ãããå ·äœçãªæè¡ã¹ãã«ã蚌æããè©Šéšã§ããSQL Server補åã®æäœãæ§ç¯ã«å¿ èŠãªç¥èãåãè©Šéšã§ãã¯ãšãªã®äœæããSQL Serverã®ããŒã¿ããŒã¹å®è£ ãªã©ãå®è·µçãªå 容ãå€ãè©ŠéšãããŸãã
2.3 æ¥æ¬æ å ±æè¡è è©ŠéšåäŒ(ITPEC)ã®è³æ Œ
ãããŠæåŸã«æ¥æ¬æ å ±æè¡è è©ŠéšåäŒïŒITPECïŒã®è³æ ŒãåãäžããŸããITPECã¯ã¢ãžã¢ååœãååããŠå®æœããŠããè©Šéšã§ããã®äžã§ããã£ãªãã³åœå®¶è©ŠéšïŒPNCïŒããããã åœå®¶è©ŠéšïŒVNCïŒãªã©ãååœèªã§ã®SQLã®è³æ ŒãååšããŸããSQLã䜿ã£ãããŒã¿ããŒã¹èšèšã管çãããã°ã©ã ã®äœæçãåºç€çãªç¥èããå®è·µçãªã¹ãã«ãŸã§åãããè©Šéšå 容ãšãªã£ãŠããŸãã
3. åè³æ Œã®å ·äœçãªå 容ãšé£æ床
ããŸããŸãªSQLè³æ ŒãååšããŸãããããã§ã¯äž»èŠãª3ã€ã®è³æ ŒãOracleèªå®è³æ ŒãMOS SQLèªå®è©ŠéšããããŠITPECã®SQLè³æ Œã«ã€ããŠãã®å 容ãšé£æ床ã«ã€ããŠè§£èª¬ããŸãã
3.1 Oracleèªå®è³æ Œã®å 容ãšé£æ床
Oracleèªå®è³æ Œã¯ãããŒã¿ããŒã¹ç®¡çã®ã¹ãã«ã蚌æããåœéçã«èªç¥ãããŠããè³æ Œã§ãããã®äžã§ããOracleèªå®SQLåºç€1ã¯ãSQLã®åºæ¬çãªç¥èãšæè¡ãåãè©Šéšã§ãããŒã¿ããŒã¹ã®åçŽè ã«åããå 容ã«ãªã£ãŠããŸãã
é£æ床 | åçŽ |
è©Šéšæé | çŽ2æé |
è©Šéšåœ¢åŒ | éžæåé¡ |
åæ Œç¹ | 60ïŒ |
3.2 MOS SQLèªå®è©Šéšã®å 容ãšé£æ床
Microsoft Office Specialist (MOS) SQLèªå®è©Šéšã¯ãMicrosoftã®ããŒã¿ããŒã¹ç®¡çã·ã¹ãã ã§ããSQL ServerãçšããããŒã¿ããŒã¹ç®¡çã®ã¹ãã«ã蚌æããè³æ Œã§ããå®éçãªåæãããŒã¿ããŒã¹ã®éçºãéçšã«é¢ããç¥èãªã©ãåãããŸãã®ã§ãåçŽããäžçŽè åãã®å 容ãšãªããŸãã
é£æ床 | åçŽïœäžçŽ |
è©Šéšæé | çŽ2æé |
è©Šéšåœ¢åŒ | éžæåé¡ãšå®æè©Šéš |
åæ Œç¹ | 70ïŒ |
3.3 ITPECã®SQLè³æ Œã®å 容ãšé£æ床
ITPECã®SQLè³æ Œã¯ãã¢ãžã¢ååœã§å ±éã«è¡ãããæ å ±æè¡è è©Šéšã®äžã€ã§ãããããŒã¿ããŒã¹ãSQLã«é¢ããåºæ¬çãªç¥èãåãããŸããå ¥éè ã§ãåãçµã¿ãããå 容ã§ãããªãããå¹ åºãç¥èãæ±ãããããããåçŽããäžçŽè åããšãããŸãã
é£æ床 | åçŽïœäžçŽ |
è©Šéšæé | çŽ2æé |
è©Šéšåœ¢åŒ | éžæåé¡ |
åæ Œç¹ | 60ïŒ |
åè³æ Œã®å ·äœçãªå 容ãšé£æ床ãææ¡ããããšã§ãèªåã®ã¹ãã«ã¬ãã«ãç®æãæ¹åæ§ã«åã£ãè³æ Œãéžã¹ãŸãããŸããè©Šéšã®åœ¢åŒãåæ Œç¹ãåèã«ããŠãå¹ççãªåŠç¿èšç»ãç«ãŠãŸãããã
4. ããå ·äœçãªSQLè³æ ŒååŸã®æ¹æ³
äœããããŸããSQLè³æ ŒãååŸããããã«ã¯ããã®åºç€ãšãªãç¥èãå¿ èŠãšãªããŸãã
4.1 SQLã®åºç€ç¥èã身ã«ã€ãã
SQLã®åºç€ç¥èã身ã«çããããã«ã¯ãããŒã¿ããŒã¹ã®æ§é ãç解ããåºæ¬çãªã¯ãšãªïŒSELECTãINSERTãUPDATEãDELETEïŒã®äœ¿ãæ¹ãšãã®æ§æãç解ããããšãæ±ããããŸãããŸãããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã®çè«ãæŒãããŠããå¿ èŠããããŸãããããã®ç¥èããããšãå ·äœçãªæ¥åãè©Šéšåé¡ã«å¯ŸããŠãé©åãªSQLã®ã³ãã³ããéžæããå¹ççãªåé¡è§£æ±ºãå¯èœãšãªããŸãã
4.2 å匷ã®ã³ããšããããææ
SQLã®åŠç¿ã«ã¯ãäžå®ã®æéã確ä¿ããŠå埩çã«åŠç¿ããããšãæå¹ã§ããæ¯æ¥äžå®æéã®åŠç¿ãç¶ããããšã§ãå°ããã€ã§ãã確å®ã«ã¹ãã«ã¢ãããå³ããŸãããŸãããªã³ã©ã€ã³ã®æè²ãã©ãããã©ãŒã ãããã¹ãããã¯ããåŠã¶ããšãããããã§ããç¹ã«ãããã°ã©ã åŠç¿ãµã€ãã§ããProgateãæžç±ã§ãããããããåŠã¶SQLãã¯ãåºæ¬çãªæžãæ¹ããå¿çšãŸã§æ®µéçã«åŠç¿ã§ãããããå¹æçã§ãã
4.3 è³æ Œè©Šéšã®ç³ã蟌ã¿æ¹æ³
åºç€ç¥èã身ã«ã€ããããè³æ Œè©Šéšãåããããã®ç³ã蟌ã¿ãããŸããåè³æ Œã«ã¯ããããç³ã蟌ã¿æ¹æ³ãç°ãªããããäŸãã°Oracleèªå®è³æ Œã§ããã°ãOracle Universityã®ãŠã§ããµã€ãããç³ã蟌ã¿ãè¡ããŸããç³ã蟌ã¿ã®éã«ã¯ãè©Šéšæ¥ãè©ŠéšäŒå Žãéžã³ãŸãããªããCOVID-19ã®åœ±é¿ã§ãäžéšã§ãªã³ã©ã€ã³è©Šéšãå®æœãããŠããããšãããããããã®åéšç°å¢ããã確èªããèªåã«åã£ã圢åŒã§ç³ã蟌ãããšã倧åã§ãã
4.4 è©Šéšåœæ¥ã®å¿åŸ
è©Šéšåœæ¥ã¯ãåæ¥ã«ååãªç¡ç ãåããç©ãããªå¿æã¡ã§æãããšã倧åã§ãããŸããè©Šéšã¯çŽ°éšãŸã§ç解ããå¿ èŠããããããæ·±ãèããããŠæéã䜿ãæãããªãããã«æ³šæãå¿ èŠã§ããåé¡ããšã®æéé åãæèããã¹ã ãŒãºã«åçã§ããããã«ããŸããããè©Šéšã¯ç¥èãè©Šããã®ã§ããããããšåæã«èšåãç解ããé©åã«è§£çããåãè©ŠãããŸãã
5. SQLè³æ Œãæã€ããšã®äººæåžå Žã§ã®å¹çš
ããSQLè³æ ŒãååŸãããšããã§ããã®åŸå ·äœçã«ã©ã®ãããªå©ç¹ãããã®ã§ãããããããã§ã¯ãSQLè³æ Œãããããå¯èœæ§ã就掻ããã£ãªã¢ã®èŠ³ç¹ããèããŠã¿ãŸãããã
5.1 就掻ããã£ãªã¢ã«ã€ããŠ
SQLè³æ Œã¯å°±æŽ»ãããããã®ãã£ãªã¢ã«å€§ããªåœ±é¿ãäžããŸããç¹ã«ãITæ¥çãå¿æããæ¹ã«ãšã£ãŠã¯ã競äºåãæ Œæ®µã«åŒãäžãããã®ãšãªããŸããSQLã¯ããŒã¿åæãã·ã¹ãã éçºãªã©ãå€ãã®ITé¢é£æ¥åã§å¿ é ãšãããã¹ãã«ã§ãããã®ãããSQLè³æ Œãæã€ããšã¯äŒæ¥ãžã®èªå·±PRããé¢æ¥ã§ã®å·®å¥åã«æå©ãšãªããŸãã
5.2 ã¹ãã«ãã©ãã·ã¥ã¢ãããšèªå·±æé·ã®èŠ³ç¹
次ã«ãã¹ãã«ã®ãã©ãã·ã¥ã¢ãããèªå·±æé·ã«ã€ããŠèããŠã¿ãŸããããSQLè³æ Œã®ååŸã¯ãèªèº«ã®ã¹ãã«ã»ãããé«ããã ãã§ãªããåŠç¿ã®éææãèªä¿¡ãžãšç¹ãããŸãããã®çµéšã¯ãæ°ããªèª²é¡ã«å¯ŸããææŠæ欲ãåºæ¿ããŸãããŸããèªãåŠãã ç¥èãå©çšããŠåé¡è§£æ±ºãè¡ãéææã¯ãèªå·±æé·ã®äžç°ãšãªããŸãã
5.3 ãã£ãªã¢ã¢ãããšåå ¥åäžã®å¯èœæ§
ãŸããSQLè³æ Œãæã€ããšã¯ããã£ãªã¢ã¢ãããšåå ¥åäžã«å¯ŸããŠãããžãã£ããªåœ±é¿ãåãŒãå¯èœæ§ããããŸããããŒãªã³ã°ããŒã¿ã掻çšããææ決å®ãæ¯ããããŒã¿åæè ããã·ã¹ãã ãéçºããéçºè ãªã©ãSQLã¹ãã«ãå¿ èŠãšããè·çš®ã¯å€å²ã«ããããŸãããããã®ããžã·ã§ã³ã¯ãäžè¬çã«é«ãå ±é ¬ãåŸãããåŸåã«ãããŸããSQLã®ã¹ãã«ãæã€ããšã§ããããã®è·çš®ãžã®è»¢è·ãæé²ã®éãéãããããããŸããã
6. ãŸãšã
ãã®èšäºã§ã¯ãSQLè³æ Œã®ååŸæ¹æ³ãšãã®å¹çšã«ã€ããŠè§£èª¬ããŸããããŸãSQLãšã¯äœãããããŠãã®è³æ Œãäœæ å¿ èŠãªã®ããšãã£ãåºæ¬çãªéšåããå§ããããããã®è³æ Œã®çš®é¡ãå 容ãé£æ床ã«ã€ããŠè©³çŽ°ã«èŠãŠããŸããã
ãŸããè³æ ŒååŸã®å ·äœçãªæé ãè©Šéšã®ãã€ã³ããããã«ã¯è©Šéšç³ã蟌ã¿ã®æ¹æ³ãªã©ã玹ä»ãäžè¬çãªç¥èãéœåºŠåŒã³èµ·ãããªãããå ·äœçãªã¹ããããèžãããšã§ãããå¹æçãªè³æ ŒååŸãå¯èœãšãªãäºããäŒãããŸããã
SQLè³æ Œã®ä¿æãããã£ãªã¢åœ¢æãå°±è·æŽ»åãã¹ãã«ã¢ãããªã©ã«ã©ã®ãããªåœ±é¿ãäžããã®ãã確èªãèªèº«ã®ãã£ãªã¢ãåå ¥ãåäžãããããã®æåãªæ段ã§ãããšããäºãåèªèé ããããšæããŸãã
ããããäœããã倧åãªã®ã¯ãè³æ Œãç®çã§ã¯ãªãæ段ã§ãããšããäºãå¿ããªãã§ãã ããã確ãã«ãè³æ Œã¯ããªãã®ã¹ãã«ã蚌æããããªãã®åžå ŽäŸ¡å€ãäžããŸãããããããã以äžã«éèŠãªã®ã¯ããã®ã¹ãã«ãå®éã«ããªãã®åãšãªãã掻çšãããããšã§ãã
ç®æãè³æ Œããã®ã¹ãã«ããèªèº«ã®ç®æããã£ãªã¢ãç®æšã«ã©ã掻ããããã®ããèããè¡åããããšã倧åã§ããè³æ ŒååŸã®ããã®ç¥èãæ·±ããããšãã§ãããã次ã¯ã©ã掻çšãããèããããã«è¡åã«ç§»ããŠãããŸãããã