本來只打算考完70-461,70-462就好了,因為這二科的內容是工作上比較用的到的。 但是不考70-463就沒有MCSA認證,少了一個MCSA認證就覺得好像什麼都沒有,所以還是決定了繼續準備考70-463。 希望以最少的時間來完成這項考試,雖然對這個領域真的很陌生,但是有先前的考試經驗,應該可以應付的來才是。 以下整理一些與這個科目考試相關的資料:
試題領域
- 設計和實作資料倉儲 (11%)
- 擷取和轉換資料 (23%)
- 載入資料 (27%)
- 設定和部署 SSIS 解決方案 (24%)
- 建置資料品質解決方案 (15%)
Major Topics | Percent Weight | Sub-topics |
---|---|---|
Design and Implement a Data Warehouse | 11 |
|
Extract and Transform Data | 23 |
|
Load Data | 27 |
|
Configure and Deploy SSIS Solutions | 24 |
|
Build Data Quality Solutions | 15 |
|
AdventureWorks2012
AdventureWorks2012 範例資料庫的下載網址:
http://msftdbprodsamples.codeplex.com/releases/view/55330
AdventureWorks2012 OLTP
線上交易用的 AdventureWorks databases 有二種版本:
- AdventureWorks2012_Data.mdf : for case-insensitive
- AdventureWorks2012_CS_Data.mdf : for case-sensitive
另外也提供使用腳本安裝的版本:
- AdventureWorks 2012 OLTP Script.zip : for case-insensitive
- AdventureWorks 2012 CS OLTP Script.zip : for case-sensitive
AdventureWorksLT2012 則是精簡版的 AdventureWorks2012 .
AdventureWorks DW
AdventureWorks DW 是資料倉儲用的範例資庫,下載回來的範例資料庫檔,檔名為 AdventureWorksDW2012_Data.mdf ,安裝方法可參考以下網址:
下載與安裝 SQL Server 2012 範例程式,以 Adventure Works 資料庫為例參考書目
- [悅知]SQL Server 2012 SSIS整合服務
- Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012
- [MSDN]:SQL Server Integration Services
- [MSDN]:Integration Services (SSIS) 封裝
- [MSDN]:Integration Services 教學課程 (SSIS)
- [MSDN]:Analysis Services 教學課程 (SSAS)
- Exam material for Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463)
網誌管理員已經移除這則留言。
回覆刪除Your very own commitment to getting the message throughout came to be rather powerful and have consistently enabled employees just like me to arrive at their desired goals.
回覆刪除Web Designing Training in Chennai | Web Designing Training Institute in Chennai
SQL Server Training in Chennai | SQL Server Training Institute in Chennai
Digital Marketing Training in Chennai | Digital Marketing Training Institute in Chennai
Java Training in Chennai | Java Training Institute in Chennai
C C++ Training in Chennai | C C++ Training Institute in Chennai
Very Informative blog thank you for sharing. Keep sharing.
回覆刪除Best software training institute in Chennai. Make your career development the best by learning software courses.
rpa uipath training in chennai
Docker Training in Chennai
blue prism training in chennai