Introduction to Oracle SQL
4.4 (50 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,508 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to Oracle SQL to your Wishlist.

Add to Wishlist

Introduction to Oracle SQL

Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.
4.4 (50 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,508 students enrolled
Created by Ben Brumm
Last updated 2/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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.
View Curriculum
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 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 69 Lectures Collapse All 69 Lectures 04:38:20
+
Introduction and Setup
1 Lecture 03:03

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

Preview 03:03
+
Software Setup
4 Lectures 14:17

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

Preview 05:53



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

Preview 04:22
+
Sample Data
2 Lectures 04:27

An explanation of the sample database we will be using.

Our Sample Database
02:14

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

Setting Up Our Sample Data
02:13
+
Viewing Data
10 Lectures 41:14

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

How to View Data With the SELECT Statement
05:38

Expansion of the SELECT statement to select individual columns.

Selecting Individual Columns
05:33

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

Filtering Data with WHERE
03:48

How to use different comparison operators in your queries.

Comparison Operators
03:18

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

Filtering on Partial Values with LIKE
04:15

How to filter your results on date values.

Filtering on Date Values
03:35

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

Using Two Filters
03:03

Using three or more filters in WHERE clauses.

More Than Two Filters
03:54

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

What is NULL?
03:49

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

Getting Unique Records with DISTINCT
04:21

A quiz to cover topics learnt on the SELECT query.

SELECT Quiz
3 questions
+
More Operators
4 Lectures 16:30
IN and NOT IN
04:09

BETWEEN and NOT BETWEEN
03:19

ALL Keyword
04:18

ANY Keyword
04:44

A quiz on using operators.

Operators Quiz
3 questions
+
Sorting Data
2 Lectures 07:52
Sorting Results with the ORDER BY Clause
04:19

Ordering By Multiple Columns
03:33
+
Set Operators
5 Lectures 18:51
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
+
Aggregate Functions and Grouping
10 Lectures 38:59
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
+
Joins
12 Lectures 53:03
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
+
Functions
6 Lectures 32:49
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
4 More Sections
About the Instructor
Ben Brumm
4.3 Average rating
264 Reviews
6,734 Students
2 Courses
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.