Microsoft Azure Virtual Training Day data PDF

Preview

Summary

Azure training sessions. Year 2021
For those who missed it....

Description

Microsoft Azure Virtual Training Day: Data Fundamentals Learn the fundamentals of core database concepts in a cloud environment. Build your foundational knowledge of cloud data services in Azure and explore relational and nonrelational data offerings, including provisioning and deploying relational and nonrelational databases. You will also learn about big data and modern data warehouse analytics solutions in Azure. Agenda Part Two Introduction Explore Non-relational Data in Azure (segment 1 of 2) Break-10 minutes Explore Non-relational Data in Azure (segment 2 of 2) Break-10 minutes Explore modern data warehouse analytics in Azure Closing Q&A

Answers Important References 1. https://docs.microsoft.com/en-us/learn/modules/explore-core-data-concepts/1introduction?ns-enrollment-type=LearningPath&ns-enrollment-id=learn.wwl.azure-datafundamentals-explore-core-data-concepts 2. https://docs.microsoft.com/enus/learn/modules/explore-core-data-concepts/2-identify-need-data-solutions 3. https://do cs.microsoft.com/en-us/learn/modules/explore-core-data-concepts/3-identify-typesstorage 4. https://docs.microsoft.com/en-us/learn/modules/explore-core-dataconcepts/4-describe-difference 5. https://docs.microsoft.com/enus/learn/modules/explore-core-data-concepts/5-knowledge-check Additional References... 1. https://www.michael-gramlich.com/what-is-structured-semi-structured-andunstructured-data/ 2. https://www.xplenty.com/blog/data-ingestion-vs-etl/ 3. https://whatis.techtarget.com/definition/data-ingestion 4. https://www.talend.com/res ources/what-is-data-processing/ 5. https://www.bmc.com/blogs/batch-processingstream-processing-real-time/ How I can decide which blob I should use? Any specific usage and purpose of each one? Pls refer to... 1. https://docs.microsoft.com/en-us/learn/modules/explore-non-relationaldata-offerings-azure/2-explore-azure-table-storage?ns-enrollmenttype=LearningPath&ns-enrollment-id=learn.wwl.azure-data-fundamentals-explore-non-

relational-data 2. https://docs.microsoft.com/enus/rest/api/storageservices/Understanding-the-Table-Service-Data-Model 3. https://docs. microsoft.com/en-us/azure/cosmos-db/table-storage-design-guide Important References... 1. https://docs.microsoft.com/en-us/learn/paths/azure-data-fundamentals-explore-nonrelational-data/ 2. https://www.mongodb.com/nosqlexplained 3. https://docs.microsoft.com/en-us/learn/modules/explore-non-relationaldata-offerings-azure/2-explore-azure-table-storage?ns-enrollmenttype=LearningPath&ns-enrollment-id=learn.wwl.azure-data-fundamentals-explore-nonrelational-data 4. https://docs.microsoft.com/en-us/learn/modules/explore-non-relationaldata-offerings-azure/3-explore-azure-blob-storage 5. https://docs.microsoft.com/enus/learn/modules/explore-non-relational-data-offerings-azure/4-explore-azure-filestorage 6. https://docs.microsoft.com/en-us/learn/modules/explore-non-relational-dataofferings-azure/5-explore-azure-cosmos-database 7. https://docs.microsoft.com/enus/learn/modules/explore-non-relational-data-offerings-azure/6-knowledge-check References on File Storages... https://docs.microsoft.com/en-us/azure/storage/files/storage-files-introduction More references on CosmosDB https://docs.microsoft.com/en-us/azure/cosmosdb/introductionhttps://docs.microsoft.com/en-us/azure/cosmos-db/tableintroductionhttps://docs.microsoft.com/en-us/azure/cosmos-db/graphintroductionhttps://docs.microsoft.com/en-us/azure/cosmos-db/mongodbintroductionhttps://docs.microsoft.com/en-us/azure/cosmos-db/cassandraintroductionhttps://docs.microsoft.com/en-us/azure/cosmos-db/indexoverviewhttps://docs.microsoft.com/en-us/azure/cosmos-db/usecaseshttps://docs.microsoft.com/en-us/azure/cosmos-db/consistencylevelshttps://docs.microsoft.com/en-us/azure/cosmos-db/table-storage-design-guide References on CosmosDB APIs 1. https://docs.microsoft.com/en-us/azure/cosmos-db/table-introduction 2. https://docs. microsoft.com/en-us/azure/cosmos-db/graph-introduction 3. https://docs.microsoft.com/ en-us/azure/cosmos-db/mongodb-introduction 4.https://docs.microsoft.com/enus/azure/cosmos-db/cassandra-introduction More references... https://docs.microsoft.com/en-us/azure/storage/files/storage-files-planning More on Provisioning No-SQL services https://docs.microsoft.com/en-us/learn/modules/explore-provision-deploy-non-relationaldata-services-azure/2-describe-provision-non-relational-data-services?ns-enrollmenttype=LearningPath&ns-enrollment-id=learn.wwl.azure-data-fundamentals-explore-nonrelational-data Important References on Provisioning No-SQL... 1. https://docs.microsoft.com/en-us/learn/modules/explore-provision-deploy-nonrelational-data-services-azure/3-provision-azure-cosmos-db?ns-enrollmenttype=LearningPath&ns-enrollment-id=learn.wwl.azure-data-fundamentals-explore-nonrelational-data 2. https://docs.microsoft.com/en-us/learn/modules/explore-provisiondeploy-non-relational-data-services-azure/4-provision-non-relational-data-services?nsenrollment-type=LearningPath&ns-enrollment-id=learn.wwl.azure-data-fundamentalsexplore-non-relational-data 3. https://docs.microsoft.com/en-us/learn/modules/exploreprovision-deploy-non-relational-data-services-azure/5-describe-configure-non-relational-

data-services?ns-enrollment-type=LearningPath&ns-enrollment-id=learn.wwl.azuredata-fundamentals-explore-non-relational-data Important references on Provisioning No-SQL services... https://docs.microsoft.com/en-us/learn/modules/explore-provision-deploy-non-relationaldata-services-azure/6-configure-non-relational-data-services?ns-enrollmenttype=LearningPath&ns-enrollment-id=learn.wwl.azure-data-fundamentals-explore-nonrelational-data Provisioning Cosmos DB... 1. https://docs.microsoft.com/en-us/powershell/module/az.cosmosdb/newazcosmosdbaccount?view=azps-5.7.0 2. https://docs.microsoft.com/enus/cli/azure/cosmosdb?view=azure-cli-latest#az-cosmosdb-create 3. https://docs.micros oft.com/en-us/azure/cosmos-db/manage-with-templates Important References... 1. https://docs.microsoft.com/en-us/learn/modules/explore-non-relational-data-storesazure/2-manage-azure-cosmos-db 2. https://docs.microsoft.com/enus/learn/modules/explore-non-relational-data-stores-azure/3-query-azure-cosmos-db 3. h ttps://docs.microsoft.com/en-us/learn/modules/explore-non-relational-data-storesazure/4-manage-azure-blob-storage 4. https://docs.microsoft.com/enus/learn/modules/explore-non-relational-data-stores-azure/5-manage-azure-file-storage References on Consistencies in CosmosDB https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels References on Querying SQL Database... https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-getting-started Important References... 1. https://docs.microsoft.com/en-us/learn/modules/explore-non-relational-data-storesazure/2-manage-azure-cosmos-db 2. https://docs.microsoft.com/enus/learn/modules/explore-non-relational-data-stores-azure/3-query-azure-cosmos-db 3. h ttps://docs.microsoft.com/en-us/learn/modules/explore-non-relational-data-storesazure/4-manage-azure-blob-storage 4. https://docs.microsoft.com/enus/learn/modules/explore-non-relational-data-stores-azure/5-manage-azure-file-storage References on Data Migration... 1. https://azure.microsoft.com/en-us/features/storage-explorer/ 2. Download CosmosDB Migration tool… https://aka.ms/csdmtool Using Data Migration tool… https://docs.microsoft.com/en-us/azure/cosmos-db/import-data Using Data Factory… https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-cosmosdb Bulk Import using .Net SDK https://docs.microsoft.com/en-us/azure/cosmosdb/tutorial-sql-api-dotnet-bulk-importhttps://docs.microsoft.com/en-us/azure/cosmosdb/create-sql-api-dotnet-v4 References on Powershell/CLI for Storage and CosmosDB... Powershell/cli commands to work with Azure Storage Blob and Azure Storage container https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-clilatest#az-storage-container-createhttps://docs.microsoft.com/enus/powershell/module/az.storage/new-azstoragecontainer?view=azps5.7.0https://docs.microsoft.com/en-us/powershell/module/az.storage/removeazstoragecontainer?view=azps-5.7.0https://docs.microsoft.com/enus/powershell/module/azure.storage/set-azurestorageblobcontent?view=azurermps6.13.0https://docs.microsoft.com/en-us/powershell/module/az.storage/GetAzStorageBlob?view=azps-5.7.0https://docs.microsoft.com/en-

us/powershell/module/az.storage/get-azstorageblobcontent?view=azps5.7.0https://docs.microsoft.com/en-us/powershell/module/az.storage/removeazstorageblob?view=azps-5.7.0https://docs.microsoft.com/en-us/cli/azure/storage/blob? view=azure-cli-latest#az-storage-blob-download Important references... 1. https://docs.microsoft.com/en-us/learn/modules/examine-components-of-moderndata-warehouse/2-describe-warehousing 2. https://docs.microsoft.com/enus/learn/modules/examine-components-of-modern-data-warehouse/3-explore-azuredata-services-warehousing 3. https://docs.microsoft.com/en-us/learn/modules/examinecomponents-of-modern-data-warehouse/4-knowledge-check References on Data Migration using Azure Data Factory... 1. https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-guide? view=sql-server-ver15 2. https://docs.microsoft.com/en-us/azure/data-factory/conceptspipelines-activities 3. https://docs.microsoft.com/en-us/azure/data-factory/quickstartcreate-data-factory-portal References on Azure Databricks 1. https://docs.microsoft.com/azure/azure-databricks/databricks-extract-load-sql-datawarehouse 2. https://docs.microsoft.com/azure/azure-databricks/what-is-azuredatabricks References on Synapse Analytics... https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-datawarehouse-tables-distributehttps://docs.microsoft.com/en-us/azure/synapseanalytics/sql-data-warehouse/design-elt-data-loadinghttps://azure.microsoft.com/enus/blog/azure-sql-data-warehouse-is-now-azure-synapse-analytics/ https://docs.microsoft .com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is Important URLs... 1. https://docs.microsoft.com/en-us/learn/modules/explore-data-storage-processingazure/2-describe-azure 2. https://docs.microsoft.com/en-us/learn/modules/explore-datastorage-processing-azure/3-explore-azure-synapse-analytics 3. https://docs.microsoft.co m/en-us/learn/modules/explore-data-storage-processing-azure/4-knowledge-check References on Azure Data Factory... https://docs.microsoft.com/azure/data-factory/concepts-pipelines-activities Important References on PowerBI... 1. https://docs.microsoft.com/en-us/learn/modules/get-started-with-power-bi/ 2. https://docs.microsoft.com/en-us/learn/modules/get-started-with-power-bi/2-usingpower-bi' target='_blank'>https://docs.microsoft.com/en-us/learn/modules/get-startedwith-power-bi/2-using-power-bi 3. https://docs.microsoft.com/en-us/learn/modules/getstarted-with-power-bi/3-building-blocks-of-power-bi' target='_blank'>https://docs.microsoft.com/en-us/learn/modules/get-started-with-powerbi/3-building-blocks-of-power-bi 4. https://docs.microsoft.com/en-us/learn/modules/getstarted-with-power-bi/4-exercise-touring-and-using-power-bi' target='_blank'>https://docs.microsoft.com/en-us/learn/modules/get-started-with-powerbi/4-exercise-touring-and-using-power-bi

THANK YOU SO MUCH FOR WATCHING.

THESE LINKS WILL BE SHARED IN DESCRIPTION....