Are you sure you want to cancel your subscription?
YES NO
Sorry to see you go

Your subscription will remain active until . If you change your mind, you may rectivate your subscription anytime before that date.

OK
Are you sure you want to reactivate?
YES NO
Welcome Back!

Your subscription has been reactivated and you will continue to be charged on .

OK
Reactivate Subscription

Thank you for choosing to reactivate your subscription. In order to lock in your previous subscription rate, you owe: .

Your Subscription term is from - .

Questions? Call Sales.

541-284-5522
Payment Due:

OK

To start a new subscription with new annual term CLICK HERE

Auto-Renew Subscription

To auto-renew your subscription you need to select or enter your payment method in "Your Account" under Manage Payments.

Click continue to set up your payments.
CONTINUE
CANCEL

Oracle Database 11g SQL Fundamentals 1 1Z0-051

Query Optimization Basics

X

Oracle Database 11g SQL Fundamentals 1 1Z0-051

You have just watched the first 2 minutes of this video
Subscribe Now for The Best Way to Learn IT
Subscribe
The MySpeed control is not installed or failed to initialize.

Add New Bookmark

close
Video Title: Query Optimization Basics
Position:
Bookmark Title:
Submit Bookmark
  • Details
  • Notes
  • Bookmarks
  • Trainer
  • Support

Query Optimization Basics

In this concluding nugget of the series we apply everything we've learned over the course of this training and pick up some practical advice on how to tune and optimize our SQL queries. To start with we will explain how Oracle parses (interprets) SQL. We will then practice using the EXPLAIN PLAN statement to view the fine details of Oracle's query execution plans. Finally, we finish up with a "laundry list" of strategies for customizing how Oracle builds its execution plans.

Oracle Database 11g SQL Fundamentals 1 1Z0-051 Videos

Add Bookmark
Name Position
No Bookmarks Found

Timothy Warner

CERTIFICATIONS Microsoft MCITP, MCTS, MCSE, MCT; CompTIA A+, Network+, Security+, CTT+; Cisco CCNA; HDI-DST; Apple ACSA, ACTC; Novell CNE, NetWare 6

AREAS OF EXPERTISE Microsoft Windows systems administration; web development and administration (XHTML, CSS, PHP, Python, SharePoint); Windows - Mac OS integration;RDBMS design, development, and administration (SQL Server, MySQL, Oracle, DB2). Author or coauthor of: The Unauthorized Guide to iPhone, iPad, and iPod Repair; Hacking Raspberry Pi; MCSE Exams: A TestTaker's Guide; TestTaker's Guide Series: A+ Exams Version 2000; MCSE Accelerated Exams; and more.

CBT NUGGETS TRAINER SINCE 11/07

"Hey there! Thanks for letting me be your guide through the wild and wooly world of information technology and certification. In my career thus far I have held many roles, from systems engineer, to software developer, to database administrator, to IT manager, to technical trainer. My professional motto is, 'Always teaching, always learning.' Above all else, I am honored to be working with you and helping you achieve your goals."

Tim Warner has worked full-time in the information technology field since 1997. His professional background includes Windows server management, Cisco internetworking, SharePoint implementation, SQL Server database administration, and .NET development with Visual Basic.

He has served as a systems engineer in K-12, corporate, and university environments; as a technical trainer for corporate training centers and vocational schools; and as a software developer for a number of high-profile IT educational firms.

Tim is also widely published. His bibliography includes two trade books on Microsoft certification and a couple dozen pieces for IT industry periodicals such as Certification Magazine, Microsoft Certified Professional Magazine and Processor Magazine.


We use a doublespeed control to enhance your viewing experience. In order to make it work we have to manipulate the flash buffering. This advanced buffering is applied to all streams regardless if you installed the doublespeed control or not. Sometimes the advanced buffering causes the video to hang or behave erratically. If you are experienceing issues with video playback please Disable the DoubleSpeed Buffer

Remember to re-enable the buffer if you want to use the doublespeed control.

For other common video playback issues, including firewall and corporate network issues, please visit our Tech Support Forum