Blog

I can teach you analytics! Postgres is excellent at analytics, and this week, I will show you the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and how to use a derived table to filter your rank commands. All of these examples have come from my books and training classes. Please…

I can teach you analytics! Greenplum is excellent at analytics, and this week, I will show you the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and how to use a derived table to filter your rank commands. All of these examples have come from my books and training classes. Please…

I can teach you analytics! Vertica is excellent at analytics, and this week, I will show you the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and how to use a derived table to filter your rank commands. All of these examples have come from my books and training classes. Please…

I can teach you analytics! Teradata is excellent at analytics, and this week, I will show you the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and QUALIFY commands to filter your analytic results. All of these examples have come from my books and training classes. Please do me a favor…

I can teach you analytics! DB2 is excellent at analytics, and this week, I will show you the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and how to use a derived table to filter your rank commands. All of these examples have come from my books and training classes. Please…

I can teach you analytics! Netezza is excellent at analytics, and this week, I will show you the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and how to use a derived table to filter your rank commands. All of these examples have come from my books and training classes. Please…

I can teach you analytics! SQL Server is excellent at analytics. This week, we are working on the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and how to use a derived table to filter your rank commands. All of these examples have come from my books and training classes. Please…

I can teach you analytics! Oracle is excellent at analytics. We are working on the RANK, DENSE_RANK, and PERCENT_RANK commands this week. You will also learn about PARTITION BY and how to use a derived table to filter your rank commands. All of these examples have come from my books and training classes. Please do…

I can teach you analytics!  Azure Synapse is excellent at analytics. This week we are working on the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and how to use a derived table to filter your rank commands. All of these examples have come from my books and training classes. Please do…

I can teach you analytics!  Databricks is excellent at analytics. This week we are working on the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and QUALIFY. All of these examples have come from my books and training classes. Please do me a favor and tell your training coordinator that you know…

I can teach you analytics!  Amazon Redshift’s columnar design is built for analytics. This week we are working on the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and how to use a derived table to filter the calculations. All of these examples have come from my books and training classes. Please…

I can teach you analytics!  Google BigQuery is excellent at analytics. This week we are working on the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and QUALIFY. All of these examples have come from my books and training classes. Please do me a favor and tell your training coordinator that you…

Good morning! I am reaching out to all Training, Learning, and Development staff to introduce myself in hopes of becoming the best teacher you have ever hired to train your employees. What makes me a special teacher is that I teach two types of classes on the opposite extremes. I can teach your marketing and…

Date, time, and timestamp functions are different in every database, and date and timestamp formatting can be difficult for experts. I have put together clear and brilliant examples in separate blogs, 45 blogs, to show you date, time, timestamp functions, date formats, and timestamp formats for all systems. I have the 45 links listed for…

Formatting a timestamp on any system can be challenging, but not anymore. I have 250,000 examples across all databases, so you are only seconds away from clear explanations with detailed examples. Below, you will find each database listed with a link to another simple blog explaining the format statement, the components you can use to…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and Greenplum handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me a…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and MySQL handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me a…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and Postgres handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me a…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and Netezza handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me a…

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and Vertica handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations. All of these examples have come from my books and training classes. Please do me a…