SQL All-in-One For Dummies

Allen G. Taylor is a 30-year veteran of the computer industry and the author of more than 40 books, including previous editions of SQL For Dummies and SQL All-in-One For Dummies. Richard Blum has more than 30 years of experience in the IT industry as a systems and network administrator. He is author of Linux All-in-One For Dummies 7th Edition, and PHP, MySQL, & JavaScript All-in-One For Dummies.

• Introduction 1Book 1: Getting Started with SQL 5Chapter 1: Understanding Relational Databases 7Chapter 2: Modeling a System 29Chapter 3: Getting to Know SQL 53Chapter 4: SQL and the Relational Model 65Chapter 5: Knowing the Major Components of SQL 75Chapter 6: Drilling Down to the SQL Nitty-Gritty 99Book 2: Developing Relational Databases 133Chapter 1: System Development Overview 135Chapter 2: Building a Database Model 151Chapter 3: Balancing Performance and Correctness 169Chapter 4: Creating a Database with SQL 203Book 3: Writing SQL Queries 217Chapter 1: Values, Variables, Functions, and Expressions 219Chapter 2: SELECT Statements and Modifying Clauses 249Chapter 3: Querying Multiple Tables with Subqueries 295Chapter 4: Querying Multiple Tables with Relational Operators 323Chapter 5: Cursors 345Book 4: Securing Your Data 357Chapter 1: Protecting Against Hardware Failure and External Threats 359Chapter 2: Protecting Against User Errors and Conflicts 391Chapter 3: Assigning Access Privileges 419Chapter 4: Error Handling 431Book 5: Programming with SQL 447Chapter 1: Database Development Environments 449Chapter 2: Interfacing SQL to a Procedural Language 455Chapter 3: Using SQL in an Application Program 461Chapter 4: Designing a Sample Application 477Chapter 5: Building an Application 497Chapter 6: Understanding SQL’s Procedural Capabilities 513Chapter 7: Connecting SQL to a Remote Database 531Book 6: Working with Advanced Data Types in SQL: XML, JSON, and PGQ 545Chapter 1: Using XML with SQL 547Chapter 2: Storing XML Data in SQL Tables 575Chapter 3: Retrieving Data from XML Documents 599Chapter 4: Using JSON with SQL 617Chapter 5: Exploring Property Graph Queries 633Book 7: Optimizing Your Database 645Chapter 1: Tuning the Database 647Chapter 2: Tuning the Environment 659Chapter 3: Finding and Eliminating Performance Bottlenecks 681Book 8: Appendixes 709Chapter 1: SQL:2023 Reserved Words 711Chapter 2: Glossary 721Index 731