SQL for dummies
Uncover the secrets of SQL and start building better relational databases today! This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | E-Book Buch |
| Sprache: | Englisch |
| Veröffentlicht: |
Hoboken, N.J
Wiley
01.01.2013
John Wiley & Sons John Wiley & Sons, Incorporated For Dummies Wiley-Blackwell |
| Ausgabe: | 8th ed |
| Schriftenreihe: | For dummies |
| Schlagworte: | |
| ISBN: | 9781118607961, 1118607961 |
| Online-Zugang: | Volltext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Abstract | Uncover the secrets of SQL and start building better relational databases today! This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruption Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQL Provides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your work Don't be daunted by database development anymore - get SQL For Dummies, 8th Edition, and you'll be on your way to SQL stardom. |
|---|---|
| AbstractList | Uncover the secrets of SQL and start building better relational databases today! This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruption Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQL Provides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your work Don't be daunted by database development anymore - get SQL For Dummies, 8th Edition, and you'll be on your way to SQL stardom. |
| Author | Allen G. Taylor |
| Author_xml | – sequence: 1 fullname: Taylor, Allen G. |
| BackLink | https://cir.nii.ac.jp/crid/1130016018335386501$$DView record in CiNii |
| BookMark | eNqN0F9LwzAQAPCITtzq8CtMEMSHwl3Ta5JHHfMPDEQUX0O6JFjXtbPZFP30RiuIb77kcvC74-5GbK9pG7fDxkpIRJQFCZRy9zcHoQocsFEGyFWeCYH7bCiJCHJS-QEbh_AMAIjAFaghO7q_m098203sdrWqXDhkA2_q4MY_MWGPl7OH6XU6v726mZ7PU0OCSKV5KRVZEAtnCUqS4EslHHoDmXfkMys8Wsm54Ka0XBhPaHPyFsGaIlbyhJ31jU1Yurfw1NaboF9rV7btMug_6_3foor2tLfrrn3ZurDR32zhmk1naj27mCLnlBV5lCe9bKpKL6qvF5HH2xSAcXLisWW8YsKOe7Yy3fbDNXrdVfH7riMF4FAA8U-BGm2G |
| ContentType | eBook Book |
| DBID | MOSFZ PS5 RYH |
| DEWEY | 005.133 |
| DatabaseName | Maruzen eBook Library Maruzen eBook Library (Global) CiNii Complete |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Computer Science |
| DocumentTitleAlternate | SQL for dummies Structured Query Language for dummies |
| EISBN | 9781118657188 1118657187 9781118657119 111865711X |
| Edition | 8th ed 8 8th edition. 7th ed. |
| ExternalDocumentID | 9781118657188 9781118657119 EBC1335264 BD03740392 3000030605 |
| GroupedDBID | -0~ 089 38. 5VX A4J AABBV AALIM ABARN ABIAV ABQPQ ACLGV ACNAM ADVEM AERYV AFOJC AHWGJ AJFER AKHYG ALMA_UNASSIGNED_HOLDINGS AMYDA AZZ BBABE BPBUR CZZ GEOUK JJU MOSFZ MYL NK1 NK2 OHILO OODEK PQQKQ PS5 UZ6 WZT RYH AHRNR 6XM DRU IVK IWL |
| ID | FETCH-LOGICAL-a57559-4b895d07ced50b580fb97e1fa02fe5f2d7f1d83373abd37af51d45fd10da695d3 |
| ISBN | 9781118607961 1118607961 |
| IngestDate | Fri Nov 08 05:35:59 EST 2024 Fri Mar 28 10:36:35 EDT 2025 Wed Dec 10 12:17:03 EST 2025 Fri Jun 27 00:25:13 EDT 2025 Tue Nov 18 22:39:48 EST 2025 |
| IsPeerReviewed | false |
| IsScholarly | false |
| LCCN | 2013942771 |
| LCCallNum_Ident | QA76.73.S67 T39 2013 |
| Language | English |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-a57559-4b895d07ced50b580fb97e1fa02fe5f2d7f1d83373abd37af51d45fd10da695d3 |
| Notes | Includes index |
| OCLC | 855504594 |
| PQID | EBC1335264 |
| PageCount | 480 |
| ParticipantIDs | askewsholts_vlebooks_9781118657188 askewsholts_vlebooks_9781118657119 proquest_ebookcentral_EBC1335264 nii_cinii_1130016018335386501 maruzen_primary_3000030605 |
| PublicationCentury | 2000 |
| PublicationDate | 2013/01/01 c2013 2013 2013-08-07 2013-08-02 |
| PublicationDateYYYYMMDD | 2013-01-01 2013-08-07 2013-08-02 |
| PublicationDate_xml | – month: 01 year: 2013 text: 2013/01/01 day: 01 |
| PublicationDecade | 2010 |
| PublicationPlace | Hoboken, N.J |
| PublicationPlace_xml | – name: Hoboken, N.J – name: Somerset |
| PublicationSeriesTitle | For dummies |
| PublicationYear | 2013 |
| Publisher | Wiley John Wiley & Sons John Wiley & Sons, Incorporated For Dummies Wiley-Blackwell |
| Publisher_xml | – name: Wiley – name: John Wiley & Sons – name: John Wiley & Sons, Incorporated – name: For Dummies – name: Wiley-Blackwell |
| SSID | ssj0001103909 |
| Score | 1.8967445 |
| Snippet | Uncover the secrets of SQL and start building better relational databases today! This fun and friendly guide will help you demystify database management... |
| SourceID | askewsholts proquest nii maruzen |
| SourceType | Aggregation Database Publisher |
| SubjectTerms | Computer programming Database management Relational databases Relational databases (Computer program) SQL (Computer program language) |
| TableOfContents | Intro -- Table of Contents -- Introduction -- About This Book -- Who Should Read This Book? -- Icons Used in This Book -- Where to Go from Here -- Part I: Getting Started with SQL -- Chapter 1: Relational Database Fundamentals -- Keeping Track of Things -- What Is a Database? -- Database Size and Complexity -- What Is a Database Management System? -- Flat Files -- Database Models -- Database Design Considerations -- Chapter 2: SQL Fundamentals -- What SQL Is and Isn't -- A (Very) Little History -- SQL Statements -- Reserved Words -- Data Types -- Null Values -- Constraints -- Using SQL in a Client/Server System -- Using SQL on the Internet or an Intranet -- Chapter 3: The Components of SQL -- Data Definition Language -- Data Manipulation Language -- Data Control Language -- Part II: Using SQL to Build Databases -- Chapter 4: Building and Maintaining a Simple Database Structure -- Using a RAD Tool to Build a Simple Database -- Building POWER with SQL's DDL -- Portability Considerations -- Chapter 5: Building a Multitable Relational Database -- Designing a Database -- Working with Indexes -- Maintaining Data Integrity -- Normalizing the Database -- Part III: Storing and Retrieving Data -- Chapter 6: Manipulating Database Data -- Retrieving Data -- Creating Views -- Updating Views -- Adding New Data -- Updating Existing Data -- Transferring Data -- Deleting Obsolete Data -- Chapter 7: Handling Temporal Data -- Understanding Times and Periods in SQL: 2011 -- Working with Application-Time Period Tables -- Working with System-Versioned Tables -- Tracking Even More Time Data with Bitemporal Tables -- Chapter 8: Specifying Values -- Values -- Value Expressions -- Functions -- Chapter 9: Using Advanced SQL Value Expressions -- CASE Conditional Expressions -- CAST Data-Type Conversions -- Row Value Expressions -- Chapter 10: Zeroing In on the Data You Want Modifying Clauses -- FROM Clauses -- WHERE Clauses -- Logical Connectives -- GROUP BY Clauses -- HAVING Clauses -- ORDER BY Clauses -- Limited FETCH -- Peering through a Window to Create a Result Set -- Chapter 11: Using Relational Operators -- UNION -- INTERSECT -- EXCEPT -- Join Operators -- ON versus WHERE -- Chapter 12: Delving Deep with Nested Queries -- What Subqueries Do -- Chapter 13: Recursive Queries -- What Is Recursion? -- What Is a Recursive Query? -- Where Might You Use a Recursive Query? -- Where Else Might You Use a Recursive Query? -- Part IV: Controlling Operations -- Chapter 14: Providing Database Security -- The SQL Data Control Language -- User Access Levels -- Granting Privileges to Users -- Granting Privileges across Levels -- Granting the Power to Grant Privileges -- Taking Privileges Away -- Using GRANT and REVOKE Together to Save Time and Effort -- Chapter 15: Protecting Data -- Threats to Data Integrity -- Reducing Vulnerability to Data Corruption -- Constraints Within Transactions -- Chapter 16: Using SQL within Applications -- SQL in an Application -- Hooking SQL into Procedural Languages -- Part V: Taking SQL to the Real World -- Chapter 17: Accessing Data with ODBC and JDBC -- ODBC -- ODBC in a Client/Server Environment -- ODBC and the Internet -- ODBC and an Intranet -- JDBC -- Chapter 18: Operating on XML Data with SQL -- How XML Relates to SQL -- The XML Data Type -- Mapping SQL to XML and XML to SQL -- SQL Functions That Operate on XML Data -- Predicates -- Transforming XML Data into SQL Tables -- Mapping Non-Predefined Data Types to XML -- The Marriage of SQL and XML -- Part VI: Advanced Topics -- Chapter 19: Stepping through a Dataset with Cursors -- Declaring a Cursor -- Opening a Cursor -- Fetching Data from a Single Row -- Closing a Cursor Chapter 20: Adding Procedural Capabilities with Persistent Stored Modules -- Compound Statements -- Flow of Control Statements -- Stored Procedures -- Stored Functions -- Privileges -- Stored Modules -- Chapter 21: Handling Errors -- SQLSTATE -- WHENEVER Clause -- Diagnostics Areas -- Handling Exceptions -- Chapter 22: Triggers -- Examining Some Applications of Triggers -- Creating a Trigger -- Firing a Succession of Triggers -- Referencing Old Values and New Values -- Firing Multiple Triggers on a Single Table -- Part VII: The Part of Tens -- Chapter 23: Ten Common Mistakes -- Assuming That Your Clients Know What They Need -- Ignoring Project Scope -- Considering Only Technical Factors -- Not Asking for Client Feedback -- Always Using Your Favorite Development Environment -- Using Your Favorite System Architecture Exclusively -- Designing Database Tables in Isolation -- Neglecting Design Reviews -- Skipping Beta Testing -- Not Documenting Your Process -- Chapter 24: Ten Retrieval Tips -- Verify the Database Structure -- Try Queries on a Test Database -- Double-Check Queries That Include Joins -- Triple-Check Queries with Subselects -- Summarize Data with GROUP BY -- Watch GROUP BY Clause Restrictions -- Use Parentheses with AND, OR, and NOT -- Control Retrieval Privileges -- Back Up Your Databases Regularly -- Handle Error Conditions Gracefully -- Appendix: SQL: 2011 Reserved Words -- Index -- About the Author -- Dedication -- Author's Acknowledgments |
| Title | SQL for dummies |
| URI | https://elib.maruzen.co.jp/elib/html/BookDetail/Id/3000030605 https://cir.nii.ac.jp/crid/1130016018335386501 https://ebookcentral.proquest.com/lib/[SITE_ID]/detail.action?docID=1335264 https://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9781118657119 https://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9781118657188&uid=none |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV1ZSwMxEB61-mAfvMV6sYhvspJkjySPHrWC4gEqvi3ZJoGqrNLWUvz1Tra7bT1AffAlbMLuLDsTJvPtXAC7khETspT5hCntO4ehr6yiPloOsinClLHU5s0m-MWFuL-XV5MTD2UuTO-JZ5no9-XLv4oa11DYLnX2D-IeEsUFvEah44hix_GTRTycFkkd1-d50KDGl42FBo4w-YFrm7LX2B9H-q7rwgek_00ozQcwiFpLxITLQXHzT1WkD49doRmC1tAUTPEYYep0o355ezb6H-V8wkTmzZRKOkVJrOG8ClXVeUTli4q523Etl1T79c1keC5nrdaX0yw_om8WoOLSNhZh0mRLMF82q_AK3bUMc8geD9njFexZgbuT-s3RqV90g_AVmpSR9MNUyEgT3jQ6ImkkiE0lN9QqwqyJLNPcUi2CgAcq1QFXNqI6jKymRKsYnwxWoZI9Z2YNPKuMkpyhqcwcwJQqRKtJaCas4bg54xrsjH1o0nvKPdedpORGxCmVv7hJiBqsF0xKXgblQ5KA5EAUcWQNtpBvSbPlRuocixTxsUuDc51YCa2BV3I0yYkXAbtJ_fCIumS5OFz_gcQGzI620iZUuu1XswUzzV631WlvF5vgHbkVFHs |
| 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+for+dummies&rft.au=Taylor%2C+Allen+G.&rft.date=2013-01-01&rft.pub=John+Wiley+%26+Sons&rft.isbn=9781118607961&rft.externalDocID=BD03740392 |
| thumbnail_m | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fvle.dmmserver.com%2Fmedia%2F640%2F97811186%2F9781118657119.jpg http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fvle.dmmserver.com%2Fmedia%2F640%2F97811186%2F9781118657188.jpg |