Leveling Up with SQL: Advanced Techniques for Transforming Data Into Insights (Paperback)

Learn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level.

Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL databases are designed and how to extract just the right data from them. You'll then learn about each individual table's structure and how to work with the relationships between tables. As you progress through the book, you will learn more sophisticated techniques such as using common table expressions and subqueries, analyzing your data using aggregate and windowing functions, and how to save queries in the form of views and other methods. This book employs an accessible approach to work through a realistic sample, enabling you to learn concepts as they arise to improve parts of the database or to work with the data itself.

After completing this book, you will have a more thorough understanding of database structure and how to use advanced techniques to extract, manage, and analyze data.

What Will You Learn

• Gain a stronger understanding of database design principles, especially individual tables
• Understand the relationships between tables
• Utilize techniques such as views, subqueries, common table expressions, and windowing functions

Who Is This Book For:

SQL Databases users who want to improve their knowledge and techniques.

學習撰寫 SQL 查詢以選擇和分析資料，並提升您操作資料的能力。本書將幫助您將現有技能提升到更高水平。

作者 Mark Simon 開始快速回顧基本的 SQL 知識，接著演示了高效的 SQL 資料庫設計以及如何從中提取正確的資料。然後，您將學習每個個別表格的結構以及如何處理表格之間的關係。隨著閱讀的進展，您將學習更複雜的技巧，例如使用常用表達式和子查詢，使用聚合和窗口函數分析資料，以及如何將查詢保存為視圖和其他方法。本書以易於理解的方式通過一個真實的示例進行，使您能夠在概念出現時學習，以改進資料庫的部分或直接處理資料。

閱讀完本書後，您將對資料庫結構有更深入的了解，並能夠使用高級技巧來提取、管理和分析資料。

您將學到什麼：
- 加深對資料庫設計原則的理解，特別是個別表格
- 理解表格之間的關係
- 使用視圖、子查詢、常用表達式和窗口函數等技巧
- 本書適合對 SQL 資料庫有一定了解並希望提升知識和技巧的使用者。

Mark Simon has been involved in training and education since the beginning of his career. He started as a teacher of mathematics, but quickly pivoted 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 mainly on web development and database languages. When not involved in work, you will generally find him listening to or playing music, reading, or just wandering about.

Mark Simon自從開始他的職業生涯以來，一直參與培訓和教育工作。他起初是一位數學教師，但很快轉向IT顧問和培訓，因為與高中學生相比，電腦更容易操作。他曾與多種編程語言和編碼語言合作並接受培訓，目前主要專注於網頁開發和數據庫語言。在工作之餘，你通常會發現他在聽音樂、演奏樂器、閱讀或四處遊蕩。