Are you sure you want to cancel your subscription?

If you cancel, your subscription will remain active through the paid term. You will be able to reactivate the subscription until that date.

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.

Are you sure you want to reactivate?
Welcome Back!

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

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.

Payment Due:

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.

CBT Nuggets License Agreement

Unless otherwise stated all references to “training videos” or to “videos” includes both individual videos within a series, entire series, series packages, and streaming subscription access to CBT Nuggets content. All references to CBT or CBT Nuggets shall mean CBT Nuggets LLC, a Delaware limited liability company located at 44 Country Club Road, Ste. 150, Eugene, Oregon.

A CBT Nuggets license is defined as a single user license. Accounts may purchase multiple users, and each user is assigned a single license.

  • GRANT OF LICENSE. CBT Nuggets grants you a non-transferable, non-exclusive license to use the training videos contained in this package or streaming subscription access to CBT content (the “Products”), solely for internal use by your business or for your own personal use. You may not copy, reproduce, reverse engineer, translate, port, modify or make derivative works of the Products without the express consent of CBT. You may not rent, disclose, publish, sell, assign, lease, sublicense, market, or transfer the Products or use them in any manner not expressly authorized by this Agreement without the express consent of CBT. You shall not derive or attempt to derive the source code, source files or structure of all or any portion of the Products by reverse engineering, disassembly, decompilation or any other means. You do not receive any, and CBT Nuggets retains all, ownership rights in the Products. The Products are copyrighted and may not be copied, distributed or reproduced in any form, in whole or in part even if modified or merged with other Products. You shall not alter or remove any copyright notice or proprietary legend contained in or on the Products.
  • TERMINATION OF LICENSE. Once any applicable subscription period has concluded, the license granted by this Agreement shall immediately terminate and you shall have no further right to access, review or use in any manner any CBT Nuggets content. CBT reserves the right to terminate your subscription if, at its sole discretion, CBT believes you are in violation of this Agreement. CBT reserves the right to terminate your subscription if, at its sole discretion, CBT believes you have exceeded reasonable usage. In these events no refund will be made of any amounts previously paid to CBT.
  • DISCLAIMER OF WARRANTY AND LIABILITY. The products are provided to you on an “as is” and “with all faults” basis. You assume the entire risk of loss in using the products. The products are complex and may contain some nonconformities, defects or errors. CBT Nuggets does not warrant that the products will meet your needs, “expectations or intended use,” that operations of the products will be error-free or uninterrupted, or that all nonconformities can or will be corrected. CBT Nuggets makes and user receives no warranty, whether express or implied, and all warranties of merchantability, title, and fitness for any particular purpose are expressly excluded. In no event shall CBT Nuggets be liable to you or any third party for any damages, claim or loss incurred (including, without limitation, compensatory, incidental, indirect, special, consequential or exemplary damages, lost profits, lost sales or business, expenditures, investments, or commitments in connection with any business, loss of any goodwill, or damages resulting from lost data or inability to use data) irrespective of whether CBT Nuggets has been informed of, knew of, or should have known of the likelihood of such damages. This limitation applies to all causes of action in the aggregate including without limitation breach of contract, breach of warranty, negligence, strict liability, misrepresentation, and other torts. In no event shall CBT Nuggets’ liability to you or any third party exceed $100.00.
  • REMEDIES. In the event of any breach of the terms of the Agreement CBT reserves the right to seek and recover damages for such breach, including but not limited to damages for copyright infringement and for unauthorized use of CBT content. CBT also reserves the right to seek and obtain injunctive relief in addition to all other remedies at law or in equity.
  • MISCELLANEOUS. This is the exclusive Agreement between CBT Nuggets and you regarding its subject matter. You may not assign any part of this Agreement without CBT Nuggets’ prior written consent. This Agreement shall be governed by the laws of the State of Oregon and venue of any legal proceeding shall be in Lane County, Oregon. In any proceeding to enforce or interpret this Agreement, the prevailing party shall be entitled to recover from the losing party reasonable attorney fees, costs and expenses incurred by the prevailing party before and at any trial, arbitration, bankruptcy or other proceeding and in any appeal or review. You shall pay any sales tax, use tax, excise, duty or any other form of tax relating to the Products or transactions. If any provision of this Agreement is declared invalid or unenforceable, the remaining provisions of this Agreement shall remain in effect. Any notice to CBT under this Agreement shall be delivered by U.S. certified mail, return receipt requested, or by overnight courier to CBT Nuggets at the following address: 44 Club Rd Suite 150, Eugene, OR 97401 or such other address as CBT may designate.

CBT Nuggets reserves the right, in its sole discretion, to change, modify, add, or remove all or part of the License Agreement at any time, with or without notice.

Billing Agreement

  • By entering into a Billing Agreement with CBT Nuggets, you authorize CBT Nuggets to use automatic billing and to charge your credit card on a recurring basis.
  • You agree to pay subscription charges on a monthly basis, under the following terms and conditions:
    • CBT Nuggets will periodically charge your credit card each monthly billing cycle as your subscription charges become due;
    • All payments are non-refundable and charges made to the credit card under this agreement will constitute in effect a "sales receipt" and confirmation that services were rendered and received;
    • To terminate the recurring billing process and/or arrange for an alternative method of payment, you must notify CBT Nuggets at least 24 hours prior to the end of the monthly billing cycle;
    • You will not dispute CBT Nugget’s recurring billing charges with your credit card issuer so long as the amount in question was for periods prior to the receipt and acknowledgement of a written request to cancel your account or cancel individual licenses on your account.
  • You guarantee and warrant that you are the legal cardholder for the credit card associated with the account, and that you are legally authorized to enter into this recurring billing agreement.
  • You agree to indemnify, defend and hold CBT Nuggets harmless, against any liability pursuant to this authorization.
  • You agree that CBT Nuggets is not obligated to verify or confirm the amount for the purpose of processing these types of payments. You acknowledge and agree that Recurring Payments may be variable and scheduled to occur at certain times.
  • If your payment requires a currency conversion by us, the amount of the currency conversion fee will be determined at the time of your payment. You acknowledge that the exchange rate determined at the time of each payment transaction will differ and you agree to the future execution of payments being based on fluctuating exchange rates.

CBT Nuggets reserves the right, in its sole discretion, to change, modify, add, or remove all or part of the Billing Agreement at any time, with or without notice.

Oracle Database 11g SQL Fundamentals 1 1Z0-051

Control and Manipulate your Oracle Database 11g with Structured Query Language.

Course Duration: 10:29:23
Course Introduction
In this nugget, we start by defining what Oracle is and how it fits into the concepts of the database, relational database, and relational database management system. Next we perform a deep-dive into the Oracle certification program, learning exactly how the current course maps to the Oracle Certified Associate (OCA) credential. We also provide tips and tricks for getting the most out of the training, and give suggestions on how to pass the 1Z0-051 exam with a minimum of muss or fuss.
About SQL
In this nugget, we set the stage for the rest of the training. Here we formally define the Structured Query Language (SQL), explaining its basic modes of operation, as well as how Oracle's implementation of SQL stacks up to the ANSI/ISO standard as well as other vendors' implementations. We complete this nugget with quick-start tutorials on how to use SQL*Plus as well as Oracle SQL Developer.
Retrieving Data By Using the SELECT Statement
The SELECT statement is the universal workhorse of SQL. In this nugget we discuss both the theory and practice of using SELECT to retrieve query results from Oracle database.
Restricting and Sorting Data
In this nugget we continue our discussion of the SQL SELECT statement, this time learning how to pare down our query results by employing the powerful WHERE clause. We also learn how to sort our query results by leveraging the ORDER BY statement, and finally begin to write more dynamic, interactive SQL by using substitution variables.
Using Single-Row Functions to Customize Output
In this nugget we introduce the concept of the function, both from a general mathematics standpoint, and then with sharper focus on Oracle Database 11g. We spend our time learning to master the basic character, number, and date functions that you'll be expected to understand on the SQL Fundamentals certification exam.
Reporting Aggregated Data Using the Group Functions
In this nugget we apply many of the function-related principles we picked up in the previous nugget. Here we learn how to aggregate data across multiple table rows by employing both grouping functions as well as the GROUP BY SQL statement. We also will understand how to filter grouped rows by using the HAVING clause.
PL/SQL Basics
In this nugget we truly round out our Oracle SQL skills by conducting a survey of PL/SQL, Oracle's procedural programming extensions to the Structured Query Language. By the end of this nugget you will not only understand the basic nomenclature and syntax of PL/SQL, but you'll also be able to write basic PL/SQL blocks, both the anonymous and named varieties.
Displaying Data from Multiple Tables
In this nugget we truly begin to see the great beauty of the relational database model. Here we learn how to query across multiple related tables by using joins. In addition to learning all about the supported join types in Oracle Database, we will also flirt around with the concept of constraints, two of which (primary key and foreign key) are crucial to our understanding of the relational model.
Using Subqueries
In this nugget we broaden and deepen our usage of the SELECT statement by learning how to embed one SELECT inside of another SELECT; this is called a subquery. As we'll learn, subqueries are useful for data load scenarios as well as when we aren't quite sure which row(s) we need to evaluate in a WHERE clause. By the end of this nugget you will not only understand how subqueries work, but you'll be able to write both single-row and multi-row subqueries in either the simple or correlated processing formats.
Using the Set Operators
SQL is a set-oriented database access language. In this nugget we learn various methods of combining multiple result sets. Here we master the use of the UNION, MINUS, and INTERSECT keywords in combining multiple queries into a single result set.
Using DDL Statements to Create and Manage Tables
In this nugget we formally treat the subject of creating, altering, and dropping database objects; this collection of SQL commands is formally called Data Definition Language, or DDL. In this nugget we start with a high-level overview of the major database objects. We then follow up with learning how to design and create tables, and then conclude with a consideration of the importance and use of integrity constraints in database tables and views.
Creating Other Schema Objects Part 1
In this nugget we continue the discussion we opened in the previous nugget on DDL statements in Oracle Database 11g. Here we learn how to design and implement sequences and views.
Creating Other Schema Objects Part 2
Indexes, when properly designed and used, can dramatically speed up query performance in an RDBMS. In this nugget we cover the fundamental points concerning indexes. We also learn just what synonyms are--not in the English grammar context, but instead in the Oracle database nomenclature.
Manipulating Data Part 1
Thus far in the course we have covered the use of SELECT and the DDL command suite. Formally speaking, SELECT is actually one of the Data Manipulation Language (DML) statements in SQL. In this nugget we cover two of the major DML players, namely the INSERT and UPDATE statements.
Manipulating Data Part 2
In this nugget we "book end" our discussion from Nugget #14, wrapping up our consideration of basic DML by investigating the finer points of the DELETE statement. We also define and discuss what database transactions are as well as how to control their operation in Oracle Database 11g.
Basic Oracle Database Security
Relational database security is a huge topic and can constitute a very lucrative career for those who are so talented and interested. In this nugget we survey some of the major principles behind user account security in Oracle Database 11g. In particular, we learn how to create and administer Oracle user accounts. We then delve into access control, learning how to leverage the GRANT and REVOKE statements. We complete this nugget with some best-practice advice on leveraging database roles to make our database security more efficient and effective.
Accessing the Data Dictionary
The data dictionary in Oracle Database 11g is a read-only collection of tables that stores metadata about the database. As such, an understanding of the data dictionary is crucial for anyone who presents himself or herself as an Oracle DBA. By the conclusion of this nugget you will not only be able to intelligently discuss the data dictionary, but you will also know how to query the data dictionary views as an ordinary schema (user) and as a DBA.
Referencing the Oracle Documentation
While Oracle's documentation library is presented to the public at no charge, Oracle keeps much of the "good stuff" behind a paywall for, well, paying Oracle Support customers. The purpose of this nugget is to deeply familiarize you with the free and excellently written/organized corpus of technical documentation in the Oracle Web site. This is a best-kept secret of Oracle, and you should make the official Oracle Documentation a daily read as you build your skill set up and out.
Using Oracle Flashback Query
In the life of the DBA, restoring data that was accidentally or intentionally dropped or deleted can be a fairly regular occurrence. Here we turn to the nifty Flashback technology in Oracle Database 11g to learn first of all how Flashback works, and then how we can leverage Flashback to recover individual rows or entire tables from the ether. We'll also spend some time with the Oracle Recycle Bin.
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.

No Bookmarks

Data, data everywhere…take control of your database and learn to manipulate it with the tried-and-true Structured Query Language (SQL) in Oracle Database 11g. Whether you're an IT pro who wants to add Oracle DBA and SQL querying to your tool belt, a DBA in another technology who wants to dive into Oracle, or a newcomer to relational databases who yearns to learn SQL, this series will give you what you need to reach your goal.

In this course, you'll gain SQL proficiency and be able to take control of your data. Best of all, you can apply the skills you learn not only to Oracle, but to almost any RDBMS platform! And, trainer Tim Warner gives you all sorts of cool supplemental learning references -– all of the SQL work files can be downloaded free at, and the course is filled with recommendations for white papers, Web sites and more.

Once you've finished this Nugget series, you'll be fully prepared to pass the 1Z0-051 SQL Fundamentals exam -– and be ready to move on to the next in line for the Oracle DBA OCA track. More importantly, you'll gain an extremely useful and portable tool that will help you make the most of your database.

This forum is for community use – trainers will not participate in conversations. Share your thoughts on training content and engage with other members of the CBT Nuggets community. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
Community Standards

We encourage you to share your wisdom, opinions, and questions with the CBT Nuggets community. To keep things civil, we have established the following policy.

We reserve the right not to post comments that:
contain obscene, indecent, or profane language; contain threats or defamatory statements; contain personal attacks; contain hate speech directed at race, color, sex, sexual orientation, national origin, ethnicity, age, religion, or disability; contributes to a hostile atmosphere; or promotes or endorses services or products. Non-commercial links, if relevant to the topic, are acceptable. Comments are not moderated, however, all comments will automatically be filtered for content that might violate our comment policies. If your comment is flagged by our filter, it will not be published.

We will be continually monitoring published comments and any content that violates our policies will be removed. Users who repeatedly violate our comments policy may be prohibited from commenting.

Course Features

Speed Control

Play videos at a faster or slower pace.


Pick up where you left off watching a video.


Jot down information to refer back to at a later time.

MP3 Downloads

Listen to videos anytime, anywhere


Files/materials that supplement the video training

Annual Course Features

Transcender Practice Exams

These practice tests help you review your knowledge and prepare you for exams.
Available only with the annual subscription.
Your browser cannot access Virtual Labs
Add training to a playlist
or create a new list
Add to current playlist
or add to an existing list
Add to new playlist