Vertica - GROUP BY GROUPING SETS Advanced SQL
This blog comes from the Vertica Architecture and SQL book by Tom Coffing and David Cook. Are you ready to learn Vertica SQL from the...
top of page
Search
tomcoffing
- Sep 18, 2022
- 2 min
Migrate to Vertica Faster Than a Heartbeat
You are about to witness what some might consider impossible, but records were made to be broken. After almost 20 years of work, the...
7 views0 comments
tomcoffing
- Sep 15, 2022
- 5 min
The Mistake that Teradata and Snowflake Make
Why would Teradata charge a customer $20,000,000.00 to buy an on-premises Teradata system, then tack on another $2,000,000.00 for...
286 views0 comments
tomcoffing
- Sep 14, 2022
- 3 min
Teradata Retires SQL Asst - There is a God
Why would Teradata charge a customer $20,000,000.00 to buy an on-premises Teradata system, then tack on another $2,000,000.00 for...
21 views0 comments
tomcoffing
- Sep 14, 2022
- 4 min
Vertica - What is a Recursive Derived Table?
This blog comes from the Vertica Architecture and SQL book by Tom Coffing and David Cook. Are you ready to learn Vertica SQL from the...
9 views0 comments
tomcoffing
- Sep 14, 2022
- 4 min
Teradata - What is a Recursive Derived Table?
This picture is of Tera-Tom Coffing, his wife Leona, and their three kids in 1989. Tom began teaching Teradata in 1995, has written 50...
30 views0 comments
tomcoffing
- Sep 14, 2022
- 3 min
Snowflake - What is a Recursive Derived Table?
This blog comes from the Snowflake Architecture and SQL book by Tom Coffing and David Cook. Are you ready to learn SQL from the best...
27 views0 comments
tomcoffing
- Sep 12, 2022
- 2 min
Migration with Microsoft Access is Essential
The CEO writes the checks, but the business users attract the customers, hunt down the competition, and provide the profits. The IT staff...
35 views0 comments
tomcoffing
- Aug 31, 2022
- 1 min
Learn SQL with Tera-Tom: PERCENT_RANK Ordered Analytic
Tom Coffing taught Teradata certification back in the 90s. Tom wrote six Tera-Cram books, and 10,000 people became certified. Thousands...
5 views0 comments
tomcoffing
- Aug 31, 2022
- 1 min
Learn SQL with Tera-Tom: How Rank Handles Ties
Tom Coffing taught Teradata certification back in the 90s. Tom wrote six Tera-Cram books, and 10,000 people became certified. Thousands...
5 views0 comments
tomcoffing
- Aug 31, 2022
- 2 min
Learn SQL with Tera-Tom: RANK, PARTITION BY, and QUALIFY
Tom Coffing taught Teradata certification back in the 90s. Tom wrote six Tera-Cram books, and 10,000 people became certified. Thousands...
50 views0 comments
tomcoffing
- Aug 31, 2022
- 1 min
Learn SQL with Tera-Tom: Moving Average Ordered Analytic
Tom Coffing taught Teradata certification back in the 90s. Tom wrote six Tera-Cram books, and 10,000 people became certified. Thousands...
12 views0 comments
tomcoffing
- Aug 31, 2022
- 2 min
Learn SQL with Tera-Tom: RANK Ordered Analytic
Tom Coffing taught Teradata certification back in the 90s. Tom wrote six Tera-Cram books, and 10,000 people became certified. Thousands...
16 views0 comments
tomcoffing
- Aug 31, 2022
- 1 min
Learn SQL with Tera-Tom: Moving Sum Ordered Analytic
Tom Coffing taught Teradata certification back in the 90s. Tom wrote six Tera-Cram books, and 10,000 people became certified. Thousands...
1 view0 comments
tomcoffing
- Aug 31, 2022
- 2 min
Learn SQL with Tera-Tom: Cumulative Sum and PARTITION BY
Tom Coffing taught Teradata certification back in the 90s. Tom wrote six Tera-Cram books, and 10,000 people became certified. Thousands...
7 views0 comments
tomcoffing
- Aug 31, 2022
- 2 min
Learn SQL with Tera-Tom: Cumulative Sum Ordered Analytic
Tom Coffing taught Teradata certification back in the 90s. Tom wrote six Tera-Cram books, and 10,000 people became certified. Thousands...
18 views0 comments
tomcoffing
- Aug 31, 2022
- 2 min
Learn Python with Tera-Tom - Embedding Multiple Values into a String
This picture shows Tom Coffing (Tera-Tom) teaching Teradata certification in the 90s. Tom wrote six Tera-Cram books, and 10,000 people...
9 views0 comments
tomcoffing
- Aug 31, 2022
- 2 min
Learn Python with Tera-Tom - Splitting a Quote in a String into a List
This picture shows Tom Coffing (Tera-Tom) teaching Teradata certification in the 90s. Tom wrote six Tera-Cram books, and 10,000 people...
5 views0 comments
tomcoffing
- Aug 31, 2022
- 2 min
Learn Python with Tera-Tom - Replacing Words in Your String
This picture shows Tom Coffing (Tera-Tom) teaching Teradata certification in the 90s. Tom wrote six Tera-Cram books, and 10,000 people...
14 views0 comments
tomcoffing
- Aug 31, 2022
- 2 min
Learn Python with Tera-Tom - Helpful String Commands
This picture shows Tom Coffing (Tera-Tom) teaching Teradata certification in the 90s. Tom wrote six Tera-Cram books, and 10,000 people...
6 views0 comments
bottom of page