Prepare for the Azure Data Fundamentals Certification and pass! ✏️ Course developed by Andrew Brown of ExamPro. Check out the ExamPro YouTube channel: https://www.youtube.com/ExamProChannel ???? ExamPro Cloud Obsessed Certification Training:
Prepare for the Azure Data Fundamentals Certification and pass!
✏️ Course developed by Andrew Brown of ExamPro. Check out the ExamPro YouTube channel: https://www.youtube.com/ExamProChannel
???? ExamPro Cloud Obsessed Certification Training: https://www.exampro.co
☁️ Data Concepts
???? (0:10:12) Auzre Core Data Related Services
???? (0:14:55) Types of Cloud Computing
???? (0:16:56) Azure Data Related Roles
???? (0:18:42) Database Administrator Common tools
???? (0:20:27) Data Engineering Common tools
???? (0:21:43) Data Analyst Common tools
???? (0:22:26) Data Overview
???? (0:23:43) Introduction to Data
???? (0:24:32) Data documents
???? (0:25:30) Data sets
???? (0:28:31) Data types
???? (0:32:15) Schema vs Schemaless
???? (0:34:09) Query and Querying
???? (0:35:54) Batch vs Stream processing
???? (0:38:30) Relational data
???? (0:40:35) Relational data Relationships
???? (0:42:07) Row store vs Column store
???? (0:43:44) Database Index
???? (0:45:05) Data Integegrity vs Data Corruption
???? (0:47:11) Normalized vs Denomralized data
???? (0:48:32) Pivot table
???? (0:50:10) Strongly consistent vs Eventually consistent
???? (0:51:33) Synchronus vs Asynchronous
???? (0:53:29) Non relational data
???? (0:54:29) Data source
???? (0:55:41) Data store
???? (0:56:32) Database
???? (0:57:56) Data warehouse
???? (0:59:39) Data mart
???? (1:00:36) Data lakes
???? (1:01:42) Data lakehouse
???? (1:03:12) Data structures
???? (1:04:02) Unstructured data
???? (1:04:47) Semi structured
???? (1:06:10) Semi structured Data Structures
???? (1:07:16) Semi structure JSON
???? (1:08:11) semi structure ORC
???? (1:09:39) semi structure Parquets
???? (1:10:35) semi structure AVRO
???? (1:11:25) Structured Data
???? (1:11:56) Data mining
???? (1:13:02) Data mining methods
???? (1:14:28) Data wrangling
???? (1:15:31) Ddata modeling
???? (1:17:18) ETL vs ELT
???? (1:19:18) Data analytics
???? (1:20:14) Key performance indicators KPI
???? (1:21:23) Data Analytic Techniques
???? (1:23:02) Microsoft One Drive
???? (1:24:20) Microsoft Sharepoint
???? (1:25:49) Data Core Concepts CheatSheet
☁️ Azure Synapse and Data Lake
???? (1:33:36) Azure Synapse Analytics
???? (1:35:26) Sypanse SQL and pools
???? (1:37:19) Synapse Key Features
???? (1:38:31) Azure Data Lake Gen 2
???? (1:40:03) Polybase
???? (1:40:50) Synapse ELT
???? (1:41:51) Azure Data Lake Analytics
???? (1:43:05) Azure Sypanse and Data Lakes CheatSheet
☁️ Account Storage
???? (1:44:25) Azure Blob Storage
???? (1:45:20) Azure Files
???? (1:47:14) Azure Storage Accounts CheatSheet
☁️ Power BI
???? (1:48:07) Business Intelligence
???? (1:48:40) Power BI
???? (1:51:29) Power BI Visualizations
???? (1:53:13) Power BI Embedded
???? (1:54:02) Power BI Interactive Reports
???? (1:55:36) Power BI Service and Dashboards
???? (1:56:47) Reports vs Dashboards
???? (1:57:47) Paginated Reports
???? (1:58:57) Power BI CheatSheet
☁️ Relational Databases
???? (2:00:38) Structured Query Language
???? (2:01:48) OLAP vs OLAP
???? (2:03:14) Open Source Relational Databases
???? (2:06:01) Read Replicas
???? (2:07:10) Citus Postgres Hyperscale
???? (2:08:03) Azure SQL Family
???? (2:10:30) Elastic pools
???? (2:11:45) Relational Databases CheatSheet
☁️ T SQL
???? (2:14:12) T SQL
???? (2:15:40) Data Defintion Language
???? (2:16:43) Data Manipulation Language
???? (2:18:02) Data Query Language
???? (2:19:08) Data Control Language
???? (2:19:36) Transaction Control Langauge
???? (2:20:22) SQL Document Comparsions
???? (2:21:10) T SQL CheatSheet
☁️ Database Security
???? (2:22:01) Connectivity Architecture
???? (2:23:13) Database Authentication
???? (2:24:41) Network Connectivity
???? (2:25:19) Azure Defender for SQL
???? (2:25:54) Azure Database Server Firewalls
???? (2:27:00) Always Encrypted
???? (2:27:47) Role Based Access Controls
???? (2:28:48) Transparent Data Encryption
???? (2:29:49) Dynamic Data Masking
???? (2:31:02) Private Links
???? (2:31:57) Database Security Cheatsheet
☁️ Azure Tables Cosmos DB
???? (2:34:13) Key Value Store
???? (2:35:40) Document Store
???? (2:36:33) Mongo DB
???? (2:38:35) Graph Database
???? (2:39:42) Apache Tinkerpop and Gremlin
???? (2:41:23) Azure Tables
???? (2:42:45) Azure Cosmos DB
???? (2:44:40) Azure Table Account Storage vs Cosmos DB
???? (2:46:39) Azure Tables and CosmosDB CheatSheet
☁️ Hadoop Systems
???? (2:48:29) Apache Hadoop
???? (2:49:57) Apache Kafka
???? (2:50:53) HDInsights
???? (2:52:05) Hadoop CheatSheet
☁️ Azure and Databricks
???? (2:53:21) Apache Spark
???? (2:55:04) Azure Databricks
???? (2:57:16) Apache Spark and Databricks CheatSheet
☁️ ELT and SQL Tools
???? (2:58:46) SQL Server Management Studio
???? (2:59:37) SQL Server Data Tools
???? (3:00:58) Azure Data Studio
???? (3:01:48) Azure Data Factory
???? (3:02:59) SQL Server Integration Services
???? (3:04:08) ETL and SQL Tools CheatSheet
☁️ Follow Alongs
???? (3:05:38) Install and Use Power BI
???? (3:08:17) Launch Azure SQL and Use Data Studio
???? (3:34:53) Use Azure SQL as data source in Power BI
???? (3:44:20) Use SSMS to perform a query on Azure SQL
???? (3:47:37) Create Blob and File storage
???? (3:57:36) Explore CosmosDB various NoSQL engines
???? (4:27:08) Create a ELT job from Azure SQL to Blob Storage
???? (4:33:06) Explore Azure Databricks
???? (4:39:49) Explore Azure Synapse Analytics
???? (4:44:47) Cleanup









