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.
If You Need More Stuff, kindly Visit and Support Us -->> https://DevCourseWeb.com
Get More Tutorials and Support Us -->> https://CourseWikia.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
~Get Your Files Here !/1. SQL Server Setup/1. Introduction.mp4
1.5 MB
~Get Your Files Here !/1. SQL Server Setup/10. Install adventureworksDatabase.mp4
32.6 MB
~Get Your Files Here !/1. SQL Server Setup/11. Install adventureworksDWDatabase.mp4
28.9 MB
~Get Your Files Here !/1. SQL Server Setup/2. What is SQL Server.mp4
11.1 MB
~Get Your Files Here !/1. SQL Server Setup/3. SQL Server Edition.mp4
28.3 MB
~Get Your Files Here !/1. SQL Server Setup/4. SQL Server Installation Requirements.mp4
21.2 MB
~Get Your Files Here !/1. SQL Server Setup/5. Note.html
73 B
~Get Your Files Here !/1. SQL Server Setup/6. Download SQL Server.mp4
23.2 MB
~Get Your Files Here !/1. SQL Server Setup/7. Install SQL Server.mp4
62.1 MB
~Get Your Files Here !/1. SQL Server Setup/8. Install SSMS.mp4
36.6 MB
~Get Your Files Here !/1. SQL Server Setup/9. Connect SSMS to SQL Server.mp4
12.5 MB
~Get Your Files Here !/2. Microsoft -SQL (T-SQL ) Essentials/1. Overview of Microsoft SQL (T-SQL).html
2.3 KB
~Get Your Files Here !/2. Microsoft -SQL (T-SQL ) Essentials/2. Introduction to stored procedures.mp4
24.5 MB
~Get Your Files Here !/2. Microsoft -SQL (T-SQL ) Essentials/3. Creating stored procedures.mp4
52.5 MB
~Get Your Files Here !/2. Microsoft -SQL (T-SQL ) Essentials/4. Modifying stored procedures.mp4
18.9 MB
~Get Your Files Here !/2. Microsoft -SQL (T-SQL ) Essentials/5. Properties page of a stored procedure.mp4
20.9 MB
~Get Your Files Here !/2. Microsoft -SQL (T-SQL ) Essentials/6. Viewing dependencies of a stored procedure.mp4
11.5 MB
~Get Your Files Here !/2. Microsoft -SQL (T-SQL ) Essentials/7. Deleting a stored procedure.mp4
8.1 MB
~Get Your Files Here !/2. Microsoft -SQL (T-SQL ) Essentials/8. Viewing the definition of a stored procedure.mp4
19.6 MB
~Get Your Files Here !/3. Visual Studio Setup/1. What is Visual Studio.mp4
23.9 MB
~Get Your Files Here !/3. Visual Studio Setup/2. Visual Studio installation requirements.mp4
37.4 MB
~Get Your Files Here !/3. Visual Studio Setup/3. Install Visual Studio.mp4
33.4 MB
~Get Your Files Here !/3. Visual Studio Setup/4. Visual studio workloads.mp4
17.9 MB
~Get Your Files Here !/3. Visual Studio Setup/5. Install SQL Server Data Tools.mp4
22 MB
~Get Your Files Here !/3. Visual Studio Setup/6. Install SSDT Designer Templates.mp4
38.1 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/1. What is SSIS.html
2.2 KB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/10. Add and configure the flat file source.mp4
28.1 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/11. Add and configure the lookup transformations.mp4
75.3 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/11.1 lookupsqlquery.txt
775 B
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/12. Add and configure Lookup for datekey transformations.mp4
68.1 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/13. Add and configure the OLE DB destination.mp4
53.9 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/14. Test SSIS Package.mp4
12.1 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/2. What is ETL.mp4
19 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/3. ETLSSIS Overview.html
2.6 KB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/4. Create SSIS Package.mp4
11.5 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/5. SSIS Designer.mp4
14.6 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/6. Add and configure a flat file connection manager.mp4
38.8 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/6.1 SampleCurrencyData.txt
43.2 KB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/7. Remapping Column Data Types.mp4
104.1 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/8. Add and configure an OLE DB Connection manager.mp4
26 MB
~Get Your Files Here !/4. Building ETL Pipelines with SQL Server Integration Services (SSIS)/9. Add a data flow task to package.mp4
26.1 MB
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/1. Introduction to SSRS.html
1.8 KB
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/10. Previewing the report.mp4
6.7 MB
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/11. Exporting the report.mp4
5.2 MB
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/2. Create a report server project.mp4
7.9 MB
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/3. Create a report definition file.mp4
10.5 MB
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/4. Configure a data source for the report.mp4
15.2 MB
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/5. Define a dataset for the report.mp4
30.5 MB
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/5.1 SQL+Script.txt
821 B
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/6. Add a table to the report.mp4
32.5 MB
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/7. Format the report.mp4
36.7 MB
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/8. Group data in report.mp4
24.8 MB
~Get Your Files Here !/5. Creating Reports with SQL Server Reporting Services (SSRS)/9. Adding totals to the report.mp4
28.7 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/1. What is SSAS.html
1.3 KB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/10. Create calculated columns Part 1.mp4
64.7 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/10.1 DAX+Formulas.txt
1.1 KB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/11. Create calculated columns Part 2.mp4
31.3 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/12. Creating measures Part 1.mp4
51.9 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/12.1 Creating+measures++Part+1.txt
555 B
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/13. Creating measures Part 2.mp4
30.4 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/13.1 create+additional+measures+in+the+FactInternetSales+table.xlsx
10.1 KB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/14. Creating measures Part 3.mp4
27.5 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/14.1 CUSTOM+MEASURES.xlsx
9.9 KB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/15. Create key performance indicators.mp4
38.9 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/15.1 Create+Key+Performance+Indicators.txt
868 B
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/16. Creating perspectives.mp4
13.5 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/17. Creating Hierarchies Part 1.mp4
25.5 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/18. Creating Hierarchies Part 2.mp4
41.3 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/19. What are partitions.mp4
9.2 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/2. Install SSAS.mp4
44.7 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/20. Creating partitions.mp4
83 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/21. Creating Roles.mp4
48.2 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/22. Analyze in Excel.mp4
30.5 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/23. Deploying your model.mp4
22.3 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/24. Analyzing Model.mp4
34.8 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/3. Connect to SSAS.mp4
4.8 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/4. Creating a Tabular model project.mp4
10.3 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/5. Explore tabular model authoring.mp4
21.8 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/6. Create a connection to data source.mp4
14.9 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/7. Transform and import data.mp4
67 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/8. Mark as data table.mp4
13.2 MB
~Get Your Files Here !/6. Create a Tabular Model with SQL Server Analysis Services (SSAS)/9. Create table relationships.mp4
53.9 MB
~Get Your Files Here !/Bonus Resources.txt
386 B
Alternative Torrents for 'Udemy ETL SQL Developer Toolkit MS SQL Server SSISETLSSRSSSAS'.
