Beginner SQL Programming Using Microsoft SQL Server 2014

Learn Microsoft SQL Server 2014 Programming! Beginning yet practical SQL (Structured Query Language) programming teach-by-practical-diagrams-&-examples illustrated book for database 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 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 practical SQL queries (over 1,100 SELECT queries) and T-SQL scripts, plenty to learn indeed. The 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. The book teaches through vivid 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 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 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 2014 installation, new programming functions, data export and data import presented step by step. Mastery of SQL programming book likely to be sufficient for career advancement as a database developer. SQL Server 2014 programming builds on achievements of decades in advanced relational database technology. Among the new SQL Server 2014 features is prominent: in-memory OLTP tables. Disk was always the slowest part of the computer system. Since memory is abundant, it is logical to place tables into memory to gain in performance. Programming SQL Server 2014 is fun due to the host of marvelous tools available for the developer in SQL Server Management Studio and Visual Studio. Graphical query designer, for example, helps the developer to develop the JOIN structure of a complex query. SQL Server 2014 provides a highly productive environment for database software development.

學習 Microsoft SQL Server 2014 程式設計！這本書是一本以實例圖解和範例教學為主的 SQL（結構化查詢語言）程式設計入門書籍，適合剛接觸關聯式資料庫和客戶端/伺服器技術的資料庫開發人員、程式設計師、系統分析師和專案經理閱讀。同樣適合已經具備一定 SQL 程式設計和資料庫設計知識的資料庫開發人員、資料庫設計師和資料庫管理員（DBA），他們希望更新和擴展他們的關聯式資料庫管理系統（RDBMS）開發技術視野。書中假設讀者對至少一種電腦程式語言、Windows 檔案系統和 Excel 有一定的熟悉程度。由於本書以職業發展為導向，所以提供了大量實用的 SQL 查詢（超過 1,100 個 SELECT 查詢）和 T-SQL 腳本，讓讀者有很多學習的機會。這些查詢是基於歷史和當前的 SQL Server 範例資料庫：pubs（主鍵 9 個，外鍵 10 個）、Northwind（主鍵 13 個，外鍵 13 個）和最新的 AdventureWorks 系列。其中包括：AdventureWorks、AdventureWorks2008、AdventureWorks2012（主鍵 71 個，外鍵 90 個）和 AdventureWorksDW2012（主鍵 27 個，外鍵 44 個）。最後一個是一個資料倉儲資料庫。本書通過生動的 T-SQL 查詢教授如何以集合為基礎進行高層次思考，專注於集合操作而不是像程序式程式設計語言中的迴圈。掌握 T-SQL 程式設計的最佳方法是在自己的 SQL Server Management Studio 查詢編輯器中輸入、測試、檢查、修改和學習查詢。只要複製和貼上就可以更容易嗎？是的，但學習價值會迅速減少。你需要將 SQL 語言融入你的血液中。SQL 查詢必須從你的手指流入鍵盤。為什麼要熟記 SQL 查詢如此重要？畢竟，網上可以找到一切，為什麼不只是複製和貼上呢？嗯，不完全是這樣。如果你想成為一個資料庫開發專家，它必須存在於你的頭腦中，而不是在網上。其次，當你的主管在你肩膀上看著你時，“Charlie，你能告訴我三月份的總收入是多少嗎？”你必須能夠在沒有文件或 SQL 論壇搜索的情況下輸入查詢並迅速向上級提供結果。本書設計成在任何環境下都可閱讀，即使在海灘上，無論是帶著筆記型電腦還是根本沒有筆記型電腦。所有查詢都附有結果行數和/或以表格（網格）格式列出的完整/部分結果。在處理 SQL Server Management Studio 等圖形化工具時，使用屏幕截圖。逐步介紹了 SQL Server 2014 的安裝、新的程式設計函數、資料匯出和資料匯入。掌握 SQL 程式設計的能力可能足以在職業發展中成為一名資料庫開發人員。SQL Server 2014 程式設計建立在數十年的先進關聯式資料庫技術成果之上。其中一個新的 SQL Server 2014 功能是突出的：內存 OLTP 表。磁碟一直是電腦系統中最慢的部分。由於內存充足，將表格放入內存中以提高性能是合乎邏輯的。SQL Server 2014 的程式設計之所以有趣，是因為開發人員可以使用 SQL Server Management Studio 和 Visual Studio 中提供的許多優秀工具。例如，圖形化查詢設計工具可以幫助開發人員開發複雜查詢的 JOIN 結構。SQL Server 2014 為資料庫軟體開發提供了一個高效的環境。