Prepare for the Azure Data Fundamentals Certification and pass!
✏️ Course developed by Andrew Brown of ExamPro. Check out the ExamPro YouTube channel: https://www.youtube.com/ExamProChannel
🔗 ExamPro Cloud Obsessed Certification Training: https://www.exampro.co
☁️ Data Concepts
🎤 (0:10:12) Auzre Core Data Related Services
🎤 (0:14:55) Types of Cloud Computing
🎤 (0:16:56) Azure Data Related Roles
🎤 (0:18:42) Database Administrator Common tools
🎤 (0:20:27) Data Engineering Common tools
🎤 (0:21:43) Data Analyst Common tools
🎤 (0:22:26) Data Overview
🎤 (0:23:43) Introduction to Data
🎤 (0:24:32) Data documents
🎤 (0:25:30) Data sets
🎤 (0:28:31) Data types
🎤 (0:32:15) Schema vs Schemaless
🎤 (0:34:09) Query and Querying
🎤 (0:35:54) Batch vs Stream processing
🎤 (0:38:30) Relational data
🎤 (0:40:35) Relational data Relationships
🎤 (0:42:07) Row store vs Column store
🎤 (0:43:44) Database Index
🎤 (0:45:05) Data Integegrity vs Data Corruption
🎤 (0:47:11) Normalized vs Denomralized data
🎤 (0:48:32) Pivot table
🎤 (0:50:10) Strongly consistent vs Eventually consistent
🎤 (0:51:33) Synchronus vs Asynchronous
🎤 (0:53:29) Non relational data
🎤 (0:54:29) Data source
🎤 (0:55:41) Data store
🎤 (0:56:32) Database
🎤 (0:57:56) Data warehouse
🎤 (0:59:39) Data mart
🎤 (1:00:36) Data lakes
🎤 (1:01:42) Data lakehouse
🎤 (1:03:12) Data structures
🎤 (1:04:02) Unstructured data
🎤 (1:04:47) Semi structured
🎤 (1:06:10) Semi structured Data Structures
🎤 (1:07:16) Semi structure JSON
🎤 (1:08:11) semi structure ORC
🎤 (1:09:39) semi structure Parquets
🎤 (1:10:35) semi structure AVRO
🎤 (1:11:25) Structured Data
🎤 (1:11:56) Data mining
🎤 (1:13:02) Data mining methods
🎤 (1:14:28) Data wrangling
🎤 (1:15:31) Ddata modeling
🎤 (1:17:18) ETL vs ELT
🎤 (1:19:18) Data analytics
🎤 (1:20:14) Key performance indicators KPI
🎤 (1:21:23) Data Analytic Techniques
🎤 (1:23:02) Microsoft One Drive
🎤 (1:24:20) Microsoft Sharepoint
🎤 (1:25:49) Data Core Concepts CheatSheet
☁️ Azure Synapse and Data Lake
🎤 (1:33:36) Azure Synapse Analytics
🎤 (1:35:26) Sypanse SQL and pools
🎤 (1:37:19) Synapse Key Features
🎤 (1:38:31) Azure Data Lake Gen 2
🎤 (1:40:03) Polybase
🎤 (1:40:50) Synapse ELT
🎤 (1:41:51) Azure Data Lake Analytics
🎤 (1:43:05) Azure Sypanse and Data Lakes CheatSheet
☁️ Account Storage
🎤 (1:44:25) Azure Blob Storage
🎤 (1:45:20) Azure Files
🎤 (1:47:14) Azure Storage Accounts CheatSheet
☁️ Power BI
🎤 (1:48:07) Business Intelligence
🎤 (1:48:40) Power BI
🎤 (1:51:29) Power BI Visualizations
🎤 (1:53:13) Power BI Embedded
🎤 (1:54:02) Power BI Interactive Reports
🎤 (1:55:36) Power BI Service and Dashboards
🎤 (1:56:47) Reports vs Dashboards
🎤 (1:57:47) Paginated Reports
🎤 (1:58:57) Power BI CheatSheet
☁️ Relational Databases
🎤 (2:00:38) Structured Query Language
🎤 (2:01:48) OLAP vs OLAP
🎤 (2:03:14) Open Source Relational Databases
🎤 (2:06:01) Read Replicas
🎤 (2:07:10) Citus Postgres Hyperscale
🎤 (2:08:03) Azure SQL Family
🎤 (2:10:30) Elastic pools
🎤 (2:11:45) Relational Databases CheatSheet
☁️ T SQL
🎤 (2:14:12) T SQL
🎤 (2:15:40) Data Defintion Language
🎤 (2:16:43) Data Manipulation Language
🎤 (2:18:02) Data Query Language
🎤 (2:19:08) Data Control Language
🎤 (2:19:36) Transaction Control Langauge
🎤 (2:20:22) SQL Document Comparsions
🎤 (2:21:10) T SQL CheatSheet
☁️ Database Security
🎤 (2:22:01) Connectivity Architecture
🎤 (2:23:13) Database Authentication
🎤 (2:24:41) Network Connectivity
🎤 (2:25:19) Azure Defender for SQL
🎤 (2:25:54) Azure Database Server Firewalls
🎤 (2:27:00) Always Encrypted
🎤 (2:27:47) Role Based Access Controls
🎤 (2:28:48) Transparent Data Encryption
🎤 (2:29:49) Dynamic Data Masking
🎤 (2:31:02) Private Links
🎤 (2:31:57) Database Security Cheatsheet
☁️ Azure Tables Cosmos DB
🎤 (2:34:13) Key Value Store
🎤 (2:35:40) Document Store
🎤 (2:36:33) Mongo DB
🎤 (2:38:35) Graph Database
🎤 (2:39:42) Apache Tinkerpop and Gremlin
🎤 (2:41:23) Azure Tables
🎤 (2:42:45) Azure Cosmos DB
🎤 (2:44:40) Azure Table Account Storage vs Cosmos DB
🎤 (2:46:39) Azure Tables and CosmosDB CheatSheet
☁️ Hadoop Systems
🎤 (2:48:29) Apache Hadoop
🎤 (2:49:57) Apache Kafka
🎤 (2:50:53) HDInsights
🎤 (2:52:05) Hadoop CheatSheet
☁️ Azure and Databricks
🎤 (2:53:21) Apache Spark
🎤 (2:55:04) Azure Databricks
🎤 (2:57:16) Apache Spark and Databricks CheatSheet
☁️ ELT and SQL Tools
🎤 (2:58:46) SQL Server Management Studio
🎤 (2:59:37) SQL Server Data Tools
🎤 (3:00:58) Azure Data Studio
🎤 (3:01:48) Azure Data Factory
🎤 (3:02:59) SQL Server Integration Services
🎤 (3:04:08) ETL and SQL Tools CheatSheet
☁️ Follow Alongs
🎤 (3:05:38) Install and Use Power BI
🎤 (3:08:17) Launch Azure SQL and Use Data Studio
🎤 (3:34:53) Use Azure SQL as data source in Power BI
🎤 (3:44:20) Use SSMS to perform a query on Azure SQL
🎤 (3:47:37) Create Blob and File storage
🎤 (3:57:36) Explore CosmosDB various NoSQL engines
🎤 (4:27:08) Create a ELT job from Azure SQL to Blob Storage
🎤 (4:33:06) Explore Azure Databricks
🎤 (4:39:49) Explore Azure Synapse Analytics
🎤 (4:44:47) Cleanup
source
When will you be doing Power Platform Fundamentals?
2:22:20, it is 1433
I come from tech backgrd but have no cloud experience, managed to pass the exam with a score of 858 by only watching this video and doing practice tests! Passed AZ 900 by only watching your course too. Thank you!
Can you do DP-100?
Just came here to say I used this along with Microsofts Traing Day series and passed the test with 947 this morning.
43:31 Column-store
I think he means OLAP not OLTP.
I can appreciate the instructor and the effort he put in making this course but it is filled with small faults and typos. He should have checked it before uploading.
at 3:10 , you don't have anything for the DP-300 ? Thats the one I was planning on taking after the DP-900
Thank u, passed with 876 never did a preparation exam.
Is following along on your own console to get familiar with all the buttons etc. really required? Are there going to be any questions regarding the follow-alongs, or is that more just to help our understanding of the material?
Thanks your video. I just passed the DP-900 exam with 908.
32:17
I passed my DP-900. Thank you sooooooo much. Your video helped soo much!
Taking the test tomorrow. Watched the whole series – admittedly at mostly 0.75x – looking forward to posting back on success. A whole career of MSSQL, a few years of HDinsights, a couple of hours on Cosmos, and a few years of detached hadoop. I should've been looking into resources like this for a long time, nice refresher.
just cleared the exam with a 908 overall score. this series of lectures, along with the free internet dumps and other related videos have been most helpful. don't know how to thank you enough.
43:30 should be OLAP not OLTP for the Column-store example
A K/V data store is optmised for simple lookups
Passed the AZ 900 certification today with exact score of 700 😉 Just watched this video once & did not take any practice test. Thanks a ton for uploading this video 🙂
01:17:00
Please make a course on DP-203
You have to slow this down to .70 and its still fast lol
Thanks for great content.. pls create AZ 720 Troubleshooting Microsoft Azure Connectivity
Presentation is excellent. However, there are many many many TYPOs and you term or call things wrongly often. Seems you have a great deal of knowledge but consistency with the terms and phrases would add more value.
Hello Andrew, I'm planning to buy your course but it wont allow me to pay using PayPal, I don't want to put my credit card there since I have bad experience putting my card information, I remember using my card from Microsoft Educations and continuedly charge me every month but they did not refund my money.
great video. the cheatsheets were really useful for revision on the day of exam
Thank you!! Really helpful in getting the basics of almost all data concepts
Can anyone tell me an online course which covers all the data concepts in detail like relationships, normalization, denormalization, slowly changing dimensions, schemas, data warehouse, data lake, delta lake, etc
Incredibly useful, thank you!
Immediate 0.75 speed switching of the video, due to the speaking being done here very fast.
Where can i get the study materials?
greattt
Hello Brown,
I have passed DP-900 with help of This Vidio. All Concepts were Clear to Frame Connectivity and understanding How Cocepts work.
Thank you.
Dude, I appreciate all the work, but you’re burping on all cheatsheet parts. Disgusting.
I just passed the test laast night, there are few queeries question and data factory, for the rest ensure you memorize the cheat sheet
and there ya go!
Full video https://youtube.com/shorts/5Vc4nxHMfIk?feature=share
Typo @01:28:17 Data lakes should be Data Lakehouse
dp 203 pls
"Okaaayyyy"!!!
Do you also have the latest version of DP100?.. Looks like since Oct 2021, the content of the exam has been updated.
Over all good course.
But wont recommend for absolute beginners. + I observed a lot of mistakes/ carelessness throughout the video which may confuse us.
Thank you so much bro,I have passed az900 with mark 940 by your video
Full video https://youtube.com/shorts/5Vc4nxHMfIk?feature=share