Home›Azure in 5 Days›Day 3
Day 3 of 5
⏱ ~60 minutes
Azure in 5 Days — Day 3

Storage: Blobs and Azure SQL

Create storage accounts, upload files to Blob Storage, generate SAS tokens, and provision an Azure SQL database.

Azure Blob Storage

Create Storage Account
az storage account create \
  --name mystorageacc123 \
  --resource-group myapp-rg \
  --location eastus \
  --sku Standard_LRS

# Create a container
az storage container create \
  --name uploads \
  --account-name mystorageacc123 \
  --public-access blob
Upload Files
# Get connection string
az storage account show-connection-string \
  --name mystorageacc123 --resource-group myapp-rg

# Upload a file
az storage blob upload \
  --container-name uploads \
  --file ./photo.jpg \
  --name photo.jpg \
  --connection-string 'DefaultEndpointsProtocol=...'
SAS Token (Python SDK)
from azure.storage.blob import BlobServiceClient, generate_blob_sas, BlobSasPermissions
from datetime import datetime, timedelta

sas_token = generate_blob_sas(
    account_name='mystorageacc123',
    container_name='uploads',
    blob_name='photo.jpg',
    account_key='...',
    permission=BlobSasPermissions(read=True),
    expiry=datetime.utcnow() + timedelta(hours=1)
)
url = f'https://mystorageacc123.blob.core.windows.net/uploads/photo.jpg?{sas_token}'
Azure SQL Database
az sql server create \
  --name my-sql-server --resource-group myapp-rg \
  --location eastus --admin-user sqladmin --admin-password MyPass@123

az sql db create \
  --resource-group myapp-rg --server my-sql-server \
  --name myapp-db --service-objective Basic
📝 Day 3 Exercise
Work with Azure Storage
  1. C
  2. r
  3. e
  4. a
  5. t
  6. e
  8. a
  10. s
  11. t
  12. o
  13. r
  14. a
  15. g
  16. e
  18. a
  19. c
  20. c
  21. o
  22. u
  23. n
  24. t
  26. a
  27. n
  28. d
  30. c
  31. o
  32. n
  33. t
  34. a
  35. i
  36. n
  37. e
  38. r
  39. .
  41. U
  42. p
  43. l
  44. o
  45. a
  46. d
  48. 3
  50. f
  51. i
  52. l
  53. e
  54. s
  56. v
  57. i
  58. a
  60. C
  61. L
  62. I
  63. .
  65. G
  66. e
  67. n
  68. e
  69. r
  70. a
  71. t
  72. e
  74. a
  76. S
  77. A
  78. S
  80. t
  81. o
  82. k
  83. e
  84. n
  86. a
  87. n
  88. d
  90. v
  91. e
  92. r
  93. i
  94. f
  95. y
  97. i
  98. t
  100. g
  101. r
  102. a
  103. n
  104. t
  105. s
  107. t
  108. i
  109. m
  110. e
  111. -
  112. l
  113. i
  114. m
  115. i
  116. t
  117. e
  118. d
  120. a
  121. c
  122. c
  123. e
  124. s
  125. s
  126. .
  128. C
  129. r
  130. e
  131. a
  132. t
  133. e
  135. a
  136. n
  138. A
  139. z
  140. u
  141. r
  142. e
  144. S
  145. Q
  146. L
  148. d
  149. a
  150. t
  151. a
  152. b
  153. a
  154. s
  155. e
  157. a
  158. n
  159. d
  161. c
  162. o
  163. n
  164. n
  165. e
  166. c
  167. t
  169. t
  170. o
  172. i
  173. t
  174. .

Day 3 Summary

  • Azure Blob Storage = object storage for files. Three access tiers: Hot, Cool, Archive.
  • SAS tokens grant temporary, scoped access to storage resources without sharing keys.
  • Azure SQL is managed SQL Server. Basic tier is the cheapest for dev (~$5/month).
  • Always configure a firewall rule on Azure SQL to allow your IP: az sql server firewall-rule create.
→
← Previous
Day 2: Virtual Machines
Next →
Day 4: Azure App Service
→
Finished this lesson?