Wentworth
Institute of Technology
Joe Celko's SQL for smarties : advanced SQL programming /
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, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teache...
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Waltham, MA :
Morgan Kaufmann,
[2014]
|
| Edition: | Fifth edition. |
| Series: | Morgan Kaufmann series in data management systems.
|
| Subjects: | |
| Online Access: |
Full text (Wentworth users only) |
| Local Note: | ProQuest Ebook Central |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | in00000149745 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 150123s2014 mau ob 001 0 eng d | ||
| 005 | 20240806211945.3 | ||
| 019 | |a 898422006 |a 898424123 | ||
| 020 | |a 9780128008300 | ||
| 020 | |a 012800830X | ||
| 020 | |a 0128007613 | ||
| 020 | |a 9780128007617 | ||
| 020 | |z 9780128007617 | ||
| 035 | |a (OCoLC)900639849 |z (OCoLC)898422006 |z (OCoLC)898424123 | ||
| 035 | |a (OCoLC)ocn900639849 | ||
| 037 | |a CL0500000537 |b Safari Books Online | ||
| 040 | |a UMI |b eng |e rda |e pn |c UMI |d OCLCF |d DEBBG |d DEBSZ |d EBLCP |d YDXCP |d OCLCQ |d MERUC |d OCLCQ |d REB |d CEF |d OCLCQ |d OCLCO |d INARC |d OCLCQ |d OCLCO |d OCLCL |d OCLCQ |d SXB | ||
| 050 | 4 | |a QA76.73.S67 | |
| 082 | 0 | 4 | |a 005.13/3 |a 005.133 |
| 100 | 1 | |a Celko, Joe, |e author. | |
| 245 | 1 | 0 | |a Joe Celko's SQL for smarties : |b advanced SQL programming / |c Joe Celko. |
| 246 | 3 | |a SQL for smarties | |
| 246 | 3 | |a Advanced SQL programming | |
| 246 | 3 | 0 | |a Structured query language for smarties |
| 246 | 3 | 0 | |a Advanced structured query language programming |
| 250 | |a Fifth edition. | ||
| 264 | 1 | |a Waltham, MA : |b Morgan Kaufmann, |c [2014] | |
| 264 | 4 | |c ©2014 | |
| 300 | |a 1 online resource (1 volume). | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a The Morgan Kaufmann Series in Data Management Systems | |
| 504 | |a Includes bibliographical references and index. | ||
| 505 | 0 | |a Front Cover; Joe Celko's sql for Smarties: Advanced sql Programming; Copyright; Dedication; Contents; Introduction to the Fifth Edition; What is New in this Edition; Corrections and Additions; Part 1: Data Declaration Features; Chapter 1: Databases Versus File Systems; 1.1. The Schema Statement; 1.2. Tables as Entities; 1.3. Tables as Relationships; 1.3.1. E-R Diagrams; 1.4. Rows Versus Records; 1.5. Columns Versus Fields; Chapter 2: Transactions and Concurrency Control; 2.1. Sessions; 2.2. Transactions and ACID ; 2.3. Concurrency Control; 2.3.1. The Transaction Phenomena. | |
| 505 | 8 | |a 2.4. The Isolation Levels2.5. Pessimistic Concurrency Control; 2.6. Snapshot Isolation Optimistic Concurrency; 2.7. Logical Concurrency Control; 2.8. Cap Theorem; 2.9. Base; 2.10. Server-Side Consistency; 2.11. Error Handling; 2.12. Deadlock and Livelocks; Chapter 3: Tables; 3.1. Create Table Statements; 3.1.1. Base Tables; 3.1.2. [Global Local] Temporary Tables; 3.2. Column Definitions; 3.2.1. DEFAULT Clause; 3.2.2. NOT NULL Constraint; 3.2.3. CHECK () Constraint; 3.2.4. UNIQUE and PRIMARY KEY Constraints; 3.2.5. REFERENCES Clause; 3.2.6. Referential Actions. | |
| 505 | 8 | |a 3.2.6.1. Nested UNIQUE Constraints3.2.6.2. Overlapping Keys; 3.3. Computed Columns; 3.4. [NOT] DEFERRABLE Constraints; 3.5. CREATE DOMAIN and CREATE SEQUENCE ; 3.5.1. CREATE DOMAIN ; 3.5.2. CREATE SEQUENCE ; 3.5.2.1. Using the SEQUENCE ; 3.6. Character Set Related Constructs; 3.6.1. CREATE CHARACTER SET ; 3.6.2. CREATE COLLATION ; 3.6.3. CREATE TRANSLATION ; Chapter 4: Keys, Locators, and Generated Values; 4.1. Key Types; 4.1.1. Natural Keys; 4.1.2. Artificial Keys; 4.1.3. Exposed Physical Locators; 4.2. Practical Hints for Denormalization; 4.2.1. Row Sorting; Chapter 5: Normalization. | |
| 505 | 8 | |a 5.1. Functional and Multivalued Dependencies5.2. First Normal Form (1NF); 5.2.1. Note on Repeating Groups; 5.2.1.1. Repeating Columns; 5.2.1.2. Parsing a List in a String; 5.3. Second Normal Form (2NF); 5.4. Third Normal Form (3NF); 5.5. Elementary Key Normal Form (EKNF); 5.6. Boyce-Codd Normal Form (BCNF); 5.7. Fourth Normal Form (4NF); 5.8. Fifth Normal Form (5NF); 5.9. Domain-Key Normal Form (DKNF); 5.10. Practical Hints for Normalization; 5.11. Non-Normal Form Redundancy; 5.11.1. Aggregation Level Redundancy; 5.11.2. Entire Table Redundancy; 5.11.3. Access Path Redundancy. | |
| 505 | 8 | |a 5.11.4. Attribute SplittingChapter 6: VIEWs, Derived, and Other Virtual Tables; 6.1. VIEWs in Queries; 6.2. Updatable and Read-Only VIEWs; 6.3. Types of VIEWs; 6.3.1. Single-Table Projection and Restriction; 6.3.2. Calculated Columns; 6.3.3. Translated Columns; 6.3.4. Grouped VIEWs; 6.3.5. UNION-ed VIEWs; 6.3.6. JOINs in VIEWs; 6.3.7. Nested VIEWs; 6.4. How VIEWs are Handled in the Database Engine; 6.4.1. View Column List; 6.4.2. VIEW Materialization; 6.4.3. In-Line Text Expansion; 6.4.4. Pointer Structures; 6.4.5. Indexing and Views; 6.5. WITH CHECK OPTION Clause; 6.5.1. WITH CHECK OPTION as CHECK() clause. | |
| 520 | |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, 20 years later and in its fifth 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 perfo. | ||
| 588 | 0 | |a Online resource; title from title page (Safari, viewed Janurary 19, 2015). | |
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 758 | |i has work: |a SQL for smarties (Text) |1 https://id.oclc.org/worldcat/entity/E39PCGJvCJJt8bYGCFj8FQtgw3 |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Celko, Joe. |t Joe Celko's SQL for Smarties : Advanced SQL Programming. |d Burlington : Elsevier Science, ©2014 |z 9780128007617 |
| 830 | 0 | |a Morgan Kaufmann series in data management systems. | |
| 852 | |b Ebooks |h ProQuest | ||
| 856 | 4 | 0 | |u https://ebookcentral.proquest.com/lib/wit/detail.action?docID=1887713 |z Full text (Wentworth users only) |t 0 |
| 947 | |a FLO |x pq-ebc-base | ||
| 999 | f | f | |s 390fb52b-475c-4c4b-add7-1ff1684a0e13 |i d5fe1864-3cc9-4e8d-ad1f-f124de3064dc |t 0 |
| 952 | f | f | |a Wentworth Institute of Technology |b Main Campus |c Wentworth Library |d Ebooks |t 0 |e ProQuest |h Other scheme |
| 856 | 4 | 0 | |t 0 |u https://ebookcentral.proquest.com/lib/wit/detail.action?docID=1887713 |y Full text (Wentworth users only) |