SQL For Dummies

ISBN-13: 9781119527077 / Angielski / Miękka / 2018 / 512 str.

Allen G. Taylor

Opis

Get ready to make SQL easy! Updated 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.

Spis treści

Introduction 1Part 1: Getting Started with SQL 5Chapter 1: Relational Database Fundamentals 7Chapter 2: SQL Fundamentals 23Chapter 3: The Components of SQL 55Part 2: Using SQL to Build Databases 83Chapter 4: Building and Maintaining a Simple Database Structure 85Chapter 5: Building a Multi-table Relational Database 109Part 3: Storing and Retrieving Data 141Chapter 6: Manipulating Database Data 143Chapter 7: Handling Temporal Data 163Chapter 8: Specifying Values 179Chapter 9: Using Advanced SQL Value Expressions 209Chapter 10: Zeroing In on the Data You Want 223Chapter 11: Using Relational Operators 259Chapter 12: Delving Deep with Nested Queries 283Chapter 13: Recursive Queries 303Part 4: Controlling Operations 313Chapter 14: Providing Database Security 315Chapter 15: Protecting Data 331Chapter 16: Using SQL within Applications 351Part 5: Taking SQL to the Real World 365Chapter 17: Accessing Data with ODBC and JDBC 367Chapter 18: Operating on XML Data with SQL 377Chapter 19: SQL and JSON 399Part 6: Advanced Topics 413Chapter 20: Stepping through a Dataset with Cursors 415Chapter 21: Adding Procedural Capabilities with Persistent Stored Modules 427Chapter 22: Handling Errors 445Chapter 23: Triggers 457Part 7: The Parts of Tens 463Chapter 24: Ten Common Mistakes 465Chapter 25: Ten Retrieval Tips 469Appendix: ISO/IEC SQL: 2016 Reserved Words 473Index 479

O autorze

Allen G. Taylor is a 30-year veteran of the computer industry and the author of over 40 books, including SQL For Dummies and Crystal Reports For Dummies. He lectures nationally on databases, innovation, and entrepreneurship. He also teaches database development internationally through a leading online education provider.