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
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.
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
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.
🎯 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
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.
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.
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 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 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.
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.
i'd rather appreciate the slides if i can download them, keeping up with the video would give me a headache. It's reading the slides really fast while throwing a bit more information here and there
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).
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, 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.
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.
DO NOT order the certempire dump. Wrong answers, grammar errors and more. It's an edited PDF and some of the question\answers are so small you can barely read it. I wasted 30.00 for nothing. It appears to be a screen shot with wrong answers.
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!
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 :)
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
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.
@@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.
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.
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!
"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.
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
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.
At 4:14:23 - It's one entry, not two. The IDs are the same. I think, it is some error on site, that shows one entry as two. I thinks, db.products does not work, because you don't initialize products with valid database before issuing the commands, but maybe I'm wrong
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.
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
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.
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 :)
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!
@@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.
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
Please UPDATE (DP-900) Microsoft Azure Data Fundamentals. It's been 3 Years.
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!
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?
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
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.
🎯 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 you're a super man...need tutorial for DP 203
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.
Please make a course on DP-203
Thankyou
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
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.
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 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
1:29:29, the Data Lake concept is changed by Data LakeHouse
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 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
@@user-lq9ql3rz2r th-cam.com/video/zJ-LqeX_fLU/w-d-xo.html
th-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.
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?
@@chinecheremuzondu294 Yes…
how long did you learn to take the certification ?
@@thangnguyen3786 2 weeks
watch till 3:05:00 and I got 895 with few practice in examtopics along with this ..... really helpful !!!
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.
i'd rather appreciate the slides if i can download them, keeping up with the video would give me a headache. It's reading the slides really fast while throwing a bit more information here and there
Thanks for this. I just finished taking the dp-900 and I passed :)
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?
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).
Andrew, i watched your video a couple of times and passed the exam! Thanks for putting this together. There you go..!
Very Informative and well explained. Please share tutorial for DP-203: Data Engineering on Microsoft Azure.
Thank you Andrew.
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.
Hey folks,
DP-900 can act as an entryway for Azure Database Administrator Associate (DP-300) too, right?
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
calm down , I'm not done yet with your last video 😭
th-cam.com/play/PLBsBYvyG3LXn9L1V3ET__6rwUCrulsbom.html
LOL
LOL. You have to keep up #sarcasm
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.
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.
Thank you so much bro,I have passed az900 with mark 940 by your video
At 2:36:59 - A BSON is SUBset of JSON - so, it is smaller than JSON. And then - "BSON has MORE data types than JSON"
I have no idea what it is but now I would become Azure Professional. I guess that is life… 🤷♂️
At 02:01:46 - OLAP vs OLAP. Needs to be OLAP vs OLTP
Thank you for another brillant Azure certification tutorial Andrew! Your DP-900 will help so many people!
At 01:33:16 - Predictive Analytics two times. Second must be "Prescriptive"
DO NOT order the certempire dump. Wrong answers, grammar errors and more. It's an edited PDF and some of the question\answers are so small you can barely read it. I wasted 30.00 for nothing. It appears to be a screen shot with wrong answers.
Thank you Andrew, i completed by DP 900 certification, ever grateful to you
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!
Just passed! Thank you for a great course.
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 :)
After learn with this course, my score is > 800. Thanks!
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
Thanks your video. I just passed the DP-900 exam with 908.
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.
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.
Andrew Brown you legend!
Thanks Andrew! I was able to pass in the exam in the first attempt! Great content! You rock!
40:06 Primary Key: Column that unqiuely identifies a row in a table
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.
Thank you very much! I passed dp-900 recently. Your course was very helpful.
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!
Thanks Andrew, Can you please make a course on DP-100 Designing and Implementing a Data Science Solution on Azure
At 2:39:56 - Distributed, not disTRUSTED
"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?
Thanks for the tutorial! I hope that the DP-300 Azure Database Administrator Associate course will be launched soon!
43:30 should be OLAP not OLTP for the Column-store example
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?
Thanks!
Hey, I just watched your video about 3 hours prior to me writing this exam.
I 'm glad to say, I have passed 🎉🎉🥂🥂
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
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.
1:14:03 - Outlier detection instead of outer Detection
At 4:14:23 - It's one entry, not two. The IDs are the same. I think, it is some error on site, that shows one entry as two. I thinks, db.products does not work, because you don't initialize products with valid database before issuing the commands, but maybe I'm wrong
it seems you and i both are studying.
At 01:28:27 - "Data Lakes combines the best of data warehouses and data lakes"... It must be "Data Lakehouses"
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.
Hello Andrew Thanks for the Video I cleared the Exam Today
Thank you for the video. Just passed the DP-900
Thanks , you are holy person. As of Nov 2023, do you know what tools/or online access I can use/install to train for this 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 😀
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
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?
¡Gracias!
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?
Cam anyone tell is the dp 900 exam procrored?
Just came here to say I used this along with Microsofts Traing Day series and passed the test with 947 this morning.
Please Bring Data Science Full Course !!!
nvm I found it
th-cam.com/video/ua-CiDNNj30/w-d-xo.html
Thank you Andrew. Appreciate the effort you have put in to make these videos.
Passed the Azure fundamentals exam and now I'm here.
Thank you sir! This video helped me!!! Scored 876!!! Thank you again! Your video was worth it.
Please make a Microsoft Azure Data Engineer Associate course.
Hey, could you make one of these for the SC-200, they seem super helpful! :)
th-cam.com/play/PLBsBYvyG3LXn9L1V3ET__6rwUCrulsbom.html
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 :)
Thank you so much Andrew! This has been so helpful to me. I like the follow-along. God bless you!
Best video for a person who already passed DP-900, after passing DP-900 you will enjoy else you may reschedule the exam 🙂
Typo @01:28:17 Data lakes should be Data Lakehouse
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!
Thanks to Adruino i passed my exam
I just passed the test laast night, there are few queeries question and data factory, for the rest ensure you memorize the cheat sheet
You guys are a God send...much appreciated
Thank u, passed with 876 never did a preparation exam.
So assuming we've watched the video along with it, are the cheat sheets enough to study from in order to pass the exams?
Thanks for making this course Andrew!!
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
Thank you for publishing this educational video.
5 Types of SQL Commands
2:20:52