Summaries of books about Databases & Data Management:
Designing Data-Intensive Applications
The Big Ideas Behind Reliable, Scalable, and Maintainable Systems
Martin Kleppmann
The book explores the fundamental principles and technologies that underpin scalable, reliable, and maintainable data systems, discussing topics such as storage, retrieval, encoding, replication, partitioning, and consensus. It provides a deep dive into the architecture of modern data-processing systems, offering insights into how to design them effectively to handle the complex demands of real-world applications.
See full summary
Excel 2019 Bible
Michael Alexander|Richard Kusleika|John Walkenbach
The book serves as a comprehensive guide to mastering Excel 2019, covering fundamental concepts, advanced features, and step-by-step instructions for utilizing Excel's tools. It includes practical examples, tips, and tricks to help users analyze, manage, and share data effectively using Excel.
See full summary
Excel for Beginners
M.L. Humphrey
The book serves as an introductory guide to Microsoft Excel, providing step-by-step instructions on how to use the basic features and functions of the spreadsheet software. It covers topics such as creating and formatting worksheets, working with data, and understanding essential formulas for beginners.
See full summary
101 Most Popular Excel Formulas
John Michaloudis|Bryan Hong
The book provides a comprehensive guide to the most commonly used Excel formulas, offering explanations, examples, and practical applications for each formula. It serves as a resource for users looking to improve their data analysis skills and enhance their proficiency in spreadsheet tasks.
See full summary
SQL All-in-One For Dummies
Allen G. Taylor
The book serves as a comprehensive guide to SQL, covering fundamental concepts, syntax, and functions for database management and manipulation. It includes practical examples, tips for optimizing queries, and explanations of advanced topics like triggers, stored procedures, and indexing for readers ranging from beginners to more advanced users.
See full summary
The Big Book of Dashboards
Visualizing Your Data Using Real-World Business Scenarios
Steve Wexler|Jeffrey Shaffer|Andy Cotgreave
The book provides a comprehensive guide to designing and implementing effective dashboards in a business context, showcasing a variety of real-world examples and best practices. It covers essential principles of data visualization, dashboard architecture, and how to tailor dashboards to specific business needs and audiences for maximum impact.
See full summary
Digital Zettelkasten
Principles, Methods, & Examples
David Kadavy
The book provides a comprehensive guide on how to implement the Zettelkasten note-taking system using digital tools, offering practical advice on organizing thoughts and improving knowledge management. It includes examples and methodologies to help readers effectively create and maintain a personal digital knowledge base for creative and academic work.
See full summary
The Data Warehouse Toolkit
The Definitive Guide to Dimensional Modeling
Ralph Kimball|Margy Ross
The book provides a comprehensive guide to dimensional modeling techniques, best practices, and methodologies for designing effective and scalable data warehouses. It includes real-world case studies, detailed examples of star and snowflake schema designs, and practical advice for implementing business intelligence solutions.
See full summary
Excel All-in-One For Dummies
Paul McFedries|Greg Harvey
The book serves as a comprehensive guide to mastering Microsoft Excel, covering everything from basic spreadsheet creation to advanced functions, data analysis, and macro programming. It provides step-by-step instructions, practical examples, and tips to help users of all levels improve their Excel skills and productivity.
See full summary
Access 2016 Bible
Michael Alexander|Richard Kusleika
The book serves as a comprehensive guide to mastering Microsoft Access 2016, covering everything from basic database concepts to advanced VBA programming techniques. It provides step-by-step instructions, practical examples, and tips to help users design, develop, and maintain professional Access databases.
See full summary