Requirements analysis and performance optimizations in relational databases are the main focus on these entries.
Topics such as
- Requirements analysis, data modeling and database design, data model, normalization and function model
- Database concepts for understanding SQL performance tuning
- SQL execution plan concepts and aspect of controlling them on Oracle, DB2, MySQL and PostgreSQL
- Dan Tow's diagramming method for query optimization presented with UML diagrams
- Clustered versus non clustered database indexes
and more can be found in this series.
CONTENTS: