商品描述
Microsoft SQL training book for developers & programmers in designing databases and programming solutions with the Transact-SQL language. The T-SQL language required a different mindset from developers than the procedural programming languages such as C, C++, C# and Visual Basic. The developer has to learn to think in term of sets not loops. Relational database design & SQL (Structured Query Language) programming teach-by-practical-diagrams-&-examples book for developers, programmers, systems analysts and project managers who are new to relational database and client/server technologies. Also for database developers, database designers and database administrators (DBA), who know some SQL programming and database design, and who wish to refresh & expand their RDBMS design & development technology horizons. Familiarity with at least one computer programming language, Windows file system & Excel is assumed. Since the book is career advancement oriented, it has a great number of 3NF database design examples with metadata explanations along with practical SQL queries (over 1,400 SELECT queries) and T-SQL scripts, plenty to learn indeed. Great emphasis is placed on explaining the FOREIGN KEY - PRIMARY KEY constraints among tables, the connections which make the collection of individual tables a database. The database diagrams and queries are based on historic and current SQL Server sample databases: pubs (PRIMARY KEYs 9, FOREIGN KEYs 10) , Northwind (PRIMARY KEYs 13, FOREIGN KEYs 13) and the latest AdventureWorks series. Among them: AdventureWorks, AdventureWorks2008, AdventureWorks2012 (PRIMARY KEYs 71, FOREIGN KEYs 90), & AdventureWorksDW2012 (PRIMARY KEYs 27, FOREIGN KEYs 44). The last one is a data warehouse database which is the basis for multi-dimensional OLAP cubes. Sample databases installation instructions are included. The book teaches through vivid database diagrams and T-SQL queries how to think in terms of sets at a very high level, focusing on set-based operations instead of loops like in procedural programming languages. The best way to master T-SQL programming is to type the query in your own SQL Server Management Studio Query Editor, test it, examine it, change it and study it. Wouldn't it be easier just to copy & paste it? It would, but the learning value would diminish rapidly. You need to feel relational database design and the SQL language in your DNA. SQL queries must "pour" out from your fingers into the keyboard. Why is knowing SQL queries by heart so important? After all everything can be found on the web so why not just copy & paste? Well not exactly. If you want to be an database designer & development expert, it has to be in your head not on the web. Second, when your supervisor is looking over your shoulder, "Bill, can you tell me what is the total revenue for March?", you have to be able to type the query without documentation or SQL forum search and provide the results to your superior promptly. The book was designed to be readable in any environment, even on the beach laptop around or no laptop in sight at all. All queries are followed by results row count and /or full/partial results listing in tabular (grid) format. Screenshots are used when dealing with GUI tools such as SQL Server Management Studio. Mastery of the database design & SQL programming book likely to be sufficient for career advancement as a database designer and database developer.
商品描述(中文翻譯)
《Microsoft SQL 開發人員和程式設計師培訓書》是一本關於使用 Transact-SQL 語言設計資料庫和編程解決方案的書籍。T-SQL 語言需要開發人員以不同的思維方式來思考，與 C、C++、C# 和 Visual Basic 等程序式編程語言有所不同。開發人員必須學會以集合而非迴圈的方式思考。這本書是為新接觸關聯式資料庫和客戶端/伺服器技術的開發人員、程式設計師、系統分析師和專案經理而設計的，同時也適用於已經具備一定 SQL 編程和資料庫設計知識的資料庫開發人員、資料庫設計師和資料庫管理員（DBA），他們希望更新和擴展他們的關聯式資料庫管理系統設計和開發技術。本書假設讀者至少熟悉一種電腦編程語言、Windows 檔案系統和 Excel。由於本書的目標是職業發展，因此提供了大量的第三正規化資料庫設計示例，並附有元數據解釋，以及實用的 SQL 查詢（超過 1,400 個 SELECT 查詢）和 T-SQL 腳本，讓讀者有充分的學習資源。本書特別強調解釋表之間的外鍵-主鍵約束，這些約束將個別表集合成一個資料庫。資料庫圖表和查詢是基於歷史和當前的 SQL Server 樣本資料庫：pubs（主鍵 9，外鍵 10）、Northwind（主鍵 13，外鍵 13）和最新的 AdventureWorks 系列。其中包括：AdventureWorks、AdventureWorks2008、AdventureWorks2012（主鍵 71，外鍵 90）和 AdventureWorksDW2012（主鍵 27，外鍵 44）。最後一個是一個數據倉庫資料庫，是多維 OLAP 立方體的基礎。書中包含了示範資料庫的安裝說明。本書通過生動的資料庫圖表和 T-SQL 查詢教授如何以高層次的集合思維來思考，專注於基於集合的操作，而不是像程序式編程語言中的迴圈。掌握 T-SQL 編程的最佳方法是在自己的 SQL Server Management Studio 查詢編輯器中輸入、測試、檢查、修改和學習查詢。只是複製和貼上會更容易嗎？確實如此，但學習價值會迅速降低。你需要將關聯式資料庫設計和 SQL 語言融入你的血液中。SQL 查詢必須從你的手指流淌到鍵盤上。為什麼要熟記 SQL 查詢如此重要？畢竟，一切都可以在網上找到，為什麼不只是複製和貼上呢？嗯，不完全是這樣。如果你想成為一個資料庫設計師和開發專家，你必須將其記在腦海中，而不是依賴於網上資料。其次，當你的主管在你肩膀上看著你時，“比爾，你能告訴我三月份的總收入是多少嗎？”你必須能夠在沒有文件或 SQL 論壇搜索的情況下輸入查詢，並迅速向上級提供結果。本書設計成在任何環境下都可閱讀，即使在海灘上，無論是帶著筆記型電腦還是根本沒有筆記型電腦。所有查詢都附有結果行數和/或以表格（網格）格式列出的完整/部分結果。在處理 SQL Server Management Studio 等圖形化工具時，使用屏幕截圖。掌握資料庫設計和 SQL 編程的技能很可能足以在職業發展中成為一名資料庫設計師和開發人員。
