| |
| |
| Preface | |
| |
| |
| Acknowledgments | |
| |
| |
| Author | |
| |
| |
| |
| Introduction to Database Systems and Cloud Computing | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Overview of Database Management Systems | |
| |
| |
| |
| Database Components | |
| |
| |
| |
| Database Development Process | |
| |
| |
| |
| Overview of Cloud Computing | |
| |
| |
| |
| Software as a Service | |
| |
| |
| |
| Platform as a Service | |
| |
| |
| |
| Infrastructure as a Service | |
| |
| |
| |
| Personal Cloud | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| |
| Database Design and Windows Azure Data Storage | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Database Conceptual Design | |
| |
| |
| |
| Interview Key Players | |
| |
| |
| |
| Observe How Data Are Used in Business Processes | |
| |
| |
| |
| Examine Documents Used in Business Processes | |
| |
| |
| |
| Analyze Collected Information | |
| |
| |
| |
| Entity-Relationship Data Model | |
| |
| |
| |
| Integration Definition for Information Modeling | |
| |
| |
| |
| Entities | |
| |
| |
| |
| Attributes, Identifiers, and Domains | |
| |
| |
| |
| Relationships | |
| |
| |
| |
| Database Physical Design | |
| |
| |
| |
| Database System Architecture | |
| |
| |
| |
| Windows Azure Data Storage Overview | |
| |
| |
| |
| Windows Azure SQL Database | |
| |
| |
| |
| Windows Azure Storage | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| |
| Table Normalization and Windows Azure SQL Database | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Overview of Relational Database | |
| |
| |
| |
| Functional Dependency | |
| |
| |
| |
| Keys | |
| |
| |
| |
| Linking Tables | |
| |
| |
| |
| Normalization | |
| |
| |
| |
| Why Table Normalization? | |
| |
| |
| |
| Normal Forms | |
| |
| |
| |
| Denormalization | |
| |
| |
| |
| Transferring Data Model to Relational Database | |
| |
| |
| |
| Representing Entities | |
| |
| |
| |
| Representing Relationships | |
| |
| |
| |
| Enforcing Constraints | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| |
| Database Development and Management with SQL | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Structured Query Language | |
| |
| |
| |
| Creating Database Objects | |
| |
| |
| |
| Defining Data Types | |
| |
| |
| |
| Constraints | |
| |
| |
| |
| Creating Database | |
| |
| |
| |
| Creating Tables | |
| |
| |
| |
| Managing Database Objects | |
| |
| |
| |
| Viewing Table Structures | |
| |
| |
| |
| Modifying Table Structures | |
| |
| |
| |
| Controlling Database Object Privileges | |
| |
| |
| |
| Manipulating Data in Tables | |
| |
| |
| |
| Inserting Data | |
| |
| |
| |
| Modifying Data | |
| |
| |
| |
| Querying Data | |
| |
| |
| |
| Deleting Data | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| |
| Importing and Exporting Database Objects | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| SQL Server Management Studio | |
| |
| |
| |
| Data-Tier Application | |
| |
| |
| |
| Windows Azure SQL Database Migration Wizard | |
| |
| |
| |
| Moving Data in and out of Windows Azure SQL Database Using SSIS | |
| |
| |
| |
| Import and Export Data with Bulk Copy Program | |
| |
| |
| |
| Working with XML Data | |
| |
| |
| |
| Introduction to Extensible Markup Language | |
| |
| |
| |
| XML Data Type | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| |
| Querying Information in Windows Azure SQL Database | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Retrieving Data from Tables with SQL | |
| |
| |
| |
| Querying Data with SELECT, FROM, and WHERE Statements | |
| |
| |
| |
| Logical Operators | |
| |
| |
| |
| Comparison Operators | |
| |
| |
| |
| Arithmetic Operators | |
| |
| |
| |
| Subqueries | |
| |
| |
| |
| Joining Multiple Tables with SQL | |
| |
| |
| |
| Inner Join | |
| |
| |
| |
| Outer Join | |
| |
| |
| |
| Multiple Joins | |
| |
| |
| |
| Self-Join | |
| |
| |
| |
| SQL Built-in Functions | |
| |
| |
| |
| Aggregate Functions | |
| |
| |
| |
| Scalar Functions | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| |
| Windows Azure SQL Database Procedures and Functions | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| SQL Programming Extensions | |
| |
| |
| |
| Variables | |
| |
| |
| |
| Flow-Control Structures | |
| |
| |
| |
| Procedures and Functions | |
| |
| |
| |
| Functions | |
| |
| |
| |
| Scalar Functions | |
| |
| |
| |
| Table Functions | |
| |
| |
| |
| APPLY Operator | |
| |
| |
| |
| Procedures | |
| |
| |
| |
| Creating and Executing Stored Procedures | |
| |
| |
| |
| Modifying and Deleting Stored Procedures | |
| |
| |
| |
| Triggers | |
| |
| |
| |
| Creating, Modifying, and Deleting Triggers | |
| |
| |
| |
| Using Triggers | |
| |
| |
| |
| Validating Business Constraints | |
| |
| |
| |
| Implementing Dynamic Application Logic | |
| |
| |
| |
| Keeping Database Integrity | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| |
| Windows Azure SQL Database Views, Indexes, and Federations | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Views | |
| |
| |
| |
| Create Views | |
| |
| |
| |
| Modify Views | |
| |
| |
| |
| Modify Data in a View | |
| |
| |
| |
| Drop Views | |
| |
| |
| |
| Indexes | |
| |
| |
| |
| Create Indexes | |
| |
| |
| |
| Manage Indexes | |
| |
| |
| |
| Remove Indexes | |
| |
| |
| |
| Federations | |
| |
| |
| |
| Federation Design | |
| |
| |
| |
| Generating Federation Key | |
| |
| |
| |
| Database Operations across Multiple Federation Members | |
| |
| |
| |
| Data Distribution across Multiple Federation Members | |
| |
| |
| |
| Applications and Federation Logic | |
| |
| |
| |
| Federation Implementation with T-SQL | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| |
| Database Application Development | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Database Application Design | |
| |
| |
| |
| Application Design | |
| |
| |
| |
| GUI Design | |
| |
| |
| |
| Database Application Development | |
| |
| |
| |
| Form Development | |
| |
| |
| |
| Report Development | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| |
| Windows Azure and Deployment of Applications to the Cloud | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Windows Azure | |
| |
| |
| |
| Windows Azure Structure | |
| |
| |
| |
| Windows Azure Management Portal | |
| |
| |
| |
| Windows Azure SDK | |
| |
| |
| |
| Windows Azure Compute Emulator | |
| |
| |
| |
| Windows Azure Storage Emulator | |
| |
| |
| |
| Application Development with Windows Azure SDK | |
| |
| |
| |
| Windows Azure Application Design | |
| |
| |
| |
| Windows Azure Application Development | |
| |
| |
| |
| Developing Applications on Local Computers | |
| |
| |
| |
| Role Definition and Configuration | |
| |
| |
| |
| Authentication | |
| |
| |
| |
| Windows Azure Application Deployment | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| |
| Windows Azure Storage | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Windows Azure Storage Services | |
| |
| |
| |
| Use of Table Storage | |
| |
| |
| |
| Use of Blob Storage | |
| |
| |
| |
| Use of Queue Storage | |
| |
| |
| |
| Deploy Applications to Windows Azure | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| |
| Windows Azure Management | |
| |
| |
| Objectives | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Windows Azure SQL Database Security | |
| |
| |
| |
| Managing Windows Azure SQL Database | |
| |
| |
| |
| Managing Windows Azure | |
| |
| |
| |
| Monitoring Windows Azure | |
| |
| |
| |
| Summary | |
| |
| |
| Review Questions | |
| |
| |
| Bibliography | |
| |
| |
| Index | |