本書有DRM加密保護,需使用HyRead閱讀軟體開啟
  • SQL All-in-One for dummies
  • 點閱:7
  • 作者: by Allen G. Taylor
  • 出版社:Wiley Publishing, Inc.
  • 出版年:c2011
  • 集叢名:--For dummies
  • ISBN:9780470929964; 9781118038635
  • 格式:PDF

SQL is the international standard language for creating and maintaining relational databases. This book is a compendium of information about SQL and relational database design, development, and maintenance. The eight mini-books cover the full spectrum of issues that arise in building, using, and maintaining relational database systems. Book I: SQL Concepts Book II: Relational Database Development Book III: SQL Queries Book IV: Data Security Book V: SQL and Programming Book VI: SQL and XML Book VII: Database Tuning Overview Book VIII: Appendixes

  • Introduction(第1頁)
    • About This Book(第1頁)
    • Foolish Assumptions(第2頁)
    • Conventions Used in This Book(第2頁)
    • What You Don’t Have to Read(第3頁)
    • How This Book Is Organized(第3頁)
    • Icons Used in This Book(第5頁)
    • Where to Go from Here(第6頁)
  • Book I: SQL Concepts(第7頁)
    • Chapter 1: Understanding Relational Databases(第9頁)
    • Chapter 2: Modeling a System(第29頁)
    • Chapter 3: Getting to Know SQL(第51頁)
    • Chapter 4: SQL and the Relational Model(第63頁)
    • Chapter 5: Knowing the Major Components of SQL(第73頁)
    • Chapter 6: Drilling Down to the SQL Nitty-Gritty(第95頁)
  • Book II: Relational Database Development(第125頁)
    • Chapter 1: System Development Overview(第127頁)
    • Chapter 2: Building a Database Model(第143頁)
    • Chapter 3: Balancing Performance and Correctness(第161頁)
    • Chapter 4: Creating a Database with SQL(第193頁)
  • Book III: SQL Queries(第205頁)
    • Chapter 1: Values, Variables, Functions, and Expressions(第207頁)
    • Chapter 2: SELECT Statements and Modifying Clauses(第231頁)
    • Chapter 3: Querying Multiple Tables with Subqueries(第275頁)
    • Chapter 4: Querying Multiple Tables with Relational Operators(第303頁)
    • Chapter 5: Cursors(第323頁)
  • Book IV: Data Security(第335頁)
    • Chapter 1: Protecting Against Hardware Failure and External Threats(第337頁)
    • Chapter 2: Protecting Against User Errors and Conflicts(第367頁)
    • Chapter 3: Assigning Access Privileges(第395頁)
    • Chapter 4: Error Handling(第407頁)
  • Book V: SQL and Programming(第423頁)
    • Chapter 1: Database Development Environments(第425頁)
    • Chapter 2: Interfacing SQL to a Procedural Language(第431頁)
    • Chapter 3: Using SQL in an Application Program(第437頁)
    • Chapter 4: Designing a Sample Application(第451頁)
    • Chapter 5: Building an Application(第469頁)
    • Chapter 6: Understanding SQL’s Procedural Capabilities(第485頁)
    • Chapter 7: Connecting SQL to a Remote Database(第501頁)
  • Book VI: SQL and XML(第515頁)
    • Chapter 1: Using XML with SQL(第517頁)
    • Chapter 2: Storing XML Data in SQL Tables(第541頁)
    • Chapter 3: Retrieving Data from XML Documents(第561頁)
  • Book VII: Database Tuning Overview(第577頁)
    • Chapter 1: Tuning the Database(第579頁)
    • Chapter 2: Tuning the Environment(第591頁)
    • Chapter 3: Finding and Eliminating Bottlenecks(第611頁)
  • Book VIII: Appendices(第641頁)
    • Appendix A: SQL: 2008 Reserved Words(第643頁)
    • Appendix B: Glossary(第651頁)
  • Index(第661頁)
紙本書 NT$ 1280
單本電子書
NT$ 896

還沒安裝 HyRead 3 嗎?馬上免費安裝~
QR Code