Data integration with SSIS - SQL Server Integration Services

Focused View

Expert-Only Training

10:27:23

4 View

1. Introduction to SSIS and environment set-up

1. Overview of the course.mp4

13:39

2. Introduction to BI and SSIS.mp4

15:32

3. Test your knowledge on BI , ETL and SSIS concepts.html

4.1 SQL Server download link.html

4. Download and install SQL Server 2022.mp4

16:17

5. Download and install SSMS 19.mp4

09:58

6. Download and install Visual Studio 2022 and SSIS.mp4

10:41

7. The MS BI development environment quiz.html

8. Create an SSIS solution, project and package in Visual Studio.mp4

07:03

9.1 01 create table customers.zip

9.2 02 create table customers with initials.zip

9. P01 Develop a package to copy and transform data.mp4

12:53

10. SSIS projects and package structure.html

2. Import and export Flat Files (CSV and TXT)

1. Flat files definition and key points.mp4

05:53

2.1 01 create table customers.zip

2.2 Customers Data.txt

2.3 Notepad++ Software.html

2. P02 Import a Text file into a SQL Server table.mp4

14:37

3.1 01 create table customers.zip

3. P03 Export data from SQL Server to CSV files.mp4

14:15

4. Flat files import and export.html

5.1 01 create table customers with filename.zip

5.2 Customers Data 1.csv

5.3 Customers Data 2.csv

5.4 Customers Data 3.csv

5. P04 Import multiple CSV files at once with a dynamic loop.mp4

18:20

3. Import and Export Excel files

1. Import and export Excel files.mp4

06:27

2.1 Customers Data.xlsx

2. P05 Install and test Excel Drivers.mp4

12:21

3.1 create sales table.zip

3.2 insert sales data.zip

3. P06 Export data from SQL Server to an Excel file.mp4

13:37

4. Test your Excel integration knowledge.html

5. P07 Manage Excel Sheets and Data Types in exports.mp4

15:40

6.1 create table salesbymonthyear.zip

6.2 Sales By Month Year.xlsx

6. P08 Import specific Excel cells and filter Excel data with SSIS.mp4

19:28

4. Import and export XML documents

1.1 XML page.html

1. XML Lecture introduction.mp4

09:20

2.1 create table customers.zip

2.2 Customers Data with length.txt

2.3 customers data.zip

2. P09 Import an XML document into SQL Server.mp4

12:55

3.1 create insert customers.zip

3.2 xml select queries.zip

3. P10 Export data from SQL Server to an XML document.mp4

17:07

4. XML documents and SSIS.html

5.1 create insert products.zip

5.2 insert xml data productsdetails.zip

5. P11 Export table with XML format into an XML document.mp4

14:21

5. Manage Logging, Metadata, Process and Errors

1. Introduction to Logs, Metadata, Process and Errors.mp4

09:57

2.1 01 create table products generate data.zip

2.2 02 drop create table products target.zip

2.3 03 select last execution logs.zip

2. P12 Activate and read SQL Server logging.mp4

09:00

3.1 01 create table products generate data.zip

3.2 02 SSIS XML Path Formula.txt

3. P13 Activate the log using XML dynamic file names.mp4

13:02

4.1 01 prepare ods and dwh products.zip

4.2 02 fill ods products.zip

4.3 03 select all steps.zip

4.4 04 update statement.zip

4.5 ERP Products 2023-10-01.txt

4.6 ERP Products 2023-10-02.txt

4. P14 ODS to DWH process with custom metadata.mp4

18:50

5.1 01 prepare products and errors tables.zip

5. P15 Manage Package Errors.mp4

13:09

6. Test your SSIS logging knowledge.html

6. Variables, Configurations and Deployments

1. About variables, configurations and SSIS deployments.mp4

10:48

2.1 create sales table.zip

2.2 insert sales data 01 dev.zip

2.3 insert sales data 02 test.zip

2.4 insert sales data 03 prod.zip

2. P16 SSIS Variables (Part 1 of 2).mp4

10:43

3. P16 SSIS Variables (Part 2 of 2).mp4

13:36

4. Building SSIS variables using Formulas.html

5. Update Visual Studio and SSIS Projects.mp4

05:53

6. Create SSIS configurations and deploy packages.mp4

13:35

7. Manage environments from the SSIS Catalog.mp4

08:40

8. Test your SSIS variables and configuration understanding.html

7. Data Transformations

1. Data Transformations with SSIS.mp4

07:50

2.1 01 create table sales.zip

2.2 02 create table customers.zip

2.3 03 create table sales enriched.zip

2. P17 Enrich data using the Merge Join.mp4

12:56

3.1 01 create table customers x3.zip

3.2 02 insert customers data in 3 tables.zip

3.3 03 create table customers grouped.zip

3. P18 Group data from multiple tables with Union All.mp4

09:33

4. About the transformation concepts.html

5.1 01 create table insert salesbymonth in lines.zip

5.2 02 create table salesbymonth in columns.zip

5. P19 PIVOT data from rows to columns.mp4

12:50

6.1 01 create table insert salesbymonth in columns.zip

6.2 02 create table salesbymonth in lines.zip

6. P20 UNPIVOT data.mp4

09:47

7. About PIVOT and UNPIVOT.html

8. Zip and Unzip files and folders with SSIS

1. About Zip and Unzip with SSIS.mp4

03:46

2.1 7 Zip official website.html

2. Download, Install and test the Zipping Software.mp4

04:53

3.1 data.zip

3. P21 Zip files and folders.mp4

13:12

4. P22 UnZip files and folders.mp4

08:00

9. Real End To End BI Project

1.1 DB Schema free software to design and manage databases.html

1. BI Project Presentation.mp4

10:57

2. Step 1 Create ODS and DWH databases.html

3. Step 2 Create ODS tables and load static dimensions.html

4. Step 3 Load the Fuel Prices in the ODS.html

5. Step 3 solution Part 1 Solution, Package and flat file connection.mp4

05:25

6. Step 3 solution Part 2 Sequence, Loop and Data Flow.mp4

08:58

7. Step 3 solution Part 3 Duplicate Work for Fuel Prices Without Taxes.mp4

06:55

8. Step 4 Load Exchange Rates in the ODS.html

9. About the DWH Database Structure.mp4

05:40

10. Step 5 Create the DWH tables.html

11. Step 6 Load DWH Dimension tables.html

12. Step 6 solution Part 1 Create DWH Time dimension data flow.mp4

10:13

13. Step 6 solution Part 2 Create DWH Currency and Country dimension data flows.mp4

04:32

14. Step 7 Develop Fact Fuel Prices DWH Package.html

15. Step 8 Develop Exchange Rates DWH Package.html

10. Bonuses and final word

1. Bonus Step Part 1 Install Analysis Services.mp4

07:55

2. Bonus Step Part 2 Install Analysis Services Projects on Visual Studio.mp4

06:26

3. Bonus Step Part 3 Import DWH tables and create relationships.mp4

16:47

4.1 DAX Formulas Fuel WOT.txt

4.2 DAX Formulas Fuel WT.txt

4. Bonus Step Part 4 Create DAX Measures and Hierarchies.mp4

11:29

5.1 01 tabular enrich exchange rates.zip

5. Bonus Step Part 5 Enrich Exchange Rates and Analyse DWH in Excel.mp4

08:31

6.1 ssas fuel price.zip

6. Bonus Step Part 6 Deploy the Tabular Model or Import it using XMLA.mp4

07:53

7.1 DAX Formulas Adjustments.txt

7.2 ssas fuel price after adjustments.zip

7. Bonus Step Part 7 Fine Tuning the Model.mp4

08:20

8. Bonus Step Part 8 Download and Install Power BI Desktop.mp4

04:45

9. Bonus Step Part 9 Create a Power BI Report with Graphs.mp4

15:33

10. 10 Expert SSIS Tips for Successful BI Projects.mp4

14:16

11. A Final Word.mp4

02:24

Description

Develop SSIS packages to transform and load data, real Data warehouse project with SSAS and Power BI introduction.

What You'll Learn?

Install SQL Server, and SSIS
Check and run SQL Server services on Windows
Install Visual Studio and SSIS Projects
Install SSMS
Create SSIS projects and solutions with Visual Studio
Create your first SSIS package from scratch
Learn how to connect to SQL Server databases
Import and export CSV, Excel files and XML documents
Learn how to manage errors during data integration
Zip and Unzip Windows files and folders with SSIS
Import and export multiple files at once with dynamic SSIS packages
Learn best practice for integrating data using files
Install SSAS
Develop a simple Tabular Model
Install Power BI
Develop a simple Power BI report with graphs
Install SSAS Projects on Visual Studio
Understand High Level ETL and BI concepts

Who is this for?

You're new to SSIS or just want to understand how it works and especially how to get started.

You are a beginner or with minimal SQL Server or T-SQL experience. It will help, but it is not necessary.

This course is suitable for you if you are beginning from scratch or if you know previous versions of SSIS.

It is also for Experienced or Junior Developers, Data engineers or Consultants who wants to quickly learn SSIS basics and best practices.

What You Need to Know?

All required Software installed during the training

Experience of T-SQL is preferable, but not mandatory (all SQL queries are provided).

More details

Description
Unlock the Power of Data Integration with Our Comprehensive SSIS Course!

Embark today on a transformative journey into the realm of SQL Server Integration Services (SSIS) with our specially crafted course that caters to both novices and experienced professionals.
This course is Designed by a seasoned Microsoft BI and EPM Consultant with over 15 years of hands-on experience.
It is your gateway to mastering the essentials of SSIS, ensuring you can confidently handle data integration tasks with confidence.

Key Highlights

Seamless Setup and Configuration
Install SQL Server, SSIS, SSAS, SSMS, Visual Studio and also Power BI
Check and run SQL Server services on Windows
Hands-On Project Development
Create SSIS projects and solutions from scratch using Visual Studio
Develop your inaugural SSIS package with step-by-step guidance
Import and export CSV, Excel files, and XML documents effortlessly
No Prior SQL Experience Required
T-SQL familiarity is preferred but not mandatory â€“ all SQL queries are provided
Beginners are welcome â€“ lower the entry barrier and kickstart your SSIS journey
Advanced Techniques for Professionals
Import and export multiple files simultaneously with dynamic SSIS packages
Manage errors during data integration effectively
Versatile Audience
Tailored for both Experienced and Junior Developers, Data Engineers, and Consultants
Perfect for those new to SSIS or seeking a deeper understanding of its workings
Comprehensive Learning Path
Understand High-Level ETL and BI concepts
Learn best practices for integrating data using files
Practical Real-World Applications
Build a real BI and ETL project from authentic data files to a Data Warehouse
Bonus content on SSAS Tabular Model and Power BI
Create a straightforward Tabular Model in SSAS
Develop a simple Power BI report
Expand Your Toolkit
Zip and Unzip Windows files and folders effortlessly with SSIS and 7zip
By the end of this course, you'll have a robust skill set, enabling you to confidently navigate SSIS projects, manage data integration challenges, and contribute to the success of your organization's BI initiatives. Whether you're a beginner or a seasoned professional, our course offers a comprehensive and accessible learning experience. Start your SSIS journey today!

Who this course is for:
You're new to SSIS or just want to understand how it works and especially how to get started.
You are a beginner or with minimal SQL Server or T-SQL experience. It will help, but it is not necessary.
This course is suitable for you if you are beginning from scratch or if you know previous versions of SSIS.
It is also for Experienced or Junior Developers, Data engineers or Consultants who wants to quickly learn SSIS basics and best practices.

User Reviews

Rating

average 0

Total votes0

Focused display

With 15+ years of experience in SQL Server BI and IT, I have consistently focused on addressing technical and business challenges for dozens of customers in many different business areas.My technical expertise spans Microsoft BI, from functional scoping to deployment and production support, and professional end users training.Additionally, I have documented and shared industry insights and best practices through my technical blog, mainly focused on Microsoft BI.As a Senior MS BI consultant, I'm now looking to share my understanding and experiences of T-SQL, Datawarehousing, SSIS, SSAS Tabular, and Power BI, and still learn new skills in the quickly evolving BI domain.

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.