Data is the backbone of computer science, and databases are the main way that data is stored, exchanged, manipulated, and managed. Whether you’re a software developer, a data scientist, or an enthusiastic business user looking to up your data analysis skills, it pays to learn how to create and query relational databases like MySQL, SQL Server, PostgreSQL, and Oracle. Grokking Relational Database Design will get you started!
In Grokking Relational Database Design, you’ll learn how to:
• Query and create databases using Structured Query Language (SQL)
• Design databases from scratch
• Implement and optimize database designs
• Take advantage of generative AI when designing databases
A well-constructed database is easy to understand, query, manage, and scale when your app needs to grow. In Grokking Relational Database Design you’ll learn the basics of relational database design including how to name fields and tables, which data to store where, how to eliminate repetition, good practices for data collection and hygiene, and much more. You won’t need a computer science degree or in-depth knowledge of programming—the book’s practical examples and down-to-earth definitions are beginner-friendly.
About the book
Grokking Relational Database Design teaches the art of database design through real-world projects, insightful illustrations, and action-oriented learning. Unlike many beginning database books that focus on the technical details of SQL and formal database theory, this book teaches you how to think about relational database design from the ground up, so you’ll create databases that are a joy to use for a long time.
Everything in this book is reinforced by hands-on exercises and examples. You’ll quickly design, implement, and optimize a database for an e-commerce application like the ones you use every day. You’ll also explore how generative AI tools such as ChatGPT radically simplify the mundane tasks of database design.
About the reader
Suitable for self-taught programmers, engineers, data scientists, and business data users. No previous experience with relational databases required.
About the author
Qiang Hao is an associate professor of Computer Science at Western Washington University. He is a recognized expert in computing education research and has extensive experience in teaching a variety of computer science courses, such as software engineering and database systems.
Michail Tsikerdekis is an associate professor of Computer Science at Western Washington University. He holds a Ph.D. in Informatics from Masaryk University, Czechia. Additionally, he is recognized as an IEEE Senior Member, and his expertise covers over a decade of teaching experience in Computer Science and Cybersecurity.
Ebook License
End-User Warranty And License Agreement
1. Grant Of License
Manning Has Authorized The Download By You Of An Unrestricted Number Of Copies Of The Electronic Book (Ebook) In Any Of The Available Formats. Manning Grants You A Nonexclusive, Nontransferable License To Use The Ebook According To The Terms And Conditions Herein. This License Agreement Permits You To Install The Ebook On Any And All Your Devices For Your Personal Use Only.
2. Restrictions
You Shall Not: (1) Share, Resell, Rent, Assign, Timeshare, Distribute, Or Transfer All Or Part Of The Ebook Or Any Rights Granted Hereunder To Any Other Person; (2) Duplicate The Ebook, Except For A Single Backup Or Archival Copy; (3) Remove Any Proprietary Notices, Labels, Or Marks From The Ebook; (4) Transfer Or Sublicense Title To The Ebook To Any Other Party.
3. Intellectual Property Protection
The Ebook Is Owned By Manning And Is Protected By United States And International Copyright And Other Intellectual Property Laws. Manning Reserves All Rights In The Ebook Not Expressly Granted Herein. This License And Your Right To Use The Ebook Terminate Automatically If You Violate Any Part Of This Agreement. In The Event Of Termination, You Must Remove The Original And Any Copies Of The Ebook From All Your Devices.
4. Source Code Supplementary Material
Any Source Code Files Provided As A Supplement To The Book Are Freely Available To The Public For Download. Reuse Of The Code Is Permitted, In Whole Or In Part, Including The Creation Of Derivative Works, Provided That You Acknowledge That You Are Using It And Identify The Source: Title, Publisher And Year.
5. Limited Warranty
Manning Warrants That The Ebook Files, A Copy Of Which You Are Authorized To Download, Are Free From Defects In The Operational Sense That They Can Be Read By A Pdf Reader Or Epub Reader, Or Other. Except For This Express Limited Warranty, Manning Makes And You Receive No Warranties, Express, Implied, Statutory Or In Any Communication With You, And Manning Specifically Disclaims Any Other Warranty Including The Implied Warranty Of Merchantability Or Fitness Or A Particular Purpose. Manning Does Not Warrant That The Operation Of The Ebook Will Be Uninterrupted Or Error Free. If The Ebook Was Purchased In The United States, The Above Exclusions May Not Apply To You As Some States Do Not Allow The Exclusion Of Implied Warranties. In Addition To The Above Warranty Rights, You May Also Have Other Rights That Vary From State To State.
6. Limitation Of Liability
In No Event Will Manning Be Liable For Any Damages, Whether Arising For Tort Or Contract, Including Loss Of Data, Lost Profits, Or Other Special, Incidental, Consequential, Or Indirect Damages Arising Out Of The Use Or Inability To Use The Ebook.
7. General
This Agreement Constitutes The Entire Agreement Between You And Manning And Supersedes Any Prior Agreement Concerning The Ebook. This Agreement Is Governed By The Laws Of The State Of New York
