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

1. SQL Server Setup

1. Introduction

2. What is SQL Server

3. SQL Server Edition

4. SQL Server Installation Requirements

5. Note.html

6. Download SQL Server

7. Install SQL Server

8. Install SSMS

9. Connect SSMS to SQL Server

10. Install adventureworksDatabase

11. Install adventureworksDWDatabase

2. Microsoft -SQL (T-SQL ) Essentials

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

2. Introduction to stored procedures

3. Creating stored procedures

4. Modifying stored procedures

5. Properties page of a stored procedure

6. Viewing dependencies of a stored procedure

7. Deleting a stored procedure

8. Viewing the definition of a stored procedure

3. Visual Studio Setup

1. What is Visual Studio

2. Visual Studio installation requirements

3. Install Visual Studio

4. Visual studio workloads

5. Install SQL Server Data Tools

6. Install SSDT Designer Templates

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

1. What is SSIS.html

2. What is ETL

3. ETLSSIS Overview.html

4. Create SSIS Package

5. SSIS Designer

6.1 SampleCurrencyData.txt

6. Add and configure a flat file connection manager

7. Remapping Column Data Types

8. Add and configure an OLE DB Connection manager

9. Add a data flow task to package

10. Add and configure the flat file source

11.1 lookupsqlquery.txt

11. Add and configure the lookup transformations

12. Add and configure Lookup for datekey transformations

13. Add and configure the OLE DB destination

14. Test SSIS Package

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

1. Introduction to SSRS.html

2. Create a report server project

3. Create a report definition file

4. Configure a data source for the report

5.1 SQL+Script.txt

5. Define a dataset for the report

6. Add a table to the report

7. Format the report

8. Group data in report

9. Adding totals to the report

10. Previewing the report

11. Exporting the report

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

1. What is SSAS.html

2. Install SSAS

3. Connect to SSAS

4. Creating a Tabular model project

5. Explore tabular model authoring

6. Create a connection to data source

7. Transform and import data

8. Mark as data table

9. Create table relationships

10.1 DAX+Formulas.txt

10. Create calculated columns Part 1

11. Create calculated columns Part 2

12.1 Creating+measures++Part+1.txt

12. Creating measures Part 1

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

13. Creating measures Part 2

14.1 CUSTOM+MEASURES.xlsx

14. Creating measures Part 3

15.1 Create+Key+Performance+Indicators.txt

15. Create key performance indicators

16. Creating perspectives

17. Creating Hierarchies Part 1

18. Creating Hierarchies Part 2

19. What are partitions

20. Creating partitions

21. Creating Roles

22. Analyze in Excel

23. Deploying your model

24. Analyzing Model

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training