Cloud Database Development and Management

Book description

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.

Table of contents

  1. Front Cover (1/2)
  2. Front Cover (2/2)
  3. Contents (1/2)
  4. Contents (2/2)
  5. Preface (1/2)
  6. Preface (2/2)
  7. Acknowledgments
  8. Author
  9. Chapter 1 - Introduction to Database Systems and Cloud Computing (1/6)
  10. Chapter 1 - Introduction to Database Systems and Cloud Computing (2/6)
  11. Chapter 1 - Introduction to Database Systems and Cloud Computing (3/6)
  12. Chapter 1 - Introduction to Database Systems and Cloud Computing (4/6)
  13. Chapter 1 - Introduction to Database Systems and Cloud Computing (5/6)
  14. Chapter 1 - Introduction to Database Systems and Cloud Computing (6/6)
  15. Chapter 2 - Database Design and Windows Azure Data Storage (1/8)
  16. Chapter 2 - Database Design and Windows Azure Data Storage (2/8)
  17. Chapter 2 - Database Design and Windows Azure Data Storage (3/8)
  18. Chapter 2 - Database Design and Windows Azure Data Storage (4/8)
  19. Chapter 2 - Database Design and Windows Azure Data Storage (5/8)
  20. Chapter 2 - Database Design and Windows Azure Data Storage (6/8)
  21. Chapter 2 - Database Design and Windows Azure Data Storage (7/8)
  22. Chapter 2 - Database Design and Windows Azure Data Storage (8/8)
  23. Chapter 3 - Table Normalization and Windows Azure SQL Database (1/9)
  24. Chapter 3 - Table Normalization and Windows Azure SQL Database (2/9)
  25. Chapter 3 - Table Normalization and Windows Azure SQL Database (3/9)
  26. Chapter 3 - Table Normalization and Windows Azure SQL Database (4/9)
  27. Chapter 3 - Table Normalization and Windows Azure SQL Database (5/9)
  28. Chapter 3 - Table Normalization and Windows Azure SQL Database (6/9)
  29. Chapter 3 - Table Normalization and Windows Azure SQL Database (7/9)
  30. Chapter 3 - Table Normalization and Windows Azure SQL Database (8/9)
  31. Chapter 3 - Table Normalization and Windows Azure SQL Database (9/9)
  32. Chapter 4 - Database Development and Management with SQL (1/10)
  33. Chapter 4 - Database Development and Management with SQL (2/10)
  34. Chapter 4 - Database Development and Management with SQL (3/10)
  35. Chapter 4 - Database Development and Management with SQL (4/10)
  36. Chapter 4 - Database Development and Management with SQL (5/10)
  37. Chapter 4 - Database Development and Management with SQL (6/10)
  38. Chapter 4 - Database Development and Management with SQL (7/10)
  39. Chapter 4 - Database Development and Management with SQL (8/10)
  40. Chapter 4 - Database Development and Management with SQL (9/10)
  41. Chapter 4 - Database Development and Management with SQL (10/10)
  42. Chapter 5 - Importing and Exporting Database Objects (1/8)
  43. Chapter 5 - Importing and Exporting Database Objects (2/8)
  44. Chapter 5 - Importing and Exporting Database Objects (3/8)
  45. Chapter 5 - Importing and Exporting Database Objects (4/8)
  46. Chapter 5 - Importing and Exporting Database Objects (5/8)
  47. Chapter 5 - Importing and Exporting Database Objects (6/8)
  48. Chapter 5 - Importing and Exporting Database Objects (7/8)
  49. Chapter 5 - Importing and Exporting Database Objects (8/8)
  50. Chapter 6 - Querying Information in Windows Azure SQL Database (1/8)
  51. Chapter 6 - Querying Information in Windows Azure SQL Database (2/8)
  52. Chapter 6 - Querying Information in Windows Azure SQL Database (3/8)
  53. Chapter 6 - Querying Information in Windows Azure SQL Database (4/8)
  54. Chapter 6 - Querying Information in Windows Azure SQL Database (5/8)
  55. Chapter 6 - Querying Information in Windows Azure SQL Database (6/8)
  56. Chapter 6 - Querying Information in Windows Azure SQL Database (7/8)
  57. Chapter 6 - Querying Information in Windows Azure SQL Database (8/8)
  58. Chapter 7 - Windows Azure SQL Database Procedures and Functions (1/6)
  59. Chapter 7 - Windows Azure SQL Database Procedures and Functions (2/6)
  60. Chapter 7 - Windows Azure SQL Database Procedures and Functions (3/6)
  61. Chapter 7 - Windows Azure SQL Database Procedures and Functions (4/6)
  62. Chapter 7 - Windows Azure SQL Database Procedures and Functions (5/6)
  63. Chapter 7 - Windows Azure SQL Database Procedures and Functions (6/6)
  64. Chapter 8 - Windows Azure SQL Database Views, Indexes, and Federations (1/8)
  65. Chapter 8 - Windows Azure SQL Database Views, Indexes, and Federations (2/8)
  66. Chapter 8 - Windows Azure SQL Database Views, Indexes, and Federations (3/8)
  67. Chapter 8 - Windows Azure SQL Database Views, Indexes, and Federations (4/8)
  68. Chapter 8 - Windows Azure SQL Database Views, Indexes, and Federations (5/8)
  69. Chapter 8 - Windows Azure SQL Database Views, Indexes, and Federations (6/8)
  70. Chapter 8 - Windows Azure SQL Database Views, Indexes, and Federations (7/8)
  71. Chapter 8 - Windows Azure SQL Database Views, Indexes, and Federations (8/8)
  72. Chapter 9 - Database Application Development (1/7)
  73. Chapter 9 - Database Application Development (2/7)
  74. Chapter 9 - Database Application Development (3/7)
  75. Chapter 9 - Database Application Development (4/7)
  76. Chapter 9 - Database Application Development (5/7)
  77. Chapter 9 - Database Application Development (6/7)
  78. Chapter 9 - Database Application Development (7/7)
  79. Chapter 10 - Windows Azure and Deployment of Applications to the Cloud (1/8)
  80. Chapter 10 - Windows Azure and Deployment of Applications to the Cloud (2/8)
  81. Chapter 10 - Windows Azure and Deployment of Applications to the Cloud (3/8)
  82. Chapter 10 - Windows Azure and Deployment of Applications to the Cloud (4/8)
  83. Chapter 10 - Windows Azure and Deployment of Applications to the Cloud (5/8)
  84. Chapter 10 - Windows Azure and Deployment of Applications to the Cloud (6/8)
  85. Chapter 10 - Windows Azure and Deployment of Applications to the Cloud (7/8)
  86. Chapter 10 - Windows Azure and Deployment of Applications to the Cloud (8/8)
  87. Chapter 11 - Windows Azure Storage (1/10)
  88. Chapter 11 - Windows Azure Storage (2/10)
  89. Chapter 11 - Windows Azure Storage (3/10)
  90. Chapter 11 - Windows Azure Storage (4/10)
  91. Chapter 11 - Windows Azure Storage (5/10)
  92. Chapter 11 - Windows Azure Storage (6/10)
  93. Chapter 11 - Windows Azure Storage (7/10)
  94. Chapter 11 - Windows Azure Storage (8/10)
  95. Chapter 11 - Windows Azure Storage (9/10)
  96. Chapter 11 - Windows Azure Storage (10/10)
  97. Chapter 12 - Windows Azure Management (1/7)
  98. Chapter 12 - Windows Azure Management (2/7)
  99. Chapter 12 - Windows Azure Management (3/7)
  100. Chapter 12 - Windows Azure Management (4/7)
  101. Chapter 12 - Windows Azure Management (5/7)
  102. Chapter 12 - Windows Azure Management (6/7)
  103. Chapter 12 - Windows Azure Management (7/7)
  104. Bibliography
  105. Back Cover

Product information

  • Title: Cloud Database Development and Management
  • Author(s): Lee Chao
  • Release date: July 2013
  • Publisher(s): Auerbach Publications
  • ISBN: 9781466565067