Introduction to Oracle SQL

Learn the basics of using the SQL language on an Oracle database with these easy-to-follow lessons and examples.
17 reviews
TAUGHT BY
  • Ben Brumm IT Software Consultant

    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.

WHAT'S INSIDE
  • Lifetime access to 37 lectures
  • 4+ hours of high quality content
  • A community of 4200+ students learning together!
SHARE

Introduction to Oracle SQL

Learn the basics of using the SQL language on an Oracle database with these easy-to-follow lessons and examples.
17 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

Learn and practice real-world skills and achieve your goals.

COURSE DESCRIPTION

Learn how to use Oracle SQL AND get a Certification of Completion when you finish.

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

It uses video lectures, 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 lean.

Why should you take this course?

You can go from absolute beginner to capable of writing SQL statements in a matter of hours, without paying thousands of dollars for training. You can also study in your own time!

    • Access to an Oracle database - a test database or somewhere you can install Oracle yourself
    • Over 37 lectures and 4 hours of content!
    • 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.
    • 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

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • SECTION 1:
    Introduction and Setup
  • 1
    Introduction
    02:08

    An introduction to this course, who I am, and what will be covered.

  • 2
    Tools and Concepts
    07:38

    Explains key concepts used in Oracle and this course, as well as what tools are needed for this course.

  • 3
    Oracle Client Download
    01:45

    Demonstration of how to download the Oracle Client.

  • 4
    Oracle Client Install
    01:24

    Demonstration of how to install the Oracle Client.

  • 5
    How To Install Oracle On A Mac
    Text
  • 6
    Java JDK Download
    01:10

    Demonstration of how to download the Java Development Kit.

  • 7
    Java JDK Install
    01:20

    Demonstration of how to install the Java Development Kit.

  • 8
    SQL Developer Download
    02:46

    Demonstration of how to download the Oracle SQL Developer software.

  • 9
    SQL Developer Setup
    02:15

    Demonstration of how to setup the Oracle SQL Developer software.

  • 10
    SQL Developer Connection Setup
    01:11

    Demonstration of how to setup the connections inside the Oracle SQL Developer software.

  • SECTION 2:
    Viewing Data
  • 11
    Viewing Data - SELECT statement (Part 1)
    02:52

    Covers the basics of an SQL statement and how to run it on SQL Developer.

  • 12
    SQL Developer - Create New User
    02:35

    Demonstrates how to create a new user in SQL Developer.

  • 13
    SQL Developer - Create and Populate Tables
    03:26

    Demonstrates how to create and populate the tables required for this course.

  • 14
    Viewing Data - SELECT statement (Part 2)
    05:02

    Includes how to run SELECT statements on the data in this database.

  • 15
    Viewing Data - Operators, DISTINCT and NULL
    13:22

    Explains the concepts of operators, as well as the DISTINCT and NULL keywords.

  • 16
    SQL Data Types
    05:19

    Covers some of the data types used in Oracle SQL.

  • 17
    Viewing Data - Restricting and Sorting (Part 1)
    13:16

    Part one of how to restrict the data and sort it in a SELECT statement.

  • 18
    Viewing Data - Restricting and Sorting (Part 2)
    10:22

    Part two of how to restrict the data and sort it in a SELECT statement.

  • SECTION 3:
    Functions
  • 19
    Functions - Strings
    11:20

    Explains some of the string functions in Oracle SQL.

  • 20
    Functions - Numbers
    06:11

    Explains some of the number functions in Oracle SQL.

  • 21
    Working with Dates and Times
    05:27

    Covers how to work with dates and times in Oracle.

  • 22
    Functions - Dates
    04:23

    Explains some of the date functions in Oracle SQL.

  • 23
    Functions - Conversion
    03:42

    Explains some of the conversion functions in Oracle SQL.

  • 24
    Aggregate Functions
    11:39

    Covers the aggregate functions used in Oracle.

  • SECTION 4:
    More SELECT Concepts
  • 25
    Table Aliases and Joins
    16:42

    Explains what table aliases are, as well as how to use joins.

  • 26
    Joins Part 2
    08:42

    Part two of using joins on tables in Oracle.

  • 27
    Set Operators
    06:33

    This session covers the concept of set operators and how to use them.

  • 28
    Translate, Decode and Case
    06:39

    Covers three concepts inside Oracle - Translate, Decode and Case.

  • 29
    Subqueries - Single Row
    13:19

    Explains the concept of a subquery, focusing on those that work with single rows.

  • 30
    Subqueries - Multiple Row
    17:12

    Explains the concept of a subquery, focusing on those that work with multiple rows.

  • SECTION 5:
    DML - Data Manipulation Language
  • 31
    DML - Insert
    07:13

    Introduces the INSERT statement for inserting data into a table.

  • 32
    DML - Update
    06:05

    Covers the UPDATE statement for updating data in a table.

  • 33
    DML - Delete and TRUNCATE
    04:25

    Covers how to delete data from a table.

  • SECTION 6:
    Objects
  • 34
    DDL - Object Types
    15:46

    Explains several of the object types used in Oracle.

  • 35
    DDL - Create Table and Constraints
    20:26

    Looks at how to create a table, as well as how constraints are used.

  • 36
    DDL - Alter and Drop Table
    04:48

    Covers how to alter and drop a table in Oracle.

  • SECTION 7:
    Conclusion
  • 37
    Conclusion
    01:10

    The course conclusion and next steps.

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,800,000
Students

RATING

  • 12
  • 2
  • 2
  • 1
  • 0
AVERAGE RATING
NUMBER OF RATINGS
17

REVIEWS

  • Oli Sawtell
    Ok but...

    Overall this course is OK and has helped me from knowing nothing at all about SQL to understanding some of the basics. Where could it be better? There is virtually no triggers to trying examples out yourself, the examples given are not very 'real world' either, and often the lectures deviate from what is possible with loaded data that you are asked to load during the initial parts of the course. I'm afraid I also have to report that there is real 'death-by-powerpoint' in this course. The first setup video showed some finesse by the lecturer in the use of a desktop camera tool, but sadly that was never revisited. There was no encouragement to entering in the SQL into the delveoper application either, I found myself doing that without any prompt, but more often I found myself 'switching off' due to the over use of powerpoint static slides. This is a shame since the lecturer is not a bore to listen to and what is presented is presented well. Its just a very dry subject so to have very dry slides as well made for a sleepy experience! Overall then, good and worth the money. But could be much better, more vibrant and if encouraged the student to engage more with the material with examples (homework) to do, would really help with the learning activity.. (if the lecturer reads this, I highly recommend watching Bob Tabor's C# fundamentals course, which takes and even dryer subject (c# programming) and turns in an engaging and awesome online course - which is FREE on Microsoft Virtual Acadamey.

  • Brian Prall
    Enjoyed the course!

    Course was well designed and laid out. Speaker was easy to hear/understand and topics were well designed.

  • Trevor Bradley
    Have just began, initial impression

    I have literally just began this course (only on the second video) but I am very impressed. The commentator is very clear and precise and I feel that this is going to be of a great benefit to me during my studies.

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion
MORE FROM Ben Brumm