ETL/SQL Developer Toolkit :MS SQL Server ,SSIS,ETL,SSRS,SSAS
https://FreeCourseWeb.com
Published 5/2023
Created by Digital Learning Academy
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 74 Lectures ( 5h 20m ) | Size: 2 GB
Master ETL/SQL Developer Skills: Microsoft SQL Server /SSIS /ETL/SSRS/SSAS/T-SQL
What you'll learn
The basics of ETL (extract, transform, load) concepts and data integration
Creating stored procedures using T-SQL
Using SQL Server Integration Services (SSIS) for ETL
Creating SSIS packages for data extraction, transformation, and loading
SQL Server Reporting Services (SSRS) for creating reports
Designing and building reports using SSRS
Designing efficient ETL pipelines
Data transformations, including data cleaning and data mapping
Create Tabular Data model with SSAS
Create and execute SSIS Package
Deploy SSAS Model
Requirements
Students should have a basic understanding of database concepts and SQL (Structured Query Language).
Students should have access to a computer running MS SQL Server and the SQL Server Management Studio (SSMS) software.