SQL for Dummies
Learn SQL the fun and easy way - no programmingexperience needed! SQL For Dummies, 7th Edition, shows programmers and webdevelopers how to use SQL to build relational databases and getvaluable information from them. This book covers the core featuresof the SQL language. Topics covered include how to...
Uloženo v:
| Hlavní autor: | |
|---|---|
| Médium: | E-kniha |
| Jazyk: | angličtina |
| Vydáno: |
Hoboken
John Wiley & Sons, Incorporated
2010
For Dummies |
| Vydání: | 7 |
| Témata: | |
| ISBN: | 9780470557419, 0470557419 |
| On-line přístup: | Získat plný text |
| Tagy: |
Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
|
| Abstract | Learn SQL the fun and easy way - no programmingexperience needed! SQL For Dummies, 7th Edition, shows programmers and webdevelopers how to use SQL to build relational databases and getvaluable information from them. This book covers the core featuresof the SQL language. Topics covered include how to use SQL tostructure a DBMS and implement a database design; secure adatabase; and retrieve information from a database. This editionwill be revised to reflect the new enhancements ofSQL/XML:2008. The latest update of the perennial bestselling SQL ForDummies, which has sold more than 210,000 units in sixeditions.SQL is the most popular database language in the worldCovers creating, accessing, manipulating, maintaining, andstoring information in relational database management systems(DBMS) such as Access, Oracle, SQL Server, and MySQL.Includes new content on using SQL with XML to power data-drivenweb sites and using SQL with Access 2010 Whether you're daunted by database development or a system adminstar, SQL For Dummies, 7th Dummies will have you workingyour web site in no time at all. |
|---|---|
| AbstractList | 'SQL For Dummies' shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. This book covers the core features of the SQL language. Learn SQL the fun and easy way - no programmingexperience needed! SQL For Dummies, 7th Edition, shows programmers and webdevelopers how to use SQL to build relational databases and getvaluable information from them. This book covers the core featuresof the SQL language. Topics covered include how to use SQL tostructure a DBMS and implement a database design; secure adatabase; and retrieve information from a database. This editionwill be revised to reflect the new enhancements ofSQL/XML:2008. The latest update of the perennial bestselling SQL ForDummies, which has sold more than 210,000 units in sixeditions.SQL is the most popular database language in the worldCovers creating, accessing, manipulating, maintaining, andstoring information in relational database management systems(DBMS) such as Access, Oracle, SQL Server, and MySQL.Includes new content on using SQL with XML to power data-drivenweb sites and using SQL with Access 2010 Whether you're daunted by database development or a system adminstar, SQL For Dummies, 7th Dummies will have you workingyour web site in no time at all. |
| Author | Taylor, Allen G |
| Author_xml | – sequence: 1 fullname: Taylor, Allen G |
| BookMark | eNo1j0tLw0AUhUd8YFuDf6ErwUVgJnceuUuN9QEBEcVtuJncoDbNaCa1f9_a6tkcDnwc-KbiqA89H4ip1E4aBKXzQ5Ggy3fbOK3wREysxNxol7lTkcT4IbcBa5WxE3H-_FTO2zDMb9ar1TvHM3HcUhc5-euZeL1dvBT3afl491BclSkZDdak4JX1qsmNb4Bqy0Q1YoYWXKY9MkvKWtXIRtXkGgJG0E7Vus2sb0EDwUxc7o8pLnkT30I3xuq74zqEZaz-DX6N1Ja92LOfQ_hacxyrHea5HwfqqsV1oR2iQvgB3WpIYg |
| ContentType | eBook |
| DEWEY | 005.133 |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Computer Science |
| EISBN | 0470593148 9780470593141 |
| Edition | 7 7th Edition |
| ExternalDocumentID | 9780470593141 EBC479919 |
| GroupedDBID | 089 20A 38. 5VX 8V7 92K A4I A4J AABBV ABARN ABIAV ABQPQ ACLGV ACNAM ADVEM AERYV AFOJC AHWGJ AJFER AKHYG ALMA_UNASSIGNED_HOLDINGS AMYDA AZZ BBABE BPBUR CZZ GEOUK HF4 JJU MYL NK1 NK2 OHILO OODEK PQQKQ |
| ID | FETCH-LOGICAL-a54365-3c16c1d85cd3ab6eaab992963724c9ee0a2f1d0d1ba7da3e93471b4f26cf343a3 |
| ISBN | 9780470557419 0470557419 |
| IngestDate | Wed Nov 12 00:13:13 EST 2025 Wed Nov 26 06:54:39 EST 2025 |
| IsPeerReviewed | false |
| IsScholarly | false |
| LCCallNum_Ident | QA76.73.S67 T39 2010 |
| Language | English |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-a54365-3c16c1d85cd3ab6eaab992963724c9ee0a2f1d0d1ba7da3e93471b4f26cf343a3 |
| OCLC | 609854727 |
| PQID | EBC479919 |
| PageCount | 467 |
| ParticipantIDs | askewsholts_vlebooks_9780470593141 proquest_ebookcentral_EBC479919 |
| PublicationCentury | 2000 |
| PublicationDate | 2010 2010-01-19 |
| PublicationDateYYYYMMDD | 2010-01-01 2010-01-19 |
| PublicationDate_xml | – year: 2010 text: 2010 |
| PublicationDecade | 2010 |
| PublicationPlace | Hoboken |
| PublicationPlace_xml | – name: Hoboken |
| PublicationYear | 2010 |
| Publisher | John Wiley & Sons, Incorporated For Dummies |
| Publisher_xml | – name: John Wiley & Sons, Incorporated – name: For Dummies |
| SSID | ssj0000366156 |
| Score | 1.8383982 |
| Snippet | Learn SQL the fun and easy way - no programmingexperience needed! SQL For Dummies, 7th Edition, shows programmers and webdevelopers how to use SQL to build... 'SQL For Dummies' shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. This book covers... |
| SourceID | askewsholts proquest |
| SourceType | Aggregation Database Publisher |
| SubjectTerms | Computer programming Database management Relational databases SQL (Computer program language) |
| TableOfContents | HAVING Clauses -- ORDER BY Clauses -- Chapter 10: Using Relational Operators -- UNION -- INTERSECT -- EXCEPT -- Various Joins -- ON versus WHERE -- Chapter 11: Delving Deep with Nested Queries -- What Subqueries Do -- Chapter 12: 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 13: 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 14: Protecting Data -- Threats to Data Integrity -- Reducing Vulnerability to Data Corruption -- Constraints Within Transactions -- Chapter 15: Using SQL within Applications -- SQL in an Application -- Hooking SQL into Procedural Languages -- Part V: Taking SQL to the Real World -- Chapter 16: Accessing Data with ODBC and JDBC -- ODBC -- ODBC in a Client/Server Environment -- ODBC and the Internet -- ODBC and an Intranet -- JDBC -- Chapter 17: 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 18: Stepping through a Dataset with Cursors -- Declaring a Cursor -- Opening a Cursor -- Fetching Data from a Single Row -- Closing a Cursor -- Chapter 19: Adding Procedural Capabilities with Persistent Stored Modules -- Compound Statements -- Flow of Control Statements -- Stored Procedures -- Stored Functions -- Privileges -- Stored Modules -- Chapter 20: Handling Errors SQL For Dummies®, 7th Edition -- About the Author -- Dedication -- Author's Acknowledgments -- Contents at a Glance -- Table of Contents -- Introduction -- About This Book -- Who Should Read This Book? -- How This Book Is Organized -- Icons Used in This Book -- Getting Started -- Part I: Basic Concepts -- 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: Specifying Values -- Values -- Value Expressions -- Functions -- Chapter 8: Using Advanced SQL Value Expressions -- CASE Conditional Expressions -- CAST Data-Type Conversions -- Row Value Expressions -- Chapter 9: Zeroing In on the Data You Want -- Modifying Clauses -- FROM Clauses -- WHERE Clauses -- Logical Connectives -- GROUP BY Clauses SQLSTATE -- WHENEVER Clause -- Diagnostics Areas -- Handling Exceptions -- Chapter 21: 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 22: 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 23: 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: 2008 Reserved Words -- Index -- Glossary |
| Title | SQL for Dummies |
| URI | https://ebookcentral.proquest.com/lib/[SITE_ID]/detail.action?docID=479919 https://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9780470593141 |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV3NS8MwFI9z8-AOfovzs4jXQtukTXPUuSk4psIcu5U0TUAcVdY59uf7UpJuzosevIQmgVeSX_s-2t_LQ-iKCxJCKE30maHKJbHCLguoDzGP8uFtCsOsZFUOe7Tfj0cj9lRby2wuzGxM8zyez9nHv0INYwC2Tp39A9yVUBiAawAdWoAd2hWPuOqapI7nXkkavIWbLVEDFzH5tS6bYoppmUC_5Iu5S-qkuyLAxoAe0QfigGPAFiq9ItrZeYZ9nd2_TiMIUBt3nceXh-pLFNgwcGuiMl3firJHE9l-EzV58QZqF1TytPhht0pjPNhBDakzNHZRTeZ7aNvWpXCMmtpHW7ATDuyEYxZygIbdzqB975rCDy4PiabdYeFHws_iUGSYp5HkPGXgx0WYBkQwKT2uHyUv81NOM44lw2BjU6KCSChMMMeHqJ6_5_IIOZRJD4eCilhwQqXifspULBUO4gyk8Ba6XFpZMhuXP6mL5NvOtdCFXXBSzhvmbNK5aRMKLjY7_o2YE7S5APYU1aeTT3mGNsRs-lpMzg0uX3g99hw |
| 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=2010-01-19&rft.pub=For+Dummies&rft.isbn=9780470557419&rft.externalDocID=9780470593141 |
| thumbnail_m | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fvle.dmmserver.com%2Fmedia%2F640%2F97804705%2F9780470593141.jpg |