Overview

We really hope you'll agree, this training is way more than the average course on Udemy! Have access to the following:Training from an instructor of over 25 years who has trained thousands of people and also a Microsoft Certified TrainerLecture that explains the concepts in an easy to learn method for someone that is just starting out with this materialInstructor led hands on and simulations to practice that can be followed even if you have little to no experienceTOPICS COVERED INCLUDING HANDS ON LECTURE AND PRACTICE TUTORIALS:IntroductionWelcome to the courseUnderstanding the Microsoft EnvironmentHaving a Solid Foundation of Active Directory DomainsHaving a Solid Foundation of RAS, DMZ, and VirtualizationHaving a Solid Foundation of the Microsoft Cloud ServicesOrder of concepts covered in the courseSetting up for hands onIMPORTANT Using Assignments in the courseCreating a free Azure AccountActivating Entra ID P2 licenseDescribe ways to represent dataFeatures of structured dataFeatures of semi-structuredFeatures of unstructured dataIdentify options for data storageUnderstanding formats for data filesRelational databases as a type of data storageCreating a relational database in Azure using Microsoft SQLInstalling SQL Server Management Studio (SSMS) for connecting to SQLConnecting to a SQL database with SSMSNon-relational databases as a type of data storageCreating a non-relational database in Azure using Microsoft CosmosConnecting to a Microsoft Cosmos databaseDescribe common data workloadsFeatures of transactional workloadsFeatures of analytical workloadsIdentify roles and responsibilities for data workloadsResponsibilities for database administratorsPermissions in Azure regarding a database administratorResponsibilities for data engineersPermissions in Azure regarding a data engineersResponsibilities for data analystsPermissions regarding a data analystsDescribe relational conceptsFeatures of relational dataNormalization and why it is usedCreating an Azure VM with Microsoft SQL serverUsing common structured query language (SQL) statementsA look at common database objectsDescribe relational Azure data servicesAzure SQL Family: Azure SQL Database, SQL Managed Instance, SQL Server on VMsAzure database services for open-source database systemsDescribe capabilities of Azure storageUnderstanding the capabilities of Azure storage accountsCreating a storage account to explore Blob, File, & Table storage capabilitiesSecuring a Azure storage accountUtilizing Azure Blob storageUtilizing Azure File storageUtilizing Azure Table storageDescribe capabilities and features of Azure Cosmos DBUse cases for Azure Cosmos DBUnderstanding the Azure Cosmos DB APIsDeleting the existing Cosmos DB before moving onCreating a new Cosmos DB account for NoSQLAdding and querying data within a Cosmos DB for NoSQLCleaning up our lab environment to this pointDescribe common elements of large-scale analyticsConsiderations for data ingestion and processingUnderstanding Azure Data Lake storageCreating an Azure Data Lake storage accountUnderstanding Azure DatabricksVisualizing Azure Synapse AnalyticsRegistering Azure Synapse as a resource provider in AzureSetting up a SQL DB and server for use with Azure Synapse AnalyticsCreating a Azure Synapse workspace and Data Lake Storage accountConcepts of SQL Pool usage with Azure Synapse AnalyticsPurposes of Azure HDInsightUnderstanding Azure Data FactorySetting up an Azure Data Factory resourcesUsing Azure Data Factory to copy data into Azure Synapse Analytics Describe consideration for real-time data analyticsUnderstanding the difference between batch and streaming dataConcepts of Azure Stream AnalyticsCreating an Azure Stream Analytics job for real-time analyticsBenefits of using Apache SparkCleaning up the existing resources before moving onDescribe data visualization in Microsoft Power BICapabilities of Power BIDownloading and installing Power BI DesktopCreating a database with data for testing Power BConnecting Power BI to a SQL database and performing an importFeatures of data models in Power BIUsing the appropriate visualizations for data

Skills

Reviews