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

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
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 14020
    حجم: 2047 مگابایت
    مدت زمان: 315 دقیقه
    تاریخ انتشار: 29 خرداد 1402
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید