Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL/ETL/Data Warehouse Developer -(MS-SQL, SSIS, SSRS, SSAS)
Rating: 4.5 out of 5(88 ratings)
444 students

SQL/ETL/Data Warehouse Developer -(MS-SQL, SSIS, SSRS, SSAS)

Design and implement an SQL data warehouse
Last updated 3/2026
English

What you'll learn

  • Install SQL Server
  • Design Logical Data Warehouse
  • Design Physical Data Warehouse
  • Design Dimension Tables
  • Enable Database for Data Warehouse
  • Implement ETL & SSIS Solution
  • Debug SSIS Package
  • Deploy & Configure SSIS
  • Create Tabular Data Model with SSAS
  • Create reports with SSRS
  • Enforce Data Quality
  • Consume Data in a Data Warehouse

Course content

12 sections98 lectures9h 16m total length
  • Introduction0:20
  • What is a data warehouse3:06
  • Databases vs Data warehouse3:15
  • What is SQL Server2:57
  • SQL Server Editions4:45
  • SQL Server Installation Requirements4:21
  • Download SQL Server4:31
  • Install SQL Server9:43
  • Install SSMS5:48
  • Connect SSMS to SQL Server7:46
  • Install sample database6:28
  • Install sample data warehouse database5:49
  • Enable SQL Server Agent2:33
  • Enable Database settings for data warehouse6:38

Requirements

  • Basic knowledge of database concepts advised.

Description

A data warehouse is the central repository of information for data analysis, artificial intelligence, and machine learning. Data flows from different data sources like transactional databases. The data is also updated regularly to make informed decisions on time.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network .

SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading.

SQL Server Reporting Services is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS and SSIS. Administered via a Web interface, it can be used to prepare and deliver a variety of interactive and printed reports.

Microsoft SQL Server Analysis Services is an online analytical processing and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files.

ETL is a process that extracts, transforms, and loads data from multiple sources to a data warehouse or other unified data repository.

Who this course is for:

  • Beginner Data Warehouse Developers
  • Beginner SQL Developers
  • Beginner ETL Developers