000 03243cam a22004217a 4500
001 16646339
005 20240317020002.0
008 110210s2011 inua 001 0 eng d
010 _a 2011922790
016 7 _a015695905
_2Uk
020 _a9781118002674
020 _a1118002679
020 _a9781118092798
020 _a9781118092774
020 _a9781118092781
020 _a9788126531028
035 _a(OCoLC)ocn671701736
040 _aBTCTA
_cBTCTA
_dYDXCP
_dVP@
_dUKMGB
_dS9O
_dBDX
_dKMS
_dDLC
042 _alccopycat
050 0 0 _aQA76.73.S67
_bK758 2011
082 0 4 _a005.133
_222
_bKRI-D
100 1 _aKriegel, Alex
245 1 0 _aDiscovering SQL :
_ba hands-on guide for beginners
_cAlex Kriegel.
260 _aIndianapolis, IN :
_bWiley,
_cc2011.
300 _axxx, 400 p. :
_bill. ;
_c24 cm.
490 1 _aWrox beginning guides
500 _a"Wrox programmer to programmer"--Cover.
500 _aIncludes index.
505 0 _aDrowning in data, dying of thirst for knowledge -- Breaking and entering : structured information -- A think you can relate to--designing a relational database -- Overcoming the limitations of SQL -- Grouping and aggregation -- When one is not enough : a query within a query -- You broke it ; you fix it : combining data sets -- What else is there, and why? -- Optimizing performance -- Multiuser environment -- Working with unstructured and semistructured data -- Not by SQL alone -- Installing the library database -- Installing RDBMSs software -- Accessing RDBMSs -- Accessing RDBMSs with the SQuirreL Universal SQL Client.
520 _aStructured Query Language, more popularly known as SQL, is a standard database language used to create, access and manipulate data, and store and maintain information in relational databases such as Access, SQL Server, Oracle, and MySQL. If that's all you know about SQL, then you're already ahead of the curve! Assuming no prior knowledge of SQL or relational databases, author Alex Kriegel takes you on a voyage of discovery as you learn SQL basics and learn to work with data stored in a relational database. Written in a beginner-friendly tone, this guide walks you through the creation of a sample database that incorporates all the SQL concepts taught throughout the book and also introduces data modeling, query tuning, and optimization. Discovering SQL: covers the most important SQL dialects along with the current release of SQL Standard; highlights the differences between particular implementations as well as the power and limitations of SQL; demonstrates how SQL deals with all types of data: structured, unstructured and everything in between; looks at dynamic SQL, procedural extensions and latest developments in the field; shares best practices for optimizing query performance; walks you through the basics of database design and introduces the tools for working with normalized data --
650 0 _aSQL (Computer program language)
650 7 _aSQL (Computer language)
_2sears
830 0 _aWrox beginning guides.
906 _a7
_bcbc
_ccopycat
_d2
_encip
_f20
_gy-gencatlg
942 _2ddc
_cBK
_03
999 _c9060
_d9060