Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Introduction to Oracle SQL

via DataCamp

Overview

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

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.

Syllabus

  • SQL Basics
    • 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.
  • 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.
  • 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.
  • 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.

Taught by

Hadrien Lacroix and Sara Billen

Reviews

Start your review of Introduction to Oracle SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.