相關主題
商品描述
This book introduces you to the field of relational database development and usage. There are many good books in this field. This book is different. It covers the basics so that beginners can read cover to cover. It is not a book for all levels of readers. For example, this book uses Microsoft SQL Server and Transact-SQL (or T-SQL). It will not mention the different dialect of Oracle or MySQL. If you are interested in Oracle or MySQL, you should use a different book. If you learned SQL Server from this book at your institution and you need to use other DBMS in your future job, the knowledge is only one Google away. This is not a reference book. For example, there are multiple ways to use aliases in T-SQL, but we only use one way. We believe that it is pretty easy to know different ways of using aliases once you finish this book. Why introduce all the different ways of using aliases for the first timer?This book is also unique with over 100 SQL examples and exercises. Most of these examples and exercises are paired. Readers learn one SQL example and can find a corresponding SQL exercise. We believe you have to write the codes in order to show you understood this book. You won't complete this book in 24 hours or 7 days.Even though the book is simple, by the end of the book, readers will be able to apply the knowledge learned to real world projects. We include one project with the detailed process of developing the database and the SQL examples of using the database. This book also includes three case studies readers can practice. This book uses a custom database which is simple with very limited data. The advantage of this approach is that you can manually find the solution before you write the SQL statement (Appendix 2 provides all data of the database). For example, if the question asks for the highest priced deliveries product, you can manually go to Appendix 2 of the book and find the product before you write the SQL statement.Please use Amazon's preview to take a look of the book before purchasing.
The third edition includes 343 review questions. We are grateful to Dr. Youlong Zhuang for reviewing this edition.
商品描述(中文翻譯)
這本書介紹了關聯式資料庫的開發與使用領域。這個領域有許多優秀的書籍，但這本書有所不同。它涵蓋了基礎知識，讓初學者可以從頭到尾閱讀。這不是一本適合所有讀者的書。例如，本書使用 Microsoft SQL Server 和 Transact-SQL（或 T-SQL），不會提及 Oracle 或 MySQL 的不同方言。如果你對 Oracle 或 MySQL 感興趣，應該參考其他書籍。如果你在學校學習了 SQL Server，並且未來的工作需要使用其他資料庫管理系統（DBMS），那麼相關知識只需 Google 一下即可。這不是一本參考書。例如，在 T-SQL 中有多種使用別名的方法，但我們只使用一種。我們相信，一旦你完成這本書，了解不同使用別名的方法會變得相當簡單。為什麼要為第一次接觸的人介紹所有不同的別名使用方法呢？
這本書還獨特地提供了超過 100 個 SQL 範例和練習。這些範例和練習大多是成對的。讀者學習一個 SQL 範例後，可以找到相應的 SQL 練習。我們相信，必須寫出程式碼才能證明你理解了這本書。你不會在 24 小時或 7 天內完成這本書。儘管這本書簡單，但到書的結尾，讀者將能夠將所學知識應用於實際專案。我們包含了一個專案，詳細說明了開發資料庫的過程以及使用該資料庫的 SQL 範例。本書還包括三個案例研究，供讀者練習。這本書使用了一個自訂的資料庫，資料量非常有限。這種方法的優點在於，你可以在撰寫 SQL 語句之前手動找到解決方案（附錄 2 提供了資料庫的所有數據）。例如，如果問題要求找出價格最高的交付產品，你可以手動查閱書的附錄 2，找到該產品，然後再撰寫 SQL 語句。請在購買前使用 Amazon 的預覽功能查看這本書。
第三版包含 343 個複習問題。我們感謝 Dr. Youlong Zhuang 對本版的審閱。
