For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Get more from Toad in our "Ask Toad" webcast series - 2020

Think you know all there is to know about Toad® for Oracle? Think again! Because the top Toad experts are joining forces to show you how to get more value and save more time than ever with Toad. From lesser-known features to cool, new functionality, Toad offers countless ways to help you improve code quality, reduce code defects, maintain peak database performance and enjoy easier workdays.

Each 30-minute session includes step-by-step guidance on an everyday challenge to simplify and streamline your work, followed by a helpful Q&A.

So get ready to Ask Toad and learn something new about your favorite database management tool.

Don’t miss out, check out the Ask Toad 2019 webcast series.

Select the checkbox for the relevant webcast(s) you wish to attend.
To sign up for all of them, select each box and then register—then we'll notify you of upcoming events in this series.

Select your events


Online

Oct.

1

Time: 11:00 AM EST
Location: WebEx

Anyone in your organization writing PL/SQL code is writing code that other team members may have to someday read, interpret, alter and maintain.  That’s why it’s so important to use a good code review tool to ensure coding standards are met.  

If you have code standards in place already, whether for formatting code or for using (or not using) particular clauses and constructs in code, the standards are meant to ensure that quality code is being promoted to production always.

You can rely on Toad® for Oracle by Quest® as your code review tool. Use it to define coding standards from a selection of 200 rules, or create new rules, to ensure development teams can correct code as they type and consistently improve overall quality. The right code review tool will make it easier to maintain code in the future and reduce the likelihood of defects.

In this session, you’ll learn about the importance of running code reviews of PL/SQL objects. You’ll also see how you can use Toad for Oracle to:

  • Run code reviews using out-of-the-box rules
  • Create new rules for your code reviews
  • Automate code reviews

On Demand

Sept

3

Are you struggling to tune your SQL statements and PL/SQL code? Are you reliant on your DBAs to assist you and can't get their time? According to Forrester Research, 60 percent of database performance issues can be attributed to poor SQL statement execution. You don’t want your queries to bog down the database, but you may not know where to start your tuning efforts.

Fortunately, you can automate the SQL optimization process and maximize the performance of your SQL statements with the SQL Optimizer functionality in Toad® for Oracle Xpert edition.

SQL Optimizer analyzes, evaluates and rewrites SQL statements located within database objects, files, or collections from Oracle's System Global Area (SGA). Once SQL Optimizer identifies problematic SQL statements, it optimizes the SQL and provides replacement code that includes the rewritten statement.

In this session of Ask Toad, Gary Jerep, software solutions consultant, will demonstrate how the SQL Optimizer in Toad for Oracle Xpert edition works to improve your code. You will learn:

  • Why you should use SQL Optimizer
  • Optimization steps and results
  • How to scan existing code for performance problems
  • Capturing running SQL and identifying issues

Join us to learn how the SQL Optimizer will ensure poorly-written queries don’t affect the performance of your Oracle databases.

On Demand

Aug.

6

Poorly-written SQL queries and PLSQL code can bring an Oracle database to its electronic knees – and it’s not a pretty sight. Database professionals spend a lot of time mitigating the effects of bad code on performance, and Toad® is one of the most powerful tools available to get this done. 

Depending on whether you have the Professional or Xpert edition of Toad, there are different features available that you can leverage in your ongoing efforts to address poor code. 

In this session of Ask Toad, Mathew Phan, Software Sales Engineer, will showcase these two editions of Toad for Oracle and how features like static code reviews, sensitive data awareness and SQL optimization address the issues and data governance risks that arise from bad coding practices. 

In Toad Professional, you’ll learn about:

  • Code Analysis
  • Generate Test Data
  • Sensitive Data Awareness

In Toad Xpert, Mathew will cover:

  • SQL Optimization
  • Auto Optimizer
  • Advanced Optimizer

Join us to learn how these features will keep your Oracle databases standing 24x7.

    On Demand

    May

    7

    Do you take the same actions every day with Toad for Oracle? Did you know that you can create hot keys to perform those actions and streamline your tasks? You can also create filters to remove items that you don’t use frequently or don’t need to see. And there are other configurations you might not know about that affect how Toad looks and behaves. 

    In this on demand session, we’ll cover these settings and offer a few more tips to help you get the most from Toad for Oracle.

    On Demand

    Jun.

    4

    Speaker: Russell Tuttle

    The Ask Toad webcast series continues with another compelling session to help you maximize your investment in Toad for Oracle. Tune in on the first Thursday of the month.

    Our second session, features Russell Tuttle, Software Sales Engineer, who will be presenting Five Cool DBA Features in Toad for Oracle Base Edition. 

    Toad for Oracle Base Edition is an amazing tool for Oracle administration that lets you manage all your on-premises and cloud databases, control database access, browse and navigate database objects, and run SQL and PL/SQL. There are also many ways to get organized, productive and collaborative. In this session, you’ll gain insight into five of the most useful DBA features in Toad for Oracle Base Edition, including how to:

    Automate many Toad and non-Toad functions
    Manage all your scripts from a central location
    Browse, view & edit data across tables regardless of the referential integrity (RI)
    Manage and view all your sessions in a single view
    Generate database documentation easily for all the database objects in multiple databases


    On Demand

    Jul.

    2

    Oracle database developers are facing pressures to code faster while still producing high-quality PL/SQL that doesn’t break anything or slow down the database.

    Additionally, developing on Oracle databases poses challenges like finding object references and dependencies in your code, validating code flow and minimizing connections without sacrificing performance. If not addressed properly, any one of these challenges can cost your company time and money.

    In this 30-minute on demand Ask Toad session, Gary Jerep, Software Solutions Consultant, will demonstrate five use cases, and how Toad for Oracle Base Edition helps developers:

    • Quickly find all object references and dependencies in their code
    • Guarantee that code is following the correct flows of control
    • Identify the most expensive lines in their code
    • See how program connections affect database performance
    • Automate tasks for greater efficiency and accuracy