• views: 354
• date: 8 May 2022
• posted by: voska89

Genre: eLearning | Language: English + srt | Duration: 97 lectures (9h 14m) | Size: 3.58 GB
Design and implement an SQL data warehouse
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
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
Homepage

https://www.udemy.com/course/sqletldata-warehouse-developer-ms-sql-ssis-ssrs-ssas/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.