Etl/Sql Developer Toolkit :Ms Sql Server ,Ssis,Etl,Ssrs,Ssas

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.

Description

The ETL/SQL Developer Toolkit is an essential set of tools and techniques for building efficient and scalable ETL pipelines using Microsoft SQL Server. This comprehensive training program covers all the core components of the ETL/SQL Developer Toolkit, including MS SQL Server, SSIS, ETL, SSRS, and SSAS. The course is designed to provide developers and data professionals with the skills and knowledge they need to design, develop, and deploy complex ETL solutions using Microsoft SQL Server. Students will then learn how to use create stored procedures using  T-SQL, which is a powerful language used for managing and manipulating data in SQL Server databases. The course covers core components of the ETL/SQL Developer Toolkit, beginning with SQL Server Integration Services (SSIS). Students will learn how to create SSIS packages for data extraction, transformation, and loading.The course covers  how to create reports with SQL Server Reporting Services (SSRS). Students will learn how to design and build reports using SSRS, and explore features like publishing and deploying reports in SQL Server.The course also covers SQL Server Analysis Services (SSAS), which is used for designing and developing Tabular models. Students will learn how to create a Tabular model using SSAS .Overall, this course provides a comprehensive overview of the ETL/SQL Developer Toolkit, covering all the essential components and best practices for developing efficient ETL pipelines using MS SQL Server. Whether you're a data professional, developer, or IT professional, this course is an essential step towards mastering ETL development with Microsoft SQL Server.

Overview

Section 1: SQL Server Setup

Lecture 1 Introduction

Lecture 2 What is SQL Server

Lecture 3 SQL Server Edition

Lecture 4 SQL Server Installation Requirements

Lecture 5 Note

Lecture 6 Download SQL Server

Lecture 7 Install SQL Server

Lecture 8 Install SSMS

Lecture 9 Connect SSMS to SQL Server

Lecture 10 Install adventureworksDatabase

Lecture 11 Install adventureworksDWDatabase

Section 2: Microsoft -SQL (T-SQL ) Essentials

Lecture 12 Overview of Microsoft SQL (T-SQL)

Lecture 13 Introduction to stored procedures

Lecture 14 Creating stored procedures

Lecture 15 Modifying stored procedures

Lecture 16 Properties page of a stored procedure

Lecture 17 Viewing dependencies of a stored procedure

Lecture 18 Deleting a stored procedure

Lecture 19 Viewing the definition of a stored procedure

Section 3: Visual Studio Setup

Lecture 20 What is Visual Studio

Lecture 21 Visual Studio installation requirements

Lecture 22 Install Visual Studio

Lecture 23 Visual studio workloads

Lecture 24 Install SQL Server Data Tools

Lecture 25 Install SSDT Designer Templates

Section 4: Building ETL Pipelines with SQL Server Integration Services (SSIS)

Lecture 26 What is SSIS

Lecture 27 What is ETL

Lecture 28 ETL/SSIS Overview

Lecture 29 Create SSIS Package

Lecture 30 SSIS Designer

Lecture 31 Add and configure a flat file connection manager

Lecture 32 Remapping Column Data Types

Lecture 33 Add and configure an OLE DB Connection manager

Lecture 34 Add a data flow task to package

Lecture 35 Add and configure the flat file source

Lecture 36 Add and configure the lookup transformations

Lecture 37 Add and configure Lookup for datekey transformations

Lecture 38 Add and configure the OLE DB destination

Lecture 39 Test SSIS Package

Section 5: Creating Reports with SQL Server Reporting Services (SSRS)

Lecture 40 Introduction to SSRS

Lecture 41 Create a report server project

Lecture 42 Create a report definition file

Lecture 43 Configure a data source for the report

Lecture 44 Define a dataset for the report

Lecture 45 Add a table to the report

Lecture 46 Format the report

Lecture 47 Group data in report

Lecture 48 Adding totals to the report

Lecture 49 Previewing the report

Lecture 50 Exporting the report

Section 6: Create a Tabular Model with SQL Server Analysis Services (SSAS)

Lecture 51 What is SSAS

Lecture 52 Install SSAS

Lecture 53 Connect to SSAS

Lecture 54 Creating a Tabular model project

Lecture 55 Explore tabular model authoring

Lecture 56 Create a connection to data source

Lecture 57 Transform and import data

Lecture 58 Mark as data table

Lecture 59 Create table relationships

Lecture 60 Create calculated columns: Part 1

Lecture 61 Create calculated columns: Part 2

Lecture 62 Creating measures: Part 1

Lecture 63 Creating measures: Part 2

Lecture 64 Creating measures: Part 3

Lecture 65 Create key performance indicators

Lecture 66 Creating perspectives

Lecture 67 Creating Hierarchies: Part 1

Lecture 68 Creating Hierarchies: Part 2

Lecture 69 What are partitions

Lecture 70 Creating partitions

Lecture 71 Creating Roles

Lecture 72 Analyze in Excel

Lecture 73 Deploying your model

Lecture 74 Analyzing Model

Database Administrators (DBAs),Business Intelligence (BI) Developers,Data Analysts,Data Scientists,ETL Developers,Software Developers,System Architects,IT Managers,Project Managers,Data Warehouse Developers