Exam DP203 Course Tybul: Difference between revisions

From MillerSql.com
NeilM (talk | contribs)
NeilM (talk | contribs)
No edit summary
 
(27 intermediate revisions by the same user not shown)
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


== 03 Storage Account Overview ==
== 03 Storage Account Overview ==
https://www.youtube.com/watch?v=ClqZ1j_7NY4
[[Exam_DP203_Course_Tybul_03_Storage_Account_Overview]]


Storage Account Table Service. Configured in portal - storage account.
== 04 Storage Account Redundancy ==
[[Exam_DP203_Course_Tybul_04_Storage_Account_Redundancy]]


Used by NoSQL. Table is schemaless.
== 05 Storage Account Access Tiers ==
[[Exam_DP203_Course_Tybul_05_Storage_Account_Access_Tiers]]


It is disabled by default, and if you try to create a table, it fails with a permissions error.
== 06 Common File Types csv xml json ==
[[Exam_DP203_Course_Tybul_06_Common_file_types_csv_xml_json]]


https://learn.microsoft.com/en-us/azure/storage/tables/assign-azure-role-data-access?tabs=powershell
== 07 Common File Types parquet ==
[[Exam_DP203_Course_Tybul_07_Common_file_types_parquet]]


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.
[[Exam_DP203_file_formats_Parquet]]


Storage Table Data Contributor
== 07 Common File Types delta lake ==
[[Exam_DP203_Course_Tybul_07_Common_file_types_delta_lake]]
 
== 08 Common File Types Data lake structure raw layer ==
[[Exam_DP203_Course_Tybul_08_Data_lake_structure_Raw_layer]]
 
== 09 Common File Types Azure Data Factory ==
[[Exam_DP203_Course_Tybul_09_Azure_Data_Factory]]
 
Note this also contains videos 10 - 14
 
== 15 Questions about new data source ==
[[Exam_DP203_Course_Tybul_15_Questions_about_new_data_source]]
 
== 32 - A closer look at Databricks notebooks ==
 
[[Exam_DP203_Course_Tybul_32_A_closer_look_at_Databricks_notebooks]]
 
== 39 - Azure Synapse Analytics - Spark Pools ==
 
[[Exam_DP203_Course_Tybul_39_Azure_Synapse_Analytics__Spark_Pools]]

Latest revision as of 20:37, 31 December 2024

Piotr Tybul YouTube course on DP 203:

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

03 Storage Account Overview

Exam_DP203_Course_Tybul_03_Storage_Account_Overview

04 Storage Account Redundancy

Exam_DP203_Course_Tybul_04_Storage_Account_Redundancy

05 Storage Account Access Tiers

Exam_DP203_Course_Tybul_05_Storage_Account_Access_Tiers

06 Common File Types csv xml json

Exam_DP203_Course_Tybul_06_Common_file_types_csv_xml_json

07 Common File Types parquet

Exam_DP203_Course_Tybul_07_Common_file_types_parquet

Exam_DP203_file_formats_Parquet

07 Common File Types delta lake

Exam_DP203_Course_Tybul_07_Common_file_types_delta_lake

08 Common File Types Data lake structure raw layer

Exam_DP203_Course_Tybul_08_Data_lake_structure_Raw_layer

09 Common File Types Azure Data Factory

Exam_DP203_Course_Tybul_09_Azure_Data_Factory

Note this also contains videos 10 - 14

15 Questions about new data source

Exam_DP203_Course_Tybul_15_Questions_about_new_data_source

32 - A closer look at Databricks notebooks

Exam_DP203_Course_Tybul_32_A_closer_look_at_Databricks_notebooks

39 - Azure Synapse Analytics - Spark Pools

Exam_DP203_Course_Tybul_39_Azure_Synapse_Analytics__Spark_Pools