Skip to main content
HomeSQLIntroduction to Oracle SQL

Introduction to Oracle SQL

Sharpen your skills in Oracle SQL including SQL basics, aggregating, combining, and customizing data.

Comece O Curso Gratuitamente
4 Horas15 Videos54 Exercicios
10.606 AprendizesTrophyDeclaração de Realização

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
GroupTreinar 2 ou mais pessoas?Experimente o DataCamp For Business

Loved by learners at thousands of companies

Descrição do Curso

Gain an Introduction in Oracle SQL

Oracle SQL is one of the most widely used database management systems around the world. It's well suited to power primarily commercial and enterprise applications, and is particularly popular at large companies with mission-critical databases.

This introductory course will teach you all the essentials you need to master Oracle SQL. This includes SQL basics, aggregating, combining, and customizing data in Oracle. You will apply your newly acquired knowledge to solve business problems for a digital media store using the Chinook data.

Practice Essential Skills Using Chinook data

The course begins by exploring SQL Basics. In this chapter, you will familiarize yourself with topics such as what is an Oracle database and relational databases, and essentially how to retrieve, order, and filter data.

The last chapter will explain 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.

Further Develop Your Oracle SQL Skills

By the end of this course, you will understand how Oracle processes SQL queries and will have a solid foundation in Oracle SQL. With the growing importance of relational databases, comes a simultaneously increasing demand of RDBMS and SQL programmers. Explore our library to discover more about SQL and its RDBMS.
Para Empresas

GroupTreinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados
Experimente O DataCamp for BusinessPara uma solução sob medida , agende uma demonstração.
  1. 1

    SQL Basics

    Grátis

    You're about to write your first Oracle SQL queries! At the end of this chapter, you will be able to retrieve, order and filter data.

    Reproduzir Capítulo Agora
    What is an Oracle database?
    50 xp
    Writing your first query
    100 xp
    Relational databases
    50 xp
    Retrieving data
    50 xp
    Removing duplicates
    100 xp
    Working with strings
    100 xp
    Arithmetic expressions
    100 xp
    Ordering
    100 xp
    Restricting data
    50 xp
    Comparison operators
    100 xp
    Logical operators
    100 xp
    Comparison keywords
    100 xp
  2. 2

    Aggregating Data

    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.

    Reproduzir Capítulo Agora
    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
  3. 3

    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.

    Reproduzir Capítulo Agora
    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
  4. 4

    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.

    Reproduzir Capítulo Agora
    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
    Manipulating strings
    100 xp
    Replacing letters
    100 xp
    Working with NULL values
    50 xp
    Testing if a value is NULL
    100 xp
    Replacing NULL values
    100 xp
    Comparing values
    100 xp
    Using conversion functions
    50 xp
    Implicit and explicit conversion
    50 xp
    Conversion functions
    100 xp
    Congratulations!
    50 xp
Para Empresas

GroupTreinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados

Conjuntos De Dados

Chinook data

Colaboradores

Collaborator's avatar
Lis Sulmont
Hadrien Lacroix HeadshotHadrien Lacroix

Curriculum Manager at DataCamp

Veja Mais

O que os outros alunos têm a dizer?

    Cadastre-se mais 13 milhões de alunos e comece Introduction to Oracle SQL Hoje!

    Create Your Free Account

    GoogleLinkedInFacebook

    or

    By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.