facebook twitter

Webucator's Free Advanced Oracle SQL Queries Tutorial

Welcome to our free Advanced Oracle SQL Queries tutorial. This tutorial is based on Webucator's Advanced Oracle SQL Queries course.
Start Tutorial or choose from a lesson below
Oracle SQL can do more than simply retrieve data from tables. There are features of the language which allow certain values that are not explicitly included in the database to be derived or calculated. This chapter will explore several of the features of the language which provide these capabilities.
A subquery is a SQL SELECT statement that is contained within another SELECT statement. Subqueries can appear in various parts of a query, including the SELECT clause, the FROM clause, the WHERE clause and the HAVING clause. The innermost query is evaluated prior to queries that contain it. Performance problems can result if an "expensive" query is nested as an inner query.
Oracle SQL queries are not limited to selecting data from a single table. Several tables can be accessed within a query and the data aggregated into a single result set which is returned to the user. The relationship between two tables is known as a join and consists of a mapping of values between specified columns in each table. In this lesson, you will learn about various types of joins and their application to data retrieval.
In this lesson, you will learn about enhanced group processing and using rollup and cube.
Set operators are used to combine the result sets returned by two separate queries into a single result set. The set operators for SQL are MINUS, INTERSECT, UNION and UNION ALL.
Many programming languages have the concept of conditional processing. Among the most common construct is an if/else structure. Oracle SQL does allow for conditional processing, but does not use if/else statements to accomplish it. Instead, the DECODE() function and a CASE statement are provided.
SQL Functions return values based upon specified input. They provide functionality that is traditionally addressed in a procedural rather than a set-oriented programming paradigm. This lesson will provide an overview of functions included with Oracle that relate to character data.
In this lesson, you will learn about non-character SQL functions.
The Data Manipulation Language (DML) is used to manipulate data in the database. The ability to query data is a different kind of responsibility than the ability to change data. Because of this, a database user must have been granted appropriate security privileges to perform an INSERT, UPDATE, or DELETE on a given table. The target table is the table that is having rows added, changed or removed.