05449nam 22006734a 450 991045895760332120200520144314.01-280-63348-497866106334870-08-046004-6(CKB)1000000000364181(EBL)269713(OCoLC)76301229(SSID)ssj0000075775(PQKBManifestationID)11107705(PQKBTitleCode)TC0000075775(PQKBWorkID)10130078(PQKB)11622149(MiAaPQ)EBC269713(CaSebORM)9780123693792(Au-PeEL)EBL269713(CaPaEBR)ebr10138250(CaONFJC)MIL63348(EXLCZ)99100000000036418120050831d2005 uy 0engur|n|---|||||txtccrJoe Celko's SQL for smarties[electronic resource] advanced SQL programming /Joe Celko3rd ed.Amsterdam ;Boston Morgan Kaufmannc20051 online resource (839 p.)The Morgan Kaufmann series in data management systemsDescription based upon print version of record.0-12-369379-9 Includes bibliographical references and index.front cover; copyright; table of contents; front matter; Introduction to the Third Edition; 1.1 What Changed in Ten Years; 1.2 What Is New in This Edition; 1.3 Corrections and Additions; body; 1 Database Design; 1.1 Schema and Table Creation; 1.1.1 CREATE SCHEMA Statement; 1.1.2 Manipulating Tables; 1.1.3 Column Constraints; 1.1.4 UNIQUE Constraints versus UNIQUE Indexes; 1.1.5 Nested UNIQUE Constraints; 1.1.6 Overlapping Keys; 1.1.7 CREATE ASSERTION Constraints; 1.1.8 Using VIEWs for Schema Level Constraints; 1.1.9 Using PRIMARY KEYs and ASSERTIONs for Constraints1.1.10 Avoiding Attribute Splitting1.1.11 Modeling Class Hierarchies in DDL; 1.2 Generating Unique Sequential Numbers for Keys; 1.2.1 IDENTITY Columns; 1.2.2 ROWID and Physical Disk Addresses; 1.2.3 Sequential Numbering in Pure SQL; 1.2.4 GUIDs; 1.2.5 Sequence Generator Functions; 1.2.6 Unique Value Generators; 1.2.7 Preallocated Values; 1.2.8 Random Order Values; 1.3 A Remark on Duplicate Rows; 1.4 Other Schema Objects; 1.4.1 Schema Tables; 1.4.2 Temporary Tables; 1.4.3 CREATE DOMAIN Statement; 1.4.4 CREATE TRIGGER Statement; 1.4.5 CREATE PROCEDURE Statement; 1.4.6 DECLARE CURSOR Statement2 Normalization2.1 Functional and Multivalued Dependencies; 2.2 First Normal Form (1NF); 2.2.1 Note on Repeated Groups; 2.3 Second Normal Form (2NF); 2.4 Third Normal Form (3NF); 2.5 Elementary Key Normal Form (EKNF); 2.6 Boyce-Codd Normal Form (BCNF); 2.7 Fourth Normal Form (4NF); 2.8 Fifth Normal Form (5NF); 2.9 Domain-Key Normal Form (DKNF); 2.10 Practical Hints for Normalization; 2.11 Key Types; 2.11.1 Natural Keys; 2.11.2 Artificial Keys; 2.11.3 Exposed Physical Locators; 2.11.4 Practical Hints for Denormalization; 2.11.5 Row Sorting; 3 Numeric Data in SQL; 3.1 Numeric Types3.1.1 BIT, BYTE, and BOOLEAN Data Types3.2 Numeric Type Conversion; 3.2.1 Rounding and Truncating; 3.2.2 CAST() Function; 3.3 Four-Function Arithmetic; 3.4 Arithmetic and NULLs; 3.5 Converting Values to and from NULL; 3.5.1 NULLIF() Function; 3.5.2 COALESCE() Function; 3.6 Vendor Math Functions; 3.6.1 Number Theory Operators; 3.6.2 Exponential Functions; 3.6.3 Scaling Functions; 3.6.4 Converting Numbers to Words; 4 Temporal Data Types in SQL; 4.1 Notes on Calendar Standards; 4.2 SQL Temporal Data Types; 4.2.1 Tips for Handling Dates, Timestamps, and Times; 4.2.2 Date Format Standards4.2.3 Handling Timestamps4.2.4 Handling Times; 4.3 Queries with Date Arithmetic; 4.4 The Nature of Temporal Data Models; 4.4.1 Temporal Duplicates; 4.4.2 Temporal Databases; 4.4.3 Temporal Projection and Selection; 4.4.4 Temporal Joins; 4.4.5 Modifying Valid-Time State Tables; 4.4.6 Current Modifications; 4.4.7 Sequenced Modifications; 4.4.8 Nonsequenced Modifications; 4.4.9 Transaction-Time State Tables; 4.4.10 Maintaining the Audit Log; 4.4.11 Querying the Audit Log; 4.4.12 Modifying the Audit Log; 4.4.13 Bitemporal Tables; 4.4.14 Temporal Support in Standard SQL5 Character Data Types in SQLSQL 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, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. In the third edition, Joe features new exampMorgan Kaufmann series in data management systems.SQL for smartiesSQL (Computer program language)Electronic books.SQL (Computer program language)005.13/3Celko Joe627493MiAaPQMiAaPQMiAaPQBOOK9910458957603321Joe Celko's sql for smarties1950888UNINA02721oam 2200673I 450 991077944580332120230802005730.01-136-28346-30-203-11269-51-283-89387-81-136-28347-110.4324/9780203112694 (CKB)2550000000710818(EBL)1101348(OCoLC)823389706(SSID)ssj0000786970(PQKBManifestationID)12325723(PQKBTitleCode)TC0000786970(PQKBWorkID)10802886(PQKB)11546977(MiAaPQ)EBC1101348(Au-PeEL)EBL1101348(CaPaEBR)ebr10640520(CaONFJC)MIL420637(OCoLC)823169954(FINmELB)ELB137075(EXLCZ)99255000000071081820180706d2012 uy 0engur|n|---|||||txtccrA complexity theory for public policy /Goktŭg MorcolNew York, N.Y. :Routledge,2012.1 online resource (313 p.)Routledge research in public administration and public policy ;1Routledge research in public administration and public policy ;1Description based upon print version of record.1-138-01574-1 0-415-51827-X Includes bibliographical references and index.pt. 1. Concepts -- pt. 2. Epistemology -- pt. 3. Methodology.Complexity theory has become popular in the natural and social sciences over the last few decades as a result of the advancements in our understanding of the complexities in natural and social phenomena. Concepts and methods of complexity theory have been applied by scholars of public affairs in North America and Europe, but a comprehensive framework for these applications is lacking. A Complexity Theory for Public Policy proposes a conceptual synthesis and sets a foundation for future developments and applications. In this book, Göktu? Morçöl convincingly makes the cRoutledge Research in Public Administration and Public PolicyPolicy sciencesPolicy sciencesMathematical modelsPolitical planningPolicy sciences.Policy sciencesMathematical models.Political planning.320.601Morcol Goktug.1555438FlBoTFGFlBoTFGBOOK9910779445803321A complexity theory for public policy3817323UNINA