Oracle PLSQL

Oracle PL/SQL Developer online interactive course

Requirements

  • You need to know how to use a computer, and hopefully, know how to use a spreadsheet.
  • No prior knowledge of Oracle SQL Database or any other database is required – although the more knowledge you do have, the better.
  • To install Oracle SQL Database on your computer, you will need a 64-bit machine.
  • Oracle SQL Database cannot easily be installed on the macOS because Oracle doesn’t support running an Oracle database directly on a Mac computer. You can’t install Oracle Express, for example, in the same way, that you can on a Windows computer. If you wish to install it on a Mac, you will need either to dual boot into Windows or be running Parallel Desktop.
  • You don’t even need Oracle SQL Database installed – I’ll show you have to install it on your computer for free!
  • Why not have a look at the curriculum below and see what you can learn?

Description

This course is the foundation for the Oracle Database SQL 1Z0-071 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access. It is divided into 6 sessions, each of which should take a morning or afternoon to complete.

Lesson 1: Writing Basic SQL Statements

After completing this lesson, you should be able to do the following:

  • List the capabilities of SQL SELECT statements
  • Execute a basic SELECT statement
  • Differentiate between SQL statements and SQL*Plus commands

Lesson 2: Restricting and Sorting Data

After completing this lesson, you should be able to do the following:

  • Limit the rows retrieved by a query
  • Sort the rows retrieved by a query

Lesson 3: Single-Row Functions

After completing this lesson, you should be able to do the following:

  • Describe various types of functions available in SQL
  • Use character, number, and date functions in SELECT statements
  • Describe the use of conversion functions

Lesson 4: Displaying Data from Multiple Tables

After completing this lesson, you should be able to do the following:

  • Write SELECT statements to access data from more than one table using equality and nonequality joins
  • View data that generally does not meet a join condition by using outer joins
  • Join a table to itself

Lesson 5: Aggregating Data Using Group Functions

After completing this lesson, you should be able to do the following:

  • Identify the available group functions
  • Describe the use of group functions
  • Group data using the GROUP BY clause
  • Include or exclude grouped rows by using the HAVING clause

Lesson 6: Subqueries

After completing this lesson, you should be able to do the following:

  • Describe the types of problems that subqueries can solve
  • Define subqueries
  • List the types of subqueries
  • Write single-row and multiple-row subqueries

Lesson 7: Multiple-Column Subqueries

After completing this lesson, you should be able to do the following:

  • Write a multiple-column subquery
  • Describe and explain the behavior of subqueries when null values are retrieved
  • Write a subquery in a FROM clause

Who this course is for:

  • This SQL course is meant for you, if you have not used Oracle SQL Database much (or at all), and want to learn SQL.
  • This course is also for you if you want a refresher on SQL. However, no prior Oracle SQL Database knowledge is required