ETL/SQL Developer Toolkit :MS SQL Server ,SSIS,ETL,SSRS,SSAS

Focused View

Digital Learning Academy

5:14:54

174 View

1. SQL Server Setup

1. Introduction.mp4

00:20

2. What is SQL Server.mp4

02:57

3. SQL Server Edition.mp4

04:45

4. SQL Server Installation Requirements.mp4

04:21

5. Note.html

6. Download SQL Server.mp4

04:31

7. Install SQL Server.mp4

09:43

8. Install SSMS.mp4

05:48

9. Connect SSMS to SQL Server.mp4

02:16

10. Install adventureworksDatabase.mp4

06:28

11. Install adventureworksDWDatabase.mp4

05:49

2. Microsoft -SQL (T-SQL ) Essentials

1. Overview of Microsoft SQL (T-SQL).html

2. Introduction to stored procedures.mp4

08:43

3. Creating stored procedures.mp4

07:33

4. Modifying stored procedures.mp4

02:07

5. Properties page of a stored procedure.mp4

04:35

6. Viewing dependencies of a stored procedure.mp4

02:14

7. Deleting a stored procedure.mp4

01:31

8. Viewing the definition of a stored procedure.mp4

02:26

3. Visual Studio Setup

1. What is Visual Studio.mp4

04:32

2. Visual Studio installation requirements.mp4

04:27

3. Install Visual Studio.mp4

06:46

4. Visual studio workloads.mp4

03:59

5. Install SQL Server Data Tools.mp4

04:09

6. Install SSDT Designer Templates.mp4

06:21

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

1. What is SSIS.html

2. What is ETL.mp4

05:41

3. ETLSSIS Overview.html

4. Create SSIS Package.mp4

02:13

5. SSIS Designer.mp4

02:18

6.1 SampleCurrencyData.txt

6. Add and configure a flat file connection manager.mp4

06:26

7. Remapping Column Data Types.mp4

11:12

8. Add and configure an OLE DB Connection manager.mp4

03:39

9. Add a data flow task to package.mp4

05:02

10. Add and configure the flat file source.mp4

04:28

11.1 lookupsqlquery.txt

11. Add and configure the lookup transformations.mp4

11:29

12. Add and configure Lookup for datekey transformations.mp4

09:28

13. Add and configure the OLE DB destination.mp4

07:53

14. Test SSIS Package.mp4

02:02

5. Creating Reports with SQL Server Reporting Services (SSRS)

1. Introduction to SSRS.html

2. Create a report server project.mp4

02:05

3. Create a report definition file.mp4

01:56

4. Configure a data source for the report.mp4

02:32

5.1 SQL+Script.txt

5. Define a dataset for the report.mp4

04:51

6. Add a table to the report.mp4

03:33

7. Format the report.mp4

04:43

8. Group data in report.mp4

03:50

9. Adding totals to the report.mp4

04:38

10. Previewing the report.mp4

00:54

11. Exporting the report.mp4

00:49

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

1. What is SSAS.html

2. Install SSAS.mp4

08:07

3. Connect to SSAS.mp4

01:27

4. Creating a Tabular model project.mp4

02:30

5. Explore tabular model authoring.mp4

04:16

6. Create a connection to data source.mp4

02:42

7. Transform and import data.mp4

07:10

8. Mark as data table.mp4

01:34

9. Create table relationships.mp4

06:26

10.1 DAX+Formulas.txt

10. Create calculated columns Part 1.mp4

07:55

11. Create calculated columns Part 2.mp4

03:24

12.1 Creating+measures++Part+1.txt

12. Creating measures Part 1.mp4

05:47

13.1 create+additional+measures+in+the+FactInternetSales+table.xlsx

13. Creating measures Part 2.mp4

03:44

14.1 CUSTOM+MEASURES.xlsx

14. Creating measures Part 3.mp4

03:13

15.1 Create+Key+Performance+Indicators.txt

15. Create key performance indicators.mp4

05:00

16. Creating perspectives.mp4

02:07

17. Creating Hierarchies Part 1.mp4

03:19

18. Creating Hierarchies Part 2.mp4

05:31

19. What are partitions.mp4

01:51

20. Creating partitions.mp4

10:10

21. Creating Roles.mp4

07:06

22. Analyze in Excel.mp4

03:35

23. Deploying your model.mp4

03:11

24. Analyzing Model.mp4

06:46

Description

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

Who is this for?

Database Administrators (DBAs)

Business Intelligence (BI) Developers

Data Analysts

Data Scientists

ETL Developers

Software Developers

System Architects

IT Managers

Project Managers

Data Warehouse Developers

What You Need to Know?

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.

More details

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.

Who this course is for:
Database Administrators (DBAs)
Business Intelligence (BI) Developers
Data Analysts
Data Scientists
ETL Developers
Software Developers
System Architects
IT Managers
Project Managers
Data Warehouse Developers

User Reviews

Rating

average 0

Total votes0

Focused display

Digital learning academy produces bespoke elearning which helps you to effectively gain useful and marketable skills and knowledge . We work closely with you to map out exactly what you want to bring about and discover what you want to learn and achieve. We can help you learn something completely new? Working together, we can help you acquire some useful digital skills online. Our instructors are industry experts and have years of experience to deliver the training and skills you need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.