Implementing a Data Warehouse with Microsoft SQL Server 2012: Training Kit: Exam 70-463 - Brossura

Sarka, Dejan; Lah, Matija; Jerkic, Grega

Brossura

ISBN 10: 0735666091 ISBN 13: 9780735666092

Casa editrice: Microsoft Pr, 2012

Riassunto

Ace your preparation for Microsoft® Certification Exam 70-463 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests-featuring multiple, customizable testing options.

Maximize your performance on the exam by learning how to:

• Design and implement a data warehouse
• Develop and enhance SQL Server Integration Services packages
• Manage and maintain SQL Server Integration Services packages
• Build data quality solutions
• Implement custom code in SQL Server Integration Services packages

Su questo libro

L'autore:

Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.

Matija Lah is an independent consultant in the general and legal information management domains. Data warehousing represents an essential data management element in practically any business domain and Matija has had the opportunity to solve a variety of data warehousing problems since he started working with data warehouses in 2001. He is one of the authors in the popular book series SQL Server MVP Deep Dives. He is a frequent speaker at conferences related to Microsoft technologies, particularly those dedicated to Microsoft SQL Server. Matija has been a Microsoft Most Valuable Professional for SQL Server since 2007, and is a mentor at SolidQ, a trusted global provider of advanced consulting, mentoring and education solutions for the Microsoft platforms.

Grega Jerkic is an independent consultant and trainer for SolidQ. For the last 12 years, he has been developing, architecting, and managing projects focusing on data warehousing, MDM, data integration, analytical/planning solutions and predictive analytics--primarily using Microsoft technology. He invented and was lead architect for a predefined business intelligence solution on top of ERP Microsoft Dynamics NAV – BI4Dynamics, which is now used worldwide by more than 150 clients and has earned two Microsoft awards for best business intelligence solution for the CEE region. Grega currently provides training and mentoring for the Microsoft BI platform around the world (Microsoft FastTrack DW workshops, Enterprise ETL with SQL 2005/2008, MDX, Advanced PowerPivot, Microsoft SQL 2008 R2 technical workshops, etc).

Contenuti:

Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012IntroductionDesigning and Implementing a Data WarehouseChapter 1: Data Warehouse Logical DesignChapter 2: Implementing a Data WarehouseDeveloping SSIS PackagesChapter 3: Creating SSIS PackagesChapter 4: Designing and Implementing Control FlowChapter 5: Designing and Implementing Data FlowEnhancing SSIS PackagesChapter 6: Enhancing Control FlowChapter 7: Enhancing Data FlowChapter 8: Creating a Robust and Restartable PackageChapter 9: Implementing Dynamic PackagesChapter 10: Auditing and LoggingManaging and Maintaining SSIS PackagesChapter 11: Installing SSIS and Deploying PackagesChapter 12: Executing and Securing PackagesChapter 13: Troubleshooting and Performance TuningBuilding Data Quality SolutionsChapter 14: Installing and Maintaining Data Quality ServicesChapter 15: Implementing Master Data ServicesChapter 16: Managing Master DataChapter 17: Creating a Data Quality Project to Clean DataAdvanced SSIS and Data Quality TopicsChapter 18: SSIS and Data MiningChapter 19: Implementing Custom Code in SSIS PackagesChapter 20: Identity Mapping and De-DuplicatingAbout the Authors

Su questa edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2012
• ISBN 10: 0735666091
• ISBN 13: 9780735666092
• Rilegatura: Copertina flessibile
• Numero di pagine: 812