Cloud database development and management
Nowadays, cloud computing is almost everywhere. However, one can hardly find a textbook that utilizes cloud computing for teaching database and application development. This cloud-based database development book that teaches both the theory and hands-on practice with step-by-step instructions and ex...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Boca Raton :
Taylor & Francis
2014.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628557106719 |
Tabla de Contenidos:
- 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
