Azure Data Fundamentals Certification (DP-900) - Full Course to PASS the Exam
FBTwitterReddit
video description
Rating: 4.5; Vote: 2
Prepare for the Azure Data Fundamentals Certification and pass!
- (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 Date: 2022-03-14
Arun 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
reply
Muni 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.
reply
Veena Over all good course. But wont recommend for absolute beginners. + I observed a lot of mistakes/ carelessness throughout the video which may confuse us.
reply
Periyasamy I attended the Microsoft virtual training days for 2 days and went through this video twice. ive passed with 890 :) .. Thanks , really helped !!
reply
Zulfan I just passed the test laast night, there are few queeries question and data factory, for the rest ensure you memorize the cheat sheet reply
2:5:31
2:5:24
