Course Outline
1. Azure for the Data Engineer for Government
- Explain the evolving landscape of data management and analysis
- Survey the services available in the Azure Data Platform for government use
- Identify the key tasks performed by a Data Engineer in a public sector context
- Describe real-world use cases for cloud solutions through case studies relevant to government agencies
- Determine the appropriate Azure Data Platform Services for specific government needs
- Identify and outline the responsibilities of a Data Engineer within government projects
- Finalize data engineering deliverables that meet public sector standards and requirements
2. Working with Data Storage in Government Environments
- Select an appropriate data storage approach in Azure for government use cases
- Create an Azure Storage Account tailored to government data needs
- Explain the features of Azure Data Lake storage for secure and scalable data management in government
- Upload data into Azure Data Lake, ensuring compliance with government regulations
- Lab: Working with Data Storage for Government
- Select a data storage approach in Azure that aligns with public sector requirements
- Create a Storage Account configured for government use
- Explain the capabilities of Data Lake Storage in a government context
- Upload data into Data Lake Store, ensuring it meets government security standards
3. Enabling Team-Based Data Science with Azure Databricks for Government
- Explain the capabilities of Azure Databricks in a government setting
- Demonstrate how to work with Azure Databricks for government data projects
- Read and process data using Azure Databricks, ensuring compliance with public sector regulations
- Perform data transformations with Azure Databricks to meet government data analysis needs
- Lab: Enabling Team-Based Data Science with Azure Databricks for Government
- Explain the use of Azure Databricks in a government context
- Demonstrate how to work with Azure Databricks for public sector projects
- Read and process data using Azure Databricks, adhering to government standards
- Perform data transformations with Azure Databricks to support government initiatives
4. Building Globally Distributed Databases with Cosmos DB for Government
- Create an Azure Cosmos DB database designed to scale for government applications
- Insert and query data in your Azure Cosmos DB database, ensuring it meets public sector requirements
- Build a .NET Core application for Cosmos DB using Visual Studio Code, tailored to government needs
- Distribute your data globally with Azure Cosmos DB, maintaining compliance with government regulations
- Lab: Building Globally Distributed Databases with Cosmos DB for Government
- Create an Azure Cosmos DB database configured for government use
- Insert and query data in Azure Cosmos DB, ensuring it meets public sector standards
- Build a .NET Core application for Azure Cosmos DB using Visual Studio Code, tailored to government projects
- Distribute data globally with Azure Cosmos DB while adhering to government security guidelines
5. Working with Relational Data Stores in the Cloud for Government
- Use Azure SQL Database for government data management
- Describe the capabilities of Azure SQL Data Warehouse for public sector use
- Create and query an Azure SQL Data Warehouse, ensuring it meets government standards
- Use PolyBase to load data into Azure SQL Data Warehouse, adhering to government regulations
- Lab: Working with Relational Data Stores in the Cloud for Government
- Use Azure SQL Database for government applications
- Describe the features of Azure SQL Data Warehouse for public sector projects
- Create and query an Azure SQL Data Warehouse, ensuring it meets government requirements
- Use PolyBase to load data into Azure SQL Data Warehouse, maintaining compliance with government standards
6. Performing Real-Time Analytics with Stream Analytics for Government
- Explain the concepts of data streams and event processing in a government context
- Perform data ingestion using Event Hubs, ensuring it meets public sector standards
- Process data with Stream Analytics Jobs to support real-time government analytics
- Lab: Performing Real-Time Analytics with Stream Analytics for Government
- Explain the concepts of data streams and event processing in a government setting
- Perform data ingestion using Event Hubs, adhering to public sector regulations
- Process data with Stream Analytics Jobs to support real-time analytics for government initiatives
7. Orchestrating Data Movement with Azure Data Factory for Government
- Explain the functionality of Azure Data Factory in a government context
- Identify the key components of Azure Data Factory relevant to public sector data management
- Demonstrate how Azure Data Factory can integrate with Databricks for government projects
- Lab: Orchestrating Data Movement with Azure Data Factory for Government
- Explain the operation of Azure Data Factory in a government setting
- Identify and describe the key components of Azure Data Factory for public sector use
- Demonstrate how Azure Data Factory can integrate with Databricks to support government data initiatives
8. Securing Azure Data Platforms for Government
- Provide an overview of security considerations in a government context
- Identify key security components essential for protecting government data
- Secure Storage Accounts and Data Lake Storage to meet public sector standards
- Protect data stores from unauthorized access and breaches, ensuring compliance with government regulations
- Secure streaming data to maintain the integrity and confidentiality of government information
- Lab: Securing Azure Data Platforms for Government
- Provide an introduction to security in a government context
- Identify key security components necessary for protecting government data
- Secure Storage Accounts and Data Lake Storage to meet public sector requirements
- Protect data stores from unauthorized access, ensuring compliance with government regulations
- Secure streaming data to maintain the integrity and confidentiality of government information
9. Monitoring and Troubleshooting Data Storage and Processing for Government
- Explain the monitoring capabilities available in Azure for government use
- Troubleshoot common issues related to data storage, ensuring they meet public sector standards
- Troubleshoot common issues related to data processing, maintaining compliance with government regulations
- Manage disaster recovery strategies to ensure continuity of government operations
- Lab: Monitoring and Troubleshooting Data Storage and Processing for Government
- Explain the monitoring capabilities available in Azure for government use
- Troubleshoot common issues related to data storage, ensuring they meet public sector standards
- Troubleshoot common issues related to data processing, maintaining compliance with government regulations
- Manage disaster recovery strategies to ensure continuity of government operations
Requirements
- Experience with basic data analysis (e.g., Excel)
- A general understanding of cloud concepts (e.g., AWS)
Audience
- Database engineers for government
- Developers for government
Testimonials (3)
Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.
Ian - Archeoworks Inc.
Course - ArcGIS Fundamentals
All the topics which he covered including examples. And also explained how they are helpful in our daily job.
madduri madduri - Boskalis Singapore Pte Ltd
Course - QGIS for Geographic Information System
The thing I liked the most about the training was the organization and the location