Getting Started with SQL and Databases: Managing and Manipulating Data with SQL
暫譯: SQL 與資料庫入門：使用 SQL 管理與操作資料
Simon, Mark
相關主題
商品描述
Learn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite.
The book starts with a general introduction to writing SQL and covers the basic concepts. Author Mark Simon then covers database principles, and how database tables are designed. He teaches you how to filter data using the WHERE clause, and you will work with NULL, numbers, dates, and strings. You will also understand sorting results using the ORDER BY clause, sorting by calculated columns, and limiting the number of results. By the end of the book, you will know how to insert and update data, and summarize data with aggregate functions and groups. Three appendices cover differences between SQL dialects, working with tables, and a crash course in PDO.
What You Will Learn
- Filter, sort, and calculate data
- Summarize data with aggregate functions
- Modify data with insert, update, and delete statements
- Study design principles in developing a database
Who This Book Is For
Developers and analysts working with SQL, as well as web developers who want a stronger understanding of working with databases
商品描述(中文翻譯)
學習撰寫 SQL 腳本的基本知識。本書以標準 SQL 為起點，教授在各種流行方言中撰寫 SQL，包括 PostgreSQL、MySQL/MariaDB、Microsoft SQL Server、Oracle 和 SQLite。
本書首先對撰寫 SQL 進行一般介紹，並涵蓋基本概念。作者 Mark Simon 接著介紹資料庫原則以及資料庫表的設計。他教你如何使用 WHERE 子句過濾資料，並將處理 NULL、數字、日期和字串。你還將了解如何使用 ORDER BY 子句對結果進行排序，根據計算列進行排序，以及限制結果的數量。在本書結束時，你將知道如何插入和更新資料，並使用聚合函數和分組來彙總資料。三個附錄涵蓋 SQL 方言之間的差異、操作表的方式，以及 PDO 的速成課程。
你將學到的內容：
- 過濾、排序和計算資料
- 使用聚合函數彙總資料
- 使用插入、更新和刪除語句修改資料
- 研究開發資料庫的設計原則
本書適合對象：
從事 SQL 的開發人員和分析師，以及希望更深入了解資料庫操作的網頁開發人員。
作者簡介
Mark Simon has been involved in training and education since the beginning of his career. He started as a teacher of mathematics but soon moved into IT consultancy and training because computers are much easier to work with than high school students! He has worked with and trained in several programming and coding languages, and currently focuses on web development and database languages. When not involved in work, you will generally find Mark listening to or playing music, reading, or just wandering about.
作者簡介(中文翻譯)
馬克·西蒙自職業生涯開始以來一直參與培訓和教育。他最初是一名數學教師，但不久後因為與高中生相比，電腦的工作要容易得多，因此轉向了IT諮詢和培訓。他曾經使用和教授多種程式設計和編碼語言，目前專注於網頁開發和資料庫語言。在不工作的時候，馬克通常會聽音樂、彈奏音樂、閱讀或隨意漫遊。
