Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012

Kalman Toth

  • 出版商: CreateSpace Independ
  • 出版日期: 2013-01-09
  • 售價: $1,400
  • 貴賓價: 9.5$1,330
  • 語言: 英文
  • 頁數: 820
  • 裝訂: Paperback
  • ISBN: 1481944770
  • ISBN-13: 9781481944779
  • 相關分類: MSSQLSQL
  • 海外代購書籍(需單獨結帳)

商品描述

Earn $120K+ as a Microsoft database designer and/or developer! Sky is the limit when you become an SQL database professional. 200 practice questions to prepare & pass Microsoft exam 70-461: Querying Microsoft SQL Server 2012! Study this book to perform to excellence as a database developer! The exam text book follows the official Microsoft exam guidelines. The book features over 200 practice exam questions & answers. Once you learn the book, very likely you pass the exam effortlessly. SQL (Structured Query Language) programming & relational database design 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. The book has special orientation for passing Exam 70-461. 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 & stored procedures; 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. There is a chapter dedicated to the new programming features of SQL Server 2012 and XML. 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, "Charlie, 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. SQL Server 2012 installation instructions with screenshots are included. Mastery of the database design & SQL programming book likely to be sufficient for career advancement as a database designer and database developer.

商品描述(中文翻譯)

成為一名微軟資料庫設計師和/或開發人員,年薪可達12萬美元以上!當您成為SQL資料庫專業人員時,天空就是極限。本書提供200道練習問題,以準備並通過微軟70-461考試:查詢Microsoft SQL Server 2012!通過學習本書,成為卓越的資料庫開發人員!本書遵循官方微軟考試指南。本書提供超過200道練習考試問題和答案。一旦您學會了本書,很有可能輕鬆通過考試。這本書是針對開發人員、程式設計師、系統分析師和專案經理等對關聯式資料庫和客戶/伺服器技術不熟悉的人士的SQL(結構化查詢語言)編程和關聯式資料庫設計的實例和範例教學書籍。同樣適用於對SQL編程和資料庫設計有一定了解的資料庫開發人員、資料庫設計師和資料庫管理員(DBA),以及希望更新和擴展其關聯式資料庫管理系統設計和開發技術視野的人士。本書特別針對通過70-461考試進行了定向指導。假設讀者至少熟悉一種電腦編程語言、Windows檔案系統和Excel。由於本書以職業發展為導向,其中包含了大量的3NF資料庫設計實例,並附有元數據解釋,以及實用的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查詢和存儲過程來教授如何以非常高的層次思考,專注於基於集合的操作,而不是像程序編程語言中的循環。書中還有一章專門介紹SQL Server 2012和XML的新編程功能。掌握T-SQL編程的最佳方法是在自己的SQL Server Management Studio查詢編輯器中輸入查詢,測試、檢查、更改和學習。只是複製和粘貼會更容易嗎?確實如此,但學習價值會迅速降低。您需要將關聯式資料庫設計和SQL語言融入您的DNA中。SQL查詢必須從您的手指流淌到鍵盤上。為什麼熟記SQL查詢如此重要?畢竟,一切都可以在網上找到,為什麼不只是複製和粘貼?嗯,不完全是這樣。如果您想成為一名資料庫設計師和開發專家,它必須存在於您的頭腦中,而不是在網上。其次,當您的主管在您的肩膀上看著您時,“查理,你能告訴我三月份的總收入是多少嗎?”您必須能夠在沒有文件或SQL論壇搜索的情況下輸入查詢並迅速向上級提供結果。本書設計成在任何環境中都可閱讀,即使在海灘上,無論是帶著筆記型電腦還是根本沒有筆記型電腦。所有查詢都附有結果行數和/或完整/部分結果的表格(網格)格式。處理SQL Server Management Studio等GUI工具時使用屏幕截圖。書中還包含了SQL Server 2012的安裝說明和屏幕截圖。掌握資料庫設計和SQL編程的技能可能足以實現作為資料庫設計師和開發人員的職業發展。