https://docs.microsoft.com/en-us/azure/
- https://github.com/anjijava16/Azure-Certification-DP-200
- https://www.udemy.com/course/microsoft-azure-database-and-analytics/
- https://github.com/MicrosoftLearning/AZ-900T0x-MicrosoftAzureFundamentals/tree/master/Instructions/Walkthroughs
Azure Cosmos DB supports many APIs, such as SQL, MongoDB, Cassandra, Gremlin, and Table. Each API has its own set of database operations. These operations range from simple point reads and writes to complex queries. Each database operation consumes system resources based on the complexity of the operation. https://github.com/cmaneu/Awesome-Azure-Advanced-Analytics#azure-cosmos-db https://azurecosmosdb.github.io/labs/ https://github.com/abhirockzz/cosmosdb-synapse-workshop
Hyperspace http://aka.ms/hellohyperspace
https://github.com/microsoft/hyperspace
An open source indexing subsystem that brings index-based query acceleration to Apache Spark™ and big data workloads.
-
https://github.com/MicrosoftLearning/DP-201-Designing-an-Azure-Data-Solution
- https://docs.microsoft.com/en-us/learn/modules/pillars-of-a-great-azure-architecture/
- Big data architectures (imp): Understand why, when and differences
- https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/
- https://www.blue-granite.com/blog/a-different-way-to-process-data-kappa-architecture
- https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing
- https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing
- https://docs.microsoft.com/en-us/azure/cosmos-db/lambda-architecture
- https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/data/enterprise-bi-sqldw
- https://azure.microsoft.com/en-in/blog/technical-reference-implementation-for-enterprise-bi-and-reporting/
#. Lambda architectures for a Real-Time Mode Perspective
#. Architect a stream processing pipeline with Azure Stream Analytics
- https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-solution-patterns
- https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/data/stream-processing-stream-analytics
- https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/stream-processing
#. Design a stream processing pipeline with Azure Databricks
#. Security Design Considerations
#. Designing distributed tables in Azure SQL Data Warehouse
- https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-distribute
- https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-best-practices
#. Horizontal, vertical, and functional data partitioning
- https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning #. Azure Cosmos DB: Designing your data structure
- https://social.technet.microsoft.com/wiki/contents/articles/39421.azure-cosmos-db-designing-your-data-structure.aspx #. Azure Example Scenarios
- https://docs.microsoft.com/en-us/azure/architecture/example-scenario/#data-scenarios #. Datasize organizing in one folder
- https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-performance-tuning-guidance
- https://azure.microsoft.com/en-in/blog/azure-cosmos-db-pushing-the-frontier-of-globally-distributed-databases/
- https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-temporary
#. Transparent data encryption or always encrypted
- https://azure.microsoft.com/en-in/blog/transparent-data-encryption-or-always-encrypted/ #. SQL database auditing
- https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing
- https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine?view=sql-server-2017
#. Azure SQL Database security capabilities
- https://docs.microsoft.com/en-us/azure/sql-database/sql-database-security-overview #. Data Compression
- https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-memory-optimizations-for-columnstore-compression
- https://blogs.msdn.microsoft.com/sqldw/2016/05/05/the-effects-of-column-level-compression/
#. Storage :
- https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-comparison
- https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview
#. Introduction to Data Lake Storage & Create an Azure Data Lake Storage Gen2
- https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-introduction
- https://www.blue-granite.com/blog/10-things-to-know-about-azure-data-lake-storage-gen2 (Good Article)
- Enabling Team Based Data Science with Azure Databricks
- https://www.blue-granite.com/blog/3-reasons-to-choose-azure-databricks-for-data-science-and-big-data-workloads
- https://www.slideshare.net/databricks/building-an-enterprise-data-platform-with-azure-databricks-to-enable-machine-learning-and-data-science-at-scale-at-sams-club
- https://docs.azuredatabricks.net/getting-started/concepts.html
- ETL: https://docs.microsoft.com/en-us/azure/azure-databricks/databricks-extract-load-sql-data-warehouse Globally Distributed Database with Azure Cosmos DB,Create an Azure Cosmos DB database built to scale ,Insert and query data in your Azure Cosmos DB database:
- https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels
- https://docs.microsoft.com/en-us/azure/cosmos-db/whitepapers
- https://docs.microsoft.com/en-us/azure/cosmos-db/databases-containers-items
- https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-multi-master
- https://docs.microsoft.com/en-us/azure/cosmos-db/global-dist-under-the-hood
- https://azure.microsoft.com/en-in/blog/a-technical-overview-of-azure-cosmos-db/ (must read)
- https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning (Do read)
- https://docs.microsoft.com/en-in/azure/sql-database/ (Read only concept section on left hand side)
- https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-partition
- https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-best-practices
- https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-overview
- https://docs.microsoft.com/en-us/azure/sql-data-warehouse/massively-parallel-processing-mpp-architecture (Do read)
- https://azure.microsoft.com/en-in/resources/videos/loading-data-with-polybase-in-azure-sql-data-warehouse/
- https://docs.microsoft.com/en-us/azure/sql-data-warehouse/load-data-wideworldimportersdw
- https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-stream-analytics-query-patterns#query-example-send-data-to-multiple-outputs (one query multiple output possible go through it)
- https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-outputs
- https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-streaming-unit-consumption
- https://azure.microsoft.com/is-is/blog/maximize-throughput-with-repartitioning-in-azure-stream-analytics/
- https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-parallelization (must read)
- https://docs.microsoft.com/en-us/azure/stream-analytics/streaming-technologies (read all concepts from left hand side)
- https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-inputs#stream-data-from-event-hubs