Getting Started with SQL: A Hands-On Approach for Beginners (Paperback)

Thomas Nield

  • 出版商: O'Reilly
  • 出版日期: 2016-03-29
  • 定價: $1,187
  • 售價: 9.5$1,128
  • 貴賓價: 9.0$1,068
  • 語言: 英文
  • 頁數: 134
  • 裝訂: Paperback
  • ISBN: 1491938617
  • ISBN-13: 9781491938614
  • 相關分類: SQL
  • 立即出貨 (庫存 < 3)



Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases.

Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you’ll also discover how to efficiently design and manage databases to meet your needs.

You’ll also learn how to:

  • Explore relational databases, including lightweight and centralized models
  • Use SQLite and SQLiteStudio to create lightweight databases in minutes
  • Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY
  • Join tables to get a more complete view of your business data
  • Build your own tables and centralized databases by using normalized design principles
  • Manage data by learning how to INSERT, DELETE, and UPDATE records



作者Thomas Nield在整本書中提供了練習,幫助你在家中練習你新學到的SQL技能,而不需要使用數據庫伺服器環境。你不僅將學習如何使用關鍵的SQL語句來查找和操作數據,還將發現如何高效地設計和管理數據庫以滿足你的需求。

- 探索關聯數據庫,包括輕量級和集中式模型
- 使用SQLite和SQLiteStudio在幾分鐘內創建輕量級數據庫
- 通過連接表格來獲得更完整的業務數據視圖
- 通過使用規範化設計原則來建立自己的表格和集中式數據庫
- 通過學習如何插入、刪除和更新記錄來管理數據