-- ·|­û / µù¥U -- ¡@
¡@±b¸¹¡G
¡@±K½X¡G
¡@ | µù¥U | §Ñ°O±K½X
3/26 ·s®Ñ¨ì¡I 3/19 ·s®Ñ¨ì¡I 3/14 ·s®Ñ¨ì¡I 12/12 ·s®Ñ¨ì¡I
ÁʮѬyµ{¡EQ & A¡E¯¸°È¯d¨¥ª©¡E«ÈªA«H½c
¢x 3ds Max¢x Maya¢x Rhino¢x After Effects¢x SketchUp¢x ZBrush¢x Painter¢x Unity¢x
¢x PhotoShop¢x AutoCad¢x MasterCam¢x SolidWorks¢x Creo¢x UG¢x Revit¢x Nuke¢x
¢x C#¢x C¢x C++¢x Java¢x ¹CÀ¸µ{¦¡¢x Linux¢x ´O¤J¦¡¢x PLC¢x FPGA¢x Matlab¢x
¢x Àb«È¢x ¸ê®Æ®w¢x ·j¯Á¤ÞÀº¢x ¼v¹³³B²z¢x Fluent¢x VR+AR¢x ANSYS¢x ²`«×¾Ç²ß¢x
¢x ³æ´¹¤ù¢x AVR¢x OpenGL¢x Arduino¢x Raspberry Pi¢x ¹q¸ô³]­p¢x Cadence¢x Protel¢x
¢x Hadoop¢x Python¢x Stm32¢x Cortex¢x Labview¢x ¤â¾÷µ{¦¡¢x Android¢x iPhone¢x
¥i¬d®Ñ¦W,§@ªÌ,ISBN,3dwoo®Ñ¸¹
¸Ô²Ó®ÑÄy¤ÀÃþ

Effective SQL¤¤¤åª© | ¼g¥X¨}¦nSQLªº61­Ó¨ãÅé°µªk

( ÁcÅé ¦r)
§@ªÌ¡GJohn L. Viescasµ¥Ãþ§O¡G1. -> ¸ê®Æ®w -> SQL»y¨¥
ĶªÌ¡G·¨´L¤@
¥Xª©ªÀ¡GùÖ®p¥Xª©Effective SQL¤¤¤åª© | ¼g¥X¨}¦nSQLªº61­Ó¨ãÅé°µªk 3dWoo®Ñ¸¹¡G 46904
¸ß°Ý®ÑÄy½Ð»¡¥X¦¹®Ñ¸¹¡I

¡i¯Ê®Ñ¡j
NT©w»ù¡G 450 ¤¸
§é¦©»ù¡G 338 ¤¸

¥Xª©¤é¡G6/1/2017
­¶¼Æ¡G
¥úºÐ¼Æ¡G0
¯¸ªø±ÀÂË¡G
¦L¨ê¡G¶Â¥Õ¦L¨ê»y¨t¡G ( ÁcÅé ª© )
¥[¤JÁʪ«¨® ¢x¥[¨ì§Úªº³Ì·R
(½Ð¥ýµn¤J·|­û)
ISBN¡G9789864764358
§@ªÌ§Ç¡@|¡@ĶªÌ§Ç¡@|¡@«e¨¥¡@|¡@¤º®e²¤¶¡@|¡@¥Ø¿ý¡@|¡@§Ç
(²Åé®Ñ¤W©Ò­z¤§¤U¸ü³sµ²¯Ó®É¶O¥\, ®¤¤£¾A¥Î¦b¥xÆW, ­YŪªÌ»Ý­n½Ð¦Û¦æ¹Á¸Õ, ®¤¤£«OÃÒ)
§@ªÌ§Ç¡G

ĶªÌ§Ç¡G

«e¨¥¡G

¤º®e²¤¶¡G

½u¤W¤U¸ü¤º®e
¡§»P¨ä½M¦£©Î¥|³B´M§äµª®×¡A½ÐÀ°¦Û¤v¤@­Ó¦£¡Gª½±µ¶R³o¥»®Ñ§a¡I¡¨-Dave Stokes¡AMySQLªÀ¸s¸g²z¡AOracle CorporationEffective SQL¾ã¦X¹ê°È¤è®×»P¬}¨£¡A¨ó§U§A¸Ñ¨M½ÆÂøªº°ÝÃD¡A¥H¤Î³]­p¥X¯à²¤Æ¸ê®ÆºÞ²zªº¸ê®Æ®w¡C¥»®Ñµ²¦X³Ì¨Î¹ê½î¤èªk»P¹ê°È®×¨Ò¡A²[»\¦UºØSQLª©¥»¡GIBM DB2¡BMicrosoft Access¡BMicrosoft SQL Server¡BMySQL¡BOracle Database»PPostgreSQL¡C§@ªÌ­Éų¥@¬É¯Å¸ê®Æ®wÅU°Ý»PÁ¿®vªºÂ×´I¸gÅç¡AÂk¯Ç¤F¼g¥X¨}¦nSQLªº61­Ó¨ãÅé°µªk¡A¨Ã´£¨Ñ¤£¦PSQLª©¥»¤¤ªº®t§O¡AµL½×§A¬O¨Ï¥Î¦óºØSQLª©¥»³£¯à±q¤¤Àò¯q¡C¥»®Ñ´£¨Ñ²M·¡¡B°È¹êªº¸ÑÄÀ¡A±M®aªºµ´©Û»P¤j¶q¹ê¥Îªºµ{¦¡½X¡C°£¤F»yªk¤§¥~¡A¤]°Q½×¸ê®Æ®w³]­p³Ì¨Î¤Æ¡B¶¥¼hºÞ²z»P¤¸¸ê®Æµ¥¦UºØijÃD¡C­Y§A¹ïSQL¤w¸g¦³°ò¥»»{ÃÑ¡A³o¥»«ü«n±N¯àÀ°§U§A¦¨¬°¸Ñ¨MSQL°ÝÃDªº±M®a¡C?¥´³y§ó¦nªº¸ê®Æ¼Ò«¬¨Ã§ï¥¿¦³°ÝÃDªº¼Ò«¬?¹ê§@´£¤É¬d¸ß®Ä¯àªº¯Á¤Þ?³B²z§A¤£¯à±±¨îªº¥~³¡¸ê®Æ¨Ó·½?°ª®Ä²vªºÂ^¨ú¨Ã·J¾ã§A©Ò»Ýªº¸ê°T?¼¶¼g§ó¦³¼u©Êªº¤l¬d¸ß?¤ÀªR»PŪ¨ú¦UºØ¸ê®Æ®wªº¤¸¸ê®Æ?¨Ï¥Î²Ã¥d¨à¿n(Cartesian product)»P¹ïÀ³ªí®æ¡A¸Ñ¨M¶Ç²ÎJOINµLªk³B²zªº°ÝÃD?«Øºc¶¥¼h¸ê®Æ¼Ò«¬¡GºÞ²zSQLªº¨ú±Ë»P¯ÊÂI
¥Ø¿ý¡G

§Ç
­PÁÂ
Ãö©ó§@ªÌ
«e¨¥

²Ä 1 ³¹¡@¸ê®Æ¼Ò«¬³]­p
²Ä 2 ³¹¡@µ{¦¡¤Æ»P¯Á¤Þ³]­p
²Ä 3 ³¹¡@¤£¯à§ïÅܳ]­p®É
²Ä 4 ³¹¡@¹LÂo»P·j´M¸ê®Æ
²Ä 5 ³¹¡@·J¾ã
²Ä 6 ³¹¡@¤l¬d¸ß
²Ä 7 ³¹¡@¨ú±o»P¤ÀªR¤¸¸ê®Æ
²Ä 8 ³¹¡@²Ã¥d¨à¿n
²Ä 9 ³¹¡@¹ïÀ³ªí
²Ä 10 ³¹¡@«Øºc¶¥¼h¸ê®Æ¼Ò«¬
ªþ¿ý¡@®É¶¡»P¤é´Á«¬§O¡B¾Þ§@¡A¥H¤Î¨ç¦¡
§Ç¡G