MySQL Crash Course: A Hands-On Introduction to Database Development (Paperback)
暫譯: MySQL Crash Course:資料庫開發實作入門(平裝本)
Silva, Rick
- 出版商: No Starch Press
- 出版日期: 2023-05-23
- 定價: $1,840
- 售價: 9.0 折 $1,656
- 語言: 英文
- 頁數: 352
- 裝訂: Quality Paper - also called trade paper
- ISBN: 1718503008
- ISBN-13: 9781718503007
-
相關分類:
MySQL
-
相關翻譯:
MySQL 資料庫開發的樂趣 (MySQL Crash Course: A Hands-on Introduction to Database Development) (繁中版)
MySQL數據庫開發:從入門到實踐 (簡中版)
立即出貨 (庫存=1)
買這商品的人也買了...
-
Interaction Design: Beyond Human Computer Interaction, 3/e (Paperback)$1,300$1,274 -
Computer Science: An Overview, 13/e (IE-Paperback)$1,320$1,293 -
Practical SQL : A Beginner's Guide to Storytelling with Data, 2/e (Paperback)$1,580$1,501 -
Data Structures the Fun Way: An Amusing Adventure with Coffee-Filled Examples$1,450$1,377 -
演算法邏輯力:工程師必備的演算法解題、設計、加速技巧 (Algorithmic Thinking: A Problem-Based Introduction)$720$561 -
完全圖解人工智慧:零基礎也OK!從NLP、圖像辨識到生成模型,現代人必修的53堂AI課$480$379 -
計算機概論 - AI 應用與資訊安全, 20/e$680$612 -
$490利用 Python 解決數學問題 (原書第2版) -
第一次學機率就上手, 2/e$360$342 -
Deep Learning Crash Course (Paperback)$2,160$2,052
相關主題
商品描述
With databases lurking in the background of every website, knowing how to manage them with MySQL is a no-brainer. This practical, hands-on introduction teaches readers all they need to know.
MySQL Crash Course is a fast-paced, no-nonsense introduction to relational database development. It's filled withpractical examples and expert advice that will have you up and running quickly.
You'll learn the basics of SQL, how to create a database, craft SQL queries to extract data, and work with events, procedures, and functions. You'll see how to add constraints to tables to enforce rules about permitted data and useindexes to accelerate data retrieval. You'll even explore how to call MySQL from PHP, Python, and Java.
Three final projects will show you how to build a weather database from scratch, use triggers to prevent errors in anelection database, and use views to protect sensitive data in a salary database.
You'll also learn how to:
- Query database tables for specific information, order the results, comment SQL code, and deal with null values
- Define table columns to hold strings, integers, and dates, and determine what data types to use
- Join multiple database tables as well as use temporary tables, common table expressions, derived tables, andsubqueries
- Add, change, and remove data from tables, create views based on specific queries, write reusable stored routines, and automate and schedule events
The perfect quick-start resource for database developers, MySQL Crash Course will arm you with the tools you needto build and manage fast, powerful, and secure MySQL-based data storage systems.
每個網站的背景都離不開資料庫,因此懂得如何使用 MySQL 管理資料庫是基本必備技能。這本實作導向的入門書,將教導讀者所需的一切知識。
《MySQL Crash Course》是一本節奏明快、內容直接的關聯式資料庫開發入門書。書中充滿實用範例與專家建議,讓你能迅速開始實作。
你將學習 SQL 基礎、如何建立資料庫、撰寫 SQL 查詢以擷取資料,以及如何使用事件(events)、程序(procedures)和函式(functions)。你也會了解如何為資料表加入條件約束(constraints),以強制執行資料允許規則,並使用索引(indexes)加速資料擷取。此外,你還將探索如何從 PHP、Python 和 Java 呼叫 MySQL。
最後的三個專案將帶你從零建立氣象資料庫、使用觸發程序(triggers)避免選舉資料庫中的錯誤,以及使用檢視表(views)保護薪資資料庫中的敏感資料。
你還將學習如何:
• 查詢資料表以取得特定資訊、排序查詢結果、為 SQL 程式碼加入註解,以及處理 null 值
• 定義資料表欄位以儲存字串、整數和日期,並判斷應使用哪些資料型別
• 結合多個資料庫資料表,並使用暫存資料表(temporary tables)、通用資料表運算式(common table expressions)、衍生資料表(derived tables)和子查詢(subqueries)
• 在資料表中新增、修改和移除資料;根據特定查詢建立檢視表;撰寫可重複使用的儲存常式(stored routines);以及自動化並排程事件
《MySQL Crash Course》是資料庫開發人員快速入門的理想資源,將提供你建立與管理快速、強大且安全之 MySQL 資料儲存系統所需的工具。
以上中文內容由 AI 翻譯作者簡介
Rick Silva is a software developer with decades of database experience. Silva has worked at Harvard Business School, Zipcar, and various financial services companies. A Boston native and a Boston College alum, he now lives in the Raleigh, North Carolina area with his wife Patti and his dog Dixie. When he's not joining database tables, he's playing banjo at a local bluegrass jam.
Rick Silva 是一名擁有數十年資料庫經驗的軟體開發人員。Silva 曾任職於 Harvard Business School、Zipcar 以及多家金融服務公司。他在 Boston 出生,畢業於 Boston College,目前與妻子 Patti 及愛犬 Dixie 居住在 North Carolina 州 Raleigh 地區。沒有在連接資料庫資料表時,他就會在當地的藍草音樂即興演奏會上彈奏班卓琴。
以上中文內容由 AI 翻譯