TGx:Udemy - SSIS Real World Scenarios & Projects : Tricks of the Trade

Hot Picks

New TV

First Cam

New Movies

1080p x265

Misc

Torrent details for "Udemy - SSIS Real World Scenarios & Projects : Tricks of the Trade" Log in to bookmark

Quicknav > Description Read comments 1 Post guest comment

Torrent details

Name:

Udemy - SSIS Real World Scenarios & Projects : Tricks of the Trade

Controls:

Report Torrent

Torrent verified by tutsnode

Category:

Other > Training

Language:

English

Total Size:

2.14 GB

Info Hash:

831a34e73e16019f024a1de4199f93f962a0dbaf

Added By:

tutsnode

Added:

12-04-2021 05:21

Views:

624

Update stats Post guest comment 1

Health:

Seeds:

Leechers:

Completed:

File	Size
.pad/0	101.69 kB
.pad/1	56.11 kB
.pad/10	98.99 kB
.pad/11	213.82 kB
.pad/12	369.72 kB
.pad/13	275.14 kB
.pad/14	89.07 kB
.pad/15	368.53 kB
.pad/16	313.92 kB
.pad/17	99.75 kB
.pad/18	466.55 kB
.pad/19	157.83 kB
.pad/2	212.72 kB
.pad/20	310.48 kB
.pad/21	155.57 kB
.pad/22	370.58 kB
.pad/23	287.46 kB
.pad/24	167.94 kB
.pad/25	175.65 kB
.pad/26	12.66 kB
.pad/27	58.26 kB
.pad/3	251.42 kB
.pad/4	94.75 kB
.pad/5	41.13 kB
.pad/6	480.95 kB
.pad/7	39.56 kB
.pad/8	274.83 kB
.pad/9	449.78 kB
TutsNode.com.txt	63.00 B
[TGx]Downloaded from torrentgalaxy.to .txt	585.00 B
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/1. Introduction/1. Topics covered in this course.mp4	65.91 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/1. Introduction/2. How to use Temporary Table in SSIS Package.mp4	114.96 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/1. Introduction/3. Please download Scripts and Files used in this course.html	236.00 B
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/1. Introduction/3.1 SSIS Scripts and Files.zip	37.25 kB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/2. Project 1 - OLTP , Staging and Datawarehouse/1. ETL Project Theory.mp4	25.33 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/2. Project 1 - OLTP , Staging and Datawarehouse/2. Transferring Data from OLTP to Staging Table.mp4	190.36 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/2. Project 1 - OLTP , Staging and Datawarehouse/3. Transferring data from Staging to Datawarehouse.mp4	64.14 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/3. Project2 - Testing Metadata of the files and Loading the data/1. Project 2 - Part 1.mp4	143.29 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/3. Project2 - Testing Metadata of the files and Loading the data/2. Project 2 - Part 2.mp4	161.45 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/3. Project2 - Testing Metadata of the files and Loading the data/3. Project 2 - Part 3.mp4	36.22 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/3. Project2 - Testing Metadata of the files and Loading the data/4. Project 2 - Part 4.mp4	59.69 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/4. Before Project 3/1. How to execute Foreach Loop Fixed Number of Times.mp4	67.23 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/4. Before Project 3/2. SSIS Expression to get the File Name from the complete File Path.mp4	41.35 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/4. Before Project 3/3. SSIS Expression to separate Name and Date Component of a file.mp4	44.70 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/4. Before Project 3/4. YYYYMMDD date format using SSIS expression.mp4	21.94 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/4. Before Project 3/5. Compress and Uncompress Folder using Winrar in SSIS.mp4	56.54 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/5. Project 3/1. Project Scenario Explained.mp4	38.64 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/5. Project 3/10. Shared Folder Transfer and Naming Conventions.mp4	59.40 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/5. Project 3/2. Parameter Settings of the Project.mp4	16.20 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/5. Project 3/3. Testing the existence of Compressed File.mp4	71.79 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/5. Project 3/4. Extracting Zip File From Shared Folder to Local Processed Folder.mp4	75.90 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/5. Project 3/5. Testing Date Component of each file with the Current Date.mp4	70.14 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/5. Project 3/6. Dynamically Deciding which file to load in which table.mp4	112.53 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/5. Project 3/7. ETL Operations.mp4	89.06 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/5. Project 3/8. ETL with Lookup Option.mp4	54.35 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/5. Project 3/9. To Do Task.html	1.09 kB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/6. Debugging and Troubleshooting SSIS Packages/1. Breakpoints , Watch Windows and Data Viewer.mp4	137.25 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/6. Debugging and Troubleshooting SSIS Packages/2. Troubleshooting Problematic Records Using Data Flow Paths & Script Component.mp4	118.41 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/6. Debugging and Troubleshooting SSIS Packages/3. Troubleshooting with Precedence Constraints.mp4	24.99 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/7. Project Deployment/1. Deploying the Packages to Integration Services Catalog.mp4	96.73 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/7. Project Deployment/2. Setting up Test and Production Environment.mp4	96.96 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/7. Project Deployment/3. Automating the Package Execution and Checking the Reports of Execution.mp4	34.84 MB
[TutsNode.com] - SSIS Real World Scenarios & Projects Tricks of the Trade/7. Project Deployment/4. Bonus Lecture.html	6.09 kB

Description

Description

This Microsoft SQL Server SSIS is an intermediate level training course and it is the part of MSBI. You have to have the knowledge of basic tools and package creation. This SQL Server Integration Services course using SSDT contains three projects along with other tricks based on real world scenarios. All the projects are developed step by step. In one project you can learn how to perform ETL operation for the data warehouse using SSIS as well . The contents of this online SSIS business intelligence video tutorial on Udemy as follows.

How to use Temporary Table in SSIS Package

Transferring Data from OLTP to Staging Table

Transferring data from Staging to Datawarehouse

Testing Metadata of the files and Loading the data

How to execute Foreach Loop Fixed Number of Times

SSIS Expression to get the File Name from the complete File Path

SSIS Expression to separate Name and Date Component of a file

YYYYMMDD date format using SSIS expression

Compress and Uncompress Folder using Winrar in SSIS

Parameter Settings of the Project

Testing the existence of Compressed File

Extracting ZIp File From Shared Folder to Local Processed Folder

Testing Date Component of each file with the Current Date

Dynamically Deciding which file to load in which table

ETL Operations

ETL with Lookup Option

Shared Folder Transfer and Naming Conventions

Debugging and Troubleshooting SSIS Packages

Breakpoints , Watch Windows and Data Viewer

Troubleshooting Problematic Records Using Data Flow Paths

Troubleshooting with Precedence Constraints

Deploying the Packages to Integration Services Catalog

Setting up Test and Production Environment

Automating the Package Execution and Checking the Reports of Execution
Who this course is for:

Intermediate Microsoft Business Intelligence developers interested in deepen the knowledge in SSIS Technology
Who wants to work on some projects in SSIS Technology
Also wants to crack interviews

Requirements

Beginners level knowledge of developing SSIS Packges is must
Control flow, Data flow and Connection Manager concept should be known

Last Updated 5/2020