Introduction to Oracle SQL

Learn the basics of using the SQL language on an Oracle database with these easy-to-follow lessons and examples.
  • Lectures 37
  • Video 5 Hours
  • Skill level beginner level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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!

What are the requirements?

  • Access to an Oracle database - a test database or somewhere you can install Oracle yourself

What am I going to get from this course?

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

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee

Forever yours.
Lifetime access

Learn on the go.
Desktop, iOS and Android

Get rewarded.
Certificate of completion

Curriculum

Section 1: Introduction and Setup
02:08

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

07:38

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

01:45

Demonstration of how to download the Oracle Client.

01:24

Demonstration of how to install the Oracle Client.

How To Install Oracle On A Mac
Text
01:10

Demonstration of how to download the Java Development Kit.

01:20

Demonstration of how to install the Java Development Kit.

02:46

Demonstration of how to download the Oracle SQL Developer software.

02:15

Demonstration of how to setup the Oracle SQL Developer software.

01:11

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

Section 2: Viewing Data
02:52

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

02:35

Demonstrates how to create a new user in SQL Developer.

03:26

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

05:02

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

13:22

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

05:19

Covers some of the data types used in Oracle SQL.

13:16

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

10:22

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

Section 3: Functions
11:20

Explains some of the string functions in Oracle SQL.

06:11

Explains some of the number functions in Oracle SQL.

05:27

Covers how to work with dates and times in Oracle.

04:23

Explains some of the date functions in Oracle SQL.

03:42

Explains some of the conversion functions in Oracle SQL.

11:39

Covers the aggregate functions used in Oracle.

Section 4: More SELECT Concepts
16:42

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

08:42

Part two of using joins on tables in Oracle.

06:33

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

06:39

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

13:19

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

17:12

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

Section 5: DML - Data Manipulation Language
07:13

Introduces the INSERT statement for inserting data into a table.

06:05

Covers the UPDATE statement for updating data in a table.

04:25

Covers how to delete data from a table.

Section 6: Objects
15:46

Explains several of the object types used in Oracle.

20:26

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

04:48

Covers how to alter and drop a table in Oracle.

Section 7: Conclusion
01:10

The course conclusion and next steps.

Instructor Biography

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.

Join the biggest student community

6,400,000

Hours of video content

28,000,000

Course Enrollments

7,500,000

Students

Reviews

Average Rating
4.4
Details
  1. 5 Stars
    11
  2. 4 Stars
    2
  3. 3 Stars
    3
  4. 2 Stars
    1
  5. 1 Stars
    0
    • Andy Russell

    Good starter course buy very PowerPoint heavey

    I got what I needed from this course which was a basic refresher in Oracle 11g. It starts off well enough with videos on how to get things up and running. However after this it's ALL PowerPoint - there are NO other proper demos. The guy obviously knows what he's talking about, and there is example code on the PowerPoint slides which you can go and try out in SQL Developer. He's perfectly pleasant and articulate but it's really hard work without some proper videos to break it up. He also mentions future courses which it seems he never went on to do which is a bit of a shame.

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

Ready to start learning?
Preview this course