For the best web experience, please use IE11+, Chrome, Firefox, or Safari
Free Trials
Database Training Days: Oracle Resources

Database Training Days: Oracle Resources

Elevate your Oracle database skills with Quest Software's comprehensive resources. Join industry experts as they delve into performance optimization, seamless migrations, efficient administration, and advanced development techniques. Enjoy these on-demand sessions today to access a wealth of knowledge and take your Oracle database expertise to the next level!

Looking to dive deeper into the solutions featured in our Database Training Days sessions? Elevate your technical skills with SharePlex Skills 101, Foglight Skills 101, and Toad Training Tuesdays. These specialized training programs offer even more in-depth knowledge on the powerful tools you’ll encounter during Database Training Days, equipping you with the expertise to maximize their potential in your environment. Don’t miss this opportunity to advance your skills and stay ahead in the ever-evolving world of database management.

Select your events

Do you struggle to understand why a query is running slowly, or why it runs quickly most of the time but occasionally takes much longer? Being able to review and interpret query execution plans is crucial for identifying bottlenecks in database performance. Not only must DBAs understand execution plans for proactive performance management, but developers also need to review these plans as queries and procedures are developed. In this session, you’ll learn how to gather and read execution plans, understand what query operators are and what actions they perform, and distinguish between different plan types. Finally, you’ll discover how to improve your code and enhance performance by leveraging the insights revealed in these plans.

Topics that will be discussed include:

  • Gathering and reading SQL Server query execution plans
  • Understanding query operators and their functions
  • Differentiating between various execution plan types
  • Improving code performance using execution plan data

Speaker:

  • Monica Rathbun, Microsoft MVP for Data Platform, Microsoft Certified Solutions Expert, and VMware vExpert at Denny Cherry and Associates Consulting

Maintaining data integrity is a critical responsibility for database administrators (DBAs). In this foundational session, we'll explore the powerful Database Console Commands (DBCC) toolset, which provides an array of options for validating the logical and physical integrity of your SQL Server databases. We’ll guide you through the setup process, ensuring you're equipped to leverage DBCC effectively.

Topics that will be discussed include:

  • The importance of incorporating integrity checks into DBA practices
  • Overview of DBCC options and their role in ensuring data consistency and reliability
  • Detailed exploration of DBCC parameters and configuration methods
  • Introduction to community-driven tools that streamline DBCC processes
  • Best practices for integrating DBCC into your database maintenance routines

Speaker:

  • Mikey Bronowski
    Data Enthusiast, Microsoft Data Platform MVP, Microsoft Certified Trainer

In this session, delve into the utilization of free Linux tools to conduct comprehensive analysis of Oracle database performance. While Oracle software is equipped with excellent instrumentation, certain scenarios require deeper investigation. This session addresses common queries, such as identifying the causes of excessive CPU consumption or sluggish I/O performance. Attendees will gain insights into a range of free tools available on the Linux platform, empowering them to effectively troubleshoot various database-related issues and optimize performance.

Topics that will be discussed include:

  • Utilizing free Linux tools for Oracle database performance analysis
  • Investigating causes of excessive CPU consumption and sluggish I/O performance
  • Conducting comprehensive performance assessments beyond Oracle’s built-in instrumentation
  • Troubleshooting complex database-related issues with Linux tools

Speaker:

  • Stefan Koehler, Independent Oracle Performance Consultant and Researcher

Select one or more relevant webcast(s) you wish to attend before you register.

triangle-down check
By downloading, you are registering to receive marketing email from us. To opt-out, follow steps described in our Privacy Policy.

reCAPTCHA protects this site. See Google's Privacy Policy and Terms of Use.

Contact

© Quest Software Inc. All Rights Reserved. Legal| Terms of Use| Privacy Policy Your Privacy Choices| Cookie Use Policy Accessibility
United States of America (EN)