Welcome - SQL Server Tutorial

Contents

• Introduction Introduction

  • Welcome

    40s
  • What you should know

    28s
  • Using the exercise files

    22s
• 1. Setting Up the Environment 1. Setting Up the Environment

  • (Locked)
    Finding and downloading SQL Server 2012 trial edition

    1m 46s
  • (Locked)
    Installing SQL Server 2012 trial edition

    5m 17s
  • (Locked)
    Finding and installing the sample data

    2m 39s
• 2. Introduction to Data Warehousing 2. Introduction to Data Warehousing

  • Overview of data warehousing

    3m 6s
  • (Locked)
    Understanding the differences between typical databases and data warehouses

    2m 13s
  • (Locked)
    Implementing a data warehouse using a SQL database engine

    3m 11s
• 3. Designing a Data Warehouse 3. Designing a Data Warehouse

  • (Locked)
    Logical design for a data warehouse

    3m 3s
  • (Locked)
    Choosing between star and snowflake schema design techniques

    3m 42s
  • (Locked)
    Physical design for a data warehouse

    8m 19s
• 4. Data Warehouse Hardware 4. Data Warehouse Hardware

  • (Locked)
    Considerations for building a data warehouse

    5m 54s
  • Data warehouse reference architectures

    2m 28s
  • (Locked)
    Appliances and big data

    4m 14s
• 5. Creating an Extract Transform and Load (ETL) Solution with SQL Server Integration Services (SSIS) 5. Creating an Extract Transform and Load (ETL) Solution with SQL Server Integration Services (SSIS)

  • (Locked)
    Introduction to ETL with SSIS

    5m 27s
  • (Locked)
    Exploring source data

    5m 57s
  • (Locked)
    Introduction to control flow

    8m 50s
  • (Locked)
    Implementing data flow

    8m 29s
• 6. Debugging and Troubleshooting SSIS Packages 6. Debugging and Troubleshooting SSIS Packages

  • (Locked)
    Debugging an SSIS package

    5m 16s
  • (Locked)
    Logging SSIS package events

    5m 34s
  • (Locked)
    Handling errors in an SSIS package

    4m 47s
• 7. Implementing an Incremental ETL Process 7. Implementing an Incremental ETL Process

  • Introduction to incremental ETL

    3m 39s
  • (Locked)
    Extracting modified data

    10m 16s
  • (Locked)
    Loading modified data

    7m 53s
  • (Locked)
    Working with slowly changing dimensions

    4m 47s
• 8. Deploying and Configuring SSIS Packages 8. Deploying and Configuring SSIS Packages

  • (Locked)
    Installing and maintaining SSIS components

    5m 8s
  • (Locked)
    Deploying SSIS solutions

    6m 21s
  • (Locked)
    Using SQL Server Agent to execute an ETL package

    7m 15s
  • (Locked)
    Configuring advanced SSIS settings

    3m 11s
• 9. Enforcing Data Quality 9. Enforcing Data Quality

  • (Locked)
    Installing Data Quality Services

    2m 55s
  • (Locked)
    Using Data Quality Services to cleanse data

    4m 34s
  • (Locked)
    Using Data Quality Services to find duplicate data

    10m 47s
  • (Locked)
    Utilizing Data Quality Services in an SSIS data flow

    5m 36s
• 10. Consuming Data in a Data Warehouse 10. Consuming Data in a Data Warehouse

  • Introduction to business intelligence

    3m 14s
  • (Locked)
    Using Reporting Services with a data warehouse

    8m 54s
  • (Locked)
    Introduction to data analysis with SQL Server Analysis Services (SSAS)

    9m 5s
• Conclusion Conclusion

  • (Locked)
    Next steps

    1m 23s