Interactive Course

Introduction to Oracle SQL

Learn how to import and manipulate data with Oracle SQL.

  • 4 hours
  • 15 Videos
  • 54 Exercises
  • 110 Participants
  • 4,500 XP

Loved by learners at thousands of top companies:

roche-grey.svg
t-mobile-grey.svg
intel-grey.svg
siemens-grey.svg
mercedes-grey.svg
axa-grey.svg

Course Description

Oracle SQL is one of the most widely used database management system 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. Mastering Oracle SQL is therefore guaranteed to open exciting opportunities.

In this course, you will get a complete introduction to Oracle SQL solving business problems for a digital media store. You will first learn how to access, retrieve and restrict data. You will then perform aggregation and combine tables. The last chapter will have you handle missing values and convert data. By the end of this course, you will understand how Oracle processes SQL queries and will have a solid foundation in Oracle SQL.

  1. 1

    SQL Basics

    Free

    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.

  2. 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.

  3. 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.

  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.

  1. 1

    SQL Basics

    Free

    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.

  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.

  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.

  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.

What do other learners have to say?

Devon

“I've used other sites, but DataCamp's been the one that I've stuck with.”

Devon Edwards Joseph

Lloyd's Banking Group

Louis

“DataCamp is the top resource I recommend for learning data science.”

Louis Maiden

Harvard Business School

Ronbowers

“DataCamp is by far my favorite website to learn from.”

Ronald Bowers

Decision Science Analytics @ USAA

Sara Billen
Sara Billen

Curriculum Manager at DataCamp

Sara is a graduate of a master's degree in Business Engineering and Marketing Analysis. Prior to working at DataCamp she worked as a Data Science consultant for a Belgian IT company. Sara is passionate about education, data science, and business and loves that she is able to combine all of these disciplines in her job as curriculum manager at DataCamp.

See More
Hadrien Lacroix
Hadrien Lacroix

Content Developer at DataCamp

Hadrien is a Content Developer at DataCamp. He's helping instructors daily build the best Data Science and Machine Learning courses possible.

See More
Collaborators
  • Lis Sulmont

    Lis Sulmont

Icon Icon Icon professional info