Preparing data for analysis often means encountering some shortcomings within the data itself. Extra spaces, null values, blank values, wrong data types and duplicate values all stand in the way of pr...
We’ve heard again and again from customers how much they value Toad® by Quest®, and how this database development and management tool helps make their job easier every day. They also want to connect w...
“Someday, we’ll find it, the Snowflake connection. The users, the analysts and me.” – with Toad’s apologies to fellow amphibian, Kermit the Frog If you haven’t seen the latest versions of Quest® Toa...
Why do you need a data preparation tool? Most businesses have multiple sources of data and want to answer a wide variety of questions based on solid analysis. A data preparation tool is essential for...
If you use the DATEdata type in your SQL code, it is likely that you have come across the “not a valid month” Oracle database error. As we shall discuss, the error can be fixed with a slight tweak of ...
Data preparation and reporting can be incredibly time consuming without the right tools. Quest® Toad® Data Point and Toad Intelligence Central are a powerhouse combination designed to simplify data...
Introduction to Oracle 18c Express edition (XE) Oracle 18c Express edition (XE) is a lightweight database that can be used to host small applications and is often used by students or developers to tes...
Remember the old days of original “dark mode?” I do. When I was in my second year at university, I was delighted to receive a personal computer XT as a gift. It was a wonderful gift because it allowed...
Save time when you query data Data analysts often use the same criteria as they query data. Whether it’s a monthly, weekly or quarterly report, the data may change but the overall criteria won’t. To e...
When working with large data sets, it can be difficult to easily share data and collaborate on analysis. Beyond the time and resources it takes to create a data set for analysis, there are also securi...
No database can process all queries expediently, but we can strive to make sure our databases process SQL as efficiently as possible. That means applying SQL performance tuning and optimization to our...
Quest® Toad® for Oracle and Toad Data Point offer powerful sets of features. However, it is essential to understand when it is most appropriate to use one tool over the other. When choosing between To...
