DP-900 Azure Data Fundamentals hands on course with sims
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!
Requirements
- Willingness to put in the time and practice the steps shown in the course
Description
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 Trainer
Lecture that explains the concepts in an easy to learn method for someone that is just starting out with this material
Instructor led hands on and simulations to practice that can be followed even if you have little to no experience
TOPICS COVERED INCLUDING HANDS ON LECTURE AND PRACTICE TUTORIALS:
Introduction
Welcome to the course
Understanding the Microsoft Environment
Having a Solid Foundation of Active Directory Domains
Having a Solid Foundation of RAS, DMZ, and Virtualization
Having a Solid Foundation of the Microsoft Cloud Services
Order of concepts covered in the course
Setting up for hands on
IMPORTANT Using Assignments in the course
Creating a free Azure Account
Activating Entra ID P2 license
Describe ways to represent data
Features of structured data
Features of semi-structured
Features of unstructured data
Identify options for data storage
Understanding formats for data files
Relational databases as a type of data storage
Creating a relational database in Azure using Microsoft SQL
Installing SQL Server Management Studio (SSMS) for connecting to SQL
Connecting to a SQL database with SSMS
Non-relational databases as a type of data storage
Creating a non-relational database in Azure using Microsoft Cosmos
Connecting to a Microsoft Cosmos database
Describe common data workloads
Features of transactional workloads
Features of analytical workloads
Identify roles and responsibilities for data workloads
Responsibilities for database administrators
Permissions in Azure regarding a database administrator
Responsibilities for data engineers
Permissions in Azure regarding a data engineers
Responsibilities for data analysts
Permissions regarding a data analysts
Describe relational concepts
Features of relational data
Normalization and why it is used
Creating an Azure VM with Microsoft SQL server
Using common structured query language (SQL) statements
A look at common database objects
Describe relational Azure data services
Azure SQL Family: Azure SQL Database, SQL Managed Instance, SQL Server on VMs
Azure database services for open-source database systems
Describe capabilities of Azure storage
Understanding the capabilities of Azure storage accounts
Creating a storage account to explore Blob, File, & Table storage capabilities
Securing a Azure storage account
Utilizing Azure Blob storage
Utilizing Azure File storage
Utilizing Azure Table storage
Describe capabilities and features of Azure Cosmos DB
Use cases for Azure Cosmos DB
Understanding the Azure Cosmos DB APIs
Deleting the existing Cosmos DB before moving on
Creating a new Cosmos DB account for NoSQL
Adding and querying data within a Cosmos DB for NoSQL
Cleaning up our lab environment to this point
Describe common elements of large-scale analytics
Considerations for data ingestion and processing
Understanding Azure Data Lake storage
Creating an Azure Data Lake storage account
Understanding Azure Databricks
Visualizing Azure Synapse Analytics
Registering Azure Synapse as a resource provider in Azure
Setting up a SQL DB and server for use with Azure Synapse Analytics
Creating a Azure Synapse workspace and Data Lake Storage account
Concepts of SQL Pool usage with Azure Synapse Analytics
Purposes of Azure HDInsight
Understanding Azure Data Factory
Setting up an Azure Data Factory resources
Using Azure Data Factory to copy data into Azure Synapse Analytics <AZ-305>
Describe consideration for real-time data analytics
Understanding the difference between batch and streaming data
Concepts of Azure Stream Analytics
Creating an Azure Stream Analytics job for real-time analytics
Benefits of using Apache Spark
Cleaning up the existing resources before moving on
Describe data visualization in Microsoft Power BI
Capabilities of Power BI
Downloading and installing Power BI Desktop
Creating a database with data for testing Power B
Connecting Power BI to a SQL database and performing an import
Features of data models in Power BI
Using the appropriate visualizations for data
Who this course is for:
- IT people interested in learning and passing the Microsoft DP-900 exam!
Instructor
John Christopher is a Technical Instructor that has been in the business for 25 years. His first experience with information technology occurred in the early 90s when he ran an MS-DOS based BBS(Bulletin Board System) as a System Operator. In the late 90s, after working with Windows NT 3.50 performing backups for Regal Group, he decided to get Windows NT Microsoft Certified.
In 1998 he got his first Microsoft Certified Systems Engineer and Microsoft Certified Trainer certification. Shortly after getting certified, he began working as a Junior Administrator and Instructor for Knowledge Alliance. From there John was able to become one of the first people in the world to gain an MCSE for the Windows 2000 operating system and he began teaching full time for a company called Productivity Point International. At Productivity Point, John got Citrix Metaframe certified and began teaching Citrix along with Microsoft classes. Productivity Point began experiencing financial troubles and John moved on to work with another training company in 2001
For many years at the training company in Atlanta John was the network administrator and held the title of Senior Technical Instructor for the company. John designed and administered their network from the ground up, going from a single floor in a single building, to multiple floors in multiple buildings and locations. He furthered his certifications, gaining the MCSE for 2003, 2008(MCITP), 2012, A+, Network+, Security+, Exchange, and CCNA. Along with his Network admin duties, John taught hundreds of students during his 11 years for the company. During all his years of training, John has had the honor of doing lots of classes with the military, along with quite a few classes within on-site military bases. In 2012, he decided to break away from the company he had been working for and do consulting and contract teaching. Currently, John gets hired by many different training companies to teach technical training classes all over the United States. He is also hired as a consultant to go into companies and work on their networks and implement, along with troubleshoot real world scenarios.