Sometimes, you need to perform operations on a group of data, and get aggregated results. This second chapter will show you how. You will also learn about data types.

Group functions

50 XP

Getting started with group functions

100 XP

Counting

100 XP

Data types

100 XP

Creating groups of data

50 XP

Grouping

100 XP

Advanced grouping

100 XP

Restricting group results

50 XP

Restricting groups

100 XP

More restricting

100 XP

Combining WHERE and HAVING

100 XP

章を開始

Combining Data

What if your data is spread across multiple tables? This third chapter will show you how to join several tables, and how to perform queries and operations on them.

Using joins

50 XP

Inner joins

100 XP

Using USING

100 XP

Joining multiple tables

100 XP

Outer joins

50 XP

Picking an outer join type

50 XP

Left outer join

100 XP

Right outer join

100 XP

More joins

50 XP

Cross joins

100 XP

Self joins

100 XP

Set operators

50 XP

I want it all

100 XP

Under pressure

100 XP

Another one bites the dust

100 XP

章を開始

Taking it to the Next Level

By now, you already have some solid basics. Let's take it a step further and understand how Oracle SQL interprets your queries. You will then learn how to customize your outputs, handle missing values, and how to convert data from one type to another.

Query processing order

50 XP

Order of execution of a query

100 XP

Mistakes against query processing order

100 XP

Customizing output

50 XP

Rounding numbers

100 XP

Working with the modulo

100 XP