{"product_id":"sql-for-dummies-paperback-softback-9781119527077","title":"SQL For Dummies (Paperback \/ softback) 9781119527077","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eSQL For Dummies\u003c\/font\u003e\u003cbr\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003c\/p\u003e\n\u003cp\u003e\u003cfont size=\"4\"\u003eAllen G. Taylor (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9781119527077, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 18 January 2019\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e512 pages\u003cbr\u003e23.1 x 18.8 x 3.3 cm, 0.658 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\u003cb\u003eGet ready to make SQL easy!\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUpdated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database; and much more.  \u003c\/p\u003e \u003cp\u003eSQL is the international standard database language used to create, access, manipulate, maintain, and store information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL. SQL adds powerful data manipulation and retrieval capabilities to conventional languages—and this book shows you how to harness the core element of relational databases with ease.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eServer platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems\u003c\/li\u003e \u003cli\u003eFind great examples on the use of temporal data\u003c\/li\u003e \u003cli\u003eJump right in—without previous knowledge of database programming or SQL\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eAs database-driven websites continue to grow in popularity—and complexity—\u003ci\u003eSQL For Dummies \u003c\/i\u003eis the easy-to-understand, go-to resource you need to use it seamlessly.\u003c\/p\u003e\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\u003cb\u003eIntroduction\u003c\/b\u003e\u003cb\u003e 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAbout This Book 1\u003c\/p\u003e \u003cp\u003eFoolish Assumptions 2\u003c\/p\u003e \u003cp\u003eIcons Used in This Book 2\u003c\/p\u003e \u003cp\u003eBeyond the Book 3\u003c\/p\u003e \u003cp\u003eWhere to Go from Here 3\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1: Getting Started with SQL 5\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Relational Database Fundamentals\u003c\/b\u003e\u003cb\u003e 7\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eKeeping Track of Things 8\u003c\/p\u003e \u003cp\u003eWhat Is a Database? 9\u003c\/p\u003e \u003cp\u003eDatabase Size and Complexity 10\u003c\/p\u003e \u003cp\u003eWhat Is a Database Management System? 10\u003c\/p\u003e \u003cp\u003eFlat Files 12\u003c\/p\u003e \u003cp\u003eDatabase Models 13\u003c\/p\u003e \u003cp\u003eDatabase Design Considerations 20\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: SQL Fundamentals\u003c\/b\u003e\u003cb\u003e 23\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat SQL Is and Isn’t 23\u003c\/p\u003e \u003cp\u003eA (Very) Little History 25\u003c\/p\u003e \u003cp\u003eSQL Statements 26\u003c\/p\u003e \u003cp\u003eReserved Words 28\u003c\/p\u003e \u003cp\u003eData Types 28\u003c\/p\u003e \u003cp\u003eNull Values 49\u003c\/p\u003e \u003cp\u003eConstraints 50\u003c\/p\u003e \u003cp\u003eUsing SQL in a Client\/Server System 50\u003c\/p\u003e \u003cp\u003eUsing SQL on the Internet or an Intranet 52\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: The Components of SQL\u003c\/b\u003e\u003cb\u003e 55\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData Definition Language 56\u003c\/p\u003e \u003cp\u003eData Manipulation Language 68\u003c\/p\u003e \u003cp\u003eData Control Language 76\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2: Using SQL to Build Databases 83\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Building and Maintaining a Simple Database Structure\u003c\/b\u003e\u003cb\u003e 85\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing a RAD Tool to Build a Simple Database 86\u003c\/p\u003e \u003cp\u003eBuilding POWER with SQL’s DDL 98\u003c\/p\u003e \u003cp\u003ePortability Considerations 107\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Building a Multi-table Relational Database\u003c\/b\u003e\u003cb\u003e 109\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDesigning a Database 110\u003c\/p\u003e \u003cp\u003eWorking with Indexes 119\u003c\/p\u003e \u003cp\u003eMaintaining Data Integrity 122\u003c\/p\u003e \u003cp\u003eNormalizing the Database 134\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 3: Storing and Retrieving Data 141\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Manipulating Database Data\u003c\/b\u003e\u003cb\u003e 143\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRetrieving Data 144\u003c\/p\u003e \u003cp\u003eCreating Views 145\u003c\/p\u003e \u003cp\u003eUpdating Views 149\u003c\/p\u003e \u003cp\u003eAdding New Data 150\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7: Handling Temporal Data\u003c\/b\u003e\u003cb\u003e 163\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Times and Periods 164\u003c\/p\u003e \u003cp\u003eWorking with Application-Time Period Tables 165\u003c\/p\u003e \u003cp\u003eWorking with System-Versioned Tables 171\u003c\/p\u003e \u003cp\u003eTracking Even More Time Data with Bitemporal Tables 175\u003c\/p\u003e \u003cp\u003eFormatting and Parsing Dates and Times 176\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8: Specifying Values\u003c\/b\u003e\u003cb\u003e 179\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eValues 179\u003c\/p\u003e \u003cp\u003eValue Expressions 186\u003c\/p\u003e \u003cp\u003eFunctions 189\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9: Using Advanced SQL Value Expressions\u003c\/b\u003e\u003cb\u003e 209\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCASE Conditional Expressions 210\u003c\/p\u003e \u003cp\u003eCAST Data-Type Conversions 217\u003c\/p\u003e \u003cp\u003eRow Value Expressions 221\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10: Zeroing In on the Data You Want\u003c\/b\u003e\u003cb\u003e 223\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModifying Clauses 224\u003c\/p\u003e \u003cp\u003eFROM Clauses 225\u003c\/p\u003e \u003cp\u003eWHERE Clauses 226\u003c\/p\u003e \u003cp\u003eLogical Connectives 243\u003c\/p\u003e \u003cp\u003eGROUP BY Clauses 245\u003c\/p\u003e \u003cp\u003eHAVING Clauses 247\u003c\/p\u003e \u003cp\u003eORDER BY Clauses 248\u003c\/p\u003e \u003cp\u003eLimited FETCH 250\u003c\/p\u003e \u003cp\u003ePeering through a Window to Create a Result Set 251\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11: Using Relational Operators\u003c\/b\u003e\u003cb\u003e 259\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUNION 259\u003c\/p\u003e \u003cp\u003eINTERSECT 262\u003c\/p\u003e \u003cp\u003eEXCEPT 264\u003c\/p\u003e \u003cp\u003eJoin Operators 265\u003c\/p\u003e \u003cp\u003eON versus WHERE 282\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12: Delving Deep with Nested Queries\u003c\/b\u003e\u003cb\u003e 283\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Subqueries Do 285\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13: Recursive Queries\u003c\/b\u003e\u003cb\u003e 303\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is Recursion? 303\u003c\/p\u003e \u003cp\u003eWhat Is a Recursive Query? 306\u003c\/p\u003e \u003cp\u003eWhere Might You Use a Recursive Query? 306\u003c\/p\u003e \u003cp\u003eWhere Else Might You Use a Recursive Query? 311\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 4: Controlling Operations 313\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14: Providing Database Security \u003c\/b\u003e\u003cb\u003e315\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe SQL Data Control Language 316\u003c\/p\u003e \u003cp\u003eUser Access Levels 316\u003c\/p\u003e \u003cp\u003eGranting Privileges to Users 318\u003c\/p\u003e \u003cp\u003eGranting Privileges across Levels 325\u003c\/p\u003e \u003cp\u003eGranting the Power to Grant Privileges 327\u003c\/p\u003e \u003cp\u003eTaking Privileges Away 328\u003c\/p\u003e \u003cp\u003eUsing GRANT and REVOKE Together to Save Time and Effort 329\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15: Protecting Data\u003c\/b\u003e\u003cb\u003e 331\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThreats to Data Integrity 332\u003c\/p\u003e \u003cp\u003eReducing Vulnerability to Data Corruption 336\u003c\/p\u003e \u003cp\u003eConstraints Within Transactions 345\u003c\/p\u003e \u003cp\u003eAvoiding SQL Injection Attacks 350\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16: Using SQL within Applications\u003c\/b\u003e\u003cb\u003e 351\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSQL in an Application 352\u003c\/p\u003e \u003cp\u003eHooking SQL into Procedural Languages 354\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 5: Taking SQL to the Real World 365\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17: Accessing Data with ODBC and JDBC\u003c\/b\u003e\u003cb\u003e 367\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eODBC 368\u003c\/p\u003e \u003cp\u003eODBC in a Client\/Server Environment 370\u003c\/p\u003e \u003cp\u003eODBC and the Internet 370\u003c\/p\u003e \u003cp\u003eODBC and an Intranet 373\u003c\/p\u003e \u003cp\u003eJDBC 373\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18: Operating on XML Data with SQL\u003c\/b\u003e\u003cb\u003e 377\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHow XML Relates to SQL 377\u003c\/p\u003e \u003cp\u003eThe XML Data Type 378\u003c\/p\u003e \u003cp\u003eMapping SQL to XML and XML to SQL 380\u003c\/p\u003e \u003cp\u003eSQL Functions That Operate on XML Data 385\u003c\/p\u003e \u003cp\u003ePredicates 390\u003c\/p\u003e \u003cp\u003eTransforming XML Data into SQL Tables 392\u003c\/p\u003e \u003cp\u003eMapping Non-Predefined Data Types to XML 393\u003c\/p\u003e \u003cp\u003eThe Marriage of SQL and XML 398\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 19: SQL and JSON\u003c\/b\u003e\u003cb\u003e 399\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing JSON with SQL 400\u003c\/p\u003e \u003cp\u003eThe SQL\/JSON Data Model 401\u003c\/p\u003e \u003cp\u003eSQL\/JSON Functions 403\u003c\/p\u003e \u003cp\u003eSQL\/JSON Path Language 411\u003c\/p\u003e \u003cp\u003eThere’s More 412\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 6: Advanced Topics 413\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 20: Stepping through a Dataset with Cursors\u003c\/b\u003e\u003cb\u003e 415\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDeclaring a Cursor 416\u003c\/p\u003e \u003cp\u003eOpening a Cursor 421\u003c\/p\u003e \u003cp\u003eFetching Data from a Single Row 422\u003c\/p\u003e \u003cp\u003eClosing a Cursor 425\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 21: Adding Procedural Capabilities with Persistent Stored Modules\u003c\/b\u003e\u003cb\u003e 427\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCompound Statements 428\u003c\/p\u003e \u003cp\u003eFlow of Control Statements 435\u003c\/p\u003e \u003cp\u003eStored Procedures 440\u003c\/p\u003e \u003cp\u003eStored Functions 442\u003c\/p\u003e \u003cp\u003ePrivileges 442\u003c\/p\u003e \u003cp\u003eStored Modules 443\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 22: Handling Errors\u003c\/b\u003e\u003cb\u003e 445\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSQLSTATE 445\u003c\/p\u003e \u003cp\u003eWHENEVER Clause 447\u003c\/p\u003e \u003cp\u003eDiagnostics Areas 448\u003c\/p\u003e \u003cp\u003eHandling Exceptions 455\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 23: Triggers\u003c\/b\u003e\u003cb\u003e 457\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExamining Some Applications of Triggers 457\u003c\/p\u003e \u003cp\u003eCreating a Trigger 458\u003c\/p\u003e \u003cp\u003eFiring a Succession of Triggers 460\u003c\/p\u003e \u003cp\u003eReferencing Old Values and New Values 461\u003c\/p\u003e \u003cp\u003eFiring Multiple Triggers on a Single Table 462\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 7: The Parts of Tens 463\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 24: Ten Common Mistakes\u003c\/b\u003e\u003cb\u003e 465\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAssuming That Your Clients Know What They Need 465\u003c\/p\u003e \u003cp\u003eIgnoring Project Scope 466\u003c\/p\u003e \u003cp\u003eConsidering Only Technical Factors 466\u003c\/p\u003e \u003cp\u003eNot Asking for Client Feedback 466\u003c\/p\u003e \u003cp\u003eAlways Using Your Favorite Development Environment 467\u003c\/p\u003e \u003cp\u003eUsing Your Favorite System Architecture Exclusively 467\u003c\/p\u003e \u003cp\u003eDesigning Database Tables in Isolation 467\u003c\/p\u003e \u003cp\u003eNeglecting Design Reviews 468\u003c\/p\u003e \u003cp\u003eSkipping Beta Testing 468\u003c\/p\u003e \u003cp\u003eNot Documenting Your Process 468\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 25: Ten Retrieval Tips\u003c\/b\u003e\u003cb\u003e 469\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eVerify the Database Structure 470\u003c\/p\u003e \u003cp\u003eTry Queries on a Test Database 470\u003c\/p\u003e \u003cp\u003eDouble-Check Queries That Include Joins 470\u003c\/p\u003e \u003cp\u003eTriple-Check Queries with Subselects 470\u003c\/p\u003e \u003cp\u003eSummarize Data with GROUP BY 471\u003c\/p\u003e \u003cp\u003eWatch GROUP BY Clause Restrictions 471\u003c\/p\u003e \u003cp\u003eUse Parentheses with AND, OR, and NOT 471\u003c\/p\u003e \u003cp\u003eControl Retrieval Privileges 472\u003c\/p\u003e \u003cp\u003eBack Up Your Databases Regularly 472\u003c\/p\u003e \u003cp\u003eHandle Error Conditions Gracefully 472\u003c\/p\u003e \u003cp\u003eAppendix: ISO\/IEC SQL: 2016 Reserved Words 473\u003c\/p\u003e \u003cp\u003eIndex 479\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Computer programming \/ software development [\u003ca title=\"See our other books on Computer programming \/ software development\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Computer%20programming%20\/%20software%20development%20%5BUM%5D%22\"\u003eUM\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"For Dummies","offers":[{"title":"Brand New","offer_id":52458356703512,"sku":"9781119527077","price":18.59,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9781119527077.jpg?v=1785371496","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/sql-for-dummies-paperback-softback-9781119527077","provider":"Freshly Printed Books","version":"1.0","type":"link"}