Although today’s job market requires IT professionals to understand cloud computing theories and have hands-on skills for developing real-world database systems, there are few books available that integrate coverage of both. Filling this void, Cloud Database Development and Management explains how readers can take advantage of the cloud environment to develop their own fully functioning database systems without any additional investment in IT infrastructure.
Filled with step-by-step instructions, examples, and hands-on projects, the book begins by providing readers with the required foundation in database systems and cloud-based database development tools. It supplies detailed instructions on setting up data storage on Windows Azure and also explains how readers can develop their own virtual machines with Windows Server 2012 as the guest operating system.
The book’s wide-ranging coverage includes database design, database implementation, database deployment to the cloud environment, SQL Database, Table Storage service, Blob Storage service, Queue Storage service, and database application development. The text deals with all three aspects of database design: conceptual design, logical design, and physical design. It introduces the SQL language, explains how to use SQL to create database objects, and introduces the migration of the database between Windows Azure and the on-premises SQL Server. It also discusses the management tasks that keep both SQL Database and Windows Azure running smoothly.
Detailing how to design, implement, and manage database systems in the cloud, the book provides you with tools that can make your cloud database development much more efficient and flexible. Its easy-to-follow instructions will help you develop the hands-on skills needed to store and manage critical business information and to make that data available anytime through the Internet.
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
Overview
Although today’s job market requires IT professionals to understand cloud computing theories and have hands-on skills for developing real-world database systems, there are few books available that integrate coverage of both. Filling this void, Cloud Database Development and Management explains how readers can take advantage of the cloud environment to develop their own fully functioning database systems without any additional investment in IT infrastructure.
Filled with ...