وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Implementing a Data Warehouse with SQL Server 2022

سرفصل های دوره

Data warehouses solve fundamentally different problems than a traditional transactional database, and SQL Server Data Warehouses provide a different model for storing valuable data. In this course, database expert Adam Wilbert guides you through the process of developing data warehouses in SQL Server 2022 to provide a robust, trustworthy platform to serve all your business intelligence reporting and analysis workloads. Explore data warehouse foundations, then get started creating a data warehouse in SQL Server. Learn about columnstore indexes, as well as how to automate the tasks associated with integrating multiple data sources together into a warehouse. Find out how to implement an Azure Synapse Analytics Dedicated SQL Pool and enforce data quality using Data Quality Services. Discover ways to use Master Data Services, plus learn how to consume data from your warehouse with business intelligence applications.


01 - Introduction
  • 01 - Storing information in a data warehouse
  • 02 - What you should know
  • 03 - Set up the example databases

  • 02 - 1. Data Warehouse Foundations
  • 04 - Data warehouse core concepts
  • 05 - Transactional DBs vs. data warehouses
  • 06 - Dimensions and facts
  • 07 - Star and snowflake schemas
  • 08 - Hardware and infrastructure

  • 03 - 2. Create a Data Warehouse
  • 09 - Create a data warehouse in SQL Server
  • 10 - Design dimension tables
  • 11 - Design fact tables
  • 12 - Create an indexed view

  • 04 - 3. Columnstore Indexes
  • 13 - Advantages of columnstore indexes
  • 14 - Memory-optimized columnstore table
  • 15 - Rebuild columnstore indexes

  • 05 - 4. Extract, Transform, and Load
  • 16 - What are ETL and SSIS
  • 17 - Understand data flow
  • 18 - Establish control flow

  • 06 - 5. Implement an Azure Synapse Analytics Dedicated SQL Pool
  • 19 - Hosting a DW in the cloud
  • 20 - Create a dedicated SQL Pool
  • 21 - Reserve resources with workload isolation groups
  • 22 - Classify workloads
  • 23 - Load data into a staging table
  • 24 - Pause and remove resources in Azure

  • 07 - 6. Enforce Data Quality
  • 25 - SQL Server Data Quality Services
  • 26 - Cleanse data with DQS
  • 27 - Create a custom knowledge base

  • 08 - 7. Master Data Services
  • 28 - Introduction to Master Data Services
  • 29 - Install MDS and IIS
  • 30 - Configure Master Data Services
  • 31 - Deploy a sample MDS model
  • 32 - Install the MDS Excel add-in
  • 33 - Update master data in Excel

  • 09 - 8. Consume Data from the Warehouse
  • 34 - Business intelligence applications

  • 10 - Conclusion
  • 35 - Next steps
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 8439
    حجم: 388 مگابایت
    مدت زمان: 157 دقیقه
    تاریخ انتشار: 8 فروردین 1402
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید