1. Microsoft SQL Serverèªå®ã®æŠèŠ
è¿å¹ŽãããŒã¿ããŒã¹æè¡ã®é²åãšãšãã«ãMicrosoft SQL Serverã®èªå®ã倧ããªå€é©ãéããŠããŸããããã®ã»ã¯ã·ã§ã³ã§ã¯ããã®å€é©ã®å 容ãæ°ããèªå®ã¢ãã«ããããŠAzureã«é¢é£ããèªå®ã«ã€ããŠè©³ãã解説ããŸãã
1.1. èªå®ããã°ã©ã ã®å€æŽç¹
2021幎6æãMicrosoftã¯èªå®ããã°ã©ã ã«ããã€ãã®éèŠãªå€æŽãå°å ¥ããŸããããããã®å€æŽã¯ãæè¡ã®é²åãæ¥çã®ããŒãºã«å¿ããŠãèªå®ã®å 容ã圢åŒãæŽæ°ããããšãç®çãšããŠããŸããäŸãã°ãåŸæ¥ã®èªå®è©Šéšã¯äžè¬çãªç¥èãäžå¿ã«èšèšãããŠããŸããããæ°ããã¢ãã«ã§ã¯ãå®éã®æ¥åã«å³ããã¹ãã«ãç¥èãè©äŸ¡ããããšãéèŠãããŠããŸãã
1.2. 圹å²ããŒã¹ã®èªå®ã¢ãã«
æ°ããèªå®ã¢ãã«ã®æã泚ç®ãã¹ãç¹åŸŽã®äžã€ãã圹å²ããŒã¹ã®èªå®ã§ããããã¯ãç¹å®ã®è·æ¥ã圹å²ã«ç¹åããã¹ãã«ã»ãããæã€äººã ã察象ãšããèªå®ããã°ã©ã ãæå³ããŸããäŸãã°ãããŒã¿ããŒã¹ç®¡çè ãããŒã¿ããŒã¹éçºè ãããžãã¹ã€ã³ããªãžã§ã³ã¹ã®å°é家ãªã©ãããããã®åœ¹å²ã«åãããèªå®ãæäŸãããŠããŸããããã«ãããåéšè ã¯èªåã®ãã£ãªã¢ç®æšãå°éåéã«åãããŠãæãé©åãªèªå®ãéžæããããšãã§ããŸãã
1.3. Azureã«çŠç¹ãåœãŠãèªå®
ã¯ã©ãŠãæè¡ã®æ®åãšãšãã«ãAzureã¯Microsoftã®äž»èŠãªãã©ãããã©ãŒã ãšããŠæ¥éã«æé·ããŠããŸãããã®ãããæ°ããèªå®ããã°ã©ã ã§ã¯ãAzureã«é¢é£ããç¥èãã¹ãã«ãè©äŸ¡ããèªå®ãå¢å ããŠããŸããããã«ã¯ãAzureã®ããŒã¿ããŒã¹ãµãŒãã¹ããAzureäžã§ã®ããŒã¿ããŒã¹ç®¡çãããŒã¿ããŒã¹ã®ç§»è¡ãªã©ãããŸããŸãªãããã¯ãå«ãŸããŠããŸãã
2. SQL Serverèªå®ã®å©ç¹
Microsoft SQL Serverã®èªå®ãååŸããããšã¯ãå€ãã®å©ç¹ãæã£ãŠããŸãããã®ã»ã¯ã·ã§ã³ã§ã¯ããã®äž»ãªå©ç¹ã«ã€ããŠè©³ãã解説ããŸãã
2.1. ã¹ãã«ãšç¥èã®æ€èšŒ
èªå®è©Šéšãåéšããåæ Œããããšã¯ãããªãã®ã¹ãã«ãšç¥èãäžå®ã®åºæºãæºãããŠããããšã®èšŒæãšãªããŸããç¹ã«ãããŒã¿ããŒã¹æè¡ã®é²åãæ¥éã«é²è¡ããŠããçŸä»£ã«ãããŠãææ°ã®ç¥èãšæè¡ãæã£ãŠããããšã瀺ãæ段ãšããŠãèªå®ã¯éåžžã«äŸ¡å€ããããŸãã
2.2. ãã£ãªã¢ã®æ©äŒã®åäž
å€ãã®äŒæ¥ãçµç¹ã¯ãæ±äººæ å ±ãæé²ã®éã«ãç¹å®ã®èªå®ãæã£ãŠããããšãæ±ããããšãå¢ããŠããŸããSQL Serverã®èªå®ãæã£ãŠããããšã¯ãããè¯ãè·ã®æ©äŒãåŸãããã®å€§ããªã¢ããã³ããŒãžãšãªããŸãããŸããèªå®ãæã£ãŠããããšã§ãä»ã®åè£è ãšã®å·®å¥åãå³ãããããæ¡çšã®éã®ç«¶äºåãåäžããŸãã
2.3. ç¶ç¶çãªæè²ã®éèŠæ§
æè¡ã®é²åã¯æ¢ãŸãããšããããŸããããã®ãããç¶ç¶çãªåŠç¿ã¯éåžžã«éèŠã§ããSQL Serverã®èªå®ãååŸããããšã¯ãèªåèªèº«ãåžžã«ã¢ããããŒããç¶ããããã®äžã€ã®æ¹æ³ãšãªããŸããèªå®ããã°ã©ã ã¯ãææ°ã®æè¡ããã¹ããã©ã¯ãã£ã¹ã«åºã¥ããŠæŽæ°ããããããèªå®ãç¶æããããšã§ãåžžã«æåç·ã®ç¥èãæã€ããšãã§ããŸãã
3. äž»èŠãªSQL Serverèªå®
Microsoft SQL Serverã¯ãããŒã¿ããŒã¹ç®¡çãšéçºã®åéã§åºã䜿çšãããŠãããããé¢é£ããèªå®ãå€å²ã«ããããŸãããã®ã»ã¯ã·ã§ã³ã§ã¯ããã®äžã§ãç¹ã«æ³šç®ãã¹ãèªå®ã«ã€ããŠè©³ãã解説ããŸãã
3.1. Microsoft Technology Associate (MTA)
Microsoft Technology Associate (MTA)ã¯ãITã®åºç€ç¥èãæã€åå¿è ã察象ãšããèªå®ã§ãããã®èªå®ã¯ãããŒã¿ããŒã¹ã®åºæ¬çãªæŠå¿µãSQL Serverã®åºæ¬æäœã«é¢ããç¥èãè©äŸ¡ããŸããMTAã¯ãããŒã¿ããŒã¹ã®ãã£ãªã¢ãè¿œæ±ããäžã§ã®ç¬¬äžæ©ãšããŠãéåžžã«äŸ¡å€ããããŸãã
3.2. Microsoft Certified: Azure Database Administrator Associate
ã¯ã©ãŠãæè¡ã®æ®åã«äŒŽããAzureäžã§ã®ããŒã¿ããŒã¹ç®¡çã®ã¹ãã«ãæ±ããããããã«ãªã£ãŠããŸãããMicrosoft Certified: Azure Database Administrator Associateã¯ãAzureäžã§ã®ããŒã¿ããŒã¹ã®èšå®ã管çãæé©åã«é¢ããç¥èãæã€äººã ã察象ãšããèªå®ã§ãããã®èªå®ãååŸããããšã§ãã¯ã©ãŠãæ代ã®ããŒã¿ããŒã¹ç®¡çè ãšããŠã®ã¹ãã«ã蚌æããããšãã§ããŸãã
3.3. ãã®ä»ã®èªå®
äžèšã®èªå®ã®ã»ãã«ããSQL Serverã«é¢é£ããããŸããŸãªèªå®ãååšããŸããäŸãã°ãããŒã¿ããŒã¹éçºãããžãã¹ã€ã³ããªãžã§ã³ã¹ã®å°é家ã察象ãšããèªå®ãé«åºŠãªã¹ãã«ãç¥èãæã€å°é家ã察象ãšããäžçŽèªå®ãªã©ãæ§ã ãªããŒãºã«å¿ããèªå®ãæäŸãããŠããŸããèªåã®ãã£ãªã¢ç®æšãèå³ã«åãããŠãæãé©åãªèªå®ãéžæããããšãéèŠã§ãã
4. èªå®è©Šéšã®æºå
Microsoft SQL Serverã®èªå®è©Šéšãåéšããã«ã¯ãååãªæºåãäžå¯æ¬ ã§ãããã®ã»ã¯ã·ã§ã³ã§ã¯ãè©Šéšã®æºåæ¹æ³ãå©çšå¯èœãªãªãœãŒã¹ãè©Šéšã®å 容ããã©ãŒãããã«ã€ããŠè©³ãã解説ããŸãã
4.1. åŠç¿ãªãœãŒã¹ãšã¬ã€ã
è©Šéšã®æºåã«ã¯ãå ¬åŒã®åŠç¿ãªãœãŒã¹ããªã³ã©ã€ã³ã®ã¬ã€ãã掻çšããããšãæšå¥šãããŸããMicrosoftã®å ¬åŒãµã€ãã§ã¯ãåèªå®è©Šéšã«é¢ãã詳现ãªã¬ã€ããåŠç¿ãã¹ãæäŸãããŠããŸãããŸãããªã³ã©ã€ã³ã³ãŒã¹ãæžç±ãå®è·µçãªãã³ãºãªã³ã©ããªã©ãããŸããŸãªåŠç¿ãªãœãŒã¹ãå©çšå¯èœã§ãããããã®ãªãœãŒã¹ã掻çšããããšã§ãè©Šéšã®å 容ã圢åŒã«æ £ããããšãã§ããŸãã
4.2. è©Šéšã®å 容ãšãã©ãŒããã
èªå®è©Šéšã®å 容ã¯ãè©Šéšã®ç®çã察象ãšãªãã¹ãã«ã»ããã«åºã¥ããŠèšèšãããŠããŸããè©Šéšã«ã¯ãéžæåé¡ãå®è·µçãªã·ãã¥ã¬ãŒã·ã§ã³åé¡ãªã©ãããŸããŸãªã¿ã€ãã®åé¡ãå«ãŸããŠããŸãããŸããè©Šéšã®æéãåé¡æ°ãåæ Œåºæºãªã©ãäºåã«ç¢ºèªããŠããããšãéèŠã§ããããã«ãããè©Šéšåœæ¥ã«äœèšãªç·åŒµãæããããšãªããèªåã®ã¹ãã«ãæ倧éã«çºæ®ããããšãã§ããŸãã
4.3. è©Šéšã®åéšæ¹æ³
Microsoftã®èªå®è©Šéšã¯ãå ¬åŒã®è©Šéšã»ã³ã¿ãŒããªã³ã©ã€ã³ã§ã®åéšãå¯èœã§ããè©Šéšã»ã³ã¿ãŒã§ã®åéšãåžæããå Žåã¯ãäºåã«äºçŽãè¡ããæå®ãããæ¥æã«è©Šéšã»ã³ã¿ãŒã蚪ããå¿ èŠããããŸããäžæ¹ããªã³ã©ã€ã³ã§ã®åéšãéžæããå Žåã¯ãèªå® ããªãã£ã¹ããè©Šéšãåããããšãã§ããŸãããäžå®ã®æè¡çãªèŠä»¶ãæºããå¿ èŠããããŸããã©ã¡ãã®æ¹æ³ãéžæãããã¯ãèªåã®ã©ã€ãã¹ã¿ã€ã«ã奜ã¿ã«åãããŠéžã¶ããšãã§ããŸãã
5. èªå®ãååŸããåŸã®ã¹ããã
Microsoft SQL Serverã®èªå®ãååŸããåŸããæè¡ã®é²åãšãšãã«èªèº«ã®ã¹ãã«ãç¶æã»åäžãããããã®åªåãå¿ èŠã§ãããã®ã»ã¯ã·ã§ã³ã§ã¯ãèªå®ãååŸããåŸã®æšå¥šãããã¹ããããããã®ã¡ãªãããæ倧éã«æŽ»çšããæ¹æ³ã«ã€ããŠè©³ãã解説ããŸãã
5.1. ç¶ç¶çãªåŠç¿ãšæŽæ°
æè¡ã®é²åã¯çµ¶ãããç¶ç¶çãªåŠç¿ã¯ITãããã§ãã·ã§ãã«ãšããŠã®ãã£ãªã¢ãç¶æããããã®éµãšãªããŸããèªå®ãååŸããåŸããæ°ããæè¡ããã¹ããã©ã¯ãã£ã¹ã«é¢ããææ°ã®æ å ±ãè¿œãç¶ããããšãéèŠã§ãããŸããèªå®ã®æå¹æéãæŽæ°ã®èŠä»¶ã«æ³šæãæããå¿ èŠã«å¿ããŠåè©Šéšãåéšããããšãèæ ®ããå¿ èŠããããŸãã
5.2. èªå®ã®ã¡ãªããã掻çšããæ¹æ³
èªå®ãååŸããããšã§ããã£ãªã¢ã®æ©äŒãæé²ã®å¯èœæ§ãå¢å ããããšãæåŸ ãããŸããèªå®ã®ããŽããããžãå±¥æŽæžãLinkedInãããã£ãŒã«ã«è¿œå ããããšã§ãèªèº«ã®ã¹ãã«ãšç¥èãã¢ããŒã«ããããšãã§ããŸãããŸããèªå®ãæã£ãŠããããšã§ãç¹å®ã®æè¡ã³ãã¥ããã£ãã€ãã³ããžã®æåŸ ãåããããšããããŸãã
5.3. ä»ã®é¢é£ããèªå®ãžã®é²è¡
äžã€ã®èªå®ãååŸããåŸããããã«é«åºŠãªèªå®ãä»ã®é¢é£æè¡ã®èªå®ãè¿œæ±ããããšã§ãå°éæ§ãæ·±ããããšãã§ããŸããäŸãã°ãããŒã¿ããŒã¹ç®¡çã®åºæ¬çãªèªå®ãååŸããåŸãããŒã¿ããŒã¹ã®éçºãããžãã¹ã€ã³ããªãžã§ã³ã¹ã«é¢ããèªå®ãè¿œæ±ããããšã§ãããåºç¯ãªã¹ãã«ã»ãããç²åŸããããšãã§ããŸãã
6. ãŸãšã
Microsoft SQL Serverã®èªå®ã¯ãããŒã¿ããŒã¹ç®¡çãéçºã®åéã§ã®å°éç¥èãšã¹ãã«ã蚌æããããã®éèŠãªæ段ãšãªã£ãŠããŸãããã®èšäºãéããŠãèªå®ã®æŠèŠããè©Šéšã®æºåæ¹æ³ãèªå®ãååŸããåŸã®ã¹ããããŸã§ãå¹ åºãæ å ±ãæäŸããŸããã
6.1. SQL Serverèªå®ã®éèŠæ§
çŸä»£ã®ããžãã¹ç°å¢ã§ã¯ãããŒã¿ã®ç®¡çãšåæãäžå¯æ¬ ã§ããSQL Serverèªå®ã¯ããã®åéã§ã®å°éçãªç¥èãšã¹ãã«ãæã£ãŠããããšã蚌æããããã®ä¿¡é Œæ§ã®é«ãæ¹æ³ãšãªã£ãŠããŸããèªå®ãååŸããããšã§ããã£ãªã¢ã®æ©äŒãå¢å ããããé«åºŠãªãããžã§ã¯ãã圹è·ã«é¢äžããããšãæåŸ ãããŸãã
6.2. èªå®ãååŸããããã®æè¯ã®ã¢ãããŒã
èªå®è©Šéšã®æºåã¯ãèšç»çãã€ç¶ç¶çã«è¡ãããšãéµãšãªããŸããå ¬åŒã®åŠç¿ãªãœãŒã¹ããªã³ã©ã€ã³ã³ãŒã¹ã掻çšããå®è·µçãªãã³ãºãªã³ã©ãã§ã®ç·Žç¿ãéããããšã§ãè©Šéšã®å 容ã圢åŒã«æ £ããããšãã§ããŸãããŸããè©Šéšã®åéšæ¹æ³ãå Žæãæ¥æãäºåã«ç¢ºèªããŠããããšãéèŠã§ãã
6.3. ä»åŸã®å±æ
æè¡ã®é²åãšãšãã«ãèªå®ã®å 容ãèŠä»¶ãå€ããå¯èœæ§ããããŸãããã®ãããç¶ç¶çãªåŠç¿ãšæŽæ°ãå¿ èŠãšãªããŸãããŸããSQL Serverã ãã§ãªããä»ã®é¢é£æè¡ãããŒã«ã®èªå®ãè¿œæ±ããããšã§ãããåºç¯ãªã¹ãã«ã»ãããç²åŸãããã£ãªã¢ã®å¹ ãåºããããšãã§ããŸãã
åèæç®
- SQL Certifications Program from Microsoft – SQL Server Tipsãã®èšäºã¯Rajendra Guptaã«ãã£ãŠæäŸãããMicrosoftã®èªå®ããã°ã©ã ã®å€æŽç¹ã«ã€ããŠè©³ãã解説ããŠããŸããç¹ã«ã2021幎6æã«å°å ¥ããã圹å²ããŒã¹ã®èªå®ãAzureã«çŠç¹ãåœãŠãæ°ããèªå®ã«ã€ããŠã®æ å ±ãå«ãŸããŠããŸãã
- Top 5 SQL Server Certifications to Boost Your Career – Hackr2023幎ã®ããžãã¹ã€ã³ããªãžã§ã³ã¹ãšããã°ããŒã¿ã®ãã¬ã³ãã«é¢ããæ å ±ãæäŸãããã®èšäºã§ã¯ãSQLéçºè ãããŒã¿ããŒã¹ãšã³ãžãã¢ãšããŠã®ãã£ãªã¢ãåäžãããããã®æé«ã®SQL Serverèªå®ã«ã€ããŠã®ãªã¹ããæäŸããŠããŸãã