| 书目名称 | Leveling Up with SQL | | 副标题 | Advanced Techniques | | 编辑 | Mark Simon | | 视频video | | | 概述 | Real-world case studies illuminate each topic.Focuses on standard SQL, with code samples to cover five popular DBMSs.Links SQL skills with database design to show how design affects how you approach y | | 图书封面 |  | | 描述 | .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 indivi | | 出版日期 | Book 2023 | | 关键词 | database; PostgreSQL; Oracle; MySQL; MariaDB; SQLite; SQL | | 版次 | 1 | | doi | https://doi.org/10.1007/978-1-4842-9685-1 | | isbn_softcover | 978-1-4842-9684-4 | | isbn_ebook | 978-1-4842-9685-1 | | copyright | Mark Simon 2023 |
The information of publication is updating
|
|
发表于 2025-3-21 18:29:59
