商品描述
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.
作者簡介(中文翻譯)
Mark Simon自從開始他的職業生涯以來，一直參與培訓和教育工作。他起初是一位數學教師，但很快轉向IT顧問和培訓，因為與高中學生相比，電腦更容易處理！他曾與多種編程語言和編碼語言合作和培訓，目前專注於網頁開發和數據庫語言。當他不忙於工作時，你通常會發現Mark在聽音樂、演奏樂器、閱讀或四處遊蕩。
