- ホーム
- > 洋書
- > 英文書
- > Computer / Languages
Full Description
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 corruptionCovers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQLProvides 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 workDon't be daunted by database development anymore - get SQL For Dummies, 8th Edition, and you'll be on your way to SQL stardom.
Contents
Introduction 1Part I: Getting Started with SQL 3Chapter 1: Relational Database Fundamentals 5Chapter 2: SQL Fundamentals 21Chapter 3: The Components of SQL 51Part II: Using SQL to Build Databases 79Chapter 4: Building and Maintaining a Simple Database Structure 81Chapter 5: Building a Multitable Relational Database 105Part III: Storing and Retrieving Data 137Chapter 6: Manipulating Database Data 139Chapter 7: Handling Temporal Data 157Chapter 8: Specifying Values 171Chapter 9: Using Advanced SQL Value Expressions 197Chapter 10: Zeroing In on the Data You Want 211Chapter 11: Using Relational Operators 243Chapter 12: Delving Deep with Nested Queries 267Chapter 13: Recursive Queries 285Part IV: Controlling Operations 295Chapter 14: Providing Database Security 297Chapter 15: Protecting Data 313Chapter 16: Using SQL within Applications 333Part V: Taking SQL to the Real World 347Chapter 17: Accessing Data with ODBC and JDBC 349Chapter 18: Operating on XML Data with SQL 359Part VI: Advanced Topics 381Chapter 19: Stepping through a Dataset with Cursors 383Chapter 20: Adding Procedural Capabilities with Persistent Stored Modules 393Chapter 21: Handling Errors 411Chapter 22: Triggers 423Part VII: The Part of Tens 429Chapter 23: Ten Common Mistakes 431Chapter 24: Ten Retrieval Tips 435Appendix: SQL: 2011 Reserved Words 439Index 443
