Microsoft Azure Data Fundamentals (1)

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.