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, 20222 min read
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, 20225 min read
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...
312 views0 comments
tomcoffing
Sep 14, 20223 min read
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...
25 views0 comments
tomcoffing
Sep 14, 20224 min read
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...
53 views0 comments
tomcoffing
Sep 14, 20224 min read
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, 20223 min read
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...
49 views0 comments
tomcoffing
Sep 12, 20222 min read
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, 20221 min read
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, 20221 min read
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...
6 views0 comments
tomcoffing
Aug 31, 20222 min read
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...
54 views0 comments
tomcoffing
Aug 31, 20221 min read
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, 20222 min read
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...
17 views0 comments
tomcoffing
Aug 31, 20221 min read
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...
9 views0 comments
tomcoffing
Aug 31, 20222 min read
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...
23 views0 comments
tomcoffing
Aug 31, 20222 min read
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...
23 views0 comments
tomcoffing
Aug 31, 20222 min read
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, 20222 min read
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...
6 views0 comments
tomcoffing
Aug 31, 20222 min read
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, 20222 min read
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