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: 268.28

Cena netto: 255.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
MCSA Windows Server 2016 Cert Guide Library (Exams 70-740, 70-741, and 70-742)
MCSA 70-697 and 70-698 Cert Guide: Configuring Windows Devices; Installing and Configuring Windows 10
CompTIA Project+ Cert Guide: Exam PK0-004
CNA Certified Nursing Assistant Exam Cram, 2nd Edition
CompTIA Cybersecurity Analyst (CSA+) Cert Guide
Scaling Networks v6 Course Booklet
Cisco ISE for BYOD and Secure Unified Access, 2nd Edition
Zestaw Szkoleniowy (Egzaminy 70-740, 70-741, 70-742, 70-744): Windows Server 2016
MCSA 70-742 Cert Guide: Identity with Windows Server
CCNA Cyber Ops SECOPS 210-255 Official Cert Guide
Więcej produktów
Regulamin  |  Koszty wysyłki  |  Polityka prywatności  |  Pomoc  |  Kontakt