MySQL Crash Course: A Hands-On Introduction to Database Development

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查詢以提取數據，以及如何使用事件、程序和函數。你將了解如何向表中添加約束以強制執行有關允許數據的規則，並使用索引加速數據檢索。你甚至還將探索如何從PHP、Python和Java中調用MySQL。

最後的三個項目將向你展示如何從頭開始構建一個天氣數據庫，使用觸發器來防止選舉數據庫中的錯誤，以及使用視圖來保護薪資數據庫中的敏感數據。

你還將學習如何：
- 查詢數據庫表以獲取特定信息，對結果進行排序，對SQL代碼進行註釋，處理空值
- 定義表列以保存字符串、整數和日期，並確定使用哪種數據類型
- 聯接多個數據庫表，以及使用臨時表、常用表達式、派生表和子查詢
- 向表中添加、更改和刪除數據，創建基於特定查詢的視圖，編寫可重用的存儲過程，以及自動化和計劃事件

作為數據庫開發人員的完美快速入門資源，《MySQL Crash Course》將為你提供所需的工具，以構建和管理快速、強大且安全的基於MySQL的數據存儲系統。

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曾在哈佛商學院、Zipcar和其他金融服務公司工作。作為波士頓本地人和波士頓學院的校友，他現在與妻子Patti和狗Dixie一起居住在北卡羅來納州的羅利地區。當他不在連接資料庫表格時，他會在當地的藍草音樂會上彈奏五弦琴。