Data Warehousing & Business Intelligence Implementation

SQL Server 2014    |    Intermediate
  • 15 videos | 59m 43s
  • Earns a Badge
Rating 4.5 of 67 users Rating 4.5 of 67 users (67)
Data warehousing and business intelligence have become fundamental to maintaining business competitiveness. Examine what is involved in creating a SQL Server data warehouse, and how to create and deploy an SSIS package.

WHAT YOU WILL LEARN

  • Describe data warehousing
    Recognize the key concepts of business intelligence
    Recognize the function of normalization in oltp databases and denormalization in olap databases
    Describe dimension and fact tables in olap databases
    Recognize the star and snowflake schemas in data warehouse databases, and the role of kpis in business intelligence
    Create a fact table in a data warehouse database in sql server
    Create a dimension table in a data warehouse database in sql server
    Create a columnstore index in a data warehouse database in sql server
  • Create a table and index partition in a data warehouse database in sql server
    Implement data compression in a data warehouse database in sql server
    Create a simple ssis package in sql server using sql server data tools
    Create a control flow in sql server using sql server data tools
    Create a data flow in sql server using sql server data tools
    Create a transform in sql server using sql server data tools
    Deploy an ssis package in sql server

IN THIS COURSE

  • 5m
    Upon completion of this video, you will be able to describe data warehousing. FREE ACCESS
  • 4m 18s
    Upon completion of this video, you will be able to recognize the key concepts of business intelligence. FREE ACCESS
  • Locked
    3.  Normalization and Denormalization
    4m 39s
    Upon completion of this video, you will be able to recognize the function of normalization in OLTP databases and denormalization in OLAP databases. FREE ACCESS
  • Locked
    4.  Fact and Dimension Tables
    3m 48s
    After completing this video, you will be able to describe dimension and fact tables in online analytical processing databases. FREE ACCESS
  • Locked
    5.  Data Warehouse Schemas
    3m 35s
    After completing this video, you will be able to recognize the star and snowflake schemas in data warehouse databases, and the role of KPIs in business intelligence. FREE ACCESS
  • Locked
    6.  Creating a Fact Table
    4m 20s
    In this video, learn how to create a fact table in a SQL Server data warehouse database. FREE ACCESS
  • Locked
    7.  Creating a Dimension Table
    3m 2s
    During this video, you will learn how to create a dimension table in a SQL Server data warehouse database. FREE ACCESS
  • Locked
    8.  Create a Columnstore Index in SQL Server
    3m 39s
    In this video, you will create a columnstore index in a SQL Server data warehouse database. FREE ACCESS
  • Locked
    9.  Table and Index Partitioning
    5m 26s
    During this video, you will learn how to create a table and index partition in a SQL Server data warehouse database. FREE ACCESS
  • Locked
    10.  Implementing Data Compression
    3m 37s
    Learn how to implement data compression in a SQL Server data warehouse database. FREE ACCESS
  • Locked
    11.  Creating a Simple SSIS Package
    3m 53s
    In this video, learn how to create a simple SSIS package in SQL Server using SQL Server Data Tools. FREE ACCESS
  • Locked
    12.  Creating a Control Flow
    3m 28s
    In this video, you will create a control flow in SQL Server using SQL Server Data Tools. FREE ACCESS
  • Locked
    13.  Creating a Data Flow
    3m 20s
    Learn how to create a data flow in SQL Server using SQL Server Data Tools. FREE ACCESS
  • Locked
    14.  Creating a Transform
    3m 43s
    In this video, find out how to create a transformation in SQL Server using SQL Server Data Tools. FREE ACCESS
  • Locked
    15.  Deploying an SSIS Package
    3m 55s
    In this video, you will deploy an SSIS package to SQL Server. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Data Mesh in Action
Journey Data Analytics Specialist
Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Querying & Manipulating Data
Rating 4.7 of 132 users Rating 4.7 of 132 users (132)
Course Designing & Implementing Dimensions
Rating 4.5 of 13 users Rating 4.5 of 13 users (13)
Course Extract, Transform, & Load
Rating 4.5 of 71 users Rating 4.5 of 71 users (71)