00985nam0-2200325---450-99000915792040332120100309105328.0000915792FED01000915792(Aleph)000915792FED0100091579220100309d1966----km-y0itay50------baengUSa-------001yyHematologic problems in the newbornby Frank A. Oski and J. Lawrence NaimanPhiladelphia [etc.]Saunders1966VIII, 294 p.ill.24 cmMajor problems in clinical pediatricsconsulting editor: Alexander J.Schaffer4Ematologia618.9215Oski,Frank A.295953Naiman,J. Lawrence507091ITUNINARICAUNIMARCBK9900091579204033218 A 13255DMEPEDMEPEHematologic problems in the newborn778029UNINA05244nam 22007214a 450 991096035980332120200520144314.097866102534639781280253461128025346097807645963220764596322(CKB)1000000000348907(EBL)226434(OCoLC)58448281(SSID)ssj0000109909(PQKBManifestationID)11139008(PQKBTitleCode)TC0000109909(PQKBWorkID)10059894(PQKB)11536910(Au-PeEL)EBL226434(CaPaEBR)ebr10114273(CaONFJC)MIL25346(CaSebORM)9780764577321(MiAaPQ)EBC226434(OCoLC)722444405(OCoLC)ocn722444405 (Perlego)2753034(EXLCZ)99100000000034890720050103d2005 uy 0engur|n|---|||||txtccrBeginning SQL /Paul Wilton and John W. Colby1st editionIndianapolis, IN Wileyc20051 online resource (521 p.)Wrox beginning guides."Programmer to programmer"--Cover.9780764577321 0764577328 Beginning 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 DataSummaryExercises; 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; ExercisesChapter 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 QueriesTop 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 12Chapter 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; IndexTaking 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 particuWrox beginning guides.SQLSQL (Computer program language)SQL (Computer program language)005.75/65Wilton Paul1969-630536Colby John W.1954-1806199MiAaPQMiAaPQMiAaPQBOOK9910960359803321Beginning SQL4355235UNINA