Welcome to Coffee with Toad®, the Toad World® blog monthly recap. Published the first Tuesday of every month, Coffee with Toad newsletter is organized by month, then by product, followed by each blog title and a brief description. Go directly to the product of your choice or peruse products that you're interested in. Each month this running blog is updated to include the most recent month first.
So, get your steaming or iced brew-of-choice and get ready to learn about tips and tricks, industry trends, and new releases by reading our knowledge-building, career-enhancing articles written by experts and thought leaders.
If you would like to keep up to date on the latest trends in database tools and management, subscribe to the Toad World blog via the RSS feed.
April 2022
Toad Data Point
Toad Data Point Tutorials: Data setup, code snippets and SQL Recall
Learning SQL doesn’t have to be a challenge. View this tutorial to see how you can easily set up Toad Data Point and use code snippets and SQL recall functions.
Toad Data Point Tutorials: SQL Where Clause Null Values
Learn how to identify and avoid null values in your SQL data with the help of Toad Data Point.
SQL Pattern Matching in Toad Data Point
Learn how SQL pattern matching using the LIKE syntax, paired with Toad Data Point, helps data analysts find and prepare data easily.
Toad for Oracle
The top 5 most used Toad® for Oracle features
Explore the top 5 Toad for Oracle features that set it apart and add value to daily tasks, including the Editor, Schema Browser and Session Browser.
March 2022
Toad Data Point
Four functions every data preparation tool should offer
A data preparation tool like Quest Toad Data Point is essential for formatting and focusing enterprise data for effective analysis.
What is data preparation and why is it key to the business analyst?
Find out what's behind good data preparation and how it's key to unlocking truth for business analysts by revealing stats for good business decisions.
Snowflake connection, Workbook updates: New and upcoming in Toad Data Point
The latest version of Quest Toad Data Point features a new Snowflake connection along with enhanced publishing to Toad Intelligence Central.
Toad for Oracle
Fixing the "not a valid month" Oracle Database Error
Do you keep getting the “not a valid month” Oracle error from your SQL queries? Learn what causes it and how to fix it.
An Overview of the NVL and NVL2 function with examples
Get an overview of the NVL and NVL2 SQL functions along with examples of their use for correcting null values in reports.
Supported Oracle 21c new features in Toad© for Oracle 15.1
Quest® Toad® for Oracle 15.1 supports a variety of Oracle 21c new features. This overview walks through the basics of each of these supported features and offers some select use cases.
How to Create an Oracle Database Sequence: Explained with Examples
Quest® Toad® for Oracle 15.1 supports a variety of Oracle 21c new features. This overview walks through the basics of each of these supported features and offers some select use cases.
February 2022
Toad Data Point
Access and query data with a repeatable process using Quest® Toad® Data Point
Need to use the same criteria to analyze and query changing data for periodic reporting? Learn how to use Toad Views to reuse and share SQL.
Toad Talks Webcast: Data Preparation with Quest® Toad® Data Point
In this upcoming webcast, we'll dive into the latest enhancements in Toad Data Point and Toad Intelligence Central, and share what's up next for our leading data preparation tools.
Toad Talks Webcast: Data Preparation with Quest® Toad® Data Point
In this upcoming webcast, we'll dive into the latest enhancements in Toad Data Point and Toad Intelligence Central, and share what's up next for our leading data preparation tools.
Toad for Oracle
Dark mode has arrived for Toad for Oracle 15.1
Learn the similarities and differences of Toad for Oracle vs Toad Data Point, and which one to use when.
Installing and getting started with Oracle 18c Express edition (XE)
Get step-by-step instructions for installing Oracle 18c Express edition, along with creating, connecting to and dropping a pluggable database.
January 2022
SQL Optimizer for Oracle
SQL performance tuning and optimization using Quest® SQL Optimizer
Learn how to use Quest SQL Optimizer in Toad for Oracle for SQL performance tuning and optimization to remedy inefficient SQL and improve database performance.
Toad Data Point
How to use Quest® Toad® Data Point to arrange and pivot data to spot data patterns and identify problems
By using Toad Data Point Pivot Grids to arrange and pivot data, analysts can quickly derive useful insights for a variety of business scenarios.
How to use Quest® Toad® Data Point to cleanse, transform, save and retrieve data
Quest Toad Data Point makes it easy to cleanse and transform data, then save and reuse those steps, or share them using Toad Intelligence Central.
Toad for Oracle
Quest® Toad for Oracle vs. Toad Data Point
Learn the similarities and differences of Toad for Oracle vs Toad Data Point, and which one to use when.
Read other Coffee with Toad flavors:
Coffee with Toad® 2021 [Toad World® blog monthly recap]
Coffee with Toad® 2020 [Toad World® blog monthly recap]
Coffee with Toad® 2019 [Toad World® blog monthly recap]
Coffee with Toad [Toad World Annual recap, 96 blogs]
Toad is a database management toolset from Quest Software, and Toad World® is a community built by Quest®. Toad World has a huge following for good reason—we publish meaningful content. Visit Toad World often for free advice via our blogs, free interactive help via our forums and free trial downloads.
Like this Toad World monthly recap? Share this Toad newsletter with your friends now via the social media icons at the top of this post.
Start the discussion at forums.toadworld.com