Używamy cookies, aby ułatwić korzystanie z Portalu. Możesz określić warunki przechowywania, dostępu do plików cookies w Twojej przeglądarce. Dowiedz się więcej.
strona główna Strona główna | Nowości | Promocje | Zapowiedzi Twoje konto | Zarejestruj | Schowek | Kontakt | Pomoc
mapa działów
Szukaj: szukanie zaawansowane
Koszyk
Książki \ Egzaminy

Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 Język: 2

978-0-7356-6609-2

Cena Brutto: 282.98

Cena netto: 269.50

Ilość:
Wersja: Drukowana
Autor Dejan Sarka, Matija Lah, Grega Jerkic
Liczba_stron 848
Wydawnictwo Microsoft Press
Data_Wydania 2013-01-01

Training Kit

Exam

70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012

Książka z grupy:

SQL Server podręcznik

Książka z serii:

Training Kit

 

    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

  1. Designing and Implementing a Data Warehouse

    1. Chapter 1 Data Warehouse Logical Design

      1. Before You Begin
      2. Lesson 1: Introducing Star and Snowflake Schemas
      3. Lesson 2: Designing Dimensions
      4. Lesson 3: Designing Fact Tables
      5. Case Scenarios
      6. Suggested Practices
      7. Answers

    2. Chapter 2 Implementing a Data Warehouse

      1. Before You Begin
      2. Lesson 1: Implementing Dimensions and Fact Tables
      3. Lesson 2: Managing the Performance of a Data Warehouse
      4. Lesson 3: Loading and Auditing Loads
      5. Case Scenarios
      6. Suggested Practices
      7. Answers

  2. Developing SSIS Packages

    1. Chapter 3 Creating SSIS Packages

      1. Before You Begin
      2. Lesson 1: Using the SQL Server Import and Export Wizard
      3. Lesson 2: Developing SSIS Packages in SSDT
      4. Lesson 3: Introducing Control Flow, Data Flow, and Connection Managers
      5. Case Scenarios
      6. Suggested Practices
      7. Answers

    2. Chapter 4 Designing and Implementing Control Flow

      1. Before You Begin
      2. Lesson 1: Connection Managers
      3. Lesson 2: Control Flow Tasks and Containers
      4. Lesson 3: Precedence Constraints
      5. Case Scenarios
      6. Suggested Practices
      7. Answers

    3. Chapter 5 Designing and Implementing Data Flow

      1. Before You Begin
      2. Lesson 1: Defining Data Sources and Destinations
      3. Lesson 2: Working with Data Flow Transformations
      4. Lesson 3: Determining Appropriate ETL Strategy and Tools
      5. Case Scenario
      6. Suggested Practices
      7. Answers

  3. Enhancing SSIS Packages

    1. Chapter 6 Enhancing Control Flow

      1. Before You Begin
      2. Lesson 1: SSIS Variables
      3. Lesson 2: Connection Managers, Tasks, and Precedence Constraint Expressions
      4. Lesson 3: Using a Master Package for Advanced Control Flow
      5. Case Scenarios
      6. Suggested Practices
      7. Answers

    2. Chapter 7 Enhancing Data Flow

      1. Before You Begin
      2. Lesson 1: Slowly Changing Dimensions
      3. Lesson 2: Preparing a Package for Incremental Load
      4. Lesson 3: Error Flow
      5. Case Scenario
      6. Suggested Practices
      7. Answers

    3. Chapter 8 Creating a Robust and Restartable Package

      1. Before You Begin
      2. Lesson 1: Package Transactions
      3. Lesson 2: Checkpoints
      4. Lesson 3: Event Handlers
      5. Case Scenario
      6. Suggested Practices
      7. Answers

    4. Chapter 9 Implementing Dynamic Packages

      1. Before You Begin
      2. Lesson 1: Package-Level and Project-Level Connection Managers and Parameters
      3. Lesson 2: Package Configurations
      4. Case Scenario
      5. Suggested Practices
      6. Answers

    5. Chapter 10 Auditing and Logging

      1. Before You Begin
      2. Lesson 1: Logging Packages
      3. Lesson 2: Implementing Auditing and Lineage
      4. Lesson 3: Preparing Package Templates
      5. Case Scenarios
      6. Suggested Practices
      7. Answers

  4. Managing and Maintaining SSIS Packages

    1. Chapter 11 Installing SSIS and Deploying Packages

      1. Before You Begin
      2. Lesson 1: Installing SSIS Components
      3. Lesson 2: Deploying SSIS Packages
      4. Case Scenarios
      5. Suggested Practices
      6. Answers

    2. Chapter 12 Executing and Securing Packages

      1. Before You Begin
      2. Lesson 1: Executing SSIS Packages
      3. Lesson 2: Securing SSIS Packages
      4. Case Scenarios
      5. Suggested Practices
      6. Answers

    3. Chapter 13 Troubleshooting and Performance Tuning

      1. Before You Begin
      2. Lesson 1: Troubleshooting Package Execution
      3. Lesson 2: Performance Tuning
      4. Case Scenario
      5. Suggested Practice
      6. Answers

  5. Building Data Quality Solutions

    1. Chapter 14 Installing and Maintaining Data Quality Services

      1. Before You Begin
      2. Lesson 1: Data Quality Problems and Roles
      3. Lesson 2: Installing Data Quality Services
      4. Lesson 3: Maintaining and Securing Data Quality Services
      5. Case Scenario
      6. Suggested Practices
      7. Answers

    2. Chapter 15 Implementing Master Data Services

      1. Before You Begin
      2. Lesson 1: Defining Master Data
      3. Lesson 2: Installing Master Data Services
      4. Lesson 3: Creating a Master Data Services Model
      5. Case Scenarios
      6. Suggested Practices
      7. Answers

    3. Chapter 16 Managing Master Data

      1. Before You Begin
      2. Lesson 1: Importing and Exporting Master Data
      3. Lesson 2: Defining Master Data Security
      4. Lesson 3: Using Master Data Services Add-in for Excel
      5. Case Scenario
      6. Suggested Practices
      7. Answers

    4. Chapter 17 Creating a Data Quality Project to Clean Data

      1. Before You Begin
      2. Lesson 1: Creating and Maintaining a Knowledge Base
      3. Lesson 2: Creating a Data Quality Project
      4. Lesson 3: Profiling Data and Improving Data Quality
      5. Case Scenario
      6. Suggested Practices
      7. Answers

  6. Advanced SSIS and Data Quality Topics

    1. Chapter 18 SSIS and Data Mining

      1. Before You Begin
      2. Lesson 1: Data Mining Task and Transformation
      3. Lesson 2: Text Mining
      4. Lesson 3: Preparing Data for Data Mining
      5. Case Scenario
      6. Suggested Practices
      7. Answers

    2. Chapter 19 Implementing Custom Code in SSIS Packages

      1. Before You Begin
      2. Lesson 1: Script Task
      3. Lesson 2: Script Component
      4. Lesson 3: Implementing Custom Components
      5. Case Scenario
      6. Suggested Practices
      7. Answers

    3. Chapter 20 Identity Mapping and De-Duplicating

      1. Before You Begin
      2. Lesson 1: Understanding the Problem
      3. Lesson 2: Using DQS and the DQS Cleansing Transformation
      4. Lesson 3: Implementing SSIS Fuzzy Transformations
      5. Case Scenario
      6. Suggested Practices
      7. Answers

  1. Appendix About the Authors

powrót
 
Produkty Podobne
Exam Ref 70-698 Installing and Configuring Windows 10, 2nd Edition
Exam Ref 70-778 Analyzing and Visualizing Data with Microsoft Power BI
Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel
Exam Ref 70-535 Architecting Microsoft Azure Solutions
Exam Ref 70-774 Perform Cloud Data Science with Azure Machine Learning
Exam Ref 70-532 Developing Microsoft Azure Solutions, 2nd Edition
Exam Ref 70-533 Implementing Microsoft Azure Infrastructure Solutions, 2nd Edition
Exam Ref 70-347 Enabling Office 365 Services, 2nd Edition
Exam Ref 70-765 Provisioning SQL Databases
Exam Ref 70-745 Implementing a Software-Definidyn DataCenter
Więcej produktów
Regulamin  |  Koszty wysyłki  |  Polityka prywatności  |  Pomoc  |  Kontakt