Home
Videos uploaded by user “Coffing Data Warehousing”
Let's Learn Teradata Lesson 25: Introduction to Simple Partitioning
 
03:32
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about Simple Partitioning!
Let's Learn Teradata Lesson 7: AMPS, Parsing Engines, and Nodes
 
02:52
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about the Teradata architecture!.
Let's Learn Teradata Lesson 8: Nodes and Architecture
 
05:29
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, dig deeper into the architecture of a Teradata system.
Let's Learn Teradata Lesson 5: Multi-Column Primary Index
 
02:54
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about the Multi-Column Primary Index in Teradata!
Let's Learn Teradata Lesson 2: Linear Scalability
 
03:31
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how Teradata is the master of Linear Scalability!
Let's Learn Teradata Lesson 13: The Basics of Data Blocks
 
03:25
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn the basics of data blocks that reside in your Teradata system.
Let's Learn Teradata Lesson 9: Hashing with a Unique Primary Index
 
04:24
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how Teradata hashes the data with a Unique Primary Index.
Let's Learn Teradata Lesson 3: Unique Primary Index
 
03:19
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how Teradata uses the Unique Primary Index to find your data at lightning speed!
Let's Learn Teradata Lesson 58: Performance Tuning for Joins!
 
05:23
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn some helpful tips for performance tuning your Join!
Let's Learn Teradata Lesson 10: Hashing with a Non-Unique Primary Index
 
03:51
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how Teradata hashes the data with a Non-Unique Primary Index.
Let's Learn Teradata Lesson 1: Parallel Processing
 
04:43
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, get a clearer understanding of what parallel processing is.
Let's Learn Teradata Lesson 16: Teradata's Management of Data Blocks
 
03:26
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how Teradata manages the data blocks in your system.
Let's Learn SQL! Lesson 23 : Derived Tables with Aggregates!
 
03:40
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn about Derived Tables in Aggregation!
Let's Learn Teradata Lesson 15: Data Block Growth and Reading the Data Blocks
 
03:40
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how data blocks grow in your Teradata system!
Amazon Redshift: Understanding the Sort Keys
 
07:34
I'm back with more Amazon Redshift. Sort Keys in Amazon Redshift can be confusing. Let me enlighten you with how they work! I'll be talking about Single-Column Sort Keys, Compound Sort Keys, and Interleaved Sort Keys in this video!
Let's Learn Teradata Lesson 82: Collect Statistics
 
03:25
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about the Collect Statistics function in Teradata!
Let's Learn Teradata Lesson 12: Distribution and Tactical Queries
 
04:19
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how Teradata distributes the data as well as how Tactical Queries are used.
Let's Learn SQL! Lesson 82 : EXIST and NOT EXIST Subqueries
 
03:37
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn about EXIST and NOT EXIST Subqueries!
Let's Learn Teradata Lesson 45: Permanent Space and Spool Space
 
03:59
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about Permanent Space and Spool Space in your Teradata System
Let's Learn Teradata Lesson 18: Intelligent Memory
 
04:25
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about Intelligent Memory in your Teradata system.
Let's Learn Teradata Lesson 6: No Primary Index Tables
 
04:11
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about No Primary Index tables in Teradata!
Let's Learn Teradata Lesson 19: Cylinders, Row Reference Array, and the Master Index
 
04:23
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about Cylinders, the Row Reference Array, and how Teradata uses the Master Index to find its data!
Let's Learn Teradata Lesson 59: Volatile Tables and Global Temporary Tables
 
05:15
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about Volatile Tables and Global Temporary Tables!
Let's Learn SQL! Lesson 1 :  Introducing SQL
 
03:18
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn about SQL and the select statement!
Let's Learn Teradata Lesson 14: Full Table Scans & PI Look Ups for Data Blocks
 
02:47
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how data blocks in a Teradata system are affected by Full Table Scans and Primary Index Look Ups!
Let's Learn Teradata Lesson 17: Synchronized Scans
 
02:33
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about Synchronized Scans in Teradata!
Let's Learn Teradata Lesson 20: Binary Searches Via the Row Reference Array
 
04:11
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how Teradata uses Binary Searches with the help of the Row Reference Array!
Let's Learn Teradata Lesson 31: Combining Old Data and New Data in a PPI
 
02:46
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about how you can combine old data and new data into a PPI Table!
Let's Learn Teradata Lesson 62: Introducing the Transient Journal
 
04:18
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about Teradata's protection feature - the Transient Journal!
Let's Learn Teradata Lesson 110: Single Table Join Indexes
 
03:58
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how you can utilize a Single Table Join Index!
Let's Learn Teradata Lesson 33: The Primary Index and Partitioning
 
04:38
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about how the Primary Index and Partitioning interact!
Let's Learn Teradata Lesson 21: Splitting the Data Block
 
06:08
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how Teradata splits data blocks in the system.
Let's Learn Teradata Lesson 23: The Cylinder Index
 
06:36
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how Teradata uses the Cylinder Index!
Let's Learn Teradata Lesson 109: Multi-Table Join Indexes
 
03:48
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how you create and utilize a multi-table Join Index.
Let's Learn Teradata Lesson 40: Columnar Table Data Movement
 
04:27
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how data movement is done within Columnar Tables!
Let's Learn Teradata Lesson 86: Why Should You Collect Statistics
 
02:55
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, let's explore why you should Collect Statistics in Teradata!
Let's Learn Teradata Lesson 28: Clever Range_N Partition Uses
 
03:50
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how to use the Range_N Partition to partition by Day, Week, and more!
Let's Learn Teradata Lesson 29: Introduction to Case_N Partitioning
 
02:24
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about Case_N Partitioning!
Let's Learn Teradata Lesson 37: Altering a PPI and Other Helpful SQL for DBAs!
 
04:00
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about how you can alter a PPI Table! Not only that, but we also offer some helpful SQL for the DBAs out there!
Let's Learn Teradata Lesson 26: Introduction to Range_N Partitioning
 
03:37
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about Range_N Partitioning!
Let's Learn Teradata Lesson 11: The Row ID and Binary Searches
 
03:25
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about the Row ID and Binary Searches in Teradata.
Let's Learn Teradata Lesson 39: Columnar Tables!
 
06:31
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn more about Columnar Tables!
Let's Learn Teradata Lesson 54: Amps and Joins
 
03:57
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how Amps manage Joins in a Teradata System
Let's Learn Teradata Lesson 30: How Many Partitions Allowed?
 
03:18
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how many Partitions are allowed in a Teradata system!
Let's Learn SQL! Lesson 18 : The Sample Function
 
04:12
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn what exactly the Sample Function does in SQL!
Let's Learn Teradata Lesson 4: Non-Unique Primary Index
 
04:04
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about the Non-Unique Primary Index in Teradata.
Let's Learn SQL! Lesson 9 : Order of Precedence
 
04:12
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn about the Order of Precedence in SQL!
Let's Learn Teradata Lesson 85: When to Collect Statistics?
 
03:16
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn when you should Collect Statistics!
Let's Learn Teradata Lesson 99: Let's Talk Locking
 
03:34
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, let's explore Locking inside your Teradata System!
Let's Learn Netezza! Lesson Five: Netezza's Architecture!
 
05:02
Explore Netezza with Tom Coffing of Coffing Data Warehousing! In this lesson, learn more about the architecture of your Netezza system!