Introduction to Oracle SQL

Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.
4.5 (45 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
4,501 students enrolled
Instructed by Ben Brumm Development / Databases
$50
Take This Course
  • Lectures 69
  • Length 4.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

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.

About This Course

Published 9/2013 English

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.

What are the requirements?

  • Nothing - this is a beginner's course

What am I going to get from this course?

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

Who 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
03:03

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

Section 2: Software Setup
05:53

This lecture demonstrates how to download and install the Oracle Express database.

How To Install Oracle On A Mac
Preview
00:17
SQL Developer Download
Preview
03:45
04:22

This lecture demonstrates how t set up a connection in SQL Developer, so you can start writing code on your database.

Section 3: Sample Data
02:14

An explanation of the sample database we will be using.

02:13

A demonstration of how to set up the database for this course.

Section 4: Viewing Data
05:38

This lecture demonstrates how to use the SELECT statement to view data.

05:33

Expansion of the SELECT statement to select individual columns.

03:48

How to restrict the rows you are shown using the WHERE clause.

03:18

How to use different comparison operators in your queries.

04:15

Using the LIKE operator to filter on partial matches for words.

03:35

How to filter your results on date values.

03:03

How to use two filters in your queries in the WHERE clause.

03:54

Using three or more filters in WHERE clauses.

03:49

What is a NULL value and how is it treated in Oracle?

04:21

Using the DISTINCT keyword to find unique records in our queries.

3 questions

A quiz to cover topics learnt on the SELECT query.

Section 5: More Operators
IN and NOT IN
04:09
BETWEEN and NOT BETWEEN
03:19
ALL Keyword
04:18
ANY Keyword
04:44
3 questions

A quiz on using operators.

Section 6: Sorting Data
Sorting Results with the ORDER BY Clause
04:19
Ordering By Multiple Columns
03:33
Section 7: Set Operators
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
Section 8: Aggregate Functions and Grouping
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
Section 9: Joins
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
Section 10: Functions
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
Section 11: Subqueries
What are Subqueries?
02:10
Single Row Subqueries
03:00
Multi Row Subqueries
03:53
Section 12: Inserting, Updating, and Deleting Data
Inserting Data
08:43
Inserting Data From Another Table
04:33
Updating Data
04:01
Deleting Data
02:59
COMMIT and ROLLBACK
04:17
Truncating Data
02:01
Section 13: Creating, Altering, and Dropping Tables
Create a Table
04:44
Alter a Table
03:30
Drop a Table
01:34
Section 14: Conclusion
Conclusion
01:47

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

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.

Ready to start learning?
Take This Course