![]() Tables Are Types Keys Are Backwards Pointers Do One Thing Closingħ. 87 Tables and Keys Keys Define the Table Foreign Keys Foreign Key Constraints Generic ID Keys Keep It Specific Common Structures and Relationships One-to-One Relationships One-to-Many Relationships Many-to-Many Relationships Hierarchies and Trees Normal Form Normalization Denormalization The First Normal Form The Second Normal Form The Third Normal Form Higher Normal Forms Indexes How They Work Must Be Diverse INTEGER PRIMARY KEYs Order Matters One at a Time Index Summary Transferring Design ExperienceĨ7 87 89 90 91 92 93 93 95 97 99 102 103 103 104 104 105 106 107 107 108 109 109 110 111 112 Subqueries Compound SELECT Statements Alternate JOIN Notation SELECT Examples Simple SELECTs Simple JOINs JOIN.ON JOIN.USING, NATURAL JOIN OUTER JOIN Compound JOIN Self JOIN WHERE Examples GROUP BY Examples ORDER BY Examples What’s Nextħ6 77 78 79 80 80 81 82 82 82 83 83 84 85 85Ħ. 61 SQL Tables The SELECT Pipeline FROM Clause WHERE Clause GROUP BY Clause SELECT Header HAVING Clause DISTINCT Keyword ORDER BY Clause LIMIT and OFFSET Clauses Advanced Techniques viii | Table of Contents 27 Learning SQL Brief Background Declarative Portability General Syntax Basic Syntax Three-Valued Logic Simple Operators SQL Data Languages Data Definition Language Tables Views Indexes Data Manipulation Language Row Modification Commands The Query Command Transaction Control Language ACID Transactions SQL Transactions Save-Points System Catalogs Wrap-upĢ7 28 28 29 30 30 31 33 34 34 35 43 44 45 46 49 51 51 53 55 57 58ĥ. 17 SQLite Products Precompiled Distributions Documentation Distribution Source Distributions The Amalgamation Source Files Source Downloads BuildingĬonfigure Manually Build Customization Build and Installation Options An sqlite3 Primer SummaryĤ. 9 Database Junior Application Files Application Cache Archives and Data Stores Client/Server Stand-in Teaching Tool Generic SQL Engine Not the Best Choice Big Name Usersģ. 1 Self-Contained, No Server Required Single File Database Zero Configuration Embedded Device Support Unique Features Compatible License Highly ReliableĢ. 1918–1994 He took a young boy whose favorite question was “why?” and taught him to ask the question “how?” (Who also-much to the dismay of his parents and the kitchen telephone-taught him the joy of answering that question, especially if it involved pliers or screwdrivers.) -jk ![]() To my Great-Uncle Albert “Unken Al” Kreibich. While every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions, or for damages resulting from the use of the information contained herein. Where those designations appear in this book, and O’Reilly Media, Inc., was aware of a trademark claim, the designations have been printed in caps or initial caps. ![]() Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Using SQLite, the image of a great white heron, and related trade dress are trademarks of O’Reilly Media, Inc. Nutshell Handbook, the Nutshell Handbook logo, and the O’Reilly logo are registered trademarks of O’Reilly Media, Inc. Indexer: Lucie Haskins Cover Designer: Karen Montgomery Interior Designer: David Futato Illustrator: Robert Romano ![]() Įditor: Mike Loukides Production Editor: Kristen Borg Proofreader: Kiel Van Horn For more information, contact our corporate/institutional sales department: (800) 998-9938 or. ![]() Online editions are also available for most titles (). O’Reilly books may be purchased for educational, business, or sales promotional use. Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |