Grokking Relational Database Design
暫譯: 深入理解關聯資料庫設計

Hao, Qiang, Tsikerdekis, Michail

  • 出版商: Manning
  • 出版日期: 2025-04-29
  • 售價: $1,890
  • 貴賓價: 9.5$1,796
  • 語言: 英文
  • 頁數: 316
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1633437418
  • ISBN-13: 9781633437418
  • 相關分類: 資料庫SQL
  • 尚未上市,無法訂購

商品描述

A friendly illustrated guide to designing and implementing your first database.

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.

商品描述(中文翻譯)

一本友善的插圖指南,幫助您設計和實現您的第一個資料庫。

資料是計算機科學的基石,而資料庫是資料存儲、交換、操作和管理的主要方式。無論您是軟體開發人員、資料科學家,還是希望提升資料分析技能的熱情商業用戶,學習如何創建和查詢關聯資料庫,如 MySQL、SQL Server、PostgreSQL 和 Oracle,都是非常有益的。Grokking Relational Database Design 將幫助您入門!

Grokking Relational Database Design 中,您將學習如何:

- 使用結構化查詢語言 (SQL) 查詢和創建資料庫
- 從零開始設計資料庫
- 實施和優化資料庫設計
- 在設計資料庫時利用生成式 AI

一個良好構建的資料庫易於理解、查詢、管理,並在您的應用程式需要擴展時能夠輕鬆擴展。在 Grokking Relational Database Design 中,您將學習關聯資料庫設計的基本知識,包括如何命名欄位和表格、應該存儲哪些資料、如何消除重複、資料收集和衛生的良好實踐等等。您不需要計算機科學學位或深入的程式設計知識——本書的實用範例和通俗易懂的定義非常適合初學者。

關於本書

Grokking Relational Database Design 通過真實世界的專案、深刻的插圖和以行動為導向的學習來教授資料庫設計的藝術。與許多初學者資料庫書籍專注於 SQL 的技術細節和正式的資料庫理論不同,本書教您如何從基礎開始思考關聯資料庫設計,讓您創建出長期使用起來都令人愉悅的資料庫。

本書中的所有內容都通過實作練習和範例得到強化。您將快速設計、實施和優化一個電子商務應用程式的資料庫,這類應用程式是您每天都在使用的。您還將探索生成式 AI 工具,如 ChatGPT,如何徹底簡化資料庫設計中的日常任務。

關於讀者

適合自學的程式設計師、工程師、資料科學家和商業資料用戶。無需具備關聯資料庫的先前經驗。

關於作者

Qiang Hao 是西華盛頓大學計算機科學的副教授。他是計算教育研究的公認專家,並在教授各種計算機科學課程(如軟體工程和資料庫系統)方面擁有豐富的經驗。

Michail Tsikerdekis 是西華盛頓大學計算機科學的副教授。他擁有捷克馬薩里克大學的資訊學博士學位。此外,他被認可為 IEEE 高級會員,並在計算機科學和網路安全方面擁有超過十年的教學經驗。

作者簡介

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.

作者簡介(中文翻譯)

Qiang Hao 是西華盛頓大學的計算機科學副教授。他是計算教育研究的公認專家,並在教授各種計算機科學課程方面擁有豐富的經驗,例如軟體工程和資料庫系統。

Michail Tsikerdekis 是西華盛頓大學的計算機科學副教授。他擁有捷克馬薩里克大學的資訊學博士學位。此外,他被認可為IEEE資深會員,並在計算機科學和網路安全領域擁有超過十年的教學經驗。