The SQL Workshop
暫譯: SQL 工作坊

Solomon, Frank, Jayaram, Prashanth, Al Saqqa, Awni

The SQL Workshop
  • 出版商: Packt Publishing
  • 出版日期: 2019-12-27
  • 售價: $1,450
  • 貴賓價: 9.5 折 $1,378
  • 語言: 英文
  • 頁數: 286
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1838642358
  • ISBN-13: 9781838642358
  • 相關分類: SQL

    • 海外代購書籍(需單獨結帳)

相關主題

商品描述

Key Features

  • A structured, straightforward introduction to SQL for beginners
  • A SQL tutorial with step-by-step exercises and activities that help build key skills
  • Structured to let you progress at your own pace, on your own terms
  • Use your physical print copy to redeem free access to the online interactive edition

Book Description

You already know you want to learn SQL, and the best way to learn SQL is to learn by doing. The SQL Workshop focuses on building up your SQL database management skills so that you can easily store and retrieve data or become the in-house expert on complex queries. You'll learn from real examples that lead to real results.

Throughout The SQL Workshop, you'll take an engaging step-by-step approach to understanding SQL programming. You won't have to sit through any unnecessary theory. If you're short on time you can jump into a single exercise each day or spend an entire weekend learning how to create functions and stored procedures. It's your choice. Learning on your terms, you'll build up and reinforce key skills in a way that feels rewarding.

Every physical print copy of The SQL Workshop unlocks access to the interactive edition. With videos detailing all exercises and activities, you'll always have a guided solution. You can also benchmark yourself against assessments, track progress, and receive content updates. You'll even earn a secure credential that you can share and verify online upon completion. It's a premium learning experience that's included with your printed copy. To redeem, follow the instructions located at the start of your book.

Fast-paced and direct, The SQL Workshop is the ideal companion for SQL beginners. You'll build and iterate on your code like a software developer, learning along the way. This process means that you'll find that your new skills stick, embedded as best practice. A solid foundation for the years ahead.

What you will learn

  • Learn how to create normalized databases
  • Explore how to insert data into tables efficiently
  • Explore various techniques to retrieve data from multiple tables
  • Build advanced queries using techniques like subqueries and views
  • Learn advanced SQL programming techniques such as functions and triggers

Who this book is for

Our goal at Packt is to help you be successful, in whatever it is you choose to do. The SQL Workshop is an ideal SQL tutorial for the SQL beginner who is just getting started. Pick up a Workshop today, and let Packt help you develop skills that stick with you for life.

商品描述(中文翻譯)

#### 主要特點

- 為初學者提供結構化且簡單明瞭的 SQL 介紹
- 包含逐步練習和活動的 SQL 教學，幫助建立關鍵技能
- 結構化設計讓您可以按照自己的步調和條件進行學習
- 使用實體印刷版以兌換免費訪問線上互動版

#### 書籍描述

您已經知道自己想學習 SQL，而學習 SQL 的最佳方式就是透過實作來學習。《SQL 工作坊》專注於提升您的 SQL 資料庫管理技能，使您能輕鬆地儲存和檢索資料，或成為內部複雜查詢的專家。您將從真實的範例中學習，並獲得實際的成果。

在《SQL 工作坊》中，您將以引人入勝的逐步方式理解 SQL 程式設計。您不必經歷任何不必要的理論。如果您時間有限，可以每天跳入一個練習，或花整個週末學習如何創建函數和儲存過程。這完全取決於您。按照您的條件學習，您將以令人滿意的方式建立和強化關鍵技能。

每本《SQL 工作坊》的實體印刷版都解鎖了互動版的訪問權限。透過詳細說明所有練習和活動的影片，您將始終擁有指導解決方案。您還可以通過評估來自我評估、追蹤進度並接收內容更新。完成後，您甚至會獲得一個安全的憑證，可以在線上分享和驗證。這是一個包含在您的印刷版中的高級學習體驗。要兌換，請遵循書本開頭的說明。

快速且直接，《SQL 工作坊》是 SQL 初學者的理想伴侶。您將像軟體開發人員一樣構建和迭代您的程式碼，並在過程中學習。這個過程意味著您會發現您的新技能會牢牢扎根，成為最佳實踐的組成部分。為未來的幾年奠定堅實的基礎。

---

#### 您將學到的內容

- 學習如何創建正規化的資料庫
- 探索如何有效地將資料插入表格
- 探索從多個表格檢索資料的各種技術
- 使用子查詢和視圖等技術構建高級查詢
- 學習高級 SQL 程式設計技術，如函數和觸發器

#### 本書適合誰

我們在 Packt 的目標是幫助您成功，無論您選擇做什麼。《SQL 工作坊》是為剛開始學習的 SQL 初學者提供的理想 SQL 教學。今天就拿起一本工作坊，讓 Packt 幫助您發展終生受用的技能。

作者簡介

Frank Solomon started out building front-end and database software with Microsoft stack tools such as SQL Server and ASP and then extended into ASP.NET, C#, VB.NET, JavaScript, and more. He learns about new products, languages, and technologies all the time, and he pushed into technical writing as a way to present and express his research and discoveries. He works as a contractor right now. He has worked in start-ups himself, and he knows that the hard work of writers and developers makes the end user experience easier.

Prashanth Jayaram is a database technologist, blogger, engineering lead, automation expert, TechNet wiki ninja, PowerShell Geek, and technologist enthusiast with extensive experience in designing database solutions. He is the author of PowerShell 6.0 Linux Administration Cookbook and has hands-on experience with the next generation database technologies. He has been awarded as ABOVE and BEYOND and Best SQL Author 2018 towards his contribution to SQL Server technology. He has articulated over 200+ articles widespread across SQL, NoSQL, PowerShell, Python, SQL on Linux, SQL on Azure, and SQL on AWS arenas.

Awni Al Saqqa is a Microsoft Technology Specialist in MS SQL Server and a certified solutions developer since 2007. He has over a decade of experience with database development and administration on SQL Server, Oracle, and MySQL. He is a solutions architect, who is hands-on in many enterprise projects for different business sectors, such as education, hospitality, retail, manufacturing, marketing, and more, which has given him the perfect combination between business and technical experience.

作者簡介(中文翻譯)

Frank Solomon 開始時使用 Microsoft 技術堆疊工具，如 SQL Server 和 ASP，來構建前端和資料庫軟體，然後擴展到 ASP.NET、C#、VB.NET、JavaScript 等等。他不斷學習新產品、語言和技術，並將技術寫作作為展示和表達他的研究和發現的一種方式。他目前作為承包商工作。他曾在初創公司工作，並且知道作家和開發者的辛勤工作使最終用戶的體驗變得更輕鬆。

Prashanth Jayaram 是一位資料庫技術專家、部落客、工程領導、自动化專家、TechNet wiki 專家、PowerShell 發燒友，以及對技術充滿熱情的人，擁有設計資料庫解決方案的豐富經驗。他是《PowerShell 6.0 Linux 管理食譜》的作者，並擁有下一代資料庫技術的實際經驗。他因對 SQL Server 技術的貢獻而獲得了 ABOVE and BEYOND 和 2018 年最佳 SQL 作者的獎項。他已經撰寫了超過 200 篇文章，涵蓋 SQL、NoSQL、PowerShell、Python、SQL on Linux、SQL on Azure 和 SQL on AWS 等領域。

Awni Al Saqqa 是一位 Microsoft 技術專家，專注於 MS SQL Server，自 2007 年以來是一名認證解決方案開發者。他在 SQL Server、Oracle 和 MySQL 的資料庫開發和管理方面擁有超過十年的經驗。他是一位解決方案架構師，參與了許多不同商業領域的企業專案，如教育、酒店、零售、製造、行銷等，這使他在商業和技術經驗之間取得了完美的平衡。

目錄大綱

Table of Contents

  1. Introduction to SQL
  2. Manipulating Data
  3. Database Normalization
  4. The SELECT Statement
  5. Shaping Data with the WHERE Clause
  6. JOINS
  7. Taking Queries to the Next Level
  8. SQL Programming
  9. Security
  10. Aggregate Functions
  11. Functions and Transactions

目錄大綱(中文翻譯)

Table of Contents


  1. Introduction to SQL

  2. Manipulating Data

  3. Database Normalization

  4. The SELECT Statement

  5. Shaping Data with the WHERE Clause

  6. JOINS

  7. Taking Queries to the Next Level

  8. SQL Programming

  9. Security

  10. Aggregate Functions

  11. Functions and Transactions

類似商品