Database Design for Mere Mortals

Download Database Design for Mere Mortals PDF Online Free

Author :
Publisher : Addison-Wesley Professional
ISBN 13 : 9780201752847
Total Pages : 668 pages
Book Rating : 4.7/5 (528 download)

DOWNLOAD NOW!


Book Synopsis Database Design for Mere Mortals by : Michael James Hernandez

Download or read book Database Design for Mere Mortals written by Michael James Hernandez and published by Addison-Wesley Professional. This book was released on 2003 with total page 668 pages. Available in PDF, EPUB and Kindle. Book excerpt: "This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike's approach whilst simple is completely professional, and I can recommend this book to any novice database designer." --Sandra Barker, Lecturer, University of South Australia, Australia "Databases are a critical infrastructure technology for information systems and today's business. Mike Hernandez has written a literate explanation of database technology--a topic that is intricate and often obscure. If you design databases yourself, this book will educate you about pitfalls and show you what to do. If you purchase products that use a database, the book explains the technology so that you can understand what the vendor is doing and assess their products better." --Michael Blaha, consultant and trainer, author of A Manager's Guide to Database Technology "If you told me that Mike Hernandez could improve on the first edition of Database Design for Mere Mortals I wouldn't have believed you, but he did! The second edition is packed with more real-world examples, detailed explanations, and even includes database-design tools on the CD-ROM! This is a must-read for anyone who is even remotely interested in relational database design, from the individual who is called upon occasionally to create a useful tool at work, to the seasoned professional who wants to brush up on the fundamentals. Simply put, if you want to do it right, read this book!" --Matt Greer, Process Control Development, The Dow Chemical Company "Mike's approach to database design is totally common-sense based, yet he's adhered to all the rules of good relational database design. I use Mike's books in my starter database-design class, and I recommend his books to anyone who's interested in learning how to design databases or how to write SQL queries." --Michelle Poolet, President, MVDS, Inc. "Slapping together sophisticated applications with poorly designed data will hurt you just as much now as when Mike wrote his first edition, perhaps even more. Whether you're just getting started developing with data or are a seasoned pro; whether you've read Mike's previous book or this is your first; whether you're happier letting someone else design your data or you love doing it yourself--this is the book for you. Mike's ability to explain these concepts in a way that's not only clear, but fun, continues to amaze me." --From the Foreword by Ken Getz, MCW Technologies, coauthor ASP.NET Developer's JumpStart "The first edition of Mike Hernandez's book Database Design for Mere Mortals was one of the few books that survived the cut when I moved my office to smaller quarters. The second edition expands and improves on the original in so many ways. It is not only a good, clear read, but contains a remarkable quantity of clear, concise thinking on a very complex subject. It's a must for anyone interested in the subject of database design." --Malcolm C. Rubel, Performance Dynamics Associates "Mike's excellent guide to relational database design deserves a second edition. His book is an essential tool for fledgling Microsoft Access and other desktop database developers, as well as for client/server pros. I recommend it highly to all my readers." --Roger Jennings, author of Special Edition Using Access 2002 "There are no silver bullets! Database technology has advanced dramatically, the newest crop of database servers perform operations faster than anyone could have imagined six years ago, but none of these technological advances will help fix a bad database design, or capture data that you forgot to include! Database Design for Mere Mortals(TM), Second Edition, helps you design your database right in the first place!" --Matt Nunn, Product Manager, SQL Server, Microsoft Corporation "When my brother started his professional career as a developer, I gave him Mike's book to help him understand database concepts and make real-world application of database technology. When I need a refresher on the finer points of database design, this is the book I pick up. I do not think that there is a better testimony to the value of a book than that it gets used. For this reason I have wholeheartedly recommended to my peers and students that they utilize this book in their day-to-day development tasks." --Chris Kunicki, Senior Consultant, OfficeZealot.com "Mike has always had an incredible knack for taking the most complex topics, breaking them down, and explaining them so that anyone can 'get it.' He has honed and polished his first very, very good edition and made it even better. If you're just starting out building database applications, this book is a must-read cover to cover. Expert designers will find Mike's approach fresh and enlightening and a source of great material for training others." --John Viescas, President, Viescas Consulting, Inc., author of Running Microsoft Access 2000 and coauthor of SQL Queries for Mere Mortals "Whether you need to learn about relational database design in general, design a relational database, understand relational database terminology, or learn best practices for implementing a relational database, Database Design for Mere Mortals(TM), Second Edition, is an indispensable book that you'll refer to often. With his many years of real-world experience designing relational databases, Michael shows you how to analyze and improve existing databases, implement keys, define table relationships and business rules, and create data views, resulting in data integrity, uniform access to data, and reduced data-entry errors." --Paul Cornell, Site Editor, MSDN Office Developer Center Sound database design can save hours of development time and ensure functionality and reliability. Database Design for Mere Mortals(TM), Second Edition, is a straightforward, platform-independent tutorial on the basic principles of relational database design. It provides a commonsense design methodology for developing databases that work. Database design expert Michael J. Hernandez has expanded his best-selling first edition, maintaining its hands-on approach and accessibility while updating its coverage and including even more examples and illustrations. This edition features a CD-ROM that includes diagrams of sample databases, as well as design guidelines, documentation forms, and examples of the database design process. This book will give you the knowledge and tools you need to create efficient and effective relational databases.

Database Design for Mere Mortals

Download Database Design for Mere Mortals PDF Online Free

Author :
Publisher : Addison-Wesley Professional
ISBN 13 : 0321605470
Total Pages : 668 pages
Book Rating : 4.3/5 (216 download)

DOWNLOAD NOW!


Book Synopsis Database Design for Mere Mortals by : Michael J. Hernandez

Download or read book Database Design for Mere Mortals written by Michael J. Hernandez and published by Addison-Wesley Professional. This book was released on 2003-03-03 with total page 668 pages. Available in PDF, EPUB and Kindle. Book excerpt: &a>Database Design for Mere Mortals™, Second Edition, is a straightforward, platform-independent tutorial on the basic principles of relational database design. It provides a commonsense design methodology for developing databases that work. Database design expert Michael J. Hernandez has expanded his best-selling first edition, maintaining its hands-on approach and accessibility while updating its coverage and including even more examples and illustrations. This book will give you the knowledge and tools you need to create efficient and effective relational databases.

SQL Queries for Mere Mortals

Download SQL Queries for Mere Mortals PDF Online Free

Author :
Publisher : Pearson Education
ISBN 13 : 0321992474
Total Pages : 792 pages
Book Rating : 4.3/5 (219 download)

DOWNLOAD NOW!


Book Synopsis SQL Queries for Mere Mortals by : John L. Viescas

Download or read book SQL Queries for Mere Mortals written by John L. Viescas and published by Pearson Education. This book was released on 2014 with total page 792 pages. Available in PDF, EPUB and Kindle. Book excerpt: Presents a guide to writing effective SQL queries, from simple data selection and filtering to joining multiple tables and modifying sets of data, with information on how to solve a variety of challenging SQL problems.

NoSQL for Mere Mortals

Download NoSQL for Mere Mortals PDF Online Free

Author :
Publisher : Pearson Education
ISBN 13 : 0134023218
Total Pages : 546 pages
Book Rating : 4.1/5 (34 download)

DOWNLOAD NOW!


Book Synopsis NoSQL for Mere Mortals by : Dan Sullivan

Download or read book NoSQL for Mere Mortals written by Dan Sullivan and published by Pearson Education. This book was released on 2015 with total page 546 pages. Available in PDF, EPUB and Kindle. Book excerpt: NoSQL for Mere Mortals is an easy, practical guide to succeeding with NoSQL in your environment. Students are guided step-by-step through choosing technologies, designing high-performance databases, and planning for long-term maintenance. The author introduces each type of NoSQL database, shows how to install and manage them, and demonstrates how to leverage their features while avoiding common mistakes that lead to poor performance and unmet requirements. He uses four popular NoSQL databases as reference models: MongoDB, a document database; Cassandra, a column family data store; Redis, a key-value database; and Neo4j, a graph database.

Database Design and Relational Theory

Download Database Design and Relational Theory PDF Online Free

Author :
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 1449328016
Total Pages : 277 pages
Book Rating : 4.4/5 (493 download)

DOWNLOAD NOW!


Book Synopsis Database Design and Relational Theory by : C. J. Date

Download or read book Database Design and Relational Theory written by C. J. Date and published by "O'Reilly Media, Inc.". This book was released on 2012-04-17 with total page 277 pages. Available in PDF, EPUB and Kindle. Book excerpt: Because databases often stay in production for decades, careful design is critical to making the database serve the needs of your users over years, and to avoid subtle errors or performance problems. In this book, C.J. Date, a leading exponent of relational databases, lays out the principles of good database design.

Database Design for Mere Mortals

Download Database Design for Mere Mortals PDF Online Free

Author :
Publisher : Addison-Wesley
ISBN 13 : 0133122271
Total Pages : 659 pages
Book Rating : 4.1/5 (331 download)

DOWNLOAD NOW!


Book Synopsis Database Design for Mere Mortals by : Michael J. Hernandez

Download or read book Database Design for Mere Mortals written by Michael J. Hernandez and published by Addison-Wesley. This book was released on 2021-07-27 with total page 659 pages. Available in PDF, EPUB and Kindle. Book excerpt: The #1 Easy, Commonsense Guide to Database Design! Michael J. Hernandez’s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices. Step by step, Database Design for Mere Mortals®, Third Edition, shows you how to design databases that are soundly structured, reliable, and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules. Coverage includes Understanding database types, models, and design terminology Discovering what good database design can do for you—and why bad design can make your life miserable Setting objectives for your database, and transforming those objectives into real designs Analyzing a current database so you can identify ways to improve it Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views Ensuring the appropriate level of data integrity for each application Identifying and establishing business rules Whatever relational database systems you use, Hernandez will help you design databases that are robust and trustworthy. Never designed a database before? Settling for inadequate generic designs? Running existing databases that need improvement? Start here.

Six-step Relational Database Design

Download Six-step Relational Database Design PDF Online Free

Author :
Publisher : Fidel A Captain
ISBN 13 : 1481942727
Total Pages : 234 pages
Book Rating : 4.4/5 (819 download)

DOWNLOAD NOW!


Book Synopsis Six-step Relational Database Design by : Fidel A. Captain

Download or read book Six-step Relational Database Design written by Fidel A. Captain and published by Fidel A Captain. This book was released on 2013-05-11 with total page 234 pages. Available in PDF, EPUB and Kindle. Book excerpt: Bridges the gaps between database theory, database modeling, and database implementation by outlining a simple but reliable six-step process for accurately modeling user data on a Crow's Foot Relational Model Diagram, and then demonstrating how to implement this model on any relational database management system. This volume uses three case studies and starts with a statement of the problem by the client and then goes through the six steps necessary to create a reliable and accurate data model of the client's business requirements. The second edition contains a new chapter on implementation that goes through the steps necessary to implement each of the case studies on a relational database management system, clearly relating the design to implementation and database theory. In addition, questions are also included at the end of each of the six steps and one of the previous case studies has been replaced, making the case study selection more diverse. This book is intended for use as a handbook for students and professionals in the software-development field. The technique described in this book can be used by students for quickly developing relational databases for their applications, and by professionals for developing sturdy, reliable, and accurate relational database models for their software applications. --From publisher description.

User Interface Design for Mere Mortals

Download User Interface Design for Mere Mortals PDF Online Free

Author :
Publisher : Pearson Education
ISBN 13 : 0132704706
Total Pages : 320 pages
Book Rating : 4.1/5 (327 download)

DOWNLOAD NOW!


Book Synopsis User Interface Design for Mere Mortals by : Eric Butow

Download or read book User Interface Design for Mere Mortals written by Eric Butow and published by Pearson Education. This book was released on 2007-05-09 with total page 320 pages. Available in PDF, EPUB and Kindle. Book excerpt: User Interface Design for Mere Mortals takes the mystery out of designing effective interfaces for both desktop and web applications. It is recommended reading for anyone who wants to provide users of their software with interfaces that are intuitive and easy-to-use. The key to any successful application lies in providing an interface users not only enjoy interacting with but which also saves time, eliminates frustration, and gets the job done with a minimum of effort. Readers will discover the secrets of good interface design by learning how users behave and the expectations that users have of different types of interfaces. Anyone who reads User Interface Design for Mere Mortals will benefit from • Gaining an appreciation of the differences in the “look and feel” of interfaces for a variety of systems and platforms • Learning how to go about designing and creating the most appropriate interface for the application or website being developed • Becoming familiar with all the different components that make up an interface and the important role that each of those components plays in communicating with users • Understanding the business benefits that flow from good interface design such as significantly reduced support costs • Gaining invaluable insights into how users behave, including the seven stages of human interaction with computers • Working through case study based, in-depth analysis of each of the stages involved in designing a user interface • Acquiring practical knowledge about the similarities and differences between designing websites and traditional desktop applications • Learning how to define, conduct, and analyze usability testing Through the use of the proven For Mere Mortals format, User Interface Design for Mere Mortals succeeds in parting the veil of mystery surrounding effective user interface design. Whatever your background, the For Mere Mortals format makes the information easily accessible and usable. Contents Preface Introduction CHAPTER 1 Brief Histories CHAPTER 2 Concepts and Issues CHAPTER 3 Making the Business Case CHAPTER 4 Good Design CHAPTER 5 How User Behave CHAPTER 6 Analyzing Your Users CHAPTER 7 Designing a User Interface CHAPTER 8 Designing a Web Site CHAPTER 9 Usability APPENDIX A Answers to Review Questions APPENDIX B Recommended Reading Glossary References Index

Beginning Database Design

Download Beginning Database Design PDF Online Free

Author :
Publisher : Apress
ISBN 13 : 1430242108
Total Pages : 241 pages
Book Rating : 4.4/5 (32 download)

DOWNLOAD NOW!


Book Synopsis Beginning Database Design by : Clare Churcher

Download or read book Beginning Database Design written by Clare Churcher and published by Apress. This book was released on 2012-08-08 with total page 241 pages. Available in PDF, EPUB and Kindle. Book excerpt: Beginning Database Design, Second Edition provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, you’ll learn to discover and represent the details and scope of any design problem you choose to attack. Database design is not an exact science. Many are surprised to find that problems with their databases are caused by poor design rather than by difficulties in using the database management software. Beginning Database Design, Second Edition helps you ask and answer important questions about your data so you can understand the problem you are trying to solve and create a pragmatic design capturing the essentials while leaving the door open for refinements and extension at a later stage. Solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep a design simple, but allow room for development as situations change or resources permit. Provides solid design principles by which to avoid pitfalls and support changing needs Includes numerous examples of good and bad design decisions and their consequences Shows a modern method for documenting design using the Unified Modeling Language

Database Design for Mere Mortals

Download Database Design for Mere Mortals PDF Online Free

Author :
Publisher : Pearson Education
ISBN 13 : 0321884493
Total Pages : 659 pages
Book Rating : 4.3/5 (218 download)

DOWNLOAD NOW!


Book Synopsis Database Design for Mere Mortals by : Michael James Hernandez

Download or read book Database Design for Mere Mortals written by Michael James Hernandez and published by Pearson Education. This book was released on 2013 with total page 659 pages. Available in PDF, EPUB and Kindle. Book excerpt: A guide to relational database design covers such topics as setting objectives, establishing table structures, and identifying and establishing business rules.

Relational Database Design and Implementation

Download Relational Database Design and Implementation PDF Online Free

Author :
Publisher : Morgan Kaufmann
ISBN 13 : 0128499028
Total Pages : 712 pages
Book Rating : 4.1/5 (284 download)

DOWNLOAD NOW!


Book Synopsis Relational Database Design and Implementation by : Jan L. Harrington

Download or read book Relational Database Design and Implementation written by Jan L. Harrington and published by Morgan Kaufmann. This book was released on 2016-04-15 with total page 712 pages. Available in PDF, EPUB and Kindle. Book excerpt: Relational Database Design and Implementation: Clearly Explained, Fourth Edition, provides the conceptual and practical information necessary to develop a database design and management scheme that ensures data accuracy and user satisfaction while optimizing performance. Database systems underlie the large majority of business information systems. Most of those in use today are based on the relational data model, a way of representing data and data relationships using only two-dimensional tables. This book covers relational database theory as well as providing a solid introduction to SQL, the international standard for the relational database data manipulation language. The book begins by reviewing basic concepts of databases and database design, then turns to creating, populating, and retrieving data using SQL. Topics such as the relational data model, normalization, data entities, and Codd's Rules (and why they are important) are covered clearly and concisely. In addition, the book looks at the impact of big data on relational databases and the option of using NoSQL databases for that purpose. Features updated and expanded coverage of SQL and new material on big data, cloud computing, and object-relational databases Presents design approaches that ensure data accuracy and consistency and help boost performance Includes three case studies, each illustrating a different database design challenge Reviews the basic concepts of databases and database design, then turns to creating, populating, and retrieving data using SQL

Data Modeling and Database Design

Download Data Modeling and Database Design PDF Online Free

Author :
Publisher : Cengage Learning
ISBN 13 : 9781285085258
Total Pages : 720 pages
Book Rating : 4.0/5 (852 download)

DOWNLOAD NOW!


Book Synopsis Data Modeling and Database Design by : Narayan S. Umanath

Download or read book Data Modeling and Database Design written by Narayan S. Umanath and published by Cengage Learning. This book was released on 2014-06-18 with total page 720 pages. Available in PDF, EPUB and Kindle. Book excerpt: DATA MODELING AND DATABASE DESIGN presents a conceptually complete coverage of indispensable topics that each MIS student should learn if that student takes only one database course. Database design and data modeling encompass the minimal set of topics addressing the core competency of knowledge students should acquire in the database area. The text, rich examples, and figures work together to cover material with a depth and precision that is not available in more introductory database books. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Learning SQL

Download Learning SQL PDF Online Free

Author :
Publisher : O'Reilly Media
ISBN 13 : 059655107X
Total Pages : 338 pages
Book Rating : 4.5/5 (965 download)

DOWNLOAD NOW!


Book Synopsis Learning SQL by : Alan Beaulieu

Download or read book Learning SQL written by Alan Beaulieu and published by O'Reilly Media. This book was released on 2009-04-11 with total page 338 pages. Available in PDF, EPUB and Kindle. Book excerpt: Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

Database Reliability Engineering

Download Database Reliability Engineering PDF Online Free

Author :
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 149192621X
Total Pages : 294 pages
Book Rating : 4.4/5 (919 download)

DOWNLOAD NOW!


Book Synopsis Database Reliability Engineering by : Laine Campbell

Download or read book Database Reliability Engineering written by Laine Campbell and published by "O'Reilly Media, Inc.". This book was released on 2017-10-26 with total page 294 pages. Available in PDF, EPUB and Kindle. Book excerpt: The infrastructure-as-code revolution in IT is also affecting database administration. With this practical book, developers, system administrators, and junior to mid-level DBAs will learn how the modern practice of site reliability engineering applies to the craft of database architecture and operations. Authors Laine Campbell and Charity Majors provide a framework for professionals looking to join the ranks of today’s database reliability engineers (DBRE). You’ll begin by exploring core operational concepts that DBREs need to master. Then you’ll examine a wide range of database persistence options, including how to implement key technologies to provide resilient, scalable, and performant data storage and retrieval. With a firm foundation in database reliability engineering, you’ll be ready to dive into the architecture and operations of any modern database. This book covers: Service-level requirements and risk management Building and evolving an architecture for operational visibility Infrastructure engineering and infrastructure management How to facilitate the release management process Data storage, indexing, and replication Identifying datastore characteristics and best use cases Datastore architectural components and data-driven architectures

Refactoring Databases

Download Refactoring Databases PDF Online Free

Author :
Publisher : Pearson Education
ISBN 13 : 0321630173
Total Pages : 553 pages
Book Rating : 4.3/5 (216 download)

DOWNLOAD NOW!


Book Synopsis Refactoring Databases by : Scott W. Ambler

Download or read book Refactoring Databases written by Scott W. Ambler and published by Pearson Education. This book was released on 2006-03-03 with total page 553 pages. Available in PDF, EPUB and Kindle. Book excerpt: Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems. Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design–without changing semantics. You’ll learn how to evolve database schemas in step with source code–and become far more effective in projects relying on iterative, agile methodologies. This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments. The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase. Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.

Access Database Design & Programming

Download Access Database Design & Programming PDF Online Free

Author :
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 0596002734
Total Pages : 451 pages
Book Rating : 4.5/5 (96 download)

DOWNLOAD NOW!


Book Synopsis Access Database Design & Programming by : Steven Roman

Download or read book Access Database Design & Programming written by Steven Roman and published by "O'Reilly Media, Inc.". This book was released on 2002-01-07 with total page 451 pages. Available in PDF, EPUB and Kindle. Book excerpt: For programmers who prefer content to frills, this guide has succinct and straightforward information for putting Access to its full, individually tailored use.

The Manga Guide to Databases

Download The Manga Guide to Databases PDF Online Free

Author :
Publisher : No Starch Press
ISBN 13 : 1593271905
Total Pages : 228 pages
Book Rating : 4.5/5 (932 download)

DOWNLOAD NOW!


Book Synopsis The Manga Guide to Databases by : Mana Takahashi

Download or read book The Manga Guide to Databases written by Mana Takahashi and published by No Starch Press. This book was released on 2009-01-15 with total page 228 pages. Available in PDF, EPUB and Kindle. Book excerpt: Want to learn about databases without the tedium? With its unique combination of Japanese-style comics and serious educational content, The Manga Guide to Databases is just the book for you. Princess Ruruna is stressed out. With the king and queen away, she has to manage the Kingdom of Kod's humongous fruit-selling empire. Overseas departments, scads of inventory, conflicting prices, and so many customers! It's all such a confusing mess. But a mysterious book and a helpful fairy promise to solve her organizational problems—with the practical magic of databases. In The Manga Guide to Databases, Tico the fairy teaches the Princess how to simplify her data management. We follow along as they design a relational database, understand the entity-relationship model, perform basic database operations, and delve into more advanced topics. Once the Princess is familiar with transactions and basic SQL statements, she can keep her data timely and accurate for the entire kingdom. Finally, Tico explains ways to make the database more efficient and secure, and they discuss methods for concurrency and replication. Examples and exercises (with answer keys) help you learn, and an appendix of frequently used SQL statements gives the tools you need to create and maintain full-featured databases. (Of course, it wouldn't be a royal kingdom without some drama, so read on to find out who gets the girl—the arrogant prince or the humble servant.) This EduManga book is a translation of a bestselling series in Japan, co-published with Ohmsha, Ltd., of Tokyo, Japan.