Posts

Microsoft Azure Data Fundamental DP-900 Exam Study Notes

-
Image
Below are the Microsoft Azure Data Fundamental DP-900 course content and Modules on Microsoft learn website. *Explore Core Data Concepts: -Data can be categorized into 3 types. -Structured data — ex : tabular data in rows and columns -semi-structured data — ex : JSON, XML -Unstructured data — ex: audio, video files, images etc., -Data is processed either in Batches or as in when the data arrives in real-time. -Batch processing collects the data and then process it, on other hand streaming data processes it as in when data arrives. -Batch processing data examples- CSV files, one months of sales date -Stream processing data examples- online gaming data, data from sensors. -Data processing solutions are of two broad categories: analytical systems, and transaction processing systems. #Transactional system:  (OLTP) Records transactions. Transactions are a small, discrete unit of work in real time. Ex: bank transactions. These systems are high-volume and handle millions of ...
4 comments
Read more

Microsoft Azure Data Fundamentals Study Materials

-
Image
Module 1(Explore core data concepts) Data Structured : relational databases (stored in SQL Server or Azure SQL Database) Unstructured : audio and video files, and binary data files (BLOB) Semistructured: key-value stores and graph databases(key-value database stores data as a single collection without structure or relation) (Azure cosmodb) Access: Read-only (management team of large org) read/write (customers) Ownership (db admin, Data analysts and data managers) Data processing: Transactional (oltp): Splitting tables out into separate groups of columns like this is called normalization it can make querying more complex. Analytical (oatp): big picture view of the information held in a database Relational db Non relational db A transaction is a sequence of operations that are atomic. This means that either all operations in the sequence must be completed successfully, or if somethin...
3 comments
Location: India
Read more