SQL : practical guide for developers
Would the basics of SQL querying be useful to you, but you don't want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general progr...
Uložené v:
| Hlavní autori: | , |
|---|---|
| Médium: | E-kniha Kniha |
| Jazyk: | English |
| Vydavateľské údaje: |
San Francisco
Elsevier
2005
Amsterdam ; Tokyo Morgan Kaufmann Pub Elsevier Science & Technology Morgan Kaufmann |
| Vydanie: | 1 |
| Edícia: | Morgan Kaufmann practical guides series |
| Predmet: | |
| ISBN: | 9780122205316, 0122205316 |
| On-line prístup: | Získať plný text |
| Tagy: |
Pridať tag
Žiadne tagy, Buďte prvý, kto otaguje tento záznam!
|
| Abstract | Would the basics of SQL querying be useful to you, but you don't want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics--and more--in an easily digestible way.
+ Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL.+ The approach is vendor-neutral-so very adaptable and flexible-but the book's Web site includes information about DBMS-specific peculiarities.+ The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter.+ Coverage is on the key features of the language that are required to understand SQL and begin using it effectively.+ SQL 2003-compliant. |
|---|---|
| AbstractList | Would the basics of SQL querying be useful to you, but you don't want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics--and more--in an easily digestible way.
+ Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL.+ The approach is vendor-neutral-so very adaptable and flexible-but the book's Web site includes information about DBMS-specific peculiarities.+ The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter.+ Coverage is on the key features of the language that are required to understand SQL and begin using it effectively.+ SQL 2003-compliant. A solid guide and reference to the key elements of SQL and how to use it effectively. SQL 2003 compliant. |
| Author | Speegle, Gregory D. (Gregory David) Donahoo, Michael J. |
| Author_xml | – sequence: 1 fullname: Donahoo, Michael J. – sequence: 2 fullname: Speegle, Gregory D. (Gregory David) |
| BackLink | https://cir.nii.ac.jp/crid/1130282272645615616$$DView record in CiNii |
| BookMark | eNo1j1tLw0AQhVe0Ylv7H4IUwYets7O3rG-21AsURFTwLSS7G40NTc2m9e-7GoVhLszH4ZwROdo0G0_IGYMZA6Yu50anFChDigiSM6pmrxIAKD8gI4AURGq0kIdkEkFg2FNqQEYIIEEYptgxGcafUQaZOiGTED6iAKAEFGpIpk-Pq-Qq2ba57Sqb18nbrnI-KZs2cX7v62br23BKBmVeBz_5m2PycrN8XtzR1cPt_eJ6RXMlDCqqUfICU_TaAjcKS7A2906Uyhn0ceeFhhJkyQsonPZ5PKNrh8JZV6Z8TC563Tys_Vd4b-ouZPvaF02zDtlPxP_IGNnznt22zefOhy77xazfdG1eZ8v5AiUqDRGc9uCmqjJb_XTGOESbqFEJqVgsxb8BnCJi2A |
| ContentType | eBook Book |
| DBID | RYH |
| DEWEY | 005.13/3 |
| DOI | 10.1016/B978-0-12-220531-6.X5000-3 |
| DatabaseName | CiNii Complete |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Computer Science |
| EISBN | 0080489745 9780080489742 |
| Edition | 1 |
| ExternalDocumentID | 9780080489742 EBC252670 BA8768345X |
| GroupedDBID | 089 20A 35M 38. A4I A4J AAAAS AABBV AAGAK AALRI AAORS AAXUO AAYWO AAZNM ABARN ABGWT ABIAV ABLXK ABMAC ABMRC ABQPQ ABQQC ACHHS ACLGV ACXMD ADCEY ADVEM AERYV AFOJC AGAMA AHPGB AHWGJ AJFER AKHYG ALMA_UNASSIGNED_HOLDINGS ANFFI AVWMD AZZ BBABE CETPU CZZ DGIFQ EBSCA FEDTE GEOUK HF4 HGY HVGLF INJ IOW JJU JXA KAJ MYL OHILO OODEK P73 PQQKQ RYH SDK SRW UO7 AADAM AJLYV IVK |
| ID | FETCH-LOGICAL-a64926-7253b282e7c03962f0ccaed4f6d92ecca3b70f05f3b0bd7eab70012d24dcdf83 |
| ISBN | 9780122205316 0122205316 |
| IngestDate | Thu Feb 27 10:12:48 EST 2025 Wed Nov 26 07:03:17 EST 2025 Thu Jun 26 23:14:17 EDT 2025 |
| IsPeerReviewed | false |
| IsScholarly | false |
| LCCN | 2005049161 |
| LCCallNum_Ident | QA76.73.S6 |
| Language | English |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-a64926-7253b282e7c03962f0ccaed4f6d92ecca3b70f05f3b0bd7eab70012d24dcdf83 |
| Notes | "Morgan kaufmann publishers is an imprint of Elzevier"--T.p. verso HTTP:URL=http://www.loc.gov/catdir/enhancements/fy0625/2005049161-t.html Information=Table of contents only Includes index HTTP:URL=http://www.loc.gov/catdir/enhancements/fy0625/2005049161-d.html Information=Publisher description |
| OCLC | 780969216 |
| PQID | EBC252670 |
| PageCount | 273 |
| ParticipantIDs | askewsholts_vlebooks_9780080489742 proquest_ebookcentral_EBC252670 nii_cinii_1130282272645615616 |
| PublicationCentury | 2000 |
| PublicationDate | c2005 2005 2010-07-21 |
| PublicationDateYYYYMMDD | 2005-01-01 2010-07-21 |
| PublicationDate_xml | – year: 2005 text: c2005 |
| PublicationDecade | 2000 2010 |
| PublicationPlace | San Francisco Amsterdam ; Tokyo |
| PublicationPlace_xml | – name: San Francisco – name: Amsterdam ; Tokyo – name: Chantilly |
| PublicationSeriesTitle | Morgan Kaufmann practical guides series |
| PublicationYear | 2005 2010 |
| Publisher | Elsevier Morgan Kaufmann Pub Elsevier Science & Technology Morgan Kaufmann |
| Publisher_xml | – name: Elsevier – name: Morgan Kaufmann Pub – name: Elsevier Science & Technology – name: Morgan Kaufmann |
| SSID | ssj0000250246 ssib021903032 ssib002900739 |
| Score | 1.866495 |
| Snippet | A solid guide and reference to the key elements of SQL and how to use it effectively. SQL 2003 compliant. Would the basics of SQL querying be useful to you, but you don't want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get... |
| SourceID | askewsholts proquest nii |
| SourceType | Aggregation Database Publisher |
| SubjectTerms | SQL (Computer program language) |
| TableOfContents | Cover -- SQL: Practical Guide for Developers -- Copyright -- Table of Contents -- Preface -- Chapter 1. Databasics -- 1.1 Tables -- 1.2 Data Types -- 1.3 NULL -- 1.4 Primary Key -- 1.5 Table Relationships -- 1.6 Restaurant Database -- 1.7 Wrap Up -- Chapter 2. Retrieval: Basic SELECTion -- 2.1 Simple SELECT -- 2.2 Selecting Rows -- 2.3 Standard Comparison Operators -- 2.4 String Comparisons -- 2.5 Matching String Patterns with LIKE -- 2.6 Getting What We Haven't Got with NOT -- 2.7 Combining Conditions with AND and OR -- 2.8 Selecting a Range of Values with BETWEEN -- 2.9 Selecting a Set of Values Using IN -- 2.10 IS NULL: Exploring the Unknown -- 2.11 ANDs, ORs, NOTs with NULLs: Three-Valued Logic -- 2.12 Three-Valued Logic and the IN Operator -- 2.13 How WHERE Determines What's In and Out -- 2.14 Wrap Up -- Chapter 3. Reshaping Results -- 3.1 AS: Naming Result Table Columns -- 3.2 DISTINCT and ALL: Dealing with Duplicates -- 3.3 Derived Attributes -- 3.4 Computation in the WHERE Clause -- 3.5 ORDER BY: Ordering Result Table Traversal -- 3.6 CAST: Data Type Conversion -- 3.7 CASE, COALESCE, and NULLIF: Conditional Expressions -- 3.8 Wrap Up -- Chapter 4. Aggregating Results -- 4.1 Aggregation Functions -- 4.2 Removing Rows before Aggregation with WHERE -- 4.3 Removing Repeating Data with DISTINCT before Aggregation -- 4.4 Mixing Attributes, Aggregates, and Literals -- 4.5 Group Aggregation Using GROUP BY -- 4.6 Removing Rows before Grouping with WHERE -- 4.7 Sorting Groups with ORDER BY -- 4.8 Removing Groups with HAVING -- 4.9 Aggregates over Expressions -- 4.10 Wrap Up -- Chapter 5. Joins -- 5.1 Two Table Joins with WHERE -- 5.2 Table Aliases -- 5.3 Joins Needing More Than Two Tables -- 5.4 Self-Join: Joining a Table with Itself -- 5.5 Example Joins -- 5.6 How Does a Join Really Work? -- 5.7 Theta Joins: Generalizing Join Predicates 5.8 JOIN Operator -- 5.9 Join Strategies -- 5.10 Wrap Up -- Chapter 6. Set Queries: UNION, INTERSECT, and EXCEPT -- 6.1 UNION -- 6.2 INTERSECT -- 6.3 EXCEPT -- 6.4 Wrap Up -- Chapter 7. Subqueries -- 7.1 What Are Subqueries? -- 7.2 Multilevel Subquery Nesting -- 7.3 Subqueries Using NOT IN -- 7.4 Subqueries with Empty Results -- 7.5 Combining JOIN and Subqueries -- 7.6 Standard Comparison Operators with Lists Using ANY, SOME, or ALL -- 7.7 Correlated Subqueries -- 7.8 EXISTS -- 7.9 Derived Relations„Subqueries in the FROM Clause -- 7.10 Subqueries in the HAVING Clause -- 7.11 Subset Queries -- 7.12 Subqueries in the SELECT Clause -- 7.13 Wrap Up -- Chapter 8. Modifying Data -- 8.1 INSERT: Adding New Rows -- 8.2 DELETE: Removing Rows -- 8.3 UPDATE: Changing Row Values -- 8.4 Testing Your DELETE and UPDATE WHERE Conditions -- 8.5 Living within Constraints -- 8.6 Wrap Up -- Chapter 9. Creating, Deleting, and Altering Tables -- 9.1 Creating Simple Tables -- 9.2 DEFAULT Values -- 9.3 Constraints -- 9.4 Creating a Table from Tables -- 9.5 CREATE DOMAIN -- 9.6 Referential Actions: The Autopilot of Foreign Key Maintenance -- 9.7 Indexes -- 9.8 DROP TABLE -- 9.9 ALTER TABLE -- 9.10 Generated Values -- 9.11 Sequences -- 9.12 Global and Local Temporary Tables -- 9.13 Creating a Database -- 9.14 Wrap Up -- Chapter 10. Views -- 10.1 Why Views? -- 10.2 Querying Views -- 10.3 Updating Views -- 10.4 DROP VIEW -- 10.5 Wrap Up -- Chapter 11. Transactions -- 11.1 Ending a Transaction„COMMIT and ROLLBACK -- 11.2 Starting a Transaction„START TRANSACTION -- 11.3 Auto-Commit -- 11.4 SAVEPOINTs -- 11.5 Immediate or Deferred Constraints -- 11.6 Testing Changes with Transactions -- 11.7 Transaction Characteristics -- 11.8 Locking Issues -- 11.9 Wrap Up -- Chapter 12. Database Privileges -- 12.1 GRANT -- 12.2 REVOKE -- 12.3 PUBLIC 12.4 Creating a Set of Privileges Using ROLEs -- 12.5 Using Privileges and Views -- 12.6 Wrap Up -- Chapter 13. Introduction to Cursors, Embedded SQL, Stored Procedures, and Triggers -- 13.1 CURSORs -- 13.2 Programming with SQL -- 13.3 Triggers -- 13.4 Wrap Up -- Index |
| Title | SQL : practical guide for developers |
| URI | https://cir.nii.ac.jp/crid/1130282272645615616 https://ebookcentral.proquest.com/lib/[SITE_ID]/detail.action?docID=252670 https://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9780080489742&uid=none |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV3NT6QwFH_RcQ_rxY_djeMnMd5MZzsttODN0dHNanRN1MyNAC1KNIyR0fjn-woF1NVs9mBCGkqghPej7ft-AFtaeooyFRAecUVcpQPii0gSz5hyZao5L2sdXh7LkxN_NAr-2GINRVlOQOa5__QU3H0q1HgNwTahs_8BdzMoXsBzBB1bhB3bNxxx07VBHWfHpYBvA5-Q9lcPmaqSetvYKN3aboxS-Ho8fuE6v_2719rStb6qHI1tEMv2fs9qFKqecYWvtQi10sB7ozSoo1leCZPGyMbMnBTvLq2VlD-oMvL2GanuJaI3MjUVCG83lMbNb7CLa63PXW80DdN41oGZw-HpxVGjBDMMGHNFmeqofrnNitT060yxffHz45fPwmxU3OC2gFvGpEA-Ic-yv3bXkmU4n4eOCSNZgCmdL8JcXTzDsWvpN9hCuJwdpwHLKcFyECynBes7XBwMz_d-EVuygkTCpF4kknk8RjFWy4TyQLCU4hTRyk2FCpiZLjyWNKVeymMaK6mj2Bj-mWKuSlTq8x_Qyce5XgInTpIgwic4TZBlTXB0hpSM-kr7XAjqdmHzxSeHj7eldb0IDfFQDHB9lBRZF9aQEmGSmbZvjNTIEEpkgpFtxkN0YaOmUVg-b12Cw-Fgj3lMSLr8jxFW4Gv7g61CZ3L_oNfgS_I4yYr7dQv4M_DvL0s |
| linkProvider | ProQuest Ebooks |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.title=SQL+%3A+practical+guide+for+developers&rft.au=Donahoo%2C+Michael+J.&rft.au=Speegle%2C+Gregory+D.+%28Gregory+David%29&rft.date=2005-01-01&rft.pub=Elsevier&rft.isbn=9780122205316&rft_id=info:doi/10.1016%2FB978-0-12-220531-6.X5000-3&rft.externalDocID=BA8768345X |
| thumbnail_m | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fvle.dmmserver.com%2Fmedia%2F640%2F97800804%2F9780080489742.jpg |