英文原版书籍
Database英文原版书籍
- Programming Microsoft Office Access 2003 (Core Reference)
Programming Microsoft Office Access 2003
Introduction
Chapter 1 - Data Access Models: Part I
Chapter 2 - Data Access Models: Part II
Chapter 3 - The ADOX Library and Tables
Chapter 4 - Jet SQL, the ADOX Library, and Queries
Chapter 5 - Forms, Controls, and Data
Chapter 6 - Reports, Controls, and Data
Chapter 7 - Designing and Using PivotTables and PivotCharts
Chapter 8 - Microsoft Office Objects
Chapter 9 - Integrating Access with Other Office Applications
Chapter 10 - Database Security
Chapter 11 - Using Access to Build SQL Server Solutions: Part I
Chapter 12 - Using Access to Build SQL Server Solutions: Part II
Chapter 13 - Using Access to Build SQL Server Solutions: Part III
Chapter 14 - Access Does the Web
Chapter 15 - XML and Access- Beginning SQL Server 2005 for Developers
CHAPTER 1 SQL Server 2005 Overview and Installation 1
CHAPTER 2 SQL Server Management Studio 25
CHAPTER 3 Database Design and Creation 53
CHAPTER 4 Security 95
CHAPTER 5 Defining Tables 119
CHAPTER 6 Creating Indexes and Database Diagramming 153
CHAPTER 7 Database Backups, Recovery, and Maintenance 185
CHAPTER 8 Working with the Data 245
CHAPTER 9 Building a View 309
CHAPTER 10 Stored Procedures 335
CHAPTER 11 T-SQL Essentials 359
CHAPTER 12 Advanced T-SQL 403
CHAPTER 13 Triggers 427
CHAPTER 14 SQL Server 2005 Reporting Services 451- Microsoft® SQL Server 2005 Reporting Services For Dummies®
Part I: Just the Basics8
Chapter 1: Getting Familiar with Reporting Services 9
Chapter 2: Retrieving Data from a Database29
Chapter 3: Building and Running a Simple Report47
Part II: Building Reports — Your Creativity Options 63
Chapter 4: We’re Off to See the Wizard65
Chapter 5: Styling with Report Types71
Chapter 6: Accessorizing Your Reports93
Chapter 7: Reporting with Parameters and Format Options117
Chapter 8: Using Report Builder 139
Part III: Publishing, Accessing, and
Subscribing to Reports 155
Chapter 9: Publish or Perish — Getting the Report Out 157
Chapter 10: Executing and Accessing Reports on Demand181
Chapter 11: Delivering Your Reports 201
Part IV: Maintaining Your Reports 225
Chapter 12: Managing and Administering Your Reports227
Chapter 13: Securing Report Server 245
Chapter 14: Optimizing Report Performance 257
Part V: Developing Advanced Reports271
Chapter 15: More About Interactive Reporting 273
Chapter 16: Drilling Down to the Details 289
Chapter 17: Reporting from OLAP Data Sources307
Chapter 18: Helping Executives See the Big Business Picture 323
Part VI: Migrating from Other Reporting Tools 339
Chapter 19: Comparing Reporting Services to Other Popular Reporting Tools 341
Chapter 20: Converting Reports from Access 355
Part VII: The Part of Tens 365
Chapter 21: Ten Cool Tricks with Reporting Services367
Chapter 22: Ten Ways to Hook Into the Microsoft BI Platform375
Chapter 23: Ten Places to Find Reporting Services Support379
Chapter 24: Ten Third Party Tools to Use with Reporting Services 383- Beginning SQL Server™ 2005 Programming
Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?
Chapter 2: Tools of the Trade
Chapter 3: The Foundation Statements of T-SQL
Chapter 4: JOINs
Chapter 5: Creating and Altering Tables
Chapter 6: Constraints
Chapter 7: Adding More to Our Queries
Chapter 8: Being Normal: Normalization and Other Basic Design Issues
Chapter 9: SQL Server Storage and Index Structures
Chapter 10: Views
Chapter 11: Writing Scripts and Batches
Chapter 12: Stored Procedures
Chapter 13: User Defined Functions
Chapter 14: Transactions and Locks
Chapter 15: Triggers
Chapter 16: A Brief XML Primer
Chapter 17: Reporting for Duty, Sir!: A Look At Reporting Services
Chapter 18: Getting Integrated With Integration Services
Chapter 19: Playing Administrator- Microsoft® SQL ServerTM 2005 For Dummies®
Part I: SQL Server 2005: An Overview7
Chapter 1: Introducing SQL Server 2005 9
Chapter 2: New Features in SQL Server 200521
Chapter 3: Introducing and Configuring Management Studio 35
Part II: Basic Operations51
Chapter 4: Creating Databases, Tables, and Relationships with T-SQL53
Chapter 5: Asking Questions and Getting Answers 67
Chapter 6: Building a Simple Application87
Part III: Working with SQL Server99
Chapter 7: Working with XML 101
Chapter 8: Using the Common Language Runtime 121
Chapter 9: Using Stored Procedures131
Chapter 10: Error Handling in T-SQL143
Part IV: Protecting Your Data 155
Chapter 11: Securing Your Data157
Chapter 12: Availability and Preventing Data Loss 173
Chapter 13: Maintaining Integrity with Transactions 185
Chapter 14: Maintaining Data Integrity with Constraints and Triggers191
Part V: Administering a SQL Server System 209
Chapter 15: Configuring a SQL Server System 211
Chapter 16: Scheduling SQL Server Agent Jobs 231
Chapter 17: Sending Information Using Notification Services253
Chapter 18: Maintaining a SQL Server System 261
Chapter 19: Working with Multiple Servers 283
Part VI: Using SQL Server Business
Intelligence (BI) Services305
Chapter 20: SQL Server Integration Services307
Chapter 21: Analysis Services337
Chapter 22: Building Business Reports with Reporting Services 359
Part VII: The Part of Tens 377
Chapter 23: Ten Sources of Information on SQL Server 2005379
Chapter 24: Products that Work with SQL Server 2005383- MDX Solutions Second Edition: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase
Chapter 1 A First Introduction to MDX
Chapter 2 Introduction to MDX Calculated Members and Named Sets
Chapter 3 Common Calculations and Selections in MDX
Chapter 4 MDX Query Context and Execution
Chapter 5 Named Sets and Set Aliases
Chapter 6 Sorting and Ranking in MDX
Chapter 7 Advanced MDX Application Topics
Chapter 8 Using the Attribute Data Model of Microsoft Analysis Services
Chapter 9 Using Attribute Dimensions and Member Properties in Hyperion Essbase
Chapter 10 Extending MDX through External Functions
Chapter 11 Changing the Cube and Dimension Environment through MDX
Chapter 12 The Many Ways to Calculate in Microsoft Analysis Services
Chapter 13 MDX Scripting in Analysis Services 2005
Chapter 14 Enriching the Client Interaction
Chapter 15 Client Programming Basics
Chapter 16 Optimizing MDX
Chapter 17 Working with Local Cubes- The Definitive Guide to MySQL5 Third Edition
CHAPTER 1 What Is MySQL? 3
CHAPTER 2 The Test Environment 17
CHAPTER 3 Introductory Example (An Opinion Poll with PHP) 47
CHAPTER 4 mysql, mysqladmin, and mysqldump 61
CHAPTER 5 MySQL Administrator and MySQL Query Browser71
CHAPTER 6 phpMyAdmin 87
CHAPTER 7 Microsoft Office, OpenOffice/StarOffice 117
CHAPTER 8 Database Design137
CHAPTER 9 An Introduction to SQL 189
CHAPTER 10 SQL Recipes 217
CHAPTER 11 Access Administration and Security 263
CHAPTER 12 GIS Functions299
CHAPTER 13 Stored Procedures and Triggers317
CHAPTER 14 Administration and Server Configuration 345
CHAPTER 15 PHP 403
CHAPTER 16 Perl 481
CHAPTER 17 Java (JDBC and Connector/J) 507
CHAPTER 18 C 527
CHAPTER 19 Visual Basic 6/VBA 545
CHAPTER 20 Visual Basic .NET and C# 573
CHAPTER 21 SQL Reference599
CHAPTER 22 MySQL Tools and Options 667
CHAPTER 23 API Reference 693- Expert Oracle Database 10g Administration
■CHAPTER 1 The Oracle DBA’s World
■CHAPTER 2 Relational Database Modeling and Database Design
■CHAPTER 3 Essential UNIX (and Linux) for the Oracle DBA
■CHAPTER 4 Introduction to the Oracle Database 10g Architecture
■CHAPTER 5 Schema Management
■CHAPTER 6 Oracle Transaction Management
■CHAPTER 7 Installing the Oracle Database 10g RDBMS
■CHAPTER 8 Upgrading to Oracle Database 10g
■CHAPTER 9 Creating an Oracle Database
■CHAPTER 10 Connectivity and Networking
■CHAPTER 11 User Management and Database Security
■CHAPTER 12 Using SQL*Plus and iSQL*Plus
■CHAPTER 13 Loading and Transforming Data
■CHAPTER 14 Using Data Pump Export and Import
■CHAPTER 15 Backing Up Databases
■CHAPTER 16 Database Recovery
■CHAPTER 17 Automatic Management and Online Capabilities
■CHAPTER 18 Managing and Monitoring the Operational Database
■CHAPTER 19 Using Oracle Enterprise Manager
■CHAPTER 20 Managing Oracle Databases on Windows and Linux Systems
■CHAPTER 21 Improving Database Performance: SQL Query Optimization .
■CHAPTER 22 Performance Tuning: Tuning the Instance
■CHAPTER 23 The Oracle Data Dictionary and the Dynamic Performance Views
■CHAPTER 24 Using Oracle PL/SQL Packages
■APPENDIX A Oracle Database 10g SQL and PL/SQL: A Brief Primer- Wrox’s SQL Server™ 2005 Express Edition Starter Kit
Chapter 1: Getting Started with SQL Server 2005 Express Edition
Chapter 2: Database Basics with SQL Server Management Studio
Express Edition
Chapter 3: Creating a Simple Database Application
Chapter 4: Developing a Rich Client Database Application
Chapter 5: Developing a Rich Web Database Application
Chapter 6: Understanding Xcopy Deployment and User Instance Model
Chapter 7: Using XML in Your Database Application
Chapter 8: Debugging Database Applications
Chapter 9: Understanding SQL Server Express Setup
Chapter 10: Deploying Your Application
Chapter 11: Migrating from Microsoft Desktop Engine (MSDE)
Chapter 12: Migrating from Jet and Microsoft Access to MSDE and SSE
Chapter 13: Securing Your Multi-User Database Application
Chapter 14: Upgrading from SSE to Other SQL Server 2005 Editions
Chapter 15: Building Robust Multi-User Database Applications- Expert Oracle Database Architecture 9i and 10g Programming Techniques and Solutions
■CHAPTER 1 Developing Successful Oracle Applications
■CHAPTER 2 Architecture Overview
■CHAPTER 3 Files
■CHAPTER 4 Memory Structures
■CHAPTER 5 Oracle Processes
■CHAPTER 6 Locking and Latching
■CHAPTER 7 Concurrency and Multi-Versioning
■CHAPTER 8 Transactions
■CHAPTER 9 Redo and Undo
■CHAPTER 10 Database Tables
■CHAPTER 11 Indexes
■CHAPTER 12 Datatypes
■CHAPTER 13 Partitioning
■CHAPTER 14 Parallel Execution
■CHAPTER 15 Data Loading and Unloading
Index