ã¯ãšãªã®äœæã¯ãããã©ãŒãã³ã¹ãšå質ãåããïŒ
å®åäžå¿ã«ãã£ãã身ã«ã€ããŠã¿ãŠãã ããã ðšâð»
誀ã£ãŠæžãããã¯ãšãªã®æ°è¡
ããã©ãŒãã³ã¹ã®åé¡ãåŒãèµ·ãããšïŒ
ããã©ãŒãã³ã¹ã®èгç¹ãã誀ã£ãŠäœæãããã¯ãšãªã¯ãDBããã©ãŒãã³ã¹ãšãµãŒãã¹ããã©ãŒãã³ã¹ã®äœäžãåŒãèµ·ããäž»ãªåå ã§ããéçºã®åææ®µéã§ã¯ãçµæã«åºã¥ããŠäœæãããã¯ãšãªãSQL Serverã«ã¯é©ããŠããŸããã
ã ãããå質ã®è¯ãã¯ãšãªãæžãããšãéèŠã§ãïŒ
- ããã©ãŒãã³ã¹ã®è¯ãã¯ãšãªãäœæããããã®åºæ¬çãªèŠåãšçŠå¿
- å質ã®è¯ãã¯ãšãªãäœæããããã®åºæ¬çãªç¥è
- å
±éã®å®åäºäŸã®éæ¥çãªçµéš
SWéçºè
ãšããŠããããžã§ã¯ãããœãªã¥ãŒã·ã§ã³ãªã©ã®éçºæã«ã©ã®ãããªã¯ãšãªãå®è£
ãå°æ¥ã®ããã©ãŒãã³ã¹åé¡ãåŒãèµ·ããå¯èœæ§ãããããçè§£ããå®è·µã«ããã«é©çšã§ããããã«ãé¢é£ããç¥èãšçµéšãå
±æããããšæããŸãã
ãããªæ¹ãž
ããããã§ãã
SQL Server
åäžçŽéçºè
ITãããžã§ã¯ããž
äž»ã«åå ããéçºè
ã¯ãšãªã®ããã©ãŒãã³ã¹
èå³ã®ããç§ã
äžçŽãŠãŒã¶ãŒ
ã¯ãšãªã®æé©å
æ©ã
ãœãªã¥ãŒã·ã§ã³éçºè
ã¯ãšãªã®äœæ
æšæºãå¿
èŠ
ãããŒãžã£ãŒ
ã¯ãšãªã®æžãæ¹ãå¿
ãç¥ã£ãŠããã¹ã3ã€ã®çç±ïŒ
- 1ïžâ£å®åã§ã¯ãã¯ãšãªã®å®è£
ãšäœææã«ããã©ãŒãã³ã¹ãèæ
®ããŠãããè¯ãã¯ãšãªã䜿çšã§ããŸãã
- 2ïžâ£ããã©ãŒãã³ã¹åé¡ãäºæ³ãããã¯ãšãªã«ã€ããŠãDBæ
åœè
ãŸãã¯çŸæ¥ãšåè°ããããšãã§ããŸãã
- 3ïžâ£ã¯ãšãªãã¥ãŒãã³ã°ãåŠç¿ããã®ã«åœ¹ç«ã¡ãŸãã
ããè¯ãå質ã
ããè¯ãã¡ã³ããã³ã¹ã®ããã
ã€ã³ããã¯ã¹ãšã¯ãšãªã®ãã¥ãŒãã³ã°ã®ããã«ãéçºãšå®è£
ã®æ®µéããåºæ¬çã«ããå¿
èŠãããèŠåãã¿ããŒãããã³æžãæ¹ããããŸãã
ãã®ãã¬ãŒãã³ã°ã§ã¯ãéçºè
ã¯ã¯ãšãªã®å®è£
段éã§èæ
®ãã¹ãããã€ãã®èŠåãšæšå¥šäºé
ãåŠã¶ããšãã§ããããè¯ãå質ãšã¡ã³ããã³ã¹ã容æã«ããã¯ãšãªãå®è£
ããã®ã«åœ¹ç«ã¡ãŸããç¹ã«ãSQL Serverãå°éçã«é·æã«ãããã³ã³ãµã«ãã£ã³ã°ãšè¬çŸ©çµéšãæã€ç¥èå
±æè
ããåãããã¯ããšã«å®åã§å
±éããŠçŸããäŸããµã³ãã«ãšããŠäœ¿çšããŠãããããæè²åŸã®å®å掻çšã«çŽæ¥åœ¹ç«ã¡ãŸãã
SQL Server
䜿çšåå¿è
ãªã®ã«
åè¬ããŠãããã§ããïŒ
SQLã®åºç€ã¯ç¥ã£ãŠããã¹ãå
容ãçè§£ããåŸãã®ã«ç°¡åã«ãªãã§ãããããããã¯Q/Aãå©çšããŠãããã§ãããð
MySQLã
PostgreSQLãªã©
ä»ã®DBMSãž
éçºæã«ã
é©çšã§ããŸããïŒ
DBMSããšã«ã€ã³ããã¯ã¹ãçµ±èšæ
å ±ãããã¯ãã¯ãšãªæé©åãªã©ã®ã¢ãŒããã¯ãã£ã«çްããéãããããSQL Serverãåºæºãšããæ¬è¬çŸ©ã®å
容ã100%çããã¯é©çšãããŸãããããããããªãå€ãã®ã³ã³ãã³ããä»ã®DBMSã«ãé©çšããããšèšãããšãã§ããŸãã
SQL Server
ããŒãžã§ã³ã«ãã£ãŠã
éãããããŸããïŒ
ã»ãšãã©ã®ã³ã³ãã³ãã¯ãçŸåšäž»ã«äœ¿çšãããŠããããŒãžã§ã³ã«åºã¥ããŠã»ãšãã©éãã¯ãããŸãããããã€ãã®éããããéšåã¯è¬çŸ©ã§èª¬æããŸãã
次ã®å
容
åŠç¿ããŸãã
1. ã¯ãšãªã®äœæã®åºæ¬
- éçšDBã§SSMSãéçºããŒã«ãæžããšãã¯æ³šæããŠãã ããã
- WHEREå¥ãšJOINå¥ã®äœæé åºã¯ããã©ãŒãã³ã¹ã«åœ±é¿ããŸããïŒ
- æ¥æãªãã©ã«ãæååãªãã©ã«ãšæ€çŽ¢ã¯ã©ãããã°ããã§ããïŒ
- çµåæ¡ä»¶ãšæ€çŽ¢æ¡ä»¶ã¯ã©ã®ããã«åºå¥ããŠé©çšããŸããïŒ
- ç§ãä»ãŸã§äœ¿ã£ãã¯ãšãªã¯ããããæå³ãšã©ãŒãã«è©²åœããã®ã ãããïŒ
2. ã¯ãšãªã®çŠå¿
- ããã©ãŒãã³ã¹äžã®è¯ãæ¡ä»¶åŒã¯ã©ã®ãããªåœ¢åŒã§æžãã¹ãã§ããïŒ
- ã¯ãšãªçŠå¿ããããŸããïŒããç§ãç¿æ
£çã«ïŒ
- ããŒã«ã«å€æ°ãã«ã¹ã¿ã 颿°WHEREå¥ã«æžããšå±éºã§ããïŒ
3. ããè¯ãã¯ãšãªãæžã
- INãšBETWEEN誰ãéãã§ããïŒãã€èª°ãæžãã®ãããã§ããïŒ
- éèšé¢æ°ã®äž»äººå
¬ã¯NULL
- UNION(åéå)ãALL æžããŸããïŒæžç®ããŸããïŒ
- UPDATEããŠãŸãSELECTïŒãã äžéšå±ã§
- SQL Serverã®æ°ãã颿°ãšæ§æã奜ãã§ã^^
- çµåæ§æã¯ã©ã®ããã«æžãã®ã§ããïŒäžèŠãªOUTER JOINã¯ããã©ãŒãã³ã¹ã®åé¡ã§ããïŒ
- Subqueryã¯ç¡æ¡ä»¶ã«é
ãã§ããïŒãã䜿ããšè¬ã§ãã
- ã¯ãšãªãã¥ãŒãã³ã°ã®ã³ã¢æ©èœã掟çããŒãã«/CTE/APPLY
- CASEå
ã®SELECTã¹ããŒãã¡ã³ãïŒããããéã«æžããŠãã ããã
- è¶éåã¯ãšãªãå¿
èŠã§ããïŒ NOT INã¯ç¹ã«æ³šæããŠãã ãã
- ååž°åŒã³åºãã¯ãšãªãCTEãæŽ»çš
- ã¯ãšãªãã³ããæžããŸããïŒæ³šæããŠãã ããã
- SQL Serverã§ã¯ãã¯ãšãªã¯ããã¯åé¡ãå¿
ãæã£ãŠããŸãã
4. ã«ãŒãœã«ããã¥ãŒããŠãŒã¶ãŒå®çŸ©é¢æ°ãå®è£
ããéã®èæ
®äºé
- CursorïŒå¯èœãªSQLã§å®è£
ããŠãã ãããããã§ãå¿
èŠãªãâŠ
- STRING_AGGïŒïŒé¢æ°ãããããŸãããïŒé©ããŸãã
- ã¬ãžã§ããäžèœè
ïŒãããäžèœViewïŒæ³šæããŠãã ããã
- ãŠãŒã¶ãŒå®çŸ©é¢æ°ãšäžæ¬æ€çŽ¢ã«åºäŒããšããããããéããªããŸã
- FORMAT() 颿°?äžæ¬æ€çŽ¢ã§æ³šæããŠãã ãã
- ïŒä»é²ïŒ.NET EFãEF Coreãªã©ã®ORMã䜿çšããŠããŸããïŒã¢ããã€ã¹
ããã«ã¡ã¯ïŒ
ç¥èå
±æè
ãã ã»ãžã§ã³ãœã³ã§ãã
å±¥æŽ
- ã±ã·ãŒã¯ãªãïŒwww.sqlroad.comïŒä»£è¡šã³ã³ãµã«ã¿ã³ã/åç· åœ¹ïŒ2005幎ããïŒ
- SQL Serverã³ã³ãµã«ãã£ã³ã°ãæè¡æ¯æŽãè¬çŸ©ããœãªã¥ãŒã·ã§ã³éçº
- SQLBigEyesïŒSQL Serverããã©ãŒãã³ã¹ã¢ãã¿ãªã³ã°ãœãªã¥ãŒã·ã§ã³ãwww.sqlbigeyes.comïŒã®éçº
- SQLBigEyesïŒSQL Serverããã©ãŒãã³ã¹ã¢ãã¿ãªã³ã°ãœãªã¥ãŒã·ã§ã³ãwww.sqlbigeyes.comïŒã®éçº
- Microsoft Data Platform MVP
- 2002幎ããïŒçŸåš2025å¹ŽåºæºïŒ24幎éåè³ã2008幎MVPååŽè³åè³
è³æ ŒãšèªèšŒ
- MCTãAzure DBAãMCITPãªã©
è¬çŸ©æŽ»åïŒ1999幎ããïŒ
å€éšæŽ»å
- SQL Server MVP Deep Dives Vol 2 (Manning Pubs)å
±èè
ã«åå
- ãã ã»ãžã§ã³ãœã³ã®SQL Serverã³ã³ãµã«ãã£ã³ã°ã¹ããŒãªãŒã·ãŒãºã³13幎éé²è¡äž
- SQL Unpluggedã»ãããŒ5幎éé²è¡
- SQL PASS Korea Chapter Leader
- Microsoft IgniteãBITECãTech CampãMVP CampãTechEdãMSDNãªã©ã®Speakerã«åå
ãããã質å
確èªããŠã¿ãŠãã ããã
Q. éå°æ»è
ãèããè¬çŸ©ã§ããïŒ
SQLã®åºç€ã䜿çšçµéšãããã°èãããšãã§ããŸããå°ãè¶³ããªããŠããåè¬äžã«å¿
èŠãªåºç€ã䞊è¡åŠç¿ããã°è¯ãã§ãããã
Q. è¬çŸ©ãèãåã«æºåãã¹ãããšã¯ãããŸããïŒ
SQL Server ãæäŸãã SSMS ããã°ã©ã ãã¯ãšãªäœ¿çšå¯èœãªé¡äŒŒããã°ã©ã ãã€ã³ã¹ããŒã«ããŠãããæäŸããããã¢çš DB ãš SQL ã¹ã¯ãªããããããããããŠã³ããŒãããŠããããšãã§ããŸãããã¢DBã®æ§æã«ã€ããŠã¯ããã¬ãŒãã³ã°ã§èª¬æããŸãã
Q. åè¬ã«é¢ããæ³šæäºé
ïŒå¿
èŠãªç°å¢ããã®ä»ã®çæäºé
ãªã©ïŒã¯ãããŸããïŒ
ãã¢ãšèª²é¡ãå®è¡ããã«ã¯SQL Serverãå¿
èŠã§ããå¯èœã§ããã°ãææ°ããŒãžã§ã³ïŒ2021幎çŸåšã®åºæº2019ïŒãè¯ãã以åã®ããŒãžã§ã³ãåé¡ãããŸããã
Q. ãã¯ãšãªãŒãã¥ãŒãã³ã°ãã®ãããã¯ã®æè²å
容ãšã¯ã©ã®ãããªéãããããŸããïŒ
ã¯ãšãªãã¥ãŒãã³ã°ã¯ãã¯ãšãªã®ããã©ãŒãã³ã¹ã蚺æåæããåå ã®è¿œè·¡ãšè§£æ±ºãéããŠããã©ãŒãã³ã¹ãæ¹åããããã®å
šäœçãªæé ãæ¹æ³ãããã³ã±ãŒã¹ãã«ããŒããŸããæ¬ã³ãŒã¹ã§ã¯æ±ããªãç¯å²ãªã®ã§åèã«ããŠæè²æ åã®ååã§ãã®éšåãããäžåºŠèª¬æããŸãã