About This Course
<p><span>We really hope you'll agree, this training is way more than the average course on Udemy!</span></p><p><span>Have access to the following:</span></p><ul><li><p>Training from an instructor of over 25 years who has trained thousands of people and also a Microsoft Certified Trainer</p></li><li><p>Lecture that explains the concepts in an easy to learn method for someone that is just starting out with this material</p></li><li><p>Instructor led hands on and simulations to practice that can be followed even if you have little to no experience</p></li></ul><p><span>TOPICS COVERED INCLUDING HANDS ON LECTURE AND PRACTICE TUTORIALS:</span></p><p>Introduction</p><ul><li><p>Welcome to the course</p></li><li><p>Understanding the Microsoft Environment</p></li><li><p>Having a Solid Foundation of Active Directory Domains</p></li><li><p>Having a Solid Foundation of RAS, DMZ, and Virtualization</p></li><li><p>Having a Solid Foundation of the Microsoft Cloud Services</p></li><li><p>Order of concepts covered in the course</p></li></ul><p><span>Setting up for hands on</span></p><ul><li><p>IMPORTANT Using Assignments in the course</p></li><li><p>Creating a free Azure Account</p></li><li><p>Activating Entra ID P2 license</p></li></ul><p><span>Describe ways to represent data</span></p><ul><li><p>Features of structured data</p></li><li><p>Features of semi-structured</p></li><li><p>Features of unstructured data</p></li></ul><p><span>Identify options for data storage</span></p><ul><li><p>Understanding formats for data files</p></li><li><p>Relational databases as a type of data storage</p></li><li><p>Creating a relational database in Azure using Microsoft SQL</p></li><li><p>Installing SQL Server Management Studio (SSMS) for connecting to SQL</p></li><li><p>Connecting to a SQL database with SSMS</p></li><li><p>Non-relational databases as a type of data storage</p></li><li><p>Creating a non-relational database in Azure using Microsoft Cosmos</p></li><li><p>Connecting to a Microsoft Cosmos database</p></li></ul><p><span>Describe common data workloads</span></p><ul><li><p>Features of transactional workloads</p></li><li><p>Features of analytical workloads</p></li></ul><p><span>Identify roles and responsibilities for data workloads</span></p><ul><li><p>Responsibilities for database administrators</p></li><li><p>Permissions in Azure regarding a database administrator</p></li><li><p>Responsibilities for data engineers</p></li><li><p>Permissions in Azure regarding a data engineers</p></li><li><p>Responsibilities for data analysts</p></li><li><p>Permissions regarding a data analysts</p></li></ul><p><span>Describe relational concepts</span></p><ul><li><p>Features of relational data</p></li><li><p>Normalization and why it is used</p></li><li><p>Creating an Azure VM with Microsoft SQL server</p></li><li><p>Using common structured query language (SQL) statements</p></li><li><p>A look at common database objects</p></li></ul><p><span>Describe relational Azure data services</span></p><ul><li><p>Azure SQL Family: Azure SQL Database, SQL Managed Instance, SQL Server on VMs</p></li><li><p>Azure database services for open-source database systems</p></li></ul><p><span>Describe capabilities of Azure storage</span></p><ul><li><p>Understanding the capabilities of Azure storage accounts</p></li><li><p>Creating a storage account to explore Blob, File, & Table storage capabilities</p></li><li><p>Securing a Azure storage account</p></li><li><p>Utilizing Azure Blob storage</p></li><li><p>Utilizing Azure File storage</p></li><li><p>Utilizing Azure Table storage</p></li></ul><p><span>Describe capabilities and features of Azure Cosmos DB</span></p><ul><li><p>Use cases for Azure Cosmos DB</p></li><li><p>Understanding the Azure Cosmos DB APIs</p></li><li><p>Deleting the existing Cosmos DB before moving on</p></li><li><p>Creating a new Cosmos DB account for NoSQL</p></li><li><p>Adding and querying data within a Cosmos DB for NoSQL</p></li><li><p>Cleaning up our lab environment to this point</p></li></ul><p><span>Describe common elements of large-scale analytics</span></p><ul><li><p>Considerations for data ingestion and processing</p></li><li><p>Understanding Azure Data Lake storage</p></li><li><p>Creating an Azure Data Lake storage account</p></li><li><p>Understanding Azure Databricks</p></li><li><p>Visualizing Azure Synapse Analytics</p></li><li><p>Registering Azure Synapse as a resource provider in Azure</p></li><li><p>Setting up a SQL DB and server for use with Azure Synapse Analytics</p></li><li><p>Creating a Azure Synapse workspace and Data Lake Storage account</p></li><li><p>Concepts of SQL Pool usage with Azure Synapse Analytics</p></li><li><p>Purposes of Azure HDInsight</p></li><li><p>Understanding Azure Data Factory</p></li><li><p>Setting up an Azure Data Factory resources</p></li><li><p>Using Azure Data Factory to copy data into Azure Synapse Analytics <AZ-305></p></li></ul><p><span>Describe consideration for real-time data analytics</span></p><ul><li><p>Understanding the difference between batch and streaming data</p></li><li><p>Concepts of Azure Stream Analytics</p></li><li><p>Creating an Azure Stream Analytics job for real-time analytics</p></li><li><p>Benefits of using Apache Spark</p></li><li><p>Cleaning up the existing resources before moving on</p></li></ul><p><span>Describe data visualization in Microsoft Power BI</span></p><ul><li><p>Capabilities of Power BI</p></li><li><p>Downloading and installing Power BI Desktop</p></li><li><p>Creating a database with data for testing Power B</p></li><li><p>Connecting Power BI to a SQL database and performing an import</p></li><li><p>Features of data models in Power BI</p></li><li><p>Using the appropriate visualizations for data</p></li></ul>
What you'll learn:
- Learn the concepts and perform hands on activities needed to pass the DP-900 exam
- Gain a tremendous amount of knowledge involving data processing in Microsoft Azure
- Get loads of hands on experience with Microsoft Azure data processing technologies!
- Utilize hands on simulations that can be access anytime, anywhere!