Today, we're going to look at some fundamental concepts of Microsoft Azure & MSSQL Database.
Descriptive Analytics:
- What happened
Normalization:
1. + relationship
2. - redundancy
3. + integrity
ETL:
- Transform data before load
Transcribe:
- Cognitive
Prescriptive:
- Action
Star schema:
- Dimension table
MPP:
1. Distributed
2. Compute nodes
Clustered index:
1. Sort
2. Key value
Batch processing:
- File store
Treemap:
Scatter:
- Relationship
Thank you for your reading!
See you in the next tutorial.
© 2023 Harmony Pang. All rights reserved.
Comments