Learning SQL: Generate, Manipulate, and Retrieve Data, 3/e (Paperback)

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對於與數據交互是必不可少的。通過《學習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年。他是《學習SQL》和《精通Oracle SQL》(O'Reilly)的作者,並為加州大學編寫了一門關於SQL的在線課程。他目前經營自己的咨詢公司,專門從事金融服務和電信領域的數據庫設計和開發。Alan擁有康奈爾大學工程學院運籌學學士學位。他與妻子和兩個女兒居住在麻薩諸塞州。