Damn, this guy! I passed the exam with an 866 score, I am in absolute aww I prepared for 4-5 hours I am done. Thank you once again for the free content.
For anyone taking this test, I would encourage that you study Azure Data API's very well. I took the test today and was not prepared for the number of questions regarding that topic. Still passed, but wish I would have been a bit more prepared.
For those still interested: I did the exam and I can safely assume he/she means the Cosmos API's and when to use them as there were quite some basic questions around it
Is going through this video, cheatsheets & the training module alone is good enough, or any additional impetus on certain area or any additional training, if you think is needed. Thank You
This is waaaay more than what you actually need to learn for the test. You need half of these or less but it's still a very good and comprehensive content if you're interested in these concepts.
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!
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.
1:00:34 - Data lake 1:01:42 - Data lakehouse 1:03:09 - Data Structures 1:04:01 - Unstructured Data 1:04:45 - Semi Structured Data 1:11:21 - Structured Data 1:11:53 - Data Mining 1:12:57 - Data Mining methods 1:14:24 - Data Wrangling
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.
Thank you for the great session. Was able to pass the exam in my first attempt ( 775/900) after watching this video, going through the learning path & attending the virtual training event by Microsoft.
Thank you Andrew, I have passed the certification yesterday and got 816/1000 points. There were 6 questions on ACID topics in the exam for me, friends look into ACID topics that will weigh in few more points to you guys. Goodluck everyone.
Thank you so much for your great works. You did a fantastic job. You covered almost everything in a nutshell for the Azure world. You are helping us way way more than we are helping you. Thanks again
I wonder if this guy even knows what he's talking about. Every second slides has some mistake in it and he's just reading off of them. Or he made the whole course the night before it was due, it seems like he is also rushing when speaking.
I took the webinar a couple weeks ago so qualify for the test, but the info wasn’t clear on how long the webinar was, so I missed some. So grateful to find this!
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.
i'm starting to study from this guide after having read through the microsoft learning path, hope that this will explain it much better. my exam is next week
Watched this video, took notes while watching and followed along, just passed the test! Another cert down! Even though I ran out of time and only made it to the 4 hour mark of the video.
Thanks for your expertise and effort of putting this together. I really enjoyed your content! Still a lot to learn. Looking forward for your other DP related trainings :)
@@aravindrajkumark9927 This video is good for revision due to the cheatsheets present here, Also go through the microsoft learn also and complete all the modules.
Thank you so much for this video very helpful and valuable!! I'm all over your website lol please do Exam DP-300 if it's possible. awesome content bro thanks again
🎯 Key Takeaways for quick navigation: 01:37 🌐 *Introduction to DP-900 Certification* 03:27 📚 *Pathways to DP-900 Certification* 04:55 💡 *Preparing for DP-900 Exam* 06:05 📘 *Exam Guide Overview* 09:56 📊 *Detailed Exam Topics* 13:27 📦 *Azure Data Services Overview* 15:47 ⚙️ *Cloud Computing Models for Data Services* 17:09 👥 *Azure Data Roles Overview* 18:48 🧰 *Common Tools for Database Administrator* 20:27 🛠️ *Azure Data Services Overview* *- Azure Data Studio (for Mac or Linux)* *- SQL Server Management Studio (SSMS, for Windows)* *- Azure Portal and CLI for database configuration* *- Azure Resource Manager templates for infrastructure as code.* 21:39 🧰 *Data Engineering Tools* *- Various SQL languages, including T-SQL and U-SQL.* *- Additional tools like HDInsights, Azure Databricks for ETL, streaming, and working with data lakes.* 22:21 📊 *Common Tools for Data Analysts* *- Power BI Desktop for data visualization and modeling.* *- Power BI Service (Portal) for creating interactive dashboards.* *- Power BI Report Builder for building paginated reports.* 23:46 📚 *Data Fundamentals Overview* *- Understanding data as units of information.* *- Categories like data documents, datasets, data types.* *- Concepts of batch and streaming processing.* 24:29 📖 *Understanding Data* *- Data encompasses various forms, including numbers, text, images, videos, audio, or even physical forms.* *- Examples illustrating data types: binary code, books, audio spectrum, mathematical formulas.* 25:11 🗂 *Data Documents* *- Definition and types like datasets, databases, data stores, data warehouses, and notebooks.* *- Examples include MNIST and COCO datasets, highlighting structured and semi-structured data.* 26:08 📋 *Data Sets* *- Logical grouping of related data units with examples like MNIST and COCO datasets.* *- Publicly available datasets for learning statistics, analytics, and machine learning.* 28:41 🧮 *Data Types* *- Numeric data types (integer, float), text data types (characters, strings).* *- Composite data types (arrays, dictionaries) and binary data types.* 32:24 📐 *Schema vs. Schema-less* *- Schema as a formal language describing data structure in databases.* *- Schema-less offers flexibility, allowing more dynamic data without upfront modeling.* 34:14 ❓ *Querying Data* *- Query as a request for data or performing operations like insert, update, delete.* *- Data results, querying, query language (SQL, GraphQL, XQuery), and their importance.* 36:01 🔄 *Batch vs. Stream Processing* *- Batch processing involves scheduled processing of data collections.* *- Stream processing is real-time, processing data as it arrives.* 38:34 📊 *Relational Data* *- Tables, views, materialized views, indexes, constraints, triggers, and primary keys.* *- Explanation of primary keys as unique identifiers for rows in a table.* 40:09 🗃️ *Relational Database Relationships* 42:18 📊 *Row Store vs. Column Store* 43:58 📈 *Database Indexes* 45:18 🔄 *Data Integrity vs. Data Corruption* 47:15 🔄 *Normalized vs. Denormalized Data* 48:41 🔄 *Pivot Tables in Data Processing* 50:18 ⚖️ *Data Consistency: Strongly vs. Eventually Consistent* 51:41 🔄 *Synchronous vs. Asynchronous Data Transformation* 53:34 🗄️ *Non-Relational Data Stores* 54:42 🔄 *Data Sources and Connections* 55:53 🗃️ *Data Store Overview* 58:00 📊 *Data Warehouse* 01:00:48 🌊 *Data Lake* 01:01:02 📊 *Data Lakes Overview* 01:01:45 🏡 *Data Lake House Characteristics* 01:03:09 🧱 *Introduction to Data Structures* 01:04:03 🗂️ *Azure Services for Unstructured Data* 01:04:59 🧩 *Semi-Structured Data and Formats* 01:07:20 🌐 *JSON - Lightweight Data Interchange* 01:08:17 🚀 *Apache ORC Files - Optimized Row Columnar Format* 01:10:35 🏹 *Apache Avro - Compact, Fast Binary Format* 01:11:34 📊 *Structured Data Overview* 01:12:57 🛠️ *Data Mining Phases* 01:13:54 🔍 *Data Mining Methods* 01:14:49 🔗 *Data Wrangling Process* 01:15:33 🎨 *Data Modeling Overview* 01:17:25 🔄 *ETL vs. ELT* 01:19:16 📈 *Data Analytics Workflow* 01:20:14 🎯 *Key Performance Indicators (KPIs)* 01:20:57 🤔 *Data Analytics vs. Data Mining* 01:21:09 📊 *Descriptive, Diagnostic, Predictive, Prescriptive, Cognitive Analytics* 01:23:03 🏡 *Microsoft OneDrive Overview* 01:24:41 🏢 *Microsoft 365 SharePoint Features* 01:25:52 🧱 *Data Core Concepts: Data Types, Structures, and Roles* 01:27:59 📚 *Data Stores, Data Warehouses, Data Marts* 01:29:54 🧠 *Data Modeling, Integrity, Corruption, Normalization* 01:31:46 🔗 *Data Mining, Data Wrangling, Query, Data Source* 01:33:11 📊 *Data Analytics Types and Key Performance Indicators* 01:34:50 🏠 *Azure Synapse Analytics Overview* 01:35:32 🗃️ *Synapse SQL: Distributed T-SQL, Serverless, Dedicated Pools* 01:37:23 🔍 *Apache Spark, Data Lake Integration with Azure Synapse* 01:38:33 🌊 *Data Lake Overview, Azure Data Lake Storage Gen 2* 01:40:12 🔄 *PolyBase: Data Virtualization in SQL Server* 01:40:26 🔄 *ETL in Azure Synapse Analytics* 01:40:52 🔄 *Azure Synapse Analytics ETL Process* 01:41:46 📊 *Azure Data Lake Analytics and USQL* 01:43:23 🌐 *Azure Data Lake Storage and Azure Synapse Analytics* 01:44:15 ☁️ *Azure Blob Storage Overview* 01:45:58 📂 *Azure Files Use Cases* 01:47:49 🗃️ *Azure Storage Accounts Overview* 01:48:33 📊 *Business Intelligence Tools* 01:49:59 📊 *Microsoft Power BI Overview* 01:51:35 📈 *Data Visualizations in Power BI* 01:53:30 🛠️ *Power BI Embedded Overview* 01:54:54 🔄 *Power BI Interactive Reports* 01:56:49 📊 *Power BI Service and Dashboards* 02:00:02 📄 *Paginated Reports in Power BI* 02:00:29 📊 *SQL Fundamentals* 02:01:54 🔄 *OLAP vs. OLTP* 02:03:19 🗃️ *Open Source Relational Databases* 02:06:06 🔄 *Read Replicas for Azure Databases* 02:07:19 🌐 *Citus on Azure* 02:08:15 💻 *Azure SQL Family* 02:10:39 🔄 *Azure Elastic Pools* 02:11:51 📄 *Relational Database Cheat Sheet* 02:15:42 📚 *Data Definition Language (DDL)* 02:16:51 🔄 *Data Manipulation Language (DML)* 02:18:15 📖 *Data Query Language (DQL)* 02:19:14 🔐 *Data Control Language (DCL)* 02:19:44 ⚙️ *Transaction Control Language (TCL)* 02:19:58 🔄 *Transaction Concepts in SQL* 02:21:11 📑 *Overview of T-SQL (Transact-SQL)* 02:22:08 🌐 *Connectivity Architecture in Azure SQL Database* 02:23:18 🔐 *MS SQL Database Authentication Modes* 02:24:44 🌐 *Network Connectivity Options in SQL Database* 02:25:26 🛡️ *Azure Defender for SQL* 02:26:09 🚧 *Azure Database Firewall Rules* 02:27:04 🔒 *Always Encrypted in Azure SQL Database* 02:27:49 👤 *Role-Based Access Control for Databases* 02:28:59 🌐 *Transparent Data Encryption (TDE) in Microsoft Databases* 02:29:56 🎭 *Dynamic Data Masking in Azure SQL Servers* 02:31:12 🌐 *Azure Private Links for Secure Connections* 02:31:57 🌐 *Introduction to Database Security for Azure* 02:35:42 📄 *Document Stores for Structured Data* 02:36:38 🍃 *MongoDB: Open Source Document Database* 02:38:42 🌐 *Graph Databases: Modeling Relationships* 02:39:48 🔄 *Azure TinkerPop: Graph Computing Framework* 02:40:02 📊 *Graph Databases Overview* 02:41:24 🗃️ *Azure Tables - Storage for NoSQL Key-Value Data* 02:42:49 🔄 *CosmosDB Overview* 02:44:40 🔄 *Azure Tables vs. CosmosDB Comparison* 02:46:51 📋 *Azure Tables and CosmosDB Cheat Sheet* 02:52:05 📊 *Apache Hadoop and HDInsight Overview* 02:53:15 📋 *Apache Spark and Databricks Cheat Sheet* 02:55:09 🛠️ *SQL Management Studio (SSMS) and Databricks Overview* 02:58:56 📊 *SQL Management Studio (SSMS) Overview* 02:59:38 🛠️ *Azure Server Data Tools (SSDT)* 03:01:03 🌐 *Azure Data Studio Features* 03:01:43 🚀 *Azure Data Factory* 03:02:57 📊 *SQL Server Integration Services (SSIS)* 03:04:23 📊 *ETL and SQL Tools Cheat Sheet* 03:05:47 🖥️ *Installing Power BI* 03:08:28 🌐 *Azure SQL Overview* 03:11:43 🚀 *Provisioning Azure SQL Database* 03:15:08 🔒 *Azure SQL Security Features* 03:18:10 🛠️ *Connecting to Azure SQL* 03:18:37 💻 *Database Setup in Azure Data Studio* 03:23:17 📊 *Installation of Azure Data Studio and Query Execution* 03:25:26 🖥️ *Connecting Power BI to SQL Server* 03:34:54 📈 *Visualization in Power BI Desktop* 03:38:56 🚀 *Publishing to Power BI Service* 03:39:11 📊 *Power BI Overview* 03:44:19 📊 *Power BI Dashboard Creation* 03:47:37 🛠️ *SQL Server Management Studio (SSMS)* 03:57:38 ☁️ *Azure Storage Accounts* 03:57:38 🔄 *Cosmos DB - Core SQL* 03:57:38 🔄 *Cosmos DB - MongoDB* 03:57:38 🔄 *Cosmos DB - Azure Table* 03:57:38 🔄 *Cosmos DB - Gremlin* 04:00:30 🚀 *Overview of Azure Cosmos DB and Quick Start with SQL API* 04:08:50 📊 *Setting Up MongoDB with Cosmos DB* 04:16:34 📑 *Working with Azure Tables in Cosmos DB* 04:18:29 🌀 *Introduction to Gremlin API in Cosmos DB* 04:23:21 📈 *Visualizing Graph Data in Cosmos DB with Gremlin API* 04:23:43 📊 *Azure Cosmos DB and Gremlin Query Language* 04:27:10 🔄 *Data Factory for SQL to Blob Storage Transformation* 04:33:07 🚀 *Introduction to Azure Databricks* 04:39:49 📈 *Azure Synapse Analytics (formerly SQL Data Warehouse)* Made with HARPA AI
Passed the exam today! Thank you for the video it was a big help especially the cheat sheets. Worked through the Microsoft learning paths and this video and that was enough for me to take the test.
Hey, can you please tell me how long did you study for the exam and how much experience you had prevously on the data field ? I want to take the exam but I am not sure
@@rasso87 Hi, I studied for about 10 hours total, including time spent watching this video and working through the microsoft learning modules on this topic. I do have some experience in this field as I work in this field as part of my job. If you join on of the microsoft learning events at the end you can get a voucher that make taking this exam free. If its free no reason not to do it right? Good Luck!
Cleared DP900 certification today!!!! Hey Andrew, thanks for this packed course, i used this course material as revision. Thanks for all the efforts y you have put in!
Thank you, passed the DP-900 exam first time with a score of 857 thanks to your video! I personally thought this exam was much more difficult than the AZ-900. Even though I attended an MS virtual training event and read through all of the relevant learning paths, I still had no idea how to answer a few of the questions and must have had a few lucky guesses.
I failed 666 . I thought this video would be enough but i have to study more . I think I failed because my internet disconnected 3 times and they also warned me to create a case or something. Anyways I will attempt one more time after a month.
Hi I have a exam very soon, could you please guide me and let me know if this tutorial is enough to crack the exam or you have referred some other tutorial as well..
@@aXe-XBT this video covers most of the DP-900 exam part and also give you idea about every service but I felt that this video should have also covered much more on non relational data where in this video it’s not covered in very detailed manner, but coming to practical experience it depends upon the individual, everyone won’t get chance to play with things in Azure except for the people who deal with Azure services within an organisation or the people who purchase it individually.I suggest for non relational data section go with Microsoft docs, except this section other sections are covered very well.
Good introductory video and good for cramming as well. However, there are a good number of spelling/data (😉) mistakes, inaccurate or incorrect written and/or verbal information that can be very confusing at times.
"Exam DP-300: Administering Relational Databases on Microsoft Azure" is my request. I am going for the DP-300 after I pass the DP-900. Thank you Andrew for posting these videos.
Hi Andrew - going through your course, great content. Noticed a few mixups - thought I'd bring it to your attention. In the slide Row Store vs Column Store (43min mark) - you have mentioned that column store is suited for OLTP. Its actually OLAP.
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 :)
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.
At 04:34 the header of slide is wrong. It says 'Where do you take AZ-104 exam', whereas it needs to be DP-900. Through, I agree, the info will be the same (althrough you can't anymore take the exam with PSI from 2023, but this is for all exams).
I previously passed AZ900 purely by watching Andrew's video 2-3 times. Now I would be able to pass DP900 just using this video. This guy is hands-down a top tier instructor. Clear voice and diction like a narrator.
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
@@ChaahaChills hey. I did follow this for a while but there is honestly a lot of information that isn't much pertaining to the exam. You can refer the MS docs the exam cram video by John Savill as a follow up and some short DP900 exam videos on A Guide to Cloud channel. A little too excited the trainer in the last one. But very exhaustive exam content.
i've dp900 exam at 2:45 pm today, I've studied Microsoft learn and watched videos of some other UA-cam channel. This is my last stop hoping I'll make it .
@@josiedavis5531 yes, you can submit whenever you want but you’ll have to appear on the given time. Or reschedule the exam 24 hours prior the exam. PS I just missed by 25 marks. I got 675 and passing marks are 700. I didn’t study hard enough so that’s okay.
@@josiedavis5531 no I didn’t, paper was straight forward pretty easy to moderate i would say. Just don’t waste your time without studying properly like me. You’ll crack it in first try.
Incorrect Information in Azure Connectivity Architecture presentation: @ 02:22:04 Where you showed the port for SQL is 1443 which is wrong. The Correct port is 1433.
Thanks for confirming. I was really confused when the internet mentions 1433 everywhere and my external connectivity to my Azure SQL DB was working on 1433 not 1443.
CheatSheets:
Data Core Concepts: 1:25:44
Azure Sypanse and Data Lakes: 1:43:02
Azure Storage Accounts: 1:47:09
Power BI: 1:58:54
Relational Databases: 2:11:42
T-SQL: 2:21:06
Database Security: 2:31:54
Azure Tables and CosmosDb: 2:46:36
Hadoop: 2:52:02
Apache Spark and Databricks: 2:57:13
ETL and SQL Tools: 3:04:05
Absolutely brilliant review set before testing. Thank you!!
Everything you listed is the core of whats going to be on the exam?
@@9.peanut you are my hero
@k40569 For anyone looking up the cheatSheets, correction at 1:28:09
*Data Lakehouse combines best of Data Warehouse and Data lake
Damn, this guy! I passed the exam with an 866 score, I am in absolute aww I prepared for 4-5 hours I am done. Thank you once again for the free content.
Had u already taken the AZ-900 Azure Fundamentals course before taking the Data course?
For anyone taking this test, I would encourage that you study Azure Data API's very well. I took the test today and was not prepared for the number of questions regarding that topic. Still passed, but wish I would have been a bit more prepared.
Thank you for letting us know!
What do you mean with Azure Data API?
For those still interested: I did the exam and I can safely assume he/she means the Cosmos API's and when to use them as there were quite some basic questions around it
DenCato and Carb thank you both for your help
What was your cloud experience prior? And also how long did you study before taking? Appreciate your comment. Congrats (9 months later) on passing!
i passed the exam and got 833 from watching this course + training module from microsoft.
great video with cheat set ...
thank you so much...
Is going through this video, cheatsheets & the training module alone is good enough, or any additional impetus on certain area or any additional training, if you think is needed.
Thank You
This is waaaay more than what you actually need to learn for the test. You need half of these or less but it's still a very good and comprehensive content if you're interested in these concepts.
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!
Is it recommended to take the AZ-900 before the DP-900?
@@dxminixn If you are Azure beginner then start from AZ-900.
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.
I have a test next month, could you please guide me for the test
@@anjalikumari-ix1fz I have a test next month, could you please guide me for the test
1:00:34 - Data lake
1:01:42 - Data lakehouse
1:03:09 - Data Structures
1:04:01 - Unstructured Data
1:04:45 - Semi Structured Data
1:11:21 - Structured Data
1:11:53 - Data Mining
1:12:57 - Data Mining methods
1:14:24 - Data Wrangling
Andrew you're a super man...need tutorial for DP 203
Please UPDATE (DP-900) Microsoft Azure Data Fundamentals. It's been 3 Years.
I took the DP-900 test end of 9/2024. This class helped and I passed 1st try. Thanks.
Please make a course on DP-203
Thankyou
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.
Awesome course! Just passed the DP-900 exam first time with a score of 866. Thanks to your video! Great content! You rock! God Bless You Andrew!
Is this course enough to prepare for exams?
Thank you Andrew, i completed by DP 900 certification, ever grateful to you
Thank you for the great session. Was able to pass the exam in my first attempt ( 775/900) after watching this video, going through the learning path & attending the virtual training event by Microsoft.
Congrats :)
Congrats
@SpikeTaunt yeap, that's how it usually is for cloud certification exams
Congrats! Wait, you did not have to take an online course to pass?!
@SpikeTaunt Yes it is immediate upon submitting answers
watch till 3:05:00 and I got 895 with few practice in examtopics along with this ..... really helpful !!!
Andrew, i watched your video a couple of times and passed the exam! Thanks for putting this together. There you go..!
Thank you Andrew, I have passed the certification yesterday and got 816/1000 points.
There were 6 questions on ACID topics in the exam for me, friends look into ACID topics that will weigh in few more points to you guys.
Goodluck everyone.
hey Ratnakar did you use any additional course material?
@@Don-Clemtechnology Yes…
how long did you learn to take the certification ?
@@thangnguyen3786 2 weeks
Thank you so much for your great works. You did a fantastic job. You covered almost everything in a nutshell for the Azure world. You are helping us way way more than we are helping you. Thanks again
Thank you so much bro,I have passed az900 with mark 940 by your video
Very Informative and well explained. Please share tutorial for DP-203: Data Engineering on Microsoft Azure.
Thank you Andrew.
Thank you very much! I passed dp-900 recently. Your course was very helpful.
Thanks your video. I just passed the DP-900 exam with 908.
Thanks for this. I just finished taking the dp-900 and I passed :)
THE PORT FOR SQL IS 1433, NOT 1443. JUST FYI. Hope that helps someone.
I wonder if this guy even knows what he's talking about. Every second slides has some mistake in it and he's just reading off of them. Or he made the whole course the night before it was due, it seems like he is also rushing when speaking.
@@crystyxn yeah I agree
@@crystyxn Thats the impression I got too.
I was thinking of watching the Arduino video this morning but in less than 12hrs you have another 4hr+ video tutorial 🔥🔥🔥🔥🔥🔥:0
Where that video plz
@@هبةهبة-ص4م ua-cam.com/video/zJ-LqeX_fLU/v-deo.html
ua-cam.com/play/PLBsBYvyG3LXn9L1V3ET__6rwUCrulsbom.html
Andrew is out here giving the people what they need!
@@ashutoshyadav9637 Thank you so much
Thanks for this amazing content. Since dp 201 202 are being replaced by DP 203. We need a course for that as well.
I took the webinar a couple weeks ago so qualify for the test, but the info wasn’t clear on how long the webinar was, so I missed some. So grateful to find this!
After learn with this course, my score is > 800. Thanks!
Thank you for the video. Just passed the DP-900
Thanks for the tutorial! I hope that the DP-300 Azure Database Administrator Associate course will be launched soon!
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.
So your are also an MSSQL Dev.
Thanks Andrew! I was able to pass in the exam in the first attempt! Great content! You rock!
Hey, I just watched your video about 3 hours prior to me writing this exam.
I 'm glad to say, I have passed 🎉🎉🥂🥂
Just passed! Thank you for a great course.
I attended the Microsoft virtual training days for 2 days and went through this video twice. ive passed with 890 :) .. Thanks , really helped !!
The cheatsheets were really helpful for quick revisions on the day of the exam
Thank you for another brillant Azure certification tutorial Andrew! Your DP-900 will help so many people!
i'm starting to study from this guide after having read through the microsoft learning path, hope that this will explain it much better. my exam is next week
Watched this video, took notes while watching and followed along, just passed the test! Another cert down!
Even though I ran out of time and only made it to the 4 hour mark of the video.
Thanks for your expertise and effort of putting this together. I really enjoyed your content! Still a lot to learn. Looking forward for your other DP related trainings :)
Hi Sir, Gave the DP 900 exam today and cleared as well. I studied through this video for the concepts. Thank you so much
Hi, I am planning to take this exam. Can you help me in understanding some things better related to the certification?
I just passed my exam. Thank you so much for this wonderful video!
Hi.. This course seems one year old. They changed the excam a bit this year. Was there too many differences from this course and the test?
Thank you for this detailed video. I have successfully cleared DP 900 certification
Hi Suraj is this video enough or did you refer to any other document can you please help me I going to take the exam in 3weeks
@@aravindrajkumark9927 This video is good for revision due to the cheatsheets present here, Also go through the microsoft learn also and complete all the modules.
Thank you so much for this video very helpful and valuable!! I'm all over your website lol please do Exam DP-300 if it's possible. awesome content bro thanks again
🎯 Key Takeaways for quick navigation:
01:37 🌐 *Introduction to DP-900 Certification*
03:27 📚 *Pathways to DP-900 Certification*
04:55 💡 *Preparing for DP-900 Exam*
06:05 📘 *Exam Guide Overview*
09:56 📊 *Detailed Exam Topics*
13:27 📦 *Azure Data Services Overview*
15:47 ⚙️ *Cloud Computing Models for Data Services*
17:09 👥 *Azure Data Roles Overview*
18:48 🧰 *Common Tools for Database Administrator*
20:27 🛠️ *Azure Data Services Overview*
*- Azure Data Studio (for Mac or Linux)*
*- SQL Server Management Studio (SSMS, for Windows)*
*- Azure Portal and CLI for database configuration*
*- Azure Resource Manager templates for infrastructure as code.*
21:39 🧰 *Data Engineering Tools*
*- Various SQL languages, including T-SQL and U-SQL.*
*- Additional tools like HDInsights, Azure Databricks for ETL, streaming, and working with data lakes.*
22:21 📊 *Common Tools for Data Analysts*
*- Power BI Desktop for data visualization and modeling.*
*- Power BI Service (Portal) for creating interactive dashboards.*
*- Power BI Report Builder for building paginated reports.*
23:46 📚 *Data Fundamentals Overview*
*- Understanding data as units of information.*
*- Categories like data documents, datasets, data types.*
*- Concepts of batch and streaming processing.*
24:29 📖 *Understanding Data*
*- Data encompasses various forms, including numbers, text, images, videos, audio, or even physical forms.*
*- Examples illustrating data types: binary code, books, audio spectrum, mathematical formulas.*
25:11 🗂 *Data Documents*
*- Definition and types like datasets, databases, data stores, data warehouses, and notebooks.*
*- Examples include MNIST and COCO datasets, highlighting structured and semi-structured data.*
26:08 📋 *Data Sets*
*- Logical grouping of related data units with examples like MNIST and COCO datasets.*
*- Publicly available datasets for learning statistics, analytics, and machine learning.*
28:41 🧮 *Data Types*
*- Numeric data types (integer, float), text data types (characters, strings).*
*- Composite data types (arrays, dictionaries) and binary data types.*
32:24 📐 *Schema vs. Schema-less*
*- Schema as a formal language describing data structure in databases.*
*- Schema-less offers flexibility, allowing more dynamic data without upfront modeling.*
34:14 ❓ *Querying Data*
*- Query as a request for data or performing operations like insert, update, delete.*
*- Data results, querying, query language (SQL, GraphQL, XQuery), and their importance.*
36:01 🔄 *Batch vs. Stream Processing*
*- Batch processing involves scheduled processing of data collections.*
*- Stream processing is real-time, processing data as it arrives.*
38:34 📊 *Relational Data*
*- Tables, views, materialized views, indexes, constraints, triggers, and primary keys.*
*- Explanation of primary keys as unique identifiers for rows in a table.*
40:09 🗃️ *Relational Database Relationships*
42:18 📊 *Row Store vs. Column Store*
43:58 📈 *Database Indexes*
45:18 🔄 *Data Integrity vs. Data Corruption*
47:15 🔄 *Normalized vs. Denormalized Data*
48:41 🔄 *Pivot Tables in Data Processing*
50:18 ⚖️ *Data Consistency: Strongly vs. Eventually Consistent*
51:41 🔄 *Synchronous vs. Asynchronous Data Transformation*
53:34 🗄️ *Non-Relational Data Stores*
54:42 🔄 *Data Sources and Connections*
55:53 🗃️ *Data Store Overview*
58:00 📊 *Data Warehouse*
01:00:48 🌊 *Data Lake*
01:01:02 📊 *Data Lakes Overview*
01:01:45 🏡 *Data Lake House Characteristics*
01:03:09 🧱 *Introduction to Data Structures*
01:04:03 🗂️ *Azure Services for Unstructured Data*
01:04:59 🧩 *Semi-Structured Data and Formats*
01:07:20 🌐 *JSON - Lightweight Data Interchange*
01:08:17 🚀 *Apache ORC Files - Optimized Row Columnar Format*
01:10:35 🏹 *Apache Avro - Compact, Fast Binary Format*
01:11:34 📊 *Structured Data Overview*
01:12:57 🛠️ *Data Mining Phases*
01:13:54 🔍 *Data Mining Methods*
01:14:49 🔗 *Data Wrangling Process*
01:15:33 🎨 *Data Modeling Overview*
01:17:25 🔄 *ETL vs. ELT*
01:19:16 📈 *Data Analytics Workflow*
01:20:14 🎯 *Key Performance Indicators (KPIs)*
01:20:57 🤔 *Data Analytics vs. Data Mining*
01:21:09 📊 *Descriptive, Diagnostic, Predictive, Prescriptive, Cognitive Analytics*
01:23:03 🏡 *Microsoft OneDrive Overview*
01:24:41 🏢 *Microsoft 365 SharePoint Features*
01:25:52 🧱 *Data Core Concepts: Data Types, Structures, and Roles*
01:27:59 📚 *Data Stores, Data Warehouses, Data Marts*
01:29:54 🧠 *Data Modeling, Integrity, Corruption, Normalization*
01:31:46 🔗 *Data Mining, Data Wrangling, Query, Data Source*
01:33:11 📊 *Data Analytics Types and Key Performance Indicators*
01:34:50 🏠 *Azure Synapse Analytics Overview*
01:35:32 🗃️ *Synapse SQL: Distributed T-SQL, Serverless, Dedicated Pools*
01:37:23 🔍 *Apache Spark, Data Lake Integration with Azure Synapse*
01:38:33 🌊 *Data Lake Overview, Azure Data Lake Storage Gen 2*
01:40:12 🔄 *PolyBase: Data Virtualization in SQL Server*
01:40:26 🔄 *ETL in Azure Synapse Analytics*
01:40:52 🔄 *Azure Synapse Analytics ETL Process*
01:41:46 📊 *Azure Data Lake Analytics and USQL*
01:43:23 🌐 *Azure Data Lake Storage and Azure Synapse Analytics*
01:44:15 ☁️ *Azure Blob Storage Overview*
01:45:58 📂 *Azure Files Use Cases*
01:47:49 🗃️ *Azure Storage Accounts Overview*
01:48:33 📊 *Business Intelligence Tools*
01:49:59 📊 *Microsoft Power BI Overview*
01:51:35 📈 *Data Visualizations in Power BI*
01:53:30 🛠️ *Power BI Embedded Overview*
01:54:54 🔄 *Power BI Interactive Reports*
01:56:49 📊 *Power BI Service and Dashboards*
02:00:02 📄 *Paginated Reports in Power BI*
02:00:29 📊 *SQL Fundamentals*
02:01:54 🔄 *OLAP vs. OLTP*
02:03:19 🗃️ *Open Source Relational Databases*
02:06:06 🔄 *Read Replicas for Azure Databases*
02:07:19 🌐 *Citus on Azure*
02:08:15 💻 *Azure SQL Family*
02:10:39 🔄 *Azure Elastic Pools*
02:11:51 📄 *Relational Database Cheat Sheet*
02:15:42 📚 *Data Definition Language (DDL)*
02:16:51 🔄 *Data Manipulation Language (DML)*
02:18:15 📖 *Data Query Language (DQL)*
02:19:14 🔐 *Data Control Language (DCL)*
02:19:44 ⚙️ *Transaction Control Language (TCL)*
02:19:58 🔄 *Transaction Concepts in SQL*
02:21:11 📑 *Overview of T-SQL (Transact-SQL)*
02:22:08 🌐 *Connectivity Architecture in Azure SQL Database*
02:23:18 🔐 *MS SQL Database Authentication Modes*
02:24:44 🌐 *Network Connectivity Options in SQL Database*
02:25:26 🛡️ *Azure Defender for SQL*
02:26:09 🚧 *Azure Database Firewall Rules*
02:27:04 🔒 *Always Encrypted in Azure SQL Database*
02:27:49 👤 *Role-Based Access Control for Databases*
02:28:59 🌐 *Transparent Data Encryption (TDE) in Microsoft Databases*
02:29:56 🎭 *Dynamic Data Masking in Azure SQL Servers*
02:31:12 🌐 *Azure Private Links for Secure Connections*
02:31:57 🌐 *Introduction to Database Security for Azure*
02:35:42 📄 *Document Stores for Structured Data*
02:36:38 🍃 *MongoDB: Open Source Document Database*
02:38:42 🌐 *Graph Databases: Modeling Relationships*
02:39:48 🔄 *Azure TinkerPop: Graph Computing Framework*
02:40:02 📊 *Graph Databases Overview*
02:41:24 🗃️ *Azure Tables - Storage for NoSQL Key-Value Data*
02:42:49 🔄 *CosmosDB Overview*
02:44:40 🔄 *Azure Tables vs. CosmosDB Comparison*
02:46:51 📋 *Azure Tables and CosmosDB Cheat Sheet*
02:52:05 📊 *Apache Hadoop and HDInsight Overview*
02:53:15 📋 *Apache Spark and Databricks Cheat Sheet*
02:55:09 🛠️ *SQL Management Studio (SSMS) and Databricks Overview*
02:58:56 📊 *SQL Management Studio (SSMS) Overview*
02:59:38 🛠️ *Azure Server Data Tools (SSDT)*
03:01:03 🌐 *Azure Data Studio Features*
03:01:43 🚀 *Azure Data Factory*
03:02:57 📊 *SQL Server Integration Services (SSIS)*
03:04:23 📊 *ETL and SQL Tools Cheat Sheet*
03:05:47 🖥️ *Installing Power BI*
03:08:28 🌐 *Azure SQL Overview*
03:11:43 🚀 *Provisioning Azure SQL Database*
03:15:08 🔒 *Azure SQL Security Features*
03:18:10 🛠️ *Connecting to Azure SQL*
03:18:37 💻 *Database Setup in Azure Data Studio*
03:23:17 📊 *Installation of Azure Data Studio and Query Execution*
03:25:26 🖥️ *Connecting Power BI to SQL Server*
03:34:54 📈 *Visualization in Power BI Desktop*
03:38:56 🚀 *Publishing to Power BI Service*
03:39:11 📊 *Power BI Overview*
03:44:19 📊 *Power BI Dashboard Creation*
03:47:37 🛠️ *SQL Server Management Studio (SSMS)*
03:57:38 ☁️ *Azure Storage Accounts*
03:57:38 🔄 *Cosmos DB - Core SQL*
03:57:38 🔄 *Cosmos DB - MongoDB*
03:57:38 🔄 *Cosmos DB - Azure Table*
03:57:38 🔄 *Cosmos DB - Gremlin*
04:00:30 🚀 *Overview of Azure Cosmos DB and Quick Start with SQL API*
04:08:50 📊 *Setting Up MongoDB with Cosmos DB*
04:16:34 📑 *Working with Azure Tables in Cosmos DB*
04:18:29 🌀 *Introduction to Gremlin API in Cosmos DB*
04:23:21 📈 *Visualizing Graph Data in Cosmos DB with Gremlin API*
04:23:43 📊 *Azure Cosmos DB and Gremlin Query Language*
04:27:10 🔄 *Data Factory for SQL to Blob Storage Transformation*
04:33:07 🚀 *Introduction to Azure Databricks*
04:39:49 📈 *Azure Synapse Analytics (formerly SQL Data Warehouse)*
Made with HARPA AI
This comment should be pinned
Andrew Thank you for the resource you have provided I passed 9_21_21. This is my first step to becoming a data scientist. Thank you.
Thank you sir! This video helped me!!! Scored 876!!! Thank you again! Your video was worth it.
Hello Andrew Thanks for the Video I cleared the Exam Today
Passed the exam today! Thank you for the video it was a big help especially the cheat sheets. Worked through the Microsoft learning paths and this video and that was enough for me to take the test.
Hey, can you please tell me how long did you study for the exam and how much experience you had prevously on the data field ? I want to take the exam but I am not sure
@@rasso87 Hi, I studied for about 10 hours total, including time spent watching this video and working through the microsoft learning modules on this topic. I do have some experience in this field as I work in this field as part of my job. If you join on of the microsoft learning events at the end you can get a voucher that make taking this exam free. If its free no reason not to do it right? Good Luck!
Cleared DP900 certification today!!!!
Hey Andrew, thanks for this packed course, i used this course material as revision.
Thanks for all the efforts y you have put in!
Thank you ! This was very useful for me to pass my DP-900 exam
Thank you, passed the DP-900 exam first time with a score of 857 thanks to your video!
I personally thought this exam was much more difficult than the AZ-900. Even though I attended an MS virtual training event and read through all of the relevant learning paths, I still had no idea how to answer a few of the questions and must have had a few lucky guesses.
Is AZ - 900 Mandatory or Helpful while attempting for DP - 900?
@@arjun_esna it is helpful but not mandatory.
How to take the mentioned tests?? Help me.
@@arjun_esna AZ-900 is for beginners, tech sales people, and executives for companies that use Azure.
I failed 666 . I thought this video would be enough but i have to study more . I think I failed because my internet disconnected 3 times and they also warned me to create a case or something. Anyways I will attempt one more time after a month.
Thanks Andrew, Can you please make a course on DP-100 Designing and Implementing a Data Science Solution on Azure
I passed my DP-900. Thank you sooooooo much. Your video helped soo much!
Hi I have a exam very soon, could you please guide me and let me know if this tutorial is enough to crack the exam or you have referred some other tutorial as well..
Thank you Andrew. Appreciate the effort you have put in to make these videos.
43:35 typo should be OLAP not OLTP, Columnar Databases are great because you're always aggregating on a particular column
i.e GROUP BY col_name...
Thank you so much Andrew! This has been so helpful to me. I like the follow-along. God bless you!
Just to mention that I just passed this exam. Thank you so much for this video, it helped me a lot
Thanks for this awesome course andrew, passed DP-900 exam.
Was this video enough to learn all the materials keeping the practice aside?
@@aXe-XBT this video covers most of the DP-900 exam part and also give you idea about every service but I felt that this video should have also covered much more on non relational data where in this video it’s not covered in very detailed manner, but coming to practical experience it depends upon the individual, everyone won’t get chance to play with things in Azure except for the people who deal with Azure services within an organisation or the people who purchase it individually.I suggest for non relational data section go with Microsoft docs, except this section other sections are covered very well.
Awesome Course!! Thank you so much... could you please do DP-203, Andrew.
Just came here to say I used this along with Microsofts Traing Day series and passed the test with 947 this morning.
Good introductory video and good for cramming as well. However, there are a good number of spelling/data (😉) mistakes, inaccurate or incorrect written and/or verbal information that can be very confusing at times.
Thanks for making this course Andrew!!
Andrew Brown you legend!
Thank u, passed with 876 never did a preparation exam.
Thanks to Adruino i passed my exam
Passed yesterday, got 850/1000. The video was very useful.
Passed the Azure fundamentals exam and now I'm here.
"Exam DP-300: Administering Relational Databases on Microsoft Azure" is my request. I am going for the DP-300 after I pass the DP-900. Thank you Andrew for posting these videos.
Hey, same idea! When do You want to take dp900?
I have no idea what it is but now I would become Azure Professional. I guess that is life… 🤷♂️
Have my test tmm and you are a life saver !
You guys are a God send...much appreciated
great video. the cheatsheets were really useful for revision on the day of exam
Passed. Many thanks for the materials
Best video for a person who already passed DP-900, after passing DP-900 you will enjoy else you may reschedule the exam 🙂
Hi Andrew - going through your course, great content.
Noticed a few mixups - thought I'd bring it to your attention.
In the slide Row Store vs Column Store (43min mark) - you have mentioned that column store is suited for OLTP. Its actually OLAP.
Exactly my thoughts!Thanks for pointing it out 😀
Thank you for publishing this educational video.
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 :)
1:29:29, the Data Lake concept is changed by Data LakeHouse
Really enjoyed this. You made it easy and fun. Thanks Man
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.
At 04:34 the header of slide is wrong. It says 'Where do you take AZ-104 exam', whereas it needs to be DP-900. Through, I agree, the info will be the same (althrough you can't anymore take the exam with PSI from 2023, but this is for all exams).
I previously passed AZ900 purely by watching Andrew's video 2-3 times.
Now I would be able to pass DP900 just using this video.
This guy is hands-down a top tier instructor.
Clear voice and diction like a narrator.
Can you provide me the link for AZ900?
Did you clear it?
Please Bring Data Science Full Course !!!
nvm I found it
ua-cam.com/video/ua-CiDNNj30/v-deo.html
thanks for these videos; great learning tool..
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
Thanks!
Dang. I have my exam scheduled next Wednesday and was looking for something like this.
Is this video helpful?
@@ChaahaChills hey. I did follow this for a while but there is honestly a lot of information that isn't much pertaining to the exam. You can refer the MS docs the exam cram video by John Savill as a follow up and some short DP900 exam videos on A Guide to Cloud channel. A little too excited the trainer in the last one. But very exhaustive exam content.
Thanks Shalini
calm down , I'm not done yet with your last video 😭
ua-cam.com/play/PLBsBYvyG3LXn9L1V3ET__6rwUCrulsbom.html
LOL
LOL. You have to keep up #sarcasm
Really really good! Thank you very much!
Thanks for great content.. pls create AZ 720 Troubleshooting Microsoft Azure Connectivity
Hey folks,
DP-900 can act as an entryway for Azure Database Administrator Associate (DP-300) too, right?
I have exam in next 9 Hours. Finished this video. I will update the results here.
share u result plz
@@syedzohaid5799 yes I cleared the exam with 800+/1000. I was studying last night when I made this comment totally forgot about it.
@@barneystinson8862 How many days or hours did you spend study for this exam?
@@STHLMsoderort This video 4:45 hours + 4 Hours Reading.
@@barneystinson8862Wow, nice job!
Incredibly useful, thank you!
I just passed the test laast night, there are few queeries question and data factory, for the rest ensure you memorize the cheat sheet
I just passed my DP 900 exam, thank you very much, this video helped me a lot.
Congrats
How many days your prepared
Please give any notes
¡Gracias!
i've dp900 exam at 2:45 pm today, I've studied Microsoft learn and watched videos of some other UA-cam channel. This is my last stop hoping I'll make it .
All the best! Can you complete the exam when you want?
@@josiedavis5531 yes, you can submit whenever you want but you’ll have to appear on the given time. Or reschedule the exam 24 hours prior the exam. PS I just missed by 25 marks. I got 675 and passing marks are 700. I didn’t study hard enough so that’s okay.
@@Batsysup thanks for the info! I’m sure you’ll smash next time 😊 did you use any practice exams?
@@josiedavis5531 no I didn’t, paper was straight forward pretty easy to moderate i would say. Just don’t waste your time without studying properly like me. You’ll crack it in first try.
@@Batsysup thanks
Incorrect Information in Azure Connectivity Architecture presentation: @ 02:22:04
Where you showed the port for SQL is 1443 which is wrong.
The Correct port is 1433.
Thanks for confirming. I was really confused when the internet mentions 1433 everywhere and my external connectivity to my Azure SQL DB was working on 1433 not 1443.