Big Data Series

SSDB – Part 16. ETL – Creating SQL ETL Scripts

Creating SQL ETL Scripts

Big Data Series

SSDB – Part 15. ETL – Creating ETL Stored Procedures

Creating ETL Stored Procedures

Big Data Series

SSDB – Part 14. ETL – Implementing ETL with SQL Objects (VIEWS)

Implementing ETL with SQL Objects

Big Data Series

SSDB – Part 13. ETL – Connecting Foreign Keys to Surrogate Keys

Connecting Foreign Keys to Surrogate Keys

Big Data Series

SSDB – Part 12. ETL – Creating Date Lookup Tables

Creating Date Lookup Tables

Big Data Series

SSDB – Part 11. ETL – Redefining Nullable Values for Enhanced Reporting

Redefining Nullable Values for Enhanced Reporting: CLICK to Continue Reading.......

Big Data Series

SSDB – Part 7. ETL – Splitting and Merging Columns

There are specific transformations that you will likely use more than others, and learning how to program these will make creating any ETL process easier......... READ/VIEW VIDEO.................

Big Data Series

TSQL – Part 1(d) – Working with NULLS

NULL is used to indicate an unknown or missing value. NULL is not equivalent to zero or an empty string. Arithmetic or string. CLICK to READ ....

Big Data Series

TSQL – Part 1(c) – Data Types

Transact-SQL supports a wide range of data types, which can be broadly categorized as exact numeric, approximate numeric, character, date/time, binary, and other. CLICK TO READ...................

Big Data Series

TSQL – Part 1(b) – SELECT statement

Use the SELECT statement to retrieve a rowset of data from tables and views in a database.. CLICK TO READ --------------