LEADER 05066nam 22006374a 450 001 9910784351503321 005 20200520144314.0 010 $a1-280-25346-0 010 $a9786610253463 010 $a0-7645-9632-2 035 $a(CKB)1000000000348907 035 $a(EBL)226434 035 $a(OCoLC)58448281 035 $a(SSID)ssj0000109909 035 $a(PQKBManifestationID)11139008 035 $a(PQKBTitleCode)TC0000109909 035 $a(PQKBWorkID)10059894 035 $a(PQKB)11536910 035 $a(Au-PeEL)EBL226434 035 $a(CaPaEBR)ebr10114273 035 $a(CaONFJC)MIL25346 035 $a(CaSebORM)9780764577321 035 $a(MiAaPQ)EBC226434 035 $a(EXLCZ)991000000000348907 100 $a20050103d2005 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aBeginning SQL$b[electronic resource] /$fPaul Wilton and John W. Colby 205 $a1st edition 210 $aIndianapolis, IN $cWiley$dc2005 215 $a1 online resource (521 p.) 225 1 $aWrox beginning guides. 300 $a"Programmer to programmer"--Cover. 311 $a0-7645-7732-8 327 $aBeginning SQL; About the Authors; Credits; Contents; Acknowledgments; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p. wrox. com; Chapter 1: Introduction to SQL; A Brief History of Databases; Structured Query Language (SQL); Database Creation; Creating, Altering, and Deleting Tables; Good Database Design; Creating the Example Database; Summary; Exercises; Chapter 2: Entering Information; Inserting New Data; Inserting Data into the Case Study Database; Updating Data; Deleting Data 327 $aSummaryExercises; Chapter 3: Extracting Information; The SELECT Statement; Logical Operators and Operator Precedence; Ordering Results with ORDER BY; Selecting Data from More Than One Table; Introducing NULL Data; Summary; Exercises; Chapter 4: Advanced Database Design; Normalization; Ensuring Data Validity with Constraints; Speeding Up Results with Indexes; Summary; Exercises; Chapter 5: Manipulating Data; Understanding SQL Arithmetic; Introducing String Functions; Converting Different Data Types; Re-examining NULL; Using INSERT INTO with the SELECT Statement; Summary; Exercises 327 $aChapter 6: Grouping and Aggregating DataGrouping Results; Summarizing and Aggregating Data; Using the HAVING Clause with GROUP BY Statements; Summary; Exercises; Chapter 7: Selecting Data from Different Tables; Joins Revisited; Combining Results Sets with the UNION Operator; Summary; Exercises; Chapter 8: Queries within Queries; Subquery Terminology; Subqueries in a SELECT List; Subqueries in the WHERE Clause; Operators in Subqueries; Correlated Subquery; Subqueries Used with Other Statements; Summary; Exercises; Chapter 9: Advanced Queries; Updating the Database; Tackling Difficult Queries 327 $aTop Tips for Efficient QueriesSummary; Exercises; Chapter 10: Views; Introducing Views; Summary; Exercises; Chapter 11: Transactions; Introducing Transactions; Transaction Logs; Locks; Isolation Levels; Problem Examples; Revisiting the Example Code; Summary; Exercises; Chapter 12: SQL Security; Security Concepts; Summary; Exercises; Chapter 13: Database Tuning; Tuning Hardware; Tuning SQL; Tuning Tips; Summary; Exercises; Appendix A: Exercise Answers; Chapter 1; Chapter 2; Chapter 3; Chapter 4; Chapter 5; Chapter 6; Chapter 7; Chapter 8; Chapter 9; Chapter 10; Chapter 11; Chapter 12 327 $aChapter 13Appendix B: Setting Up and Using the Five Database Systems; Installing and Using MySQL Version 4.1; Installing and Using IBM DB2; Installing and Using Microsoft Access XP; Installing and Using Microsoft SQL Server 2000; Installing and Using Oracle 10g; Appendix C: Initial Data Setup; Category Table; MemberDetails Table; Location Table; FavCategory Table; Films Table; Attendance Table; Index 330 $aTaking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all timesFocuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendixPaul Wilton is a successful Wrox ""Beginning"" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particu 410 0$aWrox beginning guides. 606 $aSQL (Computer program language) 615 0$aSQL (Computer program language) 676 $a005.75/65 700 $aWilton$b Paul$f1969-$0630536 701 $aColby$b John W.$f1954-$01511541 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910784351503321 996 $aBeginning SQL$93744880 997 $aUNINA LEADER 02875nas 2200697-a 450 001 9910143784003321 005 20241019213017.0 035 $a(DE-599)ZDB2080542-1 035 $a(CKB)991042726061518 035 $a(CONSER)---76643956- 035 $a(EXLCZ)99991042726061518 100 $a20761029a19749999 -f- - 101 0 $aeng 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 00$aEconomic and social survey of Asia and the Pacific /$fUnited Nations 210 $aBangkok $cUnited Nations 215 $a1 online resource 311 08$aPrint version: Economic and social survey of Asia and the Pacific / 0252-5704 (DLC) 76643956 (OCoLC)2538563 531 $aECONOMIC AND SOCIAL SURVEY OF ASIA & THE PACIFIC 531 $aECONOMIC & SOCIAL SURVEY OF ASIA & THE PACIFIC 606 $aEconomic history$2fast$3(OCoLC)fst00901974 606 $aSocial conditions$2fast$3(OCoLC)fst01919811 606 $aEconomic development$zAsia$2ltcsh 606 $aFinance$zAsia$2ltcsh 606 $aSocial conditions$zAsia$2ltcsh 607 $aAsia$xEconomic conditions$y1945-$vPeriodicals 607 $aAsia$xSocial conditions$vPeriodicals 607 $aPacific Area$xEconomic conditions$vPeriodicals 607 $aPacific Area$xSocial conditions$vPeriodicals 607 $aAsie$xConditions économiques$y1945-$vPériodiques 607 $aAsie$xConditions sociales$vPériodiques 607 $aPacifique, Région du$xConditions économiques$vPériodiques 607 $aPacifique, Région du$xConditions sociales$vPériodiques 607 $aAsia$2fast$1https://id.oclc.org/worldcat/entity/E39PBJxMpyjKQ9Jtm3jkjPBgKd 607 $aPacific Area$2fast 607 $aPacific Area$xEconomic conditions$vPeriodicals$2nli 607 $aPacific Area$xSocial conditions$vPeriodicals$2nli 607 $aPacific Area$xEconomic conditions$xStatistics$vPeriodicals$2nli 607 $aAsia$xEconomic conditions$vPeriodicals$2nli 607 $aAsia$xSocial conditions$vPeriodicals$2nli 607 $aAsia$xEconomic conditions$vStatistics$vPeriodicals$2nli 607 $aEast Asia$xEconomic conditions$vPeriodicals$2nli 607 $aEast Asia$xSocial conditions$vPeriodicals$2nli 607 $aEast Asia$xEconomic conditions$xStatistics$vPeriodicals$2nli 608 $aPeriodicals.$2fast 608 $aPeriodicals.$2lcgft 615 7$aEconomic history. 615 7$aSocial conditions. 615 7$aEconomic development 615 7$aFinance 615 7$aSocial conditions 676 $a300 s 676 $a330.95/042 712 02$aUnited Nations.$bEconomic and Social Commission for Asia and the Pacific. 906 $aJOURNAL 912 $a9910143784003321 920 $aexl_impl conversion 996 $aEconomic and social survey of Asia and the Pacific$9885433 997 $aUNINA