SQL/ETL/Data Warehouse Developer -(MS-SQL, SSIS, SSRS, SSAS)

Focused View

Digital Learning Academy

9:14:18

9 View

1. Microsoft SQL Server Setup

1. Introduction.mp4

00:20

2. What is a data warehouse.mp4

03:06

3. Databases vs Data warehouse.mp4

03:15

4. What is SQL Server.mp4

02:57

5. SQL Server Editions.mp4

04:45

6. SQL Server Installation Requirements.mp4

04:21

7. Download SQL Server.mp4

04:31

8. Install SQL Server.mp4

09:43

9. Install SSMS.mp4

05:48

10. Connect SSMS to SQL Server.mp4

07:46

11. Install sample database.mp4

06:28

12. Install sample data warehouse database.mp4

05:49

13. Enable SQL Server Agent.mp4

02:33

14. Enable Database settings for data warehouse.mp4

06:38

2. Install SQL Server Data Tools (SSDT)

1. What is Visual Studio.mp4

04:32

2. Installing Visual Studio.mp4

08:15

3. Installing SQL Server Data Tools (SSDT).mp4

04:09

4. Install SSDT BI Templates.mp4

06:21

3. Designing a Data Warehouse

1. Hardware Requirements for data warehouse.mp4

10:42

2. Using FTDW Sizing Tool.mp4

03:56

3. Logical design.mp4

04:14

4. Physical design Part 1.mp4

09:55

5. Physical design Part 2.mp4

11:42

6. Designing Dimension Tables.mp4

10:14

4. Implementing ETL & SSIS

1. What is ETL.mp4

02:27

2. What is SSIS.mp4

03:24

3. introduction to ETL & SSIS.mp4

02:41

4. Creating a new SSIS Project.mp4

01:41

5. Exploring data source Part 1.mp4

08:41

6.1 DataProfile.txt

6. Exploring data source Part 2.mp4

04:36

7. Introduction to control flow Part 1.mp4

09:55

8. Introduction to control flow Part 2.mp4

08:21

9.1 ResellerSales.zip

9.2 Truncate.txt

9. Implementing data flow Part 1.mp4

09:44

10. Implementing data flow Part 2.mp4

09:32

5. Debugging & Troubleshooting SSIS Package

1. Debugging SSIS Package Part 1.mp4

07:20

2. Debugging SSIS Package Part 2.mp4

06:53

3. Logging SSIS Package events.mp4

10:18

4.1 ResellerSalesErr.txt

4. Handling errors in SSIS Package.mp4

08:00

6. Implementing Incremental ETL

1. Introduction.mp4

05:36

2. Extracting modified data Part 1.mp4

04:53

3. Extracting modified data Part 2.mp4

07:47

4. Extracting modified data Part 3.mp4

05:28

5. Extracting modified data Part 4.mp4

07:19

6. Loading modified data Part 1.mp4

07:31

7. Loading modified data Part 2.mp4

07:25

8. Working with slowly changing dimensions.mp4

07:38

7. Deploying & Configuring SSIS

1. Integration services catalogs.mp4

08:19

2. Deploying SSIS Solutions.mp4

11:52

3. Executing a package with SQL Server.mp4

10:58

4. Configuring advanced SSIS Settings.mp4

05:19

8. Enforcing Data Quality

1. Installing Data Quality Services.mp4

12:05

2.1 Regions.csv

2. Cleansing data with data quality services.mp4

11:27

3.1 Customers.csv

3. Finding duplicate data with data quality services Part 1.mp4

11:11

4. Finding duplicate data with data quality services Part 2.mp4

09:07

5. Using data quality services in SSIS Data Flow.mp4

09:34

9. Creating Reports with SQL Server Reporting Services

1. What is SSRS.mp4

00:30

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 report.mp4

04:51

6. Add a table to report.mp4

03:33

7. Format report.mp4

04:43

8. Grouping data in report.mp4

03:50

9. Adding totals to the report.mp4

04:38

10. Previewing report.mp4

00:54

11. Exporting report.mp4

00:49

10. Create & Analyze Model with SQL Server Analysis Services - SSAS

1. What is SSAS.mp4

00:25

2. Installing SSAS.mp4

08:07

3. Connecting to SSAS.mp4

01:27

4. Create 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 & 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. Create Key Performance Indicators.mp4

05:00

16. Create Perspectives.mp4

02:07

17. Create Hierarchies Part 1.mp4

03:19

18. Create 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. Deploy your model.mp4

03:11

24. Analyze Model.mp4

06:46

11. Consuming Data in a Data Warehouse

1. Introduction to Business Intelligence.mp4

04:15

2. Create a report with SSRS.mp4

01:56

3. Using Reporting services with Data Warehouse Part 1.mp4

08:12

4. Using Reporting services with Data Warehouse Part 2.mp4

07:00

5. Creating new SSAS Project.mp4

01:36

6. Data Analysis with SSAS Part 1.mp4

09:27

7. Data Analysis with SSAS Part 2.mp4

05:13

Description

Design and implement an SQL data warehouse

What You'll Learn?

Install SQL Server
Design Logical Data Warehouse
Design Physical Data Warehouse
Design Dimension Tables
Enable Database for Data Warehouse
Implement ETL & SSIS Solution
Debug SSIS Package
Deploy & Configure SSIS
Create Tabular Data Model with SSAS
Create reports with SSRS
Enforce Data Quality
Consume Data in a Data Warehouse

Who is this for?

Beginner Data Warehouse Developers

Beginner SQL Developers

Beginner ETL Developers

What You Need to Know?

Basic knowledge of database concepts advised.

More details

Description
A data warehouse is the central repository of information for data analysis, artificial intelligence, and machine learning. Data flows from different data sources like transactional databases. The data is also updated regularly to make informed decisions on time.
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applicationsâ€”which may run either on the same computer or on another computer across a network .
SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading.
SQL Server Reporting Services is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS and SSIS. Administered via a Web interface, it can be used to prepare and deliver a variety of interactive and printed reports.
Microsoft SQL Server Analysis Services is an online analytical processing and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files.
ETL is a process that extracts, transforms, and loads data from multiple sources to a data warehouse or other unified data repository.
Who this course is for:
Beginner Data Warehouse Developers
Beginner SQL Developers
Beginner ETL 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.