Dive into the world of database optimization with our hands-on Oracle 19c Database Tuning course. Aimed at entry-level learners, this course is designed to provide an in-depth understanding of data management and manipulation techniques. With an understanding of Oracle Database Tuning, you can contribute significantly to the efficiency of your organization's data infrastructure and the successful execution of data-driven strategies.
Our five-day course, led by an Oracle Certified instructor, combines interactive lectures, engaging discussions, and practical lab activities. Topics covered include Oracle Database Architecture, Query Optimizer, Oracle's Tuning Features, Container and Pluggable Databases, and Oracle's Real Application Testing (RAT) among others. About half of the course time is devoted to hands-on lab exercises, where you'll apply your newly learned skills in real-life scenarios. The labs provide you with the opportunity to perform tasks like optimizing queries, setting up and tuning databases, and using tools like the SQL Tuning Advisor and Automatic Workload Repository.
Upon completion of this course, you’ll be equipped to optimize queries, manage databases efficiently, utilize Oracle's Heat Map, monitor a service, and use the Automatic Workload Repository (AWR). These critical skills enable you to maintain high-performing databases that are crucial to your organization's operations.
NOTE: This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas. This course is for 19c.
This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities. Throughout the course you’ll learn how to:
If your team requires different topics, additional skills or a custom approach, our team will collaborate with you to adjust the course to focus on your specific learning objectives and goals.
This hands-on course is geared for experienced DBAs already working with Oracle. Incoming students should possess:
Take Before: Attendees should have skills equivalent to or should have attended this course as a pre-requisite:
Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience interests, skill-level and participation.
Student Materials: Each participant will receive a digital Student Guide and/or Course Notes, code samples, software tutorials, step-by-step written lab instructions (as applicable), diagrams and related reference materials and resource links. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.
Hands-On Setup Made Simple! Our dedicated tech team will work with you to ensure our ‘easy-access’ cloud-based course environment, or local installation, is accessible, fully-tested and verified as ready to go well in advance of the course start date, ensuring a smooth start to class and effective learning experience for all participants. In some cases we can also help you install this course locally if preferred. Please inquire for details and options.
Every-Course Extras = High-Value & Long-Term Learning Support! All Public Schedule courses include our unique EveryCourse Extras package (Course Recordings, Live Instructor Follow-on Support, Free *Live* Course Refresh Re-Takes, early access to Special Offers, Free Courses & more). Please inquire for details.
Live scheduled classes are listed below or browse our full course catalog anytime
Check out custom training solutions planned around your unique needs and skills.
Exclusive materials, ongoing support and a free live course refresh with every class.
Please see the current upcoming available open enrollment course dates posted below. Please feel free to Register Online below, or call 844-475-4559 toll free to connect with our Registrar for assistance. If you need additional date options, please contact us for scheduling.
Course Title | Days | Date | Time | Price | |
---|---|---|---|---|---|
Oracle 19c Database Tuning (TTOR21519) | 5 Days | Oct 30 to Nov 3 | 10:00 AM to 06:00 PM EST | $2,695.00 | Enroll |
Oracle 19c Database Tuning (TTOR21519) | 5 Days | Jan 29 to Feb 2 | 10:00 AM to 06:00 PM EST | $2,695.00 | Enroll |
Oracle 19c Database Tuning (TTOR21519) | 5 Days | Apr 8 to Apr 12 | 10:00 AM to 06:00 PM EST | $2,695.00 | Enroll |
Oracle 19c Database Tuning (TTOR21519) | 5 Days | Jun 10 to Jun 14 | 10:00 AM to 06:00 PM EST | $2,695.00 | Enroll |
Oracle 19c Database Tuning (TTOR21519) | 5 Days | Jul 15 to Jul 19 | 10:00 AM to 06:00 PM EST | $2,695.00 | Enroll |
Mix, Match & Master!
2FOR1: Two Courses, One Price!
Enroll in *any* two public courses (for 2023 *OR* 2024 dates!) by October 31, for one price! Learn something new, or share the promo!
Special Offers
Limited Offer for most courses.
SAVE 50%