MySQL Crash Course: A Hands-On Introduction to Database Development
暫譯: MySQL 快速入門：資料庫開發的實作指南

Silva, Rick

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 一起居住在北卡羅來納州的羅利地區。當他不在進行資料庫表格的聯接時，他會在當地的藍草音樂聚會上彈奏班卓琴。

類似商品