Hi there!
You can find out here of “Introduction into Relational Databases” course with theme “Semantic SQL query optimization”.
Themes are below.
- Relational algebra and optimization
- Database statistics
- Parse tree
- Query tree
- Plan tree
- Reduction Law
- Projection Law
- Reduction Projection Law
- Distribution Law
- Commutative Law
- Associative Law
- Idempotent Law
- Expression Transformation
- Semantic equivalent
- Query cost
Please if you have some comments / questions or remarks , just let me know about it.
Thanks!