matchIT SQL Useful Demo/Training Videos & Links

 matchIT SQL Videos

Matching:

• Internal matching

Address Verification:

• Address Verification

Suppressions:

• Suppressions

QA:

• Quality Assurance

Mail Sortation:

• Mail Sortation

Third Party Videos & Links

Table Joins:

• https://www.w3schools.com/sql/sql_join.asp
• http://www.sql-join.com/

SSIS Data Import:

• https://www.youtube.com/watch?v=1pOlNR-Zqdk
• https://blog.sqlauthority.com/2011/05/12/sql-server-import-csv-file-into-database-table-using-ssis/

SSIS Export to Excel:

• https://www.youtube.com/watch?v=cLSWms3h4OY
• http://knowlton-group.com/using-ssis-to-export-data-to-excel/

SSIS Merge Data:

• https://www.youtube.com/watch?v=pl7oOlXBgKU
• http://www.tutorialgateway.org/union-all-transformation-in-ssis/

SSIS - Expressions/Parameter Tutorials

• Using Expressions
• Expressions and Parameters

SSIS Writing Cursors:

• https://www.mssqltips.com/sqlservertip/1599/sql-server-cursor-example/

SSIS Conditional Splits & Derived Columns:

• https://www.youtube.com/watch?v=QSuI-qV7yWY&t /