Learning SQL: Generate, Manipulate, and Retrieve Data, 3/e (Paperback)
暫譯: 學習 SQL:生成、操作與檢索資料,第 3 版 (平裝本)

Beaulieu, Alan

買這商品的人也買了...

相關主題

商品描述

As more and more data floods into your company, you need to put it to work right away--and SQL is a vital tool for getting the job done. With the latest edition of this introductory guide, author Alan Beaulieu helps developers quickly get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You'll find new chapters on SQL and big data, working with very large databases, and analytic functions.

Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

With this book, you'll:

  • Move quickly through SQL basics and learn several advanced features
  • Use SQL data statements to generate, manipulate, and retrieve data
  • Create database objects, such as tables, indexes, and constraints, using SQL schema statements
  • Learn how datasets interact with queries and understand the importance of subqueries
  • Convert and manipulate data with SQL's built-in functions and use conditional logic in data statements

 

 

 

商品描述(中文翻譯)

隨著越來越多的數據湧入您的公司,您需要立即將其投入使用,而 SQL 是完成這項工作的關鍵工具。在這本最新版本的入門指南中,作者 Alan Beaulieu 幫助開發人員快速掌握 SQL 基礎知識,以便編寫資料庫應用程式、執行管理任務和生成報告。您將發現有關 SQL 和大數據、處理非常大的資料庫以及分析函數的新章節。

每一章都提供了一個關於關鍵 SQL 概念或技術的獨立課程,並使用大量插圖和註解範例。每章結尾的練習題讓您能夠練習所學的技能。了解 SQL 是與數據互動的必要條件。透過《Learning SQL》,您將快速學會如何利用這種語言的強大和靈活性。

透過這本書,您將:

- 快速掌握 SQL 基礎並學習幾個進階功能
- 使用 SQL 數據語句生成、操作和檢索數據
- 使用 SQL 架構語句創建資料庫對象,如表格、索引和約束
- 學習數據集如何與查詢互動,並理解子查詢的重要性
- 使用 SQL 的內建函數轉換和操作數據,並在數據語句中使用條件邏輯

作者簡介

Alan Beaulieu has been designing, building, and implementing custom database applications for over 25 years. He is the author of Learning SQL and Mastering Oracle SQL (O'Reilly), and has written an online course on SQL for the University of California. He currently runs his own consulting company that specializes in database design and development in the fields of Financial Services and Telecommunications. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters.

作者簡介(中文翻譯)

艾倫·比尤利(Alan Beaulieu)擁有超過25年的自訂資料庫應用程式設計、建置和實作經驗。他是《Learning SQL》和《Mastering Oracle SQL》(O'Reilly)的作者,並為加州大學撰寫了一門有關SQL的線上課程。他目前經營自己的顧問公司,專注於金融服務和電信領域的資料庫設計與開發。艾倫擁有康奈爾大學工程學院的運籌學學士學位。他與妻子和兩個女兒居住在麻薩諸塞州。