Exam DP203 Course Tybul: Difference between revisions

From MillerSql.com
NeilM (talk | contribs)
NeilM (talk | contribs)
Line 1: Line 1:
Piotr Tybul YouTube course on DP 203:
'''Piotr Tybul''' YouTube course on DP 203:


https://www.youtube.com/playlist?list=PLuQSde7Xvu7DCRenR1otgxAplTtnzKO9e
https://www.youtube.com/playlist?list=PLuQSde7Xvu7DCRenR1otgxAplTtnzKO9e
Line 6: Line 6:
https://www.youtube.com/watch?v=ClqZ1j_7NY4
https://www.youtube.com/watch?v=ClqZ1j_7NY4


Storage Account Table Service. Configured in portal - storage account.
Storage Account Table Service.  
 
Configured in portal - storage account.


Used by NoSQL. Table is schemaless.
Used by NoSQL. Table is schemaless.
Line 17: Line 19:


Storage Table Data Contributor
Storage Table Data Contributor
Edit: I have created a new account (Sandbox).
In a Storage account, you can click on '''Data Storage - Tables'''. or '''Storage Browser - Tables'''
Click Add Entity to add a new row to the table. Define columns and datatypes on the fly - it is schemaless so these can be changed.

Revision as of 19:50, 22 November 2024

Piotr Tybul YouTube course on DP 203:

https://www.youtube.com/playlist?list=PLuQSde7Xvu7DCRenR1otgxAplTtnzKO9e

03 Storage Account Overview

https://www.youtube.com/watch?v=ClqZ1j_7NY4

Storage Account Table Service.

Configured in portal - storage account.

Used by NoSQL. Table is schemaless.

It is disabled by default, and if you try to create a table, it fails with a permissions error.

https://learn.microsoft.com/en-us/azure/storage/tables/assign-azure-role-data-access?tabs=powershell

says: When you create an Azure Storage account, you are not automatically assigned permissions to access data via Microsoft Entra ID. You must explicitly assign yourself an Azure role for Azure Storage. You can assign it at the level of your subscription, resource group, storage account, or table.

Storage Table Data Contributor

Edit: I have created a new account (Sandbox).

In a Storage account, you can click on Data Storage - Tables. or Storage Browser - Tables

Click Add Entity to add a new row to the table. Define columns and datatypes on the fly - it is schemaless so these can be changed.