top of page
Books
We introduce a book written by Openmade Consulting as an author.
Oracle SQL Real-World Tuning Compass
The core of SQL tuning and data performance optimization.
This book covers the essential concepts and practical tuning techniques for SQL performance optimization, based on Oracle 19c.
When tuning numerous SQL statements, you'll find that 80% of the most common performance degradation issues fall into a limited number of patterns. This book focuses on resolving that 80% of frequently encountered performance-degrading patterns in real-world scenarios, while also introducing advanced tuning techniques.
The Logical Optimizer
This book focuses on SQL rewriting strategies for performance improvement. It covers how the optimizer directly alters SQL and impacts its performance, and presents solutions for performance issues that arise from the limitations of the Logical Optimizer.
Relational Data Modeling Premium Guide
A book that balances theory and reality, based on practical data modeling experience. While founded on relational theory, it presents strategies applicable to real-world modeling to help you grow as a data strategist. It emphasizes the importance of theory while helping you develop practical problem-solving skills through hands-on modeling.
ORACLE SQL Practical Tuning Basic Solution
This is a foundational guide to practical Oracle SQL tuning. It covers everything in detail from how to use tuning tools to various tuning techniques and real-world case studies, allowing you to learn through hands-on practice with the provided sample data.
Relational Data Modeling Notes
A follow-up to the 'Relational Data Modeling Premium Guide.' While the Premium Guide covered general modeling concepts, the Modeling Notes focuses on core elements like entities, attributes, and relationships for quick and easy understanding. Its classification-based explanations help foster systematic thinking, and it also covers advanced topics for experts.
bottom of page