LEADER 05431nam 2200661Ia 450 001 9910785122803321 005 20200520144314.0 010 $a1-282-87957-X 010 $a9786612879579 010 $a0-12-382023-5 035 $a(CKB)2670000000048741 035 $a(EBL)610555 035 $a(OCoLC)677829483 035 $a(SSID)ssj0000438515 035 $a(PQKBManifestationID)11321748 035 $a(PQKBTitleCode)TC0000438515 035 $a(PQKBWorkID)10453047 035 $a(PQKB)10174476 035 $a(Au-PeEL)EBL610555 035 $a(CaPaEBR)ebr10427795 035 $a(CaSebORM)9780123820228 035 $a(MiAaPQ)EBC610555 035 $a(EXLCZ)992670000000048741 100 $a20100804d2010 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aJoe Celko's SQL for smarties$b[electronic resource] $eadvanced SQL programming /$fJoe Celko 205 $a4th ed. 210 $aAmsterdam ;$aBoston $cElsevier$d2010 215 $a1 online resource (817 p.) 225 1 $aThe Morgan Kaufmann series in data management systems 300 $aDescription based upon print version of record. 311 $a0-12-382022-7 320 $aIncludes bibliographical references and index. 327 $aFront Cover; Series page; Joe Celko's SQL for Smarties; Copyright; Dedication; Table of Contents; About the Author; Introduction to the Fourth Edition; Chapter 1. Databases versus File Systems; 1.1 Tables as Entities; 1.2 Tables as Relationships; 1.3 Rows versus Records; 1.4 Columns versus Fields; 1.5 Schema Objects; 1.6 CREATE SCHEMA Statement; Chapter 2. Transactions and Concurrency Control; 2.1 Sessions; 2.2 Transactions and ACID; 2.3 Concurrency Control; 2.4 Pessimistic Concurrency Control; 2.5 SNAPSHOT Isolation and Optimistic Concurrency; 2.6 Logical Concurrency Control 327 $a2.7 Deadlock and LivelocksChapter 3. Schema Level Objects; 3.1 CREATE SCHEMA Statement; 3.2 CREATE PROCEDURE, CREATE FUNCTION, and CREATE TRIGGER; 3.3 CREATE DOMAIN Statement; 3.4 CREATE SEQUENCE; 3.5 CREATE ASSERTION; 3.6 Character Set Related Constructs; Chapter 4. Locating Data and Special Numbers; 4.1 Exposed Physical Locators; 4.2 Generated Identifiers; 4.3 Sequence Generator Functions; 4.4 Preallocated Values; 4.5 Special Series; Chapter 5. Base Tables and Related Elements; 5.1 CREATE TABLE Statement; 5.2 Nested UNIQUE Constraints; 5.3 CREATE ASSERTION Constraints; 5.4 TEMPORARY Tables 327 $a5.5 Manipulating Tables5.6 Avoiding Attribute Splitting; 5.7 Modeling Class Hierarchies in DDL; 5.8 Exposed Physical Locators; 5.9 Auto-Incrementing Columns; 5.10 Generated Identifiers; 5.11 A Remark on Duplicate Rows; 5.12 Other Schema Objects; 5.13 Temporary Tables; 5.14 CREATE DOMAIN Statement; 5.15 CREATE TRIGGER Statement; 5.16 CREATE PROCEDURE Statement; 5.17 DECLARE CURSOR Statement; Chapter 6. Procedural, Semiprocedural, and Declarative Programming; 6.1 Basics of Software Engineering; 6.2 Cohesion; 6.3 Coupling; 6.4 The Big Leap; 6.5 Rewriting Tricks; 6.6 Functions for Predicates 327 $a6.7 Procedural versus Logical DecompositionChapter 7. Procedural Constructs; 7.1 CREATE PROCEDURE; 7.2 CREATE TRIGGER; 7.3 CURSORs; 7.4 SEQUENCEs; 7.5 Generated Columns; 7.6 Table Functions; Chapter 8. Auxiliary Tables; 8.1 The Series Table; 8.2 Lookup Auxiliary Tables; 8.3 Auxiliary Function Tables; 8.4 Global Constants Tables; 8.5 A Note on Converting Procedural Code to Tables; Chapter 9. Normalization; 9.1 Functional and Multivalued Dependencies; 9.2 First Normal Form (1NF); 9.3 Second Normal Form (2NF); 9.4 Third Normal Form (3NF); 9.5 Elementary Key Normal Form (EKNF) 327 $a9.6 Boyce-Codd Normal Form (BCNF)9.7 Fourth Normal Form (4NF); 9.8 Fifth Normal Form (5NF); 9.9 Domain-Key Normal Form (DKNF); 9.10 Practical Hints for Normalization; 9.11 Key Types; 9.12 Practical Hints for Denormalization; Chapter 10. Numeric Data Types; 10.1 Numeric Types; 10.2 Numeric Type Conversion; 10.3 Four Function Arithmetic; 10.4 Arithmetic and NULLs; 10.5 Converting Values to and from NULL; 10.6 Mathematical Functions; 10.7 Unique Value Generators; 10.8 IP Addresses; Chapter 11. Temporal Data Types; 11.1 Notes on Calendar Standards; 11.2 SQL Temporal Data Types 327 $a11.3 INTERVAL Data Types 330 $a SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 15 years later and in its fourth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and pe 410 0$aMorgan Kaufmann series in data management systems. 606 $aSQL (Computer program language) 606 $aDatabase design 615 0$aSQL (Computer program language) 615 0$aDatabase design. 676 $a005.13/3 700 $aCelko$b Joe$0627493 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910785122803321 996 $aJoe Celko's SQL for smarties$93722162 997 $aUNINA