Oracle SQL - A Complete Introduction

Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.
Rating: 4.6 out of 5 (3,649 ratings)
56,443 students
Oracle SQL - A Complete Introduction
Rating: 4.6 out of 5 (3,649 ratings)
56,443 students
In this course, you will learn how to write basic SQL statements to view data, insert data, update existing data and delete data in a database.

Requirements

  • Nothing - this is a beginner's course
Description

Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work.

This course will teach you the basics of the SQL language on an Oracle database.

It uses video lectures to teach you Oracle SQL, covering database topics such as:

  • Setting up your Oracle environment
  • Basic terminology
  • Reading data using a SELECT statement
  • What can be done using a SELECT statement
  • Functions
  • Data types
  • Joins, set operators, subqueries
  • Inserting, updating and deleting data
  • Creating tables

The course materials run for approximately 4 hours and are split into multiple sessions.

It's structured into various sessions and lectures, grouped by functional areas to make it easier to learn.

Why should you take this course?

There are many benefits of taking my Oracle SQL course:

  • You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours
  • Avoid paying thousands of dollars for training.
  • You can also study in your own time!
  • Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)!

If you want to learn Oracle SQL from someone who has experience, then take this course.

Who this course is for:
  • Those who have some knowledge about IT but minimal SQL knowledge
  • University or college students
  • Those who need to use a database at work, but don't know how
Course content
13 sections • 70 lectures • 4h 40m total length
  • Introduction
    03:03
  • Oracle Express 18c Download and Setup
    07:25
  • How To Install Oracle On A Mac
    00:20
  • How to Resolve Oracle Connection Issues
    00:12
  • SQL Developer Download
    03:45
  • Create a New User
    04:57
  • Our Sample Database
    02:14
  • Setting Up Our Sample Data
    02:13
  • How to View Data With the SELECT Statement
    05:38
  • Selecting Individual Columns
    05:33
  • Filtering Data with WHERE
    03:48
  • Comparison Operators
    03:18
  • Filtering on Partial Values with LIKE
    04:15
  • Filtering on Date Values
    03:35
  • Using Two Filters
    03:03
  • More Than Two Filters
    03:54
  • What is NULL?
    03:49
  • Getting Unique Records with DISTINCT
    04:21
  • SELECT Quiz
    3 questions
  • IN and NOT IN
    04:09
  • BETWEEN and NOT BETWEEN
    03:19
  • ALL Keyword
    04:18
  • ANY Keyword
    04:44
  • Operators Quiz
    3 questions
  • Sorting Results with the ORDER BY Clause
    04:19
  • Ordering By Multiple Columns
    03:33
  • Set Operators and UNION
    06:06
  • UNION ALL Operator
    02:30
  • INTERSECT Operator
    03:58
  • MINUS Operator
    02:38
  • Three or More Sets At Once
    03:39
  • What are Functions?
    01:48
  • Counting Data
    04:01
  • Using COUNT in Other Ways
    04:08
  • Counting Data Within Groups with GROUP BY
    05:30
  • GROUP BY with WHERE and ORDER BY
    04:36
  • GROUP BY with Multiple Columns
    04:02
  • GROUP BY with HAVING
    04:09
  • The SUM Function
    03:25
  • Using the MAX and MIN functions
    04:22
  • Using the AVG function
    02:58
  • What are Table Aliases?
    03:06
  • What Are Column Aliases?
    05:02
  • What Are Joins?
    02:07
  • Inner Join
    07:46
  • Left Outer Join
    05:11
  • Right Outer Join
    03:10
  • Full Outer Join
    02:13
  • Natural Join
    03:20
  • Cartesian or Cross Join
    03:27
  • Self Join
    04:56
  • Joining Many Tables
    07:51
  • Alternative Join Syntax
    04:54
  • String Functions
    05:51
  • Nesting Functions Within Functions
    03:46
  • Number Functions
    04:48
  • Date Functions
    05:47
  • Data Types and Conversion Functions
    05:23
  • The CASE Statement
    07:14

Instructor
IT Software Consultant
Ben Brumm
  • 4.4 Instructor Rating
  • 7,599 Reviews
  • 72,303 Students
  • 3 Courses

I'm a software consultant that has a passion for databases, and teaching others. I have over seven years experience in the IT industry in many roles, including database support, database development, database design, reporting, business analysis, project management, and even Excel.

I obtained the Oracle SQL Expert certification and currently looking into the next certification on my list!

I'd like to teach others about databases and database topics, such as SQL, database design, and performance.